SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417167 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417167 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66480,104742,841068,531092,81261,1027803,263306,743601,769347,677567,325437,594019,899966,730078,801953,669097,195717,134936,657882,580682,794377,615906,404784,653121,1002463,760061,617180,584857,241241,839826,322126,888195,349979,983921,741258,152222,441233,91941,402578,34520,341351,1001085,909789,752034,355551,548842,241170,683679,309874,164965,84254,2152,306379,725627,737632,81255,146536,503038,910183,1020638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]