SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036653 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036653 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11079,952580,713095,885609,975987,215130,377245,546004,629606,138261,94020,229069,461779,110766,543013,147373,265679,342636,724479,61098,810643,1016637,246443,217549,13669,952763,556083,1008576,183429,784742,721901,302208,586777,395561,436319,130634,214964,460952,137108,756269,720239,55881,269419,457317,590624,478768,281917,449523,77636,419644,605550,698336,433533,758973,644667,284649,615134,790723,920207,972987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]