SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 812151 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 812151 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464733,897924,665475,473100,14506,108334,479531,414130,130524,524847,759197,771525,121153,141098,508484,909734,725380,940541,764760,73013,443195,131319,847443,861184,805731,618965,839147,412373,616459,731638,70968,483570,998293,981669,944260,987400,311982,97625,847248,513993,199528,2819,667101,316394,948370,705486,404463,968935,982837,755580,767996,814843,427814,517244,631449,589489,301477,481786,310038,157336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 812151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 812151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001074s ]