Query Metrics
4
Database Queries
4
Different statements
2.54 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.65 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.host AS host_2, p0_.logo AS logo_3, p0_.favicon AS favicon_4, p0_.currency AS currency_5, p0_.languages AS languages_6, p0_.is_active AS is_active_7, p0_.telegram AS telegram_8, p0_.whatsapp AS whatsapp_9, p0_.phone AS phone_10, p0_.handlers AS handlers_11, p0_.is_fullname AS is_fullname_12, p0_.is_delivery_outside_city AS is_delivery_outside_city_13, p0_.is_cpdp AS is_cpdp_14, p0_.min_order_price AS min_order_price_15, p0_.telegram_message_footer AS telegram_message_footer_16, p0_.verified_domain AS verified_domain_17, p0_.is_urgent_order AS is_urgent_order_18, p0_.is_comment_order AS is_comment_order_19, p0_.is_export_order AS is_export_order_20, p0_.country AS country_21 FROM projects p0_ WHERE p0_.host = ?
Parameters:
[
"razz1k.ru"
]
|
||||||||||||||||||||||||||||
| 2 | 0.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.logo AS logo_4, t0.favicon AS favicon_5, t0.currency AS currency_6, t0.languages AS languages_7, t0.is_active AS is_active_8, t0.telegram AS telegram_9, t0.whatsapp AS whatsapp_10, t0.phone AS phone_11, t0.handlers AS handlers_12, t0.is_fullname AS is_fullname_13, t0.is_delivery_outside_city AS is_delivery_outside_city_14, t0.is_cpdp AS is_cpdp_15, t0.min_order_price AS min_order_price_16, t0.telegram_message_footer AS telegram_message_footer_17, t0.verified_domain AS verified_domain_18, t0.is_urgent_order AS is_urgent_order_19, t0.is_comment_order AS is_comment_order_20, t0.is_export_order AS is_export_order_21, t0.country AS country_22, t23.id AS id_24, t23.monday_start AS monday_start_25, t23.monday_stop AS monday_stop_26, t23.tuesday_start AS tuesday_start_27, t23.tuesday_stop AS tuesday_stop_28, t23.wednesday_start AS wednesday_start_29, t23.wednesday_stop AS wednesday_stop_30, t23.thursday_start AS thursday_start_31, t23.thursday_stop AS thursday_stop_32, t23.friday_start AS friday_start_33, t23.friday_stop AS friday_stop_34, t23.saturday_start AS saturday_start_35, t23.saturday_stop AS saturday_stop_36, t23.sunday_start AS sunday_start_37, t23.sunday_stop AS sunday_stop_38, t23.project_id AS project_id_39 FROM projects t0 LEFT JOIN workdays t23 ON t23.project_id = t0.id
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 0.74 ms |
SELECT t0_.title AS title_0, t1_.content AS content_1 FROM translates t0_ LEFT JOIN translation_values t1_ ON t0_.id = t1_.object_id WHERE (t1_.project_id IS NULL OR t1_.project_id = ?) AND t1_.locale = ? ORDER BY t1_.project_id ASC
Parameters:
[ 1 "kz" ]
|
||||||||||||||||||||||||||||
| 4 | 0.63 ms |
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.title AS title_2, s0_.price AS price_3, s0_.type_price AS type_price_4, s0_.type AS type_5, s1_.id AS id_6, s1_.locale AS locale_7, s1_.field AS field_8, s1_.content AS content_9, s1_.short_name AS short_name_10, s0_.project_id AS project_id_11, s1_.object_id AS object_id_12 FROM services s0_ LEFT JOIN service_translations s1_ ON s0_.id = s1_.object_id WHERE s0_.project_id = ? AND s1_.locale = ? ORDER BY s0_.position ASC
Parameters:
[ 1 "kz" ]
|
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\Project | No errors. |
| App\Entity\Workdays | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\Translate | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
| App\Entity\Translates\TranslationValue | No errors. |
| App\Entity\Translates\ServiceTranslate | No errors. |