Query Metrics

6 Database Queries
6 Different statements
2.90 ms Query time
1 Invalid entities
930 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.59 ms
(54.78%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ WHERE c0_.status = ? ORDER BY c0_.name ASC
Parameters:
[
  "published"
]
0.54 ms
(18.68%)
1
SELECT t0.id AS id_1, t0.label AS label_2 FROM speech_type t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "remote"
]
0.27 ms
(9.16%)
1
SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_
Parameters:
[]
0.19 ms
(6.66%)
1
SELECT e0_.id AS id_0, e0_.label AS label_1 FROM education_level e0_
Parameters:
[]
0.19 ms
(6.48%)
1
SELECT s0_.id AS id_0, s0_.label AS label_1 FROM speech_type s0_
Parameters:
[]
0.12 ms
(4.24%)
1
SELECT c0_.id AS id_0, c0_.label AS label_1 FROM class_level c0_
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Company 435
App\Entity\User 399
App\Entity\ActivityArea 46
App\Entity\Academy 26
App\Entity\EducationLevel 9
App\Entity\ClassLevel 9
App\Entity\SuperOrganisation 4
App\Entity\SpeechType 2

Entities Mapping

Class Mapping errors
App\Entity\Feedback No errors.
App\Entity\SpeechType No errors.
App\Entity\ActivityArea No errors.
App\Entity\Company No errors.
App\Entity\EducationLevel No errors.
App\Entity\ClassLevel
  • The field App\Entity\ClassLevel#teachers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Teacher#classLevels does not contain the required 'inversedBy="teachers"' attribute.
App\Entity\Speaker No errors.
App\Entity\Pee No errors.
App\Entity\CompanyLocation No errors.
App\Entity\Manager No errors.
App\Entity\Academy No errors.
App\Entity\Corporation No errors.
App\Entity\User No errors.
App\Entity\Teacher No errors.