http://shop-hager.valuein.io/myaccount

Query Metrics

16 Database Queries
10 Different statements
5.91 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.05 ms
(17.70%)
4
SELECT t0.username AS username_1, t0.prefix_url AS prefix_url_2, t0.tennant_id AS tennant_id_3, t0.country_code AS country_code_4, t0.id AS id_5, t0.password AS password_6, t0.execution_level AS execution_level_7, t0.preview_charge_prefix AS preview_charge_prefix_8 FROM valueinshop_config_zuora t0
Parameters:
[]
0.94 ms
(15.85%)
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.isDefault AS isDefault_6, t0.prefix AS prefix_7, t0.allowed_shipping_country AS allowed_shipping_country_8, t0.allowed_billing_country AS allowed_billing_country_9, t0.allowed_global_document AS allowed_global_document_10, t0.batch AS batch_11, t0.sequence_set AS sequence_set_12, t0.communication_profile AS communication_profile_13, t0.invoice_template AS invoice_template_14, t0.credit_memo_template AS credit_memo_template_15, t0.debit_memo_template AS debit_memo_template_16, t0.currency AS currency_17, t0.title AS title_18, t0.address AS address_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.state AS state_22, t0.country AS country_23, t0.description AS description_24, t0.theme_id AS theme_id_25, t0.image_id AS image_id_26, t0.imagecover_id AS imagecover_id_27, t0.entityType FROM valueinshop_shop t0 WHERE t0.isDefault = ? AND t0.entityType IN ('shop') AND ((t0.deleted = 0)) LIMIT 1
Parameters:
[
  1
]
0.87 ms
(14.78%)
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.isDefault AS isDefault_6, t0.prefix AS prefix_7, t0.allowed_shipping_country AS allowed_shipping_country_8, t0.allowed_billing_country AS allowed_billing_country_9, t0.allowed_global_document AS allowed_global_document_10, t0.batch AS batch_11, t0.sequence_set AS sequence_set_12, t0.communication_profile AS communication_profile_13, t0.invoice_template AS invoice_template_14, t0.credit_memo_template AS credit_memo_template_15, t0.debit_memo_template AS debit_memo_template_16, t0.currency AS currency_17, t0.title AS title_18, t0.address AS address_19, t0.zipcode AS zipcode_20, t0.city AS city_21, t0.state AS state_22, t0.country AS country_23, t0.description AS description_24, t0.theme_id AS theme_id_25, t0.image_id AS image_id_26, t0.imagecover_id AS imagecover_id_27, t0.entityType FROM valueinshop_shop t0 WHERE t0.prefix = ? AND t0.entityType IN ('shop') AND ((t0.deleted = 0)) LIMIT 1
Parameters:
[
  "myaccount"
]
0.77 ms
(13.04%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.enabled_admin AS enabled_admin_4, t0.variables AS variables_5, t0.compiled_css AS compiled_css_6, t0.compiled_css_admin AS compiled_css_admin_7 FROM valueinshop_config_theme t0 WHERE t0.enabled = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[
  1
]
0.50 ms
(8.53%)
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_code AS language_code_6, t0.isDefault AS isDefault_7, t0.enabled AS enabled_8, t0.debug AS debug_9, t0.collect AS collect_10 FROM valueinshop_language t0 INNER JOIN valueinshop_shop_language ON t0.id = valueinshop_shop_language.language_id WHERE valueinshop_shop_language.shop_id = ? AND ((t0.deleted = 0))
Parameters:
[
  1
]
0.46 ms
(7.87%)
2
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.token AS token_4, t0.prod_env AS prod_env_5, t0.active AS active_6 FROM valueinshop_config_salesforce t0
Parameters:
[]
0.40 ms
(6.82%)
1
SELECT t0.id AS id_1, t0.error_code AS error_code_2, t0.activated AS activated_3, t0.title AS title_4, t0.description AS description_5, t0.image_id AS image_id_6 FROM valueinshop_error_page t0 WHERE t0.activated = ? AND t0.error_code = ? LIMIT 1
Parameters:
[
  1
  503
]
0.36 ms
(6.15%)
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_code AS language_code_6, t0.isDefault AS isDefault_7, t0.enabled AS enabled_8, t0.debug AS debug_9, t0.collect AS collect_10 FROM valueinshop_language t0 WHERE t0.isDefault = ? AND t0.enabled = ? AND ((t0.id IN (2,-1)) AND (t0.deleted = 0)) LIMIT 1
Parameters:
[
  1
  1
]
0.35 ms
(5.96%)
1
SELECT t0.id AS id_1, t0.subscription_prefix AS subscription_prefix_2, t0.subscription_format AS subscription_format_3, t0.subscription_suffix AS subscription_suffix_4, t0.subscription_current_value AS subscription_current_value_5, t0.account_number_current_value AS account_number_current_value_6, t0.entityType FROM valueinshop_config_incremental_number t0 WHERE t0.entityType IN ('incrementalnumber')
Parameters:
[]
0.20 ms
(3.30%)
1
SELECT t0.id AS id_1, t0.use_invoice_engine_preview AS use_invoice_engine_preview_2, t0.include_tax_in_product AS include_tax_in_product_3, t0.display_tax_detail AS display_tax_detail_4, t0.display_discount_detail AS display_discount_detail_5 FROM valueinshop_cart 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.

Entities Mapping

Class Mapping errors
ValueIn\ZuoraInvoiceEngineBundle\Entity\Config\Zuora No errors.
ValueIn\ZuoraInvoiceEngineBundle\Entity\Config\Iframe No errors.
AppBundle\Entity\Config\Salesforce No errors.
AppBundle\Entity\Config\IncrementalNumber No errors.
AppBundle\Entity\Config\Cart No errors.
ValueIn\CommonBundle\Entity\AbstractEntity No errors.
AppBundle\Entity\Group No errors.
AppBundle\Entity\Config\Theme No errors.
AppBundle\Entity\Shop No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
Application\Sonata\MediaBundle\Entity\Media No errors.
AppBundle\Entity\ShopSchedule No errors.
AppBundle\Entity\ShopProduct No errors.
AppBundle\Entity\Config\Language No errors.
AppBundle\Entity\Order No errors.
AppBundle\Entity\Quote No errors.
FOS\UserBundle\Model\User No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
AppBundle\Entity\User No errors.
AppBundle\Entity\Offer No errors.
AppBundle\Entity\SubscriptionStrategyCustomFields No errors.
AppBundle\Entity\ShopLanguageInvoice No errors.
AppBundle\Entity\Config\QuoteTemplate No errors.
AppBundle\Entity\ShopProductGroup No errors.
AppBundle\Entity\Config\Contract No errors.
AppBundle\Entity\Config\ErrorPage No errors.