SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305001 LIMIT 1 [ RunTime:0.000676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305001 [ RunTime:0.003977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039946,974613,839783,239004,213983,334383,709587,749752,262229,1010286,380985,242461,992693,821020,166923,510634,270212,881361,610497,423041,463149,295491,470164,532825,809566,996924,244917,740466,199931,858693,862458,816752,755205,720102,477094,830084,434322,747649,348529,630579,182247,39324,31704,707428,952519,720869,73835,394766,830164,401031,1016786,256309,263967,588334,110108,791467,562741,48407,40102,579213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001862s ]