Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.82 ms Query time

0 Invalid entities

81 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.82 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.complement AS complement_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.etablissement_email AS etablissement_email_7, t0.group_email AS group_email_8, t0.etablissement_phone AS etablissement_phone_9, t0.group_phone AS group_phone_10, t0.animateur AS animateur_11, t0.group_description AS group_description_12, t0.logo_name AS logo_name_13, t0.logo_size AS logo_size_14, t0.header_name AS header_name_15, t0.header_size AS header_size_16, t0.work_meeting AS work_meeting_17, t0.is_active AS is_active_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.type_etablissement_id AS type_etablissement_id_21, t22.id AS id_23, t22.email AS email_24, t22.roles AS roles_25, t22.password AS password_26, t22.first_name AS first_name_27, t22.last_name AS last_name_28, t22.is_activ AS is_activ_29, t22.is_verified AS is_verified_30, t22.login_name AS login_name_31, t22.avatar_name AS avatar_name_32, t22.avatar_size AS avatar_size_33, t22.typeuser AS typeuser_34, t22.adress1 AS adress1_35, t22.adress2 AS adress2_36, t22.zipcode AS zipcode_37, t22.city AS city_38, t22.phone_desk AS phone_desk_39, t22.phone_gsm AS phone_gsm_40, t22.created_at AS created_at_41, t22.updated_at AS updated_at_42, t22.etablissement_id AS etablissement_id_43 FROM etablissement t0 LEFT JOIN `user` t22 ON t22.etablissement_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.complement AS complement_4,
  t0.zipcode AS zipcode_5,
  t0.city AS city_6,
  t0.etablissement_email AS etablissement_email_7,
  t0.group_email AS group_email_8,
  t0.etablissement_phone AS etablissement_phone_9,
  t0.group_phone AS group_phone_10,
  t0.animateur AS animateur_11,
  t0.group_description AS group_description_12,
  t0.logo_name AS logo_name_13,
  t0.logo_size AS logo_size_14,
  t0.header_name AS header_name_15,
  t0.header_size AS header_size_16,
  t0.work_meeting AS work_meeting_17,
  t0.is_active AS is_active_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.type_etablissement_id AS type_etablissement_id_21,
  t22.id AS id_23,
  t22.email AS email_24,
  t22.roles AS roles_25,
  t22.password AS password_26,
  t22.first_name AS first_name_27,
  t22.last_name AS last_name_28,
  t22.is_activ AS is_activ_29,
  t22.is_verified AS is_verified_30,
  t22.login_name AS login_name_31,
  t22.avatar_name AS avatar_name_32,
  t22.avatar_size AS avatar_size_33,
  t22.typeuser AS typeuser_34,
  t22.adress1 AS adress1_35,
  t22.adress2 AS adress2_36,
  t22.zipcode AS zipcode_37,
  t22.city AS city_38,
  t22.phone_desk AS phone_desk_39,
  t22.phone_gsm AS phone_gsm_40,
  t22.created_at AS created_at_41,
  t22.updated_at AS updated_at_42,
  t22.etablissement_id AS etablissement_id_43
FROM
  etablissement t0
  LEFT JOIN `user` t22 ON t22.etablissement_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.complement AS complement_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.etablissement_email AS etablissement_email_7, t0.group_email AS group_email_8, t0.etablissement_phone AS etablissement_phone_9, t0.group_phone AS group_phone_10, t0.animateur AS animateur_11, t0.group_description AS group_description_12, t0.logo_name AS logo_name_13, t0.logo_size AS logo_size_14, t0.header_name AS header_name_15, t0.header_size AS header_size_16, t0.work_meeting AS work_meeting_17, t0.is_active AS is_active_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.type_etablissement_id AS type_etablissement_id_21, t22.id AS id_23, t22.email AS email_24, t22.roles AS roles_25, t22.password AS password_26, t22.first_name AS first_name_27, t22.last_name AS last_name_28, t22.is_activ AS is_activ_29, t22.is_verified AS is_verified_30, t22.login_name AS login_name_31, t22.avatar_name AS avatar_name_32, t22.avatar_size AS avatar_size_33, t22.typeuser AS typeuser_34, t22.adress1 AS adress1_35, t22.adress2 AS adress2_36, t22.zipcode AS zipcode_37, t22.city AS city_38, t22.phone_desk AS phone_desk_39, t22.phone_gsm AS phone_gsm_40, t22.created_at AS created_at_41, t22.updated_at AS updated_at_42, t22.etablissement_id AS etablissement_id_43 FROM etablissement t0 LEFT JOIN `user` t22 ON t22.etablissement_id = t0.id;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\Admin\EtablissementController->index (line 49)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Admin\Etablissement	44
App\Entity\Admin\User	35
App\Entity\Admin\TypeEtablissement	2

Entities Mapping

Class	Mapping errors
App\Entity\Admin\Etablissement	No errors.
App\Entity\Admin\TypeEtablissement	No errors.
App\Entity\Admin\User	No errors.
App\Entity\Webapp\Article	No errors.
App\Entity\Webapp\Section	No errors.
App\Entity\Gestapp\Ressources	No errors.
App\Entity\Admin\Message	No errors.
App\Entity\Webapp\Comment	No errors.
App\Entity\Webapp\Page	No errors.

Symfony Profiler

GET https://www.collegiens-citoyens.francas40.fr/op_admin/etablissement?page=1

Configuration Settings

Theme

Page Width