Query Metrics
16
Database Queries
5
Different statements
2806.65 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 6.13 ms |
SELECT t0.id AS id_1, t0.token AS token_2 FROM bdd_api t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 2 | 8.93 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.prix AS prix_2, b0_.date_debut AS date_debut_3, b0_.date_fin AS date_fin_4 FROM bdd_ticket_repas b0_ WHERE b0_.date_debut <= ? AND b0_.date_fin >= ?
Parameters:
[ "2026-09-30 00:00:00" "2025-10-01 00:00:00" ]
|
||||||||||||||||||||||||||||
| 3 | 2509.57 ms |
SELECT s0_.id AS id_0, s0_.signature AS signature_1, s0_.numero_bon_commande AS numero_bon_commande_2, s0_.filename AS filename_3, s0_.date_signature AS date_signature_4, s0_.signature_filename AS signature_filename_5, s0_.dossier AS dossier_6, s0_.statut AS statut_7, s0_.facture AS facture_8, s0_.statut_non_facture AS statut_non_facture_9, s0_.created_at AS created_at_10, s0_.type_quantite AS type_quantite_11, s0_.formation_pu_ht AS formation_pu_ht_12, s0_.remise_ht AS remise_ht_13, s0_.type_quantite_materiel AS type_quantite_materiel_14, s0_.type_quantite_deplacement AS type_quantite_deplacement_15, s0_.type_quantite_document AS type_quantite_document_16, s0_.materiel_pu_ht AS materiel_pu_ht_17, s0_.deplacement_pu_ht AS deplacement_pu_ht_18, s0_.document_pu_ht AS document_pu_ht_19, s0_.dossier_pu_ht AS dossier_pu_ht_20, count(s1_.id) AS sclr_21, f2_.nombre_jour AS nombre_jour_22, s3_.date_start AS date_start_23, s0_.session_id AS session_id_24, s0_.client_id AS client_id_25 FROM session_client_order s0_ LEFT JOIN sessions s4_ ON s0_.session_id = s4_.id LEFT JOIN session_dates s3_ ON s4_.id = s3_.session_id LEFT JOIN formations f2_ ON s4_.formation_id = f2_.id LEFT JOIN session_stagiaire s1_ ON s0_.id = s1_.session_client_order_id LEFT JOIN facture f5_ ON s0_.id = f5_.session_order_client_id WHERE s0_.statut_non_facture IS NULL AND s3_.dernier_jour = 1 AND (s3_.date_start BETWEEN ? AND ?) AND s1_.statut_id <= 3 AND f5_.id IS NULL GROUP BY s0_.id
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" ]
|
||||||||||||||||||||||||||||
| 4 | 4.68 ms |
SELECT s0_.session_client_order_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM session_stagiaire s0_ WHERE s0_.session_client_order_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.repas_id IS NOT NULL AND s0_.statut_id <> 4 GROUP BY s0_.session_client_order_id
Parameters:
[ 2524 2527 2530 2932 2956 3272 3273 3355 3357 3394 3410 3411 3439 3482 3550 3552 3581 3604 3615 3754 3756 3757 3790 3796 3810 3892 3952 3960 3961 3977 4115 4136 4140 4142 4163 4175 4179 4225 4255 4256 4257 4261 4277 4278 4338 4378 4387 4437 4498 4503 4516 4518 4531 4532 4533 4561 4577 4581 4582 4595 4596 4608 4634 4652 4653 4656 4664 4665 4668 4669 4672 4673 4674 4675 4679 4681 4682 4683 4699 4700 4701 4702 4705 4706 4720 4733 4734 4735 4736 4741 4742 4743 4747 4757 4760 4774 4796 4802 4803 4804 4805 4806 4808 4816 4817 4821 4837 4838 4839 4840 4843 4845 4846 4857 4858 4860 4861 4862 4863 4864 4871 4873 4874 4896 4899 4905 4908 4910 4912 4914 4917 4918 4929 4930 4931 4932 4933 4934 4951 4952 4953 4954 4955 4958 4960 4962 4963 4973 4975 4978 4979 4983 4984 4985 4996 4997 5000 5004 5005 5006 5007 5010 5013 5017 5018 5020 5024 5025 5026 5027 5029 5030 5035 5036 5037 5043 5044 5045 5046 5049 5052 5060 5066 5074 5085 5094 5096 5097 5100 5101 5103 5104 5105 5106 5107 5109 5113 5114 5116 5117 5118 5119 5120 5124 5129 5133 5134 5135 5136 5137 5138 5143 5145 5148 5149 5150 5151 5153 5154 5156 5159 5160 5161 5164 5165 5166 5167 5168 5169 5170 5173 5175 5179 5180 5181 5183 5184 5185 5186 5187 5188 5191 5192 5193 5196 5198 5200 5203 5205 5208 5209 5210 5211 5212 5215 5216 5219 5220 5222 5223 5224 5225 5226 5232 5233 5234 5238 5239 5242 5243 5245 5248 5249 5252 5253 5255 5256 5258 5260 5264 5265 5266 5268 5269 5271 5272 5273 5274 5276 5277 5282 5283 5284 5287 5288 5289 5290 5292 5293 5294 5295 5297 5298 5299 5300 5302 5303 5308 5309 5311 5312 5313 5314 5315 5316 5317 5318 5319 5321 5322 5323 5324 5325 5326 5327 5328 5329 5330 5331 5332 5333 5334 5335 5337 5338 5341 5342 5343 5344 5345 5346 5347 5348 5349 5350 5351 5353 5354 5355 5356 5357 5358 5359 5360 5361 5362 5363 5364 5368 5369 5370 5371 5372 5373 5374 5375 5376 5378 5379 5380 5381 5382 5383 5384 5385 5386 5387 5388 5389 5390 5391 5392 5393 5394 5395 5396 5397 5398 5399 5400 5401 5402 5403 5404 5405 5406 5407 5408 5409 5410 5411 5412 5413 5414 5415 5416 5417 5418 5419 5420 5421 5422 5423 5424 5425 5426 5427 5428 5429 5430 5431 5432 5433 5434 5435 5436 5437 5438 5439 5440 5441 5442 5443 5444 5446 5447 5450 5451 5452 5453 5454 5455 5456 5457 5458 5459 ]
|
||||||||||||||||||||||||||||
| 5 | 85.04 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "10" ]
|
||||||||||||||||||||||||||||
| 6 | 17.86 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "11" ]
|
||||||||||||||||||||||||||||
| 7 | 17.59 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "12" ]
|
||||||||||||||||||||||||||||
| 8 | 17.48 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "01" ]
|
||||||||||||||||||||||||||||
| 9 | 17.51 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "02" ]
|
||||||||||||||||||||||||||||
| 10 | 17.51 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "03" ]
|
||||||||||||||||||||||||||||
| 11 | 17.59 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "04" ]
|
||||||||||||||||||||||||||||
| 12 | 17.50 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "05" ]
|
||||||||||||||||||||||||||||
| 13 | 17.47 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "06" ]
|
||||||||||||||||||||||||||||
| 14 | 17.38 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "07" ]
|
||||||||||||||||||||||||||||
| 15 | 17.24 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "08" ]
|
||||||||||||||||||||||||||||
| 16 | 17.17 ms |
SELECT SUM(CASE WHEN f0_.statut = 1 THEN f1_.ht ELSE 0 END) AS sclr_0, SUM(CASE WHEN f0_.statut = 2 THEN f1_.ht ELSE 0 END) AS sclr_1, SUM(CASE WHEN f0_.statut = 3 THEN f1_.ht ELSE 0 END) AS sclr_2, SUM(f1_.ht) AS sclr_3 FROM session_client_order s2_ LEFT JOIN sessions s3_ ON s2_.session_id = s3_.id LEFT JOIN session_dates s4_ ON s3_.id = s4_.session_id LEFT JOIN facture f0_ ON s2_.id = f0_.session_order_client_id LEFT JOIN facture_prestation f1_ ON f0_.id = f1_.facture_id WHERE (s3_.etat BETWEEN 1 AND 3) AND s4_.dernier_jour = 1 AND (s4_.date_start BETWEEN ? AND ?) AND SUBSTRING(s4_.date_start FROM 6 FOR 2) = ?
Parameters:
[ "2025-10-01 00:00:00" "2026-09-30 00:00:00" "09" ]
|
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\Bdd\Api\BddApi | No errors. |
| App\Entity\Bdd\BddTicketRepas | No errors. |
| App\Entity\Sessions\SessionClientOrder | No errors. |
| App\Entity\Sessions\Sessions |
|
| App\Entity\Sessions\SessionDates | No errors. |
| App\Entity\Formations\Formations | No errors. |
| App\Entity\Sessions\SessionStagiaire | No errors. |
| App\Entity\Facturations\Facture | No errors. |
| App\Entity\Clients\Clients | No errors. |
| App\Entity\Facturations\FacturePrestation | No errors. |