Symfony Profiler

[
  "route" => "_api_/b2b/workshops{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/b2b/workshops{._format}_get_collection"
    "_controller" => "api_platform.action.placeholder"
    "_format" => null
    "_stateless" => true
    "_api_resource_class" => "App\Entity\B2b\Workshop"
    "_api_operation_name" => "_api_/b2b/workshops{._format}_get_collection"
  ]
  "request_uri" => "https://backoffice.moncoachbrico.org/api/b2b/workshops?coach.id=237588112&date%5Bafter%5D=2025-12-23&date%5Bbefore%5D=2026-01-23&isDeleted=0"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "mcb_api_prod"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "moncoachbrico_db_prod"
    "serverVersion" => "10.4.33-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.id_slack AS id_slack_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.password AS password_6, t0.profile_picture AS profile_picture_7 FROM user t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "emmanuel@moncoachbrico.com"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#1406
    -user: App\Entity\User {#1363 …}
    -roleNames: [
      "ROLE_ADMIN"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NDA0NzcyNzksImV4cCI6MzYxNzQwNDc3Mjc5LCJyb2xlcyI6WyJST0xFX0FETUlOIl0sInVzZXJuYW1lIjoiZW1tYW51ZWxAbW9uY29hY2hicmljby5jb20iLCJpcmkiOiIvYXBpL2FkbWluL3VzZXJzLzIxIn0.GIJhdV0eHjsDkDbWCZ4W6MuyoVfwTZmfxzZbsD_seogx5udQ8tbmBKdTFIiA-G9e74-5nMq8uBqLGmVJgHqPjr-wpXYmchKTtrECr1wqQ__z0Tjf6yYK0M-DUFGLvchR3G70x1kU570WTk0lPvw3wzDmBgN349uXb4QEYUbruDBtalAiLhFJAH3rw515OG3Pr7tEtyYfSulVhgPvQX6F9Gn_bdDWxcC-XRob0P7-BgKmWVWkVuyFCSjZnq10BTtBbp7yheElc1_n-YTxMs7CgYZlvo10tpqBeZzSyut3s3iEo2TkFRR8npbu9287CjhpMYibhV4V_oPXBiwkxNdDMA"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.comment AS comment_2, b0_.participant AS participant_3, b0_.status AS status_4, b0_.created_at AS created_at_5, b0_.created_by AS created_by_6, b0_.updated_at AS updated_at_7, b0_.updated_by AS updated_by_8, b0_.place AS place_9, b0_.is_deleted AS is_deleted_10, b0_.duration AS duration_11, b0_.is_credit_calculated AS is_credit_calculated_12, b0_.is_holiday_or_sunday AS is_holiday_or_sunday_13, b0_.total_credit AS total_credit_14, b0_.is_location_calculated AS is_location_calculated_15, b0_.distance AS distance_16, b0_.comment_credit_traitement AS comment_credit_traitement_17, b0_.is_unique AS is_unique_18, b0_.nbr_day AS nbr_day_19, b0_.nbr_half_day AS nbr_half_day_20, b0_.nbr_forfait AS nbr_forfait_21, c1_.id AS id_22, c1_.comment AS comment_23, c1_.title AS title_24, c1_.lastname AS lastname_25, c1_.firstname AS firstname_26, c1_.email AS email_27, c1_.landline AS landline_28, c1_.cell_phone AS cell_phone_29, c1_.hourly_rate AS hourly_rate_30, c1_.is_active AS is_active_31, c1_.is_employee AS is_employee_32, c1_.latitude AS latitude_33, c1_.longitude AS longitude_34, c1_.address AS address_35, c1_.street_location AS street_location_36, c1_.secteur AS secteur_37, c1_.address_line AS address_line_38, c1_.address_zip AS address_zip_39, c1_.address_city AS address_city_40, c1_.update_at AS update_at_41, c1_.refresh_geo AS refresh_geo_42, b2_.id AS id_43, b2_.ogust_id AS ogust_id_44, b2_.username AS username_45, b2_.password AS password_46, b2_.name AS name_47, b2_.address1 AS address1_48, b2_.address2 AS address2_49, b2_.postal_code AS postal_code_50, b2_.city AS city_51, b2_.latitude AS latitude_52, b2_.longitude AS longitude_53, b3_.id AS id_54, b3_.name AS name_55, b3_.is_idf AS is_idf_56, b4_.id AS id_57, b4_.nature AS nature_58, b4_.name AS name_59, b4_.duration AS duration_60, b5_.id AS id_61, b5_.created_at AS created_at_62, b5_.created_by AS created_by_63, b5_.comment AS comment_64, b6_.id AS id_65, b6_.hourly_rate AS hourly_rate_66, b6_.is_variable_hourly_rate AS is_variable_hourly_rate_67, b6_.status AS status_68, b6_.created_at AS created_at_69, b6_.is_deleted AS is_deleted_70, b6_.created_by AS created_by_71, c7_.id AS id_72, c7_.comment AS comment_73, c7_.title AS title_74, c7_.lastname AS lastname_75, c7_.firstname AS firstname_76, c7_.email AS email_77, c7_.landline AS landline_78, c7_.cell_phone AS cell_phone_79, c7_.hourly_rate AS hourly_rate_80, c7_.is_active AS is_active_81, c7_.is_employee AS is_employee_82, c7_.latitude AS latitude_83, c7_.longitude AS longitude_84, c7_.address AS address_85, c7_.street_location AS street_location_86, c7_.secteur AS secteur_87, c7_.address_line AS address_line_88, c7_.address_zip AS address_zip_89, c7_.address_city AS address_city_90, c7_.update_at AS update_at_91, c7_.refresh_geo AS refresh_geo_92, b8_.id AS id_93, b8_.date AS date_94, b8_.comment AS comment_95, b8_.participant AS participant_96, b8_.status AS status_97, b8_.created_at AS created_at_98, b8_.created_by AS created_by_99, b8_.updated_at AS updated_at_100, b8_.updated_by AS updated_by_101, b8_.place AS place_102, b8_.is_deleted AS is_deleted_103, b8_.duration AS duration_104, b8_.is_credit_calculated AS is_credit_calculated_105, b8_.is_holiday_or_sunday AS is_holiday_or_sunday_106, b8_.total_credit AS total_credit_107, b8_.is_location_calculated AS is_location_calculated_108, b8_.distance AS distance_109, b8_.comment_credit_traitement AS comment_credit_traitement_110, b8_.is_unique AS is_unique_111, b8_.nbr_day AS nbr_day_112, b8_.nbr_half_day AS nbr_half_day_113, b8_.nbr_forfait AS nbr_forfait_114, b9_.id AS id_115, b9_.date AS date_116, b9_.comment AS comment_117, b9_.participant AS participant_118, b9_.status AS status_119, b9_.created_at AS created_at_120, b9_.created_by AS created_by_121, b9_.updated_at AS updated_at_122, b9_.updated_by AS updated_by_123, b9_.place AS place_124, b9_.is_deleted AS is_deleted_125, b9_.duration AS duration_126, b9_.is_credit_calculated AS is_credit_calculated_127, b9_.is_holiday_or_sunday AS is_holiday_or_sunday_128, b9_.total_credit AS total_credit_129, b9_.is_location_calculated AS is_location_calculated_130, b9_.distance AS distance_131, b9_.comment_credit_traitement AS comment_credit_traitement_132, b9_.is_unique AS is_unique_133, b9_.nbr_day AS nbr_day_134, b9_.nbr_half_day AS nbr_half_day_135, b9_.nbr_forfait AS nbr_forfait_136, b10_.id AS id_137, b10_.status AS status_138, b10_.participants_number AS participants_number_139, b10_.intervention_date AS intervention_date_140, b10_.room_quality AS room_quality_141, b10_.meeting_staff AS meeting_staff_142, b10_.customer_support AS customer_support_143, b10_.customer_protective_equipment AS customer_protective_equipment_144, b10_.coach_protective_equipment AS coach_protective_equipment_145, b10_.cleaning AS cleaning_146, b10_.shopping_list AS shopping_list_147, b10_.reception_quality AS reception_quality_148, b10_.pouch AS pouch_149, b10_.post AS post_150, b10_.partnership AS partnership_151, b10_.note AS note_152, b10_.mcb_comment AS mcb_comment_153, b10_.b2c_proposal AS b2c_proposal_154, b10_.link AS link_155, b0_.coach AS coach_156, b0_.shop AS shop_157, b0_.code49 AS code49_158, b0_.parent_workshop_id AS parent_workshop_id_159, b0_.contract_id AS contract_id_160, b0_.accounting_id AS accounting_id_161, b2_.brand AS brand_162, b2_.class_price AS class_price_163, b2_.user_id AS user_id_164, b2_.area_id AS area_id_165, b3_.user_id AS user_id_166, b5_.workshop AS workshop_167, b6_.workshop AS workshop_168, b6_.coach AS coach_169, b8_.coach AS coach_170, b8_.shop AS shop_171, b8_.code49 AS code49_172, b8_.parent_workshop_id AS parent_workshop_id_173, b8_.contract_id AS contract_id_174, b8_.accounting_id AS accounting_id_175, b9_.coach AS coach_176, b9_.shop AS shop_177, b9_.code49 AS code49_178, b9_.parent_workshop_id AS parent_workshop_id_179, b9_.contract_id AS contract_id_180, b9_.accounting_id AS accounting_id_181, b10_.workshop_id AS workshop_id_182 FROM b2b_workshop b0_ INNER JOIN coach c1_ ON b0_.coach = c1_.id INNER JOIN b2b_shop b2_ ON b0_.shop = b2_.id LEFT JOIN b2b_area b3_ ON b2_.area_id = b3_.id INNER JOIN b2b_code49 b4_ ON b0_.code49 = b4_.id LEFT JOIN b2b_comment b5_ ON b0_.id = b5_.workshop LEFT JOIN b2b_proposal b6_ ON b0_.id = b6_.workshop LEFT JOIN coach c7_ ON b6_.coach = c7_.id LEFT JOIN b2b_workshop b8_ ON b0_.parent_workshop_id = b8_.id LEFT JOIN b2b_workshop b9_ ON b0_.id = b9_.parent_workshop_id LEFT JOIN b2b_audit b10_ ON b0_.id = b10_.workshop_id WHERE b0_.id IN (SELECT b11_.id FROM b2b_workshop b11_ INNER JOIN coach c12_ ON b11_.coach = c12_.id WHERE b11_.is_deleted = ? AND b11_.date <= ? AND b11_.date >= ? AND c12_.id = ?) ORDER BY b0_.date ASC"
  "params" => [
    1 => 0
    2 => "2026-01-23 00:00:00"
    3 => "2025-12-23 00:00:00"
    4 => 237588112
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 1
  ]
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::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" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

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

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::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" => "Container3xbGmdb\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\ValidateListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\WriteListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\SerializeListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "ApiPlatform\Symfony\EventListener\RespondListener::onKernelView"
]

[
  "event" => "kernel.view"
  "listener" => "Symfony\Bridge\Twig\EventListener\TemplateAttributeListener::onKernelView"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "moncoachbrico_db_prod"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Mercure\EventSubscriber\SetCookieSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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