Все мастера и бригады
Украина

У нас 18 309
строителей

Создано 20 728
тендеров

Более 4 181
услуг

Нужны мастера?

Создайте заявку

Бурение скважин под тепловые насосы в Украина

Хотите найти надежного мастера без
посредников и сэкономить?

  1. Создайте заявку
  2. Сравните условия и цены от мастеров
  3. Выберите мастера по рейтингу и цене
Разместите задание и узнайте цены

Это бесплатно и займет всего пару минут

Расценки на бурение скважин под тепловые насосы в Украина от мастеров

Эту услугу оказывают 14 исполнителей

Средняя оценка: 4.1 (на основании 2321 отзывов)

Средняя цена: 235.71 грн / м. пог.

Диапазон цен: 90.00 - 1600.00 грн / м. пог.

Фото бурение скважин под тепловые насосы

Посмотрите как работает сайт

Сколько стоит бурение скважин под тепловые насосы в Украина?

Цены на бурение скважин под тепловые насосы в Украина зависят от многих факторов, в первую очередь от объемов и класса специалиста, а также месторасположение объекта.

Оставьте заявку сейчас!

И получите лучшие предложения от проверенных мастеров.

  1. Создайте заявку;
  2. Сравните условия и цены от мастеров;
  3. Выберите мастера по рейтингу и цене.
Более 10 000 исполнителей
ждут ваших заказов!

Тендеры в категории: бурение скважин под тепловые насосы в Украина

Бурение отверстий для ремонта существующих наземных линий

Необходимо выполнить бурение отверстий под бетонные приставки (для деревянных опор) в Черновицкой области. Общее кол-во опор более 10 штук.

Бурение отверстий для ремонта существующих наземных линий

Необходимо выполнить бурение отверстий под бетонные приставки (для деревянных опор) в Черновицкой области. Общее кол-во опор более 100 штук.

Бурение и обустройство скважины, 50 м

Бурение и обустройство скважины на садовом участке, глубина 50 метров. Обсадка. Рассмотрю ваши варианты обсадки. подводка труб к дому. необходим на участке септик, 2 колодца по 1.5 метра. Раменский район, деревня Бубново. Начало работ-конец мая
Журнал приложения
Время Уровень Категория Сообщение
09:54:01.918852 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users_categories"
from cache
09:54:01.919060 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `users_categories` `t`)
09:54:01.920423 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `users_categories` `t`)
09:54:01.928775 trace system.caching.CFileCache
Serving "Yii.CUrlManager.rules" from cache
09:54:01.944189 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_countries"
from cache
09:54:01.945447 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_cities"
from cache
09:54:01.946393 trace system.caching.CFileCache
Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
`t`.`country_id` AS `t0_c0`, `t`.`country_name` AS `t0_c1`,
`t`.`country_geo_lat` AS `t0_c2`, `t`.`country_geo_lng` AS `t0_c3`,
`t`.`city_id` AS `t0_c4`, `t`.`capital_id` AS `t0_c5`, `t`.`country_code`
AS `t0_c6`, `t`.`country_domain` AS `t0_c7`, `t`.`country_language` AS
`t0_c8`, `t`.`country_new_domain` AS `t0_c9`, `t`.`country_currency` AS
`t0_c10`, `t`.`country_phone_mask` AS `t0_c11`, `t`.`country_main_article`
AS `t0_c12`, `t`.`country_tenders_article` AS `t0_c13`,
`t`.`country_users_subtext` AS `t0_c14`, `t`.`country_price_article` AS
`t0_c15`, `t`.`country_price_subtext` AS `t0_c16`,
`t`.`country_payments_config` AS `t0_c17`, `t`.`country_jivosite_code` AS
`t0_c18`, `capital`.`city_id` AS `t1_c0`, `capital`.`region_id` AS `t1_c1`,
`capital`.`city_name` AS `t1_c2`, `capital`.`city_url` AS `t1_c3`,
`capital`.`city_geo_lat` AS `t1_c4`, `capital`.`city_geo_lng` AS `t1_c5`,
`capital`.`city_type` AS `t1_c6`, `capital`.`city_sort` AS `t1_c7`,
`capital`.`city_ads_priority` AS `t1_c8` FROM `geo_countries` `t`  LEFT
OUTER JOIN `geo_cities` `capital` ON (`t`.`capital_id`=`capital`.`city_id`)
:a:0:{}" from cache
09:54:01.947890 trace system.caching.CFileCache
Serving "yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:logs"
from cache
09:54:01.949598 profile system.db.CDbCommand.execute
begin:system.db.CDbCommand.execute(INSERT INTO `logs` (`url`, `code`,
`referer`, `ip`, `agent`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4,
:yp5))
09:54:01.950275 profile system.db.CDbCommand.execute
end:system.db.CDbCommand.execute(INSERT INTO `logs` (`url`, `code`,
`referer`, `ip`, `agent`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4,
:yp5))
09:54:01.952874 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_categories"
from cache
09:54:01.952991 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `services_categories` `t`
WHERE visibility = 1 ORDER BY category_sort, category_name, category_id)
09:54:01.954925 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `services_categories` `t`
WHERE visibility = 1 ORDER BY category_sort, category_name, category_id)
09:54:01.964539 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services"
from cache
09:54:01.965585 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_gradations"
from cache
09:54:01.966547 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_articles"
from cache
09:54:01.967138 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_to_categories"
from cache
09:54:01.967437 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`service_id` AS `t0_c0`,
`t`.`service_name` AS `t0_c1`, `t`.`service_url` AS `t0_c2`,
`t`.`service_gradation_id` AS `t0_c3`, `t`.`user_id` AS `t0_c4`,
`t`.`service_priority` AS `t0_c5`, `t`.`service_date` AS `t0_c6`,
`t`.`service_banner` AS `t0_c7`, `servicesCategories`.`category_id` AS
`t1_c0`, `servicesCategories`.`category_name` AS `t1_c1`,
`servicesCategories`.`category_url` AS `t1_c2`,
`servicesCategories`.`category_caption` AS `t1_c3`,
`servicesCategories`.`category_title` AS `t1_c4`,
`servicesCategories`.`category_description` AS `t1_c5`,
`servicesCategories`.`category_sort` AS `t1_c6`,
`servicesCategories`.`service_category_title` AS `t1_c7`,
`servicesCategories`.`category_parent_id` AS `t1_c8`,
`servicesCategories`.`category_seo_type` AS `t1_c9`,
`servicesCategories`.`category_seo_priority` AS `t1_c10`,
`servicesCategories`.`visibility` AS `t1_c11`,
`serviceGradation`.`service_gradation_id` AS `t2_c0`,
`serviceGradation`.`service_gradation_name` AS `t2_c1`,
`servicesArticles`.`article_id` AS `t3_c0`, `servicesArticles`.`service_id`
AS `t3_c1`, `servicesArticles`.`country_id` AS `t3_c2`,
`servicesArticles`.`article_content` AS `t3_c3` FROM `services` `t`  LEFT
OUTER JOIN `services_to_categories` `servicesCategories_servicesCategories`
ON (`t`.`service_id`=`servicesCategories_servicesCategories`.`service_id`)
LEFT OUTER JOIN `services_categories` `servicesCategories` ON
(`servicesCategories`.`category_id`=`servicesCategories_servicesCategories`.`service_category_id`)
 LEFT OUTER JOIN `services_gradations` `serviceGradation` ON
