Query Metrics
4
Database Queries
4
Different statements
10.17 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 7.32 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.alias AS alias_2, s0_.palmes AS palmes_3, s0_.address AS address_4, s0_.logo AS logo_5, s0_.address2 AS address2_6, s0_.address3 AS address3_7, s0_.zipcode AS zipcode_8, s0_.city AS city_9, s0_.codex AS codex_10, s0_.name_international AS name_international_11, s0_.alias_international AS alias_international_12, s0_.created_date AS created_date_13, s0_.updated_date AS updated_date_14, s0_.school_type_id AS school_type_id_15 FROM school s0_ WHERE EXISTS (SELECT 1 FROM school_country s1_ WHERE s1_.school_id = s0_.id AND s1_.country_id IN (?)) ORDER BY s0_.name ASC
Parameters:
[
44
]
|
2 | 1.46 ms |
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.abbreviation AS abbreviation_2 FROM civility c0_ WHERE c0_.id = ? OR c0_.id = ? ORDER BY c0_.label ASC
Parameters:
[ 1 2 ] |
3 | 0.73 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3 FROM phone_code t0
Parameters:
[] |
4 | 0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3 FROM country t0
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
megabase | doctrine.dbal.megabase_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
megabase | doctrine.orm.megabase_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\Entity\School | No errors. |
App\Entity\SchoolType | No errors. |
App\Entity\Country | No errors. |
App\Entity\Program | No errors. |
App\Entity\ContactSchool | No errors. |
App\Entity\Civility | No errors. |
App\Entity\PhoneCode | No errors. |
App\Entity\User | No errors. |
megabase entity manager
No loaded entities.