SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412624 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412624 [ RunTime:0.004619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027122,582352,851372,1041087,170453,461641,56359,468884,107356,488609,618691,294166,311089,7644,906324,206718,539119,835122,123195,347141,344398,134832,477389,956815,519536,149367,660448,516040,297929,806271,611128,222042,575850,113413,760359,196710,73121,216186,651870,492768,44066,279620,568066,303085,119385,805253,890381,877650,1023512,252635,104601,460779,837712,602142,342730,652701,938731,65965,582772,798463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]