Symfony Profiler

[
  "route" => "app_wine_show"
  "route_parameters" => [
    "_route" => "app_wine_show"
    "_controller" => "App\Controller\CatalogController::show"
    "slug" => "primitivo-di-manduria"
  ]
  "request_uri" => "https://primo-vino.codity-dev.lt/vynai/primitivo-di-manduria"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

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

[
  "sql" => "SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36 FROM wine w0_ WHERE w0_.is_active = ? AND w0_.slug = ?"
  "params" => [
    1 => 1
    2 => "primitivo-di-manduria"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1064
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_27 FROM (SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = ? AND w0_.type = ? AND w0_.id <> ? ORDER BY w1_.position ASC) dctrn_result_inner ORDER BY position_27 ASC) dctrn_result LIMIT 4"
  "params" => [
    1 => 1
    2 => "RAUDONAS"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1064
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1156
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40, w1_.wine_id AS wine_id_41 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = ? AND w0_.type = ? AND w0_.id <> ? AND w0_.id IN (?, ?) ORDER BY w0_.position ASC, w1_.position ASC"
  "params" => [
    1 => 1
    2 => "RAUDONAS"
    3 => 1
    4 => 3
    5 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1064
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1156
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#1156}
    5 => Doctrine\DBAL\ParameterType {#1156}
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_27 FROM (SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = ? AND w0_.type <> ? AND w0_.id <> ? ORDER BY w1_.position ASC) dctrn_result_inner ORDER BY position_27 ASC) dctrn_result LIMIT 2"
  "params" => [
    1 => 1
    2 => "RAUDONAS"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1064
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1156
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40, w1_.wine_id AS wine_id_41 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = ? AND w0_.type <> ? AND w0_.id <> ? AND w0_.id IN (?) ORDER BY w0_.position ASC, w1_.position ASC"
  "params" => [
    1 => 1
    2 => "RAUDONAS"
    3 => 1
    4 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1158
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1064
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1156
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#1156}
  ]
]

[
  "sql" => "SELECT s0_.setting_key AS setting_key_0, s0_.value AS value_1 FROM site_setting s0_"
]

[
  "sql" => "SELECT t0_.trans_key AS trans_key_0, t0_.value AS value_1 FROM translation_override t0_ WHERE t0_.domain = ? AND t0_.locale = ?"
  "params" => [
    1 => "messages"
    2 => "lt"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1064
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1064}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.position AS position_4, t0.wine_id AS wine_id_5 FROM wine_image t0 WHERE t0.wine_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1156
      +name: "INTEGER"
    }
  ]
]