Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Fiche`.`id`, `Fiche`.`name`, `Fiche`.`type`, `Fiche`.`slug`, `Fiche`.`format`, `Fiche`.`vignette`, `Fiche`.`ilustration0`, `Fiche`.`ilustration1`, `Fiche`.`ilustration2`, `Fiche`.`ilustration3`, `Fiche`.`content`, `Fiche`.`user_id`, `Fiche`.`active`, `Fiche`.`lastUserId`, `Fiche`.`parent_id`, `Fiche`.`lft`, `Fiche`.`rght`, `Fiche`.`created`, `Fiche`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`active`, `User`.`role`, `User`.`created`, `User`.`modified` FROM `garchix2020`.`fiches` AS `Fiche` LEFT JOIN `garchix2020`.`users` AS `User` ON (`Fiche`.`user_id` = `User`.`id`) WHERE `Fiche`.`slug` = 'appartement-e-marseille-camas' AND `Fiche`.`active` = '1' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Fiche`.`id`, `Fiche`.`name`, `Fiche`.`type`, `Fiche`.`slug`, `Fiche`.`format`, `Fiche`.`vignette`, `Fiche`.`ilustration0`, `Fiche`.`ilustration1`, `Fiche`.`ilustration2`, `Fiche`.`ilustration3`, `Fiche`.`content`, `Fiche`.`user_id`, `Fiche`.`active`, `Fiche`.`lastUserId`, `Fiche`.`parent_id`, `Fiche`.`lft`, `Fiche`.`rght`, `Fiche`.`created`, `Fiche`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`active`, `User`.`role`, `User`.`created`, `User`.`modified` FROM `garchix2020`.`fiches` AS `Fiche` LEFT JOIN `garchix2020`.`users` AS `User` ON (`Fiche`.`user_id` = `User`.`id`) WHERE `Fiche`.`active` = '1' ORDER BY `Fiche`.`lft` desc | 18 | 18 | 2 | maybe slow |
SELECT `Menu`.`id`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`name`, `Menu`.`position`, `Menu`.`classCss`, `Menu`.`idCss`, `Menu`.`active`, `Menu`.`cible`, `Menu`.`blank`, `Menu`.`noFollow`, `Menu`.`lienExterne`, `Menu`.`lienInterne`, `Content`.`id`, `Content`.`title`, `Content`.`slug` FROM `garchix2020`.`menus` AS `Menu` LEFT JOIN `garchix2020`.`contents` AS `Content` ON (`Menu`.`content_id` = `Content`.`id`) LEFT JOIN `garchix2020`.`users` AS `User` ON (`Menu`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `lft` ASC | 5 | 5 | 5 | |