https://activityme.sf9.io/activities

Query Metrics

8 Database Queries
3 Different statements
30.18 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 16.61 ms
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:
[]
2 1.49 ms
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:
[]
3 1.60 ms
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
]
4 1.80 ms
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:
[
  4
]
5 4.24 ms
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:
[
  7
]
6 1.53 ms
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:
[
  1
]
7 1.65 ms
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:
[
  9
]
8 1.26 ms
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:
[
  3
]

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