SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318031 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318031 [ RunTime:0.002507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560459,961143,160252,463281,142800,689889,466902,373690,791948,399293,366029,1021677,1043340,191261,900519,908122,678046,84286,483532,960321,120637,919837,714810,850127,47486,243255,855038,525753,224621,119508,748340,945542,26840,1044205,855253,684658,801123,719148,481228,373133,205770,262064,476025,678278,964808,595716,376791,548029,196126,316768,258805,774292,338128,990256,444580,752519,787543,48653,170096,84566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]