GET https://stripe-billing.valuein.cloud/

Query Metrics

23 Database Queries
21 Different statements
5.19 ms Query time
0 Invalid entities
17 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.53 ms
(10.17%)
2
SELECT t0.id AS id_1, t0.enabled AS enabled_2 FROM valueinshop_admin_alert_config t0
Parameters:
[]
0.52 ms
(9.96%)
2
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
]
0.35 ms
(6.66%)
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.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
]
0.32 ms
(6.22%)
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.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.entityType IN ('product') AND ((t0.deleted = 0))
Parameters:
[]
0.32 ms
(6.13%)
1
SELECT t0.id AS id_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.priority AS priority_11, t0.adminLabel AS adminLabel_12, t0.enabled AS enabled_13, t0.uuid AS uuid_14, t0.type, t1.slider_id AS slider_id_15, t1.low_size_screen_slider_id AS low_size_screen_slider_id_16, t2.title AS title_17, t3.title AS title_18, t3.productsListType AS productsListType_19, t4.title AS title_20, t5.body AS body_21 FROM valueinshop_cms_component t0 LEFT JOIN valueinshop_component_slider t1 ON t0.id = t1.id LEFT JOIN valueinshop_component_title_separator t2 ON t0.id = t2.id LEFT JOIN valueinshop_component_product_list t3 ON t0.id = t3.id LEFT JOIN valueinshop_component_shop_list t4 ON t0.id = t4.id LEFT JOIN valueinshop_component_text_content t5 ON t0.id = t5.id WHERE t0.enabled = ? AND ((t0.deleted = 0)) ORDER BY t0.priority ASC
Parameters:
[
  1
]
0.32 ms
(6.10%)
1
SELECT v0_.head_start AS head_start_0, v0_.head_end AS head_end_1, v0_.body_start AS body_start_2, v0_.body_end AS body_end_3 FROM valueinshop_html_snippet v0_ WHERE (v0_.enabled = 1) AND (v0_.deleted = 0)
Parameters:
[]
0.28 ms
(5.36%)
1
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:
[]
0.26 ms
(4.91%)
1
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:
[]
0.25 ms
(4.72%)
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 = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1
Parameters:
[
  1
  "en"
]
0.24 ms
(4.66%)
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
Parameters:
[
  1
  "en"
]
0.22 ms
(4.28%)
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.language AS language_6, t0.text AS text_7, t0.title AS title_8, t0.source AS source_9 FROM valueinshop_text_translation t0 WHERE t0.source = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1
Parameters:
[
  "homepage_footer_text"
  "en"
]
0.21 ms
(3.95%)
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.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.product_id = ? AND ((t0.deleted = 0)) ORDER BY t0.position ASC
Parameters:
[
  1
]
0.20 ms
(3.93%)
1
SELECT t0.code AS code_1, t0.title AS title_2, t0.text AS text_3 FROM valueinshop_text t0 WHERE t0.code = ?
Parameters:
[
  "homepage_footer_text"
]
0.20 ms
(3.82%)
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.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
]
0.17 ms
(3.35%)
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.language AS language_6, t0.title AS title_7, t0.source_id AS source_id_8 FROM valueinshop_component_product_list_translation t0 WHERE t0.source_id = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1
Parameters:
[
  1
  "en"
]
0.17 ms
(3.35%)
1
SELECT t0.id AS id_1, t0.use_invoice_engine_preview AS use_invoice_engine_preview_2, t0.context AS context_3, t0.shipping_address_mode AS shipping_address_mode_4, t0.billing_address_mode AS billing_address_mode_5, t0.display_tax_detail AS display_tax_detail_6, t0.display_discount_detail AS display_discount_detail_7, t0.display_map_in_forms AS display_map_in_forms_8 FROM valueinshop_cart t0
Parameters:
[]
0.17 ms
(3.32%)
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.priority AS priority_6, t0.uuid AS uuid_7, t0.product_filter_id AS product_filter_id_8 FROM valueinshop_cms_product_filter t0 INNER JOIN valueinshop_cms_productfilter_list ON t0.id = valueinshop_cms_productfilter_list.productfilter_id WHERE valueinshop_cms_productfilter_list.component_productlist_id = ? AND ((t0.deleted = 0))
Parameters:
[
  1
]
0.14 ms
(2.64%)
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.uuid AS uuid_7 FROM valueinshop_product_tax_class t0 WHERE t0.id = ? AND ((t0.deleted = 0))
Parameters:
[
  1
]
0.13 ms
(2.47%)
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
Parameters:
[
  1
  "en"
]
0.11 ms
(2.18%)
1
SELECT t0.id AS id_1, t0.private_key AS private_key_2, t0.public_key AS public_key_3, t0.default_mcc AS default_mcc_4, t0.available_mcc AS available_mcc_5 FROM valueinshop_config_stripe t0
Parameters:
[]
0.09 ms
(1.81%)
1
SELECT t0.default_currency AS default_currency_1, t0.id AS id_2 FROM valueinshop_currency t0
Parameters:
[]

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\CmsComponent\CmsComponent 1
App\Entity\Product 1
App\Entity\ProductTaxClass 1
App\Entity\SubscriptionStrategy 1
App\Entity\ProductRatePlan 1
App\Entity\Config\Stripe 1
App\Entity\Text 1
App\Entity\ProductRatePlanCharge 1
App\Entity\TaxRate 1

Entities Mapping

Class Mapping errors
ValueIn\CommonBundle\Entity\AbstractEntity No errors.
App\Entity\Config\Language No errors.
App\Entity\CmsComponent\CmsComponent No errors.
App\Entity\CmsComponent\ComponentSlider No errors.
App\Entity\CmsComponent\ComponentTitleSeparator No errors.
App\Entity\CmsComponent\ComponentProductList No errors.
App\Entity\CmsComponent\ComponentShopList No errors.
App\Entity\CmsComponent\ComponentTextContent No errors.
Sonata\MediaBundle\Entity\BaseGallery No errors.
Application\Sonata\MediaBundle\Entity\Gallery No errors.
App\Entity\CmsComponent\CmsProductFilter No errors.
App\Entity\Translations\CmsComponent\ComponentProductListTranslation No errors.
App\Entity\ProductFilter No errors.
App\Entity\ProductType No errors.
App\Entity\Product No errors.
App\Entity\Provider No errors.
App\Entity\ProductTaxClass No errors.
App\Entity\ProductSelector No errors.
App\Entity\SubscriptionStrategyOverride No errors.
App\Entity\ShippingStrategy No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
Application\Sonata\MediaBundle\Entity\Media No errors.
App\Entity\Availability No errors.
App\Entity\ProductRatePlan 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\SubscriptionStrategy No errors.
App\Entity\SubscriptionStrategyCustomFields No errors.
App\Entity\CommissionRate No errors.
App\Entity\SubscriptionStrategyCancellation No errors.
App\Entity\Translations\ProductTranslation No errors.
App\Entity\Offer No errors.
App\Entity\ProductRatePlanCharge No errors.
App\Entity\ProductRatePlanQuestion No errors.
App\Entity\Translations\ProductRatePlanTranslation No errors.
App\Entity\Config\Currency No errors.
App\Entity\Config\Stripe No errors.
App\Entity\AdminAlert\AdminAlertConfig No errors.
App\Entity\HtmlSnippet No errors.
App\Entity\Config\Cart No errors.
App\Entity\Text No errors.
App\Entity\Translations\TextTranslation No errors.
App\Entity\ProductRatePlanChargePrice No errors.
App\Entity\Translations\ProductRatePlanChargeTranslation No errors.
App\Entity\TaxRate No errors.