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

Query Metrics

20 Database Queries
8 Different statements
29.79 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.82 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"
]
2 1.26 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"
]
3 3.49 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"
]
4 0.56 ms
SELECT NEXTVAL('activity_id_seq')
Parameters:
[]
5 0.96 ms
"START TRANSACTION"
Parameters:
[]
6 3.81 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:
[
  15125
  ""
  "[]"
  "172.69.211.190"
  "GET"
  "/app/dashboard/chart_seven"
  "fr"
  "{"q":"\/app\/dashboard\/chart_seven"}"
  "app_chart_seven"
  "2025-09-14 07:15:06"
  "2025-09-14 07:15:06"
  null
  "01990afd-cf23-a731-ae0b-219900e63d5f"
  "01990afc-4d01-098d-8485-beaa0e93eb12"
]
7 2.84 ms
"COMMIT"
Parameters:
[]
8 1.53 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-01-01 00:00:00"
  "2025-01-31 23:59:59"
]
9 0.72 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-02-01 00:00:00"
  "2025-02-28 23:59:59"
]
10 1.19 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-03-01 00:00:00"
  "2025-03-31 23:59:59"
]
11 1.38 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-04-01 00:00:00"
  "2025-04-30 23:59:59"
]
12 0.67 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-05-01 00:00:00"
  "2025-05-31 23:59:59"
]
13 0.48 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-06-01 00:00:00"
  "2025-06-30 23:59:59"
]
14 1.54 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-07-01 00:00:00"
  "2025-07-31 23:59:59"
]
15 1.45 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-08-01 00:00:00"
  "2025-08-31 23:59:59"
]
16 0.52 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-09-01 00:00:00"
  "2025-09-30 23:59:59"
]
17 1.50 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-10-01 00:00:00"
  "2025-10-31 23:59:59"
]
18 0.73 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-11-01 00:00:00"
  "2025-11-30 23:59:59"
]
19 0.74 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-12-01 00:00:00"
  "2025-12-31 23:59:59"
]
20 1.60 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.description AS description_2, e0_.date AS date_3, e0_.type AS type_4, e0_.tags AS tags_5, e0_.created_at AS created_at_6, e0_.updated_at AS updated_at_7, e0_.deleted_at AS deleted_at_8, e0_.owner_id AS owner_id_9, e0_.season_id AS season_id_10 FROM evenement e0_ WHERE (e0_.date BETWEEN ? AND ?) AND (e0_.owner_id='01990afd-cf23-a731-ae0b-219900e63d5f') AND (e0_.season_id='01990afd-cf23-a731-ae0b-219900e63d5e') AND (e0_.deleted_at IS NULL)
Parameters:
[
  "2025-09-01 00:00:00"
  "2025-09-30 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\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.