SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020018 LIMIT 1 [ RunTime:0.004542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020018 [ RunTime:0.004360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663300,506768,223019,186248,803629,814181,24657,797830,1024316,893221,499151,847227,751161,249246,986597,459029,405355,1006361,971072,996620,1000674,810120,349546,479801,866964,240592,425637,418381,516000,126907,767951,153470,1026326,576287,593535,137906,1019428,494767,135682,586341,793146,979018,971217,115166,746191,22752,466177,144428,65469,860323,451419,545521,170339,355334,332910,75217,165570,295073,700833,954935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001711s ]