Автопоезд-скотовоз DAF XF 105, 2012г, вместимость 132м3, общая г/п 31т. продажа, цена, фото, комплектация, характеристики технические. Купить в лизинг, в кредит.

День	Время работы	Перерыв
Понедельник	09:30 — 21:30
Вторник	09:30 — 21:30
Среда	09:30 — 21:30
Четверг	09:30 — 21:30
Пятница	09:30 — 21:30
Суббота	10:30 — 17:30
Воскресенье	Выходной

День	Время работы	Перерыв
Понедельник	09:30 — 21:30
Вторник	09:30 — 21:30
Среда	09:30 — 21:30
Четверг	09:30 — 21:30
Пятница	09:30 — 21:30
Суббота	10:30 — 17:30
Воскресенье	Выходной

CPU: 208.0ms TOTAL: 271.1ms SQL: 21 (45.4ms) SOLR: 1 (2.8ms) REDIS: 2 (0.4ms) MEMCACHED: 15 (5.0ms)

✖ close


memcached get	0.27ms
memcached get	0.25ms
redis GET	0.19ms
sql query	15.25ms
memcached get	0.24ms
memcached get	0.27ms
memcached get	0.24ms
memcached get	1.0ms
memcached get	0.23ms
memcached get	0.36ms
sql query	3.98ms
sql query	4.08ms
sql query	10.43ms
sql query	11.88ms
redis GET	0.24ms
sql query	3.91ms
sql query	4.55ms
solr select	2.76ms
sql query	5.77ms
memcached get	0.6ms
sql query	4.24ms
sql query	4.58ms
sql query	4.24ms
sql query	5.6ms
mako start
sql query	3.74ms
sql query	5.85ms
sql query	3.43ms
sql query	3.41ms
memcached get	0.35ms
sql query	3.41ms
sql query	2.62ms
sql query	3.68ms
memcached get	0.23ms
memcached get	0.27ms
memcached get	0.33ms
memcached get	0.15ms
memcached get	0.21ms
sql query	16.48ms
sql query	3.52ms
mako end

TIME: 2.66ms

