Query Metrics
2
Database Queries
2
Different statements
50.48 ms
Query time
0
Invalid entities
18
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.legacy_id AS legacy_id_1, p0_.title AS title_2, p0_.description AS description_3, p0_.experience_info AS experience_info_4, p0_.accreditation_info AS accreditation_info_5, p0_.seminar_type_info AS seminar_type_info_6, p0_.requirements_info AS requirements_info_7, p0_.company_name AS company_name_8, p0_.address_extra AS address_extra_9, p0_.street AS street_10, p0_.house_number AS house_number_11, p0_.postal_code AS postal_code_12, p0_.city AS city_13, p0_.state_name AS state_name_14, p0_.country AS country_15, p0_.latitude AS latitude_16, p0_.longitude AS longitude_17, p0_.contact_person AS contact_person_18, p0_.phone AS phone_19, p0_.fax AS fax_20, p0_.email AS email_21, p0_.website AS website_22, p0_.status_code AS status_code_23, p0_.is_active AS is_active_24, p0_.legacy_inserted_at AS legacy_inserted_at_25, p0_.legacy_updated_at AS legacy_updated_at_26, p0_.legacy_deleted_at AS legacy_deleted_at_27, p0_.created_at AS created_at_28, p0_.updated_at AS updated_at_29 FROM providers p0_ WHERE p0_.is_active = ? ORDER BY p0_.title ASC
Parameters:
[
1
]
|
| 2 | 50.27 ms |
SELECT s0_.provider_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM seminar_events s0_ WHERE s0_.provider_id IN (?) AND s0_.is_active = ? AND s0_.starts_at IS NOT NULL AND s0_.starts_at >= ? GROUP BY s0_.provider_id
Parameters:
[ 57 1 "2026-03-20 00:00:00" ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Provider | 18 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Provider | No errors. |
| App\Entity\SeminarEvent | No errors. |