SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261843 LIMIT 1 [ RunTime:0.001055s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261843 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500119,508534,789087,878830,452670,978944,363568,845302,623378,691697,233798,292401,144604,79955,287794,471963,644031,546266,70070,686065,677480,424017,752245,1046367,981695,52917,915820,97006,942470,431316,404510,95322,36657,862889,49676,604814,696906,965427,318757,56584,481025,296228,355167,492360,765603,322983,659860,120752,578281,364571,328957,942294,635187,233983,581172,366289,687037,616614,261580,232630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]