| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Menu`.*, `Text`.*, `Category`.`color`, `Menu`.`id` FROM `ifinanses_ifinanses`.`menus` AS `Menu` LEFT JOIN `ifinanses_ifinanses`.`texts` AS `Text` ON (`Text`.`parent_id` = `Menu`.`id` AND `Text`.`parent_type` = 'menu') LEFT JOIN `ifinanses_ifinanses`.`article_categories` AS `Category` ON (slug = replace(`Menu`.`url`, '/raksti/', '')) WHERE `Menu`.`parent_id` = 0 AND `Menu`.`lang` = 'lv' GROUP BY `Menu`.`id` ORDER BY `Menu`.`order_id` asc | 28 | 28 | 27 | maybe slow |
| SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lang`, `Menu`.`name`, `Menu`.`url`, `Menu`.`order_id`, `Menu`.`title`, `Menu`.`keywords`, `Menu`.`type`, `Menu`.`navigation`, `Menu`.`created`, `Menu`.`modified` FROM `ifinanses_ifinanses`.`menus` AS `Menu` WHERE `Menu`.`parent_id` IN (1, 3, 5, 26, 14, 63, 27, 13, 20, 217, 18, 21, 202, 23, 28, 216, 25, 29, 147, 126, 24, 159, 30, 141, 22, 112, 166, 203) | 1 | 1 | 12 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 0 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 11 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 3 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 4 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 4 AND `lang` = 'lv' AND `active` = 1 | 7 | 7 | 9 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 5 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 18 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 6 AND `lang` = 'lv' AND `active` = 1 | 5 | 5 | 11 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 8 AND `lang` = 'lv' AND `active` = 1 | 5 | 5 | 12 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 52 AND `lang` = 'lv' AND `active` = 1 | 4 | 4 | 17 | maybe slow |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 81 AND `lang` = 'lv' AND `active` = 1 | 4 | 4 | 4 | |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`lang`, `ArticleCategory`.`slug`, `ArticleCategory`.`name`, `ArticleCategory`.`parent_id`, `ArticleCategory`.`order_id`, `ArticleCategory`.`color`, `ArticleCategory`.`actual`, `ArticleCategory`.`active`, `ArticleCategory`.`created`, `ArticleCategory`.`modified`, `ArticleCategory`.`new_url` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 313 AND `lang` = 'lv' AND `active` = 1 | 1 | 1 | 1 | |
| SELECT `ArticleCategory`.`id`, `ArticleCategory`.`name` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `ArticleCategory`.`parent_id` = 0 AND `ArticleCategory`.`active` = 1 AND `ArticleCategory`.`lang` = 'lv' | 8 | 8 | 0 | |
| SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`title`, `Banner`.`link`, `Banner`.`code`, `Banner`.`stats_code`, `Banner`.`external_id`, `Banner`.`type`, `Banner`.`date_from`, `Banner`.`date_to`, `Banner`.`exposition`, `Banner`.`total_views`, `Banner`.`location`, `Banner`.`active`, `Banner`.`created`, `Banner`.`modified`, `Picture`.`id`, `Picture`.`img_name`, `Picture`.`img_type`, `Picture`.`lang`, `Picture`.`parent_type`, `Picture`.`parent_id`, `Picture`.`user_id`, `Picture`.`created`, `Picture`.`modified` FROM `ifinanses_ifinanses`.`banners` AS `Banner` LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `Picture` ON (`Picture`.`parent_id` = `Banner`.`id` AND `Picture`.`parent_type` = 'banner') WHERE `Banner`.`active` = 1 AND `Banner`.`lang` = 'lv' AND ((((((`Banner`.`date_from` IS NULL) AND (`Banner`.`date_to` IS NULL))) OR (((`Banner`.`date_from` = '0000-00-00 00:00:00') AND (`Banner`.`date_to` = '0000-00-00 00:00:00'))) OR (((`Banner`.`date_from` <= '2026-05-13 23:34:47') AND (`Banner`.`date_to` >= '2026-05-13 23:34:47'))))) AND (((`Banner`.`exposition` IS NULL) OR (`Banner`.`exposition` = 0) OR (`Banner`.`exposition` > `Banner`.`total_views`)))) | 4 | 4 | 3 | maybe slow |
| SELECT `BannersStatistics`.`id`, `BannersStatistics`.`banner_id`, `BannersStatistics`.`date`, `BannersStatistics`.`clicks`, `BannersStatistics`.`views` FROM `ifinanses_ifinanses`.`banners_statistics` AS `BannersStatistics` WHERE `BannersStatistics`.`banner_id` IN (232, 2110, 2151, 2157) | 2309 | 2309 | 5 | |
| SELECT `Banner`.`id`, `Banner`.`lang`, `Banner`.`title`, `Banner`.`link`, `Banner`.`code`, `Banner`.`stats_code`, `Banner`.`external_id`, `Banner`.`type`, `Banner`.`date_from`, `Banner`.`date_to`, `Banner`.`exposition`, `Banner`.`total_views`, `Banner`.`location`, `Banner`.`active`, `Banner`.`created`, `Banner`.`modified`, `Picture`.`id`, `Picture`.`img_name`, `Picture`.`img_type`, `Picture`.`lang`, `Picture`.`parent_type`, `Picture`.`parent_id`, `Picture`.`user_id`, `Picture`.`created`, `Picture`.`modified` FROM `ifinanses_ifinanses`.`banners` AS `Banner` LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `Picture` ON (`Picture`.`parent_id` = `Banner`.`id` AND `Picture`.`parent_type` = 'banner') WHERE `Banner`.`active` = 1 AND `Banner`.`date_to` < '2026-05-13' AND `Banner`.`lang` = 'lv' AND NOT (`Banner`.`date_to` IS NULL) | 0 | 0 | 4 | maybe slow |
| SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lang`, `Menu`.`name`, `Menu`.`url`, `Menu`.`order_id`, `Menu`.`title`, `Menu`.`keywords`, `Menu`.`type`, `Menu`.`navigation`, `Menu`.`created`, `Menu`.`modified`, `Text`.`id`, `Text`.`text`, `Text`.`parent_id`, `Text`.`parent_type`, `Text`.`created`, `Text`.`modified` FROM `ifinanses_ifinanses`.`menus` AS `Menu` LEFT JOIN `ifinanses_ifinanses`.`texts` AS `Text` ON (`Text`.`parent_id` = `Menu`.`id` AND `Text`.`parent_type` = 'menu') WHERE `Menu`.`url` = 'abonesanas_ligums' AND `Menu`.`type` = 'static' AND `Menu`.`lang` = 'lv' LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lang`, `Menu`.`name`, `Menu`.`url`, `Menu`.`order_id`, `Menu`.`title`, `Menu`.`keywords`, `Menu`.`type`, `Menu`.`navigation`, `Menu`.`created`, `Menu`.`modified` FROM `ifinanses_ifinanses`.`menus` AS `Menu` WHERE `Menu`.`parent_id` = (29) | 0 | 0 | 1 | maybe slow |
| SELECT `Article`.`id`, `Article`.`category`, `Article`.`comment_count`, `ArticleCategory`.`slug`, `TopArticleCategory`.`slug`, `TopArticleCategory`.`color`, `TopArticleCategory`.`name`, `Article`.`slug`, `Article`.`title`, `Picture`.`id`, `Picture`.`img_type`, `AuthorPicture`.`id`, `AuthorPicture`.`img_type`, `Author`.`name`, `Author`.`surname`, `Author`.`company`, `Author`.`position` FROM `ifinanses_ifinanses`.`articles` AS `Article` LEFT JOIN `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` ON (`ArticleCategory`.`id` = `Article`.`category` AND `ArticleCategory`.`active` = 1) LEFT JOIN `ifinanses_ifinanses`.`article_categories` AS `TopArticleCategory` ON (`TopArticleCategory`.`id` = `ArticleCategory`.`parent_id` AND `TopArticleCategory`.`active` = 1) LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `Picture` ON (`Picture`.`parent_id` = `Article`.`id` AND `Picture`.`parent_type` = 'article') LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `AuthorPicture` ON (`AuthorPicture`.`parent_id` = `Article`.`author_id` AND `AuthorPicture`.`parent_type` = 'author') LEFT JOIN `ifinanses_ifinanses`.`authors` AS `Author` ON (`Author`.`id` = `Article`.`author_id`) WHERE `Article`.`question_id` != 0 AND `Article`.`active` = 1 AND `Article`.`focused` = 0 AND `ArticleCategory`.`active` = 1 AND `Article`.`lang` = 'lv' AND `ArticleCategory`.`lang` = 'lv' AND `Article`.`created` < NOW() ORDER BY `Article`.`created` desc LIMIT 2 | 2 | 2 | 139 | maybe slow |
| SELECT `Seminar`.`id`, `Seminar`.`lang`, `Seminar`.`slug`, `Seminar`.`title`, `Seminar`.`description`, `Seminar`.`intro`, `Seminar`.`type`, `Seminar`.`date`, `Seminar`.`time_from`, `Seminar`.`time_to`, `Seminar`.`place`, `Seminar`.`group_price`, `Seminar`.`demio_id`, `Seminar`.`registration_ends`, `Seminar`.`published`, `Seminar`.`has_discount`, `Seminar`.`participant_count`, `Seminar`.`agenda`, `Seminar`.`topics`, `Seminar`.`created`, `Seminar`.`modified`, `Seminar`.`send_final_invoices`, `Seminar`.`send_acknowledgements`, `Seminar`.`acknowledgement_details` FROM `ifinanses_ifinanses`.`seminars` AS `Seminar` WHERE `Seminar`.`lang` = 'lv' ORDER BY `Seminar`.`date` desc LIMIT 4 | 4 | 4 | 12 | maybe slow |
| SELECT `Link`.`id`, `Link`.`lang`, `Link`.`title`, `Link`.`url`, `Link`.`parent_type`, `Link`.`parent_id`, `Link`.`active`, `Link`.`created`, `Link`.`modified` FROM `ifinanses_ifinanses`.`links` AS `Link` WHERE `Link`.`parent_type` = 'resource' AND `Link`.`active` = 1 AND `Link`.`lang` = 'lv' LIMIT 14 | 10 | 10 | 14 | maybe slow |
| SELECT `PollQuestion`.`id`, `PollQuestion`.`lang`, `PollQuestion`.`question`, `PollQuestion`.`active`, `PollQuestion`.`created`, `PollQuestion`.`modified` FROM `ifinanses_ifinanses`.`poll_questions` AS `PollQuestion` WHERE `PollQuestion`.`active` = 1 AND `PollQuestion`.`lang` = 'lv' ORDER BY `PollQuestion`.`created` desc LIMIT 1 | 0 | 0 | 10 | maybe slow |
| SELECT `StaticUrl`.`id`, `StaticUrl`.`lang`, `StaticUrl`.`section`, `StaticUrl`.`url` FROM `ifinanses_ifinanses`.`static_urls` AS `StaticUrl` WHERE `StaticUrl`.`lang` = 'lv' AND `StaticUrl`.`section` = 'breadcrumb.pages' LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `StaticUrl`.`section`, `StaticUrl`.`url` FROM `ifinanses_ifinanses`.`static_urls` AS `StaticUrl` WHERE `StaticUrl`.`lang` = 'lv' | 63 | 63 | 8 | maybe slow |