SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204987 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204987 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233742,656529,548576,77211,52002,565001,560036,662452,403467,881635,179465,703788,474109,189366,321689,666947,212780,746430,72040,401919,70594,858902,455811,538478,97564,754551,512435,318890,890005,658784,307489,624684,416152,506494,473561,396738,372309,995996,219783,339659,1002571,850299,741944,534695,914919,687817,30615,320533,73606,904861,894661,510366,676935,649151,449898,9048,153778,304677,730279,873004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]