Query Metrics
14
Database Queries
6
Different statements
55.26 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 20.74 ms |
SELECT t0.id AS id_1, t0.sli_nombre AS sli_nombre_2, t0.sli_created AS sli_created_3, t0.sli_image AS sli_image_4, t0.sli_estado AS sli_estado_5, t0.sli_url AS sli_url_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM slider t0 WHERE t0.sli_estado = ?
Parameters:
[
"1"
]
|
| 2 | 3.87 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"
]
|
| 3 | 0.85 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"
]
|
| 4 | 11.73 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
]
]
|
| 5 | 2.92 ms |
SELECT p0_.id AS id_0, p0_.pag_slug AS pag_slug_1, p0_.pag_nombre AS pag_nombre_2, p0_.pag_titulo AS pag_titulo_3, p0_.pag_palabras_clave AS pag_palabras_clave_4, p0_.pag_meta_descripcion AS pag_meta_descripcion_5, p0_.pag_idioma AS pag_idioma_6, p0_.pag_estado AS pag_estado_7, p0_.pag_posicion AS pag_posicion_8, p0_.pag_lugar AS pag_lugar_9, p0_.pag_contenido_html AS pag_contenido_html_10, p0_.pag_padre_id AS pag_padre_id_11 FROM pagina p0_ WHERE p0_.pag_estado = ? AND p0_.pag_idioma = ? AND p0_.pag_lugar = ? AND p0_.pag_padre_id IS NULL
Parameters:
[
[
true
]
"fr"
[
4
]
]
|
| 6 | 2.90 ms |
SELECT s0_.id AS id_0, s0_.ser_nombre AS ser_nombre_1, s0_.ser_descripcion AS ser_descripcion_2, s0_.ser_estado AS ser_estado_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM servicio s0_ WHERE s0_.ser_estado = ?
Parameters:
[
1
]
|
| 7 | 4.70 ms |
SELECT s0_.id AS id_0, s0_.ser_tar_num_cartas_desde AS ser_tar_num_cartas_desde_1, s0_.ser_tar_num_cartas_hasta AS ser_tar_num_cartas_hasta_2, s0_.ser_tar_precio AS ser_tar_precio_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.ser_tar_servicio_id AS ser_tar_servicio_id_6 FROM servicio_tarifas s0_ LEFT JOIN servicio s1_ ON s0_.ser_tar_servicio_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.ser_tar_precio ASC LIMIT 1
Parameters:
[
1
]
|
| 8 | 1.26 ms |
SELECT s0_.id AS id_0, s0_.ser_tar_num_cartas_desde AS ser_tar_num_cartas_desde_1, s0_.ser_tar_num_cartas_hasta AS ser_tar_num_cartas_hasta_2, s0_.ser_tar_precio AS ser_tar_precio_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.ser_tar_servicio_id AS ser_tar_servicio_id_6 FROM servicio_tarifas s0_ LEFT JOIN servicio s1_ ON s0_.ser_tar_servicio_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.ser_tar_precio ASC LIMIT 1
Parameters:
[
2
]
|
| 9 | 1.05 ms |
SELECT s0_.id AS id_0, s0_.ser_tar_num_cartas_desde AS ser_tar_num_cartas_desde_1, s0_.ser_tar_num_cartas_hasta AS ser_tar_num_cartas_hasta_2, s0_.ser_tar_precio AS ser_tar_precio_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.ser_tar_servicio_id AS ser_tar_servicio_id_6 FROM servicio_tarifas s0_ LEFT JOIN servicio s1_ ON s0_.ser_tar_servicio_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.ser_tar_precio ASC LIMIT 1
Parameters:
[
3
]
|
| 10 | 1.14 ms |
SELECT s0_.id AS id_0, s0_.ser_tar_num_cartas_desde AS ser_tar_num_cartas_desde_1, s0_.ser_tar_num_cartas_hasta AS ser_tar_num_cartas_hasta_2, s0_.ser_tar_precio AS ser_tar_precio_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.ser_tar_servicio_id AS ser_tar_servicio_id_6 FROM servicio_tarifas s0_ LEFT JOIN servicio s1_ ON s0_.ser_tar_servicio_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.ser_tar_precio ASC LIMIT 1
Parameters:
[
4
]
|
| 11 | 0.98 ms |
SELECT s0_.id AS id_0, s0_.ser_tar_num_cartas_desde AS ser_tar_num_cartas_desde_1, s0_.ser_tar_num_cartas_hasta AS ser_tar_num_cartas_hasta_2, s0_.ser_tar_precio AS ser_tar_precio_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.ser_tar_servicio_id AS ser_tar_servicio_id_6 FROM servicio_tarifas s0_ LEFT JOIN servicio s1_ ON s0_.ser_tar_servicio_id = s1_.id WHERE s1_.id = ? ORDER BY s0_.ser_tar_precio ASC LIMIT 1
Parameters:
[
5
]
|
| 12 | 1.31 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
]
]
|
| 13 | 0.85 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"
]
|
| 14 | 0.97 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\Slider | 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. |
| App\Entity\Ajustes\UsuarioValidacionEmail | No errors. |
| App\Entity\Ajustes\PedidoGradeadas | No errors. |
old entity manager
No loaded entities.