Symfony Profiler

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mve_payments_invoice m0_
  LEFT JOIN mve_payments_payment m1_ ON m0_.payment_id = m1_.id
  LEFT JOIN mve_payments_purchase_event m2_ ON m0_.purchase_event_id = m2_.id
  LEFT JOIN mve_payments_purchase_member m3_ ON m1_.purchase_membre_id = m3_.id
  LEFT JOIN mve_payments_purchase_event m4_ ON m1_.purchase_event_id = m4_.id
  LEFT JOIN mve_events_event_user m5_ ON m2_.event_user_id = m5_.id
  LEFT JOIN mve_events_event_user m6_ ON m4_.event_user_id = m6_.id
  LEFT JOIN mve_communities_community_user m7_ ON m3_.community_user_id = m7_.id
  LEFT JOIN mve_communities_community_user m8_ ON m6_.community_user_id = m8_.id
  LEFT JOIN mve_communities_community_user m9_ ON m5_.community_user_id = m9_.id
WHERE
  m7_.user_id = ?
  OR m8_.user_id = ?
  OR m9_.user_id = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM mve_payments_invoice m0_ LEFT JOIN mve_payments_payment m1_ ON m0_.payment_id = m1_.id LEFT JOIN mve_payments_purchase_event m2_ ON m0_.purchase_event_id = m2_.id LEFT JOIN mve_payments_purchase_member m3_ ON m1_.purchase_membre_id = m3_.id LEFT JOIN mve_payments_purchase_event m4_ ON m1_.purchase_event_id = m4_.id LEFT JOIN mve_events_event_user m5_ ON m2_.event_user_id = m5_.id LEFT JOIN mve_events_event_user m6_ ON m4_.event_user_id = m6_.id LEFT JOIN mve_communities_community_user m7_ ON m3_.community_user_id = m7_.id LEFT JOIN mve_communities_community_user m8_ ON m6_.community_user_id = m8_.id LEFT JOIN mve_communities_community_user m9_ ON m5_.community_user_id = m9_.id WHERE m7_.user_id = 23 OR m8_.user_id = 23 OR m9_.user_id = 23;

SELECT
  t0.id AS id_1,
  t0.grade AS grade_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.level_id AS level_id_6,
  t0.country_group_id AS country_group_id_7
FROM
  mve_costs_cost t0
WHERE
  t0.country_group_id = ?
  AND t0.level_id = ?
  AND t0.grade = ?

SELECT t0.id AS id_1, t0.grade AS grade_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.level_id AS level_id_6, t0.country_group_id AS country_group_id_7 FROM mve_costs_cost t0 WHERE t0.country_group_id = 3 AND t0.level_id = 7 AND t0.grade = 'Affiliate';

SELECT
  t0.id AS id_1,
  t0.role_name AS role_name_2,
  t0.description AS description_3,
  t0.is_default AS is_default_4,
  t0.priority AS priority_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  mve_communities_role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.role_name AS role_name_2, t0.description AS description_3, t0.is_default AS is_default_4, t0.priority AS priority_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM mve_communities_role t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.cost_id AS cost_id_3,
  t0.community_id AS community_id_4
FROM
  mve_costs_community_cost t0
