SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564815 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564815 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731296,372232,471943,449860,364456,1012180,478964,445574,268316,473479,942001,333524,143613,489288,453886,982448,84065,34566,673161,118268,348366,555850,152003,32060,523906,236150,548725,524740,1025807,650493,624042,83969,301680,876297,477000,215692,842042,819836,179431,50105,261958,147239,771442,720668,112039,572892,1004404,921054,297,177988,851210,210889,344774,347526,383525,88531,420488,841293,524776,496428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003223s ]