http://www.virtualrealitycommerce.cz/marketplace/department/9?page=149701

Query Metrics

40 Database Queries
19 Different statements
27.03 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.15 ms
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.http_host = ? OR s0_.http_host = ?
Parameters:
[
  "www.virtualrealitycommerce.cz"
  "www.www.virtualrealitycommerce.cz"
]
2 0.11 ms
SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.label = ?
Parameters:
[
  "virtualrealitycommerce.cz"
]
3 0.09 ms
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_
Parameters:
[]
4 0.09 ms
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_
Parameters:
[]
5 0.08 ms
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_ WHERE l0_.lang_id = ?
Parameters:
[
  4
]
6 0.07 ms
SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_ WHERE c0_.currency_id = ?
Parameters:
[
  4
]
7 0.10 ms
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.department_id = ?
Parameters:
[
  "9"
]
8 0.09 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "9"
  "en_US"
  "App\Entity\Department"
]
9 0.07 ms
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
  9
]
10 0.09 ms
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.lft <= 1 AND d0_.rgt >= 8 AND d0_.root_id = ? ORDER BY d0_.lft ASC
Parameters:
[
  9
]
11 0.06 ms
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
  9
]
12 0.07 ms
SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_
Parameters:
[]
13 0.13 ms
SELECT e0_.eshop_link_id AS eshop_link_id_0, e0_.eshop_link_name AS eshop_link_name_1, e0_.eshop_link_description AS eshop_link_description_2, e0_.eshop_link_url AS eshop_link_url_3, e0_.user_id AS user_id_4, e0_.eshop_link_type AS eshop_link_type_5, e0_.priority AS priority_6, e0_.status AS status_7, e0_.date_inserted AS date_inserted_8, e0_.date_last_control AS date_last_control_9, e0_.logo_url AS logo_url_10, e0_.notes AS notes_11, e0_.admin_user_id AS admin_user_id_12, e0_.eshop_link_email AS eshop_link_email_13, e0_.preferred_language_id AS preferred_language_id_14, e0_.cut_long_description AS cut_long_description_15, e0_.eshop_link_current AS eshop_link_current_16, e0_.viewed_count AS viewed_count_17, e0_.clicked_count AS clicked_count_18 FROM eshop_link e0_ INNER JOIN eshop_link_department e2_ ON e0_.eshop_link_id = e2_.eshop_link_id INNER JOIN department d1_ ON d1_.department_id = e2_.department_id WHERE d1_.department_id = ?
Parameters:
[
  "9"
]
14 0.09 ms
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM eshop_link_translation e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[
  "31"
  "en_US"
  "App\Entity\EshopLink"
]
15 0.08 ms
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id IS NULL ORDER BY d0_.lft ASC
Parameters:
[]
16 0.07 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "1"
  "en_US"
  "App\Entity\Department"
]
17 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "2"
  "en_US"
  "App\Entity\Department"
]
18 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "3"
  "en_US"
  "App\Entity\Department"
]
19 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "4"
  "en_US"
  "App\Entity\Department"
]
20 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "5"
  "en_US"
  "App\Entity\Department"
]
21 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "6"
  "en_US"
  "App\Entity\Department"
]
22 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "7"
  "en_US"
  "App\Entity\Department"
]
23 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "8"
  "en_US"
  "App\Entity\Department"
]
24 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "10"
  "en_US"
  "App\Entity\Department"
]
25 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "11"
  "en_US"
  "App\Entity\Department"
]
26 0.06 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "12"
  "en_US"
  "App\Entity\Department"
]
27 0.09 ms
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
  9
]
28 3.09 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "32"
  "en_US"
  "App\Entity\Department"
]
29 0.07 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "33"
  "en_US"
  "App\Entity\Department"
]
30 0.09 ms
SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = ? AND d0_.locale = ? AND d0_.object_class = ?
Parameters:
[
  "34"
  "en_US"
  "App\Entity\Department"
]
31 0.08 ms
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
  32
]
32 0.08 ms
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
  32
]
33 0.07 ms
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
  33
]
34 0.07 ms
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
  33
]
35 0.06 ms
SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = ?
Parameters:
[
  34
]
36 0.07 ms
SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = ?
Parameters:
[
  34
]
37 21.05 ms
SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ INNER JOIN product_department p2_ ON p0_.product_id = p2_.product_id INNER JOIN department d1_ ON d1_.department_id = p2_.department_id WHERE d1_.department_id IN (?) ORDER BY p0_.priority ASC LIMIT 20 OFFSET 2994000
Parameters:
[
  9
]
38 0.07 ms
SELECT count(p0_.product_id) AS sclr_0 FROM product p0_ INNER JOIN product_department p2_ ON p0_.product_id = p2_.product_id INNER JOIN department d1_ ON d1_.department_id = p2_.department_id WHERE d1_.department_id IN (?)
Parameters:
[
  9
]
39 0.04 ms
SELECT p0_.price_id AS price_id_0, p0_.netto_value AS netto_value_1, p0_.brutto_value AS brutto_value_2, p0_.price_mode AS price_mode_3, p0_.price_level_id AS price_level_id_4, p0_.product_id AS product_id_5 FROM price p0_ WHERE p0_.product_id IN (NULL)
Parameters:
[]
40 0.04 ms
SELECT t0.service_id AS service_id_1, t0.service_name AS service_name_2, t0.action AS action_3, t0.service_type AS service_type_4, t0.is_live AS is_live_5, t0.image AS image_6, t0.importance AS importance_7, t0.trial_months AS trial_months_8, t0.landing_url AS landing_url_9, t0.register_url AS register_url_10, t0.price AS price_11, t0.background_image AS background_image_12 FROM service t0 INNER JOIN server_service ON t0.service_id = server_service.service_id WHERE server_service.server_id = ?
Parameters:
[
  13
]

Database Connections

Name Service
default doctrine.dbal.default_connection
dynamic_conn doctrine.dbal.dynamic_conn_connection
eshop_conn doctrine.dbal.eshop_conn_connection
eshop_demo_conn doctrine.dbal.eshop_demo_conn_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
dynamic_em doctrine.orm.dynamic_em_entity_manager
eshop_em doctrine.orm.eshop_em_entity_manager
eshop_demo_em doctrine.orm.eshop_demo_em_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Server No errors.
App\Entity\Service No errors.
App\Entity\Language No errors.
App\Entity\Currency No errors.
App\Entity\Department No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
App\Entity\DepartmentTranslation No errors.
App\Entity\EshopLink No errors.
App\Entity\EshopLinkTranslation No errors.
App\Entity\Product No errors.
App\Entity\Price No errors.
App\Entity\Module No errors.

dynamic_em entity manager

No loaded entities.

eshop_em entity manager

No loaded entities.

eshop_demo_em entity manager

No loaded entities.