Symfony Profiler

SELECT
  c0_.code AS code_0,
  c0_.is_default AS is_default_1,
  c0_.is_active AS is_active_2,
  e1_.id AS id_3,
  e1_.exchange_rate AS exchange_rate_4,
  e1_.last_automatic_update AS last_automatic_update_5,
  e1_.created_at AS created_at_6,
  e1_.updated_at AS updated_at_7,
  e2_.id AS id_8,
  e2_.exchange_rate AS exchange_rate_9,
  e2_.last_automatic_update AS last_automatic_update_10,
  e2_.created_at AS created_at_11,
  e2_.updated_at AS updated_at_12,
  e1_.currency_from_id AS currency_from_id_13,
  e1_.currency_to_id AS currency_to_id_14,
  e2_.currency_from_id AS currency_from_id_15,
  e2_.currency_to_id AS currency_to_id_16
FROM
  currency c0_
  LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id
  LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id
WHERE
  c0_.is_default = ?

SELECT c0_.code AS code_0, c0_.is_default AS is_default_1, c0_.is_active AS is_active_2, e1_.id AS id_3, e1_.exchange_rate AS exchange_rate_4, e1_.last_automatic_update AS last_automatic_update_5, e1_.created_at AS created_at_6, e1_.updated_at AS updated_at_7, e2_.id AS id_8, e2_.exchange_rate AS exchange_rate_9, e2_.last_automatic_update AS last_automatic_update_10, e2_.created_at AS created_at_11, e2_.updated_at AS updated_at_12, e1_.currency_from_id AS currency_from_id_13, e1_.currency_to_id AS currency_to_id_14, e2_.currency_from_id AS currency_from_id_15, e2_.currency_to_id AS currency_to_id_16 FROM currency c0_ LEFT JOIN exchange_rate e1_ ON c0_.code = e1_.currency_to_id LEFT JOIN exchange_rate e2_ ON c0_.code = e2_.currency_from_id WHERE c0_.is_default = 1;

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.status AS status_2,
  c0_.last_activity_at AS last_activity_at_3,
  c0_.email AS email_4,
  c0_.firstname AS firstname_5,
  c0_.lastname AS lastname_6,
  c0_.telephone AS telephone_7,
  c0_.company_name AS company_name_8,
  c0_.cin AS cin_9,
  c0_.vat_id AS vat_id_10,
  c0_.pickup_point_id AS pickup_point_id_11,
  c0_.pickup_point_name AS pickup_point_name_12,
  c0_.note AS note_13,
  c0_.payment_method AS payment_method_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.address_street AS address_street_17,
  c0_.address_descriptive_number AS address_descriptive_number_18,
  c0_.address_city AS address_city_19,
  c0_.address_country AS address_country_20,
  c0_.address_zip_code AS address_zip_code_21,
  c0_.invoice_street AS invoice_street_22,
  c0_.invoice_descriptive_number AS invoice_descriptive_number_23,
  c0_.invoice_city AS invoice_city_24,
  c0_.invoice_country AS invoice_country_25,
  c0_.invoice_zip_code AS invoice_zip_code_26,
  c1_.id AS id_27,
  c1_.quantity AS quantity_28,
  c1_.created_at AS created_at_29,
  c1_.updated_at AS updated_at_30,
  p2_.id AS id_31,
  p2_.code AS code_32,
  p2_.is_default AS is_default_33,
  p2_.weight_modification AS weight_modification_34,
  p2_.price_modification_amount AS price_modification_amount_35,
  p2_.price_modification_currency AS price_modification_currency_36,
  p2_.stock_stock AS stock_stock_37,
  p2_.stock_reserved AS stock_reserved_38,
  p3_.id AS id_39,
  p3_.name AS name_40,
  p3_.description AS description_41,
  p3_.short_description AS short_description_42,
  p3_.code AS code_43,
  p3_.ean AS ean_44,
  p3_.unit AS unit_45,
  p3_.active AS active_46,
  p3_.can_be_bought AS can_be_bought_47,
  p3_.in_stock_text AS in_stock_text_48,
  p3_.out_of_stock_text AS out_of_stock_text_49,
  p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50,
  p3_.filter_variant_value_ids AS filter_variant_value_ids_51,
  p3_.seo_title AS seo_title_52,
  p3_.seo_description AS seo_description_53,
  p3_.seo_url AS seo_url_54,
  p3_.stock_stock AS stock_stock_55,
  p3_.stock_reserved AS stock_reserved_56,
  p3_.logistic_weight AS logistic_weight_57,
  p3_.logistic_size_width AS logistic_size_width_58,
  p3_.logistic_size_height AS logistic_size_height_59,
  p3_.logistic_size_length AS logistic_size_length_60,
  p3_.price_amount AS price_amount_61,
  p3_.price_currency AS price_currency_62,
  p3_.purchase_price_amount AS purchase_price_amount_63,
  p3_.purchase_price_currency AS purchase_price_currency_64,
  c0_.customer_id AS customer_id_65,
  c0_.shipping_method_id AS shipping_method_id_66,
  c1_.cart_id AS cart_id_67,
  c1_.product_variant_id AS product_variant_id_68,
  p2_.product_id AS product_id_69,
  p3_.vat_id AS vat_id_70,
  p3_.main_category_id AS main_category_id_71
