| 1 |
2.20 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.duree_lib AS duree_lib_5, t0.lieu_complement AS lieu_complement_6, t0.nb_plan_b AS nb_plan_b_7, t0.seuil_nb_inscrit AS seuil_nb_inscrit_8, t0.pre_titre AS pre_titre_9, t0.post_titre AS post_titre_10, t0.editorial AS editorial_11, t0.programme AS programme_12, t0.arrive AS arrive_13, t0.has_badge AS has_badge_14, t0.minisite AS minisite_15, t0.domaine AS domaine_16, t0.sub_domaine AS sub_domaine_17, t0.icon AS icon_18, t0.color AS color_19, t0.header_nom AS header_nom_20, t0.annulation_possible AS annulation_possible_21, t0.commentaire_personne_active AS commentaire_personne_active_22, t0.commentaire_personne_help AS commentaire_personne_help_23, t0.badge_complement AS badge_complement_24, t0.montant_non_remboursable AS montant_non_remboursable_25, t0.comment_atelier AS comment_atelier_26, t0.participant_fonction_facultative AS participant_fonction_facultative_27, t0.send_email_admin_to_created_by AS send_email_admin_to_created_by_28, t0.nom AS nom_29, t0.description AS description_30, t0.comment_form AS comment_form_31, t0.comment_mail AS comment_mail_32, t0.date_limite_annulation AS date_limite_annulation_33, t0.date_limite_inscription AS date_limite_inscription_34, t0.date_limite_remplacement AS date_limite_remplacement_35, t0.specialite AS specialite_36, t0.actif AS actif_37, t0.nb_heures AS nb_heures_38, t0.code_youtube AS code_youtube_39, t0.montant_annulation AS montant_annulation_40, t0.brochure_nom AS brochure_nom_41, t0.image_nom AS image_nom_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.lieu_id AS lieu_id_45, t0.organisateur_id AS organisateur_id_46, t0.created_by_id AS created_by_id_47, t0.updated_by_id AS updated_by_id_48 FROM evenement t0 WHERE t0.sub_domaine = ? LIMIT 1
Parameters: [
"creai-na"
]
SELECT
t0.id AS id_1,
t0.slug AS slug_2,
t0.date_debut AS date_debut_3,
t0.date_fin AS date_fin_4,
t0.duree_lib AS duree_lib_5,
t0.lieu_complement AS lieu_complement_6,
t0.nb_plan_b AS nb_plan_b_7,
t0.seuil_nb_inscrit AS seuil_nb_inscrit_8,
t0.pre_titre AS pre_titre_9,
t0.post_titre AS post_titre_10,
t0.editorial AS editorial_11,
t0.programme AS programme_12,
t0.arrive AS arrive_13,
t0.has_badge AS has_badge_14,
t0.minisite AS minisite_15,
t0.domaine AS domaine_16,
t0.sub_domaine AS sub_domaine_17,
t0.icon AS icon_18,
t0.color AS color_19,
t0.header_nom AS header_nom_20,
t0.annulation_possible AS annulation_possible_21,
t0.commentaire_personne_active AS commentaire_personne_active_22,
t0.commentaire_personne_help AS commentaire_personne_help_23,
t0.badge_complement AS badge_complement_24,
t0.montant_non_remboursable AS montant_non_remboursable_25,
t0.comment_atelier AS comment_atelier_26,
t0.participant_fonction_facultative AS participant_fonction_facultative_27,
t0.send_email_admin_to_created_by AS send_email_admin_to_created_by_28,
t0.nom AS nom_29,
t0.description AS description_30,
t0.comment_form AS comment_form_31,
t0.comment_mail AS comment_mail_32,
t0.date_limite_annulation AS date_limite_annulation_33,
t0.date_limite_inscription AS date_limite_inscription_34,
t0.date_limite_remplacement AS date_limite_remplacement_35,
t0.specialite AS specialite_36,
t0.actif AS actif_37,
t0.nb_heures AS nb_heures_38,
t0.code_youtube AS code_youtube_39,
t0.montant_annulation AS montant_annulation_40,
t0.brochure_nom AS brochure_nom_41,
t0.image_nom AS image_nom_42,
t0.created_at AS created_at_43,
t0.updated_at AS updated_at_44,
t0.lieu_id AS lieu_id_45,
t0.organisateur_id AS organisateur_id_46,
t0.created_by_id AS created_by_id_47,
t0.updated_by_id AS updated_by_id_48
FROM
evenement t0
WHERE
t0.sub_domaine = ?
LIMIT
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.duree_lib AS duree_lib_5, t0.lieu_complement AS lieu_complement_6, t0.nb_plan_b AS nb_plan_b_7, t0.seuil_nb_inscrit AS seuil_nb_inscrit_8, t0.pre_titre AS pre_titre_9, t0.post_titre AS post_titre_10, t0.editorial AS editorial_11, t0.programme AS programme_12, t0.arrive AS arrive_13, t0.has_badge AS has_badge_14, t0.minisite AS minisite_15, t0.domaine AS domaine_16, t0.sub_domaine AS sub_domaine_17, t0.icon AS icon_18, t0.color AS color_19, t0.header_nom AS header_nom_20, t0.annulation_possible AS annulation_possible_21, t0.commentaire_personne_active AS commentaire_personne_active_22, t0.commentaire_personne_help AS commentaire_personne_help_23, t0.badge_complement AS badge_complement_24, t0.montant_non_remboursable AS montant_non_remboursable_25, t0.comment_atelier AS comment_atelier_26, t0.participant_fonction_facultative AS participant_fonction_facultative_27, t0.send_email_admin_to_created_by AS send_email_admin_to_created_by_28, t0.nom AS nom_29, t0.description AS description_30, t0.comment_form AS comment_form_31, t0.comment_mail AS comment_mail_32, t0.date_limite_annulation AS date_limite_annulation_33, t0.date_limite_inscription AS date_limite_inscription_34, t0.date_limite_remplacement AS date_limite_remplacement_35, t0.specialite AS specialite_36, t0.actif AS actif_37, t0.nb_heures AS nb_heures_38, t0.code_youtube AS code_youtube_39, t0.montant_annulation AS montant_annulation_40, t0.brochure_nom AS brochure_nom_41, t0.image_nom AS image_nom_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.lieu_id AS lieu_id_45, t0.organisateur_id AS organisateur_id_46, t0.created_by_id AS created_by_id_47, t0.updated_by_id AS updated_by_id_48 FROM evenement t0 WHERE t0.sub_domaine = 'creai-na' LIMIT 1;
|
| 2 |
0.97 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prefixe AS prefixe_3, t0.sub_domain AS sub_domain_4, t0.adresse AS adresse_5, t0.complement AS complement_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.cedex AS cedex_9, t0.agrement_date AS agrement_date_10, t0.agrement_code AS agrement_code_11, t0.logo_url AS logo_url_12, t0.logo_name AS logo_name_13, t0.siret AS siret_14, t0.ape AS ape_15, t0.dom AS dom_16, t0.bic AS bic_17, t0.iban AS iban_18, t0.rib AS rib_19, t0.tel AS tel_20, t0.site AS site_21, t0.slug AS slug_22, t0.co_orga_only AS co_orga_only_23, t0.masculin AS masculin_24, t0.sans_article AS sans_article_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.username AS username_30, t28.confirmation_token AS confirmation_token_31, t28.password_requested_at AS password_requested_at_32, t28.roles AS roles_33, t28.email AS email_34, t28.email_canonical AS email_canonical_35, t28.enabled AS enabled_36, t28.salt AS salt_37, t28.password AS password_38, t28.last_login AS last_login_39, t28.nom AS nom_40, t28.prenom AS prenom_41, t28.homme AS homme_42, t28.fonction AS fonction_43, t28.signature_name AS signature_name_44, t28.organisateur_id AS organisateur_id_45, t28.dirige_id AS dirige_id_46, t28.gere_id AS gere_id_47, t28.journee_id AS journee_id_48, t28.evenement_id AS evenement_id_49, t50.id AS id_51, t50.username AS username_52, t50.confirmation_token AS confirmation_token_53, t50.password_requested_at AS password_requested_at_54, t50.roles AS roles_55, t50.email AS email_56, t50.email_canonical AS email_canonical_57, t50.enabled AS enabled_58, t50.salt AS salt_59, t50.password AS password_60, t50.last_login AS last_login_61, t50.nom AS nom_62, t50.prenom AS prenom_63, t50.homme AS homme_64, t50.fonction AS fonction_65, t50.signature_name AS signature_name_66, t50.organisateur_id AS organisateur_id_67, t50.dirige_id AS dirige_id_68, t50.gere_id AS gere_id_69, t50.journee_id AS journee_id_70, t50.evenement_id AS evenement_id_71, t0.dpo_id AS dpo_id_72 FROM organisateur t0 LEFT JOIN user t28 ON t28.dirige_id = t0.id LEFT JOIN user t50 ON t50.gere_id = t0.id WHERE t0.sub_domain = ? LIMIT 1
Parameters: [
"creai-na"
]
SELECT
t0.id AS id_1,
t0.nom AS nom_2,
t0.prefixe AS prefixe_3,
t0.sub_domain AS sub_domain_4,
t0.adresse AS adresse_5,
t0.complement AS complement_6,
t0.code_postal AS code_postal_7,
t0.ville AS ville_8,
t0.cedex AS cedex_9,
t0.agrement_date AS agrement_date_10,
t0.agrement_code AS agrement_code_11,
t0.logo_url AS logo_url_12,
t0.logo_name AS logo_name_13,
t0.siret AS siret_14,
t0.ape AS ape_15,
t0.dom AS dom_16,
t0.bic AS bic_17,
t0.iban AS iban_18,
t0.rib AS rib_19,
t0.tel AS tel_20,
t0.site AS site_21,
t0.slug AS slug_22,
t0.co_orga_only AS co_orga_only_23,
t0.masculin AS masculin_24,
t0.sans_article AS sans_article_25,
t0.created_at AS created_at_26,
t0.updated_at AS updated_at_27,
t28.id AS id_29,
t28.username AS username_30,
t28.confirmation_token AS confirmation_token_31,
t28.password_requested_at AS password_requested_at_32,
t28.roles AS roles_33,
t28.email AS email_34,
t28.email_canonical AS email_canonical_35,
t28.enabled AS enabled_36,
t28.salt AS salt_37,
t28.password AS password_38,
t28.last_login AS last_login_39,
t28.nom AS nom_40,
t28.prenom AS prenom_41,
t28.homme AS homme_42,
t28.fonction AS fonction_43,
t28.signature_name AS signature_name_44,
t28.organisateur_id AS organisateur_id_45,
t28.dirige_id AS dirige_id_46,
t28.gere_id AS gere_id_47,
t28.journee_id AS journee_id_48,
t28.evenement_id AS evenement_id_49,
t50.id AS id_51,
t50.username AS username_52,
t50.confirmation_token AS confirmation_token_53,
t50.password_requested_at AS password_requested_at_54,
t50.roles AS roles_55,
t50.email AS email_56,
t50.email_canonical AS email_canonical_57,
t50.enabled AS enabled_58,
t50.salt AS salt_59,
t50.password AS password_60,
t50.last_login AS last_login_61,
t50.nom AS nom_62,
t50.prenom AS prenom_63,
t50.homme AS homme_64,
t50.fonction AS fonction_65,
t50.signature_name AS signature_name_66,
t50.organisateur_id AS organisateur_id_67,
t50.dirige_id AS dirige_id_68,
t50.gere_id AS gere_id_69,
t50.journee_id AS journee_id_70,
t50.evenement_id AS evenement_id_71,
t0.dpo_id AS dpo_id_72
FROM
organisateur t0
LEFT JOIN user t28 ON t28.dirige_id = t0.id
LEFT JOIN user t50 ON t50.gere_id = t0.id
WHERE
t0.sub_domain = ?
LIMIT
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prefixe AS prefixe_3, t0.sub_domain AS sub_domain_4, t0.adresse AS adresse_5, t0.complement AS complement_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.cedex AS cedex_9, t0.agrement_date AS agrement_date_10, t0.agrement_code AS agrement_code_11, t0.logo_url AS logo_url_12, t0.logo_name AS logo_name_13, t0.siret AS siret_14, t0.ape AS ape_15, t0.dom AS dom_16, t0.bic AS bic_17, t0.iban AS iban_18, t0.rib AS rib_19, t0.tel AS tel_20, t0.site AS site_21, t0.slug AS slug_22, t0.co_orga_only AS co_orga_only_23, t0.masculin AS masculin_24, t0.sans_article AS sans_article_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.username AS username_30, t28.confirmation_token AS confirmation_token_31, t28.password_requested_at AS password_requested_at_32, t28.roles AS roles_33, t28.email AS email_34, t28.email_canonical AS email_canonical_35, t28.enabled AS enabled_36, t28.salt AS salt_37, t28.password AS password_38, t28.last_login AS last_login_39, t28.nom AS nom_40, t28.prenom AS prenom_41, t28.homme AS homme_42, t28.fonction AS fonction_43, t28.signature_name AS signature_name_44, t28.organisateur_id AS organisateur_id_45, t28.dirige_id AS dirige_id_46, t28.gere_id AS gere_id_47, t28.journee_id AS journee_id_48, t28.evenement_id AS evenement_id_49, t50.id AS id_51, t50.username AS username_52, t50.confirmation_token AS confirmation_token_53, t50.password_requested_at AS password_requested_at_54, t50.roles AS roles_55, t50.email AS email_56, t50.email_canonical AS email_canonical_57, t50.enabled AS enabled_58, t50.salt AS salt_59, t50.password AS password_60, t50.last_login AS last_login_61, t50.nom AS nom_62, t50.prenom AS prenom_63, t50.homme AS homme_64, t50.fonction AS fonction_65, t50.signature_name AS signature_name_66, t50.organisateur_id AS organisateur_id_67, t50.dirige_id AS dirige_id_68, t50.gere_id AS gere_id_69, t50.journee_id AS journee_id_70, t50.evenement_id AS evenement_id_71, t0.dpo_id AS dpo_id_72 FROM organisateur t0 LEFT JOIN user t28 ON t28.dirige_id = t0.id LEFT JOIN user t50 ON t50.gere_id = t0.id WHERE t0.sub_domain = 'creai-na' LIMIT 1;
|
| 3 |
1.09 ms |
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.duree_lib AS duree_lib_4, e0_.lieu_complement AS lieu_complement_5, e0_.nb_plan_b AS nb_plan_b_6, e0_.seuil_nb_inscrit AS seuil_nb_inscrit_7, e0_.pre_titre AS pre_titre_8, e0_.post_titre AS post_titre_9, e0_.editorial AS editorial_10, e0_.programme AS programme_11, e0_.arrive AS arrive_12, e0_.has_badge AS has_badge_13, e0_.minisite AS minisite_14, e0_.domaine AS domaine_15, e0_.sub_domaine AS sub_domaine_16, e0_.icon AS icon_17, e0_.color AS color_18, e0_.header_nom AS header_nom_19, e0_.annulation_possible AS annulation_possible_20, e0_.commentaire_personne_active AS commentaire_personne_active_21, e0_.commentaire_personne_help AS commentaire_personne_help_22, e0_.badge_complement AS badge_complement_23, e0_.montant_non_remboursable AS montant_non_remboursable_24, e0_.comment_atelier AS comment_atelier_25, e0_.participant_fonction_facultative AS participant_fonction_facultative_26, e0_.send_email_admin_to_created_by AS send_email_admin_to_created_by_27, e0_.nom AS nom_28, e0_.description AS description_29, e0_.comment_form AS comment_form_30, e0_.comment_mail AS comment_mail_31, e0_.date_limite_annulation AS date_limite_annulation_32, e0_.date_limite_inscription AS date_limite_inscription_33, e0_.date_limite_remplacement AS date_limite_remplacement_34, e0_.specialite AS specialite_35, e0_.actif AS actif_36, e0_.nb_heures AS nb_heures_37, e0_.code_youtube AS code_youtube_38, e0_.montant_annulation AS montant_annulation_39, e0_.brochure_nom AS brochure_nom_40, e0_.image_nom AS image_nom_41, e0_.created_at AS created_at_42, e0_.updated_at AS updated_at_43, e0_.lieu_id AS lieu_id_44, e0_.organisateur_id AS organisateur_id_45, e0_.created_by_id AS created_by_id_46, e0_.updated_by_id AS updated_by_id_47 FROM evenement e0_ INNER JOIN organisateur o1_ ON e0_.organisateur_id = o1_.id LEFT JOIN evenement_coorga e2_ ON e0_.id = e2_.evenement_id LEFT JOIN organisateur o3_ ON e2_.coorga_id = o3_.id WHERE ((o1_.id = 1 OR o3_.id = 1)) AND (e0_.date_fin > CURRENT_DATE AND e0_.actif = 1)
SELECT
e0_.id AS id_0,
e0_.slug AS slug_1,
e0_.date_debut AS date_debut_2,
e0_.date_fin AS date_fin_3,
e0_.duree_lib AS duree_lib_4,
e0_.lieu_complement AS lieu_complement_5,
e0_.nb_plan_b AS nb_plan_b_6,
e0_.seuil_nb_inscrit AS seuil_nb_inscrit_7,
e0_.pre_titre AS pre_titre_8,
e0_.post_titre AS post_titre_9,
e0_.editorial AS editorial_10,
e0_.programme AS programme_11,
e0_.arrive AS arrive_12,
e0_.has_badge AS has_badge_13,
e0_.minisite AS minisite_14,
e0_.domaine AS domaine_15,
e0_.sub_domaine AS sub_domaine_16,
e0_.icon AS icon_17,
e0_.color AS color_18,
e0_.header_nom AS header_nom_19,
e0_.annulation_possible AS annulation_possible_20,
e0_.commentaire_personne_active AS commentaire_personne_active_21,
e0_.commentaire_personne_help AS commentaire_personne_help_22,
e0_.badge_complement AS badge_complement_23,
e0_.montant_non_remboursable AS montant_non_remboursable_24,
e0_.comment_atelier AS comment_atelier_25,
e0_.participant_fonction_facultative AS participant_fonction_facultative_26,
e0_.send_email_admin_to_created_by AS send_email_admin_to_created_by_27,
e0_.nom AS nom_28,
e0_.description AS description_29,
e0_.comment_form AS comment_form_30,
e0_.comment_mail AS comment_mail_31,
e0_.date_limite_annulation AS date_limite_annulation_32,
e0_.date_limite_inscription AS date_limite_inscription_33,
e0_.date_limite_remplacement AS date_limite_remplacement_34,
e0_.specialite AS specialite_35,
e0_.actif AS actif_36,
e0_.nb_heures AS nb_heures_37,
e0_.code_youtube AS code_youtube_38,
e0_.montant_annulation AS montant_annulation_39,
e0_.brochure_nom AS brochure_nom_40,
e0_.image_nom AS image_nom_41,
e0_.created_at AS created_at_42,
e0_.updated_at AS updated_at_43,
e0_.lieu_id AS lieu_id_44,
e0_.organisateur_id AS organisateur_id_45,
e0_.created_by_id AS created_by_id_46,
e0_.updated_by_id AS updated_by_id_47
FROM
evenement e0_
INNER JOIN organisateur o1_ ON e0_.organisateur_id = o1_.id
LEFT JOIN evenement_coorga e2_ ON e0_.id = e2_.evenement_id
LEFT JOIN organisateur o3_ ON e2_.coorga_id = o3_.id
WHERE
(
(
o1_.id = 1
OR o3_.id = 1
)
)
AND (
e0_.date_fin > CURRENT_DATE
AND e0_.actif = 1
)
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.date_debut AS date_debut_2, e0_.date_fin AS date_fin_3, e0_.duree_lib AS duree_lib_4, e0_.lieu_complement AS lieu_complement_5, e0_.nb_plan_b AS nb_plan_b_6, e0_.seuil_nb_inscrit AS seuil_nb_inscrit_7, e0_.pre_titre AS pre_titre_8, e0_.post_titre AS post_titre_9, e0_.editorial AS editorial_10, e0_.programme AS programme_11, e0_.arrive AS arrive_12, e0_.has_badge AS has_badge_13, e0_.minisite AS minisite_14, e0_.domaine AS domaine_15, e0_.sub_domaine AS sub_domaine_16, e0_.icon AS icon_17, e0_.color AS color_18, e0_.header_nom AS header_nom_19, e0_.annulation_possible AS annulation_possible_20, e0_.commentaire_personne_active AS commentaire_personne_active_21, e0_.commentaire_personne_help AS commentaire_personne_help_22, e0_.badge_complement AS badge_complement_23, e0_.montant_non_remboursable AS montant_non_remboursable_24, e0_.comment_atelier AS comment_atelier_25, e0_.participant_fonction_facultative AS participant_fonction_facultative_26, e0_.send_email_admin_to_created_by AS send_email_admin_to_created_by_27, e0_.nom AS nom_28, e0_.description AS description_29, e0_.comment_form AS comment_form_30, e0_.comment_mail AS comment_mail_31, e0_.date_limite_annulation AS date_limite_annulation_32, e0_.date_limite_inscription AS date_limite_inscription_33, e0_.date_limite_remplacement AS date_limite_remplacement_34, e0_.specialite AS specialite_35, e0_.actif AS actif_36, e0_.nb_heures AS nb_heures_37, e0_.code_youtube AS code_youtube_38, e0_.montant_annulation AS montant_annulation_39, e0_.brochure_nom AS brochure_nom_40, e0_.image_nom AS image_nom_41, e0_.created_at AS created_at_42, e0_.updated_at AS updated_at_43, e0_.lieu_id AS lieu_id_44, e0_.organisateur_id AS organisateur_id_45, e0_.created_by_id AS created_by_id_46, e0_.updated_by_id AS updated_by_id_47 FROM evenement e0_ INNER JOIN organisateur o1_ ON e0_.organisateur_id = o1_.id LEFT JOIN evenement_coorga e2_ ON e0_.id = e2_.evenement_id LEFT JOIN organisateur o3_ ON e2_.coorga_id = o3_.id WHERE ((o1_.id = 1 OR o3_.id = 1)) AND (e0_.date_fin > CURRENT_DATE AND e0_.actif = 1);
|