SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012103 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012103 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30513,751295,939186,30351,30867,413819,799337,813726,197760,179270,512235,44381,898562,805501,932407,244975,794634,920818,14550,424211,764101,900943,745102,779162,190365,879240,276583,367774,409328,61525,405887,424281,401293,27079,224059,677544,945200,293850,742352,502531,439493,332088,461891,15655,532008,273715,14104,467132,490207,667847,822983,749685,280568,277303,513439,992623,949192,419808,966050,1036400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]