Symfony Profiler

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

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

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

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "staff_php2"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "staff_ud_trucks"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.source AS source_1, t0.destination AS destination_2, t0.permanent AS permanent_3, t0.count AS count_4, t0.last_accessed AS last_accessed_5, t0.id AS id_6 FROM redirects t0 WHERE t0.source = ? LIMIT 1"
  "params" => [
    1 => "/robots.txt"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::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" => "Stof\DoctrineExtensionsBundle\EventListener\LocaleListener::onKernelRequest"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\DoctrineTranslatableListener::onLateKernelRequest"
]

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

[
  "sql" => "SELECT t0.phone AS phone_1, t0.email AS email_2, t0.header_logo AS header_logo_3, t0.header_logo_spare_parts AS header_logo_spare_parts_4, t0.header_logo_services AS header_logo_services_5, t0.footer_logo AS footer_logo_6, t0.sent_image AS sent_image_7, t0.sent_title_1 AS sent_title_1_8, t0.sent_title_2 AS sent_title_2_9, t0.sent_text AS sent_text_10, t0.sent_button_home_text AS sent_button_home_text_11, t0.sent_button_models_text AS sent_button_models_text_12, t0.error_image AS error_image_13, t0.error_title_1 AS error_title_1_14, t0.error_title_2 AS error_title_2_15, t0.error_text AS error_text_16, t0.error_button_home_text AS error_button_home_text_17, t0.error_button_models_text AS error_button_models_text_18, t0.error_404_image AS error_404_image_19, t0.error_404_title_1 AS error_404_title_1_20, t0.error_404_title_2 AS error_404_title_2_21, t0.error_404_text AS error_404_text_22, t0.error_404_button_home_text AS error_404_button_home_text_23, t0.error_404_button_models_text AS error_404_button_models_text_24, t0.social_whatsapp_show AS social_whatsapp_show_25, t0.social_whatsapp_number AS social_whatsapp_number_26, t0.social_whatsapp_message AS social_whatsapp_message_27, t0.social_facebook_show AS social_facebook_show_28, t0.social_facebook_link AS social_facebook_link_29, t0.social_linkedin_show AS social_linkedin_show_30, t0.social_linkedin_link AS social_linkedin_link_31, t0.social_instagram_show AS social_instagram_show_32, t0.social_instagram_link AS social_instagram_link_33, t0.social_youtube_show AS social_youtube_show_34, t0.social_youtube_link AS social_youtube_link_35, t0.social_blog_show AS social_blog_show_36, t0.social_blog_link AS social_blog_link_37, t0.seo_indexing AS seo_indexing_38, t0.seo_favicon AS seo_favicon_39, t0.seo_title AS seo_title_40, t0.seo_description AS seo_description_41, t0.captcha_show AS captcha_show_42, t0.captcha_site AS captcha_site_43, t0.captcha_secret AS captcha_secret_44, t0.scripts_meta AS scripts_meta_45, t0.scripts_header AS scripts_header_46, t0.scripts_body AS scripts_body_47, t0.scripts_footer AS scripts_footer_48, t0.id AS id_49, t0.created_at AS created_at_50, t0.modified_at AS modified_at_51, t0.created_user AS created_user_52, t0.modified_user AS modified_user_53 FROM info t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.contact_receiver AS contact_receiver_1, t0.quotation_receiver AS quotation_receiver_2, t0.service_title AS service_title_3, t0.service_receiver AS service_receiver_4, t0.truck_title AS truck_title_5, t0.truck_subjects AS truck_subjects_6, t0.truck_receiver AS truck_receiver_7, t0.after_sales_title AS after_sales_title_8, t0.after_sales_receiver AS after_sales_receiver_9, t0.claim_title AS claim_title_10, t0.claim_text AS claim_text_11, t0.claim_establishments_items AS claim_establishments_items_12, t0.claim_establishments_text AS claim_establishments_text_13, t0.claim_establishments_note AS claim_establishments_note_14, t0.claim_p1_title AS claim_p1_title_15, t0.claim_p2_title AS claim_p2_title_16, t0.claim_goods AS claim_goods_17, t0.claim_p3_title AS claim_p3_title_18, t0.claim_types AS claim_types_19, t0.claim_p4_title AS claim_p4_title_20, t0.claim_response_days AS claim_response_days_21, t0.claim_description AS claim_description_22, t0.claim_p5_title AS claim_p5_title_23, t0.claim_notes AS claim_notes_24, t0.claim_receiver AS claim_receiver_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.modified_at AS modified_at_28, t0.created_user AS created_user_29, t0.modified_user AS modified_user_30 FROM forms t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT d0_.title AS title_0, d0_.message AS message_1, d0_.active AS active_2, d0_.position AS position_3, d0_.slug AS slug_4, d0_.id AS id_5, d0_.created_at AS created_at_6, d0_.modified_at AS modified_at_7, d0_.created_user AS created_user_8, d0_.modified_user AS modified_user_9 FROM department d0_ WHERE d0_.active = 1 ORDER BY d0_.title ASC, d0_.position ASC"
]

