GET https://100.60.26.148/

Query Metrics

30 Database Queries
21 Different statements
90.95 ms Query time
2 Invalid entities
62 Managed entities

Queries

Group similar statements

# Time Info
1 5.96 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = ? AND t0.estado = ?
Parameters:
[
  "PRINCIPAL"
  "A"
]
2 6.87 ms
SELECT t0.id AS id_1, t0.imagen_desktop AS imagen_desktop_2, t0.imagen_tablet AS imagen_tablet_3, t0.imagen_movil AS imagen_movil_4, t0.nombre_original_desktop AS nombre_original_desktop_5, t0.nombre_original_tablet AS nombre_original_tablet_6, t0.nombre_original_movil AS nombre_original_movil_7, t0.nombre_alterno AS nombre_alterno_8, t0.posicion AS posicion_9, t0.url_redirect AS url_redirect_10, t0.estado AS estado_11, t0.banner_id AS banner_id_12 FROM imagen t0 WHERE t0.banner_id = ? ORDER BY t0.posicion ASC
Parameters:
[
  15
]
3 1.43 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = ? AND t0.estado = ?
Parameters:
[
  "SECCION1"
  "A"
]
4 1.31 ms
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = ? AND t0.estado = ?
Parameters:
[
  "SECCION2"
  "A"
]
5 1.37 ms
SELECT t0.id AS id_1, t0.imagen_desktop AS imagen_desktop_2, t0.imagen_tablet AS imagen_tablet_3, t0.imagen_movil AS imagen_movil_4, t0.nombre_original_desktop AS nombre_original_desktop_5, t0.nombre_original_tablet AS nombre_original_tablet_6, t0.nombre_original_movil AS nombre_original_movil_7, t0.nombre_alterno AS nombre_alterno_8, t0.posicion AS posicion_9, t0.url_redirect AS url_redirect_10, t0.estado AS estado_11, t0.banner_id AS banner_id_12 FROM imagen t0 WHERE t0.banner_id = ? ORDER BY t0.posicion ASC
Parameters:
[
  16
]
6 17.69 ms
SELECT p0_.id AS id_0, p0_.Idinfor AS idinfor_1, p0_.Pvp AS pvp_2, p0_.Descripcion_corta AS descripcion_corta_3, p0_.Descripcion_larga AS descripcion_larga_4, p0_.url_foto AS url_foto_5, m1_.nombre AS nombre_6, p0_.Idfamilia AS idfamilia_7, f2_.Nombre AS nombre_8 FROM producto p0_ LEFT JOIN marca m1_ ON p0_.marca = m1_.id LEFT JOIN familia f2_ ON (f2_.Id_infor = p0_.Idfamilia) WHERE p0_.status_infor = 1 AND p0_.status_eCommerce = 1 AND p0_.marca IS NOT NULL AND p0_.otros_productos = true ORDER BY p0_.Descripcion ASC
Parameters:
[]
7 2.72 ms
SELECT m0_.id AS id_0, m0_.nombreMarca AS nombremarca_1, m0_.nombreAlternativo AS nombrealternativo_2, m0_.urlRedireccionar AS urlredireccionar_3, m0_.estado AS estado_4, m0_.tipoAperturaUrl AS tipoaperturaurl_5, m0_.nombreOriginalImg AS nombreoriginalimg_6, m0_.nombreImgServidor AS nombreimgservidor_7, m0_.fechaCreacion AS fechacreacion_8, m0_.fechaActualizacion AS fechaactualizacion_9, m0_.posicion AS posicion_10, m0_.busqueda_producto AS busqueda_producto_11, m0_.id_marca AS id_marca_12 FROM marca_item_home m0_ WHERE m0_.estado = ? ORDER BY m0_.posicion ASC
Parameters:
[
  "A"
]
8 2.54 ms
SELECT r0_.id AS id_0, r0_.nombre AS nombre_1 FROM region_entrega r0_ WHERE r0_.estado = ? ORDER BY r0_.nombre ASC
Parameters:
[
  1
]
9 1.87 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
  "H"
]
10 1.51 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
  "H"
]
11 2.13 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:
[
  1
]
12 14.15 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:
[]
13 3.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 = 198 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC
Parameters:
[]
14 1.56 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:
[]
15 1.84 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:
[]
16 2.30 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:
[]
17 1.42 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:
[]
18 1.29 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.status AS status_3 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  7
]
19 1.17 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.status AS status_3 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  30
]
20 1.09 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.status AS status_3 FROM marca t0 WHERE t0.id = ?
Parameters:
[
  15
]
21 2.29 ms
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.descripcion AS descripcion_3, t0.archivos AS archivos_4, t0.url AS url_5, t0.url_imagen AS url_imagen_6, t0.view_banner_top AS view_banner_top_7, t0.view_banner_bottom AS view_banner_bottom_8, t0.destacado AS destacado_9, t0.usuario_creacion AS usuario_creacion_10, t0.ultima_actualizacion AS ultima_actualizacion_11, t0.estado AS estado_12, t0.titulo_seo AS titulo_seo_13, t0.descripcion_seo AS descripcion_seo_14, t0.keywords AS keywords_15, t0.mostrar AS mostrar_16, t0.fecha_publicacion AS fecha_publicacion_17, t0.banner_top AS banner_top_18, t0.banner_bottom AS banner_bottom_19 FROM noticia t0 WHERE t0.destacado = ? AND t0.estado = ? ORDER BY t0.fecha_publicacion DESC
Parameters:
[
  1
  1
]
22 4.85 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
]
23 1.31 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
]
24 1.52 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
]
25 1.13 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
]
26 1.18 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
]
27 1.49 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
]
28 1.18 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
]
29 1.43 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
]
30 1.16 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\MarcaItemHome 10
App\Entity\Imagen 6
App\Entity\FooterColumn 6
App\Entity\FooterColumnImagen 6
App\Entity\Marca 4
App\Entity\Noticia 3
App\Entity\Banner 2
App\Entity\SeccionSeo 1
App\Entity\TipoSeccionSeo 1
App\Entity\ImgSeccionSeo 1

