Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

18.64 ms Query time

1 Invalid entities

6 Cache hits

0 Cache misses

1 Cache puts

Queries

Group similar statements

#▲	Time	Info
1	18.64 ms	SELECT t0.id AS id_11, t0.path AS path_12, t0.locale AS locale_13, t0.type, t1.foreign_id AS foreign_id_14, t2.foreign_id AS foreign_id_15, t3.foreign_id AS foreign_id_16, t4.foreign_id AS foreign_id_17, t5.foreign_id AS foreign_id_18, t6.foreign_id AS foreign_id_19, t7.foreign_id AS foreign_id_20, t8.foreign_id AS foreign_id_21, t9.foreign_id AS foreign_id_22, t10.foreign_id AS foreign_id_23 FROM route t0 LEFT JOIN route_category t1 ON t0.id = t1.id LEFT JOIN route_producer t2 ON t0.id = t2.id LEFT JOIN route_product t3 ON t0.id = t3.id LEFT JOIN route_product_status t4 ON t0.id = t4.id LEFT JOIN route_producer_collection t5 ON t0.id = t5.id LEFT JOIN route_news t6 ON t0.id = t6.id LEFT JOIN route_news_category t7 ON t0.id = t7.id LEFT JOIN route_landing_page t8 ON t0.id = t8.id LEFT JOIN route_page t9 ON t0.id = t9.id LEFT JOIN route_tag t10 ON t0.id = t10.id WHERE t0.path = ? Parameters: [`"robots.txt"`] View formatted query View runnable query Explain query SELECT t0.id AS id_11, t0.path AS path_12, t0.locale AS locale_13, t0.type, t1.foreign_id AS foreign_id_14, t2.foreign_id AS foreign_id_15, t3.foreign_id AS foreign_id_16, t4.foreign_id AS foreign_id_17, t5.foreign_id AS foreign_id_18, t6.foreign_id AS foreign_id_19, t7.foreign_id AS foreign_id_20, t8.foreign_id AS foreign_id_21, t9.foreign_id AS foreign_id_22, t10.foreign_id AS foreign_id_23 FROM route t0 LEFT JOIN route_category t1 ON t0.id = t1.id LEFT JOIN route_producer t2 ON t0.id = t2.id LEFT JOIN route_product t3 ON t0.id = t3.id LEFT JOIN route_product_status t4 ON t0.id = t4.id LEFT JOIN route_producer_collection t5 ON t0.id = t5.id LEFT JOIN route_news t6 ON t0.id = t6.id LEFT JOIN route_news_category t7 ON t0.id = t7.id LEFT JOIN route_landing_page t8 ON t0.id = t8.id LEFT JOIN route_page t9 ON t0.id = t9.id LEFT JOIN route_tag t10 ON t0.id = t10.id WHERE t0.path = ? SELECT t0.id AS id_11, t0.path AS path_12, t0.locale AS locale_13, t0.type, t1.foreign_id AS foreign_id_14, t2.foreign_id AS foreign_id_15, t3.foreign_id AS foreign_id_16, t4.foreign_id AS foreign_id_17, t5.foreign_id AS foreign_id_18, t6.foreign_id AS foreign_id_19, t7.foreign_id AS foreign_id_20, t8.foreign_id AS foreign_id_21, t9.foreign_id AS foreign_id_22, t10.foreign_id AS foreign_id_23 FROM route t0 LEFT JOIN route_category t1 ON t0.id = t1.id LEFT JOIN route_producer t2 ON t0.id = t2.id LEFT JOIN route_product t3 ON t0.id = t3.id LEFT JOIN route_product_status t4 ON t0.id = t4.id LEFT JOIN route_producer_collection t5 ON t0.id = t5.id LEFT JOIN route_news t6 ON t0.id = t6.id LEFT JOIN route_news_category t7 ON t0.id = t7.id LEFT JOIN route_landing_page t8 ON t0.id = t8.id LEFT JOIN route_page t9 ON t0.id = t9.id LEFT JOIN route_tag t10 ON t0.id = t10.id WHERE t0.path = 'robots.txt';

