Query Metrics
9
Database Queries
9
Different statements
4.35 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.85 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.61 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 | 0.39 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.59 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.40 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.44 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.43 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.31 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.33 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 |
|