Symfony Profiler

"{"queryId":"48af24ab-a16e-4654-8b01-4aafd3a6342f","data":{"summary":"Data Source: Global Network Report (Performance Data: events, clicks, revenue, costs, ROI).<br><br><table style=\"width:100%; border-collapse:collapse; font-size:13px; margin:10px 0;\"><tr style=\"background:#1B3A5C; color:white;\"><th style=\"padding:8px 10px; text-align:right; border:1px solid #ddd;\">Affiliate Id<\/th><th style=\"padding:8px 10px; text-align:left; border:1px solid #ddd;\">Affiliate Name<\/th><th style=\"padding:8px 10px; text-align:left; border:1px solid #ddd;\">Publisher Traffic Type<\/th><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">595<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Admatic<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">753<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) AppScaleAds Pty. Ltd.<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">825<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Appalgo<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">638<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Appssociate<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">690<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Click Orbits Pte Ltd<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">613<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) DCN Media LTD dba Viggo Digital<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">686<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) DiscoverMore LTD<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">693<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Erinlabs FZ LLC<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">81<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Fibermobi Performance Marketing Solution GmbH ICONPEAK<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">781<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) IrisMedia<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">751<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Kuromiko<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">752<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Piff Media Limited<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">678<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Pikakads Limited<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#f8f9fa;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">806<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Pink Media<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><tr style=\"background:#ffffff;\"><td style=\"padding:6px 10px; text-align:right; border:1px solid #eee;\">756<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">(Alexey) Princemobi<\/td><td style=\"padding:6px 10px; text-align:left; border:1px solid #eee;\">[]<\/td><\/tr><\/table><div style=\"margin-top:14px; padding:12px 14px; background:#f0f7ff; border-left:4px solid #1B3A5C; font-size:13px; line-height:1.6;\"><b>\ud83d\udcca Volume Leaders:<\/b><br>\u2022 <b>(Alexey) Admatic<\/b> leads with 595 Affiliate Id (5.9% of total)<\/div>","chart_url":"https:\/\/quickchart.io\/chart?c=%7B%22type%22%3A%22bar%22%2C%22data%22%3A%7B%22labels%22%3A%5B%22Alexey)_Admatic%22%2C%22Alexey)_AppScaleAds%22%2C%22Alexey)_Appalgo%22%2C%22Alexey)_Appssociate%22%2C%22Alexey)_Click%22%2C%22Alexey)_DCN%22%2C%22Alexey)_DiscoverMore%22%2C%22Alexey)_Erinlabs%22%2C%22Alexey)_Fibermobi%22%2C%22Alexey)_IrisMedia%22%2C%22Alexey)_Kuromiko%22%2C%22Alexey)_Piff%22%2C%22Alexey)_Pikakads%22%2C%22Alexey)_Pink%22%2C%22Alexey)_Princemobi%22%5D%2C%22datasets%22%3A%5B%7B%22label%22%3A%22Affiliate%20Id%22%2C%22data%22%3A%5B595%2C753%2C825%2C638%2C690%2C613%2C686%2C693%2C81%2C781%2C751%2C752%2C678%2C806%2C756%5D%2C%22backgroundColor%22%3A%22%23FF6384%22%7D%5D%7D%2C%22options%22%3A%7B%22responsive%22%3Atrue%2C%22plugins%22%3A%7B%22legend%22%3A%7B%22display%22%3Afalse%7D%7D%2C%22scales%22%3A%7B%22y%22%3A%7B%22beginAtZero%22%3Atrue%7D%7D%7D%7D&w=800&h=400&bkg=white","sql_query":"SELECT DISTINCT maf.id AS affiliate_id, maf.name AS affiliate_name, ((CASE WHEN bitwise_and(maf.traffic_type_mask, 1) > 0 THEN ARRAY['CTV'] ELSE CAST(ARRAY[] AS ARRAY(VARCHAR)) END) || (CASE WHEN bitwise_and(maf.traffic_type_mask, 2) > 0 THEN ARRAY['WEB'] ELSE CAST(ARRAY[] AS ARRAY(VARCHAR)) END) || (CASE WHEN bitwise_and(maf.traffic_type_mask, 4) > 0 THEN ARRAY['MOBILE'] ELSE CAST(ARRAY[] AS ARRAY(VARCHAR)) END) || (CASE WHEN bitwise_and(maf.traffic_type_mask, 8) > 0 THEN ARRAY['DSP'] ELSE CAST(ARRAY[] AS ARRAY(VARCHAR)) END) || (CASE WHEN bitwise_and(maf.traffic_type_mask, 16) > 0 THEN ARRAY['RETARGETING'] ELSE CAST(ARRAY[] AS ARRAY(VARCHAR)) END)) AS publisher_traffic_type FROM mafo_data_lake_parquet.mmp_reports mr LEFT JOIN mafo_data_lake_parquet.mafo_affiliates maf ON maf.id = mr.mafo_affiliate_id WHERE mr.report_date >= CAST(to_unixtime(TIMESTAMP '2026-05-01 00:00:00') * 1000000000 AS BIGINT) AND mr.report_date < CAST(to_unixtime(TIMESTAMP '2026-06-01 00:00:00') * 1000000000 AS BIGINT) AND LOWER(maf.name) LIKE '%x%' AND (mr.mmp_offer_id IS NULL OR mr.mmp_offer_active_flag = 1) AND mr.mmp_source NOT IN ('appsflyer_agency_account_manager', 'appsflyer_agency_af_agency') AND mr.mmp_mobile_apps_id IS NOT NULL AND (mr.affiliate NOT IN ('unilead_int', 'webmedia_int', 'auradsp42_int', 'mobinovo52_int', 'traffic4yoil300', 'af-agencyil647', 'myappmediail647', 'mobuppsxil619') OR mr.is_from_appsflyer_blocked_capping = 1) AND (mr.mmp_source NOT IN ('tune_mobile', 'tune_web') OR mr.app_id NOT IN (SELECT mobile_app FROM mafo_data_lake_parquet.mmp_offers WHERE is_deleted = 0)) ORDER BY maf.name ASC LIMIT 15"}}"

false