| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Spot`.`id`, `Spot`.`titre`, `Spot`.`photo`, `Spot`.`user_id`, `Spot`.`description`, `Spot`.`departement_id`, `Spot`.`slug`, `Spot`.`galery_id`, `Spot`.`guide_description`, `Spot`.`statut`, `Spot`.`adresse`, `Spot`.`lng`, `Spot`.`lat`, `Spot`.`question1`, `Spot`.`reponse1`, `Spot`.`question2`, `Spot`.`reponse2`, `Spot`.`question3`, `Spot`.`reponse3`, `Spot`.`question4`, `Spot`.`reponse4`, `Spot`.`vues`, `Spot`.`created`, `Spot`.`ffc_id`, `Spot`.`url`, `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`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`facebook_link`, `User`.`twitter_handle`, `User`.`instagram_handle`, `User`.`strava_handle`, `User`.`linkedin_handle`, `User`.`disciplines`, `User`.`distance`, `User`.`level_id`, `User`.`lat`, `User`.`lng`, `User`.`kilometer_count`, `User`.`training_count`, `User`.`team_count`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`bike1_id`, `User`.`is_pro`, `User`.`social_avatar`, `User`.`magasin`, `User`.`postal_code`, `User`.`country_id`, `User`.`departement_id`, `User`.`registeredby`, `User`.`handisport`, `User`.`licence`, `User`.`licence_ffc`, `User`.`reset_password_token`, `User`.`token_created_at`, `User`.`urgence_nom`, `User`.`urgence_prenom`, `User`.`urgence_tel`, `User`.`tva_intra`, `User`.`raison_sociale`, `User`.`pays_id`, `User`.`uuid`, `User`.`club`, `User`.`token`, `User`.`role_v3`, `User`.`CG`, `Galery`.`id`, `Galery`.`titre`, `Galery`.`created`, `Galery`.`updated` FROM `isoprod`.`spots` AS `Spot` LEFT JOIN `isoprod`.`departements` AS `Departement` ON (`Spot`.`departement_id` = `Departement`.`id`) LEFT JOIN `isoprod`.`users` AS `User` ON (`Spot`.`user_id` = `User`.`id`) LEFT JOIN `isoprod`.`galeries` AS `Galery` ON (`Spot`.`galery_id` = `Galery`.`id`) WHERE `Spot`.`id` = 1982 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 `Image`.`id`, `Image`.`galery_id`, `Image`.`fichier`, `Image`.`ordre`, `Image`.`statut`, `Image`.`titre` FROM `isoprod`.`images` AS `Image` WHERE `Image`.`galery_id` = (4833) | 0 | 0 | 0 | |
| SELECT `Parcours`.`id`, `Parcours`.`spot_id`, `Parcours`.`titre`, `Parcours`.`difficulte`, `Parcours`.`tourisme`, `Parcours`.`description`, `Parcours`.`lien`, `Parcours`.`image`, `Parcours`.`ordre`, `Parcours`.`depart`, `Parcours`.`depart_lng`, `Parcours`.`depart_lat`, `Parcours`.`gpx`, `Parcours`.`denivele`, `Parcours`.`komoot` FROM `isoprod`.`spots_parcours` AS `Parcours` WHERE `Parcours`.`spot_id` = (1982) | 0 | 0 | 0 | |
| SELECT `Sport`.`id`, `Sport`.`titre`, `Sport`.`description`, `Sport`.`slug`, `Sport`.`titre2`, `Sport`.`article`, `Sport`.`sports_title_SEO`, `Sport`.`uuid`, `Sport`.`iri`, `SpotsSport`.`id`, `SpotsSport`.`spot_id`, `SpotsSport`.`sport_id` FROM `isoprod`.`sports` AS `Sport` JOIN `isoprod`.`spots_sports` AS `SpotsSport` ON (`SpotsSport`.`spot_id` = 1982 AND `SpotsSport`.`sport_id` = `Sport`.`id`) | 0 | 0 | 1 | maybe slow |
| SELECT `Team`.`id`, `Team`.`category_id`, `Team`.`name`, `Team`.`user_id`, `Team`.`description`, `Team`.`distance`, `Team`.`level_id`, `Team`.`disciplines`, `Team`.`type`, `Team`.`photo`, `Team`.`address`, `Team`.`city`, `Team`.`country`, `Team`.`photo_cover`, `Team`.`team_user_count`, `Team`.`kilometer_count`, `Team`.`training_count`, `Team`.`status`, `Team`.`lat`, `Team`.`lng`, `Team`.`approved`, `Team`.`created`, `Team`.`updated`, `Team`.`photo_count`, `Team`.`topic_count`, `Team`.`video_count`, `Team`.`event_count`, `Team`.`featured`, `Team`.`group_type`, `Team`.`website`, `Team`.`facebook`, `Team`.`twitter`, `Team`.`instagram`, `Team`.`strava`, `Team`.`linkedin`, `Team`.`bike1_id`, `Team`.`privacy_type`, `Team`.`conversation_id`, `Team`.`vedette`, `Team`.`label` FROM `isoprod`.`teams` AS `Team` WHERE `Team`.`lat` >= 44 AND `Team`.`lat` <= 44.8 AND `Team`.`lng` >= 4.2 AND `Team`.`lng` <= 5 LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT `Event`.`id`, `Event`.`user_id`, `Event`.`title`, `Event`.`intro`, `Event`.`description`, `Event`.`sport_id`, `Event`.`discipline_id`, `Event`.`category_id`, `Event`.`distance`, `Event`.`address`, `Event`.`city`, `Event`.`country`, `Event`.`from`, `Event`.`from_time`, `Event`.`to`, `Event`.`to_time`, `Event`.`timezone`, `Event`.`type`, `Event`.`photo`, `Event`.`photo_cover`, `Event`.`link`, `Event`.`license_require`, `Event`.`event_rsvp_count`, `Event`.`created`, `Event`.`updated`, `Event`.`location`, `Event`.`lat`, `Event`.`lng`, `Event`.`level_id`, `Event`.`status`, `Event`.`past`, `Event`.`short_code`, `Event`.`departement_id`, `Event`.`facebook`, `Event`.`twitter`, `Event`.`youtube`, `Event`.`instagram`, `Event`.`open_runner_1`, `Event`.`open_runner_2`, `Event`.`open_runner_3`, `Event`.`open_runner_4`, `Event`.`open_runner_5`, `Event`.`open_runner_6`, `Event`.`open_runner_7`, `Event`.`open_runner_8`, `Event`.`open_runner_9`, `Event`.`open_runner_10`, `Event`.`open_runner_11`, `Event`.`open_runner_12`, `Event`.`open_runner_title_1`, `Event`.`open_runner_title_2`, `Event`.`open_runner_title_3`, `Event`.`open_runner_title_4`, `Event`.`open_runner_title_5`, `Event`.`open_runner_title_6`, `Event`.`open_runner_title_7`, `Event`.`open_runner_title_8`, `Event`.`open_runner_title_9`, `Event`.`open_runner_title_10`, `Event`.`open_runner_title_11`, `Event`.`open_runner_title_12`, `Event`.`contact`, `Event`.`reglement`, `Event`.`demande_taille_haut`, `Event`.`demande_taille_bas`, `Event`.`inscription`, `Event`.`demande_urgence`, `Event`.`federations`, `Event`.`affiche_liste`, `Event`.`pourcentage`, `Event`.`devise`, `Event`.`fraisfixes`, `Event`.`fraismin`, `Event`.`pourcentage_cache`, `Event`.`fraisfixes_cache`, `Event`.`fraismin_cache`, `Event`.`rib_name`, `Event`.`rib_bic`, `Event`.`rib_iban`, `Event`.`rib_photo`, `Event`.`vues`, `Event`.`lien_inscription`, `Event`.`conversation_id`, `Event`.`message_document`, `Event`.`ticket_orders_count`, `Event`.`nb_participants_parcours`, `Event`.`nb_prioritaires`, `Event`.`dossard_start_at`, `Event`.`tarif_repas`, `Event`.`tarif_repas_supp`, `Event`.`repas_statut`, `Event`.`label`, `Event`.`label2`, `Event`.`vedette`, `Event`.`message_inscription`, `Event`.`message_mail`, `Event`.`galery_id`, `Event`.`max_participants`, `Event`.`max_date`, `Event`.`assur_connect_statut`, `Event`.`assur_connect_mail`, `Event`.`ffc_mail`, `Event`.`visible`, `Event`.`classeur_id`, `Event`.`critere1`, `Event`.`critere2`, `Event`.`telephone`, `Event`.`mail_auto_organisateur`, `Event`.`category2_id`, `Event`.`category3_id`, `Event`.`mail_auto_organisateur_2`, `Event`.`otakam`, `Event`.`benevole`, `Event`.`accueil`, `Event`.`age_min`, `Event`.`age_max`, `Event`.`status_id`, `Event`.`photo_fond`, `Event`.`logo`, `Event`.`user_id_phone`, `Event`.`status_phone`, `Event`.`dokeop_statut`, `Event`.`dokeop_id`, `Event`.`display_paid_subscriptions`, `Event`.`statut_ca`, `Event`.`statut_monetico`, `Event`.`statut_paysurf`, `Event`.`statut_paysurf_fraction`, `Event`.`paysurf_id`, `Event`.`panier`, `Event`.`config`, `Event`.`data`, `Event`.`tva_intra`, `Event`.`raison_sociale`, `Event`.`last_order_num`, `Event`.`texte_confirmation_commande`, `Event`.`commentaire`, `Event`.`tri_listing`, `Event`.`mode_test`, `Event`.`statut_kinomap`, `Event`.`statut_frive`, `Event`.`statut_qrcodes`, `Event`.`statut_qrcodes_confirmation`, `Event`.`convocations_questions`, `Event`.`convocations_options`, `Event`.`texte_refus_certificat`, `Event`.`texte_manquant_certificat`, `Event`.`statut_cheque`, `Event`.`adresse_cheque`, `Event`.`texte_cheque`, `Event`.`ffa_id_competition`, `Event`.`quota_commentaire`, `Event`.`display_establishment`, `Event`.`display_se_loger`, `Event`.`is_expiration_cart`, `Event`.`expiration_time`, `Event`.`couleur1`, `Event`.`couleur2`, `Event`.`marque_blanche`, `Event`.`dokeop_platform_id`, `Event`.`couleur3`, `Event`.`couleur4`, `Event`.`texte_obligatoire`, `Event`.`pub1`, `Event`.`chrono_id`, `Event`.`date_relance`, `Event`.`prospection_id`, `Event`.`commercial_id`, `Event`.`prospection_date`, `Event`.`statut_prospection`, `Event`.`charge_id`, `Event`.`prospection_visio`, `Event`.`prospection_parametrage`, `Event`.`prospection_commentaire`, `Event`.`prospection_question1`, `Event`.`prospection_question2`, `Event`.`prospection_question3`, `Event`.`date_lancement`, `Event`.`affiche_quota_choix`, `Event`.`affiche_quota_parcours`, `Event`.`affiche_quota_event`, `Event`.`proposition_club`, `Event`.`widget_booking`, `Event`.`forcer_marque_blanche`, `Event`.`assurance_cloturee`, `Event`.`assurance_cloture_date`, `Eventcategory`.`id`, `Eventcategory`.`titre`, `Eventcategory`.`slug`, `Eventcategory`.`sport_id`, `Eventcategory`.`article`, `Eventcategory`.`description`, `Eventcategory`.`statut`, `Eventcategory`.`titre_singulier`, `Eventcategory`.`image_default`, `Eventcategory`.`article_bis`, `Eventcategory`.`eventcategories_title_SEO`, `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` FROM `isoprod`.`events` AS `Event` LEFT JOIN `isoprod`.`eventcategories` AS `Eventcategory` ON (`Event`.`category_id` = `Eventcategory`.`id`) LEFT JOIN `isoprod`.`departements` AS `Departement` ON (`Event`.`departement_id` = `Departement`.`id`) WHERE `from` >= '25-10-29' AND `Event`.`lat` >= 44 AND `Event`.`lat` <= 44.8 AND `Event`.`lng` >= 4.2 AND `Event`.`lng` <= 5 ORDER BY `Event`.`vedette` DESC, `Event`.`Inscription` DESC, `from` ASC LIMIT 9 | 6 | 6 | 4 | maybe slow |
| 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` 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`) WHERE `statut` = 1 AND `Magasin`.`magasin_type_id` <> 6 AND `Magasin`.`lat` >= 44 AND `Magasin`.`lat` <= 44.8 AND `Magasin`.`lng` >= 4.2 AND `Magasin`.`lng` <= 5 LIMIT 9 | 9 | 9 | 1 | maybe slow |
| 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` 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`) WHERE `statut` = 1 AND `Magasin`.`magasin_type_id` = 6 AND `Magasin`.`lat` >= 44 AND `Magasin`.`lat` <= 44.8 AND `Magasin`.`lng` >= 4.2 AND `Magasin`.`lng` <= 5 LIMIT 3 | 0 | 0 | 0 | |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `isoprod`.`spots` AS `Spot` WHERE `Spot`.`id` = 1982 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `isoprod`.`spots` AS `Spot` WHERE `Spot`.`id` = 1982 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `isoprod`.`spots` AS `Spot` WHERE `Spot`.`id` = 1982 | 1 | 1 | 0 | |
| UPDATE `isoprod`.`spots` SET `vues` = 1611 WHERE `isoprod`.`spots`.`id` = '1982' | 1 | 1 | 0 | |
| COMMIT | | | | |
| BEGIN | | | | |
| INSERT INTO `isoprod`.`spots_vues` (`user_id`, `ip`, `created`) VALUES (NULL, '216.73.216.134', '2025-10-29 10:13:14') | 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 | 1 | maybe slow |
4 duplicate queries run.
