Query Metrics
7
Database Queries
7
Different statements
3.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.68 ms (18.51%) |
1 |
SELECT t0.id AS id_3, t0.auxiliaryCode AS auxiliaryCode_4, t0.note AS note_5, t0.currency AS currency_6, t0.isDefault AS isDefault_7, t0.active AS active_8, t0.showAllHotelXml AS showAllHotelXml_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.name AS name_12, t0.address AS address_13, t0.postalCode AS postalCode_14, t0.phone AS phone_15, t0.email AS email_16, t0.fax AS fax_17, t0.identityDocument AS identityDocument_18, t0.identityNumber AS identityNumber_19, t0.market_id AS market_id_20, t0.city_id AS city_id_21, t0.parent_id AS parent_id_22, t0.logo_id AS logo_id_23, t0.dtype, t1.exemptTax AS exemptTax_24, t1.exemptStamp AS exemptStamp_25, t1.authorizedCreditAmount AS authorizedCreditAmount_26, t1.preferred AS preferred_27, t1.corporateStrategy AS corporateStrategy_28, t1.resellerMargin AS resellerMargin_29, t1.logoVisibility AS logoVisibility_30, t1.foundationDate AS foundationDate_31, t2.civility AS civility_32, t2.firstName AS firstName_33, t2.lastName AS lastName_34, t2.birthdate AS birthdate_35 FROM Customer t0 LEFT JOIN CustomerMoral t1 ON t0.id = t1.id LEFT JOIN CustomerPhysical t2 ON t0.id = t2.id WHERE t0.isDefault = ? AND t0.active = ?
Parameters:
[ 1 1 ] |
|
0.64 ms (17.60%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.active AS active_5, t0.currency AS currency_6, t0.isDefault AS isDefault_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.city_id AS city_id_10 FROM Agency t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.57 ms (15.47%) |
1 |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "3" "fr" "App\Entity\FrontPage" ] |
|
0.50 ms (13.69%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.active AS active_6, t0.editable AS editable_7, t0.seoTitle AS seoTitle_8, t0.seoDescription AS seoDescription_9 FROM FrontPage t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"a_propos"
]
|
|
0.44 ms (11.94%) |
1 |
SELECT t0.path AS path_1, t0.value AS value_2 FROM Parameter t0
Parameters:
[] |
|
0.42 ms (11.47%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.icon AS icon_4, t0.active AS active_5, t0.clicksCount AS clicksCount_6, t0.pageId AS pageId_7 FROM SocialNetwork t0 WHERE t0.active = ?
Parameters:
[
"true"
]
|
|
0.41 ms (11.33%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.active AS active_5, t0.currency AS currency_6, t0.isDefault AS isDefault_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.city_id AS city_id_10 FROM Agency t0 WHERE t0.isDefault = ?
Parameters:
[
0
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| history | doctrine.orm.history_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Agency | No errors. |
| App\Entity\City | No errors. |
| App\Entity\Personal | No errors. |
| App\Entity\FrontPage | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| App\Entity\Parameter | No errors. |
| App\Entity\SocialNetwork | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\CustomerMoral | No errors. |
| App\Entity\CustomerPhysical | No errors. |
| App\Entity\Market | No errors. |
| App\Entity\FileData | No errors. |
| App\Entity\CustomerInfoType | No errors. |
| App\Entity\CustomerAirlineXmlApi | No errors. |
history entity manager
No loaded entities.