SELECT company.id AS company_id, company.address_id AS company_address_id, company.address_country_id AS company_address_country_id, company.address_region_id AS company_address_region_id, company.address_region_text AS company_address_region_text, company.address_city AS company_address_city, company.address_street AS company_address_street, company.address_zip_code AS company_address_zip_code, company.show_on_map_data AS company_show_on_map_data, company.name AS company_name, company.legal_name AS company_legal_name, company.fax AS company_fax, company.phone AS company_phone, company.phones AS company_phones, company.phones_info AS company_phones_info, company.location_description AS company_location_description, company.location_image_id AS company_location_image_id, company.address_type AS company_address_type, company.email_contact_now_mode AS company_email_contact_now_mode, company.email_receive_site_news AS company_email_receive_site_news, company.email_not_actual_products AS company_email_not_actual_products, company.status AS company_status, company.rank AS company_rank, company.content_quality AS company_content_quality, company.status_quality AS company_status_quality, company.editing_required_reason AS company_editing_required_reason, company.num_products_on_display AS company_num_products_on_display, company.num_tenders_on_display AS company_num_tenders_on_display, company.is_registered_as_fake AS company_is_registered_as_fake, company.is_first_steps_mail_sent AS company_is_first_steps_mail_sent, company.date_created AS company_date_created, company.date_modified AS company_date_modified, company.date_launched AS company_date_launched, company.date_blocked AS company_date_blocked, company.site_settings AS company_site_settings, company.html_site_main_text AS company_html_site_main_text, company.hidden_cabinet_dashboard_blocks AS company_hidden_cabinet_dashboard_blocks, company.schedule AS company_schedule, company.verification_status AS company_verification_status, company.refferer_id AS company_refferer_id, company.promotion_id AS company_promotion_id, company.promoted_by_link AS company_promoted_by_link, company.enabled_epayment AS company_enabled_epayment, company.source_id AS company_source_id, company.owner_id AS company_owner_id, company.business_types AS company_business_types, company.total_employees_id AS company_total_employees_id, company.main_logo_id AS company_main_logo_id, company.favicon_id AS company_favicon_id, company.brands AS company_brands, company.application_ids AS company_application_ids, company.num_products_variations AS company_num_products_variations, company.html_detailed_introduction AS company_html_detailed_introduction, company.detected_as_spam AS company_detected_as_spam, company.web_site_url AS company_web_site_url, company.sub_domain AS company_sub_domain, company.ext_domain AS company_ext_domain, company.domain AS company_domain, company.all_domains AS company_all_domains, company.tax_code AS company_tax_code, company.oc_year_esteblished AS company_oc_year_esteblished, company.oc_registered_capital_id AS company_oc_registered_capital_id, company.oc_ownership_type_id AS company_oc_ownership_type_id, company.tm_main_customers AS company_tm_main_customers, company.tm_total_anual_sales_volume_id AS company_tm_total_anual_sales_volume_id, company.tm_total_annual_purchase_volume_id AS company_tm_total_annual_purchase_volume_id, company.fi_factory_size_id AS company_fi_factory_size_id, company.fi_factory_location AS company_fi_factory_location, company.fi_qa_qc_id AS company_fi_qa_qc_id, company.fi_product_lines_id AS company_fi_product_lines_id, company.fi_management_certifications AS company_fi_management_certifications, company.contact_person AS company_contact_person, company.ref_company_id AS company_ref_company_id, company.google_tracker AS company_google_tracker, company.billing_info AS company_billing_info, company.rating AS company_rating, company.opinion_count AS company_opinion_count, company.premium_service_id AS company_premium_service_id, company.market_flag_activated AS company_market_flag_activated, company.cpl_market_flag_activated AS company_cpl_market_flag_activated, company.crm_rank AS company_crm_rank, company.crm_rank_coeff AS company_crm_rank_coeff, company.context_rank AS company_context_rank, company.service_context_rank AS company_service_context_rank, company.product_average_rank AS company_product_average_rank, company.categories_context_rank AS company_categories_context_rank, company.site_google_translate AS company_site_google_translate, company.webpromo AS company_webpromo, company.contact_settings AS company_contact_settings, company.payment_details AS company_payment_details, company.delivery_regions AS company_delivery_regions, company.priority_delivery_regions AS company_priority_delivery_regions, company.shop_settings AS company_shop_settings, company.qos_since AS company_qos_since, company.loyalty_since AS company_loyalty_since, company.currency_settings AS company_currency_settings, company.test_package_changed_duration AS company_test_package_changed_duration, company.auto_moderation_type AS company_auto_moderation_type, company.branch_regions AS company_branch_regions, address_1.id AS address_1_id, address_1.country_id AS address_1_country_id, address_1.region_id AS address_1_region_id, address_1.image_id AS address_1_image_id, address_1.region_text AS address_1_region_text, address_1.city AS address_1_city, address_1.street AS address_1_street, address_1.zip_code AS address_1_zip_code, address_1.description AS address_1_description, address_1.show_on_map_data AS address_1_show_on_map_data, company_design_settings_1.id AS company_design_settings_1_id, company_design_settings_1.company_id AS company_design_settings_1_company_id, company_design_settings_1.current_design_template_id AS company_design_settings_1_current_design_template_id, company_design_settings_1.mobile_design_template_id AS company_design_settings_1_mobile_design_template_id, company_design_settings_1.wishful_design_template_id AS company_design_settings_1_wishful_design_template_id, company_design_settings_1.last_design_template_id AS company_design_settings_1_last_design_template_id 
FROM company LEFT OUTER JOIN address AS address_1 ON company.address_id = address_1.id LEFT OUTER JOIN company_design_settings AS company_design_settings_1 ON company_design_settings_1.company_id = company.id 
WHERE company.id = 1088132 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 217, in __call__
    response = self._inspect_call(self.__before__)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 377, in __before__
    c.company = self.__get_company(company_id)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 359, in __get_company
    .get(company_id)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 774, in get
    return self._load_on_ident(key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2461, in _load_on_ident
    return q.one()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2133, in one
    ret = list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 1.60ms

SELECT product_price.id AS product_price_id, product_price.product_id AS product_price_product_id, product_price.price AS product_price_price, product_price.minimum_order_quantity AS product_price_minimum_order_quantity 
FROM product_price 
WHERE product_price.product_id = '33154429' ORDER BY minimum_order_quantity /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1050, in product_view
    c.product = get_product_for_productview(product_id, c.company)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/products.py", line 496, in get_product_for_productview
    get_construct_for_product_view(product_id)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/products.py", line 315, in get_construct_for_product_view
    .order_by('minimum_order_quantity')

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 1.40ms

SELECT product_spec_link.id AS product_spec_link_id, product_spec_link.position AS product_spec_link_position, product_spec_link.product_id AS product_spec_link_product_id, product_spec_link.spec_id AS product_spec_link_spec_id, file_1.id AS file_1_id, file_1.status AS file_1_status, file_1.company_id AS file_1_company_id, file_1.file_name AS file_1_file_name, file_1.store_type AS file_1_store_type, file_1.size AS file_1_size, file_1.original_hash AS file_1_original_hash, file_1.date_created AS file_1_date_created 
FROM product_spec_link LEFT OUTER JOIN file AS file_1 ON product_spec_link.spec_id = file_1.id 
WHERE product_spec_link.product_id = '33154429' ORDER BY product_spec_link.id /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1050, in product_view
    c.product = get_product_for_productview(product_id, c.company)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/products.py", line 496, in get_product_for_productview
    get_construct_for_product_view(product_id)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/products.py", line 322, in get_construct_for_product_view
    .filter_by(product_id=product_id)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 5.48ms

SELECT image.id AS image_id, model_image.id AS model_image_id, product.variation_base_id AS product_variation_base_id, product.is_outdated AS product_is_outdated, product.type AS product_type, product_category.caption AS product_category_caption, product.selling_type AS product_selling_type, product.seo_settings AS product_seo_settings, product.packaging AS product_packaging, product_discount.product_id AS product_discount_product_id, product.presence AS product_presence, product_discount.date_start AS product_discount_date_start, product_discount.date_end AS product_discount_date_end, product_discount.active AS product_discount_active, image.file_name AS image_file_name, image.store_type AS image_store_type, image.profile AS image_profile, model_image.file_name AS model_image_file_name, model_image.store_type AS model_image_store_type, model_image.profile AS model_image_profile, product.keywords AS product_keywords, product.sku AS product_sku, product.price_currency_id AS product_price_currency_id, product.name AS product_name, product.price AS product_price, product.attributes_map AS product_attributes_map, product_model.attributes_map AS product_model_attributes_map, product.tags AS product_tags, product.is_price_from AS product_is_price_from, product.company_id AS product_company_id, product.label AS product_label, product.actual_presence AS product_actual_presence, product.status AS product_status, product.minimum_order_quantity AS product_minimum_order_quantity, product.measure_unit_id AS product_measure_unit_id, product.model_id AS product_model_id, product.html_long_description AS product_html_long_description, product_model.description AS product_model_description, product.attributes_text AS product_attributes_text, product_model.attributes_text AS product_model_attributes_text, product.attributes_custom AS product_attributes_custom, product_model.attributes_custom AS product_model_attributes_custom, product_discount.type AS product_discount_type, product_discount.percent AS product_discount_percent, product_discount.amount AS product_discount_amount, product.supply_ability_quantity AS product_supply_ability_quantity, product.supply_ability_time_unit_id AS product_supply_ability_time_unit_id, product.delivery_options AS product_delivery_options, product.seo_links AS product_seo_links, product.gifts AS product_gifts, product.supply_period AS product_supply_period, product.group_id AS product_group_id, product.date_modified AS product_date_modified, product.id AS product_id, product.variation_count AS product_variation_count, product.date_created AS product_date_created, product.category_id AS product_category_id 
FROM product LEFT OUTER JOIN image ON product.main_image_id = image.id LEFT OUTER JOIN product_discount ON product_discount.product_id = product.id LEFT OUTER JOIN product_model ON product.model_id = product_model.id LEFT OUTER JOIN image AS model_image ON product_model.main_image_id = model_image.id JOIN product_category ON product.category_id = product_category.id JOIN product_group ON product.group_id = product_group.id 
WHERE product.status = 0 AND product.company_id = 1088132 AND product.id = '33154429' 
 LIMIT 1 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1050, in product_view
    c.product = get_product_for_productview(product_id, c.company)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/products.py", line 498, in get_product_for_productview
    Product.id == product_id)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2107, in first
    ret = list(self[0:1])

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2001, in __getitem__
    return list(res)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 6.44ms

