SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511014 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511014 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324276,59497,191440,470582,242770,597458,40661,137175,632141,920344,34408,260080,596939,750639,74038,232302,105056,123733,1026405,832360,394042,503739,225002,230660,677954,648510,517451,548929,902987,284037,125625,652080,1037636,103854,500370,398741,550963,635374,946204,665616,867694,832847,534871,314653,294731,375632,800805,88920,642801,910111,948139,325483,472971,49749,13471,612384,154135,705640,888400,559932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]