SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499674 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499674 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580583,952683,52418,120722,179011,608298,95590,486961,327189,919032,145037,1005900,296358,606846,878377,1030800,388350,178195,827179,995453,413524,728270,1042740,722162,257747,751725,500123,165677,498719,741650,346964,783960,963078,182924,184179,159482,35599,277260,34176,1034055,901486,785114,290320,974176,752988,806043,861916,673234,956586,517384,654945,1044430,284895,507180,341312,448325,311846,961384,679087,901716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001821s ]