1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`user_id` FROM `moo_mps`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'eoa3fb6p2h2uk3ehesuvsq9sg3' LIMIT 1 | | 1 | 1 | 0 |
2 | SELECT `Plugin`.`enabled` FROM `moo_mps`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
3 | SELECT `Plugin`.`enabled` FROM `moo_mps`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
4 | SELECT `Plugin`.`enabled` FROM `moo_mps`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
5 | SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`award_text`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Category`.`question_time_cron`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `moo_mps`.`categories` AS `Category` INNER JOIN `moo_mps`.`i18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`type` = 'Question' AND `Category`.`active` = 1 ORDER BY `Category`.`weight` asc | | 174 | 174 | 7 |
6 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (2077, 2255, 2078, 2079, 2080, 2081, 2082, 2083, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2199, 2200, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249) ORDER BY `id` ASC | | 2436 | 2436 | 13 |
7 | SELECT `Question`.`id`, `Question`.`title`, `Question`.`description`, `Question`.`user_id`, `Question`.`category_id`, `Question`.`view_count`, `Question`.`favorite_count`, `Question`.`vote_count`, `Question`.`created`, `Question`.`modified`, `Question`.`answer_count`, `Question`.`visiable`, `Question`.`privacy`, `Question`.`feature`, `Question`.`has_best_answers`, `Question`.`thumbnail`, `Question`.`comment_count`, `Question`.`approve`, `Question`.`edited`, `Question`.`share_count`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`award_text`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Category`.`question_time_cron` FROM `moo_mps`.`questions` AS `Question` LEFT JOIN `moo_mps`.`users` AS `User` ON (`Question`.`user_id` = `User`.`id`) LEFT JOIN `moo_mps`.`categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `visiable` = '1' AND `Question`.`privacy` = 1 AND `Question`.`approve` = '1' AND `Question`.`category_id` = 2120 ORDER BY `Question`.`id` DESC LIMIT 570, 10 | | 10 | 10 | 107 |
8 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `moo_mps`.`profile_types` AS `ProfileType` INNER JOIN `moo_mps`.`i18n` AS `I18n__nameTranslation` ON (`ProfileType`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'ProfileType' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `ProfileType`.`id` IN (1, 'eng') AND `ProfileType`.`actived` = '1' ORDER BY `ProfileType`.`order` asc | | 1 | 1 | 1 |
9 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | | 14 | 14 | 1 |
10 | SELECT COUNT(*) AS `count` FROM `moo_mps`.`questions` AS `Question` LEFT JOIN `moo_mps`.`users` AS `User` ON (`Question`.`user_id` = `User`.`id`) LEFT JOIN `moo_mps`.`categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `visiable` = '1' AND `Question`.`privacy` = 1 AND `Question`.`approve` = '1' AND `Question`.`category_id` = 2120 | | 1 | 1 | 41 |
11 | SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`award_text`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Category`.`question_time_cron`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `moo_mps`.`categories` AS `Category` INNER JOIN `moo_mps`.`i18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`type` = 'Question' AND `Category`.`active` = 1 ORDER BY `Category`.`weight` asc | | 174 | 174 | 7 |
12 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (2077, 2255, 2078, 2079, 2080, 2081, 2082, 2083, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2199, 2200, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249) ORDER BY `id` ASC | | 2436 | 2436 | 13 |
13 | SELECT `Question`.`id`, `Question`.`title`, `Question`.`description`, `Question`.`user_id`, `Question`.`category_id`, `Question`.`view_count`, `Question`.`favorite_count`, `Question`.`vote_count`, `Question`.`created`, `Question`.`modified`, `Question`.`answer_count`, `Question`.`visiable`, `Question`.`privacy`, `Question`.`feature`, `Question`.`has_best_answers`, `Question`.`thumbnail`, `Question`.`comment_count`, `Question`.`approve`, `Question`.`edited`, `Question`.`share_count`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`award_text`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Category`.`question_time_cron` FROM `moo_mps`.`questions` AS `Question` LEFT JOIN `moo_mps`.`users` AS `User` ON (`Question`.`user_id` = `User`.`id`) LEFT JOIN `moo_mps`.`categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `visiable` = '1' AND `Question`.`privacy` = 1 AND `Question`.`approve` = '1' AND `Question`.`feature` = '1' ORDER BY `Question`.`view_count` desc LIMIT 10 | | 0 | 0 | 123 |
14 | SELECT `QuestionUser`.`id`, `QuestionUser`.`user_id`, `QuestionUser`.`total`, `QuestionUser`.`total_best_answer`, `QuestionUser`.`total_question`, `QuestionUser`.`total_answer`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader` FROM `moo_mps`.`question_users` AS `QuestionUser` LEFT JOIN `moo_mps`.`users` AS `User` ON (`QuestionUser`.`user_id` = `User`.`id`) WHERE `QuestionUser`.`total_question` > 0 ORDER BY `QuestionUser`.`total_question` DESC LIMIT 10 | | 3 | 3 | 1 |
15 | SELECT `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tags` AS `QuestionTag` WHERE `QuestionTag`.`status` = 1 ORDER BY `QuestionTag`.`count` DESC LIMIT 10 | | 0 | 0 | 0 |
16 | SELECT `QuestionUser`.`id`, `QuestionUser`.`user_id`, `QuestionUser`.`total`, `QuestionUser`.`total_best_answer`, `QuestionUser`.`total_question`, `QuestionUser`.`total_answer`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader` FROM `moo_mps`.`question_users` AS `QuestionUser` LEFT JOIN `moo_mps`.`users` AS `User` ON (`QuestionUser`.`user_id` = `User`.`id`) WHERE `QuestionUser`.`total` > 0 ORDER BY `QuestionUser`.`total` DESC LIMIT 10 | | 9 | 9 | 1 |
17 | SELECT `QuestionUser`.`id`, `QuestionUser`.`user_id`, `QuestionUser`.`total`, `QuestionUser`.`total_best_answer`, `QuestionUser`.`total_question`, `QuestionUser`.`total_answer`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader` FROM `moo_mps`.`question_users` AS `QuestionUser` LEFT JOIN `moo_mps`.`users` AS `User` ON (`QuestionUser`.`user_id` = `User`.`id`) WHERE `QuestionUser`.`total_answer` > 0 ORDER BY `QuestionUser`.`total_answer` DESC LIMIT 10 | | 9 | 9 | 1 |
18 | SELECT `QuestionAnswer`.`id`, `QuestionAnswer`.`question_id`, `QuestionAnswer`.`category_id`, `QuestionAnswer`.`description`, `QuestionAnswer`.`created`, `QuestionAnswer`.`modified`, `QuestionAnswer`.`user_id`, `QuestionAnswer`.`comment_count`, `QuestionAnswer`.`best_answers`, `QuestionAnswer`.`best_answers_date`, `QuestionAnswer`.`vote_count`, `QuestionAnswer`.`active_time`, `QuestionAnswer`.`edited`, (COUNT(*)) AS `QuestionAnswer__total_answer_by_cat`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` LEFT JOIN `moo_mps`.`users` AS `User` ON (`QuestionAnswer`.`user_id` = `User`.`id`) WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 10 | | 0 | 0 | 1 |
19 | SELECT `Question`.`id`, `Question`.`title`, `Question`.`description`, `Question`.`user_id`, `Question`.`category_id`, `Question`.`view_count`, `Question`.`favorite_count`, `Question`.`vote_count`, `Question`.`created`, `Question`.`modified`, `Question`.`answer_count`, `Question`.`visiable`, `Question`.`privacy`, `Question`.`feature`, `Question`.`has_best_answers`, `Question`.`thumbnail`, `Question`.`comment_count`, `Question`.`approve`, `Question`.`edited`, `Question`.`share_count`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`award_text`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Category`.`question_time_cron` FROM `moo_mps`.`questions` AS `Question` LEFT JOIN `moo_mps`.`users` AS `User` ON (`Question`.`user_id` = `User`.`id`) LEFT JOIN `moo_mps`.`categories` AS `Category` ON (`Question`.`category_id` = `Category`.`id`) WHERE `visiable` = '1' AND `Question`.`privacy` = 1 AND `Question`.`approve` = '1' ORDER BY `Question`.`vote_count` desc LIMIT 10 | | 10 | 10 | 294 |
20 | SELECT `Page`.`id` FROM `moo_mps`.`pages` AS `Page` LEFT JOIN `moo_mps`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) WHERE `Page`.`uri` = 'questions.index' ORDER BY `Page`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
21 | 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 `moo_mps`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (188) | | 12 | 12 | 0 |
22 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
23 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
24 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
25 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
26 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
27 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
28 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
29 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
30 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
31 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
32 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
33 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
34 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 928 | | 1 | 1 | 0 |
35 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
36 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
37 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
38 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
39 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
40 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
41 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
42 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
43 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
44 | 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 `moo_mps`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 969, 938) | | 10 | 10 | 1 |
45 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value` FROM `moo_mps`.`core_content_values` AS `CoreContentValue` WHERE `CoreContentValue`.`content_id` IN (928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 969, 938) | | 0 | 0 | 0 |
46 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 969, 938) ORDER BY `id` ASC | | 168 | 168 | 2 |
47 | SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `moo_mps`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (188) ORDER BY `id` ASC | | 14 | 14 | 1 |
48 | SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `moo_mps`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (188) ORDER BY `id` ASC | | 14 | 14 | 0 |
49 | SELECT `Tourguide`.`id`, `Tourguide`.`title`, `Tourguide`.`page_id`, `Tourguide`.`role_access_id`, `Tourguide`.`created`, `Tourguide`.`user_id`, `Tourguide`.`enable`, (`I18n__titleTranslation`.`content`) AS `Tourguide__i18n_titleTranslation` FROM `moo_mps`.`tourguides` AS `Tourguide` INNER JOIN `moo_mps`.`i18n` AS `I18n__titleTranslation` ON (`Tourguide`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Tourguide' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') WHERE `Tourguide`.`page_id` LIKE '%\"0\"%' AND `enable` = '1' LIMIT 1 | | 0 | 0 | 0 |
50 | SELECT `Tourguide`.`id`, `Tourguide`.`title`, `Tourguide`.`page_id`, `Tourguide`.`role_access_id`, `Tourguide`.`created`, `Tourguide`.`user_id`, `Tourguide`.`enable`, (`I18n__titleTranslation`.`content`) AS `Tourguide__i18n_titleTranslation` FROM `moo_mps`.`tourguides` AS `Tourguide` INNER JOIN `moo_mps`.`i18n` AS `I18n__titleTranslation` ON (`Tourguide`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Tourguide' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'eng') WHERE `Tourguide`.`page_id` LIKE '%\"188\"%' AND `enable` = '1' LIMIT 1 | | 0 | 0 | 0 |
51 | SELECT `Plugin`.`id`, `Plugin`.`name`, `Plugin`.`key`, `Plugin`.`permission`, `Plugin`.`enabled`, `Plugin`.`core`, `Plugin`.`version`, `Plugin`.`weight`, `Plugin`.`menu`, `Plugin`.`url`, `Plugin`.`icon_class`, `Plugin`.`bootstrap`, `Plugin`.`routes` FROM `moo_mps`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'UploadVideo' ORDER BY `Plugin`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
52 | 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 `moo_mps`.`core_menu_items` AS `CoreMenuItem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `CoreMenuItem`.`url` = '/questions/index/all' LIMIT 1 | | 0 | 0 | 0 |
53 | SELECT `Page`.`id` FROM `moo_mps`.`pages` AS `Page` LEFT JOIN `moo_mps`.`themes` AS `MyCoreTheme` ON (`Page`.`theme_id` = `MyCoreTheme`.`id`) WHERE `Page`.`uri` = 'questions.index' ORDER BY `Page`.`weight` asc LIMIT 1 | | 1 | 1 | 0 |
54 | 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 `moo_mps`.`core_contents` AS `CoreContent` WHERE `CoreContent`.`page_id` = (188) | | 12 | 12 | 0 |
55 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
56 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
57 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
58 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
59 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
60 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
61 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
62 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
63 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
64 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
65 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
66 | 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 `moo_mps`.`pages` AS `MyCorePage` WHERE `MyCorePage`.`id` = 188 | | 1 | 1 | 0 |
67 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 928 | | 1 | 1 | 0 |
68 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
69 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
70 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
71 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
72 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
73 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
74 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
75 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
76 | 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 `moo_mps`.`core_contents` AS `Parent` WHERE `Parent`.`id` = 930 | | 1 | 1 | 0 |
77 | 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 `moo_mps`.`core_contents` AS `Children` WHERE `Children`.`parent_id` IN (928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 969, 938) | | 10 | 10 | 1 |
78 | SELECT `CoreContentValue`.`id`, `CoreContentValue`.`content_id`, `CoreContentValue`.`field_name`, `CoreContentValue`.`value` FROM `moo_mps`.`core_content_values` AS `CoreContentValue` WHERE `CoreContentValue`.`content_id` IN (928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 969, 938) | | 0 | 0 | 0 |
79 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameTranslation` WHERE `model` = 'CoreContent' AND `field` = 'core_block_title' AND `nameTranslation`.`foreign_key` IN (928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 969, 938) ORDER BY `id` ASC | | 168 | 168 | 2 |
80 | SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `moo_mps`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (188) ORDER BY `id` ASC | | 14 | 14 | 0 |
81 | SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `moo_mps`.`i18n` AS `contentTranslation` WHERE `model` = 'Page' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (188) ORDER BY `id` ASC | | 14 | 14 | 0 |
82 | 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 `moo_mps`.`popups` AS `Popup` LEFT JOIN `moo_mps`.`pages` AS `Page` ON (`Popup`.`page_id` = `Page`.`id`) INNER JOIN `moo_mps`.`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` = 'eng') INNER JOIN `moo_mps`.`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` = 'eng') WHERE `Popup`.`page_id` = 0 AND `enable` = '1' LIMIT 1 | | 0 | 0 | 1 |
83 | 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 `moo_mps`.`popups` AS `Popup` LEFT JOIN `moo_mps`.`pages` AS `Page` ON (`Popup`.`page_id` = `Page`.`id`) INNER JOIN `moo_mps`.`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` = 'eng') INNER JOIN `moo_mps`.`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` = 'eng') WHERE `Popup`.`page_id` = 188 AND `enable` = '1' LIMIT 1 | | 0 | 0 | 1 |
84 | SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`award_text`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Category`.`question_time_cron`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `moo_mps`.`categories` AS `Category` INNER JOIN `moo_mps`.`i18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`id` = 2120 ORDER BY `Category`.`weight` asc LIMIT 1 | | 1 | 1 | 1 |
85 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (2120) ORDER BY `id` ASC | | 14 | 14 | 1 |
86 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 8296 | | 0 | 0 | 0 |
87 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
88 | SELECT `QuestionUser`.`id`, `QuestionUser`.`user_id`, `QuestionUser`.`total`, `QuestionUser`.`total_best_answer`, `QuestionUser`.`total_question`, `QuestionUser`.`total_answer`, `User`.`id`, `User`.`need_update_listing`, `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`.`group_count`, `User`.`event_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`.`cover1`, `User`.`cover2`, `User`.`cover3`, `User`.`approved`, `User`.`is_social`, `User`.`sms_verify_checked`, `User`.`sms_verify_phone`, `User`.`sms_verify`, `User`.`has_active_subscription`, `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`.`signature`, `User`.`show_signature`, `User`.`hide_profile_complete`, `User`.`viewer_invisible`, `User`.`lock_delete`, `User`.`collectible_directory_count`, `User`.`tutorial_count`, `User`.`auto_description`, `User`.`chat_online_status`, `User`.`send_mail_price_listing`, `User`.`token_accses`, `User`.`time_token_accses`, `User`.`directory_listing_count`, `User`.`fake_user`, `User`.`fake_photo_id`, `User`.`fake_auto_friend`, `User`.`fake_total_run`, `User`.`fake_current_run`, `User`.`fake_time_updated`, `User`.`fake_next_run_time`, `User`.`project_count`, `User`.`chat_count`, `User`.`chat_privacy`, `User`.`trading_count`, `User`.`is_trader` FROM `moo_mps`.`question_users` AS `QuestionUser` LEFT JOIN `moo_mps`.`users` AS `User` ON (`QuestionUser`.`user_id` = `User`.`id`) WHERE `QuestionUser`.`user_id` = 1 LIMIT 1 | | 1 | 1 | 1 |
89 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
90 | SELECT `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`award_text`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission`, `Category`.`question_time_cron`, (`I18n__nameTranslation`.`content`) AS `Category__i18n_nameTranslation` FROM `moo_mps`.`categories` AS `Category` INNER JOIN `moo_mps`.`i18n` AS `I18n__nameTranslation` ON (`Category`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Category' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'eng') WHERE `Category`.`type` = 'Question' AND `Category`.`active` = 1 ORDER BY `Category`.`weight` asc | | 174 | 174 | 10 |
91 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameTranslation` WHERE `model` = 'Category' AND `field` = 'name' AND `nameTranslation`.`foreign_key` IN (2077, 2255, 2078, 2079, 2080, 2081, 2082, 2083, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2189, 2190, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2199, 2200, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249) ORDER BY `id` ASC | | 2436 | 2436 | 12 |
92 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 8295 | | 0 | 0 | 0 |
93 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
94 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
95 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 8294 | | 0 | 0 | 0 |
96 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
97 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
98 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 7515 | | 0 | 0 | 0 |
99 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
100 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
101 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 7514 | | 0 | 0 | 0 |
102 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
103 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
104 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 7513 | | 0 | 0 | 0 |
105 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
106 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
107 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 7512 | | 0 | 0 | 0 |
108 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
109 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
110 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 7511 | | 0 | 0 | 0 |
111 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
112 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
113 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 6741 | | 0 | 0 | 0 |
114 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
115 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
116 | SELECT `QuestionTagMap`.`id`, `QuestionTagMap`.`tag_id`, `QuestionTagMap`.`question_id`, `QuestionTag`.`id`, `QuestionTag`.`title`, `QuestionTag`.`status`, `QuestionTag`.`user_id`, `QuestionTag`.`created`, `QuestionTag`.`modified`, `QuestionTag`.`count` FROM `moo_mps`.`question_tag_maps` AS `QuestionTagMap` LEFT JOIN `moo_mps`.`question_tags` AS `QuestionTag` ON (`QuestionTagMap`.`tag_id` = `QuestionTag`.`id`) WHERE `QuestionTagMap`.`question_id` = 6740 | | 0 | 0 | 0 |
117 | SELECT `QuestionAnswer`.`user_id`, (COUNT(*)) AS `QuestionAnswer__total_answer_user` FROM `moo_mps`.`question_answers` AS `QuestionAnswer` WHERE `QuestionAnswer`.`category_id` = 2120 GROUP BY `QuestionAnswer`.`user_id` ORDER BY (COUNT(*)) DESC LIMIT 5 | | 0 | 0 | 0 |
118 | SELECT `QuestionBadge`.`id`, `QuestionBadge`.`name`, `QuestionBadge`.`background_color`, `QuestionBadge`.`text_color`, `QuestionBadge`.`point`, `QuestionBadge`.`permission` FROM `moo_mps`.`question_badges` AS `QuestionBadge` WHERE 1 = 1 ORDER BY `QuestionBadge`.`point` DESC | | 0 | 0 | 0 |
119 | 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 `moo_mps`.`themes` AS `Theme` WHERE `Theme`.`key` = 'mypremium' LIMIT 1 | | 1 | 1 | 0 |
120 | 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 `moo_mps`.`themes` AS `Theme` WHERE `Theme`.`key` = 'mypremium' LIMIT 1 | | 1 | 1 | 0 |
121 | 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 `moo_mps`.`settings` AS `Setting` LEFT JOIN `moo_mps`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 0 |
122 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `moo_mps`.`core_menus` AS `Coremenu` WHERE `alias` = 'main-menu' LIMIT 1 | | 1 | 1 | 0 |
123 | 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 `moo_mps`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (1) ORDER BY `CoreMenuItem`.`menu_order` ASC | | 24 | 24 | 0 |
124 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (90, 43, 76, 2, 111, 74, 82, 27, 17, 124, 128, 131, 32, 25, 28, 130, 126, 5, 8, 3, 96, 110, 92, 132) ORDER BY `id` ASC | | 310 | 310 | 5 |
125 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 90 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 8 | 8 | 4 |
126 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (43, 76, 2, 111, 74, 82, 27, 17) ORDER BY `id` ASC | | 112 | 112 | 4 |
127 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 43 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
128 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 43 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
129 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 76 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
130 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 76 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
131 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 2 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
132 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 2 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
133 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 111 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
134 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 111 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
135 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 74 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
136 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 74 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
137 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 82 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
138 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 82 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
139 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
140 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
141 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
142 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
143 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 90 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 8 | 8 | 4 |
144 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (43, 76, 2, 111, 74, 82, 27, 17) ORDER BY `id` ASC | | 112 | 112 | 4 |
145 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 43 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
146 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 76 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
147 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 2 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
148 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 111 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
149 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 74 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
150 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 82 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
151 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 27 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
152 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 17 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
153 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 124 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
154 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 128 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
155 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 131 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
156 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 32 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
157 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 25 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
158 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 28 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 7 | 7 | 6 |
159 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (130, 126, 5, 8, 3, 96, 110) ORDER BY `id` ASC | | 98 | 98 | 5 |
160 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 130 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
161 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 130 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
162 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 126 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
163 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 126 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
164 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 5 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
165 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 5 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
166 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 8 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 1 |
167 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 8 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
168 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 3 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
169 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 3 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
170 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 96 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
171 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 96 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
172 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 110 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
173 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 110 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
174 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 28 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 7 | 7 | 4 |
175 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `moo_mps`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (130, 126, 5, 8, 3, 96, 110) ORDER BY `id` ASC | | 98 | 98 | 4 |
176 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 130 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
177 | 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 `moo_mps`.`core_menu_items` AS `Coremenuitem` INNER JOIN `moo_mps`.`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` = 'eng') WHERE `parent_id` = 92 AND `is_active` = '1' ORDER BY `menu_order` ASC | | 0 | 0 | 0 |
178 | 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 `moo_mps`.`settings` AS `Setting` LEFT JOIN `moo_mps`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | | 1 | 1 | 0 |
179 | 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 `moo_mps`.`themes` AS `Theme` WHERE `Theme`.`key` = 'mypremium' LIMIT 1 | | 1 | 1 | 0 |
180 | 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 `moo_mps`.`themes` AS `Theme` WHERE `Theme`.`key` = 'mypremium' LIMIT 1 | | 1 | 1 | 0 |