QUERY: 1, čas: 0.004427 s, počet: 81
SQL: [427] SELECT `t_ph_imgs`.`id_photo`, `t_ph_imgs`.`id_category`, `t_ph_imgs`.`id_article`, `t_ph_imgs`.`article_model`, `t_ph_imgs`.`file`, `t_ph_imgs`.`name_cs` , `t_ph_imgs`.`desc_cs` , `t_ph_imgs`.`edit_time`, `t_ph_imgs`.`ord`, `t_ph_imgs`.`image_active` FROM `kzvalmez_dev_221024`.`kz_photogalery_images` AS t_ph_imgs WHERE (`t_ph_imgs`.`id_article` = :ida AND `t_ph_imgs`.`id_category` = :idc )
ORDER BY `t_ph_imgs`.`ord` ASC
Params: 2
Key: Name: [4] :ida
paramno=-1
name=[4] ":ida"
is_param=1
param_type=1
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1
;
QUERY: 2, čas: 0.002880 s, počet: 1
SQL: [1062] SELECT `t_art`.`id_article`, `t_art`.`id_user`, `t_art`.`is_user_last_edit`, `t_art`.`id_cat`, `t_art`.`id_photogallery`, `t_art`.`name_cs` , `t_art`.`urlkey_cs` , `t_art`.`text_cs` , `t_art`.`text_private_cs` , `t_art`.`text_clear_cs` , `t_art`.`keywords_cs` , `t_art`.`description_cs` , `t_art`.`annotation_cs` , `t_art`.`add_time`, `t_art`.`edit_time`, `t_art`.`concept`, `t_art`.`viewed`, `t_art`.`title_image`, `t_art`.`title_image_is_illustration`, `t_art`.`author`, `t_art`.`article_priority`, `t_art`.`article_priority_end_date`, `t_art`.`article_place`, `t_art`.`article_datadir`, `Model_Users_1`.`username`, `Model_Users_1`.`name` AS `usernameName`, `Model_Users_1`.`surname` AS `usernameSurName` FROM `kzvalmez_dev_221024`.`kz_articles` AS t_art LEFT JOIN kz_users AS Model_Users_1 ON (`Model_Users_1`.`id_user` = `t_art`.`id_user`)
WHERE (`t_art`.`id_cat` = :idc AND (concept = 0 AND `t_art`.`add_time` < NOW() AND `t_art`.`urlkey_cs` IS NOT NULL AND `t_art`.`urlkey_cs` != '' ) )
ORDER BY `t_art`.`article_priority` DESC,`t_art`.`add_time` DESC
Params: 1
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1
;
QUERY: 3, čas: 0.001434 s, počet: 1
SQL: [193] SELECT `t_art`.`id_article`, YEAR(add_time) AS `art_year` FROM `kzvalmez_dev_221024`.`kz_articles` AS t_art WHERE (`t_art`.`id_cat` IN (:key_0) )
GROUP BY `art_year`
ORDER BY `art_year` ASC
Params: 1
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
;
QUERY: 4, čas: 0.001128 s, počet: 1
SQL: [845] SELECT `t_cats`.`id_category`, `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_cats`.`urlkey_cs` , TRIM(LEADING urlkey_cs FROM :urlpartfull) AS `urlpart` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats WHERE (`t_cats`.`disable_cs` = 0 AND INSTR(:url, urlkey_cs) = 1 )
ORDER BY LENGTH(`t_cats`.`urlkey_cs`) DESC
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 4
Key: Name: [4] :url
paramno=-1
name=[4] ":url"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
Key: Name: [12] :urlpartfull
paramno=-1
name=[12] ":urlpartfull"
is_param=1
param_type=2
;
QUERY: 5, čas: 0.000812 s, počet: 1
SQL: [1218] SELECT `t_art_tags_conn`.`id_at_connection`, `t_art_tags_conn`.`articles_id_article`, `t_art_tags_conn`.`articles_tags_id_article_tag`, `Articles_Model_Tags_1`.`id_article_tag` AS `id_article_tag`, `Articles_Model_Tags_1`.`article_tag_name` AS `article_tag_name` FROM `kzvalmez_dev_221024`.`kz_articles_tags_has_articles` AS t_art_tags_conn LEFT JOIN kz_articles_tags AS Articles_Model_Tags_1 ON (`Articles_Model_Tags_1`.`id_article_tag` = `t_art_tags_conn`.`articles_tags_id_article_tag`)
WHERE (`t_art_tags_conn`.`articles_id_article` IN (:pl_365,:pl_364,:pl_363,:pl_362,:pl_361,:pl_360,:pl_359,:pl_358,:pl_357,:pl_356,:pl_329,:pl_317,:pl_316,:pl_301,:pl_300,:pl_299,:pl_298,:pl_297,:pl_285,:pl_282,:pl_279,:pl_277,:pl_276,:pl_275,:pl_274,:pl_273,:pl_272,:pl_271,:pl_270,:pl_269,:pl_268,:pl_267,:pl_266,:pl_265,:pl_264,:pl_241,:pl_240,:pl_239,:pl_237,:pl_236,:pl_228,:pl_227,:pl_226,:pl_225,:pl_217,:pl_214,:pl_213,:pl_212,:pl_194,:pl_191,:pl_179,:pl_178,:pl_173,:pl_170,:pl_169,:pl_168,:pl_165,:pl_163,:pl_160,:pl_154,:pl_153,:pl_142,:pl_140,:pl_134,:pl_132,:pl_124,:pl_116,:pl_109,:pl_108,:pl_106,:pl_105,:pl_100,:pl_99,:pl_95,:pl_91,:pl_90,:pl_83,:pl_82,:pl_72,:pl_68,:pl_67) )
ORDER BY `article_tag_name` ASC
Params: 81
Key: Name: [7] :pl_365
paramno=-1
name=[7] ":pl_365"
is_param=1
param_type=1
Key: Name: [7] :pl_364
paramno=-1
name=[7] ":pl_364"
is_param=1
param_type=1
Key: Name: [7] :pl_363
paramno=-1
name=[7] ":pl_363"
is_param=1
param_type=1
Key: Name: [7] :pl_362
paramno=-1
name=[7] ":pl_362"
is_param=1
param_type=1
Key: Name: [7] :pl_361
paramno=-1
name=[7] ":pl_361"
is_param=1
param_type=1
Key: Name: [7] :pl_360
paramno=-1
name=[7] ":pl_360"
is_param=1
param_type=1
Key: Name: [7] :pl_359
paramno=-1
name=[7] ":pl_359"
is_param=1
param_type=1
Key: Name: [7] :pl_358
paramno=-1
name=[7] ":pl_358"
is_param=1
param_type=1
Key: Name: [7] :pl_357
paramno=-1
name=[7] ":pl_357"
is_param=1
param_type=1
Key: Name: [7] :pl_356
paramno=-1
name=[7] ":pl_356"
is_param=1
param_type=1
Key: Name: [7] :pl_329
paramno=-1
name=[7] ":pl_329"
is_param=1
param_type=1
Key: Name: [7] :pl_317
paramno=-1
name=[7] ":pl_317"
is_param=1
param_type=1
Key: Name: [7] :pl_316
paramno=-1
name=[7] ":pl_316"
is_param=1
param_type=1
Key: Name: [7] :pl_301
paramno=-1
name=[7] ":pl_301"
is_param=1
param_type=1
Key: Name: [7] :pl_300
paramno=-1
name=[7] ":pl_300"
is_param=1
param_type=1
Key: Name: [7] :pl_299
paramno=-1
name=[7] ":pl_299"
is_param=1
param_type=1
Key: Name: [7] :pl_298
paramno=-1
name=[7] ":pl_298"
is_param=1
param_type=1
Key: Name: [7] :pl_297
paramno=-1
name=[7] ":pl_297"
is_param=1
param_type=1
Key: Name: [7] :pl_285
paramno=-1
name=[7] ":pl_285"
is_param=1
param_type=1
Key: Name: [7] :pl_282
paramno=-1
name=[7] ":pl_282"
is_param=1
param_type=1
Key: Name: [7] :pl_279
paramno=-1
name=[7] ":pl_279"
is_param=1
param_type=1
Key: Name: [7] :pl_277
paramno=-1
name=[7] ":pl_277"
is_param=1
param_type=1
Key: Name: [7] :pl_276
paramno=-1
name=[7] ":pl_276"
is_param=1
param_type=1
Key: Name: [7] :pl_275
paramno=-1
name=[7] ":pl_275"
is_param=1
param_type=1
Key: Name: [7] :pl_274
paramno=-1
name=[7] ":pl_274"
is_param=1
param_type=1
Key: Name: [7] :pl_273
paramno=-1
name=[7] ":pl_273"
is_param=1
param_type=1
Key: Name: [7] :pl_272
paramno=-1
name=[7] ":pl_272"
is_param=1
param_type=1
Key: Name: [7] :pl_271
paramno=-1
name=[7] ":pl_271"
is_param=1
param_type=1
Key: Name: [7] :pl_270
paramno=-1
name=[7] ":pl_270"
is_param=1
param_type=1
Key: Name: [7] :pl_269
paramno=-1
name=[7] ":pl_269"
is_param=1
param_type=1
Key: Name: [7] :pl_268
paramno=-1
name=[7] ":pl_268"
is_param=1
param_type=1
Key: Name: [7] :pl_267
paramno=-1
name=[7] ":pl_267"
is_param=1
param_type=1
Key: Name: [7] :pl_266
paramno=-1
name=[7] ":pl_266"
is_param=1
param_type=1
Key: Name: [7] :pl_265
paramno=-1
name=[7] ":pl_265"
is_param=1
param_type=1
Key: Name: [7] :pl_264
paramno=-1
name=[7] ":pl_264"
is_param=1
param_type=1
Key: Name: [7] :pl_241
paramno=-1
name=[7] ":pl_241"
is_param=1
param_type=1
Key: Name: [7] :pl_240
paramno=-1
name=[7] ":pl_240"
is_param=1
param_type=1
Key: Name: [7] :pl_239
paramno=-1
name=[7] ":pl_239"
is_param=1
param_type=1
Key: Name: [7] :pl_237
paramno=-1
name=[7] ":pl_237"
is_param=1
param_type=1
Key: Name: [7] :pl_236
paramno=-1
name=[7] ":pl_236"
is_param=1
param_type=1
Key: Name: [7] :pl_228
paramno=-1
name=[7] ":pl_228"
is_param=1
param_type=1
Key: Name: [7] :pl_227
paramno=-1
name=[7] ":pl_227"
is_param=1
param_type=1
Key: Name: [7] :pl_226
paramno=-1
name=[7] ":pl_226"
is_param=1
param_type=1
Key: Name: [7] :pl_225
paramno=-1
name=[7] ":pl_225"
is_param=1
param_type=1
Key: Name: [7] :pl_217
paramno=-1
name=[7] ":pl_217"
is_param=1
param_type=1
Key: Name: [7] :pl_214
paramno=-1
name=[7] ":pl_214"
is_param=1
param_type=1
Key: Name: [7] :pl_213
paramno=-1
name=[7] ":pl_213"
is_param=1
param_type=1
Key: Name: [7] :pl_212
paramno=-1
name=[7] ":pl_212"
is_param=1
param_type=1
Key: Name: [7] :pl_194
paramno=-1
name=[7] ":pl_194"
is_param=1
param_type=1
Key: Name: [7] :pl_191
paramno=-1
name=[7] ":pl_191"
is_param=1
param_type=1
Key: Name: [7] :pl_179
paramno=-1
name=[7] ":pl_179"
is_param=1
param_type=1
Key: Name: [7] :pl_178
paramno=-1
name=[7] ":pl_178"
is_param=1
param_type=1
Key: Name: [7] :pl_173
paramno=-1
name=[7] ":pl_173"
is_param=1
param_type=1
Key: Name: [7] :pl_170
paramno=-1
name=[7] ":pl_170"
is_param=1
param_type=1
Key: Name: [7] :pl_169
paramno=-1
name=[7] ":pl_169"
is_param=1
param_type=1
Key: Name: [7] :pl_168
paramno=-1
name=[7] ":pl_168"
is_param=1
param_type=1
Key: Name: [7] :pl_165
paramno=-1
name=[7] ":pl_165"
is_param=1
param_type=1
Key: Name: [7] :pl_163
paramno=-1
name=[7] ":pl_163"
is_param=1
param_type=1
Key: Name: [7] :pl_160
paramno=-1
name=[7] ":pl_160"
is_param=1
param_type=1
Key: Name: [7] :pl_154
paramno=-1
name=[7] ":pl_154"
is_param=1
param_type=1
Key: Name: [7] :pl_153
paramno=-1
name=[7] ":pl_153"
is_param=1
param_type=1
Key: Name: [7] :pl_142
paramno=-1
name=[7] ":pl_142"
is_param=1
param_type=1
Key: Name: [7] :pl_140
paramno=-1
name=[7] ":pl_140"
is_param=1
param_type=1
Key: Name: [7] :pl_134
paramno=-1
name=[7] ":pl_134"
is_param=1
param_type=1
Key: Name: [7] :pl_132
paramno=-1
name=[7] ":pl_132"
is_param=1
param_type=1
Key: Name: [7] :pl_124
paramno=-1
name=[7] ":pl_124"
is_param=1
param_type=1
Key: Name: [7] :pl_116
paramno=-1
name=[7] ":pl_116"
is_param=1
param_type=1
Key: Name: [7] :pl_109
paramno=-1
name=[7] ":pl_109"
is_param=1
param_type=1
Key: Name: [7] :pl_108
paramno=-1
name=[7] ":pl_108"
is_param=1
param_type=1
Key: Name: [7] :pl_106
paramno=-1
name=[7] ":pl_106"
is_param=1
param_type=1
Key: Name: [7] :pl_105
paramno=-1
name=[7] ":pl_105"
is_param=1
param_type=1
Key: Name: [7] :pl_100
paramno=-1
name=[7] ":pl_100"
is_param=1
param_type=1
Key: Name: [6] :pl_99
paramno=-1
name=[6] ":pl_99"
is_param=1
param_type=1
Key: Name: [6] :pl_95
paramno=-1
name=[6] ":pl_95"
is_param=1
param_type=1
Key: Name: [6] :pl_91
paramno=-1
name=[6] ":pl_91"
is_param=1
param_type=1
Key: Name: [6] :pl_90
paramno=-1
name=[6] ":pl_90"
is_param=1
param_type=1
Key: Name: [6] :pl_83
paramno=-1
name=[6] ":pl_83"
is_param=1
param_type=1
Key: Name: [6] :pl_82
paramno=-1
name=[6] ":pl_82"
is_param=1
param_type=1
Key: Name: [6] :pl_72
paramno=-1
name=[6] ":pl_72"
is_param=1
param_type=1
Key: Name: [6] :pl_68
paramno=-1
name=[6] ":pl_68"
is_param=1
param_type=1
Key: Name: [6] :pl_67
paramno=-1
name=[6] ":pl_67"
is_param=1
param_type=1
;
QUERY: 6, čas: 0.000554 s, počet: 1
SQL: [1711] SELECT `t_ph_imgs`.`id_image`, `t_ph_imgs`.`id_category`, `t_ph_imgs`.`image_label_cs` , `t_ph_imgs`.`image_link_cs` , `t_ph_imgs`.`image_order`, `t_ph_imgs`.`image_active`, `t_ph_imgs`.`image_file`, `t_ph_imgs`.`valid_from`, `t_ph_imgs`.`valid_to`, `t_ph_imgs`.`slogan_background`, `Model_Category_1`.`id_owner_user` AS `id_owner_user`, `Model_Category_1`.`label_cs` AS label_cs, `Model_Category_1`.`alt_cs` AS alt_cs, `Model_Category_1`.`urlkey_cs` AS urlkey_cs, `Model_Category_1`.`disable_cs` AS disable_cs, `Model_Category_1`.`module` AS `module`, `Model_Category_1`.`data_dir` AS `data_dir`, `Model_Category_1`.`individual_panels` AS `individual_panels`, `Model_Category_1`.`visibility` AS `visibility`, `Model_Category_1`.`ser_params` AS `ser_params`, `Model_Category_1`.`priority` AS `priority`, `Model_Category_1`.`default_right` AS `default_right`, `Model_Category_1`.`active` AS `active`, `Model_Category_1`.`keywords_cs` AS keywords_cs, `Model_Category_1`.`description_cs` AS description_cs, `Model_Category_1`.`changed` AS `changed`, `Model_Category_1`.`created` AS `created`, `Model_Category_1`.`feeds` AS `feeds`, `Model_Category_1`.`icon` AS `icon`, `Model_Category_1`.`background` AS `background`, `Model_Category_1`.`sitemap_changefreq` AS `sitemap_changefreq`, `Model_Category_1`.`sitemap_priority` AS `sitemap_priority` FROM `kzvalmez_dev_221024`.`kz_hpslideshow_images` AS t_ph_imgs LEFT JOIN kz_categories AS Model_Category_1 ON (`Model_Category_1`.`id_category` = `t_ph_imgs`.`id_category`)
WHERE (`t_ph_imgs`.`image_active` = 1 AND `t_ph_imgs`.`valid_from` <= NOW() AND ( `t_ph_imgs`.`valid_to` IS NULL OR `t_ph_imgs`.`valid_to` >= NOW()) )
ORDER BY `t_ph_imgs`.`image_order` ASC
Params: 0
;
QUERY: 7, čas: 0.000387 s, počet: 1
SQL: [571] SELECT `t_art_tags`.`id_article_tag`, `t_art_tags`.`article_tag_name` AS `tag`, COUNT(id_article_tag) AS `count` FROM `kzvalmez_dev_221024`.`kz_articles_tags` AS t_art_tags LEFT JOIN kz_articles_tags_has_articles AS t_tg ON (`t_tg`.`articles_tags_id_article_tag` = `t_art_tags`.`id_article_tag`)
LEFT JOIN kz_articles AS t_a ON (`t_a`.`id_article` = `t_tg`.`articles_id_article`)
LEFT JOIN kz_categories AS t_c ON (`t_c`.`id_category` = `t_a`.`id_cat`)
WHERE (id_category IN (:key_0) AND concept = 0 )
GROUP BY `t_art_tags`.`id_article_tag`
ORDER BY `COUNT` DESC
Params: 1
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=1
;
QUERY: 8, čas: 0.000362 s, počet: 1
SQL: [156] SELECT COUNT(`t_ipblocks`.`ip_address`) AS cnt FROM `kzvalmez_dev_221024`.`cubecms_global_ipblock` AS t_ipblocks WHERE (`t_ipblocks`.`ip_address` = :idb )
Params: 1
Key: Name: [4] :idb
paramno=-1
name=[4] ":idb"
is_param=1
param_type=2
;
QUERY: 9, čas: 0.000292 s, počet: 1
SQL: [327] SELECT `t_texts`.`id_text`, `t_texts`.`id_user`, `t_texts`.`id_item`, `t_texts`.`subkey`, `t_texts`.`text_cs` , `t_texts`.`text_clear_cs` , `t_texts`.`label_cs` , `t_texts`.`changed`, `t_texts`.`data` FROM `kzvalmez_dev_221024`.`kz_texts` AS t_texts WHERE (`t_texts`.`id_item` = :idc )
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 3
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
QUERY: 10, čas: 0.000262 s, počet: 1
SQL: [247] SELECT `t_ses`.`session_key`, `t_ses`.`value`, `t_ses`.`ip`, `t_ses`.`created`, `t_ses`.`updated`, `t_ses`.`id_user` FROM `kzvalmez_dev_221024`.`kz_sessions` AS t_ses WHERE (`t_ses`.`session_key` = :key )
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 3
Key: Name: [4] :key
paramno=-1
name=[4] ":key"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
QUERY: 11, čas: 0.000214 s, počet: 1
SQL: [1007] SELECT `t_cats`.`id_category`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`description_cs` , `t_cats`.`keywords_cs` , `t_cats`.`default_right`, `t_cats`.`id_owner_user`, `t_cats`.`feeds`, `t_cats`.`individual_panels`, `t_cats`.`module`, `t_cats`.`urlkey_cs` , `t_cats`.`visibility`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`priority`, `t_cats`.`disable_cs` , `t_cats`.`ser_params`, `t_cats`.`data_dir`, `t_cats`.`created`, `t_cats`.`changed`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
WHERE (`t_cats`.`disable_cs` = 0 )
Params: 0
;
QUERY: 12, čas: 0.000194 s, počet: 1
SQL: [201] SELECT `key`, `value` FROM `kz_config`
UNION ALL
SELECT `key`, `value` FROM `cubecms_global_config`
WHERE `key` NOT IN (SELECT `key` FROM `kz_config`)
ORDER BY `key`
Params: 0
;
QUERY: 13, čas: 0.000164 s, počet: 1
SQL: [1759] SELECT `t_panels`.`id_panel`, `t_panels`.`id_cat`, `t_panels`.`id_show_cat`, `t_panels`.`pname_cs` AS pname, `t_panels`.`porder`, `t_panels`.`position`, `t_panels`.`pparams`, `t_panels`.`icon` AS `picon`, `t_panels`.`background` AS `pbackground`, `t_panels`.`panel_force_global`, `t_panels`.`is_admin_cat`, `t_cat`.`id_category` AS `id_category`, `t_cat`.`id_owner_user` AS `id_owner_user`, `t_cat`.`label_cs` AS label, `t_cat`.`alt_cs` AS alt, `t_cat`.`urlkey_cs` AS urlkey, `t_cat`.`disable_cs` AS disable, `t_cat`.`module` AS `module`, `t_cat`.`data_dir` AS `data_dir`, `t_cat`.`individual_panels` AS `individual_panels`, `t_cat`.`visibility` AS `visibility`, `t_cat`.`ser_params` AS `ser_params`, `t_cat`.`priority` AS `priority`, `t_cat`.`default_right` AS `default_right`, `t_cat`.`active` AS `active`, `t_cat`.`keywords_cs` AS keywords, `t_cat`.`description_cs` AS description, `t_cat`.`changed` AS `changed`, `t_cat`.`created` AS `created`, `t_cat`.`feeds` AS `feeds`, `t_cat`.`icon` AS `icon`, `t_cat`.`background` AS `background`, `t_cat`.`sitemap_changefreq` AS `sitemap_changefreq`, `t_cat`.`sitemap_priority` AS `sitemap_priority`, `t_r`.`id_group`, `t_r`.`right` FROM `kzvalmez_dev_221024`.`kz_panels` AS t_panels LEFT JOIN kz_categories AS t_cat ON (`t_cat`.`id_category` = `t_panels`.`id_cat`)
LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cat`.`id_category` AND t_r.id_group = '2')
WHERE ( ( SUBSTRING(`right`, 1, 1) = 'r' OR ( `right` IS NULL AND SUBSTRING(`default_right`, 1, 1) = 'r' )) AND ( `t_panels`.`id_show_cat` = 0 OR `t_panels`.`panel_force_global` = 1 ) AND module IS NOT NULL OR (is_admin_cat = 1 AND ( `t_panels`.`id_show_cat` = 0 OR `t_panels`.`panel_force_global` = 1 )) )
ORDER BY `t_panels`.`porder` DESC
Params: 0
;
QUERY: 14, čas: 0.000158 s, počet: 1
SQL: [176] SELECT `t_mods`.`id_module`, `t_mods`.`name`, `t_mods`.`version`, `t_mods`.`version_major`, `t_mods`.`version_minor` FROM `kzvalmez_dev_221024`.`kz_modules_instaled` AS t_mods
Params: 0
;
QUERY: 15, čas: 0.000137 s, počet: 1
SQL: [1131] SELECT `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
WHERE (`t_cats`.`urlkey_cs` = :urlkey )
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 3
Key: Name: [7] :urlkey
paramno=-1
name=[7] ":urlkey"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
QUERY: 16, čas: 0.000131 s, počet: 1
SQL: [310] SELECT `t_cats`.`id_category`, `t_cats`.`label_cs` AS label, `t_cats`.`urlkey_cs` AS urlkey, `t_r`.`id_group`, `t_r`.`right` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
WHERE (`t_cats`.`feeds` = 1 )
Params: 0
;
QUERY: 17, čas: 0.000130 s, počet: 1
SQL: [192] SELECT `t_uss`.`id_user_setting`, `t_uss`.`id_user`, `t_uss`.`setting_name`, `t_uss`.`setting_value` FROM `kzvalmez_dev_221024`.`kz_users_settings` AS t_uss WHERE (`t_uss`.`id_user` = :idu )
Params: 1
Key: Name: [4] :idu
paramno=-1
name=[4] ":idu"
is_param=1
param_type=1
;
QUERY: 18, čas: 0.000124 s, počet: 1
SQL: [744] SELECT `t_art`.`id_article`, `t_art`.`id_user`, `t_art`.`is_user_last_edit`, `t_art`.`id_cat`, `t_art`.`id_photogallery`, `t_art`.`name_cs` , `t_art`.`urlkey_cs` , `t_art`.`text_cs` , `t_art`.`text_private_cs` , `t_art`.`text_clear_cs` , `t_art`.`keywords_cs` , `t_art`.`description_cs` , `t_art`.`annotation_cs` , `t_art`.`add_time`, `t_art`.`edit_time`, `t_art`.`concept`, `t_art`.`viewed`, `t_art`.`title_image`, `t_art`.`title_image_is_illustration`, `t_art`.`author`, `t_art`.`article_priority`, `t_art`.`article_priority_end_date`, `t_art`.`article_place`, `t_art`.`article_datadir` FROM `kzvalmez_dev_221024`.`kz_articles` AS t_art WHERE (`t_art`.`concept` = 0 )
ORDER BY `t_art`.`add_time` ASC
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
QUERY: 19, čas: 0.000113 s, počet: 1
SQL: [1129] SELECT `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
WHERE (`t_cats`.`id_category` = :id )
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 3
Key: Name: [3] :id
paramno=-1
name=[3] ":id"
is_param=1
param_type=1
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
QUERY: 20, čas: 0.000111 s, počet: 1
SQL: [346] SELECT `t_jounals`.`id_journal`, `t_jounals`.`journal_number`, `t_jounals`.`journal_year`, `t_jounals`.`journal_viewed`, `t_jounals`.`journal_text`, `t_jounals`.`journal_file` FROM `kzvalmez_dev_221024`.`kz_journals` AS t_jounals ORDER BY `t_jounals`.`journal_year` DESC,`t_jounals`.`journal_number` DESC
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
QUERY: 21, čas: 0.000102 s, počet: 1
SQL: [1809] SELECT `t_cm_items`.`id_custom_menu_item`, `t_cm_items`.`id_category`, `t_cm_items`.`menu_item_box`, `t_cm_items`.`menu_item_name_cs` , `t_cm_items`.`menu_item_link`, `t_cm_items`.`menu_item_new_window`, `t_cm_items`.`menu_item_active`, `t_cm_items`.`is_tpl_menu`, `t_cm_items`.`menu_item_order`, `t_cm_items`.`id_lft`, `t_cm_items`.`id_rgt`, `t_cm_items`.`level`, `Model_Category_1`.`id_owner_user` AS `id_owner_user`, `Model_Category_1`.`label_cs` AS label_cs, `Model_Category_1`.`alt_cs` AS alt_cs, `Model_Category_1`.`urlkey_cs` AS urlkey_cs, `Model_Category_1`.`disable_cs` AS disable_cs, `Model_Category_1`.`module` AS `module`, `Model_Category_1`.`data_dir` AS `data_dir`, `Model_Category_1`.`individual_panels` AS `individual_panels`, `Model_Category_1`.`visibility` AS `visibility`, `Model_Category_1`.`ser_params` AS `ser_params`, `Model_Category_1`.`priority` AS `priority`, `Model_Category_1`.`default_right` AS `default_right`, `Model_Category_1`.`active` AS `active`, `Model_Category_1`.`keywords_cs` AS keywords_cs, `Model_Category_1`.`description_cs` AS description_cs, `Model_Category_1`.`changed` AS `changed`, `Model_Category_1`.`created` AS `created`, `Model_Category_1`.`feeds` AS `feeds`, `Model_Category_1`.`icon` AS `icon`, `Model_Category_1`.`background` AS `background`, `Model_Category_1`.`sitemap_changefreq` AS `sitemap_changefreq`, `Model_Category_1`.`sitemap_priority` AS `sitemap_priority` FROM `kzvalmez_dev_221024`.`kz_custom_menu_items` AS t_cm_items LEFT JOIN kz_categories AS Model_Category_1 ON (`Model_Category_1`.`id_category` = `t_cm_items`.`id_category`)
WHERE (`t_cm_items`.`menu_item_box` = :box AND `t_cm_items`.`menu_item_active` = 1 AND `t_cm_items`.`id_lft` != 1 AND ( disable_cs = 0 OR `t_cm_items`.`id_category` = 0 ) )
ORDER BY `t_cm_items`.`id_lft` ASC
Params: 1
Key: Name: [4] :box
paramno=-1
name=[4] ":box"
is_param=1
param_type=2
;
QUERY: 22, čas: 0.000101 s, počet: 1
SQL: [343] SELECT `t_texts`.`id_text`, `t_texts`.`id_user`, `t_texts`.`id_item`, `t_texts`.`subkey`, `t_texts`.`text_cs` , `t_texts`.`text_clear_cs` , `t_texts`.`label_cs` , `t_texts`.`changed`, `t_texts`.`data` FROM `kzvalmez_dev_221024`.`kz_texts` AS t_texts WHERE (`t_texts`.`id_item` = :idc AND `t_texts`.`subkey` IN (:key_0,:key_1,:key_2,:key_3) )
Params: 5
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=2
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=2
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=2
Key: Name: [6] :key_3
paramno=-1
name=[6] ":key_3"
is_param=1
param_type=2
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1
;
QUERY: 23, čas: 0.000098 s, počet: 1
SQL: [863] SELECT `t_partners`.`id_partner`, `t_partners`.`id_group`, `t_partners`.`partner_name`, `t_partners`.`partner_text`, `t_partners`.`partner_note`, `t_partners`.`partner_url`, `t_partners`.`partner_image`, `t_partners`.`partner_order`, `t_partners`.`partner_disabled`, `Partners_Model_Groups_1`.`id_partners_group` AS `id_partners_group`, `Partners_Model_Groups_1`.`id_category` AS `id_category`, `Partners_Model_Groups_1`.`partner_group_name_cs` AS partner_group_name_cs, `Partners_Model_Groups_1`.`partner_group_order` AS `partner_group_order` FROM `kzvalmez_dev_221024`.`kz_partners` AS t_partners LEFT JOIN kz_partners_groups AS Partners_Model_Groups_1 ON (`Partners_Model_Groups_1`.`id_partners_group` = `t_partners`.`id_group`)
WHERE (id_category = :idc )
ORDER BY `partner_group_order` ASC,`t_partners`.`partner_order` ASC,`t_partners`.`partner_name` ASC
Params: 1
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1
;
QUERY: 24, čas: 0.000093 s, počet: 1
SQL: [1751] SELECT `t_cm_items`.`id_custom_menu_item`, `t_cm_items`.`id_category`, `t_cm_items`.`menu_item_box`, `t_cm_items`.`menu_item_name_cs` , `t_cm_items`.`menu_item_link`, `t_cm_items`.`menu_item_new_window`, `t_cm_items`.`menu_item_active`, `t_cm_items`.`is_tpl_menu`, `t_cm_items`.`menu_item_order`, `t_cm_items`.`id_lft`, `t_cm_items`.`id_rgt`, `t_cm_items`.`level`, `Model_Category_1`.`id_owner_user` AS `id_owner_user`, `Model_Category_1`.`label_cs` AS label_cs, `Model_Category_1`.`alt_cs` AS alt_cs, `Model_Category_1`.`urlkey_cs` AS urlkey_cs, `Model_Category_1`.`disable_cs` AS disable_cs, `Model_Category_1`.`module` AS `module`, `Model_Category_1`.`data_dir` AS `data_dir`, `Model_Category_1`.`individual_panels` AS `individual_panels`, `Model_Category_1`.`visibility` AS `visibility`, `Model_Category_1`.`ser_params` AS `ser_params`, `Model_Category_1`.`priority` AS `priority`, `Model_Category_1`.`default_right` AS `default_right`, `Model_Category_1`.`active` AS `active`, `Model_Category_1`.`keywords_cs` AS keywords_cs, `Model_Category_1`.`description_cs` AS description_cs, `Model_Category_1`.`changed` AS `changed`, `Model_Category_1`.`created` AS `created`, `Model_Category_1`.`feeds` AS `feeds`, `Model_Category_1`.`icon` AS `icon`, `Model_Category_1`.`background` AS `background`, `Model_Category_1`.`sitemap_changefreq` AS `sitemap_changefreq`, `Model_Category_1`.`sitemap_priority` AS `sitemap_priority` FROM `kzvalmez_dev_221024`.`kz_custom_menu_items` AS t_cm_items LEFT JOIN kz_categories AS Model_Category_1 ON (`Model_Category_1`.`id_category` = `t_cm_items`.`id_category`)
WHERE (`t_cm_items`.`menu_item_box` = :box AND `t_cm_items`.`id_lft` = 1 )
ORDER BY `t_cm_items`.`id_lft` ASC
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 3
Key: Name: [4] :box
paramno=-1
name=[4] ":box"
is_param=1
param_type=2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
QUERY: 25, čas: 0.000075 s, počet: 5
SQL: [932] SELECT `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
WHERE ( ( SUBSTRING(`right`, 1, 1) = 'r' OR ( `right` IS NULL AND SUBSTRING(`default_right`, 1, 1) = 'r' )) AND disable_cs = 0 AND 1 = 1 AND `t_cats`.`disable_cs` = 0 AND `t_cats`.`module` = :module )
Params: 1
Key: Name: [7] :module
paramno=-1
name=[7] ":module"
is_param=1
param_type=2
;
QUERY: 26, čas: 0.000071 s, počet: 1
SQL: [336] SELECT `t_texts`.`id_text`, `t_texts`.`id_user`, `t_texts`.`id_item`, `t_texts`.`subkey`, `t_texts`.`text_cs` , `t_texts`.`text_clear_cs` , `t_texts`.`label_cs` , `t_texts`.`changed`, `t_texts`.`data` FROM `kzvalmez_dev_221024`.`kz_texts` AS t_texts WHERE (`t_texts`.`id_item` = :idc AND `t_texts`.`subkey` IN (:key_0,:key_1,:key_2) )
Params: 4
Key: Name: [6] :key_0
paramno=-1
name=[6] ":key_0"
is_param=1
param_type=2
Key: Name: [6] :key_1
paramno=-1
name=[6] ":key_1"
is_param=1
param_type=2
Key: Name: [6] :key_2
paramno=-1
name=[6] ":key_2"
is_param=1
param_type=2
Key: Name: [4] :idc
paramno=-1
name=[4] ":idc"
is_param=1
param_type=1
;
QUERY: 27, čas: 0.000058 s, počet: 1
SQL: [1168] SELECT `t_cats`.`id_category`, `t_cats`.`id_owner_user`, `t_cats`.`label_cs` , `t_cats`.`alt_cs` , `t_cats`.`urlkey_cs` , `t_cats`.`disable_cs` , `t_cats`.`module`, `t_cats`.`data_dir`, `t_cats`.`individual_panels`, `t_cats`.`visibility`, `t_cats`.`ser_params`, `t_cats`.`priority`, `t_cats`.`default_right`, `t_cats`.`active`, `t_cats`.`keywords_cs` , `t_cats`.`description_cs` , `t_cats`.`changed`, `t_cats`.`created`, `t_cats`.`feeds`, `t_cats`.`icon`, `t_cats`.`background`, `t_cats`.`sitemap_changefreq`, `t_cats`.`sitemap_priority`, `t_r`.`id_group`, `t_r`.`right`, `Model_Module_2`.`id_module` AS `id_module`, `Model_Module_2`.`name` AS `name`, `Model_Module_2`.`version` AS `version`, `Model_Module_2`.`version_major` AS `version_major`, `Model_Module_2`.`version_minor` AS `version_minor` FROM `kzvalmez_dev_221024`.`kz_categories` AS t_cats LEFT JOIN kz_rights AS t_r ON (`t_r`.`id_category` = `t_cats`.`id_category` AND t_r.id_group = '2')
LEFT JOIN kz_modules_instaled AS Model_Module_2 ON (`Model_Module_2`.`name` = `t_cats`.`module`)
WHERE (`t_cats`.`urlkey_cs` IS NOT NULL )
ORDER BY `t_cats`.`priority` DESC
LIMIT :cube_cms_fromrow, :cube_cms_rows
Params: 2
Key: Name: [17] :cube_cms_fromrow
paramno=-1
name=[17] ":cube_cms_fromrow"
is_param=1
param_type=1
Key: Name: [14] :cube_cms_rows
paramno=-1
name=[14] ":cube_cms_rows"
is_param=1
param_type=1
;
