Symfony Profiler

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.label AS label_6,
  t0.field_group AS field_group_7,
  t0.visible_on_all_shop AS visible_on_all_shop_8,
  t0.visible_without_shop AS visible_without_shop_9,
  t0.priority AS priority_10,
  t0.scope AS scope_11,
  t0.destination AS destination_12,
  t0.custom_field_name AS custom_field_name_13,
  t0.default_value AS default_value_14,
  t0.field_type AS field_type_15,
  t0.choices AS choices_16,
  t0.self_service_behavior AS self_service_behavior_17,
  t0.customer_care_behavior AS customer_care_behavior_18
FROM
  valueinshop_custom_fields t0
WHERE
  (
    (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.label AS label_6, t0.field_group AS field_group_7, t0.visible_on_all_shop AS visible_on_all_shop_8, t0.visible_without_shop AS visible_without_shop_9, t0.priority AS priority_10, t0.scope AS scope_11, t0.destination AS destination_12, t0.custom_field_name AS custom_field_name_13, t0.default_value AS default_value_14, t0.field_type AS field_type_15, t0.choices AS choices_16, t0.self_service_behavior AS self_service_behavior_17, t0.customer_care_behavior AS customer_care_behavior_18 FROM valueinshop_custom_fields t0 WHERE ((t0.deleted = 0));

SELECT
  v0_.id AS id_0,
  v0_.deleted AS deleted_1,
  v0_.created_at AS created_at_2,
  v0_.updated_at AS updated_at_3,
  v0_.deleted_at AS deleted_at_4,
  v0_.name AS name_5,
  v0_.is_default AS is_default_6,
  v0_.is_displayed AS is_displayed_7,
  v0_.commissioning_method AS commissioning_method_8,
  v0_.subscription_separation_level AS subscription_separation_level_9,
  v0_.contract_effective_date AS contract_effective_date_10,
  v0_.service_activation_date AS service_activation_date_11,
  v0_.customer_acceptance_date AS customer_acceptance_date_12,
  v0_.term_start_date AS term_start_date_13,
  v0_.invoice_target_date AS invoice_target_date_14,
  v0_.invoice_target_date_preview AS invoice_target_date_preview_15,
  v0_.term_type AS term_type_16,
  v0_.initial_term AS initial_term_17,
  v0_.initial_term_period_type AS initial_term_period_type_18,
  v0_.auto_renew AS auto_renew_19,
  v0_.renewal_term AS renewal_term_20,
  v0_.renewal_term_period_type AS renewal_term_period_type_21,
  v0_.renewal_setting AS renewal_setting_22,
  v0_.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_23,
  v0_.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_24,
  v0_.invoice AS invoice_25,
  v0_.collect AS collect_26,
  v0_.invoice_separately AS invoice_separately_27,
  v0_.apply_credit_balance AS apply_credit_balance_28,
  v0_.renew_allow AS renew_allow_29,
  v0_.allow_change_quantity AS allow_change_quantity_30,
  v0_.renew_apply_credit_balance AS renew_apply_credit_balance_31,
  v0_.renew_collect AS renew_collect_32,
  v0_.renew_run_billing AS renew_run_billing_33,
  v0_.upgrade_policy AS upgrade_policy_34,
  v0_.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_35,
  v0_.upgrade_collect AS upgrade_collect_36,
  v0_.upgrade_run_billing AS upgrade_run_billing_37,
  v0_.downgrade_policy AS downgrade_policy_38,
  v0_.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_39,
  v0_.downgrade_collect AS downgrade_collect_40,
  v0_.downgrade_run_billing AS downgrade_run_billing_41,
  v0_.quantity_recurring_policy AS quantity_recurring_policy_42,
  v0_.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_43,
  v0_.quantity_recurring_collect AS quantity_recurring_collect_44,
  v0_.quantity_recurring_run_billing AS quantity_recurring_run_billing_45,
  v0_.quantity_one_time_policy AS quantity_one_time_policy_46,
  v0_.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_47,
  v0_.quantity_one_time_collect AS quantity_one_time_collect_48,
  v0_.quantity_one_time_run_billing AS quantity_one_time_run_billing_49,
  v0_.fixed_date AS fixed_date_50,
  v0_.renewal_date AS renewal_date_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_.id AS id_0, v0_.deleted AS deleted_1, v0_.created_at AS created_at_2, v0_.updated_at AS updated_at_3, v0_.deleted_at AS deleted_at_4, v0_.name AS name_5, v0_.is_default AS is_default_6, v0_.is_displayed AS is_displayed_7, v0_.commissioning_method AS commissioning_method_8, v0_.subscription_separation_level AS subscription_separation_level_9, v0_.contract_effective_date AS contract_effective_date_10, v0_.service_activation_date AS service_activation_date_11, v0_.customer_acceptance_date AS customer_acceptance_date_12, v0_.term_start_date AS term_start_date_13, v0_.invoice_target_date AS invoice_target_date_14, v0_.invoice_target_date_preview AS invoice_target_date_preview_15, v0_.term_type AS term_type_16, v0_.initial_term AS initial_term_17, v0_.initial_term_period_type AS initial_term_period_type_18, v0_.auto_renew AS auto_renew_19, v0_.renewal_term AS renewal_term_20, v0_.renewal_term_period_type AS renewal_term_period_type_21, v0_.renewal_setting AS renewal_setting_22, v0_.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_23, v0_.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_24, v0_.invoice AS invoice_25, v0_.collect AS collect_26, v0_.invoice_separately AS invoice_separately_27, v0_.apply_credit_balance AS apply_credit_balance_28, v0_.renew_allow AS renew_allow_29, v0_.allow_change_quantity AS allow_change_quantity_30, v0_.renew_apply_credit_balance AS renew_apply_credit_balance_31, v0_.renew_collect AS renew_collect_32, v0_.renew_run_billing AS renew_run_billing_33, v0_.upgrade_policy AS upgrade_policy_34, v0_.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_35, v0_.upgrade_collect AS upgrade_collect_36, v0_.upgrade_run_billing AS upgrade_run_billing_37, v0_.downgrade_policy AS downgrade_policy_38, v0_.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_39, v0_.downgrade_collect AS downgrade_collect_40, v0_.downgrade_run_billing AS downgrade_run_billing_41, v0_.quantity_recurring_policy AS quantity_recurring_policy_42, v0_.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_43, v0_.quantity_recurring_collect AS quantity_recurring_collect_44, v0_.quantity_recurring_run_billing AS quantity_recurring_run_billing_45, v0_.quantity_one_time_policy AS quantity_one_time_policy_46, v0_.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_47, v0_.quantity_one_time_collect AS quantity_one_time_collect_48, v0_.quantity_one_time_run_billing AS quantity_one_time_run_billing_49, v0_.fixed_date AS fixed_date_50, v0_.renewal_date AS renewal_date_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.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.name AS name_6,
  t0.is_default AS is_default_7,
  t0.is_displayed AS is_displayed_8,
  t0.commissioning_method AS commissioning_method_9,
  t0.subscription_separation_level AS subscription_separation_level_10,
  t0.contract_effective_date AS contract_effective_date_11,
  t0.service_activation_date AS service_activation_date_12,
  t0.customer_acceptance_date AS customer_acceptance_date_13,
  t0.term_start_date AS term_start_date_14,
  t0.invoice_target_date AS invoice_target_date_15,
  t0.invoice_target_date_preview AS invoice_target_date_preview_16,
  t0.term_type AS term_type_17,
  t0.initial_term AS initial_term_18,
  t0.initial_term_period_type AS initial_term_period_type_19,
  t0.auto_renew AS auto_renew_20,
  t0.renewal_term AS renewal_term_21,
  t0.renewal_term_period_type AS renewal_term_period_type_22,
  t0.renewal_setting AS renewal_setting_23,
  t0.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_24,
  t0.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_25,
  t0.invoice AS invoice_26,
  t0.collect AS collect_27,
  t0.invoice_separately AS invoice_separately_28,
  t0.apply_credit_balance AS apply_credit_balance_29,
  t0.renew_allow AS renew_allow_30,
  t0.allow_change_quantity AS allow_change_quantity_31,
  t0.renew_apply_credit_balance AS renew_apply_credit_balance_32,
  t0.renew_collect AS renew_collect_33,
  t0.renew_run_billing AS renew_run_billing_34,
  t0.upgrade_policy AS upgrade_policy_35,
  t0.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_36,
  t0.upgrade_collect AS upgrade_collect_37,
  t0.upgrade_run_billing AS upgrade_run_billing_38,
  t0.downgrade_policy AS downgrade_policy_39,
  t0.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_40,
  t0.downgrade_collect AS downgrade_collect_41,
  t0.downgrade_run_billing AS downgrade_run_billing_42,
  t0.quantity_recurring_policy AS quantity_recurring_policy_43,
  t0.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_44,
  t0.quantity_recurring_collect AS quantity_recurring_collect_45,
  t0.quantity_recurring_run_billing AS quantity_recurring_run_billing_46,
  t0.quantity_one_time_policy AS quantity_one_time_policy_47,
  t0.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_48,
  t0.quantity_one_time_collect AS quantity_one_time_collect_49,
  t0.quantity_one_time_run_billing AS quantity_one_time_run_billing_50,
  t0.fixed_date AS fixed_date_51,
  t0.renewal_date AS renewal_date_52,
  t0.uuid AS uuid_53
FROM
  valueinshop_subscription_strategy t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted = 0)
  )
