Created
January 16, 2013 17:19
-
-
Save drsnyder/4548929 to your computer and use it in GitHub Desktop.
slow gallery's query
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT external_store_objects.id, | 00:05:41.558663 | |
| COALESCE(original_filename, SUBSTRING(local_key FROM '[^/]+$')) AS path, | |
| external_store_objects.uploaded_on, | |
| gallery_images.id AS gallery_images_id, | |
| gallery_images.description, | |
| gallery_images.user_id, | |
| gallery_albums.id AS album_id, | |
| gallery_albums.name AS album_name, | |
| gallery_albums.type AS album_type, | |
| gallery_albums.object_type AS album_object_type, | |
| gallery_albums.object_id AS album_object_id, | |
| community.object_type AS community_album_object_type, | |
| community.object_id AS community_album_object_id, | |
| COALESCE(community.category_id, gallery_albums.category_id, 0) AS category_id, | |
| content_refs.link, | |
| COALESCE(gallery_album_images.is_default, false) AS is_default_album | |
| FROM external_store_objects | |
| LEFT JOIN gallery_images | |
| ON external_store_object_id = external_store_objects.id | |
| LEFT JOIN gallery_album_images | |
| ON gallery_album_images.image_id = gallery_images.id AND is_default | |
| LEFT JOIN gallery_albums | |
| ON gallery_albums.id = gallery_album_images.gallery_album_id | |
| LEFT JOIN gallery_albums community ON ( | |
| gallery_albums.object_type = get_huddler_constant('CONTENT_TYPE_GALLERY_ALBUM')::int AND | |
| community.id = gallery_albums.object_id | |
| ) | |
| LEFT JOIN content_refs | |
| ON content_refs.content_type = gallery_albums.object_type AND content_refs.content_id = gallery_albums.object_id | |
| WHERE external_store_objects.id IN (737822) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment