Query Metrics
4
Database Queries
4
Different statements
1.19 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.43 ms (36.10%) |
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.title AS title_6, t0.parent_id AS parent_id_7, t0.product_selector_id AS product_selector_id_8, t0.image_id AS image_id_9, t10.name AS name_11, t10.description AS description_12, t10.enabled AS enabled_13, t10.provider_name AS provider_name_14, t10.provider_status AS provider_status_15, t10.provider_reference AS provider_reference_16, t10.provider_metadata AS provider_metadata_17, t10.width AS width_18, t10.height AS height_19, t10.length AS length_20, t10.content_type AS content_type_21, t10.content_size AS content_size_22, t10.copyright AS copyright_23, t10.author_name AS author_name_24, t10.context AS context_25, t10.cdn_is_flushable AS cdn_is_flushable_26, t10.cdn_flush_identifier AS cdn_flush_identifier_27, t10.cdn_flush_at AS cdn_flush_at_28, t10.cdn_status AS cdn_status_29, t10.updated_at AS updated_at_30, t10.created_at AS created_at_31, t10.uuid AS uuid_32, t10.id AS id_33, t0.entityType FROM valueinshop_group t0 LEFT JOIN valueinshop_media t10 ON t0.image_id = t10.id WHERE t0.parent_id IS NULL AND t0.entityType IN ('group') AND ((t0.deleted = 0)) ORDER BY t0.title ASC
Parameters:
[] |
|
0.33 ms (27.38%) |
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.25 ms (21.07%) |
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.18 ms (15.45%) |
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 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| ValueIn\CommonBundle\Entity\AbstractEntity | No errors. |
| App\Entity\Config\Language | No errors. |
| App\Entity\Group | No errors. |
| App\Entity\ProductSelector | No errors. |
| Sonata\MediaBundle\Entity\BaseMedia | No errors. |
| Application\Sonata\MediaBundle\Entity\Media | No errors. |
| App\Entity\HtmlSnippet | No errors. |
| App\Entity\Config\Cart | No errors. |