Query Metrics
10
Database Queries
3
Different statements
6.91 ms
Query time
2
Invalid entities
30
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.67 ms (53.08%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.quantity AS quantity_4, t0.sold AS sold_5, t0.description AS description_6, t0.early_bird AS early_bird_7, t0.end_date AS end_date_8, t0.event_id AS event_id_9 FROM ticket_type t0 WHERE t0.event_id = ?
Parameters:
[
7
]
|
|
2.39 ms (34.59%) |
1 |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.event_date AS event_date_3, e0_.start_time AS start_time_4, e0_.end_time AS end_time_5, e0_.venue AS venue_6, e0_.address AS address_7, e0_.category AS category_8, e0_.image_url AS image_url_9, e0_.capacity AS capacity_10, e0_.sold_tickets AS sold_tickets_11, e0_.status AS status_12, e0_.tags AS tags_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15, e0_.image AS image_16, e0_.qr_code_url AS qr_code_url_17, e0_.organizer_id AS organizer_id_18 FROM event e0_ ORDER BY e0_.event_date ASC
Parameters:
[] |
|
0.85 ms (12.33%) |
1 |
SELECT DISTINCT e0_.category AS category_0 FROM event e0_ ORDER BY e0_.category ASC
Parameters:
[] |
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\EventTicket | 17 |
| App\Entity\Event | 8 |
| App\Entity\User | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Event |
|
| App\Entity\User | No errors. |
| App\Entity\EventTicket | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\BilletsRestants |
|
| App\Entity\CartItem | No errors. |