| 1 | SELECT `Setting`.`field`, `Setting`.`value` FROM `toae_new`.`settings` AS `Setting` WHERE 1 = 1 | | 56 | 56 | 0 |
| 2 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `toae_new`.`cake_sessions` AS `Session` WHERE `id` = '5b286be42ef9959195779b7ad855ec86' LIMIT 1 | | 0 | 0 | 0 |
| 3 | SELECT data FROM cake_sessions WHERE expires > 1337539328 | | 39 | 39 | 0 |
| 4 | SELECT DISTINCT `Tag`.`tag`, (SELECT count(*) FROM tags WHERE tag=Tag.tag) as count FROM `toae_new`.`tags` AS `Tag` WHERE 1 = 1 ORDER BY `count` desc LIMIT 20 | | 0 | 0 | 0 |
| 5 | SELECT COUNT(*) AS `count` FROM `toae_new`.`event_rsvps` AS `EventRsvp` LEFT JOIN `toae_new`.`events` AS `Event` ON (`EventRsvp`.`event_id` = `Event`.`id`) LEFT JOIN `toae_new`.`users` AS `User` ON (`EventRsvp`.`user_id` = `User`.`id`) WHERE `EventRsvp`.`user_id` IS NULL AND (rsvp = 1 OR rsvp = 0) AND `Event`.`to` >= CURDATE() | | 1 | 1 | 0 |
| 6 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `active` = '1' ORDER BY `User`.`id` desc LIMIT 10 | | 10 | 10 | 0 |
| 7 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `active` = '1' AND `featured` = '1' ORDER BY `User`.`id` desc LIMIT 10 | | 1 | 1 | 2 |
| 8 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `active` = '1' AND SUBSTRING(birthday, 6) = '05-20' | | 0 | 0 | 1 |
| 9 | SELECT `Activity`.`id`, `Activity`.`type`, `Activity`.`target_id`, `Activity`.`user_id`, `Activity`.`action`, `Activity`.`text`, `Activity`.`content`, `Activity`.`items`, `Activity`.`item_type`, `Activity`.`item_id`, `Activity`.`created`, `Activity`.`activity_comment_count`, `Activity`.`query`, `Activity`.`privacy`, `Activity`.`modified`, `Activity`.`params`, `Activity`.`like_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`activities` AS `Activity` LEFT JOIN `toae_new`.`users` AS `User` ON (`Activity`.`user_id` = `User`.`id`) WHERE `Activity`.`type` = 'user' AND `Activity`.`privacy` = 1 ORDER BY `Activity`.`modified` desc LIMIT 20 | | 14 | 14 | 1 |
| 10 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `User`.`id` = 70470 | | 0 | 0 | 0 |
| 11 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `User`.`id` = 1 | | 1 | 1 | 0 |
| 12 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `User`.`id` = 3 | | 1 | 1 | 0 |
| 13 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `User`.`id` = 4 | | 1 | 1 | 0 |
| 14 | SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`users` AS `User` WHERE `User`.`id` = 2 | | 1 | 1 | 0 |
| 15 | SELECT `ActivityComment`.`id`, `ActivityComment`.`user_id`, `ActivityComment`.`activity_id`, `ActivityComment`.`comment`, `ActivityComment`.`like_count`, `ActivityComment`.`created` FROM `toae_new`.`activity_comments` AS `ActivityComment` WHERE `ActivityComment`.`activity_id` IN (26, 25, 24, 23, 22, 21, 20, 19, 17, 16, 13, 12, 8, 1) ORDER BY `ActivityComment`.`id` asc | | 1 | 1 | 0 |
| 16 | SELECT `Like`.`id`, `Like`.`user_id`, `Like`.`target_id`, `Like`.`type` FROM `toae_new`.`likes` AS `Like` WHERE `Like`.`type` = 'activity_comment' AND `Like`.`target_id` = (1) | | 0 | 0 | 0 |
| 17 | SELECT `Topic`.`id`, `Topic`.`category_id`, `Topic`.`user_id`, `Topic`.`title`, `Topic`.`body`, `Topic`.`created`, `Topic`.`last_post`, `Topic`.`comment_count`, `Topic`.`lastposter_id`, `Topic`.`like_count`, `Topic`.`group_id`, `Topic`.`pinned`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `Category`.`id`, `Category`.`type`, `Category`.`name`, `Category`.`description`, `Category`.`item_count`, `Category`.`active`, `Category`.`weight`, `LastPoster`.`id`, `LastPoster`.`name`, `LastPoster`.`email`, `LastPoster`.`password`, `LastPoster`.`role_id`, `LastPoster`.`avatar`, `LastPoster`.`photo`, `LastPoster`.`created`, `LastPoster`.`last_login`, `LastPoster`.`photo_count`, `LastPoster`.`friend_count`, `LastPoster`.`notification_count`, `LastPoster`.`friend_request_count`, `LastPoster`.`blog_count`, `LastPoster`.`topic_count`, `LastPoster`.`conversation_user_count`, `LastPoster`.`video_count`, `LastPoster`.`gender`, `LastPoster`.`birthday`, `LastPoster`.`active`, `LastPoster`.`confirmed`, `LastPoster`.`code`, `LastPoster`.`notification_email`, `LastPoster`.`timezone`, `LastPoster`.`ip_address`, `LastPoster`.`privacy`, `LastPoster`.`username`, `LastPoster`.`about`, `LastPoster`.`featured`, `LastPoster`.`lang`, `LastPoster`.`hide_online`, `LastPoster`.`cover`, `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` FROM `toae_new`.`topics` AS `Topic` LEFT JOIN `toae_new`.`users` AS `User` ON (`Topic`.`user_id` = `User`.`id`) LEFT JOIN `toae_new`.`categories` AS `Category` ON (`Topic`.`category_id` = `Category`.`id`) LEFT JOIN `toae_new`.`users` AS `LastPoster` ON (`Topic`.`lastposter_id` = `LastPoster`.`id`) LEFT JOIN `toae_new`.`groups` AS `Group` ON (`Topic`.`group_id` = `Group`.`id`) WHERE `Topic`.`id` IN (371177, 306952, 3) ORDER BY `Topic`.`last_post` desc | | 2 | 2 | 1 |
| 18 | SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`comments` AS `Comment` LEFT JOIN `toae_new`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 371177 AND `Comment`.`type` = 'topic' ORDER BY `Comment`.`id` desc LIMIT 2 | | 0 | 0 | 0 |
| 19 | SELECT `Like`.`id`, `Like`.`user_id` FROM `toae_new`.`likes` AS `Like` WHERE `Like`.`target_id` = 371177 AND `Like`.`type` = 'topic' ORDER BY `Like`.`id` desc | | 0 | 0 | 0 |
| 20 | SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`comments` AS `Comment` LEFT JOIN `toae_new`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 306952 AND `Comment`.`type` = 'topic' ORDER BY `Comment`.`id` desc LIMIT 2 | | 0 | 0 | 0 |
| 21 | SELECT `Like`.`id`, `Like`.`user_id` FROM `toae_new`.`likes` AS `Like` WHERE `Like`.`target_id` = 306952 AND `Like`.`type` = 'topic' ORDER BY `Like`.`id` desc | | 0 | 0 | 0 |
| 22 | SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`target_id`, `Comment`.`message`, `Comment`.`created`, `Comment`.`type`, `Comment`.`like_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover` FROM `toae_new`.`comments` AS `Comment` LEFT JOIN `toae_new`.`users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) WHERE `Comment`.`target_id` = 3 AND `Comment`.`type` = 'topic' ORDER BY `Comment`.`id` desc LIMIT 2 | | 0 | 0 | 0 |
| 23 | SELECT `Like`.`id`, `Like`.`user_id` FROM `toae_new`.`likes` AS `Like` WHERE `Like`.`target_id` = 3 AND `Like`.`type` = 'topic' ORDER BY `Like`.`id` desc | | 0 | 0 | 0 |
الاشخاص
مدونات
صور
فيديو
مواضيع
مجموعات
مناسبات
2 hours ago . تعليق
خميس الشرياني كتب موضوع جديدالبلد الفكرية ومفاتيح النجاحon May 8 at 2:44pm . تعليق
1 person likes this