[ DB ] CONNECT:[ UseTime:0.001451s ] mysql:host=127.0.0.1;port=3306;dbname=fx_develop;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fx_merchant_setting` [ RunTime:0.001671s ]
[ SQL ] SELECT `h_id` FROM `fx_merchant_setting` WHERE ( `auto_domain` = 'fx' OR `weapp_domain` = 'fx' ) LIMIT 1 [ RunTime:0.001395s ]
[ SQL ] SHOW COLUMNS FROM `fx_member` [ RunTime:0.017343s ]
[ SQL ] SELECT * FROM `fx_member` WHERE `userid` IS NULL LIMIT 1 [ RunTime:0.001693s ]
[ SQL ] SHOW COLUMNS FROM `fx_member_sub` [ RunTime:0.000660s ]
[ SQL ] SELECT * FROM `fx_member_sub` WHERE `userid` = 0 LIMIT 1 [ RunTime:0.000325s ]
[ SQL ] SELECT * FROM `fx_member` WHERE `userid` IS NULL LIMIT 1 [ RunTime:0.000754s ]
[ SQL ] SHOW COLUMNS FROM `fx_product` [ RunTime:0.001564s ]
[ SQL ] SELECT `brand_id` FROM `fx_product` WHERE `status` = 1 AND `fx08_is_show_zhu` = 1 GROUP BY `brand_id` [ RunTime:0.020538s ]
[ 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.013649s ]
[ 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.028197s ]
[ 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.018586s ]
[ 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.018643s ]
[ SQL ] SHOW COLUMNS FROM `fx_store_brand` [ RunTime:0.000627s ]
[ 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.002552s ]
[ 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.002761s ]
[ SQL ] SHOW COLUMNS FROM `fx_poster` [ RunTime:0.000893s ]
[ SQL ] SELECT * FROM `fx_poster` WHERE `start_time` < 1791970261 AND `type` = 1 AND `end_time` > 1791970261 ORDER BY `list_order` ASC [ RunTime:0.000540s ]
[ SQL ] SHOW COLUMNS FROM `fx_store_settled` [ RunTime:0.001200s ]
[ SQL ] SELECT `status` FROM `fx_store_settled` WHERE `userid` = 0 LIMIT 1 [ RunTime:0.001428s ]
[ SQL ] SHOW COLUMNS FROM `fx_hot_keywords_setting` [ RunTime:0.003000s ]
[ 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.001216s ]
[ SQL ] SELECT * FROM `fx_member` WHERE `userid` = 0 LIMIT 1 [ RunTime:0.001521s ]
[ SQL ] SHOW COLUMNS FROM `fx_product_cat` [ RunTime:0.007104s ]
[ SQL ] SELECT SUM(`num`) AS tp_sum FROM `fx_product_cat` WHERE `status` = 1 AND `userid` = 0 AND `session_id` = 'effkmjar39032lm016i5t128tp' AND `fx08_is_price_modified` = 0 [ RunTime:0.000859s ]
[ SQL ] SHOW COLUMNS FROM `fx_navigate` [ RunTime:0.000727s ]
[ SQL ] SELECT * FROM `fx_navigate` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000365s ]
[ SQL ] SELECT `fx08_banner_url` FROM `fx_navigate` WHERE `navid` = 10 LIMIT 1 [ RunTime:0.001180s ]
[ SQL ] SHOW COLUMNS FROM `fx_fx08_website_advantage` [ RunTime:0.000677s ]
[ SQL ] SELECT `image_url`,`title`,`desc` FROM `fx_fx08_website_advantage` WHERE `h_id` IS NULL ORDER BY `id` ASC LIMIT 5 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `fx_navigate` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000476s ]
正在查找同款中
