Tito`s Bunker Back to main article page
The bunker nowadays hosts the Biennal of Contemporary Art

All rights reserved
by srna.tulic
The bunker nowadays hosts the Biennal of Contemporary Art
All rights reserved
by srna.tulic
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `architectures` | 63 | 63 | 4 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | 1 | 1 | 2 | |
3 | SHOW FULL COLUMNS FROM `users` | 38 | 38 | 2 | |
4 | SHOW FULL COLUMNS FROM `roles` | 6 | 6 | 2 | |
5 | SHOW FULL COLUMNS FROM `countries` | 3 | 3 | 2 | |
6 | SHOW FULL COLUMNS FROM `states` | 3 | 3 | 2 | |
7 | SHOW FULL COLUMNS FROM `auth_keys` | 7 | 7 | 3 | |
8 | SHOW FULL COLUMNS FROM `auth_key_types` | 2 | 2 | 2 | |
9 | SHOW FULL COLUMNS FROM `feeds` | 6 | 6 | 2 | |
10 | SHOW FULL COLUMNS FROM `top_list_items` | 7 | 7 | 2 | |
11 | SHOW FULL COLUMNS FROM `top_lists` | 5 | 5 | 2 | |
12 | SHOW FULL COLUMNS FROM `architects` | 54 | 54 | 5 | |
13 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 2 | |
14 | SHOW FULL COLUMNS FROM `articles` | 22 | 22 | 3 | |
15 | SHOW FULL COLUMNS FROM `object_views` | 5 | 5 | 2 | |
16 | SHOW FULL COLUMNS FROM `associates` | 6 | 6 | 2 | |
17 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 2 | |
18 | SHOW FULL COLUMNS FROM `images` | 22 | 22 | 2 | |
19 | SHOW FULL COLUMNS FROM `sources` | 7 | 7 | 3 | |
20 | SHOW FULL COLUMNS FROM `timelines` | 6 | 6 | 2 | |
21 | SHOW FULL COLUMNS FROM `hp_features` | 4 | 4 | 4 | |
22 | SHOW FULL COLUMNS FROM `comments` | 16 | 16 | 5 | |
23 | SHOW FULL COLUMNS FROM `wall_posts` | 7 | 7 | 3 | |
24 | SHOW FULL COLUMNS FROM `profile_visits` | 4 | 4 | 2 | |
25 | SHOW FULL COLUMNS FROM `login_tokens` | 7 | 7 | 4 | |
26 | SHOW FULL COLUMNS FROM `watched_objects` | 6 | 6 | 5 | |
27 | SHOW FULL COLUMNS FROM `comments_users` | 6 | 6 | 4 | |
28 | SHOW FULL COLUMNS FROM `tags` | 5 | 5 | 2 | |
29 | SHOW FULL COLUMNS FROM `architectures_tags` | 6 | 6 | 2 | |
30 | SHOW FULL COLUMNS FROM `architects_tags` | 6 | 6 | 2 | |
31 | SHOW FULL COLUMNS FROM `versions` | 8 | 8 | 3 | |
32 | SELECT `Role`.`name`, `Role`.`permissions` FROM `roles` AS `Role` WHERE 1 = 1 | 5 | 5 | 9 | |
33 | SELECT `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 1 | 1 | 1 | 34 | |
34 | SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' | 1 | 1 | 2 | |
35 | SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' | 1 | 1 | 2 | |
36 | UPDATE `users` SET `id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1', `last_login` = '2019-12-09 00:20:10', `modified` = '2019-12-09 00:20:10' WHERE `users`.`id` = '7e59ae88-ffa7-11de-b287-4f8fe1b9fcc1' | 1 | 3 | ||
37 | SELECT `Architecture`.`title`, `Architecture`.`slug` FROM `architectures` AS `Architecture` WHERE `Architecture`.`deleted` <> 1 ORDER BY Rand() ASC LIMIT 1 | 1 | 1 | 15 | |
38 | SELECT `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`, `Architecture`.`id`, `Architecture`.`user_id`, `Architecture`.`old_id`, `Architecture`.`old_architect_id`, `Architecture`.`comment_count`, `Architecture`.`image_count`, `Architecture`.`views`, `Architecture`.`views_last_day`, `Architecture`.`views_last_week`, `Architecture`.`views_last_month`, `Architecture`.`last_viewed`, `Architecture`.`likes`, `Architecture`.`nonlikes`, `Architecture`.`created`, `Architecture`.`modified`, `Architecture`.`title`, `Architecture`.`slug`, `Architecture`.`html_description`, `Architecture`.`also_known_as`, `Architecture`.`address`, `Architecture`.`city`, `Architecture`.`state`, `Architecture`.`country_id`, `Architecture`.`zip`, `Architecture`.`lat`, `Architecture`.`lng`, `Architecture`.`area`, `Architecture`.`team`, `Architecture`.`partners`, `Architecture`.`client`, `Architecture`.`client_website`, `Architecture`.`company`, `Architecture`.`cost`, `Architecture`.`cost_currency`, `Architecture`.`architecture_type_id`, `Architecture`.`architecture_condition_id`, `Architecture`.`old_building_condition_id`, `Architecture`.`old_building_type_id`, `Architecture`.`structural_engineers`, `Architecture`.`service_engineers`, `Architecture`.`site_supervision`, `Architecture`.`project_management`, `Architecture`.`start_date`, `Architecture`.`end_date`, `Architecture`.`movements`, `Architecture`.`materials`, `Architecture`.`tags`, `Architecture`.`is_featured`, `Architecture`.`last_featured_on`, `Architecture`.`description`, `Architecture`.`start_year`, `Architecture`.`start_month`, `Architecture`.`start_day`, `Architecture`.`end_year`, `Architecture`.`end_month`, `Architecture`.`end_day`, `Architecture`.`texts`, `Architecture`.`links`, `Architecture`.`website`, `Architecture`.`deleted`, `Architecture`.`deleted_date`, `Architecture`.`is_incomplete`, `Architecture`.`incomplete_date`, `User`.`username`, `User`.`slug` FROM `images` AS `Image` LEFT JOIN `architectures` AS `Architecture` ON (`Image`.`foreign_id` = `Architecture`.`id`) LEFT JOIN `users` AS `User` ON (`Image`.`user_id` = `User`.`id`) WHERE `Image`.`aiid` = 23408 LIMIT 1 | 1 | 1 | 35 | |
39 | SELECT `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`, `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 `images` AS `Image` LEFT JOIN `users` AS `User` ON (`Image`.`user_id` = `User`.`id`) WHERE `foreign_id` = '5916c55f-eeb0-4172-9220-4e206d7b5e1b' ORDER BY `Image`.`_order` asc, `Image`.`created` asc | 17 | 17 | 68 |