menu
menu
Меню
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `baza74654_tclub`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '4cf3ce5e161bcf0fff112f05cc45317e' LIMIT 1 | 0 | 0 | 1 | |
| 2 | SELECT `Plugin`.`enabled` FROM `baza74654_tclub`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 1 | |
| 3 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core`, `Role`.`show_gender`, `Role`.`show_profile_type` FROM `baza74654_tclub`.`roles` AS `Role` WHERE `Role`.`id` = 3 LIMIT 1 | 1 | 1 | 1 | |
| 4 | SELECT `Page`.`id` FROM `baza74654_tclub`.`pages` AS `Page` LEFT JOIN `baza74654_tclub`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) WHERE `Page`.`uri` = 'users.member_login' ORDER BY `Page`.`weight` asc LIMIT 1 | 1 | 1 | 2 | |
| 5 | SELECT `CoreContent`.`id`, `CoreContent`.`page_id`, `CoreContent`.`type`, `CoreContent`.`name`, `CoreContent`.`component`, `CoreContent`.`parent_id`, `CoreContent`.`order`, `CoreContent`.`params`, `CoreContent`.`attribs`, `CoreContent`.`lft`, `CoreContent`.`rght`, `CoreContent`.`column`, `CoreContent`.`core_block_id`, `CoreContent`.`core_content_count`, `CoreContent`.`invisible`, `CoreContent`.`core_block_title`, `CoreContent`.`plugin`, `CoreContent`.`role_access` FROM `baza74654_tclub`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (90) | 2 | 2 | 1 | |
| 6 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `baza74654_tclub`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 90 | 1 | 1 | 0 | |
| 7 | SELECT `MyCorePage`.`id`, `MyCorePage`.`title`, `MyCorePage`.`alias`, `MyCorePage`.`content`, `MyCorePage`.`permission`, `MyCorePage`.`params`, `MyCorePage`.`created`, `MyCorePage`.`modified`, `MyCorePage`.`menu`, `MyCorePage`.`icon_class`, `MyCorePage`.`weight`, `MyCorePage`.`url`, `MyCorePage`.`uri`, `MyCorePage`.`description`, `MyCorePage`.`keywords`, `MyCorePage`.`custom`, `MyCorePage`.`fragment`, `MyCorePage`.`layout`, `MyCorePage`.`levels`, `MyCorePage`.`provides`, `MyCorePage`.`view_count`, `MyCorePage`.`type`, `MyCorePage`.`search`, `MyCorePage`.`theme_id`, `MyCorePage`.`core_content_count`, `MyCorePage`.`plugin`, `MyCorePage`.`show_layout` FROM `baza74654_tclub`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 90 | 1 | 1 | 0 | |
| 8 | SELECT `Parent`.`id`, `Parent`.`page_id`, `Parent`.`type`, `Parent`.`name`, `Parent`.`component`, `Parent`.`parent_id`, `Parent`.`order`, `Parent`.`params`, `Parent`.`attribs`, `Parent`.`lft`, `Parent`.`rght`, `Parent`.`column`, `Parent`.`core_block_id`, `Parent`.`core_content_count`, `Parent`.`invisible`, `Parent`.`core_block_title`, `Parent`.`plugin`, `Parent`.`role_access` FROM `baza74654_tclub`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 140 | 1 | 1 | 1 | |
| 9 | SELECT `Children`.`id`, `Children`.`page_id`, `Children`.`type`, `Children`.`name`, `Children`.`component`, `Children`.`parent_id`, `Children`.`order`, `Children`.`params`, `Children`.`attribs`, `Children`.`lft`, `Children`.`rght`, `Children`.`column`, `Children`.`core_block_id`, `Children`.`core_content_count`, `Children`.`invisible`, `Children`.`core_block_title`, `Children`.`plugin`, `Children`.`role_access` FROM `baza74654_tclub`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (140, 141) | 1 | 1 | 2 | |
| 10 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value` FROM `baza74654_tclub`.`core_content_values` AS `CoreContentValue` WHERE `CoreContentValue`.`content_id` IN (140, 141) | 0 | 0 | 1 | |
| 11 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `baza74654_tclub`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (140, 141) ORDER BY `id` ASC | 4 | 4 | 2 | |
| 12 | SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `baza74654_tclub`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (90) ORDER BY `id` ASC | 2 | 2 | 2 | |
| 13 | SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `baza74654_tclub`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (90) ORDER BY `id` ASC | 2 | 2 | 1 | |
| 14 | SELECT `Popup`.`id`, `Popup`.`page_id`, `Popup`.`title`, `Popup`.`body`, `Popup`.`onetime`, `Popup`.`popup_option`, `Popup`.`permission`, `Popup`.`enable`, (`I18n__titleTranslation`.`content`) AS `Popup__i18n_titleTranslation`, (`I18n__bodyTranslation`.`content`) AS `Popup__i18n_bodyTranslation`, `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, `Page`.`plugin`, `Page`.`show_layout` FROM `baza74654_tclub`.`popups` AS `Popup` LEFT JOIN `baza74654_tclub`.`pages` AS `Page` ON (`Popup`.`page_id` = `Page`.`id`) INNER JOIN `baza74654_tclub`.`i18n` AS `I18n__titleTranslation` ON (`Popup`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Popup' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ukr') INNER JOIN `baza74654_tclub`.`i18n` AS `I18n__bodyTranslation` ON (`Popup`.`id` = `I18n__bodyTranslation`.`foreign_key` AND `I18n__bodyTranslation`.`model` = 'Popup' AND `I18n__bodyTranslation`.`field` = 'body' AND `I18n__bodyTranslation`.`locale` = 'ukr') WHERE `Popup`.`page_id` = 0 AND `enable` = '1' LIMIT 1 | 0 | 0 | 3 | |
| 15 | SELECT `Popup`.`id`, `Popup`.`page_id`, `Popup`.`title`, `Popup`.`body`, `Popup`.`onetime`, `Popup`.`popup_option`, `Popup`.`permission`, `Popup`.`enable`, (`I18n__titleTranslation`.`content`) AS `Popup__i18n_titleTranslation`, (`I18n__bodyTranslation`.`content`) AS `Popup__i18n_bodyTranslation`, `Page`.`id`, `Page`.`title`, `Page`.`alias`, `Page`.`content`, `Page`.`permission`, `Page`.`params`, `Page`.`created`, `Page`.`modified`, `Page`.`menu`, `Page`.`icon_class`, `Page`.`weight`, `Page`.`url`, `Page`.`uri`, `Page`.`description`, `Page`.`keywords`, `Page`.`custom`, `Page`.`fragment`, `Page`.`layout`, `Page`.`levels`, `Page`.`provides`, `Page`.`view_count`, `Page`.`type`, `Page`.`search`, `Page`.`theme_id`, `Page`.`core_content_count`, `Page`.`plugin`, `Page`.`show_layout` FROM `baza74654_tclub`.`popups` AS `Popup` LEFT JOIN `baza74654_tclub`.`pages` AS `Page` ON (`Popup`.`page_id` = `Page`.`id`) INNER JOIN `baza74654_tclub`.`i18n` AS `I18n__titleTranslation` ON (`Popup`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Popup' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ukr') INNER JOIN `baza74654_tclub`.`i18n` AS `I18n__bodyTranslation` ON (`Popup`.`id` = `I18n__bodyTranslation`.`foreign_key` AND `I18n__bodyTranslation`.`model` = 'Popup' AND `I18n__bodyTranslation`.`field` = 'body' AND `I18n__bodyTranslation`.`locale` = 'ukr') WHERE `Popup`.`page_id` = 90 AND `enable` = '1' LIMIT 1 | 0 | 0 | 3 | |
| 16 | SELECT COUNT(DISTINCT(`OidcProvider`.`id`)) AS count FROM `baza74654_tclub`.`oidc_providers` AS `OidcProvider` INNER JOIN `baza74654_tclub`.`i18n` AS `I18nModel` ON (`OidcProvider`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'OidcProvider' AND `I18nModel`.`locale` = 'ukr') WHERE `OidcProvider`.`status` = '1' | 1 | 1 | 3 | |
| 17 | SELECT `OidcProvider`.`id`, `OidcProvider`.`name`, `OidcProvider`.`login_text`, `OidcProvider`.`login_img`, `OidcProvider`.`login_background`, `OidcProvider`.`login_color`, `OidcProvider`.`app_name`, `OidcProvider`.`server`, `OidcProvider`.`callback_url`, `OidcProvider`.`client_id`, `OidcProvider`.`client_secret`, `OidcProvider`.`scope`, `OidcProvider`.`authorize_endpoint`, `OidcProvider`.`access_token_endpoint`, `OidcProvider`.`get_user_info_endpoint`, `OidcProvider`.`logout_endpoint`, `OidcProvider`.`logout_endpoint_token`, `OidcProvider`.`map_user_id`, `OidcProvider`.`map_email`, `OidcProvider`.`map_name`, `OidcProvider`.`map_avatar`, `OidcProvider`.`status`, `OidcProvider`.`created`, `OidcProvider`.`modified`, (`I18n__login_textTranslation`.`content`) AS `OidcProvider__i18n_login_textTranslation` FROM `baza74654_tclub`.`oidc_providers` AS `OidcProvider` INNER JOIN `baza74654_tclub`.`i18n` AS `I18n__login_textTranslation` ON (`OidcProvider`.`id` = `I18n__login_textTranslation`.`foreign_key` AND `I18n__login_textTranslation`.`model` = 'OidcProvider' AND `I18n__login_textTranslation`.`field` = 'login_text' AND `I18n__login_textTranslation`.`locale` = 'ukr') WHERE `OidcProvider`.`status` = '1' ORDER BY `OidcProvider`.`id` DESC | 2 | 2 | 2 | |
| 18 | SELECT `login_textTranslation`.`id`, `login_textTranslation`.`locale`, `login_textTranslation`.`model`, `login_textTranslation`.`foreign_key`, `login_textTranslation`.`field`, `login_textTranslation`.`content` FROM `baza74654_tclub`.`i18n` AS `login_textTranslation` WHERE `model` = 'OidcProvider' AND `field` = 'login_text' AND `login_textTranslation`.`foreign_key` IN (6, 5) ORDER BY `id` ASC | 4 | 4 | 2 | |
| 19 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css_dark`, `Theme`.`custom_css` FROM `baza74654_tclub`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 1 | |
| 20 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css_dark`, `Theme`.`custom_css` FROM `baza74654_tclub`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 1 | |
| 21 | SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `baza74654_tclub`.`settings` AS `Setting` LEFT JOIN `baza74654_tclub`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 1 | |
| 22 | SELECT `Setting`.`id`, `Setting`.`group_id`, `Setting`.`label`, `Setting`.`name`, `Setting`.`field`, `Setting`.`value`, `Setting`.`is_hidden`, `Setting`.`version_id`, `Setting`.`type_id`, `Setting`.`value_actual`, `Setting`.`value_default`, `Setting`.`description`, `Setting`.`ordering`, `Setting`.`is_boot`, `SettingGroup`.`id`, `SettingGroup`.`parent_id`, `SettingGroup`.`lft`, `SettingGroup`.`rght`, `SettingGroup`.`group_type`, `SettingGroup`.`module_id`, `SettingGroup`.`name` FROM `baza74654_tclub`.`settings` AS `Setting` LEFT JOIN `baza74654_tclub`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 1 | |
| 23 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css_dark`, `Theme`.`custom_css` FROM `baza74654_tclub`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 1 | |
| 24 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css_dark`, `Theme`.`custom_css` FROM `baza74654_tclub`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 |