Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.33 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.33 ms (100.00%)	1	SELECT t0.id AS id_1, t0.name_of_the_child AS name_of_the_child_2, t0.date_of_birth AS date_of_birth_3, t0.place_of_birth AS place_of_birth_4, t0.sex AS sex_5, t0.name_of_the_father AS name_of_the_father_6, t0.father_sprofession AS father_sprofession_7, t0.father_sresidence AS father_sresidence_8, t0.fathers_date_of_birth AS fathers_date_of_birth_9, t0.fathers_place_of_birth AS fathers_place_of_birth_10, t0.name_of_the_mother AS name_of_the_mother_11, t0.mother_sresidence AS mother_sresidence_12, t0.mother_sdate_of_birth AS mother_sdate_of_birth_13, t0.mother_splace_of_birth AS mother_splace_of_birth_14, t0.mother_sprofession AS mother_sprofession_15, t0.father_semail AS father_semail_16, t0.mother_semail AS mother_semail_17, t0.first_witness AS first_witness_18, t0.second_witness AS second_witness_19, t0.other_contact AS other_contact_20, t0.update_at AS update_at_21, t0.father_contact AS father_contact_22, t0.mother_contact AS mother_contact_23, t0.first_witness_nic AS first_witness_nic_24, t0.second_witness_nic AS second_witness_nic_25, t0.first_witness_phone_number AS first_witness_phone_number_26, t0.second_witness_phone_number AS second_witness_phone_number_27, t0.father_nic AS father_nic_28, t0.mother_nic AS mother_nic_29, t0.birth_declaration_file AS birth_declaration_file_30, t0.marriage_certificate AS marriage_certificate_31, t0.officer_validation1 AS officer_validation1_32, t0.officer_validation2 AS officer_validation2_33, t0.secretary_validation AS secretary_validation_34, t0.hospital_id AS hospital_id_35, t0.user_id AS user_id_36 FROM child t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name_of_the_child AS name_of_the_child_2, t0.date_of_birth AS date_of_birth_3, t0.place_of_birth AS place_of_birth_4, t0.sex AS sex_5, t0.name_of_the_father AS name_of_the_father_6, t0.father_sprofession AS father_sprofession_7, t0.father_sresidence AS father_sresidence_8, t0.fathers_date_of_birth AS fathers_date_of_birth_9, t0.fathers_place_of_birth AS fathers_place_of_birth_10, t0.name_of_the_mother AS name_of_the_mother_11, t0.mother_sresidence AS mother_sresidence_12, t0.mother_sdate_of_birth AS mother_sdate_of_birth_13, t0.mother_splace_of_birth AS mother_splace_of_birth_14, t0.mother_sprofession AS mother_sprofession_15, t0.father_semail AS father_semail_16, t0.mother_semail AS mother_semail_17, t0.first_witness AS first_witness_18, t0.second_witness AS second_witness_19, t0.other_contact AS other_contact_20, t0.update_at AS update_at_21, t0.father_contact AS father_contact_22, t0.mother_contact AS mother_contact_23, t0.first_witness_nic AS first_witness_nic_24, t0.second_witness_nic AS second_witness_nic_25, t0.first_witness_phone_number AS first_witness_phone_number_26, t0.second_witness_phone_number AS second_witness_phone_number_27, t0.father_nic AS father_nic_28, t0.mother_nic AS mother_nic_29, t0.birth_declaration_file AS birth_declaration_file_30, t0.marriage_certificate AS marriage_certificate_31, t0.officer_validation1 AS officer_validation1_32, t0.officer_validation2 AS officer_validation2_33, t0.secretary_validation AS secretary_validation_34, t0.hospital_id AS hospital_id_35, t0.user_id AS user_id_36 FROM child t0 SELECT t0.id AS id_1, t0.name_of_the_child AS name_of_the_child_2, t0.date_of_birth AS date_of_birth_3, t0.place_of_birth AS place_of_birth_4, t0.sex AS sex_5, t0.name_of_the_father AS name_of_the_father_6, t0.father_sprofession AS father_sprofession_7, t0.father_sresidence AS father_sresidence_8, t0.fathers_date_of_birth AS fathers_date_of_birth_9, t0.fathers_place_of_birth AS fathers_place_of_birth_10, t0.name_of_the_mother AS name_of_the_mother_11, t0.mother_sresidence AS mother_sresidence_12, t0.mother_sdate_of_birth AS mother_sdate_of_birth_13, t0.mother_splace_of_birth AS mother_splace_of_birth_14, t0.mother_sprofession AS mother_sprofession_15, t0.father_semail AS father_semail_16, t0.mother_semail AS mother_semail_17, t0.first_witness AS first_witness_18, t0.second_witness AS second_witness_19, t0.other_contact AS other_contact_20, t0.update_at AS update_at_21, t0.father_contact AS father_contact_22, t0.mother_contact AS mother_contact_23, t0.first_witness_nic AS first_witness_nic_24, t0.second_witness_nic AS second_witness_nic_25, t0.first_witness_phone_number AS first_witness_phone_number_26, t0.second_witness_phone_number AS second_witness_phone_number_27, t0.father_nic AS father_nic_28, t0.mother_nic AS mother_nic_29, t0.birth_declaration_file AS birth_declaration_file_30, t0.marriage_certificate AS marriage_certificate_31, t0.officer_validation1 AS officer_validation1_32, t0.officer_validation2 AS officer_validation2_33, t0.secretary_validation AS secretary_validation_34, t0.hospital_id AS hospital_id_35, t0.user_id AS user_id_36 FROM child t0;

