SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417312 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417312 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312441,380300,329020,369909,1004762,939470,198438,77311,539551,917473,930381,458662,357957,109298,585089,652482,762919,327232,799501,817094,107045,565147,98541,113724,1044181,687741,1016157,208101,458148,396511,208137,419390,704774,750461,376157,521497,13544,460849,963290,125083,896020,370624,1019672,57247,749540,1045987,412574,611071,116703,762188,407596,858364,308930,876699,666222,403453,255969,598705,3078,914514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]