Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 12
• Events
• Routing
• Cache
• Translation 21
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Workflow
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.role AS role_7, t0.is_active AS is_active_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12 FROM "user" t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.role AS role_7,
  t0.is_active AS is_active_8,
  t0.last_login_at AS last_login_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.organization_id AS organization_id_12
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.role AS role_7, t0.is_active AS is_active_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.organization_id AS organization_id_12 FROM "user" t0 WHERE t0.id = 3;

SELECT DISTINCT o0_.id AS id_0, o0_.company_name AS company_name_1 FROM organization o0_ WHERE o0_.assigned_cm_id = ? AND o0_.status <> ? ORDER BY o0_.company_name ASC LIMIT 25

[
  3
  "churned"
]

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.company_name AS company_name_1
FROM
  organization o0_
WHERE
  o0_.assigned_cm_id = ?
  AND o0_.status <> ?
ORDER BY
  o0_.company_name ASC
LIMIT
  25

SELECT DISTINCT o0_.id AS id_0, o0_.company_name AS company_name_1 FROM organization o0_ WHERE o0_.assigned_cm_id = 3 AND o0_.status <> 'churned' ORDER BY o0_.company_name ASC LIMIT 25;

SELECT o0_.id AS id_0, o0_.company_name AS company_name_1, o0_.email AS email_2, o0_.phone AS phone_3, o0_.website AS website_4, o0_.status AS status_5, o0_.pack_type AS pack_type_6, o0_.validation_mode AS validation_mode_7, o0_.custom_posts_per_month AS custom_posts_per_month_8, o0_.custom_max_networks AS custom_max_networks_9, o0_.custom_price_ht AS custom_price_ht_10, o0_.dolibarr_third_party_id AS dolibarr_third_party_id_11, o0_.brand_brief AS brand_brief_12, o0_.content_strategy AS content_strategy_13, o0_.visual_identity AS visual_identity_14, o0_.calendar_preferences AS calendar_preferences_15, o0_.compliance_rules AS compliance_rules_16, o0_.platform_policies AS platform_policies_17, o0_.compiled_brand_core AS compiled_brand_core_18, o0_.compiled_platform_policies AS compiled_platform_policies_19, o0_.compiled_brief_version AS compiled_brief_version_20, o0_.onboarding_step AS onboarding_step_21, o0_.brief_completeness_score AS brief_completeness_score_22, o0_.completed_onboarding_steps AS completed_onboarding_steps_23, o0_.onboarding_part_completed_at AS onboarding_part_completed_at_24, o0_.zernio_profile_id AS zernio_profile_id_25, o0_.created_at AS created_at_26, o0_.updated_at AS updated_at_27, o0_.assigned_cm_id AS assigned_cm_id_28 FROM organization o0_ WHERE o0_.assigned_cm_id = ? AND o0_.status <> ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.company_name ASC

[
  3
  "churned"
  4
  3
  6
  11
  12
  13
  14
  7
]

SELECT
  o0_.id AS id_0,
  o0_.company_name AS company_name_1,
  o0_.email AS email_2,
  o0_.phone AS phone_3,
  o0_.website AS website_4,
  o0_.status AS status_5,
  o0_.pack_type AS pack_type_6,
  o0_.validation_mode AS validation_mode_7,
  o0_.custom_posts_per_month AS custom_posts_per_month_8,
  o0_.custom_max_networks AS custom_max_networks_9,
  o0_.custom_price_ht AS custom_price_ht_10,
  o0_.dolibarr_third_party_id AS dolibarr_third_party_id_11,
  o0_.brand_brief AS brand_brief_12,
  o0_.content_strategy AS content_strategy_13,
  o0_.visual_identity AS visual_identity_14,
  o0_.calendar_preferences AS calendar_preferences_15,
  o0_.compliance_rules AS compliance_rules_16,
  o0_.platform_policies AS platform_policies_17,
  o0_.compiled_brand_core AS compiled_brand_core_18,
  o0_.compiled_platform_policies AS compiled_platform_policies_19,
  o0_.compiled_brief_version AS compiled_brief_version_20,
  o0_.onboarding_step AS onboarding_step_21,
  o0_.brief_completeness_score AS brief_completeness_score_22,
  o0_.completed_onboarding_steps AS completed_onboarding_steps_23,
  o0_.onboarding_part_completed_at AS onboarding_part_completed_at_24,
  o0_.zernio_profile_id AS zernio_profile_id_25,
  o0_.created_at AS created_at_26,
  o0_.updated_at AS updated_at_27,
  o0_.assigned_cm_id AS assigned_cm_id_28
FROM
  organization o0_
WHERE
  o0_.assigned_cm_id = ?
  AND o0_.status <> ?
  AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.company_name ASC

SELECT o0_.id AS id_0, o0_.company_name AS company_name_1, o0_.email AS email_2, o0_.phone AS phone_3, o0_.website AS website_4, o0_.status AS status_5, o0_.pack_type AS pack_type_6, o0_.validation_mode AS validation_mode_7, o0_.custom_posts_per_month AS custom_posts_per_month_8, o0_.custom_max_networks AS custom_max_networks_9, o0_.custom_price_ht AS custom_price_ht_10, o0_.dolibarr_third_party_id AS dolibarr_third_party_id_11, o0_.brand_brief AS brand_brief_12, o0_.content_strategy AS content_strategy_13, o0_.visual_identity AS visual_identity_14, o0_.calendar_preferences AS calendar_preferences_15, o0_.compliance_rules AS compliance_rules_16, o0_.platform_policies AS platform_policies_17, o0_.compiled_brand_core AS compiled_brand_core_18, o0_.compiled_platform_policies AS compiled_platform_policies_19, o0_.compiled_brief_version AS compiled_brief_version_20, o0_.onboarding_step AS onboarding_step_21, o0_.brief_completeness_score AS brief_completeness_score_22, o0_.completed_onboarding_steps AS completed_onboarding_steps_23, o0_.onboarding_part_completed_at AS onboarding_part_completed_at_24, o0_.zernio_profile_id AS zernio_profile_id_25, o0_.created_at AS created_at_26, o0_.updated_at AS updated_at_27, o0_.assigned_cm_id AS assigned_cm_id_28 FROM organization o0_ WHERE o0_.assigned_cm_id = 3 AND o0_.status <> 'churned' AND o0_.id IN (4, 3, 6, 11, 12, 13, 14, 7) ORDER BY o0_.company_name ASC;

SELECT count(*) AS sclr_0 FROM organization o0_ WHERE o0_.assigned_cm_id = ? AND o0_.status <> ?

[
  3
  "churned"
]

SELECT
  count(*) AS sclr_0
FROM
  organization o0_
WHERE
  o0_.assigned_cm_id = ?
  AND o0_.status <> ?

SELECT count(*) AS sclr_0 FROM organization o0_ WHERE o0_.assigned_cm_id = 3 AND o0_.status <> 'churned';