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

begin:system.db.CDbCommand.query(SELECT t.service_id,
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`
LEFT JOIN `users` ON users.user_id = t.user_id
LEFT JOIN `services` ON services.service_id = t.service_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
LEFT JOIN `services_to_categories` ON services_to_categories.service_id =
t.service_id
LEFT JOIN `services_categories` ON services_categories.category_id =
services_to_categories.service_category_id
WHERE ((services.user_id IS NULL) AND (geo_regions.country_id =
:country_id)) AND (services_categories.category_parent_id =
:category_parent_id)
GROUP BY `t`.`service_id`)

end:system.db.CDbCommand.query(SELECT t.service_id,
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`
LEFT JOIN `users` ON users.user_id = t.user_id
LEFT JOIN `services` ON services.service_id = t.service_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
LEFT JOIN `services_to_categories` ON services_to_categories.service_id =
t.service_id
LEFT JOIN `services_categories` ON services_categories.category_id =
services_to_categories.service_category_id
WHERE ((services.user_id IS NULL) AND (geo_regions.country_id =
:country_id)) AND (services_categories.category_parent_id =
:category_parent_id)
GROUP BY `t`.`service_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

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`, `serviceGradation`.`service_gradation_id`
AS `t1_c0`, `serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services` `t`  STRAIGHT_JOIN `services_gradations` `serviceGradation` ON
(`t`.`service_gradation_id`=`serviceGradation`.`service_gradation_id`) 
WHERE ((t.service_id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6,
:ycp7, :ycp8, :ycp9, :ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15,
:ycp16, :ycp17, :ycp18, :ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24,
:ycp25, :ycp26, :ycp27, :ycp28, :ycp29, :ycp30, :ycp31, :ycp32, :ycp33,
:ycp34, :ycp35, :ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41, :ycp42,
:ycp43, :ycp44, :ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50, :ycp51))
AND (t.user_id IS NULL)) ORDER BY service_priority DESC LIMIT 20)

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`, `serviceGradation`.`service_gradation_id`
AS `t1_c0`, `serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services` `t`  STRAIGHT_JOIN `services_gradations` `serviceGradation` ON
(`t`.`service_gradation_id`=`serviceGradation`.`service_gradation_id`) 
WHERE ((t.service_id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6,
:ycp7, :ycp8, :ycp9, :ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15,
:ycp16, :ycp17, :ycp18, :ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24,
:ycp25, :ycp26, :ycp27, :ycp28, :ycp29, :ycp30, :ycp31, :ycp32, :ycp33,
:ycp34, :ycp35, :ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41, :ycp42,
:ycp43, :ycp44, :ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50, :ycp51))
AND (t.user_id IS NULL)) ORDER BY service_priority DESC LIMIT 20)

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

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

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