SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316198 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316198 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229299,571190,147377,537978,582287,253975,930350,299689,931823,464361,323268,16685,67957,918732,324866,328502,799401,666230,794316,48270,9620,480736,738439,507731,161247,394363,682194,411792,612317,739939,28859,438298,348240,413682,609672,122747,388740,689355,596892,246948,40845,203320,616541,147698,966656,703030,309744,393082,733829,879508,743282,910312,642357,389171,458614,306551,92524,551095,380653,844408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]