Symfony Profiler

Query Metrics

13 Database Queries

13 Different statements

37.19 ms Query time

1 Invalid entities

714 Managed entities

Queries

Group similar statements

shopware connection


SELECT t0.id AS id_1, t0.parent AS parent_2, t0.path AS path_3, t0.description AS description_4, t0.position AS position_5, t0.active AS active_6, t0.hidetop AS hidetop_7, t0.shops AS shops_8, t0.meta_title AS meta_title_9, t0.metadescription AS metadescription_10, t0.cmstext AS cmstext_11, t0.mediaID AS mediaID_12 FROM s_categories t0 WHERE t0.id = ?
SELECT s0_.id AS id_0, s0_.parent AS parent_1, s0_.path AS path_2, s0_.description AS description_3, s0_.position AS position_4, s0_.active AS active_5, s0_.hidetop AS hidetop_6, s0_.shops AS shops_7, s0_.meta_title AS meta_title_8, s0_.metadescription AS metadescription_9, s0_.cmstext AS cmstext_10, s0_.mediaID AS mediaID_11 FROM s_categories s0_ WHERE s0_.active = 1 AND s0_.hidetop = 0 ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.org_path AS org_path_1, s0_.path AS path_2, s0_.main AS main_3, s0_.subshopID AS subshopID_4 FROM s_core_rewrite_urls s0_ WHERE s0_.org_path IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.main = 1 AND s0_.subshopID = ?
SELECT DISTINCT s0_.id AS id_0 FROM s_articles s0_ INNER JOIN s_articles_details s1_ ON s0_.id = s1_.articleID AND (s1_.kind = 1) INNER JOIN s_articles_attributes s2_ ON s1_.id = s2_.articledetailsID WHERE s0_.active = 1 AND s1_.active = 1 AND COALESCE(s2_.msm_classified_is_deleted, 0) = 0 AND COALESCE(s2_.msm_promotion_type, 0) = 0 AND (EXISTS (SELECT s3_.id FROM s_plugin_msm_promotions s3_ WHERE s3_.article = s0_.id AND s3_.type = ? AND s3_.validUntil > ?))
SELECT s0_.id AS id_0, s0_.parent AS parent_1, s0_.path AS path_2, s0_.description AS description_3, s0_.position AS position_4, s0_.active AS active_5, s0_.hidetop AS hidetop_6, s0_.shops AS shops_7, s0_.meta_title AS meta_title_8, s0_.metadescription AS metadescription_9, s0_.cmstext AS cmstext_10, s1_.id AS id_11, s1_.albumID AS albumID_12, s1_.name AS name_13, s1_.description AS description_14, s1_.path AS path_15, s1_.type AS type_16, s1_.extension AS extension_17, s1_.file_size AS file_size_18, s1_.width AS width_19, s1_.height AS height_20, s1_.userID AS userID_21, s1_.created AS created_22, s0_.mediaID AS mediaID_23 FROM s_categories s0_ INNER JOIN s_media s1_ ON s0_.mediaID = s1_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT s0_.id AS id_0, s0_.albumID AS albumID_1, s0_.create_thumbnails AS create_thumbnails_2, s0_.thumbnail_size AS thumbnail_size_3 FROM s_media_album_settings s0_ WHERE s0_.albumID IN (?) AND s0_.create_thumbnails = 1
SELECT s0_.id AS id_0, s1_.msm_classified_user_id AS sclr_1 FROM s_articles s0_ INNER JOIN s_articles_details s2_ ON s0_.id = s2_.articleID AND (s2_.kind = 1) INNER JOIN s_articles_attributes s1_ ON s2_.id = s1_.articledetailsID WHERE s0_.active = 1 AND s2_.active = 1 AND COALESCE(s1_.msm_classified_is_deleted, 0) = 0 AND COALESCE(s1_.msm_promotion_type, 0) = 0 ORDER BY s0_.datum DESC, s0_.changetime DESC, s0_.id DESC LIMIT 200
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.description AS description_3, s0_.description_long AS description_long_4, s0_.metaTitle AS metaTitle_5, s0_.datum AS datum_6, s0_.changetime AS changetime_7, s1_.id AS id_8, s1_.ordernumber AS ordernumber_9, s1_.active AS active_10, s1_.kind AS kind_11, s2_.id AS id_12, s2_.msm_classified_user_id AS msm_classified_user_id_13, s2_.msm_classified_is_deleted AS msm_classified_is_deleted_14, s2_.msm_classified_youtube_id AS msm_classified_youtube_id_15, s2_.msm_classified_viewcount AS msm_classified_viewcount_16, s2_.msm_classified_hide_name AS msm_classified_hide_name_17, s2_.msm_classified_hide_street AS msm_classified_hide_street_18, s2_.msm_classified_hide_telephone AS msm_classified_hide_telephone_19, s2_.msm_classified_hide_fax AS msm_classified_hide_fax_20, s2_.msm_classified_hide_company_name AS msm_classified_hide_company_name_21, s2_.msm_promotion_type AS msm_promotion_type_22, s2_.msm_promotion_highlight_until AS msm_promotion_highlight_until_23, s2_.msm_sort_date AS msm_sort_date_24, s2_.msm_classified_deleted_at AS msm_classified_deleted_at_25, s2_.msm_classified_delete_reason AS msm_classified_delete_reason_26, s2_.msm_classified_deactivate_reason AS msm_classified_deactivate_reason_27, s2_.msm_classified_review_verdict AS msm_classified_review_verdict_28, s2_.msm_classified_review_reason AS msm_classified_review_reason_29, s2_.msm_classified_review_confidence AS msm_classified_review_confidence_30, s3_.id AS id_31, s3_.email AS email_32, s3_.active AS active_33, s3_.accountmode AS accountmode_34, s3_.doubleOptinRegister AS doubleOptinRegister_35, s3_.doubleOptinConfirmDate AS doubleOptinConfirmDate_36, s3_.password_change_date AS password_change_date_37, s3_.firstname AS firstname_38, s3_.lastname AS lastname_39, s3_.password AS password_40, s3_.encoder AS encoder_41, s3_.changed AS changed_42, s3_.firstlogin AS firstlogin_43, s3_.customernumber AS customernumber_44, s3_.paymentID AS paymentID_45, s3_.language AS language_46, s4_.id AS id_47, s4_.company AS company_48, s4_.phone AS phone_49, s4_.street AS street_50, s4_.zipcode AS zipcode_51, s4_.city AS city_52, s4_.firstname AS firstname_53, s4_.lastname AS lastname_54, s5_.id AS id_55, s5_.iso3 AS iso3_56, s5_.countryname AS countryname_57, s5_.countryen AS countryen_58, s5_.countryiso AS countryiso_59, s6_.id AS id_60, s6_.company AS company_61, s6_.phone AS phone_62, s6_.street AS street_63, s6_.zipcode AS zipcode_64, s6_.city AS city_65, s6_.firstname AS firstname_66, s6_.lastname AS lastname_67, s7_.id AS id_68, s7_.iso3 AS iso3_69, s7_.countryname AS countryname_70, s7_.countryen AS countryen_71, s7_.countryiso AS countryiso_72, s8_.id AS id_73, s8_.tax AS tax_74, s8_.description AS description_75, s0_.supplierID AS supplierID_76, s0_.taxID AS taxID_77, s1_.articleID AS articleID_78, s2_.articledetailsID AS articledetailsID_79, s2_.msm_classified_user_id AS msm_classified_user_id_80, s2_.msm_classified_address_id AS msm_classified_address_id_81, s3_.default_billing_address_id AS default_billing_address_id_82, s4_.country_id AS country_id_83, s6_.country_id AS country_id_84 FROM s_articles s0_ INNER JOIN s_articles_details s1_ ON s0_.id = s1_.articleID INNER JOIN s_articles_attributes s2_ ON s1_.id = s2_.articledetailsID LEFT JOIN s_user s3_ ON s2_.msm_classified_user_id = s3_.id LEFT JOIN s_user_addresses s4_ ON s3_.default_billing_address_id = s4_.id LEFT JOIN s_core_countries s5_ ON s4_.country_id = s5_.id LEFT JOIN s_user_addresses s6_ ON s2_.msm_classified_address_id = s6_.id LEFT JOIN s_core_countries s7_ ON s6_.country_id = s7_.id LEFT JOIN s_core_tax s8_ ON s0_.taxID = s8_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?)
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.description AS description_3, s0_.description_long AS description_long_4, s0_.metaTitle AS metaTitle_5, s0_.datum AS datum_6, s0_.changetime AS changetime_7, s1_.id AS id_8, s1_.img AS img_9, s1_.main AS main_10, s1_.description AS description_11, s1_.position AS position_12, s1_.width AS width_13, s1_.height AS height_14, s1_.relations AS relations_15, s1_.extension AS extension_16, s2_.id AS id_17, s2_.albumID AS albumID_18, s2_.name AS name_19, s2_.description AS description_20, s2_.path AS path_21, s2_.type AS type_22, s2_.extension AS extension_23, s2_.file_size AS file_size_24, s2_.width AS width_25, s2_.height AS height_26, s2_.userID AS userID_27, s2_.created AS created_28, s0_.supplierID AS supplierID_29, s0_.taxID AS taxID_30, s1_.articleID AS articleID_31, s1_.media_id AS media_id_32 FROM s_articles s0_ LEFT JOIN s_articles_img s1_ ON s0_.id = s1_.articleID LEFT JOIN s_media s2_ ON s1_.media_id = s2_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?)
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.description AS description_3, s0_.description_long AS description_long_4, s0_.metaTitle AS metaTitle_5, s0_.datum AS datum_6, s0_.changetime AS changetime_7, s1_.id AS id_8, s1_.pricegroup AS pricegroup_9, s1_.`from` AS from_10, s1_.price AS price_11, s1_.pseudoprice AS pseudoprice_12, s0_.supplierID AS supplierID_13, s0_.taxID AS taxID_14, s1_.articleID AS articleID_15, s1_.articledetailsID AS articledetailsID_16 FROM s_articles s0_ LEFT JOIN s_articles_prices s1_ ON s0_.id = s1_.articleID WHERE s0_.id IN (?, ?, ?, ?, ?, ?)
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.active AS active_2, s0_.description AS description_3, s0_.description_long AS description_long_4, s0_.metaTitle AS metaTitle_5, s0_.datum AS datum_6, s0_.changetime AS changetime_7, s1_.id AS id_8, s1_.value AS value_9, s1_.position AS position_10, s2_.id AS id_11, s2_.name AS name_12, s2_.filterable AS filterable_13, s0_.supplierID AS supplierID_14, s0_.taxID AS taxID_15, s1_.optionID AS optionID_16 FROM s_articles s0_ LEFT JOIN s_filter_articles s3_ ON s0_.id = s3_.articleID LEFT JOIN s_filter_values s1_ ON s1_.id = s3_.valueID LEFT JOIN s_filter_options s2_ ON s1_.optionID = s2_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?)
SELECT s0_.userID AS sclr_0 FROM s_user_attributes s0_ WHERE s0_.userID IN (?, ?, ?, ?) AND s0_.msm_is_user_verified = 1
SELECT s0_.id AS id_0, s0_.org_path AS org_path_1, s0_.path AS path_2, s0_.main AS main_3, s0_.subshopID AS subshopID_4 FROM s_core_rewrite_urls s0_ WHERE s0_.org_path IN (?, ?, ?, ?, ?, ?) AND s0_.main = 1 AND s0_.subshopID = ?

