SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80612 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80612 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316756,721603,840046,963089,286235,637418,518462,986418,400605,987981,760380,203987,636134,190321,698243,795606,355488,352831,247945,990017,41136,953631,1012252,510654,154497,167100,1013380,426523,289702,50251,533670,141189,493080,1030639,494237,418226,383000,92581,110320,681324,513847,346630,642889,706530,388882,194886,92664,189141,1000771,798887,1006737,273831,844699,284869,924870,528093,341618,478785,1037991,158438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]