Symfony Profiler

Query Metrics

40 Database Queries

30 Different statements

8.10 ms Query time

0 Invalid entities

15 Managed entities

Queries


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 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.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.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.parent_id AS parent_id_7, t0.product_selector_id AS product_selector_id_8, t0.image_id AS image_id_9, t10.name AS name_11, t10.description AS description_12, t10.enabled AS enabled_13, t10.provider_name AS provider_name_14, t10.provider_status AS provider_status_15, t10.provider_reference AS provider_reference_16, t10.provider_metadata AS provider_metadata_17, t10.width AS width_18, t10.height AS height_19, t10.length AS length_20, t10.content_type AS content_type_21, t10.content_size AS content_size_22, t10.copyright AS copyright_23, t10.author_name AS author_name_24, t10.context AS context_25, t10.cdn_is_flushable AS cdn_is_flushable_26, t10.cdn_flush_identifier AS cdn_flush_identifier_27, t10.cdn_flush_at AS cdn_flush_at_28, t10.cdn_status AS cdn_status_29, t10.updated_at AS updated_at_30, t10.created_at AS created_at_31, t10.uuid AS uuid_32, t10.id AS id_33, t0.entityType FROM valueinshop_group t0 LEFT JOIN valueinshop_media t10 ON t0.image_id = t10.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.short_description AS short_description_6, t0.rating AS rating_7, t0.sku AS sku_8, t0.position AS position_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, t26.name AS name_27, t26.description AS description_28, t26.enabled AS enabled_29, t26.provider_name AS provider_name_30, t26.provider_status AS provider_status_31, t26.provider_reference AS provider_reference_32, t26.provider_metadata AS provider_metadata_33, t26.width AS width_34, t26.height AS height_35, t26.length AS length_36, t26.content_type AS content_type_37, t26.content_size AS content_size_38, t26.copyright AS copyright_39, t26.author_name AS author_name_40, t26.context AS context_41, t26.cdn_is_flushable AS cdn_is_flushable_42, t26.cdn_flush_identifier AS cdn_flush_identifier_43, t26.cdn_flush_at AS cdn_flush_at_44, t26.cdn_status AS cdn_status_45, t26.updated_at AS updated_at_46, t26.created_at AS created_at_47, t26.uuid AS uuid_48, t26.id AS id_49, t0.entityType FROM valueinshop_product t0 LEFT JOIN valueinshop_media t26 ON t0.image_id = t26.id WHERE t0.id = ? AND t0.entityType IN ('product') 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.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.short_description AS short_description_6, t0.language AS language_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.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.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.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 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.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.priority AS priority_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.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.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.min_quantity AS min_quantity_6, t0.max_quantity AS max_quantity_7, t0.value AS value_8, t0.currency AS currency_9, t0.operation AS operation_10, t0.position AS position_11, t0.uuid AS uuid_12, t0.rate_plan_charge_id AS rate_plan_charge_id_13 FROM valueinshop_product_rate_plan_charge_price t0 WHERE t0.rate_plan_charge_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.name AS name_6, t0.uuid AS uuid_7 FROM valueinshop_product_tax_class 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.country AS country_6, t0.starting_date AS starting_date_7, t0.tax_rate AS tax_rate_8, t0.uuid AS uuid_9, t0.tax_class_id AS tax_class_id_10 FROM valueinshop_tax_rates t0 WHERE t0.tax_class_id = ? AND ((t0.deleted = 0)) ORDER BY t0.starting_date 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.uuid AS uuid_6, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override 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, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override 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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.strategy_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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_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 = ? 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 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.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.priority AS priority_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.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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_datetime t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_float t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_int t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_json t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_string t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_stringindexed t0 WHERE t0.product_id = ? AND ((t0.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 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.cancellation_allow AS cancellation_allow_7, t0.cancellation_apply_credit_balance AS cancellation_apply_credit_balance_8, t0.cancellation_collect AS cancellation_collect_9, t0.cancellation_run_billing AS cancellation_run_billing_10, t0.cancellation_effective_date AS cancellation_effective_date_11, t0.cancellation_last_possible_date AS cancellation_last_possible_date_12, t0.cancellation_with_regularization_subscription AS cancellation_with_regularization_subscription_13, t0.cancellation_policy AS cancellation_policy_14, t0.regularization_product AS regularization_product_15, t0.uuid AS uuid_16, t0.subscription_strategy_id AS subscription_strategy_id_17 FROM valueinshop_subscription_strategy_cancellation t0 WHERE t0.subscription_strategy_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.name AS name_6, t0.value AS value_7, t0.target_object AS target_object_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.shop_id AS shop_id_11 FROM valueinshop_custom_field_subscription_strategy t0 WHERE t0.strategy_id = ? AND ((t0.deleted = 0))
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.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.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.priority AS priority_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.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 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.deleted = 0)) ORDER BY t0.title ASC

