Symfony Profiler

[
  "route" => "indexProfessionnalPackage"
  "route_parameters" => [
    "_route" => "indexProfessionnalPackage"
    "_controller" => "App\Controller\ProfessionnalController::indexProfessionnalPackage"
    "id" => "2"
  ]
  "request_uri" => "https://www.zonedev.bookpresta.com/siteProfessionnal/listePackage/indexProfessionnalPackage/2"
  "method" => "GET"
]

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

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

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

[
  "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\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.request"
  "listener" => "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "dwe64"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "devBookpresta"
    "serverVersion" => "8.0.33"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name_compagny AS name_compagny_2, t0.birthday_compagny AS birthday_compagny_3, t0.adress_compagny AS adress_compagny_4, t0.postal_code_compagny AS postal_code_compagny_5, t0.city_compagny AS city_compagny_6, t0.country_compagny AS country_compagny_7, t0.description_compagny AS description_compagny_8, t0.identification_number_compagny AS identification_number_compagny_9, t0.first_price AS first_price_10, t0.rcs AS rcs_11, t0.pourcentage_fees AS pourcentage_fees_12, t0.legal_type AS legal_type_13, t0.amount_limit_min_deposit AS amount_limit_min_deposit_14, t0.pourcentage_deposit AS pourcentage_deposit_15, t0.accepted_deposit AS accepted_deposit_16, t0.user_id AS user_id_17, t0.domain_activity_id AS domain_activity_id_18, t0.picture_profil_compagny_id AS picture_profil_compagny_id_19, t0.job_id AS job_id_20, t0.department_compagny_id AS department_compagny_id_21 FROM compagny_info t0 WHERE t0.id = ?"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 1
  ]
]

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_ht AS price_ht_2, p0_.price_ttc AS price_ttc_3, p0_.description AS description_4, p0_.min_pers AS min_pers_5, p0_.max_pers AS max_pers_6, p0_.option_print_interval_person AS option_print_interval_person_7, p0_.ask_deposit AS ask_deposit_8, p0_.tax_id AS tax_id_9 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = ? ORDER BY p0_.price_ttc DESC LIMIT 12"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT count(p0_.id) AS sclr_0 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT MIN(p0_.price_ttc) AS sclr_0, MAX(p0_.price_ttc) AS sclr_1 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT MIN(p0_.min_pers) AS sclr_0, MAX(p0_.max_pers) AS sclr_1 FROM package_compagny p0_ INNER JOIN package_compagny_compagny_info p2_ ON p0_.id = p2_.package_compagny_id INNER JOIN compagny_info c1_ ON c1_.id = p2_.compagny_info_id WHERE c1_.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.name AS name_6, t0.firstname AS firstname_7, t0.birthday AS birthday_8, t0.adress AS adress_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.phone AS phone_13, t0.pseudonym AS pseudonym_14, t0.registration_date AS registration_date_15, t0.statut_id AS statut_id_16, t0.compagny_id AS compagny_id_17, t0.bank_id AS bank_id_18, t0.profil_picture_id AS profil_picture_id_19, t0.notation_id AS notation_id_20, t0.statistic_id AS statistic_id_21 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.number_clic AS number_clic_2, t0.number_contact AS number_contact_3, t0.invoiced_monthly_turnover AS invoiced_monthly_turnover_4, t0.monthly_turnover_collected AS monthly_turnover_collected_5, t0.invoiced_quarterly_turnover AS invoiced_quarterly_turnover_6, t0.quarterly_turnover_collected AS quarterly_turnover_collected_7, t0.invoiced_half_yearly_turnover AS invoiced_half_yearly_turnover_8, t0.half_yearly_turnover_collected AS half_yearly_turnover_collected_9, t0.annual_turnover_invoiced AS annual_turnover_invoiced_10, t0.annual_turnover_collected AS annual_turnover_collected_11, t0.monthly_commission_due AS monthly_commission_due_12, t0.monthly_commission_paid AS monthly_commission_paid_13, t0.quarterly_commission_due AS quarterly_commission_due_14, t0.quarterly_commission_paid AS quarterly_commission_paid_15, t0.semi_annual_commission_due AS semi_annual_commission_due_16, t0.semi_annual_commission_paid AS semi_annual_commission_paid_17, t0.annual_commission_due AS annual_commission_due_18, t0.annual_commission_paid AS annual_commission_paid_19, t0.monthly_commission_collected AS monthly_commission_collected_20, t0.quarterly_commission_collected AS quarterly_commission_collected_21, t0.semi_annual_commission_collected AS semi_annual_commission_collected_22, t0.annual_commission_collected AS annual_commission_collected_23, t0.monthly_commission_mango_pay_due AS monthly_commission_mango_pay_due_24, t0.quarterly_commission_mango_pay_due AS quarterly_commission_mango_pay_due_25, t0.semi_annual_commission_mango_pay_due AS semi_annual_commission_mango_pay_due_26, t0.annual_commission_mango_pay_due AS annual_commission_mango_pay_due_27, t0.monthly_commission_mango_pay_paid AS monthly_commission_mango_pay_paid_28, t0.quarterly_commission_mango_pay_paid AS quarterly_commission_mango_pay_paid_29, t0.semi_annual_commission_mango_pay_paid AS semi_annual_commission_mango_pay_paid_30, t0.annual_commission_mango_pay_paid AS annual_commission_mango_pay_paid_31, t0.monthly_profit AS monthly_profit_32, t0.quarterly_profit AS quarterly_profit_33, t0.semi_annual_profit AS semi_annual_profit_34, t0.annual_profit AS annual_profit_35, t0.profit_since_foundation AS profit_since_foundation_36, t0.amount_paid AS amount_paid_37, t0.amount_not_paid AS amount_not_paid_38, t0.monthly_refund AS monthly_refund_39, t0.quarterly_refund AS quarterly_refund_40, t0.semi_annual_refund AS semi_annual_refund_41, t0.annual_refund AS annual_refund_42 FROM statistic t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "UPDATE statistic SET number_clic = ? WHERE id = ?"
  "params" => [
    1 => 88
    2 => 3
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

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

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

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

[
  "sql" => "SELECT t0.id AS id_1, t0.gallery_title AS gallery_title_2, t0.date_creating AS date_creating_3, t0.gallery_description AS gallery_description_4, t0.select_header_slide AS select_header_slide_5, t0.user_property_id AS user_property_id_6 FROM gallery_photo t0 WHERE t0.user_property_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.global_note AS global_note_2, t0.number_notation AS number_notation_3, t0.total_notation AS total_notation_4 FROM notation t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.picture_profile AS picture_profile_2 FROM profil_picture t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.gallery_title AS gallery_title_2, t0.date_creating AS date_creating_3, t0.gallery_description AS gallery_description_4, t0.user_property_id AS user_property_id_5 FROM gallery_video t0 WHERE t0.user_property_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "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" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::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\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"
]