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

Query Metrics

18 Database Queries
12 Different statements
29.08 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 18.30 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"
]
2 0.57 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"
]
3 3.64 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:
[]
4 0.27 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:
[]
5 0.43 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:
[]
6 0.36 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:
[]
7 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_
Parameters:
[]
8 0.71 ms
SELECT c0_.id AS id_0, c0_.user_id AS user_id_1 FROM client c0_
Parameters:
[]
9 0.56 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
]
10 0.73 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:
[]
11 0.66 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
]
12 0.67 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
]
13 0.33 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
]
14 0.33 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
]
15 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:
[
  4
]
16 0.33 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
]
17 0.25 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
]
18 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\DeliverySpace No errors.
App\Entity\Payment No errors.
App\Entity\User No errors.
App\Entity\ArticleBuy No errors.
App\Entity\Adresse No errors.
App\Entity\Comment No errors.
App\Entity\Order No errors.
App\Entity\Article No errors.
App\Entity\Phone No errors.
App\Entity\Category No errors.
App\Entity\Category2 No errors.
App\Entity\Category3 No errors.