Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

7.19 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.41 ms
(33.56%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.canonical_url AS canonical_url_6, t0.footer_text AS footer_text_7, t0.body AS body_8, t0.page_type AS page_type_9, t0.enabled AS enabled_10, t0.imitate_main AS imitate_main_11, t0.can_imitate_main AS can_imitate_main_12 FROM page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "shop"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.canonical_url AS canonical_url_6,
  t0.footer_text AS footer_text_7,
  t0.body AS body_8,
  t0.page_type AS page_type_9,
  t0.enabled AS enabled_10,
  t0.imitate_main AS imitate_main_11,
  t0.can_imitate_main AS can_imitate_main_12
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.canonical_url AS canonical_url_6, t0.footer_text AS footer_text_7, t0.body AS body_8, t0.page_type AS page_type_9, t0.enabled AS enabled_10, t0.imitate_main AS imitate_main_11, t0.can_imitate_main AS can_imitate_main_12 FROM page t0 WHERE t0.slug = 'shop' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 63)
4	App\Controller\SlugResolver->__invoke (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 18)

1.49 ms
(20.73%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.thumbnail_image AS thumbnail_image_4, t0.image_height AS image_height_5, t0.image_width AS image_width_6, t0.thumnail_image_height AS thumnail_image_height_7, t0.thumbnail_image_width AS thumbnail_image_width_8, t0.bonus AS bonus_9, t0.rating AS rating_10, t0.promo AS promo_11, t0.url AS url_12, t0.created_at AS created_at_13, t0.views AS views_14, t0.pluses AS pluses_15, t0.cons AS cons_16, t0.body AS body_17, t0._order AS _order_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.canonical_url AS canonical_url_21, t0.features AS features_22, t0.slug AS slug_23, t0.created_by_id AS created_by_id_24, t0.type_id AS type_id_25, t0.category_id AS category_id_26 FROM universal_entity t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "shop"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.thumbnail_image AS thumbnail_image_4,
  t0.image_height AS image_height_5,
  t0.image_width AS image_width_6,
  t0.thumnail_image_height AS thumnail_image_height_7,
  t0.thumbnail_image_width AS thumbnail_image_width_8,
  t0.bonus AS bonus_9,
  t0.rating AS rating_10,
  t0.promo AS promo_11,
  t0.url AS url_12,
  t0.created_at AS created_at_13,
  t0.views AS views_14,
  t0.pluses AS pluses_15,
  t0.cons AS cons_16,
  t0.body AS body_17,
  t0._order AS _order_18,
  t0.meta_title AS meta_title_19,
  t0.meta_description AS meta_description_20,
  t0.canonical_url AS canonical_url_21,
  t0.features AS features_22,
  t0.slug AS slug_23,
  t0.created_by_id AS created_by_id_24,
  t0.type_id AS type_id_25,
  t0.category_id AS category_id_26
FROM
  universal_entity t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.thumbnail_image AS thumbnail_image_4, t0.image_height AS image_height_5, t0.image_width AS image_width_6, t0.thumnail_image_height AS thumnail_image_height_7, t0.thumbnail_image_width AS thumbnail_image_width_8, t0.bonus AS bonus_9, t0.rating AS rating_10, t0.promo AS promo_11, t0.url AS url_12, t0.created_at AS created_at_13, t0.views AS views_14, t0.pluses AS pluses_15, t0.cons AS cons_16, t0.body AS body_17, t0._order AS _order_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.canonical_url AS canonical_url_21, t0.features AS features_22, t0.slug AS slug_23, t0.created_by_id AS created_by_id_24, t0.type_id AS type_id_25, t0.category_id AS category_id_26 FROM universal_entity t0 WHERE t0.slug = 'shop' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 120)
4	App\Controller\SlugResolver->__invoke (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 18)

1.42 ms
(19.75%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.canonical_url AS canonical_url_6 FROM universal_entity_type t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "shop"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.canonical_url AS canonical_url_6
FROM
  universal_entity_type t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.canonical_url AS canonical_url_6 FROM universal_entity_type t0 WHERE t0.slug = 'shop' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 133)
4	App\Controller\SlugResolver->__invoke (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 18)

