День | Время работы | Перерыв |
---|---|---|
Понедельник | 09:30 — 21:30 | |
Вторник | 09:30 — 21:30 | |
Среда | 09:30 — 21:30 | |
Четверг | 09:30 — 21:30 | |
Пятница | 09:30 — 21:30 | |
Суббота | 10:30 — 17:30 | |
Воскресенье | Выходной |
* Время указано для региона: Россия, Москва
65 900 €
День | Время работы | Перерыв |
---|---|---|
Понедельник | 09:30 — 21:30 | |
Вторник | 09:30 — 21:30 | |
Среда | 09:30 — 21:30 | |
Четверг | 09:30 — 21:30 | |
Пятница | 09:30 — 21:30 | |
Суббота | 10:30 — 17:30 | |
Воскресенье | Выходной |
* Время указано для региона: Россия, Москва
Mercedes-Benz Axor 1829 L, штора 44м3, все загрузки, длина 7.2м, гидролифт, г/п 10т, спальник
- без пробега по России и СНГ
- 09/2011г
- оригинальный пробег 230 тыс.км
- сделано в Германии
- предоставляется гарантия на основные узлы и агрегаты
- указана цена с учетом всех таможенных платежей и утилизационного сбора
Двигатель, КПП:
- 6-ти цилиндровый 6374 см3, 290 л.с., Евро-5
- 6-ти ступенчатая МКПП
Шасси, резина:
- колесная формула 4х2
- грузоподъемность 10 тонн
- отличная резина R 22.5
Тормозная система и ходовая:
- тормозная система с ABS, ASR, ESP
- пневматическая подвеска
- дисковые тормоза
Кузов:
- штора 44 м3 (производство Германия), сдвижные крыша и бока
- внутренние размеры 7200 х 2480 х 2480 мм
- гидролифт
Навесное оборудование:
- противотуманные фары
- солнцезащитный козырек
- спойлер
- фаркоп
Комплектация:
- кабина с одним спальным местом
- кондиционер
- автономный отопитель салона
- комфортабельное сидение водителя на воздушной подушке
- электрозеркала
- электростеклоподъемники
- бортовой компьютер
- магнитола CD
- навигационная система
- люк
- цифровой тахограф
Техническое состояние и информация об условиях эксплуатации:
- страна производства, эксплуатации и обслуживания - Германия, один владелец
- обслуживался по регламенту у официального представителя Mercedes, история ТО
- копии немецких документов (бриф, ТЮФ)
- идеальное техническое состояние и внешний вид
Порядок поставки:
- грузовик Мерседес-Бенц Аксор находится в Германии
- поставка шторного грузовика Mercedes-Benz Axor осуществляется за счет нашей компании, оплата вперед не требуется
- срок поставки до Москвы 2-3 недели со дня заключения договора с заказчиком
- у автомобиля будет российский ПТС
Порядок оплаты и оформления:
- нал/безнал расчет
- возможна продажа шторного грузовика Мерседес Аксор из Германии в кредит/лизинг юр. и физ. лицам из всех регионов РФ с минимальным первоначальным взносом
- бесплатное оформление купли-продажи в комфортном офисе на территории стоянки
Дополнительные услуги:
- ОСАГО/КАСКО
- доставка в любой регион России
- бесплатный поиск и подбор грузовой техники в Германии под задачи и бюджет заказчика.
Арт. № 4762
Основные атрибуты | |
---|---|
Марка | Mercedes-Benz |
Тип грузового автомобиля | Тент, полуприцеп |
Год выпуска | 2011 |
Производитель | Mercedes-Benz |
Пробег | 230000 (км) |
Объем грузового отсека | 44.0 (куб. м) |
Коробка переключения передач | Механическая |
Количество ступеней коробки передач | 6 |
Страна производитель | Германия |
Характеристики двигателя | |
Тип двигателя | Дизельный |
Объем двигателя | 6374.0 (куб. см) |
Мощность двигателя | 290.0 (л. с.) |
Количество цилиндров | 6 |
Характеристики ходовой | |
Колесная формула | 4×2 |
Дополнительные характеристики | |
Комфорт | Круиз-контроль , Электростеклоподъемники, Подогрев зеркал, Электрозеркала, Кондиционер, Подогрев сидений, Люк, Пневмоподвеска |
Безопасность | Антиблокировочная система тормозов ABS , Антипробуксовочная система ASR , Электронная система торможения EBS (EHB, Brake-by-wire) |
Цвет | Красный |
Стояночный отопитель двигателя | Да |
Отзывов пока нет, будьте первыми!
Panzer-Auto - продажа грузовиков и прицепов из Германии со стоянки в Москве и на заказ. Кредит, лизинг.
memcached get |
4.54ms
|
memcached get |
0.22ms
|
redis GET |
6.3ms
|
sql query |
12.07ms
|
memcached get |
0.22ms
|
memcached get |
0.24ms
|
memcached get |
0.2ms
|
memcached get |
0.95ms
|
memcached get |
0.17ms
|
memcached get |
0.4ms
|
sql query |
4.09ms
|
sql query |
3.38ms
|
sql query |
22.24ms
|
sql query |
14.27ms
|
redis GET |
3.68ms
|
sql query |
5.53ms
|
sql query |
9.27ms
|
solr select |
3.87ms
|
sql query |
8.15ms
|
memcached get |
0.55ms
|
sql query |
6.9ms
|
sql query |
15.84ms
|
sql query |
5.94ms
|
sql query |
11.53ms
|
mako start |
|
redis GET |
4.94ms
|
sql query |
4.84ms
|
sql query |
8.74ms
|
sql query |
3.81ms
|
sql query |
4.71ms
|
memcached get |
0.4ms
|
redis GET |
0.21ms
|
sql query |
5.77ms
|
sql query |
6.56ms
|
sql query |
3.59ms
|
sql query |
4.82ms
|
memcached get |
0.37ms
|
memcached get |
0.6ms
|
memcached get |
0.4ms
|
memcached get |
2.34ms
|
memcached get |
0.67ms
|
sql query |
8.93ms
|
sql query |
14.79ms
|
mako end |
|
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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = '35962348' ORDER BY minimum_order_quantity /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = '35962348' ORDER BY product_spec_link.id /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = '35962348' LIMIT 1 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 (35962348) ORDER BY product_image_link.id /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 2217692 ORDER BY product_group.position LIMIT 1 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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, 29347, 33210, 11182, 12750, 14425) AND attribute_value.status = 'a' AND attribute.status = 'active' /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 2217692 AND product.id > 35962348 ORDER BY product.id LIMIT 10 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 2217692 AND product.id < 35962348 ORDER BY product.id LIMIT 6 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 35962348)) LIMIT 10 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = '35962348' ORDER BY position LIMIT 2 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 2217692 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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 2217692 ORDER BY product_group_manager_contact_product_group_link.product_group_id /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 35962348 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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 = 35962348 AND product_opinion.bounded_to_company = true GROUP BY product_opinion.rating ORDER BY product_opinion.rating DESC /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 FROM attribute_value WHERE attribute_value.id = 29347 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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 117, in render_body __M_writer(escape(bcmb.boilerplate_text_block(c.company, 'product_view', c.product, group=c.group, category=c.category))) 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/d1/common/boilerplate.py", line 55, in boilerplate_text_block }[_page_type]() File "/opt/workspace/ruprom-svn/uaprom/site/blocks/versions/d1/common/boilerplate.py", line 42, in product_page_boilerplate_text category File "/opt/workspace/ruprom-svn/uaprom/lib/helpers/helpers_company_site.py", line 439, in __call__ custom_context = self.custom_context_func(company, *args, **kwargs) File "/opt/workspace/ruprom-svn/uaprom/lib/helpers/helpers_company_site.py", line 310, in custom_product_template_context manufacturer = get_manufacturer_attribute_value(product) or '' File "/opt/workspace/ruprom-svn/uaprom/lib/bl/bl_product.py", line 2588, in get_manufacturer_attribute_value return AttributeValue.get(value_id).value 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)
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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
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 /* 8279012f-c296-11e3-a1ab-c8cbb8c5f4a4 */
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)
[(u'q', u'*:*'), (u'rows', 0)]
[(u'fq', [u'company:1088132', u'groups:2217692'])]
[(u'facet.field', [u'{!key=bss0 ex=bss0}bss0'])]
['auth.cs:2e16c40828aae7327a24d0b8dd7403edf37b166a:remote_user']
6.30ms['cached.currency_rates.108211.revision']
3.68ms['cached.feature_flags.v2.revision']
4.94ms['cached.attribute_units.108211.revision']
0.21ms['cache:ru:func:uaprom.site.app:resolve_site_domain:8747773721184184143']
{}
4.54ms['cache:ru:func:uaprom.site.app:resolve_site_domain:8747773721184184143']
{}
0.22ms['cache:ru:func:uaprom.site.lib.menu:cached_wrapper:version']
{}
0.22ms['cache:ru:func:uaprom.site.lib.menu:cached_wrapper:-6400043321735182980:1397343259']
{}
0.24ms['cache:ru:func:uaprom.site.lib.query:get_company_site_base_data:version']
{}
0.20ms['cache:ru:func:uaprom.site.lib.query:get_company_site_base_data:-4014661943223949966:1397343295']
{}
0.95ms['cache:ru:func:uaprom.site.lib.menu:cached_wrapper:version']
{}
0.17ms['cache:ru:func:uaprom.site.lib.menu:cached_wrapper:-7459059773093839902:1397343259']
{}
0.40ms['cache:ru:uaprom.catalog.blocks.products.companies_cache.v9:1088132']
{}
0.55ms['cache:ru:func:/portlets_shop_settings.mako:schedule_info_popup4:4616560990959269700']
{}
0.40ms['cache:ru:func:uaprom.lib.bl.bl_product:get_group_path:-3580309952871413628']
{}
0.37ms['cache:ru:func:uaprom.lib.bl.bl_product:get_group_path:-3580309952871413628']
{}
0.60ms['cache:ru:func:/portlets_shop_settings.mako:schedule_info_popup4:4616560990959269700']
{}
0.40ms['cache:ru:func:uaprom.lib.bl.bl_endorsement:get_approved_votes_count_for_company:-7202469968718387396']
{}
2.34ms['cache:ru:func:uaprom.lib.bl.bl_opinion:get_ratings:-7202469968718387396']
{}
0.67ms