Symfony Profiler

SELECT 
  i0_.created_at AS created_at_0, 
  i0_.updated_at AS updated_at_1, 
  i0_.created_by AS created_by_2, 
  i0_.updated_by AS updated_by_3, 
  i0_.id AS id_4, 
  i0_.nombre AS nombre_5, 
  i0_.codigo AS codigo_6, 
  i0_.estacion_manual AS estacion_manual_7, 
  i0_.estacion_automatica AS estacion_automatica_8, 
  i0_.estado AS estado_9, 
  i0_.ab_inicio AS ab_inicio_10, 
  i0_.longitud_ini AS longitud_ini_11, 
  i0_.latitud_ini AS latitud_ini_12, 
  u1_.created_at AS created_at_13, 
  u1_.updated_at AS updated_at_14, 
  u1_.created_by AS created_by_15, 
  u1_.updated_by AS updated_by_16, 
  u1_.id AS id_17, 
  u1_.codigo AS codigo_18, 
  u1_.p_inicio AS p_inicio_19, 
  u1_.p_fin AS p_fin_20, 
  u1_.ab_inicio AS ab_inicio_21, 
  u1_.ab_fin AS ab_fin_22, 
  s2_.created_at AS created_at_23, 
  s2_.updated_at AS updated_at_24, 
  s2_.created_by AS created_by_25, 
  s2_.updated_by AS updated_by_26, 
  s2_.id AS id_27, 
  s2_.codigo AS codigo_28, 
  s2_.p_inicio AS p_inicio_29, 
  s2_.p_fin AS p_fin_30, 
  s2_.ab_inicio AS ab_inicio_31, 
  s2_.ab_fin AS ab_fin_32, 
  s2_.altura_ini AS altura_ini_33, 
  s2_.altura_fin AS altura_fin_34, 
  s2_.estado AS estado_35, 
  s2_.calzada_nombre AS calzada_nombre_36, 
  s2_.segmento_nombre AS segmento_nombre_37, 
  s2_.superficie_nombre AS superficie_nombre_38, 
  s2_.tipo_elemento AS tipo_elemento_39, 
  s2_.lado AS lado_40, 
  s2_.segmento_id AS segmento_id_41, 
  s2_.abs_sgm AS abs_sgm_42, 
  s2_.codigo_r AS codigo_r_43, 
  s2_.identificacion_ramal AS identificacion_ramal_44, 
  t3_.id AS id_45, 
  t3_.nombre AS nombre_46, 
  t3_.puntos AS puntos_47, 
  t3_.reutilizable AS reutilizable_48, 
  t3_.custom_order AS custom_order_49, 
  t3_.src AS src_50, 
  t3_.visible_on_policies AS visible_on_policies_51, 
  s4_.id AS id_52, 
  s4_.nombre AS nombre_53, 
  s4_.visible_on_policies AS visible_on_policies_54, 
  m5_.id AS id_55, 
  m5_.nombre AS nombre_56, 
  d6_.id AS id_57, 
  d6_.nombre AS nombre_58, 
  d6_.indicativo AS indicativo_59, 
  d7_.id AS id_60, 
  d7_.nombre AS nombre_61, 
  d7_.indicativo AS indicativo_62, 
  t8_.created_at AS created_at_63, 
  t8_.updated_at AS updated_at_64, 
  t8_.created_by AS created_by_65, 
  t8_.updated_by AS updated_by_66, 
  t8_.id AS id_67, 
  t8_.codigo AS codigo_68, 
  t8_.p_inicio AS p_inicio_69, 
  t8_.p_fin AS p_fin_70, 
  t8_.ab_inicio AS ab_inicio_71, 
  t8_.ab_fin AS ab_fin_72, 
  t8_.inicio AS inicio_73, 
  t8_.final AS final_74, 
  i0_.unidad_funcional_id AS unidad_funcional_id_75, 
  i0_.segmento_id AS segmento_id_76, 
  i0_.tramo_id AS tramo_id_77, 
  u1_.ruta_id AS ruta_id_78, 
  s2_.tipo_calzada_id AS tipo_calzada_id_79, 
  s2_.tipo_segmento_id AS tipo_segmento_id_80, 
  s2_.tipo_superficie_id AS tipo_superficie_id_81, 
  s2_.municipio_id AS municipio_id_82, 
  s2_.departamento_id AS departamento_id_83, 
  s2_.unidad_funcional_id AS unidad_funcional_id_84, 
  s2_.tramo_id AS tramo_id_85, 
  t3_.sistema_id AS sistema_id_86, 
  t3_.unidad_medida_id AS unidad_medida_id_87, 
  t3_.unidad_medida_id AS unidad_medida_id_88, 
  m5_.departamento_id AS departamento_id_89, 
  t8_.unidad_funcional_id AS unidad_funcional_id_90 
