Архитектурный проект в Житомир

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users_categories"
from cache

begin:system.db.CDbCommand.query(SELECT * FROM `users_categories` `t`)

end:system.db.CDbCommand.query(SELECT * FROM `users_categories` `t`)

Serving "Yii.CUrlManager.rules" from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_countries"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_cities"
from cache

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

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_regions"
from cache

Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere: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_url = :city_url AND
region.country_id =
:country_id):a:2:{s:9:":city_url";s:2:"zt";s:11:":country_id";s:1:"1";}"
from cache

Serving "yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:logs"
from cache

begin:system.db.CDbCommand.execute(INSERT INTO `logs` (`url`, `code`,
`referer`, `ip`, `agent`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4,
:yp5))

end:system.db.CDbCommand.execute(INSERT INTO `logs` (`url`, `code`,
`referer`, `ip`, `agent`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4,
:yp5))

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_categories"
from cache

begin:system.db.CDbCommand.query(SELECT * FROM `services_categories` `t`
WHERE visibility = 1 ORDER BY category_sort, category_name, category_id)

end:system.db.CDbCommand.query(SELECT * FROM `services_categories` `t`
WHERE visibility = 1 ORDER BY category_sort, category_name, category_id)

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_gradations"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_articles"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_to_categories"
from cache

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)))

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)))

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:tenders_tmp"
from cache

begin:system.db.CDbCommand.query(SELECT * FROM `tenders_tmp` `t` WHERE
link_omastere_request=:ycp1 ORDER BY id LIMIT 100 OFFSET 5)

end:system.db.CDbCommand.query(SELECT * FROM `tenders_tmp` `t` WHERE
link_omastere_request=:ycp1 ORDER BY id LIMIT 100 OFFSET 5)

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
WHERE (t.service_id = :service_id) AND (users.city_id = :city_id)
GROUP BY `t`.`service_id`)

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
WHERE (t.service_id = :service_id) AND (users.city_id = :city_id)
GROUP BY `t`.`service_id`)

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_prices"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users" from
cache

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=:ycp2) AND (city.city_id=:ycp3)) AND
(service_id=:ycp4)) ORDER BY user.user_pro_date DESC, user.user_rating DESC
LIMIT 10)

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=:ycp2) AND (city.city_id=:ycp3)) AND
(service_id=:ycp4)) ORDER BY user.user_pro_date DESC, user.user_rating DESC
LIMIT 10)

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:domains" from
cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users_types"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users_contacts"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:logos" from
cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:files" from
cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:reviews" from
cache

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=:ycp5) ORDER BY user.user_vip DESC, service_price_date
DESC)

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=:ycp5) ORDER BY user.user_vip DESC, service_price_date
DESC)

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)

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)

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=:ycp6)) AND
(region.country_id=:ycp7)) GROUP BY t.city_id)

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=:ycp6)) AND
(region.country_id=:ycp7)) GROUP BY t.city_id)

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)

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)

begin:system.db.CDbCommand.query(SELECT * FROM `geo_countries` `t` WHERE
country_id != :country_id AND country_id != 3)

end:system.db.CDbCommand.query(SELECT * FROM `geo_countries` `t` WHERE
country_id != :country_id AND country_id != 3)

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)

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)

begin:system.db.CDbCommand.query(SELECT * FROM `services` `t` WHERE
service_id IN (:ycp8, :ycp9, :ycp10, :ycp11, :ycp12))

end:system.db.CDbCommand.query(SELECT * FROM `services` `t` WHERE
service_id IN (:ycp8, :ycp9, :ycp10, :ycp11, :ycp12))

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(1519,3037,3373,3394,8478)) AND
(geo_regions.country_id = :country_id)
GROUP BY `t`.`service_id`
ORDER BY `service_id`)

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(1519,3037,3373,3394,8478)) AND
(geo_regions.country_id = :country_id)
GROUP BY `t`.`service_id`
ORDER BY `service_id`)

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))

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))

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))

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))

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))

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))

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))

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))

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))

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))

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))

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))

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))

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))

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))

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))

Users.count() eagerly

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

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:tenders" from
cache

Tenders.count() eagerly

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

Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
COUNT(*) FROM `services` `t` WHERE t.user_id IS NULL:a:0:{}" from cache