https://test.inzynio.pl/pl/oferta/a8986879-9946-46ec-b7ae-e6a73cdeaea2/kosztorysant-instalacji-elektrycznych

Query Metrics

57 Database Queries
13 Different statements
17.02 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
3.62 ms
(21.24%)
13
SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM PAGE t0 WHERE t0.migration_id = ? LIMIT 1
Parameters:
[
  1
]
3.13 ms
(18.40%)
9
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.approved AS approved_5, t0.second_level AS second_level_6, t0.third_level AS third_level_7, t0.can_be_nice_to_have AS can_be_nice_to_have_8, t0.type AS type_9, t0.salary AS salary_10, t0.placeholder AS placeholder_11, t0.use_count AS use_count_12, t0.search_slug AS search_slug_13, t0.can_show AS can_show_14, t0.id AS id_15 FROM item t0 INNER JOIN offer_item_item ON t0.id = offer_item_item.item_id WHERE offer_item_item.offer_item_id = ?
Parameters:
[
  352755
]
2.84 ms
(16.66%)
10
SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.displayed_description AS displayed_description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
2.81 ms
(16.50%)
10
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.info AS info_4, t0.field_type AS field_type_5, t0.can_be_nice_to_have AS can_be_nice_to_have_6, t0.category_type AS category_type_7, t0.required AS required_8, t0.placeholder AS placeholder_9, t0.can_enter_own AS can_enter_own_10, t0.translation AS translation_11, t0.show_can_nice_to_be_have_button AS show_can_nice_to_be_have_button_12, t0.active AS active_13, t0.is_name_offer AS is_name_offer_14, t0.is_level_offer AS is_level_offer_15, t0.search_slug AS search_slug_16, t0.field_type_view AS field_type_view_17, t0.is_technology AS is_technology_18, t0.item_quantity AS item_quantity_19, t0.position AS position_20, t0.show_label AS show_label_21, t0.id AS id_22, t0.item_category_id AS item_category_id_23, t0.seo_industry_id AS seo_industry_id_24 FROM item_category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  142
]
1.81 ms
(10.63%)
7
SELECT t0.migration_id AS migration_id_1, t0.template_path AS template_path_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.blog_id AS blog_id_6, t0.footer_link_id AS footer_link_id_7 FROM PAGE t0 WHERE t0.footer_link_id = ? LIMIT 1
Parameters:
[
  "12"
]
0.69 ms
(4.07%)
1
SELECT o0_.search_params AS search_params_0, o0_.offer_name_pl AS offer_name_pl_1, o0_.offer_name_en AS offer_name_en_2, o0_.offer_level_pl AS offer_level_pl_3, o0_.offer_level_en AS offer_level_en_4, o0_.published_at AS published_at_5, o0_.boost_date AS boost_date_6, o0_.active_until AS active_until_7, o0_.update_insteps AS update_insteps_8, o0_.short_offer_code AS short_offer_code_9, o0_.creator AS creator_10, o0_.language AS language_11, o0_.number_of_insteps AS number_of_insteps_12, o0_.keywords AS keywords_13, o0_.visible AS visible_14, o0_.temporary_id AS temporary_id_15, o0_.done AS done_16, o0_.active AS active_17, o0_.step AS step_18, o0_.email AS email_19, o0_.category_id AS category_id_20, o0_.number_of_application AS number_of_application_21, o0_.access_key AS access_key_22, o0_.salary_data AS salary_data_23, o0_.work_data AS work_data_24, o0_.id AS id_25, o0_.created_at AS created_at_26, o0_.updated_at AS updated_at_27, o0_.offer_company_id AS offer_company_id_28, o0_.package_id AS package_id_29, o0_.offer_id AS offer_id_30, o0_.order_id AS order_id_31, o0_.user_id AS user_id_32 FROM offer o0_ WHERE o0_.temporary_id = ?
Parameters:
[
  "a8986879-9946-46ec-b7ae-e6a73cdeaea2"
]
0.39 ms
(2.27%)
1
SELECT t0.id AS id_1, t0.name_pl AS name_pl_2, t0.name_en AS name_en_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.content_pl AS content_pl_6, t0.content_en AS content_en_7, t0.url_pl AS url_pl_8, t0.url_en AS url_en_9, t0.page_id AS page_id_10 FROM footer_link t0
Parameters:
[]
0.37 ms
(2.14%)
1
SELECT t0.nice_to_have_button AS nice_to_have_button_1, t0.text AS text_2, t0.second_level AS second_level_3, t0.third_level AS third_level_4, t0.nice_to_have AS nice_to_have_5, t0.category_type AS category_type_6, t0.item_category_id AS item_category_id_7, t0.field_type AS field_type_8, t0.offer_item_name_pl AS offer_item_name_pl_9, t0.offer_item_name_en AS offer_item_name_en_10, t0.is_name_offer AS is_name_offer_11, t0.is_level_offer AS is_level_offer_12, t0.field_type_view AS field_type_view_13, t0.show_label AS show_label_14, t0.id AS id_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.offer_id AS offer_id_18 FROM offer_item t0 WHERE t0.offer_id = ?
Parameters:
[
  28223
]
0.34 ms
(1.99%)
1
SELECT t0.phone_number AS phone_number_1, t0.website_url AS website_url_2, t0.number_of_employers AS number_of_employers_3, t0.description AS description_4, t0.is_extra_invoice_data AS is_extra_invoice_data_5, t0.is_external_applications AS is_external_applications_6, t0.source_for_the_external_application AS source_for_the_external_application_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.invoice_data_id AS invoice_data_id_11, t0.extra_invoice_data_id AS extra_invoice_data_id_12, t0.logo_id AS logo_id_13 FROM offer_company t0 WHERE t0.id = ?
Parameters:
[
  24722
]
0.29 ms
(1.71%)
1
SELECT t0.file_name AS file_name_1, t0.original_file_name AS original_file_name_2, t0.extension AS extension_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.invoice_id AS invoice_id_6, t0.id AS id_7, t0.blog_id AS blog_id_8 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  37271
]
0.28 ms
(1.65%)
1
SELECT t0.vat_id AS vat_id_1, t0.name AS name_2, t0.email AS email_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.address_id AS address_id_7 FROM invoice_data t0 WHERE t0.id = ?
Parameters:
[
  52607
]
0.27 ms
(1.58%)
1
SELECT t0.seo_right_block_pl AS seo_right_block_pl_1, t0.seo_left_block_pl AS seo_left_block_pl_2, t0.seo_right_block_en AS seo_right_block_en_3, t0.seo_left_block_en AS seo_left_block_en_4, t0.id_industry AS id_industry_5, t0.id AS id_6 FROM seo_industry t0 WHERE t0.id_industry = ? LIMIT 1
Parameters:
[
  "2"
]
0.20 ms
(1.16%)
1
SELECT t0.address AS address_1, t0.post_code AS post_code_2, t0.city AS city_3, t0.country AS country_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM address t0 WHERE t0.id = ?
Parameters:
[
  52607
]

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.