#▲	Time	Info
1	0.23 ms	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) Parameters: [] View formatted query View runnable query Explain query 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);
2	0.24 ms	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)) Parameters: [`"1"`] View formatted query View runnable query Explain query 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));
3	0.27 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
4	0.21 ms	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 Parameters: [`1 "en"`] View formatted query View runnable query Explain query 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;
5	0.20 ms	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, t10.name AS name_11, t10.description AS description_12, t10.enabled AS enabled_13, t10.provider_name AS provider_name_14, t10.provider_status AS provider_status_15, t10.provider_reference AS provider_reference_16, t10.provider_metadata AS provider_metadata_17, t10.width AS width_18, t10.height AS height_19, t10.length AS length_20, t10.content_type AS content_type_21, t10.content_size AS content_size_22, t10.copyright AS copyright_23, t10.author_name AS author_name_24, t10.context AS context_25, t10.cdn_is_flushable AS cdn_is_flushable_26, t10.cdn_flush_identifier AS cdn_flush_identifier_27, t10.cdn_flush_at AS cdn_flush_at_28, t10.cdn_status AS cdn_status_29, t10.updated_at AS updated_at_30, t10.created_at AS created_at_31, t10.uuid AS uuid_32, t10.id AS id_33, t0.entityType FROM valueinshop_group t0 LEFT JOIN valueinshop_media t10 ON t0.image_id = t10.id WHERE t0.id = ? AND t0.entityType IN ('group') AND ((t0.deleted = 0)) Parameters: [`"1"`] View formatted query View runnable query Explain query 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, t10.name AS name_11, t10.description AS description_12, t10.enabled AS enabled_13, t10.provider_name AS provider_name_14, t10.provider_status AS provider_status_15, t10.provider_reference AS provider_reference_16, t10.provider_metadata AS provider_metadata_17, t10.width AS width_18, t10.height AS height_19, t10.length AS length_20, t10.content_type AS content_type_21, t10.content_size AS content_size_22, t10.copyright AS copyright_23, t10.author_name AS author_name_24, t10.context AS context_25, t10.cdn_is_flushable AS cdn_is_flushable_26, t10.cdn_flush_identifier AS cdn_flush_identifier_27, t10.cdn_flush_at AS cdn_flush_at_28, t10.cdn_status AS cdn_status_29, t10.updated_at AS updated_at_30, t10.created_at AS created_at_31, t10.uuid AS uuid_32, t10.id AS id_33, t0.entityType FROM valueinshop_group t0 LEFT JOIN valueinshop_media t10 ON t0.image_id = t10.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, t10.name AS name_11, t10.description AS description_12, t10.enabled AS enabled_13, t10.provider_name AS provider_name_14, t10.provider_status AS provider_status_15, t10.provider_reference AS provider_reference_16, t10.provider_metadata AS provider_metadata_17, t10.width AS width_18, t10.height AS height_19, t10.length AS length_20, t10.content_type AS content_type_21, t10.content_size AS content_size_22, t10.copyright AS copyright_23, t10.author_name AS author_name_24, t10.context AS context_25, t10.cdn_is_flushable AS cdn_is_flushable_26, t10.cdn_flush_identifier AS cdn_flush_identifier_27, t10.cdn_flush_at AS cdn_flush_at_28, t10.cdn_status AS cdn_status_29, t10.updated_at AS updated_at_30, t10.created_at AS created_at_31, t10.uuid AS uuid_32, t10.id AS id_33, t0.entityType FROM valueinshop_group t0 LEFT JOIN valueinshop_media t10 ON t0.image_id = t10.id WHERE t0.id = '1' AND t0.entityType IN ('group') AND ((t0.deleted = 0));
6	0.26 ms	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.short_description AS short_description_6, t0.rating AS rating_7, t0.sku AS sku_8, t0.position AS position_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, t26.name AS name_27, t26.description AS description_28, t26.enabled AS enabled_29, t26.provider_name AS provider_name_30, t26.provider_status AS provider_status_31, t26.provider_reference AS provider_reference_32, t26.provider_metadata AS provider_metadata_33, t26.width AS width_34, t26.height AS height_35, t26.length AS length_36, t26.content_type AS content_type_37, t26.content_size AS content_size_38, t26.copyright AS copyright_39, t26.author_name AS author_name_40, t26.context AS context_41, t26.cdn_is_flushable AS cdn_is_flushable_42, t26.cdn_flush_identifier AS cdn_flush_identifier_43, t26.cdn_flush_at AS cdn_flush_at_44, t26.cdn_status AS cdn_status_45, t26.updated_at AS updated_at_46, t26.created_at AS created_at_47, t26.uuid AS uuid_48, t26.id AS id_49, t0.entityType FROM valueinshop_product t0 LEFT JOIN valueinshop_media t26 ON t0.image_id = t26.id WHERE t0.id = ? AND t0.entityType IN ('product') AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.short_description AS short_description_6, t0.rating AS rating_7, t0.sku AS sku_8, t0.position AS position_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, t26.name AS name_27, t26.description AS description_28, t26.enabled AS enabled_29, t26.provider_name AS provider_name_30, t26.provider_status AS provider_status_31, t26.provider_reference AS provider_reference_32, t26.provider_metadata AS provider_metadata_33, t26.width AS width_34, t26.height AS height_35, t26.length AS length_36, t26.content_type AS content_type_37, t26.content_size AS content_size_38, t26.copyright AS copyright_39, t26.author_name AS author_name_40, t26.context AS context_41, t26.cdn_is_flushable AS cdn_is_flushable_42, t26.cdn_flush_identifier AS cdn_flush_identifier_43, t26.cdn_flush_at AS cdn_flush_at_44, t26.cdn_status AS cdn_status_45, t26.updated_at AS updated_at_46, t26.created_at AS created_at_47, t26.uuid AS uuid_48, t26.id AS id_49, t0.entityType FROM valueinshop_product t0 LEFT JOIN valueinshop_media t26 ON t0.image_id = t26.id WHERE t0.id = ? AND t0.entityType IN ('product') 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.short_description AS short_description_6, t0.rating AS rating_7, t0.sku AS sku_8, t0.position AS position_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, t26.name AS name_27, t26.description AS description_28, t26.enabled AS enabled_29, t26.provider_name AS provider_name_30, t26.provider_status AS provider_status_31, t26.provider_reference AS provider_reference_32, t26.provider_metadata AS provider_metadata_33, t26.width AS width_34, t26.height AS height_35, t26.length AS length_36, t26.content_type AS content_type_37, t26.content_size AS content_size_38, t26.copyright AS copyright_39, t26.author_name AS author_name_40, t26.context AS context_41, t26.cdn_is_flushable AS cdn_is_flushable_42, t26.cdn_flush_identifier AS cdn_flush_identifier_43, t26.cdn_flush_at AS cdn_flush_at_44, t26.cdn_status AS cdn_status_45, t26.updated_at AS updated_at_46, t26.created_at AS created_at_47, t26.uuid AS uuid_48, t26.id AS id_49, t0.entityType FROM valueinshop_product t0 LEFT JOIN valueinshop_media t26 ON t0.image_id = t26.id WHERE t0.id = 1 AND t0.entityType IN ('product') AND ((t0.deleted = 0));
7	0.24 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
8	0.25 ms	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.short_description AS short_description_6, t0.language AS language_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 Parameters: [`1 "en"`] View formatted query View runnable query Explain query 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.short_description AS short_description_6, t0.language AS language_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.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.short_description AS short_description_6, t0.language AS language_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;
9	0.15 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
10	0.11 ms	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)) Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4 AND ((t0.deleted = 0));
11	0.57 ms	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 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.deleted = 0)) ORDER BY t0.title ASC Parameters: [`4`] View formatted query View runnable query Explain query 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 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.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.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 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 = 4 AND ((t0.deleted = 0)) ORDER BY t0.title ASC;
12	0.20 ms	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.priority AS priority_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 Parameters: [`4`] View formatted query View runnable query Explain query 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.priority AS priority_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.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.priority AS priority_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 = 4 AND ((t0.deleted = 0)) ORDER BY t0.priority ASC;
13	0.22 ms	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 Parameters: [`1`] View formatted query View runnable query Explain query 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;
14	0.20 ms	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 Parameters: [`1 "en"`] View formatted query View runnable query Explain query 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;
15	0.20 ms	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.min_quantity AS min_quantity_6, t0.max_quantity AS max_quantity_7, t0.value AS value_8, t0.currency AS currency_9, t0.operation AS operation_10, t0.position AS position_11, t0.uuid AS uuid_12, t0.rate_plan_charge_id AS rate_plan_charge_id_13 FROM valueinshop_product_rate_plan_charge_price t0 WHERE t0.rate_plan_charge_id = ? AND ((t0.deleted = 0)) ORDER BY t0.position ASC Parameters: [`1`] View formatted query View runnable query Explain query 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.min_quantity AS min_quantity_6, t0.max_quantity AS max_quantity_7, t0.value AS value_8, t0.currency AS currency_9, t0.operation AS operation_10, t0.position AS position_11, t0.uuid AS uuid_12, t0.rate_plan_charge_id AS rate_plan_charge_id_13 FROM valueinshop_product_rate_plan_charge_price t0 WHERE t0.rate_plan_charge_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.min_quantity AS min_quantity_6, t0.max_quantity AS max_quantity_7, t0.value AS value_8, t0.currency AS currency_9, t0.operation AS operation_10, t0.position AS position_11, t0.uuid AS uuid_12, t0.rate_plan_charge_id AS rate_plan_charge_id_13 FROM valueinshop_product_rate_plan_charge_price t0 WHERE t0.rate_plan_charge_id = 1 AND ((t0.deleted = 0)) ORDER BY t0.position ASC;
16	0.14 ms	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.uuid AS uuid_7 FROM valueinshop_product_tax_class t0 WHERE t0.id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.uuid AS uuid_7 FROM valueinshop_product_tax_class 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.name AS name_6, t0.uuid AS uuid_7 FROM valueinshop_product_tax_class t0 WHERE t0.id = 1 AND ((t0.deleted = 0));
17	0.17 ms	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.country AS country_6, t0.starting_date AS starting_date_7, t0.tax_rate AS tax_rate_8, t0.uuid AS uuid_9, t0.tax_class_id AS tax_class_id_10 FROM valueinshop_tax_rates t0 WHERE t0.tax_class_id = ? AND ((t0.deleted = 0)) ORDER BY t0.starting_date ASC Parameters: [`1`] View formatted query View runnable query Explain query 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.country AS country_6, t0.starting_date AS starting_date_7, t0.tax_rate AS tax_rate_8, t0.uuid AS uuid_9, t0.tax_class_id AS tax_class_id_10 FROM valueinshop_tax_rates t0 WHERE t0.tax_class_id = ? AND ( (t0.deleted = 0) ) ORDER BY t0.starting_date 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.country AS country_6, t0.starting_date AS starting_date_7, t0.tax_rate AS tax_rate_8, t0.uuid AS uuid_9, t0.tax_class_id AS tax_class_id_10 FROM valueinshop_tax_rates t0 WHERE t0.tax_class_id = 1 AND ((t0.deleted = 0)) ORDER BY t0.starting_date ASC;
18	0.15 ms	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, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override t0 WHERE t0.id = ? AND ((t0.deleted = 0)) Parameters: [`2`] View formatted query View runnable query Explain query 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, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override 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, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override t0 WHERE t0.id = 2 AND ((t0.deleted = 0));
19	0.14 ms	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, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override t0 WHERE t0.id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override 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, t0.subscription_strategy_id AS subscription_strategy_id_7 FROM valueinshop_subscription_strategy_override t0 WHERE t0.id = 1 AND ((t0.deleted = 0));
20	0.15 ms	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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.strategy_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.strategy_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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.strategy_id = 1 AND ((t0.deleted = 0));
21	0.18 ms	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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_id = 1 AND ((t0.deleted = 0));
22	0.15 ms	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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_id = ? AND ((t0.deleted = 0)) Parameters: [`2`] View formatted query View runnable query Explain query 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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_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.starting_date AS starting_date_6, t0.ending_date AS ending_date_7, t0.commission_rate AS commission_rate_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.override_id AS override_id_11 FROM valueinshop_commission_rate t0 WHERE t0.override_id = 2 AND ((t0.deleted = 0));
23	0.13 ms	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)) Parameters: [`3`] View formatted query View runnable query Explain query 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 = 3 AND ((t0.deleted = 0));
24	0.50 ms	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 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.deleted = 0)) ORDER BY t0.title ASC Parameters: [`3`] View formatted query View runnable query Explain query 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 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.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.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 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 = 3 AND ((t0.deleted = 0)) ORDER BY t0.title ASC;
25	0.20 ms	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.priority AS priority_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 Parameters: [`3`] View formatted query View runnable query Explain query 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.priority AS priority_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.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.priority AS priority_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 = 3 AND ((t0.deleted = 0)) ORDER BY t0.priority ASC;
26	0.15 ms	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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_datetime t0 WHERE t0.product_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_datetime t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_datetime t0 WHERE t0.product_id = 1 AND ((t0.deleted = 0));
27	0.13 ms	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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_float t0 WHERE t0.product_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_float t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_float t0 WHERE t0.product_id = 1 AND ((t0.deleted = 0));
28	0.16 ms	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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_int t0 WHERE t0.product_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_int t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_int t0 WHERE t0.product_id = 1 AND ((t0.deleted = 0));
29	0.15 ms	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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_json t0 WHERE t0.product_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_json t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_json t0 WHERE t0.product_id = 1 AND ((t0.deleted = 0));
30	0.13 ms	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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_string t0 WHERE t0.product_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_string t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_string t0 WHERE t0.product_id = 1 AND ((t0.deleted = 0));
31	0.15 ms	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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_stringindexed t0 WHERE t0.product_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_stringindexed t0 WHERE t0.product_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.field AS field_6, t0.delta AS delta_7, t0.value AS value_8, t0.product_id AS product_id_9 FROM valueinshop_product_eav_stringindexed t0 WHERE t0.product_id = 1 AND ((t0.deleted = 0));
32	0.15 ms	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_ Parameters: [] View formatted query View runnable query Explain query 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_;
33	0.18 ms	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.cancellation_allow AS cancellation_allow_7, t0.cancellation_apply_credit_balance AS cancellation_apply_credit_balance_8, t0.cancellation_collect AS cancellation_collect_9, t0.cancellation_run_billing AS cancellation_run_billing_10, t0.cancellation_effective_date AS cancellation_effective_date_11, t0.cancellation_last_possible_date AS cancellation_last_possible_date_12, t0.cancellation_with_regularization_subscription AS cancellation_with_regularization_subscription_13, t0.cancellation_policy AS cancellation_policy_14, t0.regularization_product AS regularization_product_15, t0.uuid AS uuid_16, t0.subscription_strategy_id AS subscription_strategy_id_17 FROM valueinshop_subscription_strategy_cancellation t0 WHERE t0.subscription_strategy_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.cancellation_allow AS cancellation_allow_7, t0.cancellation_apply_credit_balance AS cancellation_apply_credit_balance_8, t0.cancellation_collect AS cancellation_collect_9, t0.cancellation_run_billing AS cancellation_run_billing_10, t0.cancellation_effective_date AS cancellation_effective_date_11, t0.cancellation_last_possible_date AS cancellation_last_possible_date_12, t0.cancellation_with_regularization_subscription AS cancellation_with_regularization_subscription_13, t0.cancellation_policy AS cancellation_policy_14, t0.regularization_product AS regularization_product_15, t0.uuid AS uuid_16, t0.subscription_strategy_id AS subscription_strategy_id_17 FROM valueinshop_subscription_strategy_cancellation t0 WHERE t0.subscription_strategy_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.title AS title_6, t0.cancellation_allow AS cancellation_allow_7, t0.cancellation_apply_credit_balance AS cancellation_apply_credit_balance_8, t0.cancellation_collect AS cancellation_collect_9, t0.cancellation_run_billing AS cancellation_run_billing_10, t0.cancellation_effective_date AS cancellation_effective_date_11, t0.cancellation_last_possible_date AS cancellation_last_possible_date_12, t0.cancellation_with_regularization_subscription AS cancellation_with_regularization_subscription_13, t0.cancellation_policy AS cancellation_policy_14, t0.regularization_product AS regularization_product_15, t0.uuid AS uuid_16, t0.subscription_strategy_id AS subscription_strategy_id_17 FROM valueinshop_subscription_strategy_cancellation t0 WHERE t0.subscription_strategy_id = 1 AND ((t0.deleted = 0));
34	0.16 ms	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.value AS value_7, t0.target_object AS target_object_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.shop_id AS shop_id_11 FROM valueinshop_custom_field_subscription_strategy t0 WHERE t0.strategy_id = ? AND ((t0.deleted = 0)) Parameters: [`1`] View formatted query View runnable query Explain query 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.value AS value_7, t0.target_object AS target_object_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.shop_id AS shop_id_11 FROM valueinshop_custom_field_subscription_strategy t0 WHERE t0.strategy_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.name AS name_6, t0.value AS value_7, t0.target_object AS target_object_8, t0.uuid AS uuid_9, t0.strategy_id AS strategy_id_10, t0.shop_id AS shop_id_11 FROM valueinshop_custom_field_subscription_strategy t0 WHERE t0.strategy_id = 1 AND ((t0.deleted = 0));
35	0.14 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
36	0.12 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
37	0.16 ms	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)) Parameters: [] View formatted query View runnable query Explain query 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));
38	0.15 ms	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)) Parameters: [`6`] View formatted query View runnable query Explain query 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 = 6 AND ((t0.deleted = 0));
39	0.21 ms	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.priority AS priority_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 Parameters: [`6`] View formatted query View runnable query Explain query 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.priority AS priority_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.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.priority AS priority_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 = 6 AND ((t0.deleted = 0)) ORDER BY t0.priority ASC;
40	0.51 ms	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 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.deleted = 0)) ORDER BY t0.title ASC Parameters: [`6`] View formatted query View runnable query Explain query 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 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.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.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 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 = 6 AND ((t0.deleted = 0)) ORDER BY t0.title ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ProductSelector	6
App\Entity\SubscriptionStrategyOverride	2
App\Entity\ProductRatePlan	1
App\Entity\Product	1
App\Entity\SubscriptionStrategy	1
App\Entity\ProductTaxClass	1
App\Entity\ProductRatePlanCharge	1
App\Entity\TaxRate	1
App\Entity\Config\Cart	1

