Symfony Profiler

[
  "route" => "product_show"
  "route_parameters" => [
    "_route" => "product_show"
    "_controller" => "App\Controller\CatalogController::product"
    "slug" => "bague-fleur-sechee"
  ]
  "request_uri" => "https://creations-naura.fr/creation/bague-fleur-sechee"
  "method" => "GET"
]

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

[
  "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" => "localhost"
    "port" => 3306
    "user" => "creationsnaura"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "8.0.40"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "creationsnaura"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.price_cents AS price_cents_4, p0_.discount_type AS discount_type_5, p0_.discount_value AS discount_value_6, p0_.is_published AS is_published_7, p0_.is_favorite AS is_favorite_8, p0_.favorite_at AS favorite_at_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, c1_.description AS description_15, c1_.cover_image AS cover_image_16, c1_.position AS position_17, c1_.is_active AS is_active_18, c1_.created_at AS created_at_19, c1_.updated_at AS updated_at_20, c2_.id AS id_21, c2_.name AS name_22, c2_.slug AS slug_23, c2_.description AS description_24, c2_.cover_image AS cover_image_25, c2_.position AS position_26, c2_.is_active AS is_active_27, c2_.created_at AS created_at_28, c2_.updated_at AS updated_at_29, p3_.id AS id_30, p3_.filename AS filename_31, p3_.width AS width_32, p3_.height AS height_33, p3_.position AS position_34, c1_.parent_id AS parent_id_35, c2_.parent_id AS parent_id_36, p3_.product_id AS product_id_37 FROM product p0_ LEFT JOIN product_category p4_ ON p0_.id = p4_.product_id LEFT JOIN category c1_ ON c1_.id = p4_.category_id LEFT JOIN category c2_ ON c1_.parent_id = c2_.id INNER JOIN product_image p3_ ON p0_.id = p3_.product_id WHERE p0_.is_published = 1 AND (EXISTS (SELECT 1 AS sclr_38 FROM product p5_ INNER JOIN product_category p7_ ON p5_.id = p7_.product_id INNER JOIN category c6_ ON c6_.id = p7_.category_id LEFT JOIN category c8_ ON c6_.parent_id = c8_.id WHERE p5_.id = p0_.id AND c6_.is_active = 1 AND (c8_.id IS NULL OR c8_.is_active = 1))) AND p0_.slug = ? ORDER BY p3_.position ASC"
  "params" => [
    1 => "bague-fleur-sechee"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#780
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.cover_image AS cover_image_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.name ASC"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.is_published = 1 AND (EXISTS (SELECT 1 AS sclr_1 FROM product p1_ INNER JOIN product_category p3_ ON p1_.id = p3_.product_id INNER JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN category c4_ ON c2_.parent_id = c4_.id WHERE p1_.id = p0_.id AND c2_.is_active = 1 AND (c4_.id IS NULL OR c4_.is_active = 1))) AND EXISTS (SELECT 1 AS sclr_2 FROM product_image p5_ WHERE p5_.product_id = p0_.id) AND p0_.id <> ? AND (EXISTS (SELECT 1 AS sclr_3 FROM product p6_ INNER JOIN product_category p8_ ON p6_.id = p8_.product_id INNER JOIN category c7_ ON c7_.id = p8_.category_id WHERE p6_.id = p0_.id AND c7_.id IN (?, ?))) ORDER BY p0_.created_at DESC LIMIT 4"
  "params" => [
    1 => 32
    2 => 9
    3 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#927}
    3 => Doctrine\DBAL\ParameterType {#927}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.price_cents AS price_cents_4, p0_.discount_type AS discount_type_5, p0_.discount_value AS discount_value_6, p0_.is_published AS is_published_7, p0_.is_favorite AS is_favorite_8, p0_.favorite_at AS favorite_at_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, c1_.description AS description_15, c1_.cover_image AS cover_image_16, c1_.position AS position_17, c1_.is_active AS is_active_18, c1_.created_at AS created_at_19, c1_.updated_at AS updated_at_20, c2_.id AS id_21, c2_.name AS name_22, c2_.slug AS slug_23, c2_.description AS description_24, c2_.cover_image AS cover_image_25, c2_.position AS position_26, c2_.is_active AS is_active_27, c2_.created_at AS created_at_28, c2_.updated_at AS updated_at_29, p3_.id AS id_30, p3_.filename AS filename_31, p3_.width AS width_32, p3_.height AS height_33, p3_.position AS position_34, c1_.parent_id AS parent_id_35, c2_.parent_id AS parent_id_36, p3_.product_id AS product_id_37 FROM product p0_ LEFT JOIN product_category p4_ ON p0_.id = p4_.product_id LEFT JOIN category c1_ ON c1_.id = p4_.category_id LEFT JOIN category c2_ ON c1_.parent_id = c2_.id INNER JOIN product_image p3_ ON p0_.id = p3_.product_id WHERE p0_.id IN (?, ?, ?, ?) ORDER BY p3_.position ASC"
  "params" => [
    1 => 35
    2 => 34
    3 => 33
    4 => 31
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#927}
    3 => Doctrine\DBAL\ParameterType {#927}
    4 => Doctrine\DBAL\ParameterType {#927}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.owner_name AS owner_name_3, t0.tagline AS tagline_4, t0.about AS about_5, t0.portrait_image AS portrait_image_6, t0.phone AS phone_7, t0.public_email AS public_email_8, t0.inbox_email AS inbox_email_9, t0.city AS city_10, t0.shipping_info AS shipping_info_11, t0.footer_text AS footer_text_12, t0.legal_name AS legal_name_13, t0.legal_status AS legal_status_14, t0.siret AS siret_15, t0.legal_address AS legal_address_16, t0.host_name AS host_name_17, t0.host_address AS host_address_18 FROM site_settings t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, p1_.id AS id_1 FROM product p1_ INNER JOIN product_category p2_ ON p1_.id = p2_.product_id INNER JOIN category c0_ ON c0_.id = p2_.category_id WHERE p1_.is_published = 1 AND EXISTS (SELECT 1 AS sclr_2 FROM product_image p3_ WHERE p3_.product_id = p1_.id)"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.cover_image AS cover_image_4, c0_.position AS position_5, c0_.is_active AS is_active_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.slug AS slug_11, c1_.description AS description_12, c1_.cover_image AS cover_image_13, c1_.position AS position_14, c1_.is_active AS is_active_15, c1_.created_at AS created_at_16, c1_.updated_at AS updated_at_17, c0_.parent_id AS parent_id_18, c1_.parent_id AS parent_id_19 FROM category c0_ LEFT JOIN category c1_ ON c0_.parent_id = c1_.id ORDER BY c0_.position ASC, c0_.name ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.cover_image AS cover_image_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.name ASC"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.cover_image AS cover_image_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.name ASC"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.cover_image AS cover_image_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC, t0.name ASC"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.network AS network_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.settings_id AS settings_id_6 FROM social_link t0 WHERE t0.settings_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#927
      +name: "INTEGER"
    }
  ]
]