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.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 = '1' 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.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.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 = 1 AND t0.language = 'en' 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.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.id = ?
  AND t0.entityType IN ('group')
  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.id = '1' AND t0.entityType IN ('group') AND ((t0.deleted = 0));

SELECT
  t0.short_description AS short_description_1,
  t0.rating AS rating_2,
  t0.sku AS sku_3,
  t0.position AS position_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,
  t0.uuid AS uuid_10,
  t0.title AS title_11,
  t0.description AS description_12,
  t0.product_type AS product_type_13,
  t0.provider_id AS provider_id_14,
  t0.tax_class_id AS tax_class_id_15,
  t0.upgrade_products_id AS upgrade_products_id_16,
  t0.downgrade_products_id AS downgrade_products_id_17,
  t0.included_products_id AS included_products_id_18,
  t0.excluded_products_id AS excluded_products_id_19,
  t0.related_product_id AS related_product_id_20,
  t0.gallery_id AS gallery_id_21,
  t0.subscription_strategy_override_id AS subscription_strategy_override_id_22,
  t0.shipping_strategy_id AS shipping_strategy_id_23,
  t0.product_options_id AS product_options_id_24,
  t0.image_id AS image_id_25,
  t27.name AS name_26,
  t27.description AS description_28,
  t27.enabled AS enabled_29,
  t27.provider_name AS provider_name_30,
  t27.provider_status AS provider_status_31,
  t27.provider_reference AS provider_reference_32,
  t27.provider_metadata AS provider_metadata_33,
  t27.width AS width_34,
  t27.height AS height_35,
  t27.length AS length_36,
  t27.content_type AS content_type_37,
  t27.content_size AS content_size_38,
  t27.copyright AS copyright_39,
  t27.author_name AS author_name_40,
  t27.context AS context_41,
  t27.cdn_is_flushable AS cdn_is_flushable_42,
  t27.cdn_flush_identifier AS cdn_flush_identifier_43,
  t27.cdn_flush_at AS cdn_flush_at_44,
  t27.cdn_status AS cdn_status_45,
  t27.updated_at AS updated_at_46,
  t27.created_at AS created_at_47,
  t27.uuid AS uuid_48,
  t27.id AS id_49,
  t0.entityType
FROM
  valueinshop_product t0
  LEFT JOIN valueinshop_media t27 ON t0.image_id = t27.id
