| 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 `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 (41329, 41331, 41337, 41322, 41321) | 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 (41329, 41331, 41337, 41322, 41321) AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 25 | 25 | 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 -7 DAY) ORDER BY `Rrapage`.`views` DESC, `Rrapage`.`toppage` DESC, `Rrapage`.`ordine` DESC, `Rrapage`.`added` DESC LIMIT 5 | 5 | 5 | 13 | 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 (41195, 41146, 41226, 41279, 41159) | 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 (41195, 41146, 41226, 41279, 41159) 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 | 45 | 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 (40506, 40541, 40547, 40604, 40571) | 1 | 1 | 1 | |
| 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 (40506, 40541, 40547, 40604, 40571) AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 51 | 51 | 1 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`apare`, `Category`.`arhiva`, `CategoryType`.`id`, `CategoryType`.`name`, `ParentCategory`.`id`, `ParentCategory`.`name`, `ParentCategory`.`cattype_id`, `ParentCategory`.`parent_id`, `ParentCategory`.`haschildren`, `ParentCategory`.`ordine`, `ParentCategory`.`active`, `ParentCategory`.`apare`, `ParentCategory`.`arhiva` 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 | 45 | 45 | 2 | |
| 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` = (665) | 30 | 30 | 2 | maybe slow |
| SELECT `Videofile`.`id`, `Videofile`.`id_newmedia`, `Videofile`.`added`, `Videofile`.`modified`, `Videofile`.`deleted`, `Videofile`.`title`, `Videofile`.`descriere`, `Videofile`.`linkuri`, `Videofile`.`views`, `Videofile`.`playlist_id` FROM `videofiles` AS `Videofile` WHERE 1 = 1 ORDER BY `Videofile`.`added` DESC LIMIT 10 | 10 | 10 | 0 | |
| SELECT `Podcast`.`id`, `Podcast`.`name`, `Podcast`.`idmedia`, `Podcast`.`description`, `Podcast`.`added`, `Podcast`.`active`, `Podcast`.`ends`, `Podcast`.`type`, `Podcast`.`playlist_id`, `Podcast`.`titleimg`, `Playlist`.`id`, `Playlist`.`name`, `Playlist`.`added`, `Playlist`.`active`, `Playlist`.`is_podcast` FROM `podcasts` AS `Podcast` LEFT JOIN `playlists` AS `Playlist` ON (`Podcast`.`playlist_id` = `Playlist`.`id`) 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 | 1 | |
| 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` = 117 ORDER BY `Topitem`.`pozitie` asc LIMIT 10 | 10 | 10 | 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`, `Category`.`arhiva`, `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 | 54 | 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` = (41350) | 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` = 41350 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`, `Category`.`arhiva`, `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 | 54 | 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` = (41347) | 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` = 41347 AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 5 | 5 | 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`, `Category`.`arhiva`, `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 | 48 | 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` = (41324) | 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` = 41324 AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 0 | 0 | 0 | |
| 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 `Promo`.`id` = 11 ORDER BY `Promoitem`.`pozitie` Asc | 2 | 2 | 0 | |
| 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 `Promo`.`id` = 3 ORDER BY `Promoitem`.`pozitie` Asc | 1 | 1 | 0 | |
| SELECT `Grila`.`zi`, `Grila`.`emisiune`, `Grila`.`start`, `Grila`.`end` FROM `grilas` AS `Grila` WHERE ((`Grila`.`zi` = '5') AND (`Grila`.`start` < '14:31') AND (`Grila`.`end` > '14:31')) LIMIT 1 | 1 | 1 | 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` = 1004 AND `Programitem`.`hour` <= '14:31' ORDER BY `Programitem`.`hour` desc 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` = 1004 AND `Programitem`.`hour` >= '14:31' ORDER BY `Programitem`.`hour` asc 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 `Promo`.`id` = 1 ORDER BY `Promoitem`.`pozitie` Asc | 2 | 2 | 0 | |
| 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`, `Category`.`arhiva`, `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` = 34525 LIMIT 1 | 1 | 1 | 5 | 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` = (34525) | 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` = 34525 AND `RrapagesTag`.`tag_id` = `Tag`.`id`) | 6 | 6 | 1 | maybe slow |