Entities Mapping

Class Mapping errors
App\Entity\Banner No errors.
App\Entity\Imagen No errors.
App\Entity\ClickBanner No errors.
App\Entity\Producto No errors.
App\Entity\Marca No errors.
App\Entity\Familia No errors.
App\Entity\MarcaItemHome No errors.
App\Entity\RegionEntrega No errors.
App\Entity\SeccionSeo No errors.
App\Entity\TipoSeccionSeo No errors.
App\Entity\ImgSeccionSeo No errors.
App\Entity\Adjuntos No errors.
App\Entity\DetalleProductoTipoRelacion No errors.
App\Entity\CrossReferences No errors.
App\Entity\Caracteristica_valor No errors.
App\Entity\DetalleProductoAplicacion No errors.
App\Entity\shopping_cart No errors.
App\Entity\DetalleOrden No errors.
App\Entity\DetalleFamiliaCaracteristica No errors.
App\Entity\Ciudad 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\Noticia No errors.
App\Entity\CategoriaNoticia No errors.
App\Entity\FooterColumn No errors.
App\Entity\FooterColumnTexto No errors.
App\Entity\FooterColumnImagen No errors.
App\Entity\TipoDocumento No errors.
App\Entity\Caracteristica No errors.
App\Entity\Aplicacion No errors.
App\Entity\Orden No errors.
App\Entity\Provincia 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.
App\Entity\Grupo No errors.
App\Entity\EstructuraAplicacion No errors.
App\Entity\Users No errors.
App\Entity\User_ecommerce No errors.
App\Entity\DatosFacturacion No errors.
App\Entity\DatosEntrega No errors.
App\Entity\TipoServicio No errors.
App\Entity\PuntoVenta No errors.
App\Entity\Pago No errors.
App\Entity\CanalContacto No errors.
App\Entity\EstadoOrden No errors.
App\Entity\EstadoServicio No errors.
App\Entity\DetalleFamiliaCaracteristica_ES No errors.
App\Entity\Aplicacion_ES No errors.
App\Entity\Caracteristica_ES No errors.