SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 833499 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 833499 [ RunTime:0.003700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602347,840144,940770,666326,506187,2344,692798,833093,146543,755446,4543,264173,396074,214258,128300,459885,588701,526275,940171,937141,1017269,828369,772630,623132,418941,41113,202607,438379,45858,1000,215461,337751,29398,590686,1024883,516106,517968,274915,550775,66542,770290,826090,127109,334321,53632,95425,358466,585976,864523,687140,379650,729886,106845,202978,626014,671900,554583,171499,741145,278503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 833499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 833499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]