Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

2.21 ms Query time

6 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.29 ms	SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.staticPrefix = ? AND w0_.type = ?) AND w0_.autoRoute IN ('0', '1') Parameters: [`"/_fragment" "cmf_routing_auto.redirect"`] View formatted query View runnable query Explain query SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE ( w0_.staticPrefix = ? AND w0_.type = ? ) AND w0_.autoRoute IN ('0', '1') SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.staticPrefix = '/_fragment' AND w0_.type = 'cmf_routing_auto.redirect') AND w0_.autoRoute IN ('0', '1');
2	1.73 ms	SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN (?) AND t0.autoRoute IN ('1') ORDER BY t0.position ASC Parameters: [`[ "/_fragment" "/" ]`] View formatted query View runnable query Explain query SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN (?) AND t0.autoRoute IN ('1') ORDER BY t0.position ASC SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN ('/_fragment', '/') AND t0.autoRoute IN ('1') ORDER BY t0.position ASC;
3	0.19 ms	SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN (?) AND t0.autoRoute IN ('1') ORDER BY t0.position ASC Parameters: [`[ "/_fragment" "/" ]`] View formatted query View runnable query Explain query SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN (?) AND t0.autoRoute IN ('1') ORDER BY t0.position ASC SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN ('/_fragment', '/') AND t0.autoRoute IN ('1') ORDER BY t0.position ASC;

#▲

Time

Info

0.29 ms

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.staticPrefix = ? AND w0_.type = ?) AND w0_.autoRoute IN ('0', '1')

Parameters:

[
  "/_fragment"
  "cmf_routing_auto.redirect"
]

View formatted query View runnable query Explain query

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.staticPrefix = ?
    AND w0_.type = ?
  )
  AND w0_.autoRoute IN ('0', '1')

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.staticPrefix = '/_fragment' AND w0_.type = 'cmf_routing_auto.redirect') AND w0_.autoRoute IN ('0', '1');

1.73 ms

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN (?) AND t0.autoRoute IN ('1') ORDER BY t0.position ASC

Parameters:

[
  [
    "/_fragment"
    "/"
  ]
]

View formatted query View runnable query Explain query

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.condition_expr AS condition_expr_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.position AS position_12,
  t0.canonical_name AS canonical_name_13,
  t0.tag AS tag_14,
  t0.sitemapeable AS sitemapeable_15,
  t0.type AS type_16,
  t0.seo_meta_data AS seo_meta_data_17,
  t0.content_class AS content_class_18,
  t0.content_id AS content_id_19,
  t0.redirect_target AS redirect_target_20,
  t0.autoRoute
FROM
  wam_routing_route t0
WHERE
  t0.staticPrefix IN (?)
  AND t0.autoRoute IN ('1')
ORDER BY
  t0.position ASC

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN ('/_fragment', '/') AND t0.autoRoute IN ('1') ORDER BY t0.position ASC;

0.19 ms

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN (?) AND t0.autoRoute IN ('1') ORDER BY t0.position ASC

Parameters:

[
  [
    "/_fragment"
    "/"
  ]
]

View formatted query View runnable query Explain query

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.condition_expr AS condition_expr_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.position AS position_12,
  t0.canonical_name AS canonical_name_13,
  t0.tag AS tag_14,
  t0.sitemapeable AS sitemapeable_15,
  t0.type AS type_16,
  t0.seo_meta_data AS seo_meta_data_17,
  t0.content_class AS content_class_18,
  t0.content_id AS content_id_19,
  t0.redirect_target AS redirect_target_20,
  t0.autoRoute
FROM
  wam_routing_route t0
WHERE
  t0.staticPrefix IN (?)
  AND t0.autoRoute IN ('1')
