https://www.rapeto.net/produit/94

Query Metrics

4 Database Queries
4 Different statements
4.70 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.87 ms
(39.70%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.price_ht AS price_ht_3, t0.stock AS stock_4, t0.desctription AS desctription_5, t0.picture AS picture_6, t0.linkspictures AS linkspictures_7, t0.statdispo AS statdispo_8, t0.stateval AS stateval_9, t0.statetype AS statetype_10, t0.statetypes AS statetypes_11, t0.points AS points_12, t0.search_count AS search_count_13, t0.key_word AS key_word_14, t0.modules AS modules_15, t0.enabled AS enabled_16, t0.user_add_id AS user_add_id_17, t0.fkcategorie_id AS fkcategorie_id_18, t0.fksous_categorie_id AS fksous_categorie_id_19, t0.fkdevise_id AS fkdevise_id_20, t0.shop_id AS shop_id_21 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "94"
]
1.29 ms
(27.32%)
1
SELECT t0.id AS id_1, t0.price_dealer AS price_dealer_2, t0.nbr_dealer_prod AS nbr_dealer_prod_3, t0.price_customer AS price_customer_4, t0.supplier_price AS supplier_price_5, t0.price_bulk_customer AS price_bulk_customer_6, t0.promo_price_dealer AS promo_price_dealer_7, t0.promo_price_customer AS promo_price_customer_8, t0.promo_price_bulk_customer AS promo_price_bulk_customer_9, t0.promo_start_at AS promo_start_at_10, t0.promo_end_at AS promo_end_at_11, t0.is_promo_active AS is_promo_active_12, t0.nbr_bulk_prod AS nbr_bulk_prod_13, t0.taxe_product AS taxe_product_14, t0.product_id AS product_id_15 FROM price_product t0 WHERE t0.product_id = ?
Parameters:
[
  94
]
0.78 ms
(16.67%)
1
SELECT t0.id AS id_1, t0.title AS title_2 FROM devise t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.77 ms
(16.31%)
1
SELECT t0.id AS id_1, t0.title AS title_2 FROM categori_product t0 WHERE t0.id = ?
Parameters:
[
  6
]

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\Product
  • The field App\Entity\Product#historiqueTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HistoriqueTransactionFreelance#produit does not contain the required 'inversedBy="historiqueTransactions"' attribute.
App\Entity\UserPlatform
  • The field App\Entity\UserPlatform#freelanceStocks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\FreelanceStock#freelance does not contain the required 'inversedBy="freelanceStocks"' attribute.
  • The field App\Entity\UserPlatform#historiqueTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HistoriqueTransactionFreelance#freelance does not contain the required 'inversedBy="historiqueTransactions"' attribute.
App\Entity\CategoriProduct No errors.
App\Entity\SousCategorie No errors.
App\Entity\Devise No errors.
App\Entity\Shop No errors.
App\Entity\PriceProduct No errors.
App\Entity\Stock No errors.
App\Entity\Location No errors.
App\Entity\FreelanceStock No errors.
App\Entity\HistoriqueTransactionFreelance No errors.