GET https://ipopema.bloomnet.pl/oferty-pracy/konsultant-sap-co-zespol-wdrozeniowy

Query Metrics

17 Database Queries
8 Different statements
3.82 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.96 ms
(25.07%)
6
SELECT t0.id AS id_1, t0.hash_id AS hash_id_2, t0.lang AS lang_3, t0.content AS content_4, t0.location AS location_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM editable_blocks t0 WHERE t0.hash_id = ? AND t0.lang = ? AND t0.location = ? LIMIT 1
Parameters:
[
  "b33388c3ad5b"
  "pl"
  "/oferty-pracy/konsultant-sap-co-zespol-wdrozeniowy"
]
0.83 ms
(21.68%)
3
SELECT m0_.lang AS lang_0, m0_.id AS id_1, m0_.label AS label_2, m0_.url AS url_3, m0_.seo_title AS seo_title_4, m0_.seo_description AS seo_description_5, m0_.seo_keywords AS seo_keywords_6, m0_.enabled AS enabled_7, m0_.position AS position_8, m0_.icon AS icon_9, m0_.parent_id AS parent_id_10 FROM menu_item m0_ WHERE m0_.lang = ? ORDER BY m0_.parent_id ASC, m0_.position ASC
Parameters:
[
  "pl"
]
0.57 ms
(14.95%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.job_list_id AS job_list_id_3 FROM job_list_items t0 WHERE t0.job_list_id = ?
Parameters:
[
  133
]
0.36 ms
(9.32%)
1
SELECT count(j0_.id) AS sclr_0 FROM job_offers j0_ WHERE j0_.active = ? AND j0_.lang LIKE ? AND j0_.job_position_id = ? AND j0_.id <> ?
Parameters:
[
  1
  "pl"
  4
  45
]
0.32 ms
(8.40%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.place AS place_3, t0.specialization AS specialization_4, t0.main_site AS main_site_5, t0.active AS active_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.other_meta_tags AS other_meta_tags_11, t0.lang AS lang_12, t0.created_at AS created_at_13, t0.updatedAt AS updatedAt_14, t0.job_position_id AS job_position_id_15 FROM job_offers t0 WHERE t0.lang = ? AND t0.active = ? AND t0.slug = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[
  "pl"
  1
  "konsultant-sap-co-zespol-wdrozeniowy"
]
0.30 ms
(7.93%)
1
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.place AS place_2, j0_.specialization AS specialization_3, j0_.main_site AS main_site_4, j0_.active AS active_5, j0_.slug AS slug_6, j0_.meta_title AS meta_title_7, j0_.meta_keywords AS meta_keywords_8, j0_.meta_description AS meta_description_9, j0_.other_meta_tags AS other_meta_tags_10, j0_.lang AS lang_11, j0_.created_at AS created_at_12, j0_.updatedAt AS updatedAt_13, j0_.job_position_id AS job_position_id_14 FROM job_offers j0_ WHERE j0_.id <> ? AND j0_.active = ? AND j0_.lang LIKE ? AND j0_.job_position_id = ? ORDER BY j0_.created_at DESC LIMIT 2
Parameters:
[
  45
  1
  "pl"
  4
]
0.26 ms
(6.78%)
1
SELECT t0.lang AS lang_1, t0.id AS id_2, t0.label AS label_3, t0.url AS url_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.enabled AS enabled_8, t0.position AS position_9, t0.icon AS icon_10, t0.parent_id AS parent_id_11 FROM menu_item t0 WHERE t0.url = ? AND t0.lang = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "/oferty-pracy/konsultant-sap-co-zespol-wdrozeniowy"
  "pl"
  1
]
0.22 ms
(5.87%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.job_offer_id AS job_offer_id_3 FROM job_lists t0 WHERE t0.job_offer_id = ?
Parameters:
[
  45
]

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\JobOffer No errors.
App\Entity\JobPosition No errors.
App\Entity\JobList No errors.
App\Entity\MenuItem No errors.
App\Entity\JobListItem No errors.
App\Entity\EditableBlock No errors.