WHERE
  t0.community_id = ?
  AND t0.cost_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.price AS price_2, t0.cost_id AS cost_id_3, t0.community_id AS community_id_4 FROM mve_costs_community_cost t0 WHERE t0.community_id = 3 AND t0.cost_id = 14 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.email AS email_7,
  t0.birth_date AS birth_date_8,
  t0.gender AS gender_9,
  t0.phone AS phone_10,
  t0.password AS password_11,
  t0.password_hash AS password_hash_12,
  t0.is_active AS is_active_13,
  t0.type_social AS type_social_14,
  t0.id_social AS id_social_15,
  t0.is_blocked AS is_blocked_16,
  t0.cv AS cv_17,
  t0.bio AS bio_18,
  t0.picture AS picture_19,
  t0.qr_path AS qr_path_20,
  t0.is_default AS is_default_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.organization_id AS organization_id_24,
  t0.country_id AS country_id_25,
  t0.functions_id AS functions_id_26,
  t0.speciality_id AS speciality_id_27,
  t28.id AS id_29,
  t28.qr_code_content AS qr_code_content_30,
  t28.qr_code_image AS qr_code_image_31,
  t28.center_element_type AS center_element_type_32,
  t28.custom_icon_image AS custom_icon_image_33,
  t28.theme_color AS theme_color_34,
  t28.custom_color AS custom_color_35,
  t28.layout AS layout_36,
  t28.template_id AS template_id_37,
  t28.photo_position AS photo_position_38,
  t28.center_element_size AS center_element_size_39,
  t28.center_element_position AS center_element_position_40,
  t28.background_type AS background_type_41,
  t28.background_value AS background_value_42,
  t28.font_family AS font_family_43,
  t28.show_email AS show_email_44,
  t28.show_phone AS show_phone_45,
  t28.show_speciality AS show_speciality_46,
  t28.show_function AS show_function_47,
  t28.show_organization AS show_organization_48,
  t28.show_community_logo AS show_community_logo_49,
  t28.is_active AS is_active_50,
  t28.version AS version_51,
  t28.created_at AS created_at_52,
  t28.updated_at AS updated_at_53,
  t28.user_id AS user_id_54
FROM
  mve_users_user t0
  LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.username AS username_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.birth_date AS birth_date_8, t0.gender AS gender_9, t0.phone AS phone_10, t0.password AS password_11, t0.password_hash AS password_hash_12, t0.is_active AS is_active_13, t0.type_social AS type_social_14, t0.id_social AS id_social_15, t0.is_blocked AS is_blocked_16, t0.cv AS cv_17, t0.bio AS bio_18, t0.picture AS picture_19, t0.qr_path AS qr_path_20, t0.is_default AS is_default_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.organization_id AS organization_id_24, t0.country_id AS country_id_25, t0.functions_id AS functions_id_26, t0.speciality_id AS speciality_id_27, t28.id AS id_29, t28.qr_code_content AS qr_code_content_30, t28.qr_code_image AS qr_code_image_31, t28.center_element_type AS center_element_type_32, t28.custom_icon_image AS custom_icon_image_33, t28.theme_color AS theme_color_34, t28.custom_color AS custom_color_35, t28.layout AS layout_36, t28.template_id AS template_id_37, t28.photo_position AS photo_position_38, t28.center_element_size AS center_element_size_39, t28.center_element_position AS center_element_position_40, t28.background_type AS background_type_41, t28.background_value AS background_value_42, t28.font_family AS font_family_43, t28.show_email AS show_email_44, t28.show_phone AS show_phone_45, t28.show_speciality AS show_speciality_46, t28.show_function AS show_function_47, t28.show_organization AS show_organization_48, t28.show_community_logo AS show_community_logo_49, t28.is_active AS is_active_50, t28.version AS version_51, t28.created_at AS created_at_52, t28.updated_at AS updated_at_53, t28.user_id AS user_id_54 FROM mve_users_user t0 LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id WHERE t0.id = 23;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.grade AS grade_3,
  t0.status AS status_4,
  t0.payment_link_token AS payment_link_token_5,
  t0.payment_link_expires_at AS payment_link_expires_at_6,
  t0.validated_at AS validated_at_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.validated_by AS validated_by_10,
  t0.created_by_id AS created_by_id_11,
  t0.blocked_by_id AS blocked_by_id_12,
  t0.community_id AS community_id_13,
  t0.user_id AS user_id_14,
  t0.role_id AS role_id_15
FROM
  mve_communities_community_user t0
