SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394711 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394711 [ RunTime:0.004011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530794,581297,900481,262663,723944,786963,765751,23145,917609,348845,823819,287410,865410,588023,1008552,86285,537335,142213,703214,396882,998258,67004,300858,590125,64573,270710,163471,135786,695524,945787,279025,399111,1015965,509889,978309,34751,421707,79558,242345,455116,891578,13114,638254,631169,312178,234224,469179,510990,4220,920103,998870,746121,290323,785001,335004,1046968,101971,277566,628145,809923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001217s ]