Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

0.85 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.45 ms	SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id Parameters: [] View formatted query View runnable query Explain query SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id;
2	0.40 ms	SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id Parameters: [] View formatted query View runnable query Explain query SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id;

#▲

Time

Info

0.45 ms

SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.first_name AS first_name_4,
  t1.last_name AS last_name_5,
  t1.roles AS roles_6,
  t1.password AS password_7,
  t1.logo AS logo_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t0.title AS title_11,
  t0.address AS address_12,
  t0.phone AS phone_13,
  t0.statut AS statut_14,
  t1.type
FROM
  agency t0
  INNER JOIN user t1 ON t0.id = t1.id

SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id;

0.40 ms

SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.first_name AS first_name_4,
  t1.last_name AS last_name_5,
  t1.roles AS roles_6,
  t1.password AS password_7,
  t1.logo AS logo_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t0.title AS title_11,
  t0.address AS address_12,
  t0.phone AS phone_13,
  t0.statut AS statut_14,
  t1.type
FROM
  agency t0
  INNER JOIN user t1 ON t0.id = t1.id

SELECT t1.id AS id_2, t1.email AS email_3, t1.first_name AS first_name_4, t1.last_name AS last_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.logo AS logo_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.title AS title_11, t0.address AS address_12, t0.phone AS phone_13, t0.statut AS statut_14, t1.type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.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\User	No errors.
App\Entity\Agency	No errors.
App\Entity\Order	The mappings App\Entity\Order#agency and App\Entity\Agency#orders are inconsistent with each other.
App\Entity\Bike	The mappings App\Entity\Bike#kind and App\Entity\Kind#bikes are inconsistent with each other.
App\Entity\Accessory	No errors.
App\Entity\Event	No errors.
App\Entity\History	No errors.
App\Entity\Contact	No errors.

Symfony Profiler

https://solibikes.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CFrontend%255CFrontendController%253A%253Aagency

Configuration Settings

Theme