| 1 |
0.40 ms |
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
"programista-abap"
]
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 = 'pl' AND t0.active = 1 AND t0.slug = 'programista-abap' ORDER BY t0.created_at DESC LIMIT 1;
|
| 2 |
0.36 ms |
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"
2
3
]
SELECT count(j0_.id) AS sclr_0 FROM job_offers j0_ WHERE j0_.active = 1 AND j0_.lang LIKE 'pl' AND j0_.job_position_id = 2 AND j0_.id <> 3;
|
| 3 |
0.24 ms |
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: [
3
1
"pl"
2
]
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 <> 3 AND j0_.active = 1 AND j0_.lang LIKE 'pl' AND j0_.job_position_id = 2 ORDER BY j0_.created_at DESC LIMIT 2;
|
| 4 |
0.26 ms |
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/programista-abap"
"pl"
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 = '/oferty-pracy/programista-abap' AND t0.lang = 'pl' AND t0.enabled = 1 LIMIT 1;
|
| 5 |
0.28 ms |
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
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 = 'pl' ORDER BY m0_.parent_id ASC, m0_.position ASC;
|
| 6 |
0.26 ms |
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
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 = 'pl' ORDER BY m0_.parent_id ASC, m0_.position ASC;
|
| 7 |
0.26 ms |
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
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 = 'pl' ORDER BY m0_.parent_id ASC, m0_.position ASC;
|
| 8 |
0.24 ms |
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 = ?
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 = 3;
|
| 9 |
0.53 ms |
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 = ?
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 = 7;
|
| 10 |
0.33 ms |
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 = ?
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 = 8;
|
| 11 |
0.14 ms |
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 = ?
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 = 9;
|
| 12 |
0.21 ms |
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/programista-abap"
]
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 = 'b33388c3ad5b' AND t0.lang = 'pl' AND t0.location = '/oferty-pracy/programista-abap' LIMIT 1;
|
| 13 |
0.19 ms |
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: [
"bfa708a8fb7d"
"pl"
"/oferty-pracy/programista-abap"
]
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 = 'bfa708a8fb7d' AND t0.lang = 'pl' AND t0.location = '/oferty-pracy/programista-abap' LIMIT 1;
|
| 14 |
0.19 ms |
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: [
"8a3f1583ca10"
"pl"
"/oferty-pracy/programista-abap"
]
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 = '8a3f1583ca10' AND t0.lang = 'pl' AND t0.location = '/oferty-pracy/programista-abap' LIMIT 1;
|
| 15 |
0.16 ms |
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: [
"8f9c5da98c7e"
"pl"
"/oferty-pracy/programista-abap"
]
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 = '8f9c5da98c7e' AND t0.lang = 'pl' AND t0.location = '/oferty-pracy/programista-abap' LIMIT 1;
|
| 16 |
0.16 ms |
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: [
"c5b3f5d1011e"
"pl"
"/oferty-pracy/programista-abap"
]
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 = 'c5b3f5d1011e' AND t0.lang = 'pl' AND t0.location = '/oferty-pracy/programista-abap' LIMIT 1;
|
| 17 |
0.15 ms |
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: [
"9d296aaf2e78"
"pl"
"/oferty-pracy/programista-abap"
]
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 = '9d296aaf2e78' AND t0.lang = 'pl' AND t0.location = '/oferty-pracy/programista-abap' LIMIT 1;
|