GET https://www.lustra-bronza.ru/api/v2/products?itemsPerPage=10&page=1

Query Metrics

35 Database Queries
7 Different statements
19.45 ms Query time
0 Invalid entities
52 Managed entities

Queries

Group similar statements

# Time Info
1 1.16 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.sort_order AS sort_order_3, p0_.effective_price AS effective_price_4, p0_.status AS status_5, p0_.type AS type_6, p0_.quantity AS quantity_7, p0_.options_json AS options_json_8, p0_.attribute_json AS attribute_json_9, p0_.code AS code_10, p0_.description AS description_11, p0_.similar_group_id AS similar_group_id_12, p0_.price AS price_13, p0_.sale_price AS sale_price_14, p0_.currency AS currency_15, p0_.date_added AS date_added_16, p0_.date_edited AS date_edited_17, p0_.manufacturer_id AS manufacturer_id_18, p0_.series_id AS series_id_19 FROM product p0_ ORDER BY p0_.id DESC LIMIT 10
Parameters:
[]
2 1.08 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  258
]
3 2.00 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  257
]
4 1.46 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  256
]
5 0.78 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  255
]
6 0.78 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  254
]
7 0.32 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  253
]
8 0.38 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  252
]
9 0.30 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  251
]
10 0.31 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  250
]
11 0.30 ms
SELECT t0.meta_title AS meta_title_1, t0.meta_description AS meta_description_2, t0.meta_keywords AS meta_keywords_3, t0.h1 AS h1_4, t0.product_id AS product_id_5 FROM product_seo t0 WHERE t0.product_id = ?
Parameters:
[
  249
]
12 0.39 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  258
]
13 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visibility AS visibility_4, t0.parent_category_id AS parent_category_id_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.sort_order AS sort_order_9, t0.meta_h1 AS meta_h1_10, t0.description AS description_11, t0.navbar_visibility AS navbar_visibility_12, t0.footer_visibility AS footer_visibility_13 FROM category t0 WHERE t0.id = ?
Parameters:
[
  6
]
14 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.visibility AS visibility_4, t0.parent_category_id AS parent_category_id_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.meta_keywords AS meta_keywords_8, t0.sort_order AS sort_order_9, t0.meta_h1 AS meta_h1_10, t0.description AS description_11, t0.navbar_visibility AS navbar_visibility_12, t0.footer_visibility AS footer_visibility_13 FROM category t0 WHERE t0.id = ?
Parameters:
[
  19
]
15 0.44 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  258
]
16 0.49 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  257
]
17 0.52 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  257
]
18 0.33 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  256
]
19 0.36 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  256
]
20 0.34 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  255
]
21 0.34 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  255
]
22 0.32 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  254
]
23 0.42 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  254
]
24 0.32 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  253
]
25 0.35 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  253
]
26 0.30 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  252
]
27 0.35 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  252
]
28 0.36 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  251
]
29 0.31 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  251
]
30 0.31 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  250
]
31 0.32 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  250
]
32 0.32 ms
SELECT t0.id AS id_1, t0.is_parent AS is_parent_2, t0.position AS position_3, t0.visibility AS visibility_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM product_to_category t0 WHERE t0.product_id = ?
Parameters:
[
  249
]
33 0.31 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.sort_order AS sort_order_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC LIMIT 1
Parameters:
[
  249
]
34 1.97 ms
SELECT p0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM product p0_ LEFT JOIN product_option_value_assignment p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.type IN (?, ?) GROUP BY p0_.id
Parameters:
[
  258
  257
  256
  255
  254
  253
  252
  251
  250
  249
  "variable"
  "variable_no_prices"
]
35 0.61 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_
Parameters:
[]

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\ProductToCategory 20
App\Entity\Product 10
App\Entity\ProductSeo 10
App\Entity\ProductImage 10
App\Entity\Category 2