SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80109 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80109 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384495,922574,361791,582578,741063,667175,898100,692061,631118,659991,812316,928812,294128,324756,712695,81876,483859,683316,767060,327143,128356,607910,660453,703990,899346,428740,811297,1014761,142620,75135,769987,684465,860346,629359,452713,426384,785579,24591,163806,897385,981520,441473,584710,568905,720628,186649,671324,860765,994231,815920,700021,399786,816155,804250,211879,778140,529804,582984,788953,750632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001282s ]