Query Metrics
18
Database Queries
8
Different statements
13.35 ms
Query time
3
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.34 ms |
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ WHERE b0_.is_active = 1
Parameters:
[] |
| 2 | 0.53 ms |
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM blog b0_ WHERE b0_.is_active = 1 ORDER BY b0_.created_at DESC LIMIT 5
Parameters:
[] |
| 3 | 0.45 ms |
SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3 FROM blog b0_ WHERE b0_.is_active = 1 AND b0_.id IN (?) ORDER BY b0_.created_at DESC
Parameters:
[
2
]
|
| 4 | 1.64 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.image AS image_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.translatable_id AS translatable_id_9, t10.id AS id_11, t10.is_active AS is_active_12, t10.created_at AS created_at_13, t10.updated_at AS updated_at_14 FROM blog_translation t0 LEFT JOIN blog t10 ON t0.translatable_id = t10.id WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 5 | 1.59 ms |
SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3 FROM blog_categories b0_ WHERE b0_.is_active = 1 ORDER BY b0_.created_at DESC
Parameters:
[] |
| 6 | 4.60 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.id AS id_8, t7.is_active AS is_active_9, t7.created_at AS created_at_10, t7.updated_at AS updated_at_11 FROM blog_categories_translation t0 LEFT JOIN blog_categories t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = ?
Parameters:
[
3
]
|
| 7 | 0.76 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.id AS id_8, t7.is_active AS is_active_9, t7.created_at AS created_at_10, t7.updated_at AS updated_at_11 FROM blog_categories_translation t0 LEFT JOIN blog_categories t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 8 | 0.64 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6, t7.id AS id_8, t7.is_active AS is_active_9, t7.created_at AS created_at_10, t7.updated_at AS updated_at_11 FROM blog_categories_translation t0 LEFT JOIN blog_categories t7 ON t0.translatable_id = t7.id WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
| 9 | 0.32 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
| 10 | 0.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_DESCRIPTION"
]
|
| 11 | 0.19 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
| 12 | 0.17 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_DESCRIPTION"
]
|
| 13 | 0.20 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Banner"
]
|
| 14 | 0.17 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.type AS type_7 FROM app_text_translation t0 LEFT JOIN app_text t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
| 15 | 0.14 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
| 16 | 0.12 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header2"
]
|
| 17 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
| 18 | 0.11 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header2"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| pharmonline | doctrine.dbal.pharmonline_connection |
Entity Managers
| Name | Service |
|---|---|
| pharmonline | doctrine.orm.pharmonline_entity_manager |
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
pharmonline entity manager
| Class | Mapping errors |
|---|---|
| App\EntityPharmonline\Users | No errors. |
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Superadmin | No errors. |
| App\Entity\Blog\BlogCategories | No errors. |
| App\Entity\Blog\Blog | No errors. |
| App\Entity\Blog\BlogTranslation | No errors. |
| App\Entity\Blog\BlogCategoriesTranslation | No errors. |
| App\Entity\PharmacyNotification | No errors. |
| App\Entity\Orders\OrdersProducts | No errors. |
| App\Entity\Orders\Orders | No errors. |
| App\Entity\Products\Categories\ProductsCategories |
|
| App\Entity\Products\Products |
|
| App\Entity\Pharmacies\Pharmacies |
|
| App\Entity\Products\Attribut\ProductsAttributsTerms | No errors. |
| App\Entity\Gift\OrderGift | No errors. |
| App\Entity\AppText | No errors. |
| App\Entity\AppTextTranslation | No errors. |