Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`img`, `Gallery`.`album_id`, (`I18n__title`.`content`) AS `Gallery__i18n_title`, `Album`.`id`, `Album`.`category_id`, `Album`.`title`, `Album`.`img`, `Album`.`created`, `Album`.`modified` FROM `p-786_db`.`galleries` AS `Gallery` LEFT JOIN `p-786_db`.`albums` AS `Album` ON (`Gallery`.`album_id` = `Album`.`id`) INNER JOIN `p-786_db`.`i18n` AS `I18n__title` ON (`Gallery`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Gallery' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ru') WHERE 1 = 1 ORDER BY `Gallery`.`id` desc LIMIT 5 | 5 | 5 | 0 | |
SELECT `Certification`.`id`, `Certification`.`img` FROM `p-786_db`.`certifications` AS `Certification` WHERE 1 = 1 | 10 | 10 | 1 | maybe slow |
SELECT `Video`.`id`, `Video`.`title`, `Video`.`link`, (`I18n__title`.`content`) AS `Video__i18n_title` FROM `p-786_db`.`videos` AS `Video` INNER JOIN `p-786_db`.`i18n` AS `I18n__title` ON (`Video`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Video' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ru') WHERE 1 = 1 ORDER BY `Video`.`id` desc LIMIT 6 | 5 | 5 | 6 | maybe slow |
SELECT `News`.`id`, `News`.`date`, `News`.`img`, (`I18n__title`.`content`) AS `News__i18n_title` FROM `p-786_db`.`news` AS `News` INNER JOIN `p-786_db`.`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') WHERE `category` = 'news' ORDER BY `News`.`date` desc LIMIT 4 | 4 | 4 | 7 | maybe slow |
SELECT `News`.`id`, `News`.`date`, `News`.`img`, (`I18n__title`.`content`) AS `News__i18n_title` FROM `p-786_db`.`news` AS `News` INNER JOIN `p-786_db`.`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') WHERE `category` = 'otrasl' ORDER BY `News`.`date` desc LIMIT 4 | 4 | 4 | 9 | maybe slow |
SELECT `News`.`id`, `News`.`date`, `News`.`img`, (`I18n__title`.`content`) AS `News__i18n_title` FROM `p-786_db`.`news` AS `News` INNER JOIN `p-786_db`.`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') WHERE `category` = 'doska' ORDER BY `News`.`date` desc LIMIT 4 | 4 | 4 | 25 | maybe slow |
SELECT `Album`.`id`, `Album`.`category_id`, `Album`.`title`, `Album`.`img`, `Album`.`created`, `Album`.`modified`, (`I18n__title`.`content`) AS `Album__i18n_title` FROM `p-786_db`.`albums` AS `Album` INNER JOIN `p-786_db`.`i18n` AS `I18n__title` ON (`Album`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Album' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ru') WHERE 1 = 1 ORDER BY `Album`.`id` desc LIMIT 6 | 6 | 6 | 32 | maybe slow |
SELECT `Gallery`.`id`, `Gallery`.`title`, `Gallery`.`img`, `Gallery`.`album_id` FROM `p-786_db`.`galleries` AS `Gallery` WHERE `Gallery`.`album_id` IN (13, 12, 11, 10, 9, 8) | 40 | 40 | 2 | maybe slow |
SELECT `Slide`.`id`, `Slide`.`title`, `Slide`.`link`, `Slide`.`img`, (`I18n__title`.`content`) AS `Slide__i18n_title` FROM `p-786_db`.`slides` AS `Slide` INNER JOIN `p-786_db`.`i18n` AS `I18n__title` ON (`Slide`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Slide' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'ru') WHERE 1 = 1 ORDER BY `Slide`.`id` desc | 7 | 7 | 6 | maybe slow |
SELECT `Page`.`id`, `Page`.`title`, `Page`.`body`, `Page`.`keywords`, `Page`.`description`, `Page`.`created`, `Page`.`modified`, `Page`.`alias`, (`I18n__keywords`.`content`) AS `Page__i18n_keywords`, (`I18n__description`.`content`) AS `Page__i18n_description`, (`I18n__titleTranslation`.`content`) AS `Page__i18n_titleTranslation`, (`I18n__bodyTranslation`.`content`) AS `Page__i18n_bodyTranslation` FROM `p-786_db`.`pages` AS `Page` INNER JOIN `p-786_db`.`i18n` AS `I18n__keywords` ON (`Page`.`id` = `I18n__keywords`.`foreign_key` AND `I18n__keywords`.`model` = 'Page' AND `I18n__keywords`.`field` = 'keywords' AND `I18n__keywords`.`locale` = 'ru') INNER JOIN `p-786_db`.`i18n` AS `I18n__description` ON (`Page`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Page' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'ru') INNER JOIN `p-786_db`.`i18n` AS `I18n__titleTranslation` ON (`Page`.`id` = `I18n__titleTranslation`.`foreign_key` AND `I18n__titleTranslation`.`model` = 'Page' AND `I18n__titleTranslation`.`field` = 'title' AND `I18n__titleTranslation`.`locale` = 'ru') INNER JOIN `p-786_db`.`i18n` AS `I18n__bodyTranslation` ON (`Page`.`id` = `I18n__bodyTranslation`.`foreign_key` AND `I18n__bodyTranslation`.`model` = 'Page' AND `I18n__bodyTranslation`.`field` = 'body' AND `I18n__bodyTranslation`.`locale` = 'ru') WHERE `Page`.`id` = 1 LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `titleTranslation`.`id`, `titleTranslation`.`locale`, `titleTranslation`.`model`, `titleTranslation`.`foreign_key`, `titleTranslation`.`field`, `titleTranslation`.`content` FROM `p-786_db`.`i18n` AS `titleTranslation` WHERE `model` = 'Page' AND `field` = 'title' AND `titleTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 2 | 2 | 13 | maybe slow |
SELECT `bodyTranslation`.`id`, `bodyTranslation`.`locale`, `bodyTranslation`.`model`, `bodyTranslation`.`foreign_key`, `bodyTranslation`.`field`, `bodyTranslation`.`content` FROM `p-786_db`.`i18n` AS `bodyTranslation` WHERE `model` = 'Page' AND `field` = 'body' AND `bodyTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 2 | 2 | 14 | maybe slow |