https://viglager.optima.rs/sr/product/index?page=3

Query Metrics

56 Database Queries
18 Different statements
3359.28 ms Query time
1 Invalid entities
3 Cache hits
2 Cache misses
14 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 88.85 ms
SELECT c0_.code AS code_0, c0_.name AS name_1, c0_.rate AS rate_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.synced_at AS synced_at_5, c0_.index_at AS index_at_6 FROM currency c0_ WHERE c0_.code = ?
Parameters:
[
  "RSD"
]
2 425.95 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN depot_product d1_ ON p0_.id = d1_.product WHERE p0_.disabled IS NULL AND d1_.quantity > 0
Parameters:
[]
3 132.81 ms
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN depot_product d1_ ON p0_.id = d1_.product WHERE p0_.disabled IS NULL AND d1_.quantity > 0 ORDER BY p0_.id ASC OFFSET 12 ROWS FETCH NEXT 6 ROWS ONLY
Parameters:
[]
4 58.93 ms
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.barcode AS barcode_2, p0_.title AS title_3, p0_.original_title AS original_title_4, p0_.search_title AS search_title_5, p0_.slug AS slug_6, p0_.origin AS origin_7, p0_.link AS link_8, p0_.inner_diameter_min AS inner_diameter_min_9, p0_.inner_diameter_max AS inner_diameter_max_10, p0_.outer_diameter_min AS outer_diameter_min_11, p0_.outer_diameter_max AS outer_diameter_max_12, p0_.width_min AS width_min_13, p0_.width_max AS width_max_14, p0_.weight AS weight_15, p0_.gross_price AS gross_price_16, p0_.minimal_quantity AS minimal_quantity_17, p0_.disabled AS disabled_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.synced_at AS synced_at_21, p0_.index_at AS index_at_22, p0_.remote_id AS remote_id_23, p0_.category AS category_24, p0_.sub_category AS sub_category_25, p0_.product_group AS product_group_26, p0_.manufacturer AS manufacturer_27, p0_.unit_of_measurement AS unit_of_measurement_28 FROM product p0_ LEFT JOIN depot_product d1_ ON p0_.id = d1_.product WHERE p0_.disabled IS NULL AND d1_.quantity > 0 AND p0_.id IN (?) ORDER BY p0_.id ASC
Parameters:
[
  [
    16
    18
    20
    21
    22
    23
  ]
]
5 55.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.file_name AS file_name_3, t0.tries AS tries_4, t0.error AS error_5, t0.original AS original_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.synced_at AS synced_at_9, t0.index_at AS index_at_10, t0.product AS product_11 FROM product_photo t0 WHERE t0.product IN (?)
Parameters:
[
  [
    16
    18
    20
    21
    22
    23
  ]
]
6 51.30 ms
SELECT t0.id AS id_1, t0.page AS page_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.document AS document_7, t0.product AS product_8 FROM product_document t0 WHERE t0.product IN (?)
Parameters:
[
  [
    16
    18
    20
    21
    22
    23
  ]
]
7 46.10 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  9
]
8 45.86 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  10
]
9 45.86 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  11
]
10 45.49 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  12
]
11 45.97 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  13
]
12 45.75 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  30
]
13 45.92 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  14
]
14 47.23 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product_manufacturer p0_
Parameters:
[]
15 51.56 ms
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product_manufacturer p0_ ORDER BY p0_.id ASC OFFSET 0 ROWS FETCH NEXT 8 ROWS ONLY
Parameters:
[]
16 49.28 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sorting_priority AS sorting_priority_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.synced_at AS synced_at_5, p0_.index_at AS index_at_6, p0_.remote_id AS remote_id_7 FROM product_manufacturer p0_ WHERE p0_.id IN (?) ORDER BY p0_.id ASC
Parameters:
[
  [
    1
    2
    3
    4
    5
    6
    7
    8
  ]
]
17 72.52 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product_category p0_ INNER JOIN product_category_translation p1_ ON p0_.id = p1_.translatable_id
Parameters:
[]
18 46.06 ms
SELECT DISTINCT p0_.id AS id_0 FROM product_category p0_ INNER JOIN product_category_translation p1_ ON p0_.id = p1_.translatable_id ORDER BY 1 OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
Parameters:
[]
19 46.10 ms
SELECT p0_.id AS id_0, p0_.remote_id AS remote_id_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.synced_at AS synced_at_4, p0_.index_at AS index_at_5 FROM product_category p0_ INNER JOIN product_category_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.id IN (?)
Parameters:
[
  [
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
  ]
]
20 45.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
21 46.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
22 46.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
23 46.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
24 45.90 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
25 45.97 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
26 46.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
27 46.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
28 45.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
29 45.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM product_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
30 81.15 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.quantity AS quantity_3, t0.minimal_quantity AS minimal_quantity_4, t0.optimal_quantity AS optimal_quantity_5, t0.price AS price_6, t0.tax_rate AS tax_rate_7, t0.location AS location_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.synced_at AS synced_at_11, t0.index_at AS index_at_12, t0.product AS product_13, t0.depot AS depot_14 FROM depot_product t0 WHERE t0.product = ?
Parameters:
[
  16
]
31 51.70 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = ? ORDER BY t0.title ASC
Parameters:
[
  16
]
32 44.61 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6 FROM product_info t0 INNER JOIN product_product_info ON t0.id = product_product_info.product_info WHERE product_product_info.product = ?
Parameters:
[
  16
]
33 49.90 ms
SELECT t0.id AS id_1, t0.info AS info_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM depot_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
34 75.45 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.quantity AS quantity_3, t0.minimal_quantity AS minimal_quantity_4, t0.optimal_quantity AS optimal_quantity_5, t0.price AS price_6, t0.tax_rate AS tax_rate_7, t0.location AS location_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.synced_at AS synced_at_11, t0.index_at AS index_at_12, t0.product AS product_13, t0.depot AS depot_14 FROM depot_product t0 WHERE t0.product = ?
Parameters:
[
  18
]
35 57.25 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = ? ORDER BY t0.title ASC
Parameters:
[
  18
]
36 45.81 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6 FROM product_info t0 INNER JOIN product_product_info ON t0.id = product_product_info.product_info WHERE product_product_info.product = ?
Parameters:
[
  18
]
37 74.13 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.quantity AS quantity_3, t0.minimal_quantity AS minimal_quantity_4, t0.optimal_quantity AS optimal_quantity_5, t0.price AS price_6, t0.tax_rate AS tax_rate_7, t0.location AS location_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.synced_at AS synced_at_11, t0.index_at AS index_at_12, t0.product AS product_13, t0.depot AS depot_14 FROM depot_product t0 WHERE t0.product = ?
Parameters:
[
  20
]
38 53.89 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = ? ORDER BY t0.title ASC
Parameters:
[
  20
]
39 45.66 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6 FROM product_info t0 INNER JOIN product_product_info ON t0.id = product_product_info.product_info WHERE product_product_info.product = ?
Parameters:
[
  20
]
40 70.65 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.quantity AS quantity_3, t0.minimal_quantity AS minimal_quantity_4, t0.optimal_quantity AS optimal_quantity_5, t0.price AS price_6, t0.tax_rate AS tax_rate_7, t0.location AS location_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.synced_at AS synced_at_11, t0.index_at AS index_at_12, t0.product AS product_13, t0.depot AS depot_14 FROM depot_product t0 WHERE t0.product = ?
Parameters:
[
  21
]
41 45.92 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = ? ORDER BY t0.title ASC
Parameters:
[
  21
]
42 45.76 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6 FROM product_info t0 INNER JOIN product_product_info ON t0.id = product_product_info.product_info WHERE product_product_info.product = ?
Parameters:
[
  21
]
43 65.12 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.quantity AS quantity_3, t0.minimal_quantity AS minimal_quantity_4, t0.optimal_quantity AS optimal_quantity_5, t0.price AS price_6, t0.tax_rate AS tax_rate_7, t0.location AS location_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.synced_at AS synced_at_11, t0.index_at AS index_at_12, t0.product AS product_13, t0.depot AS depot_14 FROM depot_product t0 WHERE t0.product = ?
Parameters:
[
  22
]
44 55.30 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = ? ORDER BY t0.title ASC
Parameters:
[
  22
]
45 45.58 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6 FROM product_info t0 INNER JOIN product_product_info ON t0.id = product_product_info.product_info WHERE product_product_info.product = ?
Parameters:
[
  22
]
46 76.94 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.quantity AS quantity_3, t0.minimal_quantity AS minimal_quantity_4, t0.optimal_quantity AS optimal_quantity_5, t0.price AS price_6, t0.tax_rate AS tax_rate_7, t0.location AS location_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.synced_at AS synced_at_11, t0.index_at AS index_at_12, t0.product AS product_13, t0.depot AS depot_14 FROM depot_product t0 WHERE t0.product = ?
Parameters:
[
  23
]
47 52.09 ms
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.title AS title_3, t0.search_title AS search_title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.synced_at AS synced_at_7, t0.index_at AS index_at_8, t0.product AS product_9 FROM product_alternative t0 WHERE t0.product = ? ORDER BY t0.title ASC
Parameters:
[
  23
]
48 45.23 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6 FROM product_info t0 INNER JOIN product_product_info ON t0.id = product_product_info.product_info WHERE product_product_info.product = ?
Parameters:
[
  23
]
49 45.85 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  35
]
50 45.94 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  36
]
51 45.94 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  37
]
52 45.97 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  38
]
53 47.98 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  39
]
54 45.82 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  40
]
55 45.98 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  41
]
56 46.63 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  42
]

