SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040110 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040110 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435095,642034,17779,552078,344445,424968,380726,19249,853830,855366,959889,246001,84370,891423,760384,732984,519219,466416,761345,825951,670646,409057,959061,508586,902174,299462,836460,775154,414668,42539,156904,998450,902254,342099,378163,1009217,868201,911424,205517,198356,883183,112138,346349,477027,1016638,585846,554487,65649,594841,345358,694540,146016,460505,893646,589401,1046478,795477,632009,40524,406110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]