FROM
  cart c0_
  LEFT JOIN cart_item 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
WHERE
  c0_.session_id = ?
  AND c0_.status = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.name AS name_40, p3_.description AS description_41, p3_.short_description AS short_description_42, p3_.code AS code_43, p3_.ean AS ean_44, p3_.unit AS unit_45, p3_.active AS active_46, p3_.can_be_bought AS can_be_bought_47, p3_.in_stock_text AS in_stock_text_48, p3_.out_of_stock_text AS out_of_stock_text_49, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50, p3_.filter_variant_value_ids AS filter_variant_value_ids_51, p3_.seo_title AS seo_title_52, p3_.seo_description AS seo_description_53, p3_.seo_url AS seo_url_54, p3_.stock_stock AS stock_stock_55, p3_.stock_reserved AS stock_reserved_56, p3_.logistic_weight AS logistic_weight_57, p3_.logistic_size_width AS logistic_size_width_58, p3_.logistic_size_height AS logistic_size_height_59, p3_.logistic_size_length AS logistic_size_length_60, p3_.price_amount AS price_amount_61, p3_.price_currency AS price_currency_62, p3_.purchase_price_amount AS purchase_price_amount_63, p3_.purchase_price_currency AS purchase_price_currency_64, c0_.customer_id AS customer_id_65, c0_.shipping_method_id AS shipping_method_id_66, c1_.cart_id AS cart_id_67, c1_.product_variant_id AS product_variant_id_68, p2_.product_id AS product_id_69, p3_.vat_id AS vat_id_70, p3_.main_category_id AS main_category_id_71 FROM cart c0_ LEFT JOIN cart_item 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 WHERE c0_.session_id = '' AND c0_.status = 'active' ORDER BY c1_.id ASC;

SELECT
  s0_.id AS id_0,
  s0_.range_from AS range_from_1,
  s0_.range_to AS range_to_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.price_amount AS price_amount_5,
  s0_.price_currency AS price_currency_6,
  s0_.shipping_method_id AS shipping_method_id_7,
  s0_.country_id AS country_id_8
FROM
  shipping_method_fee s0_
  INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id
WHERE
  (
    (
      (
        s1_.fee_based_on = ?
        AND s0_.range_from <= ?
        AND s0_.range_to > ?
      )
      OR (
        s1_.fee_based_on = ?
        AND s0_.range_from <= ?
        AND s0_.range_to > ?
      )
    )
    OR (
      s1_.behaviour_outside_fee_range = ?
      AND (
        NOT EXISTS (
          SELECT
            1 AS sclr_9
          FROM
            shipping_method_fee s2_
            INNER JOIN shipping_method s3_ ON s2_.shipping_method_id = s3_.id
          WHERE
            s3_.id = s1_.id
            AND (
              (
                s3_.fee_based_on = ?
                AND s2_.range_from <= ?
                AND s2_.range_to > ?
              )
              OR (
                s3_.fee_based_on = ?
                AND s2_.range_from <= ?
                AND s2_.range_to > ?
              )
            )
        )
      )
      AND s0_.price_amount = (
        SELECT
          MAX(s4_.price_amount) AS sclr_10
        FROM
          shipping_method_fee s5_,
          shipping_method_fee s4_
        WHERE
          s4_.shipping_method_id = s1_.id
      )
    )
  )
  AND s1_.is_active = true
  AND s1_.carrier IS NOT NULL
