Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.is_default AS is_default_2,
  t0.is_displayed AS is_displayed_3,
  t0.commissioning_method AS commissioning_method_4,
  t0.subscription_separation_level AS subscription_separation_level_5,
  t0.contract_effective_date AS contract_effective_date_6,
  t0.service_activation_date AS service_activation_date_7,
  t0.customer_acceptance_date AS customer_acceptance_date_8,
  t0.term_start_date AS term_start_date_9,
  t0.invoice_target_date AS invoice_target_date_10,
  t0.invoice_target_date_preview AS invoice_target_date_preview_11,
  t0.term_type AS term_type_12,
  t0.initial_term AS initial_term_13,
  t0.initial_term_period_type AS initial_term_period_type_14,
  t0.auto_renew AS auto_renew_15,
  t0.renewal_term AS renewal_term_16,
  t0.renewal_term_period_type AS renewal_term_period_type_17,
  t0.renewal_setting AS renewal_setting_18,
  t0.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_19,
  t0.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_20,
  t0.invoice AS invoice_21,
  t0.collect AS collect_22,
  t0.invoice_separately AS invoice_separately_23,
  t0.apply_credit_balance AS apply_credit_balance_24,
  t0.renew_allow AS renew_allow_25,
  t0.allow_change_quantity AS allow_change_quantity_26,
  t0.renew_apply_credit_balance AS renew_apply_credit_balance_27,
  t0.renew_collect AS renew_collect_28,
  t0.renew_run_billing AS renew_run_billing_29,
  t0.upgrade_policy AS upgrade_policy_30,
  t0.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_31,
  t0.upgrade_collect AS upgrade_collect_32,
  t0.upgrade_run_billing AS upgrade_run_billing_33,
  t0.downgrade_policy AS downgrade_policy_34,
  t0.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_35,
  t0.downgrade_collect AS downgrade_collect_36,
  t0.downgrade_run_billing AS downgrade_run_billing_37,
  t0.quantity_recurring_policy AS quantity_recurring_policy_38,
  t0.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_39,
  t0.quantity_recurring_collect AS quantity_recurring_collect_40,
  t0.quantity_recurring_run_billing AS quantity_recurring_run_billing_41,
  t0.quantity_one_time_policy AS quantity_one_time_policy_42,
  t0.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_43,
  t0.quantity_one_time_collect AS quantity_one_time_collect_44,
  t0.quantity_one_time_run_billing AS quantity_one_time_run_billing_45,
  t0.fixed_date AS fixed_date_46,
  t0.renewal_date AS renewal_date_47,
  t0.id AS id_48,
  t0.deleted AS deleted_49,
  t0.created_at AS created_at_50,
  t0.updated_at AS updated_at_51,
  t0.deleted_at AS deleted_at_52,
  t0.uuid AS uuid_53
FROM
  valueinshop_subscription_strategy t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted = 0)
  )
LIMIT
  1

