Symfony Profiler

SELECT
  o0_.fecharegistro AS fecharegistro_0,
  o0_.fechaservicio AS fechaservicio_1,
  o0_.fechaestatus AS fechaestatus_2,
  o0_.monto AS monto_3,
  o0_.montopresupuesto AS montopresupuesto_4,
  o0_.montonocubierto AS montonocubierto_5,
  o0_.nroprepupuesto AS nroprepupuesto_6,
  o0_.montoautorizado AS montoautorizado_7,
  o0_.tasacambio AS tasacambio_8,
  o0_.tipo AS tipo_9,
  o0_.indplazosespera AS indplazosespera_10,
  o0_.diasplazosespera AS diasplazosespera_11,
  o0_.id AS id_12,
  o0_.analista_id AS analista_id_13,
  o0_.certificados_id AS certificados_id_14,
  o0_.clientes_id AS clientes_id_15,
  o0_.contratos_id AS contratos_id_16,
  o0_.estatusordenes_id AS estatusordenes_id_17,
  o0_.tiposervicios_id AS tiposervicios_id_18,
  o0_.usuarios_id AS usuarios_id_19,
  o0_.causarechazos_id AS causarechazos_id_20,
  o0_.monedas_id AS monedas_id_21,
  o0_.motivoscosulta_id AS motivoscosulta_id_22,
  o0_.patologias_id AS patologias_id_23,
  o0_.proveedores_id AS proveedores_id_24,
  o0_.recibos_id AS recibos_id_25,
  o0_.referidos_id AS referidos_id_26,
  o0_.unidades_id AS unidades_id_27
FROM
  ordenes o0_
  INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id
WHERE
  c1_.tipoid = ?
  AND c1_.numid = ?
ORDER BY
  o0_.fecharegistro DESC
LIMIT
  20

SELECT o0_.fecharegistro AS fecharegistro_0, o0_.fechaservicio AS fechaservicio_1, o0_.fechaestatus AS fechaestatus_2, o0_.monto AS monto_3, o0_.montopresupuesto AS montopresupuesto_4, o0_.montonocubierto AS montonocubierto_5, o0_.nroprepupuesto AS nroprepupuesto_6, o0_.montoautorizado AS montoautorizado_7, o0_.tasacambio AS tasacambio_8, o0_.tipo AS tipo_9, o0_.indplazosespera AS indplazosespera_10, o0_.diasplazosespera AS diasplazosespera_11, o0_.id AS id_12, o0_.analista_id AS analista_id_13, o0_.certificados_id AS certificados_id_14, o0_.clientes_id AS clientes_id_15, o0_.contratos_id AS contratos_id_16, o0_.estatusordenes_id AS estatusordenes_id_17, o0_.tiposervicios_id AS tiposervicios_id_18, o0_.usuarios_id AS usuarios_id_19, o0_.causarechazos_id AS causarechazos_id_20, o0_.monedas_id AS monedas_id_21, o0_.motivoscosulta_id AS motivoscosulta_id_22, o0_.patologias_id AS patologias_id_23, o0_.proveedores_id AS proveedores_id_24, o0_.recibos_id AS recibos_id_25, o0_.referidos_id AS referidos_id_26, o0_.unidades_id AS unidades_id_27 FROM ordenes o0_ INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id WHERE c1_.tipoid = 'V' AND c1_.numid = '13400167' ORDER BY o0_.fecharegistro DESC LIMIT 20;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_12
    FROM
      (
        SELECT
          o0_.fecharegistro AS fecharegistro_0,
          o0_.fechaservicio AS fechaservicio_1,
          o0_.fechaestatus AS fechaestatus_2,
          o0_.monto AS monto_3,
          o0_.montopresupuesto AS montopresupuesto_4,
          o0_.montonocubierto AS montonocubierto_5,
          o0_.nroprepupuesto AS nroprepupuesto_6,
          o0_.montoautorizado AS montoautorizado_7,
          o0_.tasacambio AS tasacambio_8,
          o0_.tipo AS tipo_9,
          o0_.indplazosespera AS indplazosespera_10,
          o0_.diasplazosespera AS diasplazosespera_11,
          o0_.id AS id_12
        FROM
          ordenes o0_
          INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id
        WHERE
          c1_.tipoid = ?
          AND c1_.numid = ?
        ORDER BY
          o0_.fecharegistro DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_12 FROM (SELECT o0_.fecharegistro AS fecharegistro_0, o0_.fechaservicio AS fechaservicio_1, o0_.fechaestatus AS fechaestatus_2, o0_.monto AS monto_3, o0_.montopresupuesto AS montopresupuesto_4, o0_.montonocubierto AS montonocubierto_5, o0_.nroprepupuesto AS nroprepupuesto_6, o0_.montoautorizado AS montoautorizado_7, o0_.tasacambio AS tasacambio_8, o0_.tipo AS tipo_9, o0_.indplazosespera AS indplazosespera_10, o0_.diasplazosespera AS diasplazosespera_11, o0_.id AS id_12 FROM ordenes o0_ INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id WHERE c1_.tipoid = 'V' AND c1_.numid = '13400167' ORDER BY o0_.fecharegistro DESC) dctrn_result) dctrn_table;

