SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002914s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45891 LIMIT 1 [ RunTime:0.003690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45891 [ RunTime:0.008140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128519,819186,620404,665267,334277,261676,1018053,148011,645229,688976,46017,348436,879171,27618,794339,536987,728749,128264,763905,135697,10800,1011296,938996,1011484,292538,418660,260213,15050,86208,127046,96810,219198,546988,623672,120625,81335,1039218,157968,214041,235243,746114,878499,465329,51852,420639,872887,233056,321129,355743,512954,263957,777865,155155,314641,981104,823629,690614,375731,12174,713965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001412s ]