Query Metrics
3
Database Queries
2
Different statements
6.75 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
6.01 ms (89.04%) |
2 |
SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1, a0_.email AS email_2, a0_.phone AS phone_3, a0_.enabled AS enabled_4, a0_.create_at AS create_at_5, a0_.update_at AS update_at_6, a0_.description AS description_7 FROM association a0_ INNER JOIN event e1_ ON a0_.id = e1_.association_id WHERE e1_.id IS NOT NULL ORDER BY a0_.id ASC
Parameters:
[] |
0.74 ms (10.96%) |
1 |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.external_link AS external_link_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.place_name AS place_name_6, e0_.postal_code AS postal_code_7, e0_.town AS town_8, e0_.address_line AS address_line_9, e0_.price AS price_10, e0_.create_at AS create_at_11, e0_.update_at AS update_at_12, e0_.public AS public_13, e0_.association_id AS association_id_14 FROM event e0_ WHERE e0_.association_id IN (NULL) AND ((e0_.start_date >= ? AND e0_.end_date <= ?) OR (e0_.start_date <= ? AND e0_.end_date >= ?) OR (e0_.end_date <= ? AND e0_.end_date >= ?) OR (e0_.start_date >= ? AND e0_.start_date <= ?)) AND e0_.public = 1 ORDER BY e0_.start_date ASC
Parameters:
[ "2024-12-22 00:00:00" "2025-01-05 23:59:59" "2024-12-22 00:00:00" "2025-01-05 23:59:59" "2025-01-05 23:59:59" "2024-12-22 00:00:00" "2024-12-22 00:00:00" "2025-01-05 23:59:59" ] |
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\Association | No errors. |
App\Entity\Event | No errors. |