GET http://profit.knauf.pl/produkty/za-punkty/1/systemy-suchej-zabudowy?category=1&page=0

Query Metrics

10 Database Queries
5 Different statements
18.03 ms Query time
1 Invalid entities
122 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.24 ms
(56.78%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.subtitle AS subtitle_3, t0.status AS status_4, t0.edycja7 AS edycja7_5, t0.base_price AS base_price_6, t0.description AS description_7, t0.options AS options_8, t0.points AS points_9, t0.netto AS netto_10, t0.promo_points AS promo_points_11, t0.promo_start AS promo_start_12, t0.promo_end AS promo_end_13, t0.number AS number_14, t0.manufacturer AS manufacturer_15, t0.packing AS packing_16, t0.packing2 AS packing2_17, t0.orderable AS orderable_18, t0.position AS position_19, t0.vip AS vip_20, t0.only_vip AS only_vip_21, t0.knauf AS knauf_22, t0.label AS label_23, t0.info AS info_24, t0.slug AS slug_25, t0.image_name AS image_name_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.deleted_at AS deleted_at_29 FROM p_product t0 INNER JOIN product_product_category ON t0.id = product_product_category.product_id WHERE product_product_category.product_category_id = ?
Parameters:
[
  13
]
2.56 ms
(14.20%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.subtitle AS subtitle_2, p0_.status AS status_3, p0_.edycja7 AS edycja7_4, p0_.base_price AS base_price_5, p0_.description AS description_6, p0_.options AS options_7, p0_.points AS points_8, p0_.netto AS netto_9, p0_.promo_points AS promo_points_10, p0_.promo_start AS promo_start_11, p0_.promo_end AS promo_end_12, p0_.number AS number_13, p0_.manufacturer AS manufacturer_14, p0_.packing AS packing_15, p0_.packing2 AS packing2_16, p0_.orderable AS orderable_17, p0_.position AS position_18, p0_.vip AS vip_19, p0_.only_vip AS only_vip_20, p0_.knauf AS knauf_21, p0_.label AS label_22, p0_.info AS info_23, p0_.slug AS slug_24, p0_.image_name AS image_name_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.deleted_at AS deleted_at_28, p1_.id AS id_29, p1_.name AS name_30, p1_.position AS position_31, p1_.slug AS slug_32, p1_.image_name AS image_name_33, p1_.active AS active_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p2_.id AS id_38, p2_.image AS image_39, p2_.main AS main_40, p2_.created_at AS created_at_41, p2_.updated_at AS updated_at_42, p1_.parent_id AS parent_id_43, p2_.product_id AS product_id_44 FROM p_product p0_ LEFT JOIN product_product_category p3_ ON p0_.id = p3_.product_id LEFT JOIN p_category p1_ ON p1_.id = p3_.product_category_id LEFT JOIN p_photo p2_ ON p0_.id = p2_.product_id WHERE p0_.status = ? AND p0_.deleted_at IS NULL AND p1_.id = ? AND (p0_.only_vip = 0 OR p0_.only_vip IS NULL) ORDER BY p1_.position ASC, p0_.position ASC
Parameters:
[
  1
  34
]
1.92 ms
(10.63%)
1
SELECT p0_.slug AS slug_0, p1_.id AS id_1 FROM p_category p0_ LEFT JOIN product_product_category p2_ ON p0_.id = p2_.product_category_id LEFT JOIN p_product p1_ ON p1_.id = p2_.product_id WHERE p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.deleted_at IS NULL
Parameters:
[
  165
  167
  168
  169
  170
  264
  266
  265
  539
  540
  182
]
1.66 ms
(9.23%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.slug AS slug_4, t0.image_name AS image_name_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM p_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "systemy-suchej-zabudowy"
]
1.65 ms
(9.16%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.position AS position_2, p0_.slug AS slug_3, p0_.image_name AS image_name_4, p0_.active AS active_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8, p0_.parent_id AS parent_id_9 FROM p_category p0_ WHERE p0_.parent_id = ? AND p0_.active = 1 AND p0_.deleted_at IS NULL ORDER BY p0_.position ASC
Parameters:
[
  1
]

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 115
App\Entity\ProductCategory 7

Entities Mapping

Class Mapping errors
App\Entity\ProductCategory No errors.
App\Entity\Product No errors.
App\Entity\ProductPhoto No errors.
App\Entity\InvoiceProduct No errors.
App\Entity\OrderProduct No errors.
App\Entity\Invoice
  • The mappings App\Entity\Invoice#invoiceLogs and App\Entity\InvoiceLog#invoice are inconsistent with each other.
App\Entity\Order No errors.
App\Entity\User No errors.
App\Entity\InvoicePhoto No errors.
App\Entity\Point No errors.
App\Entity\InvoiceLog No errors.
App\Entity\Distributor No errors.
App\Entity\DeliveryAddress No errors.
App\Entity\OrderLog No errors.
App\Entity\ReportAward No errors.
App\Entity\Group No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\ArticleCategory No errors.
App\Entity\Dealer No errors.
App\Entity\ReportProduct No errors.
App\Entity\Profile No errors.
App\Entity\Region No errors.
App\Entity\Email No errors.
App\Entity\News No errors.
App\Entity\Article No errors.
App\Entity\Photo No errors.
App\Entity\ArticlePhoto No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
Vich\UploaderBundle\Entity\File No errors.