Query Metrics
6
Database Queries
6
Different statements
1.26 ms
Query time
0
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.24 ms (19.07%) |
1 |
SELECT t0.id AS id_1, t0.deleted AS deleted_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.label AS label_6, t0.field_group AS field_group_7, t0.visible_on_all_shop AS visible_on_all_shop_8, t0.visible_without_shop AS visible_without_shop_9, t0.priority AS priority_10, t0.scope AS scope_11, t0.destination AS destination_12, t0.custom_field_name AS custom_field_name_13, t0.default_value AS default_value_14, t0.field_type AS field_type_15, t0.choices AS choices_16, t0.self_service_behavior AS self_service_behavior_17, t0.customer_care_behavior AS customer_care_behavior_18 FROM valueinshop_custom_fields t0 WHERE ((t0.deleted = 0))
Parameters:
[] |
|
0.24 ms (18.77%) |
1 |
SELECT v0_.language_code AS language_code_0, v0_.isDefault AS isDefault_1, v0_.debug AS debug_2, v0_.collect AS collect_3 FROM valueinshop_language v0_ WHERE (v0_.enabled = 1) AND (v0_.deleted = 0)
Parameters:
[] |
|
0.22 ms (17.03%) |
1 |
SELECT t0.id AS id_1, t0.deleted AS deleted_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.language AS language_6, t0.text AS text_7, t0.title AS title_8, t0.source AS source_9 FROM valueinshop_text_translation t0 WHERE t0.source = ? AND t0.language = ? AND ((t0.deleted = 0)) LIMIT 1
Parameters:
[ "empty_cart" "en" ] |
|
0.20 ms (16.07%) |
1 |
SELECT t0.code AS code_1, t0.title AS title_2, t0.text AS text_3 FROM valueinshop_text t0 WHERE t0.code = ?
Parameters:
[
"empty_cart"
]
|
|
0.19 ms (14.80%) |
1 |
SELECT v0_.head_start AS head_start_0, v0_.head_end AS head_end_1, v0_.body_start AS body_start_2, v0_.body_end AS body_end_3 FROM valueinshop_html_snippet v0_ WHERE (v0_.enabled = 1) AND (v0_.deleted = 0)
Parameters:
[] |
|
0.18 ms (14.26%) |
1 |
SELECT v0_.id AS id_0, v0_.use_invoice_engine_preview AS use_invoice_engine_preview_1, v0_.context AS context_2, v0_.shipping_address_mode AS shipping_address_mode_3, v0_.billing_address_mode AS billing_address_mode_4, v0_.display_tax_detail AS display_tax_detail_5, v0_.display_discount_detail AS display_discount_detail_6, v0_.display_map_in_forms AS display_map_in_forms_7 FROM valueinshop_cart v0_
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Config\Cart | 1 |
| App\Entity\Text | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| ValueIn\CommonBundle\Entity\AbstractEntity | No errors. |
| App\Entity\Config\Language | No errors. |
| App\Entity\Config\Cart | No errors. |
| App\Entity\CartCustomField | No errors. |
| App\Entity\HtmlSnippet | No errors. |
| App\Entity\Text | No errors. |
| App\Entity\Translations\TextTranslation | No errors. |