SELECT t0.name AS name_1, t0.is_default AS is_default_2, t0.is_displayed AS is_displayed_3, t0.commissioning_method AS commissioning_method_4, t0.subscription_separation_level AS subscription_separation_level_5, t0.contract_effective_date AS contract_effective_date_6, t0.service_activation_date AS service_activation_date_7, t0.customer_acceptance_date AS customer_acceptance_date_8, t0.term_start_date AS term_start_date_9, t0.invoice_target_date AS invoice_target_date_10, t0.invoice_target_date_preview AS invoice_target_date_preview_11, t0.term_type AS term_type_12, t0.initial_term AS initial_term_13, t0.initial_term_period_type AS initial_term_period_type_14, t0.auto_renew AS auto_renew_15, t0.renewal_term AS renewal_term_16, t0.renewal_term_period_type AS renewal_term_period_type_17, t0.renewal_setting AS renewal_setting_18, t0.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_19, t0.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_20, t0.invoice AS invoice_21, t0.collect AS collect_22, t0.invoice_separately AS invoice_separately_23, t0.apply_credit_balance AS apply_credit_balance_24, t0.renew_allow AS renew_allow_25, t0.allow_change_quantity AS allow_change_quantity_26, t0.renew_apply_credit_balance AS renew_apply_credit_balance_27, t0.renew_collect AS renew_collect_28, t0.renew_run_billing AS renew_run_billing_29, t0.upgrade_policy AS upgrade_policy_30, t0.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_31, t0.upgrade_collect AS upgrade_collect_32, t0.upgrade_run_billing AS upgrade_run_billing_33, t0.downgrade_policy AS downgrade_policy_34, t0.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_35, t0.downgrade_collect AS downgrade_collect_36, t0.downgrade_run_billing AS downgrade_run_billing_37, t0.quantity_recurring_policy AS quantity_recurring_policy_38, t0.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_39, t0.quantity_recurring_collect AS quantity_recurring_collect_40, t0.quantity_recurring_run_billing AS quantity_recurring_run_billing_41, t0.quantity_one_time_policy AS quantity_one_time_policy_42, t0.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_43, t0.quantity_one_time_collect AS quantity_one_time_collect_44, t0.quantity_one_time_run_billing AS quantity_one_time_run_billing_45, t0.fixed_date AS fixed_date_46, t0.renewal_date AS renewal_date_47, t0.id AS id_48, t0.deleted AS deleted_49, t0.created_at AS created_at_50, t0.updated_at AS updated_at_51, t0.deleted_at AS deleted_at_52, t0.uuid AS uuid_53 FROM valueinshop_subscription_strategy t0 WHERE t0.is_default = 1 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
  v0_.name AS name_0,
  v0_.is_default AS is_default_1,
  v0_.is_displayed AS is_displayed_2,
  v0_.commissioning_method AS commissioning_method_3,
  v0_.subscription_separation_level AS subscription_separation_level_4,
  v0_.contract_effective_date AS contract_effective_date_5,
  v0_.service_activation_date AS service_activation_date_6,
  v0_.customer_acceptance_date AS customer_acceptance_date_7,
  v0_.term_start_date AS term_start_date_8,
  v0_.invoice_target_date AS invoice_target_date_9,
  v0_.invoice_target_date_preview AS invoice_target_date_preview_10,
  v0_.term_type AS term_type_11,
  v0_.initial_term AS initial_term_12,
  v0_.initial_term_period_type AS initial_term_period_type_13,
  v0_.auto_renew AS auto_renew_14,
  v0_.renewal_term AS renewal_term_15,
  v0_.renewal_term_period_type AS renewal_term_period_type_16,
  v0_.renewal_setting AS renewal_setting_17,
  v0_.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_18,
  v0_.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_19,
  v0_.invoice AS invoice_20,
  v0_.collect AS collect_21,
  v0_.invoice_separately AS invoice_separately_22,
  v0_.apply_credit_balance AS apply_credit_balance_23,
  v0_.renew_allow AS renew_allow_24,
  v0_.allow_change_quantity AS allow_change_quantity_25,
  v0_.renew_apply_credit_balance AS renew_apply_credit_balance_26,
  v0_.renew_collect AS renew_collect_27,
  v0_.renew_run_billing AS renew_run_billing_28,
  v0_.upgrade_policy AS upgrade_policy_29,
  v0_.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_30,
  v0_.upgrade_collect AS upgrade_collect_31,
  v0_.upgrade_run_billing AS upgrade_run_billing_32,
  v0_.downgrade_policy AS downgrade_policy_33,
  v0_.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_34,
  v0_.downgrade_collect AS downgrade_collect_35,
  v0_.downgrade_run_billing AS downgrade_run_billing_36,
  v0_.quantity_recurring_policy AS quantity_recurring_policy_37,
  v0_.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_38,
  v0_.quantity_recurring_collect AS quantity_recurring_collect_39,
  v0_.quantity_recurring_run_billing AS quantity_recurring_run_billing_40,
  v0_.quantity_one_time_policy AS quantity_one_time_policy_41,
  v0_.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_42,
  v0_.quantity_one_time_collect AS quantity_one_time_collect_43,
  v0_.quantity_one_time_run_billing AS quantity_one_time_run_billing_44,
  v0_.fixed_date AS fixed_date_45,
  v0_.renewal_date AS renewal_date_46,
  v0_.id AS id_47,
  v0_.deleted AS deleted_48,
  v0_.created_at AS created_at_49,
  v0_.updated_at AS updated_at_50,
  v0_.deleted_at AS deleted_at_51,
  v0_.uuid AS uuid_52
