GET https://mastermontenegro.com/index.php/proizvodi/co-detekcija/dodatna-oprema-za-co-detekciju

Query Metrics

15 Database Queries
8 Different statements
34.93 ms Query time
0 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 5.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "co-detekcija"
]
2 1.83 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.position AS position_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.is_publish AS is_publish_10, t0.is_archived AS is_archived_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "dodatna-oprema-za-co-detekciju"
]
3 0.95 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.subtitle AS subtitle_3, p0_.description AS description_4, p0_.position AS position_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.is_publish AS is_publish_9, p0_.is_archived AS is_archived_10, p0_.tree_root AS tree_root_11, p0_.parent_id AS parent_id_12 FROM product_category p0_ WHERE p0_.parent_id = ? AND p0_.is_archived = ? ORDER BY p0_.position ASC
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#1001
    __toString(): "ea9e287b-5ca2-40be-b9d8-b9f7b8cab658"
  }
  0
]
4 1.62 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.position AS position_3, a0_.lft AS lft_4, a0_.lvl AS lvl_5, a0_.rgt AS rgt_6, a0_.is_group AS is_group_7, a0_.tree_root AS tree_root_8, a0_.parent_id AS parent_id_9, a0_.product_category_id AS product_category_id_10 FROM attribute a0_ INNER JOIN product_category p1_ ON a0_.product_category_id = p1_.id WHERE p1_.slug = ? AND a0_.parent_id IS NULL ORDER BY a0_.position ASC, a0_.title ASC
Parameters:
[
  "dodatna-oprema-za-co-detekciju"
]
5 1.96 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.description AS description_4, p0_.price AS price_5, p0_.special_price AS special_price_6, p0_.max_discount AS max_discount_7, p0_.sku AS sku_8, p0_.featured_image AS featured_image_9, p0_.image_gallery AS image_gallery_10, p0_.tabs AS tabs_11, p0_.seo_meta AS seo_meta_12, p0_.is_publish AS is_publish_13, p0_.is_archived AS is_archived_14, p0_.is_featured AS is_featured_15, p0_.is_homepage_slider AS is_homepage_slider_16, p0_.show_in_category AS show_in_category_17, p0_.is_highlighted AS is_highlighted_18, p0_.is_b2_c AS is_b2_c_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.documents AS documents_22, p0_.related_products AS related_products_23, p0_.stock_quantity AS stock_quantity_24, p0_.category_id AS category_id_25, p0_.brand_id AS brand_id_26 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ? ORDER BY p0_.created_at DESC LIMIT 24
Parameters:
[
  "dodatna-oprema-za-co-detekciju"
  1
  0
]
6 0.72 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p1_ ON p0_.category_id = p1_.id WHERE p1_.slug = ? AND p0_.is_publish = ? AND p0_.is_archived = ?
Parameters:
[
  "dodatna-oprema-za-co-detekciju"
  1
  0
]
7 3.28 ms
SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.delivery AS delivery_6, t0.delivery_price AS delivery_price_7, t0.customer_note AS customer_note_8, t0.company_id AS company_id_9, t0.user_id AS user_id_10 FROM `order` t0 WHERE t0.id IS NULL AND t0.status = ? LIMIT 1
Parameters:
[
  "cart"
]
8 5.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.featured_image AS featured_image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.web_url AS web_url_8, t0.color AS color_9 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  "d247cc0b-299e-4db8-b9d5-d106dae5a606"
]
9 0.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "3ce8645a-582b-4eed-a487-b7cb9aa04aaa"
]
10 1.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.featured_image AS featured_image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.web_url AS web_url_8, t0.color AS color_9 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  "3ea48654-fdde-43ef-83cf-646464bb191b"
]
11 6.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "8efa4c46-5961-4b55-a043-f9a738e28e57"
]
12 0.66 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "54929912-6455-46fc-8a6f-74b3cab9b1b5"
]
13 1.54 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "f6c82c87-e8a9-4461-8eb6-35ccc6feeed0"
]
14 0.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "0797ee3f-7337-4dbc-a65a-83ac2dab8e7c"
]
15 1.77 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.is_group AS is_group_8, t0.tree_root AS tree_root_9, t0.parent_id AS parent_id_10, t0.product_category_id AS product_category_id_11 FROM attribute t0 INNER JOIN product_attribute ON t0.id = product_attribute.attribute_id WHERE product_attribute.product_id = ?
Parameters:
[
  "5cbfa8b8-8e15-435b-8cd7-829b82b4f30b"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Product 6
App\Entity\ProductCategory 4
App\Entity\Brand 2

Entities Mapping

Class Mapping errors
App\Entity\ProductCategory No errors.
App\Entity\Product No errors.
App\Entity\Attribute No errors.
App\Entity\Brand No errors.
App\Entity\Tag No errors.
App\Entity\Order No errors.
App\Entity\Company No errors.
App\Entity\User No errors.