SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581913 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581913 [ RunTime:0.004384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888500,539510,261745,939301,237933,1008985,321955,910425,196300,660077,1014292,290722,749037,742003,973805,50824,455,11145,1035167,566786,220945,726057,135951,460588,22590,228301,462399,765789,856523,234919,241619,100978,230275,807334,902111,1000976,550302,954578,223688,209117,132727,355634,343022,751365,468467,312465,803154,400659,533958,73798,114731,1017373,738979,99677,1018696,12913,945119,408367,226052,566907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]