SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34949 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34949 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177041,519731,718136,799558,493388,1013002,868202,566365,697075,154523,452008,33284,799303,571366,120054,655180,560281,60136,1018504,1021292,691271,22720,878311,697295,514717,24108,962436,258621,58443,226989,579038,112944,15840,987582,870505,663018,571689,1037065,922987,713599,715611,915957,827999,422188,131194,99319,525768,844660,547323,1025896,989358,598769,569994,524106,598682,603590,996746,361979,274408,343802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]