GET https://azima24.com/api/promotion/invoice/25989

Query Metrics

6 Database Queries
3 Different statements
40.79 ms Query time
1 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 17.02 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.promotion_id AS promotion_id_3, t0.invoice_id AS invoice_id_4, t0.brand_id AS brand_id_5 FROM promotion_invoice t0 WHERE t0.invoice_id = ?
Parameters:
[
  "25989"
]
2 11.30 ms
SELECT t0.id AS id_1, t0.required_products_for_free AS required_products_for_free_2, t0.number_good_free AS number_good_free_3, t0.unite AS unite_4, t0.unity_free AS unity_free_5, t0.date AS date_6, t0.date_fin AS date_fin_7, t0.status AS status_8, t0.good_id AS good_id_9, t0.good_free_id AS good_free_id_10 FROM promotion t0 WHERE t0.id = ?
Parameters:
[
  69
]
3 1.21 ms
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.pricectns AS pricectns_3, t0.pricebox AS pricebox_4, t0.pricebottle AS pricebottle_5, t0.priceitem AS priceitem_6, t0.pricesac AS pricesac_7 FROM goods t0 WHERE t0.id = ?
Parameters:
[
  8
]
4 0.64 ms
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.pricectns AS pricectns_3, t0.pricebox AS pricebox_4, t0.pricebottle AS pricebottle_5, t0.priceitem AS priceitem_6, t0.pricesac AS pricesac_7 FROM goods t0 WHERE t0.id = ?
Parameters:
[
  41
]
5 7.96 ms
SELECT t0.id AS id_1, t0.required_products_for_free AS required_products_for_free_2, t0.number_good_free AS number_good_free_3, t0.unite AS unite_4, t0.unity_free AS unity_free_5, t0.date AS date_6, t0.date_fin AS date_fin_7, t0.status AS status_8, t0.good_id AS good_id_9, t0.good_free_id AS good_free_id_10 FROM promotion t0 WHERE t0.id = ?
Parameters:
[
  70
]
6 2.66 ms
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.pricectns AS pricectns_3, t0.pricebox AS pricebox_4, t0.pricebottle AS pricebottle_5, t0.priceitem AS priceitem_6, t0.pricesac AS pricesac_7 FROM goods t0 WHERE t0.id = ?
Parameters:
[
  39
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Goods 3
App\Entity\PromotionInvoice 2
App\Entity\Promotion 2
App\Entity\Invoice 1

Entities Mapping

Class Mapping errors
App\Entity\PromotionInvoice
  • The association App\Entity\PromotionInvoice#brand refers to the inverse side field App\Entity\Goods#promotionInvoices which does not exist.
App\Entity\Promotion No errors.
App\Entity\Invoice No errors.
App\Entity\Goods No errors.
App\Entity\Purchase No errors.
App\Entity\Inventory No errors.
App\Entity\MvtStock No errors.