Query Metrics
20
Database Queries
14
Different statements
11.10 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.48 ms (22.33%) |
6 |
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
]
|
1.99 ms (17.89%) |
1 |
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:
[
5
]
|
1.10 ms (9.94%) |
1 |
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:
[
5
]
|
0.80 ms (7.20%) |
1 |
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"
]
|
0.79 ms (7.07%) |
2 |
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:
[] |
0.61 ms (5.50%) |
1 |
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"
]
|
0.55 ms (4.98%) |
1 |
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
]
|
0.50 ms (4.49%) |
1 |
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
]
|
0.44 ms (3.94%) |
1 |
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:
[] |
0.44 ms (3.94%) |
1 |
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:
[] |
0.40 ms (3.63%) |
1 |
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:
[] |
0.36 ms (3.21%) |
1 |
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:
[] |
0.34 ms (3.08%) |
1 |
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:
[] |
0.31 ms (2.79%) |
1 |
SELECT c0_.id AS id_0, c0_.user_id AS user_id_1 FROM client c0_
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. |