Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `UserSetting`.`id`, `UserSetting`.`name`, `UserSetting`.`name_public`, `UserSetting`.`value`, `UserSetting`.`type`, `UserSetting`.`category` FROM `madarka_hu`.`madarka_user_settings` AS `UserSetting` WHERE 1 = 1 | 80 | 80 | 2 | |
SELECT `Content`.`id`, `Content`.`page_name`, `Content`.`url_name`, `Content`.`page_content`, `Content`.`page_title`, `Content`.`created`, `Content`.`modified` FROM `madarka_hu`.`madarka_contents` AS `Content` WHERE 1 = 1 | 1 | 1 | 1 | |
SELECT `UserActivity`.`id`, `UserActivity`.`useragent`, `UserActivity`.`user_id`, `UserActivity`.`last_action`, `UserActivity`.`last_url`, `UserActivity`.`logout_time`, `UserActivity`.`type`, `UserActivity`.`user_browser`, `UserActivity`.`ip_address`, `UserActivity`.`bad_login`, `UserActivity`.`logout`, `UserActivity`.`deleted`, `UserActivity`.`status`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `madarka_hu`.`madarka_user_activities` AS `UserActivity` WHERE `UserActivity`.`useragent` = '492e1f358b76e7e3e07a00036e13de100lt4495gbr9mseq1tod376icp6' AND `UserActivity`.`type` != 'login' | 0 | 0 | 259 | maybe slow |
INSERT INTO `madarka_hu`.`madarka_user_activities` (`useragent`, `user_id`, `last_action`, `last_url`, `user_browser`, `ip_address`, `status`, `modified`, `created`) VALUES ('492e1f358b76e7e3e07a00036e13de100lt4495gbr9mseq1tod376icp6', NULL, 1660502271, '/', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '18.204.56.185', 0, '2022-08-14 16:37:51', '2022-08-14 16:37:51') | 1 | 1 | 3 | maybe slow |
SELECT COUNT(*) AS `count` FROM `madarka_hu`.`madarka_page_contents` AS `PageContent` WHERE `PageContent`.`id` = 1 | 1 | 1 | 0 | |
SELECT `PageContent`.`id`, `PageContent`.`name`, `PageContent`.`lead`, `PageContent`.`text`, `PageContent`.`status`, `PageContent`.`sortval`, `PageContent`.`slug`, `PageContent`.`title`, `PageContent`.`meta_keywords`, `PageContent`.`meta_description`, `PageContent`.`gallery_id`, `PageContent`.`style`, `PageContent`.`created`, `PageContent`.`modified`, (`I18n__nameTranslation`.`content`) AS `PageContent__i18n_nameTranslation`, (`I18n__leadTranslation`.`content`) AS `PageContent__i18n_leadTranslation`, (`I18n__textTranslation`.`content`) AS `PageContent__i18n_textTranslation`, (`I18n__slugTranslation`.`content`) AS `PageContent__i18n_slugTranslation`, (`I18n__titleTranslation`.`content`) AS `PageContent__i18n_titleTranslation`, (`I18n__metaKeywordsTranslation`.`content`) AS `PageContent__i18n_metaKeywordsTranslation`, (`I18n__metaDescriptionTranslation`.`content`) AS `PageContent__i18n_metaDescriptionTranslation`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`model`, `Gallery`.`is_real_gallery`, `Gallery`.`date`, `Gallery`.`image_limit`, `Gallery`.`file_limit`, `Gallery`.`width_limit`, `Gallery`.`height_limit`, `Gallery`.`status`, `Gallery`.`created` FROM `madarka_hu`.`madarka_page_contents` AS `PageContent` LEFT JOIN `madarka_hu`.`madarka_galleries` AS `Gallery` ON (`PageContent`.`gallery_id` = `Gallery`.`id`) INNER JOIN `madarka_hu`.`madarka_i18n` AS `I18n__nameTranslation` ON (`PageContent`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'PageContent' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'hun') INNER JOIN `madarka_hu`.`madarka_i18n` AS `I18n__leadTranslation` ON (`PageContent`.`id` = `I18n__leadTranslation`.`foreign_key` AND `I18n__leadTranslation`.`model` = 'PageContent' AND `I18n__leadTranslation`.`field` = 'lead' AND `I18n__leadTranslation`.`locale` = 'hun') INNER JOIN `madarka_hu`.`madarka_i18n` AS `I18n__textTranslation` ON (`PageContent`.`id` = `I18n__textTranslation`.`foreign_key` AND `I18n__textTranslation`.`model` = 'PageContent' AND `I18n__textTranslation`.`field` = 'text' AND `I18n__textTranslation`.`locale` = 'hun') INNER JOIN `madarka_hu`.`madarka_i18n` AS `I18n__slugTranslation` ON (`PageContent`.`id` = `I18n__slugTranslation`.`foreign_key` AND `I18n__slugTranslation`.`model` = 'PageContent' AND `I18n__slugTranslation`.`field` = 'slug' AND `I18n__slugTranslation`.`locale` = 'hun') INNER JOIN `madarka_hu`.`madarka_i18n` AS `I18n__titleTranslation` ON (`PageContent`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'PageContent' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'hun') INNER JOIN `madarka_hu`.`madarka_i18n` AS `I18n__metaKeywordsTranslation` ON (`PageContent`.`id` = `I18n__metaKeywordsTranslation`.`foreign_key` AND `I18n__metaKeywordsTranslation`.`model` = 'PageContent' AND `I18n__metaKeywordsTranslation`.`field` = 'meta_keywords' AND `I18n__metaKeywordsTranslation`.`locale` = 'hun') INNER JOIN `madarka_hu`.`madarka_i18n` AS `I18n__metaDescriptionTranslation` ON (`PageContent`.`id` = `I18n__metaDescriptionTranslation`.`foreign_key` AND `I18n__metaDescriptionTranslation`.`model` = 'PageContent' AND `I18n__metaDescriptionTranslation`.`field` = 'meta_description' AND `I18n__metaDescriptionTranslation`.`locale` = 'hun') WHERE `PageContent`.`id` = 1 LIMIT 1 | 1 | 1 | 12 | maybe slow |
SELECT `Upload`.`id`, `Upload`.`name`, `Upload`.`filename`, `Upload`.`url`, `Upload`.`type`, `Upload`.`image`, `Upload`.`main_image`, `Upload`.`background`, `Upload`.`sortval`, `Upload`.`width`, `Upload`.`height`, `Upload`.`standing`, `Upload`.`gallery_id`, `Upload`.`created` FROM `madarka_hu`.`madarka_uploads` AS `Upload` WHERE `Upload`.`gallery_id` = 4 AND `Upload`.`main_image` = '1' AND `Upload`.`image` = '1' | 1 | 1 | 2 | maybe slow |
SELECT `Uploads`.`id`, `Uploads`.`name`, `Uploads`.`filename`, `Uploads`.`url`, `Uploads`.`type`, `Uploads`.`image`, `Uploads`.`main_image`, `Uploads`.`background`, `Uploads`.`sortval`, `Uploads`.`width`, `Uploads`.`height`, `Uploads`.`standing`, `Uploads`.`gallery_id`, `Uploads`.`created` FROM `madarka_hu`.`madarka_uploads` AS `Uploads` WHERE `image` = 1 AND `Uploads`.`gallery_id` = (4) ORDER BY `sortval` asc | 1 | 1 | 0 | |
SELECT `Background`.`id`, `Background`.`name`, `Background`.`filename`, `Background`.`url`, `Background`.`type`, `Background`.`image`, `Background`.`main_image`, `Background`.`background`, `Background`.`sortval`, `Background`.`width`, `Background`.`height`, `Background`.`standing`, `Background`.`gallery_id`, `Background`.`created` FROM `madarka_hu`.`madarka_uploads` AS `Background` WHERE `image` = 1 AND `background` = 1 AND `Background`.`gallery_id` = (4) ORDER BY `sortval` asc | 0 | 0 | 0 | |
SELECT `Files`.`id`, `Files`.`name`, `Files`.`filename`, `Files`.`url`, `Files`.`type`, `Files`.`image`, `Files`.`main_image`, `Files`.`background`, `Files`.`sortval`, `Files`.`width`, `Files`.`height`, `Files`.`standing`, `Files`.`gallery_id`, `Files`.`created` FROM `madarka_hu`.`madarka_uploads` AS `Files` WHERE `image` = 0 AND `Files`.`gallery_id` = (4) ORDER BY `sortval` asc | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `madarka_hu`.`madarka_i18n` AS `nameTranslation` WHERE `model` = 'PageContent' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) | 2 | 2 | 2 | |
SELECT `leadTranslation`.`id`, `leadTranslation`.`locale`, `leadTranslation`.`model`, `leadTranslation`.`foreign_key`, `leadTranslation`.`field`, `leadTranslation`.`content` FROM `madarka_hu`.`madarka_i18n` AS `leadTranslation` WHERE `model` = 'PageContent' AND `field` = 'lead' AND `leadTranslation`.`foreign_key` = (1) | 2 | 2 | 1 | maybe slow |
SELECT `textTranslation`.`id`, `textTranslation`.`locale`, `textTranslation`.`model`, `textTranslation`.`foreign_key`, `textTranslation`.`field`, `textTranslation`.`content` FROM `madarka_hu`.`madarka_i18n` AS `textTranslation` WHERE `model` = 'PageContent' AND `field` = 'text' AND `textTranslation`.`foreign_key` = (1) | 2 | 2 | 1 | maybe slow |
SELECT `slugTranslation`.`id`, `slugTranslation`.`locale`, `slugTranslation`.`model`, `slugTranslation`.`foreign_key`, `slugTranslation`.`field`, `slugTranslation`.`content` FROM `madarka_hu`.`madarka_i18n` AS `slugTranslation` WHERE `model` = 'PageContent' AND `field` = 'slug' AND `slugTranslation`.`foreign_key` = (1) | 2 | 2 | 1 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `madarka_hu`.`madarka_i18n` AS `titleTranslation` WHERE `model` = 'PageContent' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (1) | 2 | 2 | 1 | maybe slow |
SELECT `metaKeywordsTranslation`.`id`, `metaKeywordsTranslation`.`locale`, `metaKeywordsTranslation`.`model`, `metaKeywordsTranslation`.`foreign_key`, `metaKeywordsTranslation`.`field`, `metaKeywordsTranslation`.`content` FROM `madarka_hu`.`madarka_i18n` AS `metaKeywordsTranslation` WHERE `model` = 'PageContent' AND `field` = 'meta_keywords' AND `metaKeywordsTranslation`.`foreign_key` = (1) | 2 | 2 | 1 | maybe slow |
SELECT `metaDescriptionTranslation`.`id`, `metaDescriptionTranslation`.`locale`, `metaDescriptionTranslation`.`model`, `metaDescriptionTranslation`.`foreign_key`, `metaDescriptionTranslation`.`field`, `metaDescriptionTranslation`.`content` FROM `madarka_hu`.`madarka_i18n` AS `metaDescriptionTranslation` WHERE `model` = 'PageContent' AND `field` = 'meta_description' AND `metaDescriptionTranslation`.`foreign_key` = (1) | 2 | 2 | 1 | maybe slow |