(`t`.`service_gradation_id`=`serviceGradation`.`service_gradation_id`) 
LEFT OUTER JOIN `services_articles` `servicesArticles` ON
(`servicesArticles`.`service_id`=`t`.`service_id`) AND
(servicesArticles.country_id = :country_id)  WHERE ((service_url=:ycp0) AND
(t.user_id IS NULL)))
09:54:01.968403 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`service_id` AS `t0_c0`,
`t`.`service_name` AS `t0_c1`, `t`.`service_url` AS `t0_c2`,
`t`.`service_gradation_id` AS `t0_c3`, `t`.`user_id` AS `t0_c4`,
`t`.`service_priority` AS `t0_c5`, `t`.`service_date` AS `t0_c6`,
`t`.`service_banner` AS `t0_c7`, `servicesCategories`.`category_id` AS
`t1_c0`, `servicesCategories`.`category_name` AS `t1_c1`,
`servicesCategories`.`category_url` AS `t1_c2`,
`servicesCategories`.`category_caption` AS `t1_c3`,
`servicesCategories`.`category_title` AS `t1_c4`,
`servicesCategories`.`category_description` AS `t1_c5`,
`servicesCategories`.`category_sort` AS `t1_c6`,
`servicesCategories`.`service_category_title` AS `t1_c7`,
`servicesCategories`.`category_parent_id` AS `t1_c8`,
`servicesCategories`.`category_seo_type` AS `t1_c9`,
`servicesCategories`.`category_seo_priority` AS `t1_c10`,
`servicesCategories`.`visibility` AS `t1_c11`,
`serviceGradation`.`service_gradation_id` AS `t2_c0`,
`serviceGradation`.`service_gradation_name` AS `t2_c1`,
`servicesArticles`.`article_id` AS `t3_c0`, `servicesArticles`.`service_id`
AS `t3_c1`, `servicesArticles`.`country_id` AS `t3_c2`,
`servicesArticles`.`article_content` AS `t3_c3` FROM `services` `t`  LEFT
OUTER JOIN `services_to_categories` `servicesCategories_servicesCategories`
ON (`t`.`service_id`=`servicesCategories_servicesCategories`.`service_id`)
LEFT OUTER JOIN `services_categories` `servicesCategories` ON
(`servicesCategories`.`category_id`=`servicesCategories_servicesCategories`.`service_category_id`)
 LEFT OUTER JOIN `services_gradations` `serviceGradation` ON
