SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100427 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100427 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521168,998632,704274,593221,677546,108300,329005,158393,1045916,430950,458044,849375,479543,533680,755016,540912,634353,976883,581158,140430,298991,740531,274013,282647,159900,734184,1031070,141784,429255,423994,179501,905614,77866,152274,464285,280098,708043,215549,309108,582487,1031265,607915,66604,17973,806051,586045,783129,885175,320560,124551,4331,360037,680036,349004,196609,689119,471941,766639,30214,77431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]