https://inserjeune.francophonie.org/fr/front/persondegree/satisfactionSearch/4702/edit

Query Metrics

2 Database Queries
2 Different statements
2.92 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.58 ms
(54.23%)
1
SELECT t0.id AS id_1, t0.registered_training AS registered_training_2, t0.formation_pursuit_last_degree AS formation_pursuit_last_degree_3, t0.other_formation_degree_name AS other_formation_degree_name_4, t0.other_formation_activity_name AS other_formation_activity_name_5, t0.search_work AS search_work_6, t0.no_search_work_reason AS no_search_work_reason_7, t0.active_volunteer AS active_volunteer_8, t0.other_domain_volunteer AS other_domain_volunteer_9, t0.job_volunteer AS job_volunteer_10, t0.job_refuse AS job_refuse_11, t0.job_from_formation AS job_from_formation_12, t0.job_time AS job_time_13, t0.job_not_found_other AS job_not_found_other_14, t0.degree_date AS degree_date_15, t0.created_date AS created_date_16, t0.updated_date AS updated_date_17, t0.sector_area_volunteer_id AS sector_area_volunteer_id_18, t0.activity_volunteer_id AS activity_volunteer_id_19, t0.person_degree_id AS person_degree_id_20, t0.degree_id AS degree_id_21, t0.id_sectorArea AS id_sectorArea_22 FROM satisfaction_search t0 WHERE t0.id = ?
Parameters:
[
  "4702"
]
1.34 ms
(45.77%)
1
SELECT t0.status AS status_1, t0.type AS type_2, t0.agree_rgpd AS agree_rgpd_3, t0.last_degree_year AS last_degree_year_4, t0.last_degree_month AS last_degree_month_5, t0.other_degree AS other_degree_6, t0.diaspora AS diaspora_7, t0.address_diaspora AS address_diaspora_8, t0.created_date AS created_date_9, t0.updated_date AS updated_date_10, t0.client_updated_date AS client_updated_date_11, t0.previousEndedContract AS previousEndedContract_12, t0.registration_student_school AS registration_student_school_13, t0.check_school AS check_school_14, t0.other_school AS other_school_15, t0.monthly_salary AS monthly_salary_16, t0.other_activity AS other_activity_17, t0.temporary_passwd AS temporary_passwd_18, t0.lastIdSatisfactionSalary AS lastIdSatisfactionSalary_19, t0.lastIdSatisfactionSearch AS lastIdSatisfactionSearch_20, t0.lastIdSatisfactionCreato AS lastIdSatisfactionCreato_21, t0.unlocked AS unlocked_22, t0.id AS id_23, t0.firstname AS firstname_24, t0.lastname AS lastname_25, t0.birth_date AS birth_date_26, t0.address_number AS address_number_27, t0.address_locality AS address_locality_28, t0.address_road AS address_road_29, t0.other_city AS other_city_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.maps_address AS maps_address_33, t0.phone_mobile1 AS phone_mobile1_34, t0.phone_mobile2 AS phone_mobile2_35, t0.phone_mobile3 AS phone_mobile3_36, t0.phone_home AS phone_home_37, t0.phone_office AS phone_office_38, t0.location_mode AS location_mode_39, t0.email AS email_40, t0.sex AS sex_41, t0.residence_country_id AS residence_country_id_42, t0.residence_region_id AS residence_region_id_43, t0.id_degree AS id_degree_44, t0.school_id AS school_id_45, t0.lasted_company_id AS lasted_company_id_46, t0.activity_id AS activity_id_47, t0.id_sectorArea AS id_sectorArea_48, t0.lasted_contract_id AS lasted_contract_id_49, t0.lasted_company_id AS lasted_company_id_50, t0.user_id AS user_id_51, t0.id_city AS id_city_52, t0.id_region AS id_region_53, t0.id_country AS id_country_54, t0.id_image AS id_image_55 FROM person_degree t0 WHERE t0.id = ?
Parameters:
[
  16464
]

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\SatisfactionSearch No errors.
App\Entity\SectorArea No errors.
App\Entity\Activity
  • The association App\Entity\Activity#country refers to the owning side field App\Entity\Country#activity which does not exist.
App\Entity\PersonDegree
  • The field App\Entity\PersonDegree#satisfactionSalaries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionSalary#personDegree does not contain the required 'inversedBy="satisfactionSalaries"' attribute.
  • The field App\Entity\PersonDegree#satisfactionSearches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionSearch#personDegree does not contain the required 'inversedBy="satisfactionSearches"' attribute.
  • The field App\Entity\PersonDegree#satisfactionCreators is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionCreator#personDegree does not contain the required 'inversedBy="satisfactionCreators"' attribute.
App\Entity\Degree
  • The association App\Entity\Degree#schools refers to the owning side field App\Entity\School#degree which does not exist.
App\Entity\JobNotFoundReason No errors.
App\Entity\Country No errors.
App\Entity\Region
  • The association App\Entity\Region#currency refers to the inverse side field App\Entity\Currency#regions which does not exist.
  • The association App\Entity\Region#prefectures refers to the owning side field App\Entity\Prefecture#regions which does not exist.
App\Entity\School
  • The field App\Entity\School#personDegrees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PersonDegree#school does not contain the required 'inversedBy="personDegrees"' attribute.
App\Entity\Company
  • The field App\Entity\Company#salaries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PersonDegree#company does not contain the required 'inversedBy="salaries"' attribute.
  • The field App\Entity\Company#apprentices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Apprentice#company does not contain the required 'inversedBy="apprentices"' attribute.
  • The field App\Entity\Company#satisfactionCompanies is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SatisfactionCompany#company does not contain the required 'inversedBy="satisfactionCompanies"' attribute.
  • The field App\Entity\Company#schools is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\School#companies does not contain the required 'inversedBy="schools"' attribute.
App\Entity\Contract No errors.
App\Entity\User
  • The field App\Entity\User#school is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\School#user does not contain the required 'inversedBy="school"' attribute.
App\Entity\City No errors.
App\Entity\Image No errors.
App\Entity\SocialNetwork No errors.
App\Entity\InfoCreator No errors.
App\Entity\SatisfactionSalary No errors.
App\Entity\SatisfactionCreator No errors.