| 1 |
./ellington/media/views/photogalleries.py:152 |
SELECT "photogallery_sets"."id", "photogallery_sets"."name", "photogallery_sets"."slug", "photogallery_sets"."blurb", "photogallery_sets"."creation_date", "photogallery_sets"."template_name" FROM "photogallery_sets" WHERE "photogallery_sets"."slug" = fighting |
0.002 |
| 2 |
./ellington/media/views/photogalleries.py:166 |
SELECT "news_photo_galleries"."id", "news_photo_galleries"."name", "news_photo_galleries"."slug", "news_photo_galleries"."blurb", "news_photo_galleries"."creation_date", "news_photo_galleries"."pub_date", "news_photo_galleries"."updated_date", "news_photo_galleries"."deleted", "news_photo_galleries"."template_prefix", "news_photo_galleries"."is_static", "news_photo_galleries"."comment_status", "news_photo_galleries"."trusted_comments_only", "news_photo_galleries"."ad_sensitivity" FROM "news_photo_galleries" JOIN "news_photo_galleries_sets" AS "t1" ON "news_photo_galleries"."id" = "t1"."gallery_id" WHERE "news_photo_galleries"."id" IN (SELECT "photo_gallery_id" FROM "news_photo_galleries_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "news_photo_galleries"."pub_date" <= NOW() + INTERVAL '1 year' AND "news_photo_galleries"."deleted" = False AND "t1"."galleryset_id" = 54 ORDER BY "news_photo_galleries"."pub_date" DESC LIMIT 20 |
0.017 |
| 3 |
./ellington/media/views/photogalleries.py:183 |
SELECT "content_types"."id", "content_types"."name", "content_types"."package", "content_types"."python_module_name" FROM "content_types" WHERE "content_types"."package" = photogalleries AND "content_types"."python_module_name" = galleries |
0.001 |
| 4 |
./ellington/media/views/photogalleries.py:189 |
SELECT COUNT(*) FROM "news_photo_galleries" JOIN "news_photo_galleries_sets" AS "t1" ON "news_photo_galleries"."id" = "t1"."gallery_id" WHERE "news_photo_galleries"."id" IN (SELECT "photo_gallery_id" FROM "news_photo_galleries_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "news_photo_galleries"."pub_date" <= NOW() + INTERVAL '1 year' AND "news_photo_galleries"."deleted" = False AND "t1"."galleryset_id" = 54 |
0.010 |
| 5 |
./ellington/media/views/photogalleries.py:186 |
SELECT COUNT(*) FROM "core_sessions" WHERE "core_sessions"."session_key" = 6b69b080ef9f4d58abc5a626a5b1653f |
0.001 |
| 6 |
./ellington/core/ellington_context_processors.py:58 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE "sites"."id" = 1 |
0.002 |
| 7 |
./ellington/core/templatetags/smart_cache.py:77 |
SELECT "content_types"."id", "content_types"."name", "content_types"."package", "content_types"."python_module_name" FROM "content_types" WHERE "content_types"."package" = news AND "content_types"."python_module_name" = stories |
0.000 |
| 8 |
./ellington/core/templatetags/smart_cache.py:77 |
SELECT "content_types"."id", "content_types"."name", "content_types"."package", "content_types"."python_module_name" FROM "content_types" WHERE "content_types"."package" = weblogs AND "content_types"."python_module_name" = entries |
0.000 |
| 9 |
./ellington/mailfriend/templatetags/mailfriend.py:133 |
SELECT "content_types"."id", "content_types"."name", "content_types"."package", "content_types"."python_module_name" FROM "content_types" WHERE "content_types"."package" = news AND "content_types"."python_module_name" = stories |
0.000 |
| 10 |
./ellington/core/templatetags/smart_cache.py:77 |
SELECT "content_types"."id", "content_types"."name", "content_types"."package", "content_types"."python_module_name" FROM "content_types" WHERE "content_types"."package" = news AND "content_types"."python_module_name" = stories |
0.000 |
| 11 |
./ellington/core/templatetags/smart_cache.py:77 |
SELECT "content_types"."id", "content_types"."name", "content_types"."package", "content_types"."python_module_name" FROM "content_types" WHERE "content_types"."package" = news AND "content_types"."python_module_name" = stories |
0.000 |
| 12 |
./ellington/weather/templatetags/weather.py:105 |
SELECT "weather_conditions"."id", "weather_conditions"."station_id", "weather_conditions"."timestamp", "weather_conditions"."temperature", "weather_conditions"."heat_index", "weather_conditions"."dew_point", "weather_conditions"."wind_speed", "weather_conditions"."wind_dir", "weather_conditions"."visibility", "weather_conditions"."humidity", "weather_conditions"."pressure", "weather_conditions"."uv_index", "weather_conditions"."pollen_trees", "weather_conditions"."pollen_weeds", "weather_conditions"."pollen_grass", "weather_conditions"."pollen_mold", "weather_conditions"."weather_text" FROM "weather_conditions" JOIN "weather_weatherstations" AS "t1" ON "weather_conditions"."station_id" = "t1"."id" WHERE "t1"."metar" ::text ILIKE klas AND "weather_conditions"."temperature" IS NOT NULL ORDER BY "weather_conditions"."timestamp" DESC LIMIT 1 |
0.001 |
| 13 |
./ellington/fragments/templatetags/fragments.py:56 |
SELECT "fragments"."id", "fragments"."label", "fragments"."content", "fragments"."data", "fragments"."last_updated", "fragments"."active" FROM "fragments" WHERE "fragments"."id" IN (SELECT "fragment_id" FROM "fragments_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "fragments"."active" = True AND "fragments"."label" = piano_nav |
0.001 |
| 14 |
./ellington/fragments/templatetags/fragments.py:56 |
SELECT "fragments"."id", "fragments"."label", "fragments"."content", "fragments"."data", "fragments"."last_updated", "fragments"."active" FROM "fragments" WHERE "fragments"."id" IN (SELECT "fragment_id" FROM "fragments_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "fragments"."active" = True AND "fragments"."label" = fighting-subnav-events |
0.001 |
| 15 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 33369 |
0.000 |
| 16 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 33369 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.001 |
| 17 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 786629 |
0.001 |
| 18 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 786629 AND origin = TRUE LIMIT 1) |
0.001 |
| 19 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 33369 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 20 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 33361 |
0.000 |
| 21 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 33361 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 22 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 786413 |
0.000 |
| 23 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 786413 AND origin = TRUE LIMIT 1) |
0.000 |
| 24 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 33361 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 25 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 33360 |
0.000 |
| 26 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 33360 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 27 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 786400 |
0.000 |
| 28 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 786400 AND origin = TRUE LIMIT 1) |
0.000 |
| 29 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 33360 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 30 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 33358 |
0.000 |
| 31 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 33358 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.001 |
| 32 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 786358 |
0.000 |
| 33 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 786358 AND origin = TRUE LIMIT 1) |
0.000 |
| 34 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 33358 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 35 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 33343 |
0.000 |
| 36 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 33343 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 37 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 786105 |
0.000 |
| 38 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 786105 AND origin = TRUE LIMIT 1) |
0.000 |
| 39 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 33343 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 40 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 32408 |
0.001 |
| 41 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 32408 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.001 |
| 42 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 763823 |
0.001 |
| 43 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 763823 AND origin = TRUE LIMIT 1) |
0.000 |
| 44 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 32408 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 45 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 32407 |
0.000 |
| 46 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 32407 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 47 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 763829 |
0.000 |
| 48 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 763829 AND origin = TRUE LIMIT 1) |
0.000 |
| 49 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 32407 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 50 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 32400 |
0.000 |
| 51 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 32400 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 52 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 763638 |
0.000 |
| 53 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 763638 AND origin = TRUE LIMIT 1) |
0.000 |
| 54 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 32400 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 55 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 32194 |
0.000 |
| 56 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 32194 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 57 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 758213 |
0.000 |
| 58 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 758213 AND origin = TRUE LIMIT 1) |
0.000 |
| 59 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 32194 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 60 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 32004 |
0.000 |
| 61 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 32004 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 62 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 752954 |
0.000 |
| 63 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 752954 AND origin = TRUE LIMIT 1) |
0.000 |
| 64 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 32004 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 65 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 32003 |
0.000 |
| 66 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 32003 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 67 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 752950 |
0.001 |
| 68 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 752950 AND origin = TRUE LIMIT 1) |
0.000 |
| 69 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 32003 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 70 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31992 |
0.000 |
| 71 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31992 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 72 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 752659 |
0.000 |
| 73 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 752659 AND origin = TRUE LIMIT 1) |
0.000 |
| 74 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31992 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 75 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31913 |
0.000 |
| 76 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31913 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.001 |
| 77 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 750682 |
0.001 |
| 78 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 750682 AND origin = TRUE LIMIT 1) |
0.000 |
| 79 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31913 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 80 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31541 |
0.000 |
| 81 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31541 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.001 |
| 82 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 741032 |
0.000 |
| 83 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 741032 AND origin = TRUE LIMIT 1) |
0.001 |
| 84 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31541 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 85 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31536 |
0.000 |
| 86 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31536 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 87 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 740911 |
0.000 |
| 88 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 740911 AND origin = TRUE LIMIT 1) |
0.000 |
| 89 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31536 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 90 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31529 |
0.000 |
| 91 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31529 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 92 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 740782 |
0.000 |
| 93 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 740782 AND origin = TRUE LIMIT 1) |
0.000 |
| 94 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31529 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 95 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31525 |
0.000 |
| 96 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31525 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 97 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 740682 |
0.000 |
| 98 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 740682 AND origin = TRUE LIMIT 1) |
0.000 |
| 99 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31525 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 100 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31207 |
0.000 |
| 101 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31207 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 102 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 733232 |
0.000 |
| 103 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 733232 AND origin = TRUE LIMIT 1) |
0.001 |
| 104 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31207 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 105 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 31206 |
0.000 |
| 106 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 31206 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 107 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 733221 |
0.000 |
| 108 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 733221 AND origin = TRUE LIMIT 1) |
0.000 |
| 109 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 31206 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.001 |
| 110 |
./ellington/media/views/photogalleries.py:194 |
SELECT "news_photo_galleries_publication_rights"."id", "news_photo_galleries_publication_rights"."photo_gallery_id", "news_photo_galleries_publication_rights"."site_id", "news_photo_galleries_publication_rights"."origin", "news_photo_galleries_publication_rights"."rights" FROM "news_photo_galleries_publication_rights" WHERE "news_photo_galleries_publication_rights"."rights" = 2 AND "news_photo_galleries_publication_rights"."photo_gallery_id" = 30763 |
0.000 |
| 111 |
./ellington/media/models/photogalleries.py:178 |
SELECT "news_gallery_photos"."id", "news_gallery_photos"."gallery_id", "news_gallery_photos"."photo_id" FROM "news_gallery_photos" WHERE "news_gallery_photos"."gallery_id" = 30763 ORDER BY "news_gallery_photos"."_order" ASC LIMIT 1 |
0.000 |
| 112 |
./ellington/core/parts/templatetags.py:437 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" = 722281 |
0.000 |
| 113 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 722281 AND origin = TRUE LIMIT 1) |
0.000 |
| 114 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 30763 AND "t1"."package" = photogalleries AND "t1"."python_module_name" = galleries AND "comments"."site_id" = 1 |
0.000 |
| 115 |
./ellington/core/parts/most_x_logic.py:111 |
SELECT "weblogs_entries"."id", "weblogs_entries"."author_id", "weblogs_entries"."one_off_by_line", "weblogs_entries"."blog_id", "weblogs_entries"."title", "weblogs_entries"."slug", "weblogs_entries"."summary", "weblogs_entries"."entry_icon", "weblogs_entries"."body", "weblogs_entries"."pub_date", "weblogs_entries"."updated_date", "weblogs_entries"."featured_date", "weblogs_entries"."priority", "weblogs_entries"."display", "weblogs_entries"."related_content_type_id", "weblogs_entries"."related_object_id", "weblogs_entries"."view_count", "weblogs_entries"."comment_status", "weblogs_entries"."trusted_comments_only", "weblogs_entries"."tease_photo_id", "weblogs_entries"."lead_photo_id", "weblogs_entries"."corrections", "weblogs_entries"."correction_date", "weblogs_entries"."alternate_headline" FROM "weblogs_entries" WHERE "weblogs_entries"."id" IN (SELECT "entry_id" FROM "weblogs_entries_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "weblogs_entries"."pub_date" <= NOW() + INTERVAL '1 year' AND "weblogs_entries"."pub_date" BETWEEN 2021-01-20 18:59:12.159088 AND 2021-01-21 18:59:12.159150 ORDER BY "weblogs_entries"."view_count" DESC LIMIT 5 |
0.002 |
| 116 |
./ellington/core/parts/most_x_logic.py:112 |
SELECT "news_stories"."id", "news_stories"."view_count", "news_stories"."slug", "news_stories"."pub_date", "news_stories"."update_date", "news_stories"."deleted", "news_stories"."dateline_id", "news_stories"."headline", "news_stories"."subhead", "news_stories"."tease", "news_stories"."story", "news_stories"."status", "news_stories"."one_off_byline", "news_stories"."tease_photo_id", "news_stories"."post_story_blurb", "news_stories"."lead_photo_id", "news_stories"."lead_photo_has_headline", "news_stories"."comment_status", "news_stories"."trusted_comments_only", "news_stories"."print_pub_date", "news_stories"."print_edition_id", "news_stories"."print_section_id", "news_stories"."print_page", "news_stories"."default_framing_id", "news_stories"."expire_story_on", "news_stories"."alternate_headline", "news_stories"."kicker", "news_stories"."corrections", "news_stories"."correction_date", "news_stories"."paginate" FROM "news_stories" WHERE "news_stories"."id" IN (SELECT "story_id" FROM "news_stories_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "news_stories"."pub_date" <= NOW() + INTERVAL '1 year' AND "news_stories"."deleted" = False AND "news_stories"."pub_date" BETWEEN 2021-01-20 18:59:12.159088 AND 2021-01-21 18:59:12.159150 ORDER BY "news_stories"."view_count" DESC LIMIT 5 |
0.002 |
| 117 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2227581 |
0.001 |
| 118 |
./ellington/taxonomy/slots.py:85 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE "sites"."id" = 15 |
0.000 |
| 119 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2227581 AND hierarchy.slug = 'lvmagazine-taxonomy' |
0.001 |
| 120 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2227574 |
0.000 |
| 121 |
./ellington/taxonomy/slots.py:85 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE "sites"."id" = 15 |
0.000 |
| 122 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2227574 AND hierarchy.slug = 'lvmagazine-taxonomy' |
0.000 |
| 123 |
./ellington/core/parts/most_x_logic.py:131 |
SELECT COUNT(*) AS comment_count, content_type_id, object_id
FROM comments
WHERE submit_date >= '2021-01-20 18:59:12'
AND submit_date <= '2021-01-21 18:59:12'
AND site_id = 1
GROUP BY content_type_id, object_id
ORDER BY comment_count DESC
LIMIT 5; |
0.000 |
| 124 |
./ellington/core/parts/most_x_logic.py:165 |
SELECT content_type_id, object_id, COUNT(*)
FROM mailfriend_maileditems mi, mailfriend_maileditems_sites ms
WHERE mi.id = ms.maileditem_id AND ms.site_id = 1 AND content_type_id = 72 AND when_emailed > 2021-01-07 18:59:12 GROUP BY 1, 2 ORDER BY 3 DESC LIMIT 5 |
0.001 |
| 125 |
./ellington/news/templatetags/sections.py:98 |
SELECT "news_sections"."id", "news_sections"."url", "news_sections"."title", "news_sections"."template_name", "news_sections"."stories_per_page", "news_sections"."order_field1", "news_sections"."order_field2", "news_sections"."order_field3", "news_sections"."blurb", "news_sections"."categories_join_method", "news_sections"."email_edition_id", "news_sections"."email_edition_template", "news_sections"."twitter_name", "news_sections"."aggregate_type", "news_sections"."deleted" FROM "news_sections" WHERE "news_sections"."id" IN (SELECT "section_id" FROM "news_sections_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "news_sections"."deleted" = False AND "news_sections"."url" = apnews |
0.001 |
| 126 |
./ellington/news/models/news.py:659 |
SELECT a."id",a."hierarchy_id",a."parent_id",a."name",a."slug",a."path",a."slug_path",a."creation_date",a."pub_date",a."updated_date",a."deprecated" FROM "categories" a, "news_sections_categories" b WHERE a."id" = b."category_id" AND b."section_id" = 45 ORDER BY "a"."hierarchy_id" ASC, "a"."path" ASC |
0.001 |
| 127 |
./ellington/news/models/news.py:593 |
SELECT "news_sectionrules"."id", "news_sectionrules"."section_id", "news_sectionrules"."field_name", "news_sectionrules"."operator", "news_sectionrules"."parameter" FROM "news_sectionrules" WHERE "news_sectionrules"."section_id" = 45 ORDER BY "news_sectionrules"."field_name" ASC |
0.000 |
| 128 |
./ellington/news/models/news.py:710 |
SELECT s.id, s.pub_date, s.update_date, s.headline,
news_section_priorities.priority
FROM news_stories s
LEFT JOIN news_section_priorities ON
news_section_priorities.story_id=s.id
AND section_id=45
AND news_section_priorities.start_date <= NOW()
AND news_section_priorities.end_date >= NOW(),
news_stories_publication_rights ss,
news_stories_categories sc
WHERE (s.id = ss.story_id AND ss.site_id = 1 AND ss.rights <> 0)
AND s.id = sc.story_id
AND s.pub_date <= NOW() + INTERVAL '1 year' AND s.deleted = false AND sc.category_id IN ( 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213 ) ORDER BY priority DESC NULLS LAST, "s"."pub_date" DESC |
0.314 |
| 129 |
./ellington/news/models/news.py:770 |
SELECT "news_stories"."id", "news_stories"."view_count", "news_stories"."slug", "news_stories"."pub_date", "news_stories"."update_date", "news_stories"."deleted", "news_stories"."dateline_id", "news_stories"."headline", "news_stories"."subhead", "news_stories"."tease", "news_stories"."story", "news_stories"."status", "news_stories"."one_off_byline", "news_stories"."tease_photo_id", "news_stories"."post_story_blurb", "news_stories"."lead_photo_id", "news_stories"."lead_photo_has_headline", "news_stories"."comment_status", "news_stories"."trusted_comments_only", "news_stories"."print_pub_date", "news_stories"."print_edition_id", "news_stories"."print_section_id", "news_stories"."print_page", "news_stories"."default_framing_id", "news_stories"."expire_story_on", "news_stories"."alternate_headline", "news_stories"."kicker", "news_stories"."corrections", "news_stories"."correction_date", "news_stories"."paginate" FROM "news_stories" WHERE "news_stories"."id" IN (2226774,2226773,2226762,2226761,2226472,2226471,2226463,2226462,2226461,2225456) ORDER BY "news_stories"."pub_date" DESC |
0.002 |
| 130 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226774 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.001 |
| 131 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226774 |
0.001 |
| 132 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226774 AND hierarchy.slug = 'lvsun-taxonomy' |
0.001 |
| 133 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226773 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.001 |
| 134 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226773 |
0.000 |
| 135 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226773 AND hierarchy.slug = 'lvsun-taxonomy' |
0.000 |
| 136 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226762 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.001 |
| 137 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226762 |
0.000 |
| 138 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226762 AND hierarchy.slug = 'lvsun-taxonomy' |
0.001 |
| 139 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226761 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.000 |
| 140 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226761 |
0.000 |
| 141 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226761 AND hierarchy.slug = 'lvsun-taxonomy' |
0.000 |
| 142 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226472 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.000 |
| 143 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226472 |
0.000 |
| 144 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226472 AND hierarchy.slug = 'lvsun-taxonomy' |
0.001 |
| 145 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226471 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.000 |
| 146 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226471 |
0.000 |
| 147 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226471 AND hierarchy.slug = 'lvsun-taxonomy' |
0.000 |
| 148 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226463 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.000 |
| 149 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226463 |
0.000 |
| 150 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226463 AND hierarchy.slug = 'lvsun-taxonomy' |
0.001 |
| 151 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226462 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.000 |
| 152 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226462 |
0.000 |
| 153 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226462 AND hierarchy.slug = 'lvsun-taxonomy' |
0.001 |
| 154 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2226461 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.001 |
| 155 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2226461 |
0.000 |
| 156 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2226461 AND hierarchy.slug = 'lvsun-taxonomy' |
0.000 |
| 157 |
./ellington/core/parts/templatetags.py:172 |
SELECT COUNT(*) FROM "comments" JOIN "content_types" AS "t1" ON "comments"."content_type_id" = "t1"."id" WHERE user_id NOT IN (SELECT user_id FROM auth_users_groups WHERE group_id = 11) AND "comments"."object_id" = 2225456 AND "t1"."package" = news AND "t1"."python_module_name" = stories AND "comments"."site_id" = 1 |
0.000 |
| 158 |
./ellington/taxonomy/slots.py:85 |
SELECT "news_stories_publication_rights"."id", "news_stories_publication_rights"."story_id", "news_stories_publication_rights"."site_id", "news_stories_publication_rights"."origin", "news_stories_publication_rights"."rights" FROM "news_stories_publication_rights" WHERE "news_stories_publication_rights"."rights" = 2 AND "news_stories_publication_rights"."story_id" = 2225456 |
0.000 |
| 159 |
./ellington/taxonomy/slots.py:49 |
SELECT slug_path FROM categories JOIN taxonomy_object_taxons AS obj_taxons ON categories.id = obj_taxons.taxon_id JOIN categories_hierarchies AS hierarchy ON categories.hierarchy_id = hierarchy.id WHERE obj_taxons.object_id = 2225456 AND hierarchy.slug = 'lvsun-taxonomy' |
0.000 |
| 160 |
./ellington/collections/templatetags/collections.py:40 |
SELECT "collections_collections"."id", "collections_collections"."slug", "collections_collections"."creation_date", "collections_collections"."last_updated" FROM "collections_collections" WHERE "collections_collections"."slug" = homepage_ae |
0.000 |
| 161 |
./ellington/fragments/templatetags/fragments.py:56 |
SELECT "fragments"."id", "fragments"."label", "fragments"."content", "fragments"."data", "fragments"."last_updated", "fragments"."active" FROM "fragments" WHERE "fragments"."id" IN (SELECT "fragment_id" FROM "fragments_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "fragments"."active" = True AND "fragments"."label" = Scene-On-The-Sun |
0.000 |
| 162 |
./ellington/collections/models/collections.py:76 |
SELECT "collections_items"."content_type_id", "collections_items"."object_id", "collections_items"."id" FROM "collections_items" WHERE "collections_items"."collection_id" = 2257 ORDER BY "collections_items"."_order" ASC |
0.009 |
| 163 |
./ellington/collections/models/collections.py:85 |
SELECT "content_types"."id", "content_types"."name", "content_types"."package", "content_types"."python_module_name" FROM "content_types" WHERE "content_types"."id" IN (37) ORDER BY "content_types"."package" ASC, "content_types"."name" ASC |
0.000 |
| 164 |
./ellington/collections/models/collections.py:90 |
SELECT "photos"."id", "photos"."creation_date", "photos"."pub_date", "photos"."updated_date", "photos"."deleted", "photos"."photographer_id", "photos"."one_off_photographer", "photos"."credit", "photos"."caption", "photos"."photo", "photos"."width", "photos"."height", "photos"."on_cdn", "photos"."photo_type_id", "photos"."reproduction_allowed", "photos"."title", "photos"."slideshow_link", "photos"."file_size" FROM "photos" WHERE "photos"."id" IN (SELECT "photo_id" FROM "photos_publication_rights" WHERE "site_id" = 1 AND rights != 0) AND "photos"."pub_date" <= NOW() + INTERVAL '1 year' AND "photos"."deleted" = False AND "photos"."id" IN (815247,815248,815249) ORDER BY "photos"."pub_date" DESC |
0.001 |
| 165 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 815247 AND origin = TRUE LIMIT 1) |
0.000 |
| 166 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 815248 AND origin = TRUE LIMIT 1) |
0.000 |
| 167 |
./ellington/media/models/media.py:169 |
SELECT "sites"."id", "sites"."domain", "sites"."name", "sites"."settings_module" FROM "sites" WHERE id = (SELECT site_id FROM photos_publication_rights WHERE photo_id = 815249 AND origin = TRUE LIMIT 1) |
0.000 |
Connect with Us