SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531000 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531000 [ RunTime:0.002334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754229,223471,1034420,984448,710937,975441,57225,87650,293062,345227,29019,509225,8449,844267,37870,705850,386717,624770,858115,677273,1012192,54395,693382,47671,287682,1030863,73395,940137,46559,5469,907564,974869,625290,526089,382955,833181,322206,293454,682371,654223,161758,433460,28338,474818,31700,607634,573233,102343,581095,758425,108332,456499,423161,79173,896975,689622,557516,239523,343280,970872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]