SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551084 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551084 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279620,239651,677592,345162,300433,975950,934275,916754,832177,909723,117400,342595,942975,233286,334186,227140,468596,755039,745264,34958,879956,269581,490484,119299,275657,449483,213033,14916,650249,522995,157254,829121,771941,311937,598824,772686,638153,887744,1039819,984613,348493,864424,219557,112355,952198,978206,760134,265850,479319,914586,748022,679973,125876,882151,368521,43108,894079,541587,982095,985809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]