SELECT product_image_link.id AS product_image_link_id, product_image_link.position AS product_image_link_position, product_image_link.product_id AS product_image_link_product_id, product_image_link.image_id AS product_image_link_image_id, image_1.id AS image_1_id, image_1.status AS image_1_status, image_1.company_id AS image_1_company_id, image_1.file_name AS image_1_file_name, image_1.store_type AS image_1_store_type, image_1.size AS image_1_size, image_1.original_hash AS image_1_original_hash, image_1.date_created AS image_1_date_created, image_1.profile AS image_1_profile, image_1.watermark_text AS image_1_watermark_text, image_1.sizes AS image_1_sizes, image_1.perceptual_hash AS image_1_perceptual_hash 
FROM product_image_link LEFT OUTER JOIN image AS image_1 ON product_image_link.image_id = image_1.id 
WHERE product_image_link.product_id IN (33154429) ORDER BY product_image_link.id /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1050, in product_view
    c.product = get_product_for_productview(product_id, c.company)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/products.py", line 505, in get_product_for_productview
    with_image_links=True)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/products.py", line 169, in postprocess_products
    ProductImageLink.product_id.in_(product_ids))).all()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.69ms

SELECT product_group.id AS product_group_id, product_group.s_external_id AS product_group_s_external_id, product_group.type AS product_group_type, product_group.selling_type AS product_group_selling_type, product_group.name AS product_group_name, product_group.description AS product_group_description, product_group.company_id AS product_group_company_id, product_group.parent_group_id AS product_group_parent_group_id, product_group.num_products_on_display AS product_group_num_products_on_display, product_group.weight AS product_group_weight, product_group.date_created AS product_group_date_created, product_group.date_modified AS product_group_date_modified, product_group.position AS product_group_position, product_group.image_id AS product_group_image_id, product_group.email AS product_group_email, product_group.send_to_branch AS product_group_send_to_branch, product_group.seo_settings AS product_group_seo_settings, product_group.custom_order_id AS product_group_custom_order_id, product_group.preferred_category_ids AS product_group_preferred_category_ids 
FROM product_group 
WHERE product_group.id = 3135366 ORDER BY product_group.position 
 LIMIT 1 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1063, in product_view
    c.group = ProductGroup.get_or_abort(c.product.group_id)

  File "/opt/workspace/ruprom-svn/uaprom/model/base.py", line 53, in get_or_abort
    obj = query.first()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2107, in first
    ret = list(self[0:1])

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2001, in __getitem__
    return list(res)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.69ms

