SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31458 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31458 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048284,910488,695176,971463,448050,428432,92420,1007941,165125,149280,646266,747583,578723,1002137,657954,940398,6257,914236,440291,299683,173644,540889,642659,662907,568844,811654,41506,190126,280812,623288,297141,784220,122311,12002,427348,599155,539791,109845,354559,711784,769303,612646,584606,451371,832663,606771,378733,523721,701117,50597,442652,271667,373798,559982,477107,551615,199694,418938,963115,129115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]