Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`role`, `User`.`created`, `User`.`modified`, `User`.`email`, `User`.`forgetpwd`, `User`.`fio`, `User`.`company`, `User`.`phone`, `User`.`area_id`, `User`.`city`, `User`.`city_id`, `User`.`img`, `User`.`active_email`, `Area`.`id`, `Area`.`title_ru`, `Area`.`title_kz`, `Area`.`title_en`, `Area`.`priority`, `Area`.`created`, `Area`.`modified` FROM `user8634_ac`.`users` AS `User` LEFT JOIN `user8634_ac`.`areas` AS `Area` ON (`User`.`area_id` = `Area`.`id`) WHERE `User`.`role` = 'admin' | 1 | 1 | 3 | maybe slow |
SELECT `Setting`.`id`, `Setting`.`title`, `Setting`.`address`, `Setting`.`phone`, `Setting`.`phone2`, `Setting`.`fax`, `Setting`.`map_code`, `Setting`.`email`, `Setting`.`vk`, `Setting`.`fb`, `Setting`.`instagram`, `Setting`.`seo-main-title`, `Setting`.`body`, `Setting`.`seo-main-keywords`, `Setting`.`seo-main-description`, `Setting`.`main-title`, `Setting`.`description`, `Setting`.`pre_title`, `Setting`.`pre_text`, `Setting`.`pre2_title`, `Setting`.`pre2_text`, `Setting`.`pre3_title`, `Setting`.`pre3_text`, `Setting`.`service_text` FROM `user8634_ac`.`settings` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `City`.`id`, `City`.`title`, `City`.`alias`, `City`.`title_h1`, `City`.`title_h2`, `City`.`body`, `City`.`meta_title`, `City`.`meta_description`, `City`.`meta_keywords`, `City`.`about_meta_title`, `City`.`about_meta_description`, `City`.`about_meta_keywords`, `City`.`category_meta_title`, `City`.`category_meta_description`, `City`.`category_meta_keywords`, `City`.`pro_meta_title`, `City`.`pro_meta_description`, `City`.`pro_meta_keywords`, `City`.`contact_meta_title`, `City`.`contact_meta_description`, `City`.`contact_meta_keywords`, `City`.`print_meta_title`, `City`.`print_meta_description`, `City`.`print_meta_keywords`, `City`.`created`, `City`.`modified` FROM `user8634_ac`.`cities` AS `City` WHERE 1 = 1 | 4 | 4 | 1 | maybe slow |
SELECT `City`.`id`, `City`.`title`, `City`.`alias`, `City`.`title_h1`, `City`.`title_h2`, `City`.`body`, `City`.`meta_title`, `City`.`meta_description`, `City`.`meta_keywords`, `City`.`about_meta_title`, `City`.`about_meta_description`, `City`.`about_meta_keywords`, `City`.`category_meta_title`, `City`.`category_meta_description`, `City`.`category_meta_keywords`, `City`.`pro_meta_title`, `City`.`pro_meta_description`, `City`.`pro_meta_keywords`, `City`.`contact_meta_title`, `City`.`contact_meta_description`, `City`.`contact_meta_keywords`, `City`.`print_meta_title`, `City`.`print_meta_description`, `City`.`print_meta_keywords`, `City`.`created`, `City`.`modified` FROM `user8634_ac`.`cities` AS `City` WHERE `City`.`alias` = 'nur-sultan' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Contact`.`id`, `Contact`.`title`, `Contact`.`city`, `Contact`.`address`, `Contact`.`email`, `Contact`.`phone`, `Contact`.`phone2`, `Contact`.`map`, `Contact`.`created`, `Contact`.`modified` FROM `user8634_ac`.`contacts` AS `Contact` WHERE `Contact`.`city` = 'nur-sultan' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Partner`.`id`, `Partner`.`img`, `Partner`.`title`, `Partner`.`link`, `Partner`.`body`, `Partner`.`created`, `Partner`.`modified`, (`I18n__title`.`content`) AS `Partner__i18n_title`, (`I18n__body`.`content`) AS `Partner__i18n_body` FROM `user8634_ac`.`partners` AS `Partner` INNER JOIN `user8634_ac`.`i18n` AS `I18n__title` ON (`Partner`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Partner' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ru') INNER JOIN `user8634_ac`.`i18n` AS `I18n__body` ON (`Partner`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Partner' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'ru') WHERE 1 = 1 | 4 | 4 | 1 | maybe slow |
SELECT COUNT(DISTINCT(`News`.`id`)) AS count FROM `user8634_ac`.`news` AS `News` INNER JOIN `user8634_ac`.`i18n` AS `I18nModel` ON (`News`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'News' AND `I18nModel`.`locale` = 'ru') WHERE 1 = 1 | 1 | 1 | 2 | maybe slow |
SELECT `News`.`id`, `News`.`title`, `News`.`alias`, `News`.`body`, `News`.`date`, `News`.`img`, `News`.`img2`, `News`.`keywords`, `News`.`description`, `News`.`created`, `News`.`modified`, (`I18n__title`.`content`) AS `News__i18n_title`, (`I18n__body`.`content`) AS `News__i18n_body`, (`I18n__keywords`.`content`) AS `News__i18n_keywords`, (`I18n__description`.`content`) AS `News__i18n_description` FROM `user8634_ac`.`news` AS `News` INNER JOIN `user8634_ac`.`i18n` AS `I18n__title` ON (`News`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'News' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ru') INNER JOIN `user8634_ac`.`i18n` AS `I18n__body` ON (`News`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'News' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'ru') INNER JOIN `user8634_ac`.`i18n` AS `I18n__keywords` ON (`News`.`id` = `I18n__keywords`.`foreign_key` AND `I18n__keywords`.`model` = 'News' AND `I18n__keywords`.`field` = 'keywords' AND `I18n__keywords`.`locale` = 'ru') INNER JOIN `user8634_ac`.`i18n` AS `I18n__description` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'News' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ru') WHERE 1 = 1 ORDER BY `News`.`date` DESC, `News`.`id` DESC LIMIT 9 | 9 | 9 | 1 | maybe slow |
SELECT `City`.`id`, `City`.`title`, `City`.`alias`, `City`.`title_h1`, `City`.`title_h2`, `City`.`body`, `City`.`meta_title`, `City`.`meta_description`, `City`.`meta_keywords`, `City`.`about_meta_title`, `City`.`about_meta_description`, `City`.`about_meta_keywords`, `City`.`category_meta_title`, `City`.`category_meta_description`, `City`.`category_meta_keywords`, `City`.`pro_meta_title`, `City`.`pro_meta_description`, `City`.`pro_meta_keywords`, `City`.`contact_meta_title`, `City`.`contact_meta_description`, `City`.`contact_meta_keywords`, `City`.`print_meta_title`, `City`.`print_meta_description`, `City`.`print_meta_keywords`, `City`.`created`, `City`.`modified` FROM `user8634_ac`.`cities` AS `City` WHERE `City`.`alias` = 'nur-sultan' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Comp`.`id`, `Comp`.`body`, `Comp`.`media`, `Comp`.`comments`, `Comp`.`created`, `Comp`.`modified` FROM `user8634_ac`.`comps` AS `Comp` WHERE `Comp`.`id` = 8 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Comp`.`id`, `Comp`.`body`, `Comp`.`media`, `Comp`.`comments`, `Comp`.`created`, `Comp`.`modified` FROM `user8634_ac`.`comps` AS `Comp` WHERE `Comp`.`id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Comp`.`id`, `Comp`.`body`, `Comp`.`media`, `Comp`.`comments`, `Comp`.`created`, `Comp`.`modified` FROM `user8634_ac`.`comps` AS `Comp` WHERE `Comp`.`id` = 7 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Comp`.`id`, `Comp`.`body`, `Comp`.`media`, `Comp`.`comments`, `Comp`.`created`, `Comp`.`modified` FROM `user8634_ac`.`comps` AS `Comp` WHERE `Comp`.`id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Comp`.`id`, `Comp`.`body`, `Comp`.`media`, `Comp`.`comments`, `Comp`.`created`, `Comp`.`modified` FROM `user8634_ac`.`comps` AS `Comp` WHERE `Comp`.`id` = 8 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Comp`.`id`, `Comp`.`body`, `Comp`.`media`, `Comp`.`comments`, `Comp`.`created`, `Comp`.`modified` FROM `user8634_ac`.`comps` AS `Comp` WHERE `Comp`.`id` = 9 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Comp`.`id`, `Comp`.`body`, `Comp`.`media`, `Comp`.`comments`, `Comp`.`created`, `Comp`.`modified` FROM `user8634_ac`.`comps` AS `Comp` WHERE `Comp`.`id` = 7 LIMIT 1 | 1 | 1 | 1 | |