Query Metrics
35
Database Queries
28
Different statements
133.91 ms
Query time
0
Invalid entities
2539
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.target_blank AS target_blank_4, t0.description AS description_5, t0.body AS body_6, t0.top_menu AS top_menu_7, t0.published AS published_8, t0.type AS type_9, t0.sequence AS sequence_10, t11.id AS id_12, t11.type AS type_13, t11.pattern AS pattern_14, t11.title AS title_15, t11.h1 AS h1_16, t11.canonical AS canonical_17, t11.product_id AS product_id_18, t11.article_id AS article_id_19, t11.static_id AS static_id_20 FROM static_page t0 LEFT JOIN seo__seo t11 ON t11.static_id = t0.id WHERE t0.url = ? LIMIT 1
Parameters:
[
"Plecak-100104"
]
|
| 2 | 5.52 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.temporarily_off AS temporarily_off_3, t0.amount_id AS amount_id_4, t0.slug AS slug_5, t0.link AS link_6, t0.name AS name_7, t0."sequence" AS sequence_8, t0.thumbnail AS thumbnail_9, t0.new_homepage_thumbnail AS new_homepage_thumbnail_10, t0.hover_thumbnail AS hover_thumbnail_11, t0.image AS image_12, t0.alt AS alt_13, t0.image_additional AS image_additional_14, t0.alt_additional AS alt_additional_15, t0.header AS header_16, t0.description AS description_17, t0.new_selector_main_image AS new_selector_main_image_18, t0.new_selector_main_image_alt AS new_selector_main_image_alt_19, t0.new_selector_amounts_image AS new_selector_amounts_image_20, t0.new_selector_amounts_image_alt AS new_selector_amounts_image_alt_21, t0.updated_at AS updated_at_22, t0.technical_specification AS technical_specification_23, t0.base_product_id AS base_product_id_24, t0.mockup AS mockup_25, t0.importance_level AS importance_level_26, t0.google_feed_default_product_id AS google_feed_default_product_id_27, t0.google_feed_description AS google_feed_description_28, t0.marketplace_code AS marketplace_code_29, t0.modal_title AS modal_title_30, t0.modal_link AS modal_link_31, t0.modal_content AS modal_content_32, t0.modal_enabled AS modal_enabled_33, t0.additional_content_field1 AS additional_content_field1_34, t0.additional_content_field2 AS additional_content_field2_35, t0.additional_content_field3 AS additional_content_field3_36, t0.additional_content_field4 AS additional_content_field4_37, t0.additional_content_field5 AS additional_content_field5_38, t0.group_id AS group_id_39, t40.id AS id_41, t40.amount_id AS amount_id_42, t40.product_id AS product_id_43, t44.id AS id_45, t44.type AS type_46, t44.pattern AS pattern_47, t44.title AS title_48, t44.h1 AS h1_49, t44.canonical AS canonical_50, t44.product_id AS product_id_51, t44.article_id AS article_id_52, t44.static_id AS static_id_53, t54.id AS id_55, t54.type AS type_56, t54.title AS title_57, t54.name AS name_58, t54.sequence AS sequence_59, t54.product_id AS product_id_60, t54.category_id AS category_id_61, t54.group_id AS group_id_62, t0.sticker_id AS sticker_id_63, t64.active AS active_65, t64.id AS id_66, t64.created_at AS created_at_67, t64.updated_at AS updated_at_68, t64.image1_active AS image1_active_69, t64.image1 AS image1_70, t64.image3alt AS image3alt_71, t64.field2_active AS field2_active_72, t64.title2 AS title2_73, t64.sub_title2 AS sub_title2_74, t64.text2 AS text2_75, t64.field3_active AS field3_active_76, t64.image3 AS image3_77, t64.image1alt AS image1alt_78, t64.title3 AS title3_79, t64.sub_title3 AS sub_title3_80, t64.text3 AS text3_81, t64.link3 AS link3_82, t64.button3 AS button3_83, t64.field4_active AS field4_active_84, t64.image4 AS image4_85, t64.image4alt AS image4alt_86, t64.title4 AS title4_87, t64.sub_title4 AS sub_title4_88, t64.text4 AS text4_89, t64.link4 AS link4_90, t64.button4 AS button4_91, t64.field5_active AS field5_active_92, t64.field6_active AS field6_active_93, t64.field8_active AS field8_active_94, t64.field9_active AS field9_active_95, t64.title9 AS title9_96, t64.brief9 AS brief9_97, t64.text9 AS text9_98, t64.field10_active AS field10_active_99, t64.product_id AS product_id_100, t101.id AS id_102, t101.image AS image_103, t101.alt AS alt_104, t101.link_type AS link_type_105, t101.link AS link_106, t101.updated_at AS updated_at_107, t101.sequence AS sequence_108, t101.carousel_id AS carousel_id_109, t101.product_id AS product_id_110, t101.product_group_id AS product_group_id_111, t101.product_category_id AS product_category_id_112 FROM product__product t0 LEFT JOIN product__promoted t40 ON t40.product_id = t0.id LEFT JOIN seo__seo t44 ON t44.product_id = t0.id LEFT JOIN seo__footer_product_menu t54 ON t54.product_id = t0.id LEFT JOIN product__description t64 ON t64.product_id = t0.id LEFT JOIN new_homepage__carousel_element t101 ON t101.product_id = t0.id WHERE t0.link = ? LIMIT 1
Parameters:
[
"Plecak-100104"
]
|
| 3 | 0.86 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3 FROM global_tag t0 WHERE t0.type = ?
Parameters:
[
1
]
|
| 4 | 0.70 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.pattern AS pattern_3, t0.title AS title_4, t0.h1 AS h1_5, t0.canonical AS canonical_6, t0.product_id AS product_id_7, t0.article_id AS article_id_8, t0.static_id AS static_id_9 FROM seo__seo t0 WHERE t0.type = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "product" 3879 ] |
| 5 | 0.55 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.pattern AS pattern_3, t0.title AS title_4, t0.h1 AS h1_5, t0.canonical AS canonical_6, t0.product_id AS product_id_7, t0.article_id AS article_id_8, t0.static_id AS static_id_9 FROM seo__seo t0 WHERE t0.type = ? AND t0.pattern = ? LIMIT 1
Parameters:
[ "pattern" "*" ] |
| 6 | 0.54 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3 FROM global_tag t0 WHERE t0.type = ?
Parameters:
[
4
]
|
| 7 | 1.90 ms |
SELECT t0.id AS id_1, t0.additional_header AS additional_header_2, t0.additional_footer AS additional_footer_3, t0.header_active AS header_active_4, t0.footer_active AS footer_active_5, t0.overwrite_current_footer AS overwrite_current_footer_6 FROM additional_header_footer t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[] |
| 8 | 1.22 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.active AS active_3, p0_.visible_in_menu AS visible_in_menu_4, p0_.image AS image_5, p0_.image_alt AS image_alt_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.second_image AS second_image_9, p0_.third_image AS third_image_10, p0_.description AS description_11, p0_.second_image_alt AS second_image_alt_12, p0_.third_image_alt AS third_image_alt_13 FROM product_industry p0_ WHERE p0_.active = ? AND p0_.visible_in_menu = ? ORDER BY p0_.id ASC
Parameters:
[ 1 1 ] |
| 9 | 1.39 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.section_offer_active AS section_offer_active_3, t0.section_offer_sequence AS section_offer_sequence_4, t0.section_lottie_files_active AS section_lottie_files_active_5, t0.section_lottie_files_sequence AS section_lottie_files_sequence_6, t0.section_easy_active AS section_easy_active_7, t0.section_easy_sequence AS section_easy_sequence_8, t0.section_blog_active AS section_blog_active_9, t0.section_blog_sequence AS section_blog_sequence_10, t0.section_script_active AS section_script_active_11, t0.section_script_sequence AS section_script_sequence_12, t0.section_script_content AS section_script_content_13, t0.section_newsletter_active AS section_newsletter_active_14, t0.section_newsletter_sequence AS section_newsletter_sequence_15, t0.newsletter_baner AS newsletter_baner_16, t0.newsletter_baner_mobile_image AS newsletter_baner_mobile_image_17, t0.section_register_active AS section_register_active_18, t0.section_register_sequence AS section_register_sequence_19, t0.section_marketing_active AS section_marketing_active_20, t0.section_marketing_sequence AS section_marketing_sequence_21, t0.section_marketing_title AS section_marketing_title_22, t0.section_marketing_brief AS section_marketing_brief_23, t0.section_marketing_description AS section_marketing_description_24, t0.updated_at AS updated_at_25, t0.slider_id AS slider_id_26, t0.section_carousel_id AS section_carousel_id_27, t0.section_banner_id AS section_banner_id_28, t0.section_banner_2_id AS section_banner_2_id_29, t0.section_inspirations_id AS section_inspirations_id_30, t0.section_carousel_2_id AS section_carousel_2_id_31 FROM new_homepage t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
| 10 | 2.37 ms |
SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.title AS title_2, b0_.active AS active_3, b0_.short_description AS short_description_4, b0_.description AS description_5, b0_.author_name AS author_name_6, b0_.image AS image_7, b0_.alt AS alt_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.blog_category_id AS blog_category_id_11 FROM blog__article b0_ WHERE b0_.active = ? ORDER BY b0_.created_at DESC LIMIT 10
Parameters:
[
1
]
|
| 11 | 1.59 ms |
SELECT p0_.id AS id_0, p0_.content AS content_1, p0_.script AS script_2, p0_.size AS size_3, p0_.views AS views_4, p0_.days_between_view AS days_between_view_5, p0_.active_from AS active_from_6, p0_.active_to AS active_to_7, p0_.style AS style_8, p0_.only_for_logged_user AS only_for_logged_user_9 FROM popup p0_ INNER JOIN popup_popup_route p2_ ON p0_.id = p2_.popup_id INNER JOIN popup_route p1_ ON p1_.id = p2_.popup_route_id WHERE p0_.active_from <= ? AND p0_.active_to >= ? AND p1_.name = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ "2026-04-23" "2026-04-23" "front.static_page.static_page" ] |
| 12 | 0.91 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.target_blank AS target_blank_4, t0.description AS description_5, t0.body AS body_6, t0.top_menu AS top_menu_7, t0.published AS published_8, t0.type AS type_9, t0.sequence AS sequence_10, t11.id AS id_12, t11.type AS type_13, t11.pattern AS pattern_14, t11.title AS title_15, t11.h1 AS h1_16, t11.canonical AS canonical_17, t11.product_id AS product_id_18, t11.article_id AS article_id_19, t11.static_id AS static_id_20 FROM static_page t0 LEFT JOIN seo__seo t11 ON t11.static_id = t0.id WHERE t0.url = ? LIMIT 1
Parameters:
[
"Plecak-100104"
]
|
| 13 | 3.21 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.temporarily_off AS temporarily_off_3, t0.amount_id AS amount_id_4, t0.slug AS slug_5, t0.link AS link_6, t0.name AS name_7, t0."sequence" AS sequence_8, t0.thumbnail AS thumbnail_9, t0.new_homepage_thumbnail AS new_homepage_thumbnail_10, t0.hover_thumbnail AS hover_thumbnail_11, t0.image AS image_12, t0.alt AS alt_13, t0.image_additional AS image_additional_14, t0.alt_additional AS alt_additional_15, t0.header AS header_16, t0.description AS description_17, t0.new_selector_main_image AS new_selector_main_image_18, t0.new_selector_main_image_alt AS new_selector_main_image_alt_19, t0.new_selector_amounts_image AS new_selector_amounts_image_20, t0.new_selector_amounts_image_alt AS new_selector_amounts_image_alt_21, t0.updated_at AS updated_at_22, t0.technical_specification AS technical_specification_23, t0.base_product_id AS base_product_id_24, t0.mockup AS mockup_25, t0.importance_level AS importance_level_26, t0.google_feed_default_product_id AS google_feed_default_product_id_27, t0.google_feed_description AS google_feed_description_28, t0.marketplace_code AS marketplace_code_29, t0.modal_title AS modal_title_30, t0.modal_link AS modal_link_31, t0.modal_content AS modal_content_32, t0.modal_enabled AS modal_enabled_33, t0.additional_content_field1 AS additional_content_field1_34, t0.additional_content_field2 AS additional_content_field2_35, t0.additional_content_field3 AS additional_content_field3_36, t0.additional_content_field4 AS additional_content_field4_37, t0.additional_content_field5 AS additional_content_field5_38, t0.group_id AS group_id_39, t40.id AS id_41, t40.amount_id AS amount_id_42, t40.product_id AS product_id_43, t44.id AS id_45, t44.type AS type_46, t44.pattern AS pattern_47, t44.title AS title_48, t44.h1 AS h1_49, t44.canonical AS canonical_50, t44.product_id AS product_id_51, t44.article_id AS article_id_52, t44.static_id AS static_id_53, t54.id AS id_55, t54.type AS type_56, t54.title AS title_57, t54.name AS name_58, t54.sequence AS sequence_59, t54.product_id AS product_id_60, t54.category_id AS category_id_61, t54.group_id AS group_id_62, t0.sticker_id AS sticker_id_63, t64.active AS active_65, t64.id AS id_66, t64.created_at AS created_at_67, t64.updated_at AS updated_at_68, t64.image1_active AS image1_active_69, t64.image1 AS image1_70, t64.image3alt AS image3alt_71, t64.field2_active AS field2_active_72, t64.title2 AS title2_73, t64.sub_title2 AS sub_title2_74, t64.text2 AS text2_75, t64.field3_active AS field3_active_76, t64.image3 AS image3_77, t64.image1alt AS image1alt_78, t64.title3 AS title3_79, t64.sub_title3 AS sub_title3_80, t64.text3 AS text3_81, t64.link3 AS link3_82, t64.button3 AS button3_83, t64.field4_active AS field4_active_84, t64.image4 AS image4_85, t64.image4alt AS image4alt_86, t64.title4 AS title4_87, t64.sub_title4 AS sub_title4_88, t64.text4 AS text4_89, t64.link4 AS link4_90, t64.button4 AS button4_91, t64.field5_active AS field5_active_92, t64.field6_active AS field6_active_93, t64.field8_active AS field8_active_94, t64.field9_active AS field9_active_95, t64.title9 AS title9_96, t64.brief9 AS brief9_97, t64.text9 AS text9_98, t64.field10_active AS field10_active_99, t64.product_id AS product_id_100, t101.id AS id_102, t101.image AS image_103, t101.alt AS alt_104, t101.link_type AS link_type_105, t101.link AS link_106, t101.updated_at AS updated_at_107, t101.sequence AS sequence_108, t101.carousel_id AS carousel_id_109, t101.product_id AS product_id_110, t101.product_group_id AS product_group_id_111, t101.product_category_id AS product_category_id_112 FROM product__product t0 LEFT JOIN product__promoted t40 ON t40.product_id = t0.id LEFT JOIN seo__seo t44 ON t44.product_id = t0.id LEFT JOIN seo__footer_product_menu t54 ON t54.product_id = t0.id LEFT JOIN product__description t64 ON t64.product_id = t0.id LEFT JOIN new_homepage__carousel_element t101 ON t101.product_id = t0.id WHERE t0.link = ? LIMIT 1
Parameters:
[
"Plecak-100104"
]
|
| 14 | 33.67 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.temporarily_off AS temporarily_off_3, t0.amount_id AS amount_id_4, t0.slug AS slug_5, t0.link AS link_6, t0.name AS name_7, t0."sequence" AS sequence_8, t0.thumbnail AS thumbnail_9, t0.new_homepage_thumbnail AS new_homepage_thumbnail_10, t0.hover_thumbnail AS hover_thumbnail_11, t0.image AS image_12, t0.alt AS alt_13, t0.image_additional AS image_additional_14, t0.alt_additional AS alt_additional_15, t0.header AS header_16, t0.description AS description_17, t0.new_selector_main_image AS new_selector_main_image_18, t0.new_selector_main_image_alt AS new_selector_main_image_alt_19, t0.new_selector_amounts_image AS new_selector_amounts_image_20, t0.new_selector_amounts_image_alt AS new_selector_amounts_image_alt_21, t0.updated_at AS updated_at_22, t0.technical_specification AS technical_specification_23, t0.base_product_id AS base_product_id_24, t0.mockup AS mockup_25, t0.importance_level AS importance_level_26, t0.google_feed_default_product_id AS google_feed_default_product_id_27, t0.google_feed_description AS google_feed_description_28, t0.marketplace_code AS marketplace_code_29, t0.modal_title AS modal_title_30, t0.modal_link AS modal_link_31, t0.modal_content AS modal_content_32, t0.modal_enabled AS modal_enabled_33, t0.additional_content_field1 AS additional_content_field1_34, t0.additional_content_field2 AS additional_content_field2_35, t0.additional_content_field3 AS additional_content_field3_36, t0.additional_content_field4 AS additional_content_field4_37, t0.additional_content_field5 AS additional_content_field5_38, t0.group_id AS group_id_39, t40.id AS id_41, t40.amount_id AS amount_id_42, t40.product_id AS product_id_43, t44.id AS id_45, t44.type AS type_46, t44.pattern AS pattern_47, t44.title AS title_48, t44.h1 AS h1_49, t44.canonical AS canonical_50, t44.product_id AS product_id_51, t44.article_id AS article_id_52, t44.static_id AS static_id_53, t54.id AS id_55, t54.type AS type_56, t54.title AS title_57, t54.name AS name_58, t54.sequence AS sequence_59, t54.product_id AS product_id_60, t54.category_id AS category_id_61, t54.group_id AS group_id_62, t0.sticker_id AS sticker_id_63, t64.active AS active_65, t64.id AS id_66, t64.created_at AS created_at_67, t64.updated_at AS updated_at_68, t64.image1_active AS image1_active_69, t64.image1 AS image1_70, t64.image3alt AS image3alt_71, t64.field2_active AS field2_active_72, t64.title2 AS title2_73, t64.sub_title2 AS sub_title2_74, t64.text2 AS text2_75, t64.field3_active AS field3_active_76, t64.image3 AS image3_77, t64.image1alt AS image1alt_78, t64.title3 AS title3_79, t64.sub_title3 AS sub_title3_80, t64.text3 AS text3_81, t64.link3 AS link3_82, t64.button3 AS button3_83, t64.field4_active AS field4_active_84, t64.image4 AS image4_85, t64.image4alt AS image4alt_86, t64.title4 AS title4_87, t64.sub_title4 AS sub_title4_88, t64.text4 AS text4_89, t64.link4 AS link4_90, t64.button4 AS button4_91, t64.field5_active AS field5_active_92, t64.field6_active AS field6_active_93, t64.field8_active AS field8_active_94, t64.field9_active AS field9_active_95, t64.title9 AS title9_96, t64.brief9 AS brief9_97, t64.text9 AS text9_98, t64.field10_active AS field10_active_99, t64.product_id AS product_id_100, t101.id AS id_102, t101.image AS image_103, t101.alt AS alt_104, t101.link_type AS link_type_105, t101.link AS link_106, t101.updated_at AS updated_at_107, t101.sequence AS sequence_108, t101.carousel_id AS carousel_id_109, t101.product_id AS product_id_110, t101.product_group_id AS product_group_id_111, t101.product_category_id AS product_category_id_112 FROM product__product t0 LEFT JOIN product__promoted t40 ON t40.product_id = t0.id LEFT JOIN seo__seo t44 ON t44.product_id = t0.id LEFT JOIN seo__footer_product_menu t54 ON t54.product_id = t0.id LEFT JOIN product__description t64 ON t64.product_id = t0.id LEFT JOIN new_homepage__carousel_element t101 ON t101.product_id = t0.id WHERE t0.active = ? AND t0.temporarily_off = ? ORDER BY t0."sequence" DESC, t0.name ASC
Parameters:
[ 1 0 ] |
| 15 | 1.20 ms |
SELECT p0_.id AS id_0, p0_.content AS content_1, p0_.script AS script_2, p0_.size AS size_3, p0_.views AS views_4, p0_.days_between_view AS days_between_view_5, p0_.active_from AS active_from_6, p0_.active_to AS active_to_7, p0_.style AS style_8, p0_.only_for_logged_user AS only_for_logged_user_9 FROM popup p0_ INNER JOIN popup_popup_route p2_ ON p0_.id = p2_.popup_id INNER JOIN popup_route p1_ ON p1_.id = p2_.popup_route_id WHERE p0_.active_from <= ? AND p0_.active_to >= ? AND p1_.name = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ "2026-04-23" "2026-04-23" "product" ] |
| 16 | 2.53 ms |
SELECT t0.id AS id_1, t0.key AS key_2, t0.description AS description_3, t0.default_text AS default_text_4, t0.text AS text_5, t0.params AS params_6, t0.required AS required_7, t0.engine AS engine_8, t0.domain_identity AS domain_identity_9, t0.locked AS locked_10, t0.updated_at AS updated_at_11 FROM translation t0 WHERE t0.engine = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[
"VUE"
]
|
| 17 | 0.78 ms |
SELECT CURRENT_DATABASE()
Parameters:
[] |
| 18 | 3.80 ms |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_catalog = ? AND table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type = 'BASE TABLE' ORDER BY quote_ident(table_name)
Parameters:
[
"drukomat_dev"
]
|
| 19 | 0.58 ms |
SELECT current_schema()
Parameters:
[] |
| 20 | 0.53 ms |
SELECT CURRENT_DATABASE()
Parameters:
[] |
| 21 | 1.64 ms |
SELECT quote_ident(table_name) AS table_name, table_schema AS schema_name FROM information_schema.tables WHERE table_catalog = ? AND table_schema NOT LIKE 'pg\_%' AND table_schema != 'information_schema' AND table_name != 'geometry_columns' AND table_name != 'spatial_ref_sys' AND table_type = 'BASE TABLE' ORDER BY quote_ident(table_name)
Parameters:
[
"drukomat_dev"
]
|
| 22 | 7.32 ms |
SELECT n.nspname, c.relname, a.attname, t.typname, format_type(a.atttypid, a.atttypmod), bt.typname, format_type(bt.oid, t.typtypmod), a.attnotnull, a.attidentity, ( SELECT CASE WHEN a.attgenerated = 's' THEN NULL ELSE pg_get_expr(adbin, adrelid) END FROM pg_attrdef WHERE c.oid = pg_attrdef.adrelid AND pg_attrdef.adnum=a.attnum), dsc.description, CASE WHEN coll.collprovider = 'c' THEN coll.collcollate WHEN coll.collprovider = 'd' THEN NULL ELSE coll.collname END FROM pg_attribute a JOIN pg_class c ON c.oid = a.attrelid JOIN pg_namespace n ON n.oid = c.relnamespace JOIN pg_type t ON t.oid = a.atttypid LEFT JOIN pg_type bt ON t.typtype = 'd' AND bt.oid = t.typbasetype LEFT JOIN pg_collation coll ON coll.oid = a.attcollation LEFT JOIN pg_depend dep ON dep.objid = c.oid AND dep.deptype = 'e' AND dep.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class') LEFT JOIN pg_description dsc ON dsc.objoid = c.oid AND dsc.objsubid = a.attnum LEFT JOIN pg_inherits i ON i.inhrelid = c.oid LEFT JOIN pg_class p ON i.inhparent = p.oid AND p.relkind = 'p' WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys') AND a.attnum > 0 AND dep.refobjid IS NULL -- exclude partitions (tables that inherit from partitioned tables) AND p.oid IS NULL ORDER BY n.nspname, c.relname, a.attnum
Parameters:
[ "public" "migration_versions" ] |
| 23 | 1.36 ms |
SELECT n.nspname, c.relname, CASE c.relpersistence WHEN 'u' THEN true ELSE false END, obj_description(c.oid, 'pg_class') FROM pg_class c INNER JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys')
Parameters:
[ "public" "migration_versions" ] |
| 24 | 4.30 ms |
SELECT n.nspname, c.relname, ct.conname, a.attname FROM pg_namespace n INNER JOIN pg_class c ON c.relnamespace = n.oid INNER JOIN pg_constraint ct ON ct.conrelid = c.oid INNER JOIN pg_index i ON i.indrelid = c.oid AND i.indexrelid = ct.conindid INNER JOIN LATERAL unnest(i.indkey) WITH ORDINALITY AS keys(attnum, ord) ON true INNER JOIN pg_attribute a ON a.attrelid = c.oid AND a.attnum = keys.attnum WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys') AND ct.contype = 'p' ORDER BY n.nspname, c.relname, ct.conname, keys.ord
Parameters:
[ "public" "migration_versions" ] |
| 25 | 2.72 ms |
SELECT n.nspname, c.relname, ic.relname, i.indisunique, pg_get_expr(indpred, indrelid), attname FROM pg_index i JOIN pg_class AS c ON c.oid = i.indrelid JOIN pg_namespace n ON n.oid = c.relnamespace JOIN pg_class AS ic ON ic.oid = i.indexrelid JOIN LATERAL unnest(i.indkey) WITH ORDINALITY AS keys(attnum, ord) ON TRUE JOIN pg_attribute a ON a.attrelid = c.oid AND a.attnum = keys.attnum WHERE n.nspname = ? AND c.relname = ? AND n.nspname NOT LIKE 'pg\_%' AND n.nspname != 'information_schema' AND c.relkind IN ('r', 'p') AND c.relname NOT IN ('geometry_columns', 'spatial_ref_sys') AND i.indisprimary = false ORDER BY n.nspname, c.relname, ic.relname, keys.ord
Parameters:
[ "public" "migration_versions" ] |
| 26 | 5.63 ms |
SELECT pkn.nspname, pkc.relname, r.conname, fkn.nspname, fkc.relname, r.confupdtype, r.confdeltype, r.condeferrable, r.condeferred, pka.attname, fka.attname FROM pg_constraint r JOIN pg_class fkc ON fkc.oid = r.confrelid JOIN pg_namespace fkn ON fkn.oid = fkc.relnamespace JOIN unnest(r.confkey) WITH ORDINALITY AS fk_attnum(attnum, ord) ON TRUE JOIN pg_attribute fka ON fka.attrelid = fkc.oid AND fka.attnum = fk_attnum.attnum JOIN pg_class pkc ON pkc.oid = r.conrelid JOIN pg_namespace pkn ON pkn.oid = pkc.relnamespace JOIN unnest(r.conkey) WITH ORDINALITY AS pk_attnum(attnum, ord) ON pk_attnum.ord = fk_attnum.ord JOIN pg_attribute pka ON pka.attrelid = pkc.oid AND pka.attnum = pk_attnum.attnum WHERE pkn.nspname = ? AND pkc.relname = ? AND pkn.nspname NOT LIKE 'pg\_%' AND pkn.nspname != 'information_schema' AND pkc.relkind IN ('r', 'p') AND pkc.relname NOT IN ('geometry_columns', 'spatial_ref_sys') AND r.contype = 'f' ORDER BY pkn.nspname, pkc.relname, r.conname
Parameters:
[ "public" "migration_versions" ] |
| 27 | 0.89 ms |
SELECT * FROM migration_versions
Parameters:
[] |
| 28 | 0.84 ms |
SELECT CURRENT_DATABASE()
Parameters:
[] |
| 29 | 1.76 ms |
SELECT t0.id AS id_1, t0.style AS style_2, t0.name AS name_3, t0.slug AS slug_4, t0.active AS active_5, t0.sequence AS sequence_6, t0.grouping AS grouping_7, t0.description AS description_8, t9.id AS id_10, t9.type AS type_11, t9.title AS title_12, t9.name AS name_13, t9.sequence AS sequence_14, t9.product_id AS product_id_15, t9.category_id AS category_id_16, t9.group_id AS group_id_17, t18.id AS id_19, t18.image AS image_20, t18.alt AS alt_21, t18.link_type AS link_type_22, t18.link AS link_23, t18.updated_at AS updated_at_24, t18.sequence AS sequence_25, t18.carousel_id AS carousel_id_26, t18.product_id AS product_id_27, t18.product_group_id AS product_group_id_28, t18.product_category_id AS product_category_id_29 FROM product__category t0 LEFT JOIN seo__footer_product_menu t9 ON t9.category_id = t0.id LEFT JOIN new_homepage__carousel_element t18 ON t18.product_category_id = t0.id WHERE t0.active = ? ORDER BY t0.sequence ASC, t0.id ASC
Parameters:
[
1
]
|
| 30 | 33.33 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.temporarily_off AS temporarily_off_3, t0.amount_id AS amount_id_4, t0.slug AS slug_5, t0.link AS link_6, t0.name AS name_7, t0."sequence" AS sequence_8, t0.thumbnail AS thumbnail_9, t0.new_homepage_thumbnail AS new_homepage_thumbnail_10, t0.hover_thumbnail AS hover_thumbnail_11, t0.image AS image_12, t0.alt AS alt_13, t0.image_additional AS image_additional_14, t0.alt_additional AS alt_additional_15, t0.header AS header_16, t0.description AS description_17, t0.new_selector_main_image AS new_selector_main_image_18, t0.new_selector_main_image_alt AS new_selector_main_image_alt_19, t0.new_selector_amounts_image AS new_selector_amounts_image_20, t0.new_selector_amounts_image_alt AS new_selector_amounts_image_alt_21, t0.updated_at AS updated_at_22, t0.technical_specification AS technical_specification_23, t0.base_product_id AS base_product_id_24, t0.mockup AS mockup_25, t0.importance_level AS importance_level_26, t0.google_feed_default_product_id AS google_feed_default_product_id_27, t0.google_feed_description AS google_feed_description_28, t0.marketplace_code AS marketplace_code_29, t0.modal_title AS modal_title_30, t0.modal_link AS modal_link_31, t0.modal_content AS modal_content_32, t0.modal_enabled AS modal_enabled_33, t0.additional_content_field1 AS additional_content_field1_34, t0.additional_content_field2 AS additional_content_field2_35, t0.additional_content_field3 AS additional_content_field3_36, t0.additional_content_field4 AS additional_content_field4_37, t0.additional_content_field5 AS additional_content_field5_38, t0.group_id AS group_id_39, t40.id AS id_41, t40.amount_id AS amount_id_42, t40.product_id AS product_id_43, t44.id AS id_45, t44.type AS type_46, t44.pattern AS pattern_47, t44.title AS title_48, t44.h1 AS h1_49, t44.canonical AS canonical_50, t44.product_id AS product_id_51, t44.article_id AS article_id_52, t44.static_id AS static_id_53, t54.id AS id_55, t54.type AS type_56, t54.title AS title_57, t54.name AS name_58, t54.sequence AS sequence_59, t54.product_id AS product_id_60, t54.category_id AS category_id_61, t54.group_id AS group_id_62, t0.sticker_id AS sticker_id_63, t64.active AS active_65, t64.id AS id_66, t64.created_at AS created_at_67, t64.updated_at AS updated_at_68, t64.image1_active AS image1_active_69, t64.image1 AS image1_70, t64.image3alt AS image3alt_71, t64.field2_active AS field2_active_72, t64.title2 AS title2_73, t64.sub_title2 AS sub_title2_74, t64.text2 AS text2_75, t64.field3_active AS field3_active_76, t64.image3 AS image3_77, t64.image1alt AS image1alt_78, t64.title3 AS title3_79, t64.sub_title3 AS sub_title3_80, t64.text3 AS text3_81, t64.link3 AS link3_82, t64.button3 AS button3_83, t64.field4_active AS field4_active_84, t64.image4 AS image4_85, t64.image4alt AS image4alt_86, t64.title4 AS title4_87, t64.sub_title4 AS sub_title4_88, t64.text4 AS text4_89, t64.link4 AS link4_90, t64.button4 AS button4_91, t64.field5_active AS field5_active_92, t64.field6_active AS field6_active_93, t64.field8_active AS field8_active_94, t64.field9_active AS field9_active_95, t64.title9 AS title9_96, t64.brief9 AS brief9_97, t64.text9 AS text9_98, t64.field10_active AS field10_active_99, t64.product_id AS product_id_100, t101.id AS id_102, t101.image AS image_103, t101.alt AS alt_104, t101.link_type AS link_type_105, t101.link AS link_106, t101.updated_at AS updated_at_107, t101.sequence AS sequence_108, t101.carousel_id AS carousel_id_109, t101.product_id AS product_id_110, t101.product_group_id AS product_group_id_111, t101.product_category_id AS product_category_id_112 FROM product__product t0 LEFT JOIN product__promoted t40 ON t40.product_id = t0.id LEFT JOIN seo__seo t44 ON t44.product_id = t0.id LEFT JOIN seo__footer_product_menu t54 ON t54.product_id = t0.id LEFT JOIN product__description t64 ON t64.product_id = t0.id LEFT JOIN new_homepage__carousel_element t101 ON t101.product_id = t0.id INNER JOIN categories_products ON t0.id = categories_products.product_id WHERE categories_products.product_category_id = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 31 | 1.67 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.header AS header_3, t0.active AS active_4, t0."sequence" AS sequence_5, t0.thumbnail AS thumbnail_6, t0.new_homepage_thumbnail AS new_homepage_thumbnail_7, t0.hover_thumbnail AS hover_thumbnail_8, t0.slug AS slug_9, t0.updated_at AS updated_at_10, t0.description AS description_11, t12.id AS id_13, t12.type AS type_14, t12.title AS title_15, t12.name AS name_16, t12.sequence AS sequence_17, t12.product_id AS product_id_18, t12.category_id AS category_id_19, t12.group_id AS group_id_20, t0.sticker_id AS sticker_id_21, t22.id AS id_23, t22.image AS image_24, t22.alt AS alt_25, t22.link_type AS link_type_26, t22.link AS link_27, t22.updated_at AS updated_at_28, t22.sequence AS sequence_29, t22.carousel_id AS carousel_id_30, t22.product_id AS product_id_31, t22.product_group_id AS product_group_id_32, t22.product_category_id AS product_category_id_33 FROM product__group t0 LEFT JOIN seo__footer_product_menu t12 ON t12.group_id = t0.id LEFT JOIN new_homepage__carousel_element t22 ON t22.product_group_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
| 32 | 2.64 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.temporarily_off AS temporarily_off_3, t0.amount_id AS amount_id_4, t0.slug AS slug_5, t0.link AS link_6, t0.name AS name_7, t0."sequence" AS sequence_8, t0.thumbnail AS thumbnail_9, t0.new_homepage_thumbnail AS new_homepage_thumbnail_10, t0.hover_thumbnail AS hover_thumbnail_11, t0.image AS image_12, t0.alt AS alt_13, t0.image_additional AS image_additional_14, t0.alt_additional AS alt_additional_15, t0.header AS header_16, t0.description AS description_17, t0.new_selector_main_image AS new_selector_main_image_18, t0.new_selector_main_image_alt AS new_selector_main_image_alt_19, t0.new_selector_amounts_image AS new_selector_amounts_image_20, t0.new_selector_amounts_image_alt AS new_selector_amounts_image_alt_21, t0.updated_at AS updated_at_22, t0.technical_specification AS technical_specification_23, t0.base_product_id AS base_product_id_24, t0.mockup AS mockup_25, t0.importance_level AS importance_level_26, t0.google_feed_default_product_id AS google_feed_default_product_id_27, t0.google_feed_description AS google_feed_description_28, t0.marketplace_code AS marketplace_code_29, t0.modal_title AS modal_title_30, t0.modal_link AS modal_link_31, t0.modal_content AS modal_content_32, t0.modal_enabled AS modal_enabled_33, t0.additional_content_field1 AS additional_content_field1_34, t0.additional_content_field2 AS additional_content_field2_35, t0.additional_content_field3 AS additional_content_field3_36, t0.additional_content_field4 AS additional_content_field4_37, t0.additional_content_field5 AS additional_content_field5_38, t0.group_id AS group_id_39, t40.id AS id_41, t40.amount_id AS amount_id_42, t40.product_id AS product_id_43, t44.id AS id_45, t44.type AS type_46, t44.pattern AS pattern_47, t44.title AS title_48, t44.h1 AS h1_49, t44.canonical AS canonical_50, t44.product_id AS product_id_51, t44.article_id AS article_id_52, t44.static_id AS static_id_53, t54.id AS id_55, t54.type AS type_56, t54.title AS title_57, t54.name AS name_58, t54.sequence AS sequence_59, t54.product_id AS product_id_60, t54.category_id AS category_id_61, t54.group_id AS group_id_62, t0.sticker_id AS sticker_id_63, t64.active AS active_65, t64.id AS id_66, t64.created_at AS created_at_67, t64.updated_at AS updated_at_68, t64.image1_active AS image1_active_69, t64.image1 AS image1_70, t64.image3alt AS image3alt_71, t64.field2_active AS field2_active_72, t64.title2 AS title2_73, t64.sub_title2 AS sub_title2_74, t64.text2 AS text2_75, t64.field3_active AS field3_active_76, t64.image3 AS image3_77, t64.image1alt AS image1alt_78, t64.title3 AS title3_79, t64.sub_title3 AS sub_title3_80, t64.text3 AS text3_81, t64.link3 AS link3_82, t64.button3 AS button3_83, t64.field4_active AS field4_active_84, t64.image4 AS image4_85, t64.image4alt AS image4alt_86, t64.title4 AS title4_87, t64.sub_title4 AS sub_title4_88, t64.text4 AS text4_89, t64.link4 AS link4_90, t64.button4 AS button4_91, t64.field5_active AS field5_active_92, t64.field6_active AS field6_active_93, t64.field8_active AS field8_active_94, t64.field9_active AS field9_active_95, t64.title9 AS title9_96, t64.brief9 AS brief9_97, t64.text9 AS text9_98, t64.field10_active AS field10_active_99, t64.product_id AS product_id_100, t101.id AS id_102, t101.image AS image_103, t101.alt AS alt_104, t101.link_type AS link_type_105, t101.link AS link_106, t101.updated_at AS updated_at_107, t101.sequence AS sequence_108, t101.carousel_id AS carousel_id_109, t101.product_id AS product_id_110, t101.product_group_id AS product_group_id_111, t101.product_category_id AS product_category_id_112 FROM product__product t0 LEFT JOIN product__promoted t40 ON t40.product_id = t0.id LEFT JOIN seo__seo t44 ON t44.product_id = t0.id LEFT JOIN seo__footer_product_menu t54 ON t54.product_id = t0.id LEFT JOIN product__description t64 ON t64.product_id = t0.id LEFT JOIN new_homepage__carousel_element t101 ON t101.product_id = t0.id WHERE t0.group_id = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 33 | 1.06 ms |
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.temporarily_off AS temporarily_off_2, p0_.amount_id AS amount_id_3, p0_.slug AS slug_4, p0_.link AS link_5, p0_.name AS name_6, p0_."sequence" AS sequence_7, p0_.thumbnail AS thumbnail_8, p0_.new_homepage_thumbnail AS new_homepage_thumbnail_9, p0_.hover_thumbnail AS hover_thumbnail_10, p0_.image AS image_11, p0_.alt AS alt_12, p0_.image_additional AS image_additional_13, p0_.alt_additional AS alt_additional_14, p0_.header AS header_15, p0_.description AS description_16, p0_.new_selector_main_image AS new_selector_main_image_17, p0_.new_selector_main_image_alt AS new_selector_main_image_alt_18, p0_.new_selector_amounts_image AS new_selector_amounts_image_19, p0_.new_selector_amounts_image_alt AS new_selector_amounts_image_alt_20, p0_.updated_at AS updated_at_21, p0_.technical_specification AS technical_specification_22, p0_.base_product_id AS base_product_id_23, p0_.mockup AS mockup_24, p0_.importance_level AS importance_level_25, p0_.google_feed_default_product_id AS google_feed_default_product_id_26, p0_.google_feed_description AS google_feed_description_27, p0_.marketplace_code AS marketplace_code_28, p0_.modal_title AS modal_title_29, p0_.modal_link AS modal_link_30, p0_.modal_content AS modal_content_31, p0_.modal_enabled AS modal_enabled_32, p0_.additional_content_field1 AS additional_content_field1_33, p0_.additional_content_field2 AS additional_content_field2_34, p0_.additional_content_field3 AS additional_content_field3_35, p0_.additional_content_field4 AS additional_content_field4_36, p0_.additional_content_field5 AS additional_content_field5_37, p0_.group_id AS group_id_38, p0_.sticker_id AS sticker_id_39 FROM product__product p0_ WHERE p0_.marketplace_code = ? AND p0_.active = true LIMIT 1
Parameters:
[
"macma"
]
|
| 34 | 1.11 ms |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.description AS description_2, i0_.active AS active_3, i0_.background_hex AS background_hex_4, i0_.font_hex AS font_hex_5 FROM info_bar i0_ WHERE i0_.active = ?
Parameters:
[
true
]
|
| 35 | 0.72 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.name AS name_4, t0.sequence AS sequence_5, t0.product_id AS product_id_6, t0.category_id AS category_id_7, t0.group_id AS group_id_8 FROM seo__footer_product_menu t0 ORDER BY t0.sequence ASC, t0.id ASC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Product | 2498 |
| App\Entity\ProductDescription | 16 |
| App\Entity\BlogArticle | 10 |
| App\Entity\NewHomepageSectionCarousel | 2 |
| App\Entity\NewHomepageSectionBanner | 2 |
| App\Entity\BlogCategory | 2 |
| App\Entity\ProductPromoted | 2 |
| App\Entity\ProductIndustry | 1 |
| App\Entity\NewHomepage | 1 |
| App\Entity\Slider | 1 |
| App\Entity\NewHomepageSectionInspirations | 1 |
| App\Entity\ProductGroup | 1 |
| App\Entity\Translation | 1 |
| App\Entity\ProductCategory | 1 |