SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341006 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341006 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499563,110782,79835,1042212,422385,743882,56684,201628,49974,942257,727019,647822,501262,709874,717804,917765,108522,91840,718056,767542,685891,627012,1019359,90847,901002,434305,469035,770202,365957,33486,490028,632922,837099,122968,959409,71222,554053,951012,960548,717415,959274,256898,531944,705354,743540,674638,701682,97587,649637,234779,553578,105882,813972,935858,855031,343553,293089,256585,186010,972770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]