Query Metrics
20
Database Queries
10
Different statements
17.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.52 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.github_id AS github_id_3, t0.github_access_token AS github_access_token_4, t0.facebook_id AS facebook_id_5, t0.facebook_access_token AS facebook_access_token_6, t0.google_id AS google_id_7, t0.google_access_token AS google_access_token_8, t0.linkedin_id AS linkedin_id_9, t0.linkedin_access_token AS linkedin_access_token_10, t0.twitter_id AS twitter_id_11, t0.twitter_access_token AS twitter_access_token_12, t0.yahoo_id AS yahoo_id_13, t0.yahoo_access_token AS yahoo_access_token_14, t0.password AS password_15, t0.is_verified AS is_verified_16, t0.avatarPath AS avatarPath_17, t0.phoneNumber AS phoneNumber_18, t0.gender AS gender_19, t0.birthday AS birthday_20, t0.birthplace AS birthplace_21, t0.nationality AS nationality_22, t0.location AS location_23, t0.region AS region_24, t0.department AS department_25, t0.academicLevel AS academicLevel_26, t0.numCni AS numCni_27, t0.status AS status_28, t0.full_name AS full_name_29, t0.security_question AS security_question_30, t0.security_answer AS security_answer_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.image_name AS image_name_34, t0.domain_id AS domain_id_35 FROM user t0 WHERE t0.id = ?
Parameters:
[
120
]
|
| 2 | 0.53 ms |
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 0.68 ms |
SELECT a0_.id AS id_0, a0_.head_teacher AS head_teacher_1, a0_.course_id AS course_id_2, a0_.teacher_id AS teacher_id_3, a0_.year_id AS year_id_4 FROM attribution a0_ WHERE a0_.year_id = ?
Parameters:
[
7
]
|
| 4 | 2.59 ms |
SELECT c0_.id AS id_0, c0_.wording AS wording_1, c0_.coefficient AS coefficient_2, c0_.code AS code_3, c0_.domain_id AS domain_id_4, c0_.module_id AS module_id_5 FROM course c0_ WHERE c0_.id NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2 4 66 176 177 94 95 151 152 164 184 185 35 302 38 39 79 3 37 92 150 223 8 9 10 11 12 13 30 31 46 47 48 49 50 51 52 53 178 179 70 71 72 73 83 84 85 86 132 133 146 147 155 156 100 101 102 103 93 129 222 36 5 28 29 42 43 68 81 98 99 139 142 162 174 214 215 216 217 165 166 32 33 69 44 45 82 229 230 232 233 368 369 372 370 303 304 307 373 374 375 378 186 187 180 181 188 189 58 204 205 59 89 76 20 21 202 203 110 111 134 144 157 169 309 381 382 63 24 25 62 77 90 112 113 313 225 161 136 172 226 224 362 365 377 356 22 23 310 311 158 170 159 171 206 207 208 209 400 401 402 403 210 211 212 213 227 228 314 315 354 355 60 61 18 19 56 57 88 75 108 109 137 143 160 173 198 199 200 201 26 27 64 65 78 91 114 115 140 141 163 175 218 219 220 221 231 234 244 245 257 258 270 283 335 312 308 280 296 297 298 299 300 338 339 246 259 379 391 395 398 399 242 255 267 289 295 241 254 278 291 292 266 318 359 268 340 341 342 358 357 271 281 286 243 256 269 279 282 293 336 337 389 384 385 386 388 390 392 393 394 396 397 235 273 260 284 330 331 236 237 247 248 274 275 262 261 285 332 333 334 238 249 263 329 276 328 366 367 239 250 277 290 264 327 240 251 265 272 287 320 294 326 360 361 14 15 40 41 67 80 96 97 130 149 153 168 194 195 196 197 305 288 126 ] |
| 5 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 6 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 7 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 8 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 9 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 10 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 11 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 12 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 13 | 2.92 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.github_id AS github_id_2, u0_.github_access_token AS github_access_token_3, u0_.facebook_id AS facebook_id_4, u0_.facebook_access_token AS facebook_access_token_5, u0_.google_id AS google_id_6, u0_.google_access_token AS google_access_token_7, u0_.linkedin_id AS linkedin_id_8, u0_.linkedin_access_token AS linkedin_access_token_9, u0_.twitter_id AS twitter_id_10, u0_.twitter_access_token AS twitter_access_token_11, u0_.yahoo_id AS yahoo_id_12, u0_.yahoo_access_token AS yahoo_access_token_13, u0_.password AS password_14, u0_.is_verified AS is_verified_15, u0_.avatarPath AS avatarPath_16, u0_.phoneNumber AS phoneNumber_17, u0_.gender AS gender_18, u0_.birthday AS birthday_19, u0_.birthplace AS birthplace_20, u0_.nationality AS nationality_21, u0_.location AS location_22, u0_.region AS region_23, u0_.department AS department_24, u0_.academicLevel AS academicLevel_25, u0_.numCni AS numCni_26, u0_.status AS status_27, u0_.full_name AS full_name_28, u0_.security_question AS security_question_29, u0_.security_answer AS security_answer_30, u0_.created_at AS created_at_31, u0_.updated_at AS updated_at_32, u0_.image_name AS image_name_33, u0_.domain_id AS domain_id_34 FROM user u0_ ORDER BY u0_.full_name ASC
Parameters:
[] |
| 14 | 0.62 ms |
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1
Parameters:
[
1
]
|
| 15 | 1.00 ms |
SELECT t0.id AS id_1, t0.officialExamResult AS officialExamResult_2, t0.finance_holder AS finance_holder_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.class_room_id AS class_room_id_7, t0.school_year_id AS school_year_id_8 FROM subscription t0 WHERE t0.school_year_id = ?
Parameters:
[
7
]
|
| 16 | 0.69 ms |
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1
Parameters:
[
1
]
|
| 17 | 3.94 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.github_id AS github_id_2, u0_.github_access_token AS github_access_token_3, u0_.facebook_id AS facebook_id_4, u0_.facebook_access_token AS facebook_access_token_5, u0_.google_id AS google_id_6, u0_.google_access_token AS google_access_token_7, u0_.linkedin_id AS linkedin_id_8, u0_.linkedin_access_token AS linkedin_access_token_9, u0_.twitter_id AS twitter_id_10, u0_.twitter_access_token AS twitter_access_token_11, u0_.yahoo_id AS yahoo_id_12, u0_.yahoo_access_token AS yahoo_access_token_13, u0_.password AS password_14, u0_.is_verified AS is_verified_15, u0_.avatarPath AS avatarPath_16, u0_.phoneNumber AS phoneNumber_17, u0_.gender AS gender_18, u0_.birthday AS birthday_19, u0_.birthplace AS birthplace_20, u0_.nationality AS nationality_21, u0_.location AS location_22, u0_.region AS region_23, u0_.department AS department_24, u0_.academicLevel AS academicLevel_25, u0_.numCni AS numCni_26, u0_.status AS status_27, u0_.full_name AS full_name_28, u0_.security_question AS security_question_29, u0_.security_answer AS security_answer_30, u0_.created_at AS created_at_31, u0_.updated_at AS updated_at_32, u0_.image_name AS image_name_33, u0_.domain_id AS domain_id_34 FROM user u0_ LEFT JOIN attribution a1_ ON u0_.id = a1_.teacher_id LEFT JOIN school_year s2_ ON a1_.year_id = s2_.id WHERE s2_.id = ? ORDER BY u0_.full_name ASC
Parameters:
[
7
]
|
| 18 | 0.74 ms |
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id
Parameters:
[] |
| 19 | 0.34 ms |
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1
Parameters:
[
1
]
|
| 20 | 1.24 ms |
SELECT COUNT(c0_.id) AS sclr_0, c0_.id AS id_1 FROM class_room c0_ INNER JOIN subscription s1_ ON c0_.id = s1_.class_room_id WHERE s1_.school_year_id = ? GROUP BY c0_.id
Parameters:
[
7
]
|
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\Domain | No errors. |
| App\Entity\Email | No errors. |
| App\Entity\Attribution | No errors. |
| App\Entity\MainTeacher | No errors. |
| App\Entity\SchoolYear | No errors. |
| App\Entity\PaymentPlan | No errors. |
| App\Entity\Quater | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\Course | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\Evaluation | No errors. |
| App\Entity\Student | No errors. |
| App\Entity\ClassRoom | No errors. |
| App\Entity\Installment | No errors. |