SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585391 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585391 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200517,828392,517428,558017,274044,175392,129586,761623,370987,225999,657804,368601,788891,851015,213734,289156,412649,775752,186815,852176,102011,11997,389233,934819,19783,431638,769423,425249,599131,1028946,490006,710743,1008861,552182,601896,1005325,652661,40613,983223,955731,378319,962070,659872,436039,421003,249431,343250,690680,369364,802924,570609,508494,995502,882689,518360,82665,829419,952089,695250,999610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]