SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541984 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541984 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354284,685048,89068,688915,454473,608164,683265,303164,119285,159021,38241,317224,207952,457395,397226,276455,461215,584250,862642,969236,342981,840794,918405,605120,438698,458044,299693,878591,865834,573022,44519,864554,1040237,765268,180379,181011,896263,721383,356800,624647,958262,1040482,146891,435544,394730,508957,719026,801358,375491,467135,841835,694944,995846,430602,406794,90745,1045937,559903,1043193,211596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]