Query Metrics
3
Database Queries
3
Different statements
17.44 ms
Query time
1
Invalid entities
Queries
site connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 15.18 ms |
SELECT c0_.name AS name_0, c0_.domain AS domain_1, c0_.name_genitive AS name_genitive_2, c0_.name_locative AS name_locative_3, c0_.active AS active_4, c0_.position AS position_5, c0_.google_analytics AS google_analytics_6, ST_AsEWKT(c0_.point::geometry) AS point_7, c0_.id AS id_8, c0_.parent_id AS parent_id_9 FROM city c0_ WHERE c0_.active = ? AND c0_.domain = ? LIMIT 1
Parameters:
[ 1 "stolbcy" ] |
| 2 | 1.74 ms |
SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = ? AND t0.main_alias = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "stolbcy" "/skidki-i-rasprodazhi/restorany-minsk-skidka-dodopizza" 1 ] |
| 3 | 0.52 ms |
SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = ? ORDER BY t0.id DESC
Parameters:
[
"/skidki-i-rasprodazhi/restorany-minsk-skidka-dodopizza"
]
|
admin connection
No database queries were performed.
subscription connection
No database queries were performed.
default connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| site | doctrine.dbal.site_connection |
| admin | doctrine.dbal.admin_connection |
| subscription | doctrine.dbal.subscription_connection |
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| admin | doctrine.orm.admin_entity_manager |
| subscription | doctrine.orm.subscription_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| Slivki\Entity\City | No errors. |
| Slivki\Entity\PartnerMailingCampaignAction | No errors. |
| Slivki\Entity\AbstractCategoryBase | No errors. |
| Slivki\Entity\CityArea | No errors. |
| Slivki\Entity\TopSale | No errors. |
| Slivki\Entity\Mall | No errors. |
| Slivki\Entity\Banner\AbstractBannerBase | No errors. |
| Slivki\Entity\BrandingBanner | No errors. |
| Slivki\Entity\Seo | No errors. |
| Slivki\Entity\Media\AbstractMediaBase | No errors. |
| Slivki\Entity\Media | No errors. |
| Slivki\Entity\Banner\AbstractMobileAppBanner |
|
| Slivki\Entity\Banner | No errors. |
| Slivki\Entity\ServerFeatureState | No errors. |
admin entity manager
No loaded entities.
subscription entity manager
No loaded entities.