SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106412 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106412 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687563,16417,194936,304554,841634,230761,875641,921787,825530,519288,592943,546317,127505,489975,476018,615754,557941,105561,188259,63728,519472,664777,256546,83971,1000945,626644,211430,672505,563106,328738,367085,835010,302079,451351,245318,650695,847921,544061,863486,419390,1033769,171522,146833,533318,667434,631236,694382,696504,668377,850928,559906,615157,849813,1001253,530210,346054,958103,340430,690704,907588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]