Architects added

(default) 66 queries took 414 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 552
2SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification`, `Role`.`id`, `Role`.`name`, `Role`.`permissions`, `Role`.`description`, `Role`.`created`, `Role`.`modified` FROM `users` AS `User` LEFT JOIN `roles` AS `Role` ON (`User`.`role_id` = `Role`.`id`) WHERE `login` = 'guest@architectuul.com' LIMIT 11128
3SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
4SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' 112
5UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-08-21 01:48:27', `modified` = '2019-08-21 01:48:27' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1'13
6SELECT `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 11112
7SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification`, `Country`.`name`, `State`.`name` FROM `users` AS `User` LEFT JOIN `countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`User`.`state_id` = `State`.`id`) WHERE `User`.`slug` = 'lacuna' AND `User`.`cancelled` is null LIMIT 1113
8SELECT `TopList`.`id`, `TopList`.`title`, `TopList`.`slug`, `TopList`.`user_id`, `TopList`.`created` FROM `top_lists` AS `TopList` WHERE `user_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' ORDER BY `title` asc 002
9SELECT `TopList`.`id`, `TopList`.`title`, `TopList`.`slug`, `TopList`.`user_id`, `TopList`.`created`, `User`.`username`, `User`.`slug` FROM `top_lists` AS `TopList` LEFT JOIN `users` AS `User` ON (`TopList`.`user_id` = `User`.`id`) WHERE `TopList`.`user_id` <> '4e88341b-443c-4937-b453-5a9e6d7b5f76' ORDER BY `title` asc LIMIT 3333
10SELECT `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '5a64e2ec-7f5c-48e8-afec-22d36d7b5e1b' 112
11SELECT `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '5814e10b-128c-4130-9214-13d56d7b5e1b' 112
12SELECT `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '54fd6040-6c5c-4b7d-abfe-76826d7b5e1b' 112
13SELECT `TopListItem`.`model`, `TopListItem`.`foreign_id`, `TopListItem`.`top_list_id` FROM `top_list_items` AS `TopListItem` WHERE `TopListItem`.`top_list_id` = ('5a7f585f-6374-453d-901c-3e126d7b5e1b') ORDER BY `TopListItem`.`created` ASC LIMIT 1114
14SELECT `Architecture`.`id`, `Architecture`.`title` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4caa0b8f-7124-4b4b-a897-3052183d6281' 002
15SELECT `Architect`.`id`, `Architect`.`title` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4caa0b8f-7124-4b4b-a897-3052183d6281' 112
16SELECT `Image`.`md_url`, `Image`.`sm_url`, `Image`.`id`, `Image`.`foreign_id` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('4caa0b8f-7124-4b4b-a897-3052183d6281') ORDER BY `_order` asc, `created` asc LIMIT 11144
17SELECT `TopListItem`.`model`, `TopListItem`.`foreign_id`, `TopListItem`.`top_list_id` FROM `top_list_items` AS `TopListItem` WHERE `TopListItem`.`top_list_id` = ('5814e1ea-0fc4-443d-a483-11d36d7b5e1b') ORDER BY `TopListItem`.`created` ASC LIMIT 1116
18SELECT `Architecture`.`id`, `Architecture`.`title` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '51dd462c-aac8-4c6a-8234-5bb36d7b5f76' 112
19SELECT `Image`.`md_url`, `Image`.`sm_url`, `Image`.`id`, `Image`.`foreign_id` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('51dd462c-aac8-4c6a-8234-5bb36d7b5f76') ORDER BY `_order` asc, `created` asc LIMIT 11133
20SELECT `Architect`.`id`, `Architect`.`title` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '51dd462c-aac8-4c6a-8234-5bb36d7b5f76' 002
21SELECT `TopListItem`.`model`, `TopListItem`.`foreign_id`, `TopListItem`.`top_list_id` FROM `top_list_items` AS `TopListItem` WHERE `TopListItem`.`top_list_id` = ('54fd61f9-c4b0-4546-87e9-0cf16d7b5e1b') ORDER BY `TopListItem`.`created` ASC LIMIT 1116
22SELECT `Architecture`.`id`, `Architecture`.`title` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '512de497-4164-4329-94ad-5e726d7b5f76' 112
23SELECT `Image`.`md_url`, `Image`.`sm_url`, `Image`.`id`, `Image`.`foreign_id` FROM `images` AS `Image` WHERE `Image`.`foreign_id` = ('512de497-4164-4329-94ad-5e726d7b5f76') ORDER BY `_order` asc, `created` asc LIMIT 11143
24SELECT `Architect`.`id`, `Architect`.`title` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '512de497-4164-4329-94ad-5e726d7b5f76' 002
25SELECT COUNT(*) AS `count` FROM `feeds` AS `Feed` WHERE `Feed`.`user_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' AND DATE_FORMAT(`Feed`.`created`, '%Y-%m-%d') >= '2019-08-18 00:00' 1117
26SELECT `Feed`.`id`, `Feed`.`type`, `Feed`.`user_id`, `Feed`.`model`, `Feed`.`foreign_id`, `Feed`.`created`, `TopListItem`.`id`, `TopListItem`.`top_list_id`, `TopListItem`.`foreign_id`, `TopListItem`.`model`, `TopListItem`.`user_id`, `TopListItem`.`weight`, `TopListItem`.`created`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`deleted`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`deleted`, `Architecture`.`city`, `Architecture`.`country_id`, `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification` FROM `feeds` AS `Feed` LEFT JOIN `top_list_items` AS `TopListItem` ON (`Feed`.`foreign_id` = `TopListItem`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Feed`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Feed`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `comments` AS `Comment` ON (`Feed`.`foreign_id` = `Comment`.`id`) LEFT JOIN `users` AS `User` ON (`Feed`.`user_id` = `User`.`id`) WHERE `Feed`.`user_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' ORDER BY `Feed`.`created` desc LIMIT 33329
27SELECT `TopListItem`.`id`, `TopListItem`.`top_list_id`, `TopListItem`.`foreign_id`, `TopListItem`.`model`, `TopListItem`.`user_id`, `TopListItem`.`weight`, `TopListItem`.`created` FROM `top_list_items` AS `TopListItem` WHERE `TopListItem`.`id` = '50bdfd94-06b0-4333-a12c-78d26d7b5f76' 002
28SELECT `TopListItem`.`id`, `TopListItem`.`top_list_id`, `TopListItem`.`foreign_id`, `TopListItem`.`model`, `TopListItem`.`user_id`, `TopListItem`.`weight`, `TopListItem`.`created` FROM `top_list_items` AS `TopListItem` WHERE `TopListItem`.`id` = '4b463919-e8f0-420c-afd7-0a6bb372233b' 002
29SELECT `TopListItem`.`id`, `TopListItem`.`top_list_id`, `TopListItem`.`foreign_id`, `TopListItem`.`model`, `TopListItem`.`user_id`, `TopListItem`.`weight`, `TopListItem`.`created` FROM `top_list_items` AS `TopListItem` WHERE `TopListItem`.`id` = '4d7c95b4-f458-48ef-ae19-595d6d7b5f76' 002
30SELECT `Architect`.`title`, `Architect`.`slug`, `Architect`.`deleted` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '50bdfd94-06b0-4333-a12c-78d26d7b5f76' 002
31SELECT `Architect`.`title`, `Architect`.`slug`, `Architect`.`deleted` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4b463919-e8f0-420c-afd7-0a6bb372233b' 002
32SELECT `Architect`.`title`, `Architect`.`slug`, `Architect`.`deleted` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4d7c95b4-f458-48ef-ae19-595d6d7b5f76' 002
33SELECT `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`deleted`, `Architecture`.`city`, `Architecture`.`country_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '50bdfd94-06b0-4333-a12c-78d26d7b5f76' 112
34SELECT `Country`.`id`, `Country`.`name`, `Country`.`user_count` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948a-7de0-4a3f-9aa3-4aed1030b5da' 112
35SELECT `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`deleted`, `Architecture`.`city`, `Architecture`.`country_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4b463919-e8f0-420c-afd7-0a6bb372233b' 112
36SELECT `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`deleted`, `Architecture`.`city`, `Architecture`.`country_id` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4d7c95b4-f458-48ef-ae19-595d6d7b5f76' 112
37SELECT `Country`.`id`, `Country`.`name`, `Country`.`user_count` FROM `countries` AS `Country` WHERE `Country`.`id` = '4936948b-8598-4ed9-aa3e-47781030b5da' 112
38SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id` FROM `comments` AS `Comment` WHERE `Comment`.`id` = '50bdfd94-06b0-4333-a12c-78d26d7b5f76' 002
39SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id` FROM `comments` AS `Comment` WHERE `Comment`.`id` = '4b463919-e8f0-420c-afd7-0a6bb372233b' 002
40SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id` FROM `comments` AS `Comment` WHERE `Comment`.`id` = '4d7c95b4-f458-48ef-ae19-595d6d7b5f76' 002
41SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification` FROM `users` AS `User` WHERE `User`.`id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' 112
42SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification` FROM `users` AS `User` WHERE `User`.`id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' 112
43SELECT `User`.`id`, `User`.`username`, `User`.`slug`, `User`.`fname`, `User`.`lname`, `User`.`verified`, `User`.`top_list_count`, `User`.`comment_count`, `User`.`old_id`, `User`.`created`, `User`.`modified`, `User`.`name`, `User`.`password`, `User`.`password_hash_version`, `User`.`old_password_hash`, `User`.`role_id`, `User`.`login`, `User`.`active`, `User`.`gender`, `User`.`profile_visit_count`, `User`.`country_id`, `User`.`state_id`, `User`.`background`, `User`.`profession`, `User`.`photo_url`, `User`.`sm_photo_url`, `User`.`architecture_count`, `User`.`architect_count`, `User`.`activation_reminded`, `User`.`website`, `User`.`facebook`, `User`.`twitter`, `User`.`archived`, `User`.`last_login`, `User`.`cancelled`, `User`.`comment_notification`, `User`.`watch_notification`, `User`.`collection_notification` FROM `users` AS `User` WHERE `User`.`id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' 112
44SELECT DISTINCT CommentsUser.comment_id, CommentsUser.parent_id, Comment.body, Comment.last_message_id, `Comment`.`id` FROM `comments_users` AS `CommentsUser` LEFT JOIN `comments` AS `Comment` ON (`CommentsUser`.`comment_id` = `Comment`.`id`) WHERE ((`CommentsUser`.`user_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76') OR (`CommentsUser`.`mention_user_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76') OR (`CommentsUser`.`foreign_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76')) ORDER BY `Comment`.`id` desc 17173
45SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`id` IN ('5a796554-5ee4-4437-9a86-03446d7b5e1b', '544756b4-c7b4-4d44-91e6-3c566d7b5e1b', '544756b1-457c-451d-a7ab-3b7c6d7b5e1b') ORDER BY `Comment`.`last_message_id` desc, `Comment`.`id` desc 332
46SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '5a795e23-0214-45f6-bbc7-07f36d7b5e1b' 112
47SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '5447558b-9570-4ceb-bb00-3c566d7b5e1b' 112
48SELECT `User`.`id`, `User`.`username`, `User`.`slug` FROM `users` AS `User` WHERE `User`.`id` = '5447558b-9570-4ceb-bb00-3c566d7b5e1b' 112
49SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '54909362-7db8-4a79-a5f6-17326d7b5e1b' 112
50SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 002
51SELECT `Architect`.`id`, `Architect`.`title`, `Architect`.`slug` FROM `architects` AS `Architect` WHERE `Architect`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 002
52SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '54909362-7db8-4a79-a5f6-17326d7b5e1b' 002
53SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 112
54SELECT `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 112
55SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '54909362-7db8-4a79-a5f6-17326d7b5e1b' 002
56SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 002
57SELECT `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug` FROM `users` AS `Receiver` WHERE `Receiver`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 002
58SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '54909362-7db8-4a79-a5f6-17326d7b5e1b' 002
59SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 002
60SELECT `TopList`.`id`, `TopList`.`title` FROM `top_lists` AS `TopList` WHERE `TopList`.`id` = '4ee89d7a-80f0-41b5-a6c3-25006d7b5f76' 002
61SELECT `Mention`.`id`, `Mention`.`username`, `Mention`.`slug`, `Mention`.`fname`, `Mention`.`lname`, `Mention`.`verified`, `Mention`.`top_list_count`, `Mention`.`comment_count`, `Mention`.`old_id`, `Mention`.`created`, `Mention`.`modified`, `Mention`.`name`, `Mention`.`password`, `Mention`.`password_hash_version`, `Mention`.`old_password_hash`, `Mention`.`role_id`, `Mention`.`login`, `Mention`.`active`, `Mention`.`gender`, `Mention`.`profile_visit_count`, `Mention`.`country_id`, `Mention`.`state_id`, `Mention`.`background`, `Mention`.`profession`, `Mention`.`photo_url`, `Mention`.`sm_photo_url`, `Mention`.`architecture_count`, `Mention`.`architect_count`, `Mention`.`activation_reminded`, `Mention`.`website`, `Mention`.`facebook`, `Mention`.`twitter`, `Mention`.`archived`, `Mention`.`last_login`, `Mention`.`cancelled`, `Mention`.`comment_notification`, `Mention`.`watch_notification`, `Mention`.`collection_notification`, `CommentsUser`.`id`, `CommentsUser`.`comment_id`, `CommentsUser`.`user_id`, `CommentsUser`.`mention_user_id`, `CommentsUser`.`foreign_id`, `CommentsUser`.`parent_id` FROM `users` AS `Mention` JOIN `comments_users` AS `CommentsUser` ON (`CommentsUser`.`comment_id` IN ('5a796554-5ee4-4437-9a86-03446d7b5e1b', '544756b4-c7b4-4d44-91e6-3c566d7b5e1b', '544756b1-457c-451d-a7ab-3b7c6d7b5e1b') AND `CommentsUser`.`mention_user_id` = `Mention`.`id`) 332
62SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`parent_id` = '5a796554-5ee4-4437-9a86-03446d7b5e1b' ORDER BY `Comment`.`id` DESC 003
63SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`parent_id` = '544756b4-c7b4-4d44-91e6-3c566d7b5e1b' ORDER BY `Comment`.`id` DESC 003
64SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_id`, `Comment`.`model`, `Comment`.`user_id`, `Comment`.`increment`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`author_ip`, `Comment`.`author_agent`, `Comment`.`body`, `Comment`.`created`, `Comment`.`modified`, `Comment`.`is_edited`, `Comment`.`last_message_id`, `User`.`id`, `User`.`username`, `User`.`slug`, `Architect`.`id`, `Architect`.`title`, `Architect`.`slug`, `Architecture`.`id`, `Architecture`.`title`, `Architecture`.`slug`, `Receiver`.`id`, `Receiver`.`username`, `Receiver`.`slug`, `TopList`.`id`, `TopList`.`title`, `OriginalComment`.`id`, `OriginalComment`.`author_name`, `OriginalComment`.`foreign_id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `User` ON (`Comment`.`user_id` = `User`.`id`) LEFT JOIN `architects` AS `Architect` ON (`Comment`.`foreign_id` = `Architect`.`id`) LEFT JOIN `architectures` AS `Architecture` ON (`Comment`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `Receiver` ON (`Comment`.`foreign_id` = `Receiver`.`id`) LEFT JOIN `top_lists` AS `TopList` ON (`Comment`.`foreign_id` = `TopList`.`id`) LEFT JOIN `comments` AS `OriginalComment` ON (`Comment`.`parent_id` = `OriginalComment`.`id`) WHERE `Comment`.`parent_id` = '544756b1-457c-451d-a7ab-3b7c6d7b5e1b' ORDER BY `Comment`.`id` DESC 003
65SELECT `Architect`.`id`, `Architect`.`old_id`, `Architect`.`user_id`, `Architect`.`comment_count`, `Architect`.`image_count`, `Architect`.`views`, `Architect`.`views_last_day`, `Architect`.`views_last_week`, `Architect`.`views_last_month`, `Architect`.`last_viewed`, `Architect`.`likes`, `Architect`.`nonlikes`, `Architect`.`created`, `Architect`.`modified`, `Architect`.`title`, `Architect`.`slug`, `Architect`.`date_of_birth`, `Architect`.`date_of_death`, `Architect`.`birthplace_city`, `Architect`.`birthplace_country`, `Architect`.`bio`, `Architect`.`html_biography`, `Architect`.`education`, `Architect`.`awards`, `Architect`.`company`, `Architect`.`history`, `Architect`.`quote`, `Architect`.`materials`, `Architect`.`sectors`, `Architect`.`tags`, `Architect`.`is_featured`, `Architect`.`last_featured_on`, `Architect`.`biography`, `Architect`.`start_year`, `Architect`.`start_month`, `Architect`.`start_day`, `Architect`.`end_year`, `Architect`.`end_month`, `Architect`.`end_day`, `Architect`.`texts`, `Architect`.`links`, `Architect`.`person`, `Architect`.`practice`, `Architect`.`practice_address`, `Architect`.`practice_city`, `Architect`.`practice_state`, `Architect`.`practice_zip`, `Architect`.`practice_country_id`, `Architect`.`practice_website`, `Architect`.`associates`, `Architect`.`deleted`, `Architect`.`deleted_date`, `Architect`.`is_incomplete`, `Architect`.`incomplete_date` FROM `architects` AS `Architect` WHERE `Architect`.`user_id` = '4e88341b-443c-4937-b453-5a9e6d7b5f76' AND `Architect`.`deleted` <> 1 ORDER BY `Architect`.`title` asc 12112124
66SELECT `Image`.`id`, `Image`.`aiid`, `Image`.`user_id`, `Image`.`model`, `Image`.`foreign_id`, `Image`.`description`, `Image`.`author`, `Image`.`license`, `Image`.`source_name`, `Image`.`source_link`, `Image`.`orig_url`, `Image`.`lg_url`, `Image`.`bg_url`, `Image`.`md_url`, `Image`.`sm_url`, `Image`.`th_url`, `Image`.`is_cropped`, `Image`.`orig_width`, `Image`.`orig_height`, `Image`.`_order`, `Image`.`modified`, `Image`.`created` FROM `images` AS `Image` WHERE `Image`.`foreign_id` IN ('4ebd25a3-4558-41e7-a003-02dd6d7b5f76', '50658c82-7530-405b-98bb-69816d7b5f76', '4eb7df3c-a5c4-46bd-b61b-12f56d7b5f76', '4fda87f4-0504-4ef8-87e1-5b2f6d7b5f76', '54364bf6-2210-4e40-ba74-1c636d7b5e1b', '4f0c16fe-0d94-4ca9-af0a-36e36d7b5f76', '533169b5-e284-4554-824d-23a06d7b5e1b', '4e969219-7958-4fc8-9394-27de6d7b5f76', '549f053f-d978-4edf-98c6-070c6d7b5e1b', '4eb923b8-7254-45fd-ab39-2b9e6d7b5f76', '50714790-2bc4-41e7-becc-7e9e6d7b5f76', '547b41c6-5154-467c-9d5e-47566d7b5e1b', '4f38d235-c704-4e40-b032-59526d7b5f76', '4eb7baf4-d8ec-4cf1-ba60-130f6d7b5f76', '4e959d27-e974-4993-a5da-116e6d7b5f76', '4eb7c107-2d50-4b51-8d26-13106d7b5f76', '4eb798ec-c108-467c-a313-12f36d7b5f76', '4e96c918-5cd8-479c-b5ac-280c6d7b5f76', '4f4ced99-489c-479b-93ed-01db6d7b5f76', '5332c44c-3494-4b84-b6de-01f66d7b5e1b', '547b72dc-c4ac-4fca-9811-486f6d7b5e1b', '4fbd2931-1858-4ae4-9f06-070c6d7b5f76', '4f215003-14f4-4b9b-90df-6ac86d7b5f76', '53577b5f-8c2c-4d75-addb-7bcb6d7b5e1b', '4ebd460b-66d8-46b7-b280-02dd6d7b5f76', '4f3b7cfe-a434-45b5-983d-157f6d7b5f76', '4f2a99a8-27d8-47cd-8d68-320b6d7b5f76', '4eb9165b-aa0c-463f-a6b4-2ba06d7b5f76', '5307a19f-e078-4db5-9d6f-6f4f6d7b5e1b', '4eb8f592-8df4-4b65-865f-2ba06d7b5f76', '5332991b-1f74-410b-9112-01f46d7b5e1b', '4f17f847-bf00-4973-8c04-16426d7b5f76', '4eb7f93c-1f68-4ab5-a967-12f36d7b5f76', '4ebbb97b-e208-4a6d-a838-6c4f6d7b5f76', '4e8c5a98-4e44-411c-8989-5a646d7b5f76', '547b5818-c1b0-4b70-a8c1-46436d7b5e1b', '4f06b188-f5b0-4957-aece-32266d7b5f76', '4fb389db-49f0-4df0-af9c-3dd76d7b5f76', '4e95596e-805c-4bb2-b748-115a6d7b5f76', '4f1d28e5-a374-4c81-8ebe-273c6d7b5f76', '533166d4-f230-4196-946d-27716d7b5e1b', '4eb3fdf4-4434-461f-a051-06b86d7b5f76', '4f6c3420-3ca8-48b2-a5a7-62a46d7b5f76', '4e96da2c-b090-4b5b-a7b9-28126d7b5f76', '4fb612d8-1520-4501-908c-09396d7b5f76', '4e96b0f0-17d4-43f6-a1c2-280e6d7b5f76', '4f0b6309-e06c-4cec-8568-363b6d7b5f76', '4f2123ab-551c-460c-a178-6ac86d7b5f76', '4f6309e4-5750-485f-b147-1ed76d7b5f76', '4fa8f86e-36c8-47f0-9e13-4aa56d7b5f76', '5358ddd4-5d68-4ca0-b297-28896d7b5e1b', '534fe7e3-ba44-42a1-8789-026b6d7b5e1b', '4eba5d13-4e4c-4e66-b6c4-56246d7b5f76', '4f2fc8b2-c108-447f-8837-1be76d7b5f76', '50570214-3448-491a-bc83-114f6d7b5f76', '4eb80c69-21ec-49c9-87f4-2bc06d7b5f76', '54b6dbe0-3ab0-47f3-a91a-650f6d7b5e1b', '4fa27b7c-5100-4ed6-9ffc-3f646d7b5f76', '4f959bdb-18e8-42d9-8e72-39f46d7b5f76', '4eba8b86-6978-4c69-9ba2-563f6d7b5f76', '503603d7-4658-4ec3-aa70-7e306d7b5f76', '4f3958c8-a900-4e55-9054-58c96d7b5f76', '5357cfc3-2204-4d6e-86f2-0d136d7b5e1b', '4e9351d9-c6a4-4c13-8d91-5b476d7b5f76', '4f1a9462-7d20-4faa-a6dd-3c506d7b5f76', '4eb93dac-2f9c-499f-b0b4-2ba06d7b5f76', '54909362-7db8-4a79-a5f6-17326d7b5e1b', '4eb7df3c-82bc-4eee-a3ca-12f56d7b5f76', '533168f9-9784-4194-8cc2-21396d7b5e1b', '4eb7ecfb-46a8-401f-9c82-12f56d7b5f76', '549f0c7c-83b4-4ed8-8c24-1aa76d7b5e1b', '4f5e3036-694c-4fb5-befc-43a86d7b5f76', '53427d0f-8500-497e-a676-4c7a6d7b5e1b', '535014dc-b398-45de-a3d8-0e0a6d7b5e1b', '4fda7cfe-340c-49a2-b9ed-5b2f6d7b5f76', '5358f2c6-a084-4279-8b75-28896d7b5e1b', '4f2a98ff-b188-43e0-a208-32006d7b5f76', '549f1548-5f78-47fe-a080-1b856d7b5e1b', '4fb267df-a7f8-4fd3-b216-170f6d7b5f76', '4f998f06-e990-4e6b-8862-12896d7b5f76', '505adf98-10f0-4b62-a634-02346d7b5f76', '4eba8b85-670c-4e31-aa66-563f6d7b5f76', '4e95fec3-d1ac-432a-9e7a-27de6d7b5f76', '502a763e-4380-4d3e-b530-1c516d7b5f76', '54bc055e-3e48-4a84-8971-4d4c6d7b5e1b', '4e958cdc-6930-44e2-84a7-116e6d7b5f76', '4ebce8ae-472c-405c-9d80-03376d7b5f76', '53578978-fc00-4a68-8423-7cbd6d7b5e1b', '4eb914ae-9d10-4a5c-9817-2b9d6d7b5f76', '4eb7a351-5fa8-420a-9a95-130f6d7b5f76', '4f1e6ca7-f900-4ef6-a1a2-45376d7b5f76', '4ee9caa9-d5fc-47a6-a798-3e2c6d7b5f76', '4f79e13c-2910-4269-870b-73f26d7b5f76', '4f1ff0a9-5238-42aa-b4f2-45376d7b5f76', '4ebaa07f-ce48-4251-b3b8-56416d7b5f76', '50570214-1acc-482c-9a83-114f6d7b5f76', '50570214-2594-4899-bf7a-114f6d7b5f76', '5056fc61-760c-4ef9-841b-111e6d7b5f76', '5357c94c-8e60-4d36-b51d-7c926d7b5e1b', '4f8bcb8a-3704-48fa-83be-51c26d7b5f76', '4eb3f22b-8ee4-4777-aae2-06b96d7b5f76', '50570213-63c8-4166-8e43-114f6d7b5f76', '4e96e6f6-78c0-405d-8914-280e6d7b5f76', '5289c8d2-5384-471e-980e-265e6d7b5f76', '4ebcfc6b-f8e0-4d87-9deb-02dd6d7b5f76', '4eb90882-9148-442b-9ba1-2bc06d7b5f76', '4f3a6b95-0ab8-4f94-aeb6-738e6d7b5f76', '4f3a6b95-2a88-43ec-9fdd-738e6d7b5f76', '5358daba-74c0-44f8-af26-28896d7b5e1b', '4eeb1240-70cc-4554-a7c4-54eb6d7b5f76', '4e8ed398-a98c-49b1-86cf-7e6d6d7b5f76', '4eb80067-d3c4-4ec6-ae34-12f56d7b5f76', '4f5e2ea7-5ce0-43b4-a5d4-43526d7b5f76', '54bbfaf2-b100-4501-8572-4c1a6d7b5e1b', '4f512bd3-1a1c-42d6-b418-507c6d7b5f76', '4f396dcb-cdd4-44b7-91da-58746d7b5f76', '4eb4128d-4980-48fa-a751-06b96d7b5f76', '4f8bcb45-5eb0-48de-9341-51c26d7b5f76', '4f1fcddd-3664-4287-9a64-45636d7b5f76', '5357833b-fcd4-474d-9ffc-7cbd6d7b5e1b', '4e95bd20-b6b0-4b25-b8d4-28126d7b5f76') ORDER BY `_order` asc, `created` asc 12712753