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 | 26 | 26 | 12 | 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, 202, 21, 28, 18, 23, 29, 25, 126, 159, 24, 30, 141, 22, 112, 147, 166, 203) | 1 | 1 | 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 0 AND `lang` = 'lv' AND `active` = 1 | 9 | 9 | 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 3 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 4 AND `lang` = 'lv' AND `active` = 1 | 7 | 7 | 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 5 AND `lang` = 'lv' AND `active` = 1 | 8 | 8 | 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 6 AND `lang` = 'lv' AND `active` = 1 | 5 | 5 | 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 8 AND `lang` = 'lv' AND `active` = 1 | 5 | 5 | 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` 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 81 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` FROM `ifinanses_ifinanses`.`article_categories` AS `ArticleCategory` WHERE `parent_id` = 223 AND `lang` = 'lv' AND `active` = 1 | 1 | 1 | 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` 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' | 9 | 9 | 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` <= '2025-08-07 15:16:43') AND (`Banner`.`date_to` >= '2025-08-07 15:16:43'))))) AND (((`Banner`.`exposition` IS NULL) OR (`Banner`.`exposition` = 0) OR (`Banner`.`exposition` > `Banner`.`total_views`)))) | 2 | 2 | 7 | 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, 1955) | 1994 | 1994 | 11 | |
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` < '2025-08-07' AND `Banner`.`lang` = 'lv' AND NOT (`Banner`.`date_to` IS NULL) | 0 | 0 | 3 | 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`, `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`, `MainPicture`.`id`, `MainPicture`.`img_name`, `MainPicture`.`img_type`, `MainPicture`.`lang`, `MainPicture`.`parent_type`, `MainPicture`.`parent_id`, `MainPicture`.`user_id`, `MainPicture`.`created`, `MainPicture`.`modified` FROM `ifinanses_ifinanses`.`seminars` AS `Seminar` LEFT JOIN `ifinanses_ifinanses`.`sellable_objects` AS `SellableObject` ON (`SellableObject`.`parent_id` = `Seminar`.`id` AND `SellableObject`.`parent_type` = 'seminar') LEFT JOIN `ifinanses_ifinanses`.`pictures` AS `MainPicture` ON (`MainPicture`.`parent_id` = `Seminar`.`id` AND `MainPicture`.`parent_type` = 'seminar') WHERE `Seminar`.`slug` = 'jaunas-prasibas-kiberdrosibai-uznemumos' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Loyalty`.`id`, `Loyalty`.`parent_id`, `Loyalty`.`parent_type`, `Loyalty`.`level_1`, `Loyalty`.`level_2`, `Loyalty`.`level_3`, `Loyalty`.`level_4`, `Loyalty`.`level_5`, `Loyalty`.`created`, `Loyalty`.`modified` FROM `ifinanses_ifinanses`.`loyalties` AS `Loyalty` WHERE `Loyalty`.`parent_id` = 594 AND `Loyalty`.`parent_type` = 'sellable_object' | 1 | 1 | 1 | |
SELECT `Upload`.`id`, `Upload`.`file_name`, `Upload`.`file_type`, `Upload`.`file_size`, `Upload`.`parent_type`, `Upload`.`parent_id`, `Upload`.`user_id`, `Upload`.`created`, `Upload`.`modified`, `Upload`.`is_audio`, `Upload`.`duration` FROM `ifinanses_ifinanses`.`uploads` AS `Upload` WHERE `Upload`.`parent_type` = 'seminar' AND `Upload`.`parent_id` = (448) | 0 | 0 | 0 | |
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_type` = 'seminar_report' AND `Picture`.`parent_id` = (448) | 0 | 0 | 0 | |
SELECT `BoughtItem`.`id`, `BoughtItem`.`bought_pack_id`, `BoughtItem`.`parent_type`, `BoughtItem`.`parent_id`, `BoughtItem`.`title`, `BoughtItem`.`payment_method`, `BoughtItem`.`user_id`, `BoughtItem`.`buyer_type`, `BoughtItem`.`sellable_pack_term_id`, `BoughtItem`.`sellable_pack_count_id`, `BoughtItem`.`sellable_pack_sample_id`, `BoughtItem`.`active_from`, `BoughtItem`.`active_to`, `BoughtItem`.`agent_discount`, `BoughtItem`.`status`, `BoughtItem`.`signed`, `BoughtItem`.`active`, `BoughtItem`.`loyalty_counted`, `BoughtItem`.`recreated`, `BoughtItem`.`price`, `BoughtItem`.`count`, `BoughtItem`.`created`, `BoughtItem`.`modified`, `BoughtItem`.`old_user_id`, `BoughtItem`.`manual_insert`, `BoughtItem`.`subuser_cnt`, `BoughtItem`.`created_by`, `BoughtItem`.`cancelled_at` FROM `ifinanses_ifinanses`.`bought_items` AS `BoughtItem` WHERE `BoughtItem`.`parent_type` = 'seminar' AND `BoughtItem`.`parent_id` = (448) | 0 | 0 | 16 | maybe slow |
SELECT `SeminarSponsor`.`id`, `SeminarSponsor`.`sponsor_id`, `SeminarSponsor`.`parent_id`, `SeminarSponsor`.`parent_type`, `SeminarSponsor`.`general` FROM `ifinanses_ifinanses`.`seminar_sponsors` AS `SeminarSponsor` WHERE `SeminarSponsor`.`parent_type` = 'seminar' AND `SeminarSponsor`.`parent_id` = (448) | 0 | 0 | 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`, `AuthorsSeminar`.`id`, `AuthorsSeminar`.`author_id`, `AuthorsSeminar`.`seminar_id` FROM `ifinanses_ifinanses`.`authors` AS `Author` JOIN `ifinanses_ifinanses`.`authors_seminars` AS `AuthorsSeminar` ON (`AuthorsSeminar`.`seminar_id` = 448 AND `AuthorsSeminar`.`author_id` = `Author`.`id`) | 1 | 1 | 1 | |
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` = 3322 AND `Picture`.`parent_type` = 'author' | 1 | 1 | 1 | |
SELECT `Employee`.`id`, `Employee`.`lang`, `Employee`.`name`, `Employee`.`surname`, `Employee`.`position`, `Employee`.`company`, `Employee`.`phone`, `Employee`.`email`, `Employee`.`description`, `Employee`.`photo_reference`, `Employee`.`author`, `Employee`.`lecturer`, `Employee`.`expert`, `Employee`.`employee`, `Employee`.`editor`, `Employee`.`created`, `Employee`.`modified`, `Employee`.`new_id`, (CONCAT(`Employee`.`name`, " ", `Employee`.`surname`)) AS `Employee__full_name`, `AuthorsSeminarsContact`.`id`, `AuthorsSeminarsContact`.`author_id`, `AuthorsSeminarsContact`.`seminar_id` FROM `ifinanses_ifinanses`.`authors` AS `Employee` JOIN `ifinanses_ifinanses`.`authors_seminars_contacts` AS `AuthorsSeminarsContact` ON (`AuthorsSeminarsContact`.`seminar_id` = 448 AND `AuthorsSeminarsContact`.`author_id` = `Employee`.`id`) | 1 | 1 | 14 | 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` = 2688 AND `Picture`.`parent_type` = 'author' | 1 | 1 | 1 | |
SELECT `Sponsor`.`id`, `Sponsor`.`lang`, `Sponsor`.`title`, `Sponsor`.`general`, `Sponsor`.`created`, `Sponsor`.`modified`, (CONCAT(`Sponsor`.`title`)) AS `Sponsor__full_name`, `SeminarSponsor`.`id`, `SeminarSponsor`.`sponsor_id`, `SeminarSponsor`.`parent_id`, `SeminarSponsor`.`parent_type`, `SeminarSponsor`.`general` FROM `ifinanses_ifinanses`.`sponsors` AS `Sponsor` JOIN `ifinanses_ifinanses`.`seminar_sponsors` AS `SeminarSponsor` ON (`SeminarSponsor`.`parent_id` = 448 AND `SeminarSponsor`.`sponsor_id` = `Sponsor`.`id`) WHERE `SeminarSponsor`.`parent_type` = 'seminar' | 0 | 0 | 8 | 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.all_seminari' LIMIT 1 | 1 | 1 | 13 | 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.seminari' LIMIT 1 | 1 | 1 | 1 | |
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` = 448) 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 | 1 | 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` = 448) 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 | 0 | |
SELECT `StaticUrl`.`section`, `StaticUrl`.`url` FROM `ifinanses_ifinanses`.`static_urls` AS `StaticUrl` WHERE `StaticUrl`.`lang` = 'lv' | 63 | 63 | 0 | |