Database Connections

Name	Service
default	doctrine.dbal.default_connection
shopware	doctrine.dbal.shopware_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
shopware	doctrine.orm.shopware_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

shopware entity manager

Class	Amount of managed objects
App\Entity\Shopware\CoreRewriteUrl	289
App\Entity\Shopware\Category	287
App\Entity\Shopware\Media	34
App\Entity\Shopware\ArticleImage	27
App\Entity\Shopware\FilterValue	27
App\Entity\Shopware\FilterOption	10
App\Entity\Shopware\Article	6
App\Entity\Shopware\ArticleDetail	6
App\Entity\Shopware\ArticleAttribute	6
App\Entity\Shopware\ArticlePrice	6
App\Entity\Shopware\ArticleSupplier	5
App\Entity\Shopware\User	4
App\Entity\Shopware\UserAddress	4
App\Entity\Shopware\MediaAlbumSettings	1
App\Entity\Shopware\Country	1
App\Entity\Shopware\Tax	1

Entities Mapping

default entity manager

No loaded entities.

shopware entity manager

Class	Mapping errors
App\Entity\Shopware\Category	No errors.
App\Entity\Shopware\Media	No errors.
App\Entity\Shopware\CoreRewriteUrl	No errors.
App\Entity\Shopware\Article	The field App\Entity\Shopware\Article#prices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Shopware\ArticlePrice#article does not contain the required 'inversedBy: "prices"' attribute.
App\Entity\Shopware\ArticleDetail	No errors.
App\Entity\Shopware\ArticleAttribute	No errors.
App\Entity\Shopware\PromotionEntry	No errors.
App\Entity\Shopware\MediaAlbumSettings	No errors.
App\Entity\Shopware\User	No errors.
App\Entity\Shopware\UserAddress	No errors.
App\Entity\Shopware\Country	No errors.
App\Entity\Shopware\Tax	No errors.
App\Entity\Shopware\ArticleSupplier	No errors.
App\Entity\Shopware\ArticleImage	No errors.
App\Entity\Shopware\ArticlePrice	No errors.
App\Entity\Shopware\FilterValue	No errors.
App\Entity\Shopware\FilterOption	No errors.
App\Entity\Shopware\UserAttribute	No errors.

GET http://eddie.taile2ae39.ts.net/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

shopware connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

shopware entity manager

Entities Mapping

default entity manager

shopware entity manager