https://pjtqdev.zele.ovh/ton-projet

Query Metrics

9 Database Queries
9 Different statements
5.54 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT b0_.id AS id_0, b0_.label AS label_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.position AS position_4 FROM branch_activity b0_ ORDER BY b0_.position ASC, b0_.label ASC
Parameters:
[]
2 0.53 ms
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.position AS position_4 FROM capacity c0_ ORDER BY c0_.position ASC, c0_.label ASC
Parameters:
[]
3 1.81 ms
SELECT h0_.id AS id_0, h0_.label AS label_1, h0_.created_at AS created_at_2, h0_.updated_at AS updated_at_3 FROM health_exercise_mode h0_ ORDER BY h0_.label ASC
Parameters:
[]
4 0.52 ms
SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.slug AS slug_3, r0_.latitude AS latitude_4, r0_.longitude AS longitude_5, r0_.active AS active_6, r0_.searchable AS searchable_7 FROM region r0_ WHERE r0_.searchable = 1 ORDER BY r0_.name ASC
Parameters:
[]
5 0.37 ms
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.position AS position_4 FROM project_situation_status p0_ ORDER BY p0_.position ASC
Parameters:
[]
6 0.47 ms
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.active AS active_4, p0_.labels AS labels_5 FROM professional_type p0_ WHERE p0_.active = ?
Parameters:
[
  1
]
7 0.46 ms
SELECT h0_.id AS id_0, h0_.created_at AS created_at_1, h0_.updated_at AS updated_at_2, h0_.label AS label_3, h0_.position AS position_4 FROM health_speciality h0_ ORDER BY h0_.position ASC, h0_.label ASC
Parameters:
[]
8 0.40 ms
SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, t0_.position AS position_4 FROM type_research t0_ ORDER BY t0_.position ASC, t0_.label ASC
Parameters:
[]
9 0.36 ms
SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.position AS position_4 FROM project_leader_type p0_ ORDER BY p0_.position ASC, p0_.label ASC
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.

Entities Mapping

Class Mapping errors
App\Entity\ProfessionalType No errors.
App\Entity\BranchActivity No errors.
App\Entity\CompanyProfile No errors.
App\Entity\Capacity No errors.
App\Entity\HealthSpeciality No errors.
App\Entity\HealthExerciseMode No errors.
App\Entity\ProfessionalProfile No errors.
App\Entity\TypeResearch No errors.
App\Entity\Region No errors.
App\Entity\Department No errors.
App\Entity\ProjectSituationStatus No errors.
App\Entity\ProjectLeaderType No errors.
App\Entity\Territory
  • The mappings App\Entity\Territory#criterias and App\Entity\TerritoryCriteria#territory are inconsistent with each other.