(`t`.`service_gradation_id`=`serviceGradation`.`service_gradation_id`) 
LEFT OUTER JOIN `services_articles` `servicesArticles` ON
(`servicesArticles`.`service_id`=`t`.`service_id`) AND
(servicesArticles.country_id = :country_id)  WHERE ((service_url=:ycp0) AND
(t.user_id IS NULL)))
09:54:01.969728 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:tenders_tmp"
from cache
09:54:01.969846 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tenders_tmp` `t` WHERE
link_omastere_request=:ycp1 ORDER BY id LIMIT 5)
09:54:01.970622 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tenders_tmp` `t` WHERE
link_omastere_request=:ycp1 ORDER BY id LIMIT 5)
09:54:01.970912 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `tenders_tmp` `t` WHERE gid
IN (:ycp2, :ycp3, :ycp4))
09:54:01.971270 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `tenders_tmp` `t` WHERE gid IN
(:ycp2, :ycp3, :ycp4))
09:54:01.972119 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT MIN(service_price_offer) as min,
MAX(service_price_offer) as max, AVG(service_price_offer) as avg,
COUNT(service_price_offer) as count
FROM `services_prices` `t`
JOIN `users` ON users.user_id = t.user_id
JOIN `geo_cities` ON geo_cities.city_id = users.city_id
JOIN `geo_regions` ON geo_regions.region_id = geo_cities.region_id
WHERE (t.service_id = :service_id) AND (geo_regions.country_id =
:country_id)
GROUP BY `t`.`service_id`)
09:54:01.973951 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT MIN(service_price_offer) as min,
MAX(service_price_offer) as max, AVG(service_price_offer) as avg,
COUNT(service_price_offer) as count
FROM `services_prices` `t`
JOIN `users` ON users.user_id = t.user_id
JOIN `geo_cities` ON geo_cities.city_id = users.city_id
JOIN `geo_regions` ON geo_regions.region_id = geo_cities.region_id
WHERE (t.service_id = :service_id) AND (geo_regions.country_id =
:country_id)
GROUP BY `t`.`service_id`)
09:54:01.975055 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_prices"
from cache
09:54:01.978233 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users" from
cache
09:54:01.979708 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_regions"
from cache
09:54:01.980581 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`service_price_id` AS `t0_c0`,
`user`.`user_id` AS `t1_c0`, `user`.`user_email` AS `t1_c1`,
`user`.`user_vip` AS `t1_c2`, `user`.`mailgun_verification` AS `t1_c3`,
`user`.`is_accepted` AS `t1_c4`, `user`.`is_valid` AS `t1_c5`,
`user`.`is_opened` AS `t1_c6`, `user`.`is_clicked` AS `t1_c7`,
`user`.`user_phone` AS `t1_c8`, `user`.`user_confirmed` AS `t1_c9`,
`user`.`send_notifications` AS `t1_c10`, `user`.`send_notifications_old` AS
`t1_c11`, `user`.`user_activity` AS `t1_c12`, `user`.`last_notification` AS
`t1_c13`, `user`.`user_password` AS `t1_c14`, `user`.`user_pro_date` AS
`t1_c15`, `user`.`user_pro_status` AS `t1_c16`, `user`.`first_login` AS
`t1_c17`, `user`.`user_phone_status` AS `t1_c18`, `user`.`user_data` AS
`t1_c19`, `user`.`user_hidden` AS `t1_c20`, `user`.`user_type` AS `t1_c21`,
`user`.`user_type_change` AS `t1_c22`, `user`.`user_notifications_interval`
AS `t1_c23`, `user`.`user_notifications_date` AS `t1_c24`,
`user`.`user_title` AS `t1_c25`, `user`.`post_id` AS `t1_c26`,
`user`.`user_name` AS `t1_c27`, `user`.`user_surname` AS `t1_c28`,
`user`.`user_patronymic` AS `t1_c29`, `user`.`user_site_address` AS
`t1_c30`, `user`.`user_site_informer` AS `t1_c31`,
`user`.`user_site_verification` AS `t1_c32`, `user`.`user_company_details`
AS `t1_c33`, `user`.`user_company_file` AS `t1_c34`,
`user`.`user_company_type` AS `t1_c35`, `user`.`user_seller` AS `t1_c36`,
`user`.`city_id` AS `t1_c37`, `user`.`area_id` AS `t1_c38`,
`user`.`metro_id` AS `t1_c39`, `user`.`user_address` AS `t1_c40`,
`user`.`user_street` AS `t1_c41`, `user`.`user_house` AS `t1_c42`,
`user`.`user_geo_address` AS `t1_c43`, `user`.`user_geo_lat` AS `t1_c44`,
`user`.`user_geo_lng` AS `t1_c45`, `user`.`user_post_index` AS `t1_c46`,
`user`.`work_clearing` AS `t1_c47`, `user`.`work_prepayment` AS `t1_c48`,
`user`.`work_contract` AS `t1_c49`, `user`.`user_workers` AS `t1_c50`,
`user`.`user_work_terms` AS `t1_c51`, `user`.`user_prepay_work` AS
`t1_c52`, `user`.`user_prepay_materials` AS `t1_c53`,
`user`.`user_need_review` AS `t1_c54`, `user`.`domain_id` AS `t1_c55`,
`user`.`logo_id` AS `t1_c56`, `user`.`user_rating` AS `t1_c57`,
`user`.`user_rating_verification` AS `t1_c58`, `user`.`user_info` AS
`t1_c59`, `user`.`user_schedule` AS `t1_c60`, `user`.`register_offer` AS
`t1_c61`, `user`.`news_subscription` AS `t1_c62`, `user`.`register_date` AS
`t1_c63`, `user`.`last_login` AS `t1_c64`, `user`.`block_lvl` AS `t1_c65`,
`user`.`unblock_date` AS `t1_c66`, `user`.`delete_account` AS `t1_c67`,
`user`.`delete_reason` AS `t1_c68`, `user`.`delete_text` AS `t1_c69`,
`user`.`delete_date` AS `t1_c70`, `user`.`account_status` AS `t1_c71`,
`user`.`user_access_lvl` AS `t1_c72`, `user`.`prices_count` AS `t1_c73`,
`user`.`photos_count` AS `t1_c74`, `user`.`tenders_count` AS `t1_c75`,
`user`.`comments_count` AS `t1_c76`, `user`.`user_bonus` AS `t1_c77`,
`user`.`user_is_active` AS `t1_c78`, `user`.`user_comment` AS `t1_c79`,
`user`.`user_checked` AS `t1_c80`, `user`.`user_marked` AS `t1_c81`,
`user`.`user_tmp` AS `t1_c82`, `user`.`is_remtrust` AS `t1_c83`,
`user`.`is_remtrust_pro` AS `t1_c84`, `user`.`user_inform_active` AS
`t1_c85`, `user`.`mailgun_check` AS `t1_c86`, `city`.`city_id` AS `t2_c0`,
`city`.`region_id` AS `t2_c1`, `city`.`city_name` AS `t2_c2`,
`city`.`city_url` AS `t2_c3`, `city`.`city_geo_lat` AS `t2_c4`,
`city`.`city_geo_lng` AS `t2_c5`, `city`.`city_type` AS `t2_c6`,
`city`.`city_sort` AS `t2_c7`, `city`.`city_ads_priority` AS `t2_c8`,
`region`.`region_id` AS `t3_c0`, `region`.`country_id` AS `t3_c1`,
`region`.`region_name` AS `t3_c2`, `region`.`city_id` AS `t3_c3`,
`region`.`region_url` AS `t3_c4` FROM `services_prices` `t`  LEFT OUTER
JOIN `users` `user` ON (`t`.`user_id`=`user`.`user_id`)  LEFT OUTER JOIN
`geo_cities` `city` ON (`user`.`city_id`=`city`.`city_id`)  LEFT OUTER JOIN
`geo_regions` `region` ON (`city`.`region_id`=`region`.`region_id`)  WHERE
((region.country_id=:ycp5) AND (service_id=:ycp6)) ORDER BY
user.user_pro_date DESC, user.user_rating DESC LIMIT 10 OFFSET 10)
09:54:01.984529 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`service_price_id` AS `t0_c0`,
`user`.`user_id` AS `t1_c0`, `user`.`user_email` AS `t1_c1`,
`user`.`user_vip` AS `t1_c2`, `user`.`mailgun_verification` AS `t1_c3`,
`user`.`is_accepted` AS `t1_c4`, `user`.`is_valid` AS `t1_c5`,
`user`.`is_opened` AS `t1_c6`, `user`.`is_clicked` AS `t1_c7`,
`user`.`user_phone` AS `t1_c8`, `user`.`user_confirmed` AS `t1_c9`,
`user`.`send_notifications` AS `t1_c10`, `user`.`send_notifications_old` AS
`t1_c11`, `user`.`user_activity` AS `t1_c12`, `user`.`last_notification` AS
`t1_c13`, `user`.`user_password` AS `t1_c14`, `user`.`user_pro_date` AS
`t1_c15`, `user`.`user_pro_status` AS `t1_c16`, `user`.`first_login` AS
`t1_c17`, `user`.`user_phone_status` AS `t1_c18`, `user`.`user_data` AS
`t1_c19`, `user`.`user_hidden` AS `t1_c20`, `user`.`user_type` AS `t1_c21`,
`user`.`user_type_change` AS `t1_c22`, `user`.`user_notifications_interval`
AS `t1_c23`, `user`.`user_notifications_date` AS `t1_c24`,
`user`.`user_title` AS `t1_c25`, `user`.`post_id` AS `t1_c26`,
`user`.`user_name` AS `t1_c27`, `user`.`user_surname` AS `t1_c28`,
`user`.`user_patronymic` AS `t1_c29`, `user`.`user_site_address` AS
`t1_c30`, `user`.`user_site_informer` AS `t1_c31`,
`user`.`user_site_verification` AS `t1_c32`, `user`.`user_company_details`
AS `t1_c33`, `user`.`user_company_file` AS `t1_c34`,
`user`.`user_company_type` AS `t1_c35`, `user`.`user_seller` AS `t1_c36`,
`user`.`city_id` AS `t1_c37`, `user`.`area_id` AS `t1_c38`,
`user`.`metro_id` AS `t1_c39`, `user`.`user_address` AS `t1_c40`,
`user`.`user_street` AS `t1_c41`, `user`.`user_house` AS `t1_c42`,
`user`.`user_geo_address` AS `t1_c43`, `user`.`user_geo_lat` AS `t1_c44`,
`user`.`user_geo_lng` AS `t1_c45`, `user`.`user_post_index` AS `t1_c46`,
`user`.`work_clearing` AS `t1_c47`, `user`.`work_prepayment` AS `t1_c48`,
`user`.`work_contract` AS `t1_c49`, `user`.`user_workers` AS `t1_c50`,
`user`.`user_work_terms` AS `t1_c51`, `user`.`user_prepay_work` AS
`t1_c52`, `user`.`user_prepay_materials` AS `t1_c53`,
`user`.`user_need_review` AS `t1_c54`, `user`.`domain_id` AS `t1_c55`,
`user`.`logo_id` AS `t1_c56`, `user`.`user_rating` AS `t1_c57`,
`user`.`user_rating_verification` AS `t1_c58`, `user`.`user_info` AS
`t1_c59`, `user`.`user_schedule` AS `t1_c60`, `user`.`register_offer` AS
`t1_c61`, `user`.`news_subscription` AS `t1_c62`, `user`.`register_date` AS
`t1_c63`, `user`.`last_login` AS `t1_c64`, `user`.`block_lvl` AS `t1_c65`,
`user`.`unblock_date` AS `t1_c66`, `user`.`delete_account` AS `t1_c67`,
`user`.`delete_reason` AS `t1_c68`, `user`.`delete_text` AS `t1_c69`,
`user`.`delete_date` AS `t1_c70`, `user`.`account_status` AS `t1_c71`,
`user`.`user_access_lvl` AS `t1_c72`, `user`.`prices_count` AS `t1_c73`,
`user`.`photos_count` AS `t1_c74`, `user`.`tenders_count` AS `t1_c75`,
`user`.`comments_count` AS `t1_c76`, `user`.`user_bonus` AS `t1_c77`,
`user`.`user_is_active` AS `t1_c78`, `user`.`user_comment` AS `t1_c79`,
`user`.`user_checked` AS `t1_c80`, `user`.`user_marked` AS `t1_c81`,
`user`.`user_tmp` AS `t1_c82`, `user`.`is_remtrust` AS `t1_c83`,
`user`.`is_remtrust_pro` AS `t1_c84`, `user`.`user_inform_active` AS
`t1_c85`, `user`.`mailgun_check` AS `t1_c86`, `city`.`city_id` AS `t2_c0`,
`city`.`region_id` AS `t2_c1`, `city`.`city_name` AS `t2_c2`,
`city`.`city_url` AS `t2_c3`, `city`.`city_geo_lat` AS `t2_c4`,
`city`.`city_geo_lng` AS `t2_c5`, `city`.`city_type` AS `t2_c6`,
`city`.`city_sort` AS `t2_c7`, `city`.`city_ads_priority` AS `t2_c8`,
`region`.`region_id` AS `t3_c0`, `region`.`country_id` AS `t3_c1`,
`region`.`region_name` AS `t3_c2`, `region`.`city_id` AS `t3_c3`,
`region`.`region_url` AS `t3_c4` FROM `services_prices` `t`  LEFT OUTER
JOIN `users` `user` ON (`t`.`user_id`=`user`.`user_id`)  LEFT OUTER JOIN
`geo_cities` `city` ON (`user`.`city_id`=`city`.`city_id`)  LEFT OUTER JOIN
`geo_regions` `region` ON (`city`.`region_id`=`region`.`region_id`)  WHERE
((region.country_id=:ycp5) AND (service_id=:ycp6)) ORDER BY
user.user_pro_date DESC, user.user_rating DESC LIMIT 10 OFFSET 10)
09:54:01.988573 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:domains" from
cache
09:54:01.989939 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users_types"
from cache
09:54:01.991025 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users_contacts"
from cache
09:54:01.992024 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:logos" from
cache
09:54:01.993247 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:files" from
cache
09:54:01.994544 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:reviews" from
cache
09:54:01.995754 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`service_price_id` AS `t0_c0`,
`t`.`service_id` AS `t0_c1`, `t`.`user_id` AS `t0_c2`,
`t`.`service_price_offer` AS `t0_c3`, `t`.`service_price_date` AS `t0_c4`,
`user`.`user_id` AS `t1_c0`, `user`.`user_email` AS `t1_c1`,
`user`.`user_vip` AS `t1_c2`, `user`.`mailgun_verification` AS `t1_c3`,
`user`.`is_accepted` AS `t1_c4`, `user`.`is_valid` AS `t1_c5`,
`user`.`is_opened` AS `t1_c6`, `user`.`is_clicked` AS `t1_c7`,
`user`.`user_phone` AS `t1_c8`, `user`.`user_confirmed` AS `t1_c9`,
`user`.`send_notifications` AS `t1_c10`, `user`.`send_notifications_old` AS
`t1_c11`, `user`.`user_activity` AS `t1_c12`, `user`.`last_notification` AS
`t1_c13`, `user`.`user_password` AS `t1_c14`, `user`.`user_pro_date` AS
`t1_c15`, `user`.`user_pro_status` AS `t1_c16`, `user`.`first_login` AS
`t1_c17`, `user`.`user_phone_status` AS `t1_c18`, `user`.`user_data` AS
`t1_c19`, `user`.`user_hidden` AS `t1_c20`, `user`.`user_type` AS `t1_c21`,
`user`.`user_type_change` AS `t1_c22`, `user`.`user_notifications_interval`
AS `t1_c23`, `user`.`user_notifications_date` AS `t1_c24`,
`user`.`user_title` AS `t1_c25`, `user`.`post_id` AS `t1_c26`,
`user`.`user_name` AS `t1_c27`, `user`.`user_surname` AS `t1_c28`,
`user`.`user_patronymic` AS `t1_c29`, `user`.`user_site_address` AS
`t1_c30`, `user`.`user_site_informer` AS `t1_c31`,
`user`.`user_site_verification` AS `t1_c32`, `user`.`user_company_details`
AS `t1_c33`, `user`.`user_company_file` AS `t1_c34`,
`user`.`user_company_type` AS `t1_c35`, `user`.`user_seller` AS `t1_c36`,
`user`.`city_id` AS `t1_c37`, `user`.`area_id` AS `t1_c38`,
`user`.`metro_id` AS `t1_c39`, `user`.`user_address` AS `t1_c40`,
`user`.`user_street` AS `t1_c41`, `user`.`user_house` AS `t1_c42`,
`user`.`user_geo_address` AS `t1_c43`, `user`.`user_geo_lat` AS `t1_c44`,
`user`.`user_geo_lng` AS `t1_c45`, `user`.`user_post_index` AS `t1_c46`,
`user`.`work_clearing` AS `t1_c47`, `user`.`work_prepayment` AS `t1_c48`,
`user`.`work_contract` AS `t1_c49`, `user`.`user_workers` AS `t1_c50`,
`user`.`user_work_terms` AS `t1_c51`, `user`.`user_prepay_work` AS
`t1_c52`, `user`.`user_prepay_materials` AS `t1_c53`,
`user`.`user_need_review` AS `t1_c54`, `user`.`domain_id` AS `t1_c55`,
`user`.`logo_id` AS `t1_c56`, `user`.`user_rating` AS `t1_c57`,
`user`.`user_rating_verification` AS `t1_c58`, `user`.`user_info` AS
`t1_c59`, `user`.`user_schedule` AS `t1_c60`, `user`.`register_offer` AS
`t1_c61`, `user`.`news_subscription` AS `t1_c62`, `user`.`register_date` AS
`t1_c63`, `user`.`last_login` AS `t1_c64`, `user`.`block_lvl` AS `t1_c65`,
`user`.`unblock_date` AS `t1_c66`, `user`.`delete_account` AS `t1_c67`,
`user`.`delete_reason` AS `t1_c68`, `user`.`delete_text` AS `t1_c69`,
`user`.`delete_date` AS `t1_c70`, `user`.`account_status` AS `t1_c71`,
`user`.`user_access_lvl` AS `t1_c72`, `user`.`prices_count` AS `t1_c73`,
`user`.`photos_count` AS `t1_c74`, `user`.`tenders_count` AS `t1_c75`,
`user`.`comments_count` AS `t1_c76`, `user`.`user_bonus` AS `t1_c77`,
`user`.`user_is_active` AS `t1_c78`, `user`.`user_comment` AS `t1_c79`,
`user`.`user_checked` AS `t1_c80`, `user`.`user_marked` AS `t1_c81`,
`user`.`user_tmp` AS `t1_c82`, `user`.`is_remtrust` AS `t1_c83`,
`user`.`is_remtrust_pro` AS `t1_c84`, `user`.`user_inform_active` AS
`t1_c85`, `user`.`mailgun_check` AS `t1_c86`, `domain`.`id` AS `t2_c0`,
`domain`.`user_id` AS `t2_c1`, `domain`.`name` AS `t2_c2`, `domain`.`zone`
AS `t2_c3`, `domain`.`comment` AS `t2_c4`, `domain`.`date` AS `t2_c5`,
`userType`.`type_id` AS `t3_c0`, `userType`.`type_name` AS `t3_c1`,
`userType`.`type_url` AS `t3_c2`, `userType`.`is_performer` AS `t3_c3`,
`userType`.`type_name_form1` AS `t3_c4`, `userType`.`type_name_form2` AS
`t3_c5`, `userType`.`type_name_form3` AS `t3_c6`,
`userType`.`type_name_form4` AS `t3_c7`, `userType`.`type_name_form5` AS
`t3_c8`, `userType`.`type_name_form6` AS `t3_c9`,
`usersContacts`.`contact_id` AS `t4_c0`, `usersContacts`.`user_id` AS
`t4_c1`, `usersContacts`.`type_id` AS `t4_c2`,
`usersContacts`.`contact_name` AS `t4_c3`, `logo`.`logo_id` AS `t5_c0`,
`logo`.`user_id` AS `t5_c1`, `logo`.`file_id` AS `t5_c2`, `logo`.`logo_x1`
AS `t5_c3`, `logo`.`logo_y1` AS `t5_c4`, `logo`.`logo_x2` AS `t5_c5`,
`logo`.`logo_y2` AS `t5_c6`, `logo`.`logo_date` AS `t5_c7`,
`file`.`file_id` AS `t6_c0`, `file`.`file_parent_id` AS `t6_c1`,
`file`.`file_data` AS `t6_c2`, `file`.`file_requests` AS `t6_c3`,
`file`.`user_id` AS `t6_c4`, `file`.`file_path` AS `t6_c5`,
`file`.`file_extension` AS `t6_c6`, `file`.`file_size` AS `t6_c7`,
`file`.`file_md5` AS `t6_c8`, `file`.`file_mime_type` AS `t6_c9`,
`file`.`file_available` AS `t6_c10`, `file`.`file_date` AS `t6_c11`,
`file`.`status` AS `t6_c12`, `file`.`image_width` AS `t6_c13`,
`file`.`image_height` AS `t6_c14`, `file`.`convert` AS `t6_c15`,
`reviews`.`review_id` AS `t7_c0`, `reviews`.`performer_id` AS `t7_c1`,
`reviews`.`customer_id` AS `t7_c2`, `reviews`.`contract_id` AS `t7_c3`,
`reviews`.`review_rate` AS `t7_c4`, `reviews`.`review_rate_communication`
AS `t7_c5`, `reviews`.`review_rate_terms` AS `t7_c6`,
`reviews`.`review_rate_behavior` AS `t7_c7`,
`reviews`.`review_rate_quality` AS `t7_c8`,
`reviews`.`review_rate_documentation` AS `t7_c9`,
`reviews`.`review_rate_prices` AS `t7_c10`,
`reviews`.`review_info_positive` AS `t7_c11`,
`reviews`.`review_info_negative` AS `t7_c12`,
`reviews`.`review_info_conclusion` AS `t7_c13`, `reviews`.`review_status`
AS `t7_c14`, `reviews`.`review_date_create` AS `t7_c15` FROM
`services_prices` `t`  LEFT OUTER JOIN `users` `user` ON
(`t`.`user_id`=`user`.`user_id`)  LEFT OUTER JOIN `domains` `domain` ON
(`user`.`domain_id`=`domain`.`id`)  LEFT OUTER JOIN `users_types`
`userType` ON (`user`.`user_type`=`userType`.`type_id`)  LEFT OUTER JOIN
`users_contacts` `usersContacts` ON
(`usersContacts`.`user_id`=`user`.`user_id`)  LEFT OUTER JOIN `logos`
`logo` ON (`user`.`logo_id`=`logo`.`logo_id`)  LEFT OUTER JOIN `files`
`file` ON (`logo`.`file_id`=`file`.`file_id`)  LEFT OUTER JOIN `reviews`
`reviews` ON (`reviews`.`customer_id`=`user`.`user_id`)  WHERE
(t.service_price_id IN (:ycp7, :ycp8, :ycp9, :ycp10)) ORDER BY
user.user_vip DESC, service_price_date DESC)
09:54:02.001897 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`service_price_id` AS `t0_c0`,
`t`.`service_id` AS `t0_c1`, `t`.`user_id` AS `t0_c2`,
`t`.`service_price_offer` AS `t0_c3`, `t`.`service_price_date` AS `t0_c4`,
`user`.`user_id` AS `t1_c0`, `user`.`user_email` AS `t1_c1`,
`user`.`user_vip` AS `t1_c2`, `user`.`mailgun_verification` AS `t1_c3`,
`user`.`is_accepted` AS `t1_c4`, `user`.`is_valid` AS `t1_c5`,
`user`.`is_opened` AS `t1_c6`, `user`.`is_clicked` AS `t1_c7`,
`user`.`user_phone` AS `t1_c8`, `user`.`user_confirmed` AS `t1_c9`,
`user`.`send_notifications` AS `t1_c10`, `user`.`send_notifications_old` AS
`t1_c11`, `user`.`user_activity` AS `t1_c12`, `user`.`last_notification` AS
`t1_c13`, `user`.`user_password` AS `t1_c14`, `user`.`user_pro_date` AS
`t1_c15`, `user`.`user_pro_status` AS `t1_c16`, `user`.`first_login` AS
`t1_c17`, `user`.`user_phone_status` AS `t1_c18`, `user`.`user_data` AS
`t1_c19`, `user`.`user_hidden` AS `t1_c20`, `user`.`user_type` AS `t1_c21`,
`user`.`user_type_change` AS `t1_c22`, `user`.`user_notifications_interval`
AS `t1_c23`, `user`.`user_notifications_date` AS `t1_c24`,
`user`.`user_title` AS `t1_c25`, `user`.`post_id` AS `t1_c26`,
`user`.`user_name` AS `t1_c27`, `user`.`user_surname` AS `t1_c28`,
`user`.`user_patronymic` AS `t1_c29`, `user`.`user_site_address` AS
`t1_c30`, `user`.`user_site_informer` AS `t1_c31`,
`user`.`user_site_verification` AS `t1_c32`, `user`.`user_company_details`
AS `t1_c33`, `user`.`user_company_file` AS `t1_c34`,
`user`.`user_company_type` AS `t1_c35`, `user`.`user_seller` AS `t1_c36`,
`user`.`city_id` AS `t1_c37`, `user`.`area_id` AS `t1_c38`,
`user`.`metro_id` AS `t1_c39`, `user`.`user_address` AS `t1_c40`,
`user`.`user_street` AS `t1_c41`, `user`.`user_house` AS `t1_c42`,
`user`.`user_geo_address` AS `t1_c43`, `user`.`user_geo_lat` AS `t1_c44`,
`user`.`user_geo_lng` AS `t1_c45`, `user`.`user_post_index` AS `t1_c46`,
`user`.`work_clearing` AS `t1_c47`, `user`.`work_prepayment` AS `t1_c48`,
`user`.`work_contract` AS `t1_c49`, `user`.`user_workers` AS `t1_c50`,
`user`.`user_work_terms` AS `t1_c51`, `user`.`user_prepay_work` AS
`t1_c52`, `user`.`user_prepay_materials` AS `t1_c53`,
`user`.`user_need_review` AS `t1_c54`, `user`.`domain_id` AS `t1_c55`,
`user`.`logo_id` AS `t1_c56`, `user`.`user_rating` AS `t1_c57`,
`user`.`user_rating_verification` AS `t1_c58`, `user`.`user_info` AS
`t1_c59`, `user`.`user_schedule` AS `t1_c60`, `user`.`register_offer` AS
`t1_c61`, `user`.`news_subscription` AS `t1_c62`, `user`.`register_date` AS
`t1_c63`, `user`.`last_login` AS `t1_c64`, `user`.`block_lvl` AS `t1_c65`,
`user`.`unblock_date` AS `t1_c66`, `user`.`delete_account` AS `t1_c67`,
`user`.`delete_reason` AS `t1_c68`, `user`.`delete_text` AS `t1_c69`,
`user`.`delete_date` AS `t1_c70`, `user`.`account_status` AS `t1_c71`,
`user`.`user_access_lvl` AS `t1_c72`, `user`.`prices_count` AS `t1_c73`,
`user`.`photos_count` AS `t1_c74`, `user`.`tenders_count` AS `t1_c75`,
`user`.`comments_count` AS `t1_c76`, `user`.`user_bonus` AS `t1_c77`,
`user`.`user_is_active` AS `t1_c78`, `user`.`user_comment` AS `t1_c79`,
`user`.`user_checked` AS `t1_c80`, `user`.`user_marked` AS `t1_c81`,
`user`.`user_tmp` AS `t1_c82`, `user`.`is_remtrust` AS `t1_c83`,
`user`.`is_remtrust_pro` AS `t1_c84`, `user`.`user_inform_active` AS
`t1_c85`, `user`.`mailgun_check` AS `t1_c86`, `domain`.`id` AS `t2_c0`,
`domain`.`user_id` AS `t2_c1`, `domain`.`name` AS `t2_c2`, `domain`.`zone`
AS `t2_c3`, `domain`.`comment` AS `t2_c4`, `domain`.`date` AS `t2_c5`,
`userType`.`type_id` AS `t3_c0`, `userType`.`type_name` AS `t3_c1`,
`userType`.`type_url` AS `t3_c2`, `userType`.`is_performer` AS `t3_c3`,
`userType`.`type_name_form1` AS `t3_c4`, `userType`.`type_name_form2` AS
`t3_c5`, `userType`.`type_name_form3` AS `t3_c6`,
`userType`.`type_name_form4` AS `t3_c7`, `userType`.`type_name_form5` AS
`t3_c8`, `userType`.`type_name_form6` AS `t3_c9`,
`usersContacts`.`contact_id` AS `t4_c0`, `usersContacts`.`user_id` AS
`t4_c1`, `usersContacts`.`type_id` AS `t4_c2`,
`usersContacts`.`contact_name` AS `t4_c3`, `logo`.`logo_id` AS `t5_c0`,
`logo`.`user_id` AS `t5_c1`, `logo`.`file_id` AS `t5_c2`, `logo`.`logo_x1`
AS `t5_c3`, `logo`.`logo_y1` AS `t5_c4`, `logo`.`logo_x2` AS `t5_c5`,
`logo`.`logo_y2` AS `t5_c6`, `logo`.`logo_date` AS `t5_c7`,
`file`.`file_id` AS `t6_c0`, `file`.`file_parent_id` AS `t6_c1`,
`file`.`file_data` AS `t6_c2`, `file`.`file_requests` AS `t6_c3`,
`file`.`user_id` AS `t6_c4`, `file`.`file_path` AS `t6_c5`,
`file`.`file_extension` AS `t6_c6`, `file`.`file_size` AS `t6_c7`,
`file`.`file_md5` AS `t6_c8`, `file`.`file_mime_type` AS `t6_c9`,
`file`.`file_available` AS `t6_c10`, `file`.`file_date` AS `t6_c11`,
`file`.`status` AS `t6_c12`, `file`.`image_width` AS `t6_c13`,
`file`.`image_height` AS `t6_c14`, `file`.`convert` AS `t6_c15`,
`reviews`.`review_id` AS `t7_c0`, `reviews`.`performer_id` AS `t7_c1`,
`reviews`.`customer_id` AS `t7_c2`, `reviews`.`contract_id` AS `t7_c3`,
`reviews`.`review_rate` AS `t7_c4`, `reviews`.`review_rate_communication`
AS `t7_c5`, `reviews`.`review_rate_terms` AS `t7_c6`,
`reviews`.`review_rate_behavior` AS `t7_c7`,
`reviews`.`review_rate_quality` AS `t7_c8`,
`reviews`.`review_rate_documentation` AS `t7_c9`,
`reviews`.`review_rate_prices` AS `t7_c10`,
`reviews`.`review_info_positive` AS `t7_c11`,
`reviews`.`review_info_negative` AS `t7_c12`,
`reviews`.`review_info_conclusion` AS `t7_c13`, `reviews`.`review_status`
AS `t7_c14`, `reviews`.`review_date_create` AS `t7_c15` FROM
`services_prices` `t`  LEFT OUTER JOIN `users` `user` ON
(`t`.`user_id`=`user`.`user_id`)  LEFT OUTER JOIN `domains` `domain` ON
(`user`.`domain_id`=`domain`.`id`)  LEFT OUTER JOIN `users_types`
`userType` ON (`user`.`user_type`=`userType`.`type_id`)  LEFT OUTER JOIN
`users_contacts` `usersContacts` ON
(`usersContacts`.`user_id`=`user`.`user_id`)  LEFT OUTER JOIN `logos`
`logo` ON (`user`.`logo_id`=`logo`.`logo_id`)  LEFT OUTER JOIN `files`
`file` ON (`logo`.`file_id`=`file`.`file_id`)  LEFT OUTER JOIN `reviews`
`reviews` ON (`reviews`.`customer_id`=`user`.`user_id`)  WHERE
(t.service_price_id IN (:ycp7, :ycp8, :ycp9, :ycp10)) ORDER BY
user.user_vip DESC, service_price_date DESC)
09:54:02.005301 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`city_id` AS `t0_c0`,
`t`.`region_id` AS `t0_c1`, `t`.`city_name` AS `t0_c2`, `t`.`city_url` AS
`t0_c3`, `t`.`city_geo_lat` AS `t0_c4`, `t`.`city_geo_lng` AS `t0_c5`,
`t`.`city_type` AS `t0_c6`, `t`.`city_sort` AS `t0_c7`,
`t`.`city_ads_priority` AS `t0_c8`, `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_cities` `t`  LEFT OUTER JOIN `geo_regions` `region` ON
(`t`.`region_id`=`region`.`region_id`)  WHERE (t.city_id = region.city_id
AND region.country_id = :country_id) ORDER BY t.city_sort DESC, t.city_id)
09:54:02.006551 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`city_id` AS `t0_c0`,
`t`.`region_id` AS `t0_c1`, `t`.`city_name` AS `t0_c2`, `t`.`city_url` AS
`t0_c3`, `t`.`city_geo_lat` AS `t0_c4`, `t`.`city_geo_lng` AS `t0_c5`,
`t`.`city_type` AS `t0_c6`, `t`.`city_sort` AS `t0_c7`,
`t`.`city_ads_priority` AS `t0_c8`, `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_cities` `t`  LEFT OUTER JOIN `geo_regions` `region` ON
(`t`.`region_id`=`region`.`region_id`)  WHERE (t.city_id = region.city_id
AND region.country_id = :country_id) ORDER BY t.city_sort DESC, t.city_id)
09:54:02.014527 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`city_id` AS `t0_c0`,
`t`.`region_id` AS `t0_c1`, `t`.`city_name` AS `t0_c2`, `t`.`city_url` AS
`t0_c3`, `t`.`city_geo_lat` AS `t0_c4`, `t`.`city_geo_lng` AS `t0_c5`,
`t`.`city_type` AS `t0_c6`, `t`.`city_sort` AS `t0_c7`,
`t`.`city_ads_priority` AS `t0_c8`, `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4`,
`users`.`user_id` AS `t2_c0`, `users`.`user_email` AS `t2_c1`,
`users`.`user_vip` AS `t2_c2`, `users`.`mailgun_verification` AS `t2_c3`,
`users`.`is_accepted` AS `t2_c4`, `users`.`is_valid` AS `t2_c5`,
`users`.`is_opened` AS `t2_c6`, `users`.`is_clicked` AS `t2_c7`,
`users`.`user_phone` AS `t2_c8`, `users`.`user_confirmed` AS `t2_c9`,
`users`.`send_notifications` AS `t2_c10`, `users`.`send_notifications_old`
AS `t2_c11`, `users`.`user_activity` AS `t2_c12`,
`users`.`last_notification` AS `t2_c13`, `users`.`user_password` AS
`t2_c14`, `users`.`user_pro_date` AS `t2_c15`, `users`.`user_pro_status` AS
`t2_c16`, `users`.`first_login` AS `t2_c17`, `users`.`user_phone_status` AS
`t2_c18`, `users`.`user_data` AS `t2_c19`, `users`.`user_hidden` AS
`t2_c20`, `users`.`user_type` AS `t2_c21`, `users`.`user_type_change` AS
`t2_c22`, `users`.`user_notifications_interval` AS `t2_c23`,
`users`.`user_notifications_date` AS `t2_c24`, `users`.`user_title` AS
`t2_c25`, `users`.`post_id` AS `t2_c26`, `users`.`user_name` AS `t2_c27`,
`users`.`user_surname` AS `t2_c28`, `users`.`user_patronymic` AS `t2_c29`,
`users`.`user_site_address` AS `t2_c30`, `users`.`user_site_informer` AS
`t2_c31`, `users`.`user_site_verification` AS `t2_c32`,
`users`.`user_company_details` AS `t2_c33`, `users`.`user_company_file` AS
`t2_c34`, `users`.`user_company_type` AS `t2_c35`, `users`.`user_seller` AS
`t2_c36`, `users`.`city_id` AS `t2_c37`, `users`.`area_id` AS `t2_c38`,
`users`.`metro_id` AS `t2_c39`, `users`.`user_address` AS `t2_c40`,
`users`.`user_street` AS `t2_c41`, `users`.`user_house` AS `t2_c42`,
`users`.`user_geo_address` AS `t2_c43`, `users`.`user_geo_lat` AS `t2_c44`,
`users`.`user_geo_lng` AS `t2_c45`, `users`.`user_post_index` AS `t2_c46`,
`users`.`work_clearing` AS `t2_c47`, `users`.`work_prepayment` AS `t2_c48`,
`users`.`work_contract` AS `t2_c49`, `users`.`user_workers` AS `t2_c50`,
`users`.`user_work_terms` AS `t2_c51`, `users`.`user_prepay_work` AS
`t2_c52`, `users`.`user_prepay_materials` AS `t2_c53`,
`users`.`user_need_review` AS `t2_c54`, `users`.`domain_id` AS `t2_c55`,
`users`.`logo_id` AS `t2_c56`, `users`.`user_rating` AS `t2_c57`,
`users`.`user_rating_verification` AS `t2_c58`, `users`.`user_info` AS
`t2_c59`, `users`.`user_schedule` AS `t2_c60`, `users`.`register_offer` AS
`t2_c61`, `users`.`news_subscription` AS `t2_c62`, `users`.`register_date`
AS `t2_c63`, `users`.`last_login` AS `t2_c64`, `users`.`block_lvl` AS
`t2_c65`, `users`.`unblock_date` AS `t2_c66`, `users`.`delete_account` AS
`t2_c67`, `users`.`delete_reason` AS `t2_c68`, `users`.`delete_text` AS
`t2_c69`, `users`.`delete_date` AS `t2_c70`, `users`.`account_status` AS
`t2_c71`, `users`.`user_access_lvl` AS `t2_c72`, `users`.`prices_count` AS
`t2_c73`, `users`.`photos_count` AS `t2_c74`, `users`.`tenders_count` AS
`t2_c75`, `users`.`comments_count` AS `t2_c76`, `users`.`user_bonus` AS
`t2_c77`, `users`.`user_is_active` AS `t2_c78`, `users`.`user_comment` AS
`t2_c79`, `users`.`user_checked` AS `t2_c80`, `users`.`user_marked` AS
`t2_c81`, `users`.`user_tmp` AS `t2_c82`, `users`.`is_remtrust` AS
`t2_c83`, `users`.`is_remtrust_pro` AS `t2_c84`,
`users`.`user_inform_active` AS `t2_c85`, `users`.`mailgun_check` AS
`t2_c86`, `servicesPrices`.`service_price_id` AS `t3_c0`,
`servicesPrices`.`service_id` AS `t3_c1`, `servicesPrices`.`user_id` AS
`t3_c2`, `servicesPrices`.`service_price_offer` AS `t3_c3`,
`servicesPrices`.`service_price_date` AS `t3_c4` FROM `geo_cities` `t` 
LEFT OUTER JOIN `geo_regions` `region` ON
(`t`.`region_id`=`region`.`region_id`)  LEFT OUTER JOIN `users` `users` ON
(`users`.`city_id`=`t`.`city_id`)  LEFT OUTER JOIN `services_prices`
`servicesPrices` ON (`servicesPrices`.`user_id`=`users`.`user_id`)  WHERE
(((t.city_id <> region.city_id) AND (servicesPrices.service_id=:ycp11)) AND
(region.country_id=:ycp12)) GROUP BY t.city_id)
09:54:02.017980 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`city_id` AS `t0_c0`,
`t`.`region_id` AS `t0_c1`, `t`.`city_name` AS `t0_c2`, `t`.`city_url` AS
`t0_c3`, `t`.`city_geo_lat` AS `t0_c4`, `t`.`city_geo_lng` AS `t0_c5`,
`t`.`city_type` AS `t0_c6`, `t`.`city_sort` AS `t0_c7`,
`t`.`city_ads_priority` AS `t0_c8`, `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4`,
`users`.`user_id` AS `t2_c0`, `users`.`user_email` AS `t2_c1`,
`users`.`user_vip` AS `t2_c2`, `users`.`mailgun_verification` AS `t2_c3`,
`users`.`is_accepted` AS `t2_c4`, `users`.`is_valid` AS `t2_c5`,
`users`.`is_opened` AS `t2_c6`, `users`.`is_clicked` AS `t2_c7`,
`users`.`user_phone` AS `t2_c8`, `users`.`user_confirmed` AS `t2_c9`,
`users`.`send_notifications` AS `t2_c10`, `users`.`send_notifications_old`
AS `t2_c11`, `users`.`user_activity` AS `t2_c12`,
`users`.`last_notification` AS `t2_c13`, `users`.`user_password` AS
`t2_c14`, `users`.`user_pro_date` AS `t2_c15`, `users`.`user_pro_status` AS
`t2_c16`, `users`.`first_login` AS `t2_c17`, `users`.`user_phone_status` AS
`t2_c18`, `users`.`user_data` AS `t2_c19`, `users`.`user_hidden` AS
`t2_c20`, `users`.`user_type` AS `t2_c21`, `users`.`user_type_change` AS
`t2_c22`, `users`.`user_notifications_interval` AS `t2_c23`,
`users`.`user_notifications_date` AS `t2_c24`, `users`.`user_title` AS
`t2_c25`, `users`.`post_id` AS `t2_c26`, `users`.`user_name` AS `t2_c27`,
`users`.`user_surname` AS `t2_c28`, `users`.`user_patronymic` AS `t2_c29`,
`users`.`user_site_address` AS `t2_c30`, `users`.`user_site_informer` AS
`t2_c31`, `users`.`user_site_verification` AS `t2_c32`,
`users`.`user_company_details` AS `t2_c33`, `users`.`user_company_file` AS
`t2_c34`, `users`.`user_company_type` AS `t2_c35`, `users`.`user_seller` AS
`t2_c36`, `users`.`city_id` AS `t2_c37`, `users`.`area_id` AS `t2_c38`,
`users`.`metro_id` AS `t2_c39`, `users`.`user_address` AS `t2_c40`,
`users`.`user_street` AS `t2_c41`, `users`.`user_house` AS `t2_c42`,
`users`.`user_geo_address` AS `t2_c43`, `users`.`user_geo_lat` AS `t2_c44`,
`users`.`user_geo_lng` AS `t2_c45`, `users`.`user_post_index` AS `t2_c46`,
`users`.`work_clearing` AS `t2_c47`, `users`.`work_prepayment` AS `t2_c48`,
`users`.`work_contract` AS `t2_c49`, `users`.`user_workers` AS `t2_c50`,
`users`.`user_work_terms` AS `t2_c51`, `users`.`user_prepay_work` AS
`t2_c52`, `users`.`user_prepay_materials` AS `t2_c53`,
`users`.`user_need_review` AS `t2_c54`, `users`.`domain_id` AS `t2_c55`,
`users`.`logo_id` AS `t2_c56`, `users`.`user_rating` AS `t2_c57`,
`users`.`user_rating_verification` AS `t2_c58`, `users`.`user_info` AS
`t2_c59`, `users`.`user_schedule` AS `t2_c60`, `users`.`register_offer` AS
`t2_c61`, `users`.`news_subscription` AS `t2_c62`, `users`.`register_date`
AS `t2_c63`, `users`.`last_login` AS `t2_c64`, `users`.`block_lvl` AS
`t2_c65`, `users`.`unblock_date` AS `t2_c66`, `users`.`delete_account` AS
`t2_c67`, `users`.`delete_reason` AS `t2_c68`, `users`.`delete_text` AS
`t2_c69`, `users`.`delete_date` AS `t2_c70`, `users`.`account_status` AS
`t2_c71`, `users`.`user_access_lvl` AS `t2_c72`, `users`.`prices_count` AS
`t2_c73`, `users`.`photos_count` AS `t2_c74`, `users`.`tenders_count` AS
`t2_c75`, `users`.`comments_count` AS `t2_c76`, `users`.`user_bonus` AS
`t2_c77`, `users`.`user_is_active` AS `t2_c78`, `users`.`user_comment` AS
`t2_c79`, `users`.`user_checked` AS `t2_c80`, `users`.`user_marked` AS
`t2_c81`, `users`.`user_tmp` AS `t2_c82`, `users`.`is_remtrust` AS
`t2_c83`, `users`.`is_remtrust_pro` AS `t2_c84`,
`users`.`user_inform_active` AS `t2_c85`, `users`.`mailgun_check` AS
`t2_c86`, `servicesPrices`.`service_price_id` AS `t3_c0`,
`servicesPrices`.`service_id` AS `t3_c1`, `servicesPrices`.`user_id` AS
`t3_c2`, `servicesPrices`.`service_price_offer` AS `t3_c3`,
`servicesPrices`.`service_price_date` AS `t3_c4` FROM `geo_cities` `t` 
LEFT OUTER JOIN `geo_regions` `region` ON
(`t`.`region_id`=`region`.`region_id`)  LEFT OUTER JOIN `users` `users` ON
(`users`.`city_id`=`t`.`city_id`)  LEFT OUTER JOIN `services_prices`
`servicesPrices` ON (`servicesPrices`.`user_id`=`users`.`user_id`)  WHERE
(((t.city_id <> region.city_id) AND (servicesPrices.service_id=:ycp11)) AND
(region.country_id=:ycp12)) GROUP BY t.city_id)
09:54:02.019095 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`service_id` AS `t0_c0`,
`t`.`service_name` AS `t0_c1`, `t`.`service_url` AS `t0_c2`,
`t`.`service_gradation_id` AS `t0_c3`, `t`.`user_id` AS `t0_c4`,
`t`.`service_priority` AS `t0_c5`, `t`.`service_date` AS `t0_c6`,
`t`.`service_banner` AS `t0_c7`, `servicesCategories`.`category_id` AS
`t1_c0`, `servicesCategories`.`category_name` AS `t1_c1`,
`servicesCategories`.`category_url` AS `t1_c2`,
`servicesCategories`.`category_caption` AS `t1_c3`,
`servicesCategories`.`category_title` AS `t1_c4`,
`servicesCategories`.`category_description` AS `t1_c5`,
`servicesCategories`.`category_sort` AS `t1_c6`,
`servicesCategories`.`service_category_title` AS `t1_c7`,
`servicesCategories`.`category_parent_id` AS `t1_c8`,
`servicesCategories`.`category_seo_type` AS `t1_c9`,
`servicesCategories`.`category_seo_priority` AS `t1_c10`,
`servicesCategories`.`visibility` AS `t1_c11` FROM `services` `t`  LEFT
OUTER JOIN `services_to_categories` `servicesCategories_servicesCategories`
ON (`t`.`service_id`=`servicesCategories_servicesCategories`.`service_id`)
LEFT OUTER JOIN `services_categories` `servicesCategories` ON
(`servicesCategories`.`category_id`=`servicesCategories_servicesCategories`.`service_category_id`)
 WHERE (t.user_id IS NULL AND servicesCategories.category_id =
:category_id) ORDER BY t.service_id)
09:54:02.020056 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`service_id` AS `t0_c0`,
`t`.`service_name` AS `t0_c1`, `t`.`service_url` AS `t0_c2`,
`t`.`service_gradation_id` AS `t0_c3`, `t`.`user_id` AS `t0_c4`,
`t`.`service_priority` AS `t0_c5`, `t`.`service_date` AS `t0_c6`,
`t`.`service_banner` AS `t0_c7`, `servicesCategories`.`category_id` AS
`t1_c0`, `servicesCategories`.`category_name` AS `t1_c1`,
`servicesCategories`.`category_url` AS `t1_c2`,
`servicesCategories`.`category_caption` AS `t1_c3`,
`servicesCategories`.`category_title` AS `t1_c4`,
`servicesCategories`.`category_description` AS `t1_c5`,
`servicesCategories`.`category_sort` AS `t1_c6`,
`servicesCategories`.`service_category_title` AS `t1_c7`,
`servicesCategories`.`category_parent_id` AS `t1_c8`,
`servicesCategories`.`category_seo_type` AS `t1_c9`,
`servicesCategories`.`category_seo_priority` AS `t1_c10`,
`servicesCategories`.`visibility` AS `t1_c11` FROM `services` `t`  LEFT
OUTER JOIN `services_to_categories` `servicesCategories_servicesCategories`
ON (`t`.`service_id`=`servicesCategories_servicesCategories`.`service_id`)
LEFT OUTER JOIN `services_categories` `servicesCategories` ON
(`servicesCategories`.`category_id`=`servicesCategories_servicesCategories`.`service_category_id`)
 WHERE (t.user_id IS NULL AND servicesCategories.category_id =
:category_id) ORDER BY t.service_id)
09:54:02.021465 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `geo_countries` `t` WHERE
country_id != :country_id AND country_id != 3)
09:54:02.021898 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `geo_countries` `t` WHERE
country_id != :country_id AND country_id != 3)
09:54:02.022088 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `t`.`service_id`
FROM `services` `t`
JOIN `services_to_categories` ON services_to_categories.service_id =
t.service_id
WHERE t.user_id IS NULL AND services_to_categories.service_category_id =
:category_id)
09:54:02.022882 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `t`.`service_id`
FROM `services` `t`
JOIN `services_to_categories` ON services_to_categories.service_id =
t.service_id
WHERE t.user_id IS NULL AND services_to_categories.service_category_id =
:category_id)
09:54:02.023542 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT * FROM `services` `t` WHERE
service_id IN (:ycp13, :ycp14, :ycp15, :ycp16, :ycp17))
09:54:02.024048 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT * FROM `services` `t` WHERE
service_id IN (:ycp13, :ycp14, :ycp15, :ycp16, :ycp17))
09:54:02.024729 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT t.service_id,
AVG(service_price_offer) as avg
FROM `services_prices` `t`
JOIN `users` ON users.user_id = t.user_id
LEFT JOIN `geo_cities` ON geo_cities.city_id = users.city_id
LEFT JOIN `geo_regions` ON geo_regions.region_id = geo_cities.region_id
WHERE (t.service_id IN(1498,3331,9475,9484,9487)) AND
(geo_regions.country_id = :country_id)
GROUP BY `t`.`service_id`
ORDER BY `service_id`)
09:54:02.026576 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT t.service_id,
AVG(service_price_offer) as avg
FROM `services_prices` `t`
JOIN `users` ON users.user_id = t.user_id
LEFT JOIN `geo_cities` ON geo_cities.city_id = users.city_id
LEFT JOIN `geo_regions` ON geo_regions.region_id = geo_cities.region_id
WHERE (t.service_id IN(1498,3331,9475,9484,9487)) AND
(geo_regions.country_id = :country_id)
GROUP BY `t`.`service_id`
ORDER BY `service_id`)
09:54:02.034626 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.035260 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.035854 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.036230 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.036746 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.037283 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.048552 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.049094 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.049686 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.049985 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.050515 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.051043 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.053814 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.054157 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.054502 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.054863 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.055810 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.056274 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.058404 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.058712 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `city`.`city_id` AS `t1_c0`,
`city`.`region_id` AS `t1_c1`, `city`.`city_name` AS `t1_c2`,
`city`.`city_url` AS `t1_c3`, `city`.`city_geo_lat` AS `t1_c4`,
`city`.`city_geo_lng` AS `t1_c5`, `city`.`city_type` AS `t1_c6`,
`city`.`city_sort` AS `t1_c7`, `city`.`city_ads_priority` AS `t1_c8` FROM
`geo_cities` `city`  WHERE (`city`.`city_id`=:ypl0))
09:54:02.058936 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.059273 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `region`.`region_id` AS `t1_c0`,
`region`.`country_id` AS `t1_c1`, `region`.`region_name` AS `t1_c2`,
`region`.`city_id` AS `t1_c3`, `region`.`region_url` AS `t1_c4` FROM
`geo_regions` `region`  WHERE (`region`.`region_id`=:ypl0))
09:54:02.059488 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.059948 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT `country`.`country_id` AS `t1_c0`,
`country`.`country_name` AS `t1_c1`, `country`.`country_geo_lat` AS
`t1_c2`, `country`.`country_geo_lng` AS `t1_c3`, `country`.`city_id` AS
`t1_c4`, `country`.`capital_id` AS `t1_c5`, `country`.`country_code` AS
`t1_c6`, `country`.`country_domain` AS `t1_c7`,
`country`.`country_language` AS `t1_c8`, `country`.`country_new_domain` AS
`t1_c9`, `country`.`country_currency` AS `t1_c10`,
`country`.`country_phone_mask` AS `t1_c11`,
`country`.`country_main_article` AS `t1_c12`,
`country`.`country_tenders_article` AS `t1_c13`,
`country`.`country_users_subtext` AS `t1_c14`,
`country`.`country_price_article` AS `t1_c15`,
`country`.`country_price_subtext` AS `t1_c16`,
`country`.`country_payments_config` AS `t1_c17`,
`country`.`country_jivosite_code` AS `t1_c18` FROM `geo_countries`
`country`  WHERE (`country`.`country_id`=:ypl0))
09:54:02.067827 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.068420 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.068954 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.069282 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.069694 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.069984 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.070453 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.070774 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.071245 profile system.db.CDbCommand.query
begin:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.071516 profile system.db.CDbCommand.query
end:system.db.CDbCommand.query(SELECT
`serviceGradation`.`service_gradation_id` AS `t1_c0`,
`serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services_gradations` `serviceGradation`  WHERE
(`serviceGradation`.`service_gradation_id`=:ypl0))
09:54:02.078562 trace system.db.ar.CActiveRecord
Users.count() eagerly
09:54:02.079724 trace system.caching.CFileCache
Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
COUNT(DISTINCT `t`.`user_id`) FROM `users` `t`  LEFT OUTER JOIN
`geo_cities` `city` ON (`t`.`city_id`=`city`.`city_id`)  LEFT OUTER JOIN
`geo_regions` `region` ON (`city`.`region_id`=`region`.`region_id`)  WHERE
(t.user_type <> 1 AND region.country_id =
:country_id):a:1:{s:11:":country_id";s:1:"1";}" from cache
09:54:02.081501 trace system.caching.CFileCache
Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:tenders" from
cache
09:54:02.081995 trace system.db.ar.CActiveRecord
Tenders.count() eagerly
09:54:02.082793 trace system.caching.CFileCache
Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
COUNT(DISTINCT `t`.`tender_id`) FROM `tenders` `t`  LEFT OUTER JOIN
`geo_cities` `city` ON (`t`.`city_id`=`city`.`city_id`)  LEFT OUTER JOIN
`geo_regions` `region` ON (`city`.`region_id`=`region`.`region_id`)  WHERE
(region.country_id = :country_id):a:1:{s:11:":country_id";s:1:"1";}" from
cache
09:54:02.083194 trace system.caching.CFileCache
Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
COUNT(*) FROM `services` `t` WHERE t.user_id IS NULL:a:0:{}" from cache