FROM
  valueinshop_subscription_strategy v0_
WHERE
  (v0_.is_displayed = 1)
  AND (v0_.deleted = 0)
ORDER BY
  v0_.name ASC

SELECT v0_.name AS name_0, v0_.is_default AS is_default_1, v0_.is_displayed AS is_displayed_2, v0_.commissioning_method AS commissioning_method_3, v0_.subscription_separation_level AS subscription_separation_level_4, v0_.contract_effective_date AS contract_effective_date_5, v0_.service_activation_date AS service_activation_date_6, v0_.customer_acceptance_date AS customer_acceptance_date_7, v0_.term_start_date AS term_start_date_8, v0_.invoice_target_date AS invoice_target_date_9, v0_.invoice_target_date_preview AS invoice_target_date_preview_10, v0_.term_type AS term_type_11, v0_.initial_term AS initial_term_12, v0_.initial_term_period_type AS initial_term_period_type_13, v0_.auto_renew AS auto_renew_14, v0_.renewal_term AS renewal_term_15, v0_.renewal_term_period_type AS renewal_term_period_type_16, v0_.renewal_setting AS renewal_setting_17, v0_.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_18, v0_.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_19, v0_.invoice AS invoice_20, v0_.collect AS collect_21, v0_.invoice_separately AS invoice_separately_22, v0_.apply_credit_balance AS apply_credit_balance_23, v0_.renew_allow AS renew_allow_24, v0_.allow_change_quantity AS allow_change_quantity_25, v0_.renew_apply_credit_balance AS renew_apply_credit_balance_26, v0_.renew_collect AS renew_collect_27, v0_.renew_run_billing AS renew_run_billing_28, v0_.upgrade_policy AS upgrade_policy_29, v0_.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_30, v0_.upgrade_collect AS upgrade_collect_31, v0_.upgrade_run_billing AS upgrade_run_billing_32, v0_.downgrade_policy AS downgrade_policy_33, v0_.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_34, v0_.downgrade_collect AS downgrade_collect_35, v0_.downgrade_run_billing AS downgrade_run_billing_36, v0_.quantity_recurring_policy AS quantity_recurring_policy_37, v0_.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_38, v0_.quantity_recurring_collect AS quantity_recurring_collect_39, v0_.quantity_recurring_run_billing AS quantity_recurring_run_billing_40, v0_.quantity_one_time_policy AS quantity_one_time_policy_41, v0_.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_42, v0_.quantity_one_time_collect AS quantity_one_time_collect_43, v0_.quantity_one_time_run_billing AS quantity_one_time_run_billing_44, v0_.fixed_date AS fixed_date_45, v0_.renewal_date AS renewal_date_46, v0_.id AS id_47, v0_.deleted AS deleted_48, v0_.created_at AS created_at_49, v0_.updated_at AS updated_at_50, v0_.deleted_at AS deleted_at_51, v0_.uuid AS uuid_52 FROM valueinshop_subscription_strategy v0_ WHERE (v0_.is_displayed = 1) AND (v0_.deleted = 0) ORDER BY v0_.name ASC;

SELECT
  t0.username AS username_1,
  t0.prefix_url AS prefix_url_2,
  t0.tennant_id AS tennant_id_3,
  t0.country_code AS country_code_4,
  t0.id AS id_5,
  t0.password AS password_6,
  t0.execution_level AS execution_level_7,
  t0.preview_charge_prefix AS preview_charge_prefix_8
