SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027700 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027700 [ RunTime:0.003699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456838,33949,73181,939251,143922,940203,150784,241881,890872,436785,836049,51329,743468,548551,118357,507918,925498,375509,788001,81520,703294,207333,901474,924517,195743,780305,146735,943233,188176,696954,992424,510511,965434,38575,770244,838175,470007,443057,642586,452203,377931,873122,744488,51253,254189,320486,777075,81138,712870,528896,154513,384524,648402,602879,259667,256211,153835,272856,506236,929814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]