1.22 ms
(16.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.image_height AS image_height_4, t0.image_width AS image_width_5, t0.short_description AS short_description_6, t0.youtube_url AS youtube_url_7, t0.twitch_url AS twitch_url_8, t0.bio AS bio_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.canonical_url AS canonical_url_12, t0._order AS _order_13, t0.slug AS slug_14, t0.sub_title AS sub_title_15, t0.text_block_title1 AS text_block_title1_16, t0.text_block1 AS text_block1_17, t0.text_block_title2 AS text_block_title2_18, t0.text_block2 AS text_block2_19, t0.text_bottom_title AS text_bottom_title_20, t0.text_bottom AS text_bottom_21, t0.country_id AS country_id_22, t0.language_id AS language_id_23, t0.discipline_id AS discipline_id_24, t0.favorite_casino_id AS favorite_casino_id_25 FROM streamer t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "shop"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.image_height AS image_height_4,
  t0.image_width AS image_width_5,
  t0.short_description AS short_description_6,
  t0.youtube_url AS youtube_url_7,
  t0.twitch_url AS twitch_url_8,
  t0.bio AS bio_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.canonical_url AS canonical_url_12,
  t0._order AS _order_13,
  t0.slug AS slug_14,
  t0.sub_title AS sub_title_15,
  t0.text_block_title1 AS text_block_title1_16,
  t0.text_block1 AS text_block1_17,
  t0.text_block_title2 AS text_block_title2_18,
  t0.text_block2 AS text_block2_19,
  t0.text_bottom_title AS text_bottom_title_20,
  t0.text_bottom AS text_bottom_21,
  t0.country_id AS country_id_22,
  t0.language_id AS language_id_23,
  t0.discipline_id AS discipline_id_24,
  t0.favorite_casino_id AS favorite_casino_id_25
FROM
  streamer t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.image_height AS image_height_4, t0.image_width AS image_width_5, t0.short_description AS short_description_6, t0.youtube_url AS youtube_url_7, t0.twitch_url AS twitch_url_8, t0.bio AS bio_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.canonical_url AS canonical_url_12, t0._order AS _order_13, t0.slug AS slug_14, t0.sub_title AS sub_title_15, t0.text_block_title1 AS text_block_title1_16, t0.text_block1 AS text_block1_17, t0.text_block_title2 AS text_block_title2_18, t0.text_block2 AS text_block2_19, t0.text_bottom_title AS text_bottom_title_20, t0.text_bottom AS text_bottom_21, t0.country_id AS country_id_22, t0.language_id AS language_id_23, t0.discipline_id AS discipline_id_24, t0.favorite_casino_id AS favorite_casino_id_25 FROM streamer t0 WHERE t0.slug = 'shop' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 108)
4	App\Controller\SlugResolver->__invoke (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 18)

0.65 ms
(9.03%)

SELECT t0.id AS id_1, t0.bio AS bio_2, t0.image AS image_3, t0.facebook_url AS facebook_url_4, t0.instagram_url AS instagram_url_5, t0.telegram_url AS telegram_url_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.canonical_url AS canonical_url_10, t0.created_at AS created_at_11, t0.short_bio AS short_bio_12, t0.displayed_email AS displayed_email_13, t0.linked_in_url AS linked_in_url_14, t0.name AS name_15, t0.ed_desc_full AS ed_desc_full_16, t0.ed_name AS ed_name_17, t0.ed_years AS ed_years_18, t0.ed_icon AS ed_icon_19, t0.langs AS langs_20, t0.work_name1 AS work_name1_21, t0.work_post1 AS work_post1_22, t0.work_years1 AS work_years1_23, t0.work_icon1 AS work_icon1_24, t0.work_name2 AS work_name2_25, t0.work_post2 AS work_post2_26, t0.work_years2 AS work_years2_27, t0.work_icon2 AS work_icon2_28, t0.work_name3 AS work_name3_29, t0.work_post3 AS work_post3_30, t0.work_years3 AS work_years3_31, t0.work_icon3 AS work_icon3_32, t0.work_name4 AS work_name4_33, t0.work_post4 AS work_post4_34, t0.work_years4 AS work_years4_35, t0.work_icon4 AS work_icon4_36, t0.user_id AS user_id_37, t0.tag_id AS tag_id_38 FROM author t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "shop"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.bio AS bio_2,
  t0.image AS image_3,
  t0.facebook_url AS facebook_url_4,
  t0.instagram_url AS instagram_url_5,
  t0.telegram_url AS telegram_url_6,
  t0.slug AS slug_7,
  t0.meta_title AS meta_title_8,
  t0.meta_description AS meta_description_9,
  t0.canonical_url AS canonical_url_10,
  t0.created_at AS created_at_11,
  t0.short_bio AS short_bio_12,
  t0.displayed_email AS displayed_email_13,
  t0.linked_in_url AS linked_in_url_14,
  t0.name AS name_15,
  t0.ed_desc_full AS ed_desc_full_16,
  t0.ed_name AS ed_name_17,
  t0.ed_years AS ed_years_18,
  t0.ed_icon AS ed_icon_19,
  t0.langs AS langs_20,
  t0.work_name1 AS work_name1_21,
  t0.work_post1 AS work_post1_22,
  t0.work_years1 AS work_years1_23,
  t0.work_icon1 AS work_icon1_24,
  t0.work_name2 AS work_name2_25,
  t0.work_post2 AS work_post2_26,
  t0.work_years2 AS work_years2_27,
  t0.work_icon2 AS work_icon2_28,
  t0.work_name3 AS work_name3_29,
  t0.work_post3 AS work_post3_30,
  t0.work_years3 AS work_years3_31,
  t0.work_icon3 AS work_icon3_32,
  t0.work_name4 AS work_name4_33,
  t0.work_post4 AS work_post4_34,
  t0.work_years4 AS work_years4_35,
  t0.work_icon4 AS work_icon4_36,
  t0.user_id AS user_id_37,
  t0.tag_id AS tag_id_38
