| 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 | 0 | |
| 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 | 1 | |
| 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 | 0 | |
| 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 | 0 | |
| SELECT `Crondata`.`id`, `Crondata`.`created`, `Crondata`.`cheie`, `Crondata`.`data` FROM `crondatas` AS `Crondata` WHERE `cheie` = 'blogs' ORDER BY `created` DESC LIMIT 1 | 1 | 1 | 0 | |
| 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:03' ORDER BY `Programitem`.`hour` desc LIMIT 1 | 1 | 1 | 0 | |
| 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:03' ORDER BY `Programitem`.`hour` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Grila`.`zi`, `Grila`.`emisiune`, `Grila`.`start`, `Grila`.`end` FROM `grilas` AS `Grila` WHERE ((`Grila`.`zi` = '3') AND (`Grila`.`start` < '21:03') AND (`Grila`.`end` > '21:03')) LIMIT 1 | 1 | 1 | 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 -1 DAY) ORDER BY `Rrapage`.`views` DESC, `Rrapage`.`toppage` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 5 | 5 | 4 | 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 | 9 | 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) | 3 | 3 | 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 | 32 | 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 | 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 (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 | 428 | 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, 38347, 38352) | 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, 38347, 38352) 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 | 4 | 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 | 11 | 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 | 32 | 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 | 33 | 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 | 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` = 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 | 30 | 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 | 0 | |
| 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 | 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`.`id` = 13079 LIMIT 1 | 1 | 1 | 2 | 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` = (13079) | 4 | 4 | 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` = 13079 AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 5 | 5 | 1 | maybe slow |