FROM 
  inventariopeaje i0_ 
  INNER JOIN unidad_funcional u1_ ON i0_.unidad_funcional_id = u1_.id 
  INNER JOIN segmento s2_ ON i0_.segmento_id = s2_.id 
  INNER JOIN tipo_elemento t3_ ON s2_.tipo_superficie_id = t3_.id 
  LEFT JOIN sistema s4_ ON t3_.sistema_id = s4_.id 
  LEFT JOIN municipio m5_ ON s2_.municipio_id = m5_.id 
  LEFT JOIN departamento d6_ ON m5_.departamento_id = d6_.id 
  LEFT JOIN departamento d7_ ON s2_.departamento_id = d7_.id 
  INNER JOIN tramo t8_ ON i0_.tramo_id = t8_.id 
ORDER BY 
  i0_.id ASC 
LIMIT 
  10

SELECT i0_.created_at AS created_at_0, i0_.updated_at AS updated_at_1, i0_.created_by AS created_by_2, i0_.updated_by AS updated_by_3, i0_.id AS id_4, i0_.nombre AS nombre_5, i0_.codigo AS codigo_6, i0_.estacion_manual AS estacion_manual_7, i0_.estacion_automatica AS estacion_automatica_8, i0_.estado AS estado_9, i0_.ab_inicio AS ab_inicio_10, i0_.longitud_ini AS longitud_ini_11, i0_.latitud_ini AS latitud_ini_12, u1_.created_at AS created_at_13, u1_.updated_at AS updated_at_14, u1_.created_by AS created_by_15, u1_.updated_by AS updated_by_16, u1_.id AS id_17, u1_.codigo AS codigo_18, u1_.p_inicio AS p_inicio_19, u1_.p_fin AS p_fin_20, u1_.ab_inicio AS ab_inicio_21, u1_.ab_fin AS ab_fin_22, s2_.created_at AS created_at_23, s2_.updated_at AS updated_at_24, s2_.created_by AS created_by_25, s2_.updated_by AS updated_by_26, s2_.id AS id_27, s2_.codigo AS codigo_28, s2_.p_inicio AS p_inicio_29, s2_.p_fin AS p_fin_30, s2_.ab_inicio AS ab_inicio_31, s2_.ab_fin AS ab_fin_32, s2_.altura_ini AS altura_ini_33, s2_.altura_fin AS altura_fin_34, s2_.estado AS estado_35, s2_.calzada_nombre AS calzada_nombre_36, s2_.segmento_nombre AS segmento_nombre_37, s2_.superficie_nombre AS superficie_nombre_38, s2_.tipo_elemento AS tipo_elemento_39, s2_.lado AS lado_40, s2_.segmento_id AS segmento_id_41, s2_.abs_sgm AS abs_sgm_42, s2_.codigo_r AS codigo_r_43, s2_.identificacion_ramal AS identificacion_ramal_44, t3_.id AS id_45, t3_.nombre AS nombre_46, t3_.puntos AS puntos_47, t3_.reutilizable AS reutilizable_48, t3_.custom_order AS custom_order_49, t3_.src AS src_50, t3_.visible_on_policies AS visible_on_policies_51, s4_.id AS id_52, s4_.nombre AS nombre_53, s4_.visible_on_policies AS visible_on_policies_54, m5_.id AS id_55, m5_.nombre AS nombre_56, d6_.id AS id_57, d6_.nombre AS nombre_58, d6_.indicativo AS indicativo_59, d7_.id AS id_60, d7_.nombre AS nombre_61, d7_.indicativo AS indicativo_62, t8_.created_at AS created_at_63, t8_.updated_at AS updated_at_64, t8_.created_by AS created_by_65, t8_.updated_by AS updated_by_66, t8_.id AS id_67, t8_.codigo AS codigo_68, t8_.p_inicio AS p_inicio_69, t8_.p_fin AS p_fin_70, t8_.ab_inicio AS ab_inicio_71, t8_.ab_fin AS ab_fin_72, t8_.inicio AS inicio_73, t8_.final AS final_74, i0_.unidad_funcional_id AS unidad_funcional_id_75, i0_.segmento_id AS segmento_id_76, i0_.tramo_id AS tramo_id_77, u1_.ruta_id AS ruta_id_78, s2_.tipo_calzada_id AS tipo_calzada_id_79, s2_.tipo_segmento_id AS tipo_segmento_id_80, s2_.tipo_superficie_id AS tipo_superficie_id_81, s2_.municipio_id AS municipio_id_82, s2_.departamento_id AS departamento_id_83, s2_.unidad_funcional_id AS unidad_funcional_id_84, s2_.tramo_id AS tramo_id_85, t3_.sistema_id AS sistema_id_86, t3_.unidad_medida_id AS unidad_medida_id_87, t3_.unidad_medida_id AS unidad_medida_id_88, m5_.departamento_id AS departamento_id_89, t8_.unidad_funcional_id AS unidad_funcional_id_90 FROM inventariopeaje i0_ INNER JOIN unidad_funcional u1_ ON i0_.unidad_funcional_id = u1_.id INNER JOIN segmento s2_ ON i0_.segmento_id = s2_.id INNER JOIN tipo_elemento t3_ ON s2_.tipo_superficie_id = t3_.id LEFT JOIN sistema s4_ ON t3_.sistema_id = s4_.id LEFT JOIN municipio m5_ ON s2_.municipio_id = m5_.id LEFT JOIN departamento d6_ ON m5_.departamento_id = d6_.id LEFT JOIN departamento d7_ ON s2_.departamento_id = d7_.id INNER JOIN tramo t8_ ON i0_.tramo_id = t8_.id ORDER BY i0_.id ASC LIMIT 10;

