SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411708 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411708 [ RunTime:0.002758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386912,155223,1028057,2330,1006517,865948,198625,351125,329781,558954,612503,1029089,713150,293347,903150,401439,639893,916477,233172,531315,649502,152664,383814,46296,384427,135027,404732,667756,282899,98938,935211,1001245,350730,765862,694287,79380,63986,547768,628003,519181,710378,439228,366997,900318,229442,484745,396538,419522,925350,89179,7996,781685,781296,387001,106101,640468,101359,589028,878374,16737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]