SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814380 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814380 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813010,300007,34321,827670,731883,507612,687642,458313,252238,773849,9632,778382,502497,88480,861037,911921,771419,601075,237262,410616,149539,1016465,537023,107155,869565,942320,854978,186367,323967,549041,481943,757953,1017194,434654,369355,38752,690487,234895,628426,547177,392914,107530,565051,626344,553163,869058,598547,34568,344053,287331,969516,438179,932872,855257,354029,751809,624486,356042,469936,461644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]