Query Metrics
9
Database Queries
9
Different statements
12.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.95 ms (40.38%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Area2 t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
1.94 ms (15.85%) |
1 |
SELECT t0.id AS id_1, t0.seoTitle AS seoTitle_2, t0.seoDescription AS seoDescription_3, t0.seoKeywords AS seoKeywords_4, t0.name AS name_5, t0.url AS url_6, t0.final AS final_7, t0.price AS price_8, t0.isVisible AS isVisible_9, t0.priceForMeter AS priceForMeter_10, t0.lat AS lat_11, t0.lng AS lng_12, t0.content AS content_13, t0.complex AS complex_14, t0.subway2Id AS subway2Id_15, t0.area2Id AS area2Id_16, t0.addressId AS addressId_17, t0.typeComplexId AS typeComplexId_18, t0.stageComplexId AS stageComplexId_19 FROM ComplexPage t0 WHERE t0.url = ?
Parameters:
[
"clos_17"
]
|
|
1.28 ms (10.46%) |
1 |
SELECT t0.id AS id_1, t0.metaTitle AS metaTitle_2, t0.metaDescription AS metaDescription_3, t0.metaKeywords AS metaKeywords_4, t0.description AS description_5, t0.Header1 AS Header1_6, t0.Text1 AS Text1_7, t0.PromoHeader1 AS PromoHeader1_8, t0.PromoNHeader1 AS PromoNHeader1_9, t0.PromoText1 AS PromoText1_10, t0.PromoComplex1 AS PromoComplex1_11, t0.promoHeader2 AS promoHeader2_12, t0.PromoText2 AS PromoText2_13, t0.Apart AS Apart_14, t0.Parking AS Parking_15, t0.Child AS Child_16, t0.Infra AS Infra_17, t0.Diz AS Diz_18, t0.Complex2 AS Complex2_19, t0.PromoImg1 AS PromoImg1_20, t0.PromoImg2 AS PromoImg2_21, t0.Link1 AS Link1_22, t0.Ico1 AS Ico1_23, t0.Ico2 AS Ico2_24, t0.Ico3 AS Ico3_25, t0.Ico4 AS Ico4_26, t0.Ico5 AS Ico5_27, t0.LastHeader AS LastHeader_28, t0.LastText AS LastText_29, t0.promoType AS promoType_30, t0.complex AS complex_31, t0.settlement AS settlement_32, t0.business AS business_33, t0.country AS country_34, t0.filter AS filter_35 FROM MainPage t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.89 ms (7.23%) |
1 |
SELECT t0.id AS id_1, t0.willDelete AS willDelete_2, t0.name AS name_3, t0.spaceFrom AS spaceFrom_4, t0.spaceTo AS spaceTo_5, t0.priceFrom AS priceFrom_6, t0.priceTo AS priceTo_7, t0.complex AS complex_8 FROM ComplexOrders t0 WHERE t0.complex = ?
Parameters:
[
103
]
|
|
0.78 ms (6.38%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.isMain AS isMain_3, t0.deleteIt AS deleteIt_4, t0.complex AS complex_5 FROM ComplexPhoto t0 WHERE t0.complex = ? ORDER BY t0.isMain DESC
Parameters:
[
103
]
|
|
0.74 ms (6.03%) |
1 |
SELECT t0.id AS id_1, t0.address AS address_2, t0.home AS home_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.streetId AS streetId_6 FROM Address t0 WHERE t0.id = ?
Parameters:
[
2117
]
|
|
0.62 ms (5.07%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM TypeComplex t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.56 ms (4.60%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM StageComplex t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.49 ms (4.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM Street t0 WHERE t0.id = ?
Parameters:
[
1619
]
|
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 |
|---|---|
| Troika\MainBundle\Entity\ComplexPage | No errors. |
| Troika\MainBundle\Entity\Complex | No errors. |
| Troika\MainBundle\Entity\Subway2 | No errors. |
| Troika\MainBundle\Entity\Area2 | No errors. |
| Troika\MainBundle\Entity\Address | No errors. |
| Troika\MainBundle\Entity\TypeComplex | No errors. |
| Troika\MainBundle\Entity\StageComplex | No errors. |
| Troika\MainBundle\Entity\ComplexPhoto | No errors. |
| Troika\MainBundle\Entity\ComplexOrders | No errors. |
| Troika\MainBundle\Entity\MainPage | No errors. |
| Troika\MainBundle\Entity\Settlement | No errors. |
| Troika\MainBundle\Entity\BusinessCenter | No errors. |
| Troika\MainBundle\Entity\Country | No errors. |
| Troika\MainBundle\Entity\FilterPreset | No errors. |
| Troika\MainBundle\Entity\Street | No errors. |