Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.06 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
3.06 ms (100.00%)	1	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.namefr AS namefr_3, t0.description AS description_4, t0.active AS active_5, t0.route AS route_6, t0.service_group AS service_group_7, t0.min_role AS min_role_8, t0.public AS public_9, t0.order AS order_10, t0.admin_access AS admin_access_11, t0.engineer_access AS engineer_access_12, t0.manager_access AS manager_access_13, t0.collaborator_access AS collaborator_access_14, t0.is_hidden AS is_hidden_15, t0.logo_id AS logo_id_16, t17.id AS id_18, t17.updated_date AS updated_date_19, t17.path AS path_20 FROM service t0 LEFT JOIN service_logo t17 ON t0.logo_id = t17.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.namefr AS namefr_3, t0.description AS description_4, t0.active AS active_5, t0.route AS route_6, t0.service_group AS service_group_7, t0.min_role AS min_role_8, t0.public AS public_9, t0.order AS order_10, t0.admin_access AS admin_access_11, t0.engineer_access AS engineer_access_12, t0.manager_access AS manager_access_13, t0.collaborator_access AS collaborator_access_14, t0.is_hidden AS is_hidden_15, t0.logo_id AS logo_id_16, t17.id AS id_18, t17.updated_date AS updated_date_19, t17.path AS path_20 FROM service t0 LEFT JOIN service_logo t17 ON t0.logo_id = t17.id SELECT t0.id AS id_1, t0.slug AS slug_2, t0.namefr AS namefr_3, t0.description AS description_4, t0.active AS active_5, t0.route AS route_6, t0.service_group AS service_group_7, t0.min_role AS min_role_8, t0.public AS public_9, t0.order AS order_10, t0.admin_access AS admin_access_11, t0.engineer_access AS engineer_access_12, t0.manager_access AS manager_access_13, t0.collaborator_access AS collaborator_access_14, t0.is_hidden AS is_hidden_15, t0.logo_id AS logo_id_16, t17.id AS id_18, t17.updated_date AS updated_date_19, t17.path AS path_20 FROM service t0 LEFT JOIN service_logo t17 ON t0.logo_id = t17.id;

Time▼

Count

Info

3.06 ms
(100.00%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.namefr AS namefr_3, t0.description AS description_4, t0.active AS active_5, t0.route AS route_6, t0.service_group AS service_group_7, t0.min_role AS min_role_8, t0.public AS public_9, t0.order AS order_10, t0.admin_access AS admin_access_11, t0.engineer_access AS engineer_access_12, t0.manager_access AS manager_access_13, t0.collaborator_access AS collaborator_access_14, t0.is_hidden AS is_hidden_15, t0.logo_id AS logo_id_16, t17.id AS id_18, t17.updated_date AS updated_date_19, t17.path AS path_20 FROM service t0 LEFT JOIN service_logo t17 ON t0.logo_id = t17.id

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.namefr AS namefr_3,
  t0.description AS description_4,
  t0.active AS active_5,
  t0.route AS route_6,
  t0.service_group AS service_group_7,
  t0.min_role AS min_role_8,
  t0.public AS public_9,
  t0.order AS order_10,
  t0.admin_access AS admin_access_11,
  t0.engineer_access AS engineer_access_12,
  t0.manager_access AS manager_access_13,
  t0.collaborator_access AS collaborator_access_14,
  t0.is_hidden AS is_hidden_15,
  t0.logo_id AS logo_id_16,
  t17.id AS id_18,
  t17.updated_date AS updated_date_19,
  t17.path AS path_20
FROM
  service t0
  LEFT JOIN service_logo t17 ON t0.logo_id = t17.id

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.namefr AS namefr_3, t0.description AS description_4, t0.active AS active_5, t0.route AS route_6, t0.service_group AS service_group_7, t0.min_role AS min_role_8, t0.public AS public_9, t0.order AS order_10, t0.admin_access AS admin_access_11, t0.engineer_access AS engineer_access_12, t0.manager_access AS manager_access_13, t0.collaborator_access AS collaborator_access_14, t0.is_hidden AS is_hidden_15, t0.logo_id AS logo_id_16, t17.id AS id_18, t17.updated_date AS updated_date_19, t17.path AS path_20 FROM service t0 LEFT JOIN service_logo t17 ON t0.logo_id = t17.id;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
georef	doctrine.dbal.georef_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
georef	doctrine.orm.georef_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\App\Service	No errors.
App\Entity\App\LogoService	No errors.
App\Entity\Company\Company	No errors.
App\Entity\App\ServiceWidget	No errors.
App\Entity\Company\EngineerPermissions	No errors.
App\Entity\Company\CompanyRelationService	No errors.
App\Entity\Company\CompanyServices	No errors.
App\Entity\App\ServiceQuota	No errors.

georef entity manager

No loaded entities.