Error 404 Not Found

POST https://pricing.efel.app/api/getprice

Query Metrics

5 Database Queries
4 Different statements
2.22 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.90 ms
(40.36%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.vat AS vat_3 FROM agency t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "LISBONNE"
]
0.55 ms
(24.95%)
1
SELECT d0_.id AS id_0, d0_.day AS day_1, d0_.product AS product_2, d0_.default_price AS default_price_3, d0_.factor AS factor_4, d0_.agency_id AS agency_id_5 FROM day_price d0_ WHERE d0_.agency_id = ? AND d0_.product = ? AND d0_.day >= ? AND d0_.day <= ? ORDER BY d0_.day ASC
Parameters:
[
  92
  "BAROUDEUR CALIFORNIA T6.1"
  "2028-09-04 00:00:00"
  "2028-09-20 00:00:00"
]
0.53 ms
(23.83%)
1
SELECT t0.id AS id_1, t0.day AS day_2, t0.product AS product_3, t0.default_price AS default_price_4, t0.factor AS factor_5, t0.agency_id AS agency_id_6 FROM day_price t0 WHERE t0.agency_id = ? AND t0.product = ? LIMIT 1
Parameters:
[
  92
  "BAROUDEUR CALIFORNIA T6.1"
]
0.24 ms
(10.86%)
1
SELECT t0.id AS id_1, t0.price AS price_2, t0.product AS product_3, t0.agency_id AS agency_id_4 FROM product_floor_price t0 WHERE t0.product = ? AND t0.agency_id = ? LIMIT 1
Parameters:
[
  "BAROUDEUR CALIFORNIA T6.1"
  92
]

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\Agency No errors.
App\Entity\DayPrice
  • The field 'App\Entity\DayPrice#defaultPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\FactorByLength No errors.
App\Entity\ProductFloorPrice No errors.