SELECT `django_content_type`.`id`, `django_content_type`.`name`, `django_content_type`.`app_label`,
`django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`model` = photo AND
`django_content_type`.`app_label` = photologue ) ORDER BY `django_content_type`.`name` ASC
took 0.001 seconds
module: tagging.models
file: /var/mediaon/www/tribes/3rdparty/pinax/lib/python2.7/site-packages/tagging/models.py
line: 106
function: _get_usage
'content_type_id': ContentType.objects.get_for_model(model).pk,
SELECT `django_content_type`.`id`, `django_content_type`.`name`, `django_content_type`.`app_label`,
`django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`model` = image AND
`django_content_type`.`app_label` = photos ) ORDER BY `django_content_type`.`name` ASC
took 0.001 seconds
module: tagging.models
file: /var/mediaon/www/tribes/3rdparty/pinax/lib/python2.7/site-packages/tagging/models.py
line: 106
function: _get_usage
'content_type_id': ContentType.objects.get_for_model(model).pk,
SELECT DISTINCT `tagging_tag`.id, `tagging_tag`.name FROM `tagging_tag` INNER
JOIN `tagging_taggeditem` ON `tagging_tag`.id = `tagging_taggeditem`.tag_id INNER JOIN
`photos_image` ON `tagging_taggeditem`.object_id = `photos_image`.`id` WHERE
`tagging_taggeditem`.content_type_id = 105 AND `photos_image`.`safetylevel` = 1 GROUP BY
`tagging_tag`.id, `tagging_tag`.name ORDER BY `tagging_tag`.name ASC
took 0.002 seconds
module: tagging.models
file: /var/mediaon/www/tribes/3rdparty/pinax/lib/python2.7/site-packages/tagging/models.py
line: 115
function: _get_usage
cursor.execute(query % (extra_joins, extra_criteria, min_count_sql), params)
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 801 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 217
function: city_id_home
city = get_object_or_404(City, id = city_id)
SELECT `locals_province`.`id`, `locals_province`.`prov_code`, `locals_province`.`prov_name`,
`locals_province`.`id_nation_id`, `locals_province`.`istatt_code`, `locals_province`.`latitude`,
`locals_province`.`longitude` FROM `locals_province` WHERE `locals_province`.`id` = 13 ORDER BY
`locals_province`.`prov_name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 222
function: city_id_home
provinces = Province.objects.filter(id = city.province.id)
SELECT `django_content_type`.`id`, `django_content_type`.`name`, `django_content_type`.`app_label`,
`django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`model` = announces AND
`django_content_type`.`app_label` = mediaon_announces ) ORDER BY `django_content_type`.`name` ASC
took 0.001 seconds
module: context_processors
file: /var/mediaon/www/tribes/mediaon/announces/webframework/tribes_framework/context_processors.py
line: 112
function: case_in_festa_settings
'ANNOUNCES_CONTENT_TYPE_ID' : ContentType.objects.get(app_label="mediaon_announces",
model="announces").id,
SELECT `mediaon_announces_announces`.`id`, `mediaon_announces_announces`.`category_id`,
`mediaon_announces_announces`.`province_id`, `mediaon_announces_announces`.`city_id`,
`mediaon_announces_announces`.`hamlet_id`, `mediaon_announces_announces`.`address`,
`mediaon_announces_announces`.`sender_id`, `mediaon_announces_announces`.`created`,
`mediaon_announces_announces`.`updated`, `mediaon_announces_announces`.`pub_date`,
`mediaon_announces_announces`.`title`, `mediaon_announces_announces`.`text`, `mediaon_announces_announces`.`is_private`,
`mediaon_announces_announces`.`moderated`, `mediaon_announces_announces`.`is_publishable`,
`mediaon_announces_announces`.`pubblished`, `mediaon_announces_announces`.`deleted`,
`mediaon_announces_announces`.`auto_publish`, `mediaon_announces_announces`.`email`,
`mediaon_announces_announces`.`under_age` FROM `mediaon_announces_announces` INNER JOIN
`mediaon_announces_announces_site` ON (`mediaon_announces_announces`.`id` =
`mediaon_announces_announces_site`.`announces_id`) WHERE (`mediaon_announces_announces`.`deleted` = False AND
`mediaon_announces_announces`.`auto_publish` = False AND `mediaon_announces_announces_site`.`site_id` = 17 AND
`mediaon_announces_announces`.`moderated` = False AND `mediaon_announces_announces`.`pub_date` BETWEEN 2019-02-17 and
2019-06-17 AND `mediaon_announces_announces`.`is_private` = False AND `mediaon_announces_announces`.`city_id` = 801 )
ORDER BY `mediaon_announces_announces`.`pub_date` DESC, `mediaon_announces_announces`.`created` DESC
took 0.005 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `django_content_type`.`id`, `django_content_type`.`name`, `django_content_type`.`app_label`,
`django_content_type`.`model` FROM `django_content_type` WHERE (`django_content_type`.`model` = announces AND
`django_content_type`.`app_label` = mediaon_announces ) ORDER BY `django_content_type`.`name` ASC
took 0.001 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 293
function: get_primary_image
announce_type = ContentType.objects.get_for_model(self)
SELECT `photos_image`.`id`, `photos_image`.`image`, `photos_image`.`date_taken`, `photos_image`.`view_count`,
`photos_image`.`crop_from`, `photos_image`.`effect_id`, `photos_image`.`title`, `photos_image`.`title_slug`,
`photos_image`.`caption`, `photos_image`.`date_added`, `photos_image`.`is_public`, `photos_image`.`member_id`,
`photos_image`.`safetylevel`, `photos_image`.`tags`, `photos_extended_relatedimage`.`image_ptr_id`,
`photos_extended_relatedimage`.`content_type_id`, `photos_extended_relatedimage`.`object_id`,
`photos_extended_relatedimage`.`primary_image`, `photos_extended_relatedimage`.`safe_image`,
`photos_extended_relatedimage`.`deleted`, `photos_extended_relatedimage`.`moderated`,
`photos_extended_relatedimage`.`recipient_user_id`, `photos_extended_relatedimage`.`auto_publish` FROM
`photos_extended_relatedimage` INNER JOIN `photos_image` ON (`photos_extended_relatedimage`.`image_ptr_id` =
`photos_image`.`id`) WHERE (`photos_extended_relatedimage`.`deleted` = False AND `photos_image`.`is_public` = True AND
`photos_extended_relatedimage`.`safe_image` = True AND `photos_extended_relatedimage`.`moderated` = False AND
`photos_extended_relatedimage`.`primary_image` = True AND `photos_extended_relatedimage`.`content_type_id` = 73 AND
`photos_extended_relatedimage`.`object_id` = 135951 ) ORDER BY `photos_image`.`date_added` DESC
took 0.004 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 294
function: get_primary_image
return RelatedImage.valid_objects.get(primary_image = True, content_type = announce_type, object_id =
self.id)
SELECT `photologue_extended_photosize`.`id`, `photologue_extended_photosize`.`name`,
`photologue_extended_photosize`.`width`, `photologue_extended_photosize`.`height`,
`photologue_extended_photosize`.`quality`, `photologue_extended_photosize`.`upscale`,
`photologue_extended_photosize`.`crop`, `photologue_extended_photosize`.`pre_cache`,
`photologue_extended_photosize`.`increment_count`, `photologue_extended_photosize`.`effect_id`,
`photologue_extended_photosize`.`watermark_id` FROM `photologue_extended_photosize` ORDER BY
`photologue_extended_photosize`.`width` ASC, `photologue_extended_photosize`.`height` ASC
took 0.002 seconds
module: photologue_extended.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/photologue_extended/models.py
line: 732
function: __init__
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 801 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `mediaon_announces_category`.`id`, `mediaon_announces_category`.`name`, `mediaon_announces_category`.`slug`,
`mediaon_announces_category`.`is_photo_category`, `mediaon_announces_category`.`is_pro_category`,
`mediaon_announces_category`.`title_class`, `mediaon_announces_category`.`special_div`,
`mediaon_announces_category`.`ordering` FROM `mediaon_announces_category` WHERE `mediaon_announces_category`.`id` = 3
ORDER BY `mediaon_announces_category`.`ordering` DESC, `mediaon_announces_category`.`name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `photos_image`.`id`, `photos_image`.`image`, `photos_image`.`date_taken`, `photos_image`.`view_count`,
`photos_image`.`crop_from`, `photos_image`.`effect_id`, `photos_image`.`title`, `photos_image`.`title_slug`,
`photos_image`.`caption`, `photos_image`.`date_added`, `photos_image`.`is_public`, `photos_image`.`member_id`,
`photos_image`.`safetylevel`, `photos_image`.`tags`, `photos_extended_relatedimage`.`image_ptr_id`,
`photos_extended_relatedimage`.`content_type_id`, `photos_extended_relatedimage`.`object_id`,
`photos_extended_relatedimage`.`primary_image`, `photos_extended_relatedimage`.`safe_image`,
`photos_extended_relatedimage`.`deleted`, `photos_extended_relatedimage`.`moderated`,
`photos_extended_relatedimage`.`recipient_user_id`, `photos_extended_relatedimage`.`auto_publish` FROM
`photos_extended_relatedimage` INNER JOIN `photos_image` ON (`photos_extended_relatedimage`.`image_ptr_id` =
`photos_image`.`id`) WHERE (`photos_extended_relatedimage`.`deleted` = False AND `photos_image`.`is_public` = True AND
`photos_extended_relatedimage`.`safe_image` = True AND `photos_extended_relatedimage`.`moderated` = False AND
`photos_extended_relatedimage`.`primary_image` = True AND `photos_extended_relatedimage`.`content_type_id` = 73 AND
`photos_extended_relatedimage`.`object_id` = 135545 ) ORDER BY `photos_image`.`date_added` DESC
took 0.001 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 294
function: get_primary_image
return RelatedImage.valid_objects.get(primary_image = True, content_type = announce_type, object_id =
self.id)
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 801 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `mediaon_announces_category`.`id`, `mediaon_announces_category`.`name`, `mediaon_announces_category`.`slug`,
`mediaon_announces_category`.`is_photo_category`, `mediaon_announces_category`.`is_pro_category`,
`mediaon_announces_category`.`title_class`, `mediaon_announces_category`.`special_div`,
`mediaon_announces_category`.`ordering` FROM `mediaon_announces_category` WHERE `mediaon_announces_category`.`id` = 3
ORDER BY `mediaon_announces_category`.`ordering` DESC, `mediaon_announces_category`.`name` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `photos_image`.`id`, `photos_image`.`image`, `photos_image`.`date_taken`, `photos_image`.`view_count`,
`photos_image`.`crop_from`, `photos_image`.`effect_id`, `photos_image`.`title`, `photos_image`.`title_slug`,
`photos_image`.`caption`, `photos_image`.`date_added`, `photos_image`.`is_public`, `photos_image`.`member_id`,
`photos_image`.`safetylevel`, `photos_image`.`tags`, `photos_extended_relatedimage`.`image_ptr_id`,
`photos_extended_relatedimage`.`content_type_id`, `photos_extended_relatedimage`.`object_id`,
`photos_extended_relatedimage`.`primary_image`, `photos_extended_relatedimage`.`safe_image`,
`photos_extended_relatedimage`.`deleted`, `photos_extended_relatedimage`.`moderated`,
`photos_extended_relatedimage`.`recipient_user_id`, `photos_extended_relatedimage`.`auto_publish` FROM
`photos_extended_relatedimage` INNER JOIN `photos_image` ON (`photos_extended_relatedimage`.`image_ptr_id` =
`photos_image`.`id`) WHERE (`photos_extended_relatedimage`.`deleted` = False AND `photos_image`.`is_public` = True AND
`photos_extended_relatedimage`.`safe_image` = True AND `photos_extended_relatedimage`.`moderated` = False AND
`photos_extended_relatedimage`.`primary_image` = True AND `photos_extended_relatedimage`.`content_type_id` = 73 AND
`photos_extended_relatedimage`.`object_id` = 135622 ) ORDER BY `photos_image`.`date_added` DESC
took 0.003 seconds
module: mediaon_announces.models
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/models.py
line: 294
function: get_primary_image
return RelatedImage.valid_objects.get(primary_image = True, content_type = announce_type, object_id =
self.id)
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`id` = 801 ORDER BY `locals_city`.`city` ASC
took 0.001 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `mediaon_announces_category`.`id`, `mediaon_announces_category`.`name`, `mediaon_announces_category`.`slug`,
`mediaon_announces_category`.`is_photo_category`, `mediaon_announces_category`.`is_pro_category`,
`mediaon_announces_category`.`title_class`, `mediaon_announces_category`.`special_div`,
`mediaon_announces_category`.`ordering` FROM `mediaon_announces_category` WHERE `mediaon_announces_category`.`id` = 4
ORDER BY `mediaon_announces_category`.`ordering` DESC, `mediaon_announces_category`.`name` ASC
took 0.004 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_province`.`id`, `locals_province`.`prov_code`, `locals_province`.`prov_name`,
`locals_province`.`id_nation_id`, `locals_province`.`istatt_code`, `locals_province`.`latitude`,
`locals_province`.`longitude` FROM `locals_province` WHERE `locals_province`.`id_nation_id` = 1 ORDER BY
`locals_province`.`prov_name` ASC
took 0.004 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`province_id` = 13 ORDER BY `locals_city`.`city` ASC
took 0.017 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_province`.`id`, `locals_province`.`prov_code`, `locals_province`.`prov_name`,
`locals_province`.`id_nation_id`, `locals_province`.`istatt_code`, `locals_province`.`latitude`,
`locals_province`.`longitude` FROM `locals_province` WHERE `locals_province`.`id_nation_id` = 1 ORDER BY
`locals_province`.`prov_name` ASC
took 0.002 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
SELECT `locals_city`.`id`, `locals_city`.`istatt_code`, `locals_city`.`city`, `locals_city`.`family_num`,
`locals_city`.`male_num`, `locals_city`.`female_num`, `locals_city`.`family_total`, `locals_city`.`province_id`,
`locals_city`.`prov_code`, `locals_city`.`prov_name`, `locals_city`.`id_nation_id`, `locals_city`.`internet_site`,
`locals_city`.`email`, `locals_city`.`phone_number`, `locals_city`.`fax_number`, `locals_city`.`logo`,
`locals_city`.`notes`, `locals_city`.`lat`, `locals_city`.`lng`, `locals_city`.`chieftown` FROM `locals_city` WHERE
`locals_city`.`province_id` = 13 ORDER BY `locals_city`.`city` ASC
took 0.015 seconds
module: mediaon_announces.views
file: /var/mediaon/www/tribes/mediaon/_master/webframework/tribes_framework/mediaon_announces/views.py
line: 234
function: city_id_home
}, context_instance=RequestContext(request))
