Query Metrics
7
Database Queries
7
Different statements
5.46 ms
Query time
5
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.21 ms (22.18%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5, t0.district_id AS district_id_6 FROM city_stations t0 WHERE t0.city_id = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
|
0.95 ms (17.42%) |
1 |
SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1
Parameters:
[
"/license/"
]
|
|
0.82 ms (15.02%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5 FROM city_districts t0 WHERE t0.city_id = ?
Parameters:
[
1
]
|
|
0.78 ms (14.27%) |
1 |
SELECT p0_.city_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.person_gender IN (?) AND p0_.moderation_status IN (?, ?, ?)) AND (p0_.deleted_at IS NULL) GROUP BY p0_.city_id
Parameters:
[ 1 0 2 1 ] |
|
0.65 ms (11.93%) |
1 |
SELECT s0_.id AS id_0, s0_.`group` AS group_1, s0_.name AS name_2, s0_.uri_identity AS uri_identity_3 FROM services s0_ ORDER BY s0_.`group` ASC, s0_.id ASC
Parameters:
[] |
|
0.62 ms (11.36%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.country_code AS country_code_3, c0_.city_group AS city_group_4, c0_.timezone AS timezone_5, c0_.map_latitude AS map_latitude_6, c0_.map_longitude AS map_longitude_7 FROM cities c0_ WHERE c0_.uri_identity = ? LIMIT 1
Parameters:
[
"moscow"
]
|
|
0.43 ms (7.84%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.country_code AS country_code_4, t0.city_group AS city_group_5, t0.timezone AS timezone_6, t0.map_latitude AS map_latitude_7, t0.map_longitude AS map_longitude_8 FROM cities t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| multi_website | doctrine.dbal.multi_website_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| multi_website | doctrine.orm.multi_website_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Sales\Profile\AdBoardPlacement | No errors. |
| App\Entity\Sales\PaidPlacementPrice |
|
| App\Entity\SEO\PageMetadata | No errors. |
| App\Entity\Location\MapCoordinate |
|
| App\Entity\Location\City |
|
| App\Entity\Sales\PaidPlacementsOrder | No errors. |
| App\Entity\Location\County | No errors. |
| App\Entity\Location\District | No errors. |
| App\Entity\Location\Station | No errors. |
| App\Entity\Location\Subway\Line | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Profile\PersonParameters | No errors. |
| App\Entity\Messengers |
|
| App\Entity\PhoneCallRestrictions | No errors. |
| App\Entity\Profile\ClientRestrictions | No errors. |
| App\Entity\ApartmentsPricing | No errors. |
| App\Entity\TakeOutPricing | No errors. |
| App\Entity\ExpressPricing | No errors. |
| App\Entity\Profile\CarPricing | No errors. |
| App\Entity\Profile\Profile |
|
multi_website entity manager
No loaded entities.