| 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 | 11 | 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 | 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` = 0 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 8 | |
| 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 | 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` = 4 AND `lang` = 'lv' AND `active` = 1 | 7 | 7 | 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` = 5 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 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` = 6 AND `lang` = 'lv' AND `active` = 1 | 5 | 5 | 15 | 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 | 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` = 52 AND `lang` = 'lv' AND `active` = 1 | 4 | 4 | 0 | |
| 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 | 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` = 313 AND `lang` = 'lv' AND `active` = 1 | 1 | 1 | 0 | |
| 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 | 10 | 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:13') AND (`Banner`.`date_to` >= '2026-05-13 23:37:13'))))) AND (((`Banner`.`exposition` IS NULL) OR (`Banner`.`exposition` = 0) OR (`Banner`.`exposition` > `Banner`.`total_views`)))) | 4 | 4 | 11 | 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 | 8 | |
| 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 | 26 | maybe slow |
| SELECT `JournalCategory`.`id` FROM `ifinanses_ifinanses`.`journal_categories` AS `JournalCategory` LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `Picture` ON (`Picture`.`parent_id` = `JournalCategory`.`id` AND `Picture`.`parent_type` = 'journal_category') LEFT JOIN `ifinanses_ifinanses`.`sellable_objects` AS `SellableObject` ON (`SellableObject`.`parent_id` = `JournalCategory`.`id` AND `SellableObject`.`parent_type` = 'journal_category') WHERE `JournalCategory`.`slug` = 'ifit' LIMIT 1 | 1 | 1 | 32 | maybe slow |
| SELECT `Journal`.`id`, `Journal`.`lang`, `Journal`.`slug`, `Journal`.`title`, `Journal`.`active`, `Journal`.`archive`, `Journal`.`archive_count`, `Journal`.`journal_category_id`, `Journal`.`release_date`, `Journal`.`created`, `Journal`.`modified`, `Journal`.`journal_month`, (CONCAT(EXTRACT(YEAR FROM `Journal`.`release_date`), ", ", `Journal`.`title`)) AS `Journal__date_title`, `JournalCategory`.`id`, `JournalCategory`.`lang`, `JournalCategory`.`slug`, `JournalCategory`.`title`, `JournalCategory`.`intro`, `JournalCategory`.`description`, `JournalCategory`.`created`, `JournalCategory`.`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`.`journals` AS `Journal` LEFT JOIN `ifinanses_ifinanses`.`journal_categories` AS `JournalCategory` ON (`Journal`.`journal_category_id` = `JournalCategory`.`id`) LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `Picture` ON (`Picture`.`parent_id` = `Journal`.`id` AND `Picture`.`parent_type` = 'journal') WHERE `Journal`.`journal_category_id` = 11 AND `Journal`.`active` = 1 ORDER BY `Journal`.`release_date` DESC LIMIT 1 | 1 | 1 | 11 | maybe slow |
| SELECT `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`.`pictures` AS `Picture` WHERE `Picture`.`parent_id` = 11 AND `Picture`.`parent_type` = 'journal_category' | 1 | 1 | 1 | |
| SELECT `SellableObject`.`id`, `SellableObject`.`title`, `SellableObject`.`price`, `SellableObject`.`discount_price`, `SellableObject`.`vat`, `SellableObject`.`pack_has_discount`, `SellableObject`.`product_has_discount`, `SellableObject`.`parent_id`, `SellableObject`.`parent_type`, `SellableObject`.`deleted`, `SellableObject`.`created`, `SellableObject`.`modified` FROM `ifinanses_ifinanses`.`sellable_objects` AS `SellableObject` WHERE `SellableObject`.`parent_id` = 11 AND `SellableObject`.`parent_type` = 'journal_category' | 1 | 1 | 0 | |
| SELECT `Author`.`id`, `Author`.`lang`, `Author`.`name`, `Author`.`surname`, `Author`.`position`, `Author`.`company`, `Author`.`phone`, `Author`.`email`, `Author`.`description`, `Author`.`photo_reference`, `Author`.`author`, `Author`.`lecturer`, `Author`.`expert`, `Author`.`employee`, `Author`.`editor`, `Author`.`created`, `Author`.`modified`, `Author`.`new_id`, (CONCAT(`Author`.`name`, " ", `Author`.`surname`)) AS `Author__full_name`, `JournalCategoriesAuthor`.`id`, `JournalCategoriesAuthor`.`author_id`, `JournalCategoriesAuthor`.`journal_category_id` FROM `ifinanses_ifinanses`.`authors` AS `Author` JOIN `ifinanses_ifinanses`.`journal_categories_authors` AS `JournalCategoriesAuthor` ON (`JournalCategoriesAuthor`.`journal_category_id` = 11 AND `JournalCategoriesAuthor`.`author_id` = `Author`.`id`) | 1 | 1 | 1 | |
| SELECT `JournalChapter`.`id`, `JournalChapter`.`journal_id`, `JournalChapter`.`title`, `JournalChapter`.`created`, `JournalChapter`.`modified` FROM `ifinanses_ifinanses`.`journal_chapters` AS `JournalChapter` WHERE `JournalChapter`.`journal_id` = (422) | 10 | 10 | 1 | maybe slow |
| SELECT `JournalSubchapter`.`id`, `JournalSubchapter`.`journal_chapter_id`, `JournalSubchapter`.`title`, `JournalSubchapter`.`description`, `JournalSubchapter`.`created`, `JournalSubchapter`.`modified` FROM `ifinanses_ifinanses`.`journal_subchapters` AS `JournalSubchapter` WHERE `JournalSubchapter`.`journal_chapter_id` IN (4282, 4283, 4284, 4285, 4286, 4287, 4288, 4289, 4290, 4291) | 18 | 18 | 1 | 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.journals' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `StaticUrl`.`section`, `StaticUrl`.`url` FROM `ifinanses_ifinanses`.`static_urls` AS `StaticUrl` WHERE `StaticUrl`.`lang` = 'lv' | 63 | 63 | 1 | |