SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51800 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51800 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258761,588285,506383,819048,685589,876258,850156,769440,473386,324116,26352,940020,186691,675849,375141,764169,91355,817543,514555,367886,869375,51187,191807,396545,990974,33099,862235,521726,556906,236348,398679,331394,389771,112647,956414,854407,663959,695306,169981,886841,403379,723657,580951,470692,643423,557526,805669,807467,672256,188733,474677,40102,755004,139015,29520,681769,755753,190853,197089,17778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]