WHERE
  t0.user_id = ?
  AND t0.community_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.grade AS grade_3, t0.status AS status_4, t0.payment_link_token AS payment_link_token_5, t0.payment_link_expires_at AS payment_link_expires_at_6, t0.validated_at AS validated_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.validated_by AS validated_by_10, t0.created_by_id AS created_by_id_11, t0.blocked_by_id AS blocked_by_id_12, t0.community_id AS community_id_13, t0.user_id AS user_id_14, t0.role_id AS role_id_15 FROM mve_communities_community_user t0 WHERE t0.user_id = 23 AND t0.community_id = 3 LIMIT 1;

SELECT
  m0_.community_id AS sclr_0,
  COUNT(m0_.id) AS sclr_1
FROM
  mve_communities_community_user m0_
WHERE
  m0_.community_id IN (?)
  AND m0_.status IN (?, ?)
GROUP BY
  m0_.community_id

SELECT m0_.community_id AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM mve_communities_community_user m0_ WHERE m0_.community_id IN (3) AND m0_.status IN ('ACTIVE', 'Validated') GROUP BY m0_.community_id;

SELECT
  m0_.id AS id_0,
  m0_.unique_id AS unique_id_1,
  m0_.name AS name_2,
  m0_.fr_name AS fr_name_3,
  m0_.qr_path AS qr_path_4,
  m0_.slug AS slug_5,
  m0_.status AS status_6,
  m0_.pricing_plan AS pricing_plan_7,
  m0_.require_validation_before_payment AS require_validation_before_payment_8,
  m0_.community_url AS community_url_9,
  m0_.registration_background_url AS registration_background_url_10,
  m0_.signin_brand_config AS signin_brand_config_11,
  m0_.created_at AS created_at_12,
  m0_.updated_at AS updated_at_13,
  m1_.id AS id_14,
  m1_.unique_id AS unique_id_15,
  m1_.matricule_fiscal AS matricule_fiscal_16,
  m1_.name AS name_17,
  m1_.address AS address_18,
  m1_.city AS city_19,
  m1_.postal_code AS postal_code_20,
  m1_.phone AS phone_21,
  m1_.email AS email_22,
  m1_.web_site AS web_site_23,
  m1_.creation_date AS creation_date_24,
  m1_.description AS description_25,
  m1_.logo_url AS logo_url_26,
  m1_.fav_icon_url AS fav_icon_url_27,
  m1_.status AS status_28,
  m1_.created_at AS created_at_29,
  m1_.updated_at AS updated_at_30,
  m2_.id AS id_31,
  m2_.name AS name_32,
  m2_.fr_name AS fr_name_33,
  m2_.iso2 AS iso2_34,
  m2_.numeric_code AS numeric_code_35,
  m2_.enabled AS enabled_36,
  m0_.organization_id AS organization_id_37,
  m0_.speciality_id AS speciality_id_38,
  m1_.sector_id AS sector_id_39,
  m1_.country_id AS country_id_40,
  m1_.tax_id AS tax_id_41
FROM
  mve_communities_community m0_
  INNER JOIN mve_organizations_organization m1_ ON m0_.organization_id = m1_.id
  INNER JOIN mve_misc_country m2_ ON m1_.country_id = m2_.id
WHERE
  m0_.id IN (?)

