SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41876 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41876 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224470,472356,751969,695825,831967,38865,342743,13453,95954,101206,884339,251140,239711,983382,948250,665802,748106,400107,1040247,238293,673230,122005,969090,1041192,263155,229502,875825,377089,1020823,269127,897913,920915,593080,606723,1006962,161264,943402,421991,956907,817503,107275,58890,951253,244703,1043340,207448,413890,611800,134611,585525,69528,39849,75583,17497,448115,650804,602888,331189,865172,268913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]