Query Metrics
9
Database Queries
8
Different statements
8.66 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.65 ms (53.66%) |
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.92 ms (10.60%) |
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.85 ms (9.83%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"malickto_boutique_pmd"
]
|
0.69 ms (7.92%) |
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.52 ms (5.97%) |
2 |
SELECT DATABASE()
Parameters:
[] |
0.37 ms (4.29%) |
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.37 ms (4.21%) |
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.31 ms (3.52%) |
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:
[] |
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. |