SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205685 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205685 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336771,690025,1008387,605121,170845,847618,404712,884951,600963,781658,912527,701983,831332,994048,278403,715643,482623,622034,443267,455123,964973,310818,151480,242348,370270,53442,655971,148650,1006852,417860,640646,125101,689883,505555,861193,925379,235227,332178,466041,117549,505609,684380,740230,1048022,502478,807462,716132,859343,637732,750570,1010463,699716,867226,160906,902848,20116,647421,669343,487687,486840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]