Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

23.93 ms Query time

1 Invalid entities

278 Managed entities

Queries


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.id = ?
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
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
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?

#▲	Time	Info
1	3.06 ms	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.id = ? Parameters: [`999`] View formatted query View runnable query Explain query 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.id = ? 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.id = 999;
2	1.58 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, 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: [`7`] 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, 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 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 = 7 AND p0_.active = 1 AND p0_.deleted_at IS NULL ORDER BY p0_.position ASC;
3	6.13 ms	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 "7"`] View formatted query View runnable query Explain query 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 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 = 1 AND p0_.deleted_at IS NULL AND p1_.id = '7' AND (p0_.only_vip = 0 OR p0_.only_vip IS NULL) ORDER BY p1_.position ASC, p0_.position ASC;
4	2.43 ms	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: [`67 349 351 69 71 192 352 74 72 73 541 75 348 193 108 231 301 542 529 543 544 545 78 363 354 88 87 86 160 38 270 92 96 93 271 161 94 454 99 272 95 357 358 359 360 361 362 546 430 203 205 365 43 548 549 452 451 450 77 453 47 550 551 487 240 547 552 553 554 555 373 556 557 558 189 243 244 376 245 190 153 246 155 186 188 149 216 156 154 227 377 150 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576`] View formatted query View runnable query Explain query 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 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 (67, 349, 351, 69, 71, 192, 352, 74, 72, 73, 541, 75, 348, 193, 108, 231, 301, 542, 529, 543, 544, 545, 78, 363, 354, 88, 87, 86, 160, 38, 270, 92, 96, 93, 271, 161, 94, 454, 99, 272, 95, 357, 358, 359, 360, 361, 362, 546, 430, 203, 205, 365, 43, 548, 549, 452, 451, 450, 77, 453, 47, 550, 551, 487, 240, 547, 552, 553, 554, 555, 373, 556, 557, 558, 189, 243, 244, 376, 245, 190, 153, 246, 155, 186, 188, 149, 216, 156, 154, 227, 377, 150, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 572, 573, 574, 575, 576) AND p0_.deleted_at IS NULL;
5	1.52 ms	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: [`24`] View formatted query View runnable query Explain query 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 = ? 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 = 24;
6	2.40 ms	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: [`25`] View formatted query View runnable query Explain query 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 = ? 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 = 25;
7	1.68 ms	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: [`26`] View formatted query View runnable query Explain query 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 = ? 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 = 26;
8	1.64 ms	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: [`27`] View formatted query View runnable query Explain query 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 = ? 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 = 27;
9	1.48 ms	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: [`29`] View formatted query View runnable query Explain query 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 = ? 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 = 29;
10	2.01 ms	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: [`23`] View formatted query View runnable query Explain query 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 = ? 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 = 23;

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

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/nagrody/za-punkty/7/wszystkie?category=7&page=0

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping