Query Metrics
61
Database Queries
4
Different statements
60.82 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
37.09 ms (60.99%) |
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"
]
|
17.55 ms (28.86%) |
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
]
|
5.78 ms (9.50%) |
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 ] |
0.40 ms (0.66%) |
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. |