FROM
  valueinshop_config_zuora t0

SELECT t0.username AS username_1, t0.prefix_url AS prefix_url_2, t0.tennant_id AS tennant_id_3, t0.country_code AS country_code_4, t0.id AS id_5, t0.password AS password_6, t0.execution_level AS execution_level_7, t0.preview_charge_prefix AS preview_charge_prefix_8 FROM valueinshop_config_zuora t0;

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.title AS title_1,
  t0.uom AS uom_2,
  t0.language AS language_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.source_id AS source_id_9
FROM
  valueinshop_product_rate_plan_charge_translation t0
WHERE
  t0.source_id = ?
  AND t0.language = ?
  AND (
    (t0.deleted = 0)
  )
LIMIT
  1

SELECT t0.title AS title_1, t0.uom AS uom_2, t0.language AS language_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.source_id AS source_id_9 FROM valueinshop_product_rate_plan_charge_translation t0 WHERE t0.source_id = 3 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.default_strategy AS default_strategy_1,
  t0.title AS title_2,
  t0.one_time_shipping AS one_time_shipping_3,
  t0.catchup AS catchup_4,
  t0.shipping_start_date AS shipping_start_date_5,
  t0.shipping_period AS shipping_period_6,
  t0.shipping_end_date AS shipping_end_date_7,
  t0.shipping_trigger AS shipping_trigger_8,
  t0.payment_failure_action AS payment_failure_action_9,
  t0.shipping_expire AS shipping_expire_10,
  t0.shipping_expiration_delay AS shipping_expiration_delay_11,
  t0.can_share_packages AS can_share_packages_12,
  t0.send_ship_order_directly AS send_ship_order_directly_13,
  t0.wait_for_validation AS wait_for_validation_14,
  t0.association_required AS association_required_15,
  t0.id AS id_16,
  t0.deleted AS deleted_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.deleted_at AS deleted_at_20,
  t0.uuid AS uuid_21
FROM
  valueinshop_shipping_strategy t0
WHERE
  (
    (t0.deleted = 0)
  )

SELECT t0.default_strategy AS default_strategy_1, t0.title AS title_2, t0.one_time_shipping AS one_time_shipping_3, t0.catchup AS catchup_4, t0.shipping_start_date AS shipping_start_date_5, t0.shipping_period AS shipping_period_6, t0.shipping_end_date AS shipping_end_date_7, t0.shipping_trigger AS shipping_trigger_8, t0.payment_failure_action AS payment_failure_action_9, t0.shipping_expire AS shipping_expire_10, t0.shipping_expiration_delay AS shipping_expiration_delay_11, t0.can_share_packages AS can_share_packages_12, t0.send_ship_order_directly AS send_ship_order_directly_13, t0.wait_for_validation AS wait_for_validation_14, t0.association_required AS association_required_15, t0.id AS id_16, t0.deleted AS deleted_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.deleted_at AS deleted_at_20, t0.uuid AS uuid_21 FROM valueinshop_shipping_strategy 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.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.allowed_shipping_country AS allowed_shipping_country_1,
  t0.allowed_billing_country AS allowed_billing_country_2,
  t0.allowed_global_document AS allowed_global_document_3,
  t0.currency AS currency_4,
  t0.id AS id_5,
  t0.deleted AS deleted_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9
FROM
  valueinshop_shop_internationalization t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted = 0)
  )

SELECT t0.allowed_shipping_country AS allowed_shipping_country_1, t0.allowed_billing_country AS allowed_billing_country_2, t0.allowed_global_document AS allowed_global_document_3, t0.currency AS currency_4, t0.id AS id_5, t0.deleted AS deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM valueinshop_shop_internationalization t0 WHERE t0.id = 3 AND ((t0.deleted = 0));

