Symfony Profiler

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 ('9911', '4069', '4151', '22440', '2537', '4065', '4067', '8986', '13903', '15872', '22444', '22646', '5803', '8984', '8988', '8990', '8992', '14400', '22431', '22434', '22439', '3263', '13822', '13821', '15647', '21777', '2515', '22267', '22327') ORDER BY p0_.id ASC, d2_.posicion ASC;

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;

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 ('9911', '4069', '4151', '22440', '2537', '4065', '4067', '8986', '13903', '15872', '22444', '22646', '5803', '8984', '8988', '8990', '8992', '14400', '22431', '22434', '22439', '3263', '13822', '13821', '15647', '21777', '2515', '22267', '22327');

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

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;

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;