LIMIT
  1

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.name AS name_6, t0.is_default AS is_default_7, t0.is_displayed AS is_displayed_8, t0.commissioning_method AS commissioning_method_9, t0.subscription_separation_level AS subscription_separation_level_10, t0.contract_effective_date AS contract_effective_date_11, t0.service_activation_date AS service_activation_date_12, t0.customer_acceptance_date AS customer_acceptance_date_13, t0.term_start_date AS term_start_date_14, t0.invoice_target_date AS invoice_target_date_15, t0.invoice_target_date_preview AS invoice_target_date_preview_16, t0.term_type AS term_type_17, t0.initial_term AS initial_term_18, t0.initial_term_period_type AS initial_term_period_type_19, t0.auto_renew AS auto_renew_20, t0.renewal_term AS renewal_term_21, t0.renewal_term_period_type AS renewal_term_period_type_22, t0.renewal_setting AS renewal_setting_23, t0.conditionnal_renewal_start_date AS conditionnal_renewal_start_date_24, t0.conditionnal_renewal_end_date AS conditionnal_renewal_end_date_25, t0.invoice AS invoice_26, t0.collect AS collect_27, t0.invoice_separately AS invoice_separately_28, t0.apply_credit_balance AS apply_credit_balance_29, t0.renew_allow AS renew_allow_30, t0.allow_change_quantity AS allow_change_quantity_31, t0.renew_apply_credit_balance AS renew_apply_credit_balance_32, t0.renew_collect AS renew_collect_33, t0.renew_run_billing AS renew_run_billing_34, t0.upgrade_policy AS upgrade_policy_35, t0.upgrade_apply_credit_balance AS upgrade_apply_credit_balance_36, t0.upgrade_collect AS upgrade_collect_37, t0.upgrade_run_billing AS upgrade_run_billing_38, t0.downgrade_policy AS downgrade_policy_39, t0.downgrade_apply_credit_balance AS downgrade_apply_credit_balance_40, t0.downgrade_collect AS downgrade_collect_41, t0.downgrade_run_billing AS downgrade_run_billing_42, t0.quantity_recurring_policy AS quantity_recurring_policy_43, t0.quantity_recurring_apply_credit_balance AS quantity_recurring_apply_credit_balance_44, t0.quantity_recurring_collect AS quantity_recurring_collect_45, t0.quantity_recurring_run_billing AS quantity_recurring_run_billing_46, t0.quantity_one_time_policy AS quantity_one_time_policy_47, t0.quantity_one_time_apply_credit_balance AS quantity_one_time_apply_credit_balance_48, t0.quantity_one_time_collect AS quantity_one_time_collect_49, t0.quantity_one_time_run_billing AS quantity_one_time_run_billing_50, t0.fixed_date AS fixed_date_51, t0.renewal_date AS renewal_date_52, t0.uuid AS uuid_53 FROM valueinshop_subscription_strategy t0 WHERE t0.is_default = 1 AND ((t0.deleted = 0)) LIMIT 1;

