Symfony Profiler

SELECT
  t0.title AS title_1,
  t0.code AS code_2,
  t0.enabled AS enabled_3,
  t0.head_start AS head_start_4,
  t0.head_end AS head_end_5,
  t0.body_start AS body_start_6,
  t0.body_end AS body_end_7,
  t0.id AS id_8,
  t0.deleted AS deleted_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12
FROM
  valueinshop_html_snippet t0
WHERE
  (
    (t0.deleted = 0)
  )

SELECT t0.title AS title_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.head_start AS head_start_4, t0.head_end AS head_end_5, t0.body_start AS body_start_6, t0.body_end AS body_end_7, t0.id AS id_8, t0.deleted AS deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12 FROM valueinshop_html_snippet t0 WHERE ((t0.deleted = 0));

SELECT
  t0.id AS id_1,
  t0.use_invoice_engine_preview AS use_invoice_engine_preview_2,
  t0.context AS context_3,
  t0.shipping_address_mode AS shipping_address_mode_4,
  t0.billing_address_mode AS billing_address_mode_5,
  t0.display_tax_detail AS display_tax_detail_6,
  t0.display_discount_detail AS display_discount_detail_7,
  t0.display_map_in_forms AS display_map_in_forms_8
FROM
  valueinshop_cart t0

SELECT t0.id AS id_1, t0.use_invoice_engine_preview AS use_invoice_engine_preview_2, t0.context AS context_3, t0.shipping_address_mode AS shipping_address_mode_4, t0.billing_address_mode AS billing_address_mode_5, t0.display_tax_detail AS display_tax_detail_6, t0.display_discount_detail AS display_discount_detail_7, t0.display_map_in_forms AS display_map_in_forms_8 FROM valueinshop_cart t0;

SELECT
  t0.language AS language_1,
  t0.text AS text_2,
  t0.id AS id_3,
  t0.deleted AS deleted_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.title AS title_8,
  t0.source AS source_9
FROM
  valueinshop_text_translation t0
WHERE
  t0.source = ?
  AND t0.language = ?
  AND (
    (t0.deleted = 0)
  )
LIMIT
  1

SELECT t0.language AS language_1, t0.text AS text_2, t0.id AS id_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.title AS title_8, t0.source AS source_9 FROM valueinshop_text_translation t0 WHERE t0.source = 'empty_cart' AND t0.language = 'en' AND ((t0.deleted = 0)) LIMIT 1;

SELECT
  v0_.name AS name_0,
  v0_.amendment_system_name AS amendment_system_name_1,
  v0_.enabled_from AS enabled_from_2,
  v0_.enabled_to AS enabled_to_3,
  v0_.status AS status_4,
  v0_.term_types AS term_types_5,
  v0_.allow_custom_subscription_strategy AS allow_custom_subscription_strategy_6,
  v0_.id AS id_7,
  v0_.deleted AS deleted_8,
  v0_.created_at AS created_at_9,
  v0_.updated_at AS updated_at_10,
  v0_.deleted_at AS deleted_at_11
FROM
  valueinshop_config_amendement v0_
WHERE
  (
    v0_.enabled_to >= ?
    AND v0_.enabled_from <= ?
  )
  AND (v0_.deleted = 0)
ORDER BY
  v0_.amendment_system_name ASC

SELECT v0_.name AS name_0, v0_.amendment_system_name AS amendment_system_name_1, v0_.enabled_from AS enabled_from_2, v0_.enabled_to AS enabled_to_3, v0_.status AS status_4, v0_.term_types AS term_types_5, v0_.allow_custom_subscription_strategy AS allow_custom_subscription_strategy_6, v0_.id AS id_7, v0_.deleted AS deleted_8, v0_.created_at AS created_at_9, v0_.updated_at AS updated_at_10, v0_.deleted_at AS deleted_at_11 FROM valueinshop_config_amendement v0_ WHERE (v0_.enabled_to >= '2025-04-29 00:00:00' AND v0_.enabled_from <= '2025-04-29 00:00:00') AND (v0_.deleted = 0) ORDER BY v0_.amendment_system_name ASC;

SELECT
  t0.code AS code_1,
  t0.title AS title_2,
  t0.text AS text_3
