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` = 713423 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 713423 [ RunTime:0.002786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612839,556988,615824,41510,305756,566717,73880,129293,807933,841582,270775,373891,452846,378111,327842,265324,959088,216299,541534,760497,784940,138722,583320,942349,365717,568681,695167,485328,429244,575469,176666,880137,294077,200498,953180,735631,44814,743683,38149,471451,673247,322349,213749,473569,952994,1012333,881553,838275,555447,996290,440790,688926,742208,211480,441629,276993,172663,178344,625067,980713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 713423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 713423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]