SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005824s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498084 LIMIT 1 [ RunTime:0.004247s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498084 [ RunTime:0.005856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200670,890145,17426,289661,860847,934740,1001827,606,33719,64552,360809,314975,231369,588203,874437,698716,801037,793313,364902,840942,380346,674740,581979,29381,905218,159825,1031809,107243,549329,875281,766645,266251,318705,202657,522023,118636,20472,319166,228120,794756,143852,88728,408061,85590,5712,559922,1010067,116460,809990,701132,642584,815851,197793,954115,325924,746581,574407,997447,352556,644064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]