Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.64 ms Query time

1 Invalid entities

0 Cache hits

1 Cache misses

1 Cache puts

Grouped Statements

Show all queries

Time▼	Count	Info
0.64 ms (100.00%)	1	SELECT t0.id AS id_7, t0.path AS path_8, t0.site_id AS site_id_9, t0.type, t1.foreign_id AS foreign_id_10, t2.foreign_id AS foreign_id_11, t3.foreign_id AS foreign_id_12, t4.foreign_id AS foreign_id_13, t5.foreign_id AS foreign_id_14, t6.foreign_id AS foreign_id_15 FROM routes t0 LEFT JOIN routes_article t1 ON t0.id = t1.id LEFT JOIN routes_article_category t2 ON t0.id = t2.id LEFT JOIN routes_page t3 ON t0.id = t3.id LEFT JOIN routes_group_section t4 ON t0.id = t4.id LEFT JOIN routes_product t5 ON t0.id = t5.id LEFT JOIN routes_category t6 ON t0.id = t6.id WHERE t0.path = ? AND t0.site_id = ? LIMIT 1 Parameters: [`"Blog" "pl"`] View formatted query View runnable query Explain query SELECT t0.id AS id_7, t0.path AS path_8, t0.site_id AS site_id_9, t0.type, t1.foreign_id AS foreign_id_10, t2.foreign_id AS foreign_id_11, t3.foreign_id AS foreign_id_12, t4.foreign_id AS foreign_id_13, t5.foreign_id AS foreign_id_14, t6.foreign_id AS foreign_id_15 FROM routes t0 LEFT JOIN routes_article t1 ON t0.id = t1.id LEFT JOIN routes_article_category t2 ON t0.id = t2.id LEFT JOIN routes_page t3 ON t0.id = t3.id LEFT JOIN routes_group_section t4 ON t0.id = t4.id LEFT JOIN routes_product t5 ON t0.id = t5.id LEFT JOIN routes_category t6 ON t0.id = t6.id WHERE t0.path = ? AND t0.site_id = ? LIMIT 1 SELECT t0.id AS id_7, t0.path AS path_8, t0.site_id AS site_id_9, t0.type, t1.foreign_id AS foreign_id_10, t2.foreign_id AS foreign_id_11, t3.foreign_id AS foreign_id_12, t4.foreign_id AS foreign_id_13, t5.foreign_id AS foreign_id_14, t6.foreign_id AS foreign_id_15 FROM routes t0 LEFT JOIN routes_article t1 ON t0.id = t1.id LEFT JOIN routes_article_category t2 ON t0.id = t2.id LEFT JOIN routes_page t3 ON t0.id = t3.id LEFT JOIN routes_group_section t4 ON t0.id = t4.id LEFT JOIN routes_product t5 ON t0.id = t5.id LEFT JOIN routes_category t6 ON t0.id = t6.id WHERE t0.path = 'Blog' AND t0.site_id = 'pl' LIMIT 1;

Time▼

Count

Info

0.64 ms
(100.00%)

SELECT t0.id AS id_7, t0.path AS path_8, t0.site_id AS site_id_9, t0.type, t1.foreign_id AS foreign_id_10, t2.foreign_id AS foreign_id_11, t3.foreign_id AS foreign_id_12, t4.foreign_id AS foreign_id_13, t5.foreign_id AS foreign_id_14, t6.foreign_id AS foreign_id_15 FROM routes t0 LEFT JOIN routes_article t1 ON t0.id = t1.id LEFT JOIN routes_article_category t2 ON t0.id = t2.id LEFT JOIN routes_page t3 ON t0.id = t3.id LEFT JOIN routes_group_section t4 ON t0.id = t4.id LEFT JOIN routes_product t5 ON t0.id = t5.id LEFT JOIN routes_category t6 ON t0.id = t6.id WHERE t0.path = ? AND t0.site_id = ? LIMIT 1

Parameters:

