1 | SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1008 | | 1 | 1 | 0 |
2 | SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`description`, `Item`.`markings`, `Item`.`zoomable_url`, `Item`.`initial_rotation`, `Item`.`disable_annotations`, `Item`.`zoomify_slideshow`, `Item`.`360_url`, `Item`.`external_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest`, `Item`.`flickr_set`, `Item`.`show_gallery`, `Item`.`user_id`, `Item`.`created`, `Item`.`modified`, `Item`.`primary_parent`, `Item`.`revision_parent`, `Item`.`status`, `AppUser`.`slug`, `AppUser`.`display_name`, `Person`.`sex`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`items` AS `Item` LEFT JOIN `cslide`.`users` AS `AppUser` ON (`Item`.`user_id` = `AppUser`.`id`) LEFT JOIN `cslide`.`people` AS `Person` ON (`Person`.`item_id` = `Item`.`id`) WHERE `Item`.`id` = 1008 AND `Item`.`status` <> 'trashed' LIMIT 1 | | 1 | 1 | 0 |
3 | SELECT `LinkRight`.`id`, `LinkRight`.`item_left_id`, `LinkRight`.`type` FROM `cslide`.`links` AS `LinkRight` WHERE `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' AND `item_left_id` = '1008' AND `type` = 'annotation' AND `LinkRight`.`item_left_id` = (1008) | | 0 | 0 | 0 |
4 | SELECT `RevisionChild`.`id`, `RevisionChild`.`user_id`, `RevisionChild`.`revision_parent` FROM `cslide`.`items` AS `RevisionChild` WHERE `RevisionChild`.`revision_parent` = (1008) ORDER BY `created` DESC | | 5 | 5 | 6 |
5 | SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 32 | | 1 | 1 | 0 |
6 | SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 32 | | 1 | 1 | 0 |
7 | SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 6 | | 1 | 1 | 0 |
8 | SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 6 | | 1 | 1 | 0 |
9 | SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 6 | | 1 | 1 | 0 |
10 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`type`, `ItemsTag`.`item_id`, `ItemsTag`.`tag_id` FROM `cslide`.`tags` AS `Tag` JOIN `cslide`.`items_tags` AS `ItemsTag` ON (`ItemsTag`.`item_id` = 1008 AND `ItemsTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 0 |
11 | SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id`, `LinkLeft`.`type`, `LinkLeft`.`item_right_id`, `LinkLeft`.`description`, `LinkLeft`.`confidence`, `LinkLeft`.`location_id`, `LinkLeft`.`date_from`, `LinkLeft`.`date_to`, `LinkLeft`.`date_type`, `LinkLeft`.`link_group_id`, `LinkLeft`.`user_id`, `LinkLeft`.`created`, `LinkLeft`.`modified`, `LinkLeft`.`revision_parent`, `LinkLeft`.`status`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `Location`.`id`, `Location`.`name`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order`, `LinkGroup`.`id`, `LinkGroup`.`type` FROM `cslide`.`links` AS `LinkLeft` LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkLeft`.`item_right_id` = `ItemRight`.`id`) LEFT JOIN `cslide`.`locations` AS `Location` ON (`LinkLeft`.`location_id` = `Location`.`id`) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkLeft`.`type` = `LinkType`.`id`) LEFT JOIN `cslide`.`link_groups` AS `LinkGroup` ON (`LinkLeft`.`link_group_id` = `LinkGroup`.`id`) WHERE `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published' AND `LinkLeft`.`item_left_id` = 1008 AND ((`LinkType`.`id` = 'creation') OR (`LinkType`.`parent` = 'creation')) ORDER BY `ItemRight`.`name` ASC | | 1 | 1 | 1 |
12 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 851 | | 1 | 1 | 0 |
13 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`type`, `LinksTag`.`link_id`, `LinksTag`.`tag_id` FROM `cslide`.`tags` AS `Tag` JOIN `cslide`.`links_tags` AS `LinksTag` ON (`LinksTag`.`link_id` = 2 AND `LinksTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 0 |
14 | SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id`, `LinkLeft`.`type`, `LinkLeft`.`item_right_id`, `LinkLeft`.`description`, `LinkLeft`.`confidence`, `LinkLeft`.`location_id`, `LinkLeft`.`date_from`, `LinkLeft`.`date_to`, `LinkLeft`.`date_type`, `LinkLeft`.`link_group_id`, `LinkLeft`.`user_id`, `LinkLeft`.`created`, `LinkLeft`.`modified`, `LinkLeft`.`revision_parent`, `LinkLeft`.`status`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `Location`.`id`, `Location`.`name`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order`, `LinkGroup`.`id`, `LinkGroup`.`type` FROM `cslide`.`links` AS `LinkLeft` LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkLeft`.`item_right_id` = `ItemRight`.`id`) LEFT JOIN `cslide`.`locations` AS `Location` ON (`LinkLeft`.`location_id` = `Location`.`id`) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkLeft`.`type` = `LinkType`.`id`) LEFT JOIN `cslide`.`link_groups` AS `LinkGroup` ON (`LinkLeft`.`link_group_id` = `LinkGroup`.`id`) WHERE `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published' AND `LinkLeft`.`item_left_id` = 1008 AND ((`LinkType`.`id` = 'current_holder') OR (`LinkType`.`parent` = 'current_holder')) ORDER BY `ItemRight`.`name` ASC | | 2 | 2 | 1 |
15 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 3196 | | 1 | 1 | 0 |
16 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 1058 | | 0 | 0 | 0 |
17 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`type`, `LinksTag`.`link_id`, `LinksTag`.`tag_id` FROM `cslide`.`tags` AS `Tag` JOIN `cslide`.`links_tags` AS `LinksTag` ON (`LinksTag`.`link_id` IN (4518, 4517) AND `LinksTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 0 |
18 | SELECT `LinkRight`.`id`, `LinkRight`.`item_left_id`, `LinkRight`.`type`, `LinkRight`.`item_right_id`, `LinkRight`.`description`, `LinkRight`.`confidence`, `LinkRight`.`location_id`, `LinkRight`.`date_from`, `LinkRight`.`date_to`, `LinkRight`.`date_type`, `LinkRight`.`link_group_id`, `LinkRight`.`user_id`, `LinkRight`.`created`, `LinkRight`.`modified`, `LinkRight`.`revision_parent`, `LinkRight`.`status`, `ItemLeft`.`id`, `ItemLeft`.`type`, `ItemLeft`.`name`, `ItemLeft`.`zoomable_url`, `ItemLeft`.`thumbnail`, `ItemLeft`.`thumb_farm`, `ItemLeft`.`thumb_server`, `ItemLeft`.`thumb_id`, `ItemLeft`.`thumb_secret`, `ItemLeft`.`thumb_largest`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order` FROM `cslide`.`links` AS `LinkRight` LEFT JOIN `cslide`.`items` AS `ItemLeft` ON (`LinkRight`.`item_left_id` = `ItemLeft`.`id` AND `ItemLeft`.`id` <> 1008) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1008) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkRight`.`type` = `LinkType`.`id`) WHERE `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' AND `LinkRight`.`type` NOT IN ('primary_parent', 'parent', 'annotation') AND ((`LinkRight`.`item_right_id` = 1008) OR (`LinkRight`.`item_left_id` = 1008)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC | | 6 | 6 | 1 |
19 | SELECT `LinkRight`.`id`, `LinkRight`.`item_left_id`, `LinkRight`.`type`, `LinkRight`.`item_right_id`, `LinkRight`.`description`, `LinkRight`.`confidence`, `LinkRight`.`location_id`, `LinkRight`.`date_from`, `LinkRight`.`date_to`, `LinkRight`.`date_type`, `LinkRight`.`link_group_id`, `LinkRight`.`user_id`, `LinkRight`.`created`, `LinkRight`.`modified`, `LinkRight`.`revision_parent`, `LinkRight`.`status`, `ItemLeft`.`id`, `ItemLeft`.`type`, `ItemLeft`.`name`, `ItemLeft`.`zoomable_url`, `ItemLeft`.`thumbnail`, `ItemLeft`.`thumb_farm`, `ItemLeft`.`thumb_server`, `ItemLeft`.`thumb_id`, `ItemLeft`.`thumb_secret`, `ItemLeft`.`thumb_largest`, `ItemRight`.`id`, `ItemRight`.`type`, `ItemRight`.`name`, `ItemRight`.`zoomable_url`, `ItemRight`.`thumbnail`, `ItemRight`.`thumb_farm`, `ItemRight`.`thumb_server`, `ItemRight`.`thumb_id`, `ItemRight`.`thumb_secret`, `ItemRight`.`thumb_largest`, `Location`.`id`, `Location`.`name`, `AppUser`.`slug`, `AppUser`.`display_name`, `LinkType`.`id`, `LinkType`.`parent`, `LinkType`.`right_title`, `LinkType`.`right_description`, `LinkType`.`right_type`, `LinkType`.`left_title`, `LinkType`.`left_description`, `LinkType`.`order` FROM `cslide`.`links` AS `LinkRight` LEFT JOIN `cslide`.`items` AS `ItemLeft` ON (`LinkRight`.`item_left_id` = `ItemLeft`.`id` AND `ItemLeft`.`id` <> 1008) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1008) LEFT JOIN `cslide`.`locations` AS `Location` ON (`LinkRight`.`location_id` = `Location`.`id`) LEFT JOIN `cslide`.`users` AS `AppUser` ON (`LinkRight`.`user_id` = `AppUser`.`id`) LEFT JOIN `cslide`.`link_types` AS `LinkType` ON (`LinkRight`.`type` = `LinkType`.`id`) WHERE `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' AND `LinkRight`.`type` NOT IN ('primary_parent', 'parent', 'annotation') AND ((`LinkRight`.`item_right_id` = 1008) OR (`LinkRight`.`item_left_id` = 1008)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC LIMIT 20 | | 6 | 6 | 2 |
20 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 3193 | | 1 | 1 | 0 |
21 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 3256 | | 0 | 0 | 0 |
22 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 851 | | 1 | 1 | 0 |
23 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 3196 | | 1 | 1 | 0 |
24 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 1058 | | 0 | 0 | 0 |
25 | SELECT `Person`.`id`, (TRIM(CONCAT(TRIM(`Person`.`title`), " ", TRIM(`Person`.`firstnames`), " ", TRIM(`Person`.`lastname`)))) AS `Person__fullname` FROM `cslide`.`people` AS `Person` WHERE `Person`.`item_id` = 1829 | | 1 | 1 | 0 |
26 | SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`type`, `LinksTag`.`link_id`, `LinksTag`.`tag_id` FROM `cslide`.`tags` AS `Tag` JOIN `cslide`.`links_tags` AS `LinksTag` ON (`LinksTag`.`link_id` IN (2, 4518, 4517, 4514, 4515, 5207) AND `LinksTag`.`tag_id` = `Tag`.`id`) | | 0 | 0 | 0 |
27 | SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1008 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1 | | 1 | 1 | 0 |
28 | SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1005) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC | | 1 | 1 | 0 |
29 | SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1005 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1 | | 1 | 1 | 0 |
30 | SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1000) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC | | 1 | 1 | 0 |
31 | SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1000 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1 | | 1 | 1 | 0 |
32 | SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (NULL) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC | | 0 | 0 | 0 |
33 | SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id` FROM `cslide`.`links` AS `LinkLeft` WHERE `item_right_id` = 1008 AND `LinkLeft`.`type` = 'parent' AND `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published' | | 0 | 0 | 0 |
34 | SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1008 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1 | | 1 | 1 | 0 |
35 | SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1005) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' | | 1 | 1 | 0 |
36 | SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1008 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' | | 0 | 0 | 0 |
37 | SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1008 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' | | 1 | 1 | 5 |
38 | SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1008 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' | | 0 | 0 | 0 |
39 | SELECT `Item`.`id`, `Item`.`type`, `Item`.`name`, `Item`.`zoomable_url`, `Item`.`thumbnail`, `Item`.`thumb_farm`, `Item`.`thumb_server`, `Item`.`thumb_id`, `Item`.`thumb_secret`, `Item`.`thumb_largest` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1008 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC | | 21 | 21 | 6 |