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

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.telefono AS telefono_3,
  t0.persona_id AS persona_id_4
FROM
  asistenteprofesional t0
  INNER JOIN profesionales_asistenteprofesional ON t0.id = profesionales_asistenteprofesional.asistenteprofesional_id
WHERE
  profesionales_asistenteprofesional.profesionales_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.telefono AS telefono_3, t0.persona_id AS persona_id_4 FROM asistenteprofesional t0 INNER JOIN profesionales_asistenteprofesional ON t0.id = profesionales_asistenteprofesional.asistenteprofesional_id WHERE profesionales_asistenteprofesional.profesionales_id = 431;

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

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

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
  INNER JOIN profesionales_entidad ON t0.id = profesionales_entidad.entidad_id
WHERE
  profesionales_entidad.profesionales_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 INNER JOIN profesionales_entidad ON t0.id = profesionales_entidad.entidad_id WHERE profesionales_entidad.profesionales_id = 431;

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.marca_id AS marca_id_10,
  t0.categoriaproducto_id AS categoriaproducto_id_11,
  t0.tipoproducto_id AS tipoproducto_id_12,
  t0.subtipoproducto_id AS subtipoproducto_id_13
FROM
  productos t0
  INNER JOIN paqueteproducto_productos ON t0.id = paqueteproducto_productos.productos_id
WHERE
  paqueteproducto_productos.paqueteproducto_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.marca_id AS marca_id_10, t0.categoriaproducto_id AS categoriaproducto_id_11, t0.tipoproducto_id AS tipoproducto_id_12, t0.subtipoproducto_id AS subtipoproducto_id_13 FROM productos t0 INNER JOIN paqueteproducto_productos ON t0.id = paqueteproducto_productos.productos_id WHERE paqueteproducto_productos.paqueteproducto_id = 17;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3
FROM
  estadocobertura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadocobertura t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.comision AS comision_2,
  t0.numhabilitacion AS numhabilitacion_3,
  t0.cuenta AS cuenta_4,
  t0.idintegracion AS idintegracion_5,
  t0.persona_id AS persona_id_6,
  t0.empresa_id AS empresa_id_7,
  t0.bancos_id AS bancos_id_8,
  t0.tipocuenta_id AS tipocuenta_id_9
FROM
  comercial t0
WHERE
  t0.persona_id = ?

SELECT t0.id AS id_1, t0.comision AS comision_2, t0.numhabilitacion AS numhabilitacion_3, t0.cuenta AS cuenta_4, t0.idintegracion AS idintegracion_5, t0.persona_id AS persona_id_6, t0.empresa_id AS empresa_id_7, t0.bancos_id AS bancos_id_8, t0.tipocuenta_id AS tipocuenta_id_9 FROM comercial t0 WHERE t0.persona_id = 41;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.descripcion AS descripcion_2
FROM
  poliza p0_

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2 FROM poliza p0_;

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.categoriaproducto_id AS categoriaproducto_id_9,
  t0.tipoproducto_id AS tipoproducto_id_10,
  t0.subtipoproducto_id AS subtipoproducto_id_11
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.categoriaproducto_id AS categoriaproducto_id_9, t0.tipoproducto_id AS tipoproducto_id_10, t0.subtipoproducto_id AS subtipoproducto_id_11 FROM paqueteproducto t0 WHERE t0.id = '17';

SELECT
  p0_.id AS id_0,
  p0_.numerocuenta AS numerocuenta_1,
  p0_.anioexperiencia AS anioexperiencia_2,
  p0_.tarjetaprofesional AS tarjetaprofesional_3,
  p0_.validacion AS validacion_4,
  p0_.persona_id AS persona_id_5,
  p0_.profesion_id AS profesion_id_6,
  p0_.banco_id AS banco_id_7,
  p0_.tipocuenta_id AS tipocuenta_id_8,
  p0_.comercial_id AS comercial_id_9,
  p0_.poliza_id AS poliza_id_10,
  p0_.estado_id AS estado_id_11,
  p0_.tipofacturacion_id AS tipofacturacion_id_12,
  p0_.razonsocialfacturacion_id AS razonsocialfacturacion_id_13,
  p0_.catalogoventa_id AS catalogoventa_id_14
FROM
  profesionales p0_
  INNER JOIN estadoprofesional e1_ ON p0_.estado_id = e1_.id
WHERE
  p0_.comercial_id = ?
  AND e1_.nombre = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.numerocuenta AS numerocuenta_1, p0_.anioexperiencia AS anioexperiencia_2, p0_.tarjetaprofesional AS tarjetaprofesional_3, p0_.validacion AS validacion_4, p0_.persona_id AS persona_id_5, p0_.profesion_id AS profesion_id_6, p0_.banco_id AS banco_id_7, p0_.tipocuenta_id AS tipocuenta_id_8, p0_.comercial_id AS comercial_id_9, p0_.poliza_id AS poliza_id_10, p0_.estado_id AS estado_id_11, p0_.tipofacturacion_id AS tipofacturacion_id_12, p0_.razonsocialfacturacion_id AS razonsocialfacturacion_id_13, p0_.catalogoventa_id AS catalogoventa_id_14 FROM profesionales p0_ INNER JOIN estadoprofesional e1_ ON p0_.estado_id = e1_.id WHERE p0_.comercial_id = 11 AND e1_.nombre = 'Activo' ORDER BY p0_.id DESC;

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
ORDER BY
  t0.nombre ASC

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 ORDER BY t0.nombre ASC;

