https://dev.tripup.fr/produit/triporteur-cargo-blanc

Query Metrics

72 Database Queries
9 Different statements
102.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
28.79 ms
(28.18%)
30
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.name_es AS name_es_4, t0.texte AS texte_5, t0.texte_en AS texte_en_6, t0.texte_es AS texte_es_7, t0.prix AS prix_8, t0.nbmax AS nbmax_9, t0.type_elem AS type_elem_10, t0.type_prix AS type_prix_11, t0.position AS position_12, t0.prix_table AS prix_table_13, t0.prixmois AS prixmois_14, t0.prixmoisplus AS prixmoisplus_15, t0.nom_accord AS nom_accord_16, t0.maxpv AS maxpv_17, t0.prixachat AS prixachat_18, t0.cat_option_id AS cat_option_id_19, t0.type_cover_id AS type_cover_id_20, t21.id AS id_22, t21.nom AS nom_23, t21.prix AS prix_24 FROM optionvelo t0 LEFT JOIN covering_type t21 ON t0.type_cover_id = t21.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "23"
]
22.29 ms
(21.82%)
30
SELECT t0.id AS id_1, t0.name AS name_2, t0.alt AS alt_3, t0.img_file AS img_file_4, t0.typmedia AS typmedia_5 FROM biblio t0 INNER JOIN optionvelo_biblio ON t0.id = optionvelo_biblio.biblio_id WHERE optionvelo_biblio.optionvelo_id = ?
Parameters:
[
  23
]
16.42 ms
(16.07%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_en AS nom_en_3, t0.nom_es AS nom_es_4, t0.cat AS cat_5, t0.nb_vehicules AS nb_vehicules_6, t0.prix AS prix_7, t0.assist_elect AS assist_elect_8, t0.coque AS coque_9, t0.volume AS volume_10, t0.data AS data_11, t0.meta_title AS meta_title_12, t0.meta_title_en AS meta_title_en_13, t0.meta_title_es AS meta_title_es_14, t0.meta_description AS meta_description_15, t0.meta_description_en AS meta_description_en_16, t0.meta_description_es AS meta_description_es_17, t0.url AS url_18, t0.url_en AS url_en_19, t0.url_es AS url_es_20, t0.prix_loc AS prix_loc_21, t0.data_loc AS data_loc_22, t0.bloc_text AS bloc_text_23, t0.bloc_text_en AS bloc_text_en_24, t0.bloc_text_es AS bloc_text_es_25, t0.prixmois AS prixmois_26, t0.prixmoisplus AS prixmoisplus_27, t0.caractliste AS caractliste_28, t0.prix_table AS prix_table_29, t0.prixoccas AS prixoccas_30, t0.position AS position_31, t0.faq AS faq_32, t0.medias AS medias_33, t0.nb_occasion AS nb_occasion_34, t0.isotherme AS isotherme_35, t0.froid_positif AS froid_positif_36, t0.froid_negatif AS froid_negatif_37, t0.frigo40l AS frigo40l_38, t0.compartimentposinega AS compartimentposinega_39, t0.compartimentisotherme AS compartimentisotherme_40, t0.frigo70l AS frigo70l_41, t0.frigo105l AS frigo105l_42, t0.iso77l AS iso77l_43, t0.mariage AS mariage_44, t0.tournage AS tournage_45, t0.location_min AS location_min_46, t0.images AS images_47, t0.photos AS photos_48, t0.iso60l AS iso60l_49, t0.surface AS surface_50, t0.origine AS origine_51, t0.assist_inclus AS assist_inclus_52, t0.capacite AS capacite_53, t0.categorie_option_img AS categorie_option_img_54, t0.largeur AS largeur_55, t0.hauteur AS hauteur_56, t0.longueur AS longueur_57, t0.emprisesol AS emprisesol_58, t0.nbpassager AS nbpassager_59, t0.compatible_remorque AS compatible_remorque_60, t0.mobilite_reduite AS mobilite_reduite_61, t0.comptoire AS comptoire_62, t0.pilote AS pilote_63, t0.surfacept AS surfacept_64, t0.ptspe AS ptspe_65, t0.defautoptions AS defautoptions_66, t0.interfiles AS interfiles_67, t0.prixachat AS prixachat_68, t0.textinterne AS textinterne_69, t0.nbneuf AS nbneuf_70, t0.coul_coque AS coul_coque_71, t0.coul_cadre AS coul_cadre_72, t0.categorie_id AS categorie_id_73 FROM vehicule t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "triporteur-cargo-blanc"
]
8.92 ms
(8.73%)
1
SELECT f0_.id AS id_0, f0_.titre AS titre_1, f0_.detail AS detail_2, f0_.ordre AS ordre_3, f0_.vehiculeconcerne AS vehiculeconcerne_4, f0_.type AS type_5, f0_.display AS display_6 FROM faq f0_ WHERE f0_.vehiculeconcerne LIKE ? ORDER BY f0_.ordre DESC
Parameters:
[
  "%26%"
]
7.42 ms
(7.26%)
1
SELECT t0.id AS id_1, t0.vehicule AS vehicule_2, t0.localisation AS localisation_3, t0.nom AS nom_4, t0.details AS details_5, t0.disponible AS disponible_6, t0.agence AS agence_7, t0.mecanique AS mecanique_8, t0.preparation AS preparation_9, t0.origine AS origine_10, t0.infos AS infos_11, t0.pilote AS pilote_12, t0.debloc AS debloc_13, t0.entretients AS entretients_14, t0.nomjur AS nomjur_15, t0.nomcomm AS nomcomm_16, t0.typstruct AS typstruct_17, t0.nomclient AS nomclient_18, t0.prenomclient AS prenomclient_19, t0.clienttelfixe AS clienttelfixe_20, t0.clienttelport AS clienttelport_21, t0.clientmail1 AS clientmail1_22, t0.clientmail2 AS clientmail2_23, t0.vendeur_nomprenom AS vendeur_nomprenom_24, t0.vente_date AS vente_date_25, t0.ventenofact AS ventenofact_26, t0.prixventehttc AS prixventehttc_27, t0.payele AS payele_28, t0.ventenote AS ventenote_29, t0.datelastmod AS datelastmod_30, t0.notes AS notes_31, t0.nomoteur AS nomoteur_32, t0.nochassi AS nochassi_33, t0.fournisseur AS fournisseur_34, t0.prixachat AS prixachat_35, t0.dateachat AS dateachat_36, t0.datereceptiontripup AS datereceptiontripup_37, t0.notereceptiontripup AS notereceptiontripup_38, t0.datereceptionclient AS datereceptionclient_39, t0.nobycode AS nobycode_40, t0.noserie AS noserie_41 FROM version_vehicules t0 WHERE t0.vehicule = ? AND t0.disponible = ?
Parameters:
[
  26
  1
]
6.58 ms
(6.44%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.name_es AS name_es_4, t0.position AS position_5, t0.type AS type_6 FROM caract_vehicule t0 WHERE t0.id IN (?) ORDER BY t0.position ASC
Parameters:
[
  [
    "137"
    "72"
    "73"
    "92"
    "81"
    "82"
    "83"
    "84"
    "86"
    "87"
    "89"
    "110"
    "90"
    "120"
    "121"
    "37"
    "41"
    "43"
    "45"
    "47"
    "48"
    "49"
    "54"
    "60"
    "61"
    "63"
    "64"
    "67"
    "70"
    "76"
    "77"
    "79"
    "80"
    "91"
    "94"
    "95"
    "96"
    "100"
  ]
]
5.35 ms
(5.24%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.name_es AS name_es_4, t0.image AS image_5 FROM categorie_option t0 WHERE t0.id = ?
Parameters:
[
  19
]
3.61 ms
(3.54%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.alt AS alt_3, t0.img_file AS img_file_4, t0.typmedia AS typmedia_5 FROM biblio t0 INNER JOIN vehicule_biblio ON t0.id = vehicule_biblio.biblio_id WHERE vehicule_biblio.vehicule_id = ?
Parameters:
[
  26
]
2.78 ms
(2.72%)
1
SELECT t0.id AS id_1, t0.no_devis AS no_devis_2, t0.date_deb AS date_deb_3, t0.date_fin AS date_fin_4, t0.vehictrue AS vehictrue_5, t0.vehic_id AS vehic_id_6, t0.option_id AS option_id_7, t0.nbsel AS nbsel_8, t0.loc_id AS loc_id_9 FROM location_lock t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Vehicule No errors.
App\Entity\CaractVehicule No errors.
App\Entity\Optionvelo No errors.
App\Entity\LocationLock No errors.
App\Entity\Faq No errors.
App\Entity\DevisTemp No errors.
App\Entity\Reduction No errors.
App\Entity\VersionVehicules No errors.
App\Entity\Agence No errors.
App\Entity\CategorieVehicule No errors.
App\Entity\Biblio No errors.
App\Entity\RefEvent No errors.
App\Entity\CategorieOption No errors.
App\Entity\CoveringType No errors.