SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542743 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542743 [ RunTime:0.002281s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693022,383442,545229,284936,126123,345770,831658,274893,872761,415524,340590,758281,4192,483877,145378,50089,638143,155930,557230,85972,304281,237512,476095,267643,652988,739575,889991,739014,1046070,857438,627999,877229,426007,972963,341686,470456,109645,27210,989494,689618,48878,862836,448620,187943,45923,794324,944069,463730,76372,119302,240542,242207,952746,344923,411555,864340,999310,849320,433454,976202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]