Time▼

Count

Info

1.33 ms
(100.00%)

SELECT t0.id AS id_1, t0.name_of_the_child AS name_of_the_child_2, t0.date_of_birth AS date_of_birth_3, t0.place_of_birth AS place_of_birth_4, t0.sex AS sex_5, t0.name_of_the_father AS name_of_the_father_6, t0.father_sprofession AS father_sprofession_7, t0.father_sresidence AS father_sresidence_8, t0.fathers_date_of_birth AS fathers_date_of_birth_9, t0.fathers_place_of_birth AS fathers_place_of_birth_10, t0.name_of_the_mother AS name_of_the_mother_11, t0.mother_sresidence AS mother_sresidence_12, t0.mother_sdate_of_birth AS mother_sdate_of_birth_13, t0.mother_splace_of_birth AS mother_splace_of_birth_14, t0.mother_sprofession AS mother_sprofession_15, t0.father_semail AS father_semail_16, t0.mother_semail AS mother_semail_17, t0.first_witness AS first_witness_18, t0.second_witness AS second_witness_19, t0.other_contact AS other_contact_20, t0.update_at AS update_at_21, t0.father_contact AS father_contact_22, t0.mother_contact AS mother_contact_23, t0.first_witness_nic AS first_witness_nic_24, t0.second_witness_nic AS second_witness_nic_25, t0.first_witness_phone_number AS first_witness_phone_number_26, t0.second_witness_phone_number AS second_witness_phone_number_27, t0.father_nic AS father_nic_28, t0.mother_nic AS mother_nic_29, t0.birth_declaration_file AS birth_declaration_file_30, t0.marriage_certificate AS marriage_certificate_31, t0.officer_validation1 AS officer_validation1_32, t0.officer_validation2 AS officer_validation2_33, t0.secretary_validation AS secretary_validation_34, t0.hospital_id AS hospital_id_35, t0.user_id AS user_id_36 FROM child t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name_of_the_child AS name_of_the_child_2,
  t0.date_of_birth AS date_of_birth_3,
  t0.place_of_birth AS place_of_birth_4,
  t0.sex AS sex_5,
  t0.name_of_the_father AS name_of_the_father_6,
  t0.father_sprofession AS father_sprofession_7,
  t0.father_sresidence AS father_sresidence_8,
  t0.fathers_date_of_birth AS fathers_date_of_birth_9,
  t0.fathers_place_of_birth AS fathers_place_of_birth_10,
  t0.name_of_the_mother AS name_of_the_mother_11,
  t0.mother_sresidence AS mother_sresidence_12,
  t0.mother_sdate_of_birth AS mother_sdate_of_birth_13,
  t0.mother_splace_of_birth AS mother_splace_of_birth_14,
  t0.mother_sprofession AS mother_sprofession_15,
  t0.father_semail AS father_semail_16,
  t0.mother_semail AS mother_semail_17,
  t0.first_witness AS first_witness_18,
  t0.second_witness AS second_witness_19,
  t0.other_contact AS other_contact_20,
  t0.update_at AS update_at_21,
  t0.father_contact AS father_contact_22,
  t0.mother_contact AS mother_contact_23,
  t0.first_witness_nic AS first_witness_nic_24,
  t0.second_witness_nic AS second_witness_nic_25,
  t0.first_witness_phone_number AS first_witness_phone_number_26,
  t0.second_witness_phone_number AS second_witness_phone_number_27,
  t0.father_nic AS father_nic_28,
  t0.mother_nic AS mother_nic_29,
  t0.birth_declaration_file AS birth_declaration_file_30,
  t0.marriage_certificate AS marriage_certificate_31,
  t0.officer_validation1 AS officer_validation1_32,
  t0.officer_validation2 AS officer_validation2_33,
  t0.secretary_validation AS secretary_validation_34,
  t0.hospital_id AS hospital_id_35,
  t0.user_id AS user_id_36