ORDER BY
  t0.position ASC

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.staticPrefix IN ('/_fragment', '/') AND t0.autoRoute IN ('1') ORDER BY t0.position ASC;

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
Symfony\Component\Routing\Route	No errors.
Symfony\Cmf\Bundle\RoutingBundle\Model\Route	No errors.
WAM\Bundle\RoutingBundle\Entity\Route	No errors.
WAM\Bundle\RoutingBundle\Entity\ManualRoute	No errors.
WAM\Bundle\RoutingBundle\Entity\AutoRoute	No errors.
App\Entity\Routing\Url	No errors.
App\Entity\Ecommerce\Abstracts\AbstractPurchasable	The association App\Entity\Ecommerce\Abstracts\AbstractPurchasable#categories refers to the inverse side field App\Entity\Ecommerce\PurchasableCategory#purchasables which does not exist.
App\Entity\Ecommerce\Gift	The association App\Entity\Ecommerce\Gift#categories refers to the inverse side field App\Entity\Ecommerce\PurchasableCategory#purchasables which does not exist.
App\Entity\WebContent\Faq	No errors.
App\Entity\WebContent\Popup	No errors.
WAM\Bundle\CoreBundle\Entity\Key	No errors.
App\Entity\Form	No errors.
WAM\Bundle\CoreBundle\Entity\BaseCategory	No errors.
WAM\Bundle\CoreBundle\Model\Category	No errors.
WAM\Bundle\CoreBundle\Entity\Cookies	No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit	No errors.
App\Entity\WebContent\Review	No errors.
App\Entity\WebContent\MenuItem	No errors.
App\Entity\Hotel	No errors.
App\Entity\WebContent\Banner	No errors.
App\Entity\Ecommerce\Cart	The field App\Entity\Ecommerce\Cart#cartLines is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ecommerce\CartLine#cart does not contain the required 'inversedBy="cartLines"' attribute.
WAM\Bundle\EcommerceBundle\Entity\Currency	No errors.
WAM\Bundle\WebMakerBundle\Entity\BlockMapping	No errors.
WAM\Bundle\BlockBundle\Entity\UrlHasBlocks	No errors.
WAM\Bundle\RoutingBundle\Entity\Host	No errors.
App\Entity\Routing\UrlTranslation	No errors.
WAM\Bundle\EcommerceBundle\Entity\Tax	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Ecommerce\PurchasableCategory	No errors.
App\Entity\Ecommerce\GiftHasExtra	No errors.
App\Entity\Room	No errors.
App\Entity\Ecommerce\GiftCategory	No errors.
App\Entity\Ecommerce\Abstracts\AbstractPurchasableTranslation	No errors.
App\Entity\Ecommerce\GiftTranslation	No errors.
App\Entity\Media\Gallery	The field App\Entity\Media\Gallery#galleryHasMedias is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Media\GalleryHasMedia#gallery does not contain the required 'inversedBy="galleryHasMedias"' attribute.
App\Entity\WebContent\FaqTranslation	No errors.
WAM\Bundle\CoreBundle\Model\Tag	No errors.
App\Entity\WebContent\PopupTranslation	No errors.
App\Entity\WebContent\VisibilityRule	No errors.
WAM\Bundle\CoreBundle\Entity\Scope	No errors.
App\Entity\FormTranslation	No errors.
WAM\Bundle\CoreBundle\Entity\Context	No errors.
WAM\Bundle\CoreBundle\Entity\BaseCategoryTranslation	No errors.
WAM\Bundle\CoreBundle\Entity\CookiesTranslation	No errors.
Lexik\Bundle\TranslationBundle\Model\Translation	No errors.
Lexik\Bundle\TranslationBundle\Entity\Translation	No errors.
App\Entity\WebContent\MenuItemTranslation	No errors.
App\Entity\KeySellingPoint	No errors.
App\Entity\Experience	No errors.
App\Entity\Advantage	No errors.
App\Entity\Location	No errors.
App\Entity\PurchasableExperience	No errors.
App\Entity\HotelTranslation	No errors.
App\Entity\WebContent\BannerTranslation	No errors.
App\Entity\ShippingData	No errors.
App\Entity\User\Abstracts\AbstractUser	No errors.
App\Entity\Ecommerce\Customer	The field App\Entity\Ecommerce\Customer#carts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ecommerce\Cart#customer does not contain the required 'inversedBy="carts"' attribute. The field App\Entity\Ecommerce\Customer#billingAddresses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ecommerce\AddressBillable#customer does not contain the required 'inversedBy="billingAddresses"' attribute. The field App\Entity\Ecommerce\Customer#shippingAddresses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ecommerce\AddressShippable#customer does not contain the required 'inversedBy="shippingAddresses"' attribute.
App\Entity\Ecommerce\CartLine	No errors.
App\Entity\Ecommerce\Order	The field App\Entity\Ecommerce\Order#orderLines is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Ecommerce\OrderLine#order does not contain the required 'inversedBy="orderLines"' attribute.
App\Entity\Ecommerce\Abstracts\AbstractAddress	No errors.
App\Entity\Ecommerce\AddressBillable	No errors.
App\Entity\Ecommerce\AddressShippable	No errors.
App\Entity\Ecommerce\Promocode	No errors.
WAM\Bundle\BlockBundle\Entity\AbstractBlock	No errors.
WAM\Bundle\BlockBundle\Entity\BaseBlock	No errors.

Symfony Profiler

https://artiemv2.wamrelease.net/_fragment

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping