Query Metrics
173
Database Queries
20
Different statements
206.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
46.17 ms (22.37%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? LIMIT 1
Parameters:
[ "category_id=261" 1 ] |
|
43.24 ms (20.95%) |
32 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? AND t0.archived = ? LIMIT 1
Parameters:
[ "blog_id=64" 1 1 0 ] |
|
28.81 ms (13.96%) |
60 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
28.17 ms (13.65%) |
7 |
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = ?
Parameters:
[
1
]
|
|
15.25 ms (7.39%) |
16 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.title AS title_5, t0.link AS link_6, t0.content AS content_7, t0.short_desc AS short_desc_8, t0.seo_title AS seo_title_9, t0.seo_desc AS seo_desc_10, t0.extra_seo_desc AS extra_seo_desc_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.language_id AS language_id_14, t0.category_page_id AS category_page_id_15, t0.blog_category_id AS blog_category_id_16, t0.static_page_id AS static_page_id_17 FROM pages_meta t0 WHERE t0.blog_category_id = ? ORDER BY t0.id ASC
Parameters:
[
64
]
|
|
14.98 ms (7.26%) |
15 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = ? AND t0.language_id = ? AND t0.domain_id = ? LIMIT 1
Parameters:
[ "category_id=3" 1 1 ] |
|
13.10 ms (6.35%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = ? AND t0.language_id = ? LIMIT 1
Parameters:
[ "najlepsie-notebooky-od-furbify-aprilova-top-3" 1 ] |
|
5.38 ms (2.61%) |
15 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.cover_image AS cover_image_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.domain_id AS domain_id_11, t0.category_page_id AS category_page_id_12 FROM pages_blog t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
3.87 ms (1.88%) |
6 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
1.46 ms (0.71%) |
5 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.title AS title_5, t0.link AS link_6, t0.content AS content_7, t0.short_desc AS short_desc_8, t0.seo_title AS seo_title_9, t0.seo_desc AS seo_desc_10, t0.extra_seo_desc AS extra_seo_desc_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.language_id AS language_id_14, t0.category_page_id AS category_page_id_15, t0.blog_category_id AS blog_category_id_16, t0.static_page_id AS static_page_id_17 FROM pages_meta t0 WHERE t0.category_page_id = ? ORDER BY t0.id ASC
Parameters:
[
3
]
|
|
1.15 ms (0.56%) |
5 |
SELECT COUNT(*) FROM pages_blog t0 WHERE t0.category_page_id = ?
Parameters:
[
3
]
|
|
0.99 ms (0.48%) |
2 |
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[] |
|
0.97 ms (0.47%) |
1 |
SELECT t.name, t.slug, COUNT(DISTINCT bp.blog_page_id ) AS total FROM pages_blog_tags AS bp JOIN tag AS t ON t.id = bp.tag_id WHERE t.language_id = ? GROUP BY t.name
Parameters:
[
1
]
|
|
0.62 ms (0.30%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.type AS type_8, t0.badges AS badges_9, t0.show_only_discounted AS show_only_discounted_10, t0.show_only_flash_sales AS show_only_flash_sales_11, t0.show_only_bazaar AS show_only_bazaar_12, t0.include_bazaar AS include_bazaar_13, t0.show_popular_products AS show_popular_products_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.domain_id AS domain_id_17, t0.parent_category_id AS parent_category_id_18 FROM pages_category t0 WHERE t0.domain_id = ? AND t0.published = ? AND t0.type = ?
Parameters:
[ 1 1 2 ] |
|
0.50 ms (0.24%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.username AS username_5, t0.password AS password_6, t0.salt AS salt_7, t0.email AS email_8, t0.roles AS roles_9, t0.is_active AS is_active_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.nick_name AS nick_name_13, t0.locale AS locale_14, t0.work_since AS work_since_15, t0.work_until AS work_until_16, t0.birthday AS birthday_17, t0.allowedDaysOff AS allowedDaysOff_18, t0.phone AS phone_19, t0.sales_manager AS sales_manager_20, t0.permissions AS permissions_21, t0.birthday_visibility AS birthday_visibility_22, t0.avatar AS avatar_23, t0.fingera_id AS fingera_id_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26, t27.id AS id_28, t27.created AS created_29, t27.updated AS updated_30, t27.updated_by_time AS updated_by_time_31, t27.created_by AS created_by_32, t27.updated_by AS updated_by_33, t27.user_id AS user_id_34, t27.stock_position_id AS stock_position_id_35 FROM users t0 LEFT JOIN users_stock_position t27 ON t27.user_id = t0.id WHERE t0.id = ?
Parameters:
[
15
]
|
|
0.45 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.name AS name_4, t0.slug AS slug_5, t0.language_id AS language_id_6 FROM tag t0 INNER JOIN pages_blog_tags ON t0.id = pages_blog_tags.tag_id WHERE pages_blog_tags.blog_page_id = ?
Parameters:
[
64
]
|
|
0.36 ms (0.17%) |
1 |
SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.updated_by_time AS updated_by_time_3, d0_.type AS type_4, d0_.price AS price_5, d0_.free_ship_limit AS free_ship_limit_6, d0_.active_on_web AS active_on_web_7, d0_.sort_index AS sort_index_8, d0_.shipping_days AS shipping_days_9, d0_.free_shipping_product_types AS free_shipping_product_types_10, d0_.free_shipping_start_date AS free_shipping_start_date_11, d0_.free_shipping_end_date AS free_shipping_end_date_12, d0_.created_by AS created_by_13, d0_.updated_by AS updated_by_14, d0_.domain_id AS domain_id_15 FROM domain_shipping_types d0_ WHERE d0_.domain_id = ? AND d0_.active_on_web = 1 AND d0_.price > 0
Parameters:
[
1
]
|
|
0.35 ms (0.17%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.cover_image AS cover_image_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.domain_id AS domain_id_11, t0.category_page_id AS category_page_id_12 FROM pages_blog t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"64"
]
|
|
0.31 ms (0.15%) |
1 |
SELECT b0_.id AS id_0, b0_.created AS created_1, b0_.updated AS updated_2, b0_.sort_index AS sort_index_3, b0_.language_id AS language_id_4, b0_.blog_page_id AS blog_page_id_5 FROM blog_item_featured b0_ WHERE b0_.language_id = ? ORDER BY b0_.sort_index ASC
Parameters:
[
1
]
|
|
0.28 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.payment_method AS payment_method_4, t0.shipping_method AS shipping_method_5, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_6, t0.message AS message_7, t0.coupon_code AS coupon_code_8, t0.active AS active_9, t0.abandoned_cart_email AS abandoned_cart_email_10, t0.domain_id AS domain_id_11, t0.customer_id AS customer_id_12, t0.billing_address_id AS billing_address_id_13, t0.shipping_address_id AS shipping_address_id_14 FROM baskets t0 WHERE t0.id IS NULL AND t0.active = ? LIMIT 1
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.