SELECT
  t0.descripcion AS descripcion_1,
  t0.estatus AS estatus_2,
  t0.id AS id_3
FROM
  estatusordenes t0
WHERE
  t0.id = ?

SELECT t0.descripcion AS descripcion_1, t0.estatus AS estatus_2, t0.id AS id_3 FROM estatusordenes t0 WHERE t0.id = 1;

SELECT
  DISTINCT id_12
FROM
  (
    SELECT
      DISTINCT id_12,
      fecharegistro_0
    FROM
      (
        SELECT
          o0_.fecharegistro AS fecharegistro_0,
          o0_.fechaservicio AS fechaservicio_1,
          o0_.fechaestatus AS fechaestatus_2,
          o0_.monto AS monto_3,
          o0_.montopresupuesto AS montopresupuesto_4,
          o0_.montonocubierto AS montonocubierto_5,
          o0_.nroprepupuesto AS nroprepupuesto_6,
          o0_.montoautorizado AS montoautorizado_7,
          o0_.tasacambio AS tasacambio_8,
          o0_.tipo AS tipo_9,
          o0_.indplazosespera AS indplazosespera_10,
          o0_.diasplazosespera AS diasplazosespera_11,
          o0_.id AS id_12,
          c1_.tipoid AS tipoid_13,
          c1_.numid AS numid_14
        FROM
          ordenes o0_
          INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id
        WHERE
          c1_.tipoid = ?
          AND c1_.numid = ?
      ) dctrn_result_inner
    ORDER BY
      fecharegistro_0 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_12 FROM (SELECT DISTINCT id_12, fecharegistro_0 FROM (SELECT o0_.fecharegistro AS fecharegistro_0, o0_.fechaservicio AS fechaservicio_1, o0_.fechaestatus AS fechaestatus_2, o0_.monto AS monto_3, o0_.montopresupuesto AS montopresupuesto_4, o0_.montonocubierto AS montonocubierto_5, o0_.nroprepupuesto AS nroprepupuesto_6, o0_.montoautorizado AS montoautorizado_7, o0_.tasacambio AS tasacambio_8, o0_.tipo AS tipo_9, o0_.indplazosespera AS indplazosespera_10, o0_.diasplazosespera AS diasplazosespera_11, o0_.id AS id_12, c1_.tipoid AS tipoid_13, c1_.numid AS numid_14 FROM ordenes o0_ INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id WHERE c1_.tipoid = 'V' AND c1_.numid = '13400167') dctrn_result_inner ORDER BY fecharegistro_0 DESC) dctrn_result LIMIT 20;

SELECT
  t0.descripcion AS descripcion_1,
  t0.observaciones AS observaciones_2,
  t0.iniciales AS iniciales_3,
  t0.prioridad AS prioridad_4,
  t0.id AS id_5
FROM
  tiposervicios t0
WHERE
  t0.id = ?

SELECT t0.descripcion AS descripcion_1, t0.observaciones AS observaciones_2, t0.iniciales AS iniciales_3, t0.prioridad AS prioridad_4, t0.id AS id_5 FROM tiposervicios t0 WHERE t0.id = 5;

SELECT
  o0_.fecharegistro AS fecharegistro_0,
  o0_.fechaservicio AS fechaservicio_1,
  o0_.fechaestatus AS fechaestatus_2,
  o0_.monto AS monto_3,
  o0_.montopresupuesto AS montopresupuesto_4,
  o0_.montonocubierto AS montonocubierto_5,
  o0_.nroprepupuesto AS nroprepupuesto_6,
  o0_.montoautorizado AS montoautorizado_7,
  o0_.tasacambio AS tasacambio_8,
  o0_.tipo AS tipo_9,
  o0_.indplazosespera AS indplazosespera_10,
  o0_.diasplazosespera AS diasplazosespera_11,
  o0_.id AS id_12,
  o0_.analista_id AS analista_id_13,
  o0_.certificados_id AS certificados_id_14,
  o0_.clientes_id AS clientes_id_15,
  o0_.contratos_id AS contratos_id_16,
  o0_.estatusordenes_id AS estatusordenes_id_17,
  o0_.tiposervicios_id AS tiposervicios_id_18,
  o0_.usuarios_id AS usuarios_id_19,
  o0_.causarechazos_id AS causarechazos_id_20,
  o0_.monedas_id AS monedas_id_21,
  o0_.motivoscosulta_id AS motivoscosulta_id_22,
  o0_.patologias_id AS patologias_id_23,
  o0_.proveedores_id AS proveedores_id_24,
  o0_.recibos_id AS recibos_id_25,
  o0_.referidos_id AS referidos_id_26,
  o0_.unidades_id AS unidades_id_27
FROM
  ordenes o0_
  INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id
WHERE
  c1_.tipoid = ?
  AND c1_.numid = ?
  AND o0_.id IN (?)
ORDER BY
  o0_.fecharegistro DESC

SELECT o0_.fecharegistro AS fecharegistro_0, o0_.fechaservicio AS fechaservicio_1, o0_.fechaestatus AS fechaestatus_2, o0_.monto AS monto_3, o0_.montopresupuesto AS montopresupuesto_4, o0_.montonocubierto AS montonocubierto_5, o0_.nroprepupuesto AS nroprepupuesto_6, o0_.montoautorizado AS montoautorizado_7, o0_.tasacambio AS tasacambio_8, o0_.tipo AS tipo_9, o0_.indplazosespera AS indplazosespera_10, o0_.diasplazosespera AS diasplazosespera_11, o0_.id AS id_12, o0_.analista_id AS analista_id_13, o0_.certificados_id AS certificados_id_14, o0_.clientes_id AS clientes_id_15, o0_.contratos_id AS contratos_id_16, o0_.estatusordenes_id AS estatusordenes_id_17, o0_.tiposervicios_id AS tiposervicios_id_18, o0_.usuarios_id AS usuarios_id_19, o0_.causarechazos_id AS causarechazos_id_20, o0_.monedas_id AS monedas_id_21, o0_.motivoscosulta_id AS motivoscosulta_id_22, o0_.patologias_id AS patologias_id_23, o0_.proveedores_id AS proveedores_id_24, o0_.recibos_id AS recibos_id_25, o0_.referidos_id AS referidos_id_26, o0_.unidades_id AS unidades_id_27 FROM ordenes o0_ INNER JOIN clientes c1_ ON o0_.clientes_id = c1_.id WHERE c1_.tipoid = 'V' AND c1_.numid = '13400167' AND o0_.id IN (3929, 3928, 3927, 3926, 3925, 3924, 3923, 3922, 3921, 3920, 3919, 3918, 3917, 3885, 3853, 3814, 3813, 3737, 3114, 3017) ORDER BY o0_.fecharegistro DESC;

SELECT
  t0.fecharegistro AS fecharegistro_1,
  t0.observacion AS observacion_2,
  t0.fechaestatus AS fechaestatus_3,
  t0.indservicioconrecibopendiente AS indservicioconrecibopendiente_4,
  t0.vip AS vip_5,
  t0.id AS id_6,
  t0.clientes_id AS clientes_id_7,
  t0.tipofacturacion_id AS tipofacturacion_id_8,
  t0.formaspago_id AS formaspago_id_9,
  t0.monedas_id AS monedas_id_10,
  t0.tiporiesgo_id AS tiporiesgo_id_11,
  t0.tipocontrato_id AS tipocontrato_id_12,
  t0.usuarios_id AS usuarios_id_13,
  t0.cotizaciones_id AS cotizaciones_id_14,
  t0.estatuscontratos_id AS estatuscontratos_id_15,
  t0.tipovigencias_id AS tipovigencias_id_16
FROM
  contratos t0
WHERE
  t0.id = ?

SELECT t0.fecharegistro AS fecharegistro_1, t0.observacion AS observacion_2, t0.fechaestatus AS fechaestatus_3, t0.indservicioconrecibopendiente AS indservicioconrecibopendiente_4, t0.vip AS vip_5, t0.id AS id_6, t0.clientes_id AS clientes_id_7, t0.tipofacturacion_id AS tipofacturacion_id_8, t0.formaspago_id AS formaspago_id_9, t0.monedas_id AS monedas_id_10, t0.tiporiesgo_id AS tiporiesgo_id_11, t0.tipocontrato_id AS tipocontrato_id_12, t0.usuarios_id AS usuarios_id_13, t0.cotizaciones_id AS cotizaciones_id_14, t0.estatuscontratos_id AS estatuscontratos_id_15, t0.tipovigencias_id AS tipovigencias_id_16 FROM contratos t0 WHERE t0.id = 242;

SELECT
  t0.tipoid AS tipoid_1,
  t0.numid AS numid_2,
  t0.fecharegistro AS fecharegistro_3,
  t0.fechaestatus AS fechaestatus_4,
  t0.fechadesde AS fechadesde_5,
  t0.fechahasta AS fechahasta_6,
  t0.ncertificado AS ncertificado_7,
  t0.estatus AS estatus_8,
  t0.fechaproximafacturacion AS fechaproximafacturacion_9,
  t0.fechaanulacion AS fechaanulacion_10,
  t0.causaanulacion AS causaanulacion_11,
  t0.id AS id_12,
  t0.contratos_id AS contratos_id_13
FROM
  certificados t0
WHERE
  t0.id = ?

SELECT t0.tipoid AS tipoid_1, t0.numid AS numid_2, t0.fecharegistro AS fecharegistro_3, t0.fechaestatus AS fechaestatus_4, t0.fechadesde AS fechadesde_5, t0.fechahasta AS fechahasta_6, t0.ncertificado AS ncertificado_7, t0.estatus AS estatus_8, t0.fechaproximafacturacion AS fechaproximafacturacion_9, t0.fechaanulacion AS fechaanulacion_10, t0.causaanulacion AS causaanulacion_11, t0.id AS id_12, t0.contratos_id AS contratos_id_13 FROM certificados t0 WHERE t0.id = 5164;

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.id = ?

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.id = 2891;