Query Metrics
10
Database Queries
6
Different statements
12.23 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
3.21 ms (26.30%) |
4 |
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"
]
|
3.14 ms (25.66%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.prod_idioma = ? AND p0_.prod_estado = ?
Parameters:
[ "es" 1 ] |
2.67 ms (21.81%) |
2 |
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 ] "es" [ 1 ] ] |
1.95 ms (15.96%) |
1 |
SELECT p0_.id AS id_0, p0_.prod_nombre AS prod_nombre_1, p0_.prod_referencia AS prod_referencia_2, p0_.prod_estado AS prod_estado_3, p0_.prod_descripcion AS prod_descripcion_4, p0_.prod_image AS prod_image_5, p0_.prod_original_name AS prod_original_name_6, p0_.prod_precio AS prod_precio_7, p0_.prod_descripcion_larga AS prod_descripcion_larga_8, p0_.prod_idioma AS prod_idioma_9, p0_.prod_old_id AS prod_old_id_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12 FROM producto p0_ WHERE p0_.prod_idioma = ? AND p0_.prod_estado = ? AND p0_.id IN (?) ORDER BY p0_.id DESC
Parameters:
[ "es" 1 [ 4 3 2 1 ] ] |
0.74 ms (6.05%) |
1 |
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_padre_id = ? ORDER BY p0_.pag_posicion DESC
Parameters:
[ [ true ] "es" 1 ] |
0.52 ms (4.22%) |
1 |
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:
[ "es" 1 ] |
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\Ajustes\HistProdLinea | No errors. |
App\Entity\Ajustes\PedidosAccesorios | 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.