https://checkcarrier.fourniresto.eu/api/get_range_price

Method
POST
HTTP Status
200
IP
57.128.92.110
Profiled on
Token
a3141a

Query Metrics

3 Database Queries
3 Different statements
0.79 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.14 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.carrier_type_id AS carrier_type_id_3 FROM carrier t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
2 0.52 ms 
SELECT c.id as carrier_id,
                    cz.id as carrier_zone_id,
                    rd.id as range_date_id,
                    pg.id as price_grid_id,
                    rw.id as range_weight_id,
                    pg.*,
                    rw.*,
                    AVG(rw.price) as price
                FROM carrier c
                LEFT JOIN carrier_zone cz
                    ON cz.carrier_id = c.id
                LEFT JOIN range_date rd
                    ON rd.carrier_id = c.id
                LEFT JOIN price_grid pg
                    ON pg.range_date_id = rd.id
                    AND pg.carrier_zone_id = cz.id
                LEFT JOIN range_weight rw
                    ON rw.price_grid_id = pg.id
                WHERE c.id = :carrier_id
                    AND :weight BETWEEN weight_begin AND weight_end
                    AND :date BETWEEN begin AND end
Parameters: 
[
  "carrier_id" => 11
  "weight" => "4.2"
  "date" => "2025-12-13"
]
View formatted query    View runnable query    Explain query
3 0.13 ms 
SELECT t0.id AS id_1, t0.redevance_securite AS redevance_securite_2, t0.livraison_samedi AS livraison_samedi_3, t0.relais_colis AS relais_colis_4, t0.avis_rc AS avis_rc_5, t0.zone_eloignee AS zone_eloignee_6, t0.hors_normes AS hors_normes_7, t0.colis_non_mecanisable AS colis_non_mecanisable_8, t0.out_of_range AS out_of_range_9, t0.ramassage_occasionnel AS ramassage_occasionnel_10, t0.livraison_corse AS livraison_corse_11, t0.on_demand AS on_demand_12, t0.bad_weight AS bad_weight_13, t0.enlevement AS enlevement_14, t0.assurance_ad AS assurance_ad_15, t0.iles_montagnes AS iles_montagnes_16, t0.livraison_saison AS livraison_saison_17, t0.surete AS surete_18, t0.livraison_gms AS livraison_gms_19, t0.livraison_transitaire AS livraison_transitaire_20, t0.livraison_particulier AS livraison_particulier_21, t0.livraison_paris AS livraison_paris_22, t0.livraison_saisonniere AS livraison_saisonniere_23, t0.schenker_surete AS schenker_surete_24, t0.poids_errone AS poids_errone_25, t0.zones_urbaines AS zones_urbaines_26, t0.schenker_express AS schenker_express_27, t0.dpd_surete AS dpd_surete_28, t0.dpd_corse AS dpd_corse_29, t0.dpd_zone_difficile AS dpd_zone_difficile_30, t0.dpd_echec_livraison AS dpd_echec_livraison_31, t0.dpd_frais_dossier AS dpd_frais_dossier_32, t0.dpd_hors_norme AS dpd_hors_norme_33, t0.schenker_taxe_environnementale AS schenker_taxe_environnementale_34, t0.tnt_rpv AS tnt_rpv_35, t0.geodis_paris AS geodis_paris_36, t0.dpd_contibution_logistique AS dpd_contibution_logistique_37, t0.schenker_maut AS schenker_maut_38, t0.schenker_inter_marpol AS schenker_inter_marpol_39, t0.schenker_inter_surete AS schenker_inter_surete_40, t0.schenker_inter_contibution_energetique AS schenker_inter_contibution_energetique_41, t0.fedex_livraison_particulier AS fedex_livraison_particulier_42, t0.fedex_livraison_non_convoyable AS fedex_livraison_non_convoyable_43, t0.fedex_hors_norme AS fedex_hors_norme_44, t0.fedex_poids_eleve AS fedex_poids_eleve_45, t0.schenker_inter_rpv AS schenker_inter_rpv_46, t0.fedex_inter_rpv AS fedex_inter_rpv_47, t0.schenker_inter_douane_suisse AS schenker_inter_douane_suisse_48, t0.dpd_non_mecanisable AS dpd_non_mecanisable_49, t0.range_date_id AS range_date_id_50, t0.carrier_zone_id AS carrier_zone_id_51, t0.carrier_zone_eloignee_id AS carrier_zone_eloignee_id_52 FROM price_grid t0 WHERE t0.id = ?
Parameters: 
[
  "165"
]
View formatted query    View runnable query    Explain query

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\RangeWeight No errors.
App\Entity\CarrierZone No errors.
App\Entity\PriceGrid No errors.
App\Entity\Carrier No errors.
App\Entity\CarrierType No errors.
App\Entity\RangeDate No errors.
App\Entity\Invoice No errors.