SELECT
  t0.position AS position_1,
  t0.external_id AS external_id_2,
  t0.attributes AS attributes_3,
  t0.dynamic_pricing_setting AS dynamic_pricing_setting_4,
  t0.dynamic_pricing_file AS dynamic_pricing_file_5,
  t0.show_empty_line AS show_empty_line_6,
  t0.id AS id_7,
  t0.deleted AS deleted_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.deleted_at AS deleted_at_11,
  t0.uuid AS uuid_12,
  t0.title AS title_13,
  t0.publish_start_date AS publish_start_date_14,
  t0.publish_end_date AS publish_end_date_15,
  t0.product_id AS product_id_16,
  t0.subscription_strategy_override_id AS subscription_strategy_override_id_17,
  t0.offer_id AS offer_id_18
FROM
  valueinshop_product_rate_plan t0
WHERE
  t0.id = ?
  AND (
    (
      t0.product_id IN (
        SELECT
          product_id
        FROM
          valueinshop_shop_product
        WHERE
          shop_id = 3
      )
      OR (
        SELECT
          COUNT(product_id)
        FROM
          valueinshop_shop_product
        WHERE
          shop_id = 3
      )= 0
    )
    AND (t0.deleted = 0)
  )

SELECT t0.position AS position_1, t0.external_id AS external_id_2, t0.attributes AS attributes_3, t0.dynamic_pricing_setting AS dynamic_pricing_setting_4, t0.dynamic_pricing_file AS dynamic_pricing_file_5, t0.show_empty_line AS show_empty_line_6, t0.id AS id_7, t0.deleted AS deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.uuid AS uuid_12, t0.title AS title_13, t0.publish_start_date AS publish_start_date_14, t0.publish_end_date AS publish_end_date_15, t0.product_id AS product_id_16, t0.subscription_strategy_override_id AS subscription_strategy_override_id_17, t0.offer_id AS offer_id_18 FROM valueinshop_product_rate_plan t0 WHERE t0.id = '2' AND ((t0.product_id IN (SELECT product_id FROM valueinshop_shop_product WHERE shop_id=3) OR (SELECT COUNT(product_id) FROM valueinshop_shop_product WHERE shop_id=3)=0) 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.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.external_id AS external_id_2,
  t0.price AS price_3,
  t0.overage_price AS overage_price_4,
  t0.included_units AS included_units_5,
  t0.quantity AS quantity_6,
  t0.quantity_configuration AS quantity_configuration_7,
  t0.uom AS uom_8,
  t0.position AS position_9,
  t0.id AS id_10,
  t0.deleted AS deleted_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.uuid AS uuid_15,
  t0.description AS description_16,
  t0.rate_plan_id AS rate_plan_id_17
FROM
  valueinshop_product_rate_plan_charge t0
WHERE
  t0.rate_plan_id = ?
  AND (
    (t0.deleted = 0)
  )
ORDER BY
  t0.position ASC

SELECT t0.title AS title_1, t0.external_id AS external_id_2, t0.price AS price_3, t0.overage_price AS overage_price_4, t0.included_units AS included_units_5, t0.quantity AS quantity_6, t0.quantity_configuration AS quantity_configuration_7, t0.uom AS uom_8, t0.position AS position_9, t0.id AS id_10, t0.deleted AS deleted_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.uuid AS uuid_15, t0.description AS description_16, t0.rate_plan_id AS rate_plan_id_17 FROM valueinshop_product_rate_plan_charge t0 WHERE t0.rate_plan_id = 2 AND ((t0.deleted = 0)) ORDER BY t0.position ASC;

SELECT
  t0.title AS title_1,
  t0.language AS language_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.source_id AS source_id_8
FROM
  valueinshop_product_rate_plan_translation t0
WHERE
  t0.source_id = ?
  AND t0.language = ?
  AND (
    (t0.deleted = 0)
  )
LIMIT
  1

SELECT t0.title AS title_1, t0.language AS language_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.source_id AS source_id_8 FROM valueinshop_product_rate_plan_translation t0 WHERE t0.source_id = 2 AND t0.language = 'en' 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));