Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.07 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

maenar connection

Time▼	Count	Info
0.60 ms (56.51%)	1	SELECT s0_.id AS id0, s0_.name AS name1, s0_.nameURL AS nameURL2, s0_.codigo AS codigo3, s0_.title AS title4, s0_.metadescription AS metadescription5, s0_.category_id AS category_id6 FROM Subcategory s0_ WHERE s0_.nameURL = 'index.php' Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id0, s0_.name AS name1, s0_.nameURL AS nameURL2, s0_.codigo AS codigo3, s0_.title AS title4, s0_.metadescription AS metadescription5, s0_.category_id AS category_id6 FROM Subcategory s0_ WHERE s0_.nameURL = 'index.php' SELECT s0_.id AS id0, s0_.name AS name1, s0_.nameURL AS nameURL2, s0_.codigo AS codigo3, s0_.title AS title4, s0_.metadescription AS metadescription5, s0_.category_id AS category_id6 FROM Subcategory s0_ WHERE s0_.nameURL = 'index.php';
0.46 ms (43.49%)	1	SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6 FROM Category t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6 FROM Category t0 SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6 FROM Category t0;

Time▼

Count

Info

0.60 ms
(56.51%)

SELECT s0_.id AS id0, s0_.name AS name1, s0_.nameURL AS nameURL2, s0_.codigo AS codigo3, s0_.title AS title4, s0_.metadescription AS metadescription5, s0_.category_id AS category_id6 FROM Subcategory s0_ WHERE s0_.nameURL = 'index.php'

Parameters: []

View formatted query View runnable query Explain query

SELECT 
  s0_.id AS id0, 
  s0_.name AS name1, 
  s0_.nameURL AS nameURL2, 
  s0_.codigo AS codigo3, 
  s0_.title AS title4, 
  s0_.metadescription AS metadescription5, 
  s0_.category_id AS category_id6 
FROM 
  Subcategory s0_ 
WHERE 
  s0_.nameURL = 'index.php'

SELECT s0_.id AS id0, s0_.name AS name1, s0_.nameURL AS nameURL2, s0_.codigo AS codigo3, s0_.title AS title4, s0_.metadescription AS metadescription5, s0_.category_id AS category_id6 FROM Subcategory s0_ WHERE s0_.nameURL = 'index.php';

0.46 ms
(43.49%)

SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6 FROM Category t0

Parameters: []

View formatted query View runnable query Explain query

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.nameURL AS nameURL3, 
  t0.codigo AS codigo4, 
  t0.title AS title5, 
  t0.metadescription AS metadescription6 
FROM 
  Category t0

SELECT t0.id AS id1, t0.name AS name2, t0.nameURL AS nameURL3, t0.codigo AS codigo4, t0.title AS title5, t0.metadescription AS metadescription6 FROM Category t0;

localizacion connection

No database queries were performed.

Database Connections

Name	Service
localizacion	doctrine.dbal.localizacion_connection
maenar	doctrine.dbal.maenar_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
localizacion	doctrine.orm.localizacion_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

localizacion entity manager

No loaded entities.

default entity manager

Class	Mapping errors
Maenar\productsBundle\Entity\Category	The field Maenar\productsBundle\Entity\Category#subcategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Maenar\productsBundle\Entity\Subcategory#category does not contain the required 'inversedBy=subcategories' attribute.
Maenar\productsBundle\Entity\Subcategory	No errors.