Entities Mapping

Class	Mapping errors
ValueIn\CommonBundle\Entity\AbstractEntity	No errors.
App\Entity\Config\Language	No errors.
App\Entity\Availability	No errors.
App\Entity\ProductRatePlan	No errors.
App\Entity\ProductType	No errors.
App\Entity\Product	No errors.
App\Entity\SubscriptionStrategyOverride	No errors.
App\Entity\Offer	No errors.
App\Entity\ProductRatePlanCharge	No errors.
App\Entity\ProductSelector	No errors.
App\Entity\ProductRatePlanQuestion	No errors.
App\Entity\SubscriptionStrategy	No errors.
App\Entity\SubscriptionStrategyCustomFields	No errors.
App\Entity\CommissionRate	No errors.
App\Entity\SubscriptionStrategyCancellation	No errors.
App\Entity\Translations\ProductRatePlanTranslation	No errors.
App\Entity\Group	No errors.
Sonata\MediaBundle\Entity\BaseMedia	No errors.
Application\Sonata\MediaBundle\Entity\Media	No errors.
App\Entity\Provider	No errors.
App\Entity\ProductTaxClass	No errors.
Sonata\MediaBundle\Entity\BaseGallery	No errors.
Application\Sonata\MediaBundle\Entity\Gallery	No errors.
App\Entity\ShippingStrategy	No errors.
App\Entity\ShopProduct	No errors.
App\Entity\OrderProduct	No errors.
App\Entity\ProductAttribute	No errors.
ValueIn\CommonBundle\Entity\EAV\AbstractField	No errors.
ValueIn\CommonBundle\Entity\EAV\AbstractDatetime	No errors.
App\Entity\EAV\Product\EAVDatetime	No errors.
ValueIn\CommonBundle\Entity\EAV\AbstractFloat	No errors.
App\Entity\EAV\Product\EAVFloat	No errors.
ValueIn\CommonBundle\Entity\EAV\AbstractInt	No errors.
App\Entity\EAV\Product\EAVInt	No errors.
ValueIn\CommonBundle\Entity\EAV\AbstractJson	No errors.
App\Entity\EAV\Product\EAVJson	No errors.
ValueIn\CommonBundle\Entity\EAV\AbstractString	No errors.
App\Entity\EAV\Product\EAVString	No errors.
ValueIn\CommonBundle\Entity\EAV\AbstractStringIndexed	No errors.
App\Entity\EAV\Product\EAVStringIndexed	No errors.
App\Entity\Translations\ProductTranslation	No errors.
App\Entity\ProductSelectorOrderedFilter	No errors.
App\Entity\ProductFilter	No errors.
App\Entity\ProductRatePlanChargePrice	No errors.
App\Entity\Translations\ProductRatePlanChargeTranslation	No errors.
App\Entity\TaxRate	No errors.
App\Entity\Config\Cart	No errors.
App\Entity\Shop	No errors.
ValueIn\ZuoraInvoiceEngineBundle\Entity\Config\Zuora	No errors.
App\Entity\CartCustomField	No errors.

Symfony Profiler

GET https://stripe-billing.valuein.cloud/cart/product/per-unit/add/1/1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping