Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.primernombre AS primernombre_2,
  t0.segundonombre AS segundonombre_3,
  t0.primerapellido AS primerapellido_4,
  t0.segundoapellido AS segundoapellido_5,
  t0.documento AS documento_6,
  t0.estado AS estado_7,
  t0.fechanacimiento AS fechanacimiento_8,
  t0.direccion AS direccion_9,
  t0.telefono AS telefono_10,
  t0.email AS email_11,
  t0.idintegracion AS idintegracion_12,
  t0.documentfile AS documentfile_13,
  t0.tipodocumento_id AS tipodocumento_id_14,
  t0.municipio_id AS municipio_id_15,
  t0.empresa_id AS empresa_id_16,
  t0.tipopago_id AS tipopago_id_17,
  t0.catalogoprecio_id AS catalogoprecio_id_18,
  t0.tipocliente_id AS tipocliente_id_19,
  t0.resptributaria_id AS resptributaria_id_20,
  t0.posicionfiscal_id AS posicionfiscal_id_21
FROM
  persona t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.primernombre AS primernombre_2, t0.segundonombre AS segundonombre_3, t0.primerapellido AS primerapellido_4, t0.segundoapellido AS segundoapellido_5, t0.documento AS documento_6, t0.estado AS estado_7, t0.fechanacimiento AS fechanacimiento_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.email AS email_11, t0.idintegracion AS idintegracion_12, t0.documentfile AS documentfile_13, t0.tipodocumento_id AS tipodocumento_id_14, t0.municipio_id AS municipio_id_15, t0.empresa_id AS empresa_id_16, t0.tipopago_id AS tipopago_id_17, t0.catalogoprecio_id AS catalogoprecio_id_18, t0.tipocliente_id AS tipocliente_id_19, t0.resptributaria_id AS resptributaria_id_20, t0.posicionfiscal_id AS posicionfiscal_id_21 FROM persona t0 WHERE t0.id = 8674;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.carrounico AS carrounico_9,
  t0.requiere_agenda AS requiere_agenda_10,
  t0.marca_id AS marca_id_11,
  t0.categoriaproducto_id AS categoriaproducto_id_12,
  t0.tipoproducto_id AS tipoproducto_id_13,
  t0.subtipoproducto_id AS subtipoproducto_id_14
FROM
  productos t0
  INNER JOIN solicitudcobertura_productos ON t0.id = solicitudcobertura_productos.productos_id
WHERE
  solicitudcobertura_productos.solicitudcobertura_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.carrounico AS carrounico_9, t0.requiere_agenda AS requiere_agenda_10, t0.marca_id AS marca_id_11, t0.categoriaproducto_id AS categoriaproducto_id_12, t0.tipoproducto_id AS tipoproducto_id_13, t0.subtipoproducto_id AS subtipoproducto_id_14 FROM productos t0 INNER JOIN solicitudcobertura_productos ON t0.id = solicitudcobertura_productos.productos_id WHERE solicitudcobertura_productos.solicitudcobertura_id = 8334;

SELECT
  t0.id AS id_1,
  t0.precio AS precio_2,
  t0.valorasegurado AS valorasegurado_3,
  t0.duracion AS duracion_4,
  t0.observacion AS observacion_5,
  t0.fechaprocedimiento AS fechaprocedimiento_6,
  t0.fechacreacion AS fechacreacion_7,
  t0.fechaenviada AS fechaenviada_8,
  t0.urldocidentificacion AS urldocidentificacion_9,
  t0.urlcobertura AS urlcobertura_10,
  t0.urlcomprobantepago AS urlcomprobantepago_11,
  t0.tipopersonafacturacion AS tipopersonafacturacion_12,
  t0.sincronizado AS sincronizado_13,
  t0.pedidoodoo AS pedidoodoo_14,
  t0.edad AS edad_15,
  t0.estatura AS estatura_16,
  t0.peso AS peso_17,
  t0.asa AS asa_18,
  t0.hemoglobina AS hemoglobina_19,
  t0.anexos AS anexos_20,
  t0.certificado AS certificado_21,
  t0.fechamodificacion AS fechamodificacion_22,
  t0.nombreodoo AS nombreodoo_23,
  t0.consumidorfinal AS consumidorfinal_24,
  t0.usuario_id AS usuario_id_25,
  t0.profesional_id AS profesional_id_26,
  t0.asistente_id AS asistente_id_27,
  t0.paciente_id AS paciente_id_28,
  t0.entidad_id AS entidad_id_29,
  t0.paquetecobertura_id AS paquetecobertura_id_30,
  t0.estado_id AS estado_id_31,
  t0.especialidad_id AS especialidad_id_32,
  t0.municipio_id AS municipio_id_33,
  t0.poliza_id AS poliza_id_34,
  t0.personafacturacion_id AS personafacturacion_id_35,
  t0.empresafacturacion_id AS empresafacturacion_id_36,
  t0.usuariocancela_id AS usuariocancela_id_37,
  t0.usuariomodifica_id AS usuariomodifica_id_38,
  t0.tipopago_id AS tipopago_id_39
