Query Metrics
336
Database Queries
4
Different statements
54.96 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
47.94 ms (87.23%) |
328 |
SELECT t0.id AS id_1, t0.parentcontribution AS parentcontribution_2, t0.status AS status_3, t0.comment AS comment_4, t0.session_id AS session_id_5 FROM contributions t0 WHERE t0.session_id = ?
Parameters:
[
2748
]
|
|
4.38 ms (7.97%) |
1 |
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.dob AS dob_2, c0_.fathername AS fathername_3, c0_.fatherphone AS fatherphone_4, c0_.cityborn AS cityborn_5, c0_.fatheremail AS fatheremail_6, c0_.motheremail AS motheremail_7, c0_.fatherhebrewname AS fatherhebrewname_8, c0_.mothername AS mothername_9, c0_.motherphone AS motherphone_10, c0_.motherhebrewname AS motherhebrewname_11, c0_.doctorname AS doctorname_12, c0_.doctoraddress AS doctoraddress_13, c0_.doctorphone AS doctorphone_14, c0_.image AS image_15, c0_.email AS email_16, c0_.lastname AS lastname_17, c0_.firstname AS firstname_18, c0_.phone AS phone_19, c0_.gender AS gender_20, c0_.referrals AS referrals_21, c0_.sessionseta AS sessionseta_22, c0_.commentaire AS commentaire_23, c0_.doctorcity AS doctorcity_24, c0_.doctorzipcode AS doctorzipcode_25, c0_.payment AS payment_26, c0_.sessionsemail AS sessionsemail_27, c0_.fileone AS fileone_28, c0_.filetwo AS filetwo_29, c0_.filethree AS filethree_30, c0_.creationdate AS creationdate_31, c0_.finishdate AS finishdate_32, c0_.paymentmethod AS paymentmethod_33, c0_.childaddress AS childaddress_34, c0_.childzipcode AS childzipcode_35, c0_.childcity AS childcity_36, c0_.school_id AS school_id_37 FROM childs c0_ INNER JOIN childs_user c2_ ON c0_.id = c2_.childs_id INNER JOIN `user` u1_ ON u1_.id = c2_.user_id INNER JOIN schools s3_ ON c0_.school_id = s3_.id WHERE u1_.id = ? AND c0_.status <> ? AND c0_.status <> ? AND c0_.status <> ? AND c0_.status <> ?
Parameters:
[ "15660" "not_check" "Terminer" "En attente" "Terminé" ] |
|
2.47 ms (4.49%) |
6 |
SELECT s0_.id AS id_0, s0_.comment AS comment_1, s0_.report AS report_2, s0_.date AS date_3, s0_.child_id AS child_id_4, s0_.user_id AS user_id_5, s0_.domain_id AS domain_id_6 FROM sessions s0_ INNER JOIN childs c1_ ON s0_.child_id = c1_.id WHERE c1_.id = ?
Parameters:
[
380
]
|
|
0.17 ms (0.30%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1 FROM domains d0_ INNER JOIN user_domains u1_ ON d0_.id = u1_.domains_id WHERE u1_.user_id = ?
Parameters:
[
"15660"
]
|
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\Sessions | No errors. |
| App\Entity\Childs | No errors. |
| App\Entity\Domains | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Schools | No errors. |
| App\Entity\UserDomains |
|
| App\Entity\Contributions | No errors. |