SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445272 LIMIT 1 [ RunTime:0.000831s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445272 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027139,205893,58303,81245,324049,134984,201097,277520,750187,342669,673860,665348,94348,547970,711591,1041672,163195,526248,515581,841379,269261,779712,10700,792159,188986,96411,841941,475075,797422,501567,134959,670494,526941,138915,253392,204862,178434,646309,460907,726796,170350,445776,773862,395897,429223,98597,625780,526229,588851,888035,396256,517344,221513,175720,1033626,594024,35389,159331,626457,786800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]