Query Metrics
6
Database Queries
5
Different statements
6.08 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.wtt_id AS wtt_id_4, t0.wtt_name AS wtt_name_5, t0.logo AS logo_6, t0.config AS config_7, t0.apikey AS apikey_8, t0.login_hash AS login_hash_9, t0.channel AS channel_10, t0.mail_copy AS mail_copy_11, t0.active AS active_12 FROM shop t0 WHERE t0.id = ?
Parameters:
[
"13"
]
|
| 2 | 0.24 ms |
SELECT count(DISTINCT u0_.id) AS sclr_0 FROM `user` u0_ LEFT JOIN company c1_ ON u0_.company_id = c1_.id LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id WHERE u0_.active = ? AND u0_.shop_id = ?
Parameters:
[ 1 13 ] |
| 3 | 0.14 ms |
SELECT DISTINCT u0_.id AS id_0 FROM `user` u0_ LEFT JOIN company c1_ ON u0_.company_id = c1_.id LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id WHERE u0_.active = ? AND u0_.shop_id = ? LIMIT 30
Parameters:
[ 1 13 ] |
| 4 | 0.17 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.phone AS phone_7, u0_.active AS active_8, u0_.shop_id AS shop_id_9, u0_.company_id AS company_id_10, u0_.parent_id AS parent_id_11 FROM `user` u0_ LEFT JOIN company c1_ ON u0_.company_id = c1_.id LEFT JOIN shop s2_ ON u0_.shop_id = s2_.id WHERE u0_.active = ? AND u0_.shop_id = ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 13 13 553 554 556 557 558 560 563 564 574 587 595 602 634 ] |
| 5 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.vat AS vat_3, t0.siret AS siret_4, t0.kbis_filename AS kbis_filename_5, t0.comment AS comment_6, t0.active AS active_7, t0.parent_id AS parent_id_8, t0.shop_id AS shop_id_9, t0.address_id AS address_id_10 FROM company t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 6 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.vat AS vat_3, t0.siret AS siret_4, t0.kbis_filename AS kbis_filename_5, t0.comment AS comment_6, t0.active AS active_7, t0.parent_id AS parent_id_8, t0.shop_id AS shop_id_9, t0.address_id AS address_id_10 FROM company t0 WHERE t0.id = ?
Parameters:
[
18
]
|
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\Shop | No errors. |
| App\Entity\User |
|
| App\Entity\Order | No errors. |
| App\Entity\Stock | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\ShopSetting | No errors. |
| App\Entity\Imei | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Option | No errors. |
| App\Entity\Status | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\UserSetting | No errors. |
| App\Entity\Sav | No errors. |