1 |
0.37 ms |
SELECT t0.id AS id_1, t0.route AS route_2, t0.image_slider AS image_slider_3, t0.titre_fr_seo AS titre_fr_seo_4, t0.titre_en_seo AS titre_en_seo_5, t0.titre_de_seo AS titre_de_seo_6, t0.description_fr_seo AS description_fr_seo_7, t0.description_en_seo AS description_en_seo_8, t0.description_de_seo AS description_de_seo_9, t0.titre_fr AS titre_fr_10, t0.titre_en AS titre_en_11, t0.titre_de AS titre_de_12 FROM pages t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.route AS route_2, t0.image_slider AS image_slider_3, t0.titre_fr_seo AS titre_fr_seo_4, t0.titre_en_seo AS titre_en_seo_5, t0.titre_de_seo AS titre_de_seo_6, t0.description_fr_seo AS description_fr_seo_7, t0.description_en_seo AS description_en_seo_8, t0.description_de_seo AS description_de_seo_9, t0.titre_fr AS titre_fr_10, t0.titre_en AS titre_en_11, t0.titre_de AS titre_de_12 FROM pages t0 WHERE t0.id = 4 LIMIT 1;
|
2 |
0.38 ms |
SELECT t0.id AS id_1, t0.titre_en AS titre_en_2, t0.titre_fr AS titre_fr_3, t0.titre_de AS titre_de_4, t0.intro_fr AS intro_fr_5, t0.intro_en AS intro_en_6, t0.intro_de AS intro_de_7, t0.page_id AS page_id_8, t0.expertise_id AS expertise_id_9, t0.event_id AS event_id_10, t0.award_id AS award_id_11 FROM qand_a t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.titre_en AS titre_en_2, t0.titre_fr AS titre_fr_3, t0.titre_de AS titre_de_4, t0.intro_fr AS intro_fr_5, t0.intro_en AS intro_en_6, t0.intro_de AS intro_de_7, t0.page_id AS page_id_8, t0.expertise_id AS expertise_id_9, t0.event_id AS event_id_10, t0.award_id AS award_id_11 FROM qand_a t0 WHERE t0.page_id = 4;
|
3 |
0.33 ms |
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.contenus_id AS contenus_id_8, t0.qanda_id AS qanda_id_9 FROM accordeons t0 WHERE t0.qanda_id IN (NULL)
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.titre_de AS titre_de_4, t0.description_fr AS description_fr_5, t0.description_en AS description_en_6, t0.description_de AS description_de_7, t0.contenus_id AS contenus_id_8, t0.qanda_id AS qanda_id_9 FROM accordeons t0 WHERE t0.qanda_id IN (NULL);
|
4 |
0.43 ms |
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 ORDER BY t0.nom_en ASC
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 ORDER BY t0.nom_en ASC;
|
5 |
0.34 ms |
SELECT t0.id AS id_1, t0.role_en AS role_en_2, t0.priority AS priority_3, t0.role_fr AS role_fr_4, t0.role_de AS role_de_5, t0.role_change_fr AS role_change_fr_6, t0.role_change_en AS role_change_en_7, t0.role_change_de AS role_change_de_8 FROM roles_avocats t0 ORDER BY t0.priority ASC
SELECT t0.id AS id_1, t0.role_en AS role_en_2, t0.priority AS priority_3, t0.role_fr AS role_fr_4, t0.role_de AS role_de_5, t0.role_change_fr AS role_change_fr_6, t0.role_change_en AS role_change_en_7, t0.role_change_de AS role_change_de_8 FROM roles_avocats t0 ORDER BY t0.priority ASC;
|
6 |
11.83 ms |
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.description_en AS description_en_2, a0_.telephone AS telephone_3, a0_.linkedin AS linkedin_4, a0_.mail AS mail_5, a0_.image AS image_6, a0_.education_accordeon AS education_accordeon_7, a0_.language_accordeon AS language_accordeon_8, a0_.memberships_accordeon AS memberships_accordeon_9, a0_.date_admission_barreau AS date_admission_barreau_10, a0_.telephone_perso AS telephone_perso_11, a0_.vcard AS vcard_12, a0_.bio_pdf AS bio_pdf_13, a0_.qrcode AS qrcode_14, a0_.affichage AS affichage_15, a0_.affichage_liste AS affichage_liste_16, a0_.seo_description_en AS seo_description_en_17, a0_.seo_description_fr AS seo_description_fr_18, a0_.seo_description_de AS seo_description_de_19, a0_.role_change_en AS role_change_en_20, a0_.role_change_fr AS role_change_fr_21, a0_.role_change_de AS role_change_de_22, a0_.role_id AS role_id_23 FROM avocats a0_ INNER JOIN roles_avocats r1_ ON a0_.role_id = r1_.id ORDER BY r1_.priority ASC, CASE WHEN a0_.date_admission_barreau IS NULL THEN 1 ELSE 0 END ASC, a0_.date_admission_barreau ASC, SUBSTRING(a0_.nom FROM LOCATE(' ', a0_.nom) + 1) ASC
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.description_en AS description_en_2, a0_.telephone AS telephone_3, a0_.linkedin AS linkedin_4, a0_.mail AS mail_5, a0_.image AS image_6, a0_.education_accordeon AS education_accordeon_7, a0_.language_accordeon AS language_accordeon_8, a0_.memberships_accordeon AS memberships_accordeon_9, a0_.date_admission_barreau AS date_admission_barreau_10, a0_.telephone_perso AS telephone_perso_11, a0_.vcard AS vcard_12, a0_.bio_pdf AS bio_pdf_13, a0_.qrcode AS qrcode_14, a0_.affichage AS affichage_15, a0_.affichage_liste AS affichage_liste_16, a0_.seo_description_en AS seo_description_en_17, a0_.seo_description_fr AS seo_description_fr_18, a0_.seo_description_de AS seo_description_de_19, a0_.role_change_en AS role_change_en_20, a0_.role_change_fr AS role_change_fr_21, a0_.role_change_de AS role_change_de_22, a0_.role_id AS role_id_23 FROM avocats a0_ INNER JOIN roles_avocats r1_ ON a0_.role_id = r1_.id ORDER BY r1_.priority ASC, CASE WHEN a0_.date_admission_barreau IS NULL THEN 1 ELSE 0 END ASC, a0_.date_admission_barreau ASC, SUBSTRING(a0_.nom FROM LOCATE(' ', a0_.nom) + 1) ASC;
|
7 |
0.35 ms |
SELECT t0.id AS id_1, t0.texte_fr AS texte_fr_2, t0.texte_en AS texte_en_3, t0.texte_de AS texte_de_4, t0.image AS image_5, t0.pages_id AS pages_id_6, t0.expertises_id AS expertises_id_7 FROM sliders t0 WHERE t0.pages_id = ?
SELECT t0.id AS id_1, t0.texte_fr AS texte_fr_2, t0.texte_en AS texte_en_3, t0.texte_de AS texte_de_4, t0.image AS image_5, t0.pages_id AS pages_id_6, t0.expertises_id AS expertises_id_7 FROM sliders t0 WHERE t0.pages_id = 4;
|
8 |
0.41 ms |
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 ORDER BY t0.nom_en ASC
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 ORDER BY t0.nom_en ASC;
|
9 |
0.25 ms |
SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0
SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0;
|
10 |
0.46 ms |
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 WHERE t0.affichage = ? ORDER BY t0.nom_en ASC
SELECT t0.id AS id_1, t0.nom_en AS nom_en_2, t0.nom_fr AS nom_fr_3, t0.nom_de AS nom_de_4, t0.image AS image_5, t0.affichage AS affichage_6, t0.seo_description_de AS seo_description_de_7, t0.seo_description_fr AS seo_description_fr_8, t0.seo_description_en AS seo_description_en_9, t0.categorie_id AS categorie_id_10 FROM expertises t0 WHERE t0.affichage = 'Oui' ORDER BY t0.nom_en ASC;
|
11 |
0.25 ms |
SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0
SELECT t0.id AS id_1, t0.libelle_en AS libelle_en_2, t0.libelle_fr AS libelle_fr_3, t0.libelle_de AS libelle_de_4 FROM categories_expertises t0;
|