SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51912 LIMIT 1 [ RunTime:0.001730s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51912 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017885,797552,502326,975204,784195,267476,283750,912724,174186,557695,273990,540582,56023,106910,729213,80982,514410,926254,567208,121016,450686,957349,978121,186504,420238,986067,295389,915735,504656,122536,82387,365581,65209,302599,701504,1032643,14117,423452,839515,777552,709346,147336,47653,45289,1017767,217008,490468,192173,267230,918042,758660,125610,409344,720112,556303,924133,198285,1047679,518363,108995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002358s ]