Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

0.88 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.46 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.42 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.46 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.42 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.
App\Entity\Period	No errors.
App\Entity\Discount	No errors.
App\Entity\Participant	No errors.
App\Entity\OrderParticipantBike	No errors.
App\Entity\Circuit	No errors.
App\Entity\Dealer	No errors.
App\Entity\OrderCircuit	No errors.
App\Entity\Category	No errors.
App\Entity\Kind	The association App\Entity\Kind#bikes refers to the owning side field App\Entity\Bike#Type which does not exist.
App\Entity\Size	No errors.
App\Entity\Brand	No errors.
App\Entity\CategoryAccessory	No errors.

Symfony Profiler

http://solibikes.com/contact/add

Configuration Settings

Theme