https://mail.crsat.cd/

Query Metrics

11 Database Queries
11 Different statements
4.33 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5 FROM imagebackground t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 0.36 ms
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM service s0_
Parameters:
[]
3 0.24 ms
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM service s0_ ORDER BY s0_.id DESC LIMIT 6
Parameters:
[]
4 0.36 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.avatar AS avatar_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM service s0_ WHERE s0_.id IN (?, ?, ?) ORDER BY s0_.id DESC
Parameters:
[
  5
  4
  3
]
5 0.26 ms
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM agenda a0_
Parameters:
[]
6 0.24 ms
SELECT DISTINCT a0_.id AS id_0, a0_.id AS id_1 FROM agenda a0_ ORDER BY a0_.id DESC LIMIT 3
Parameters:
[]
7 0.61 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.subtitle AS subtitle_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.aday AS aday_5, a0_.amonth AS amonth_6, a0_.ayear AS ayear_7, a0_.avatar AS avatar_8, a0_.updated_at AS updated_at_9, a0_.localisation AS localisation_10, a0_.author AS author_11, a0_.hours AS hours_12 FROM agenda a0_ WHERE a0_.id IN (?, ?, ?) ORDER BY a0_.id DESC
Parameters:
[
  16
  15
  14
]
8 0.33 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM project p0_
Parameters:
[]
9 0.31 ms
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM project p0_ ORDER BY p0_.id DESC LIMIT 3
Parameters:
[]
10 0.49 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.subtitle AS subtitle_2, p0_.description AS description_3, p0_.goal AS goal_4, p0_.approach AS approach_5, p0_.purpose AS purpose_6, p0_.author AS author_7, p0_.partners AS partners_8, p0_.avatar AS avatar_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11 FROM project p0_ WHERE p0_.id IN (?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[
  9
  8
  7
]
11 0.40 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.middlename AS middlename_3, t0.lastname AS lastname_4, t0.avatar AS avatar_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.mrole AS mrole_8, t0.professionaloverview AS professionaloverview_9, t0.linkedin AS linkedin_10 FROM member 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\Project No errors.
App\Entity\Service No errors.
App\Entity\Agenda No errors.
App\Entity\Member No errors.
App\Entity\Department No errors.
App\Entity\Imagebackground No errors.