SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033423 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033423 [ RunTime:0.002853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851103,1018221,491569,977267,507768,635899,53852,293774,537151,378286,99125,125390,92330,951366,143512,165177,50241,96078,1929,923807,704343,872629,932089,332733,774228,112470,780161,425675,352452,1020538,502818,215864,672067,711796,263319,1028963,319610,827314,845856,529850,261322,193797,559139,311837,336352,237325,594694,462966,1021622,817306,534122,876408,947921,192068,1041166,309121,684050,173708,975061,1024469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]