SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320198 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320198 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909538,681325,478449,1020715,119612,863208,385984,317559,897947,582581,151012,747067,532256,430960,185193,1045623,965787,1020386,783830,745869,648001,205411,911645,655686,86940,697387,264536,39346,611017,1016236,603788,288689,707966,928403,896708,803867,702108,640078,797186,231843,868626,881264,815267,502594,398034,613939,254839,549222,405172,6898,799022,329109,85484,605114,970074,930314,985696,106830,283993,202887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]