GET https://clevernursery.com/app/dashboard/chart_one?q=%2Fapp%2Fdashboard%2Fchart_one

Response
200 OK
Browse referrer URL
IP
172.69.211.191
Profiled on
Token
14abb4

Query Metrics

21 Database Queries
8 Different statements
69.41 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 6.08 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_verified AS is_verified_7, t0.photo AS photo_8, t0.google_id AS google_id_9, t0.facebook_id AS facebook_id_10, t0.last_login AS last_login_11, t0.phone AS phone_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.company_id AS company_id_17 FROM "user" t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  "01990afc-4d01-098d-8485-beaa0e93eb12"
]
View formatted query    View runnable query    Explain query
2 2.34 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.size AS size_4, t0.logo AS logo_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.fax AS fax_9, t0.description AS description_10, t0.website AS website_11, t0.facebook AS facebook_12, t0.twitter AS twitter_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.tiktok AS tiktok_16, t0.rc AS rc_17, t0.nif AS nif_18, t0.nis AS nis_19, t0.is_active AS is_active_20, t0.date_format AS date_format_21, t0.languege AS languege_22, t0.currencie AS currencie_23, t0.time_zone AS time_zone_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.deleted_at AS deleted_at_27, t0.address_id AS address_id_28 FROM company t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  "01990afd-cf23-a731-ae0b-219900e63d5f"
]
View formatted query    View runnable query    Explain query
3 1.14 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.owner_id AS owner_id_10 FROM season t0 WHERE t0.owner_id = ? AND ((t0.deleted_at IS NULL))
Parameters: 
[
  "01990afd-cf23-a731-ae0b-219900e63d5f"
]
View formatted query    View runnable query    Explain query
4 0.98 ms 
SELECT NEXTVAL('activity_id_seq')
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 0.46 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 3.68 ms 
INSERT INTO activity (id, action, context, ip, method, path, locale, query, route, created_at, updated_at, deleted_at, owner_id, made_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  15113
  ""
  "[]"
  "172.69.211.191"
  "GET"
  "/app/dashboard/chart_one"
  "fr"
  "{"q":"\/app\/dashboard\/chart_one"}"
  "app_chart_one"
  "2025-09-14 06:31:10"
  "2025-09-14 06:31:10"
  null
  "01990afd-cf23-a731-ae0b-219900e63d5f"
  "01990afc-4d01-098d-8485-beaa0e93eb12"
]
View formatted query    View runnable query    Explain query
7 12.07 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 3.03 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-01-01 00:00:00"
  "2025-01-31 23:59:59"
]
View formatted query    View runnable query    Explain query
9 1.01 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-02-01 00:00:00"
  "2025-02-28 23:59:59"
]
View formatted query    View runnable query    Explain query
10 3.46 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-03-01 00:00:00"
  "2025-03-31 23:59:59"
]
View formatted query    View runnable query    Explain query
11 1.62 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-04-01 00:00:00"
  "2025-04-30 23:59:59"
]
View formatted query    View runnable query    Explain query
12 4.37 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-05-01 00:00:00"
  "2025-05-31 23:59:59"
]
View formatted query    View runnable query    Explain query
13 1.11 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-06-01 00:00:00"
  "2025-06-30 23:59:59"
]
View formatted query    View runnable query    Explain query
14 1.47 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-07-01 00:00:00"
  "2025-07-31 23:59:59"
]
View formatted query    View runnable query    Explain query
15 0.75 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-08-01 00:00:00"
  "2025-08-31 23:59:59"
]
View formatted query    View runnable query    Explain query
16 1.30 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-09-01 00:00:00"
  "2025-09-30 23:59:59"
]
View formatted query    View runnable query    Explain query
17 2.41 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-10-01 00:00:00"
  "2025-10-31 23:59:59"
]
View formatted query    View runnable query    Explain query
18 5.46 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-11-01 00:00:00"
  "2025-11-30 23:59:59"
]
View formatted query    View runnable query    Explain query
19 4.16 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-12-01 00:00:00"
  "2025-12-31 23:59:59"
]
View formatted query    View runnable query    Explain query
20 11.65 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-09-01 00:00:00"
  "2025-09-30 23:59:59"
]
View formatted query    View runnable query    Explain query
21 0.88 ms 
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.gender AS gender_3, c0_.birth_date AS birth_date_4, c0_.birth_place AS birth_place_5, c0_.blood AS blood_6, c0_.diseases AS diseases_7, c0_.allergies AS allergies_8, c0_.food_habit AS food_habit_9, c0_.behavior AS behavior_10, c0_.fears AS fears_11, c0_.interests AS interests_12, c0_.description AS description_13, c0_.status AS status_14, c0_.photo AS photo_15, c0_.first_name_ar AS first_name_ar_16, c0_.last_name_ar AS last_name_ar_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.deleted_at AS deleted_at_20, c0_.section_id AS section_id_21, c0_.owner_id AS owner_id_22, c0_.address_id AS address_id_23, c0_.season_id AS season_id_24 FROM child c0_ WHERE (c0_.created_at BETWEEN ? AND ?) AND (c0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (c0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (c0_.deleted_at IS NULL)
Parameters: 
[
  "2025-08-01 00:00:00"
  "2025-08-31 23:59:59"
]
View formatted query    View runnable query    Explain query

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\User No errors.
App\Entity\Company No errors.
App\Entity\Order No errors.
App\Entity\Subscription No errors.
App\Entity\Payment No errors.
App\Entity\Post No errors.
App\Entity\Pointing No errors.
App\Entity\AbsenceEmployee No errors.
App\Entity\Activity No errors.
App\Entity\Location No errors.
App\Entity\Expense No errors.
App\Entity\ExpenseCategory No errors.
App\Entity\Season No errors.
App\Entity\Service No errors.
App\Entity\Section No errors.
App\Entity\FamilyMember No errors.
App\Entity\Child No errors.
App\Entity\Employee No errors.
App\Entity\Classroom No errors.
App\Entity\Evenement No errors.
App\Entity\Task No errors.
App\Entity\Colleague No errors.
App\Entity\Abonnement No errors.
App\Entity\Prechild No errors.