Query Metrics
4
Database Queries
4
Different statements
1.41 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.32 ms |
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, t0.homepage_newsletter_enabled AS homepage_newsletter_enabled_25, t0.company_logo AS company_logo_26, t0.locked AS locked_27, t0.show_on_homepage AS show_on_homepage_28, t0.show_events_on_homepage AS show_events_on_homepage_29, t0.stripe_account_id AS stripe_account_id_30, t0.stripe_fee_percent_bps AS stripe_fee_percent_bps_31, t0.stripe_fee_cents AS stripe_fee_cents_32, t0.birthday_reminder_recipients AS birthday_reminder_recipients_33, t0.birthday_reminder_sender_address_id AS birthday_reminder_sender_address_id_34 FROM company t0
Parameters:
[] |
| 2 | 0.31 ms |
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:
[
6
]
|
| 3 | 0.46 ms |
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.archived AS archived_9, t0.payment_deadline_days AS payment_deadline_days_10, t0.paid_mail AS paid_mail_11, t0.unpaid_mail AS unpaid_mail_12, t0.deleted_mail AS deleted_mail_13, t0.reserved_mail AS reserved_mail_14, t0.has_paypal AS has_paypal_15, t0.ticket_template AS ticket_template_16, t0.location AS location_17, t0.invoice_template AS invoice_template_18, t0.hide_from_homepage AS hide_from_homepage_19, t0.description AS description_20, t0.long_description AS long_description_21, t0.duration AS duration_22, t0.hero_image_path AS hero_image_path_23, t0.card_image_path AS card_image_path_24, t0.seating_type AS seating_type_25, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_26, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_27, t0.payment_method_windows_json AS payment_method_windows_json_28, t0.map_id AS map_id_29, t0.poster_id AS poster_id_30, t0.company_id AS company_id_31, t0.event_collection_id AS event_collection_id_32, t0.ticket_document_template_id AS ticket_document_template_id_33, t0.invoice_document_template_id AS invoice_document_template_id_34, t0.reserved_mail_template_id AS reserved_mail_template_id_35, t0.paid_mail_template_id AS paid_mail_template_id_36, t0.unpaid_mail_template_id AS unpaid_mail_template_id_37, t0.deleted_mail_template_id AS deleted_mail_template_id_38, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_39 FROM events t0 WHERE t0.event_collection_id = ?
Parameters:
[
15
]
|
| 4 | 0.32 ms |
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.archived AS archived_9, t0.payment_deadline_days AS payment_deadline_days_10, t0.paid_mail AS paid_mail_11, t0.unpaid_mail AS unpaid_mail_12, t0.deleted_mail AS deleted_mail_13, t0.reserved_mail AS reserved_mail_14, t0.has_paypal AS has_paypal_15, t0.ticket_template AS ticket_template_16, t0.location AS location_17, t0.invoice_template AS invoice_template_18, t0.hide_from_homepage AS hide_from_homepage_19, t0.description AS description_20, t0.long_description AS long_description_21, t0.duration AS duration_22, t0.hero_image_path AS hero_image_path_23, t0.card_image_path AS card_image_path_24, t0.seating_type AS seating_type_25, t0.reserve_deadline_relative_hours AS reserve_deadline_relative_hours_26, t0.reserve_user_deadline_relative_hours AS reserve_user_deadline_relative_hours_27, t0.payment_method_windows_json AS payment_method_windows_json_28, t0.map_id AS map_id_29, t0.poster_id AS poster_id_30, t0.company_id AS company_id_31, t0.event_collection_id AS event_collection_id_32, t0.ticket_document_template_id AS ticket_document_template_id_33, t0.invoice_document_template_id AS invoice_document_template_id_34, t0.reserved_mail_template_id AS reserved_mail_template_id_35, t0.paid_mail_template_id AS paid_mail_template_id_36, t0.unpaid_mail_template_id AS unpaid_mail_template_id_37, t0.deleted_mail_template_id AS deleted_mail_template_id_38, t0.reservation_edited_mail_template_id AS reservation_edited_mail_template_id_39 FROM events t0 WHERE t0.company_id = ? AND t0.event_collection_id IS NULL AND t0.deleted = ?
Parameters:
[ 6 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\CustomerCompanySubscription | 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. |