Query Metrics
50
Database Queries
12
Different statements
18.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.99 ms (22.10%) |
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.19 ms (17.62%) |
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.86 ms (15.82%) |
6 |
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:
[
351743
]
|
|
2.70 ms (14.95%) |
7 |
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:
[
47
]
|
|
2.05 ms (11.33%) |
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.89 ms (4.90%) |
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:
[
"b42e516c-3f48-44e7-86b2-77d51858e613"
]
|
|
0.64 ms (3.54%) |
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:
[
28134
]
|
|
0.40 ms (2.21%) |
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.38 ms (2.08%) |
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:
[
24639
]
|
|
0.35 ms (1.95%) |
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:
[
52435
]
|
|
0.32 ms (1.78%) |
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:
[
"44"
]
|
|
0.31 ms (1.73%) |
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:
[
52435
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Offer\Offer | No errors. |
| App\Entity\Offer\OfferCompany | No errors. |
| App\Entity\Package\Package | No errors. |
| App\Entity\Order\Orders | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\Offer\OfferItem | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\Offer\OfferLinkList | No errors. |
| App\Entity\SharedOffer | No errors. |
| App\Entity\InvoiceData | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Item\Item | No errors. |
| App\Entity\Item\ItemCategory | No errors. |
| App\Entity\Another | No errors. |
| App\Entity\JobLevel | No errors. |
| App\Entity\Search\SearchTechnology | No errors. |
| App\Entity\SeoIndustry | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\Search\SearchIndustry | No errors. |
| App\Entity\FooterLink | No errors. |
| App\Entity\Page\Page | No errors. |
| App\Entity\Page\PageTranslation | No errors. |