SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033811 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033811 [ RunTime:0.003305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226931,308773,420402,420337,334090,848186,60681,172908,47762,199714,793047,426369,436093,982725,433787,165914,626511,816919,355526,550046,10442,394001,321111,143642,1025513,620125,634061,567051,711959,131329,72569,1000857,1034219,713458,145064,168131,373098,332407,443069,945503,824799,546269,188702,275192,272702,609030,881387,741230,249373,1025608,663433,3828,538742,623109,754730,282329,22996,419453,449875,188491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]