SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002726s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429746 LIMIT 1 [ RunTime:0.002852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429746 [ RunTime:0.007847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373774,1038538,923177,828128,862483,408421,197515,502152,329961,846776,987313,1014433,249335,258255,62498,883682,905547,402916,959580,880265,807062,11221,353337,118359,1048778,659685,713942,689568,424711,34520,979135,339915,926129,65810,782688,935400,1039285,802614,819149,46878,63353,928070,123621,75306,344268,679642,728576,802827,31188,68728,109923,873683,12022,893122,95894,994079,773927,256219,710830,739229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001399s ]