SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40460 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40460 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292587,670990,1014212,407450,147877,536448,946950,360157,675417,470543,691914,433147,357833,631706,908484,957883,646715,646539,835153,28597,628362,157745,878775,210919,689540,1043350,574941,241450,297426,224109,425180,92722,690303,589197,810212,99282,236995,463502,406701,743870,455297,887804,821958,621286,554157,359916,634168,425655,87938,21466,469833,209443,96362,91022,509750,65335,379215,1040993,757418,197223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004372s ]