Symfony Profiler

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.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.source_id AS source_id_10,
  t0.manufacturer_id AS manufacturer_id_11,
  t0.remote_category_id AS remote_category_id_12
FROM
  product t0
WHERE
  t0.id = ?

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.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.source_id AS source_id_10, t0.manufacturer_id AS manufacturer_id_11, t0.remote_category_id AS remote_category_id_12 FROM product t0 WHERE t0.id = '109';

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 = ?

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 = 5;

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 = ?

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 = 3;

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

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 = 109 AND p4_.visible = true AND p3_.visible = true AND a0_.visible = true GROUP BY a0_.id ORDER BY a0_.sort_path ASC;

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

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 = 109 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 1 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.id ASC;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 109;

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

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 = 109 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 1 AND p3_.id IN (5648, 5647) ORDER BY a0_.id ASC;

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

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 = 109 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 10 GROUP BY a0_.id, a0_.value, a0_.value_float, a0_.attribute_id ORDER BY a0_.value ASC;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 109;

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

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 = 109 AND p4_.visible = true AND p3_.visible = true AND a1_.id = 10 AND p3_.id IN (5648, 5647) ORDER BY a0_.value ASC;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 109;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 109;

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

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 = 109 AND p3_.visible = true AND p2_.visible = true AND p2_.id IN (5648, 5647) GROUP BY i0_.id, i0_.url, i0_.path, i0_.filename, i0_.hash ORDER BY i0_.path ASC;

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

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 = 109 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;

SELECT
  p0_.id AS id_0
FROM
  product_variant p0_
WHERE
  p0_.product_id = ?

SELECT p0_.id AS id_0 FROM product_variant p0_ WHERE p0_.product_id = 109;

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 (?, ?)

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 = 109 AND p1_.visible = true AND p0_.visible = true AND p0_.id IN (5648, 5647);

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

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;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.owner_id AS owner_id_4,
  t0.shipping_method_id AS shipping_method_id_5,
  t0.payment_method_id AS payment_method_id_6,
  t0.applied_discount_code_id AS applied_discount_code_id_7
FROM
  cart t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.owner_id AS owner_id_4, t0.shipping_method_id AS shipping_method_id_5, t0.payment_method_id AS payment_method_id_6, t0.applied_discount_code_id AS applied_discount_code_id_7 FROM cart t0 WHERE t0.id = 514;

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,
  p3_.created_at AS created_at_19,
  p3_.updated_at AS updated_at_20,
  r4_.id AS id_21,
  r4_.name AS name_22,
  c5_.id AS id_23,
  c5_.name AS name_24,
  c5_.visible AS visible_25,
  c5_.created_at AS created_at_26,
  c5_.updated_at AS updated_at_27,
  c5_.position AS position_28,
  c5_.depth AS depth_29,
  c5_.sort_path AS sort_path_30,
  p6_.id AS id_31,
  a7_.id AS id_32,
  a7_.value AS value_33,
  a7_.value_float AS value_float_34,
  a8_.id AS id_35,
  a8_.code AS code_36,
  a8_.name AS name_37,
  a8_.visible AS visible_38,
  a8_.position AS position_39,
  a8_.depth AS depth_40,
  a8_.sort_path AS sort_path_41,
  p9_.id AS id_42,
  p9_.original_filename AS original_filename_43,
  p9_.filename AS filename_44,
  p9_.mime_type AS mime_type_45,
  p9_.size AS size_46,
  p9_.path AS path_47,
  p9_.created_at AS created_at_48,
  p9_.updated_at AS updated_at_49,
  d10_.id AS id_50,
  d10_.code AS code_51,
  d10_.type AS type_52,
  d10_.value AS value_53,
  d10_.max_discount_amount AS max_discount_amount_54,
  d10_.active AS active_55,
  d10_.valid_from AS valid_from_56,
  d10_.valid_to AS valid_to_57,
  d10_.max_uses_total AS max_uses_total_58,
  d10_.max_uses_per_user AS max_uses_per_user_59,
  d10_.min_cart_value AS min_cart_value_60,
  d10_.min_cart_items AS min_cart_items_61,
  d10_.created_at AS created_at_62,
  d10_.updated_at AS updated_at_63,
  c0_.owner_id AS owner_id_64,
  c0_.shipping_method_id AS shipping_method_id_65,
  c0_.payment_method_id AS payment_method_id_66,
  c0_.applied_discount_code_id AS applied_discount_code_id_67,
  c1_.cart_id AS cart_id_68,
  c1_.product_variant_id AS product_variant_id_69,
  c1_.project_file_id AS project_file_id_70,
  p2_.product_id AS product_id_71,
  p3_.source_id AS source_id_72,
  p3_.manufacturer_id AS manufacturer_id_73,
  p3_.remote_category_id AS remote_category_id_74,
  r4_.source_id AS source_id_75,
  r4_.category_id AS category_id_76,
  c5_.parent_id AS parent_id_77,
  p6_.variant_id AS variant_id_78,
  p6_.attribute_value_id AS attribute_value_id_79,
  a7_.attribute_id AS attribute_id_80,
  a8_.parent_id AS parent_id_81,
  p9_.user_id AS user_id_82,
  d10_.restricted_to_user_id AS restricted_to_user_id_83
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 remote_category r4_ ON p3_.remote_category_id = r4_.id
  LEFT JOIN category c5_ ON r4_.category_id = c5_.id
  LEFT JOIN product_variant_attribute_value p6_ ON p2_.id = p6_.variant_id
  LEFT JOIN attribute_value a7_ ON p6_.attribute_value_id = a7_.id
  LEFT JOIN attribute a8_ ON a7_.attribute_id = a8_.id
  LEFT JOIN project_file p9_ ON c1_.project_file_id = p9_.id
  LEFT JOIN discount_code d10_ ON c0_.applied_discount_code_id = d10_.id
