Query Metrics
2
Database Queries
2
Different statements
1.07 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.62 ms (57.89%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.profile_api_url AS profile_api_url_3, t0.redirect_uri AS redirect_uri_4, t0.client_id AS client_id_5, t0.secret AS secret_6, t0.language AS language_7, t0.country AS country_8, t0.isDefault AS isDefault_9, t0.shop_id AS shop_id_10 FROM jan_rain_config t0 WHERE t0.shop_id = ? LIMIT 1
Parameters:
[
1
]
|
0.45 ms (42.11%) |
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
]
|
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. |
Local\HagerBundle\Entity\Admin\Janrain\JanRainConfig | No errors. |