Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

3.68 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
2.43 ms (65.89%)	1	SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.is_active = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.is_active = ? SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.is_active = 1;
1.26 ms (34.11%)	1	SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0;

Time▼

Count

Info

2.43 ms
(65.89%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.modified AS modified_5,
  t0.created AS created_6,
  t0.is_active AS is_active_7,
  t0.currency AS currency_8
FROM
  countries t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.is_active = 1;

1.26 ms
(34.11%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.modified AS modified_5,
  t0.created AS created_6,
  t0.is_active AS is_active_7,
  t0.currency AS currency_8
FROM
  countries t0

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
remote	doctrine.dbal.remote_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
remote	doctrine.orm.remote_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Countries	No errors.
App\Entity\Distributors	No errors.
App\Entity\Clinics	The association App\Entity\Clinics#retailUsers refers to the owning side field App\Entity\RetailUsers#clinic which does not exist.
App\Entity\RetailUsers	The association App\Entity\RetailUsers#addresses refers to the owning side field App\Entity\Addresses#retail which does not exist. The association App\Entity\RetailUsers#baskets refers to the owning side field App\Entity\Baskets#retailUser which does not exist. The association App\Entity\RetailUsers#orders refers to the owning side field App\Entity\Orders#retail which does not exist.

remote entity manager

No loaded entities.