#▲

Time

Info

18.64 ms

SELECT t0.id AS id_11, t0.path AS path_12, t0.locale AS locale_13, t0.type, t1.foreign_id AS foreign_id_14, t2.foreign_id AS foreign_id_15, t3.foreign_id AS foreign_id_16, t4.foreign_id AS foreign_id_17, t5.foreign_id AS foreign_id_18, t6.foreign_id AS foreign_id_19, t7.foreign_id AS foreign_id_20, t8.foreign_id AS foreign_id_21, t9.foreign_id AS foreign_id_22, t10.foreign_id AS foreign_id_23 FROM route t0 LEFT JOIN route_category t1 ON t0.id = t1.id LEFT JOIN route_producer t2 ON t0.id = t2.id LEFT JOIN route_product t3 ON t0.id = t3.id LEFT JOIN route_product_status t4 ON t0.id = t4.id LEFT JOIN route_producer_collection t5 ON t0.id = t5.id LEFT JOIN route_news t6 ON t0.id = t6.id LEFT JOIN route_news_category t7 ON t0.id = t7.id LEFT JOIN route_landing_page t8 ON t0.id = t8.id LEFT JOIN route_page t9 ON t0.id = t9.id LEFT JOIN route_tag t10 ON t0.id = t10.id WHERE t0.path = ?

Parameters:

[
  "robots.txt"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_11,
  t0.path AS path_12,
  t0.locale AS locale_13,
  t0.type,
  t1.foreign_id AS foreign_id_14,
  t2.foreign_id AS foreign_id_15,
  t3.foreign_id AS foreign_id_16,
  t4.foreign_id AS foreign_id_17,
  t5.foreign_id AS foreign_id_18,
  t6.foreign_id AS foreign_id_19,
  t7.foreign_id AS foreign_id_20,
  t8.foreign_id AS foreign_id_21,
  t9.foreign_id AS foreign_id_22,
  t10.foreign_id AS foreign_id_23
FROM
  route t0
  LEFT JOIN route_category t1 ON t0.id = t1.id
  LEFT JOIN route_producer t2 ON t0.id = t2.id
  LEFT JOIN route_product t3 ON t0.id = t3.id
  LEFT JOIN route_product_status t4 ON t0.id = t4.id
  LEFT JOIN route_producer_collection t5 ON t0.id = t5.id
  LEFT JOIN route_news t6 ON t0.id = t6.id
  LEFT JOIN route_news_category t7 ON t0.id = t7.id
  LEFT JOIN route_landing_page t8 ON t0.id = t8.id
  LEFT JOIN route_page t9 ON t0.id = t9.id
  LEFT JOIN route_tag t10 ON t0.id = t10.id
WHERE
  t0.path = ?

SELECT t0.id AS id_11, t0.path AS path_12, t0.locale AS locale_13, t0.type, t1.foreign_id AS foreign_id_14, t2.foreign_id AS foreign_id_15, t3.foreign_id AS foreign_id_16, t4.foreign_id AS foreign_id_17, t5.foreign_id AS foreign_id_18, t6.foreign_id AS foreign_id_19, t7.foreign_id AS foreign_id_20, t8.foreign_id AS foreign_id_21, t9.foreign_id AS foreign_id_22, t10.foreign_id AS foreign_id_23 FROM route t0 LEFT JOIN route_category t1 ON t0.id = t1.id LEFT JOIN route_producer t2 ON t0.id = t2.id LEFT JOIN route_product t3 ON t0.id = t3.id LEFT JOIN route_product_status t4 ON t0.id = t4.id LEFT JOIN route_producer_collection t5 ON t0.id = t5.id LEFT JOIN route_news t6 ON t0.id = t6.id LEFT JOIN route_news_category t7 ON t0.id = t7.id LEFT JOIN route_landing_page t8 ON t0.id = t8.id LEFT JOIN route_page t9 ON t0.id = t9.id LEFT JOIN route_tag t10 ON t0.id = t10.id WHERE t0.path = 'robots.txt';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

6 Hits

0 Misses

1 Puts

Number of cache hits

Region	Hits
wellcommerce_bundle_appbundle_entity_shop	2
wellcommerce_bundle_corebundle_entity_route	1
wellcommerce_bundle_appbundle_entity_locale	2
wellcommerce_bundle_appbundle_entity_currency	1

Number of cache puts

Region	Puts
wellcommerce_bundle_corebundle_entity_route	1

Entities Mapping

Class	Mapping errors
WellCommerce\Bundle\AppBundle\Entity\Shop	No errors.
WellCommerce\Bundle\AppBundle\Entity\Pos	No errors.
WellCommerce\Bundle\AppBundle\Entity\Tax	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\ProductStatus	No errors.
WellCommerce\Bundle\AppBundle\Entity\ComplaintStatus	No errors.
WellCommerce\Bundle\AppBundle\Entity\Company	No errors.
WellCommerce\Bundle\AppBundle\Entity\Mailbox	No errors.
WellCommerce\Bundle\AppBundle\Entity\Theme	No errors.
WellCommerce\Bundle\CmsBundle\Entity\Contact	No errors.
WellCommerce\Bundle\AppBundle\Entity\ClientGroup	No errors.
WellCommerce\Bundle\OrderBundle\Entity\OrderStatus	No errors.
WellCommerce\Bundle\AppBundle\Entity\ShopTranslation	No errors.
WellCommerce\Bundle\CoreBundle\Entity\Route	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\CategoryRoute	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\ProducerRoute	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\ProductRoute	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\ProductStatusRoute	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\ProducerCollectionRoute	No errors.
WellCommerce\Bundle\CmsBundle\Entity\NewsRoute	No errors.
WellCommerce\Bundle\CmsBundle\Entity\NewsCategoryRoute	No errors.
WellCommerce\Bundle\CmsBundle\Entity\LandingPageRoute	No errors.
WellCommerce\Bundle\CmsBundle\Entity\PageRoute	No errors.
WellCommerce\Bundle\CmsBundle\Entity\TagRoute	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\Category	The field WellCommerce\Bundle\CatalogBundle\Entity\Category#featureGroups is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity UniSport\Bundle\AppBundle\Entity\CategoryFeatureGroup#category does not contain the required 'inversedBy="featureGroups"' attribute.
WellCommerce\Bundle\CatalogBundle\Entity\Producer	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\Product	No errors.
WellCommerce\Bundle\CatalogBundle\Entity\ProducerCollection	No errors.
WellCommerce\Bundle\CmsBundle\Entity\News	No errors.
WellCommerce\Bundle\CmsBundle\Entity\NewsCategory	No errors.
WellCommerce\Bundle\CmsBundle\Entity\LandingPage	No errors.
WellCommerce\Bundle\CmsBundle\Entity\Page	No errors.
WellCommerce\Bundle\CmsBundle\Entity\Tag	No errors.
WellCommerce\Bundle\AppBundle\Entity\LayoutBox	No errors.
WellCommerce\Bundle\AppBundle\Entity\Warehouse	No errors.
WellCommerce\Bundle\CmsBundle\Entity\Faq	No errors.
WellCommerce\Bundle\CmsBundle\Entity\FaqCategory	No errors.
WellCommerce\Bundle\NotificationBundle\Entity\PriceNotification	No errors.
WellCommerce\Bundle\NotificationBundle\Entity\StockNotification	No errors.
WellCommerce\Bundle\AppBundle\Entity\Locale	No errors.
WellCommerce\Bundle\AppBundle\Entity\Currency	No errors.
WellCommerce\Bundle\AppBundle\Entity\LocaleTranslation	No errors.

Symfony Profiler

https://api.dev.mmtsklep.pl/robots.txt

Configuration Settings

Theme

Page Width