SELECT product_category.id AS product_category_id, product_category.code AS product_category_code, product_category.caption AS product_category_caption, product_category.alt_caption AS product_category_alt_caption, product_category.normalized_caption AS product_category_normalized_caption, product_category.model_caption AS product_category_model_caption, product_category.date_created AS product_category_date_created, product_category.is_other AS product_category_is_other, product_category.is_paid_category AS product_category_is_paid_category, product_category.main_parent_category_id AS product_category_main_parent_category_id, product_category.group_id AS product_category_group_id, product_category.alias AS product_category_alias, product_category.types AS product_category_types, product_category.main_type AS product_category_main_type, product_category.image_id AS product_category_image_id, product_category.status AS product_category_status, product_category.min_price AS product_category_min_price, product_category.num_products_on_display AS product_category_num_products_on_display, product_category.default_view AS product_category_default_view, product_category.context_rank AS product_category_context_rank, product_category.is_prohibited AS product_category_is_prohibited, product_category.multiplier_b2b AS product_category_multiplier_b2b, product_category.multiplier_b2b_r AS product_category_multiplier_b2b_r, product_category.multiplier_b2c AS product_category_multiplier_b2c, product_category.multiplier_b2c_r AS product_category_multiplier_b2c_r, product_category.multiplier_services AS product_category_multiplier_services 
FROM product_category 
WHERE product_category.id = 340112 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1065, in product_view
    c.category = ProductCategory.get(c.product.category_id)

  File "/usr/local/lib/python2.7/dist-packages/Elixir-0.7.1-py2.7.egg/elixir/entity.py", line 1144, in get
    return cls.query.get(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 774, in get
    return self._load_on_ident(key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2461, in _load_on_ident
    return q.one()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2133, in one
    ret = list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 1.45ms

SELECT attribute_value.id AS attribute_value_id, attribute_value.value AS attribute_value_value, attribute_value.value_slug AS attribute_value_value_slug, attribute_value.alias AS attribute_value_alias, attribute_value.attribute_id AS attribute_value_attribute_id, attribute_value.substitution_id AS attribute_value_substitution_id, attribute_value.position AS attribute_value_position, attribute_value.user_id AS attribute_value_user_id, attribute_value.date_created AS attribute_value_date_created, attribute_value.status AS attribute_value_status, attribute_value.help AS attribute_value_help, attribute_value.is_artificial AS attribute_value_is_artificial, attribute_value.image_id AS attribute_value_image_id, image_1.id AS image_1_id, image_1.status AS image_1_status, image_1.company_id AS image_1_company_id, image_1.file_name AS image_1_file_name, image_1.store_type AS image_1_store_type, image_1.size AS image_1_size, image_1.original_hash AS image_1_original_hash, image_1.date_created AS image_1_date_created, image_1.profile AS image_1_profile, image_1.watermark_text AS image_1_watermark_text, image_1.sizes AS image_1_sizes, image_1.perceptual_hash AS image_1_perceptual_hash 
FROM attribute_value JOIN attribute ON attribute_value.attribute_id = attribute.id LEFT OUTER JOIN image AS image_1 ON attribute_value.image_id = image_1.id 
WHERE attribute_value.id IN (10646, 11182, 12750, 29347) AND attribute_value.status = 'a' AND attribute.status = 'active' /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1073, in product_view
    c.company, c.group, request.GET.copy())

  File "/opt/workspace/ruprom-svn/uaprom/site/lib/query.py", line 290, in get_manufacturers
    AttributeBinding.get_manufacturer_solr_field_name()).all_values)

  File "/opt/workspace/ruprom-svn/uaprom/site/lib/query.py", line 267, in fv_to_manufacturers
    return filter(bool, map(mapper, fv_list))

  File "/opt/workspace/ruprom-svn/uaprom/site/lib/query.py", line 255, in mapper
    if fv.instance:

  File "/opt/workspace/ruprom-svn/solar/queryfilter.py", line 364, in instance
    return self.facet_value.instance

  File "/opt/workspace/ruprom-svn/solar/facets.py", line 94, in instance
    self.facet._populate_instances()

  File "/opt/workspace/ruprom-svn/solar/facets.py", line 74, in _populate_instances
    instances = self.instance_mapper([v.value for v in values])

  File "/opt/workspace/ruprom-svn/uaprom/lib/searchers/filters.py", line 101, in binding_mapper
    return {x.id: x for x in query}

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 1.08ms

SELECT product.id AS product_id, product.name AS product_name, image.id AS image_id, image.file_name AS image_file_name, image.store_type AS image_store_type, image.profile AS image_profile 
FROM product LEFT OUTER JOIN image ON product.main_image_id = image.id 
WHERE product.type = 'B' AND product.status = 0 AND product.company_id = 1088132 AND product.group_id = 3135366 AND product.id > 33154429 ORDER BY product.id 
 LIMIT 10 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1086, in product_view
    product_accessories) = get_related_products(c.product, c.company)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 317, in get_related_products
    company_related_products = get_company_related_products_info(product)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 248, in get_company_related_products_info
    related_products = query.filter(Product.id > product.id).limit(10).all()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.96ms

SELECT product.id AS product_id, product.name AS product_name, image.id AS image_id, image.file_name AS image_file_name, image.store_type AS image_store_type, image.profile AS image_profile 
FROM product LEFT OUTER JOIN image ON product.main_image_id = image.id 
WHERE product.type = 'B' AND product.status = 0 AND product.company_id = 1088132 AND product.group_id = 3135366 AND product.id < 33154429 ORDER BY product.id 
 LIMIT 8 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1086, in product_view
    product_accessories) = get_related_products(c.product, c.company)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 317, in get_related_products
    company_related_products = get_company_related_products_info(product)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 253, in get_company_related_products_info
    Product.id < product.id).limit(remaining))

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 1.77ms

SELECT product.id AS product_id, product.name AS product_name, image.id AS image_id, image.file_name AS image_file_name, image.store_type AS image_store_type, image.profile AS image_profile 
FROM product LEFT OUTER JOIN image ON product.main_image_id = image.id 
WHERE product.status = 0 AND (EXISTS (SELECT * 
FROM product_accessories 
WHERE product_accessories.accessory_id = product.id AND product_accessories.product_id = 33154429)) 
 LIMIT 10 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1086, in product_view
    product_accessories) = get_related_products(c.product, c.company)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 328, in get_related_products
    get_product_accessories_info(product)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 271, in get_product_accessories_info
    .limit(limit)

  File "/opt/workspace/ruprom-svn/uaprom/lib/construct.py", line 477, in from_query
    return list(self._from_row(row) for row in query)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 2.45ms

SELECT portfolio_job.confirm_status AS portfolio_job_confirm_status, image.id AS image_id, image.file_name AS image_file_name, image.store_type AS image_store_type, image.profile AS image_profile, portfolio_job.title AS portfolio_job_title, portfolio_job.id AS portfolio_job_id, opinion.date_created AS opinion_date_created, opinion.rating AS opinion_rating, (SELECT count(portfolio_job_photo.id) AS count_1 
FROM portfolio_job_photo 
WHERE portfolio_job_photo.portfolio_job_id = portfolio_job.id) AS anon_1 
FROM portfolio_job LEFT OUTER JOIN image ON portfolio_job.image_id = image.id LEFT OUTER JOIN opinion ON opinion.date_created = (SELECT opinion.date_created AS opinion_date_created 
FROM opinion 
WHERE opinion.linked_portfolio_job_id = portfolio_job.id AND opinion.status != 2 AND opinion.blocked_by_company = false AND opinion.company_id = 1088132 ORDER BY opinion.date_created DESC 
 LIMIT 1) LEFT OUTER JOIN portfolio_job_product ON portfolio_job.id = portfolio_job_product.portfolio_job_id 
WHERE portfolio_job.company_id = 1088132 AND portfolio_job.status = 0 AND portfolio_job_product.product_id = '33154429' ORDER BY position 
 LIMIT 2 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1098, in product_view
    .limit(2)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.59ms

WITH RECURSIVE group_t(custom_order_id, _id, _parent_group_id) AS 
(SELECT product_group.custom_order_id AS custom_order_id, product_group.id AS _id, product_group.parent_group_id AS _parent_group_id 
FROM product_group 
WHERE product_group.id = 3135366 UNION SELECT product_group.custom_order_id AS product_group_custom_order_id, product_group.id AS _id, product_group.parent_group_id AS _parent_group_id 
FROM product_group, group_t AS group_t 
WHERE group_t._parent_group_id = product_group.id)
 SELECT group_t.custom_order_id AS group_t_custom_order_id 
