Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

18.03 ms Query time

0 Invalid entities

122 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.slug = ? LIMIT 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
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	1.66 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.slug = ? LIMIT 1 Parameters: [`"systemy-suchej-zabudowy"`] 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.slug = ? LIMIT 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 = 'systemy-suchej-zabudowy' LIMIT 1;
2	1.65 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: [`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, 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 = 1 AND p0_.active = 1 AND p0_.deleted_at IS NULL ORDER BY p0_.position ASC;
3	2.56 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 34`] 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 = 34 AND (p0_.only_vip = 0 OR p0_.only_vip IS NULL) ORDER BY p1_.position ASC, p0_.position ASC;
4	1.92 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: [`165 167 168 169 170 264 266 265 539 540 182`] 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 (165, 167, 168, 169, 170, 264, 266, 265, 539, 540, 182) AND p0_.deleted_at IS NULL;
5	2.42 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: [`13`] 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 = 13;
6	1.73 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: [`12`] 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 = 12;
7	1.53 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: [`3`] 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 = 3;
8	1.53 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: [`2`] 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 = 2;
9	1.53 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: [`34`] 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 = 34;
10	1.50 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: [`4`] 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 = 4;

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.

Symfony Profiler

GET http://profit.knauf.pl/_fragment?_path=_format%3Dhtml%26_locale%3Dpl%26_controller%3DApp%255CController%255CIndexController%253A%253AtranslationAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping