menu
menu
Menu
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Currency`.`id`, `Currency`.`currency_code`, `Currency`.`symbol`, `Currency`.`name`, `Currency`.`description`, `Currency`.`ordering`, `Currency`.`is_default`, `Currency`.`is_active` FROM `d020ed2b`.`currencies` AS `Currency` WHERE `Currency`.`is_default` = '1' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `d020ed2b`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '285dbe53d18cf4a3a915b3c17585ec83' LIMIT 1 | 0 | 0 | 0 | |
| 3 | SELECT `Language`.`key`, `Language`.`name` FROM `d020ed2b`.`languages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`name` asc | 2 | 2 | 0 | |
| 4 | SELECT `Language`.`id`, `Language`.`key`, `Language`.`name`, `Language`.`rtl` FROM `d020ed2b`.`languages` AS `Language` WHERE 1 = 1 ORDER BY `Language`.`name` asc | 2 | 2 | 0 | |
| 5 | SELECT `Theme`.`key`, `Theme`.`name` FROM `d020ed2b`.`themes` AS `Theme` WHERE `Theme`.`key` != 'mooApp' | 2 | 2 | 0 | |
| 6 | SELECT `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`, (`I18n__titleTranslation`.`content`) AS `Page__i18n_titleTranslation`, (`I18n__contentTranslation`.`content`) AS `Page__i18n_contentTranslation`, `MyCoreTheme`.`id`, `MyCoreTheme`.`key`, `MyCoreTheme`.`name`, `MyCoreTheme`.`core`, `MyCoreTheme`.`custom_css_enable`, `MyCoreTheme`.`custom_css_landing`, `MyCoreTheme`.`custom_css`, `MyCoreTheme`.`custom_css_dark` FROM `d020ed2b`.`pages` AS `Page` LEFT JOIN `d020ed2b`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) INNER JOIN `d020ed2b`.`i18n` AS `I18n__titleTranslation` ON (`Page`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Page' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'deu') INNER JOIN `d020ed2b`.`i18n` AS `I18n__contentTranslation` ON (`Page`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Page' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'deu') WHERE `Page`.`uri` = 'histories.ajax_show' ORDER BY `Page`.`weight` asc LIMIT 1 | 0 | 0 | 0 | |
| 7 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value`, (`I18n__valueTranslation`.`content`) AS `CoreContentValue__i18n_valueTranslation`, `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 `d020ed2b`.`core_content_values` AS `CoreContentValue` LEFT JOIN `d020ed2b`.`core_contents` AS `CoreContent` ON (`CoreContentValue`.`content_id` = `CoreContent`.`id`) INNER JOIN `d020ed2b`.`i18n` AS `I18n__valueTranslation` ON (`CoreContentValue`.`id` = `I18n__valueTranslation`.`foreign_key` AND `I18n__valueTranslation`.`model` = 'CoreContentValue' AND `I18n__valueTranslation`.`field` = 'value' AND `I18n__valueTranslation`.`locale` = 'deu') WHERE `CoreContentValue`.`content_id` = 149 LIMIT 1 | 0 | 0 | 0 | |
| 8 | SELECT `CommentHistory`.`id`, `CommentHistory`.`user_id`, `CommentHistory`.`content`, `CommentHistory`.`created`, `CommentHistory`.`photo`, `CommentHistory`.`link`, `CommentHistory`.`type`, `CommentHistory`.`target_id`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`expired_time_code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`group_count`, `User`.`event_count`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`package_select`, `User`.`who_can_see_gender`, `User`.`darkmode`, `User`.`lock_delete`, `User`.`chat_count`, `User`.`chat_privacy` FROM `d020ed2b`.`comment_histories` AS `CommentHistory` LEFT JOIN `d020ed2b`.`users` AS `User` ON (`CommentHistory`.`user_id` = `User`.`id`) WHERE `type` = 'activity' AND `target_id` = 105178 ORDER BY `CommentHistory`.`created` ASC LIMIT 12 | 0 | 0 | 1 | |
| 9 | SELECT COUNT(*) AS `count` FROM `d020ed2b`.`comment_histories` AS `CommentHistory` WHERE `type` = 'activity' AND `target_id` = 105178 | 1 | 1 | 1 | |
| 10 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `d020ed2b`.`themes` AS `Theme` WHERE `Theme`.`key` = 'black' LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `d020ed2b`.`themes` AS `Theme` WHERE `Theme`.`key` = 'black' LIMIT 1 | 1 | 1 | 0 | |
| 12 | 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 `d020ed2b`.`settings` AS `Setting` LEFT JOIN `d020ed2b`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 0 | |
| 13 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `d020ed2b`.`core_menus` AS `Coremenu` WHERE `alias` = 'main-menu' LIMIT 1 | 1 | 1 | 0 | |
| 14 | SELECT `CoreMenuItem`.`id`, `CoreMenuItem`.`parent_id`, `CoreMenuItem`.`lft`, `CoreMenuItem`.`rght`, `CoreMenuItem`.`name`, `CoreMenuItem`.`original_name`, `CoreMenuItem`.`url`, `CoreMenuItem`.`title_attribute`, `CoreMenuItem`.`font_class`, `CoreMenuItem`.`is_active`, `CoreMenuItem`.`new_blank`, `CoreMenuItem`.`role_access`, `CoreMenuItem`.`menu_id`, `CoreMenuItem`.`type`, `CoreMenuItem`.`menu_order`, `CoreMenuItem`.`plugin`, `CoreMenuItem`.`group`, `CoreMenuItem`.`url_app`, `CoreMenuItem`.`font_class_app`, `CoreMenuItem`.`show_web`, `CoreMenuItem`.`show_app` FROM `d020ed2b`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (1) ORDER BY `CoreMenuItem`.`menu_order` ASC | 7 | 7 | 0 | |
| 15 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `d020ed2b`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (11, 12, 19, 20, 18, 16, 17) ORDER BY `id` ASC | 14 | 14 | 0 | |
| 16 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `d020ed2b`.`core_menu_items` AS `Coremenuitem` INNER JOIN `d020ed2b`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'deu') WHERE `parent_id` = 11 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
| 17 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `d020ed2b`.`core_menu_items` AS `Coremenuitem` INNER JOIN `d020ed2b`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'deu') WHERE `parent_id` = 12 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
| 18 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `d020ed2b`.`core_menu_items` AS `Coremenuitem` INNER JOIN `d020ed2b`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'deu') WHERE `parent_id` = 19 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
| 19 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `d020ed2b`.`core_menu_items` AS `Coremenuitem` INNER JOIN `d020ed2b`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'deu') WHERE `parent_id` = 20 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
| 20 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `d020ed2b`.`core_menu_items` AS `Coremenuitem` INNER JOIN `d020ed2b`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'deu') WHERE `parent_id` = 18 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
| 21 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `d020ed2b`.`core_menu_items` AS `Coremenuitem` INNER JOIN `d020ed2b`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'deu') WHERE `parent_id` = 16 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
| 22 | SELECT `Coremenuitem`.`id`, `Coremenuitem`.`parent_id`, `Coremenuitem`.`lft`, `Coremenuitem`.`rght`, `Coremenuitem`.`name`, `Coremenuitem`.`original_name`, `Coremenuitem`.`url`, `Coremenuitem`.`title_attribute`, `Coremenuitem`.`font_class`, `Coremenuitem`.`is_active`, `Coremenuitem`.`new_blank`, `Coremenuitem`.`role_access`, `Coremenuitem`.`menu_id`, `Coremenuitem`.`type`, `Coremenuitem`.`menu_order`, `Coremenuitem`.`plugin`, `Coremenuitem`.`group`, `Coremenuitem`.`url_app`, `Coremenuitem`.`font_class_app`, `Coremenuitem`.`show_web`, `Coremenuitem`.`show_app`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `d020ed2b`.`core_menu_items` AS `Coremenuitem` INNER JOIN `d020ed2b`.`i18n` AS `I18n__nameMenuTranslation` ON (`Coremenuitem`.`id` = `I18n__nameMenuTranslation`.`foreign_key` AND `I18n__nameMenuTranslation`.`model` = 'CoreMenuItem' AND `I18n__nameMenuTranslation`.`field` = 'name' AND `I18n__nameMenuTranslation`.`locale` = 'deu') WHERE `parent_id` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 0 | |
| 23 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `d020ed2b`.`themes` AS `Theme` WHERE `Theme`.`key` = 'black' LIMIT 1 | 1 | 1 | 0 | |
| 24 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css_landing`, `Theme`.`custom_css`, `Theme`.`custom_css_dark` FROM `d020ed2b`.`themes` AS `Theme` WHERE `Theme`.`key` = 'black' LIMIT 1 | 1 | 1 | 0 |