Query Metrics
12
Database Queries
11
Different statements
12.59 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.01 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.subtitle AS subtitle_3, c0_.created_at AS created_at_4, c0_.person_id AS person_id_5, c0_.address_id AS address_id_6, c0_.user_id AS user_id_7, c0_.contact_id AS contact_id_8, c0_.configuration_id AS configuration_id_9, c0_.partner_id AS partner_id_10, c0_.logo_id AS logo_id_11, c0_.tax_information_id AS tax_information_id_12, c0_.invoice_settings_id AS invoice_settings_id_13, c0_.contract_settings_id AS contract_settings_id_14, c0_.content_how_to_id AS content_how_to_id_15, c0_.content_about_us_id AS content_about_us_id_16, c0_.template_id AS template_id_17, c0_.faq_id AS faq_id_18, c0_.notification_id AS notification_id_19 FROM customer c0_ LEFT JOIN customer_configuration c1_ ON c0_.configuration_id = c1_.id WHERE c1_.host LIKE ? AND c1_.contract_start <= ? AND c1_.contract_end >= ? AND c1_.active = 1
Parameters:
[ "%sportlive-ev.werbebanden-manager.de%" "2024-10-30" "2024-10-30" ] |
2 | 0.32 ms |
SELECT t0.id AS id_1, t0.host AS host_2, t0.test AS test_3, t0.active AS active_4, t0.contribution_allow AS contribution_allow_5, t0.contribution_active AS contribution_active_6, t0.contribution_price AS contribution_price_7, t0.contract_start AS contract_start_8, t0.contract_end AS contract_end_9, t0.homedir AS homedir_10, t0.basic_price AS basic_price_11, t0.area_basic_price AS area_basic_price_12 FROM customer_configuration t0 WHERE t0.id IN (?)
Parameters:
[
5
]
|
3 | 1.82 ms |
SELECT t0.id AS id_1, t0.token AS token_2, t0.free_field AS free_field_3, t0.next_value AS next_value_4, t0.min_length AS min_length_5, t0.tax_rate AS tax_rate_6, t0.invoice_due AS invoice_due_7, t0.automatic_send AS automatic_send_8, t0.payment_term_in_days AS payment_term_in_days_9 FROM customer_invoice_settings t0 WHERE t0.id IN (?)
Parameters:
[
5
]
|
4 | 1.55 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.how_to_text1 AS how_to_text1_3, t0.how_to_text2 AS how_to_text2_4, t0.how_to_text3 AS how_to_text3_5, t0.background_color AS background_color_6, t0.icon_color AS icon_color_7, t0.fk_icon_1 AS fk_icon_1_8, t0.fk_icon_2 AS fk_icon_2_9, t0.fk_icon_3 AS fk_icon_3_10, t0.background_image_id AS background_image_id_11 FROM customer_content_how_to t0 WHERE t0.id IN (?)
Parameters:
[
5
]
|
5 | 1.13 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.description AS description_3 FROM customer_content_about_us t0 WHERE t0.id IN (?)
Parameters:
[
5
]
|
6 | 1.04 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.text_color AS text_color_3, t0.background_color AS background_color_4 FROM customer_faq t0 WHERE t0.id IN (?)
Parameters:
[
5
]
|
7 | 0.39 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.subtitle AS subtitle_3, c0_.created_at AS created_at_4, c0_.person_id AS person_id_5, c0_.address_id AS address_id_6, c0_.user_id AS user_id_7, c0_.contact_id AS contact_id_8, c0_.configuration_id AS configuration_id_9, c0_.partner_id AS partner_id_10, c0_.logo_id AS logo_id_11, c0_.tax_information_id AS tax_information_id_12, c0_.invoice_settings_id AS invoice_settings_id_13, c0_.contract_settings_id AS contract_settings_id_14, c0_.content_how_to_id AS content_how_to_id_15, c0_.content_about_us_id AS content_about_us_id_16, c0_.template_id AS template_id_17, c0_.faq_id AS faq_id_18, c0_.notification_id AS notification_id_19 FROM customer c0_ LEFT JOIN customer_configuration c1_ ON c0_.configuration_id = c1_.id WHERE c1_.host LIKE ? AND c1_.contract_start <= ? AND c1_.contract_end >= ? AND c1_.active = 1
Parameters:
[ "%sportlive-ev.werbebanden-manager.de%" "2024-10-30" "2024-10-30" ] |
8 | 1.08 ms |
SELECT t0.id AS id_1, t0.src AS src_2, t0.size AS size_3, t0.complete AS complete_4 FROM image t0 WHERE t0.id = ?
Parameters:
[
6
]
|
9 | 1.25 ms |
SELECT t0.id AS id_1, t0.primary_color AS primary_color_2, t0.secondary_color AS secondary_color_3, t0.footer_background_color AS footer_background_color_4, t0.footer_text_color AS footer_text_color_5, t0.header_image_id AS header_image_id_6 FROM customer_template t0 WHERE t0.id = ?
Parameters:
[
5
]
|
10 | 1.73 ms |
SELECT t0.id AS id_1, t0.salutation AS salutation_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4 FROM person t0 WHERE t0.id = ?
Parameters:
[
5
]
|
11 | 0.32 ms |
SELECT t0.id AS id_1, t0.company AS company_2, t0.street AS street_3, t0.housenr AS housenr_4, t0.city AS city_5, t0.zipcode AS zipcode_6, t0.country AS country_7 FROM address t0 WHERE t0.id = ?
Parameters:
[
5
]
|
12 | 0.95 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.fax AS fax_3, t0.email AS email_4, t0.url AS url_5 FROM contact t0 WHERE t0.id = ?
Parameters:
[
5
]
|
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\Customer | No errors. |
App\Entity\CustomerConfiguration | No errors. |
App\Entity\Person | No errors. |
App\Entity\Address | No errors. |
App\Entity\User | No errors. |
App\Entity\Contact | No errors. |
App\Entity\Partner | No errors. |
App\Entity\Image | No errors. |
App\Entity\CustomerTaxInformation | No errors. |
App\Entity\CustomerInvoiceSettings | No errors. |
App\Entity\CustomerContractSettings | No errors. |
App\Entity\CustomerContentHowTo | No errors. |
App\Entity\CustomerContentAboutUs | No errors. |
App\Entity\CustomerTemplate | No errors. |
App\Entity\CustomerFaq | No errors. |
App\Entity\CustomerNotification | No errors. |
App\Entity\CustomerPackage | No errors. |
App\Entity\CustomerBankAccount | No errors. |
App\Entity\Sponsor | No errors. |
App\Entity\InvoiceInterval | No errors. |
App\Entity\Icon | No errors. |
App\Entity\CustomerContentAboutUsImage | No errors. |
App\Entity\CustomerFaqItem | No errors. |