https://inserjeune.francophonie.org/fr/front/school/companies/1232/updateCompany

Query Metrics

3 Database Queries
3 Different statements
2.04 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.82 ms
(40.05%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.client_updated_date AS client_updated_date_6, t0.other_city AS other_city_7, t0.address_number AS address_number_8, t0.address_locality AS address_locality_9, t0.address_road AS address_road_10, t0.phone_standard AS phone_standard_11, t0.phone_other AS phone_other_12, t0.email AS email_13, t0.temporary_passwd AS temporary_passwd_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.maps_address AS maps_address_17, t0.location_fixed AS location_fixed_18, t0.agree_rgpd AS agree_rgpd_19, t0.location_mode AS location_mode_20, t0.unlocked AS unlocked_21, t0.id_city AS id_city_22, t0.id_region AS id_region_23, t0.id_country AS id_country_24, t0.id_contactCompany AS id_contactCompany_25, t0.id_sectorArea AS id_sectorArea_26, t0.id_legal_status AS id_legal_status_27, t0.user_id AS user_id_28, t0.id_image AS id_image_29 FROM company t0 WHERE t0.id = ?
Parameters:
[
  "1232"
]
0.62 ms
(30.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.post_code AS post_code_3, t0.is_capital AS is_capital_4, t0.is_prefecture_capital AS is_prefecture_capital_5, t0.id_region AS id_region_6, t0.prefecture_id AS prefecture_id_7 FROM city t0 WHERE t0.id = ?
Parameters:
[
  226
]
0.61 ms
(29.73%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.valid AS valid_3, t0.iso_code AS iso_code_4, t0.phone_code AS phone_code_5, t0.phone_digit AS phone_digit_6, t0.id_country AS id_country_7, t0.id_currency AS id_currency_8 FROM region t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\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\City 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\Country No errors.
App\Entity\ContactCompany No errors.
App\Entity\SectorArea No errors.
App\Entity\LegalStatus 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\Image No errors.
App\Entity\JobOffer No errors.
App\Entity\Publicity
  • The association App\Entity\Publicity#image refers to the inverse side field App\Entity\Image#publicities 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\Apprentice No errors.
App\Entity\SatisfactionCompany No errors.
App\Entity\SocialNetwork No errors.
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\Prefecture
  • The mappings App\Entity\Prefecture#region and App\Entity\Region#prefectures are inconsistent with each other.
App\Entity\Currency No errors.