SELECT
  t0_.id AS id_0,
  t0_.descripcion AS descripcion_1,
  t0_.codigo AS codigo_2,
  t0_.codigoodoo AS codigoodoo_3
FROM
  tiporesponsabilidad t0_

SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.codigo AS codigo_2, t0_.codigoodoo AS codigoodoo_3 FROM tiporesponsabilidad t0_;

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

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.descripcion AS descripcion_2,
  p0_.is_active AS is_active_3,
  p0_.costo AS costo_4,
  p0_.urlimagen AS urlimagen_5,
  p0_.urlvideo AS urlvideo_6,
  p0_.visible AS visible_7,
  p0_.categoriaproducto_id AS categoriaproducto_id_8,
  p0_.tipoproducto_id AS tipoproducto_id_9,
  p0_.subtipoproducto_id AS subtipoproducto_id_10
FROM
  paqueteproducto p0_

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2, p0_.is_active AS is_active_3, p0_.costo AS costo_4, p0_.urlimagen AS urlimagen_5, p0_.urlvideo AS urlvideo_6, p0_.visible AS visible_7, p0_.categoriaproducto_id AS categoriaproducto_id_8, p0_.tipoproducto_id AS tipoproducto_id_9, p0_.subtipoproducto_id AS subtipoproducto_id_10 FROM paqueteproducto p0_;

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.codigo AS codigo_2,
  m0_.departamento_id AS departamento_id_3
FROM
  municipio m0_

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.codigo AS codigo_2, m0_.departamento_id AS departamento_id_3 FROM municipio m0_;

SELECT
  e0_.id AS id_0,
  e0_.descripcion AS descripcion_1,
  e0_.estado AS estado_2,
  e0_.direccion AS direccion_3,
  e0_.empresa_id AS empresa_id_4,
  e0_.tipoentidad_id AS tipoentidad_id_5,
  e0_.municipio_id AS municipio_id_6
FROM
  entidad e0_

SELECT e0_.id AS id_0, e0_.descripcion AS descripcion_1, e0_.estado AS estado_2, e0_.direccion AS direccion_3, e0_.empresa_id AS empresa_id_4, e0_.tipoentidad_id AS tipoentidad_id_5, e0_.municipio_id AS municipio_id_6 FROM entidad e0_;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3
FROM
  rol t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.urlconexion AS urlconexion_2,
  t0.basededatos AS basededatos_3,
  t0.usuario AS usuario_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.idusuario AS idusuario_7
FROM
  sincronizacion t0

SELECT t0.id AS id_1, t0.urlconexion AS urlconexion_2, t0.basededatos AS basededatos_3, t0.usuario AS usuario_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.idusuario AS idusuario_7 FROM sincronizacion t0;

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

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;

SELECT
  t0_.id AS id_0,
  t0_.descripcion AS descripcion_1,
  t0_.abreviatura AS abreviatura_2,
  t0_.tipodocumentodian AS tipodocumentodian_3,
  t0_.idodoo AS idodoo_4
FROM
  tipodocumento t0_

SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.abreviatura AS abreviatura_2, t0_.tipodocumentodian AS tipodocumentodian_3, t0_.idodoo AS idodoo_4 FROM tipodocumento t0_;

SELECT
  e0_.id AS id_0,
  e0_.nombre AS nombre_1,
  e0_.descripcion AS descripcion_2
FROM
  estadocobertura e0_

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.descripcion AS descripcion_2 FROM estadocobertura e0_;

SELECT
  t0.id AS id_1,
  t0.maxprocedalta AS maxprocedalta_2,
  t0.maxnumprocedimiento AS maxnumprocedimiento_3,
  t0.edadmin AS edadmin_4,
  t0.edadmax AS edadmax_5,
  t0.imcmax AS imcmax_6,
  t0.asa AS asa_7,
  t0.hemoglobinamax AS hemoglobinamax_8,
  t0.consumidorfinal AS consumidorfinal_9,
  t0.catalogoprecio_id AS catalogoprecio_id_10
FROM
  config_cobertura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.maxprocedalta AS maxprocedalta_2, t0.maxnumprocedimiento AS maxnumprocedimiento_3, t0.edadmin AS edadmin_4, t0.edadmax AS edadmax_5, t0.imcmax AS imcmax_6, t0.asa AS asa_7, t0.hemoglobinamax AS hemoglobinamax_8, t0.consumidorfinal AS consumidorfinal_9, t0.catalogoprecio_id AS catalogoprecio_id_10 FROM config_cobertura t0 WHERE t0.id = 1;

SELECT
  r0_.id AS id_0,
  r0_.descripcion AS descripcion_1,
  r0_.codigo AS codigo_2,
  r0_.codigoodoo AS codigoodoo_3
FROM
  resptributaria r0_

SELECT r0_.id AS id_0, r0_.descripcion AS descripcion_1, r0_.codigo AS codigo_2, r0_.codigoodoo AS codigoodoo_3 FROM resptributaria r0_;