FROM
  valueinshop_text t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.title AS title_2, t0.text AS text_3 FROM valueinshop_text t0 WHERE t0.code = 'empty_cart';

SELECT
  t0.isDefault AS isDefault_1,
  t0.prefix AS prefix_2,
  t0.id AS id_3,
  t0.deleted AS deleted_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.title AS title_8,
  t0.address AS address_9,
  t0.zipcode AS zipcode_10,
  t0.city AS city_11,
  t0.state AS state_12,
  t0.country AS country_13,
  t0.description AS description_14,
  t0.frontend_id AS frontend_id_15,
  t0.internationalization_id AS internationalization_id_16,
  t0.invoicing_id AS invoicing_id_17,
  t0.image_id AS image_id_18,
  t20.name AS name_19,
  t20.description AS description_21,
  t20.enabled AS enabled_22,
  t20.provider_name AS provider_name_23,
  t20.provider_status AS provider_status_24,
  t20.provider_reference AS provider_reference_25,
  t20.provider_metadata AS provider_metadata_26,
  t20.width AS width_27,
  t20.height AS height_28,
  t20.length AS length_29,
  t20.content_type AS content_type_30,
  t20.content_size AS content_size_31,
  t20.copyright AS copyright_32,
  t20.author_name AS author_name_33,
  t20.context AS context_34,
  t20.cdn_is_flushable AS cdn_is_flushable_35,
  t20.cdn_flush_identifier AS cdn_flush_identifier_36,
  t20.cdn_flush_at AS cdn_flush_at_37,
  t20.cdn_status AS cdn_status_38,
  t20.updated_at AS updated_at_39,
  t20.created_at AS created_at_40,
  t20.uuid AS uuid_41,
  t20.id AS id_42,
  t0.imagecover_id AS imagecover_id_43,
  t0.entityType
FROM
  valueinshop_shop t0
  LEFT JOIN valueinshop_media t20 ON t0.image_id = t20.id
WHERE
  t0.id = ?
  AND t0.entityType IN ('shop')
  AND (
    (t0.deleted = 0)
  )

SELECT t0.isDefault AS isDefault_1, t0.prefix AS prefix_2, t0.id AS id_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.title AS title_8, t0.address AS address_9, t0.zipcode AS zipcode_10, t0.city AS city_11, t0.state AS state_12, t0.country AS country_13, t0.description AS description_14, t0.frontend_id AS frontend_id_15, t0.internationalization_id AS internationalization_id_16, t0.invoicing_id AS invoicing_id_17, t0.image_id AS image_id_18, t20.name AS name_19, t20.description AS description_21, t20.enabled AS enabled_22, t20.provider_name AS provider_name_23, t20.provider_status AS provider_status_24, t20.provider_reference AS provider_reference_25, t20.provider_metadata AS provider_metadata_26, t20.width AS width_27, t20.height AS height_28, t20.length AS length_29, t20.content_type AS content_type_30, t20.content_size AS content_size_31, t20.copyright AS copyright_32, t20.author_name AS author_name_33, t20.context AS context_34, t20.cdn_is_flushable AS cdn_is_flushable_35, t20.cdn_flush_identifier AS cdn_flush_identifier_36, t20.cdn_flush_at AS cdn_flush_at_37, t20.cdn_status AS cdn_status_38, t20.updated_at AS updated_at_39, t20.created_at AS created_at_40, t20.uuid AS uuid_41, t20.id AS id_42, t0.imagecover_id AS imagecover_id_43, t0.entityType FROM valueinshop_shop t0 LEFT JOIN valueinshop_media t20 ON t0.image_id = t20.id WHERE t0.id = 3 AND t0.entityType IN ('shop') AND ((t0.deleted = 0));

SELECT
  t0.context AS context_1,
  t0.shipping_address_mode AS shipping_address_mode_2,
  t0.billing_address_mode AS billing_address_mode_3,
  t0.id AS id_4,
  t0.deleted AS deleted_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.theme_id AS theme_id_9
FROM
  valueinshop_shop_frontend t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted = 0)
  )

SELECT t0.context AS context_1, t0.shipping_address_mode AS shipping_address_mode_2, t0.billing_address_mode AS billing_address_mode_3, t0.id AS id_4, t0.deleted AS deleted_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.theme_id AS theme_id_9 FROM valueinshop_shop_frontend t0 WHERE t0.id = 3 AND ((t0.deleted = 0));

