Query Metrics
5
Database Queries
5
Different statements
3.02 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.62 ms |
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
]
|
| 2 | 0.52 ms |
SELECT t0.path AS path_1, t0.value AS value_2 FROM Parameter t0
Parameters:
[] |
| 3 | 0.49 ms |
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"
]
|
| 4 | 0.77 ms |
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
]
|
| 5 | 0.62 ms |
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 ] |
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\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.