Symfony Profiler

[
  "route" => "app_catalog"
  "route_parameters" => [
    "_route" => "app_catalog"
    "_controller" => "App\Controller\CatalogController::catalog"
  ]
  "request_uri" => "https://mail.adriabliss.com/mobilheime?kategorie=luxus-mobilheime"
  "method" => "GET"
]

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

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

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

[
  "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.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\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

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

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN category c2_ ON p0_.category_id = c2_.id LEFT JOIN product_product_feature p4_ ON p0_.id = p4_.product_id LEFT JOIN product_feature p3_ ON p3_.id = p4_.product_feature_id WHERE p0_.status = ? AND c2_.slug = ? ORDER BY p0_.is_featured DESC, p0_.created_at DESC"
  "params" => [
    1 => "active"
    2 => "luxus-mobilheime"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#636}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.slug AS slug_2, p0_.name AS name_3, p0_.short_description AS short_description_4, p0_.description AS description_5, p0_.model AS model_6, p0_.price AS price_7, p0_.old_price AS old_price_8, p0_.currency AS currency_9, p0_.status AS status_10, p0_.`condition` AS condition_11, p0_.availability AS availability_12, p0_.stock_quantity AS stock_quantity_13, p0_.main_image AS main_image_14, p0_.surface AS surface_15, p0_.length AS length_16, p0_.width AS width_17, p0_.height AS height_18, p0_.weight AS weight_19, p0_.bedrooms AS bedrooms_20, p0_.bathrooms AS bathrooms_21, p0_.sleeping_places AS sleeping_places_22, p0_.year AS year_23, p0_.location AS location_24, p0_.manufacturer AS manufacturer_25, p0_.mpn AS mpn_26, p0_.gtin AS gtin_27, p0_.google_product_category AS google_product_category_28, p0_.product_type AS product_type_29, p0_.item_group_id AS item_group_id_30, p0_.is_featured AS is_featured_31, p0_.views_count AS views_count_32, p0_.meta_title AS meta_title_33, p0_.meta_description AS meta_description_34, p0_.canonical_url AS canonical_url_35, p0_.robots AS robots_36, p0_.structured_data_enabled AS structured_data_enabled_37, p0_.created_at AS created_at_38, p0_.updated_at AS updated_at_39, b1_.id AS id_40, b1_.name AS name_41, b1_.slug AS slug_42, b1_.description AS description_43, b1_.logo AS logo_44, b1_.website AS website_45, b1_.country AS country_46, b1_.is_active AS is_active_47, b1_.display_order AS display_order_48, c2_.id AS id_49, c2_.name AS name_50, c2_.slug AS slug_51, c2_.description AS description_52, c2_.subtitle AS subtitle_53, c2_.image AS image_54, c2_.icon AS icon_55, c2_.display_order AS display_order_56, c2_.is_active AS is_active_57, p3_.id AS id_58, p3_.name AS name_59, p3_.code AS code_60, p3_.category AS category_61, p3_.icon AS icon_62, p3_.is_highlighted AS is_highlighted_63, p0_.brand_id AS brand_id_64, p0_.category_id AS category_id_65 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN category c2_ ON p0_.category_id = c2_.id LEFT JOIN product_product_feature p4_ ON p0_.id = p4_.product_id LEFT JOIN product_feature p3_ ON p3_.id = p4_.product_feature_id WHERE p0_.status = ? AND c2_.slug = ? ORDER BY p0_.is_featured DESC, p0_.created_at DESC LIMIT 9"
  "params" => [
    1 => "active"
    2 => "luxus-mobilheime"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#636}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.subtitle AS subtitle_4, c0_.image AS image_5, c0_.icon AS icon_6, c0_.display_order AS display_order_7, c0_.is_active AS is_active_8 FROM category c0_ WHERE c0_.is_active = ? ORDER BY c0_.display_order ASC, c0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#772
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.website AS website_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.display_order AS display_order_9 FROM brand t0 WHERE t0.is_active = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#772
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.category AS category_4, t0.icon AS icon_5, t0.is_highlighted AS is_highlighted_6 FROM product_feature t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.canonical_url AS canonical_url_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.og_image AS og_image_8, t0.twitter_card AS twitter_card_9, t0.robots AS robots_10 FROM seo_setting t0 WHERE t0.route_name = ? LIMIT 1"
  "params" => [
    1 => "app_catalog"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.merchant_center_id AS merchant_center_id_2, t0.merchant_account_id AS merchant_account_id_3, t0.api_client_id AS api_client_id_4, t0.api_client_secret AS api_client_secret_5, t0.refresh_token AS refresh_token_6, t0.feed_url AS feed_url_7, t0.ga_measurement_id AS ga_measurement_id_8, t0.ga_property_id AS ga_property_id_9, t0.gsc_property AS gsc_property_10, t0.gsc_verification_method AS gsc_verification_method_11, t0.gsc_verification_code AS gsc_verification_code_12, t0.gtm_id AS gtm_id_13, t0.google_site_verification_meta AS google_site_verification_meta_14, t0.is_connected AS is_connected_15, t0.last_tested_at AS last_tested_at_16, t0.last_sync_at AS last_sync_at_17, t0.last_sync_status AS last_sync_status_18, t0.updated_at AS updated_at_19 FROM google_integration t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.merchant_center_id AS merchant_center_id_2, t0.merchant_account_id AS merchant_account_id_3, t0.api_client_id AS api_client_id_4, t0.api_client_secret AS api_client_secret_5, t0.refresh_token AS refresh_token_6, t0.feed_url AS feed_url_7, t0.ga_measurement_id AS ga_measurement_id_8, t0.ga_property_id AS ga_property_id_9, t0.gsc_property AS gsc_property_10, t0.gsc_verification_method AS gsc_verification_method_11, t0.gsc_verification_code AS gsc_verification_code_12, t0.gtm_id AS gtm_id_13, t0.google_site_verification_meta AS google_site_verification_meta_14, t0.is_connected AS is_connected_15, t0.last_tested_at AS last_tested_at_16, t0.last_sync_at AS last_sync_at_17, t0.last_sync_status AS last_sync_status_18, t0.updated_at AS updated_at_19 FROM google_integration t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "contact_phone"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "contact_phone"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "opening_hours"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "contact_phone"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "contact_phone"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "contact_phone"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#636
      +name: "STRING"
    }
  ]
]

[
  "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" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::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\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

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

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