Query Metrics
50
Database Queries
13
Different statements
83.37 ms
Query time
0
Invalid entities
Grouped Statements
| 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. |