https://crmsuzielc.fr/get-childs-from-user?userid=15660

Query Metrics

336 Database Queries
4 Different statements
54.96 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • The field App\Entity\UserDomains#users is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#userdomains does not contain the required 'inversedBy="users"' attribute.
App\Entity\Contributions No errors.