Query Metrics
12
Database Queries
8
Different statements
17.30 ms
Query time
4
Invalid entities
Queries
site connection
#▲ | Time | Info |
---|---|---|
1 | 2.90 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" "/landing" 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:
[
"/landing"
]
|
3 | 0.74 ms |
SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_
Parameters:
[] |
4 | 0.91 ms |
SELECT t0.sort_order AS sort_order_1, t0.id AS id_2, t0.category_id AS category_id_3 FROM popular_category t0 ORDER BY t0.sort_order ASC LIMIT 3
Parameters:
[] |
5 | 1.89 ms |
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.type_id AS type_id_8, t0.domain_object_id AS domain_object_id_9, t0.past AS past_10, t0.code AS code_11, t0.top_count AS top_count_12, t0.description AS description_13, t0.mobile_api_hash AS mobile_api_hash_14, t0.entity_count AS entity_count_15, t0.last_modified AS last_modified_16, t0.in_menu_bottom AS in_menu_bottom_17, t0.hot_feed_name AS hot_feed_name_18, t0.unpopular AS unpopular_19, t0.featured_in_menu AS featured_in_menu_20, t0.position AS position_21, t0.telegram_bot_show AS telegram_bot_show_22, t0.telegram_bot_name AS telegram_bot_name_23, t0.telegram_bot_position AS telegram_bot_position_24, t0.split_offers_with_same_categories AS split_offers_with_same_categories_25, t0.utm_campaign AS utm_campaign_26, t0.me_on_map_active AS me_on_map_active_27, t0.me_on_map_position AS me_on_map_position_28, t0.me_on_map_featured_active AS me_on_map_featured_active_29, t0.me_on_map_featured_position AS me_on_map_featured_position_30, t0.show_items_catalog AS show_items_catalog_31, t0.active_in_best_offers_category AS active_in_best_offers_category_32, t0.hide_work_examples AS hide_work_examples_33, t0.is_bonus_code AS is_bonus_code_34, t0.city_id AS city_id_35, t0.type_id AS type_id_36, t0.type FROM category t0 WHERE t0.id = ? AND t0.type IN ('0')
Parameters:
[
3894
]
|
6 | 1.63 ms |
SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = ? AND t0.type_id = ? AND t0.type IN ('0') ORDER BY t0.sort_order ASC
Parameters:
[ 3894 18235 ] |
7 | 1.28 ms |
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.city_id AS city_id_8, t0.type, t0.type_id AS type_id_9, t0.domain_object_id AS domain_object_id_10, t0.past AS past_11, t0.code AS code_12, t0.top_count AS top_count_13, t0.description AS description_14, t0.mobile_api_hash AS mobile_api_hash_15, t0.entity_count AS entity_count_16, t0.last_modified AS last_modified_17, t0.in_menu_bottom AS in_menu_bottom_18, t0.hot_feed_name AS hot_feed_name_19, t0.unpopular AS unpopular_20, t0.featured_in_menu AS featured_in_menu_21, t0.position AS position_22, t0.telegram_bot_show AS telegram_bot_show_23, t0.telegram_bot_name AS telegram_bot_name_24, t0.telegram_bot_position AS telegram_bot_position_25, t0.split_offers_with_same_categories AS split_offers_with_same_categories_26, t0.utm_campaign AS utm_campaign_27, t0.me_on_map_active AS me_on_map_active_28, t0.me_on_map_position AS me_on_map_position_29, t0.me_on_map_featured_active AS me_on_map_featured_active_30, t0.me_on_map_featured_position AS me_on_map_featured_position_31, t0.show_items_catalog AS show_items_catalog_32, t0.active_in_best_offers_category AS active_in_best_offers_category_33, t0.hide_work_examples AS hide_work_examples_34, t0.is_bonus_code AS is_bonus_code_35, t0.type_id AS type_id_36 FROM category t0 INNER JOIN category_child_relation ON t0.id = category_child_relation.parent_id WHERE category_child_relation.child_id = ? AND t0.type IN ('0', '1', '3', '4', '5', '6')
Parameters:
[
3894
]
|
8 | 0.69 ms |
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.type_id AS type_id_8, t0.domain_object_id AS domain_object_id_9, t0.past AS past_10, t0.code AS code_11, t0.top_count AS top_count_12, t0.description AS description_13, t0.mobile_api_hash AS mobile_api_hash_14, t0.entity_count AS entity_count_15, t0.last_modified AS last_modified_16, t0.in_menu_bottom AS in_menu_bottom_17, t0.hot_feed_name AS hot_feed_name_18, t0.unpopular AS unpopular_19, t0.featured_in_menu AS featured_in_menu_20, t0.position AS position_21, t0.telegram_bot_show AS telegram_bot_show_22, t0.telegram_bot_name AS telegram_bot_name_23, t0.telegram_bot_position AS telegram_bot_position_24, t0.split_offers_with_same_categories AS split_offers_with_same_categories_25, t0.utm_campaign AS utm_campaign_26, t0.me_on_map_active AS me_on_map_active_27, t0.me_on_map_position AS me_on_map_position_28, t0.me_on_map_featured_active AS me_on_map_featured_active_29, t0.me_on_map_featured_position AS me_on_map_featured_position_30, t0.show_items_catalog AS show_items_catalog_31, t0.active_in_best_offers_category AS active_in_best_offers_category_32, t0.hide_work_examples AS hide_work_examples_33, t0.is_bonus_code AS is_bonus_code_34, t0.city_id AS city_id_35, t0.type_id AS type_id_36, t0.type FROM category t0 WHERE t0.id = ? AND t0.type IN ('0')
Parameters:
[
476
]
|
9 | 0.46 ms |
SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = ? AND t0.type_id = ? AND t0.type IN ('0') ORDER BY t0.sort_order ASC
Parameters:
[ 476 18235 ] |
10 | 0.75 ms |
SELECT t0.name AS name_1, t0.h1 AS h1_2, t0.active AS active_3, t0.sort_order AS sort_order_4, t0.api_sort_order AS api_sort_order_5, t0.map_pin_color AS map_pin_color_6, t0.id AS id_7, t0.type_id AS type_id_8, t0.domain_object_id AS domain_object_id_9, t0.past AS past_10, t0.code AS code_11, t0.top_count AS top_count_12, t0.description AS description_13, t0.mobile_api_hash AS mobile_api_hash_14, t0.entity_count AS entity_count_15, t0.last_modified AS last_modified_16, t0.in_menu_bottom AS in_menu_bottom_17, t0.hot_feed_name AS hot_feed_name_18, t0.unpopular AS unpopular_19, t0.featured_in_menu AS featured_in_menu_20, t0.position AS position_21, t0.telegram_bot_show AS telegram_bot_show_22, t0.telegram_bot_name AS telegram_bot_name_23, t0.telegram_bot_position AS telegram_bot_position_24, t0.split_offers_with_same_categories AS split_offers_with_same_categories_25, t0.utm_campaign AS utm_campaign_26, t0.me_on_map_active AS me_on_map_active_27, t0.me_on_map_position AS me_on_map_position_28, t0.me_on_map_featured_active AS me_on_map_featured_active_29, t0.me_on_map_featured_position AS me_on_map_featured_position_30, t0.show_items_catalog AS show_items_catalog_31, t0.active_in_best_offers_category AS active_in_best_offers_category_32, t0.hide_work_examples AS hide_work_examples_33, t0.is_bonus_code AS is_bonus_code_34, t0.city_id AS city_id_35, t0.type_id AS type_id_36, t0.type FROM category t0 WHERE t0.id = ? AND t0.type IN ('0')
Parameters:
[
212
]
|
11 | 0.56 ms |
SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.tags AS tags_10, t0.id AS id_11, t0.type_id AS type_id_12, t0.entity_id AS entity_id_13, t0.type_id AS type_id_14, t0.type FROM media t0 WHERE t0.entity_id = ? AND t0.type_id = ? AND t0.type IN ('0') ORDER BY t0.sort_order ASC
Parameters:
[ 212 18235 ] |
12 | 5.06 ms |
SELECT t0.type_id AS type_id_1, t0.title AS title_2, t0.url AS url_3, t0.file_path AS file_path_4, t0.active AS active_5, t0.file_path_mobile AS file_path_mobile_6, t0.substitute_path AS substitute_path_7, t0.javascript AS javascript_8, t0.json AS json_9, t0.code AS code_10, t0.code_file_path AS code_file_path_11, t0.position AS position_12, t0.pixel_code AS pixel_code_13, t0.pixel_code_mobile AS pixel_code_mobile_14, t0.id AS id_15, t0.type FROM banner t0 WHERE t0.active = ? AND t0.type IN ('9') ORDER BY t0.position ASC
Parameters:
[
1
]
|
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\ServerFeatureState | No errors. |
Slivki\Entity\AbstractCategoryBase | No errors. |
Slivki\Entity\Category |
|
Slivki\Entity\PopularCategory | No errors. |
Slivki\Entity\Media\AbstractMediaBase | No errors. |
Slivki\Entity\Media | No errors. |
Slivki\Entity\CategoryType | No errors. |
Slivki\Entity\Media\CategoryMobileMenuIconMedia | No errors. |
Slivki\Entity\Media\CategoryAppIconMedia | No errors. |
Slivki\Entity\Media\CategoryMapPinIconMedia | No errors. |
Slivki\Entity\Banner\AbstractBannerBase | No errors. |
Slivki\Entity\Banner | No errors. |
Slivki\Entity\BrandingBanner | No errors. |
Slivki\Entity\Sale |
|
Slivki\Entity\MediaType | No errors. |
Slivki\Entity\ProductCategory | No errors. |
Slivki\Entity\OfferExtensionCategory | No errors. |
Slivki\Entity\GiftCertificateCategory | No errors. |
Slivki\Entity\GiftCertificateGiftCategory | No errors. |
Slivki\Entity\OfferExtensionOnlineCategory | No errors. |
Slivki\Entity\MediaSize | No errors. |
Slivki\Entity\Banner\MobileLandingBanner | No errors. |
Slivki\Entity\Banner\AbstractMobileAppBanner |
|
Slivki\Entity\Offer |
|
admin entity manager
No loaded entities.
subscription entity manager
No loaded entities.