| 1 |
1.03 ms |
SELECT b0_.slug AS slug_0, b0_.id AS id_1, b0_.adresse AS adresse_2, b0_.adresse3_words AS adresse3_words_3, b0_.latitude AS latitude_4, b0_.longitude AS longitude_5, b0_.est_pro AS est_pro_6, b0_.est_bloque AS est_bloque_7, b0_.date_premium AS date_premium_8, b0_.horaire_douverture AS horaire_douverture_9, b0_.adresse_gpslat AS adresse_gpslat_10, b0_.adresse_gpslong AS adresse_gpslong_11, b0_.la_date AS la_date_12, b0_.nombre_avis AS nombre_avis_13, b0_.moyenne_avis AS moyenne_avis_14, b0_.nom AS nom_15, b0_.moyenne_note AS moyenne_note_16, b0_.nombre_de_visite AS nombre_de_visite_17, b0_.est_certifie AS est_certifie_18, b0_.est_supprime AS est_supprime_19, b0_.sigle AS sigle_20, b0_.email AS email_21, b0_.phone AS phone_22, b0_.code_postal AS code_postal_23, b0_.ville AS ville_24, b0_.site_web AS site_web_25, b0_.description AS description_26, b0_.fax AS fax_27, b0_.statut_juridique AS statut_juridique_28, b0_.capital AS capital_29, b0_.matricule AS matricule_30, b0_.siret AS siret_31, b0_.ape AS ape_32, b0_.cc AS cc_33, b0_.facture_tva AS facture_tva_34, b0_.mention_legal AS mention_legal_35, b0_.banque AS banque_36, b0_.rib AS rib_37, b0_.iban AS iban_38, b0_.bic AS bic_39, b0_.annee AS annee_40, b0_.mois AS mois_41, b0_.qualification AS qualification_42, b0_.disponibilite AS disponibilite_43, b0_.gamme_de_prix AS gamme_de_prix_44, b0_.main_d_oeuvre AS main_d_oeuvre_45, b0_.zone_d_intervention AS zone_d_intervention_46, a1_.slug_username AS slug_username_47, a1_.id AS id_48, a1_.email AS email_49, a1_.email_token AS email_token_50, a1_.piece_didentite_recto AS piece_didentite_recto_51, a1_.piece_didentite_verso AS piece_didentite_verso_52, a1_.username AS username_53, a1_.roles AS roles_54, a1_.password AS password_55, a1_.nom AS nom_56, a1_.prenom AS prenom_57, a1_.code AS code_58, a1_.sexe AS sexe_59, a1_.est_supprime AS est_supprime_60, a1_.telephone AS telephone_61, a1_.adresse AS adresse_62, a1_.type_compte AS type_compte_63, a1_.nom_complet AS nom_complet_64, a1_.mois AS mois_65, a1_.annee AS annee_66, a1_.nombre_avis AS nombre_avis_67, a1_.created_at AS created_at_68, a1_.qualification AS qualification_69, a1_.description AS description_70, a1_.disponibilite AS disponibilite_71, a1_.enabled AS enabled_72, a1_.gamme_de_prix AS gamme_de_prix_73, a1_.main_d_oeuvre AS main_d_oeuvre_74, a1_.zone_d_intervention AS zone_d_intervention_75, a1_.domaine_d_activite AS domaine_d_activite_76, a1_.est_embassadeur AS est_embassadeur_77, c2_.slug AS slug_78, c2_.id AS id_79, c2_.nom AS nom_80, c2_.nombre_element AS nombre_element_81, c2_.description AS description_82, c2_.phrase_d_appel AS phrase_d_appel_83, c2_.est_supprime AS est_supprime_84, p3_.id AS id_85, p3_.url AS url_86, p3_.full_url AS full_url_87, p3_.alt AS alt_88, p3_.date_ajout AS date_ajout_89, p3_.est_valide AS est_valide_90 FROM boutique b0_ LEFT JOIN app_user a1_ ON b0_.user_id = a1_.id LEFT JOIN categorie_entreprise c2_ ON b0_.categorie_entreprise_id = c2_.id LEFT JOIN photo p3_ ON b0_.logo_id = p3_.id WHERE b0_.id = ?
SELECT
b0_.slug AS slug_0,
b0_.id AS id_1,
b0_.adresse AS adresse_2,
b0_.adresse3_words AS adresse3_words_3,
b0_.latitude AS latitude_4,
b0_.longitude AS longitude_5,
b0_.est_pro AS est_pro_6,
b0_.est_bloque AS est_bloque_7,
b0_.date_premium AS date_premium_8,
b0_.horaire_douverture AS horaire_douverture_9,
b0_.adresse_gpslat AS adresse_gpslat_10,
b0_.adresse_gpslong AS adresse_gpslong_11,
b0_.la_date AS la_date_12,
b0_.nombre_avis AS nombre_avis_13,
b0_.moyenne_avis AS moyenne_avis_14,
b0_.nom AS nom_15,
b0_.moyenne_note AS moyenne_note_16,
b0_.nombre_de_visite AS nombre_de_visite_17,
b0_.est_certifie AS est_certifie_18,
b0_.est_supprime AS est_supprime_19,
b0_.sigle AS sigle_20,
b0_.email AS email_21,
b0_.phone AS phone_22,
b0_.code_postal AS code_postal_23,
b0_.ville AS ville_24,
b0_.site_web AS site_web_25,
b0_.description AS description_26,
b0_.fax AS fax_27,
b0_.statut_juridique AS statut_juridique_28,
b0_.capital AS capital_29,
b0_.matricule AS matricule_30,
b0_.siret AS siret_31,
b0_.ape AS ape_32,
b0_.cc AS cc_33,
b0_.facture_tva AS facture_tva_34,
b0_.mention_legal AS mention_legal_35,
b0_.banque AS banque_36,
b0_.rib AS rib_37,
b0_.iban AS iban_38,
b0_.bic AS bic_39,
b0_.annee AS annee_40,
b0_.mois AS mois_41,
b0_.qualification AS qualification_42,
b0_.disponibilite AS disponibilite_43,
b0_.gamme_de_prix AS gamme_de_prix_44,
b0_.main_d_oeuvre AS main_d_oeuvre_45,
b0_.zone_d_intervention AS zone_d_intervention_46,
a1_.slug_username AS slug_username_47,
a1_.id AS id_48,
a1_.email AS email_49,
a1_.email_token AS email_token_50,
a1_.piece_didentite_recto AS piece_didentite_recto_51,
a1_.piece_didentite_verso AS piece_didentite_verso_52,
a1_.username AS username_53,
a1_.roles AS roles_54,
a1_.password AS password_55,
a1_.nom AS nom_56,
a1_.prenom AS prenom_57,
a1_.code AS code_58,
a1_.sexe AS sexe_59,
a1_.est_supprime AS est_supprime_60,
a1_.telephone AS telephone_61,
a1_.adresse AS adresse_62,
a1_.type_compte AS type_compte_63,
a1_.nom_complet AS nom_complet_64,
a1_.mois AS mois_65,
a1_.annee AS annee_66,
a1_.nombre_avis AS nombre_avis_67,
a1_.created_at AS created_at_68,
a1_.qualification AS qualification_69,
a1_.description AS description_70,
a1_.disponibilite AS disponibilite_71,
a1_.enabled AS enabled_72,
a1_.gamme_de_prix AS gamme_de_prix_73,
a1_.main_d_oeuvre AS main_d_oeuvre_74,
a1_.zone_d_intervention AS zone_d_intervention_75,
a1_.domaine_d_activite AS domaine_d_activite_76,
a1_.est_embassadeur AS est_embassadeur_77,
c2_.slug AS slug_78,
c2_.id AS id_79,
c2_.nom AS nom_80,
c2_.nombre_element AS nombre_element_81,
c2_.description AS description_82,
c2_.phrase_d_appel AS phrase_d_appel_83,
c2_.est_supprime AS est_supprime_84,
p3_.id AS id_85,
p3_.url AS url_86,
p3_.full_url AS full_url_87,
p3_.alt AS alt_88,
p3_.date_ajout AS date_ajout_89,
p3_.est_valide AS est_valide_90
FROM
boutique b0_
LEFT JOIN app_user a1_ ON b0_.user_id = a1_.id
LEFT JOIN categorie_entreprise c2_ ON b0_.categorie_entreprise_id = c2_.id
LEFT JOIN photo p3_ ON b0_.logo_id = p3_.id
WHERE
b0_.id = ?
SELECT b0_.slug AS slug_0, b0_.id AS id_1, b0_.adresse AS adresse_2, b0_.adresse3_words AS adresse3_words_3, b0_.latitude AS latitude_4, b0_.longitude AS longitude_5, b0_.est_pro AS est_pro_6, b0_.est_bloque AS est_bloque_7, b0_.date_premium AS date_premium_8, b0_.horaire_douverture AS horaire_douverture_9, b0_.adresse_gpslat AS adresse_gpslat_10, b0_.adresse_gpslong AS adresse_gpslong_11, b0_.la_date AS la_date_12, b0_.nombre_avis AS nombre_avis_13, b0_.moyenne_avis AS moyenne_avis_14, b0_.nom AS nom_15, b0_.moyenne_note AS moyenne_note_16, b0_.nombre_de_visite AS nombre_de_visite_17, b0_.est_certifie AS est_certifie_18, b0_.est_supprime AS est_supprime_19, b0_.sigle AS sigle_20, b0_.email AS email_21, b0_.phone AS phone_22, b0_.code_postal AS code_postal_23, b0_.ville AS ville_24, b0_.site_web AS site_web_25, b0_.description AS description_26, b0_.fax AS fax_27, b0_.statut_juridique AS statut_juridique_28, b0_.capital AS capital_29, b0_.matricule AS matricule_30, b0_.siret AS siret_31, b0_.ape AS ape_32, b0_.cc AS cc_33, b0_.facture_tva AS facture_tva_34, b0_.mention_legal AS mention_legal_35, b0_.banque AS banque_36, b0_.rib AS rib_37, b0_.iban AS iban_38, b0_.bic AS bic_39, b0_.annee AS annee_40, b0_.mois AS mois_41, b0_.qualification AS qualification_42, b0_.disponibilite AS disponibilite_43, b0_.gamme_de_prix AS gamme_de_prix_44, b0_.main_d_oeuvre AS main_d_oeuvre_45, b0_.zone_d_intervention AS zone_d_intervention_46, a1_.slug_username AS slug_username_47, a1_.id AS id_48, a1_.email AS email_49, a1_.email_token AS email_token_50, a1_.piece_didentite_recto AS piece_didentite_recto_51, a1_.piece_didentite_verso AS piece_didentite_verso_52, a1_.username AS username_53, a1_.roles AS roles_54, a1_.password AS password_55, a1_.nom AS nom_56, a1_.prenom AS prenom_57, a1_.code AS code_58, a1_.sexe AS sexe_59, a1_.est_supprime AS est_supprime_60, a1_.telephone AS telephone_61, a1_.adresse AS adresse_62, a1_.type_compte AS type_compte_63, a1_.nom_complet AS nom_complet_64, a1_.mois AS mois_65, a1_.annee AS annee_66, a1_.nombre_avis AS nombre_avis_67, a1_.created_at AS created_at_68, a1_.qualification AS qualification_69, a1_.description AS description_70, a1_.disponibilite AS disponibilite_71, a1_.enabled AS enabled_72, a1_.gamme_de_prix AS gamme_de_prix_73, a1_.main_d_oeuvre AS main_d_oeuvre_74, a1_.zone_d_intervention AS zone_d_intervention_75, a1_.domaine_d_activite AS domaine_d_activite_76, a1_.est_embassadeur AS est_embassadeur_77, c2_.slug AS slug_78, c2_.id AS id_79, c2_.nom AS nom_80, c2_.nombre_element AS nombre_element_81, c2_.description AS description_82, c2_.phrase_d_appel AS phrase_d_appel_83, c2_.est_supprime AS est_supprime_84, p3_.id AS id_85, p3_.url AS url_86, p3_.full_url AS full_url_87, p3_.alt AS alt_88, p3_.date_ajout AS date_ajout_89, p3_.est_valide AS est_valide_90 FROM boutique b0_ LEFT JOIN app_user a1_ ON b0_.user_id = a1_.id LEFT JOIN categorie_entreprise c2_ ON b0_.categorie_entreprise_id = c2_.id LEFT JOIN photo p3_ ON b0_.logo_id = p3_.id WHERE b0_.id = '165';
|
| 2 |
0.72 ms |
SELECT c0_.id AS id_0, c0_.periodique AS periodique_1, c0_.la_date AS la_date_2, c0_.date_debut AS date_debut_3, c0_.date_fin AS date_fin_4, c0_.id_transaction AS id_transaction_5, c0_.signature AS signature_6, c0_.cpm_amount AS cpm_amount_7, c0_.cpm_trans_id AS cpm_trans_id_8, c0_.cpm_custom AS cpm_custom_9, c0_.cpm_currency AS cpm_currency_10, c0_.cpm_payid AS cpm_payid_11, c0_.cpm_payment_date AS cpm_payment_date_12, c0_.cpm_payment_time AS cpm_payment_time_13, c0_.cpm_error_message AS cpm_error_message_14, c0_.payment_method AS payment_method_15, c0_.cpm_phone_prefixe AS cpm_phone_prefixe_16, c0_.celPhoneNum AS celPhoneNum_17, c0_.cpm_ipn_ack AS cpm_ipn_ack_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.cpm_result AS cpm_result_21, c0_.cpm_trans_status AS cpm_trans_status_22, c0_.cpm_designation AS cpm_designation_23, c0_.buyer_name AS buyer_name_24, b1_.slug AS slug_25, b1_.id AS id_26, b1_.adresse AS adresse_27, b1_.adresse3_words AS adresse3_words_28, b1_.latitude AS latitude_29, b1_.longitude AS longitude_30, b1_.est_pro AS est_pro_31, b1_.est_bloque AS est_bloque_32, b1_.date_premium AS date_premium_33, b1_.horaire_douverture AS horaire_douverture_34, b1_.adresse_gpslat AS adresse_gpslat_35, b1_.adresse_gpslong AS adresse_gpslong_36, b1_.la_date AS la_date_37, b1_.nombre_avis AS nombre_avis_38, b1_.moyenne_avis AS moyenne_avis_39, b1_.nom AS nom_40, b1_.moyenne_note AS moyenne_note_41, b1_.nombre_de_visite AS nombre_de_visite_42, b1_.est_certifie AS est_certifie_43, b1_.est_supprime AS est_supprime_44, b1_.sigle AS sigle_45, b1_.email AS email_46, b1_.phone AS phone_47, b1_.code_postal AS code_postal_48, b1_.ville AS ville_49, b1_.site_web AS site_web_50, b1_.description AS description_51, b1_.fax AS fax_52, b1_.statut_juridique AS statut_juridique_53, b1_.capital AS capital_54, b1_.matricule AS matricule_55, b1_.siret AS siret_56, b1_.ape AS ape_57, b1_.cc AS cc_58, b1_.facture_tva AS facture_tva_59, b1_.mention_legal AS mention_legal_60, b1_.banque AS banque_61, b1_.rib AS rib_62, b1_.iban AS iban_63, b1_.bic AS bic_64, b1_.annee AS annee_65, b1_.mois AS mois_66, b1_.qualification AS qualification_67, b1_.disponibilite AS disponibilite_68, b1_.gamme_de_prix AS gamme_de_prix_69, b1_.main_d_oeuvre AS main_d_oeuvre_70, b1_.zone_d_intervention AS zone_d_intervention_71, p2_.slug AS slug_72, p2_.id AS id_73, p2_.nom AS nom_74, p2_.contenu AS contenu_75, p2_.tarif AS tarif_76 FROM commande c0_ LEFT JOIN boutique b1_ ON c0_.boutique_id = b1_.id LEFT JOIN plan p2_ ON c0_.plan_id = p2_.id WHERE b1_.id = ? AND c0_.date_fin > ?
Parameters: [
"165"
"2026-08-18 15:37:00"
]
SELECT
c0_.id AS id_0,
c0_.periodique AS periodique_1,
c0_.la_date AS la_date_2,
c0_.date_debut AS date_debut_3,
c0_.date_fin AS date_fin_4,
c0_.id_transaction AS id_transaction_5,
c0_.signature AS signature_6,
c0_.cpm_amount AS cpm_amount_7,
c0_.cpm_trans_id AS cpm_trans_id_8,
c0_.cpm_custom AS cpm_custom_9,
c0_.cpm_currency AS cpm_currency_10,
c0_.cpm_payid AS cpm_payid_11,
c0_.cpm_payment_date AS cpm_payment_date_12,
c0_.cpm_payment_time AS cpm_payment_time_13,
c0_.cpm_error_message AS cpm_error_message_14,
c0_.payment_method AS payment_method_15,
c0_.cpm_phone_prefixe AS cpm_phone_prefixe_16,
c0_.celPhoneNum AS celPhoneNum_17,
c0_.cpm_ipn_ack AS cpm_ipn_ack_18,
c0_.created_at AS created_at_19,
c0_.updated_at AS updated_at_20,
c0_.cpm_result AS cpm_result_21,
c0_.cpm_trans_status AS cpm_trans_status_22,
c0_.cpm_designation AS cpm_designation_23,
c0_.buyer_name AS buyer_name_24,
b1_.slug AS slug_25,
b1_.id AS id_26,
b1_.adresse AS adresse_27,
b1_.adresse3_words AS adresse3_words_28,
b1_.latitude AS latitude_29,
b1_.longitude AS longitude_30,
b1_.est_pro AS est_pro_31,
b1_.est_bloque AS est_bloque_32,
b1_.date_premium AS date_premium_33,
b1_.horaire_douverture AS horaire_douverture_34,
b1_.adresse_gpslat AS adresse_gpslat_35,
b1_.adresse_gpslong AS adresse_gpslong_36,
b1_.la_date AS la_date_37,
b1_.nombre_avis AS nombre_avis_38,
b1_.moyenne_avis AS moyenne_avis_39,
b1_.nom AS nom_40,
b1_.moyenne_note AS moyenne_note_41,
b1_.nombre_de_visite AS nombre_de_visite_42,
b1_.est_certifie AS est_certifie_43,
b1_.est_supprime AS est_supprime_44,
b1_.sigle AS sigle_45,
b1_.email AS email_46,
b1_.phone AS phone_47,
b1_.code_postal AS code_postal_48,
b1_.ville AS ville_49,
b1_.site_web AS site_web_50,
b1_.description AS description_51,
b1_.fax AS fax_52,
b1_.statut_juridique AS statut_juridique_53,
b1_.capital AS capital_54,
b1_.matricule AS matricule_55,
b1_.siret AS siret_56,
b1_.ape AS ape_57,
b1_.cc AS cc_58,
b1_.facture_tva AS facture_tva_59,
b1_.mention_legal AS mention_legal_60,
b1_.banque AS banque_61,
b1_.rib AS rib_62,
b1_.iban AS iban_63,
b1_.bic AS bic_64,
b1_.annee AS annee_65,
b1_.mois AS mois_66,
b1_.qualification AS qualification_67,
b1_.disponibilite AS disponibilite_68,
b1_.gamme_de_prix AS gamme_de_prix_69,
b1_.main_d_oeuvre AS main_d_oeuvre_70,
b1_.zone_d_intervention AS zone_d_intervention_71,
p2_.slug AS slug_72,
p2_.id AS id_73,
p2_.nom AS nom_74,
p2_.contenu AS contenu_75,
p2_.tarif AS tarif_76
FROM
commande c0_
LEFT JOIN boutique b1_ ON c0_.boutique_id = b1_.id
LEFT JOIN plan p2_ ON c0_.plan_id = p2_.id
WHERE
b1_.id = ?
AND c0_.date_fin > ?
SELECT c0_.id AS id_0, c0_.periodique AS periodique_1, c0_.la_date AS la_date_2, c0_.date_debut AS date_debut_3, c0_.date_fin AS date_fin_4, c0_.id_transaction AS id_transaction_5, c0_.signature AS signature_6, c0_.cpm_amount AS cpm_amount_7, c0_.cpm_trans_id AS cpm_trans_id_8, c0_.cpm_custom AS cpm_custom_9, c0_.cpm_currency AS cpm_currency_10, c0_.cpm_payid AS cpm_payid_11, c0_.cpm_payment_date AS cpm_payment_date_12, c0_.cpm_payment_time AS cpm_payment_time_13, c0_.cpm_error_message AS cpm_error_message_14, c0_.payment_method AS payment_method_15, c0_.cpm_phone_prefixe AS cpm_phone_prefixe_16, c0_.celPhoneNum AS celPhoneNum_17, c0_.cpm_ipn_ack AS cpm_ipn_ack_18, c0_.created_at AS created_at_19, c0_.updated_at AS updated_at_20, c0_.cpm_result AS cpm_result_21, c0_.cpm_trans_status AS cpm_trans_status_22, c0_.cpm_designation AS cpm_designation_23, c0_.buyer_name AS buyer_name_24, b1_.slug AS slug_25, b1_.id AS id_26, b1_.adresse AS adresse_27, b1_.adresse3_words AS adresse3_words_28, b1_.latitude AS latitude_29, b1_.longitude AS longitude_30, b1_.est_pro AS est_pro_31, b1_.est_bloque AS est_bloque_32, b1_.date_premium AS date_premium_33, b1_.horaire_douverture AS horaire_douverture_34, b1_.adresse_gpslat AS adresse_gpslat_35, b1_.adresse_gpslong AS adresse_gpslong_36, b1_.la_date AS la_date_37, b1_.nombre_avis AS nombre_avis_38, b1_.moyenne_avis AS moyenne_avis_39, b1_.nom AS nom_40, b1_.moyenne_note AS moyenne_note_41, b1_.nombre_de_visite AS nombre_de_visite_42, b1_.est_certifie AS est_certifie_43, b1_.est_supprime AS est_supprime_44, b1_.sigle AS sigle_45, b1_.email AS email_46, b1_.phone AS phone_47, b1_.code_postal AS code_postal_48, b1_.ville AS ville_49, b1_.site_web AS site_web_50, b1_.description AS description_51, b1_.fax AS fax_52, b1_.statut_juridique AS statut_juridique_53, b1_.capital AS capital_54, b1_.matricule AS matricule_55, b1_.siret AS siret_56, b1_.ape AS ape_57, b1_.cc AS cc_58, b1_.facture_tva AS facture_tva_59, b1_.mention_legal AS mention_legal_60, b1_.banque AS banque_61, b1_.rib AS rib_62, b1_.iban AS iban_63, b1_.bic AS bic_64, b1_.annee AS annee_65, b1_.mois AS mois_66, b1_.qualification AS qualification_67, b1_.disponibilite AS disponibilite_68, b1_.gamme_de_prix AS gamme_de_prix_69, b1_.main_d_oeuvre AS main_d_oeuvre_70, b1_.zone_d_intervention AS zone_d_intervention_71, p2_.slug AS slug_72, p2_.id AS id_73, p2_.nom AS nom_74, p2_.contenu AS contenu_75, p2_.tarif AS tarif_76 FROM commande c0_ LEFT JOIN boutique b1_ ON c0_.boutique_id = b1_.id LEFT JOIN plan p2_ ON c0_.plan_id = p2_.id WHERE b1_.id = '165' AND c0_.date_fin > '2026-08-18 15:37:00';
|