0.62ms |
connect |
0.72ms |
SELECT hash, `cs`
FROM fp_i18n |
0.23ms |
SELECT `fp_settings`.* FROM `fp_settings` |
0.16ms |
SELECT `fp_component_types`.* FROM `fp_component_types` WHERE (`id` = '35') LIMIT 1 |
0.45ms |
SELECT `biz_osobnosti`.* FROM `biz_osobnosti` WHERE (seo = 'nahy-prodavac') LIMIT 1 |
0.71ms |
SELECT `biz_skupiny`.* FROM `biz_skupiny` WHERE (seo = 'nahy-prodavac') LIMIT 1 |
0.83ms |
SELECT `biz_tagy`.*, COUNT(biz_osobnosti.id) AS `pocet`, `biz_clankyxtagy`.*, `fp_content`.`seo` AS `xseo`, `biz_osobnostixclanky`.*, `biz_osobnosti`.`seo`, `biz_osobnosti`.`jmeno` FROM `biz_tagy`
LEFT JOIN `biz_clankyxtagy` ON biz_clankyxtagy.tag_id = biz_tagy.id
LEFT JOIN `fp_content` ON biz_clankyxtagy.clanek_id = fp_content.id
LEFT JOIN `biz_osobnostixclanky` ON biz_osobnostixclanky.clanek_id2=biz_clankyxtagy.clanek_id
LEFT JOIN `biz_osobnosti` ON biz_osobnostixclanky.id_osobnosti5=biz_osobnosti.id WHERE (biz_tagy.seo = 'nahy-prodavac') AND (biz_osobnosti.id is not null) AND (fp_content.active = 1) AND (fp_content.seo NOT LIKE 'co-tyden%' ) GROUP BY `biz_osobnosti`.`id` ORDER BY `pocet` DESC LIMIT 3 |
0.58ms |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `biz_tagy`
LEFT JOIN `biz_clankyxtagy` ON biz_clankyxtagy.tag_id = biz_tagy.id
LEFT JOIN `fp_content` ON biz_clankyxtagy.clanek_id = fp_content.id WHERE ((NOW() BETWEEN fp_content.date_startPublish AND fp_content.date_stopPublish) OR (NOW() > fp_content.date_startPublish AND ISNULL(fp_content.date_stopPublish))) AND (fp_content.active = 1) AND (biz_tagy.seo = 'nahy-prodavac') |
1.27ms |
SELECT `biz_tagy`.*, `biz_clankyxtagy`.*, `fp_content`.`image_thumb`, `fp_content`.`seo` AS `cseo`, `fp_content`.`title` AS `ctitle`, `fp_content`.`introText`, `fp_content`.`date_created` FROM `biz_tagy`
LEFT JOIN `biz_clankyxtagy` ON biz_clankyxtagy.tag_id = biz_tagy.id
LEFT JOIN `fp_content` ON biz_clankyxtagy.clanek_id = fp_content.id WHERE ((NOW() BETWEEN fp_content.date_startPublish AND fp_content.date_stopPublish) OR (NOW() > fp_content.date_startPublish AND ISNULL(fp_content.date_stopPublish))) AND (fp_content.active = 1) AND (biz_tagy.seo = 'nahy-prodavac') ORDER BY `fp_content`.`date_created` desc LIMIT 15 |
0.21ms |
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 = '' 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.31ms |
SELECT `fp_menu_items`.* FROM `fp_menu_items` |
0.16ms |
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.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 (fp_component_types.active = 1) AND (fp_menu_items.active = 1) AND (access_type >= 999) |
0.24ms |
SELECT `fp_menu_items`.* FROM `fp_menu_items` |
0.14ms |
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.11ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '162') LIMIT 1 |
0.12ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '161') LIMIT 1 |
0.13ms |
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.15ms |
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.18ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '157') LIMIT 1 |
0.12ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '233') LIMIT 1 |
0.92ms |
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.17ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '160') LIMIT 1 |
0.09ms |
SELECT `fp_content_wrapper`.`content` FROM `fp_content_wrapper` WHERE (id_fp_components = '158') LIMIT 1 |
0.17ms |
SELECT `top_celeb_vas`.* FROM `top_celeb_vas` WHERE (category = 0) AND (rating_category = 3) ORDER BY `rating_total` DESC, `rating_count` DESC LIMIT 10 |
0.14ms |
SELECT `top_celeb_vas`.* FROM `top_celeb_vas` WHERE (category = 0) AND (rating_category = 3) ORDER BY `rating_total` DESC, `rating_count` DESC LIMIT 10 OFFSET 10 |