Symfony Profiler

SELECT
  DISTINCT c0_.nombresrazonsocial AS nombresrazonsocial_0,
  c1_.id AS id_1,
  c2_.id AS id_2,
  c2_.ncertificado AS ncertificado_3,
  c2_.fechadesde AS fechadesde_4,
  c2_.fechahasta AS fechahasta_5,
  p3_.descripcion AS descripcion_6,
  (
    SELECT
      c4_.nombresrazonsocial
    FROM
      clientes c4_
    WHERE
      c4_.tipoid = c2_.tipoid
      AND c4_.numid = c2_.numid
  ) AS sclr_7,
  (
    SELECT
      c5_.nombresrazonsocial
    FROM
      clientes c5_
    WHERE
      c5_.id = c1_.clientes_id
  ) AS sclr_8,
  c1_.indservicioconrecibopendiente AS indservicioconrecibopendiente_9,
  c1_.vip AS vip_10,
  a6_.fechaingreso AS fechaingreso_11,
  DATEDIFF(CURRENT_TIME, a6_.fechaingreso) AS sclr_12
FROM
  riesgoscubiertos r7_
  INNER JOIN clientes c0_ ON (c0_.id = r7_.clientes_id)
  INNER JOIN contratos c1_ ON (c1_.id = r7_.contratos_id)
  INNER JOIN certificados c2_ ON (
    c2_.ncertificado = r7_.ncertificado
    AND c2_.contratos_id = r7_.contratos_id
  )
  INNER JOIN afiliados a6_ ON (
    a6_.clientes_id = r7_.clientes_id
    AND a6_.contratos_id = r7_.contratos_id
  )
  INNER JOIN planseleccionado p8_ ON (
    p8_.contratos_id = r7_.contratos_id
  )
  INNER JOIN planesservicios p9_ ON (p9_.id = p8_.planesservicios_id)
  INNER JOIN planes p3_ ON (p3_.id = p9_.planes_id)
WHERE
  r7_.clientes_id = ?
  AND (
    c1_.estatuscontratos_id = 2
    OR (
      c1_.estatuscontratos_id = 1
      AND c1_.indservicioconrecibopendiente = 1
    )
  )
  AND CURRENT_DATE BETWEEN DATE_FORMAT(c2_.fechadesde, '%Y-%m-%d')
  AND DATE_FORMAT(c2_.fechahasta, '%Y-%m-%d')
ORDER BY
  c1_.id DESC

SELECT DISTINCT c0_.nombresrazonsocial AS nombresrazonsocial_0, c1_.id AS id_1, c2_.id AS id_2, c2_.ncertificado AS ncertificado_3, c2_.fechadesde AS fechadesde_4, c2_.fechahasta AS fechahasta_5, p3_.descripcion AS descripcion_6, (SELECT c4_.nombresrazonsocial FROM clientes c4_ WHERE c4_.tipoid = c2_.tipoid AND c4_.numid = c2_.numid) AS sclr_7, (SELECT c5_.nombresrazonsocial FROM clientes c5_ WHERE c5_.id = c1_.clientes_id) AS sclr_8, c1_.indservicioconrecibopendiente AS indservicioconrecibopendiente_9, c1_.vip AS vip_10, a6_.fechaingreso AS fechaingreso_11, DATEDIFF(CURRENT_TIME, a6_.fechaingreso) AS sclr_12 FROM riesgoscubiertos r7_ INNER JOIN clientes c0_ ON (c0_.id = r7_.clientes_id) INNER JOIN contratos c1_ ON (c1_.id = r7_.contratos_id) INNER JOIN certificados c2_ ON (c2_.ncertificado = r7_.ncertificado AND c2_.contratos_id = r7_.contratos_id) INNER JOIN afiliados a6_ ON (a6_.clientes_id = r7_.clientes_id AND a6_.contratos_id = r7_.contratos_id) INNER JOIN planseleccionado p8_ ON (p8_.contratos_id = r7_.contratos_id) INNER JOIN planesservicios p9_ ON (p9_.id = p8_.planesservicios_id) INNER JOIN planes p3_ ON (p3_.id = p9_.planes_id) WHERE r7_.clientes_id = 2987 AND (c1_.estatuscontratos_id = 2 OR (c1_.estatuscontratos_id = 1 AND c1_.indservicioconrecibopendiente = 1)) AND CURRENT_DATE BETWEEN DATE_FORMAT(c2_.fechadesde, '%Y-%m-%d') AND DATE_FORMAT(c2_.fechahasta, '%Y-%m-%d') ORDER BY c1_.id DESC;

SELECT
  t0.tipoid AS tipoid_1,
  t0.numid AS numid_2,
  t0.nombresrazonsocial AS nombresrazonsocial_3,
  t0.datosregistro AS datosregistro_4,
  t0.direccion AS direccion_5,
  t0.codarea1 AS codarea1_6,
  t0.numero1 AS numero1_7,
  t0.codarea2 AS codarea2_8,
  t0.numero2 AS numero2_9,
  t0.email AS email_10,
  t0.edad AS edad_11,
  t0.sexo AS sexo_12,
  t0.fechanacimiento AS fechanacimiento_13,
  t0.id AS id_14
FROM
  clientes t0
WHERE
  t0.tipoid = ?
  AND t0.numid = ?
LIMIT
  1

SELECT t0.tipoid AS tipoid_1, t0.numid AS numid_2, t0.nombresrazonsocial AS nombresrazonsocial_3, t0.datosregistro AS datosregistro_4, t0.direccion AS direccion_5, t0.codarea1 AS codarea1_6, t0.numero1 AS numero1_7, t0.codarea2 AS codarea2_8, t0.numero2 AS numero2_9, t0.email AS email_10, t0.edad AS edad_11, t0.sexo AS sexo_12, t0.fechanacimiento AS fechanacimiento_13, t0.id AS id_14 FROM clientes t0 WHERE t0.tipoid = 'V' AND t0.numid = '27208006' LIMIT 1;

SELECT
  t0.ncertificado AS ncertificado_1,
  t0.fecharegistro AS fecharegistro_2,
  t0.cantidadmaxservicios AS cantidadmaxservicios_3,
  t0.sumaasegurada AS sumaasegurada_4,
  t0.fechaefectiva AS fechaefectiva_5,
  t0.id AS id_6,
  t0.clientes_id AS clientes_id_7,
  t0.contratos_id AS contratos_id_8,
  t0.tipoagotamiento_id AS tipoagotamiento_id_9,
  t0.tiposervicios_id AS tiposervicios_id_10
FROM
  riesgoscubiertos t0
WHERE
  t0.clientes_id = ?

SELECT t0.ncertificado AS ncertificado_1, t0.fecharegistro AS fecharegistro_2, t0.cantidadmaxservicios AS cantidadmaxservicios_3, t0.sumaasegurada AS sumaasegurada_4, t0.fechaefectiva AS fechaefectiva_5, t0.id AS id_6, t0.clientes_id AS clientes_id_7, t0.contratos_id AS contratos_id_8, t0.tipoagotamiento_id AS tipoagotamiento_id_9, t0.tiposervicios_id AS tiposervicios_id_10 FROM riesgoscubiertos t0 WHERE t0.clientes_id = 2987;