https://dbtechafricatracer.org/DBTA/public/fr/jobOffer/117

Method
GET
HTTP Status
500
IP
216.244.66.236
Profiled on
Token
c283d9

Query Metrics

1 Database Queries
1 Different statements
3.74 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
3.74 ms
(100.00%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_date AS created_date_4, t0.closed_date AS closed_date_5, t0.posted_contact AS posted_contact_6, t0.posted_phone AS posted_phone_7, t0.posted_email AS posted_email_8, t0.cover_letter AS cover_letter_9, t0.other_activity AS other_activity_10, t0.filename AS filename_11, t0.other_city AS other_city_12, t0.updated_date AS updated_date_13, t0.is_view AS is_view_14, t0.candidate_profile AS candidate_profile_15, t0.candidate_sended AS candidate_sended_16, t0.id_company AS id_company_17, t0.id_school AS id_school_18, t0.id_sectorArea AS id_sectorArea_19, t0.activity_id AS activity_id_20, t0.lasted_contract_id AS lasted_contract_id_21, t0.id_city AS id_city_22, t0.id_region AS id_region_23, t0.id_country AS id_country_24 FROM job_offer t0 WHERE t0.id = ?
Parameters: 
[
  "117"
]
View formatted query    View runnable query    Explain query

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\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\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\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\JobOffer No errors.
App\Entity\JobApplied No errors.
App\Entity\SatisfactionCompany 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\Contract No errors.
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\Prefecture
  • The mappings App\Entity\Prefecture#region and App\Entity\Region#prefectures are inconsistent with each other.
App\Entity\SatisfactionSearch No errors.
App\Entity\JobNotFoundReason No errors.
App\Entity\SatisfactionSalary No errors.
App\Entity\SatisfactionCreator No errors.
App\Entity\LegalStatus No errors.
App\Entity\Degree
  • The association App\Entity\Degree#schools refers to the owning side field App\Entity\School#degree which does not exist.