SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349218 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349218 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49328,501565,1009873,845147,242630,1038566,952553,311215,310285,102474,677076,482960,101146,660278,819339,794848,492327,1040610,537956,73716,387008,902981,118271,474100,973937,57225,12510,859855,303691,1035082,568767,107874,484483,308713,631510,421352,788001,424952,521623,253088,967469,77810,1033865,586920,567512,877568,36177,248594,479457,585441,735059,769831,91066,542585,137775,356427,591257,770206,95410,782484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]