Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Article`.`id`, `Article`.`name`, `Article`.`slug`, `Article`.`content`, `Article`.`created`, `Article`.`online`, `Article`.`media_id`, `Article`.`acategory_id`, `Article`.`views`, `Article`.`modified`, `Article`.`location`, `Article`.`price`, `Article`.`retail`, `Article`.`fpa_23`, `Article`.`fpa_13`, `Article`.`reduction_box`, `Article`.`reduction`, `Article`.`price_reduction`, `Article`.`retail_reduction`, `Article`.`weight`, `Article`.`mycomments`, `Article`.`manufactor_id`, `Article`.`tags`, `Article`.`youtube_url`, `Article`.`keywords`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__contentTranslation`.`content`) AS `Article__i18n_contentTranslation`, (`I18n__tagsTranslation`.`content`) AS `Article__i18n_tagsTranslation`, (`I18n__keywordsTranslation`.`content`) AS `Article__i18n_keywordsTranslation`, `Acategory`.`id`, `Acategory`.`name`, `Acategory`.`slug`, `Acategory`.`product_count`, `Acategory`.`content`, `Acategory`.`parent_id`, `Acategory`.`lft`, `Acategory`.`rght`, `Acategory`.`online`, `Acategory`.`media_id`, `Acategory`.`created`, `Acategory`.`url`, `Acategory`.`footer`, `Acategory`.`menu`, `Acategory`.`layout`, `Acategory`.`articles_layout`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position`, `Thumb`.`title` FROM `artadanceschool_website_db`.`articles` AS `Article` LEFT JOIN `artadanceschool_website_db`.`acategories` AS `Acategory` ON (`Article`.`acategory_id` = `Acategory`.`id`) LEFT JOIN `artadanceschool_website_db`.`medias` AS `Thumb` ON (`Article`.`media_id` = `Thumb`.`id`) INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__contentTranslation` ON (`Article`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Article' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__tagsTranslation` ON (`Article`.`id` = `I18n__tagsTranslation`.`foreign_key` AND `I18n__tagsTranslation`.`model` = 'Article' AND `I18n__tagsTranslation`.`field` = 'tags' AND `I18n__tagsTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__keywordsTranslation` ON (`Article`.`id` = `I18n__keywordsTranslation`.`foreign_key` AND `I18n__keywordsTranslation`.`model` = 'Article' AND `I18n__keywordsTranslation`.`field` = 'keywords' AND `I18n__keywordsTranslation`.`locale` = 'gre') WHERE `Article`.`id` = 21 AND `Article`.`online` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Pdf`.`id`, `Pdf`.`name`, `Pdf`.`url`, `Pdf`.`type`, `Pdf`.`alt`, `Pdf`.`product_id`, `Pdf`.`article_id`, `Pdf`.`item_id` FROM `artadanceschool_website_db`.`pdfs` AS `Pdf` WHERE `Pdf`.`article_id` = (21) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (21) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `contentTranslation` WHERE `model` = 'Article' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (21) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `tagsTranslation`.`id`, `tagsTranslation`.`locale`, `tagsTranslation`.`model`, `tagsTranslation`.`foreign_key`, `tagsTranslation`.`field`, `tagsTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `tagsTranslation` WHERE `model` = 'Article' AND `field` = 'tags' AND `tagsTranslation`.`foreign_key` = (21) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `keywordsTranslation`.`id`, `keywordsTranslation`.`locale`, `keywordsTranslation`.`model`, `keywordsTranslation`.`foreign_key`, `keywordsTranslation`.`field`, `keywordsTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `keywordsTranslation` WHERE `model` = 'Article' AND `field` = 'keywords' AND `keywordsTranslation`.`foreign_key` = (21) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`title` FROM `artadanceschool_website_db`.`medias` AS `Media` WHERE ref = "Article" AND `Media`.`ref_id` = (21) ORDER BY `Media`.`position` ASC | 8 | 8 | 0 | |
UPDATE `artadanceschool_website_db`.`articles` AS `Article` LEFT JOIN `artadanceschool_website_db`.`acategories` AS `Acategory` ON (`Article`.`acategory_id` = `Acategory`.`id`) LEFT JOIN `artadanceschool_website_db`.`medias` AS `Thumb` ON (`Article`.`media_id` = `Thumb`.`id`) SET `Article`.`views` = Article.views + 1 WHERE `Article`.`id` = 21 | 1 | 1 | 0 | |
SELECT `Acategory`.`id`, `Acategory`.`name`, `Acategory`.`slug`, `Acategory`.`product_count`, `Acategory`.`content`, `Acategory`.`parent_id`, `Acategory`.`lft`, `Acategory`.`rght`, `Acategory`.`online`, `Acategory`.`media_id`, `Acategory`.`created`, `Acategory`.`url`, `Acategory`.`footer`, `Acategory`.`menu`, `Acategory`.`layout`, `Acategory`.`articles_layout`, (`I18n__nameTranslation`.`content`) AS `Acategory__i18n_nameTranslation`, (`I18n__contentTranslation`.`content`) AS `Acategory__i18n_contentTranslation`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position`, `Thumb`.`title` FROM `artadanceschool_website_db`.`acategories` AS `Acategory` LEFT JOIN `artadanceschool_website_db`.`medias` AS `Thumb` ON (`Acategory`.`media_id` = `Thumb`.`id`) INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__nameTranslation` ON (`Acategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Acategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__contentTranslation` ON (`Acategory`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Acategory' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'gre') WHERE `Acategory`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `nameTranslation` WHERE `model` = 'Acategory' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `contentTranslation` WHERE `model` = 'Acategory' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (1) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`title` FROM `artadanceschool_website_db`.`medias` AS `Media` WHERE ref = "Acategory" AND `Media`.`ref_id` = (1) ORDER BY `Media`.`position` ASC | 0 | 0 | 0 | |
SELECT `Acategory`.`lft`, `Acategory`.`rght` FROM `artadanceschool_website_db`.`acategories` AS `Acategory` WHERE `Acategory`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Acategory`.`id`, `Acategory`.`name`, `Acategory`.`slug`, `Acategory`.`product_count`, `Acategory`.`content`, `Acategory`.`parent_id`, `Acategory`.`lft`, `Acategory`.`rght`, `Acategory`.`online`, `Acategory`.`media_id`, `Acategory`.`created`, `Acategory`.`url`, `Acategory`.`footer`, `Acategory`.`menu`, `Acategory`.`layout`, `Acategory`.`articles_layout`, (`I18n__nameTranslation`.`content`) AS `Acategory__i18n_nameTranslation`, (`I18n__contentTranslation`.`content`) AS `Acategory__i18n_contentTranslation` FROM `artadanceschool_website_db`.`acategories` AS `Acategory` INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__nameTranslation` ON (`Acategory`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Acategory' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__contentTranslation` ON (`Acategory`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Acategory' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'gre') WHERE 1 = 1 AND `Acategory`.`lft` <= 1 AND `Acategory`.`rght` >= 2 ORDER BY `Acategory`.`lft` asc | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`slug` FROM `artadanceschool_website_db`.`articles` AS `Article` LEFT JOIN `artadanceschool_website_db`.`acategories` AS `Acategory` ON (`Article`.`acategory_id` = `Acategory`.`id`) LEFT JOIN `artadanceschool_website_db`.`medias` AS `Thumb` ON (`Article`.`media_id` = `Thumb`.`id`) WHERE `Article`.`online` = 1 AND `Article`.`acategory_id` = 1 AND `Article`.`id` < 21 ORDER BY `Article`.`id` DESC LIMIT 1 | 0 | 0 | 0 | |
SELECT `Article`.`id`, `Article`.`slug` FROM `artadanceschool_website_db`.`articles` AS `Article` LEFT JOIN `artadanceschool_website_db`.`acategories` AS `Acategory` ON (`Article`.`acategory_id` = `Acategory`.`id`) LEFT JOIN `artadanceschool_website_db`.`medias` AS `Thumb` ON (`Article`.`media_id` = `Thumb`.`id`) WHERE `Article`.`online` = 1 AND `Article`.`acategory_id` = 1 AND `Article`.`id` > 21 ORDER BY `Article`.`id` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Pdf`.`id`, `Pdf`.`name`, `Pdf`.`url`, `Pdf`.`type`, `Pdf`.`alt`, `Pdf`.`product_id`, `Pdf`.`article_id`, `Pdf`.`item_id` FROM `artadanceschool_website_db`.`pdfs` AS `Pdf` WHERE `Pdf`.`article_id` = (22) | 0 | 0 | 0 | |
SELECT `nameTranslation`.`id`, `nameTranslation`.`locale`, `nameTranslation`.`model`, `nameTranslation`.`foreign_key`, `nameTranslation`.`field`, `nameTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `nameTranslation` WHERE `model` = 'Article' AND `field` = 'name' AND `nameTranslation`.`foreign_key` = (22) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `contentTranslation`.`id`, `contentTranslation`.`locale`, `contentTranslation`.`model`, `contentTranslation`.`foreign_key`, `contentTranslation`.`field`, `contentTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `contentTranslation` WHERE `model` = 'Article' AND `field` = 'content' AND `contentTranslation`.`foreign_key` = (22) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `tagsTranslation`.`id`, `tagsTranslation`.`locale`, `tagsTranslation`.`model`, `tagsTranslation`.`foreign_key`, `tagsTranslation`.`field`, `tagsTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `tagsTranslation` WHERE `model` = 'Article' AND `field` = 'tags' AND `tagsTranslation`.`foreign_key` = (22) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `keywordsTranslation`.`id`, `keywordsTranslation`.`locale`, `keywordsTranslation`.`model`, `keywordsTranslation`.`foreign_key`, `keywordsTranslation`.`field`, `keywordsTranslation`.`content` FROM `artadanceschool_website_db`.`i18n` AS `keywordsTranslation` WHERE `model` = 'Article' AND `field` = 'keywords' AND `keywordsTranslation`.`foreign_key` = (22) ORDER BY `id` ASC | 3 | 3 | 0 | |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`title` FROM `artadanceschool_website_db`.`medias` AS `Media` WHERE ref = "Article" AND `Media`.`ref_id` = (22) ORDER BY `Media`.`position` ASC | 2 | 2 | 0 | |
SELECT `Article`.`id`, `Article`.`name`, `Article`.`slug`, `Article`.`content`, `Article`.`created`, `Article`.`online`, `Article`.`media_id`, `Article`.`acategory_id`, `Article`.`views`, `Article`.`modified`, `Article`.`location`, `Article`.`price`, `Article`.`retail`, `Article`.`fpa_23`, `Article`.`fpa_13`, `Article`.`reduction_box`, `Article`.`reduction`, `Article`.`price_reduction`, `Article`.`retail_reduction`, `Article`.`weight`, `Article`.`mycomments`, `Article`.`manufactor_id`, `Article`.`tags`, `Article`.`youtube_url`, `Article`.`keywords`, (`I18n__nameTranslation`.`content`) AS `Article__i18n_nameTranslation`, (`I18n__contentTranslation`.`content`) AS `Article__i18n_contentTranslation`, (`I18n__tagsTranslation`.`content`) AS `Article__i18n_tagsTranslation`, (`I18n__keywordsTranslation`.`content`) AS `Article__i18n_keywordsTranslation` FROM `artadanceschool_website_db`.`articles` AS `Article` INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__nameTranslation` ON (`Article`.`id` = `I18n__nameTranslation`.`foreign_key` AND `I18n__nameTranslation`.`model` = 'Article' AND `I18n__nameTranslation`.`field` = 'name' AND `I18n__nameTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__contentTranslation` ON (`Article`.`id` = `I18n__contentTranslation`.`foreign_key` AND `I18n__contentTranslation`.`model` = 'Article' AND `I18n__contentTranslation`.`field` = 'content' AND `I18n__contentTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__tagsTranslation` ON (`Article`.`id` = `I18n__tagsTranslation`.`foreign_key` AND `I18n__tagsTranslation`.`model` = 'Article' AND `I18n__tagsTranslation`.`field` = 'tags' AND `I18n__tagsTranslation`.`locale` = 'gre') INNER JOIN `artadanceschool_website_db`.`i18n` AS `I18n__keywordsTranslation` ON (`Article`.`id` = `I18n__keywordsTranslation`.`foreign_key` AND `I18n__keywordsTranslation`.`model` = 'Article' AND `I18n__keywordsTranslation`.`field` = 'keywords' AND `I18n__keywordsTranslation`.`locale` = 'gre') WHERE `Article`.`online` = 1 ORDER BY `Article`.`created` DESC LIMIT 4 | 4 | 4 | 1 | maybe slow |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`title` FROM `artadanceschool_website_db`.`medias` AS `Media` WHERE ref = "Article" AND `Media`.`ref_id` IN (25, 24, 23, 21) ORDER BY `Media`.`position` ASC | 19 | 19 | 0 | |