Symfony Profiler

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.id AS id_1,
  t0.deleted AS deleted_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.title AS title_6,
  t0.parent_id AS parent_id_7,
  t0.product_selector_id AS product_selector_id_8,
  t0.image_id AS image_id_9,
  t11.name AS name_10,
  t11.description AS description_12,
  t11.enabled AS enabled_13,
  t11.provider_name AS provider_name_14,
  t11.provider_status AS provider_status_15,
  t11.provider_reference AS provider_reference_16,
  t11.provider_metadata AS provider_metadata_17,
  t11.width AS width_18,
  t11.height AS height_19,
  t11.length AS length_20,
  t11.content_type AS content_type_21,
  t11.content_size AS content_size_22,
  t11.copyright AS copyright_23,
  t11.author_name AS author_name_24,
  t11.context AS context_25,
  t11.cdn_is_flushable AS cdn_is_flushable_26,
  t11.cdn_flush_identifier AS cdn_flush_identifier_27,
  t11.cdn_flush_at AS cdn_flush_at_28,
  t11.cdn_status AS cdn_status_29,
  t11.updated_at AS updated_at_30,
  t11.created_at AS created_at_31,
  t11.uuid AS uuid_32,
  t11.id AS id_33,
  t0.entityType
FROM
  valueinshop_group t0
  LEFT JOIN valueinshop_media t11 ON t0.image_id = t11.id
WHERE
  t0.parent_id IS NULL
  AND t0.entityType IN ('group')
  AND (
    (t0.deleted = 0)
  )
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.deleted AS deleted_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.title AS title_6, t0.parent_id AS parent_id_7, t0.product_selector_id AS product_selector_id_8, t0.image_id AS image_id_9, t11.name AS name_10, t11.description AS description_12, t11.enabled AS enabled_13, t11.provider_name AS provider_name_14, t11.provider_status AS provider_status_15, t11.provider_reference AS provider_reference_16, t11.provider_metadata AS provider_metadata_17, t11.width AS width_18, t11.height AS height_19, t11.length AS length_20, t11.content_type AS content_type_21, t11.content_size AS content_size_22, t11.copyright AS copyright_23, t11.author_name AS author_name_24, t11.context AS context_25, t11.cdn_is_flushable AS cdn_is_flushable_26, t11.cdn_flush_identifier AS cdn_flush_identifier_27, t11.cdn_flush_at AS cdn_flush_at_28, t11.cdn_status AS cdn_status_29, t11.updated_at AS updated_at_30, t11.created_at AS created_at_31, t11.uuid AS uuid_32, t11.id AS id_33, t0.entityType FROM valueinshop_group t0 LEFT JOIN valueinshop_media t11 ON t0.image_id = t11.id WHERE t0.parent_id IS NULL AND t0.entityType IN ('group') AND ((t0.deleted = 0)) ORDER BY t0.title ASC;

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.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.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.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_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));

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));