SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36481 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36481 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309716,696389,653461,871003,299439,68211,434877,641892,241818,962829,403041,828775,199953,875712,500027,65995,35966,163967,407406,377319,11824,694318,433210,552089,32966,128701,609613,692272,129476,318101,220631,915131,799285,439623,123808,771608,220690,627349,72936,295456,734686,464904,592935,1046760,555780,370844,797258,436233,421687,475653,657216,17546,447762,321726,976393,1002623,648410,453495,954889,276449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]