Symfony Profiler

[
  "route" => "product_show"
  "route_parameters" => [
    "_route" => "product_show"
    "_controller" => "App\Controller\ProductController::show"
    "id" => "105"
  ]
  "request_uri" => "https://moonprint-kuba.cod3lab.eu/product/105"
  "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_pgsql"
    "idle_connection_ttl" => 600
    "host" => "postgresql"
    "port" => 5432
    "user" => "username"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "database"
    "serverVersion" => "17"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.title AS title_4, t0.specification AS specification_5, t0.description AS description_6, t0.visible AS visible_7, t0.source_id AS source_id_8, t0.manufacturer_id AS manufacturer_id_9, t0.remote_category_id AS remote_category_id_10 FROM product t0 WHERE t0.id = ?"
  "params" => [
    1 => "105"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.source_id AS source_id_3, t0.category_id AS category_id_4 FROM remote_category t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.visible AS visible_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.depth AS depth_7, t0.sort_path AS sort_path_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a0_.parent_id AS parent_id_7 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_variant_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id ORDER BY a0_.sort_path ASC"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.id ASC"
  "params" => [
    1 => 105
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#673}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? AND p3_.id IN (?, ?, ?, ?, ?) ORDER BY a0_.id ASC"
  "params" => [
    1 => 105
    2 => 1
    3 => 5625
    4 => 5626
    5 => 5627
    6 => 5628
    7 => 5629
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#673}
    3 => Doctrine\DBAL\ParameterType {#673}
    4 => Doctrine\DBAL\ParameterType {#673}
    5 => Doctrine\DBAL\ParameterType {#673}
    6 => Doctrine\DBAL\ParameterType {#673}
    7 => Doctrine\DBAL\ParameterType {#673}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.value ASC"
  "params" => [
    1 => 105
    2 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#673}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.value AS value_1, a0_.value_float AS value_float_2, a0_.attribute_id AS attribute_id_3 FROM attribute_value a0_ INNER JOIN attribute a1_ ON a0_.attribute_id = a1_.id INNER JOIN product_variant_attribute_value p2_ ON a0_.id = p2_.attribute_value_id INNER JOIN product_variant p3_ ON p2_.variant_id = p3_.id INNER JOIN product p4_ ON p3_.product_id = p4_.id WHERE p4_.id = ? AND p4_.visible = true AND p3_.visible = true AND a1_.id = ? AND p3_.id IN (?, ?, ?, ?, ?) ORDER BY a0_.value ASC"
  "params" => [
    1 => 105
    2 => 10
    3 => 5625
    4 => 5626
    5 => 5627
    6 => 5628
    7 => 5629
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#673}
    3 => Doctrine\DBAL\ParameterType {#673}
    4 => Doctrine\DBAL\ParameterType {#673}
    5 => Doctrine\DBAL\ParameterType {#673}
    6 => Doctrine\DBAL\ParameterType {#673}
    7 => Doctrine\DBAL\ParameterType {#673}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.url AS url_1, i0_.path AS path_2, i0_.filename AS filename_3, i0_.hash AS hash_4 FROM image i0_ INNER JOIN product_variant_image p1_ ON i0_.id = p1_.image_id INNER JOIN product_variant p2_ ON p1_.variant_id = p2_.id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (?, ?, ?, ?, ?) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC"
  "params" => [
    1 => 105
    2 => 5625
    3 => 5626
    4 => 5627
    5 => 5628
    6 => 5629
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#673}
    3 => Doctrine\DBAL\ParameterType {#673}
    4 => Doctrine\DBAL\ParameterType {#673}
    5 => Doctrine\DBAL\ParameterType {#673}
    6 => Doctrine\DBAL\ParameterType {#673}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.visible AS visible_3, a0_.position AS position_4, a0_.depth AS depth_5, a0_.sort_path AS sort_path_6, a1_.id AS id_7, a1_.value AS value_8, a1_.value_float AS value_float_9, a0_.parent_id AS parent_id_10, a1_.attribute_id AS attribute_id_11 FROM attribute a0_ INNER JOIN attribute_value a1_ ON a0_.id = a1_.attribute_id INNER JOIN product_attribute_value p2_ ON a1_.id = p2_.attribute_value_id INNER JOIN product p3_ ON p2_.product_id = p3_.id WHERE p3_.id = ? AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id, a0_.code, a0_.name, a0_.visible, a0_.position, a0_.depth, a0_.sort_path, a0_.parent_id, a1_.id, a1_.value, a1_.value_float, a1_.attribute_id ORDER BY a0_.sort_path ASC"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product_variant p0_ INNER JOIN product p1_ ON p0_.product_id = p1_.id WHERE p1_.id = ? AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (?, ?, ?, ?, ?)"
  "params" => [
    1 => 105
    2 => 5625
    3 => 5626
    4 => 5627
    5 => 5628
    6 => 5629
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#673}
    3 => Doctrine\DBAL\ParameterType {#673}
    4 => Doctrine\DBAL\ParameterType {#673}
    5 => Doctrine\DBAL\ParameterType {#673}
    6 => Doctrine\DBAL\ParameterType {#673}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.visible AS visible_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.position AS position_5, c0_.depth AS depth_6, c0_.sort_path AS sort_path_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.visible = true ORDER BY c0_.sort_path ASC"
]

[
  "sql" => "INSERT INTO cart (created_at, updated_at, owner_id, shipping_method_id, payment_method_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "2026-03-17 20:46:36"
    2 => "2026-03-17 20:46:36"
    3 => null
    4 => null
    5 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1031
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1031}
    3 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
    4 => Doctrine\DBAL\ParameterType {#673}
    5 => Doctrine\DBAL\ParameterType {#673}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c1_.id AS id_3, c1_.quantity AS quantity_4, c1_.created_at AS created_at_5, c1_.updated_at AS updated_at_6, p2_.id AS id_7, p2_.ean AS ean_8, p2_.price AS price_9, p2_.stock AS stock_10, p2_.visible AS visible_11, p3_.id AS id_12, p3_.remote_id AS remote_id_13, p3_.name AS name_14, p3_.title AS title_15, p3_.specification AS specification_16, p3_.description AS description_17, p3_.visible AS visible_18, p4_.id AS id_19, a5_.id AS id_20, a5_.value AS value_21, a5_.value_float AS value_float_22, a6_.id AS id_23, a6_.code AS code_24, a6_.name AS name_25, a6_.visible AS visible_26, a6_.position AS position_27, a6_.depth AS depth_28, a6_.sort_path AS sort_path_29, p7_.id AS id_30, p7_.original_filename AS original_filename_31, p7_.filename AS filename_32, p7_.mime_type AS mime_type_33, p7_.size AS size_34, p7_.path AS path_35, p7_.created_at AS created_at_36, p7_.updated_at AS updated_at_37, c0_.owner_id AS owner_id_38, c0_.shipping_method_id AS shipping_method_id_39, c0_.payment_method_id AS payment_method_id_40, c1_.cart_id AS cart_id_41, c1_.product_variant_id AS product_variant_id_42, c1_.project_file_id AS project_file_id_43, p2_.product_id AS product_id_44, p3_.source_id AS source_id_45, p3_.manufacturer_id AS manufacturer_id_46, p3_.remote_category_id AS remote_category_id_47, p4_.variant_id AS variant_id_48, p4_.attribute_value_id AS attribute_value_id_49, a5_.attribute_id AS attribute_id_50, a6_.parent_id AS parent_id_51, p7_.user_id AS user_id_52 FROM cart c0_ LEFT JOIN cart_product_variant c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id LEFT JOIN product_variant_attribute_value p4_ ON p2_.id = p4_.variant_id LEFT JOIN attribute_value a5_ ON p4_.attribute_value_id = a5_.id LEFT JOIN attribute a6_ ON a5_.attribute_id = a6_.id LEFT JOIN project_file p7_ ON c1_.project_file_id = p7_.id WHERE c0_.id = ?"
  "params" => [
    1 => 123
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.attachment_image_id AS attachment_image_id_3 FROM product_attachment_image t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = ?"
  "params" => [
    1 => 209
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attachment t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.filename AS filename_4, t0.hash AS hash_5, t0.attachment_id AS attachment_id_6 FROM attachment_image t0 WHERE t0.id = ?"
  "params" => [
    1 => 210
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.visible AS visible_4, t0.position AS position_5, t0.depth AS depth_6, t0.sort_path AS sort_path_7, t0.parent_id AS parent_id_8 FROM attachment t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#673
      +name: "INTEGER"
    }
  ]
]