Query Metrics

19 Database Queries
15 Different statements
83.06 ms Query time
2 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 22.01 ms
SELECT q0_.id AS id_0, q0_.viewBanner AS viewbanner_1, q0_.mision AS mision_2, q0_.urlImagenMision AS urlimagenmision_3, q0_.vision AS vision_4, q0_.urlImagenVision AS urlimagenvision_5, q0_.historias AS historias_6, q0_.banner AS banner_7 FROM quienes_somos q0_ ORDER BY q0_.id DESC LIMIT 1
Parameters:
[]
2 6.73 ms
SELECT s0_.titulo AS titulo_0 FROM seccion_seo s0_ INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id WHERE s0_.estado = ? AND s0_.mostrar = ? AND t1_.id_tipo = ? LIMIT 1
Parameters:
[
  "A"
  1
  "Q"
]
3 1.61 ms
SELECT s0_.id AS id_0, s0_.titulo AS titulo_1, s0_.descripcion AS descripcion_2, s0_.keywords AS keywords_3, s0_.estado AS estado_4, s0_.mostrar AS mostrar_5, s0_.fechaCreacion AS fechacreacion_6, s0_.fechaActualizacion AS fechaactualizacion_7, s0_.header_principal AS header_principal_8, s0_.header_secundario AS header_secundario_9, s0_.tipo_seccion_seo_id AS tipo_seccion_seo_id_10 FROM seccion_seo s0_ INNER JOIN tipo_seccion_seo t1_ ON s0_.tipo_seccion_seo_id = t1_.id WHERE s0_.estado = ? AND s0_.mostrar = ? AND t1_.id_tipo = ? LIMIT 1
Parameters:
[
  "A"
  1
  "Q"
]
4 2.41 ms
SELECT t0.id AS id_1, t0.urlImagen AS urlimagen_2, t0.seccion_seo_id AS seccion_seo_id_3 FROM img_seccion_seo t0 WHERE t0.seccion_seo_id = ?
Parameters:
[
  5
]
5 18.44 ms
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND p1_.cat1 = e0_.id AND p1_.status_eCommerce = 1 AND p1_.status_infor = 1 ORDER BY e0_.Nombres ASC
Parameters:
[]
6 4.54 ms
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 198 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
7 2.81 ms
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 201 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
8 2.16 ms
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 200 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
9 2.46 ms
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 199 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
10 1.68 ms
SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 212 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
11 7.27 ms
SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ?
Parameters:
[
  "A"
  1
]
12 1.45 ms
SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ? ORDER BY f0_.posicion ASC
Parameters:
[
  "A"
  1
]
13 1.60 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = ?
Parameters:
[
  2
]
14 1.26 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = ?
Parameters:
[
  3
]
15 1.22 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = ?
Parameters:
[
  4
]
16 1.50 ms
SELECT t0.id AS id_1, t0.imgNombreServidor AS imgnombreservidor_2, t0.imgNombreAlternativo AS imgnombrealternativo_3, t0.url AS url_4, t0.tipoAperturaUrl AS tipoaperturaurl_5, t0.texto_alternativo_imagen AS texto_alternativo_imagen_6, t0.footer_column_id AS footer_column_id_7 FROM footer_column_imagen t0 WHERE t0.footer_column_id = ?
Parameters:
[
  5
]
17 1.14 ms
SELECT t0.id AS id_1, t0.imgNombreServidor AS imgnombreservidor_2, t0.imgNombreAlternativo AS imgnombrealternativo_3, t0.url AS url_4, t0.tipoAperturaUrl AS tipoaperturaurl_5, t0.texto_alternativo_imagen AS texto_alternativo_imagen_6, t0.footer_column_id AS footer_column_id_7 FROM footer_column_imagen t0 WHERE t0.footer_column_id = ?
Parameters:
[
  6
]
18 1.46 ms
SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna = ? AND f0_.mostrar = ?
Parameters:
[
  "A"
  "C"
  1
]
19 1.32 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\FooterColumnTexto 22
App\Entity\FooterColumn 6
App\Entity\FooterColumnImagen 6
App\Entity\QuienesSomos 1
App\Entity\SeccionSeo 1
App\Entity\TipoSeccionSeo 1
App\Entity\ImgSeccionSeo 1

Entities Mapping

Class Mapping errors
App\Entity\QuienesSomos No errors.
App\Entity\Banner No errors.
App\Entity\SeccionSeo No errors.
App\Entity\TipoSeccionSeo No errors.
App\Entity\ImgSeccionSeo No errors.
App\Entity\Imagen No errors.
App\Entity\ClickBanner No errors.
App\Entity\Estructura_ecommerce_ES No errors.
App\Entity\Producto_ES
  • The mappings App\Entity\Producto_ES#crossreferenceses and App\Entity\CrossReferences_ES#producto are inconsistent with each other.
App\Entity\FooterColumn No errors.
App\Entity\FooterColumnTexto No errors.
App\Entity\FooterColumnImagen No errors.
App\Entity\Marca_ES No errors.
App\Entity\Familia_ES No errors.
App\Entity\CrossReferences_ES
  • The association App\Entity\CrossReferences_ES#producto refers to the inverse side field App\Entity\Producto_ES#crossReferences which does not exist.
App\Entity\DetalleProductoAplicacion_ES No errors.
App\Entity\DetalleProductoTipoRelacion_ES No errors.
App\Entity\DetalleValorMarca_ES No errors.
App\Entity\Caracteristica_valor_ES No errors.