https://furbify-staging.lacne-pc.sk/sluzby-furbify

Query Metrics

41 Database Queries
11 Different statements
64.68 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
31.07 ms
(48.03%)
2
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 = ? AND t0.archived = ? AND (t0.domain_id IN (?, ?) OR t0.domain_id IS NULL) LIMIT 1
Parameters:
[
  "sluzby-furbify"
  1
  0
  1
  null
]
11.68 ms
(18.06%)
4
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
]
6.19 ms
(9.57%)
9
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:
[
  "static_id=79"
  1
  1
  0
]
6.00 ms
(9.27%)
17
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
]
5.47 ms
(8.45%)
2
SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC LIMIT 1
Parameters:
[]
1.23 ms
(1.91%)
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.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.domain_id AS domain_id_10 FROM pages_static t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  79
]
1.00 ms
(1.55%)
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.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.static_page_id = ? ORDER BY t0.id ASC
Parameters:
[
  79
]
0.59 ms
(0.91%)
1
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.code = ? LIMIT 1
Parameters:
[
  "sluzby-furbify"
]
0.58 ms
(0.90%)
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.54 ms
(0.83%)
2
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
]
0.33 ms
(0.52%)
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.

Entities Mapping

Class Mapping errors
App\AtechNet\CoreBundle\Entity\AbstractEntity No errors.
App\AtechNet\CoreBundle\Entity\AbstractSortableEntity No errors.
App\AtechNet\CoreBundle\Entity\Language No errors.
App\AtechNet\CoreBundle\Entity\Translation No errors.
App\AtechNet\CoreBundle\Entity\Country No errors.
App\AtechNet\CoreBundle\Entity\SeoUrl No errors.
App\AtechNet\CoreBundle\Entity\Domain No errors.
App\AtechNet\CoreBundle\Entity\Company No errors.
App\AtechNet\CoreBundle\Entity\AbstractSignedEntity No errors.
App\AtechNet\CoreBundle\Entity\User No errors.
App\AtechNet\CoreBundle\Entity\Customer No errors.
App\AtechNet\CoreBundle\Entity\DomainShippingType No errors.
App\AtechNet\CoreBundle\Entity\DomainPaymentType No errors.
App\AtechNet\CoreBundle\Entity\Order No errors.
App\AtechNet\CoreBundle\Entity\DocumentGroup No errors.
App\AtechNet\CoreBundle\Entity\Banner No errors.
App\AtechNet\CoreBundle\Entity\Nanobar No errors.
App\AtechNet\CoreBundle\Entity\AbstractPage No errors.
App\AtechNet\CoreBundle\Entity\StaticPage No errors.
App\AtechNet\CoreBundle\Entity\PageMeta No errors.
App\AtechNet\CoreBundle\Entity\CategoryPage No errors.
App\AtechNet\CoreBundle\Entity\BlogPage No errors.
App\AtechNet\CoreBundle\Entity\Basket No errors.
App\AtechNet\CoreBundle\Entity\CustomerAddress No errors.
App\AtechNet\CoreBundle\Entity\Stock No errors.
App\AtechNet\CoreBundle\Entity\DocumentYear No errors.
App\AtechNet\CoreBundle\Entity\ShipmentNotificationPreference No errors.
App\AtechNet\CoreBundle\Entity\Dashboard No errors.
App\AtechNet\CoreBundle\Entity\UserPermission No errors.
App\AtechNet\CoreBundle\Entity\StockItem No errors.
App\AtechNet\CoreBundle\Entity\UserDepartment No errors.
App\AtechNet\CoreBundle\Entity\UserStockPosition No errors.
App\AtechNet\CoreBundle\Entity\UserPermissionChangeLog No errors.
App\AtechNet\CoreBundle\Entity\CustomerLink No errors.
App\AtechNet\CoreBundle\Entity\CustomerContactPerson No errors.
App\AtechNet\CoreBundle\Entity\CustomerEmail No errors.
App\AtechNet\CoreBundle\Entity\CustomerSentEmail No errors.
App\AtechNet\CoreBundle\Entity\CustomerNotification No errors.
App\AtechNet\CoreBundle\Entity\CustomerData No errors.
App\AtechNet\CoreBundle\Entity\CustomerNote No errors.
App\AtechNet\CoreBundle\Entity\CustomerViewLog No errors.
App\AtechNet\CoreBundle\Entity\ProductCommission No errors.
App\AtechNet\CoreBundle\Entity\StockMovement No errors.
App\AtechNet\CoreBundle\Entity\Document No errors.
App\AtechNet\CoreBundle\Entity\Claim No errors.
App\AtechNet\CoreBundle\Entity\CustomerBillingoData No errors.
App\AtechNet\CoreBundle\Entity\Review No errors.
App\AtechNet\CoreBundle\Entity\CustomerSalesManagerChangelog No errors.
App\AtechNet\CoreBundle\Entity\CustomerPaymentType No errors.
App\AtechNet\CoreBundle\Entity\CustomerClaimProduct No errors.
App\AtechNet\CoreBundle\Entity\OrderItem No errors.
App\AtechNet\CoreBundle\Entity\OrderComment No errors.
App\AtechNet\CoreBundle\Entity\OrderSetting No errors.
App\AtechNet\CoreBundle\Entity\OrderPackage No errors.
App\AtechNet\CoreBundle\Entity\AbstractFile No errors.
App\AtechNet\CoreBundle\Entity\BannerItem No errors.
App\AtechNet\CoreBundle\Entity\DomainNavigation No errors.
App\AtechNet\CoreBundle\Entity\ProductType No errors.
App\AtechNet\CoreBundle\Entity\Product No errors.
App\AtechNet\CoreBundle\Entity\CategoryPageFilterAttribute No errors.
App\AtechNet\CoreBundle\Entity\Vendor No errors.
App\AtechNet\CoreBundle\Entity\CategoryPagesPriorityProducts No errors.
App\AtechNet\CoreBundle\Entity\ProductTag No errors.
App\AtechNet\CoreBundle\Entity\Tag No errors.
App\AtechNet\CoreBundle\Entity\BasketItem No errors.