http://cnfcpp1.abshore.com/show/service/detail/6

Query Metrics

5 Database Queries
5 Different statements
2.99 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.25 ms
SELECT t0.id AS id_5, t0.axe AS axe_6, t0.description AS description_7, t0.type FROM service t0 LEFT JOIN intervention_entreprise_service t1 ON t0.id = t1.id LEFT JOIN formations_service t2 ON t0.id = t2.id LEFT JOIN programme_formation_service t3 ON t0.id = t3.id LEFT JOIN other_service t4 ON t0.id = t4.id WHERE t0.id = ?
Parameters:
[
  6
]
2 0.81 ms
SELECT AVG(f0_.stars) AS sclr_0, COUNT(d1_.id) AS sclr_1 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = ?
Parameters:
[
  6
]
3 0.45 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.is_showable AS is_showable_3, t0.service_id AS service_id_4 FROM rubrique t0 WHERE t0.service_id = ?
Parameters:
[
  6
]
4 0.23 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.rubrique_id AS rubrique_id_3 FROM prestation t0 WHERE t0.rubrique_id = ?
Parameters:
[
  14
]
5 0.25 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.is_showable AS is_showable_4, t0.file AS file_5, t0.prestation_id AS prestation_id_6 FROM module t0 WHERE t0.prestation_id = ?
Parameters:
[
  30
]

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\Service No errors.
App\Entity\InterventionEntrepriseService No errors.
App\Entity\FormationsService No errors.
App\Entity\ProgrammeFormationService No errors.
App\Entity\OtherService No errors.
App\Entity\Rubrique No errors.
App\Entity\Feedback No errors.
App\Entity\DemandeService No errors.
App\Entity\Prestation No errors.
App\Entity\Module No errors.
App\Entity\GroupeDemande No errors.