SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046807 LIMIT 1 [ RunTime:0.001470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046807 [ RunTime:0.002634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464776,924752,497048,756281,296947,834059,165781,911895,112223,233061,374857,372346,468533,808173,1009947,278963,686369,143381,113751,452573,384228,247287,141389,435467,111983,616647,1040446,986372,367565,191580,473120,958045,364086,749669,1016792,451941,423149,192606,756489,952657,552448,497846,744545,31,829863,468318,839533,1045460,322974,490287,616712,29474,252321,644727,97707,125455,612900,124126,639720,685302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000742s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]