Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

5 Database Queries

2 Different statements

2.51 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.80 ms (71.79%)	4	SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = ? SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = 1;
0.71 ms (28.21%)	1	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 Parameters: [] View formatted query View runnable query Explain query 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 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;

Time▼

Count

Info

1.80 ms
(71.79%)

SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  AVG(f0_.stars) AS sclr_0
FROM
  feedback f0_
  INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id
WHERE
  d1_.service_id = ?

SELECT AVG(f0_.stars) AS sclr_0 FROM feedback f0_ INNER JOIN demande_service d1_ ON f0_.demande_id = d1_.id WHERE d1_.service_id = 1;

0.71 ms
(28.21%)

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

Parameters:

[]

View formatted query View runnable query Explain query

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

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;

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.

Symfony Profiler

http://cnfcpp1.abshore.com/list/service/index/

Configuration Settings

Theme