| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Magasin`.`id`, `Magasin`.`nom`, `Magasin`.`logo`, `Magasin`.`photo`, `Magasin`.`bandeau`, `Magasin`.`adresse`, `Magasin`.`intro`, `Magasin`.`texte`, `Magasin`.`mail`, `Magasin`.`telephone`, `Magasin`.`lien`, `Magasin`.`facebook`, `Magasin`.`twitter`, `Magasin`.`statut`, `Magasin`.`departement_id`, `Magasin`.`user_id`, `Magasin`.`lat`, `Magasin`.`lng`, `Magasin`.`date_fin`, `Magasin`.`vues`, `Magasin`.`magasin_type_id`, `Magasin`.`instagram`, `Magasin`.`contactform`, `Magasin`.`youtube`, `Magasin`.`label`, `Magasin`.`vedette`, `Magasin`.`galery_id`, `Magasin`.`slug`, `Magasin`.`created`, `Magasin`.`updated`, `Magasin`.`code_postal`, `Magasin`.`ville`, `MagasinType`.`id`, `MagasinType`.`nom`, `MagasinType`.`ordre`, `MagasinType`.`slug`, `MagasinType`.`article`, `Departement`.`id`, `Departement`.`departement_code`, `Departement`.`departement_nom`, `Departement`.`departement_nom_uppercase`, `Departement`.`departement_slug`, `Departement`.`departement_nom_soundex`, `Departement`.`country_id`, `Departement`.`article`, `Departement`.`ordre`, `Departement`.`pays_id`, (CONCAT(`Departement`.`departement_code`, " - ", `Departement`.`departement_nom`)) AS `Departement__code_nom`, `Galery`.`id`, `Galery`.`titre`, `Galery`.`created`, `Galery`.`updated` FROM `isoprod`.`magasins` AS `Magasin` LEFT JOIN `isoprod`.`magasins_types` AS `MagasinType` ON (`Magasin`.`magasin_type_id` = `MagasinType`.`id`) LEFT JOIN `isoprod`.`departements` AS `Departement` ON (`Magasin`.`departement_id` = `Departement`.`id`) LEFT JOIN `isoprod`.`galeries` AS `Galery` ON (`Magasin`.`galery_id` = `Galery`.`id`) WHERE `Magasin`.`id` = 83 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`name_fr` FROM `isoprod`.`countries` AS `Country` WHERE `Country`.`id` = 74 | 1 | 1 | 0 | |
| SELECT `Marque`.`id`, `Marque`.`nom`, `Marque`.`slug`, `MagasinsMarque`.`id`, `MagasinsMarque`.`magasin_id`, `MagasinsMarque`.`marque_id` FROM `isoprod`.`marques` AS `Marque` JOIN `isoprod`.`magasins_marques` AS `MagasinsMarque` ON (`MagasinsMarque`.`magasin_id` = 83 AND `MagasinsMarque`.`marque_id` = `Marque`.`id`) | 1 | 1 | 1 | |
| SELECT `Service`.`id`, `Service`.`nom`, `Service`.`slug`, `Service`.`article`, `MagasinsService`.`id`, `MagasinsService`.`magasin_id`, `MagasinsService`.`service_id` FROM `isoprod`.`services` AS `Service` JOIN `isoprod`.`magasins_services` AS `MagasinsService` ON (`MagasinsService`.`magasin_id` = 83 AND `MagasinsService`.`service_id` = `Service`.`id`) | 3 | 3 | 3 | |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `isoprod`.`magasins` AS `Magasin` WHERE `Magasin`.`id` = 83 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `isoprod`.`magasins` AS `Magasin` WHERE `Magasin`.`id` = 83 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `isoprod`.`magasins` AS `Magasin` WHERE `Magasin`.`id` = 83 | 1 | 1 | 0 | |
| UPDATE `isoprod`.`magasins` SET `vues` = 4234, `updated` = '2025-10-29 13:04:57' WHERE `isoprod`.`magasins`.`id` = '83' | 1 | 1 | 0 | |
| COMMIT | | | | |
| BEGIN | | | | |
| INSERT INTO `isoprod`.`magasins_vues` (`magasin_id`, `user_id`, `ip`, `created`) VALUES (83, NULL, '216.73.216.134', '2025-10-29 13:04:57') | 1 | 1 | 0 | |
| COMMIT | | | | |
| SELECT `Country`.`id`, `Country`.`name_fr` FROM `isoprod`.`countries` AS `Country` WHERE 1 = 1 ORDER BY `name_fr` ASC | 244 | 244 | 1 | |
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `isoprod`.`configs` AS `Config` WHERE `categorie` = 'v3' | 8 | 8 | 0 | |
4 duplicate queries run.
