SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9661 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9661 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310307,659636,278720,386253,309190,210781,161647,526986,50801,26423,537913,713748,373336,655337,516464,739491,338959,7296,946417,57593,337837,23882,150838,448052,563004,380515,199930,375307,644287,412015,179648,569781,128576,11921,412545,274744,578299,285479,851119,169518,597181,805606,992956,871921,540634,147133,689393,925011,359112,970007,9792,676108,433462,312941,124233,757165,6493,747038,497845,62166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]