NYOMKÖVETÉS (string) «{modul:page}»
INCLUDE MODUL: hirdeto_userbox CALL: Andrea\Plugins\Hirdeto\Hirdeto::modul_hirdeto_userbox
INCLUDE MODUL: main_header CALL: Andrea\Plugins\MainBody\MainBody::modul_main_header
INCLUDE MODUL: sharing CALL: Andrea\Plugins\MainBody\MainBody::modul_sharing
INCLUDE MODUL: breadcumb_area CALL: Andrea\Plugins\MainBody\MainBody::modul_breadcumb_area
INCLUDE MODUL: page CALL: Andrea\Core\Page::modul_page
INCLUDE MODUL: browser_alert CALL: Andrea\Plugins\MainBody\MainBody::modul_browser_alert
(string) «Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)»
INCLUDE MODUL: reg_ajanlo CALL: Andrea\Plugins\MainBody\MainBody::modul_reg_ajanlo
INCLUDE MODUL: kiemelt_partnerek CALL: Andrea\Plugins\MainBody\MainBody::modul_kiemelt_partnerek
INCLUDE MODUL: frequented_searches CALL: Andrea\Plugins\MainBody\MainBody::modul_frequented_searches
INCLUDE MODUL: main_page:5 CALL: Andrea\Plugins\MainBody\MainBody::modul_main_page
INCLUDE MODUL: szakmai_cikkek CALL: Andrea\Plugins\MainBody\MainBody::modul_szakmai_cikkek
INCLUDE MODUL: rolunk_mondtak CALL: Andrea\Plugins\MainBody\MainBody::modul_rolunk_mondtak
INCLUDE MODUL: gmap_script CALL: Andrea\Plugins\MainBody\MainBody::modul_gmap_script
(array) array (
'THEME' =>
\Andrea\Core\Theme::__set_state(array(
'inner_modules' =>
array (
),
'template' => NULL,
'items' => NULL,
'props' =>
array (
'id' => 1,
'is_system' => 1,
'title' => 'hrport',
'template_path' => '/templates/km',
'date_create' => 1216102698,
'date_modify' => 1595912076,
'user_create_id' => 1,
'user_modify_id' => 19078,
),
)),
'PAGE' =>
\Andrea\Core\Page::__set_state(array(
'inner_modules' =>
array (
),
'template' => '<section>
<div class="container page">
{this>description}
</div>
</section>
',
'items' => NULL,
'props' =>
array (
'id' => 1,
'domain_id' => 5,
'is_system' => 1,
'parent_id' => 0,
'title' => 'Nyitólap',
'image' => '',
'quote' => '',
'description' => '<p>{modul:preferred_adverts}</p>',
'meta_keywords' => 'állás, álláskeresés, toborzás, munkaerőpiac, karrier',
'meta_description' => 'A HR112 több mint egy állásportál.',
'date_publish' => 0,
'link' => '',
'permalink' => '',
'bearing' => 9,
'refered_page_ids' => '',
'theme_id' => 1,
'option_mainmenu' => 1,
'option_submenu' => 0,
'option_basemenu' => 1,
'date_create' => 1149631361,
'date_modify' => 1644294472,
'user_create_id' => 1,
'user_modify_id' => 19078,
'level' => 0,
'level_class' => 'level0',
'option_collapse' => '',
'publish_date' => '',
'hide_date' => '2026. November 8., Sunday',
'create_date' => '2006. June 7., Wednesday',
'modify_date' => '2022. February 8., Tuesday',
'command' => 'https://new.hr112.eu',
'url' => 'https://new.hr112.eu',
'is_selected' => true,
'class_selected' => 'active',
'option_selected' => 'selected="selected"',
'checked_selected' => 'checked="checked"',
),
'roots' =>
array (
0 => 1,
1 => 0,
),
)),
'SVN' => '1',
'TITLE' => 'Nyitólap',
'META_KEYWORDS' => 'állás, álláskeresés, toborzás, munkaerőpiac, karrier',
'META_DESCRIPTION' => 'A HR112 több mint egy állásportál.',
'META_DECRIPTION' => 'A HR112 több mint egy állásportál.',
)
INCLUDE MODUL: preferred_adverts CALL: Andrea\Plugins\Hirdetes\Hirdetes::modul_preferred_adverts
MUNKAMENET VÁLTOZÓ array (
'SID' => '102a62c84906db89f275a4fc9c66bacf',
'user' => 'O:16:"Andrea\Core\User":5:{s:13:"inner_modules";a:0:{}s:8:"template";s:0:"";s:5:"items";N;s:8:"' . "{debug_info}" . '*' . "{debug_info}" . 'props";a:1:{s:7:"message";s:0:"";}s:8:"login_ok";b:0;}',
'lang' => 'hu',
'currency' => 'huf',
'C' => 'N',
'O' => 'D',
'a' => '',
'template_path' => '/templates/km',
'p' => '1',
) KIKÜLDÖTT SQL KÉRÉSEK PDO connected to localhost.
SET SESSION `character_set_client` = 'utf8' (0 sor: 0.0002 mp/0.0002 mp)
SET SESSION `character_set_connection` = 'utf8' (0 sor: 0.0001 mp/0.0003 mp)
SET SESSION `character_set_database` = 'utf8' (0 sor: 0.0001 mp/0.0004 mp)
SET SESSION `character_set_filesystem` = 'utf8' (0 sor: 0.0001 mp/0.0005 mp)
SET SESSION `character_set_results` = 'utf8' (0 sor: 0.0001 mp/0.0006 mp)
SET SESSION `character_set_server` = 'utf8' (0 sor: 0.0001 mp/0.0006 mp)
SET SESSION `collation_connection` = 'utf8_hungarian_ci' (0 sor: 0.0001 mp/0.0008 mp)
SET SESSION `collation_database` = 'utf8_hungarian_ci' (0 sor: 0.0000 mp/0.0008 mp)
SET SESSION `collation_server` = 'utf8_hungarian_ci' (0 sor: 0.0000 mp/0.0008 mp)
SET SESSION `group_concat_max_len` = 512 (0 sor: 0.0000 mp/0.0008 mp)
SELECT * FROM `ap_core_plugin`
WHERE `domain_id` = ? AND `option_active`=1
ORDER BY `depend_nums` ASC (9 sor: 0.0000 mp/0.0009 mp)
SELECT `name`,`value` FROM `ap_core_param` WHERE domain_id = ? (39 sor: 0.0000 mp/0.0009 mp)
SELECT `name`,`value` FROM `ap_core_lang` WHERE domain_id = ? (13 sor: 0.0000 mp/0.0009 mp)
SELECT `theme_id` FROM `ap_core_domain` WHERE `id`=5 (1 sor: 0.0000 mp/0.0009 mp)
SELECT * FROM `ap_core_theme` WHERE (`id`=1) LIMIT 1 (1 sor: 0.0000 mp/0.0010 mp)
SELECT * FROM `ap_core_page` WHERE (`id`=1) LIMIT 1 (1 sor: 0.0000 mp/0.0010 mp)
SELECT * FROM ap_core_pagelist WHERE url = '/?C=N&O=D' (0 sor: 0.0014 mp/0.0024 mp)
Select
a.id,
a.title,
a.short_description,
a.enabled,
DATE_FORMAT(from_unixtime(a.release_date), '%Y.%m.%d') as release_date,
a.reference_number,
a.outer_advert,
a.inner_advert,
a.video_interview,
a.user_id,
a.region_id,
r.title as region_title,
a.nature_of_employment_id,
fj.title as nature_of_employment_title,
a.information,
a.user_create_id,
u.name as user_name,
u.shown_company,
u.contact_name,
u.contact_email,
u.contact_phone,
u.user_category_id,
a.date_create,
a.date_modify,
a.user_modify_id,
u.logo_url,
u1.name as user_modify_name,
from_unixtime(a.date_create) as date_create_readable,
from_unixtime(a.date_modify) as date_modify_readable,
a.original_id,
a.youtube,
a.start_date,
a.professional_experience_id,
pf.title as professional_experience_title,
a.education_id,
ev.title as education_title,
a.category_id,
ac.title as category_title,
a.work_schedules_id,
ws.title as work_schedules_title,
a.driving_licence_ids,
group_concat(dl.title) as driving_licence_title,
a.video_link,
a.letter_level_id,
a.parent_advert_id,
a.recruitment_area,
DATE_FORMAT(DATE_ADD(from_unixtime(a.release_date), INTERVAL a.running_days - a.views DAY), '%Y.%m.%d') as expiration_date
from ap_allasajanlat_fej a join ap_regions_full r on r.id = a.region_id
left outer join ap_allasajanlat_foglalakoztatas_jellege fj on fj.id = a.nature_of_employment_id
left outer join ap_users u on u.id = a.user_id
left outer join ap_users u1 on u1.id = a.user_modify_id
left outer join ap_torzs_hirdetes_szakmai_tapasztalat pf on pf.id = a.professional_experience_id
left outer join ap_torzs_hirdetes_elvart_vegzettseg ev on ev.id = a.education_id
left outer join ap_torzs_hirdetes_alkategoria ac on ac.id = a.category_id
left outer join ap_allasajanlat_munkarend ws on ws.id = a.work_schedules_id
left outer join ap_torzs_jogositvany dl on FIND_IN_SET(dl.id, a.driving_licence_ids)!=0
WHERE 1=1
and a.enabled = 1 and a.approved = 1 and a.views <= a.running_days
and FIND_IN_SET(1, a.extras_option_ids)!=0
group by
a.id,
a.title,
a.short_description,
a.enabled,
a.release_date,
a.reference_number,
a.outer_advert,
a.inner_advert,
a.video_interview,
a.user_id,
a.region_id,
r.title,
a.nature_of_employment_id,
a.information,
a.user_create_id,
u.name,
u.shown_company,
u.contact_name,
u.contact_email,
u.contact_phone,
a.date_create,
a.date_modify,
a.user_modify_id,
u1.name,
a.original_id,
a.youtube,
a.start_date,
a.professional_experience_id,
pf.title,
a.education_id,
ev.title,
a.category_id,
ac.title,
a.work_schedules_id,
ws.title,
a.driving_licence_ids,
a.video_link,
a.letter_level_id,
a.parent_advert_id,
a.recruitment_area
order by list_views
limit 0,16 (0 sor: 0.0002 mp/0.0026 mp)
FUTÁSI IDŐK SQL: 0.0026 mp
Oldal: 0.0050 mp
