Symfony Profiler

[
  "route" => "network"
  "route_parameters" => [
    "_route" => "network"
    "_controller" => "App\Controller\Front\NetworkController::network"
  ]
  "request_uri" => "https://eurocamiones.staff.digital/red"
  "method" => "GET"
]

[
  "firewall_name" => "adviser"
  "authenticators" => 2
]

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

[
  "firewall_name" => "adviser"
  "authenticator" => "App\Security\AdminAuthenticator"
]

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

[
  "event" => "kernel.request"
  "listener" => "Stof\DoctrineExtensionsBundle\EventListener\LocaleListener::onKernelRequest"
]

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

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

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

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

[
  "firewall_name" => "adviser"
  "authenticator" => "App\Security\AdminAuthenticator"
]

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

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

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

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

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

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

[
  "firewall_name" => "adviser"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "adviser"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

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

[
  "sql" => "SELECT t0.address AS address_1, t0.phone AS phone_2, t0.email AS email_3, t0.service_address AS service_address_4, t0.service_phone AS service_phone_5, t0.service_email AS service_email_6, t0.technical_assistance_address AS technical_assistance_address_7, t0.technical_assistance_phone AS technical_assistance_phone_8, t0.technical_assistance_email AS technical_assistance_email_9, t0.shop_active AS shop_active_10, t0.shop_button_text AS shop_button_text_11, t0.shop_link AS shop_link_12, t0.shop_target AS shop_target_13, t0.roulette_active AS roulette_active_14, t0.roulette_text AS roulette_text_15, t0.roulette_image AS roulette_image_16, t0.roulette_banner_home AS roulette_banner_home_17, t0.header_logo_color AS header_logo_color_18, t0.header_logo_white AS header_logo_white_19, t0.footer_logo AS footer_logo_20, t0.sent_image AS sent_image_21, t0.sent_title AS sent_title_22, t0.sent_text AS sent_text_23, t0.sent_button_home_text AS sent_button_home_text_24, t0.error_image AS error_image_25, t0.error_title AS error_title_26, t0.error_text AS error_text_27, t0.error_button_home_text AS error_button_home_text_28, t0.error_404_image AS error_404_image_29, t0.error_404_title AS error_404_title_30, t0.error_404_text AS error_404_text_31, t0.error_404_button_home_text AS error_404_button_home_text_32, t0.social_whatsapp_show AS social_whatsapp_show_33, t0.social_whatsapp_number AS social_whatsapp_number_34, t0.social_whatsapp_message AS social_whatsapp_message_35, t0.social_facebook_show AS social_facebook_show_36, t0.social_facebook_link AS social_facebook_link_37, t0.social_linkedin_show AS social_linkedin_show_38, t0.social_linkedin_link AS social_linkedin_link_39, t0.social_youtube_show AS social_youtube_show_40, t0.social_youtube_link AS social_youtube_link_41, t0.social_blog_show AS social_blog_show_42, t0.social_blog_link AS social_blog_link_43, t0.social_blog_categories AS social_blog_categories_44, t0.social_blog_posts AS social_blog_posts_45, t0.seo_indexing AS seo_indexing_46, t0.seo_favicon AS seo_favicon_47, t0.seo_title AS seo_title_48, t0.seo_description AS seo_description_49, t0.scripts_meta AS scripts_meta_50, t0.scripts_header AS scripts_header_51, t0.scripts_body AS scripts_body_52, t0.scripts_footer AS scripts_footer_53, t0.captcha_show AS captcha_show_54, t0.captcha_site AS captcha_site_55, t0.captcha_secret AS captcha_secret_56, t0.id AS id_57, t0.created_at AS created_at_58, t0.modified_at AS modified_at_59, t0.created_user AS created_user_60, t0.modified_user AS modified_user_61 FROM info t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.document_types AS document_types_1, t0.contact_title AS contact_title_2, t0.contact_text AS contact_text_3, t0.contact_types AS contact_types_4, t0.contact_receiver AS contact_receiver_5, t0.technical_assistance_title AS technical_assistance_title_6, t0.technical_assistance_receiver AS technical_assistance_receiver_7, t0.promotion_receiver AS promotion_receiver_8, t0.application_receiver AS application_receiver_9, t0.truck_quotation_receiver AS truck_quotation_receiver_10, t0.service_quotation_title AS service_quotation_title_11, t0.service_quotation_receiver AS service_quotation_receiver_12, t0.claim_p1_title AS claim_p1_title_13, t0.claim_p2_title AS claim_p2_title_14, t0.claim_goods AS claim_goods_15, t0.claim_p3_title AS claim_p3_title_16, t0.claim_types AS claim_types_17, t0.claim_p4_title AS claim_p4_title_18, t0.claim_response_days AS claim_response_days_19, t0.claim_description AS claim_description_20, t0.claim_notes AS claim_notes_21, t0.claim_receiver AS claim_receiver_22, t0.id AS id_23, t0.created_at AS created_at_24, t0.modified_at AS modified_at_25, t0.created_user AS created_user_26, t0.modified_user AS modified_user_27 FROM forms t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT b0_.title AS title_0, b0_.open_external_link AS open_external_link_1, b0_.external_link AS external_link_2, b0_.banner_text AS banner_text_3, b0_.banner_image AS banner_image_4, b0_.banner_button_show AS banner_button_show_5, b0_.banner_button_text AS banner_button_text_6, b0_.banner_button_link AS banner_button_link_7, b0_.banner_button_target AS banner_button_target_8, b0_.detail_show AS detail_show_9, b0_.detail_title AS detail_title_10, b0_.detail_text AS detail_text_11, b0_.features_show AS features_show_12, b0_.features_items AS features_items_13, b0_.active AS active_14, b0_.position AS position_15, b0_.slug AS slug_16, b0_.id AS id_17, b0_.created_at AS created_at_18, b0_.modified_at AS modified_at_19, b0_.created_user AS created_user_20, b0_.modified_user AS modified_user_21 FROM brand b0_ WHERE b0_.active = 1 ORDER BY b0_.position ASC"
]

[
  "sql" => "SELECT s0_.title AS title_0, s0_.image AS image_1, s0_.banner_image AS banner_image_2, s0_.banner_title AS banner_title_3, s0_.banner_text AS banner_text_4, s0_.detail_show AS detail_show_5, s0_.detail_title AS detail_title_6, s0_.detail_text AS detail_text_7, s0_.benefits_show AS benefits_show_8, s0_.benefits_title AS benefits_title_9, s0_.benefits_text AS benefits_text_10, s0_.benefits_image AS benefits_image_11, s0_.active AS active_12, s0_.in_header AS in_header_13, s0_.position AS position_14, s0_.slug AS slug_15, s0_.id AS id_16, s0_.created_at AS created_at_17, s0_.modified_at AS modified_at_18, s0_.created_user AS created_user_19, s0_.modified_user AS modified_user_20 FROM service s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC"
]

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

[
  "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"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::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 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_ INNER JOIN city c1_ ON d0_.id = c1_.department_id INNER JOIN establishment e2_ ON c1_.id = e2_.city_id WHERE d0_.active = 1 AND c1_.active = 1 AND e2_.active = 1 ORDER BY d0_.position ASC, d0_.title ASC"
]

[
  "sql" => "SELECT e0_.title AS title_0, e0_.description AS description_1, e0_.icon AS icon_2, e0_.active AS active_3, e0_.show_in_form_quotation_services AS show_in_form_quotation_services_4, e0_.position AS position_5, e0_.slug AS slug_6, e0_.id AS id_7, e0_.created_at AS created_at_8, e0_.modified_at AS modified_at_9, e0_.created_user AS created_user_10, e0_.modified_user AS modified_user_11 FROM establishment_category e0_ WHERE e0_.active = 1 ORDER BY e0_.position ASC"
]

[
  "sql" => "SELECT e0_.title AS title_0, e0_.address AS address_1, e0_.contacts AS contacts_2, e0_.link AS link_3, e0_.show_in_man AS show_in_man_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_.city_id AS city_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 ORDER BY e1_.position ASC"
]

[
  "sql" => "SELECT t0.title AS title_1, t0.text_1 AS text_1_2, t0.text_2 AS text_2_3, t0.text_3 AS text_3_4, t0.no_results AS no_results_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.created_user AS created_user_9, t0.modified_user AS modified_user_10 FROM network t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.indexing AS indexing_1, t0.path AS path_2, t0.title AS title_3, t0.description AS description_4, t0.social_title AS social_title_5, t0.social_description AS social_description_6, t0.social_image AS social_image_7, t0.scripts_meta AS scripts_meta_8, t0.scripts_header AS scripts_header_9, t0.scripts_body AS scripts_body_10, t0.scripts_footer AS scripts_footer_11, t0.id AS id_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.created_user AS created_user_15, t0.modified_user AS modified_user_16 FROM seo t0 WHERE t0.path = ? LIMIT 1"
  "params" => [
    1 => "/red"
  ]
  "types" => [
    1 => 2
  ]
]

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

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

[
  "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 = 'staff_eurocamiones' 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 = 'staff_eurocamiones' /*!50116 AND c.CONSTRAINT_SCHEMA = 'staff_eurocamiones' */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 = 'staff_eurocamiones' 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.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]

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

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

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

[
  "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\Security\Http\Firewall\ContextListener::onKernelResponse"
]

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

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