Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

8.05 ms Query time

1 Invalid entities

94 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	5.18 ms	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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = ? AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC Parameters: [`1`] View formatted query View runnable query Explain query 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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = ? AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC 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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = 1 AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC;
2	2.88 ms	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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = ? AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC Parameters: [`1`] View formatted query View runnable query Explain query 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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = ? AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC 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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = 1 AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC;

#▲

Time

Info

5.18 ms

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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = ? AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query

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,
  p1_.id AS id_9,
  p1_.name AS name_10,
  p1_.subtitle AS subtitle_11,
  p1_.status AS status_12,
  p1_.edycja7 AS edycja7_13,
  p1_.base_price AS base_price_14,
  p1_.description AS description_15,
  p1_.options AS options_16,
  p1_.points AS points_17,
  p1_.netto AS netto_18,
  p1_.promo_points AS promo_points_19,
  p1_.promo_start AS promo_start_20,
  p1_.promo_end AS promo_end_21,
  p1_.number AS number_22,
  p1_.manufacturer AS manufacturer_23,
  p1_.packing AS packing_24,
  p1_.packing2 AS packing2_25,
  p1_.orderable AS orderable_26,
  p1_.position AS position_27,
  p1_.vip AS vip_28,
  p1_.only_vip AS only_vip_29,
  p1_.knauf AS knauf_30,
  p1_.label AS label_31,
  p1_.info AS info_32,
  p1_.slug AS slug_33,
  p1_.image_name AS image_name_34,
  p1_.created_at AS created_at_35,
  p1_.updated_at AS updated_at_36,
  p1_.deleted_at AS deleted_at_37,
  p0_.parent_id AS parent_id_38
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
  p0_.parent_id = ?
  AND p1_.status = 1
  AND p0_.active = 1
  AND p0_.deleted_at IS NULL
  AND p1_.deleted_at IS NULL
ORDER BY
  p0_.position ASC,
  p1_.position ASC

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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = 1 AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC;

2.88 ms

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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = ? AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query

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,
  p1_.id AS id_9,
  p1_.name AS name_10,
  p1_.subtitle AS subtitle_11,
  p1_.status AS status_12,
  p1_.edycja7 AS edycja7_13,
  p1_.base_price AS base_price_14,
  p1_.description AS description_15,
  p1_.options AS options_16,
  p1_.points AS points_17,
  p1_.netto AS netto_18,
  p1_.promo_points AS promo_points_19,
  p1_.promo_start AS promo_start_20,
  p1_.promo_end AS promo_end_21,
  p1_.number AS number_22,
  p1_.manufacturer AS manufacturer_23,
  p1_.packing AS packing_24,
  p1_.packing2 AS packing2_25,
  p1_.orderable AS orderable_26,
  p1_.position AS position_27,
  p1_.vip AS vip_28,
  p1_.only_vip AS only_vip_29,
  p1_.knauf AS knauf_30,
  p1_.label AS label_31,
  p1_.info AS info_32,
  p1_.slug AS slug_33,
  p1_.image_name AS image_name_34,
  p1_.created_at AS created_at_35,
  p1_.updated_at AS updated_at_36,
  p1_.deleted_at AS deleted_at_37,
  p0_.parent_id AS parent_id_38
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
  p0_.parent_id = ?
  AND p1_.status = 1
  AND p0_.active = 1
  AND p0_.deleted_at IS NULL
  AND p1_.deleted_at IS NULL
ORDER BY
  p0_.position ASC,
  p1_.position ASC

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, p1_.id AS id_9, p1_.name AS name_10, p1_.subtitle AS subtitle_11, p1_.status AS status_12, p1_.edycja7 AS edycja7_13, p1_.base_price AS base_price_14, p1_.description AS description_15, p1_.options AS options_16, p1_.points AS points_17, p1_.netto AS netto_18, p1_.promo_points AS promo_points_19, p1_.promo_start AS promo_start_20, p1_.promo_end AS promo_end_21, p1_.number AS number_22, p1_.manufacturer AS manufacturer_23, p1_.packing AS packing_24, p1_.packing2 AS packing2_25, p1_.orderable AS orderable_26, p1_.position AS position_27, p1_.vip AS vip_28, p1_.only_vip AS only_vip_29, p1_.knauf AS knauf_30, p1_.label AS label_31, p1_.info AS info_32, p1_.slug AS slug_33, p1_.image_name AS image_name_34, p1_.created_at AS created_at_35, p1_.updated_at AS updated_at_36, p1_.deleted_at AS deleted_at_37, p0_.parent_id AS parent_id_38 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 p0_.parent_id = 1 AND p1_.status = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p1_.deleted_at IS NULL ORDER BY p0_.position ASC, p1_.position ASC;

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	87
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.

Symfony Profiler

GET http://profit.knauf.pl/produkty-za-punkty

Configuration Settings

Theme

Page Width