Query Metrics

3 Database Queries
3 Different statements
1.09 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.43 ms
(39.35%)
1
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
]
0.40 ms
(36.41%)
1
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:
[]
0.26 ms
(24.24%)
1
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-13 11:00:48') 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.