SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009487 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009487 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81808,929638,874049,530352,148769,784882,417868,818289,204761,830014,1016809,1036992,561047,348356,446453,543908,999317,525473,247972,673525,1009954,136255,300366,964482,542696,978274,846329,694278,445357,293569,884407,585780,958440,412016,480170,377308,677036,139176,727904,974728,427565,546842,419010,809622,773470,16782,377635,517915,920493,549608,109633,619299,483237,768031,9734,365652,790398,942847,20151,984900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]