FROM
  child t0

SELECT t0.id AS id_1, t0.name_of_the_child AS name_of_the_child_2, t0.date_of_birth AS date_of_birth_3, t0.place_of_birth AS place_of_birth_4, t0.sex AS sex_5, t0.name_of_the_father AS name_of_the_father_6, t0.father_sprofession AS father_sprofession_7, t0.father_sresidence AS father_sresidence_8, t0.fathers_date_of_birth AS fathers_date_of_birth_9, t0.fathers_place_of_birth AS fathers_place_of_birth_10, t0.name_of_the_mother AS name_of_the_mother_11, t0.mother_sresidence AS mother_sresidence_12, t0.mother_sdate_of_birth AS mother_sdate_of_birth_13, t0.mother_splace_of_birth AS mother_splace_of_birth_14, t0.mother_sprofession AS mother_sprofession_15, t0.father_semail AS father_semail_16, t0.mother_semail AS mother_semail_17, t0.first_witness AS first_witness_18, t0.second_witness AS second_witness_19, t0.other_contact AS other_contact_20, t0.update_at AS update_at_21, t0.father_contact AS father_contact_22, t0.mother_contact AS mother_contact_23, t0.first_witness_nic AS first_witness_nic_24, t0.second_witness_nic AS second_witness_nic_25, t0.first_witness_phone_number AS first_witness_phone_number_26, t0.second_witness_phone_number AS second_witness_phone_number_27, t0.father_nic AS father_nic_28, t0.mother_nic AS mother_nic_29, t0.birth_declaration_file AS birth_declaration_file_30, t0.marriage_certificate AS marriage_certificate_31, t0.officer_validation1 AS officer_validation1_32, t0.officer_validation2 AS officer_validation2_33, t0.secretary_validation AS secretary_validation_34, t0.hospital_id AS hospital_id_35, t0.user_id AS user_id_36 FROM child t0;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Child	The association App\Entity\Child#hospital refers to the inverse side field App\Entity\Hospital#Children which does not exist.
App\Entity\Hospital	The mappings App\Entity\Hospital#children and App\Entity\Child#hospital are inconsistent with each other.
App\Entity\User	No errors.

Symfony Profiler

https://birth.habitechsolutions.cm/en/child/

Configuration Settings

Theme