[ DB ] CONNECT:[ UseTime:0.000469s ] mysql:host=127.0.0.1;port=3306;dbname=fx_develop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fx_merchant_setting` [ RunTime:0.001326s ]
[ SQL ] SELECT `h_id` FROM `fx_merchant_setting` WHERE ( `auto_domain` = 'fx' OR `weapp_domain` = 'fx' ) LIMIT 1 [ RunTime:0.000596s ]
[ SQL ] SHOW COLUMNS FROM `fx_member` [ RunTime:0.002134s ]
[ SQL ] SELECT * FROM `fx_member` WHERE `userid` IS NULL LIMIT 1 [ RunTime:0.002702s ]
[ SQL ] SHOW COLUMNS FROM `fx_member_sub` [ RunTime:0.001843s ]
[ SQL ] SELECT * FROM `fx_member_sub` WHERE `userid` = 0 LIMIT 1 [ RunTime:0.005956s ]
[ SQL ] SELECT * FROM `fx_member` WHERE `userid` IS NULL LIMIT 1 [ RunTime:0.000941s ]
[ SQL ] SHOW COLUMNS FROM `fx_product` [ RunTime:0.001570s ]
[ SQL ] SELECT `brand_id` FROM `fx_product` WHERE `status` = 1 AND `fx08_is_show_zhu` = 1 GROUP BY `brand_id` [ RunTime:0.015018s ]
[ SQL ] SELECT `brand_id` FROM `fx_product` WHERE `fx08_product_type` = 6 AND `brand_id` IN (0,1,2,3,5,9,10,11,12,13,14,15,18,19,21,22,25,27,28,29,31,36,37,41,45,47,50,58,67,68,69,70,73,75,77,79,80,86,96,97,102,103,106,107,114,117,135,136,143,146,153,160,169,176,205,211,216,219,221,222,223,224,226,235,240,241,242,245,246,251,255,259,266,271,276,293,298,305,307,315,325,332,336,338,339,352,357,359,360,367,370,388,394,416,424,427,428,442,449,456,467,468,470,471,473,485,487,507,508,509,512,514,521,529,535,551,554,565,566,567,570,572,573,574,576,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,607,608,611,612,618,619,621,622,623,624,625,626,628,629,630,631,643,645,646,648,649,650,651,652,653,654,655,657,666,668,669,672,673,674,675,676,678,681,683,694,697) [ RunTime:0.006692s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fx_product` WHERE `brand_id` = 0 GROUP BY `fx08_product_type` ) `_group_count_` [ RunTime:0.007493s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fx_product` WHERE `brand_id` = 1 GROUP BY `fx08_product_type` ) `_group_count_` [ RunTime:0.006188s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fx_product` WHERE `brand_id` = 1 GROUP BY `fx08_product_type` ) `_group_count_` [ RunTime:0.006078s ]
[ SQL ] SHOW COLUMNS FROM `fx_store_brand` [ RunTime:0.000544s ]
[ SQL ] SELECT `id`,`brand_chinese_name`,`brand_logo`,`brand_pinyin_first_word` FROM `fx_store_brand` WHERE `status` = 1 AND `id` IN (0,1,2,3,5,9,10,11,12,13,14,15,18,19,21,22,25,27,28,29,31,36,37,41,45,47,50,58,67,68,69,70,73,75,77,79,80,86,96,97,102,103,106,107,114,117,135,136,143,146,153,160,169,176,205,211,216,219,221,222,223,224,226,235,240,241,242,245,246,251,255,259,266,271,276,293,298,305,307,315,325,332,336,338,339,352,357,359,360,367,370,388,394,416,424,427,428,442,449,456,467,468,470,471,473,485,487,507,508,509,512,514,521,529,535,551,554,565,566,567,570,572,573,574,576,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,607,608,611,612,618,619,621,622,623,624,625,626,628,629,630,631,643,645,646,648,649,650,651,652,653,654,655,657,666,668,669,672,673,674,675,676,678,681,683,694,697) AND `id` <> 496 [ RunTime:0.002045s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fx_store_brand` WHERE `status` = 1 AND `id` IN (0,1,2,3,5,9,10,11,12,13,14,15,18,19,21,22,25,27,28,29,31,36,37,41,45,47,50,58,67,68,69,70,73,75,77,79,80,86,96,97,102,103,106,107,114,117,135,136,143,146,153,160,169,176,205,211,216,219,221,222,223,224,226,235,240,241,242,245,246,251,255,259,266,271,276,293,298,305,307,315,325,332,336,338,339,352,357,359,360,367,370,388,394,416,424,427,428,442,449,456,467,468,470,471,473,485,487,507,508,509,512,514,521,529,535,551,554,565,566,567,570,572,573,574,576,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,607,608,611,612,618,619,621,622,623,624,625,626,628,629,630,631,643,645,646,648,649,650,651,652,653,654,655,657,666,668,669,672,673,674,675,676,678,681,683,694,697) AND `id` <> 496 [ RunTime:0.001252s ]
[ SQL ] SHOW COLUMNS FROM `fx_poster` [ RunTime:0.000587s ]
[ SQL ] SELECT * FROM `fx_poster` WHERE `start_time` < 1791970154 AND `type` = 1 AND `end_time` > 1791970154 ORDER BY `list_order` ASC [ RunTime:0.000322s ]
[ SQL ] SHOW COLUMNS FROM `fx_store_settled` [ RunTime:0.000723s ]
[ SQL ] SELECT `status` FROM `fx_store_settled` WHERE `userid` = 0 LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SHOW COLUMNS FROM `fx_hot_keywords_setting` [ RunTime:0.000399s ]
[ SQL ] SELECT `pc_url`,`weapp_url`,`color`,`keyword` FROM `fx_hot_keywords_setting` WHERE `h_id` IS NULL ORDER BY `list_order` ASC,`id` ASC LIMIT 10 [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `fx_member` WHERE `userid` = 0 LIMIT 1 [ RunTime:0.000580s ]
[ SQL ] SHOW COLUMNS FROM `fx_product_cat` [ RunTime:0.000438s ]
[ SQL ] SELECT SUM(`num`) AS tp_sum FROM `fx_product_cat` WHERE `status` = 1 AND `userid` = 0 AND `session_id` = '6tsu0cd17pc2igo66mk045lmm0' AND `fx08_is_price_modified` = 0 [ RunTime:0.000369s ]
[ SQL ] SHOW COLUMNS FROM `fx_navigate` [ RunTime:0.000393s ]
[ SQL ] SELECT * FROM `fx_navigate` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000314s ]
[ SQL ] SELECT `fx08_banner_url` FROM `fx_navigate` WHERE `navid` = 10 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SHOW COLUMNS FROM `fx_fx08_website_advantage` [ RunTime:0.000387s ]
[ SQL ] SELECT `image_url`,`title`,`desc` FROM `fx_fx08_website_advantage` WHERE `h_id` IS NULL ORDER BY `id` ASC LIMIT 5 [ RunTime:0.000190s ]
[ SQL ] SELECT * FROM `fx_navigate` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000286s ]