SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428300 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428300 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335012,393401,846750,820831,189918,513220,210215,931643,972378,603615,121977,199662,336460,267276,632666,97089,139169,766184,322010,41379,652618,501891,467142,154641,156555,170271,288219,190600,726176,230870,547730,644480,955138,152229,23485,359784,257389,302454,630171,302262,507896,42702,283560,684839,2208,272409,660003,70784,245498,1019927,921029,615518,62160,133200,379011,341758,794729,812746,225908,710980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]