SELECT 
  t0.id AS id_1, 
  t0.lng AS lng_2, 
  t0.lat AS lat_3, 
  t0.elemento_id AS elemento_id_4 
FROM 
  ubicacion_segmento t0 
WHERE 
  t0.elemento_id = ?

SELECT t0.id AS id_1, t0.lng AS lng_2, t0.lat AS lat_3, t0.elemento_id AS elemento_id_4 FROM ubicacion_segmento t0 WHERE t0.elemento_id = 66;

SELECT 
  t0.id AS id_1, 
  t0.lng AS lng_2, 
  t0.lat AS lat_3, 
  t0.elemento_id AS elemento_id_4 
FROM 
  ubicacion_segmento t0 
WHERE 
  t0.elemento_id = ?

SELECT t0.id AS id_1, t0.lng AS lng_2, t0.lat AS lat_3, t0.elemento_id AS elemento_id_4 FROM ubicacion_segmento t0 WHERE t0.elemento_id = 73;

SELECT 
  t0.id AS id_1, 
  t0.abreviatura AS abreviatura_2, 
  t0.descripcion AS descripcion_3 
FROM 
  unidad_medida t0 
WHERE 
  t0.id IN (?)

SELECT t0.id AS id_1, t0.abreviatura AS abreviatura_2, t0.descripcion AS descripcion_3 FROM unidad_medida t0 WHERE t0.id IN (6);

SELECT 
  t0.id AS id_1, 
  t0.lng AS lng_2, 
  t0.lat AS lat_3, 
  t0.elemento_id AS elemento_id_4 
FROM 
  ubicacion_segmento t0 
WHERE 
  t0.elemento_id = ?

SELECT t0.id AS id_1, t0.lng AS lng_2, t0.lat AS lat_3, t0.elemento_id AS elemento_id_4 FROM ubicacion_segmento t0 WHERE t0.elemento_id = 97;