WHERE
  c0_.id = ?
ORDER BY
  c1_.id ASC

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, p3_.created_at AS created_at_19, p3_.updated_at AS updated_at_20, r4_.id AS id_21, r4_.name AS name_22, c5_.id AS id_23, c5_.name AS name_24, c5_.visible AS visible_25, c5_.created_at AS created_at_26, c5_.updated_at AS updated_at_27, c5_.position AS position_28, c5_.depth AS depth_29, c5_.sort_path AS sort_path_30, p6_.id AS id_31, a7_.id AS id_32, a7_.value AS value_33, a7_.value_float AS value_float_34, a8_.id AS id_35, a8_.code AS code_36, a8_.name AS name_37, a8_.visible AS visible_38, a8_.position AS position_39, a8_.depth AS depth_40, a8_.sort_path AS sort_path_41, p9_.id AS id_42, p9_.original_filename AS original_filename_43, p9_.filename AS filename_44, p9_.mime_type AS mime_type_45, p9_.size AS size_46, p9_.path AS path_47, p9_.created_at AS created_at_48, p9_.updated_at AS updated_at_49, d10_.id AS id_50, d10_.code AS code_51, d10_.type AS type_52, d10_.value AS value_53, d10_.max_discount_amount AS max_discount_amount_54, d10_.active AS active_55, d10_.valid_from AS valid_from_56, d10_.valid_to AS valid_to_57, d10_.max_uses_total AS max_uses_total_58, d10_.max_uses_per_user AS max_uses_per_user_59, d10_.min_cart_value AS min_cart_value_60, d10_.min_cart_items AS min_cart_items_61, d10_.created_at AS created_at_62, d10_.updated_at AS updated_at_63, c0_.owner_id AS owner_id_64, c0_.shipping_method_id AS shipping_method_id_65, c0_.payment_method_id AS payment_method_id_66, c0_.applied_discount_code_id AS applied_discount_code_id_67, c1_.cart_id AS cart_id_68, c1_.product_variant_id AS product_variant_id_69, c1_.project_file_id AS project_file_id_70, p2_.product_id AS product_id_71, p3_.source_id AS source_id_72, p3_.manufacturer_id AS manufacturer_id_73, p3_.remote_category_id AS remote_category_id_74, r4_.source_id AS source_id_75, r4_.category_id AS category_id_76, c5_.parent_id AS parent_id_77, p6_.variant_id AS variant_id_78, p6_.attribute_value_id AS attribute_value_id_79, a7_.attribute_id AS attribute_id_80, a8_.parent_id AS parent_id_81, p9_.user_id AS user_id_82, d10_.restricted_to_user_id AS restricted_to_user_id_83 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 remote_category r4_ ON p3_.remote_category_id = r4_.id LEFT JOIN category c5_ ON r4_.category_id = c5_.id LEFT JOIN product_variant_attribute_value p6_ ON p2_.id = p6_.variant_id LEFT JOIN attribute_value a7_ ON p6_.attribute_value_id = a7_.id LEFT JOIN attribute a8_ ON a7_.attribute_id = a8_.id LEFT JOIN project_file p9_ ON c1_.project_file_id = p9_.id LEFT JOIN discount_code d10_ ON c0_.applied_discount_code_id = d10_.id WHERE c0_.id = 514 ORDER BY c1_.id ASC;