SELECT m0_.id AS id_0, m0_.unique_id AS unique_id_1, m0_.name AS name_2, m0_.fr_name AS fr_name_3, m0_.qr_path AS qr_path_4, m0_.slug AS slug_5, m0_.status AS status_6, m0_.pricing_plan AS pricing_plan_7, m0_.require_validation_before_payment AS require_validation_before_payment_8, m0_.community_url AS community_url_9, m0_.registration_background_url AS registration_background_url_10, m0_.signin_brand_config AS signin_brand_config_11, m0_.created_at AS created_at_12, m0_.updated_at AS updated_at_13, m1_.id AS id_14, m1_.unique_id AS unique_id_15, m1_.matricule_fiscal AS matricule_fiscal_16, m1_.name AS name_17, m1_.address AS address_18, m1_.city AS city_19, m1_.postal_code AS postal_code_20, m1_.phone AS phone_21, m1_.email AS email_22, m1_.web_site AS web_site_23, m1_.creation_date AS creation_date_24, m1_.description AS description_25, m1_.logo_url AS logo_url_26, m1_.fav_icon_url AS fav_icon_url_27, m1_.status AS status_28, m1_.created_at AS created_at_29, m1_.updated_at AS updated_at_30, m2_.id AS id_31, m2_.name AS name_32, m2_.fr_name AS fr_name_33, m2_.iso2 AS iso2_34, m2_.numeric_code AS numeric_code_35, m2_.enabled AS enabled_36, m0_.organization_id AS organization_id_37, m0_.speciality_id AS speciality_id_38, m1_.sector_id AS sector_id_39, m1_.country_id AS country_id_40, m1_.tax_id AS tax_id_41 FROM mve_communities_community m0_ INNER JOIN mve_organizations_organization m1_ ON m0_.organization_id = m1_.id INNER JOIN mve_misc_country m2_ ON m1_.country_id = m2_.id WHERE m0_.id IN (3);

SELECT
  m0_.id AS id_0,
  m0_.unique_id AS unique_id_1,
  m0_.name AS name_2,
  m0_.slug AS slug_3,
  m0_.event_key AS event_key_4,
  m0_.type AS type_5,
  m0_.start_date AS start_date_6,
  m0_.end_date AS end_date_7,
  m0_.location AS location_8,
  m0_.description AS description_9,
  m0_.logo_url AS logo_url_10,
  m0_.background_url AS background_url_11,
  m0_.theme_color AS theme_color_12,
  m0_.signin_brand_config AS signin_brand_config_13,
  m0_.is_registration_open AS is_registration_open_14,
  m0_.registration_open_date AS registration_open_date_15,
  m0_.registration_close_date AS registration_close_date_16,
  m0_.registration_close_message AS registration_close_message_17,
  m0_.registration_status AS registration_status_18,
  m0_.hybrid_selected AS hybrid_selected_19,
  m0_.qr_path AS qr_path_20,
  m0_.created_at AS created_at_21,
  m0_.updated_at AS updated_at_22,
  m0_.community_id AS community_id_23,
  m0_.venue_id AS venue_id_24
FROM
  mve_events_event m0_
WHERE
  m0_.community_id = ?
  AND m0_.start_date > ?
ORDER BY
  m0_.start_date ASC
LIMIT
  50

SELECT m0_.id AS id_0, m0_.unique_id AS unique_id_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.event_key AS event_key_4, m0_.type AS type_5, m0_.start_date AS start_date_6, m0_.end_date AS end_date_7, m0_.location AS location_8, m0_.description AS description_9, m0_.logo_url AS logo_url_10, m0_.background_url AS background_url_11, m0_.theme_color AS theme_color_12, m0_.signin_brand_config AS signin_brand_config_13, m0_.is_registration_open AS is_registration_open_14, m0_.registration_open_date AS registration_open_date_15, m0_.registration_close_date AS registration_close_date_16, m0_.registration_close_message AS registration_close_message_17, m0_.registration_status AS registration_status_18, m0_.hybrid_selected AS hybrid_selected_19, m0_.qr_path AS qr_path_20, m0_.created_at AS created_at_21, m0_.updated_at AS updated_at_22, m0_.community_id AS community_id_23, m0_.venue_id AS venue_id_24 FROM mve_events_event m0_ WHERE m0_.community_id = 3 AND m0_.start_date > '2026-07-31 10:10:49' ORDER BY m0_.start_date ASC LIMIT 50;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mve_communities_community_user m0_
WHERE
  m0_.community_id = ?
  AND LOWER(m0_.status) = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM mve_communities_community_user m0_ WHERE m0_.community_id = 3 AND LOWER(m0_.status) = 'active';