SELECT 
  t0.created_at AS created_at_1, 
  t0.updated_at AS updated_at_2, 
  t0.created_by AS created_by_3, 
  t0.updated_by AS updated_by_4, 
  t0.id AS id_5, 
  t0.codigo AS codigo_6, 
  t0.categoria_ruta AS categoria_ruta_7, 
  t0.tramo AS tramo_8, 
  t0.sector AS sector_9, 
  t0.origen AS origen_10, 
  t0.destino AS destino_11, 
  t0.p_inicio AS p_inicio_12, 
  t0.p_fin AS p_fin_13, 
  t0.proyecto_id AS proyecto_id_14 
FROM 
  ruta t0 
WHERE 
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.id AS id_5, t0.codigo AS codigo_6, t0.categoria_ruta AS categoria_ruta_7, t0.tramo AS tramo_8, t0.sector AS sector_9, t0.origen AS origen_10, t0.destino AS destino_11, t0.p_inicio AS p_inicio_12, t0.p_fin AS p_fin_13, t0.proyecto_id AS proyecto_id_14 FROM ruta t0 WHERE t0.id = 8;

SELECT 
  t0.created_at AS created_at_1, 
  t0.updated_at AS updated_at_2, 
  t0.created_by AS created_by_3, 
  t0.updated_by AS updated_by_4, 
  t0.id AS id_5, 
  t0.codigo AS codigo_6, 
  t0.nombre AS nombre_7, 
  t0.concesionario AS concesionario_8, 
  t0.longitud1 AS longitud1_9, 
  t0.latitud1 AS latitud1_10, 
  t0.longitud2 AS longitud2_11, 
  t0.latitud2 AS latitud2_12, 
  t0.altura_ini AS altura_ini_13, 
  t0.altura_fin AS altura_fin_14, 
  t0.idioma AS idioma_15, 
  t0.owner_id AS owner_id_16, 
  t17.created_at AS created_at_18, 
  t17.updated_at AS updated_at_19, 
  t17.created_by AS created_by_20, 
  t17.updated_by AS updated_by_21, 
  t17.id AS id_22, 
  t17.identificacion AS identificacion_23, 
  t17.nombres AS nombres_24, 
  t17.tipo_documento AS tipo_documento_25, 
  t17.apellidos AS apellidos_26, 
  t17.username AS username_27, 
  t17.password AS password_28, 
  t17.admin_nombre AS admin_nombre_29, 
  t17.idioma AS idioma_30, 
  t17.admin_id AS admin_id_31, 
  t0.licencia_id AS licencia_id_32, 
  t33.id AS id_34, 
  t33.lng AS lng_35, 
  t33.lat AS lat_36, 
  t33.elemento_id AS elemento_id_37 
FROM 
  proyecto t0 
  LEFT JOIN usuario t17 ON t0.owner_id = t17.id 
  LEFT JOIN ubicacion_proyecto t33 ON t33.elemento_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.id AS id_5, t0.codigo AS codigo_6, t0.nombre AS nombre_7, t0.concesionario AS concesionario_8, t0.longitud1 AS longitud1_9, t0.latitud1 AS latitud1_10, t0.longitud2 AS longitud2_11, t0.latitud2 AS latitud2_12, t0.altura_ini AS altura_ini_13, t0.altura_fin AS altura_fin_14, t0.idioma AS idioma_15, t0.owner_id AS owner_id_16, t17.created_at AS created_at_18, t17.updated_at AS updated_at_19, t17.created_by AS created_by_20, t17.updated_by AS updated_by_21, t17.id AS id_22, t17.identificacion AS identificacion_23, t17.nombres AS nombres_24, t17.tipo_documento AS tipo_documento_25, t17.apellidos AS apellidos_26, t17.username AS username_27, t17.password AS password_28, t17.admin_nombre AS admin_nombre_29, t17.idioma AS idioma_30, t17.admin_id AS admin_id_31, t0.licencia_id AS licencia_id_32, t33.id AS id_34, t33.lng AS lng_35, t33.lat AS lat_36, t33.elemento_id AS elemento_id_37 FROM proyecto t0 LEFT JOIN usuario t17 ON t0.owner_id = t17.id LEFT JOIN ubicacion_proyecto t33 ON t33.elemento_id = t0.id WHERE t0.id = 8;

