SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306451 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306451 [ RunTime:0.007493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495345,399129,445499,411116,402108,74369,385057,904482,283067,191618,460707,626802,276023,782566,175897,310746,87001,755895,627017,556781,310643,1007483,448943,844244,369084,835719,996423,1024371,725005,577854,338866,970809,268936,252210,541292,1011072,351220,74198,330300,473126,884263,169493,77467,869765,240096,200839,931278,804681,721209,914590,1012022,135089,991370,343090,606433,921519,67362,416038,147851,144316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000958s ]