WHERE
  t0.id = ?
  AND t0.entityType IN ('product')
  AND (
    (
      t0.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.short_description AS short_description_1, t0.rating AS rating_2, t0.sku AS sku_3, t0.position AS position_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, t0.uuid AS uuid_10, t0.title AS title_11, t0.description AS description_12, t0.product_type AS product_type_13, t0.provider_id AS provider_id_14, t0.tax_class_id AS tax_class_id_15, t0.upgrade_products_id AS upgrade_products_id_16, t0.downgrade_products_id AS downgrade_products_id_17, t0.included_products_id AS included_products_id_18, t0.excluded_products_id AS excluded_products_id_19, t0.related_product_id AS related_product_id_20, t0.gallery_id AS gallery_id_21, t0.subscription_strategy_override_id AS subscription_strategy_override_id_22, t0.shipping_strategy_id AS shipping_strategy_id_23, t0.product_options_id AS product_options_id_24, t0.image_id AS image_id_25, t27.name AS name_26, t27.description AS description_28, t27.enabled AS enabled_29, t27.provider_name AS provider_name_30, t27.provider_status AS provider_status_31, t27.provider_reference AS provider_reference_32, t27.provider_metadata AS provider_metadata_33, t27.width AS width_34, t27.height AS height_35, t27.length AS length_36, t27.content_type AS content_type_37, t27.content_size AS content_size_38, t27.copyright AS copyright_39, t27.author_name AS author_name_40, t27.context AS context_41, t27.cdn_is_flushable AS cdn_is_flushable_42, t27.cdn_flush_identifier AS cdn_flush_identifier_43, t27.cdn_flush_at AS cdn_flush_at_44, t27.cdn_status AS cdn_status_45, t27.updated_at AS updated_at_46, t27.created_at AS created_at_47, t27.uuid AS uuid_48, t27.id AS id_49, t0.entityType FROM valueinshop_product t0 LEFT JOIN valueinshop_media t27 ON t0.image_id = t27.id WHERE t0.id = 1 AND t0.entityType IN ('product') AND ((t0.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.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.short_description AS short_description_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.title AS title_8,
  t0.description AS description_9,
  t0.source_id AS source_id_10,
  t0.gallery_id AS gallery_id_11,
  t0.image_id AS image_id_12,
  t13.name AS name_14,
  t13.description AS description_15,
  t13.enabled AS enabled_16,
  t13.provider_name AS provider_name_17,
  t13.provider_status AS provider_status_18,
  t13.provider_reference AS provider_reference_19,
  t13.provider_metadata AS provider_metadata_20,
  t13.width AS width_21,
  t13.height AS height_22,
  t13.length AS length_23,
  t13.content_type AS content_type_24,
  t13.content_size AS content_size_25,
  t13.copyright AS copyright_26,
  t13.author_name AS author_name_27,
  t13.context AS context_28,
  t13.cdn_is_flushable AS cdn_is_flushable_29,
  t13.cdn_flush_identifier AS cdn_flush_identifier_30,
  t13.cdn_flush_at AS cdn_flush_at_31,
  t13.cdn_status AS cdn_status_32,
  t13.updated_at AS updated_at_33,
  t13.created_at AS created_at_34,
  t13.uuid AS uuid_35,
  t13.id AS id_36
FROM
  valueinshop_product_translation t0
  LEFT JOIN valueinshop_media t13 ON t0.image_id = t13.id
WHERE
  t0.source_id = ?
  AND t0.language = ?
  AND (
    (t0.deleted = 0)
  )
LIMIT
  1

SELECT t0.short_description AS short_description_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.title AS title_8, t0.description AS description_9, t0.source_id AS source_id_10, t0.gallery_id AS gallery_id_11, t0.image_id AS image_id_12, t13.name AS name_14, t13.description AS description_15, t13.enabled AS enabled_16, t13.provider_name AS provider_name_17, t13.provider_status AS provider_status_18, t13.provider_reference AS provider_reference_19, t13.provider_metadata AS provider_metadata_20, t13.width AS width_21, t13.height AS height_22, t13.length AS length_23, t13.content_type AS content_type_24, t13.content_size AS content_size_25, t13.copyright AS copyright_26, t13.author_name AS author_name_27, t13.context AS context_28, t13.cdn_is_flushable AS cdn_is_flushable_29, t13.cdn_flush_identifier AS cdn_flush_identifier_30, t13.cdn_flush_at AS cdn_flush_at_31, t13.cdn_status AS cdn_status_32, t13.updated_at AS updated_at_33, t13.created_at AS created_at_34, t13.uuid AS uuid_35, t13.id AS id_36 FROM valueinshop_product_translation t0 LEFT JOIN valueinshop_media t13 ON t0.image_id = t13.id WHERE t0.source_id = 1 AND t0.language = 'en' AND ((t0.deleted = 0)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.label AS label_3,
  t0.custom_field_name AS custom_field_name_4,
  t0.options AS options_5,
  t0.required AS required_6,
  t0.hidden AS hidden_7,
  t0.default_value AS default_value_8,
  t0.min_date AS min_date_9,
  t0.min_date_enabled AS min_date_enabled_10,
  t0.max_date AS max_date_11,
  t0.max_date_enabled AS max_date_enabled_12,
  t0.default_date AS default_date_13,
  t0.default_date_enabled AS default_date_enabled_14,
  t0.uuid AS uuid_15,
  t0.product_rate_plan_id AS product_rate_plan_id_16
FROM
  valueinshop_product_rate_plan_question t0
WHERE
  t0.product_rate_plan_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.custom_field_name AS custom_field_name_4, t0.options AS options_5, t0.required AS required_6, t0.hidden AS hidden_7, t0.default_value AS default_value_8, t0.min_date AS min_date_9, t0.min_date_enabled AS min_date_enabled_10, t0.max_date AS max_date_11, t0.max_date_enabled AS max_date_enabled_12, t0.default_date AS default_date_13, t0.default_date_enabled AS default_date_enabled_14, t0.uuid AS uuid_15, t0.product_rate_plan_id AS product_rate_plan_id_16 FROM valueinshop_product_rate_plan_question t0 WHERE t0.product_rate_plan_id = 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.uuid AS uuid_6
FROM
  valueinshop_product_selector 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.uuid AS uuid_6 FROM valueinshop_product_selector t0 WHERE t0.id = 5 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
  INNER JOIN valueinshop_product_selector_product ON t0.id = valueinshop_product_selector_product.product_rate_plan_id
WHERE
  valueinshop_product_selector_product.product_selector_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)
  )
ORDER BY
  t0.title ASC

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 INNER JOIN valueinshop_product_selector_product ON t0.id = valueinshop_product_selector_product.product_rate_plan_id WHERE valueinshop_product_selector_product.product_selector_id = 5 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)) ORDER BY t0.title ASC;

SELECT
  t0.priority AS priority_1,
  t0.id AS id_2,
  t0.deleted AS deleted_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.uuid AS uuid_7,
  t0.product_selector_id AS product_selector_id_8,
  t0.filter_id AS filter_id_9
FROM
  valueinshop_product_selector_ordered_filter t0
WHERE
  t0.product_selector_id = ?
  AND (
    (t0.deleted = 0)
  )
ORDER BY
  t0.priority ASC

SELECT t0.priority AS priority_1, t0.id AS id_2, t0.deleted AS deleted_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.uuid AS uuid_7, t0.product_selector_id AS product_selector_id_8, t0.filter_id AS filter_id_9 FROM valueinshop_product_selector_ordered_filter t0 WHERE t0.product_selector_id = 5 AND ((t0.deleted = 0)) ORDER BY t0.priority 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 = ?
  AND (
    (t0.deleted = 0)
  )
ORDER BY
  t0.position ASC