Query Metrics
8
Database Queries
5
Different statements
3.63 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.31 ms |
SELECT t0.name AS name_1, t0.value AS value_2 FROM settings t0 WHERE t0.name = ?
Parameters:
[
"app.additional_langs"
]
|
| 2 | 0.70 ms |
SELECT t0.name AS name_1, t0.value AS value_2 FROM settings t0 WHERE t0.name = ?
Parameters:
[
"app.payment_methods"
]
|
| 3 | 0.71 ms |
SELECT count(DISTINCT o0_.id) AS sclr_0 FROM online_service o0_
Parameters:
[] |
| 4 | 0.17 ms |
SELECT DISTINCT o0_.id AS id_0, o0_.name AS name_1 FROM online_service o0_ ORDER BY o0_.name ASC LIMIT 12
Parameters:
[] |
| 5 | 0.23 ms |
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.description AS description_2, o0_.image AS image_3, o0_.items_price AS items_price_4, o0_.discount AS discount_5, o0_.price AS price_6 FROM online_service o0_ WHERE o0_.id IN (?) ORDER BY o0_.name ASC
Parameters:
[
1
]
|
| 6 | 1.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.price_info AS price_info_4, t0.id_offer_generator_price_list_group AS id_offer_generator_price_list_group_5 FROM offer_generator_price_list_group_item t0 INNER JOIN online_service_price_list_item ON t0.id = online_service_price_list_item.id_offer_generator_price_list_group_item WHERE online_service_price_list_item.id_online_service = ?
Parameters:
[
1
]
|
| 7 | 0.24 ms |
SELECT t0.name AS name_1, t0.value AS value_2 FROM settings t0 WHERE t0.name = ?
Parameters:
[
"offer_generator.settings"
]
|
| 8 | 0.24 ms |
SELECT t0.name AS name_1, t0.value AS value_2 FROM settings t0 WHERE t0.name = ?
Parameters:
[
"app.settings"
]
|
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\Settings | No errors. |
| App\Admin\Modules\OnlineService\Entity\OnlineService | No errors. |
| App\Admin\Modules\OfferGenerator\Entity\OfferGeneratorPriceListGroupItem | No errors. |
| App\Admin\Modules\OfferGenerator\Entity\OfferGeneratorPriceListGroup | No errors. |