Query Metrics
8
Database Queries
3
Different statements
30.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
16.61 ms (55.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.colorCode AS colorCode_4, t0.nameAr AS nameAr_5, t0.position AS position_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id IS NULL ORDER BY t0.position ASC
Parameters:
[] |
|
12.07 ms (40.00%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.colorCode AS colorCode_4, t0.nameAr AS nameAr_5, t0.position AS position_6, t0.parent_category_id AS parent_category_id_7 FROM category t0 WHERE t0.parent_category_id = ?
Parameters:
[
2
]
|
|
1.49 ms (4.94%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.colorCode AS colorCode_4, t0.nameAr AS nameAr_5, t0.position AS position_6, t0.parent_category_id AS parent_category_id_7 FROM category t0
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Category | No errors. |
| App\Entity\Organizer | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\SearchLog | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\User | No errors. |
| App\Entity\EventClaimRequest | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\Description | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\ActivityLog | No errors. |
| App\Entity\Promotion | No errors. |
| App\Entity\UserFavouriteEvent | No errors. |
| App\Entity\Section\Section | No errors. |
| App\Entity\LoginLog | No errors. |
| App\Entity\Transaction | No errors. |
| App\Entity\Participant | No errors. |