Locations
Browse Collections
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | 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` = 1000 AND `Item`.`status` <> 'trashed' LIMIT 1 | 1 | 1 | 0 | |
2 | 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` = 1000 AND `type` = 'annotation' AND `LinkRight`.`item_left_id` = (1000) | 0 | 0 | 0 | |
3 | SELECT `RevisionChild`.`id`, `RevisionChild`.`user_id`, `RevisionChild`.`revision_parent` FROM `cslide`.`items` AS `RevisionChild` WHERE `RevisionChild`.`revision_parent` = (1000) ORDER BY `created` DESC | 0 | 0 | 6 | |
4 | 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` = 1000 AND `ItemsTag`.`tag_id` = `Tag`.`id`) | 0 | 0 | 0 | |
5 | SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1000 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' | 0 | 0 | 0 | |
6 | SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1000 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' | 1 | 1 | 5 | |
7 | SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1000 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published' | 0 | 0 | 0 | |
8 | 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` = 1000 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC | 2 | 2 | 6 |