SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469080 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469080 [ RunTime:0.003436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37349,954322,300739,447373,757897,837002,931276,361705,605480,125104,67983,120407,18955,966247,690837,187296,763477,48899,345350,351082,649814,309879,788266,907930,301608,327482,799266,345392,881256,394536,1014670,685168,510590,465140,707502,588312,6752,464314,785093,866259,335978,84475,278810,22711,270136,340515,740125,127652,621409,413227,915565,65776,909192,78269,638035,744431,695958,909858,961859,297095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]