SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488787 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488787 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336560,441673,1030572,13958,411300,536886,556230,814714,566300,776461,260957,80477,424486,1033785,710883,558154,411501,801447,655537,793234,875249,770327,506812,141163,713653,742401,391376,141503,918942,951734,858036,270113,60737,752636,1024149,85436,485252,756344,699845,241949,601506,595709,444613,948867,75572,599686,598429,253127,97337,389282,80581,898659,140597,948830,342563,367754,566262,915223,1038753,868095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]