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

Query Metrics

9 Database Queries
8 Different statements
8.66 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.65 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.92 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 0.69 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.31 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.37 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.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:
[]
7 0.28 ms
SELECT DATABASE()
Parameters:
[]
8 0.85 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "malickto_boutique_pmd"
]
9 0.24 ms
SELECT DATABASE()
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\Order No errors.