| 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 | 8 | 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 | 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` = 0 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` = 3 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 10 | 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 | 1 | 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 | 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` = 6 AND `lang` = 'lv' AND `active` = 1 | 5 | 5 | 1 | 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 | 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` = 52 AND `lang` = 'lv' AND `active` = 1 | 4 | 4 | 5 | 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 | 7 | 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` = 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 | 3 | maybe slow |
| 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:37:12') AND (`Banner`.`date_to` >= '2026-05-13 23:37:12'))))) AND (((`Banner`.`exposition` IS NULL) OR (`Banner`.`exposition` = 0) OR (`Banner`.`exposition` > `Banner`.`total_views`)))) | 4 | 4 | 10 | 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 | 14 | |
| 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 | 6 | maybe slow |
| SELECT `Manual`.`id`, `Manual`.`lang`, `Manual`.`slug`, `Manual`.`title`, `Manual`.`type`, `Manual`.`parent_id`, `Manual`.`order_id`, `Manual`.`allow_comments`, `Manual`.`free`, `Manual`.`intro`, `Manual`.`text`, `Manual`.`category`, `Manual`.`author_id`, `Manual`.`editor_id`, `Manual`.`active`, `Manual`.`actual_date`, `Manual`.`created`, `Manual`.`modified` FROM `ifinanses_ifinanses`.`manuals` AS `Manual` WHERE `slug` = 'finansu-vadiba-elektroniskajas-tabulas' LIMIT 1 | 1 | 1 | 7 | 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.irokasgramatas' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `StaticUrl`.`id`, `StaticUrl`.`lang`, `StaticUrl`.`section`, `StaticUrl`.`url` FROM `ifinanses_ifinanses`.`static_urls` AS `StaticUrl` WHERE `StaticUrl`.`lang` = 'lv' AND `StaticUrl`.`section` = 'breadcrumb.irokasgr' LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `Manual`.`id`, `Manual`.`lang`, `Manual`.`slug`, `Manual`.`title`, `Manual`.`type`, `Manual`.`parent_id`, `Manual`.`order_id`, `Manual`.`allow_comments`, `Manual`.`free`, `Manual`.`intro`, `Manual`.`text`, `Manual`.`category`, `Manual`.`author_id`, `Manual`.`editor_id`, `Manual`.`active`, `Manual`.`actual_date`, `Manual`.`created`, `Manual`.`modified` FROM `ifinanses_ifinanses`.`manuals` AS `Manual` WHERE `Manual`.`parent_id` = 416 AND `Manual`.`type` = 'chapter' AND `Manual`.`active` = 1 AND `Manual`.`lang` = 'lv' ORDER BY `Manual`.`order_id` asc | 5 | 5 | 16 | maybe slow |
| SELECT `Manual`.`id`, `Manual`.`lang`, `Manual`.`slug`, `Manual`.`title`, `Manual`.`type`, `Manual`.`parent_id`, `Manual`.`order_id`, `Manual`.`allow_comments`, `Manual`.`free`, `Manual`.`intro`, `Manual`.`text`, `Manual`.`category`, `Manual`.`author_id`, `Manual`.`editor_id`, `Manual`.`active`, `Manual`.`actual_date`, `Manual`.`created`, `Manual`.`modified` FROM `ifinanses_ifinanses`.`manuals` AS `Manual` WHERE `Manual`.`parent_id` = 435 AND `Manual`.`type` = 'chapter' AND `Manual`.`active` = 1 AND `Manual`.`lang` = 'lv' ORDER BY `Manual`.`order_id` asc | 1 | 1 | 6 | maybe slow |
| SELECT `Manual`.`id`, `Manual`.`lang`, `Manual`.`slug`, `Manual`.`title`, `Manual`.`type`, `Manual`.`parent_id`, `Manual`.`order_id`, `Manual`.`allow_comments`, `Manual`.`free`, `Manual`.`intro`, `Manual`.`text`, `Manual`.`category`, `Manual`.`author_id`, `Manual`.`editor_id`, `Manual`.`active`, `Manual`.`actual_date`, `Manual`.`created`, `Manual`.`modified` FROM `ifinanses_ifinanses`.`manuals` AS `Manual` WHERE `Manual`.`parent_id` = 417 AND `Manual`.`type` = 'chapter' AND `Manual`.`active` = 1 AND `Manual`.`lang` = 'lv' ORDER BY `Manual`.`order_id` asc | 11 | 11 | 11 | |
| SELECT `Manual`.`id`, `Manual`.`lang`, `Manual`.`slug`, `Manual`.`title`, `Manual`.`type`, `Manual`.`parent_id`, `Manual`.`order_id`, `Manual`.`allow_comments`, `Manual`.`free`, `Manual`.`intro`, `Manual`.`text`, `Manual`.`category`, `Manual`.`author_id`, `Manual`.`editor_id`, `Manual`.`active`, `Manual`.`actual_date`, `Manual`.`created`, `Manual`.`modified` FROM `ifinanses_ifinanses`.`manuals` AS `Manual` WHERE `Manual`.`parent_id` = 418 AND `Manual`.`type` = 'chapter' AND `Manual`.`active` = 1 AND `Manual`.`lang` = 'lv' ORDER BY `Manual`.`order_id` asc | 2 | 2 | 11 | maybe slow |
| SELECT `Manual`.`id`, `Manual`.`lang`, `Manual`.`slug`, `Manual`.`title`, `Manual`.`type`, `Manual`.`parent_id`, `Manual`.`order_id`, `Manual`.`allow_comments`, `Manual`.`free`, `Manual`.`intro`, `Manual`.`text`, `Manual`.`category`, `Manual`.`author_id`, `Manual`.`editor_id`, `Manual`.`active`, `Manual`.`actual_date`, `Manual`.`created`, `Manual`.`modified` FROM `ifinanses_ifinanses`.`manuals` AS `Manual` WHERE `Manual`.`parent_id` = 419 AND `Manual`.`type` = 'chapter' AND `Manual`.`active` = 1 AND `Manual`.`lang` = 'lv' ORDER BY `Manual`.`order_id` asc | 1 | 1 | 11 | maybe slow |
| SELECT `Manual`.`id`, `Manual`.`lang`, `Manual`.`slug`, `Manual`.`title`, `Manual`.`type`, `Manual`.`parent_id`, `Manual`.`order_id`, `Manual`.`allow_comments`, `Manual`.`free`, `Manual`.`intro`, `Manual`.`text`, `Manual`.`category`, `Manual`.`author_id`, `Manual`.`editor_id`, `Manual`.`active`, `Manual`.`actual_date`, `Manual`.`created`, `Manual`.`modified` FROM `ifinanses_ifinanses`.`manuals` AS `Manual` WHERE `Manual`.`parent_id` = 750 AND `Manual`.`type` = 'chapter' AND `Manual`.`active` = 1 AND `Manual`.`lang` = 'lv' ORDER BY `Manual`.`order_id` asc | 1 | 1 | 14 | maybe slow |
| SELECT `Sponsor`.*, `Picture`.*, (CONCAT(`Sponsor`.`title`)) AS `Sponsor__full_name` FROM `ifinanses_ifinanses`.`sponsors` AS `Sponsor` RIGHT JOIN `ifinanses_ifinanses`.`seminar_sponsors` AS `SeminarSponsor` ON (`SeminarSponsor`.`sponsor_id` = `Sponsor`.`id` AND `SeminarSponsor`.`parent_type` = 'seminar' AND `SeminarSponsor`.`parent_id` = 416) LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `Picture` ON (`Picture`.`parent_type` = 'sponsor' AND `Picture`.`parent_id` = `Sponsor`.`id`) WHERE `Sponsor`.`general` = 1 AND `Sponsor`.`lang` = 'lv' LIMIT 1 | 0 | 0 | 13 | maybe slow |
| SELECT `Sponsor`.*, `Picture`.*, (CONCAT(`Sponsor`.`title`)) AS `Sponsor__full_name` FROM `ifinanses_ifinanses`.`sponsors` AS `Sponsor` RIGHT JOIN `ifinanses_ifinanses`.`seminar_sponsors` AS `SeminarSponsor` ON (`SeminarSponsor`.`sponsor_id` = `Sponsor`.`id` AND `SeminarSponsor`.`parent_type` = 'seminar' AND `SeminarSponsor`.`parent_id` = 416) LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `Picture` ON (`Picture`.`parent_type` = 'sponsor' AND `Picture`.`parent_id` = `Sponsor`.`id`) WHERE `Sponsor`.`general` = 0 AND `Sponsor`.`lang` = 'lv' | 0 | 0 | 9 | maybe slow |
| SELECT `StaticUrl`.`section`, `StaticUrl`.`url` FROM `ifinanses_ifinanses`.`static_urls` AS `StaticUrl` WHERE `StaticUrl`.`lang` = 'lv' | 63 | 63 | 1 | |