SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 972509 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 972509 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754984,417083,972649,28333,1023611,580310,881863,152563,990464,446422,260538,336690,379760,990537,945886,720802,11145,861379,341650,564501,296078,1841,178317,1001124,783624,601736,949711,673597,666181,212210,457727,434359,949855,211640,187596,864960,207899,624048,747408,65543,596795,415969,621703,555691,476798,420753,770797,992232,605891,121914,266202,816400,504227,45052,435793,572170,74595,693778,785750,294577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 972509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 972509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]