Query Metrics
3
Database Queries
3
Different statements
1.16 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.43 ms |
SELECT t0.isDefault AS isDefault_1, t0.prefix AS prefix_2, t0.id AS id_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.title AS title_8, t0.address AS address_9, t0.zipcode AS zipcode_10, t0.city AS city_11, t0.state AS state_12, t0.country AS country_13, t0.description AS description_14, t0.frontend_id AS frontend_id_15, t0.internationalization_id AS internationalization_id_16, t0.invoicing_id AS invoicing_id_17, t0.image_id AS image_id_18, t20.name AS name_19, t20.description AS description_21, t20.enabled AS enabled_22, t20.provider_name AS provider_name_23, t20.provider_status AS provider_status_24, t20.provider_reference AS provider_reference_25, t20.provider_metadata AS provider_metadata_26, t20.width AS width_27, t20.height AS height_28, t20.length AS length_29, t20.content_type AS content_type_30, t20.content_size AS content_size_31, t20.copyright AS copyright_32, t20.author_name AS author_name_33, t20.context AS context_34, t20.cdn_is_flushable AS cdn_is_flushable_35, t20.cdn_flush_identifier AS cdn_flush_identifier_36, t20.cdn_flush_at AS cdn_flush_at_37, t20.cdn_status AS cdn_status_38, t20.updated_at AS updated_at_39, t20.created_at AS created_at_40, t20.uuid AS uuid_41, t20.id AS id_42, t0.imagecover_id AS imagecover_id_43, t0.entityType FROM valueinshop_shop t0 LEFT JOIN valueinshop_media t20 ON t0.image_id = t20.id WHERE t0.id = ? AND t0.entityType IN ('shop') AND ((t0.deleted = 0))
Parameters:
[
1
]
|
2 | 0.44 ms |
SELECT t0.id AS id_1, t0.public_key AS public_key_2, t0.private_key AS private_key_3, t0.payment_terms AS payment_terms_4 FROM valueinshop_config_customer_care t0
Parameters:
[] |
3 | 0.30 ms |
SELECT v0_.name AS name_0, v0_.id AS id_1, v0_.deleted AS deleted_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4, v0_.deleted_at AS deleted_at_5, v0_.entityType AS entityType_6 FROM valueinshop_offer v0_ WHERE ((v0_.updated_at > '2024-12-12 15:21:08') AND (v0_.deleted = 0)) AND v0_.entityType IN ('offer')
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.
Entities Mapping
Class | Mapping errors |
---|---|
ValueIn\CommonBundle\Entity\AbstractEntity | No errors. |
App\Entity\Shop | No errors. |
App\Entity\Shop\Frontend | No errors. |
App\Entity\Shop\Internationalization | No errors. |
App\Entity\Shop\Invoicing | No errors. |
Sonata\MediaBundle\Entity\BaseMedia | No errors. |
Application\Sonata\MediaBundle\Entity\Media | No errors. |
App\Entity\ShopSchedule | No errors. |
App\Entity\ShopProduct | No errors. |
App\Entity\Order | No errors. |
App\Entity\Quote | No errors. |
App\Entity\User | No errors. |
App\Entity\Offer | No errors. |
App\Entity\SubscriptionStrategyCustomFields | No errors. |
App\Entity\Config\QuoteTemplate | No errors. |
App\Entity\ShopProductGroup | No errors. |
App\Entity\Config\Contract | No errors. |
App\Entity\Config\Amendment | No errors. |
App\Entity\Config\CustomerCare | No errors. |
App\Entity\ProductFilter | No errors. |