FROM
  solicitudcobertura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.precio AS precio_2, t0.valorasegurado AS valorasegurado_3, t0.duracion AS duracion_4, t0.observacion AS observacion_5, t0.fechaprocedimiento AS fechaprocedimiento_6, t0.fechacreacion AS fechacreacion_7, t0.fechaenviada AS fechaenviada_8, t0.urldocidentificacion AS urldocidentificacion_9, t0.urlcobertura AS urlcobertura_10, t0.urlcomprobantepago AS urlcomprobantepago_11, t0.tipopersonafacturacion AS tipopersonafacturacion_12, t0.sincronizado AS sincronizado_13, t0.pedidoodoo AS pedidoodoo_14, t0.edad AS edad_15, t0.estatura AS estatura_16, t0.peso AS peso_17, t0.asa AS asa_18, t0.hemoglobina AS hemoglobina_19, t0.anexos AS anexos_20, t0.certificado AS certificado_21, t0.fechamodificacion AS fechamodificacion_22, t0.nombreodoo AS nombreodoo_23, t0.consumidorfinal AS consumidorfinal_24, t0.usuario_id AS usuario_id_25, t0.profesional_id AS profesional_id_26, t0.asistente_id AS asistente_id_27, t0.paciente_id AS paciente_id_28, t0.entidad_id AS entidad_id_29, t0.paquetecobertura_id AS paquetecobertura_id_30, t0.estado_id AS estado_id_31, t0.especialidad_id AS especialidad_id_32, t0.municipio_id AS municipio_id_33, t0.poliza_id AS poliza_id_34, t0.personafacturacion_id AS personafacturacion_id_35, t0.empresafacturacion_id AS empresafacturacion_id_36, t0.usuariocancela_id AS usuariocancela_id_37, t0.usuariomodifica_id AS usuariomodifica_id_38, t0.tipopago_id AS tipopago_id_39 FROM solicitudcobertura t0 WHERE t0.id = '8334';

SELECT
  t0.id AS id_1,
  t0.numerocuenta AS numerocuenta_2,
  t0.anioexperiencia AS anioexperiencia_3,
  t0.tarjetaprofesional AS tarjetaprofesional_4,
  t0.validacion AS validacion_5,
  t0.corte_facturacion AS corte_facturacion_6,
  t0.persona_id AS persona_id_7,
  t0.profesion_id AS profesion_id_8,
  t0.banco_id AS banco_id_9,
  t0.tipocuenta_id AS tipocuenta_id_10,
  t0.comercial_id AS comercial_id_11,
  t0.estado_id AS estado_id_12,
  t0.tipofacturacion_id AS tipofacturacion_id_13,
  t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_14,
  t0.catalogoventa_id AS catalogoventa_id_15
FROM
  profesionales t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numerocuenta AS numerocuenta_2, t0.anioexperiencia AS anioexperiencia_3, t0.tarjetaprofesional AS tarjetaprofesional_4, t0.validacion AS validacion_5, t0.corte_facturacion AS corte_facturacion_6, t0.persona_id AS persona_id_7, t0.profesion_id AS profesion_id_8, t0.banco_id AS banco_id_9, t0.tipocuenta_id AS tipocuenta_id_10, t0.comercial_id AS comercial_id_11, t0.estado_id AS estado_id_12, t0.tipofacturacion_id AS tipofacturacion_id_13, t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_14, t0.catalogoventa_id AS catalogoventa_id_15 FROM profesionales t0 WHERE t0.id = 182;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo AS codigo_3,
  t0.departamento_id AS departamento_id_4
FROM
  municipio t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.departamento_id AS departamento_id_4 FROM municipio t0 WHERE t0.id = 354;

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.estado AS estado_3,
  t0.direccion AS direccion_4,
  t0.empresa_id AS empresa_id_5,
  t0.tipoentidad_id AS tipoentidad_id_6,
  t0.municipio_id AS municipio_id_7
