Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Slide`.`id`, `Slide`.`title`, `Slide`.`img`, `Slide`.`priority`, `Slide`.`body`, `Slide`.`link`, `Slide`.`created`, `Slide`.`modified`, (`I18n__body`.`content`) AS `Slide__i18n_body`, (`I18n__titleTranslation`.`content`) AS `Slide__i18n_titleTranslation` FROM `acqhkz_new`.`slides` AS `Slide` INNER JOIN `acqhkz_new`.`i18n` AS `I18n__body` ON (`Slide`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'Slide' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'ru') INNER JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation` ON (`Slide`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Slide' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ru') WHERE 1 = 1 ORDER BY `Slide`.`priority` DESC | 0 | 0 | 1 | maybe slow |
SELECT `MainCard`.`id`, `MainCard`.`img`, `MainCard`.`link`, `MainCard`.`title`, `MainCard`.`created`, `MainCard`.`modified`, (`I18n__body`.`content`) AS `MainCard__i18n_body`, (`I18n__titleTranslation`.`content`) AS `MainCard__i18n_titleTranslation` FROM `acqhkz_new`.`main_cards` AS `MainCard` INNER JOIN `acqhkz_new`.`i18n` AS `I18n__body` ON (`MainCard`.`id` = `I18n__body`.`foreign_key` AND `I18n__body`.`model` = 'MainCard' AND `I18n__body`.`field` = 'body' AND `I18n__body`.`locale` = 'ru') INNER JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation` ON (`MainCard`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'MainCard' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ru') WHERE 1 = 1 | 4 | 4 | 2 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `acqhkz_new`.`i18n` AS `titleTranslation` WHERE `model` = 'MainCard' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (27, 29, 30, 34) ORDER BY `id` ASC | 5 | 5 | 1 | maybe slow |
SELECT `Figure`.`id`, `Figure`.`title`, `Figure`.`number`, `Figure`.`created`, `Figure`.`modified`, (`I18n__titleTranslation`.`content`) AS `Figure__i18n_titleTranslation` FROM `acqhkz_new`.`figures` AS `Figure` INNER JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation` ON (`Figure`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Figure' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ru') WHERE 1 = 1 | 6 | 6 | 2 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `acqhkz_new`.`i18n` AS `titleTranslation` WHERE `model` = 'Figure' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (3, 4, 5, 6, 7, 8) ORDER BY `id` ASC | 6 | 6 | 1 | maybe slow |
SELECT `Partner`.`id`, `Partner`.`img`, `Partner`.`url`, `Partner`.`created`, `Partner`.`modified` FROM `acqhkz_new`.`partners` AS `Partner` WHERE 1 = 1 | 11 | 11 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`region_name`, `Category`.`alias`, `Category`.`count_mo`, `Category`.`count_gobmp`, `Category`.`count_mo_accredit`, `Category`.`procent_mo_accredit`, `Category`.`count_no_mo_accredit`, `Category`.`procent_no_mo_accredit`, `Category`.`map_code`, `Category`.`total_mo`, `Category`.`accredited`, `Category`.`no_status`, `Category`.`recalled`, `Category`.`region_exp`, `Category`.`denied`, `Category`.`doc`, `Category`.`created`, `Category`.`modified`, (`I18n__region_name__en`.`content`) AS `Category__i18n_region_name_en`, (`I18n__region_name__kz`.`content`) AS `Category__i18n_region_name_kz`, (`I18n__titleTranslation__en`.`content`) AS `Category__i18n_titleTranslation_en`, (`I18n__titleTranslation__kz`.`content`) AS `Category__i18n_titleTranslation_kz` FROM `acqhkz_new`.`categories` AS `Category` LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__region_name__en` ON (`Category`.`id` = `I18n__region_name__en`.`foreign_key` AND `I18n__region_name__en`.`model` = 'Category' AND `I18n__region_name__en`.`field` = 'region_name' AND `I18n__region_name__en`.`locale` = 'en') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__region_name__kz` ON (`Category`.`id` = `I18n__region_name__kz`.`foreign_key` AND `I18n__region_name__kz`.`model` = 'Category' AND `I18n__region_name__kz`.`field` = 'region_name' AND `I18n__region_name__kz`.`locale` = 'kz') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation__en` ON (`Category`.`id` = `I18n__titleTranslation__en`.`foreign_key` AND `I18n__titleTranslation__en`.`model` = 'Category' AND `I18n__titleTranslation__en`.`field` = 'title' AND `I18n__titleTranslation__en`.`locale` = 'en') LEFT JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation__kz` ON (`Category`.`id` = `I18n__titleTranslation__kz`.`foreign_key` AND `I18n__titleTranslation__kz`.`model` = 'Category' AND `I18n__titleTranslation__kz`.`field` = 'title' AND `I18n__titleTranslation__kz`.`locale` = 'kz') WHERE 1 = 1 | 18 | 18 | 232 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `acqhkz_new`.`i18n` AS `titleTranslation` WHERE `model` = 'Category' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18) ORDER BY `id` ASC | 18 | 18 | 2 | maybe slow |
SELECT `News`.`id`, `News`.`title`, `News`.`alias`, `News`.`type_id`, `News`.`date`, `News`.`img`, `News`.`body`, `News`.`keywords`, `News`.`description`, `News`.`created`, `News`.`modified`, (`I18n__body`.`content`) AS `News__i18n_body`, (`I18n__keywords`.`content`) AS `News__i18n_keywords`, (`I18n__description`.`content`) AS `News__i18n_description`, (`I18n__titleTranslation`.`content`) AS `News__i18n_titleTranslation` FROM `acqhkz_new`.`news` AS `News` INNER JOIN `acqhkz_new`.`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 `acqhkz_new`.`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 `acqhkz_new`.`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') INNER JOIN `acqhkz_new`.`i18n` AS `I18n__titleTranslation` ON (`News`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'News' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ru') WHERE 1 = 1 ORDER BY `News`.`date` DESC LIMIT 5 | 5 | 5 | 14 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `acqhkz_new`.`i18n` AS `titleTranslation` WHERE `model` = 'News' AND `field` = 'title' AND `titleTranslation`.`foreign_key` IN (21, 20, 19, 18, 17) ORDER BY `id` ASC | 5 | 5 | 2 | maybe slow |