FROM group_t 
WHERE group_t.custom_order_id IS NOT NULL 
 LIMIT 1 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 146, in render_body
    page_content = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout.mako.py", line 59, in render_body
    __M_writer(next.body() )

  File "/opt/workspace/ruprom/data/templates/member/product/product_base.mako.py", line 38, in render_body
    __M_writer(escape(next.body()))

  File "/opt/workspace/ruprom/data/templates/member/product/product_view.mako.py", line 113, in render_body
    variations_dump, c.category, region_related_products)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 2708, in render_product_view_on_company_site
    __M_writer(escape(self.product_view_details('company_site-product_view', company, group, product, variations_dump, category)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 525, in render_product_view_details
    __M_writer(escape(self.product_main_info(page_place, company, group, product, category, variations_dump)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 1801, in render_product_main_info
    __M_writer(escape(bco.custom_order_button(company, group, product)))

  File "/opt/workspace/ruprom-svn/uaprom/lib/pml/blocks.py", line 36, in __call__
    iter_context = [self.call(*args, **kwargs)]

  File "/opt/workspace/ruprom-svn/uaprom/lib/blocks.py", line 23, in call
    return self._func(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d2/custom_order.py", line 26, in custom_order_button
    ProductGroup.custom_order_id != None,

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2107, in first
    ret = list(self[0:1])

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2001, in __getitem__
    return list(res)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.94ms

SELECT "user".id AS user_id, "user".first_name AS user_first_name, "user".last_name AS user_last_name, "user".middle_name AS user_middle_name, "user".email AS user_email, "user".photo_id AS user_photo_id, "user".address_country_id AS user_address_country_id, "user".address_region_id AS user_address_region_id, "user".address_region_text AS user_address_region_text, "user".address_city AS user_address_city, "user".address_street AS user_address_street, "user".address_zip_code AS user_address_zip_code, "user".show_on_map_data AS user_show_on_map_data, "user".phone AS user_phone, "user".phones AS user_phones, "user".fax AS user_fax, "user".gender_id AS user_gender_id, "user".birthday AS user_birthday, "user".company_id AS user_company_id, "user".ref_user_id AS user_ref_user_id, "user".job_title AS user_job_title, "user".group_id AS user_group_id, "user".source_id AS user_source_id, "user".path_id AS user_path_id, "user".status AS user_status, "user".last_login AS user_last_login, "user".num_logins AS user_num_logins, "user".trade_alert_delivery_frequency_id AS user_trade_alert_delivery_frequency_id, "user".email_status AS user_email_status, "user".agency_manager_rate_id AS user_agency_manager_rate_id, "user".agency_manager_settings AS user_agency_manager_settings, "user".date_created AS user_date_created, "user".app_settings AS user_app_settings, "user".pwd_hash AS user_pwd_hash, "user".unsubscribed AS user_unsubscribed, "user".date_modified AS user_date_modified, "user".verified_phone AS user_verified_phone, "user".customer_type AS user_customer_type, "user".timezone AS user_timezone, "user".phones_info AS user_phones_info, "user".roles AS user_roles, "user".settings AS user_settings 
FROM "user" 
WHERE "user".id = 1092846 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 146, in render_body
    page_content = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout.mako.py", line 59, in render_body
    __M_writer(next.body() )

  File "/opt/workspace/ruprom/data/templates/member/product/product_base.mako.py", line 38, in render_body
    __M_writer(escape(next.body()))

  File "/opt/workspace/ruprom/data/templates/member/product/product_view.mako.py", line 113, in render_body
    variations_dump, c.category, region_related_products)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 2708, in render_product_view_on_company_site
    __M_writer(escape(self.product_view_details('company_site-product_view', company, group, product, variations_dump, category)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 525, in render_product_view_details
    __M_writer(escape(self.product_main_info(page_place, company, group, product, category, variations_dump)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 1837, in render_product_main_info
    company_info = h.get_company_info(company)

  File "/opt/workspace/ruprom-svn/uaprom/lib/helpers/helpers_company_info.py", line 472, in get_company_info
    email = company.get_contact_email()

  File "/opt/workspace/ruprom-svn/uaprom/model/company.py", line 1425, in get_contact_email
    return self.extra_contacts.get("email", self.owner.email)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 168, in __get__
    return self.impl.get(instance_state(instance),dict_)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 453, in get
    value = self.callable_(state, passive)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 552, in _emit_lazyload
    return q._load_on_ident(ident_key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2461, in _load_on_ident
    return q.one()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2133, in one
    ret = list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.69ms

SELECT product_group_manager_contact_product_group_link.product_group_manager_contact_id AS product_group_manager_contact_product_group_link_product__1, product_group_manager_contact_product_group_link.product_group_id AS product_group_manager_contact_product_group_link_product__2 
FROM product_group_manager_contact_product_group_link 
WHERE product_group_manager_contact_product_group_link.product_group_id = 3135366 ORDER BY product_group_manager_contact_product_group_link.product_group_id /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 146, in render_body
    page_content = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout.mako.py", line 59, in render_body
    __M_writer(next.body() )

  File "/opt/workspace/ruprom/data/templates/member/product/product_base.mako.py", line 38, in render_body
    __M_writer(escape(next.body()))

  File "/opt/workspace/ruprom/data/templates/member/product/product_view.mako.py", line 113, in render_body
    variations_dump, c.category, region_related_products)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 2708, in render_product_view_on_company_site
    __M_writer(escape(self.product_view_details('company_site-product_view', company, group, product, variations_dump, category)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 525, in render_product_view_details
    __M_writer(escape(self.product_main_info(page_place, company, group, product, category, variations_dump)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 1852, in render_product_main_info
    product_group_phones_dict=h.bl.product.get_phones_dict(company, c.group)

  File "/opt/workspace/ruprom-svn/uaprom/lib/bl/bl_product.py", line 1904, in get_phones_dict
    else _get_sorted_product_group_managers_with_phones(group)

  File "/opt/workspace/ruprom-svn/uaprom/lib/bl/bl_product.py", line 1890, in _get_sorted_product_group_managers_with_phones
    link.managers for link in product_group.managers

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 168, in __get__
    return self.impl.get(instance_state(instance),dict_)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 453, in get
    value = self.callable_(state, passive)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 574, in _emit_lazyload
    result = q.all()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.75ms

SELECT premium_service.id AS premium_service_id, premium_service.name AS premium_service_name, premium_service.status AS premium_service_status, premium_service.service_type AS premium_service_service_type, premium_service.is_enabled_for_promotion AS premium_service_is_enabled_for_promotion 
FROM premium_service 
WHERE premium_service.id = 7 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 146, in render_body
    page_content = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout.mako.py", line 59, in render_body
    __M_writer(next.body() )

  File "/opt/workspace/ruprom/data/templates/member/product/product_base.mako.py", line 38, in render_body
    __M_writer(escape(next.body()))

  File "/opt/workspace/ruprom/data/templates/member/product/product_view.mako.py", line 113, in render_body
    variations_dump, c.category, region_related_products)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 2708, in render_product_view_on_company_site
    __M_writer(escape(self.product_view_details('company_site-product_view', company, group, product, variations_dump, category)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 525, in render_product_view_details
    __M_writer(escape(self.product_main_info(page_place, company, group, product, category, variations_dump)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 1866, in render_product_main_info
    if variations_dump and company.products_variations.premium_service and company.products_variations.limit:

  File "/opt/workspace/ruprom-svn/uaprom/model/company.py", line 681, in products_variations
    return CompanyProductVariation(self)

  File "/opt/workspace/ruprom-svn/uaprom/lib/bl/product_variation.py", line 29, in __init__
    self.premium_service = company.premium_service

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 168, in __get__
    return self.impl.get(instance_state(instance),dict_)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 453, in get
    value = self.callable_(state, passive)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 552, in _emit_lazyload
    return q._load_on_ident(ident_key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2461, in _load_on_ident
    return q.one()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2133, in one
    ret = list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.75ms

SELECT product_opinion.published_without_rating AS product_opinion_published_without_rating, product_opinion.product_id AS product_opinion_product_id, product_opinion.rating AS product_opinion_rating, product_opinion.hide_author_name AS product_opinion_hide_author_name, product_opinion.bounded_to_company AS product_opinion_bounded_to_company, product_opinion.comment_main AS product_opinion_comment_main, product_opinion.author_name AS product_opinion_author_name, product_opinion.source_type AS product_opinion_source_type, product_opinion.voted_rating AS product_opinion_voted_rating, product_opinion.negative_votes AS product_opinion_negative_votes, product_opinion.comment_positive AS product_opinion_comment_positive, product_opinion.date_created AS product_opinion_date_created, product_opinion.comment_negative AS product_opinion_comment_negative, product_opinion.id AS product_opinion_id, product_opinion.positive_votes AS product_opinion_positive_votes 
FROM product_opinion 
WHERE product_opinion.product_id = 33154429 AND product_opinion.status = 1 AND product_opinion.bounded_to_company = true AND product_opinion.country_code = 'ru' ORDER BY product_opinion.date_created DESC /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 146, in render_body
    page_content = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout.mako.py", line 59, in render_body
    __M_writer(next.body() )

  File "/opt/workspace/ruprom/data/templates/member/product/product_base.mako.py", line 38, in render_body
    __M_writer(escape(next.body()))

  File "/opt/workspace/ruprom/data/templates/member/product/product_view.mako.py", line 113, in render_body
    variations_dump, c.category, region_related_products)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 2708, in render_product_view_on_company_site
    __M_writer(escape(self.product_view_details('company_site-product_view', company, group, product, variations_dump, category)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 716, in render_product_view_details
    __M_writer(escape(bo.product_comments_default_view(product, company)))

  File "/opt/workspace/ruprom-svn/uaprom/lib/pml/blocks.py", line 36, in __call__
    iter_context = [self.call(*args, **kwargs)]

  File "/opt/workspace/ruprom-svn/uaprom/lib/blocks.py", line 23, in call
    return self._func(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d2/opinions.py", line 357, in product_comments_data
    .order_by(ProductOpinion.date_created.desc())

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.55ms

SELECT product_opinion.rating AS product_opinion_rating, count(product_opinion.rating) AS count 
FROM product_opinion 
WHERE product_opinion.status = 1 AND product_opinion.product_id = 33154429 AND product_opinion.bounded_to_company = true GROUP BY product_opinion.rating ORDER BY product_opinion.rating DESC /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 146, in render_body
    page_content = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout.mako.py", line 59, in render_body
    __M_writer(next.body() )

  File "/opt/workspace/ruprom/data/templates/member/product/product_base.mako.py", line 38, in render_body
    __M_writer(escape(next.body()))

  File "/opt/workspace/ruprom/data/templates/member/product/product_view.mako.py", line 113, in render_body
    variations_dump, c.category, region_related_products)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 2708, in render_product_view_on_company_site
    __M_writer(escape(self.product_view_details('company_site-product_view', company, group, product, variations_dump, category)))

  File "/opt/workspace/ruprom/data/templates/portlets_member.mako.py", line 716, in render_product_view_details
    __M_writer(escape(bo.product_comments_default_view(product, company)))

  File "/opt/workspace/ruprom-svn/uaprom/lib/pml/blocks.py", line 36, in __call__
    iter_context = [self.call(*args, **kwargs)]

  File "/opt/workspace/ruprom-svn/uaprom/lib/blocks.py", line 23, in call
    return self._func(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d2/opinions.py", line 359, in product_comments_data
    comments_data = get_opinions_ratings_data(product_id=product.id)

  File "/opt/workspace/ruprom-svn/uaprom/lib/helpers/helpers_product_opinion.py", line 246, in get_opinions_ratings_data
    opinions_ratings = get_opinions_ratings(model_id, product_id)

  File "/opt/workspace/ruprom-svn/uaprom/lib/helpers/helpers_product_opinion.py", line 235, in get_opinions_ratings
    .order_by(ProductOpinion.rating.desc())

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2066, in all
    return list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.56ms

SELECT image.id AS image_id, image.status AS image_status, image.company_id AS image_company_id, image.file_name AS image_file_name, image.store_type AS image_store_type, image.size AS image_size, image.original_hash AS image_original_hash, image.date_created AS image_date_created, image.profile AS image_profile, image.watermark_text AS image_watermark_text, image.sizes AS image_sizes, image.perceptual_hash AS image_perceptual_hash 
FROM image 
WHERE image.id = 40338705 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 147, in render_body
    page_content_with_navigation = capture(design_customizable_site_area, page_content)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 74, in design_customizable_site_area
    return render_design_customizable_site_area(context.locals_(__M_locals),page_content)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 360, in render_design_customizable_site_area
    __M_writer(escape(member_site_logo()))

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 353, in member_site_logo
    return render_member_site_logo(context)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 465, in render_member_site_logo
    (c.company.get_site_branding_header_background_image() is not None)

  File "/opt/workspace/ruprom-svn/uaprom/model/company.py", line 2115, in get_site_branding_header_background_image
    return self.site_header_background_image

  File "/opt/workspace/ruprom-svn/uaprom/model/company.py", line 2101, in _get_site_header_background_image
    self.__site_header_background_image = model.Image.query.get(image_id) if image_id else None

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 774, in get
    return self._load_on_ident(key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2461, in _load_on_ident
    return q.one()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2133, in one
    ret = list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 13.41ms

SELECT application.item AS application_item, application_settings.settings AS application_settings_settings 
FROM application, application_settings 
WHERE application_settings.company_id = 1088132 AND application.id = application_settings.application_id /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 107, in render_body
    body = capture(next.body)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 658, in capture
    callable_(*args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member/layout_base.mako.py", line 158, in render_body
    __M_writer(escape(applications.company_applications(c.company)))

  File "/opt/workspace/ruprom-svn/uaprom/lib/blocks.py", line 31, in __call__
    return self.render(self.call(*args, **kwargs))

  File "/opt/workspace/ruprom-svn/uaprom/lib/blocks.py", line 23, in call
    return self._func(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d3/applications.py", line 51, in company_applications
    app_settings = {key.db: val for key, val in app_settings_query}

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

TIME: 0.56ms

SELECT image.id AS image_id, image.status AS image_status, image.company_id AS image_company_id, image.file_name AS image_file_name, image.store_type AS image_store_type, image.size AS image_size, image.original_hash AS image_original_hash, image.date_created AS image_date_created, image.profile AS image_profile, image.watermark_text AS image_watermark_text, image.sizes AS image_sizes, image.perceptual_hash AS image_perceptual_hash 
FROM image 
WHERE image.id = 41030228 /* a241d3ca-c1dc-11e3-a1ab-c8cbb8c5f4a4 */

stack trace

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 90, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 79, in middleware
    return app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/registry.py", line 350, in __call__
    app_iter = self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/middleware.py", line 201, in __call__
    self.app, environ, catch_exc_info=True)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/util.py", line 94, in call_wsgi_application
    app_iter = application(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth2/middleware.py", line 56, in __call__
    return self._app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/config/middleware.py", line 108, in middleware
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/auth.py", line 23, in middleware
    result = app(environ, hook)

  File "/usr/local/lib/python2.7/dist-packages/WebError-0.10.3-py2.7.egg/weberror/errormiddleware.py", line 162, in __call__
    app_iter = self.application(environ, sr_checker)

  File "/usr/local/lib/python2.7/dist-packages/Paste-1.7.2-py2.7.egg/paste/recursive.py", line 80, in __call__
    return self.application(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 73, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Beaker-1.6.4-py2.7.egg/beaker/middleware.py", line 155, in __call__
    return self.wrap_app(environ, session_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 65, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/middleware.py", line 125, in __call__
    iterable = self.app(environ, hook)

  File "/opt/workspace/ruprom-svn/uaprom/lib/flash.py", line 107, in __call__
    app = self.app(environ, flash_start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/activity_detector.py", line 26, in __call__
    return self.app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/wsgi.py", line 24, in __call__
    return app(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/site/app.py", line 120, in __call__
    return self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Routes-1.13-py2.7.egg/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 125, in __call__
    response = self.dispatch(controller, environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/wsgiapp.py", line 324, in dispatch
    return controller(environ, start_response)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 129, in __call__
    environ, start_response)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 221, in __call__
    response = self._dispatch_call()

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 57, in _dispatch_call
    return super(BaseSiteController, self)._dispatch_call()

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 172, in _dispatch_call
    response = self._inspect_call(func)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/appstats/middleware.py", line 26, in on_inspect_call
    response = method(self, func)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/controllers/core.py", line 107, in _inspect_call
    result = self._perform_call(func, args)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in _perform_call
    return db.session.readonly(lambda: func(**args))()

  File "", line 1, in 

  File "/opt/workspace/ruprom-svn/uaprom/lib/orm/scoping.py", line 109, in decorated
    return fn(*args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/site_base.py", line 87, in 
    return db.session.readonly(lambda: func(**args))()

  File "", line 2, in product_view

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 159, in wrapper
    return func(self, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/controllers/member.py", line 1108, in product_view
    portfolio_items=portfolio_items

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 663, in render
    format=format, namespace=kargs, **cache_args)

  File "/usr/local/lib/python2.7/dist-packages/Pylons-0.9.7-py2.7.egg/pylons/templating.py", line 546, in render
    **options)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/ext/turbogears.py", line 56, in render
    return template.render(**info)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/mako.py", line 13, in handler
    return func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/template.py", line 412, in render
    return runtime._render(self, self.callable_, args, data)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 766, in _render
    **_kwargs_for_callable(callable_, data))

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 798, in _render_context
    _exec_template(inherit, lclcontext, args=args, kwargs=kwargs)

  File "/usr/local/lib/python2.7/dist-packages/Mako-0.7.3-py2.7.egg/mako/runtime.py", line 824, in _exec_template
    callable_(context, *args, **kwargs)

  File "/opt/workspace/ruprom/data/templates/member_base.mako.py", line 159, in render_body
    __M_writer(escape(h.url_for_favicon(c.company, c.is_company_site)))

  File "/opt/workspace/ruprom-svn/uaprom/lib/helpers/helpers_url.py", line 1084, in url_for_favicon
    favicon = custom and company and company.get_favicon()

  File "/opt/workspace/ruprom-svn/uaprom/model/company.py", line 2120, in get_favicon
    return self.favicon if allow else None

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 168, in __get__
    return self.impl.get(instance_state(instance),dict_)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/attributes.py", line 453, in get
    value = self.callable_(state, passive)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 508, in _load_for_state
    return self._emit_lazyload(session, state, ident_key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/strategies.py", line 552, in _emit_lazyload
    return q._load_on_ident(ident_key)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2461, in _load_on_ident
    return q.one()

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2133, in one
    ret = list(self)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2176, in __iter__
    return self._execute_and_instances(context)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/tracking.py", line 13, in wrapper
    return handler(func, *args, **kwargs)

  File "/opt/workspace/ruprom-svn/uaprom/lib/debug/trackers/sqlalchemy.py", line 78, in on_query
    iterator = func(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2191, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1450, in execute
    params)

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1583, in _execute_clauseelement
    compiled_sql, distilled_params

  File "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.6-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1690, in _execute_context
    context)

Карта

Автопоезд-скотовоз DAF XF 105, 2012г, вместимость 132м3, общая г/п 31т.