SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042845 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042845 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23052,269157,635787,325022,365885,608935,642356,267879,990206,583318,63583,603882,339830,282839,786196,479293,401336,75591,206625,425122,670493,181196,553157,1009100,342335,834601,797202,165070,672755,410714,501134,682541,140284,32304,897168,252473,139164,25881,544012,203355,832431,223877,612714,384727,829104,235450,217613,15876,643645,320235,856210,542467,556541,723306,1019734,329099,523724,652440,791364,638131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001993s ]