SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683293 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683293 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195800,548188,195186,594455,492515,65983,840255,10960,871884,960115,205756,579875,908372,455281,895347,489950,293598,390458,520656,2171,302013,14923,954758,276956,860448,389369,1028897,237438,505990,557938,305315,668874,836154,772717,368688,157470,456976,636854,401007,211037,962930,480638,902934,111188,52539,161113,56818,216780,367212,725949,214470,380395,569264,837328,392151,604122,632866,824211,459961,221177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]