SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516414 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516414 [ RunTime:0.002470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499311,698811,229358,625515,48792,920793,967138,423234,933270,76234,841784,31908,803798,836870,268983,341556,328245,509042,226847,570954,663987,367429,391745,763326,373891,867222,507756,315629,41086,779166,516833,443720,693913,865323,828484,521871,1008691,792505,161639,796948,65075,626079,430378,436653,362681,92277,990164,463865,132297,338973,815981,994360,600920,951451,271307,463743,43256,1006886,596867,189963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]