Query Metrics
11
Database Queries
3
Different statements
5.62 ms
Query time
3
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 1.51 ms |
SELECT o0_.id AS id_0, o0_.order_number AS order_number_1, o0_.price AS price_2, o0_.status AS status_3, o0_.shipping_name AS shipping_name_4, o0_.shipping_address AS shipping_address_5, o0_.shipping_postcode AS shipping_postcode_6, o0_.shipping_city AS shipping_city_7, o0_.invoce_name AS invoce_name_8, o0_.invode_address AS invode_address_9, o0_.invoce_postcode AS invoce_postcode_10, o0_.invoce_city AS invoce_city_11, o0_.comment AS comment_12, o0_.is_done AS is_done_13, o0_.user_id AS user_id_14, o0_.pharmacy_id AS pharmacy_id_15, o0_.created_at AS created_at_16, o0_.updated_at AS updated_at_17, o0_.shipping_type_id AS shipping_type_id_18, o0_.payment_method_id AS payment_method_id_19 FROM orders o0_ WHERE o0_.created_at BETWEEN ? AND ?
Parameters:
[ "2025-02-16 00:00:00" "2025-02-22 04:42:06" ] |
2 | 1.61 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
3 | 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_DESCRIPTION"
]
|
4 | 0.13 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_KEYWORD"
]
|
5 | 0.09 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"HEADER_DESCRIPTION"
]
|
6 | 0.26 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Banner"
]
|
7 | 1.01 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
]
|
8 | 0.24 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
9 | 0.25 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header2"
]
|
10 | 0.10 ms |
SELECT t0.id AS id_1, t0.type AS type_2 FROM app_text t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"Header1"
]
|
11 | 0.09 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\Orders\Orders | No errors. |
App\Entity\Pharmacies\PharmacyShippingMethod | No errors. |
App\Entity\Pharmacies\PharmacyPaymentMethod | No errors. |
App\Entity\PharmacyNotification | No errors. |
App\Entity\Orders\OrdersProducts | 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. |