X
(default) 8 queries took 18 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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 1111
2SELECT `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)000
3SELECT `RevisionChild`.`id`, `RevisionChild`.`user_id`, `RevisionChild`.`revision_parent` FROM `cslide`.`items` AS `RevisionChild` WHERE `RevisionChild`.`revision_parent` = (1000) ORDER BY `created` DESC006
4SELECT `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`) 000
5SELECT `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'000
6SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1000 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published'115
7SELECT `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'000
8SELECT `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` ASC226