X
(default) 22 queries took 18 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1082110
2SELECT `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` = 1082 AND `Item`.`status` <> 'trashed' LIMIT 1110
3SELECT `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` = '1082' AND `type` = 'annotation' AND `LinkRight`.`item_left_id` = (1082)000
4SELECT `RevisionChild`.`id`, `RevisionChild`.`user_id`, `RevisionChild`.`revision_parent` FROM `cslide`.`items` AS `RevisionChild` WHERE `RevisionChild`.`revision_parent` = (1082) ORDER BY `created` DESC225
5SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 136110
6SELECT `AppUser`.`slug`, `AppUser`.`display_name` FROM `cslide`.`users` AS `AppUser` WHERE `AppUser`.`id` = 136110
7SELECT `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` = 1082 AND `ItemsTag`.`tag_id` = `Tag`.`id`) 000
8SELECT `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` <> 1082) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1082) 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` = 1082) OR (`LinkRight`.`item_left_id` = 1082)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC001
9SELECT `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` <> 1082) LEFT JOIN `cslide`.`items` AS `ItemRight` ON (`LinkRight`.`item_right_id` = `ItemRight`.`id` AND `ItemRight`.`id` <> 1082) 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` = 1082) OR (`LinkRight`.`item_left_id` = 1082)) ORDER BY `LinkType`.`order` ASC, `LinkRight`.`confidence` DESC, `ItemLeft`.`name` ASC, `ItemRight`.`name` ASC LIMIT 20001
10SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1082 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
11SELECT `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` ASC110
12SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1005 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
13SELECT `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` ASC110
14SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1000 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
15SELECT `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` ASC000
16SELECT `LinkLeft`.`id`, `LinkLeft`.`item_left_id` FROM `cslide`.`links` AS `LinkLeft` WHERE `item_right_id` = 1082 AND `LinkLeft`.`type` = 'parent' AND `LinkLeft`.`revision_parent` = 0 AND `LinkLeft`.`status` = 'published'000
17SELECT `Item`.`id`, `Item`.`primary_parent` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = 1082 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' LIMIT 1110
18SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`id` = (1005) AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published'110
19SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1082 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published'000
20SELECT COUNT(*) AS `count` FROM `cslide`.`items` AS `Item` WHERE `Item`.`primary_parent` = 1082 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published'115
21SELECT `LinkRight`.`id`, `LinkRight`.`item_right_id` FROM `cslide`.`links` AS `LinkRight` WHERE `item_left_id` = 1082 AND `LinkRight`.`type` = 'parent' AND `LinkRight`.`revision_parent` = 0 AND `LinkRight`.`status` = 'published'000
22SELECT `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` = 1082 AND `Item`.`revision_parent` = 0 AND `Item`.`status` = 'published' ORDER BY `Item`.`name` ASC13136