SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422208 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422208 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377786,925621,689031,875231,491568,889403,175476,530746,7410,1027471,1002416,494718,26159,110816,840512,181410,141200,888275,34443,283083,227318,634949,606963,861261,787351,338713,277688,34058,570910,469817,689980,3013,27268,932877,543403,652524,771514,437291,767150,148782,291816,710278,908519,1003944,67365,424071,288522,714986,763650,172293,480848,918850,421954,464609,252837,240481,850019,514433,1016705,431318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]