Symfony Profiler

[
  "route" => "api_all_generated_courses"
  "route_parameters" => [
    "_route" => "api_all_generated_courses"
    "_controller" => "App\Controller\ApiAllCoursesController::getAllGeneratedCourses"
  ]
  "request_uri" => "https://api.solidcv.com/api/protected/courses/all-generated?page=1&perPage=12"
  "method" => "GET"
]

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

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

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "solidcv_prod"
    "serverVersion" => "8"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.token_hash AS token_hash_1, u0_.created_at AS created_at_2, u0_.expires_at AS expires_at_3, u0_.last_used_at AS last_used_at_4, u0_.revoked_at AS revoked_at_5, u0_.user_agent_hash AS user_agent_hash_6, u0_.ip_hash AS ip_hash_7, u0_.user_id AS user_id_8 FROM user_auth_token u0_ WHERE u0_.token_hash = ? AND u0_.revoked_at IS NULL AND u0_.expires_at > ?"
  "params" => [
    1 => "828d4ca222a1e4cf5abd3d4911a39836b495af4d2febb7ad0889d67f64a45264"
    2 => 1785396175
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.country AS country_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone_number AS phone_number_7, t0.biography AS biography_8, t0.profile_picture AS profile_picture_9, t0.cv AS cv_10, t0.linkedin AS linkedin_11, t0.password AS password_12, t0.api_token AS api_token_13, t0.ethereum_address AS ethereum_address_14, t0.ethereum_private_key AS ethereum_private_key_15, t0.is_email_verified AS is_email_verified_16, t0.resend_verification_email_count AS resend_verification_email_count_17, t0.last_resend_verification_email_at AS last_resend_verification_email_at_18, t0.reset_password_request_count AS reset_password_request_count_19, t0.last_reset_password_request_at AS last_reset_password_request_at_20, t0.is_first_configuration_done AS is_first_configuration_done_21, t0.recieve_weekly_recommandation_emails AS recieve_weekly_recommandation_emails_22, t0.main_career_goal AS main_career_goal_23, t0.language AS language_24, t0.premium_subscription_date AS premium_subscription_date_25, t0.billing_plan AS billing_plan_26, t0.premium_subscription_period_started_at AS premium_subscription_period_started_at_27, t0.premium_subscription_period_ends_at AS premium_subscription_period_ends_at_28, t0.paypal_subscription_id AS paypal_subscription_id_29, t0.paypal_subscription_status AS paypal_subscription_status_30, t0.stripe_customer_id AS stripe_customer_id_31, t0.stripe_subscription_id AS stripe_subscription_id_32, t0.stripe_subscription_status AS stripe_subscription_status_33, t0.show_email_on_profile AS show_email_on_profile_34, t0.show_phone_on_profile AS show_phone_on_profile_35, t0.career_advice_outdated AS career_advice_outdated_36, t0.is_external_candidate_placeholder AS is_external_candidate_placeholder_37, t0.external_candidate_activated_at AS external_candidate_activated_at_38, t0.account_provisioning_source AS account_provisioning_source_39, t40.id AS id_41, t40.career_summary AS career_summary_42, t40.key_recommendations AS key_recommendations_43, t40.skill_development AS skill_development_44, t40.next_steps AS next_steps_45, t40.recommended_resources AS recommended_resources_46, t40.created_at AS created_at_47, t40.user_id AS user_id_48 FROM `user` t0 LEFT JOIN career_advice t40 ON t40.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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\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" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#1610
    -user: Proxies\__CG__\App\Entity\User {#50 …}
    -roleNames: [
      "ROLE_ADMIN"
      "ROLE_USER"
    ]
    -attributes: []
    -firewallName: "main"
  }
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

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

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

[
  "authenticator" => "App\Security\ApiKeyAuthenticator"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::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" => "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.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\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "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" => "Container3PjW3rP\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM course c0_ LEFT JOIN weekly_recommandation w1_ ON c0_.weekly_recommandation_id = w1_.id LEFT JOIN `user` u2_ ON w1_.user_id = u2_.id LEFT JOIN company_employee_future_skill c3_ ON c0_.future_skill_id = c3_.id LEFT JOIN company_employee c4_ ON c3_.company_employee_id = c4_.id LEFT JOIN `user` u5_ ON c4_.user_id = u5_.id LEFT JOIN user_purchased_course u6_ ON (u6_.course_id = c0_.id) LEFT JOIN `user` u7_ ON u6_.user_id = u7_.id WHERE (((c0_.is_progressive = 0 AND c0_.course IS NOT NULL) OR (c0_.is_progressive = 1 AND c0_.structure_generated_at IS NOT NULL AND EXISTS (SELECT c8_.id FROM course_chapter c8_ WHERE c8_.course_id = c0_.id) AND NOT EXISTS (SELECT c9_.id FROM course_chapter c9_ WHERE c9_.course_id = c0_.id AND c9_.status <> ?)))) AND c0_.company_document_id IS NULL AND c0_.publicly_shared = 1"
  "params" => [
    1 => "ready"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.level AS level_2, c0_.description AS description_3, c0_.course AS course_4, c0_.is_completed AS is_completed_5, c0_.completed_at AS completed_at_6, c0_.level_code AS level_code_7, c0_.is_progressive AS is_progressive_8, c0_.structure_generated_at AS structure_generated_at_9, c0_.language AS language_10, c0_.subject AS subject_11, c0_.rating_average AS rating_average_12, c0_.rating_count AS rating_count_13, c0_.public_view_count AS public_view_count_14, c0_.publicly_shared AS publicly_shared_15, CASE WHEN w1_.id IS NOT NULL THEN 'weekly' WHEN c2_.id IS NOT NULL THEN 'roadmap' WHEN u3_.id IS NOT NULL THEN 'purchased' ELSE 'unknown' END AS sclr_16, COALESCE(u4_.id, u5_.id, u6_.id) AS sclr_17, COALESCE(u4_.email, u5_.email, u6_.email) AS sclr_18, COALESCE(u4_.first_name, u5_.first_name, u6_.first_name) AS sclr_19, COALESCE(u4_.last_name, u5_.last_name, u6_.last_name) AS sclr_20, c0_.weekly_recommandation_id AS weekly_recommandation_id_21, c0_.future_skill_id AS future_skill_id_22, c0_.company_document_id AS company_document_id_23 FROM course c0_ LEFT JOIN weekly_recommandation w1_ ON c0_.weekly_recommandation_id = w1_.id LEFT JOIN `user` u4_ ON w1_.user_id = u4_.id LEFT JOIN company_employee_future_skill c2_ ON c0_.future_skill_id = c2_.id LEFT JOIN company_employee c7_ ON c2_.company_employee_id = c7_.id LEFT JOIN `user` u5_ ON c7_.user_id = u5_.id LEFT JOIN user_purchased_course u3_ ON (u3_.course_id = c0_.id) LEFT JOIN `user` u6_ ON u3_.user_id = u6_.id WHERE (((c0_.is_progressive = 0 AND c0_.course IS NOT NULL) OR (c0_.is_progressive = 1 AND c0_.structure_generated_at IS NOT NULL AND EXISTS (SELECT c8_.id FROM course_chapter c8_ WHERE c8_.course_id = c0_.id) AND NOT EXISTS (SELECT c9_.id FROM course_chapter c9_ WHERE c9_.course_id = c0_.id AND c9_.status <> ?)))) AND c0_.company_document_id IS NULL AND c0_.publicly_shared = 1 ORDER BY c0_.id DESC LIMIT 12"
  "params" => [
    1 => "ready"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "key" => "_security_main"
]

[
  "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\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

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

[
  "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\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"
]