https://clainservice.madaprogiciel.com/

Query Metrics

50 Database Queries
13 Different statements
83.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
34.61 ms
(41.52%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_name AS image_name_3 FROM categori_product t0
Parameters:
[]
21.91 ms
(26.29%)
9
SELECT p0_.id AS id_0, p0_.id_product AS id_product_1, p0_.product AS product_2, p0_.categorie AS categorie_3, p0_.default_image AS default_image_4, p0_.brand AS brand_5 FROM product_list p0_ WHERE p0_.categorie = ? AND p0_.brand = ? LIMIT 24
Parameters:
[
  "Chaussures"
  1
]
9.53 ms
(11.43%)
14
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:
[
  27
]
6.99 ms
(8.38%)
14
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:
[
  27
]
2.45 ms
(2.94%)
3
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.price_bulk_customer AS price_bulk_customer_5, t0.nbr_bulk_prod AS nbr_bulk_prod_6, t0.taxe_product AS taxe_product_7, t0.product_id AS product_id_8 FROM price_product t0 WHERE t0.product_id = ?
Parameters:
[
  22
]
1.82 ms
(2.18%)
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
]
1.44 ms
(1.72%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_token AS reset_token_5, t0.token_expiration AS token_expiration_6, t0.nameuser AS nameuser_7, t0.adresse AS adresse_8, t0.adresse_livraison AS adresse_livraison_9, t0.phone AS phone_10, t0.mail AS mail_11 FROM user_platform t0 WHERE t0.email = ?
Parameters:
[
  "clainservice@gmail.com"
]
1.13 ms
(1.36%)
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
]
0.87 ms
(1.05%)
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.74 ms
(0.89%)
1
SELECT t0.id AS id_1, t0.yen AS yen_2, t0.ariary AS ariary_3 FROM cours_de_change t0
Parameters:
[]
0.70 ms
(0.84%)
1
SELECT t0.id AS id_1, t0.montant AS montant_2 FROM commission t0
Parameters:
[]
0.63 ms
(0.76%)
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.54 ms
(0.65%)
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
]

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.
App\Entity\ProductList No errors.
App\Entity\CoursDeChange No errors.
App\Entity\Commission No errors.