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:"mk";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)

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 `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 (users.city_id = :city_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 `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 (users.city_id = :city_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)) 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)) 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

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