FROM
  author t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.bio AS bio_2, t0.image AS image_3, t0.facebook_url AS facebook_url_4, t0.instagram_url AS instagram_url_5, t0.telegram_url AS telegram_url_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.canonical_url AS canonical_url_10, t0.created_at AS created_at_11, t0.short_bio AS short_bio_12, t0.displayed_email AS displayed_email_13, t0.linked_in_url AS linked_in_url_14, t0.name AS name_15, t0.ed_desc_full AS ed_desc_full_16, t0.ed_name AS ed_name_17, t0.ed_years AS ed_years_18, t0.ed_icon AS ed_icon_19, t0.langs AS langs_20, t0.work_name1 AS work_name1_21, t0.work_post1 AS work_post1_22, t0.work_years1 AS work_years1_23, t0.work_icon1 AS work_icon1_24, t0.work_name2 AS work_name2_25, t0.work_post2 AS work_post2_26, t0.work_years2 AS work_years2_27, t0.work_icon2 AS work_icon2_28, t0.work_name3 AS work_name3_29, t0.work_post3 AS work_post3_30, t0.work_years3 AS work_years3_31, t0.work_icon3 AS work_icon3_32, t0.work_name4 AS work_name4_33, t0.work_post4 AS work_post4_34, t0.work_years4 AS work_years4_35, t0.work_icon4 AS work_icon4_36, t0.user_id AS user_id_37, t0.tag_id AS tag_id_38 FROM author t0 WHERE t0.slug = 'shop' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 146)
4	App\Controller\SlugResolver->__invoke (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 18)

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
App\Entity\Page	No errors.
App\Entity\Streamer	No errors.
App\Entity\Country	No errors.
App\Entity\Language	No errors.
App\Entity\StreamerDescipline	No errors.
App\Entity\Casino	No errors.
App\Entity\UniversalEntity	No errors.
App\Entity\User	No errors.
App\Entity\UniversalEntityType	No errors.
App\Entity\UniversalEntityCategory	No errors.
App\Entity\Author	No errors.
App\Entity\AuthorTag	No errors.
App\Entity\PageBlockRelation	No errors.
App\Entity\PageSidebarBlockRelation	No errors.
App\Entity\FAQ	No errors.
App\Entity\StreamerTag	No errors.
App\Entity\Stream	No errors.
App\Entity\CashDisciplines	No errors.
App\Entity\StreamerLimits	No errors.
App\Entity\PokerRoom	No errors.
App\Entity\Betting	No errors.
App\Entity\PlayerProfile	No errors.
App\Entity\Podcast	No errors.
App\Entity\CasinoFilterValue	No errors.
App\Entity\Platform	No errors.
App\Entity\License	No errors.
App\Entity\Currency	No errors.
App\Entity\CasinoCategoryCasinoRelation	No errors.
App\Entity\Slot	No errors.
App\Entity\Game	No errors.
App\Entity\Provider	No errors.
App\Entity\Payment	No errors.
App\Entity\UniversalEntityRatingField	No errors.
App\Entity\UniversalEntityCustomField	No errors.
App\Entity\UniversalEntityFilterValue	No errors.
App\Entity\News	No errors.
App\Entity\Blog	No errors.
App\Entity\AuthorFilterValue	No errors.

Symfony Profiler

GET https://dev.bigtp.org/shop

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping