https://eg.apunts.es/es/tienda/

Query Metrics

10 Database Queries
6 Different statements
12.23 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.