SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016826 LIMIT 1 [ RunTime:0.000785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016826 [ RunTime:0.003199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356502,465147,430777,195395,152206,365274,157740,879178,388736,263670,439086,673093,527361,484206,180804,689923,429093,143033,876750,1027120,986560,636243,34309,551662,615223,520478,733722,400036,84055,18701,346485,617771,980402,913570,932219,183683,982264,153110,330465,253712,1015179,415513,322910,475382,949722,733170,68407,252553,269729,616314,159238,30304,980924,704482,830763,752380,272625,7004,882728,554441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]