| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| DESCRIBE `aros` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `acos` | | 7 | 7 | 1 | maybe slow |
| DESCRIBE `aros_acos` | | 7 | 7 | 0 | |
| DESCRIBE `pages` | | 33 | 33 | 1 | |
| DESCRIBE `authors` | | 4 | 4 | 0 | |
| DESCRIBE `pagtypes` | | 3 | 3 | 0 | |
| DESCRIBE `categories` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `cattypes` | | 2 | 2 | 0 | |
| DESCRIBE `users` | | 25 | 25 | 1 | |
| DESCRIBE `groupmembers` | | 3 | 3 | 0 | |
| DESCRIBE `groups` | | 3 | 3 | 0 | |
| DESCRIBE `galleries` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `images` | | 9 | 9 | 1 | maybe slow |
| DESCRIBE `tags` | | 3 | 3 | 0 | |
| DESCRIBE `pages_tags` | | 3 | 3 | 0 | |
| DESCRIBE `videofiles` | | 13 | 13 | 1 | maybe slow |
| DESCRIBE `playlists` | | 6 | 6 | 0 | |
| DESCRIBE `audiofiles` | | 12 | 12 | 1 | maybe slow |
| DESCRIBE `settings` | | 5 | 5 | 0 | |
| SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`active` FROM `settings` AS `Setting` WHERE `Setting`.`active` = 1 | | 7 | 7 | 0 | |
| DESCRIBE `promoitems` | | 5 | 5 | 0 | |
| DESCRIBE `promos` | | 5 | 5 | 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` = 5 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` = 6 ORDER BY `Promoitem`.`pozitie` asc | | 4 | 4 | 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` = 9 ORDER BY `Promoitem`.`pozitie` asc | | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`gallery_id`, `Image`.`name`, `Image`.`img_file`, `Image`.`created`, `Image`.`modified`, `Image`.`user_id`, `Image`.`ext`, `Image`.`def`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`NumeCopil`, `Gallery`.`PrenumeCopil`, `Gallery`.`DataNasterii`, `Gallery`.`Zodia`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`user_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`active`, `User`.`descriere`, `User`.`sumar`, `User`.`titleimg1`, `User`.`titleimg2`, `User`.`titleimg3`, `User`.`name`, `User`.`facebook_id`, `User`.`created`, `User`.`modified`, `User`.`email`, `User`.`isAdmin`, `User`.`hash`, `User`.`confirmed`, `User`.`adresa`, `User`.`localitate`, `User`.`telefon`, `User`.`tara`, `User`.`disclaimerimages`, `User`.`show_adr`, `User`.`show_tel`, `User`.`show_email` FROM `images` AS `Image` LEFT JOIN `galleries` AS `Gallery` ON (`Image`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `users` AS `User` ON (`Image`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY rand() ASC LIMIT 3 | | 3 | 3 | 51 | maybe slow |
| SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`name`, `Page`.`titlevideo`, `Page`.`titleimg`, `Page`.`titleimg2`, `Page`.`titleimg3`, `Page`.`summary`, `Page`.`cvideo`, `Page`.`caudio`, `Page`.`text`, `Page`.`added`, `Page`.`modified`, `Page`.`active`, `Page`.`tags`, `Page`.`author_id`, `Page`.`pagtype_id`, `Page`.`toppage`, `Page`.`ordine`, `Page`.`videogallery_id`, `Page`.`ordinecategorie`, `Page`.`top5`, `Page`.`views`, `Page`.`comentarii`, `Page`.`related`, `Page`.`stireazilei`, `Page`.`autor`, `Page`.`reporter`, `Page`.`user_id`, `Page`.`homecrawl`, `Page`.`newmediaid`, `Page`.`newmediaserver`, `Page`.`fotogal`, `Author`.`id`, `Author`.`name`, `Author`.`added`, `Author`.`poza`, `Pagtype`.`id`, `Pagtype`.`name`, `Pagtype`.`added`, `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`description`, `Category`.`titleimg`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`active`, `User`.`descriere`, `User`.`sumar`, `User`.`titleimg1`, `User`.`titleimg2`, `User`.`titleimg3`, `User`.`name`, `User`.`facebook_id`, `User`.`created`, `User`.`modified`, `User`.`email`, `User`.`isAdmin`, `User`.`hash`, `User`.`confirmed`, `User`.`adresa`, `User`.`localitate`, `User`.`telefon`, `User`.`tara`, `User`.`disclaimerimages`, `User`.`show_adr`, `User`.`show_tel`, `User`.`show_email` FROM `pages` AS `Page` LEFT JOIN `authors` AS `Author` ON (`Page`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Page`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) WHERE `Page`.`active` = 1 AND `Page`.`category_id` = 7 ORDER BY `Page`.`ordinecategorie` desc | | 6 | 6 | 2 | maybe slow |
| SELECT `Videofile`.`id`, `Videofile`.`id_newmedia`, `Videofile`.`added`, `Videofile`.`modified`, `Videofile`.`deleted`, `Videofile`.`title`, `Videofile`.`descriere`, `Videofile`.`ordine`, `Videofile`.`playlist`, `Videofile`.`server`, `Videofile`.`embed`, `Videofile`.`pic`, `Videofile`.`data_emisiune`, `Playlist`.`id`, `Playlist`.`name`, `Playlist`.`descriere`, `Playlist`.`pic`, `Playlist`.`added`, `Playlist`.`active` FROM `videofiles` AS `Videofile` LEFT JOIN `playlists` AS `Playlist` ON (`Videofile`.`playlist` = `Playlist`.`id`) WHERE `Videofile`.`playlist` IN (13, 2, 3, 4, 8, 15) GROUP BY `Videofile`.`playlist` | | 6 | 6 | 2 | maybe slow |
| SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`name`, `Page`.`titlevideo`, `Page`.`titleimg`, `Page`.`titleimg2`, `Page`.`titleimg3`, `Page`.`summary`, `Page`.`cvideo`, `Page`.`caudio`, `Page`.`text`, `Page`.`added`, `Page`.`modified`, `Page`.`active`, `Page`.`tags`, `Page`.`author_id`, `Page`.`pagtype_id`, `Page`.`toppage`, `Page`.`ordine`, `Page`.`videogallery_id`, `Page`.`ordinecategorie`, `Page`.`top5`, `Page`.`views`, `Page`.`comentarii`, `Page`.`related`, `Page`.`stireazilei`, `Page`.`autor`, `Page`.`reporter`, `Page`.`user_id`, `Page`.`homecrawl`, `Page`.`newmediaid`, `Page`.`newmediaserver`, `Page`.`fotogal` FROM `pages` AS `Page` WHERE `Page`.`active` = 1 AND `Page`.`category_id` = 53 ORDER BY `Page`.`ordinecategorie` desc LIMIT 8 | | 8 | 8 | 4 | maybe slow |
| SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`name`, `Page`.`titlevideo`, `Page`.`titleimg`, `Page`.`titleimg2`, `Page`.`titleimg3`, `Page`.`summary`, `Page`.`cvideo`, `Page`.`caudio`, `Page`.`text`, `Page`.`added`, `Page`.`modified`, `Page`.`active`, `Page`.`tags`, `Page`.`author_id`, `Page`.`pagtype_id`, `Page`.`toppage`, `Page`.`ordine`, `Page`.`videogallery_id`, `Page`.`ordinecategorie`, `Page`.`top5`, `Page`.`views`, `Page`.`comentarii`, `Page`.`related`, `Page`.`stireazilei`, `Page`.`autor`, `Page`.`reporter`, `Page`.`user_id`, `Page`.`homecrawl`, `Page`.`newmediaid`, `Page`.`newmediaserver`, `Page`.`fotogal` FROM `pages` AS `Page` WHERE `Page`.`active` = 1 AND `Page`.`category_id` = 40 ORDER BY `Page`.`ordinecategorie` desc LIMIT 6 | | 6 | 6 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`description`, `Category`.`titleimg` FROM `categories` AS `Category` WHERE `Category`.`id` = 40 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`name`, `Page`.`titlevideo`, `Page`.`titleimg`, `Page`.`titleimg2`, `Page`.`titleimg3`, `Page`.`summary`, `Page`.`cvideo`, `Page`.`caudio`, `Page`.`text`, `Page`.`added`, `Page`.`modified`, `Page`.`active`, `Page`.`tags`, `Page`.`author_id`, `Page`.`pagtype_id`, `Page`.`toppage`, `Page`.`ordine`, `Page`.`videogallery_id`, `Page`.`ordinecategorie`, `Page`.`top5`, `Page`.`views`, `Page`.`comentarii`, `Page`.`related`, `Page`.`stireazilei`, `Page`.`autor`, `Page`.`reporter`, `Page`.`user_id`, `Page`.`homecrawl`, `Page`.`newmediaid`, `Page`.`newmediaserver`, `Page`.`fotogal` FROM `pages` AS `Page` WHERE `Page`.`active` = 1 AND `Page`.`category_id` = 41 ORDER BY `Page`.`ordinecategorie` desc LIMIT 6 | | 6 | 6 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`description`, `Category`.`titleimg` FROM `categories` AS `Category` WHERE `Category`.`id` = 41 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`name`, `Page`.`titlevideo`, `Page`.`titleimg`, `Page`.`titleimg2`, `Page`.`titleimg3`, `Page`.`summary`, `Page`.`cvideo`, `Page`.`caudio`, `Page`.`text`, `Page`.`added`, `Page`.`modified`, `Page`.`active`, `Page`.`tags`, `Page`.`author_id`, `Page`.`pagtype_id`, `Page`.`toppage`, `Page`.`ordine`, `Page`.`videogallery_id`, `Page`.`ordinecategorie`, `Page`.`top5`, `Page`.`views`, `Page`.`comentarii`, `Page`.`related`, `Page`.`stireazilei`, `Page`.`autor`, `Page`.`reporter`, `Page`.`user_id`, `Page`.`homecrawl`, `Page`.`newmediaid`, `Page`.`newmediaserver`, `Page`.`fotogal` FROM `pages` AS `Page` WHERE `Page`.`active` = 1 AND `Page`.`category_id` = 42 ORDER BY `Page`.`ordinecategorie` desc LIMIT 6 | | 6 | 6 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`description`, `Category`.`titleimg` FROM `categories` AS `Category` WHERE `Category`.`id` = 42 LIMIT 1 | | 1 | 1 | 0 | |
| SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`name`, `Page`.`titlevideo`, `Page`.`titleimg`, `Page`.`titleimg2`, `Page`.`titleimg3`, `Page`.`summary`, `Page`.`cvideo`, `Page`.`caudio`, `Page`.`text`, `Page`.`added`, `Page`.`modified`, `Page`.`active`, `Page`.`tags`, `Page`.`author_id`, `Page`.`pagtype_id`, `Page`.`toppage`, `Page`.`ordine`, `Page`.`videogallery_id`, `Page`.`ordinecategorie`, `Page`.`top5`, `Page`.`views`, `Page`.`comentarii`, `Page`.`related`, `Page`.`stireazilei`, `Page`.`autor`, `Page`.`reporter`, `Page`.`user_id`, `Page`.`homecrawl`, `Page`.`newmediaid`, `Page`.`newmediaserver`, `Page`.`fotogal` FROM `pages` AS `Page` WHERE `Page`.`active` = 1 AND `Page`.`category_id` = 43 ORDER BY `Page`.`ordinecategorie` desc LIMIT 6 | | 6 | 6 | 1 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`description`, `Category`.`titleimg` FROM `categories` AS `Category` WHERE `Category`.`id` = 43 LIMIT 1 | | 1 | 1 | 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` = 8 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` = 5 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` = 6 ORDER BY `Promoitem`.`pozitie` asc | | 4 | 4 | 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` = 9 ORDER BY `Promoitem`.`pozitie` asc | | 1 | 1 | 0 | |
| SELECT `Image`.`id`, `Image`.`gallery_id`, `Image`.`name`, `Image`.`img_file`, `Image`.`created`, `Image`.`modified`, `Image`.`user_id`, `Image`.`ext`, `Image`.`def`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`NumeCopil`, `Gallery`.`PrenumeCopil`, `Gallery`.`DataNasterii`, `Gallery`.`Zodia`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`user_id`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`active`, `User`.`descriere`, `User`.`sumar`, `User`.`titleimg1`, `User`.`titleimg2`, `User`.`titleimg3`, `User`.`name`, `User`.`facebook_id`, `User`.`created`, `User`.`modified`, `User`.`email`, `User`.`isAdmin`, `User`.`hash`, `User`.`confirmed`, `User`.`adresa`, `User`.`localitate`, `User`.`telefon`, `User`.`tara`, `User`.`disclaimerimages`, `User`.`show_adr`, `User`.`show_tel`, `User`.`show_email` FROM `images` AS `Image` LEFT JOIN `galleries` AS `Gallery` ON (`Image`.`gallery_id` = `Gallery`.`id`) LEFT JOIN `users` AS `User` ON (`Image`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY rand() ASC LIMIT 3 | | 3 | 3 | 57 | maybe slow |
| SELECT `Page`.`id`, `Page`.`category_id`, `Page`.`name`, `Page`.`titlevideo`, `Page`.`titleimg`, `Page`.`titleimg2`, `Page`.`titleimg3`, `Page`.`summary`, `Page`.`cvideo`, `Page`.`caudio`, `Page`.`text`, `Page`.`added`, `Page`.`modified`, `Page`.`active`, `Page`.`tags`, `Page`.`author_id`, `Page`.`pagtype_id`, `Page`.`toppage`, `Page`.`ordine`, `Page`.`videogallery_id`, `Page`.`ordinecategorie`, `Page`.`top5`, `Page`.`views`, `Page`.`comentarii`, `Page`.`related`, `Page`.`stireazilei`, `Page`.`autor`, `Page`.`reporter`, `Page`.`user_id`, `Page`.`homecrawl`, `Page`.`newmediaid`, `Page`.`newmediaserver`, `Page`.`fotogal`, `Author`.`id`, `Author`.`name`, `Author`.`added`, `Author`.`poza`, `Pagtype`.`id`, `Pagtype`.`name`, `Pagtype`.`added`, `Category`.`id`, `Category`.`name`, `Category`.`cattype_id`, `Category`.`parent_id`, `Category`.`haschildren`, `Category`.`ordine`, `Category`.`active`, `Category`.`description`, `Category`.`titleimg`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`active`, `User`.`descriere`, `User`.`sumar`, `User`.`titleimg1`, `User`.`titleimg2`, `User`.`titleimg3`, `User`.`name`, `User`.`facebook_id`, `User`.`created`, `User`.`modified`, `User`.`email`, `User`.`isAdmin`, `User`.`hash`, `User`.`confirmed`, `User`.`adresa`, `User`.`localitate`, `User`.`telefon`, `User`.`tara`, `User`.`disclaimerimages`, `User`.`show_adr`, `User`.`show_tel`, `User`.`show_email` FROM `pages` AS `Page` LEFT JOIN `authors` AS `Author` ON (`Page`.`author_id` = `Author`.`id`) LEFT JOIN `pagtypes` AS `Pagtype` ON (`Page`.`pagtype_id` = `Pagtype`.`id`) LEFT JOIN `categories` AS `Category` ON (`Page`.`category_id` = `Category`.`id`) LEFT JOIN `users` AS `User` ON (`Page`.`user_id` = `User`.`id`) WHERE `Page`.`active` = 1 AND `Page`.`category_id` = 7 ORDER BY `Page`.`ordinecategorie` desc | | 6 | 6 | 4 | maybe slow |