Remember me
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Plugin`.`enabled` FROM `daddycow_moosocial`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'Storage' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Album`.`id`, `Album`.`user_id`, `Album`.`category_id`, `Album`.`title`, `Album`.`description`, `Album`.`created`, `Album`.`photo_count`, `Album`.`cover`, `Album`.`modified`, `Album`.`like_count`, `Album`.`dislike_count`, `Album`.`comment_count`, `Album`.`privacy`, `Album`.`type`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content`, `Category`.`id`, `Category`.`type`, `Category`.`parent_id`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `Category`.`header`, `Category`.`create_permission` FROM `daddycow_moosocial`.`albums` AS `Album` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Album`.`user_id` = `User`.`id`) LEFT JOIN `daddycow_moosocial`.`categories` AS `Category` ON (`Album`.`category_id` = `Category`.`id`) WHERE `Album`.`id` = 12789 ORDER BY `Album`.`id` desc LIMIT 1 | 1 | 1 | 1 | |
| 3 | SELECT `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core`, `Role`.`limit_post` FROM `daddycow_moosocial`.`roles` AS `Role` WHERE `Role`.`id` = 2 | 1 | 1 | 0 | |
| 4 | SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `Comment`.`dislike_count`, `Comment`.`thumbnail`, `Comment`.`edited`, `Comment`.`count_reply`, `Comment`.`params`, `Comment`.`ai_content` FROM `daddycow_moosocial`.`comments` AS `Comment` WHERE `Comment`.`type` = 'Photo_Album' AND `Comment`.`target_id` = (12789) | 0 | 0 | 1 | |
| 5 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up` FROM `daddycow_moosocial`.`likes` AS `Like` WHERE `Like`.`type` = 'Photo_Album' AND `Like`.`target_id` = (12789) | 0 | 0 | 0 | |
| 6 | SELECT `Tag`.`id`, `Tag`.`target_id`, `Tag`.`type`, `Tag`.`tag`, `Tag`.`created` FROM `daddycow_moosocial`.`tags` AS `Tag` WHERE `Tag`.`type` = 'Photo_Album' AND `Tag`.`target_id` = (12789) | 0 | 0 | 1 | |
| 7 | SELECT `ProfileType`.`id`, `ProfileType`.`name`, `ProfileType`.`actived`, `ProfileType`.`profile`, `ProfileType`.`order`, (`I18n__nameTranslation`.`content`) AS `ProfileType__i18n_nameTranslation` FROM `daddycow_moosocial`.`profile_types` AS `ProfileType` INNER JOIN `daddycow_moosocial`.`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 | |
| 8 | SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `daddycow_moosocial`.`i18n` AS `nameTranslation` WHERE `model` = 'ProfileType' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 1 | 1 | 1 | |
| 9 | SELECT `Photo`.`id`, `Photo`.`target_id`, `Photo`.`type`, `Photo`.`user_id`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`thumbnail`, `Photo`.`original`, `Photo`.`created`, `Photo`.`like_count`, `Photo`.`dislike_count`, `Photo`.`comment_count`, `Photo`.`year_folder`, `Photo`.`album_type`, `Photo`.`album_type_id`, `Photo`.`privacy`, `Photo`.`size`, `Album`.`id`, `Album`.`user_id`, `Album`.`category_id`, `Album`.`title`, `Album`.`description`, `Album`.`created`, `Album`.`photo_count`, `Album`.`cover`, `Album`.`modified`, `Album`.`like_count`, `Album`.`dislike_count`, `Album`.`comment_count`, `Album`.`privacy`, `Album`.`type`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `Group`.`modified`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`photos` AS `Photo` LEFT JOIN `daddycow_moosocial`.`albums` AS `Album` ON (`Photo`.`type` = "Photo_Album" AND `Photo`.`target_id` = `Album`.`id`) LEFT JOIN `daddycow_moosocial`.`groups` AS `Group` ON (`Photo`.`type` = "Group_Group" AND `Photo`.`target_id` = `Group`.`id`) LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`type` = 'Photo_Album' AND `target_id` = 12789 AND `User`.`active` = 1 ORDER BY `Photo`.`id` desc LIMIT 10 | 1 | 1 | 2 | |
| 10 | SELECT `Tag`.`id`, `Tag`.`tag` FROM `daddycow_moosocial`.`tags` AS `Tag` WHERE `Tag`.`target_id` = 12789 AND `Tag`.`type` = 'Photo_Album' | 0 | 0 | 0 | |
| 11 | SELECT COUNT(*) AS `count` FROM `daddycow_moosocial`.`comments` AS `Comment` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`type` = 'Photo_Album' AND `Comment`.`target_id` = 12789 | 1 | 1 | 1 | |
| 12 | SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `Comment`.`dislike_count`, `Comment`.`thumbnail`, `Comment`.`edited`, `Comment`.`count_reply`, `Comment`.`params`, `Comment`.`ai_content`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`comments` AS `Comment` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`type` = 'Photo_Album' AND `Comment`.`target_id` = 12789 ORDER BY `Comment`.`id` desc LIMIT 12 | 0 | 0 | 1 | |
| 13 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`likes` AS `Like` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Like`.`user_id` = `User`.`id`) WHERE `Like`.`type` = 'Photo_Album' AND `Like`.`target_id` = 12789 AND `Like`.`thumb_up` = 1 ORDER BY `Like`.`id` desc | 0 | 0 | 1 | |
| 14 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type`, `Like`.`thumb_up`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`likes` AS `Like` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Like`.`user_id` = `User`.`id`) WHERE `Like`.`type` = 'Photo_Album' AND `Like`.`target_id` = 12789 AND `Like`.`thumb_up` = 0 ORDER BY `Like`.`id` desc | 0 | 0 | 1 | |
| 15 | SELECT `Photo`.`id`, `Photo`.`target_id`, `Photo`.`type`, `Photo`.`user_id`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`thumbnail`, `Photo`.`original`, `Photo`.`created`, `Photo`.`like_count`, `Photo`.`dislike_count`, `Photo`.`comment_count`, `Photo`.`year_folder`, `Photo`.`album_type`, `Photo`.`album_type_id`, `Photo`.`privacy`, `Photo`.`size`, `Album`.`id`, `Album`.`user_id`, `Album`.`category_id`, `Album`.`title`, `Album`.`description`, `Album`.`created`, `Album`.`photo_count`, `Album`.`cover`, `Album`.`modified`, `Album`.`like_count`, `Album`.`dislike_count`, `Album`.`comment_count`, `Album`.`privacy`, `Album`.`type`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `Group`.`modified`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`photos` AS `Photo` LEFT JOIN `daddycow_moosocial`.`albums` AS `Album` ON (`Photo`.`type` = "Photo_Album" AND `Photo`.`target_id` = `Album`.`id`) LEFT JOIN `daddycow_moosocial`.`groups` AS `Group` ON (`Photo`.`type` = "Group_Group" AND `Photo`.`target_id` = `Group`.`id`) LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`thumbnail` = '457559ab875ef1c7b06ceb8c6b3bf231.jpeg' ORDER BY `Photo`.`id` desc LIMIT 1 | 1 | 1 | 110 | |
| 16 | SELECT COUNT(*) AS `count` FROM `daddycow_moosocial`.`photos` AS `Photo` LEFT JOIN `daddycow_moosocial`.`albums` AS `Album` ON (`Photo`.`type` = "Photo_Album" AND `Photo`.`target_id` = `Album`.`id`) LEFT JOIN `daddycow_moosocial`.`groups` AS `Group` ON (`Photo`.`type` = "Group_Group" AND `Photo`.`target_id` = `Group`.`id`) LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`type` = 'Photo_Album' AND `target_id` = 12789 AND `User`.`active` = 1 | 1 | 1 | 1 | |
| 17 | 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 `daddycow_moosocial`.`plugins` AS `Plugin` WHERE `Plugin`.`key` = 'UploadVideo' ORDER BY `Plugin`.`weight` asc LIMIT 1 | 1 | 1 | 0 | |
| 18 | SELECT `UploadVideoLimitations`.`id`, `UploadVideoLimitations`.`role_id`, `UploadVideoLimitations`.`per_type`, `UploadVideoLimitations`.`value`, `UploadVideoLimitations`.`size`, `Role`.`id`, `Role`.`name`, `Role`.`is_admin`, `Role`.`is_super`, `Role`.`params`, `Role`.`core`, `Role`.`limit_post` FROM `daddycow_moosocial`.`video_limitations` AS `UploadVideoLimitations` LEFT JOIN `daddycow_moosocial`.`roles` AS `Role` ON (`UploadVideoLimitations`.`role_id` = `Role`.`id`) WHERE `UploadVideoLimitations`.`role_id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
| 19 | SELECT `Photo`.`id`, `Photo`.`target_id`, `Photo`.`type`, `Photo`.`user_id`, `Photo`.`caption`, `Photo`.`path`, `Photo`.`thumbnail`, `Photo`.`original`, `Photo`.`created`, `Photo`.`like_count`, `Photo`.`dislike_count`, `Photo`.`comment_count`, `Photo`.`year_folder`, `Photo`.`album_type`, `Photo`.`album_type_id`, `Photo`.`privacy`, `Photo`.`size`, `Album`.`id`, `Album`.`user_id`, `Album`.`category_id`, `Album`.`title`, `Album`.`description`, `Album`.`created`, `Album`.`photo_count`, `Album`.`cover`, `Album`.`modified`, `Album`.`like_count`, `Album`.`dislike_count`, `Album`.`comment_count`, `Album`.`privacy`, `Album`.`type`, `Group`.`id`, `Group`.`category_id`, `Group`.`name`, `Group`.`user_id`, `Group`.`description`, `Group`.`type`, `Group`.`photo`, `Group`.`group_user_count`, `Group`.`created`, `Group`.`photo_count`, `Group`.`topic_count`, `Group`.`video_count`, `Group`.`event_count`, `Group`.`featured`, `Group`.`modified`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`photos` AS `Photo` LEFT JOIN `daddycow_moosocial`.`albums` AS `Album` ON (`Photo`.`type` = "Photo_Album" AND `Photo`.`target_id` = `Album`.`id`) LEFT JOIN `daddycow_moosocial`.`groups` AS `Group` ON (`Photo`.`type` = "Group_Group" AND `Photo`.`target_id` = `Group`.`id`) LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`thumbnail` = '457559ab875ef1c7b06ceb8c6b3bf231.jpeg' ORDER BY `Photo`.`id` desc LIMIT 1 | 1 | 1 | 107 | |
| 20 | SELECT COUNT(*) AS `count` FROM `daddycow_moosocial`.`likes` AS `Like` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Like`.`user_id` = `User`.`id`) WHERE `Like`.`type` = 'Photo_Album' AND `Like`.`target_id` = 12789 AND `Like`.`thumb_up` = 1 | 1 | 1 | 1 | |
| 21 | SELECT COUNT(*) AS `count` FROM `daddycow_moosocial`.`likes` AS `Like` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Like`.`user_id` = `User`.`id`) WHERE `Like`.`type` = 'Photo_Album' AND `Like`.`target_id` = 12789 AND `Like`.`thumb_up` = 0 | 1 | 1 | 1 | |
| 22 | SELECT COUNT(*) AS `count` FROM `daddycow_moosocial`.`comments` AS `Comment` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`type` = 'Photo_Album' AND `Comment`.`target_id` = 12789 | 1 | 1 | 1 | |
| 23 | SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `Comment`.`dislike_count`, `Comment`.`thumbnail`, `Comment`.`edited`, `Comment`.`count_reply`, `Comment`.`params`, `Comment`.`ai_content`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`comments` AS `Comment` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`type` = 'Photo_Album' AND `Comment`.`target_id` = 12789 ORDER BY `Comment`.`id` desc LIMIT 12 | 0 | 0 | 1 | |
| 24 | SELECT `CloseComment`.`id`, `CloseComment`.`user_id`, `CloseComment`.`item_type`, `CloseComment`.`item_id`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`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`.`chat_count`, `User`.`chat_online_status`, `User`.`store_order_info`, `User`.`price`, `User`.`total_day`, `User`.`message_info`, `User`.`sub_message`, `User`.`message_content` FROM `daddycow_moosocial`.`close_comments` AS `CloseComment` LEFT JOIN `daddycow_moosocial`.`users` AS `User` ON (`CloseComment`.`user_id` = `User`.`id`) WHERE `item_type` = 'Photo_Album' AND `item_id` = 12789 LIMIT 1 | 0 | 0 | 1 | |
| 25 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `daddycow_moosocial`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 | |
| 26 | 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 `daddycow_moosocial`.`settings` AS `Setting` LEFT JOIN `daddycow_moosocial`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 1 | |
| 27 | SELECT `Coremenu`.`id`, `Coremenu`.`name`, `Coremenu`.`style`, `Coremenu`.`alias`, `Coremenu`.`menuid` FROM `daddycow_moosocial`.`core_menus` AS `Coremenu` WHERE `alias` = 'main-menu' LIMIT 1 | 1 | 1 | 0 | |
| 28 | 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` FROM `daddycow_moosocial`.`core_menu_items` AS `CoreMenuItem` WHERE `CoreMenuItem`.`is_active` = '1' AND `CoreMenuItem`.`menu_id` = (1) ORDER BY `CoreMenuItem`.`menu_order` ASC | 11 | 11 | 1 | |
| 29 | SELECT `nameMenuTranslation`.`id`, `nameMenuTranslation`.`locale`, `nameMenuTranslation`.`model`, `nameMenuTranslation`.`foreign_key`, `nameMenuTranslation`.`field`, `nameMenuTranslation`.`content` FROM `daddycow_moosocial`.`i18n` AS `nameMenuTranslation` WHERE `model` = 'CoreMenuItem' AND `field` = 'name' AND `nameMenuTranslation`.`foreign_key` IN (7, 1, 5, 18, 13, 2, 3, 14, 6, 4, 8) ORDER BY `id` ASC | 11 | 11 | 1 | |
| 30 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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` = 7 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
| 31 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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` = 1 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
| 32 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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 | 1 | |
| 33 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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` = 18 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
| 34 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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` = 13 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
| 35 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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 | 1 | |
| 36 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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 | 1 | |
| 37 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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` = 14 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
| 38 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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` = 6 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
| 39 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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` = 4 AND `is_active` = '1' ORDER BY `menu_order` ASC | 0 | 0 | 1 | |
| 40 | 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`, (`I18n__nameMenuTranslation`.`content`) AS `Coremenuitem__i18n_nameMenuTranslation` FROM `daddycow_moosocial`.`core_menu_items` AS `Coremenuitem` INNER JOIN `daddycow_moosocial`.`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 | |
| 41 | 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 `daddycow_moosocial`.`settings` AS `Setting` LEFT JOIN `daddycow_moosocial`.`setting_groups` AS `SettingGroup` ON (`Setting`.`group_id` = `SettingGroup`.`id`) WHERE `Setting`.`name` = 'logo' LIMIT 1 | 1 | 1 | 1 | |
| 42 | SELECT `Theme`.`id`, `Theme`.`key`, `Theme`.`name`, `Theme`.`core`, `Theme`.`custom_css_enable`, `Theme`.`custom_css` FROM `daddycow_moosocial`.`themes` AS `Theme` WHERE `Theme`.`key` = 'default' LIMIT 1 | 1 | 1 | 0 |
Comments (0)