Symfony Profiler

Query Metrics

1 Database Queries

0.84 ms Query time

0 Invalid entities

Queries

catalog connection

#▲	Time	Info
1	0.84 ms	SELECT l0_.id AS id0, l0_.isocode AS isocode1, l0_.name AS name2, l1_.id AS id3, l1_.isocode AS isocode4 FROM languages l1_, languages_trn l0_ WHERE l1_.id = l0_.language_id AND l0_.isocode = ? ORDER BY l0_.id ASC Parameters: [en] View formatted query View runnable query Explain query SELECT l0_.id AS id0, l0_.isocode AS isocode1, l0_.name AS name2, l1_.id AS id3, l1_.isocode AS isocode4 FROM languages l1_, languages_trn l0_ WHERE l1_.id = l0_.language_id AND l0_.isocode = ? ORDER BY l0_.id ASC SELECT l0_.id AS id0, l0_.isocode AS isocode1, l0_.name AS name2, l1_.id AS id3, l1_.isocode AS isocode4 FROM languages l1_, languages_trn l0_ WHERE l1_.id = l0_.language_id AND l0_.isocode = 'en' ORDER BY l0_.id ASC;

#▲

Time

Info

0.84 ms

SELECT l0_.id AS id0, l0_.isocode AS isocode1, l0_.name AS name2, l1_.id AS id3, l1_.isocode AS isocode4 FROM languages l1_, languages_trn l0_ WHERE l1_.id = l0_.language_id AND l0_.isocode = ? ORDER BY l0_.id ASC

Parameters: [en]

View formatted query View runnable query Explain query

SELECT 
  l0_.id AS id0, 
  l0_.isocode AS isocode1, 
  l0_.name AS name2, 
  l1_.id AS id3, 
  l1_.isocode AS isocode4 
FROM 
  languages l1_, 
  languages_trn l0_ 
WHERE 
  l1_.id = l0_.language_id 
  AND l0_.isocode = ? 
ORDER BY 
  l0_.id ASC

SELECT l0_.id AS id0, l0_.isocode AS isocode1, l0_.name AS name2, l1_.id AS id3, l1_.isocode AS isocode4 FROM languages l1_, languages_trn l0_ WHERE l1_.id = l0_.language_id AND l0_.isocode = 'en' ORDER BY l0_.id ASC;

external connection

No database queries were performed.

Database Connections

Name	Service
catalog	doctrine.dbal.catalog_connection
external	doctrine.dbal.external_connection

Entity Managers

Name	Service
catalog	doctrine.orm.catalog_entity_manager
external	doctrine.orm.external_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

catalog entity manager

Class	Mapping errors
Vibia\CatalogdbBundle\Entity\Subfamilies	No errors.
Vibia\CatalogdbBundle\Entity\Languages	No errors.

external entity manager

No loaded entities.