SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406736 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406736 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360601,110209,939845,361939,16651,339583,235272,20387,212746,871965,529721,127751,46448,335366,596793,543904,684151,211947,13934,613549,31274,910844,827971,176568,426938,579599,87978,803196,227488,218566,801327,284812,401963,799804,192973,787384,450625,985059,619496,747559,485122,732723,631738,667510,261507,1003711,912181,867257,1035795,1032953,171455,582695,596912,915957,955839,286694,789472,345659,803964,962287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000863s ]