SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711807 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711807 [ RunTime:0.003509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754505,421737,837409,760138,462905,55265,694255,294814,788743,406870,952148,859104,221460,932558,1000040,176003,553894,339722,619719,938519,1014731,985574,610826,733418,666199,114744,54556,40804,644286,357163,49582,933391,650322,119112,256093,341369,544206,873319,588167,342474,100388,99198,748566,463787,129437,816809,960557,556928,449054,1033284,743765,962292,424066,182137,1023237,332262,838769,276329,553207,581804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]