SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471410 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471410 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639095,200657,172940,948578,824872,891741,1010796,846182,831293,424274,683973,445575,935037,587567,351304,921534,797141,359113,367219,229769,630120,358030,777886,108391,711914,773052,739045,683330,470140,762804,27852,84257,730711,440870,678852,772689,934269,500590,629942,1017730,474141,223820,1026385,71756,644651,743678,730178,92156,539883,1046167,394378,183313,523887,153423,84743,481805,662694,385595,71156,328206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]