Частные строительные тендеры и заказы

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:tenders_categories"
from cache

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

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

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

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

Tenders.count() eagerly

begin:system.db.CDbCommand.query(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=:ycp0)
AND (t.tender_status=:ycp1)))

end:system.db.CDbCommand.query(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=:ycp0)
AND (t.tender_status=:ycp1)))

begin:system.db.CDbCommand.query(SELECT `t`.`tender_id` AS `t0_c0`,
`t`.`user_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`old_city_id` AS
`t0_c3`, `t`.`tender_type` AS `t0_c4`, `t`.`tender_street` AS `t0_c5`,
`t`.`tender_house` AS `t0_c6`, `t`.`tender_geo_lat` AS `t0_c7`,
`t`.`tender_geo_lng` AS `t0_c8`, `t`.`tender_geo` AS `t0_c9`,
`t`.`tender_name` AS `t0_c10`, `t`.`tender_url` AS `t0_c11`,
`t`.`tender_text` AS `t0_c12`, `t`.`tender_budget` AS `t0_c13`,
`t`.`tender_commission` AS `t0_c14`, `t`.`tender_period` AS `t0_c15`,
`t`.`estimate_id` AS `t0_c16`, `t`.`file_id` AS `t0_c17`,
`t`.`tender_is_dealer` AS `t0_c18`, `t`.`tender_hide_phone` AS `t0_c19`,
`t`.`tender_create_date` AS `t0_c20`, `t`.`tender_update_date` AS `t0_c21`,
`t`.`tender_expiration_date` AS `t0_c22`, `t`.`tender_last_visit_date` AS
`t0_c23`, `t`.`tender_status` AS `t0_c24`, `t`.`comment_id` AS `t0_c25`,
`t`.`tender_referer` AS `t0_c26`, `t`.`customer_review_id` AS `t0_c27`,
`t`.`performer_review_id` AS `t0_c28`, `t`.`tender_views` AS `t0_c29`,
`t`.`comments_count` AS `t0_c30`, `t`.`char_LENGTH` AS `t0_c31`,
`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`, `region`.`region_id` AS `t2_c0`,
`region`.`country_id` AS `t2_c1`, `region`.`region_name` AS `t2_c2`,
`region`.`city_id` AS `t2_c3`, `region`.`region_url` AS `t2_c4` 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=:ycp0)
AND (t.tender_status=:ycp1)) ORDER BY t.tender_status, t.tender_update_date
DESC LIMIT 15 OFFSET 75)

end:system.db.CDbCommand.query(SELECT `t`.`tender_id` AS `t0_c0`,
`t`.`user_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`old_city_id` AS
`t0_c3`, `t`.`tender_type` AS `t0_c4`, `t`.`tender_street` AS `t0_c5`,
`t`.`tender_house` AS `t0_c6`, `t`.`tender_geo_lat` AS `t0_c7`,
`t`.`tender_geo_lng` AS `t0_c8`, `t`.`tender_geo` AS `t0_c9`,
`t`.`tender_name` AS `t0_c10`, `t`.`tender_url` AS `t0_c11`,
`t`.`tender_text` AS `t0_c12`, `t`.`tender_budget` AS `t0_c13`,
`t`.`tender_commission` AS `t0_c14`, `t`.`tender_period` AS `t0_c15`,
`t`.`estimate_id` AS `t0_c16`, `t`.`file_id` AS `t0_c17`,
`t`.`tender_is_dealer` AS `t0_c18`, `t`.`tender_hide_phone` AS `t0_c19`,
`t`.`tender_create_date` AS `t0_c20`, `t`.`tender_update_date` AS `t0_c21`,
`t`.`tender_expiration_date` AS `t0_c22`, `t`.`tender_last_visit_date` AS
`t0_c23`, `t`.`tender_status` AS `t0_c24`, `t`.`comment_id` AS `t0_c25`,
`t`.`tender_referer` AS `t0_c26`, `t`.`customer_review_id` AS `t0_c27`,
`t`.`performer_review_id` AS `t0_c28`, `t`.`tender_views` AS `t0_c29`,
`t`.`comments_count` AS `t0_c30`, `t`.`char_LENGTH` AS `t0_c31`,
`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`, `region`.`region_id` AS `t2_c0`,
`region`.`country_id` AS `t2_c1`, `region`.`region_name` AS `t2_c2`,
`region`.`city_id` AS `t2_c3`, `region`.`region_url` AS `t2_c4` 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=:ycp0)
AND (t.tender_status=:ycp1)) ORDER BY t.tender_status, t.tender_update_date
DESC LIMIT 15 OFFSET 75)

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

begin:system.db.CDbCommand.query(SELECT `t`.`tender_id` AS `t0_c0`,
`t`.`user_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`old_city_id` AS
`t0_c3`, `t`.`tender_type` AS `t0_c4`, `t`.`tender_street` AS `t0_c5`,
`t`.`tender_house` AS `t0_c6`, `t`.`tender_geo_lat` AS `t0_c7`,
`t`.`tender_geo_lng` AS `t0_c8`, `t`.`tender_geo` AS `t0_c9`,
`t`.`tender_name` AS `t0_c10`, `t`.`tender_url` AS `t0_c11`,
`t`.`tender_text` AS `t0_c12`, `t`.`tender_budget` AS `t0_c13`,
`t`.`tender_commission` AS `t0_c14`, `t`.`tender_period` AS `t0_c15`,
`t`.`estimate_id` AS `t0_c16`, `t`.`file_id` AS `t0_c17`,
`t`.`tender_is_dealer` AS `t0_c18`, `t`.`tender_hide_phone` AS `t0_c19`,
`t`.`tender_create_date` AS `t0_c20`, `t`.`tender_update_date` AS `t0_c21`,
`t`.`tender_expiration_date` AS `t0_c22`, `t`.`tender_last_visit_date` AS
`t0_c23`, `t`.`tender_status` AS `t0_c24`, `t`.`comment_id` AS `t0_c25`,
`t`.`tender_referer` AS `t0_c26`, `t`.`customer_review_id` AS `t0_c27`,
`t`.`performer_review_id` AS `t0_c28`, `t`.`tender_views` AS `t0_c29`,
`t`.`comments_count` AS `t0_c30`, `t`.`char_LENGTH` AS `t0_c31`,
`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`, `region`.`region_id` AS `t2_c0`,
`region`.`country_id` AS `t2_c1`, `region`.`region_name` AS `t2_c2`,
`region`.`city_id` AS `t2_c3`, `region`.`region_url` AS `t2_c4`,
`country`.`country_domain` AS `t3_c7`, `country`.`country_id` AS `t3_c0`,
`tendersComments`.`comment_id` AS `t4_c0`, `tendersComments`.`user_id` AS
`t4_c2` 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`)  LEFT OUTER JOIN `geo_countries`
`country` ON (`region`.`country_id`=`country`.`country_id`)  LEFT OUTER
JOIN `tenders_comments` `tendersComments` ON
(`tendersComments`.`tender_id`=`t`.`tender_id`)  WHERE (t.tender_id IN
(:ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8, :ycp9, :ycp10, :ycp11,
:ycp12, :ycp13, :ycp14, :ycp15, :ycp16)) ORDER BY t.tender_status,
t.tender_update_date DESC)

end:system.db.CDbCommand.query(SELECT `t`.`tender_id` AS `t0_c0`,
`t`.`user_id` AS `t0_c1`, `t`.`city_id` AS `t0_c2`, `t`.`old_city_id` AS
`t0_c3`, `t`.`tender_type` AS `t0_c4`, `t`.`tender_street` AS `t0_c5`,
`t`.`tender_house` AS `t0_c6`, `t`.`tender_geo_lat` AS `t0_c7`,
`t`.`tender_geo_lng` AS `t0_c8`, `t`.`tender_geo` AS `t0_c9`,
`t`.`tender_name` AS `t0_c10`, `t`.`tender_url` AS `t0_c11`,
`t`.`tender_text` AS `t0_c12`, `t`.`tender_budget` AS `t0_c13`,
`t`.`tender_commission` AS `t0_c14`, `t`.`tender_period` AS `t0_c15`,
`t`.`estimate_id` AS `t0_c16`, `t`.`file_id` AS `t0_c17`,
`t`.`tender_is_dealer` AS `t0_c18`, `t`.`tender_hide_phone` AS `t0_c19`,
`t`.`tender_create_date` AS `t0_c20`, `t`.`tender_update_date` AS `t0_c21`,
`t`.`tender_expiration_date` AS `t0_c22`, `t`.`tender_last_visit_date` AS
`t0_c23`, `t`.`tender_status` AS `t0_c24`, `t`.`comment_id` AS `t0_c25`,
`t`.`tender_referer` AS `t0_c26`, `t`.`customer_review_id` AS `t0_c27`,
`t`.`performer_review_id` AS `t0_c28`, `t`.`tender_views` AS `t0_c29`,
`t`.`comments_count` AS `t0_c30`, `t`.`char_LENGTH` AS `t0_c31`,
`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`, `region`.`region_id` AS `t2_c0`,
`region`.`country_id` AS `t2_c1`, `region`.`region_name` AS `t2_c2`,
`region`.`city_id` AS `t2_c3`, `region`.`region_url` AS `t2_c4`,
`country`.`country_domain` AS `t3_c7`, `country`.`country_id` AS `t3_c0`,
`tendersComments`.`comment_id` AS `t4_c0`, `tendersComments`.`user_id` AS
`t4_c2` 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`)  LEFT OUTER JOIN `geo_countries`
`country` ON (`region`.`country_id`=`country`.`country_id`)  LEFT OUTER
JOIN `tenders_comments` `tendersComments` ON
(`tendersComments`.`tender_id`=`t`.`tender_id`)  WHERE (t.tender_id IN
(:ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8, :ycp9, :ycp10, :ycp11,
:ycp12, :ycp13, :ycp14, :ycp15, :ycp16)) ORDER BY t.tender_status,
t.tender_update_date DESC)

begin:system.db.CDbCommand.query(SELECT * FROM `tenders_categories` `t`
WHERE category_seo_priority > 0 ORDER BY category_seo_priority)

end:system.db.CDbCommand.query(SELECT * FROM `tenders_categories` `t` WHERE
category_seo_priority > 0 ORDER BY category_seo_priority)

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 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 city_sort DESC, t.city_id)

begin:system.db.CDbCommand.query(SELECT * FROM `geo_cities` `t` WHERE
`t`.`city_id` IN (887, 2203, 1516, 607, 729) ORDER BY FIELD(city_id, 887,
2203, 1516, 607, 729))

end:system.db.CDbCommand.query(SELECT * FROM `geo_cities` `t` WHERE
`t`.`city_id` IN (887, 2203, 1516, 607, 729) ORDER BY FIELD(city_id, 887,
2203, 1516, 607, 729))

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

begin:system.db.CDbCommand.query(SELECT * FROM `blog_articles` `t` WHERE
category_id=:ycp17)

end:system.db.CDbCommand.query(SELECT * FROM `blog_articles` `t` WHERE
category_id=:ycp17)

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

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:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services"
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