GET https://webbrown2.brown.gob.ar/

Query Metrics

4 Database Queries
4 Different statements
780.39 ms Query time
0 Invalid entities
30 Managed entities

Queries

Group similar statements

# Time Info
1 1.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.email_verified_at AS email_verified_at_4, t0.password AS password_5, t0.remember_token AS remember_token_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.roles AS roles_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  461
]
2 774.24 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM deceased d0_ LEFT JOIN plot p1_ ON d0_.plot_id = p1_.id LEFT JOIN tenant t2_ ON d0_.tenant_id = t2_.id LEFT JOIN title t3_ ON d0_.id = t3_.deceased_id WHERE d0_.deleted_at IS NULL
Parameters:
[]
3 1.99 ms
SELECT DISTINCT d0_.id AS id_0, d0_.id AS id_1 FROM deceased d0_ LEFT JOIN plot p1_ ON d0_.plot_id = p1_.id LEFT JOIN tenant t2_ ON d0_.tenant_id = t2_.id LEFT JOIN title t3_ ON d0_.id = t3_.deceased_id WHERE d0_.deleted_at IS NULL ORDER BY d0_.id DESC LIMIT 10
Parameters:
[]
4 2.55 ms
SELECT d0_.id AS id_0, d0_.deceased_number AS deceased_number_1, d0_.tax_deceased_id AS tax_deceased_id_2, d0_.last_name AS last_name_3, d0_.first_name AS first_name_4, d0_.death_date AS death_date_5, d0_.edad AS edad_6, d0_.document_type AS document_type_7, d0_.document_number AS document_number_8, d0_.burial_date AS burial_date_9, d0_.death_place AS death_place_10, d0_.nationality AS nationality_11, d0_.localidad AS localidad_12, d0_.gender AS gender_13, d0_.observations AS observations_14, d0_.infectious AS infectious_15, d0_.infectious_type AS infectious_type_16, d0_.judicial AS judicial_17, d0_.itp_number AS itp_number_18, d0_.is_exempt AS is_exempt_19, d0_.exemption_reason AS exemption_reason_20, d0_.missing_burial_license AS missing_burial_license_21, d0_.es_externo AS es_externo_22, d0_.difunto_foraneo AS difunto_foraneo_23, d0_.record_number AS record_number_24, d0_.civil_registry AS civil_registry_25, d0_.act_number AS act_number_26, d0_.folio AS folio_27, d0_.book AS book_28, d0_.book_year AS book_year_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.deleted_at AS deleted_at_32, p1_.id AS id_33, p1_.plot_number AS plot_number_34, p1_.zone AS zone_35, p1_.section AS section_36, p1_.block AS block_37, p1_.block_bis AS block_bis_38, p1_.`row` AS row_39, p1_.row_bis AS row_bis_40, p1_.grave AS grave_41, p1_.grave_bis AS grave_bis_42, p1_.`type` AS type_43, p1_.meters AS meters_44, p1_.cadastral_code AS cadastral_code_45, p1_.tax_account_id AS tax_account_id_46, p1_.active AS active_47, p1_.created_at AS created_at_48, p1_.updated_at AS updated_at_49, p1_.deleted_at AS deleted_at_50, p1_.is_locked AS is_locked_51, p1_.max_capacity AS max_capacity_52, t2_.id AS id_53, t2_.code AS code_54, t2_.last_name AS last_name_55, t2_.first_name AS first_name_56, t2_.document_type AS document_type_57, t2_.document_number AS document_number_58, t2_.cuit_cuil AS cuit_cuil_59, t2_.nro_contrib AS nro_contrib_60, t2_.has_cobol_payment_plan AS has_cobol_payment_plan_61, t2_.marital_status AS marital_status_62, t2_.type AS type_63, t2_.phone AS phone_64, t2_.email AS email_65, t2_.created_at AS created_at_66, t2_.updated_at AS updated_at_67, t2_.deleted_at AS deleted_at_68, d0_.plot_id AS plot_id_69, d0_.tenant_id AS tenant_id_70, d0_.funeral_home_id AS funeral_home_id_71, d0_.coffin_id AS coffin_id_72, t2_.address_id AS address_id_73 FROM deceased d0_ LEFT JOIN plot p1_ ON d0_.plot_id = p1_.id LEFT JOIN tenant t2_ ON d0_.tenant_id = t2_.id LEFT JOIN title t3_ ON d0_.id = t3_.deceased_id WHERE d0_.deleted_at IS NULL AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY d0_.id DESC
Parameters:
[
  "68145"
  "68144"
  "68143"
  "68142"
  "68141"
  "68140"
  "68139"
  "68138"
  "68137"
  "68136"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Deceased 10
App\Entity\FuneralHome 6
App\Entity\Plot 6
App\Entity\Tenant 3
App\Entity\Address 3
App\Entity\User 1
App\Entity\Coffin 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Movement No errors.
App\Entity\Deceased No errors.
App\Entity\Plot No errors.
App\Entity\Tenant No errors.
App\Entity\Title No errors.
App\Entity\FuneralHome No errors.
App\Entity\Coffin No errors.
App\Entity\Address No errors.
App\Entity\Debt No errors.
App\Entity\Procedure No errors.
App\Entity\PlotTenant No errors.
App\Entity\Invoice No errors.