client_rel_management connection

No database queries were performed.

client_rel_web_management connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
client_rel_management doctrine.dbal.client_rel_management_connection
client_rel_web_management doctrine.dbal.client_rel_web_management_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
client_rel_management doctrine.orm.client_rel_management_entity_manager
client_rel_web_management doctrine.orm.client_rel_web_management_entity_manager

Second Level Cache

3 Hits
2 Misses
14 Puts

Number of cache hits

Region Hits
public 3

Number of cache misses

Region Misses
public 2

Number of cache puts

Region Puts
public 14

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\ECommerce\Currency No errors.
App\Entity\ECommerce\Depot No errors.
App\Entity\ECommerce\Client No errors.
App\Entity\ECommerce\Shipping No errors.
App\Entity\ECommerce\Product No errors.
App\Entity\ECommerce\DepotProduct
  • The field 'App\Entity\ECommerce\DepotProduct#taxRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ECommerce\ProductPhoto No errors.
App\Entity\ECommerce\ProductDocument No errors.
App\Entity\ECommerce\ProductCategory No errors.
App\Entity\ECommerce\ProductSubCategory No errors.
App\Entity\ECommerce\ProductGroup No errors.
App\Entity\ECommerce\ProductManufacturer No errors.
App\Entity\ECommerce\ProductAlternative No errors.
App\Entity\ECommerce\ProductInfo No errors.
App\Entity\ECommerce\Unit No errors.
App\Entity\ECommerce\ProductTranslation No errors.
App\Entity\Content\Document No errors.
App\Entity\App\User No errors.
App\Entity\ECommerce\DepotTranslation No errors.
App\Entity\ECommerce\ClientGroup No errors.
App\Entity\ECommerce\Cart No errors.
App\Entity\ECommerce\Firm No errors.
App\Entity\ECommerce\ProductCategoryTranslation No errors.
App\Entity\ECommerce\Rebate No errors.
App\Entity\ECommerce\ProductInfoTranslation No errors.
App\Entity\Content\DocumentCategory No errors.
App\Entity\Content\DocumentTranslation No errors.
App\Entity\ECommerce\IndividualOrder No errors.
App\Entity\ECommerce\CartItem No errors.
App\Entity\ECommerce\Invoice No errors.
App\Entity\ECommerce\BankAccount No errors.
App\Entity\SEO\Seo No errors.
App\Entity\ECommerce\BillItem No errors.
App\Entity\ECommerce\Bill No errors.
App\Entity\App\Menu No errors.

client_rel_management entity manager

No loaded entities.

client_rel_web_management entity manager

No loaded entities.