http://shop-dev.dm-edv.de/

Query Metrics

61 Database Queries
4 Different statements
72.14 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
51.08 ms
(70.82%)
33
SELECT t0.id AS id_1, t0.name AS name_2, t0.hostname AS hostname_3, t0.upload_directory AS upload_directory_4, t0.email AS email_5, t0.dvo_email AS dvo_email_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t9.id AS id_10, t9.logo AS logo_11, t9.favicon AS favicon_12, t9.footer_address AS footer_address_13, t9.facebook_link AS facebook_link_14, t9.instagram_link AS instagram_link_15, t9.linkedin_link AS linkedin_link_16, t9.xing_link AS xing_link_17, t9.color AS color_18, t9.color_hover AS color_hover_19, t9.d_trust_link AS d_trust_link_20, t9.application_portal_link AS application_portal_link_21, t9.checklist_link AS checklist_link_22, t9.back_link AS back_link_23, t9.apply_for_ehba_link AS apply_for_ehba_link_24, t9.order_ehba_link AS order_ehba_link_25, t9.apply_for_smcb_link AS apply_for_smcb_link_26, t9.order_smcb_link AS order_smcb_link_27, t9.agb AS agb_28, t9.besgb AS besgb_29, t9.kim_agb AS kim_agb_30, t9.av_contract AS av_contract_31, t9.enable_customer_number AS enable_customer_number_32, t9.imprint_url AS imprint_url_33, t9.privacy_url AS privacy_url_34, t9.customer_file AS customer_file_35, t9.index_image AS index_image_36, t9.sub_image AS sub_image_37, t9.created_at AS created_at_38, t9.modified_at AS modified_at_39, t9.tenant_id AS tenant_id_40 FROM tenant t0 LEFT JOIN tenant_config t9 ON t9.tenant_id = t0.id WHERE t0.hostname = ? LIMIT 1
Parameters:
[
  "shop-dev.dm-edv.de"
]
12.00 ms
(16.64%)
12
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.created_at AS created_at_4, t0.modified_at AS modified_at_5, t0.tenant_id AS tenant_id_6 FROM text_template t0 WHERE t0.name = ? AND t0.tenant_id = ? LIMIT 1
Parameters:
[
  "storefront.title"
  3
]
8.65 ms
(11.99%)
15
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.favicon AS favicon_3, t0.footer_address AS footer_address_4, t0.facebook_link AS facebook_link_5, t0.instagram_link AS instagram_link_6, t0.linkedin_link AS linkedin_link_7, t0.xing_link AS xing_link_8, t0.color AS color_9, t0.color_hover AS color_hover_10, t0.d_trust_link AS d_trust_link_11, t0.application_portal_link AS application_portal_link_12, t0.checklist_link AS checklist_link_13, t0.back_link AS back_link_14, t0.apply_for_ehba_link AS apply_for_ehba_link_15, t0.order_ehba_link AS order_ehba_link_16, t0.apply_for_smcb_link AS apply_for_smcb_link_17, t0.order_smcb_link AS order_smcb_link_18, t0.agb AS agb_19, t0.besgb AS besgb_20, t0.kim_agb AS kim_agb_21, t0.av_contract AS av_contract_22, t0.enable_customer_number AS enable_customer_number_23, t0.imprint_url AS imprint_url_24, t0.privacy_url AS privacy_url_25, t0.customer_file AS customer_file_26, t0.index_image AS index_image_27, t0.sub_image AS sub_image_28, t0.created_at AS created_at_29, t0.modified_at AS modified_at_30, t0.tenant_id AS tenant_id_31 FROM tenant_config t0 WHERE t0.tenant_id = ? LIMIT 1
Parameters:
[
  3
]
0.40 ms
(0.56%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.list_image AS list_image_4, t0.header_image AS header_image_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.tenant_id AS tenant_id_8 FROM category t0 WHERE t0.tenant_id = ?
Parameters:
[
  3
]

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
App\Entity\TextTemplate No errors.
App\Entity\Tenant No errors.
App\Entity\TenantConfig No errors.
App\Entity\Faq No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Order No errors.