Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

6.72 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

site connection

Time▼	Count	Info
3.19 ms (47.51%)	1	SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = ? AND t0.main_alias = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1 Parameters: [`"www" "/api/online-order/vendor/stat/daily/141525" 1`] View formatted query View runnable query Explain query SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = ? AND t0.main_alias = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1 SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/api/online-order/vendor/stat/daily/141525' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;
0.43 ms (6.34%)	1	SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = ? ORDER BY t0.id DESC Parameters: [`"/api/online-order/vendor/stat/daily/141525"`] View formatted query View runnable query Explain query SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = ? ORDER BY t0.id DESC SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = '/api/online-order/vendor/stat/daily/141525' ORDER BY t0.id DESC;

Time▼

Count

Info

3.19 ms
(47.51%)

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = ? AND t0.main_alias = ? AND t0.active = ? ORDER BY t0.id DESC LIMIT 1

Parameters:

[
  "www"
  "/api/online-order/vendor/stat/daily/141525"
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.domain = ?
  AND t0.main_alias = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/api/online-order/vendor/stat/daily/141525' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

0.43 ms
(6.34%)

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = ? ORDER BY t0.id DESC

Parameters:

[
  "/api/online-order/vendor/stat/daily/141525"
]

View formatted query View runnable query Explain query

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.main_alias = ?
ORDER BY
  t0.id DESC

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = '/api/online-order/vendor/stat/daily/141525' ORDER BY t0.id DESC;

admin connection

Time▼	Count	Info
3.10 ms (46.14%)	1	SELECT ods.statistic_date, ods.visit_count, ods.codes_count FROM offer_daily_statistic ods WHERE (ods.offer_id = :offerId) AND (ods.statistic_date between :dateFrom and :dateTo) ORDER BY ods.statistic_date ASC Parameters: [`"offerId" => 141525 "dateFrom" => "2025-05-01 00:00:00" "dateTo" => "2025-05-08 23:59:59"`] View formatted query View runnable query Explain query SELECT ods.statistic_date, ods.visit_count, ods.codes_count FROM offer_daily_statistic ods WHERE (ods.offer_id = :offerId) AND ( ods.statistic_date between :dateFrom and :dateTo ) ORDER BY ods.statistic_date ASC SELECT ods.statistic_date, ods.visit_count, ods.codes_count FROM offer_daily_statistic ods WHERE (ods.offer_id = 141525) AND (ods.statistic_date between '2025-05-01 00:00:00' and '2025-05-08 23:59:59') ORDER BY ods.statistic_date ASC;

Time▼

Count

Info

3.10 ms
(46.14%)

SELECT ods.statistic_date, ods.visit_count, ods.codes_count FROM offer_daily_statistic ods WHERE (ods.offer_id = :offerId) AND (ods.statistic_date between :dateFrom and :dateTo) ORDER BY ods.statistic_date ASC

Parameters:

[
  "offerId" => 141525
  "dateFrom" => "2025-05-01 00:00:00"
  "dateTo" => "2025-05-08 23:59:59"
]

View formatted query View runnable query Explain query

SELECT
  ods.statistic_date,
  ods.visit_count,
  ods.codes_count
FROM
  offer_daily_statistic ods
WHERE
  (ods.offer_id = :offerId)
  AND (
    ods.statistic_date between :dateFrom
    and :dateTo
  )
ORDER BY
  ods.statistic_date ASC

SELECT ods.statistic_date, ods.visit_count, ods.codes_count FROM offer_daily_statistic ods WHERE (ods.offer_id = 141525) AND (ods.statistic_date between '2025-05-01 00:00:00' and '2025-05-08 23:59:59') ORDER BY ods.statistic_date ASC;

subscription connection

No database queries were performed.

default connection

No database queries were performed.

Database Connections

Name	Service
site	doctrine.dbal.site_connection
admin	doctrine.dbal.admin_connection
subscription	doctrine.dbal.subscription_connection
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
admin	doctrine.orm.admin_entity_manager
subscription	doctrine.orm.subscription_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
Slivki\Entity\City	No errors.
Slivki\Entity\PartnerMailingCampaignAction	No errors.
Slivki\Entity\Seo	No errors.
Slivki\Entity\Media\AbstractMediaBase	No errors.
Slivki\Entity\Media	No errors.
Slivki\Entity\Banner\AbstractBannerBase	No errors.
Slivki\Entity\Banner\AbstractMobileAppBanner	Entity class 'Slivki\Entity\Banner\AbstractMobileAppBanner' is part of inheritance hierarchy, but is not mapped in the root entity 'Slivki\Entity\Banner\AbstractBannerBase' discriminator map. All subclasses must be listed in the discriminator map.
Slivki\Entity\Banner	No errors.
Slivki\Entity\ServerFeatureState	No errors.

admin entity manager

No loaded entities.

subscription entity manager

No loaded entities.

Symfony Profiler

https://www.alexey.dev.slivki.by/api/online-order/vendor/stat/daily/141525?dateFrom=01.05.2025&dateTo=08.05.2025

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

site connection

admin connection

subscription connection

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

admin entity manager

subscription entity manager