SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418600 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418600 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44354,429176,524797,196398,430824,744065,549650,660498,68190,905258,676005,421653,276345,228775,962995,120813,990882,987595,272061,50812,710936,37538,131144,848231,504857,908725,436971,98174,730057,653994,247507,270629,1027278,56946,995129,324850,716357,503365,122247,511947,982168,563982,17497,713533,27512,637305,663524,913502,857891,608044,221705,632367,883815,327169,370198,782943,553083,453475,734438,760186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]