[
  "sql" => "SELECT e0_.title AS title_0, e0_.address AS address_1, e0_.phones AS phones_2, e0_.emails AS emails_3, e0_.map_link AS map_link_4, e0_.active AS active_5, e0_.position AS position_6, e0_.slug AS slug_7, e0_.id AS id_8, e0_.created_at AS created_at_9, e0_.modified_at AS modified_at_10, e0_.created_user AS created_user_11, e0_.modified_user AS modified_user_12, e0_.department_id AS department_id_13, e0_.category_id AS category_id_14 FROM establishment e0_ INNER JOIN establishment_category e1_ ON e0_.category_id = e1_.id WHERE e0_.active = 1 AND e1_.active = 1 AND e1_.show_in_service_form = 1 ORDER BY e0_.position ASC"
]

[
  "sql" => "SELECT t0.title AS title_1, t0.icon AS icon_2, t0.active AS active_3, t0.show_in_service_form AS show_in_service_form_4, t0.position AS position_5, t0.slug AS slug_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.modified_at AS modified_at_9, t0.created_user AS created_user_10, t0.modified_user AS modified_user_11 FROM establishment_category t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT m0_.title AS title_0, m0_.crm_title AS crm_title_1, m0_.summary AS summary_2, m0_.logo AS logo_3, m0_.image AS image_4, m0_.banner_image AS banner_image_5, m0_.banner_text AS banner_text_6, m0_.detail_show AS detail_show_7, m0_.detail_title AS detail_title_8, m0_.detail_text AS detail_text_9, m0_.detail_image AS detail_image_10, m0_.specifications_show AS specifications_show_11, m0_.specifications_items AS specifications_items_12, m0_.attributes_show AS attributes_show_13, m0_.attributes_items AS attributes_items_14, m0_.gallery_show AS gallery_show_15, m0_.gallery_items AS gallery_items_16, m0_.versions_show AS versions_show_17, m0_.versions_title AS versions_title_18, m0_.form_image AS form_image_19, m0_.active AS active_20, m0_.position AS position_21, m0_.slug AS slug_22, m0_.id AS id_23, m0_.created_at AS created_at_24, m0_.modified_at AS modified_at_25, m0_.created_user AS created_user_26, m0_.modified_user AS modified_user_27 FROM model m0_ WHERE m0_.active = 1 ORDER BY m0_.position ASC"
]

[
  "sql" => "SELECT s0_.title AS title_0, s0_.image AS image_1, s0_.external_open AS external_open_2, s0_.external_link AS external_link_3, s0_.external_target AS external_target_4, s0_.banner_image AS banner_image_5, s0_.banner_text AS banner_text_6, s0_.detail_title AS detail_title_7, s0_.detail_text AS detail_text_8, s0_.contact_show AS contact_show_9, s0_.contact_title AS contact_title_10, s0_.contact_phone AS contact_phone_11, s0_.contact_email AS contact_email_12, s0_.contact_address AS contact_address_13, s0_.active AS active_14, s0_.in_header AS in_header_15, s0_.position AS position_16, s0_.slug AS slug_17, s0_.id AS id_18, s0_.created_at AS created_at_19, s0_.modified_at AS modified_at_20, s0_.created_user AS created_user_21, s0_.modified_user AS modified_user_22 FROM service s0_ WHERE s0_.active = 1 AND s0_.in_header = 1 ORDER BY s0_.position ASC"
]

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

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

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

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

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

[
  "event" => "kernel.controller"
  "listener" => "App\EventSubscriber\TwigEventSubscriber::onControllerEvent"
]

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

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

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

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

[
  "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 => "staff_ud_trucks"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "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 => "staff_ud_trucks"
  ]
  "types" => [
    1 => 2
  ]
]

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

[
  "sql" => """
        SELECT t.TABLE_NAME,\n
               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 WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
    """
  "params" => [
    1 => "staff_ud_trucks"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

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

[
  "sql" => """
    SELECT DISTINCT            k.CONSTRAINT_NAME,\n
                k.COLUMN_NAME,\n
                k.REFERENCED_TABLE_NAME,\n
                k.REFERENCED_COLUMN_NAME,\n
                k.ORDINAL_POSITION /*!50116,\n
                c.UPDATE_RULE,\n
                c.DELETE_RULE */\n
    FROM information_schema.key_column_usage k /*!50116\n
    INNER JOIN information_schema.referential_constraints c\n
    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\n
    AND c.TABLE_NAME = k.TABLE_NAME\n
    AND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION
    """
  "params" => [
    1 => "staff_ud_trucks"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT       COLUMN_NAME        AS field,\n
           COLUMN_TYPE        AS type,\n
           IS_NULLABLE        AS `null`,\n
           COLUMN_KEY         AS `key`,\n
           COLUMN_DEFAULT     AS `default`,\n
           EXTRA,\n
           COLUMN_COMMENT     AS comment,\n
           CHARACTER_SET_NAME AS characterset,\n
           COLLATION_NAME     AS collation\n
    FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY ORDINAL_POSITION
    """
  "params" => [
    1 => "staff_ud_trucks"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

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

[
  "sql" => """
    SELECT        NON_UNIQUE  AS Non_Unique,\n
            INDEX_NAME  AS Key_name,\n
            COLUMN_NAME AS Column_Name,\n
            SUB_PART    AS Sub_Part,\n
            INDEX_TYPE  AS Index_Type\n
    FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
    """
  "params" => [
    1 => "staff_ud_trucks"
    2 => "doctrine_migration_versions"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

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

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.exception"
  "listener" => "Zenstruck\RedirectBundle\EventListener\RedirectOnNotFoundListener::onKernelException"
]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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