GET https://mastermontenegro.com/proizvodi/video-nadzor/ip-kamere/ipc-hdw2841tp-zs-27135

Query Metrics

10 Database Queries
9 Different statements
14.51 ms Query time
0 Invalid entities
34 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.09 ms
(28.17%)
1
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 p0_.slug = ? AND p1_.slug = ?
Parameters:
[
  "ipc-hdw2841tp-zs-27135"
  "ip-kamere"
]
3.50 ms
(24.15%)
1
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_.slug <> ? AND p0_.is_publish = ? AND p0_.is_archived = ? LIMIT 8
Parameters:
[
  "ip-kamere"
  "ipc-hdw2841tp-zs-27135"
  1
  0
]
1.90 ms
(13.11%)
2
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:
[
  "video-nadzor"
]
0.95 ms
(6.53%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.short_description AS short_description_5, t0.content AS content_6, t0.featured_image AS featured_image_7, t0.image_gallery AS image_gallery_8, t0.seo_meta AS seo_meta_9, t0.is_publish AS is_publish_10, t0.is_featured AS is_featured_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM post t0 WHERE t0.is_publish = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  1
]
0.87 ms
(5.98%)
1
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:
[
  "f6d46fcd-8b43-455b-8b59-2a9423cea3c4"
]
0.86 ms
(5.95%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.oib AS oib_3, t0.phone AS phone_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.address AS address_8, t0.delivery_address AS delivery_address_9, t0.payment_type AS payment_type_10, t0.discounts AS discounts_11, t0.is_verified AS is_verified_12, t0.city AS city_13, t0.postal_code AS postal_code_14 FROM company t0 WHERE t0.id = ?
Parameters:
[
  "cdd18904-dcd9-4d28-ae77-fd138f95cfcb"
]
0.84 ms
(5.79%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.personal_info AS personal_info_5, t0.account_info AS account_info_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.company_id AS company_id_9 FROM user t0 WHERE t0.id = ?
Parameters:
[
  "ef15922d-ba21-4ad4-986d-d026a080c0b8"
]
0.81 ms
(5.59%)
1
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"
]
0.69 ms
(4.74%)
1
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:
[
  "65bb129f-e7e3-45dd-b66f-80f8c9dbb78d"
]

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\Attribute 16
App\Entity\Product 9
App\Entity\Post 3
App\Entity\ProductCategory 2
App\Entity\Brand 2
App\Entity\User 1
App\Entity\Company 1

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\Post No errors.
App\Entity\User No errors.
App\Entity\Company No errors.
App\Entity\Order No errors.