SELECT 
  t0.created_at AS created_at_1, 
  t0.updated_at AS updated_at_2, 
  t0.created_by AS created_by_3, 
  t0.updated_by AS updated_by_4, 
  t0.id AS id_5, 
  t0.nombre AS nombre_6, 
  t0.tipo_rol AS tipo_rol_7, 
  t0.usuario AS usuario_8, 
  t0.perfiles AS perfiles_9, 
  t0.proyecto AS proyecto_10, 
  t0.rutas AS rutas_11, 
  t0.unifuncionales AS unifuncionales_12, 
  t0.tramos AS tramos_13, 
  t0.segmento AS segmento_14, 
  t0.contemergencia AS contemergencia_15, 
  t0.proveedores AS proveedores_16, 
  t0.serpublicos AS serpublicos_17, 
  t0.flexible AS flexible_18, 
  t0.rigido AS rigido_19, 
  t0.adoquin AS adoquin_20, 
  t0.otro AS otro_21, 
  t0.materiales AS materiales_22, 
  t0.ganulometria AS ganulometria_23, 
  t0.seguridad AS seguridad_24, 
  t0.mapa AS mapa_25, 
  t0.indicadores4g AS indicadores4g_26, 
  t0.reparaciones_menores AS reparaciones_menores_27, 
  t0.exportar_pers AS exportar_pers_28, 
  t0.reportes_pers AS reportes_pers_29, 
  t0.flujo_caja AS flujo_caja_30, 
  t0.drenaje AS drenaje_31, 
  t0.senalizacion AS senalizacion_32, 
  t0.alrededores AS alrededores_33, 
  t0.puentes AS puentes_34, 
  t0.contencion AS contencion_35, 
  t0.otro_elemento AS otro_elemento_36, 
  t0.redes AS redes_37, 
  t0.ponton AS ponton_38, 
  t0.inventario AS inventario_39, 
  t0.transito_mensual AS transito_mensual_40, 
  t0.inventarioa AS inventarioa_41, 
  t0.tunel AS tunel_42, 
  t0.disponibilidad_via AS disponibilidad_via_43, 
  t0.parametros_analisis AS parametros_analisis_44, 
  t0.alternativa_intervencion AS alternativa_intervencion_45, 
  t0.politica_general AS politica_general_46, 
  t0.politica_particular AS politica_particular_47, 
  t0.parametros_evaluacion AS parametros_evaluacion_48, 
  t0.diagrama_colorimetrico AS diagrama_colorimetrico_49, 
  t0.reparaciones AS reparaciones_50, 
  t0.deterioros AS deterioros_51, 
  t0.reportes_config AS reportes_config_52, 
  t0.reportes_pers_q AS reportes_pers_q_53, 
  t0.reportes_inventario_q AS reportes_inventario_q_54, 
  t0.reportes_indicadores_q AS reportes_indicadores_q_55, 
  t0.reportes_costos_q AS reportes_costos_q_56, 
  t0.reportes_transito_q AS reportes_transito_q_57, 
  t0.reportes_contactos_q AS reportes_contactos_q_58, 
  t0.reportes_modelacion_q AS reportes_modelacion_q_59, 
  t0.indicador_complementario AS indicador_complementario_60, 
  t0.respuesta_evaluacion_complementario AS respuesta_evaluacion_complementario_61, 
  t0.registro_novedad AS registro_novedad_62, 
  t0.respuesta_evaluacion_novedad AS respuesta_evaluacion_novedad_63, 
  t0.aprobacion AS aprobacion_64, 
  t0.config_sistema AS config_sistema_65, 
  t0.carga_masiva AS carga_masiva_66, 
  t0.idioma AS idioma_67, 
  t0.costo AS costo_68, 
  t0.audit AS audit_69 
FROM 
  atributo t0 
