Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.79 ms Query time

3 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.79 ms	SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1 Parameters: [`"/station-marksistskaya"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1 SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = '/station-marksistskaya' LIMIT 1;

#▲

Time

Info

0.79 ms

SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = ? LIMIT 1

Parameters:

[
  "/station-marksistskaya"
]

View formatted query View runnable query Explain query

SELECT
  p0_.id AS id_0,
  p0_.uri AS uri_1,
  p0_.top_html AS top_html_2,
  p0_.bottom_html AS bottom_html_3,
  p0_.meta_title AS meta_title_4,
  p0_.meta_description AS meta_description_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.page_heading AS page_heading_7,
  p0_.city_id AS city_id_8
FROM
  page_seo_texts p0_
WHERE
  p0_.uri = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = '/station-marksistskaya' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
multi_website	doctrine.dbal.multi_website_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
multi_website	doctrine.orm.multi_website_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Sales\Profile\AdBoardPlacement	No errors.
App\Entity\Sales\PaidPlacementPrice	The field 'App\Entity\Sales\PaidPlacementPrice#priceAmount' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\SEO\PageMetadata	No errors.
App\Entity\Location\MapCoordinate	The field 'App\Entity\Location\MapCoordinate#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Location\MapCoordinate#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Location\City	The field 'App\Entity\Location\City#mapCoordinate.latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Location\City#mapCoordinate.longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Sales\PaidPlacementsOrder	No errors.

multi_website entity manager

No loaded entities.