SELECT
  v0_.head_start AS head_start_0,
  v0_.head_end AS head_end_1,
  v0_.body_start AS body_start_2,
  v0_.body_end AS body_end_3
FROM
  valueinshop_html_snippet v0_
WHERE
  (v0_.enabled = 1)
  AND (v0_.deleted = 0)

SELECT v0_.head_start AS head_start_0, v0_.head_end AS head_end_1, v0_.body_start AS body_start_2, v0_.body_end AS body_end_3 FROM valueinshop_html_snippet v0_ WHERE (v0_.enabled = 1) AND (v0_.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.position AS position_6,
  t0.external_id AS external_id_7,
  t0.attributes AS attributes_8,
  t0.dynamic_pricing_setting AS dynamic_pricing_setting_9,
  t0.dynamic_pricing_file AS dynamic_pricing_file_10,
  t0.show_empty_line AS show_empty_line_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.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.position AS position_6, t0.external_id AS external_id_7, t0.attributes AS attributes_8, t0.dynamic_pricing_setting AS dynamic_pricing_setting_9, t0.dynamic_pricing_file AS dynamic_pricing_file_10, t0.show_empty_line AS show_empty_line_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 = '1' AND ((t0.deleted = 0));

SELECT
  v0_.language_code AS language_code_0,
  v0_.isDefault AS isDefault_1,
  v0_.debug AS debug_2,
  v0_.collect AS collect_3
FROM
  valueinshop_language v0_
WHERE
  (v0_.enabled = 1)
  AND (v0_.deleted = 0)

SELECT v0_.language_code AS language_code_0, v0_.isDefault AS isDefault_1, v0_.debug AS debug_2, v0_.collect AS collect_3 FROM valueinshop_language v0_ WHERE (v0_.enabled = 1) AND (v0_.deleted = 0);

SELECT
  v0_.id AS id_0,
  v0_.use_invoice_engine_preview AS use_invoice_engine_preview_1,
  v0_.context AS context_2,
  v0_.shipping_address_mode AS shipping_address_mode_3,
  v0_.billing_address_mode AS billing_address_mode_4,
  v0_.display_tax_detail AS display_tax_detail_5,
  v0_.display_discount_detail AS display_discount_detail_6,
  v0_.display_map_in_forms AS display_map_in_forms_7
FROM
  valueinshop_cart v0_

SELECT v0_.id AS id_0, v0_.use_invoice_engine_preview AS use_invoice_engine_preview_1, v0_.context AS context_2, v0_.shipping_address_mode AS shipping_address_mode_3, v0_.billing_address_mode AS billing_address_mode_4, v0_.display_tax_detail AS display_tax_detail_5, v0_.display_discount_detail AS display_discount_detail_6, v0_.display_map_in_forms AS display_map_in_forms_7 FROM valueinshop_cart v0_;

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.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.default_strategy AS default_strategy_6,
  t0.title AS title_7,
  t0.one_time_shipping AS one_time_shipping_8,
  t0.catchup AS catchup_9,
  t0.shipping_start_date AS shipping_start_date_10,
  t0.shipping_period AS shipping_period_11,
  t0.shipping_end_date AS shipping_end_date_12,
  t0.shipping_trigger AS shipping_trigger_13,
  t0.payment_failure_action AS payment_failure_action_14,
  t0.shipping_expire AS shipping_expire_15,
  t0.shipping_expiration_delay AS shipping_expiration_delay_16,
  t0.can_share_packages AS can_share_packages_17,
  t0.send_ship_order_directly AS send_ship_order_directly_18,
  t0.wait_for_validation AS wait_for_validation_19,
  t0.association_required AS association_required_20,
  t0.uuid AS uuid_21
FROM
  valueinshop_shipping_strategy t0
WHERE
  (
    (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.default_strategy AS default_strategy_6, t0.title AS title_7, t0.one_time_shipping AS one_time_shipping_8, t0.catchup AS catchup_9, t0.shipping_start_date AS shipping_start_date_10, t0.shipping_period AS shipping_period_11, t0.shipping_end_date AS shipping_end_date_12, t0.shipping_trigger AS shipping_trigger_13, t0.payment_failure_action AS payment_failure_action_14, t0.shipping_expire AS shipping_expire_15, t0.shipping_expiration_delay AS shipping_expiration_delay_16, t0.can_share_packages AS can_share_packages_17, t0.send_ship_order_directly AS send_ship_order_directly_18, t0.wait_for_validation AS wait_for_validation_19, t0.association_required AS association_required_20, t0.uuid AS uuid_21 FROM valueinshop_shipping_strategy t0 WHERE ((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.external_id AS external_id_7,
  t0.price AS price_8,
  t0.overage_price AS overage_price_9,
  t0.included_units AS included_units_10,
  t0.quantity AS quantity_11,
  t0.quantity_configuration AS quantity_configuration_12,
  t0.uom AS uom_13,
  t0.position AS position_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.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.external_id AS external_id_7, t0.price AS price_8, t0.overage_price AS overage_price_9, t0.included_units AS included_units_10, t0.quantity AS quantity_11, t0.quantity_configuration AS quantity_configuration_12, t0.uom AS uom_13, t0.position AS position_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 = 1 AND ((t0.deleted = 0)) ORDER BY t0.position 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.uom AS uom_7,
  t0.language AS language_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.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.uom AS uom_7, t0.language AS language_8, t0.source_id AS source_id_9 FROM valueinshop_product_rate_plan_charge_translation t0 WHERE t0.source_id = 1 AND t0.language = 'en' AND ((t0.deleted = 0)) LIMIT 1;

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,
  t0.fetch_email_expression AS fetch_email_expression_9
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, t0.fetch_email_expression AS fetch_email_expression_9 FROM valueinshop_config_zuora t0;

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.language AS language_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.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.language AS language_7, t0.source_id AS source_id_8 FROM valueinshop_product_rate_plan_translation t0 WHERE t0.source_id = 1 AND t0.language = 'en' AND ((t0.deleted = 0)) LIMIT 1;