SELECT
  t0.label AS label_1,
  t0.field_group AS field_group_2,
  t0.visible_on_all_shop AS visible_on_all_shop_3,
  t0.visible_without_shop AS visible_without_shop_4,
  t0.priority AS priority_5,
  t0.scope AS scope_6,
  t0.destination AS destination_7,
  t0.custom_field_name AS custom_field_name_8,
  t0.default_value AS default_value_9,
  t0.field_type AS field_type_10,
  t0.choices AS choices_11,
  t0.self_service_behavior AS self_service_behavior_12,
  t0.customer_care_behavior AS customer_care_behavior_13,
  t0.id AS id_14,
  t0.deleted AS deleted_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.deleted_at AS deleted_at_18
FROM
  valueinshop_custom_fields t0
WHERE
  (
    (t0.deleted = 0)
  )

SELECT t0.label AS label_1, t0.field_group AS field_group_2, t0.visible_on_all_shop AS visible_on_all_shop_3, t0.visible_without_shop AS visible_without_shop_4, t0.priority AS priority_5, t0.scope AS scope_6, t0.destination AS destination_7, t0.custom_field_name AS custom_field_name_8, t0.default_value AS default_value_9, t0.field_type AS field_type_10, t0.choices AS choices_11, t0.self_service_behavior AS self_service_behavior_12, t0.customer_care_behavior AS customer_care_behavior_13, t0.id AS id_14, t0.deleted AS deleted_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18 FROM valueinshop_custom_fields t0 WHERE ((t0.deleted = 0));

SELECT
  t0.language_code AS language_code_1,
  t0.isDefault AS isDefault_2,
  t0.enabled AS enabled_3,
  t0.debug AS debug_4,
  t0.collect AS collect_5,
  t0.id AS id_6,
  t0.deleted AS deleted_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  valueinshop_language t0
WHERE
  t0.language_code = ?
  AND (
    (
      t0.id IN (
        SELECT
          vil.language_id
        FROM
          valueinshop_internationalization_language vil
          JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id
        WHERE
          vs.id = 3
      )
      OR (
        SELECT
          COUNT(vil.language_id)
        FROM
          valueinshop_internationalization_language vil
          JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id
        WHERE
          vs.id = 3
      )= 0
    )
    AND (t0.deleted = 0)
  )
LIMIT
  1

SELECT t0.language_code AS language_code_1, t0.isDefault AS isDefault_2, t0.enabled AS enabled_3, t0.debug AS debug_4, t0.collect AS collect_5, t0.id AS id_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM valueinshop_language t0 WHERE t0.language_code = 'en' AND ((t0.id IN (SELECT vil.language_id FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3) OR (SELECT COUNT(vil.language_id) FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3)=0) AND (t0.deleted = 0)) LIMIT 1;

SELECT
  t0.language_code AS language_code_1,
  t0.isDefault AS isDefault_2,
  t0.enabled AS enabled_3,
  t0.debug AS debug_4,
  t0.collect AS collect_5,
  t0.id AS id_6,
  t0.deleted AS deleted_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10
FROM
  valueinshop_language t0
WHERE
  t0.enabled = ?
  AND (
    (
      t0.id IN (
        SELECT
          vil.language_id
        FROM
          valueinshop_internationalization_language vil
          JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id
        WHERE
          vs.id = 3
      )
      OR (
        SELECT
          COUNT(vil.language_id)
        FROM
          valueinshop_internationalization_language vil
          JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id
        WHERE
          vs.id = 3
      )= 0
    )
    AND (t0.deleted = 0)
  )

SELECT t0.language_code AS language_code_1, t0.isDefault AS isDefault_2, t0.enabled AS enabled_3, t0.debug AS debug_4, t0.collect AS collect_5, t0.id AS id_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM valueinshop_language t0 WHERE t0.enabled = 1 AND ((t0.id IN (SELECT vil.language_id FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3) OR (SELECT COUNT(vil.language_id) FROM valueinshop_internationalization_language vil JOIN valueinshop_shop vs ON vs.internationalization_id = vil.internationalization_id WHERE vs.id=3)=0) AND (t0.deleted = 0));