Symfony Profiler

[
  "route" => "generate_pdf"
  "route_parameters" => [
    "_route" => "generate_pdf"
    "_controller" => "App\Controller\PDFController::generatePDF"
    "id" => "3248"
  ]
  "request_uri" => "https://afpma-webapp.e-conception.fr/generate-pdf/3248"
  "method" => "GET"
]

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

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

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

[
  "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" => "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" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "afpma-webapp"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "afpma-webapp"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.code AS code_4, t0.cut_in_blocks AS cut_in_blocks_5, t0.new AS new_6, t0.customizable AS customizable_7, t0.objectives AS objectives_8, t0.complementary_objectives AS complementary_objectives_9, t0.pedagogic_content AS pedagogic_content_10, t0.pluses AS pluses_11, t0.concerned_persons AS concerned_persons_12, t0.prerequisites AS prerequisites_13, t0.price AS price_14, t0.time AS time_15, t0.date AS date_16, t0.place AS place_17, t0.terms_of_access AS terms_of_access_18, t0.alternating_rythm AS alternating_rythm_19, t0.teaching_methods AS teaching_methods_20, t0.teaching_means AS teaching_means_21, t0.education_level AS education_level_22, t0.training_order AS training_order_23, t0.certification_name AS certification_name_24, t0.assessment_methods AS assessment_methods_25, t0.target_functions AS target_functions_26, t0.continuing_studies AS continuing_studies_27, t0.disabled_accessibility AS disabled_accessibility_28, t0.testimonials AS testimonials_29, t0.accessibility_text AS accessibility_text_30, t0.creation_date AS creation_date_31, t0.edit_date AS edit_date_32, t0.logo_display AS logo_display_33, t0.which_public AS which_public_34, t0.published AS published_35, t0.is_fiche AS is_fiche_36, t0.slug AS slug_37, t0.fiche_title AS fiche_title_38, t0.trainee_or_enterprise AS trainee_or_enterprise_39, t0.validity_date AS validity_date_40, t0.link_video AS link_video_41, t0.rncp_or_rs AS rncp_or_rs_42, t0.days AS days_43, t0.hours AS hours_44, t0.company_missions AS company_missions_45, t0.validity_date_rncp AS validity_date_rncp_46, t0.reset_date AS reset_date_47, t0.type_id AS type_id_48, t0.certification_type_id AS certification_type_id_49, t0.owner_id AS owner_id_50, t0.training_place_id AS training_place_id_51, t0.education_level_name_id AS education_level_name_id_52, t0.public_type_id AS public_type_id_53 FROM trainings t0 WHERE t0.id = ?"
  "params" => [
    1 => "3248"
  ]
  "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" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::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 t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.media AS media_4, t0.description AS description_5, t0.media_url AS media_url_6 FROM domain t0 INNER JOIN trainings_domain ON t0.id = trainings_domain.domain_id WHERE trainings_domain.trainings_id = ?"
  "params" => [
    1 => 3248
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.reset_password AS reset_password_8 FROM user t0 INNER JOIN commercials_trainings ON t0.id = commercials_trainings.user_id WHERE commercials_trainings.trainings_id = ?"
  "params" => [
    1 => 3248
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM training_place t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM device_and_training t0 INNER JOIN trainings_device_and_training ON t0.id = trainings_device_and_training.device_and_training_id WHERE trainings_device_and_training.trainings_id = ?"
  "params" => [
    1 => 3248
  ]
  "types" => [
    1 => 1
  ]
]

[
  "value" => true
]

[
  "value" => 10
]

[
  "value" => 30
]

[
  "value" => 10
]

[
  "value" => 10
]

[
  "value" => "A4"
]

[
  "value" => true
]

[
  "value" => """
    <img style="padding-top:50px;" src="https://afpma-webapp.e-conception.fr/assets/images/custom/footer.png" alt="AFPMA" height="100">\n
    <div style="font-size: 20px; text-align: center; margin-top: -28px; color: #fff">\n
        <span id='page'></span> sur <span id='topage'></span>\n
    </div>\n
    \n
    <script type="text/javascript">\n
        var vars={};\n
        var x=window.location.search.substring(1).split('&');\n
        for (var i in x) {\n
            var z=x[i].split('=',2);\n
            vars[z[0]] = unescape(z[1]);\n
        }\n
        document.getElementById('page').innerHTML = vars.page;\n
        document.getElementById('topage').innerHTML = vars.topage;\n
    </script>
    """
]

[
  "command" => "wkhtmltopdf --lowquality --margin-bottom '30' --margin-left '10' --margin-right '10' --margin-top '10' --page-size 'A4' --enable-javascript --enable-local-file-access --footer-html '/tmp/knp_snappy67241065485cd5.79126830.html' '/tmp/knp_snappy672410654854c0.72434127.html' '/tmp/knp_snappy67241065485976.65702309.pdf'"
  "env" => null
  "timeout" => null
]

[
  "command" => "wkhtmltopdf --lowquality --margin-bottom '30' --margin-left '10' --margin-right '10' --margin-top '10' --page-size 'A4' --enable-javascript --enable-local-file-access --footer-html '/tmp/knp_snappy67241065485cd5.79126830.html' '/tmp/knp_snappy672410654854c0.72434127.html' '/tmp/knp_snappy67241065485976.65702309.pdf'"
  "stdout" => ""
  "stderr" => """
    Loading pages (1/6)\n
    [>                                                           ] 0%\r[======>                                                     ] 10%\r[=====================>                                      ] 36%\r[=========================>                                  ] 43%\r[===========================>                                ] 46%\r[============================================================] 100%\rCounting pages (2/6)                                               \n
    [============================================================] Object 1 of 1\rResolving links (4/6)                                                       \n
    [============================================================] Object 1 of 1\rLoading headers and footers (5/6)                                           \n
    [=>                                                          ] 3%\r[===>                                                        ] 6%\r[======>                                                     ] 10%\r[=============>                                              ] 23%\r[=====================>                                      ] 36%\r[===============================>                            ] 53%\r[=======================================>                    ] 66%\r[=================================================>          ] 83%\r[============================================================] 100%\rPrinting pages (6/6)                                               \n
    [>                                                           ] Preparing\r[===================>                                        ] Page 1 of 3\r[=======================================>                    ] Page 2 of 3\r[============================================================] Page 3 of 3\rDone                                                                      \n
    """
]

[
  "sql" => "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"
]

[
  "sql" => "SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'"
]

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

[
  "sql" => "SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'afpma-webapp' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC"
]

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

[
  "sql" => "SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'afpma-webapp' /*!50116 AND c.CONSTRAINT_SCHEMA = 'afpma-webapp' */ORDER BY k.ORDINAL_POSITION"
]

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

[
  "sql" => "SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'afpma-webapp' ORDER BY SEQ_IN_INDEX ASC"
]

[
  "sql" => """
    SELECT t.ENGINE,\n
           t.AUTO_INCREMENT,\n
           t.TABLE_COMMENT,\n
           t.CREATE_OPTIONS,\n
           t.TABLE_COLLATION,\n
           ccsa.CHARACTER_SET_NAME\n
    FROM information_schema.TABLES t\n
        INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa\n
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION\n
    WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
    """
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

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

[
  "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\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" => "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::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.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::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"
]