Symfony Profiler

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

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;

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';

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;

SELECT
  r0_.id AS id_0,
  r0_.nombre AS nombre_1
FROM
  region_entrega r0_
WHERE
  r0_.estado = ?
ORDER BY
  r0_.nombre ASC

SELECT r0_.id AS id_0, r0_.nombre AS nombre_1 FROM region_entrega r0_ WHERE r0_.estado = 1 ORDER BY r0_.nombre ASC;

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

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 = 'A' ORDER BY m0_.posicion ASC;

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 = 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 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 = 'H' 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 = ?
  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 = 'H' LIMIT 1;