SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631853 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631853 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605508,110697,420820,27939,403841,481317,93430,903481,763399,502873,846860,893525,31914,618883,586588,213327,378049,679117,692124,717208,229209,332343,813919,834552,874910,81401,175094,40758,1013867,64068,199530,106886,785032,478400,740255,709389,753834,859602,284944,546185,492272,346160,514829,277139,104545,245334,424039,119150,804149,504455,560795,794867,961634,367725,466429,510596,325160,734689,966848,986918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]