| 2 |
1.83 ms |
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.nom AS nom_4, t0.numero AS numero_5, t0.info1 AS info1_6, t0.info2 AS info2_7, t0.info3 AS info3_8, t0.description AS description_9, t0.slug AS slug_10, t0.type_etape AS type_etape_11 FROM etape t0
SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.nom AS nom_4, t0.numero AS numero_5, t0.info1 AS info1_6, t0.info2 AS info2_7, t0.info3 AS info3_8, t0.description AS description_9, t0.slug AS slug_10, t0.type_etape AS type_etape_11 FROM etape t0;
|
| 3 |
2.07 ms |
SELECT t0.id AS id_1, t0.sens AS sens_2, t0.titre AS titre_3, t0.km AS km_4, t0.denivele_monte AS denivele_monte_5, t0.denivele_descente AS denivele_descente_6, t0.difficulte AS difficulte_7, t0.numero AS numero_8, t0.slug AS slug_9, t0.etape_depart_id AS etape_depart_id_10, t0.etape_arrivee_id AS etape_arrivee_id_11 FROM troncon t0 WHERE t0.sens = ? ORDER BY t0.numero ASC
SELECT t0.id AS id_1, t0.sens AS sens_2, t0.titre AS titre_3, t0.km AS km_4, t0.denivele_monte AS denivele_monte_5, t0.denivele_descente AS denivele_descente_6, t0.difficulte AS difficulte_7, t0.numero AS numero_8, t0.slug AS slug_9, t0.etape_depart_id AS etape_depart_id_10, t0.etape_arrivee_id AS etape_arrivee_id_11 FROM troncon t0 WHERE t0.sens = 1 ORDER BY t0.numero ASC;
|
| 4 |
2.42 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.ville AS ville_4, c0_.code_postal AS code_postal_5, c0_.pays AS pays_6, c0_.adresse_ligne1 AS adresse_ligne1_7, c0_.adresse_ligne2 AS adresse_ligne2_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.slug AS slug_11, c0_.est_valide AS est_valide_12, c0_.icone AS icone_13, c0_.detail AS detail_14, c0_.activer_messagerie AS activer_messagerie_15, c0_.email AS email_16, c0_.siteweb AS siteweb_17, c0_.telephone AS telephone_18, c0_.afficher_email AS afficher_email_19, c0_.afficher_telephone AS afficher_telephone_20, c0_.demande_validation AS demande_validation_21, c0_.afficher_adresse AS afficher_adresse_22, c0_.proprietaire_id AS proprietaire_id_23, c0_.type_commerce_id AS type_commerce_id_24, c0_.etape_id AS etape_id_25 FROM commerce c0_ WHERE c0_.latitude IS NOT NULL AND c0_.longitude IS NOT NULL
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.ville AS ville_4, c0_.code_postal AS code_postal_5, c0_.pays AS pays_6, c0_.adresse_ligne1 AS adresse_ligne1_7, c0_.adresse_ligne2 AS adresse_ligne2_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.slug AS slug_11, c0_.est_valide AS est_valide_12, c0_.icone AS icone_13, c0_.detail AS detail_14, c0_.activer_messagerie AS activer_messagerie_15, c0_.email AS email_16, c0_.siteweb AS siteweb_17, c0_.telephone AS telephone_18, c0_.afficher_email AS afficher_email_19, c0_.afficher_telephone AS afficher_telephone_20, c0_.demande_validation AS demande_validation_21, c0_.afficher_adresse AS afficher_adresse_22, c0_.proprietaire_id AS proprietaire_id_23, c0_.type_commerce_id AS type_commerce_id_24, c0_.etape_id AS etape_id_25 FROM commerce c0_ WHERE c0_.latitude IS NOT NULL AND c0_.longitude IS NOT NULL;
|