Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

3.51 ms Query time

8 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
2.51 ms (71.61%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.id_region AS id_region_3 FROM prefecture t0 WHERE t0.id_region IS NULL Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.id_region AS id_region_3 FROM prefecture t0 WHERE t0.id_region IS NULL SELECT t0.id AS id_1, t0.name AS name_2, t0.id_region AS id_region_3 FROM prefecture t0 WHERE t0.id_region IS NULL;
1.00 ms (28.39%)	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_region IS NULL Parameters: [] View formatted query View runnable query Explain query 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_region IS NULL 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_region IS NULL;

Time▼

Count

Info

2.51 ms
(71.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.id_region AS id_region_3 FROM prefecture t0 WHERE t0.id_region IS NULL

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.id_region AS id_region_3
FROM
  prefecture t0
WHERE
  t0.id_region IS NULL

SELECT t0.id AS id_1, t0.name AS name_2, t0.id_region AS id_region_3 FROM prefecture t0 WHERE t0.id_region IS NULL;

1.00 ms
(28.39%)

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_region IS NULL

Parameters:

[]

View formatted query View runnable query Explain query

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_region IS NULL

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_region IS NULL;

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\Prefecture	The mappings App\Entity\Prefecture#region and App\Entity\Region#prefectures are inconsistent with each other.
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\Activity	The association App\Entity\Activity#country refers to the owning side field App\Entity\Country#activity which does not exist.
App\Entity\SectorArea	No errors.
App\Entity\SatisfactionCompany	No errors.
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\Contract	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.

Symfony Profiler

https://dbtechafricatracer.org/DBTA/public/en/getPrefecturesByRegion

Configuration Settings

Theme