|
0.72ms |
connect |
|
0.81ms |
SELECT hash, `cs`
FROM fp_i18n |
|
1.03ms |
SELECT `biz_osobnosti`.*, `dat_osobnostixkategorie`.`id_katd`, `dat_kategorie`.`value` FROM `biz_osobnosti`
LEFT JOIN `dat_osobnostixkategorie` ON dat_osobnostixkategorie.id_osobnosti8 = biz_osobnosti.id
LEFT JOIN `dat_kategorie` ON dat_kategorie.id = dat_osobnostixkategorie.id_katd WHERE (biz_osobnosti.seo = 'dimitrij-ovtcharov') ORDER BY `id_katd` asc LIMIT 1 |
|
0.15ms |
SELECT `fp_menu_items`.`id` FROM `fp_menu_items` WHERE (title = 'Sportovci') AND (menuId = 154) |
|
0.19ms |
SELECT `fp_settings`.* FROM `fp_settings` |
|
0.14ms |
SELECT `fp_menu_items`.*, `fp_components`.`lang`, `fp_components`.`type` AS `component_type`, `fp_components`.`parentMenuItem` FROM `fp_menu_items`
LEFT JOIN `fp_components` ON fp_components.id = fp_menu_items.menuId WHERE (fp_menu_items.id = '250') AND (lang = 'cs') LIMIT 1 |
|
0.13ms |
SELECT `fp_component_types`.* FROM `fp_component_types` WHERE (`id` = '40') LIMIT 1 |
|
2.09ms |
SELECT `biz_osobnosti`.* FROM `biz_osobnosti` WHERE (biz_osobnosti.seo = 'dimitrij-ovtcharov') LIMIT 1 |
|
0.95ms |
SELECT `fp_content`.`title`, `fp_content`.`introText`, `fp_content`.`seo`, `fp_content`.`image_thumb`, `fp_content`.`pr_perex_link`, `fp_content`.`pr_perex_script` FROM `fp_content` WHERE (is_PR = 1) AND (active = 1) AND ((NOW() BETWEEN date_startPublish AND date_stopPublish) OR (NOW() > date_startPublish AND ISNULL(date_stopPublish))) ORDER BY `date_created` ASC LIMIT 1 |
|
1.28ms |
SELECT `biz_skupinyxosobnosti`.*, `biz_skupiny`.`nazev` AS `xnazev`, `biz_skupiny`.`seo` AS `xseo`, `biz_skupiny`.`id` AS `xid` FROM `biz_skupinyxosobnosti`
LEFT JOIN `biz_skupiny` ON biz_skupiny.id = biz_skupinyxosobnosti.id_skupiny14 WHERE (id_osobnosti14 = '968') |
|
3.13ms |
UPDATE biz_osobnosti SET counter = counter + 1, counter_day = counter_day + 1, counter_week = counter_week + 1, counter_month = counter_month + 1 WHERE id = 968 |
|
0.36ms |
SELECT count(*) AS `pocet` FROM `fan_osobnosti` WHERE (osobnost_id = 968) |
|
0.34ms |
SELECT count(*) AS `pocet` FROM `fan_ne_osobnosti` WHERE (osobnost_id = 968) |
|
0.48ms |
SELECT `biz_mistonarozeni`.*, `biz_misto`.* FROM `biz_mistonarozeni`
LEFT JOIN `biz_misto` ON biz_misto.id = biz_mistonarozeni.id_misto2 WHERE (id_osobnosti3 = '968') |
|
0.41ms |
SELECT `biz_mistoumrti`.*, `biz_misto`.* FROM `biz_mistoumrti`
LEFT JOIN `biz_misto` ON biz_misto.id = biz_mistoumrti.id_misto WHERE (id_osobnosti2 = '968') |
|
0.44ms |
SELECT `dat_osobnostixkategorie`.*, `dat_kategorie`.* FROM `dat_osobnostixkategorie`
LEFT JOIN `dat_kategorie` ON dat_kategorie.id = dat_osobnostixkategorie.id_katd WHERE (id_osobnosti8 = '968') AND (dat_kategorie.seo != 'skupiny') |
|
189.84ms |
SELECT `rat_osobnosti`.* FROM `rat_osobnosti` WHERE (id_osobnosti = '968') |
|
4.76ms |
SELECT `rat_rebricek1`.`id` FROM `rat_rebricek1` WHERE (id_osobnosti = '968') LIMIT 1 |
|
4.60ms |
SELECT `rat_rebricek2`.`id` FROM `rat_rebricek2` WHERE (id_osobnosti = '968') LIMIT 1 |
|
3.98ms |
SELECT `rat_rebricek3`.`id` FROM `rat_rebricek3` WHERE (id_osobnosti = '968') LIMIT 1 |
|
5.13ms |
SELECT `rat_rebricek4`.`id` FROM `rat_rebricek4` WHERE (id_osobnosti = '968') LIMIT 1 |
|
3.26ms |
SELECT `fan_proc`.* FROM `fan_proc` WHERE (skupina = 0) AND (id_item = '968') |
|
2.59ms |
SELECT `fan_proc`.*, `users`.`id` AS `idu`, `users`.`username`, `users`.`avatar` FROM `fan_proc`
LEFT JOIN `users` ON users.id=fan_proc.id_user WHERE (id_item = '968') AND (skupina = 0) AND (typ = 3) |
|
3.09ms |
SELECT `fan_proc`.*, `users`.`id` AS `idu`, `users`.`username`, `users`.`avatar` FROM `fan_proc`
LEFT JOIN `users` ON users.id=fan_proc.id_user WHERE (id_item = '968') AND (skupina = 0) AND (typ = 1) |
|
2.83ms |
SELECT `fan_proc`.*, `users`.`id` AS `idu`, `users`.`username`, `users`.`avatar` FROM `fan_proc`
LEFT JOIN `users` ON users.id=fan_proc.id_user WHERE (id_item = '968') AND (skupina = 0) AND (typ = 2) |
|
0.47ms |
SELECT `fan_osobnosti`.*, `users`.* FROM `fan_osobnosti`
LEFT JOIN `users` ON users.id = fan_osobnosti.user_id WHERE (osobnost_id = '968' ) LIMIT 5 |
|
0.97ms |
SELECT `fan_ne_osobnosti`.*, `users`.* FROM `fan_ne_osobnosti`
LEFT JOIN `users` ON users.id = fan_ne_osobnosti.user_id WHERE (osobnost_id = '968' ) LIMIT 5 |
|
0.27ms |
SELECT `biz_osobnostixzanry`.*, `biz_zanry`.* FROM `biz_osobnostixzanry`
LEFT JOIN `biz_zanry` ON biz_zanry.id = biz_osobnostixzanry.id_zanru WHERE (id_osobnosti13 = '968') |
|
1.23ms |
SELECT `biz_osobnostixclanky`.*, `fp_content`.* FROM `biz_osobnostixclanky`
LEFT JOIN `fp_content` ON fp_content.id=biz_osobnostixclanky.clanek_id2 WHERE (id_osobnosti5 = '968') AND (fp_content.active = 1) AND (date_startPublish <= NOW() OR date_startPublish IS NULL) AND (date_stopPublish >= NOW() OR date_stopPublish IS NULL) ORDER BY `date_created` desc LIMIT 6 |
|
1.65ms |
SELECT `foto_osobnostixalbumy`.*, `fp_gallery_photos`.`id` AS `gid`, `fp_gallery_photos`.`title` AS `titlex`, `fp_gallery_files`.* FROM `foto_osobnostixalbumy`
LEFT JOIN `fp_gallery_photos` ON fp_gallery_photos.id=foto_osobnostixalbumy.id_alba
LEFT JOIN `fp_gallery_files` ON fp_gallery_photos.id= fp_gallery_files.gallery_photos_id WHERE (foto_osobnostixalbumy.id_osobnosti9 = '968') AND (fp_gallery_files.id IS NOT NULL) AND (fp_gallery_photos.title != 'nahe') ORDER BY `fp_gallery_files`.`order` asc LIMIT 10 |
|
0.37ms |
SELECT `foto_osobnostixalbumy`.*, `fp_gallery_photos`.* FROM `foto_osobnostixalbumy`
LEFT JOIN `fp_gallery_photos` ON fp_gallery_photos.id=foto_osobnostixalbumy.id_alba WHERE (foto_osobnostixalbumy.id_osobnosti9 = '968') AND (fp_gallery_photos.title = 'nahe') |
|
0.39ms |
SELECT `fp_gallery_files`.* FROM `fp_gallery_files` WHERE (gallery_photos_id = '76782') ORDER BY `order` desc LIMIT 5 |
|
3.52ms |
SELECT `biz_filmyxosobnosti`.*, `biz_filmy`.`nazev` AS `fnazev`, `biz_filmy`.`seo` AS `fseo` FROM `biz_filmyxosobnosti`
LEFT JOIN `biz_filmy` ON biz_filmy.id=biz_filmyxosobnosti.id_film WHERE (id_user = '968') |
|
3.40ms |
SELECT `biz_pisnicky`.`nazev`, `biz_pisnicky`.`id`, `biz_pisnicky`.`counter`, `biz_pisnicky`.`pocet_mp3`, `biz_pisnicky`.`text`, `biz_pisnicky`.`videoklip`, `biz_pisnicky`.`preklad`, `biz_pisnicky`.`interpret_nazev`, `biz_pisnicky`.`thumb`, 0 as pis FROM `biz_pisnicky` WHERE (id_origin = '968') AND (videoklip != "") AND (typ = 0) UNION SELECT `biz_pisnicky_primo`.`nazev`, `biz_pisnicky_primo`.`id`, `biz_pisnicky_primo`.`counter`, `biz_pisnicky_primo`.`pocet_mp3`, `biz_pisnicky_primo`.`text`, `biz_pisnicky_primo`.`videoklip`, `biz_pisnicky_primo`.`preklad`, `biz_pisnicky_primo`.`interpret_nazev`, `biz_pisnicky_primo`.`thumb`, 1 as pis FROM `biz_pisnicky_primo` WHERE (id_os = '968') AND (videoklip != "") ORDER BY `counter` DESC LIMIT 4 |
|
2.17ms |
SELECT `biz_pisnicky`.`nazev`, `biz_pisnicky`.`id`, `biz_pisnicky`.`counter`, `biz_pisnicky`.`pocet_mp3`, `biz_pisnicky`.`text`, `biz_pisnicky`.`videoklip`, `biz_pisnicky`.`preklad`, `biz_pisnicky`.`interpret_nazev`, `biz_mp3_alba`.`nazev` AS `mnazev`, `biz_mp3_alba`.`link`, `biz_mp3_alba`.`id_song`, `biz_mp3_alba`.`id` AS `mid`, 0 as pis FROM `biz_pisnicky`
LEFT JOIN `biz_mp3_alba` ON biz_mp3_alba.id_song=biz_pisnicky.id WHERE (id_origin = '968') AND (biz_pisnicky.typ = 0) AND (biz_mp3_alba.id is not null) UNION SELECT `biz_pisnicky_primo`.`nazev`, `biz_pisnicky_primo`.`id`, `biz_pisnicky_primo`.`counter`, `biz_pisnicky_primo`.`pocet_mp3`, `biz_pisnicky_primo`.`text`, `biz_pisnicky_primo`.`videoklip`, `biz_pisnicky_primo`.`preklad`, `biz_pisnicky_primo`.`interpret_nazev`, `biz_mp3_primo`.`nazev` AS `mnazev`, `biz_mp3_primo`.`link`, `biz_mp3_primo`.`id_song`, `biz_mp3_primo`.`id` AS `mid`, 1 as pis FROM `biz_pisnicky_primo`
LEFT JOIN `biz_mp3_primo` ON biz_mp3_primo.id_song=biz_pisnicky_primo.id WHERE (id_os = '968') AND (biz_mp3_primo.id is not null) ORDER BY `counter` DESC LIMIT 10 |
|
1.87ms |
SELECT `biz_pisnicky`.`interpret_nazev`, `biz_pisnicky`.`nazev`, `biz_pisnicky`.`id`, `biz_pisnicky`.`counter`, `biz_pisnicky`.`pocet_mp3`, `biz_pisnicky`.`text`, `biz_pisnicky`.`videoklip`, `biz_pisnicky`.`preklad`, 0 as pis FROM `biz_pisnicky` WHERE (id_origin = '968') AND (typ = 0) UNION SELECT `biz_pisnicky_primo`.`interpret_nazev`, `biz_pisnicky_primo`.`nazev`, `biz_pisnicky_primo`.`id`, `biz_pisnicky_primo`.`counter`, `biz_pisnicky_primo`.`pocet_mp3`, `biz_pisnicky_primo`.`text`, `biz_pisnicky_primo`.`videoklip`, `biz_pisnicky_primo`.`preklad`, 1 as pis FROM `biz_pisnicky_primo` WHERE (id_os = '968') ORDER BY `counter` DESC LIMIT 15 |
|
1.23ms |
SELECT `biz_osobnostixalba`.*, `biz_alba`.* FROM `biz_osobnostixalba`
LEFT JOIN `biz_alba` ON biz_alba.id = biz_osobnostixalba.id_alba WHERE (biz_osobnostixalba.id_osobnosti12 = '968' ) ORDER BY `counter` DESC LIMIT 4 |
|
0.34ms |
SELECT `fp_components`.*, `fp_component_types`.`name` AS `component_type`, `fp_component_types`.`model`, `fp_modules`.`name` AS `module`, `fp_modules`.`controller`, `fp_component_positions`.`name` AS `position`, `fp_component_menuitems_assign`.`fp_menuItemId` FROM `fp_components`
LEFT JOIN `fp_component_types` ON fp_component_types.id = fp_components.type
LEFT JOIN `fp_modules` ON fp_modules.id = fp_component_types.moduleId
LEFT JOIN `fp_component_positions` ON fp_component_positions.id = fp_components.position
LEFT JOIN `fp_component_menuitems_assign` ON fp_component_menuitems_assign.fp_componentId = fp_components.id AND fp_menuItemId = '250' WHERE (`fp_components`.`active` = '1') AND (`fp_component_positions`.`active` = '1') AND (`fp_component_types`.`active` = '1') AND (`lang` = 'cs') AND (`access_type` >= 999) AND (show_in_menu = 0 OR show_in_menu = 2 AND fp_menuItemId IS NOT NULL OR show_in_menu = 3 AND fp_menuItemId IS NULL) ORDER BY `fp_components`.order ASC |
|
0.35ms |
SELECT `fp_menu_items`.* FROM `fp_menu_items` |
|
0.20ms |
SELECT `fp_menu_items`.*, `fp_component_types`.`name` AS `componentType`, `fp_seo`.`seo` FROM `fp_menu_items`
LEFT JOIN `fp_component_types` ON fp_component_types.id = fp_menu_items.type
LEFT JOIN `fp_seo` ON fp_seo.value=fp_menu_items.value AND fp_seo.type = fp_menu_items.type AND fp_seo.lang = 'cs' WHERE (menuId = '142') AND (fp_component_types.active = 1) AND (fp_menu_items.active = 1) AND (access_type >= 999) ORDER BY `order` ASC |
|
0.32ms |
SELECT `fp_menu_items`.*, `fp_component_types`.`name` AS `componentType`, `fp_seo`.`seo` FROM `fp_menu_items`
LEFT JOIN `fp_component_types` ON fp_component_types.id = fp_menu_items.type
LEFT JOIN `fp_seo` ON fp_seo.value=fp_menu_items.value and fp_seo.type = fp_menu_items.type AND fp_seo.lang = 'cs' WHERE (fp_component_types.active = 1) AND (fp_menu_items.active = 1) AND (access_type >= 999) |
|
0.29ms |
SELECT `fp_menu_items`.* FROM `fp_menu_items` |
|
0.20ms |
SELECT `fp_menu_items`.*, `fp_component_types`.`name` AS `componentType`, `fp_seo`.`seo` FROM `fp_menu_items`
LEFT JOIN `fp_component_types` ON fp_component_types.id = fp_menu_items.type
LEFT JOIN `fp_seo` ON fp_seo.value=fp_menu_items.value AND fp_seo.type = fp_menu_items.type AND fp_seo.lang = 'cs' WHERE (menuId = '143') AND (fp_component_types.active = 1) AND (fp_menu_items.active = 1) AND (access_type >= 999) ORDER BY `order` ASC |
|
0.99ms |
SELECT `fp_content`.`title`, `fp_content`.`introText`, `fp_content`.`seo`, `fp_content`.`image_thumb`, `fp_content`.`pr_perex_link`, `fp_content`.`pr_perex_script` FROM `fp_content` WHERE (is_PR = 1) AND (active = 1) AND ((NOW() BETWEEN date_startPublish AND date_stopPublish) OR (NOW() > date_startPublish AND ISNULL(date_stopPublish))) ORDER BY `date_created` ASC LIMIT 1 |
|
0.18ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '162') LIMIT 1 |
|
0.16ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '161') LIMIT 1 |
|
0.16ms |
SELECT `biz_filmyxosobnosti`.*, `biz_filmy`.`nazev` AS `fnazev`, `biz_filmy_sceny`.`id` AS `sid` FROM `biz_filmyxosobnosti`
LEFT JOIN `biz_filmy` ON biz_filmy.id=biz_filmyxosobnosti.id_film
LEFT JOIN `biz_filmy_sceny` ON biz_filmy_sceny.id_osfilm=biz_filmyxosobnosti.id WHERE (biz_filmyxosobnosti.pr_video = 1) LIMIT 1 |
|
0.20ms |
SELECT `biz_filmyxosobnosti`.*, `biz_filmy`.`id` AS `fid`, `biz_filmy`.`nazev` AS `fnazev`, `biz_filmy`.`seo` AS `fseo`, `biz_filmy`.`typ` AS `ftyp`, `biz_filmy_sceny`.`id` AS `sid`, `biz_filmy_sceny`.`image`, `biz_filmy_sceny`.`typ`, `biz_videa_kategorie`.`seo_url` AS `kategorie_seo`, `biz_videa_kategorie`.`kategorie_name`, `biz_osobnosti`.`seo` AS `oseo`, `biz_osobnosti`.`jmeno` AS `ojmeno` FROM `biz_filmyxosobnosti`
LEFT JOIN `biz_filmy` ON biz_filmy.id=biz_filmyxosobnosti.id_film
LEFT JOIN `biz_filmy_sceny` ON biz_filmy_sceny.id_osfilm=biz_filmyxosobnosti.id
LEFT JOIN `biz_videa_kategorie` ON biz_videa_kategorie.id=biz_filmyxosobnosti.kategorie_id
LEFT JOIN `biz_osobnosti` ON biz_osobnosti.id = biz_filmyxosobnosti.id_user WHERE (biz_filmyxosobnosti.pr_video = 1) LIMIT 1 |
|
0.16ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '157') LIMIT 1 |
|
0.17ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '233') LIMIT 1 |
|
1.19ms |
SELECT `biz_osobnostixfilmy`.*, `biz_filmy`.`nazev`, `biz_filmy`.`rok`, `biz_filmy`.`typ` AS `ftyp`, `biz_filmy`.`seo`, `biz_filmy`.`hodnoceni`, `biz_filmyxzanry_csfd`.`zanr_id` FROM `biz_osobnostixfilmy`
INNER JOIN `biz_filmy` ON id = biz_osobnostixfilmy.film_id
LEFT JOIN `biz_filmyxzanry_csfd` ON id = biz_filmyxzanry_csfd.film_id AND zanr_id = 4 WHERE (osobnost_id = '968') AND (biz_osobnostixfilmy.typ = 3) AND (rok <= 2013) ORDER BY `rok` DESC |
|
2.14ms |
SELECT `biz_osobnostixfilmy`.*, `biz_filmy`.`nazev`, `biz_filmy`.`rok`, `biz_filmy`.`typ` AS `ftyp`, `biz_filmy`.`seo`, `biz_filmy`.`hodnoceni` FROM `biz_osobnostixfilmy`
INNER JOIN `biz_filmy` ON id = film_id WHERE (osobnost_id = '968') AND (biz_osobnostixfilmy.typ = 1) AND (rok <= 2013) ORDER BY `rok` DESC |
|
0.61ms |
SELECT `biz_osobnostixfilmy`.*, `biz_filmy`.`nazev`, `biz_filmy`.`rok`, `biz_filmy`.`typ` AS `ftyp`, `biz_filmy`.`seo`, `biz_filmy`.`hodnoceni` FROM `biz_osobnostixfilmy`
INNER JOIN `biz_filmy` ON id = film_id WHERE (osobnost_id = '968') AND (biz_osobnostixfilmy.typ = 2) AND (rok <= 2013) ORDER BY `rok` DESC |
|
0.13ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '160') LIMIT 1 |
|
0.14ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '158') LIMIT 1 |
|
0.25ms |
SELECT `fp_menu_items`.* FROM `fp_menu_items` |
|
0.15ms |
SELECT `fp_menu_items`.*, `fp_component_types`.`name` AS `componentType`, `fp_seo`.`seo` FROM `fp_menu_items`
LEFT JOIN `fp_component_types` ON fp_component_types.id = fp_menu_items.type
LEFT JOIN `fp_seo` ON fp_seo.value=fp_menu_items.value AND fp_seo.type = fp_menu_items.type AND fp_seo.lang = 'cs' WHERE (menuId = '154') AND (fp_component_types.active = 1) AND (fp_menu_items.active = 1) AND (access_type >= 999) ORDER BY `order` ASC |
|
107.67ms |
SELECT `biz_tagy`.* FROM `biz_tagy` WHERE (( value LIKE ('% Dimitrij Ovtcharov %')) OR (value LIKE ('Dimitrij Ovtcharov %')) OR (value LIKE ('% Dimitrij Ovtcharov') )) AND (value != 'Dimitrij Ovtcharov') AND (value NOT LIKE ('%fotky%')) AND (value NOT LIKE ('%photos%')) AND (value NOT LIKE ('%foto%')) AND (value NOT LIKE ('%photo%')) AND (value NOT LIKE ('%videa%')) AND (value NOT LIKE ('%video%')) ORDER BY `count` DESC LIMIT 40 |
|
1.88ms |
SELECT `rss_pipe`.*, `rss_articles`.* FROM `rss_pipe`
LEFT JOIN `rss_articles` ON rss_pipe.id_rss_article = rss_articles.id WHERE (rss_pipe.typ = 0) AND (rss_pipe.id_user = '968') AND (rss_articles.czech = 1) ORDER BY `date` DESC LIMIT 5 |
|
1.22ms |
SELECT `rss_pipe`.*, `rss_articles`.* FROM `rss_pipe`
LEFT JOIN `rss_articles` ON rss_pipe.id_rss_article = rss_articles.id WHERE (rss_pipe.typ = 0) AND (rss_pipe.id_user = '968') AND (rss_articles.czech = 0) ORDER BY `date` DESC LIMIT 3 |
Log (3)
Variables
60 in 369.39 ms
189 Files