https://boutique.pmd-developper.com/cart

Query Metrics

20 Database Queries
14 Different statements
7.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.92 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.quantity AS quantity_8, t0.buying_price AS buying_price_9, t0.etat AS etat_10, t0.qty_reel AS qty_reel_11, t0.label AS label_12, t0.reduction AS reduction_13, t0.status AS status_14, t0.ref AS ref_15, t0.detail AS detail_16, t0.category_id AS category_id_17, t0.brand_id AS brand_id_18 FROM article t0 WHERE t0.id = ?
Parameters:
[
  11
]
2 0.42 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.country_id AS country_id_2 FROM city c0_ INNER JOIN country c1_ ON c0_.country_id = c1_.id WHERE c1_.name = ?
Parameters:
[
  "Sénégal"
]
3 0.35 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city_id AS city_id_2, s0_.shipping_amount_id AS shipping_amount_id_3 FROM street s0_ INNER JOIN city c1_ ON s0_.city_id = c1_.id WHERE c1_.name = ?
Parameters:
[
  "Dakar"
]
4 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.instructions AS instructions_4 FROM payment_method t0
Parameters:
[]
5 0.32 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.instructions AS instructions_3 FROM payment_method p0_
Parameters:
[]
6 0.39 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.country_id AS country_id_2 FROM city c0_ INNER JOIN country c1_ ON c0_.country_id = c1_.id WHERE c1_.name = 'Sénégal'
Parameters:
[]
7 0.37 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city_id AS city_id_2, s0_.shipping_amount_id AS shipping_amount_id_3 FROM street s0_ INNER JOIN city c1_ ON s0_.city_id = c1_.id WHERE c1_.name = 'Dakar'
Parameters:
[]
8 0.32 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.city_id AS city_id_2, s0_.shipping_amount_id AS shipping_amount_id_3 FROM street s0_
Parameters:
[]
9 0.22 ms
SELECT c0_.id AS id_0, c0_.user_id AS user_id_1 FROM client c0_
Parameters:
[]
10 0.39 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.username AS username_6, t0.phone_number AS phone_number_7, t0.last_login_at AS last_login_at_8, t0.is_active AS is_active_9, t0.cle AS cle_10, t0.status AS status_11, t0.is_verified AS is_verified_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.api_key AS api_key_15, t16.id AS id_17, t16.user_id AS user_id_18, t0.delivery_space_id AS delivery_space_id_19, t0.adresse_id AS adresse_id_20 FROM user t0 LEFT JOIN client t16 ON t16.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
11 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM image t0 INNER JOIN article_image ON t0.id = article_image.image_id WHERE article_image.article_id = ?
Parameters:
[
  11
]
12 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category t0
Parameters:
[]
13 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4 FROM category3 t0 WHERE t0.id = ?
Parameters:
[
  1
]
15 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  2
]
16 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  3
]
17 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  4
]
18 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  5
]
19 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
  6
]
20 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category t0
Parameters:
[]

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\PaymentMethod No errors.
App\Entity\City No errors.
App\Entity\Country No errors.
App\Entity\Street No errors.
App\Entity\ShippingAmount No errors.
App\Entity\Client No errors.
App\Entity\Article No errors.
App\Entity\Category No errors.
App\Entity\Brand No errors.
App\Entity\ArticleOption No errors.
App\Entity\Comment No errors.
App\Entity\User No errors.
App\Entity\ArticleBuy No errors.
App\Entity\Image No errors.
App\Entity\DeliverySpace No errors.
App\Entity\Payment No errors.
App\Entity\Adresse No errors.
App\Entity\Order No errors.
App\Entity\Phone No errors.
App\Entity\Category2 No errors.
App\Entity\Category3 No errors.