| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`active` FROM `settings` AS `Setting` WHERE `Setting`.`active` = '1' | 9 | 9 | 1 | maybe slow |
| SELECT `Crondata`.`id`, `Crondata`.`created`, `Crondata`.`cheie`, `Crondata`.`data` FROM `crondatas` AS `Crondata` WHERE `cheie` = 'rss_antenasatelor' ORDER BY `created` DESC LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `Crondata`.`id`, `Crondata`.`created`, `Crondata`.`cheie`, `Crondata`.`data` FROM `crondatas` AS `Crondata` WHERE `cheie` = 'rss_radio3net' ORDER BY `created` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Crondata`.`id`, `Crondata`.`created`, `Crondata`.`cheie`, `Crondata`.`data` FROM `crondatas` AS `Crondata` WHERE `cheie` = 'rss_politicaromaneasca' ORDER BY `created` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Crondata`.`id`, `Crondata`.`created`, `Crondata`.`cheie`, `Crondata`.`data` FROM `crondatas` AS `Crondata` WHERE `cheie` = 'blogs' ORDER BY `created` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Videofile`.`id`, `Videofile`.`id_newmedia`, `Videofile`.`added`, `Videofile`.`modified`, `Videofile`.`deleted`, `Videofile`.`title`, `Videofile`.`descriere`, `Videofile`.`linkuri`, `Videofile`.`views` FROM `videofiles` AS `Videofile` WHERE 1 = 1 ORDER BY `Videofile`.`added` DESC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `Rate`.`id`, `Rate`.`day` FROM `rates` AS `Rate` WHERE 1 = 1 ORDER BY `id` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Rateitem`.`id`, `Rateitem`.`rate_id`, `Rateitem`.`value`, `Rateitem`.`currency` FROM `rateitems` AS `Rateitem` WHERE `Rateitem`.`rate_id` = (597) | 30 | 30 | 0 | |
| SELECT `Podcast`.`id`, `Podcast`.`name`, `Podcast`.`idmedia`, `Podcast`.`description`, `Podcast`.`added`, `Podcast`.`active`, `Podcast`.`ends`, `Podcast`.`type` FROM `podcasts` AS `Podcast` WHERE `Podcast`.`active` = '1' ORDER BY `Podcast`.`added` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Top`.`id`, `Top`.`name`, `Top`.`data`, `Top`.`active` FROM `tops` AS `Top` WHERE `Top`.`active` = '1' ORDER BY `Top`.`data` desc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Topitem`.`id`, `Topitem`.`top_id`, `Topitem`.`name`, `Topitem`.`piesa`, `Topitem`.`pozitie`, `Topitem`.`evolutie`, `Top`.`id`, `Top`.`name`, `Top`.`data`, `Top`.`active` FROM `topitems` AS `Topitem` LEFT JOIN `tops` AS `Top` ON (`Topitem`.`top_id` = `Top`.`id`) WHERE `Topitem`.`top_id` = 105 ORDER BY `Topitem`.`pozitie` asc LIMIT 10 | 10 | 10 | 0 | |
| SELECT `Programzile`.`id`, `Programzile`.`zi`, `Programzile`.`zilong` FROM `programziles` AS `Programzile` WHERE `Programzile`.`zi` = date(now()) LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Programitem`.`id`, `Programitem`.`programzile_id`, `Programitem`.`extid`, `Programitem`.`hour`, `Programitem`.`endt`, `Programitem`.`duration`, `Programitem`.`program_type`, `Programitem`.`title`, `Programitem`.`short_desc`, `Programitem`.`long_desc`, `Programitem`.`image1`, `Programitem`.`image2`, `Programitem`.`recommend`, `Programzile`.`id`, `Programzile`.`zi`, `Programzile`.`zilong` FROM `programitems` AS `Programitem` LEFT JOIN `programziles` AS `Programzile` ON (`Programitem`.`programzile_id` = `Programzile`.`id`) WHERE `Programitem`.`programzile_id` = 911 AND `Programitem`.`hour` <= '21:45' ORDER BY `Programitem`.`hour` desc LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `Programitem`.`id`, `Programitem`.`programzile_id`, `Programitem`.`extid`, `Programitem`.`hour`, `Programitem`.`endt`, `Programitem`.`duration`, `Programitem`.`program_type`, `Programitem`.`title`, `Programitem`.`short_desc`, `Programitem`.`long_desc`, `Programitem`.`image1`, `Programitem`.`image2`, `Programitem`.`recommend`, `Programzile`.`id`, `Programzile`.`zi`, `Programzile`.`zilong` FROM `programitems` AS `Programitem` LEFT JOIN `programziles` AS `Programzile` ON (`Programitem`.`programzile_id` = `Programzile`.`id`) WHERE `Programitem`.`programzile_id` = 911 AND `Programitem`.`hour` >= '21:45' ORDER BY `Programitem`.`hour` asc LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `Grila`.`zi`, `Grila`.`emisiune`, `Grila`.`start`, `Grila`.`end` FROM `grilas` AS `Grila` WHERE ((`Grila`.`zi` = '3') AND (`Grila`.`start` < '21:45') AND (`Grila`.`end` > '21:45')) LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`views`, `Rrapage`.`summary`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titlevideo`, `Rrapage`.`related`, `Rrapage`.`caudio`, `Rrapage`.`cvideo`, `Rrapage`.`videogallery_id`, `Rrapage`.`active`, `Author`.`name`, `Author`.`id`, `Category`.`name`, `Category`.`id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE NOT (`Rrapage`.`pagtype_id` = 3) AND `Rrapage`.`active` = '1' AND `Rrapage`.`added` > DATE_ADD(now(), INTERVAL -1 DAY) ORDER BY `Rrapage`.`views` DESC, `Rrapage`.`toppage` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 5 | 5 | 451 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`headline`, `Comment`.`text`, `Comment`.`user_id`, `Comment`.`nume`, `Comment`.`email`, `Comment`.`active`, `Comment`.`added`, `Comment`.`modified`, `Comment`.`rrapage_id`, `Comment`.`ipaddr`, `Comment`.`parent` FROM `comments` AS `Comment` WHERE `Comment`.`rrapage_id` IN (38306, 38307, 38312, 38317, 38313) | 0 | 0 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`longname`, `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `rrapages_tags` AS `RrapagesTag` ON (`RrapagesTag`.`rrapage_id` IN (38306, 38307, 38312, 38317, 38313) AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 25 | 25 | 0 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`views`, `Rrapage`.`summary`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titlevideo`, `Rrapage`.`related`, `Rrapage`.`caudio`, `Rrapage`.`cvideo`, `Rrapage`.`videogallery_id`, `Rrapage`.`active`, `Author`.`name`, `Author`.`id`, `Category`.`name`, `Category`.`id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE NOT (`Rrapage`.`pagtype_id` = 3) AND `Rrapage`.`active` = '1' AND `Rrapage`.`added` > DATE_ADD(now(), INTERVAL -7 DAY) ORDER BY `Rrapage`.`views` DESC, `Rrapage`.`toppage` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 5 | 5 | 15 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`headline`, `Comment`.`text`, `Comment`.`user_id`, `Comment`.`nume`, `Comment`.`email`, `Comment`.`active`, `Comment`.`added`, `Comment`.`modified`, `Comment`.`rrapage_id`, `Comment`.`ipaddr`, `Comment`.`parent` FROM `comments` AS `Comment` WHERE `Comment`.`rrapage_id` IN (38192, 38204, 38088, 38134, 38210) | 4 | 4 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`longname`, `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `rrapages_tags` AS `RrapagesTag` ON (`RrapagesTag`.`rrapage_id` IN (38192, 38204, 38088, 38134, 38210) AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 25 | 25 | 0 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`views`, `Rrapage`.`summary`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titlevideo`, `Rrapage`.`related`, `Rrapage`.`caudio`, `Rrapage`.`cvideo`, `Rrapage`.`videogallery_id`, `Rrapage`.`active`, `Author`.`name`, `Author`.`id`, `Category`.`name`, `Category`.`id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE NOT (`Rrapage`.`pagtype_id` = 3) AND `Rrapage`.`active` = '1' AND `Rrapage`.`added` > DATE_ADD(now(), INTERVAL -30 DAY) ORDER BY `Rrapage`.`views` DESC, `Rrapage`.`toppage` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 5 | 5 | 53 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`headline`, `Comment`.`text`, `Comment`.`user_id`, `Comment`.`nume`, `Comment`.`email`, `Comment`.`active`, `Comment`.`added`, `Comment`.`modified`, `Comment`.`rrapage_id`, `Comment`.`ipaddr`, `Comment`.`parent` FROM `comments` AS `Comment` WHERE `Comment`.`rrapage_id` IN (37384, 37429, 37481, 37723, 37702) | 0 | 0 | 1 | maybe slow |
| SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`longname`, `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `rrapages_tags` AS `RrapagesTag` ON (`RrapagesTag`.`rrapage_id` IN (37384, 37429, 37481, 37723, 37702) AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 29 | 29 | 0 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`views`, `Rrapage`.`summary`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titlevideo`, `Rrapage`.`related`, `Rrapage`.`caudio`, `Rrapage`.`cvideo`, `Rrapage`.`videogallery_id`, `Rrapage`.`active`, `Author`.`name`, `Author`.`id`, `Category`.`name`, `Category`.`id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`pagtype_id` = 2 AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`toppage` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 5 | 5 | 660 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`headline`, `Comment`.`text`, `Comment`.`user_id`, `Comment`.`nume`, `Comment`.`email`, `Comment`.`active`, `Comment`.`added`, `Comment`.`modified`, `Comment`.`rrapage_id`, `Comment`.`ipaddr`, `Comment`.`parent` FROM `comments` AS `Comment` WHERE `Comment`.`rrapage_id` IN (38351, 38354, 38342, 38352, 38347) | 0 | 0 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`longname`, `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `rrapages_tags` AS `RrapagesTag` ON (`RrapagesTag`.`rrapage_id` IN (38351, 38354, 38342, 38352, 38347) AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 25 | 25 | 0 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`views`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`videogallery_id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`pagtype_id` = 2 AND `Rrapage`.`added` > DATE_ADD(now(), INTERVAL -2 DAY) AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`views` DESC LIMIT 5 | 5 | 5 | 6 | maybe slow |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`comentarii`, `Rrapage`.`summary`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`videogallery_id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`pagtype_id` = 2 AND `Rrapage`.`active` = '1' AND `Rrapage`.`added` > DATE_ADD(now(), INTERVAL -8 DAY) AND `Rrapage`.`comentarii` > 0 ORDER BY `Rrapage`.`comentarii` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 5 | 5 | 16 | maybe slow |
| SELECT `Rrapage`.`id`, `Rrapage`.`category_id`, `Rrapage`.`name`, `Rrapage`.`titlevideo`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titleimg3`, `Rrapage`.`summary`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`text`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`active`, `Rrapage`.`tags`, `Rrapage`.`author_id`, `Rrapage`.`pagtype_id`, `Rrapage`.`toppage`, `Rrapage`.`ordine`, `Rrapage`.`videogallery_id`, `Rrapage`.`ordinecategorie`, `Rrapage`.`top5`, `Rrapage`.`views`, `Rrapage`.`comentarii`, `Rrapage`.`related`, `Rrapage`.`comentabil`, `Rrapage`.`poll_id`, `Rrapage`.`fact1`, `Rrapage`.`fact2`, `Rrapage`.`fact1type`, `Rrapage`.`fact2type`, `Rrapage`.`fact1pos`, `Rrapage`.`fact2pos`, `Rrapage`.`is_breakingnews`, `Author`.`id`, `Author`.`name`, `Author`.`added`, `Author`.`picture`, `Author`.`picture_on`, `Pagtype`.`id`, `Pagtype`.`name`, `Pagtype`.`added`, `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`apare`, `Videogallery`.`id`, `Videogallery`.`name`, `Videogallery`.`active`, `Videogallery`.`ext`, `Videogallery`.`added`, `Videogallery`.`home`, `Videogallery`.`ordine`, `Videogallery`.`t_stamp`, `Videogallery`.`summary`, `Videogallery`.`views` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`category_id` = 10 AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`ordinecategorie` DESC LIMIT 1 | 1 | 1 | 306 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`headline`, `Comment`.`text`, `Comment`.`user_id`, `Comment`.`nume`, `Comment`.`email`, `Comment`.`active`, `Comment`.`added`, `Comment`.`modified`, `Comment`.`rrapage_id`, `Comment`.`ipaddr`, `Comment`.`parent` FROM `comments` AS `Comment` WHERE `Comment`.`rrapage_id` = (38332) | 0 | 0 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`longname`, `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `rrapages_tags` AS `RrapagesTag` ON (`RrapagesTag`.`rrapage_id` = 38332 AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 0 | 0 | 0 | |
| SELECT `Rrapage`.`id`, `Rrapage`.`category_id`, `Rrapage`.`name`, `Rrapage`.`titlevideo`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titleimg3`, `Rrapage`.`summary`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`text`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`active`, `Rrapage`.`tags`, `Rrapage`.`author_id`, `Rrapage`.`pagtype_id`, `Rrapage`.`toppage`, `Rrapage`.`ordine`, `Rrapage`.`videogallery_id`, `Rrapage`.`ordinecategorie`, `Rrapage`.`top5`, `Rrapage`.`views`, `Rrapage`.`comentarii`, `Rrapage`.`related`, `Rrapage`.`comentabil`, `Rrapage`.`poll_id`, `Rrapage`.`fact1`, `Rrapage`.`fact2`, `Rrapage`.`fact1type`, `Rrapage`.`fact2type`, `Rrapage`.`fact1pos`, `Rrapage`.`fact2pos`, `Rrapage`.`is_breakingnews`, `Author`.`id`, `Author`.`name`, `Author`.`added`, `Author`.`picture`, `Author`.`picture_on`, `Pagtype`.`id`, `Pagtype`.`name`, `Pagtype`.`added`, `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`apare`, `Videogallery`.`id`, `Videogallery`.`name`, `Videogallery`.`active`, `Videogallery`.`ext`, `Videogallery`.`added`, `Videogallery`.`home`, `Videogallery`.`ordine`, `Videogallery`.`t_stamp`, `Videogallery`.`summary`, `Videogallery`.`views` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`category_id` = 17 AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`ordinecategorie` DESC LIMIT 1 | 1 | 1 | 74 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`headline`, `Comment`.`text`, `Comment`.`user_id`, `Comment`.`nume`, `Comment`.`email`, `Comment`.`active`, `Comment`.`added`, `Comment`.`modified`, `Comment`.`rrapage_id`, `Comment`.`ipaddr`, `Comment`.`parent` FROM `comments` AS `Comment` WHERE `Comment`.`rrapage_id` = (38326) | 0 | 0 | 22 | maybe slow |
| SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`longname`, `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `rrapages_tags` AS `RrapagesTag` ON (`RrapagesTag`.`rrapage_id` = 38326 AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 16 | 16 | 0 | |
| SELECT `Rrapage`.`id`, `Rrapage`.`category_id`, `Rrapage`.`name`, `Rrapage`.`titlevideo`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titleimg3`, `Rrapage`.`summary`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`text`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`active`, `Rrapage`.`tags`, `Rrapage`.`author_id`, `Rrapage`.`pagtype_id`, `Rrapage`.`toppage`, `Rrapage`.`ordine`, `Rrapage`.`videogallery_id`, `Rrapage`.`ordinecategorie`, `Rrapage`.`top5`, `Rrapage`.`views`, `Rrapage`.`comentarii`, `Rrapage`.`related`, `Rrapage`.`comentabil`, `Rrapage`.`poll_id`, `Rrapage`.`fact1`, `Rrapage`.`fact2`, `Rrapage`.`fact1type`, `Rrapage`.`fact2type`, `Rrapage`.`fact1pos`, `Rrapage`.`fact2pos`, `Rrapage`.`is_breakingnews`, `Author`.`id`, `Author`.`name`, `Author`.`added`, `Author`.`picture`, `Author`.`picture_on`, `Pagtype`.`id`, `Pagtype`.`name`, `Pagtype`.`added`, `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`apare`, `Videogallery`.`id`, `Videogallery`.`name`, `Videogallery`.`active`, `Videogallery`.`ext`, `Videogallery`.`added`, `Videogallery`.`home`, `Videogallery`.`ordine`, `Videogallery`.`t_stamp`, `Videogallery`.`summary`, `Videogallery`.`views` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`category_id` = 11 AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`ordinecategorie` DESC LIMIT 1 | 1 | 1 | 92 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`headline`, `Comment`.`text`, `Comment`.`user_id`, `Comment`.`nume`, `Comment`.`email`, `Comment`.`active`, `Comment`.`added`, `Comment`.`modified`, `Comment`.`rrapage_id`, `Comment`.`ipaddr`, `Comment`.`parent` FROM `comments` AS `Comment` WHERE `Comment`.`rrapage_id` = (38349) | 0 | 0 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`longname`, `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `rrapages_tags` AS `RrapagesTag` ON (`RrapagesTag`.`rrapage_id` = 38349 AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 3 | 3 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`apare`, `CategoryType`.`id`, `CategoryType`.`name`, `ParentCategory`.`id`, `ParentCategory`.`name`, `ParentCategory`.`cattype_id`, `ParentCategory`.`parent_id`, `ParentCategory`.`haschildren`, `ParentCategory`.`ordine`, `ParentCategory`.`active`, `ParentCategory`.`apare` FROM `categories` AS `Category` LEFT JOIN `cattypes` AS `CategoryType` ON (`Category`.`cattype_id` = `CategoryType`.`id`) LEFT JOIN `categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`haschildren` = '0' AND `Category`.`active` = '1' AND `Category`.`apare` = '1' ORDER BY `Category`.`ordine` ASC | 44 | 44 | 1 | |
| SELECT `Crondata`.`id`, `Crondata`.`created`, `Crondata`.`cheie`, `Crondata`.`data` FROM `crondatas` AS `Crondata` WHERE `cheie` = 'rss_romanialibera' ORDER BY `created` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Promoitem`.`id`, `Promoitem`.`promo_id`, `Promoitem`.`pozitie`, `Promoitem`.`desturl`, `Promoitem`.`image`, `Promo`.`id`, `Promo`.`name`, `Promo`.`description`, `Promo`.`width`, `Promo`.`height` FROM `promoitems` AS `Promoitem` LEFT JOIN `promos` AS `Promo` ON (`Promoitem`.`promo_id` = `Promo`.`id`) WHERE `Promoitem`.`promo_id` = 12 ORDER BY `Promoitem`.`pozitie` asc | 6 | 6 | 1 | maybe slow |
| SELECT `Tag`.`tag`, `Tag`.`id` FROM `tags` AS `Tag` WHERE `tag` = 'Exclusiv Online' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `rrapages_tags` AS `RrapagesTag` WHERE `tag_id` = 12367 | 187 | 187 | 1 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titleimg3`, `Rrapage`.`summary`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`videogallery_id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`id` IN (5530, 9862, 10449, 10574, 10627, 10990, 11402, 10978, 10668, 11361, 3926, 9674, 11514, 11778, 12232, 12419, 12460, 12554, 12603, 12765, 13220, 13368, 12961, 13073, 13303, 13448, 13520, 13662, 14352, 15511, 15766, 15926, 16003, 16859, 17061, 17218, 17789, 17868, 18248, 18687, 18812, 18846, 18866, 18964, 19018, 18980, 19138, 19248, 19457, 19518, 19743, 19754, 19844, 19896, 20045, 20053, 20091, 20252, 20308, 20320, 20646, 21259, 21577, 21752, 21704, 22077, 22079, 22388, 22686, 22713, 8851, 18189, 22812, 22964, 23175, 22869, 23233, 23282, 23479, 23859, 24015, 24160, 24682, 24797, 24825, 24872, 24942, 24929, 25110, 24614, 25266, 25305, 25424, 25579, 25672, 25380, 25718, 25862, 26131, 26229, 26324, 26527, 26707, 26799, 27050, 27237, 27281, 27357, 27428, 27522, 27533, 27564, 27607, 27650, 27818, 27881, 28056, 28051, 28142, 28199, 28227, 28387, 28500, 28566, 28722, 28745, 28825, 28916, 28931, 29072, 29278, 29367, 29505, 29570, 29611, 29974, 29975, 30262, 30470, 31059, 31109, 31494, 32215, 32339, 32455, 32467, 32634, 33262, 33308, 33314, 33315, 33470, 33451, 33579, 33618, 33877, 33963, 34125, 34236, 34366, 34367, 34481, 34714, 33018, 34841, 35036, 35596, 35662, 35839, 36094, 36007, 36260, 35477, 36374, 36399, 36532, 36534, 36563, 36650, 36914, 37279, 37434, 37502, 37271, 37618, 37871, 38234) AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`ordine` DESC, `Rrapage`.`modified` DESC LIMIT 12 | 12 | 12 | 18 | maybe slow |
| SELECT `Tag`.`tag`, `Tag`.`id` FROM `tags` AS `Tag` WHERE `tag` = 'Exclusiv Radio' LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `RrapagesTag`.`id`, `RrapagesTag`.`rrapage_id`, `RrapagesTag`.`tag_id` FROM `rrapages_tags` AS `RrapagesTag` WHERE `tag_id` = 12359 | 104 | 104 | 0 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titleimg3`, `Rrapage`.`summary`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`videogallery_id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`id` IN (7888, 9295, 10622, 11345, 9671, 8335, 7778, 7768, 7880, 11863, 11971, 12643, 12755, 12784, 13064, 13061, 13545, 13744, 13841, 13958, 14116, 14361, 14479, 14691, 14964, 15080, 15273, 15294, 15477, 15564, 15597, 15666, 15666, 15875, 16075, 16112, 16166, 16209, 16353, 16456, 16565, 16612, 16781, 16832, 16936, 17018, 17436, 17452, 17480, 17567, 17481, 17650, 18270, 18492, 18734, 19767, 20113, 20903, 20905, 20921, 20978, 20968, 21013, 21685, 22312, 22590, 19729, 22815, 23013, 23285, 22882, 24287, 24867, 24889, 25656, 25605, 25728, 25756, 25912, 26695, 27486, 27780, 29058, 29580, 30433, 30679, 30680, 32869, 31483, 31805, 33477, 33718, 33996, 34531, 7804, 35007, 35215, 35497, 37481, 37586, 37968, 38192, 38193, 38203) AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`ordine` DESC, `Rrapage`.`modified` DESC LIMIT 12 | 12 | 12 | 9 | maybe slow |
| SELECT `Category`.`name`, `Category`.`cattype_id`, `Category`.`id` FROM `categories` AS `Category` LEFT JOIN `cattypes` AS `CategoryType` ON (`Category`.`cattype_id` = `CategoryType`.`id`) LEFT JOIN `categories` AS `ParentCategory` ON (`Category`.`parent_id` = `ParentCategory`.`id`) WHERE `Category`.`id` = 30 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`summary`, `Rrapage`.`titleimg`, `Rrapage`.`titlevideo`, `Rrapage`.`titleimg2`, `Rrapage`.`related`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`videogallery_id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`category_id` = 30 AND `Rrapage`.`active` = '1' ORDER BY `Rrapage`.`toppage` DESC, `Rrapage`.`ordinecategorie` DESC, `Rrapage`.`added` DESC LIMIT 15 | 15 | 15 | 9 | maybe slow |
| SELECT `Rrapage`.`name`, `Rrapage`.`id`, `Rrapage`.`added`, `Rrapage`.`comentarii`, `Rrapage`.`summary`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`videogallery_id` FROM `rrapages` AS `Rrapage` LEFT JOIN `authors` AS `Author` ON (`Rrapage`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Rrapage`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Rrapage`.`category_id` = `Category`.`id`) LEFT JOIN `videogalleries` AS `Videogallery` ON (`Rrapage`.`videogallery_id` = `Videogallery`.`id`) WHERE `Rrapage`.`pagtype_id` = 2 AND `Rrapage`.`active` = '1' AND `Rrapage`.`category_id` = 30 AND `Rrapage`.`added` > DATE_ADD(now(), INTERVAL -4 DAY) AND `Rrapage`.`comentarii` > 0 ORDER BY `Rrapage`.`comentarii` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 0 | 0 | 7 | maybe slow |
| SELECT `Videogallery`.`id`, `Videogallery`.`name`, `Videogallery`.`active`, `Videogallery`.`ext`, `Videogallery`.`added`, `Videogallery`.`home`, `Videogallery`.`ordine`, `Videogallery`.`t_stamp`, `Videogallery`.`summary`, `Videogallery`.`views` FROM `videogalleries` AS `Videogallery` WHERE `Videogallery`.`active` = '1' AND `Videogallery`.`home` = '1' AND NOT (`Videogallery`.`id` = 0) ORDER BY `Videogallery`.`ordine` desc, `Videogallery`.`added` desc LIMIT 8 | 8 | 8 | 5 | maybe slow |
| SELECT `Videogalleryitem`.`id`, `Videogalleryitem`.`added`, `Videogalleryitem`.`videogallery_id`, `Videogalleryitem`.`ext`, `Videogalleryitem`.`caption`, `Videogalleryitem`.`text`, `Videogalleryitem`.`order` FROM `videogalleryitems` AS `Videogalleryitem` WHERE `Videogalleryitem`.`videogallery_id` IN (980, 979, 978, 977, 976, 974, 970, 969) | 89 | 89 | 0 | |
| SELECT `Rrapage`.`id`, `Rrapage`.`category_id`, `Rrapage`.`name`, `Rrapage`.`titlevideo`, `Rrapage`.`titleimg`, `Rrapage`.`titleimg2`, `Rrapage`.`titleimg3`, `Rrapage`.`summary`, `Rrapage`.`cvideo`, `Rrapage`.`caudio`, `Rrapage`.`text`, `Rrapage`.`added`, `Rrapage`.`modified`, `Rrapage`.`active`, `Rrapage`.`tags`, `Rrapage`.`author_id`, `Rrapage`.`pagtype_id`, `Rrapage`.`toppage`, `Rrapage`.`ordine`, `Rrapage`.`videogallery_id`, `Rrapage`.`ordinecategorie`, `Rrapage`.`top5`, `Rrapage`.`views`, `Rrapage`.`comentarii`, `Rrapage`.`related`, `Rrapage`.`comentabil`, `Rrapage`.`poll_id`, `Rrapage`.`fact1`, `Rrapage`.`fact2`, `Rrapage`.`fact1type`, `Rrapage`.`fact2type`, `Rrapage`.`fact1pos`, `Rrapage`.`fact2pos`, `Rrapage`.`is_breakingnews` FROM `rrapages` AS `Rrapage` WHERE `Rrapage`.`videogallery_id` IN (980, 979, 978, 977, 976, 974, 970, 969) | 9 | 9 | 1 | maybe slow |