[
  "Blog"
  "pl"
]

View formatted query View runnable query Explain query

SELECT 
  t0.id AS id_7, 
  t0.path AS path_8, 
  t0.site_id AS site_id_9, 
  t0.type, 
  t1.foreign_id AS foreign_id_10, 
  t2.foreign_id AS foreign_id_11, 
  t3.foreign_id AS foreign_id_12, 
  t4.foreign_id AS foreign_id_13, 
  t5.foreign_id AS foreign_id_14, 
  t6.foreign_id AS foreign_id_15 
FROM 
  routes t0 
  LEFT JOIN routes_article t1 ON t0.id = t1.id 
  LEFT JOIN routes_article_category t2 ON t0.id = t2.id 
  LEFT JOIN routes_page t3 ON t0.id = t3.id 
  LEFT JOIN routes_group_section t4 ON t0.id = t4.id 
  LEFT JOIN routes_product t5 ON t0.id = t5.id 
  LEFT JOIN routes_category t6 ON t0.id = t6.id 
WHERE 
  t0.path = ? 
  AND t0.site_id = ? 
LIMIT 
  1

SELECT t0.id AS id_7, t0.path AS path_8, t0.site_id AS site_id_9, t0.type, t1.foreign_id AS foreign_id_10, t2.foreign_id AS foreign_id_11, t3.foreign_id AS foreign_id_12, t4.foreign_id AS foreign_id_13, t5.foreign_id AS foreign_id_14, t6.foreign_id AS foreign_id_15 FROM routes t0 LEFT JOIN routes_article t1 ON t0.id = t1.id LEFT JOIN routes_article_category t2 ON t0.id = t2.id LEFT JOIN routes_page t3 ON t0.id = t3.id LEFT JOIN routes_group_section t4 ON t0.id = t4.id LEFT JOIN routes_product t5 ON t0.id = t5.id LEFT JOIN routes_category t6 ON t0.id = t6.id WHERE t0.path = 'Blog' AND t0.site_id = 'pl' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

1 Misses

1 Puts

Number of cache misses

Region	Misses
hitso_bundle_routingbundle_entity_route	1

Number of cache puts

Region	Puts
hitso_bundle_routingbundle_entity_route	1

Entities Mapping

Class	Mapping errors
Hitso\Bundle\RoutingBundle\Entity\Route	No errors.
Hitso\Bundle\ContentBundle\Entity\ArticleRoute	No errors.
Hitso\Bundle\ContentBundle\Entity\ArticleCategoryRoute	No errors.
Hitso\Bundle\ContentBundle\Entity\PageRoute	No errors.
Hitso\Bundle\SectionBundle\Entity\GroupRoute	No errors.
Hitso\Bundle\CatalogBundle\Entity\ProductRoute	No errors.
Hitso\Bundle\CatalogBundle\Entity\CategoryRoute	No errors.
Hitso\Bundle\ContentBundle\Entity\Article	No errors.
Hitso\Bundle\ContentBundle\Entity\ArticleCategory	No errors.
Hitso\Bundle\ContentBundle\Entity\Page	No errors.
Hitso\Bundle\SectionBundle\Entity\Group	No errors.
Hitso\Bundle\CatalogBundle\Entity\Product	The field Hitso\Bundle\CatalogBundle\Entity\Product#attachments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Juki\Bundle\AppBundle\Entity\ProductAttachment#product does not contain the required 'inversedBy="attachments"' attribute.
Hitso\Bundle\CatalogBundle\Entity\Category	No errors.
Hitso\Bundle\CommonBundle\Entity\ChangeLog	No errors.
Hitso\Bundle\FileManagerBundle\Entity\File	No errors.
Hitso\Bundle\CatalogBundle\Entity\ProductAttribute	No errors.
Hitso\Bundle\SeoBundle\Entity\SeoPage	No errors.

Symfony Profiler

https://api.stage.jukieurope.com/Blog

Configuration Settings

Theme

Page Width