FROM
  entidad t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.estado AS estado_3, t0.direccion AS direccion_4, t0.empresa_id AS empresa_id_5, t0.tipoentidad_id AS tipoentidad_id_6, t0.municipio_id AS municipio_id_7 FROM entidad t0 WHERE t0.id = 138;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.terminosycondiciones AS terminosycondiciones_5,
  t0.suscripcion AS suscripcion_6,
  t0.persona_id AS persona_id_7,
  t0.rol_id AS rol_id_8
FROM
  `user` t0
WHERE
  t0.rol_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.terminosycondiciones AS terminosycondiciones_5, t0.suscripcion AS suscripcion_6, t0.persona_id AS persona_id_7, t0.rol_id AS rol_id_8 FROM `user` t0 WHERE t0.rol_id = 7;

SELECT
  b0_.id AS id_0,
  b0_.activo AS activo_1,
  b0_.fecha_inicio AS fecha_inicio_2,
  b0_.fecha_fin AS fecha_fin_3,
  b0_.motivo AS motivo_4,
  b0_.mensaje_usuarios AS mensaje_usuarios_5,
  b0_.bloqueo_total AS bloqueo_total_6,
  b0_.modulos_bloqueados AS modulos_bloqueados_7,
  b0_.bloqueo_indefinido AS bloqueo_indefinido_8,
  b0_.fecha_creacion AS fecha_creacion_9,
  b0_.fecha_modificacion AS fecha_modificacion_10,
  b0_.fecha_activacion AS fecha_activacion_11,
  b0_.fecha_desactivacion AS fecha_desactivacion_12,
  b0_.creado_por_id AS creado_por_id_13,
  b0_.desactivado_por_id AS desactivado_por_id_14
FROM
  bloqueo_sistema b0_
WHERE
  b0_.activo = ?
ORDER BY
  b0_.fecha_creacion DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.activo AS activo_1, b0_.fecha_inicio AS fecha_inicio_2, b0_.fecha_fin AS fecha_fin_3, b0_.motivo AS motivo_4, b0_.mensaje_usuarios AS mensaje_usuarios_5, b0_.bloqueo_total AS bloqueo_total_6, b0_.modulos_bloqueados AS modulos_bloqueados_7, b0_.bloqueo_indefinido AS bloqueo_indefinido_8, b0_.fecha_creacion AS fecha_creacion_9, b0_.fecha_modificacion AS fecha_modificacion_10, b0_.fecha_activacion AS fecha_activacion_11, b0_.fecha_desactivacion AS fecha_desactivacion_12, b0_.creado_por_id AS creado_por_id_13, b0_.desactivado_por_id AS desactivado_por_id_14 FROM bloqueo_sistema b0_ WHERE b0_.activo = 1 ORDER BY b0_.fecha_creacion DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.abreviatura AS abreviatura_3,
  t0.tipodocumentodian AS tipodocumentodian_4,
  t0.idodoo AS idodoo_5
FROM
  tipodocumento t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.abreviatura AS abreviatura_3, t0.tipodocumentodian AS tipodocumentodian_4, t0.idodoo AS idodoo_5 FROM tipodocumento t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.tipoproducto_id AS tipoproducto_id_4
FROM
  subtipoproducto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.tipoproducto_id AS tipoproducto_id_4 FROM subtipoproducto t0 WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.is_active AS is_active_4,
  t0.costo AS costo_5,
  t0.urlimagen AS urlimagen_6,
  t0.urlvideo AS urlvideo_7,
  t0.visible AS visible_8,
  t0.requiere_agenda AS requiere_agenda_9,
  t0.categoriaproducto_id AS categoriaproducto_id_10,
  t0.tipoproducto_id AS tipoproducto_id_11,
  t0.subtipoproducto_id AS subtipoproducto_id_12
FROM
  paqueteproducto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.is_active AS is_active_4, t0.costo AS costo_5, t0.urlimagen AS urlimagen_6, t0.urlvideo AS urlvideo_7, t0.visible AS visible_8, t0.requiere_agenda AS requiere_agenda_9, t0.categoriaproducto_id AS categoriaproducto_id_10, t0.tipoproducto_id AS tipoproducto_id_11, t0.subtipoproducto_id AS subtipoproducto_id_12 FROM paqueteproducto t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.grupo_lista_precio_id AS grupo_lista_precio_id_4
FROM
  poliza t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.grupo_lista_precio_id AS grupo_lista_precio_id_4 FROM poliza t0 WHERE t0.id = 5;