Query Metrics
8
Database Queries
4
Different statements
14.80 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 4.85 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.prod_idioma = ? AND p0_.prod_estado = ?
Parameters:
[ "fr" 1 ] |
2 | 0.76 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM producto p0_ WHERE p0_.prod_idioma = ? AND p0_.prod_estado = ? ORDER BY p0_.id DESC LIMIT 12
Parameters:
[ "fr" 1 ] |
3 | 1.42 ms |
SELECT t0.id AS id_1, t0.conf_name AS conf_name_2, t0.conf_type AS conf_type_3, t0.conf_value AS conf_value_4, t0.conf_description AS conf_description_5, t0.conf_visible AS conf_visible_6, t0.conf_value_required AS conf_value_required_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM config t0 WHERE t0.conf_name = ? LIMIT 1
Parameters:
[
"CONTACTO_EMAIL"
]
|
4 | 0.78 ms |
SELECT t0.id AS id_1, t0.conf_name AS conf_name_2, t0.conf_type AS conf_type_3, t0.conf_value AS conf_value_4, t0.conf_description AS conf_description_5, t0.conf_visible AS conf_visible_6, t0.conf_value_required AS conf_value_required_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM config t0 WHERE t0.conf_name = ? LIMIT 1
Parameters:
[
"CONTACTO_TELEFONO"
]
|
5 | 3.91 ms |
SELECT p0_.id AS id_0, p0_.pag_slug AS pag_slug_1, p0_.pag_nombre AS pag_nombre_2, p0_.pag_estado AS pag_estado_3, p0_.pag_posicion AS pag_posicion_4, p0_.pag_padre_id AS pag_padre_id_5 FROM pagina p0_ WHERE p0_.pag_estado = ? AND p0_.pag_idioma = ? AND p0_.pag_lugar = ? AND p0_.pag_padre_id IS NULL ORDER BY p0_.pag_posicion DESC
Parameters:
[ [ true ] "fr" [ 1 ] ] |
6 | 1.58 ms |
SELECT p0_.id AS id_0, p0_.pag_slug AS pag_slug_1, p0_.pag_nombre AS pag_nombre_2, p0_.pag_estado AS pag_estado_3, p0_.pag_posicion AS pag_posicion_4, p0_.pag_padre_id AS pag_padre_id_5 FROM pagina p0_ WHERE p0_.pag_estado = ? AND p0_.pag_idioma = ? AND p0_.pag_lugar = ? AND p0_.pag_padre_id IS NULL ORDER BY p0_.pag_posicion DESC
Parameters:
[ [ true ] "fr" [ 2 ] ] |
7 | 0.82 ms |
SELECT t0.id AS id_1, t0.conf_name AS conf_name_2, t0.conf_type AS conf_type_3, t0.conf_value AS conf_value_4, t0.conf_description AS conf_description_5, t0.conf_visible AS conf_visible_6, t0.conf_value_required AS conf_value_required_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM config t0 WHERE t0.conf_name = ? LIMIT 1
Parameters:
[
"CONTACTO_EMAIL"
]
|
8 | 0.68 ms |
SELECT t0.id AS id_1, t0.conf_name AS conf_name_2, t0.conf_type AS conf_type_3, t0.conf_value AS conf_value_4, t0.conf_description AS conf_description_5, t0.conf_visible AS conf_visible_6, t0.conf_value_required AS conf_value_required_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM config t0 WHERE t0.conf_name = ? LIMIT 1
Parameters:
[
"CONTACTO_TELEFONO"
]
|
old connection
No database queries were performed.
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
old | doctrine.dbal.old_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
old | doctrine.orm.old_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\Ajustes\Usuario | No errors. |
App\Entity\Catalogo\Producto | No errors. |
App\Entity\Catalogo\Categoria | No errors. |
App\Entity\Ajustes\Config | No errors. |
App\Entity\Ajustes\Faq | No errors. |
App\Entity\Ajustes\Pagina | No errors. |
App\Entity\Ajustes\TransportistasTarifas | No errors. |
App\Entity\Ajustes\TransportistasSeguros | No errors. |
App\Entity\Ajustes\Pedido | No errors. |
App\Entity\Ajustes\Direccion | No errors. |
App\Entity\Ajustes\Gradeada | No errors. |
App\Entity\Ajustes\Servicio | No errors. |
App\Entity\Ajustes\ServicioTarifas | No errors. |
old entity manager
No loaded entities.