SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102807 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102807 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598826,601210,1019751,17036,614835,496831,777566,731866,232168,123575,299037,824136,161906,429308,862806,745799,987477,238321,665909,212956,669278,181341,184271,494935,908183,900437,1009173,39513,934505,684808,913938,860278,183657,981307,563053,1044912,125708,288351,452364,781566,649316,277370,448711,543572,171501,609798,28916,892119,492283,792874,3754,201491,293747,45190,169023,236120,727254,827307,752178,199265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]