SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545733 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545733 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033645,1039330,335786,1006110,8800,276713,273118,833862,508865,571371,211497,220960,1017722,85018,604036,120064,379539,509387,91450,678098,98794,225905,221225,933861,434411,96406,355225,303409,550979,1028161,1046359,356069,494096,709454,982019,797939,521465,137277,561072,659100,633646,1002700,1016475,628824,460318,48437,613617,834337,341539,152969,347210,103543,869490,47878,157939,1036301,811873,864269,145033,558985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001767s ]