Symfony Profiler

Query Metrics

28 Database Queries

21 Different statements

300.33 ms Query time

2 Invalid entities

45 Managed entities

Queries


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 = ?
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
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 = ?
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 = ?
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
SELECT count(p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.status_eCommerce = 1 AND p0_.status_infor = 1
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
SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = ?
SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = ?
SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC, d2_.posicion ASC
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
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 = ?
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
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
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
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
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
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
SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ?
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?

#▲	Time	Info
1	2.65 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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'PRINCIPAL' AND t0.estado = 'A';
2	1.92 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`] View formatted query View runnable query Explain query 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 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 = 15 ORDER BY t0.posicion ASC;
3	1.28 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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'SECCION1' AND t0.estado = 'A';
4	1.06 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"`] View formatted query View runnable query Explain query 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 = ? 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 = 'SECCION2' AND t0.estado = 'A';
5	1.09 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`] View formatted query View runnable query Explain query 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 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 = 16 ORDER BY t0.posicion ASC;
6	9.77 ms	SELECT count(p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.status_eCommerce = 1 AND p0_.status_infor = 1 Parameters: [] View formatted query View runnable query Explain query SELECT count(p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.status_eCommerce = 1 AND p0_.status_infor = 1 SELECT count(p0_.id) AS sclr_0 FROM producto p0_ WHERE p0_.status_eCommerce = 1 AND p0_.status_infor = 1;
7	2.23 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 "P"`] View formatted query View runnable query Explain query 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 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 = 'A' AND s0_.mostrar = 1 AND t1_.id_tipo = 'P' LIMIT 1;
8	17.41 ms	SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = ? Parameters: [`"fjXm"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = ? SELECT t0.id AS id_1, t0.idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Value_linea_de_producto AS value_linea_de_producto_9, t0.Value_grupo_estadistico AS value_grupo_estadistico_10, t0.Descripcion_comercial AS descripcion_comercial_11, t0.Descripcion_corta AS descripcion_corta_12, t0.Descripcion_larga AS descripcion_larga_13, t0.url_foto AS url_foto_14, t0.sesion AS sesion_15, t0.tiene_despiece AS tiene_despiece_16, t0.otros_productos AS otros_productos_17, t0.descripcion_marca AS descripcion_marca_18, t0.descripcion_id_infor AS descripcion_id_infor_19, t0.slogan AS slogan_20, t0.tipo_uso AS tipo_uso_21, t0.marca_es_id AS marca_es_id_22, t0.familia_es_id AS familia_es_id_23, t0.cat1 AS cat1_24, t0.cat2 AS cat2_25, t0.cat3 AS cat3_26, t0.cat4 AS cat4_27 FROM producto_es t0 WHERE t0.idinfor = 'fjXm';
9	196.44 ms	SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = ? Parameters: [`"fjXm"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = ? SELECT t0.id AS id_1, t0.cross_reference AS cross_reference_2, t0.marca AS marca_3, t0.publico AS publico_4, t0.producto_es_id AS producto_es_id_5 FROM cross_references_es t0 WHERE t0.cross_reference = 'fjXm';
10	6.74 ms	SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["5" "9" "11" "15" "19" "26" "28" "30" "32" "34" "35" "36" "37" "38" "39" "41" "43" "45" "47" "49" "51" "53" "55" "57" "59" "61" "64" "66" "68" "70" "72" "74" "76" "78" "80" "82" "84" "86" "88" "90" "92" "94" "96" "98" "100" "102" "104" "106" "108" "112" "114" "117" "120" "122" "124" "125" "126" "128" "130" "132" "140" "146" "148" "150" "155" "157" "159" "162" "165" "167" "169" "180" "182" "184" "186" "188" "192" "197" "199" "201" "203" "244" "246" "258" "260" "268" "269" "292" "297" "299" "301" "333" "335" "336" "337" "339" "341" "342" "343" "344" "346" "414" "416" "417" "418" "421" "425" "430" "436" "447" "451" "472" "486" "491" "492" "497" "502" "503" "507" "508" "518" "525" "536" "539" "540" "550" "553" "557" "561" "645" "647" "648" "832" "1384" "1386" "1399" "1401" "1403" "1440" "1450" "1453" "1454" "1455" "1456" "1458" "1459" "1460" "1462" "1463" "1464" "1465" "1467" "1470" "1471" "1473" "1474" "1476" "1477" "1478" "1481" "1482" "1483" "1484" "1485" "1486" "1487" "1489" "1490" "1491" "1493" "1494" "1497" "1498" "1502" "1503" "1504" "1506" "1507" "1508" "1509" "1510" "1513" "1516" "1518" "1520" "1523" "1524" "1525" "1527" "1529" "1531" "1532" "1534" "1537" "1539" "1541" "1543" "1545" "1547" "1549" "1550" "1552" "1554" "1555" "1558" "1559" "1560" "1562" "1563" "1564" "1565" "1566" "1567" "1568" "1570" "1571" "1572" "1573" "1575" "1576" "1577" "1579" "1580" "1581" "1582" "1584" "1586" "1587" "1588" "1590" "1592" "1593" "1597" "1598" "1599" "1601" "1602" "1603" "1604" "1605" "1606" "1607" "1608" "1609" "1610" "1611" "1612" "1613" "1615" "1616"] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT p0_.id AS id_0, p0_.estado_btc AS estado_btc_1 FROM producto p0_ WHERE p0_.id IN ('5', '9', '11', '15', '19', '26', '28', '30', '32', '34', '35', '36', '37', '38', '39', '41', '43', '45', '47', '49', '51', '53', '55', '57', '59', '61', '64', '66', '68', '70', '72', '74', '76', '78', '80', '82', '84', '86', '88', '90', '92', '94', '96', '98', '100', '102', '104', '106', '108', '112', '114', '117', '120', '122', '124', '125', '126', '128', '130', '132', '140', '146', '148', '150', '155', '157', '159', '162', '165', '167', '169', '180', '182', '184', '186', '188', '192', '197', '199', '201', '203', '244', '246', '258', '260', '268', '269', '292', '297', '299', '301', '333', '335', '336', '337', '339', '341', '342', '343', '344', '346', '414', '416', '417', '418', '421', '425', '430', '436', '447', '451', '472', '486', '491', '492', '497', '502', '503', '507', '508', '518', '525', '536', '539', '540', '550', '553', '557', '561', '645', '647', '648', '832', '1384', '1386', '1399', '1401', '1403', '1440', '1450', '1453', '1454', '1455', '1456', '1458', '1459', '1460', '1462', '1463', '1464', '1465', '1467', '1470', '1471', '1473', '1474', '1476', '1477', '1478', '1481', '1482', '1483', '1484', '1485', '1486', '1487', '1489', '1490', '1491', '1493', '1494', '1497', '1498', '1502', '1503', '1504', '1506', '1507', '1508', '1509', '1510', '1513', '1516', '1518', '1520', '1523', '1524', '1525', '1527', '1529', '1531', '1532', '1534', '1537', '1539', '1541', '1543', '1545', '1547', '1549', '1550', '1552', '1554', '1555', '1558', '1559', '1560', '1562', '1563', '1564', '1565', '1566', '1567', '1568', '1570', '1571', '1572', '1573', '1575', '1576', '1577', '1579', '1580', '1581', '1582', '1584', '1586', '1587', '1588', '1590', '1592', '1593', '1597', '1598', '1599', '1601', '1602', '1603', '1604', '1605', '1606', '1607', '1608', '1609', '1610', '1611', '1612', '1613', '1615', '1616');
11	22.13 ms	SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id ASC, d2_.posicion ASC Parameters: ["5" "9" "11" "15" "19" "26" "28" "30" "32" "34" "35" "36" "37" "38" "39" "41" "43" "45" "47" "49" "51" "53" "55" "57" "59" "61" "64" "66" "68" "70" "72" "74" "76" "78" "80" "82" "84" "86" "88" "90" "92" "94" "96" "98" "100" "102" "104" "106" "108" "112" "114" "117" "120" "122" "124" "125" "126" "128" "130" "132" "140" "146" "148" "150" "155" "157" "159" "162" "165" "167" "169" "180" "182" "184" "186" "188" "192" "197" "199" "201" "203" "244" "246" "258" "260" "268" "269" "292" "297" "299" "301" "333" "335" "336" "337" "339" "341" "342" "343" "344" "346" "414" "416" "417" "418" "421" "425" "430" "436" "447" "451" "472" "486" "491" "492" "497" "502" "503" "507" "508" "518" "525" "536" "539" "540" "550" "553" "557" "561" "645" "647" "648" "832" "1384" "1386" "1399" "1401" "1403" "1440" "1450" "1453" "1454" "1455" "1456" "1458" "1459" "1460" "1462" "1463" "1464" "1465" "1467" "1470" "1471" "1473" "1474" "1476" "1477" "1478" "1481" "1482" "1483" "1484" "1485" "1486" "1487" "1489" "1490" "1491" "1493" "1494" "1497" "1498" "1502" "1503" "1504" "1506" "1507" "1508" "1509" "1510" "1513" "1516" "1518" "1520" "1523" "1524" "1525" "1527" "1529" "1531" "1532" "1534" "1537" "1539" "1541" "1543" "1545" "1547" "1549" "1550" "1552" "1554" "1555" "1558" "1559" "1560" "1562" "1563" "1564" "1565" "1566" "1567" "1568" "1570" "1571" "1572" "1573" "1575" "1576" "1577" "1579" "1580" "1581" "1582" "1584" "1586" "1587" "1588" "1590" "1592" "1593" "1597" "1598" "1599" "1601" "1602" "1603" "1604" "1605" "1606" "1607" "1608" "1609" "1610" "1611" "1612" "1613" "1615" "1616"] View formatted query View runnable query Explain query SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ORDER BY p0_.id ASC, d2_.posicion ASC SELECT DISTINCT p0_.id AS id_0, c1_.Nombre AS nombre_1, d2_.posicion AS posicion_2, c3_.valor AS valor_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.slogan AS slogan_5, p0_.Pvp AS pvp_6, p0_.tipo_uso AS tipo_uso_7, p0_.Idinfor AS idinfor_8 FROM caracteristica_valor c3_ INNER JOIN caracteristica c1_ ON (c1_.id = c3_.id_caracteristica) INNER JOIN producto p0_ ON (p0_.id = c3_.id_producto) INNER JOIN detalle_familia_caracteristica d2_ ON (d2_.id_caracteristica = c1_.id) WHERE p0_.id IN ('5', '9', '11', '15', '19', '26', '28', '30', '32', '34', '35', '36', '37', '38', '39', '41', '43', '45', '47', '49', '51', '53', '55', '57', '59', '61', '64', '66', '68', '70', '72', '74', '76', '78', '80', '82', '84', '86', '88', '90', '92', '94', '96', '98', '100', '102', '104', '106', '108', '112', '114', '117', '120', '122', '124', '125', '126', '128', '130', '132', '140', '146', '148', '150', '155', '157', '159', '162', '165', '167', '169', '180', '182', '184', '186', '188', '192', '197', '199', '201', '203', '244', '246', '258', '260', '268', '269', '292', '297', '299', '301', '333', '335', '336', '337', '339', '341', '342', '343', '344', '346', '414', '416', '417', '418', '421', '425', '430', '436', '447', '451', '472', '486', '491', '492', '497', '502', '503', '507', '508', '518', '525', '536', '539', '540', '550', '553', '557', '561', '645', '647', '648', '832', '1384', '1386', '1399', '1401', '1403', '1440', '1450', '1453', '1454', '1455', '1456', '1458', '1459', '1460', '1462', '1463', '1464', '1465', '1467', '1470', '1471', '1473', '1474', '1476', '1477', '1478', '1481', '1482', '1483', '1484', '1485', '1486', '1487', '1489', '1490', '1491', '1493', '1494', '1497', '1498', '1502', '1503', '1504', '1506', '1507', '1508', '1509', '1510', '1513', '1516', '1518', '1520', '1523', '1524', '1525', '1527', '1529', '1531', '1532', '1534', '1537', '1539', '1541', '1543', '1545', '1547', '1549', '1550', '1552', '1554', '1555', '1558', '1559', '1560', '1562', '1563', '1564', '1565', '1566', '1567', '1568', '1570', '1571', '1572', '1573', '1575', '1576', '1577', '1579', '1580', '1581', '1582', '1584', '1586', '1587', '1588', '1590', '1592', '1593', '1597', '1598', '1599', '1601', '1602', '1603', '1604', '1605', '1606', '1607', '1608', '1609', '1610', '1611', '1612', '1613', '1615', '1616') ORDER BY p0_.id ASC, d2_.posicion ASC;
12	1.62 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 "P"`] View formatted query View runnable query Explain query 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 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 = 'A' AND s0_.mostrar = 1 AND t1_.id_tipo = 'P' LIMIT 1;
13	1.43 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: [`2`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
14	12.99 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: [] View formatted query View runnable query Explain query 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 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;
15	2.14 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: [] View formatted query View runnable query Explain query 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 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;
16	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 = 201 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC Parameters: [] View formatted query View runnable query Explain query 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 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;
17	1.94 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: [] View formatted query View runnable query Explain query 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 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;
18	2.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 = 199 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC Parameters: [] View formatted query View runnable query Explain query 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 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;
19	1.43 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: [] View formatted query View runnable query Explain query 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 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;
20	1.79 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`] View formatted query View runnable query Explain query SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = ? AND f0_.tipoColumna <> 'C' AND f0_.mostrar = ? SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = 'A' AND f0_.tipoColumna <> 'C' AND f0_.mostrar = 1;
21	1.28 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`] View formatted query View runnable query Explain query 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 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 = 'A' AND f0_.tipoColumna <> 'C' AND f0_.mostrar = 1 ORDER BY f0_.posicion ASC;
22	1.53 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`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
23	1.14 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`] View formatted query View runnable query Explain query 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 = ? 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 = 3;
24	1.03 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`] View formatted query View runnable query Explain query 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 = ? 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 = 4;
25	1.25 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`] View formatted query View runnable query Explain query 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 = ? 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 = 5;
26	1.02 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`] View formatted query View runnable query Explain query 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 = ? 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 = 6;
27	1.35 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`] View formatted query View runnable query Explain query 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 = ? 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 = 'A' AND f0_.tipoColumna = 'C' AND f0_.mostrar = 1;
28	1.10 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`] View formatted query View runnable query Explain query 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 = ? 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 = 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\Imagen	6
App\Entity\FooterColumn	6
App\Entity\FooterColumnImagen	6
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\SeccionSeo	No errors.
App\Entity\TipoSeccionSeo	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\Marca_ES	No errors.
App\Entity\Familia_ES	No errors.
App\Entity\Estructura_ecommerce_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\Caracteristica_valor	No errors.
App\Entity\Caracteristica	No errors.
App\Entity\DetalleFamiliaCaracteristica	No errors.
App\Entity\ImgSeccionSeo	No errors.
App\Entity\Marca	No errors.
App\Entity\Adjuntos	No errors.
App\Entity\DetalleProductoTipoRelacion	No errors.
App\Entity\CrossReferences	No errors.
App\Entity\DetalleProductoAplicacion	No errors.
App\Entity\shopping_cart	No errors.
App\Entity\DetalleOrden	No errors.
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\DetalleFamiliaCaracteristica_ES	No errors.
App\Entity\Grupo	No errors.
App\Entity\Familia	No errors.
App\Entity\FooterColumn	No errors.
App\Entity\FooterColumnTexto	No errors.
App\Entity\FooterColumnImagen	No errors.
App\Entity\MarcaItemHome	No errors.
App\Entity\TipoDocumento	No errors.
App\Entity\Aplicacion	No errors.
App\Entity\Orden	No errors.
App\Entity\Aplicacion_ES	No errors.
App\Entity\Caracteristica_ES	No errors.

GET https://52.201.159.119/_fragment?_path=_format%3Dhtml%26_locale%3Des%26_controller%3DApp%255CFrontend%255CController%255CFooterViewComponentController%253A%253A…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping