Специалисты

Показать:
Все
Общий отчет (Время: 0.41386с, Память: 8,133Кб)
Процедура Номер Всего (с) Средн. (с) Мин. (с) Макс. (с)
system.db.CDbCommand.query(SELECT `t`.`session_id` AS `t0_c0`, `t`.`device_fingerprint` AS `t0_c1`, `t`.`session_timestamp` AS `t0_c2`, `t`.`person_id` AS `t0_c3`, `t`.`is_valid` AS `t0_c4`, `person`.`person_id` AS `t1_c0`, `person`.`avatar` AS `t1_c1`, `person`.`first_name` AS `t1_c2`, `person`.`last_name` AS `t1_c3`, `person`.`age` AS `t1_c4`, `person`.`gender` AS `t1_c5`, `person`.`age_group` AS `t1_c6`, `person`.`residence` AS `t1_c7`, `person`.`language` AS `t1_c8`, `person`.`last_location` AS `t1_c9`, `person`.`phone_number` AS `t1_c10`, `person`.`email` AS `t1_c11`, `person`.`skype` AS `t1_c12`, `person`.`twitter` AS `t1_c13`, `person`.`facebook` AS `t1_c14`, `person`.`linkedin` AS `t1_c15`, `person`.`photos` AS `t1_c16`, `person`.`websites` AS `t1_c17`, `person`.`chats` AS `t1_c18`, `person`.`organizations` AS `t1_c19`, `person`.`social_profiles` AS `t1_c20`, `person`.`last_activity` AS `t1_c21`, `person`.`last_shipping` AS `t1_c22`, `person`.`last_payment` AS `t1_c23`, `person`.`agent_id` AS `t1_c24`, `person`.`account_status` AS `t1_c25`, `person`.`user_id` AS `t1_c26`, `person`.`country_id` AS `t1_c27`, `person`.`level` AS `t1_c28`, `person`.`points` AS `t1_c29`, `person`.`balance` AS `t1_c30` FROM `person_session` `t` LEFT OUTER JOIN `person` `person` ON (`person`.`person_id`=`t`.`person_id`) WHERE (`t`.`session_id` IS NULL)) 22 0.01527 0.00069 0.00046 0.00148
system.db.CDbCommand.query(SELECT * FROM `language` `t` WHERE `t`.`language_id`=5 LIMIT 1) 22 0.01334 0.00061 0.00036 0.00195
system.db.CDbCommand.query(SELECT * FROM `country` `t` WHERE `t`.`country_code`=:yp0 LIMIT 1. Bound with :yp0='US') 19 0.01037 0.00055 0.00043 0.00109
system.db.CDbCommand.query(SELECT * FROM `ip2location_db1` `t` WHERE INET_ATON('3.228.10.34') <= ip_to LIMIT 1) 19 0.01024 0.00054 0.00039 0.00104
system.db.CDbCommand.query(SELECT * FROM `country_redirect` `t` WHERE `t`.`site_id`=:yp0 AND `t`.`country_id`=:yp1 LIMIT 1. Bound with :yp0='7117', :yp1='239') 18 0.00966 0.00054 0.00039 0.00110
system.db.CDbCommand.query(SELECT * FROM `event_calendar` `t` WHERE (event_name=:ycp17) AND (event_details LIKE :ycp18) LIMIT 1. Bound with :ycp17='Order', :ycp18='%"relation\\_id":""%') 1 0.00775 0.00775 0.00775 0.00775
system.db.CDbCommand.query(SELECT `t`.`site_language_id` AS `t0_c0`, `t`.`site_name` AS `t0_c1`, `t`.`default_title` AS `t0_c2`, `t`.`default_img` AS `t0_c3`, `t`.`default_description` AS `t0_c4`, `t`.`default_keywords` AS `t0_c5`, `t`.`is_default` AS `t0_c6`, `t`.`site_id` AS `t0_c7`, `t`.`language_id` AS `t0_c8`, `site`.`site_id` AS `t1_c0`, `site`.`language_detect` AS `t1_c1`, `site`.`meta_hide` AS `t1_c2`, `site`.`create_date` AS `t1_c3`, `site`.`update_date` AS `t1_c4`, `site`.`publish_date` AS `t1_c5`, `site`.`type` AS `t1_c6`, `site`.`theme_id` AS `t1_c7`, `site`.`theme_elements` AS `t1_c8`, `site`.`template_id` AS `t1_c9`, `site`.`property_id` AS `t1_c10`, `site`.`album_id` AS `t1_c11`, `site`.`action_id` AS `t1_c12`, `site`.`logo_id` AS `t1_c13`, `site`.`original_id` AS `t1_c14`, `site`.`group_id` AS `t1_c15`, `site`.`is_geo` AS `t1_c16`, `language`.`language_id` AS `t2_c0`, `language`.`language_name` AS `t2_c1`, `language`.`language_native` AS `t2_c2`, `language`.`two_letter_code` AS `t2_c3`, `language`.`three_letter_code` AS `t2_c4`, `language`.`locale` AS `t2_c5` FROM `site_language` `t` LEFT OUTER JOIN `site` `site` ON (`site`.`site_id`=`t`.`site_id`) LEFT OUTER JOIN `language` `language` ON (`language`.`language_id`=`t`.`language_id`) WHERE (`t`.`site_language_id`=7117)) 12 0.00681 0.00057 0.00050 0.00066
system.db.CDbCommand.query(SELECT * FROM `event_calendar` `t` WHERE (event_name=:ycp32) AND (event_details LIKE :ycp33) LIMIT 1. Bound with :ycp32='Order', :ycp33='%"relation\\_id":""%') 1 0.00615 0.00615 0.00615 0.00615
system.db.CDbCommand.query(SELECT `t`.`person_id` AS `t0_c0`, `t`.`avatar` AS `t0_c1`, `t`.`first_name` AS `t0_c2`, `t`.`last_name` AS `t0_c3`, `t`.`age` AS `t0_c4`, `t`.`gender` AS `t0_c5`, `t`.`age_group` AS `t0_c6`, `t`.`residence` AS `t0_c7`, `t`.`language` AS `t0_c8`, `t`.`last_location` AS `t0_c9`, `t`.`phone_number` AS `t0_c10`, `t`.`email` AS `t0_c11`, `t`.`skype` AS `t0_c12`, `t`.`twitter` AS `t0_c13`, `t`.`facebook` AS `t0_c14`, `t`.`linkedin` AS `t0_c15`, `t`.`photos` AS `t0_c16`, `t`.`websites` AS `t0_c17`, `t`.`chats` AS `t0_c18`, `t`.`organizations` AS `t0_c19`, `t`.`social_profiles` AS `t0_c20`, `t`.`last_activity` AS `t0_c21`, `t`.`last_shipping` AS `t0_c22`, `t`.`last_payment` AS `t0_c23`, `t`.`agent_id` AS `t0_c24`, `t`.`account_status` AS `t0_c25`, `t`.`user_id` AS `t0_c26`, `t`.`country_id` AS `t0_c27`, `t`.`level` AS `t0_c28`, `t`.`points` AS `t0_c29`, `t`.`balance` AS `t0_c30`, `alias`.`alias_id` AS `t1_c0`, `alias`.`alias_type` AS `t1_c1`, `alias`.`first_name` AS `t1_c2`, `alias`.`last_name` AS `t1_c3`, `alias`.`email` AS `t1_c4`, `alias`.`person_id` AS `t1_c5`, `alias`.`property_id` AS `t1_c6`, `alias`.`is_subscriber` AS `t1_c7`, `alias`.`is_hide` AS `t1_c8`, `alias`.`is_partner` AS `t1_c9` FROM `person` `t` RIGHT JOIN person_alias AS pa ON pa.person_id = t.person_id LEFT OUTER JOIN `person_alias` `alias` ON (`alias`.`person_id`=`t`.`person_id`) WHERE (`t`.`person_id` IS NULL AND (pa.is_hide=:ycp16)). Bound with :ycp16='0') 1 0.00461 0.00461 0.00461 0.00461
system.db.CDbCommand.query(SELECT * FROM `property` `t` WHERE `t`.`property_id`=1 LIMIT 1) 5 0.00376 0.00075 0.00041 0.00118
system.db.CDbCommand.query(SELECT * FROM `site` `t` WHERE `t`.`site_id`=7117 LIMIT 1) 7 0.00353 0.00050 0.00042 0.00066
system.db.CDbCommand.query(SELECT * FROM `album` `t` WHERE `t`.`is_gallery`=:yp0. Bound with :yp0=1) 1 0.00335 0.00335 0.00335 0.00335
system.db.CDbCommand.query(SELECT * FROM `site_page` `t` WHERE `t`.`site_page_id`=31277 LIMIT 1) 5 0.00307 0.00061 0.00038 0.00098
system.db.CDbCommand.query(SELECT `t`.`person_id` AS `t0_c0`, `t`.`avatar` AS `t0_c1`, `t`.`first_name` AS `t0_c2`, `t`.`last_name` AS `t0_c3`, `t`.`age` AS `t0_c4`, `t`.`gender` AS `t0_c5`, `t`.`age_group` AS `t0_c6`, `t`.`residence` AS `t0_c7`, `t`.`language` AS `t0_c8`, `t`.`last_location` AS `t0_c9`, `t`.`phone_number` AS `t0_c10`, `t`.`email` AS `t0_c11`, `t`.`skype` AS `t0_c12`, `t`.`twitter` AS `t0_c13`, `t`.`facebook` AS `t0_c14`, `t`.`linkedin` AS `t0_c15`, `t`.`photos` AS `t0_c16`, `t`.`websites` AS `t0_c17`, `t`.`chats` AS `t0_c18`, `t`.`organizations` AS `t0_c19`, `t`.`social_profiles` AS `t0_c20`, `t`.`last_activity` AS `t0_c21`, `t`.`last_shipping` AS `t0_c22`, `t`.`last_payment` AS `t0_c23`, `t`.`agent_id` AS `t0_c24`, `t`.`account_status` AS `t0_c25`, `t`.`user_id` AS `t0_c26`, `t`.`country_id` AS `t0_c27`, `t`.`level` AS `t0_c28`, `t`.`points` AS `t0_c29`, `t`.`balance` AS `t0_c30`, `alias`.`alias_id` AS `t1_c0`, `alias`.`alias_type` AS `t1_c1`, `alias`.`first_name` AS `t1_c2`, `alias`.`last_name` AS `t1_c3`, `alias`.`email` AS `t1_c4`, `alias`.`person_id` AS `t1_c5`, `alias`.`property_id` AS `t1_c6`, `alias`.`is_subscriber` AS `t1_c7`, `alias`.`is_hide` AS `t1_c8`, `alias`.`is_partner` AS `t1_c9` FROM `person` `t` RIGHT JOIN person_alias AS pa ON pa.person_id = t.person_id LEFT OUTER JOIN `person_alias` `alias` ON (`alias`.`person_id`=`t`.`person_id`) WHERE (`t`.`person_id` IS NULL AND (pa.is_hide=:ycp31)). Bound with :ycp31='0') 1 0.00305 0.00305 0.00305 0.00305
system.db.CDbCommand.query(SELECT `t`.`page_id` AS `t0_c0`, `t`.`page_order` AS `t0_c1`, `t`.`page_name` AS `t0_c2`, `t`.`page_description` AS `t0_c3`, `t`.`page_path` AS `t0_c4`, `t`.`page_settings` AS `t0_c5`, `t`.`page_content` AS `t0_c6`, `t`.`template_id` AS `t0_c7`, `t`.`customizable` AS `t0_c8`, `template`.`template_id` AS `t1_c0`, `template`.`template_type` AS `t1_c1`, `template`.`template_name` AS `t1_c2`, `template`.`template_description` AS `t1_c3`, `template`.`template_path` AS `t1_c4`, `template`.`theme_id` AS `t1_c5`, `template`.`template_settings` AS `t1_c6` FROM `template_page` `t` LEFT OUTER JOIN `template` `template` ON (`template`.`template_id`=`t`.`template_id`) WHERE (`t`.`page_id`=185)) 4 0.00286 0.00071 0.00050 0.00124
system.db.CDbCommand.query(SELECT * FROM `site` `t` WHERE `t`.`group_id`=:yp0. Bound with :yp0='sm-int') 2 0.00257 0.00128 0.00114 0.00142
system.db.CDbCommand.query(SELECT `defaultSiteLanguage`.`site_language_id` AS `t1_c0`, `defaultSiteLanguage`.`site_name` AS `t1_c1`, `defaultSiteLanguage`.`default_title` AS `t1_c2`, `defaultSiteLanguage`.`default_img` AS `t1_c3`, `defaultSiteLanguage`.`default_description` AS `t1_c4`, `defaultSiteLanguage`.`default_keywords` AS `t1_c5`, `defaultSiteLanguage`.`is_default` AS `t1_c6`, `defaultSiteLanguage`.`site_id` AS `t1_c7`, `defaultSiteLanguage`.`language_id` AS `t1_c8` FROM `site_language` `defaultSiteLanguage` WHERE (defaultSiteLanguage.is_default = 1) AND (`defaultSiteLanguage`.`site_id`=:ypl0). Bound with :ypl0='7117') 4 0.00253 0.00063 0.00041 0.00103
system.db.CDbCommand.query(SELECT `t`.`site_language_id` AS `t0_c0`, `t`.`site_name` AS `t0_c1`, `t`.`default_title` AS `t0_c2`, `t`.`default_img` AS `t0_c3`, `t`.`default_description` AS `t0_c4`, `t`.`default_keywords` AS `t0_c5`, `t`.`is_default` AS `t0_c6`, `t`.`site_id` AS `t0_c7`, `t`.`language_id` AS `t0_c8`, `language`.`language_id` AS `t1_c0`, `language`.`language_name` AS `t1_c1`, `language`.`language_native` AS `t1_c2`, `language`.`two_letter_code` AS `t1_c3`, `language`.`three_letter_code` AS `t1_c4`, `language`.`locale` AS `t1_c5` FROM `site_language` `t` LEFT OUTER JOIN `language` `language` ON (`language`.`language_id`=`t`.`language_id`) WHERE (`t`.`site_language_id`=7117)) 5 0.00252 0.00050 0.00047 0.00056
system.db.CDbCommand.query(SELECT `t`.`site_language_id` AS `t0_c0`, `t`.`site_name` AS `t0_c1`, `t`.`default_title` AS `t0_c2`, `t`.`default_img` AS `t0_c3`, `t`.`default_description` AS `t0_c4`, `t`.`default_keywords` AS `t0_c5`, `t`.`is_default` AS `t0_c6`, `t`.`site_id` AS `t0_c7`, `t`.`language_id` AS `t0_c8`, `language`.`language_id` AS `t1_c0`, `language`.`language_name` AS `t1_c1`, `language`.`language_native` AS `t1_c2`, `language`.`two_letter_code` AS `t1_c3`, `language`.`three_letter_code` AS `t1_c4`, `language`.`locale` AS `t1_c5`, `sitePageList`.`site_page_id` AS `t2_c0`, `sitePageList`.`site_page_name` AS `t2_c1`, `sitePageList`.`site_page_slug` AS `t2_c2`, `sitePageList`.`site_page_order` AS `t2_c3`, `sitePageList`.`is_folder` AS `t2_c4`, `sitePageList`.`is_navigation` AS `t2_c5`, `sitePageList`.`is_footer_navigation` AS `t2_c6`, `sitePageList`.`meta_description` AS `t2_c7`, `sitePageList`.`meta_keywords` AS `t2_c8`, `sitePageList`.`meta_hide` AS `t2_c9`, `sitePageList`.`parent_id` AS `t2_c10`, `sitePageList`.`original_id` AS `t2_c11`, `sitePageList`.`site_language_id` AS `t2_c12`, `sitePageList`.`template_page_id` AS `t2_c13`, `sitePageList`.`is_nav_hide` AS `t2_c14`, `sitePageList`.`is_hide` AS `t2_c15`, `sitePageList`.`site_id` AS `t2_c16` FROM `site_language` `t` LEFT OUTER JOIN `language` `language` ON (`language`.`language_id`=`t`.`language_id`) LEFT OUTER JOIN `site_page` `sitePageList` ON (`sitePageList`.`site_language_id`=`t`.`site_language_id`) WHERE (`t`.`site_language_id`=7117) ORDER BY site_page_order ASC) 1 0.00242 0.00242 0.00242 0.00242
system.db.CDbCommand.query(SELECT `t`.`site_page_id` AS `t0_c0`, `t`.`site_page_name` AS `t0_c1`, `t`.`site_page_slug` AS `t0_c2`, `t`.`site_page_order` AS `t0_c3`, `t`.`is_folder` AS `t0_c4`, `t`.`is_navigation` AS `t0_c5`, `t`.`is_footer_navigation` AS `t0_c6`, `t`.`meta_description` AS `t0_c7`, `t`.`meta_keywords` AS `t0_c8`, `t`.`meta_hide` AS `t0_c9`, `t`.`parent_id` AS `t0_c10`, `t`.`original_id` AS `t0_c11`, `t`.`site_language_id` AS `t0_c12`, `t`.`template_page_id` AS `t0_c13`, `t`.`is_nav_hide` AS `t0_c14`, `t`.`is_hide` AS `t0_c15`, `t`.`site_id` AS `t0_c16`, `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `site_page` `t` LEFT OUTER JOIN `template_page` `templatePage` ON (`templatePage`.`page_id`=`t`.`template_page_id`) WHERE ((site_page_slug=:ycp2) AND (site_language_id=:ycp3)). Bound with :ycp2='partners', :ycp3='7117') 1 0.00235 0.00235 0.00235 0.00235
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ip2location_db1`) 1 0.00217 0.00217 0.00217 0.00217
system.db.CDbCommand.query(SELECT * FROM `event_calendar` `t` WHERE ((((event_name=:ycp10) AND (property_id=:ycp11)) AND (node_id=:ycp12)) AND (event_status IN (:ycp13, :ycp14))) AND (event_details LIKE :ycp15) ORDER BY event_start DESC LIMIT 1. Bound with :ycp10='ShopCart', :ycp11='1', :ycp12='7117', :ycp13=0, :ycp14=1, :ycp15='%oxC6YBVR8yQTuglfs3z5Kvw9pmDNirJG%') 1 0.00214 0.00214 0.00214 0.00214
system.db.CDbCommand.query(SELECT * FROM `theme_element` `t` WHERE `t`.`theme_id`=:yp0. Bound with :yp0='53') 2 0.00209 0.00104 0.00065 0.00144
system.db.CDbCommand.query(SELECT * FROM `person` `t` WHERE `t`.`person_id` IS NULL LIMIT 1) 2 0.00198 0.00099 0.00051 0.00147
system.db.CDbCommand.query(SELECT * FROM `site_page` `t` WHERE `t`.`site_page_id`=31275 LIMIT 1) 3 0.00197 0.00066 0.00054 0.00087
system.db.CDbCommand.query(SELECT `template`.`template_id` AS `t1_c0`, `template`.`template_type` AS `t1_c1`, `template`.`template_name` AS `t1_c2`, `template`.`template_description` AS `t1_c3`, `template`.`template_path` AS `t1_c4`, `template`.`theme_id` AS `t1_c5`, `template`.`template_settings` AS `t1_c6` FROM `template` `template` WHERE (`template`.`template_id`=:ypl0). Bound with :ypl0='48') 4 0.00197 0.00049 0.00045 0.00062
system.db.CDbCommand.query(SELECT `t`.`property_id` AS `t0_c0`, `t`.`domain_id` AS `t0_c1`, `t`.`property_name` AS `t0_c2`, `t`.`street_address1` AS `t0_c3`, `t`.`street_address2` AS `t0_c4`, `t`.`zip_code` AS `t0_c5`, `t`.`state_province` AS `t0_c6`, `t`.`city` AS `t0_c7`, `t`.`country_id` AS `t0_c8`, `t`.`phone_number` AS `t0_c9`, `t`.`fax_number` AS `t0_c10`, `t`.`email` AS `t0_c11`, `t`.`location` AS `t0_c12`, `t`.`album_id` AS `t0_c13`, `t`.`avatar_id` AS `t0_c14`, `t`.`inventory_type_id` AS `t0_c15`, `t`.`user_id` AS `t0_c16`, `t`.`brand_id` AS `t0_c17`, `t`.`currency_id` AS `t0_c18`, `t`.`category_id` AS `t0_c19`, `t`.`index_id` AS `t0_c20`, `t`.`invoice` AS `t0_c21`, `t`.`tax` AS `t0_c22`, `t`.`status` AS `t0_c23`, `propertyLanguage`.`property_language_id` AS `t1_c0`, `propertyLanguage`.`is_default` AS `t1_c1`, `propertyLanguage`.`property_id` AS `t1_c2`, `propertyLanguage`.`language_id` AS `t1_c3`, `currency`.`currency_id` AS `t2_c0`, `currency`.`currency_code` AS `t2_c1`, `currency`.`currency_symbol` AS `t2_c2` FROM `property` `t` LEFT OUTER JOIN `property_language` `propertyLanguage` ON (`propertyLanguage`.`property_id`=`t`.`property_id`) LEFT OUTER JOIN `currency` `currency` ON (`currency`.`currency_id`=`t`.`currency_id`) WHERE (`t`.`property_id`=1)) 2 0.00195 0.00098 0.00095 0.00100
system.db.CDbCommand.query(SELECT * FROM `property_user` `t` WHERE `t`.`user_id`=:yp0 AND `t`.`role_id`=:yp1. Bound with :yp0='16', :yp1=2) 3 0.00186 0.00062 0.00055 0.00072
system.db.CDbCommand.query(SELECT `language`.`language_id` AS `t1_c0`, `language`.`language_name` AS `t1_c1`, `language`.`language_native` AS `t1_c2`, `language`.`two_letter_code` AS `t1_c3`, `language`.`three_letter_code` AS `t1_c4`, `language`.`locale` AS `t1_c5` FROM `language` `language` WHERE (`language`.`language_id`=:ypl0). Bound with :ypl0='5') 4 0.00183 0.00046 0.00039 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `person_alias`) 1 0.00182 0.00182 0.00182 0.00182
system.db.CDbCommand.query(SELECT * FROM `country_region` `t` WHERE `t`.`region_id`=:yp0. Bound with :yp0='5') 1 0.00164 0.00164 0.00164 0.00164
system.db.CDbCommand.query(SELECT * FROM `template_page` `t` WHERE `t`.`page_path`=:yp0 AND `t`.`template_id`=:yp1 LIMIT 1. Bound with :yp0='action', :yp1='48') 3 0.00159 0.00053 0.00048 0.00060
system.db.CDbCommand.query(SELECT `defaultSiteLanguage`.`site_language_id` AS `t1_c0`, `defaultSiteLanguage`.`site_name` AS `t1_c1`, `defaultSiteLanguage`.`default_title` AS `t1_c2`, `defaultSiteLanguage`.`default_img` AS `t1_c3`, `defaultSiteLanguage`.`default_description` AS `t1_c4`, `defaultSiteLanguage`.`default_keywords` AS `t1_c5`, `defaultSiteLanguage`.`is_default` AS `t1_c6`, `defaultSiteLanguage`.`site_id` AS `t1_c7`, `defaultSiteLanguage`.`language_id` AS `t1_c8` FROM `site_language` `defaultSiteLanguage` WHERE (defaultSiteLanguage.is_default = 1) AND (`defaultSiteLanguage`.`site_id`=:ypl0). Bound with :ypl0='7116') 2 0.00156 0.00078 0.00049 0.00108
system.db.CDbCommand.query(SELECT `sitePage`.`site_page_id` AS `t1_c0`, `sitePage`.`site_page_name` AS `t1_c1`, `sitePage`.`site_page_slug` AS `t1_c2`, `sitePage`.`site_page_order` AS `t1_c3`, `sitePage`.`is_folder` AS `t1_c4`, `sitePage`.`is_navigation` AS `t1_c5`, `sitePage`.`is_footer_navigation` AS `t1_c6`, `sitePage`.`meta_description` AS `t1_c7`, `sitePage`.`meta_keywords` AS `t1_c8`, `sitePage`.`meta_hide` AS `t1_c9`, `sitePage`.`parent_id` AS `t1_c10`, `sitePage`.`original_id` AS `t1_c11`, `sitePage`.`site_language_id` AS `t1_c12`, `sitePage`.`template_page_id` AS `t1_c13`, `sitePage`.`is_nav_hide` AS `t1_c14`, `sitePage`.`is_hide` AS `t1_c15`, `sitePage`.`site_id` AS `t1_c16` FROM `site_page` `sitePage` WHERE (`sitePage`.`site_id`=:ypl0) ORDER BY sitePage.site_page_order ASC. Bound with :ypl0='7117') 2 0.00152 0.00076 0.00062 0.00090
system.db.CDbCommand.query(SELECT * FROM `site_page` `t` WHERE `t`.`site_page_id`=31276 LIMIT 1) 3 0.00150 0.00050 0.00041 0.00064
system.db.CDbCommand.query(SELECT * FROM `site_page` `t` WHERE `t`.`site_page_id`=31274 LIMIT 1) 3 0.00146 0.00049 0.00045 0.00051
system.db.CDbCommand.query(SELECT `t`.`site_page_id` AS `t0_c0`, `t`.`site_page_name` AS `t0_c1`, `t`.`site_page_slug` AS `t0_c2`, `t`.`site_page_order` AS `t0_c3`, `t`.`is_folder` AS `t0_c4`, `t`.`is_navigation` AS `t0_c5`, `t`.`is_footer_navigation` AS `t0_c6`, `t`.`meta_description` AS `t0_c7`, `t`.`meta_keywords` AS `t0_c8`, `t`.`meta_hide` AS `t0_c9`, `t`.`parent_id` AS `t0_c10`, `t`.`original_id` AS `t0_c11`, `t`.`site_language_id` AS `t0_c12`, `t`.`template_page_id` AS `t0_c13`, `t`.`is_nav_hide` AS `t0_c14`, `t`.`is_hide` AS `t0_c15`, `t`.`site_id` AS `t0_c16`, `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `site_page` `t` RIGHT JOIN site_language ON site_language.site_language_id = t.site_language_id RIGHT JOIN site ON site.site_id = site_language.site_id LEFT OUTER JOIN `template_page` `templatePage` ON (`templatePage`.`page_id`=`t`.`template_page_id`) WHERE (((t.template_page_id = 175) AND (site.property_id IN (:ycp6, :ycp7, :ycp8, :ycp9))) AND (site.site_id = 7117)). Bound with :ycp6='1', :ycp7='9', :ycp8='5', :ycp9='4') 1 0.00146 0.00146 0.00146 0.00146
system.db.CDbCommand.query(SELECT * FROM `property_user` `t` WHERE `t`.`property_id`=:yp0 AND `t`.`role_id`=:yp1 LIMIT 1. Bound with :yp0='1', :yp1=1) 3 0.00144 0.00048 0.00044 0.00052
system.db.CDbCommand.query(SELECT * FROM `page_widget` `t` WHERE (site_page_id=:ycp52) AND (widget_name LIKE :ycp53) LIMIT 1. Bound with :ycp52='31277', :ycp53='%ContentType%') 1 0.00144 0.00144 0.00144 0.00144
system.db.CDbCommand.query(SELECT `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `template_page` `templatePage` WHERE (`templatePage`.`page_id`=:ypl0). Bound with :ypl0='185') 2 0.00140 0.00070 0.00044 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country_redirect`) 1 0.00138 0.00138 0.00138 0.00138
system.db.CDbCommand.query(SELECT * FROM `site_page` `t` WHERE `t`.`site_page_id`=31278 LIMIT 1) 1 0.00135 0.00135 0.00135 0.00135
system.db.CDbCommand.query(SELECT `t`.`page_widget_id` AS `t0_c0`, `t`.`widget_name` AS `t0_c1`, `t`.`page_widget_order` AS `t0_c2`, `t`.`page_widget_settings` AS `t0_c3`, `t`.`is_hide` AS `t0_c4`, `t`.`site_page_id` AS `t0_c5`, `t`.`content_id` AS `t0_c6`, `t`.`template_widget_id` AS `t0_c7`, `templateWidget`.`widget_id` AS `t1_c0`, `templateWidget`.`widget_name` AS `t1_c1`, `templateWidget`.`widget_path` AS `t1_c2`, `settings`.`settings_id` AS `t2_c0`, `settings`.`widget_id` AS `t2_c1`, `settings`.`widget_settings` AS `t2_c2`, `settings`.`template_id` AS `t2_c3` FROM `page_widget` `t` LEFT OUTER JOIN `template_widget` `templateWidget` ON (`templateWidget`.`widget_id`=`t`.`template_widget_id`) LEFT OUTER JOIN `template_widget_settings` `settings` ON (`settings`.`widget_id`=`templateWidget`.`widget_id`) AND (`settings`.`widget_id`=`templateWidget`.`widget_id`) WHERE (`t`.`page_widget_id`=113770)) 1 0.00135 0.00135 0.00135 0.00135
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `page_widget`) 1 0.00131 0.00131 0.00131 0.00131
system.db.CDbCommand.query(SELECT * FROM `template_page` `t` WHERE `t`.`template_id`=:yp0 AND `t`.`page_path`=:yp1 LIMIT 1. Bound with :yp0='48', :yp1='shopcart') 2 0.00129 0.00064 0.00057 0.00072
system.db.CDbCommand.query(SELECT `t`.`region_id` AS `t0_c0`, `t`.`region_name` AS `t0_c1`, `t`.`region_type` AS `t0_c2`, `t`.`parent_id` AS `t0_c3`, `t`.`featured_order` AS `t0_c4`, `t`.`is_active` AS `t0_c5`, `countryRegion`.`country_region_id` AS `t1_c0`, `countryRegion`.`country_id` AS `t1_c1`, `countryRegion`.`region_id` AS `t1_c2`, `countryRegion`.`is_default` AS `t1_c3` FROM `region` `t` LEFT OUTER JOIN `country_region` `countryRegion` ON (`countryRegion`.`region_id`=`t`.`region_id`) WHERE ((featured_order != 0) AND (countryRegion.country_id=:ycp40)) ORDER BY featured_order ASC. Bound with :ycp40='239') 1 0.00123 0.00123 0.00123 0.00123
system.db.CDbCommand.query(SELECT * FROM `person_alias` `t` WHERE `t`.`person_id` IS NULL AND `t`.`property_id`=:yp0 LIMIT 1. Bound with :yp0='1') 3 0.00120 0.00040 0.00039 0.00041
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp38) AND (setting_name=:ycp39) LIMIT 1. Bound with :ycp38='2', :ycp39='site_7117') 1 0.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SELECT `t`.`page_widget_id` AS `t0_c0`, `t`.`widget_name` AS `t0_c1`, `t`.`page_widget_order` AS `t0_c2`, `t`.`page_widget_settings` AS `t0_c3`, `t`.`is_hide` AS `t0_c4`, `t`.`site_page_id` AS `t0_c5`, `t`.`content_id` AS `t0_c6`, `t`.`template_widget_id` AS `t0_c7`, `templateWidget`.`widget_id` AS `t1_c0`, `templateWidget`.`widget_name` AS `t1_c1`, `templateWidget`.`widget_path` AS `t1_c2`, `settings`.`settings_id` AS `t2_c0`, `settings`.`widget_id` AS `t2_c1`, `settings`.`widget_settings` AS `t2_c2`, `settings`.`template_id` AS `t2_c3` FROM `page_widget` `t` LEFT OUTER JOIN `template_widget` `templateWidget` ON (`templateWidget`.`widget_id`=`t`.`template_widget_id`) LEFT OUTER JOIN `template_widget_settings` `settings` ON (`settings`.`widget_id`=`templateWidget`.`widget_id`) AND (`settings`.`widget_id`=`templateWidget`.`widget_id`) WHERE (`t`.`site_page_id`=:yp0) ORDER BY page_widget_order. Bound with :yp0='31277') 1 0.00116 0.00116 0.00116 0.00116
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `property_language`) 1 0.00110 0.00110 0.00110 0.00110
system.db.CDbCommand.query(SELECT `t`.`page_id` AS `t0_c0`, `t`.`page_order` AS `t0_c1`, `t`.`page_name` AS `t0_c2`, `t`.`page_description` AS `t0_c3`, `t`.`page_path` AS `t0_c4`, `t`.`page_settings` AS `t0_c5`, `t`.`page_content` AS `t0_c6`, `t`.`template_id` AS `t0_c7`, `t`.`customizable` AS `t0_c8`, `template`.`template_id` AS `t1_c0`, `template`.`template_type` AS `t1_c1`, `template`.`template_name` AS `t1_c2`, `template`.`template_description` AS `t1_c3`, `template`.`template_path` AS `t1_c4`, `template`.`theme_id` AS `t1_c5`, `template`.`template_settings` AS `t1_c6` FROM `template_page` `t` LEFT OUTER JOIN `template` `template` ON (`template`.`template_id`=`t`.`template_id`) WHERE (`t`.`page_id`=173)) 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `translation`) 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SELECT * FROM `action_settings` `t` WHERE `t`.`action_id`=:yp0 AND `t`.`site_id`=:yp1 LIMIT 1. Bound with :yp0='3', :yp1='7117') 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SHOW CREATE TABLE `album`) 1 0.00103 0.00103 0.00103 0.00103
system.db.CDbCommand.query(SHOW CREATE TABLE `inventory_type`) 1 0.00100 0.00100 0.00100 0.00100
system.db.CDbCommand.query(SELECT `language`.`language_id` AS `t1_c0`, `language`.`language_name` AS `t1_c1`, `language`.`language_native` AS `t1_c2`, `language`.`two_letter_code` AS `t1_c3`, `language`.`three_letter_code` AS `t1_c4`, `language`.`locale` AS `t1_c5` FROM `language` `language` WHERE (`language`.`language_id`=:ypl0). Bound with :ypl0='1') 2 0.00100 0.00050 0.00042 0.00058
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp4) AND (setting_name=:ycp5) LIMIT 1. Bound with :ycp4='2', :ycp5='site_7117') 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SELECT `siteLanguage`.`site_language_id` AS `t1_c0`, `siteLanguage`.`site_name` AS `t1_c1`, `siteLanguage`.`default_title` AS `t1_c2`, `siteLanguage`.`default_img` AS `t1_c3`, `siteLanguage`.`default_description` AS `t1_c4`, `siteLanguage`.`default_keywords` AS `t1_c5`, `siteLanguage`.`is_default` AS `t1_c6`, `siteLanguage`.`site_id` AS `t1_c7`, `siteLanguage`.`language_id` AS `t1_c8` FROM `site_language` `siteLanguage` WHERE (`siteLanguage`.`site_language_id`=:ypl0). Bound with :ypl0='7117') 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SELECT `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `template_page` `templatePage` WHERE (`templatePage`.`page_id`=:ypl0). Bound with :ypl0='186') 1 0.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `inventory`) 1 0.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(SELECT * FROM `region` `t` WHERE parent_id=:ycp47 ORDER BY region_name ASC. Bound with :ycp47='5') 1 0.00088 0.00088 0.00088 0.00088
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `action_settings`) 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SELECT * FROM `country` `t` WHERE `t`.`country_id`=239 LIMIT 1) 2 0.00086 0.00043 0.00040 0.00047
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp48) AND (setting_name=:ycp49) LIMIT 1. Bound with :ycp48='2', :ycp49='site_7117') 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SELECT * FROM `template_page` `t` WHERE `t`.`template_id`=:yp0 AND `t`.`page_path`=:yp1 LIMIT 1. Bound with :yp0='48', :yp1='startashop') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT `t`.`page_widget_id` AS `t0_c0`, `t`.`widget_name` AS `t0_c1`, `t`.`page_widget_order` AS `t0_c2`, `t`.`page_widget_settings` AS `t0_c3`, `t`.`is_hide` AS `t0_c4`, `t`.`site_page_id` AS `t0_c5`, `t`.`content_id` AS `t0_c6`, `t`.`template_widget_id` AS `t0_c7`, `templateWidget`.`widget_id` AS `t1_c0`, `templateWidget`.`widget_name` AS `t1_c1`, `templateWidget`.`widget_path` AS `t1_c2`, `settings`.`settings_id` AS `t2_c0`, `settings`.`widget_id` AS `t2_c1`, `settings`.`widget_settings` AS `t2_c2`, `settings`.`template_id` AS `t2_c3` FROM `page_widget` `t` LEFT OUTER JOIN `template_widget` `templateWidget` ON (`templateWidget`.`widget_id`=`t`.`template_widget_id`) LEFT OUTER JOIN `template_widget_settings` `settings` ON (`settings`.`widget_id`=`templateWidget`.`widget_id`) AND (`settings`.`widget_id`=`templateWidget`.`widget_id`) WHERE (`t`.`page_widget_id`=113771)) 1 0.00083 0.00083 0.00083 0.00083
system.db.CDbCommand.query(SELECT * FROM `shipping` `t` WHERE `t`.`shipping_id` IS NULL LIMIT 1) 2 0.00083 0.00042 0.00039 0.00045
system.db.CDbCommand.query(SELECT * FROM `region` `t` WHERE `t`.`region_id`=5 LIMIT 1) 2 0.00081 0.00040 0.00039 0.00042
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `person`) 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `category`) 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `language`) 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SELECT * FROM `language` `t` WHERE `t`.`two_letter_code`=:yp0 LIMIT 1. Bound with :yp0='en') 2 0.00074 0.00037 0.00036 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `contact`) 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT * FROM `template_page` `t` WHERE `t`.`page_path`=:yp0 AND `t`.`template_id`=:yp1 LIMIT 1. Bound with :yp0='inventory', :yp1='48') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SELECT `t`.`site_page_id` AS `t0_c0`, `t`.`site_page_name` AS `t0_c1`, `t`.`site_page_slug` AS `t0_c2`, `t`.`site_page_order` AS `t0_c3`, `t`.`is_folder` AS `t0_c4`, `t`.`is_navigation` AS `t0_c5`, `t`.`is_footer_navigation` AS `t0_c6`, `t`.`meta_description` AS `t0_c7`, `t`.`meta_keywords` AS `t0_c8`, `t`.`meta_hide` AS `t0_c9`, `t`.`parent_id` AS `t0_c10`, `t`.`original_id` AS `t0_c11`, `t`.`site_language_id` AS `t0_c12`, `t`.`template_page_id` AS `t0_c13`, `t`.`is_nav_hide` AS `t0_c14`, `t`.`is_hide` AS `t0_c15`, `t`.`site_id` AS `t0_c16`, `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `site_page` `t` RIGHT JOIN site_language ON site_language.site_language_id = t.site_language_id RIGHT JOIN site ON site.site_id = site_language.site_id LEFT OUTER JOIN `template_page` `templatePage` ON (`templatePage`.`page_id`=`t`.`template_page_id`) WHERE ((t.template_page_id = 186) AND (site.property_id IN (:ycp34, :ycp35, :ycp36, :ycp37))). Bound with :ycp34='1', :ycp35='9', :ycp36='5', :ycp37='4') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SELECT `t`.`site_page_id` AS `t0_c0`, `t`.`site_page_name` AS `t0_c1`, `t`.`site_page_slug` AS `t0_c2`, `t`.`site_page_order` AS `t0_c3`, `t`.`is_folder` AS `t0_c4`, `t`.`is_navigation` AS `t0_c5`, `t`.`is_footer_navigation` AS `t0_c6`, `t`.`meta_description` AS `t0_c7`, `t`.`meta_keywords` AS `t0_c8`, `t`.`meta_hide` AS `t0_c9`, `t`.`parent_id` AS `t0_c10`, `t`.`original_id` AS `t0_c11`, `t`.`site_language_id` AS `t0_c12`, `t`.`template_page_id` AS `t0_c13`, `t`.`is_nav_hide` AS `t0_c14`, `t`.`is_hide` AS `t0_c15`, `t`.`site_id` AS `t0_c16`, `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `site_page` `t` RIGHT JOIN site_language ON site_language.site_language_id = t.site_language_id RIGHT JOIN site ON site.site_id = site_language.site_id LEFT OUTER JOIN `template_page` `templatePage` ON (`templatePage`.`page_id`=`t`.`template_page_id`) WHERE (((t.template_page_id = 175) AND (site.property_id IN (:ycp21, :ycp22, :ycp23, :ycp24))) AND (site.site_id = 7117)). Bound with :ycp21='1', :ycp22='9', :ycp23='5', :ycp24='4') 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `region`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `theme_element`) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp19) AND (setting_name=:ycp20) LIMIT 1. Bound with :ycp19='2', :ycp20='site_7117') 1 0.00070 0.00070 0.00070 0.00070
system.db.CDbCommand.query(SHOW CREATE TABLE `ip2location_db1`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW CREATE TABLE `translation`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `site_domain`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `property`) 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `media`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SELECT * FROM `event_calendar` `t` WHERE ((((event_name=:ycp25) AND (property_id=:ycp26)) AND (node_id=:ycp27)) AND (event_status IN (:ycp28, :ycp29))) AND (event_details LIKE :ycp30) ORDER BY event_start DESC LIMIT 1. Bound with :ycp25='ShopCart', :ycp26='1', :ycp27='7117', :ycp28=0, :ycp29=1, :ycp30='%oxC6YBVR8yQTuglfs3z5Kvw9pmDNirJG%') 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `template_widget_settings`) 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SELECT `domain`.`domain_id` AS `t1_c0`, `domain`.`domain_name` AS `t1_c1`, `domain`.`domain_type` AS `t1_c2`, `domain`.`is_valid` AS `t1_c3`, `domain`.`user_id` AS `t1_c4`, `domain`.`is_ssl` AS `t1_c5` FROM `domain` `domain` WHERE (`domain`.`domain_id`=:ypl0). Bound with :ypl0='1') 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SELECT * FROM `redirect` `t` WHERE `t`.`site_id`=:yp0 AND `t`.`source_url`=:yp1 LIMIT 1. Bound with :yp0='7117', :yp1='ru/partners') 1 0.00064 0.00064 0.00064 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `content`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `site`) 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SELECT * FROM `template_page` `t` WHERE `t`.`page_path`=:yp0 AND `t`.`template_id`=:yp1 LIMIT 1. Bound with :yp0='gallery', :yp1='48') 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SELECT `t`.`inventory_id` AS `t0_c0`, `t`.`inventory_name` AS `t0_c1`, `t`.`inventory_image` AS `t0_c2`, `t`.`description` AS `t0_c3`, `t`.`min_rate` AS `t0_c4`, `t`.`occupancy` AS `t0_c5`, `t`.`size` AS `t0_c6`, `t`.`inventory_order` AS `t0_c7`, `t`.`inventory_type_id` AS `t0_c8`, `t`.`album_id` AS `t0_c9`, `t`.`property_id` AS `t0_c10`, `inventoryType`.`inventory_type_id` AS `t1_c0`, `inventoryType`.`inventory_type` AS `t1_c1`, `inventoryType`.`parent_id` AS `t1_c2` FROM `inventory` `t` LEFT OUTER JOIN `inventory_type` `inventoryType` ON (`inventoryType`.`inventory_type_id`=`t`.`inventory_type_id`) WHERE (`t`.`property_id`=:yp0) ORDER BY inventoryType.inventory_type_id. Bound with :yp0='1') 1 0.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `country_region`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW CREATE TABLE `content`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SELECT * FROM `translation` `t` WHERE `t`.`group_name`=:yp0 AND `t`.`relation_id`=:yp1 AND `t`.`language_id`=:yp2 AND `t`.`label_id`=:yp3 LIMIT 1. Bound with :yp0='page_widget', :yp1='113771', :yp2='5', :yp3='widget_title') 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `site_page`) 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `method`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `event_calendar`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `domain`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `site_language`) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `album`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `redirect`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `shipping`) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `template_page`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SELECT `t`.`property_id` AS `t0_c0`, `t`.`domain_id` AS `t0_c1`, `t`.`property_name` AS `t0_c2`, `t`.`street_address1` AS `t0_c3`, `t`.`street_address2` AS `t0_c4`, `t`.`zip_code` AS `t0_c5`, `t`.`state_province` AS `t0_c6`, `t`.`city` AS `t0_c7`, `t`.`country_id` AS `t0_c8`, `t`.`phone_number` AS `t0_c9`, `t`.`fax_number` AS `t0_c10`, `t`.`email` AS `t0_c11`, `t`.`location` AS `t0_c12`, `t`.`album_id` AS `t0_c13`, `t`.`avatar_id` AS `t0_c14`, `t`.`inventory_type_id` AS `t0_c15`, `t`.`user_id` AS `t0_c16`, `t`.`brand_id` AS `t0_c17`, `t`.`currency_id` AS `t0_c18`, `t`.`category_id` AS `t0_c19`, `t`.`index_id` AS `t0_c20`, `t`.`invoice` AS `t0_c21`, `t`.`tax` AS `t0_c22`, `t`.`status` AS `t0_c23`, `currency`.`currency_id` AS `t1_c0`, `currency`.`currency_code` AS `t1_c1`, `currency`.`currency_symbol` AS `t1_c2` FROM `property` `t` LEFT OUTER JOIN `currency` `currency` ON (`currency`.`currency_id`=`t`.`currency_id`) WHERE (`t`.`domain_id`=:yp0). Bound with :yp0='233') 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `inventory_type`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `content_type`) 1 0.00056 0.00056 0.00056 0.00056
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `template`) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT `t`.`site_language_id` AS `t0_c0`, `t`.`site_name` AS `t0_c1`, `t`.`default_title` AS `t0_c2`, `t`.`default_img` AS `t0_c3`, `t`.`default_description` AS `t0_c4`, `t`.`default_keywords` AS `t0_c5`, `t`.`is_default` AS `t0_c6`, `t`.`site_id` AS `t0_c7`, `t`.`language_id` AS `t0_c8`, `site`.`site_id` AS `t1_c0`, `site`.`language_detect` AS `t1_c1`, `site`.`meta_hide` AS `t1_c2`, `site`.`create_date` AS `t1_c3`, `site`.`update_date` AS `t1_c4`, `site`.`publish_date` AS `t1_c5`, `site`.`type` AS `t1_c6`, `site`.`theme_id` AS `t1_c7`, `site`.`theme_elements` AS `t1_c8`, `site`.`template_id` AS `t1_c9`, `site`.`property_id` AS `t1_c10`, `site`.`album_id` AS `t1_c11`, `site`.`action_id` AS `t1_c12`, `site`.`logo_id` AS `t1_c13`, `site`.`original_id` AS `t1_c14`, `site`.`group_id` AS `t1_c15`, `site`.`is_geo` AS `t1_c16` FROM `site_language` `t` LEFT OUTER JOIN `site` `site` ON (`site`.`site_id`=`t`.`site_id`) WHERE (`t`.`site_id`=:yp0 AND `t`.`is_default`=:yp1). Bound with :yp0='7117', :yp1=1) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT `t`.`region_id` AS `t0_c0`, `t`.`region_name` AS `t0_c1`, `t`.`region_type` AS `t0_c2`, `t`.`parent_id` AS `t0_c3`, `t`.`featured_order` AS `t0_c4`, `t`.`is_active` AS `t0_c5`, `countryRegion`.`country_region_id` AS `t1_c0`, `countryRegion`.`country_id` AS `t1_c1`, `countryRegion`.`region_id` AS `t1_c2`, `countryRegion`.`is_default` AS `t1_c3` FROM `region` `t` LEFT OUTER JOIN `country_region` `countryRegion` ON (`countryRegion`.`region_id`=`t`.`region_id`) WHERE ((parent_id=:ycp41) AND (countryRegion.country_id=:ycp42)) ORDER BY region_name ASC. Bound with :ycp41='0', :ycp42='239') 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW CREATE TABLE `event_calendar`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT `t`.`property_id` AS `t0_c0`, `t`.`domain_id` AS `t0_c1`, `t`.`property_name` AS `t0_c2`, `t`.`street_address1` AS `t0_c3`, `t`.`street_address2` AS `t0_c4`, `t`.`zip_code` AS `t0_c5`, `t`.`state_province` AS `t0_c6`, `t`.`city` AS `t0_c7`, `t`.`country_id` AS `t0_c8`, `t`.`phone_number` AS `t0_c9`, `t`.`fax_number` AS `t0_c10`, `t`.`email` AS `t0_c11`, `t`.`location` AS `t0_c12`, `t`.`album_id` AS `t0_c13`, `t`.`avatar_id` AS `t0_c14`, `t`.`inventory_type_id` AS `t0_c15`, `t`.`user_id` AS `t0_c16`, `t`.`brand_id` AS `t0_c17`, `t`.`currency_id` AS `t0_c18`, `t`.`category_id` AS `t0_c19`, `t`.`index_id` AS `t0_c20`, `t`.`invoice` AS `t0_c21`, `t`.`tax` AS `t0_c22`, `t`.`status` AS `t0_c23`, `currency`.`currency_id` AS `t1_c0`, `currency`.`currency_code` AS `t1_c1`, `currency`.`currency_symbol` AS `t1_c2` FROM `property` `t` LEFT OUTER JOIN `currency` `currency` ON (`currency`.`currency_id`=`t`.`currency_id`) WHERE (`t`.`property_id`=1)) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT * FROM `method` `t` WHERE `t`.`method_type`=:yp0 AND `t`.`region_id`=:yp1. Bound with :yp0=1, :yp1='5') 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `contact`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `node_settings`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `person_session`) 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `property_user`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `site_page` `t` WHERE `t`.`parent_id`=:yp0 ORDER BY site_page_order. Bound with :yp0='31277') 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `template_page` `templatePage` WHERE (`templatePage`.`page_id`=:ypl0). Bound with :ypl0='174') 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `content_type` `t` WHERE `t`.`content_type_id`=0 LIMIT 1) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT `domain`.`domain_id` AS `t1_c0`, `domain`.`domain_name` AS `t1_c1`, `domain`.`domain_type` AS `t1_c2`, `domain`.`is_valid` AS `t1_c3`, `domain`.`user_id` AS `t1_c4`, `domain`.`is_ssl` AS `t1_c5` FROM `domain` `domain` WHERE (`domain`.`domain_id`=:ypl0). Bound with :ypl0='233') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT `avatar`.`media_id` AS `t1_c0`, `avatar`.`media_type` AS `t1_c1`, `avatar`.`media_src` AS `t1_c2`, `avatar`.`media_title` AS `t1_c3`, `avatar`.`media_description` AS `t1_c4`, `avatar`.`property_id` AS `t1_c5` FROM `media` `avatar` WHERE (`avatar`.`media_id`=:ypl0). Bound with :ypl0='0') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW CREATE TABLE `action_settings`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `currency`) 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SHOW CREATE TABLE `shipping`) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SHOW CREATE TABLE `node_settings`) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SELECT `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `template_page` `templatePage` WHERE (`templatePage`.`page_id`=:ypl0). Bound with :ypl0='175') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `template_widget`) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT * FROM `domain` `t` WHERE `t`.`domain_name`=:yp0 LIMIT 1. Bound with :yp0='skinmenu.com') 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SHOW CREATE TABLE `person_session`) 1 0.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT * FROM `site_page` `t` WHERE `t`.`template_page_id` IS NULL AND `t`.`site_language_id`=:yp0 AND `t`.`parent_id`=:yp1 LIMIT 1. Bound with :yp0='7117', :yp1=0) 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp50) AND (setting_name=:ycp51) LIMIT 1. Bound with :ycp50='2', :ycp51='site_7117') 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp54) AND (setting_name=:ycp55) LIMIT 1. Bound with :ycp54='2', :ycp55='site_7117') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT * FROM `property_user` `t` WHERE `t`.`property_id`=:yp0 AND `t`.`role_id`=:yp1. Bound with :yp0='1', :yp1=2) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT * FROM `site_domain` `t` WHERE `t`.`domain_id`=:yp0 LIMIT 1. Bound with :yp0='233') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT * FROM `country_region` `t` WHERE (country_id=:ycp45) AND (is_default=:ycp46) LIMIT 1. Bound with :ycp45='239', :ycp46='1') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT * FROM `content` `t` WHERE `t`.`content_id`=0 LIMIT 1) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `template_page` `templatePage` WHERE (`templatePage`.`page_id`=:ypl0). Bound with :ypl0='176') 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `currency`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `language`) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp58) AND (setting_name=:ycp59) LIMIT 1. Bound with :ycp58='2', :ycp59='site_7117') 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW CREATE TABLE `template`) 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT `templatePage`.`page_id` AS `t1_c0`, `templatePage`.`page_order` AS `t1_c1`, `templatePage`.`page_name` AS `t1_c2`, `templatePage`.`page_description` AS `t1_c3`, `templatePage`.`page_path` AS `t1_c4`, `templatePage`.`page_settings` AS `t1_c5`, `templatePage`.`page_content` AS `t1_c6`, `templatePage`.`template_id` AS `t1_c7`, `templatePage`.`customizable` AS `t1_c8` FROM `template_page` `templatePage` WHERE (`templatePage`.`page_id`=:ypl0). Bound with :ypl0='173') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT * FROM `node_settings` `t` WHERE (setting_type=:ycp56) AND (setting_name=:ycp57) LIMIT 1. Bound with :ycp56='2', :ycp57='site_7117') 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `person_alias`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SHOW CREATE TABLE `region`) 1 0.00044 0.00044 0.00044 0.00044
system.db.CDbCommand.query(SELECT * FROM `language` `t` WHERE `t`.`two_letter_code`=:yp0 LIMIT 1. Bound with :yp0='en-US') 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT * FROM `contact` `t` WHERE `t`.`property_id`=:yp0 ORDER BY contact_type. Bound with :yp0='1') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT * FROM `country_region` `t` WHERE (country_id=:ycp43) AND (is_default=:ycp44) LIMIT 1. Bound with :ycp43='239', :ycp44='1') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `redirect`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT `siteDomain`.`site_domain_id` AS `t1_c0`, `siteDomain`.`is_default` AS `t1_c1`, `siteDomain`.`domain_id` AS `t1_c2`, `siteDomain`.`site_id` AS `t1_c3`, `siteDomain`.`forward_all` AS `t1_c4` FROM `site_domain` `siteDomain` WHERE (`siteDomain`.`site_id`=:ypl0). Bound with :ypl0='7117') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `person`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT * FROM `category` `t` WHERE `t`.`category_id`=16 LIMIT 1) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SHOW CREATE TABLE `template_page`) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SHOW CREATE TABLE `media`) 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SHOW CREATE TABLE `theme_element`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `country_redirect`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `property_user`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `template_widget`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SELECT `category`.`category_id` AS `t1_c0`, `category`.`category_name` AS `t1_c1`, `category`.`category_settings` AS `t1_c2`, `category`.`parent_id` AS `t1_c3` FROM `category` `category` WHERE (`category`.`category_id`=:ypl0). Bound with :ypl0='16') 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `site_language`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT * FROM `property_user` `t` WHERE `t`.`user_id` IS NULL AND `t`.`is_active`=:yp0 LIMIT 1. Bound with :yp0=true) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `property_language`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `inventory`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `country`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `property`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `site_domain`) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SHOW CREATE TABLE `template_widget_settings`) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `category`) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `method`) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW CREATE TABLE `country_region`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `site_page`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `site`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `domain`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `page_widget`) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `content_type`) 1 0.00035 0.00035 0.00035 0.00035