| 5 |
5.17 ms |
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 = ?
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 = ?
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 = 81;
|