SELECT
  DISTINCT cg.community_id
FROM
  mve_costs_country_group cg
  INNER JOIN mve_communities_community c ON c.id = cg.community_id
WHERE
  JSON_CONTAINS(cg.country_ids, ?) = 1
  AND c.status = ?

SELECT DISTINCT cg.community_id
            FROM mve_costs_country_group cg
            INNER JOIN mve_communities_community c ON c.id = cg.community_id
            WHERE JSON_CONTAINS(cg.country_ids, '227') = 1
              AND c.status = 'Publish'
        ;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.ownership_year AS ownership_year_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.creator_id AS creator_id_8,
  t0.owner_id AS owner_id_9,
  t0.community_id AS community_id_10
FROM
  mve_communities_community_owner t0
WHERE
  t0.owner_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.ownership_year AS ownership_year_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.creator_id AS creator_id_8, t0.owner_id AS owner_id_9, t0.community_id AS community_id_10 FROM mve_communities_community_owner t0 WHERE t0.owner_id = 23;

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.field_name AS field_name_3,
  t0.field_name_fr AS field_name_fr_4,
  t0.field_type AS field_type_5,
  t0.is_required AS is_required_6,
  t0.is_visible AS is_visible_7,
  t0.is_editable AS is_editable_8,
  t0.description AS description_9,
  t0.options AS options_10,
  t0.options_fr AS options_fr_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.community_id AS community_id_14
FROM
  mve_communities_custom_field t0
WHERE
  t0.community_id = ?
  AND t0.is_visible = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.field_name AS field_name_3, t0.field_name_fr AS field_name_fr_4, t0.field_type AS field_type_5, t0.is_required AS is_required_6, t0.is_visible AS is_visible_7, t0.is_editable AS is_editable_8, t0.description AS description_9, t0.options AS options_10, t0.options_fr AS options_fr_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.community_id AS community_id_14 FROM mve_communities_custom_field t0 WHERE t0.community_id = 3 AND t0.is_visible = 1 ORDER BY t0.id ASC;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mve_communities_community_owner m0_
  INNER JOIN mve_communities_community m1_ ON m0_.community_id = m1_.id
  INNER JOIN mve_organizations_organization m2_ ON m1_.organization_id = m2_.id
  INNER JOIN mve_misc_country m3_ ON m2_.country_id = m3_.id
WHERE
  m0_.owner_id = ?
  AND m0_.community_id = ?
  AND m0_.status = ?
  AND m1_.status = ?
  AND m3_.id = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM mve_communities_community_owner m0_ INNER JOIN mve_communities_community m1_ ON m0_.community_id = m1_.id INNER JOIN mve_organizations_organization m2_ ON m1_.organization_id = m2_.id INNER JOIN mve_misc_country m3_ ON m2_.country_id = m3_.id WHERE m0_.owner_id = 23 AND m0_.community_id = 3 AND m0_.status = 'current' AND m1_.status = 'Publish' AND m3_.id = 227;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mve_communities_community m0_
WHERE
  m0_.status = ?
  AND m0_.id IN (?)

SELECT COUNT(m0_.id) AS sclr_0 FROM mve_communities_community m0_ WHERE m0_.status = 'Publish' AND m0_.id IN (3);

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mve_communities_community_user m0_
  INNER JOIN mve_communities_role m1_ ON m0_.role_id = m1_.id
WHERE
  m0_.user_id = ?
  AND m0_.community_id = ?
  AND LOWER(m0_.status) <> LOWER(?)
  AND m1_.role_name <> ?

SELECT COUNT(m0_.id) AS sclr_0 FROM mve_communities_community_user m0_ INNER JOIN mve_communities_role m1_ ON m0_.role_id = m1_.id WHERE m0_.user_id = 23 AND m0_.community_id = 3 AND LOWER(m0_.status) <> LOWER('Rejected') AND m1_.role_name <> 'ROLE_NON_MEMBER';