ORDER BY
  s0_.price_amount ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.range_from AS range_from_1, s0_.range_to AS range_to_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.price_amount AS price_amount_5, s0_.price_currency AS price_currency_6, s0_.shipping_method_id AS shipping_method_id_7, s0_.country_id AS country_id_8 FROM shipping_method_fee s0_ INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id WHERE (((s1_.fee_based_on = 'price' AND s0_.range_from <= 0 AND s0_.range_to > 0) OR (s1_.fee_based_on = 'weight' AND s0_.range_from <= 0 AND s0_.range_to > 0)) OR (s1_.behaviour_outside_fee_range = 'highest_price' AND (NOT EXISTS (SELECT 1 AS sclr_9 FROM shipping_method_fee s2_ INNER JOIN shipping_method s3_ ON s2_.shipping_method_id = s3_.id WHERE s3_.id = s1_.id AND ((s3_.fee_based_on = 'price' AND s2_.range_from <= 0 AND s2_.range_to > 0) OR (s3_.fee_based_on = 'weight' AND s2_.range_from <= 0 AND s2_.range_to > 0)))) AND s0_.price_amount = (SELECT MAX(s4_.price_amount) AS sclr_10 FROM shipping_method_fee s5_, shipping_method_fee s4_ WHERE s4_.shipping_method_id = s1_.id))) AND s1_.is_active = true AND s1_.carrier IS NOT NULL ORDER BY s0_.price_amount ASC LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.content AS content_3,
  s0_.show_contact_form AS show_contact_form_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.seo_title AS seo_title_7,
  s0_.seo_description AS seo_description_8,
  s0_.seo_url AS seo_url_9
FROM
  static_page s0_
ORDER BY
  s0_.title ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.show_contact_form AS show_contact_form_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.seo_title AS seo_title_7, s0_.seo_description AS seo_description_8, s0_.seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_.title ASC;

SELECT
  s0_.id AS id_0,
  s0_.range_from AS range_from_1,
  s0_.range_to AS range_to_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.price_amount AS price_amount_5,
  s0_.price_currency AS price_currency_6,
  s0_.shipping_method_id AS shipping_method_id_7,
  s0_.country_id AS country_id_8
FROM
  shipping_method_fee s0_
  INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id
WHERE
  s1_.is_active = true
  AND s1_.carrier IS NOT NULL
  AND s0_.price_amount = 0
  AND s0_.range_from IS NOT NULL
ORDER BY
  s0_.range_from ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.range_from AS range_from_1, s0_.range_to AS range_to_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.price_amount AS price_amount_5, s0_.price_currency AS price_currency_6, s0_.shipping_method_id AS shipping_method_id_7, s0_.country_id AS country_id_8 FROM shipping_method_fee s0_ INNER JOIN shipping_method s1_ ON s0_.shipping_method_id = s1_.id WHERE s1_.is_active = true AND s1_.carrier IS NOT NULL AND s0_.price_amount = 0 AND s0_.range_from IS NOT NULL ORDER BY s0_.range_from ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.rate AS rate_2
FROM
  tax_rate t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.rate AS rate_2 FROM tax_rate t0 WHERE t0.id = 'd4cbf291-83a9-4c10-97a6-39675f525c02';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.fee_based_on AS fee_based_on_4,
  t0.behaviour_outside_fee_range AS behaviour_outside_fee_range_5,
  t0.carrier AS carrier_6,
  t0.allow_home_delivery AS allow_home_delivery_7,
  t0.allow_box_delivery AS allow_box_delivery_8,
  t0.allow_pickup_point AS allow_pickup_point_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.logo_id AS logo_id_12,
  t0.tax_rate_id AS tax_rate_id_13,
  t0.carrier_shipping_option_id AS carrier_shipping_option_id_14
FROM
  shipping_method t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.fee_based_on AS fee_based_on_4, t0.behaviour_outside_fee_range AS behaviour_outside_fee_range_5, t0.carrier AS carrier_6, t0.allow_home_delivery AS allow_home_delivery_7, t0.allow_box_delivery AS allow_box_delivery_8, t0.allow_pickup_point AS allow_pickup_point_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.logo_id AS logo_id_12, t0.tax_rate_id AS tax_rate_id_13, t0.carrier_shipping_option_id AS carrier_shipping_option_id_14 FROM shipping_method t0 WHERE t0.id = '9a3917fc-0a87-42c9-a1b7-9b97b867218a';