Query Metrics
38
Database Queries
9
Different statements
19.77 ms
Query time
0
Invalid entities
Grouped Statements
| 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. |