https://preprod.clainservice.rapeto.net/

Query Metrics

38 Database Queries
9 Different statements
19.77 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.63 ms
(38.61%)
15
SELECT s0_.id AS id_0, s0_.stock_dispo AS stock_dispo_1, s0_.stock_reel AS stock_reel_2, p1_.id AS id_3, p1_.title AS title_4, p1_.price_ht AS price_ht_5, p1_.desctription AS desctription_6, p1_.picture AS picture_7, p1_.linkspictures AS linkspictures_8, p1_.statdispo AS statdispo_9, p1_.stateval AS stateval_10, p1_.points AS points_11, p1_.key_word AS key_word_12, p1_.product_day AS product_day_13, p1_.cat_mode AS cat_mode_14, s0_.produit_id AS produit_id_15, p1_.user_add_id AS user_add_id_16, p1_.fkcategorie_id AS fkcategorie_id_17, p1_.fksous_categorie_id AS fksous_categorie_id_18, p1_.fkdevise_id AS fkdevise_id_19, p1_.shop_id AS shop_id_20 FROM stock s0_ INNER JOIN product p1_ ON s0_.produit_id = p1_.id WHERE p1_.id = ?
Parameters:
[
  37
]
6.10 ms
(30.87%)
15
SELECT p0_.id AS id_0, p0_.price_dealer AS price_dealer_1, p0_.nbr_dealer_prod AS nbr_dealer_prod_2, p0_.price_customer AS price_customer_3, p0_.price_bulk_customer AS price_bulk_customer_4, p0_.nbr_bulk_prod AS nbr_bulk_prod_5, p0_.taxe_product AS taxe_product_6, p0_.product_id AS product_id_7 FROM price_product p0_ WHERE p0_.product_id = ?
Parameters:
[
  37
]
1.93 ms
(9.75%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_name AS image_name_3 FROM categori_product t0
Parameters:
[]
0.95 ms
(4.82%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.desctription AS desctription_3, p0_.picture AS picture_4, p0_.linkspictures AS linkspictures_5, p0_.statdispo AS statdispo_6, p0_.stateval AS stateval_7, p0_.points AS points_8, p0_.key_word AS key_word_9, p0_.product_day AS product_day_10, p0_.cat_mode AS cat_mode_11, p0_.user_add_id AS user_add_id_12, p0_.fkcategorie_id AS fkcategorie_id_13, p0_.fksous_categorie_id AS fksous_categorie_id_14, p0_.fkdevise_id AS fkdevise_id_15, p0_.shop_id AS shop_id_16 FROM product p0_ WHERE p0_.user_add_id = ? AND p0_.product_day = ? LIMIT 12
Parameters:
[
  18
  0
]
0.87 ms
(4.39%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nameuser AS nameuser_5, t0.adresse AS adresse_6, t0.phone AS phone_7, t0.mail AS mail_8 FROM user_platform t0 WHERE t0.email = ?
Parameters:
[
  "clainservice@gmail.com"
]
0.62 ms
(3.13%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.desctription AS desctription_3, p0_.picture AS picture_4, p0_.linkspictures AS linkspictures_5, p0_.statdispo AS statdispo_6, p0_.stateval AS stateval_7, p0_.points AS points_8, p0_.key_word AS key_word_9, p0_.product_day AS product_day_10, p0_.cat_mode AS cat_mode_11, p0_.user_add_id AS user_add_id_12, p0_.fkcategorie_id AS fkcategorie_id_13, p0_.fksous_categorie_id AS fksous_categorie_id_14, p0_.fkdevise_id AS fkdevise_id_15, p0_.shop_id AS shop_id_16 FROM product p0_ WHERE p0_.user_add_id = ? AND p0_.product_day = ?
Parameters:
[
  18
  1
]
0.60 ms
(3.01%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.desctription AS desctription_3, p0_.picture AS picture_4, p0_.linkspictures AS linkspictures_5, p0_.statdispo AS statdispo_6, p0_.stateval AS stateval_7, p0_.points AS points_8, p0_.key_word AS key_word_9, p0_.product_day AS product_day_10, p0_.cat_mode AS cat_mode_11, p0_.user_add_id AS user_add_id_12, p0_.fkcategorie_id AS fkcategorie_id_13, p0_.fksous_categorie_id AS fksous_categorie_id_14, p0_.fkdevise_id AS fkdevise_id_15, p0_.shop_id AS shop_id_16 FROM product p0_ WHERE p0_.user_add_id = ? AND p0_.product_day = ? ORDER BY p0_.id ASC LIMIT 3
Parameters:
[
  18
  1
]
0.58 ms
(2.91%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.desctription AS desctription_3, p0_.picture AS picture_4, p0_.linkspictures AS linkspictures_5, p0_.statdispo AS statdispo_6, p0_.stateval AS stateval_7, p0_.points AS points_8, p0_.key_word AS key_word_9, p0_.product_day AS product_day_10, p0_.cat_mode AS cat_mode_11, p0_.user_add_id AS user_add_id_12, p0_.fkcategorie_id AS fkcategorie_id_13, p0_.fksous_categorie_id AS fksous_categorie_id_14, p0_.fkdevise_id AS fkdevise_id_15, p0_.shop_id AS shop_id_16 FROM product p0_ WHERE p0_.user_add_id = ? AND p0_.product_day = ? ORDER BY p0_.id DESC LIMIT 3
Parameters:
[
  18
  1
]
0.50 ms
(2.51%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.price_ht AS price_ht_2, p0_.desctription AS desctription_3, p0_.picture AS picture_4, p0_.linkspictures AS linkspictures_5, p0_.statdispo AS statdispo_6, p0_.stateval AS stateval_7, p0_.points AS points_8, p0_.key_word AS key_word_9, p0_.product_day AS product_day_10, p0_.cat_mode AS cat_mode_11, p0_.user_add_id AS user_add_id_12, p0_.fkcategorie_id AS fkcategorie_id_13, p0_.fksous_categorie_id AS fksous_categorie_id_14, p0_.fkdevise_id AS fkdevise_id_15, p0_.shop_id AS shop_id_16 FROM product p0_ WHERE p0_.user_add_id = ? AND p0_.fkcategorie_id = ? AND p0_.cat_mode = ?
Parameters:
[
  18
  4
  1
]

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\CategoriProduct No errors.
App\Entity\UserPlatform No errors.
App\Entity\Order No errors.
App\Entity\Product 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.