SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429147 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429147 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476314,527235,321039,476062,63039,3543,883517,253296,227482,105240,45380,798447,620355,422594,100308,670111,525036,526093,807621,1471,573003,434213,397585,595290,597764,382466,990683,400136,740729,455373,564237,232144,418057,760150,697536,18008,615721,711659,82194,682823,65953,14320,941802,636073,778262,507875,841105,886954,870600,1004155,169074,562571,893292,540674,63266,1046335,899275,560177,912460,316495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]