SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439328 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439328 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507683,931225,230336,1009445,324654,402526,248424,462166,181621,899339,1028183,505586,328912,729275,689226,693083,266913,24245,231186,591165,328109,447518,787555,365101,877673,589975,936761,406401,442157,246097,115215,359381,1000483,631013,622409,8273,252841,524495,560598,998418,572217,182234,710852,660202,371598,867342,713851,596549,1022067,513033,779360,636752,1010868,612593,512159,1030311,678705,829504,389558,694800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]