SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205213 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205213 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713489,92300,1045606,143053,266558,959133,201897,629339,327772,473194,79546,133129,986318,54836,379586,915850,885394,663672,427965,409489,247823,749984,1016895,191290,402296,613438,184950,729590,745946,684958,532120,263011,666457,554969,702712,580505,317927,486988,970417,85056,950896,596287,314309,517594,371572,254349,536854,132194,755139,1038591,315627,125827,443514,766786,730803,536360,653028,102318,966733,741412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004335s ]