SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318083 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318083 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881418,405082,526998,392546,870759,224851,783788,756207,68922,994870,195533,876045,523926,869166,272217,389407,314208,761212,554405,680514,30405,638801,764911,1008242,790692,818987,82598,813902,819825,31169,502872,668329,636501,525033,83105,719201,969277,808857,555309,537697,492319,544239,424013,35962,337707,45738,300875,944761,728379,307110,452953,338042,708414,679723,885831,45784,688110,431580,522786,62272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]