Query Metrics
6
Database Queries
6
Different statements
8.20 ms
Query time
8
Invalid entities
Queries
site connection
#▲ | Time | Info |
---|---|---|
1 | 2.81 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:
[ "www" "/atest" 1 ] |
2 | 0.43 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:
[
"/atest"
]
|
3 | 2.19 ms |
SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.dob AS dob_24, c0_.batch_codes_count AS batch_codes_count_25, c0_.virtual_wallet_amount AS virtual_wallet_amount_26, c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27, c0_.money_balance AS money_balance_28, c0_.id AS id_29, c0_.city_id AS city_id_30 FROM customer c0_ WHERE c0_.id = ?
Parameters:
[
535179
]
|
4 | 0.72 ms |
SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = ?
Parameters:
[
535179
]
|
5 | 0.73 ms |
SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.dob AS dob_24, c0_.batch_codes_count AS batch_codes_count_25, c0_.virtual_wallet_amount AS virtual_wallet_amount_26, c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27, c0_.money_balance AS money_balance_28, c0_.id AS id_29, c0_.city_id AS city_id_30 FROM customer c0_ WHERE c0_.token = ?
Parameters:
[
"5351795e997e952d0622.51592337"
]
|
6 | 1.32 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.transition_id AS transition_id_3, t0.hidden AS hidden_4, t0.id AS id_5 FROM user_group t0 INNER JOIN user2group ON t0.id = user2group.group_id WHERE user2group.user_id = ?
Parameters:
[
535179
]
|
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\Seo | No errors. |
Slivki\Entity\User |
|
Slivki\Entity\Referral | No errors. |
Slivki\Entity\UserBalanceActivity | No errors. |
Slivki\Entity\SocialAccount | No errors. |
Slivki\Entity\AbstractOrderBase |
|
Slivki\Entity\OfferOrder |
|
Slivki\Entity\OfferOrderDetails | No errors. |
Slivki\Entity\UserPhone | No errors. |
Slivki\Entity\Comment | No errors. |
Slivki\Entity\UserActivity | No errors. |
Slivki\Entity\Visit | No errors. |
Slivki\Entity\UserProperty | No errors. |
Slivki\Entity\Offer |
|
Slivki\Entity\FavouriteCategory | No errors. |
Slivki\Entity\Director |
|
Slivki\Entity\Media\AbstractMediaBase | No errors. |
Slivki\Entity\Media\ProfileImageMedia | No errors. |
Slivki\Entity\Sale |
|
Slivki\Entity\AbstractShareClick |
|
Slivki\Entity\SaleProductBasket | No errors. |
Slivki\Entity\AuthToken | No errors. |
Slivki\Entity\UserAddress | No errors. |
Slivki\Entity\SubscriptionPlanUserRelation | No errors. |
Slivki\Entity\UserGroup | No errors. |
Slivki\Entity\MailingCampaignType | No errors. |
Slivki\Entity\CreditCard | No errors. |
Slivki\Entity\Media | No errors. |
Slivki\Entity\Banner\AbstractBannerBase | 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.