1
1.06 ms
SELECT t0 . id AS id_1 , t0 . capsule_client_id AS capsule_client_id_2 , t0 . nom AS nom_3 , t0 . forme_juridique AS forme_juridique_4 , t0 . adresse AS adresse_5 , t0 . code_postal AS code_postal_6 , t0 . ville AS ville_7 , t0 . pays AS pays_8 , t0 . email AS email_9 , t0 . telephone AS telephone_10 , t0 . site AS site_11 , t0 . siren AS siren_12 , t0 . siret AS siret_13 , t0 . tva AS tva_14 , t0 . rcs AS rcs_15 , t0 . numero_rcs AS numero_rcs_16 , t0 . capital AS capital_17 , t0 . numero_tva AS numero_tva_18 , t0 . logo AS logo_19 , t0 . logo_crop AS logo_crop_20 , t0 . token AS token_21 , t0 . type_societe AS type_societe_22 , t0 . objet AS objet_23 , t0 . autre AS autre_24 , t0 . signature AS signature_25 , t0 . signature_auto AS signature_auto_26 , t0 . linkedin AS linkedin_27 , t0 . presentation AS presentation_28 , t0 . date1 AS date1_29 , t0 . date2 AS date2_30 , t0 . date3 AS date3_31 , t0 . deleted AS deleted_32 , t0 . mecene AS mecene_33 , t0 . dossier AS dossier_34 , t0 . contact_id AS contact_id_35 , t0 . banque_id AS banque_id_36 , t0 . type_id AS type_id_37 , t0 . departement_id AS departement_id_38 , t0 . secteur_id AS secteur_id_39 FROM societe t0 WHERE t0 . token = ? LIMIT 1
Parameters :
[
"r9SqJvQQLucV0754g3e6DAj7c6euNGVFsYbQJH6x2b0 "
]
SELECT t0 . id AS id_1 , t0 . capsule_client_id AS capsule_client_id_2 , t0 . nom AS nom_3 , t0 . forme_juridique AS forme_juridique_4 , t0 . adresse AS adresse_5 , t0 . code_postal AS code_postal_6 , t0 . ville AS ville_7 , t0 . pays AS pays_8 , t0 . email AS email_9 , t0 . telephone AS telephone_10 , t0 . site AS site_11 , t0 . siren AS siren_12 , t0 . siret AS siret_13 , t0 . tva AS tva_14 , t0 . rcs AS rcs_15 , t0 . numero_rcs AS numero_rcs_16 , t0 . capital AS capital_17 , t0 . numero_tva AS numero_tva_18 , t0 . logo AS logo_19 , t0 . logo_crop AS logo_crop_20 , t0 . token AS token_21 , t0 . type_societe AS type_societe_22 , t0 . objet AS objet_23 , t0 . autre AS autre_24 , t0 . signature AS signature_25 , t0 . signature_auto AS signature_auto_26 , t0 . linkedin AS linkedin_27 , t0 . presentation AS presentation_28 , t0 . date1 AS date1_29 , t0 . date2 AS date2_30 , t0 . date3 AS date3_31 , t0 . deleted AS deleted_32 , t0 . mecene AS mecene_33 , t0 . dossier AS dossier_34 , t0 . contact_id AS contact_id_35 , t0 . banque_id AS banque_id_36 , t0 . type_id AS type_id_37 , t0 . departement_id AS departement_id_38 , t0 . secteur_id AS secteur_id_39 FROM societe t0 WHERE t0 . token = 'r9SqJvQQLucV0754g3e6DAj7c6euNGVFsYbQJH6x2b0' LIMIT 1 ;
Copy
2
0.64 ms
SELECT t0 . id AS id_1 , t0 . roles AS roles_2 , t0 . prenom AS prenom_3 , t0 . nom AS nom_4 , t0 . qrcode AS qrcode_5 , t0 . user_type AS user_type_6 , t0 . is_admin AS is_admin_7 , t0 . email AS email_8 , t0 . password AS password_9 , t0 . image AS image_10 , t0 . statut AS statut_11 , t0 . fonction AS fonction_12 , t0 . adresse AS adresse_13 , t0 . code_postal AS code_postal_14 , t0 . ville AS ville_15 , t0 . pays AS pays_16 , t0 . telephone AS telephone_17 , t0 . token AS token_18 , t0 . deleted AS deleted_19 , t0 . archive AS archive_20 , t0 . telephone_fixe AS telephone_fixe_21 , t0 . entreprise AS entreprise_22 , t0 . linkedin AS linkedin_23 , t0 . siteweb AS siteweb_24 , t0 . idtoken AS idtoken_25 , t0 . role_id AS role_id_26 , t0 . mecene_id AS mecene_id_27 , t0 . soc_id AS soc_id_28 FROM user t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . roles AS roles_2 , t0 . prenom AS prenom_3 , t0 . nom AS nom_4 , t0 . qrcode AS qrcode_5 , t0 . user_type AS user_type_6 , t0 . is_admin AS is_admin_7 , t0 . email AS email_8 , t0 . password AS password_9 , t0 . image AS image_10 , t0 . statut AS statut_11 , t0 . fonction AS fonction_12 , t0 . adresse AS adresse_13 , t0 . code_postal AS code_postal_14 , t0 . ville AS ville_15 , t0 . pays AS pays_16 , t0 . telephone AS telephone_17 , t0 . token AS token_18 , t0 . deleted AS deleted_19 , t0 . archive AS archive_20 , t0 . telephone_fixe AS telephone_fixe_21 , t0 . entreprise AS entreprise_22 , t0 . linkedin AS linkedin_23 , t0 . siteweb AS siteweb_24 , t0 . idtoken AS idtoken_25 , t0 . role_id AS role_id_26 , t0 . mecene_id AS mecene_id_27 , t0 . soc_id AS soc_id_28 FROM user t0 WHERE t0 . id = 3 ;
Copy
3
0.52 ms
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . nom AS nom_3 , t0 . position AS position_4 , t0 . nb AS nb_5 , t0 . affiche AS affiche_6 , t0 . affiche_nom AS affiche_nom_7 , t0 . affiche_logo AS affiche_logo_8 , t0 . deleted AS deleted_9 , t0 . societe_id AS societe_id_10 FROM niveau_mecenat t0 WHERE t0 . societe_id = ? AND t0 . deleted = ?
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . nom AS nom_3 , t0 . position AS position_4 , t0 . nb AS nb_5 , t0 . affiche AS affiche_6 , t0 . affiche_nom AS affiche_nom_7 , t0 . affiche_logo AS affiche_logo_8 , t0 . deleted AS deleted_9 , t0 . societe_id AS societe_id_10 FROM niveau_mecenat t0 WHERE t0 . societe_id = 23 AND t0 . deleted = 0 ;
Copy
4
0.47 ms
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . nom AS nom_3 , t0 . type AS type_4 , t0 . created_at AS created_at_5 , t0 . deleted AS deleted_6 , t0 . societe_id AS societe_id_7 FROM type_mecenat t0 WHERE t0 . societe_id = ? AND t0 . deleted = ?
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . nom AS nom_3 , t0 . type AS type_4 , t0 . created_at AS created_at_5 , t0 . deleted AS deleted_6 , t0 . societe_id AS societe_id_7 FROM type_mecenat t0 WHERE t0 . societe_id = 23 AND t0 . deleted = 0 ;
Copy
5
0.47 ms
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . nom AS nom_3 , t0 . description AS description_4 , t0 . image AS image_5 , t0 . deleted AS deleted_6 , t0 . valeur AS valeur_7 , t0 . nombre_activation AS nombre_activation_8 , t0 . nombre_max AS nombre_max_9 , t0 . societe_id AS societe_id_10 , t0 . categorie_id AS categorie_id_11 , t0 . projet_id AS projet_id_12 FROM type_contrepartie t0 WHERE t0 . societe_id = ? AND t0 . deleted = ?
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . nom AS nom_3 , t0 . description AS description_4 , t0 . image AS image_5 , t0 . deleted AS deleted_6 , t0 . valeur AS valeur_7 , t0 . nombre_activation AS nombre_activation_8 , t0 . nombre_max AS nombre_max_9 , t0 . societe_id AS societe_id_10 , t0 . categorie_id AS categorie_id_11 , t0 . projet_id AS projet_id_12 FROM type_contrepartie t0 WHERE t0 . societe_id = 23 AND t0 . deleted = 0 ;
Copy
6
0.56 ms
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . type AS type_3 , t0 . nom AS nom_4 , t0 . valeur AS valeur_5 , t0 . deduction_fiscale AS deduction_fiscale_6 , t0 . description AS description_7 , t0 . personnalise AS personnalise_8 , t0 . flex AS flex_9 , t0 . valeur_contrepartie AS valeur_contrepartie_10 , t0 . valeur_utilisee AS valeur_utilisee_11 , t0 . created_at AS created_at_12 , t0 . deleted AS deleted_13 , t0 . societe_id AS societe_id_14 , t0 . projet_id AS projet_id_15 , t0 . niveau_id AS niveau_id_16 FROM formule t0 WHERE t0 . societe_id = ? AND t0 . deleted = ?
SELECT t0 . id AS id_1 , t0 . idtoken AS idtoken_2 , t0 . type AS type_3 , t0 . nom AS nom_4 , t0 . valeur AS valeur_5 , t0 . deduction_fiscale AS deduction_fiscale_6 , t0 . description AS description_7 , t0 . personnalise AS personnalise_8 , t0 . flex AS flex_9 , t0 . valeur_contrepartie AS valeur_contrepartie_10 , t0 . valeur_utilisee AS valeur_utilisee_11 , t0 . created_at AS created_at_12 , t0 . deleted AS deleted_13 , t0 . societe_id AS societe_id_14 , t0 . projet_id AS projet_id_15 , t0 . niveau_id AS niveau_id_16 FROM formule t0 WHERE t0 . societe_id = 23 AND t0 . deleted = 0 ;
Copy
7
0.42 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . user_id AS user_id_4 FROM parametre_user t0 WHERE t0 . user_id = ? AND t0 . type = ? LIMIT 1
Parameters :
[
3
"accept_cgu "
]
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . user_id AS user_id_4 FROM parametre_user t0 WHERE t0 . user_id = 3 AND t0 . type = 'accept_cgu' LIMIT 1 ;
Copy
8
0.42 ms
SELECT n0_ . id AS id_0 , n0_ . idtoken AS idtoken_1 , n0_ . type AS type_2 , n0_ . titre AS titre_3 , n0_ . message AS message_4 , n0_ . action AS action_5 , n0_ . url AS url_6 , n0_ . lu AS lu_7 , n0_ . created_at AS created_at_8 , n0_ . read_at AS read_at_9 , n0_ . destinataire_id AS destinataire_id_10 FROM notification n0_ WHERE n0_ . destinataire_id = ? AND n0_ . lu = 0 ORDER BY n0_ . created_at DESC
SELECT n0_ . id AS id_0 , n0_ . idtoken AS idtoken_1 , n0_ . type AS type_2 , n0_ . titre AS titre_3 , n0_ . message AS message_4 , n0_ . action AS action_5 , n0_ . url AS url_6 , n0_ . lu AS lu_7 , n0_ . created_at AS created_at_8 , n0_ . read_at AS read_at_9 , n0_ . destinataire_id AS destinataire_id_10 FROM notification n0_ WHERE n0_ . destinataire_id = 3 AND n0_ . lu = 0 ORDER BY n0_ . created_at DESC ;
Copy
9
0.39 ms
SELECT t0 . id AS id_1 , t0 . bundle_name AS bundle_name_2 , t0 . active AS active_3 , t0 . societe_id AS societe_id_4 FROM subscription t0 WHERE t0 . societe_id = ?
SELECT t0 . id AS id_1 , t0 . bundle_name AS bundle_name_2 , t0 . active AS active_3 , t0 . societe_id AS societe_id_4 FROM subscription t0 WHERE t0 . societe_id = 23 ;
Copy
10
0.53 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
11
0.34 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
12
0.27 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
13
0.58 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
14
0.52 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
15
0.43 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
16
0.41 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
17
0.49 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
18
0.41 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
19
0.50 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
20
0.50 ms
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = ? AND s0_ . active = 1
SELECT s0_ . module AS module_0 FROM subscription_module s0_ WHERE s0_ . societe_id = 23 AND s0_ . active = 1 ;
Copy
21
0.59 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . societe_id AS societe_id_4 FROM parametre t0 WHERE t0 . societe_id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . societe_id AS societe_id_4 FROM parametre t0 WHERE t0 . societe_id = 23 ;
Copy
22
0.47 ms
SELECT n0_ . id AS id_0 , n0_ . idtoken AS idtoken_1 , n0_ . type AS type_2 , n0_ . titre AS titre_3 , n0_ . message AS message_4 , n0_ . action AS action_5 , n0_ . url AS url_6 , n0_ . lu AS lu_7 , n0_ . created_at AS created_at_8 , n0_ . read_at AS read_at_9 , n0_ . destinataire_id AS destinataire_id_10 FROM notification n0_ WHERE n0_ . destinataire_id = ? AND n0_ . lu = 0 ORDER BY n0_ . created_at DESC
SELECT n0_ . id AS id_0 , n0_ . idtoken AS idtoken_1 , n0_ . type AS type_2 , n0_ . titre AS titre_3 , n0_ . message AS message_4 , n0_ . action AS action_5 , n0_ . url AS url_6 , n0_ . lu AS lu_7 , n0_ . created_at AS created_at_8 , n0_ . read_at AS read_at_9 , n0_ . destinataire_id AS destinataire_id_10 FROM notification n0_ WHERE n0_ . destinataire_id = 3 AND n0_ . lu = 0 ORDER BY n0_ . created_at DESC ;
Copy
23
0.39 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . espace_id AS espace_id_4 FROM parametre_espace t0 WHERE t0 . espace_id IS NULL
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . espace_id AS espace_id_4 FROM parametre_espace t0 WHERE t0 . espace_id IS NULL ;
Copy
24
0.64 ms
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . titre AS titre_3 , t0 . start_date AS start_date_4 , t0 . end_date AS end_date_5 , t0 . deadline AS deadline_6 , t0 . statut AS statut_7 , t0 . created_at AS created_at_8 , t0 . objectif_financier AS objectif_financier_9 , t0 . montant_prevu AS montant_prevu_10 , t0 . montant_recu AS montant_recu_11 , t0 . archive AS archive_12 , t0 . logo AS logo_13 , t0 . affiche AS affiche_14 , t0 . public AS public_15 , t0 . deleted AS deleted_16 , t0 . idtoken AS idtoken_17 , t0 . gains AS gains_18 , t0 . depenses AS depenses_19 , t0 . import_convention AS import_convention_20 , t0 . import_formule AS import_formule_21 , t0 . import_modele AS import_modele_22 , t0 . import_contrepartie AS import_contrepartie_23 , t0 . import AS import_24 , t0 . created_by_id AS created_by_id_25 , t0 . societe_id AS societe_id_26 , t0 . signataire_id AS signataire_id_27 , t0 . responsable_id AS responsable_id_28 , t0 . parent_id AS parent_id_29 , t0 . presentation_id AS presentation_id_30 , t0 . espace_id AS espace_id_31 FROM projet t0 WHERE t0 . statut = ? AND t0 . deleted = ?
Parameters :
[
"Ouvert "
0
]
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . titre AS titre_3 , t0 . start_date AS start_date_4 , t0 . end_date AS end_date_5 , t0 . deadline AS deadline_6 , t0 . statut AS statut_7 , t0 . created_at AS created_at_8 , t0 . objectif_financier AS objectif_financier_9 , t0 . montant_prevu AS montant_prevu_10 , t0 . montant_recu AS montant_recu_11 , t0 . archive AS archive_12 , t0 . logo AS logo_13 , t0 . affiche AS affiche_14 , t0 . public AS public_15 , t0 . deleted AS deleted_16 , t0 . idtoken AS idtoken_17 , t0 . gains AS gains_18 , t0 . depenses AS depenses_19 , t0 . import_convention AS import_convention_20 , t0 . import_formule AS import_formule_21 , t0 . import_modele AS import_modele_22 , t0 . import_contrepartie AS import_contrepartie_23 , t0 . import AS import_24 , t0 . created_by_id AS created_by_id_25 , t0 . societe_id AS societe_id_26 , t0 . signataire_id AS signataire_id_27 , t0 . responsable_id AS responsable_id_28 , t0 . parent_id AS parent_id_29 , t0 . presentation_id AS presentation_id_30 , t0 . espace_id AS espace_id_31 FROM projet t0 WHERE t0 . statut = 'Ouvert' AND t0 . deleted = 0 ;
Copy
25
0.68 ms
SELECT e0_ . id AS id_0 , e0_ . idtoken AS idtoken_1 , e0_ . nom AS nom_2 , e0_ . societe_id AS societe_id_3 , e0_ . wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_ . id = p1_ . espace_id WHERE p1_ . id IN (? , ? , ? , ? )
SELECT e0_ . id AS id_0 , e0_ . idtoken AS idtoken_1 , e0_ . nom AS nom_2 , e0_ . societe_id AS societe_id_3 , e0_ . wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_ . id = p1_ . espace_id WHERE p1_ . id IN (1 , 3 , 4 , 6 );
Copy
26
0.67 ms
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . titre AS titre_3 , t0 . start_date AS start_date_4 , t0 . end_date AS end_date_5 , t0 . deadline AS deadline_6 , t0 . statut AS statut_7 , t0 . created_at AS created_at_8 , t0 . objectif_financier AS objectif_financier_9 , t0 . montant_prevu AS montant_prevu_10 , t0 . montant_recu AS montant_recu_11 , t0 . archive AS archive_12 , t0 . logo AS logo_13 , t0 . affiche AS affiche_14 , t0 . public AS public_15 , t0 . deleted AS deleted_16 , t0 . idtoken AS idtoken_17 , t0 . gains AS gains_18 , t0 . depenses AS depenses_19 , t0 . import_convention AS import_convention_20 , t0 . import_formule AS import_formule_21 , t0 . import_modele AS import_modele_22 , t0 . import_contrepartie AS import_contrepartie_23 , t0 . import AS import_24 , t0 . created_by_id AS created_by_id_25 , t0 . societe_id AS societe_id_26 , t0 . signataire_id AS signataire_id_27 , t0 . responsable_id AS responsable_id_28 , t0 . parent_id AS parent_id_29 , t0 . presentation_id AS presentation_id_30 , t0 . espace_id AS espace_id_31 FROM projet t0 WHERE t0 . societe_id = ? AND t0 . statut = ? AND t0 . deleted = ?
Parameters :
[
23
"Ouvert "
0
]
SELECT t0 . id AS id_1 , t0 . description AS description_2 , t0 . titre AS titre_3 , t0 . start_date AS start_date_4 , t0 . end_date AS end_date_5 , t0 . deadline AS deadline_6 , t0 . statut AS statut_7 , t0 . created_at AS created_at_8 , t0 . objectif_financier AS objectif_financier_9 , t0 . montant_prevu AS montant_prevu_10 , t0 . montant_recu AS montant_recu_11 , t0 . archive AS archive_12 , t0 . logo AS logo_13 , t0 . affiche AS affiche_14 , t0 . public AS public_15 , t0 . deleted AS deleted_16 , t0 . idtoken AS idtoken_17 , t0 . gains AS gains_18 , t0 . depenses AS depenses_19 , t0 . import_convention AS import_convention_20 , t0 . import_formule AS import_formule_21 , t0 . import_modele AS import_modele_22 , t0 . import_contrepartie AS import_contrepartie_23 , t0 . import AS import_24 , t0 . created_by_id AS created_by_id_25 , t0 . societe_id AS societe_id_26 , t0 . signataire_id AS signataire_id_27 , t0 . responsable_id AS responsable_id_28 , t0 . parent_id AS parent_id_29 , t0 . presentation_id AS presentation_id_30 , t0 . espace_id AS espace_id_31 FROM projet t0 WHERE t0 . societe_id = 23 AND t0 . statut = 'Ouvert' AND t0 . deleted = 0 ;
Copy
27
0.47 ms
SELECT e0_ . id AS id_0 , e0_ . idtoken AS idtoken_1 , e0_ . nom AS nom_2 , e0_ . societe_id AS societe_id_3 , e0_ . wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_ . id = p1_ . espace_id WHERE p1_ . id IN (? )
SELECT e0_ . id AS id_0 , e0_ . idtoken AS idtoken_1 , e0_ . nom AS nom_2 , e0_ . societe_id AS societe_id_3 , e0_ . wall_id AS wall_id_4 FROM espace e0_ INNER JOIN projet p1_ ON e0_ . id = p1_ . espace_id WHERE p1_ . id IN (6 );
Copy
28
0.45 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . permissions AS permissions_3 , t0 . deleted AS deleted_4 , t0 . idtoken AS idtoken_5 , t0 . societe_id AS societe_id_6 FROM role t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . permissions AS permissions_3 , t0 . deleted AS deleted_4 , t0 . idtoken AS idtoken_5 , t0 . societe_id AS societe_id_6 FROM role t0 WHERE t0 . id = 9 ;
Copy
29
0.54 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . groupe AS groupe_4 FROM permission t0 INNER JOIN role_permission ON t0 . id = role_permission . permission_id WHERE role_permission . role_id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . groupe AS groupe_4 FROM permission t0 INNER JOIN role_permission ON t0 . id = role_permission . permission_id WHERE role_permission . role_id = 9 ;
Copy
30
0.49 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . groupe AS groupe_4 FROM permission t0 INNER JOIN user_permission ON t0 . id = user_permission . permission_id WHERE user_permission . user_id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . description AS description_3 , t0 . groupe AS groupe_4 FROM permission t0 INNER JOIN user_permission ON t0 . id = user_permission . permission_id WHERE user_permission . user_id = 3 ;
Copy
31
0.51 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . societe_id AS societe_id_4 FROM parametre t0 WHERE t0 . societe_id = ? AND t0 . type = ? LIMIT 1
Parameters :
[
23
"nbutilisateur "
]
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . societe_id AS societe_id_4 FROM parametre t0 WHERE t0 . societe_id = 23 AND t0 . type = 'nbutilisateur' LIMIT 1 ;
Copy
32
0.82 ms
SELECT u0_ . id AS id_0 , u0_ . roles AS roles_1 , u0_ . prenom AS prenom_2 , u0_ . nom AS nom_3 , u0_ . qrcode AS qrcode_4 , u0_ . user_type AS user_type_5 , u0_ . is_admin AS is_admin_6 , u0_ . email AS email_7 , u0_ . password AS password_8 , u0_ . image AS image_9 , u0_ . statut AS statut_10 , u0_ . fonction AS fonction_11 , u0_ . adresse AS adresse_12 , u0_ . code_postal AS code_postal_13 , u0_ . ville AS ville_14 , u0_ . pays AS pays_15 , u0_ . telephone AS telephone_16 , u0_ . token AS token_17 , u0_ . deleted AS deleted_18 , u0_ . archive AS archive_19 , u0_ . telephone_fixe AS telephone_fixe_20 , u0_ . entreprise AS entreprise_21 , u0_ . linkedin AS linkedin_22 , u0_ . siteweb AS siteweb_23 , u0_ . idtoken AS idtoken_24 , u0_ . role_id AS role_id_25 , u0_ . mecene_id AS mecene_id_26 , u0_ . soc_id AS soc_id_27 FROM user u0_ WHERE u0_ . user_type = ? AND u0_ . deleted = ? AND EXISTS (SELECT 1 FROM user_societe u1_ WHERE u1_ . user_id = u0_ . id AND u1_ . societe_id IN (? ))
Parameters :
[
"staff "
0
23
]
SELECT u0_ . id AS id_0 , u0_ . roles AS roles_1 , u0_ . prenom AS prenom_2 , u0_ . nom AS nom_3 , u0_ . qrcode AS qrcode_4 , u0_ . user_type AS user_type_5 , u0_ . is_admin AS is_admin_6 , u0_ . email AS email_7 , u0_ . password AS password_8 , u0_ . image AS image_9 , u0_ . statut AS statut_10 , u0_ . fonction AS fonction_11 , u0_ . adresse AS adresse_12 , u0_ . code_postal AS code_postal_13 , u0_ . ville AS ville_14 , u0_ . pays AS pays_15 , u0_ . telephone AS telephone_16 , u0_ . token AS token_17 , u0_ . deleted AS deleted_18 , u0_ . archive AS archive_19 , u0_ . telephone_fixe AS telephone_fixe_20 , u0_ . entreprise AS entreprise_21 , u0_ . linkedin AS linkedin_22 , u0_ . siteweb AS siteweb_23 , u0_ . idtoken AS idtoken_24 , u0_ . role_id AS role_id_25 , u0_ . mecene_id AS mecene_id_26 , u0_ . soc_id AS soc_id_27 FROM user u0_ WHERE u0_ . user_type = 'staff' AND u0_ . deleted = 0 AND EXISTS (SELECT 1 FROM user_societe u1_ WHERE u1_ . user_id = u0_ . id AND u1_ . societe_id IN (23 ));
Copy
33
0.77 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . societe_id AS societe_id_4 FROM parametre t0 WHERE t0 . societe_id = ? AND t0 . type = ? LIMIT 1
Parameters :
[
23
"nbpartenaire "
]
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . valeur AS valeur_3 , t0 . societe_id AS societe_id_4 FROM parametre t0 WHERE t0 . societe_id = 23 AND t0 . type = 'nbpartenaire' LIMIT 1 ;
Copy
34
0.59 ms
SELECT COUNT (m0_ . id ) AS sclr_0 FROM mecene m0_ INNER JOIN mecene_societe m2_ ON m0_ . id = m2_ . mecene_id INNER JOIN societe s1_ ON s1_ . id = m2_ . societe_id WHERE s1_ . id = ?
SELECT COUNT (m0_ . id ) AS sclr_0 FROM mecene m0_ INNER JOIN mecene_societe m2_ ON m0_ . id = m2_ . mecene_id INNER JOIN societe s1_ ON s1_ . id = m2_ . societe_id WHERE s1_ . id = 23 ;
Copy