Symfony Profiler

[
  "route" => "app_viooer_event_show"
  "route_parameters" => [
    "_route" => "app_viooer_event_show"
    "_controller" => "App\Controller\Viooer\ViooerEventsController::show"
    "id" => "16"
  ]
  "request_uri" => "https://preprod.myvioo.community/viooer/events/16/show"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\LoginFormAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\OAuthAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\OAuthAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\RouteAccessConfigValidatorSubscriber::validateConfig"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LocaleSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\AccessDeniedListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\EnsureSelectedRoleListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "App\EventListener\ViooerAccessListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container0IguxIx\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\RememberMeToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "myvioo_preprod_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "myvioo_preprod_db"
    "serverVersion" => "10.6.22MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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_gender AS show_gender_49, t28.show_country AS show_country_50, t28.show_bio AS show_bio_51, t28.show_community_logo AS show_community_logo_52, t28.is_active AS is_active_53, t28.version AS version_54, t28.created_at AS created_at_55, t28.updated_at AS updated_at_56, t28.user_id AS user_id_57 FROM mve_users_user t0 LEFT JOIN mve_user_badge t28 ON t28.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "pm6@millesima-experience.com"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "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_.registration_background_url AS registration_background_url_12, m0_.cover_url AS cover_url_13, m0_.theme_color AS theme_color_14, m0_.signin_brand_config AS signin_brand_config_15, m0_.is_registration_open AS is_registration_open_16, m0_.include_landing_page AS include_landing_page_17, m0_.registration_open_date AS registration_open_date_18, m0_.registration_close_date AS registration_close_date_19, m0_.registration_close_message AS registration_close_message_20, m0_.registration_status AS registration_status_21, m0_.hybrid_selected AS hybrid_selected_22, m0_.qr_path AS qr_path_23, m0_.created_at AS created_at_24, m0_.updated_at AS updated_at_25, m1_.id AS id_26, m1_.unique_id AS unique_id_27, m1_.name AS name_28, m1_.fr_name AS fr_name_29, m1_.qr_path AS qr_path_30, m1_.slug AS slug_31, m1_.status AS status_32, m1_.pricing_plan AS pricing_plan_33, m1_.require_validation_before_payment AS require_validation_before_payment_34, m1_.community_url AS community_url_35, m1_.registration_background_url AS registration_background_url_36, m1_.cover_url AS cover_url_37, m1_.signin_brand_config AS signin_brand_config_38, m1_.created_at AS created_at_39, m1_.updated_at AS updated_at_40, m2_.id AS id_41, m2_.unique_id AS unique_id_42, m2_.matricule_fiscal AS matricule_fiscal_43, m2_.name AS name_44, m2_.address AS address_45, m2_.city AS city_46, m2_.postal_code AS postal_code_47, m2_.phone AS phone_48, m2_.email AS email_49, m2_.web_site AS web_site_50, m2_.creation_date AS creation_date_51, m2_.description AS description_52, m2_.logo_url AS logo_url_53, m2_.fav_icon_url AS fav_icon_url_54, m2_.status AS status_55, m2_.created_at AS created_at_56, m2_.updated_at AS updated_at_57, m3_.id AS id_58, m3_.name AS name_59, m3_.fr_name AS fr_name_60, m3_.iso2 AS iso2_61, m3_.numeric_code AS numeric_code_62, m3_.enabled AS enabled_63, m0_.community_id AS community_id_64, m0_.venue_id AS venue_id_65, m1_.organization_id AS organization_id_66, m1_.speciality_id AS speciality_id_67, m2_.sector_id AS sector_id_68, m2_.country_id AS country_id_69, m2_.tax_id AS tax_id_70 FROM mve_events_event m0_ INNER JOIN mve_communities_community m1_ ON m0_.community_id = m1_.id LEFT JOIN mve_organizations_organization m2_ ON m1_.organization_id = m2_.id LEFT JOIN mve_misc_country m3_ ON m2_.country_id = m3_.id WHERE m0_.id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \r\n
                SELECT DISTINCT cg.community_id\r\n
                FROM mve_costs_country_group cg\r\n
                INNER JOIN mve_communities_community c ON c.id = cg.community_id\r\n
                WHERE JSON_CONTAINS(cg.country_ids, ?) = 1\r\n
                  AND c.status = ?\r\n
            
    """
  "params" => [
    1 => "227"
    2 => "Publish"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT COUNT(m0_.id) AS sclr_0 FROM mve_events_event_user m0_ WHERE m0_.event_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT DISTINCT m0_.id AS id_0, m0_.name AS name_1, m0_.rate AS rate_2, m0_.country_ids AS country_ids_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m1_.id AS id_6, m1_.grade AS grade_7, m1_.status AS status_8, m1_.created_at AS created_at_9, m1_.updated_at AS updated_at_10, m2_.id AS id_11, m2_.name AS name_12, m2_.priority AS priority_13, m2_.created_at AS created_at_14, m2_.updated_at AS updated_at_15, m0_.currency_id AS currency_id_16, m0_.community_id AS community_id_17, m1_.level_id AS level_id_18, m1_.country_group_id AS country_group_id_19, m2_.community_id AS community_id_20 FROM mve_costs_country_group m0_ LEFT JOIN mve_costs_cost m1_ ON m0_.id = m1_.country_group_id LEFT JOIN mve_costs_level m2_ ON m1_.level_id = m2_.id WHERE m0_.community_id = ? ORDER BY m0_.name ASC, m1_.id ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.event_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT m0_.cost_id AS sclr_0, m0_.price AS price_1 FROM mve_costs_community_cost m0_ WHERE m0_.community_id = ? AND m0_.cost_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 3
    2 => 27
    3 => 28
    4 => 29
    5 => 30
    6 => 31
    7 => 32
    8 => 33
    9 => 34
    10 => 35
    11 => 36
    12 => 37
    13 => 38
    14 => 39
    15 => 40
    16 => 41
    17 => 42
    18 => 19
    19 => 20
    20 => 21
    21 => 22
    22 => 23
    23 => 24
    24 => 25
    25 => 26
    26 => 43
    27 => 44
    28 => 45
    29 => 46
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.mode AS mode_1, m0_.participant_number AS participant_number_2, m0_.payment_status AS payment_status_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m1_.id AS id_6, m1_.unique_id AS unique_id_7, m1_.grade AS grade_8, m1_.status AS status_9, m1_.payment_link_token AS payment_link_token_10, m1_.payment_link_expires_at AS payment_link_expires_at_11, m1_.validated_at AS validated_at_12, m1_.created_at AS created_at_13, m1_.updated_at AS updated_at_14, m0_.event_id AS event_id_15, m0_.community_user_id AS community_user_id_16, m1_.validated_by AS validated_by_17, m1_.created_by_id AS created_by_id_18, m1_.blocked_by_id AS blocked_by_id_19, m1_.community_id AS community_id_20, m1_.user_id AS user_id_21, m1_.role_id AS role_id_22 FROM mve_events_event_user m0_ INNER JOIN mve_communities_community_user m1_ ON m0_.community_user_id = m1_.id WHERE m1_.user_id = ? AND m0_.event_id = ?"
  "params" => [
    1 => 23
    2 => 16
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 23
    2 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM mve_misc_currency t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.value AS value_2, t0.description AS description_3, t0.max_participants AS max_participants_4, t0.access_type AS access_type_5, t0.EventId AS EventId_6 FROM mve_costs_category t0 WHERE t0.EventId = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6, t0.event_period_id AS event_period_id_7 FROM mve_costs_category_date t0 WHERE t0.category_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.event_id AS event_id_7 FROM mve_events_event_period t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.event_id AS event_id_7 FROM mve_events_event_period t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.community_id AS community_id_6 FROM mve_costs_level t0 WHERE t0.community_id = ? ORDER BY t0.priority ASC, t0.id ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id = ? LIMIT 1"
  "params" => [
    1 => 16
    2 => 21
    3 => 0
    4 => 13
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
    4 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id = ? LIMIT 1"
  "params" => [
    1 => 16
    2 => 22
    3 => 0
    4 => 13
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
    4 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id = ? LIMIT 1"
  "params" => [
    1 => 16
    2 => 43
    3 => 0
    4 => 13
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
    4 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id IS NULL LIMIT 1"
  "params" => [
    1 => 16
    2 => 43
    3 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 3
    2 => 43
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id = ? LIMIT 1"
  "params" => [
    1 => 16
    2 => 20
    3 => 0
    4 => 13
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
    4 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id = ? LIMIT 1"
  "params" => [
    1 => 16
    2 => 19
    3 => 0
    4 => 13
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
    4 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id = ? LIMIT 1"
  "params" => [
    1 => 16
    2 => 44
    3 => 0
    4 => 13
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
    4 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.category_id = ? AND t0.cost_id = ? AND t0.is_member = ? AND t0.category_date_id IS NULL LIMIT 1"
  "params" => [
    1 => 16
    2 => 44
    3 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 3
    2 => 44
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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.placeholder AS placeholder_10, t0.options AS options_11, t0.options_fr AS options_fr_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.event_id AS event_id_15 FROM mve_users_events_custom_field_event t0 WHERE t0.event_id = ? AND t0.is_visible = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 16
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 5
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.stock AS stock_7, t0.access_type AS access_type_8, t0.api_url AS api_url_9, t0.api_mode AS api_mode_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.event_id AS event_id_14, t0.event_venues_area_id AS event_venues_area_id_15 FROM mve_services_event_prestation t0 WHERE t0.event_id = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.is_member AS is_member_3, t0.cost_id AS cost_id_4, t0.event_prestation_id AS event_prestation_id_5 FROM mve_cost_prestation_cost t0 WHERE t0.event_prestation_id = ?"
  "params" => [
    1 => 25
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.is_member AS is_member_3, t0.cost_id AS cost_id_4, t0.event_prestation_id AS event_prestation_id_5 FROM mve_cost_prestation_cost t0 WHERE t0.event_prestation_id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.is_member AS is_member_3, t0.cost_id AS cost_id_4, t0.event_prestation_id AS event_prestation_id_5 FROM mve_cost_prestation_cost t0 WHERE t0.event_prestation_id = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.price AS price_2, t0.reduction AS reduction_3, t0.type AS type_4, t0.is_member AS is_member_5, t0.event_id AS event_id_6, t0.cost_id AS cost_id_7, t0.category_id AS category_id_8, t0.category_date_id AS category_date_id_9 FROM mve_costs_event_cost t0 WHERE t0.event_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.is_active AS is_active_1, m0_.config AS config_2, m0_.description AS description_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m1_.id AS id_6, m1_.name AS name_7, m1_.description AS description_8, m1_.is_active AS is_active_9, m1_.code AS code_10, m1_.logo AS logo_11, m1_.config AS config_12, m1_.created_at AS created_at_13, m1_.updated_at AS updated_at_14, m0_.organization_id AS organization_id_15, m0_.payment_method_id AS payment_method_id_16, m1_.payment_type_id AS payment_type_id_17 FROM mve_payments_payment_org_method m0_ INNER JOIN mve_payments_payment_method m1_ ON m0_.payment_method_id = m1_.id WHERE m0_.organization_id = ? AND m0_.is_active = ? AND LOWER(m1_.code) NOT IN (?, ?, ?, ?) ORDER BY m1_.name ASC"
  "params" => [
    1 => 3
    2 => 1
    3 => "cheque"
    4 => "especes"
    5 => "tpe"
    6 => "bon_commande"
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 2
    4 => 2
    5 => 2
    6 => 2
  ]
]

[
  "key" => "user_community_roles_23"
]

[
  "key" => "user_community_roles_23"
]

[
  "key" => "owner_community_id_23"
]

[
  "key" => "user_community_roles_23"
]

[
  "key" => "3600"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 23
    2 => 23
    3 => 23
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]