SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407018 LIMIT 1 [ RunTime:0.001454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407018 [ RunTime:0.002327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196146,572073,644775,452290,245264,553257,679907,1037969,561682,873394,299478,532680,906484,465572,375304,818425,910675,673475,467138,705243,412945,374104,950962,576029,919207,77361,158163,614451,216726,253815,126219,935953,17359,578514,141711,825514,1044272,530613,447237,234190,527575,616216,826937,608334,672285,579703,151114,890688,579374,168082,484646,274233,188945,18855,349217,140174,385099,297697,855102,111573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002085s ]