WHERE 
  t0.id IN (?)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.id AS id_5, t0.nombre AS nombre_6, t0.tipo_rol AS tipo_rol_7, t0.usuario AS usuario_8, t0.perfiles AS perfiles_9, t0.proyecto AS proyecto_10, t0.rutas AS rutas_11, t0.unifuncionales AS unifuncionales_12, t0.tramos AS tramos_13, t0.segmento AS segmento_14, t0.contemergencia AS contemergencia_15, t0.proveedores AS proveedores_16, t0.serpublicos AS serpublicos_17, t0.flexible AS flexible_18, t0.rigido AS rigido_19, t0.adoquin AS adoquin_20, t0.otro AS otro_21, t0.materiales AS materiales_22, t0.ganulometria AS ganulometria_23, t0.seguridad AS seguridad_24, t0.mapa AS mapa_25, t0.indicadores4g AS indicadores4g_26, t0.reparaciones_menores AS reparaciones_menores_27, t0.exportar_pers AS exportar_pers_28, t0.reportes_pers AS reportes_pers_29, t0.flujo_caja AS flujo_caja_30, t0.drenaje AS drenaje_31, t0.senalizacion AS senalizacion_32, t0.alrededores AS alrededores_33, t0.puentes AS puentes_34, t0.contencion AS contencion_35, t0.otro_elemento AS otro_elemento_36, t0.redes AS redes_37, t0.ponton AS ponton_38, t0.inventario AS inventario_39, t0.transito_mensual AS transito_mensual_40, t0.inventarioa AS inventarioa_41, t0.tunel AS tunel_42, t0.disponibilidad_via AS disponibilidad_via_43, t0.parametros_analisis AS parametros_analisis_44, t0.alternativa_intervencion AS alternativa_intervencion_45, t0.politica_general AS politica_general_46, t0.politica_particular AS politica_particular_47, t0.parametros_evaluacion AS parametros_evaluacion_48, t0.diagrama_colorimetrico AS diagrama_colorimetrico_49, t0.reparaciones AS reparaciones_50, t0.deterioros AS deterioros_51, t0.reportes_config AS reportes_config_52, t0.reportes_pers_q AS reportes_pers_q_53, t0.reportes_inventario_q AS reportes_inventario_q_54, t0.reportes_indicadores_q AS reportes_indicadores_q_55, t0.reportes_costos_q AS reportes_costos_q_56, t0.reportes_transito_q AS reportes_transito_q_57, t0.reportes_contactos_q AS reportes_contactos_q_58, t0.reportes_modelacion_q AS reportes_modelacion_q_59, t0.indicador_complementario AS indicador_complementario_60, t0.respuesta_evaluacion_complementario AS respuesta_evaluacion_complementario_61, t0.registro_novedad AS registro_novedad_62, t0.respuesta_evaluacion_novedad AS respuesta_evaluacion_novedad_63, t0.aprobacion AS aprobacion_64, t0.config_sistema AS config_sistema_65, t0.carga_masiva AS carga_masiva_66, t0.idioma AS idioma_67, t0.costo AS costo_68, t0.audit AS audit_69 FROM atributo t0 WHERE t0.id IN (3);

SELECT 
  t0.id AS id_1, 
  t0.lng AS lng_2, 
  t0.lat AS lat_3, 
  t0.elemento_id AS elemento_id_4 
FROM 
  ubicacion_inventariopeaje t0 
WHERE 
  t0.elemento_id = ?

SELECT t0.id AS id_1, t0.lng AS lng_2, t0.lat AS lat_3, t0.elemento_id AS elemento_id_4 FROM ubicacion_inventariopeaje t0 WHERE t0.elemento_id = 9;

SELECT 
  t0.id AS id_1, 
  t0.lng AS lng_2, 
  t0.lat AS lat_3, 
  t0.elemento_id AS elemento_id_4 
FROM 
  ubicacion_inventariopeaje t0 
WHERE 
  t0.elemento_id = ?

SELECT t0.id AS id_1, t0.lng AS lng_2, t0.lat AS lat_3, t0.elemento_id AS elemento_id_4 FROM ubicacion_inventariopeaje t0 WHERE t0.elemento_id = 10;

SELECT 
  t0.id AS id_1, 
  t0.lng AS lng_2, 
  t0.lat AS lat_3, 
  t0.elemento_id AS elemento_id_4 
FROM 
  ubicacion_inventariopeaje t0 
WHERE 
  t0.elemento_id = ?

SELECT t0.id AS id_1, t0.lng AS lng_2, t0.lat AS lat_3, t0.elemento_id AS elemento_id_4 FROM ubicacion_inventariopeaje t0 WHERE t0.elemento_id = 12;