Válasszon az alábbi kategóriák közül, majd kattintson a nagyító ikonra!
Műfaj szerint217 query futott le 0.20164704322815 másodperc alatt
Array
(
[query] => SELECT * FROM core_route WHERE ( route_friendly_url = 'tanfolyamok/szakkorok' ) ORDER BY route_id DESC LIMIT 0, 1
[begin] => 1766185212.6983
[end] => 1766185212.7017
[time] => 0.0034520626068115
)
Array
(
[query] => SELECT
program_extended_program_basic_id,
program_basic_id,
category_relation_foreign_id,
category_relation_type,
category_relation_category_id,
program_basic_description,
program_basic_short_description,
category_id,
program_basic_title,
program_basic_short_title,
program_location_relation_program_extended_id,
program_extended_id,
program_location_relation_location_id,
location_id,
program_extended_start_date,
program_extended_end_date,
program_extended_start_time,
program_extended_end_time,
STR_TO_DATE(CONCAT(CAST(program_extended_start_date AS CHAR), " ", program_extended_start_time, ":00"), "%Y-%m-%d %H:%i:%s") AS "date",
STR_TO_DATE(CONCAT(CAST(program_extended_start_date AS CHAR), " ", program_extended_start_time, ":00"), "%Y-%m-%d %H:%i:%s") AS "start_date",
STR_TO_DATE(CONCAT(CAST(program_extended_end_date AS CHAR), " ", program_extended_end_time, ":00"), "%Y-%m-%d %H:%i:%s") AS "end_date",
program_basic_hide_date,
mod_program_extended.program_extended_delete_user_id,
mod_program_basic.program_basic_delete_user_id
FROM mod_program_basic LEFT JOIN mod_program_extended ON ( program_extended_program_basic_id = program_basic_id ) JOIN mod_category_relation ON ( category_relation_foreign_id = program_extended_program_basic_id AND category_relation_type='mod_program_basic' ) JOIN core_category ON ( category_relation_category_id = category_id ) LEFT JOIN mod_program_location_relation ON ( program_location_relation_program_extended_id = program_extended_id ) LEFT JOIN mod_location ON ( program_location_relation_location_id = location_id ) WHERE ( IFNULL(mod_program_basic.program_basic_delete_user_id,0) = 0 AND IFNULL(mod_program_extended.program_extended_delete_user_id,0) = 0 ) AND ( CONCAT(CAST(program_extended_end_date AS CHAR), " ", program_extended_end_time, ":00") >= CURRENT_TIMESTAMP ) AND ( category_relation_type = "mod_program_basic" ) AND ( category_relation_category_id NOT IN(5) ) AND ( category_relation_category_id = 42 ) GROUP BY program_basic_id ORDER BY start_date ASC
[begin] => 1766185212.7289
[end] => 1766185212.7593
[time] => 0.030426025390625
)
Array
(
[query] => SELECT
category_id,
category_title,
category_parent_id,
category_relation_category_id,
category_relation_type,
category_order,
COUNT(category_relation_id) as category_qty
FROM core_category LEFT JOIN mod_category_relation ON ( category_relation_category_id = category_id ) LEFT JOIN mod_program_basic ON ( category_relation_foreign_id = program_basic_id ) LEFT JOIN mod_program_extended ON ( program_extended_program_basic_id = program_basic_id ) WHERE ( category_parent_id = 13 ) AND ( (category_relation_type = "mod_program_basic" OR category_relation_type IS NULL) ) AND ( IFNULL(mod_program_basic.program_basic_delete_user_id,0) = 0 AND IFNULL(mod_program_extended.program_extended_delete_user_id,0) = 0 ) AND ( CONCAT(CAST(program_extended_end_date AS CHAR), " ", program_extended_end_time, ":00") >= CURRENT_TIMESTAMP ) GROUP BY category_id ORDER BY category_order
[begin] => 1766185212.7615
[end] => 1766185212.7667
[time] => 0.0051920413970947
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_friendly_url = 'esemeny-naptar' collate utf8_bin )
[begin] => 1766185212.7698
[end] => 1766185212.7709
[time] => 0.0010969638824463
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_md5 = '1da5e2e9a76175944739ff6cbd7bee17' )
[begin] => 1766185212.771
[end] => 1766185212.7738
[time] => 0.0028631687164307
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_md5 = '0e7b698b772dbd62ddb13a48e31fbfae' )
[begin] => 1766185212.8047
[end] => 1766185212.8066
[time] => 0.0018470287322998
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_md5 = '41a37e279c06bf9a8cdbcecba4db6893' )
[begin] => 1766185212.8085
[end] => 1766185212.8103
[time] => 0.0017850399017334
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_md5 = '3b3504cf2cbbd88d18c98bd96c08fac3' )
[begin] => 1766185212.8117
[end] => 1766185212.8131
[time] => 0.0013668537139893
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_md5 = 'a9281a1e9d24b678c095ace2c52922ef' )
[begin] => 1766185212.8143
[end] => 1766185212.8164
[time] => 0.0020530223846436
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_md5 = '76d2e6d5598cc3f59baa87c3fc2cf5f7' )
[begin] => 1766185212.8178
[end] => 1766185212.819
[time] => 0.0012249946594238
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_friendly_url = 'berletek' collate utf8_bin )
[begin] => 1766185212.821
[end] => 1766185212.8226
[time] => 0.0015828609466553
)
Array
(
[query] => SELECT * FROM core_route WHERE ( route_md5 = '56e9e61f4891ffeca766f9cbc8d38661' ) ORDER BY route_id DESC LIMIT 0, 1
[begin] => 1766185212.8235
[end] => 1766185212.8248
[time] => 0.0012750625610352
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_friendly_url = 'fesztivalok' collate utf8_bin )
[begin] => 1766185212.826
[end] => 1766185212.8277
[time] => 0.0017061233520508
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_friendly_url = 'taborok' collate utf8_bin )
[begin] => 1766185212.8293
[end] => 1766185212.8308
[time] => 0.0014650821685791
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_friendly_url = 'programkereso' collate utf8_bin )
[begin] => 1766185212.8356
[end] => 1766185212.8367
[time] => 0.001021146774292
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_friendly_url = 'baron-babos-muhely' collate utf8_bin )
[begin] => 1766185212.8378
[end] => 1766185212.8391
[time] => 0.0012400150299072
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_friendly_url = 'dramapedagogiai-muhely' collate utf8_bin )
[begin] => 1766185212.8398
[end] => 1766185212.8411
[time] => 0.0013489723205566
)
Array
(
[query] => SELECT * FROM core_route WHERE ( route_md5 = '1bed56c59cc887a9bf01254271033e57' ) ORDER BY route_id DESC LIMIT 0, 1
[begin] => 1766185212.8415
[end] => 1766185212.8432
[time] => 0.0017030239105225
)
Array
(
[query] => SELECT COUNT(*) FROM core_route WHERE ( route_md5 = '1bed56c59cc887a9bf01254271033e57' )
[begin] => 1766185212.8436
[end] => 1766185212.8459
[time] => 0.0022850036621094
)
Array
(
[query] => SELECT * FROM core_metadata WHERE ( metadata_model = 'Content' ) AND ( metadata_ref_id = '9' ) LIMIT 0, 1
[begin] => 1766185212.8664
[end] => 1766185212.8686
[time] => 0.0022530555725098
)
Array
(
[query] => SELECT * FROM core_route WHERE ( route_md5 = '1cf7d41e9b2e3f306fd3c7d0fac99600' ) ORDER BY route_id DESC LIMIT 0, 1
[begin] => 1766185212.8709
[end] => 1766185212.8729
[time] => 0.0020468235015869
)
Array
(
[query] => SELECT * FROM core_category WHERE ( category_id = '0' ) LIMIT 1
[begin] => 1766185212.8737
[end] => 1766185212.8766
[time] => 0.0029170513153076
)
Array
(
[query] => SELECT * FROM core_translation WHERE ( translation_module = 'agorafooterbanner' AND translation_locale = 'hu_hu' )
[begin] => 1766185212.8779
[end] => 1766185212.8806
[time] => 0.0027148723602295
)
Array
(
[query] => SELECT * FROM mod_banner WHERE ( banner_id = 1 ) AND ( banner_status = 1 ) LIMIT 0, 1
[begin] => 1766185212.882
[end] => 1766185212.8909
[time] => 0.0088889598846436
)
Array
(
[query] => SELECT mod_banner_item.*, image_path FROM mod_banner_item JOIN core_image ON ( banner_item_image_id = image_id ) WHERE ( banner_item_banner_id = 1 ) ORDER BY banner_item_order ASC
[begin] => 1766185212.8927
[end] => 1766185212.8992
[time] => 0.0064921379089355
)