SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671064 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671064 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416104,387648,2694,991186,925600,52712,591138,126914,916186,146517,506614,1011585,1040580,337598,389919,221561,971919,890276,940001,510818,260118,136951,341134,910629,862890,879772,1047122,270757,29693,575052,328210,590166,503788,27149,838396,241677,962351,786737,157562,231510,1018831,448142,950228,999453,1032433,629493,759904,992560,860986,536085,99706,172398,398122,232140,798292,129549,1020698,572250,76851,612824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]