Query Metrics
3
Database Queries
3
Different statements
6.52 ms
Query time
4
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.86 ms |
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:
[
"/remind/"
]
|
| 2 | 5.18 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.nick_name AS nick_name_3, t0.notes AS notes_4, t0.country_code AS country_code_5, t0.roles AS roles_6, t0.password AS password_7, t0.confirmation_code AS confirmation_code_8, t0.smsc_code AS smsc_code_9, t0.enabled AS enabled_10, t0.trusted AS trusted_11, t0.credits AS credits_12, t0.currency_code AS currency_code_13, t0.full_registered AS full_registered_14, t0.post_registration_step AS post_registration_step_15, t0.created AS created_16, t0.updated AS updated_17, t0.balance_low_notified_at AS balance_low_notified_at_18, t0.ban AS ban_19, t0.city_id AS city_id_20, t22.id AS id_21, t22.path AS path_23, t22.user_id AS user_id_24, t25.account_id AS account_id_26, t0.type FROM user t0 LEFT JOIN user_media_files t22 ON t22.user_id = t0.id LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id WHERE t0.email IS NULL AND t0.type IN ('advertiser', 'customer') LIMIT 1
Parameters:
[] |
| 3 | 0.48 ms |
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"
]
|
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\User | No errors. |
| App\Entity\Account\Avatar | No errors. |
| App\Entity\OfferBarHidden | No errors. |
| App\Entity\Account\Advertiser | No errors. |
| App\Entity\Account\Customer |
|
| App\Entity\Location\County | No errors. |
| App\Entity\Location\District | No errors. |
| App\Entity\Location\Station | No errors. |
multi_website entity manager
No loaded entities.