Query Metrics
5
Database Queries
4
Different statements
1.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.41 ms (37.18%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
6
]
|
|
0.30 ms (27.27%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.identifier AS identifier_3, t0.time_zone AS time_zone_4, t0.locale AS locale_5, t0.paypal_client_key AS paypal_client_key_6, t0.paypal_secret AS paypal_secret_7, t0.com_mail AS com_mail_8, t0.com_server AS com_server_9, t0.com_server_port AS com_server_port_10, t0.com_mail_user AS com_mail_user_11, t0.com_mail_password AS com_mail_password_12, t0.paypal_verified AS paypal_verified_13, t0.public_key AS public_key_14, t0.iban AS iban_15, t0.bic AS bic_16, t0.company_street AS company_street_17, t0.company_zip AS company_zip_18, t0.company_city AS company_city_19, t0.vat AS vat_20, t0.vat_value AS vat_value_21, t0.two_factor_required AS two_factor_required_22, t0.homepage_banner AS homepage_banner_23, t0.homepage_text AS homepage_text_24 FROM company t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
"THEATERLANDSHUTBERG"
]
|
|
0.22 ms (19.97%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.deleted AS deleted_4, t0.long_description AS long_description_5, t0.hero_image_path AS hero_image_path_6, t0.card_image_path AS card_image_path_7, t0.company_id AS company_id_8, t9.id AS id_10, t9.data AS data_11, t9.event_collection_id AS event_collection_id_12, t9.company_id AS company_id_13 FROM event_collection t0 LEFT JOIN posters t9 ON t9.event_collection_id = t0.id WHERE t0.company_id = ?
Parameters:
[
2
]
|
|
0.17 ms (15.58%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.reserve_by AS reserve_by_4, t0.reserve_user_by AS reserve_user_by_5, t0.visible_from AS visible_from_6, t0.map_data AS map_data_7, t0.deleted AS deleted_8, t0.payment_deadline_days AS payment_deadline_days_9, t0.paid_mail AS paid_mail_10, t0.unpaid_mail AS unpaid_mail_11, t0.deleted_mail AS deleted_mail_12, t0.reserved_mail AS reserved_mail_13, t0.has_paypal AS has_paypal_14, t0.ticket_template AS ticket_template_15, t0.location AS location_16, t0.invoice_template AS invoice_template_17, t0.hide_from_homepage AS hide_from_homepage_18, t0.description AS description_19, t0.long_description AS long_description_20, t0.hero_image_path AS hero_image_path_21, t0.card_image_path AS card_image_path_22, t0.seating_type AS seating_type_23, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_24, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_25, t0.payment_method_windows_json AS payment_method_windows_json_26, t0.map_id AS map_id_27, t0.poster_id AS poster_id_28, t0.company_id AS company_id_29, t0.event_collection_id AS event_collection_id_30, t0.ticket_document_template_id AS ticket_document_template_id_31, t0.invoice_document_template_id AS invoice_document_template_id_32, t0.reserved_mail_template_id AS reserved_mail_template_id_33, t0.paid_mail_template_id AS paid_mail_template_id_34, t0.unpaid_mail_template_id AS unpaid_mail_template_id_35, t0.deleted_mail_template_id AS deleted_mail_template_id_36, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_37 FROM events t0 WHERE t0.company_id = ? AND t0.event_collection_id IS NULL AND t0.deleted = ?
Parameters:
[ 2 0 ] |
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\Company | No errors. |
| App\Entity\Map | No errors. |
| App\Entity\Events | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Mails | No errors. |
| App\Entity\Newsletter | No errors. |
| App\Entity\EventCollection | No errors. |
| App\Entity\Posters | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\PaymentMethod | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ResellerBilling | No errors. |
| App\Entity\DocumentTemplate | No errors. |
| App\Entity\EmailTemplate | No errors. |
| App\Entity\Seats | No errors. |
| App\Entity\Tickets | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\Categories | No errors. |
| App\Entity\EventReminder | No errors. |