Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.30 ms Query time

0 Invalid entities

76 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.08 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.type AS type_4, a0_.latitude AS latitude_5, a0_.longitude AS longitude_6, a0_.street AS street_7, a0_.city AS city_8, a0_.postcode AS postcode_9, a0_.country AS country_10, a0_.google_place_id AS google_place_id_11, a0_.url AS url_12, a0_.phone_number AS phone_number_13, a0_.rating AS rating_14, a0_.reviews_count AS reviews_count_15, a0_.image AS image_16, a0_.order_id AS order_id_17, a0_.start_date AS start_date_18, a0_.start_time AS start_time_19, a0_.end_date AS end_date_20, a0_.end_time AS end_time_21, a0_.repeat_rule AS repeat_rule_22, a0_.google_place_data AS google_place_data_23, a0_.created_at AS created_at_24, a0_.updated_at AS updated_at_25, a0_.category_id AS category_id_26, a0_.user_id AS user_id_27 FROM activity a0_ ORDER BY a0_.order_id ASC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.description AS description_3,
  a0_.type AS type_4,
  a0_.latitude AS latitude_5,
  a0_.longitude AS longitude_6,
  a0_.street AS street_7,
  a0_.city AS city_8,
  a0_.postcode AS postcode_9,
  a0_.country AS country_10,
  a0_.google_place_id AS google_place_id_11,
  a0_.url AS url_12,
  a0_.phone_number AS phone_number_13,
  a0_.rating AS rating_14,
  a0_.reviews_count AS reviews_count_15,
  a0_.image AS image_16,
  a0_.order_id AS order_id_17,
  a0_.start_date AS start_date_18,
  a0_.start_time AS start_time_19,
  a0_.end_date AS end_date_20,
  a0_.end_time AS end_time_21,
  a0_.repeat_rule AS repeat_rule_22,
  a0_.google_place_data AS google_place_data_23,
  a0_.created_at AS created_at_24,
  a0_.updated_at AS updated_at_25,
  a0_.category_id AS category_id_26,
  a0_.user_id AS user_id_27
FROM
  activity a0_
ORDER BY
  a0_.order_id ASC
LIMIT
  20

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.type AS type_4, a0_.latitude AS latitude_5, a0_.longitude AS longitude_6, a0_.street AS street_7, a0_.city AS city_8, a0_.postcode AS postcode_9, a0_.country AS country_10, a0_.google_place_id AS google_place_id_11, a0_.url AS url_12, a0_.phone_number AS phone_number_13, a0_.rating AS rating_14, a0_.reviews_count AS reviews_count_15, a0_.image AS image_16, a0_.order_id AS order_id_17, a0_.start_date AS start_date_18, a0_.start_time AS start_time_19, a0_.end_date AS end_date_20, a0_.end_time AS end_time_21, a0_.repeat_rule AS repeat_rule_22, a0_.google_place_data AS google_place_data_23, a0_.created_at AS created_at_24, a0_.updated_at AS updated_at_25, a0_.category_id AS category_id_26, a0_.user_id AS user_id_27 FROM activity a0_ ORDER BY a0_.order_id ASC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActivityRepository->findByFilter (line 32)
7	App\Service\ActivityFilterProvider->getActivitiesByFilter (line 54)
8	App\Service\ActivityFilterProvider->getHomepageActivities (line 21)
9	App\Controller\PageController->homepageAction (line 24)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

2.22 ms

SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.activity_count AS activity_count_2, c0_.name_de AS name_de_3, c0_.name_en AS name_en_4, c0_.name_tr AS name_tr_5, c0_.name_ru AS name_ru_6, c0_.name_uk AS name_uk_7, c0_.slug AS slug_8, c0_.google_types AS google_types_9, c0_.enabled AS enabled_10, c0_.order_id AS order_id_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.icon AS icon_15, c1_.activity_count AS activity_count_16, c1_.name_de AS name_de_17, c1_.name_en AS name_en_18, c1_.name_tr AS name_tr_19, c1_.name_ru AS name_ru_20, c1_.name_uk AS name_uk_21, c1_.slug AS slug_22, c1_.google_types AS google_types_23, c1_.enabled AS enabled_24, c1_.order_id AS order_id_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c0_.parent_id AS parent_id_28, c0_.user_id AS user_id_29, c1_.parent_id AS parent_id_30, c1_.user_id AS user_id_31 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.enabled = 1 AND (c1_.enabled = 1 OR c1_.id IS NULL) ORDER BY c0_.order_id ASC, c1_.order_id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.icon AS icon_1,
  c0_.activity_count AS activity_count_2,
  c0_.name_de AS name_de_3,
  c0_.name_en AS name_en_4,
  c0_.name_tr AS name_tr_5,
  c0_.name_ru AS name_ru_6,
  c0_.name_uk AS name_uk_7,
  c0_.slug AS slug_8,
  c0_.google_types AS google_types_9,
  c0_.enabled AS enabled_10,
  c0_.order_id AS order_id_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13,
  c1_.id AS id_14,
  c1_.icon AS icon_15,
  c1_.activity_count AS activity_count_16,
  c1_.name_de AS name_de_17,
  c1_.name_en AS name_en_18,
  c1_.name_tr AS name_tr_19,
  c1_.name_ru AS name_ru_20,
  c1_.name_uk AS name_uk_21,
  c1_.slug AS slug_22,
  c1_.google_types AS google_types_23,
  c1_.enabled AS enabled_24,
  c1_.order_id AS order_id_25,
  c1_.created_at AS created_at_26,
  c1_.updated_at AS updated_at_27,
  c0_.parent_id AS parent_id_28,
  c0_.user_id AS user_id_29,
  c1_.parent_id AS parent_id_30,
  c1_.user_id AS user_id_31
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.enabled = 1
  AND (
    c1_.enabled = 1
    OR c1_.id IS NULL
  )
ORDER BY
  c0_.order_id ASC,
  c1_.order_id ASC

SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.activity_count AS activity_count_2, c0_.name_de AS name_de_3, c0_.name_en AS name_en_4, c0_.name_tr AS name_tr_5, c0_.name_ru AS name_ru_6, c0_.name_uk AS name_uk_7, c0_.slug AS slug_8, c0_.google_types AS google_types_9, c0_.enabled AS enabled_10, c0_.order_id AS order_id_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.icon AS icon_15, c1_.activity_count AS activity_count_16, c1_.name_de AS name_de_17, c1_.name_en AS name_en_18, c1_.name_tr AS name_tr_19, c1_.name_ru AS name_ru_20, c1_.name_uk AS name_uk_21, c1_.slug AS slug_22, c1_.google_types AS google_types_23, c1_.enabled AS enabled_24, c1_.order_id AS order_id_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c0_.parent_id AS parent_id_28, c0_.user_id AS user_id_29, c1_.parent_id AS parent_id_30, c1_.user_id AS user_id_31 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.enabled = 1 AND (c1_.enabled = 1 OR c1_.id IS NULL) ORDER BY c0_.order_id ASC, c1_.order_id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findRootCategories (line 92)
7	App\Controller\PageController->homepageAction (line 38)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Category	60
App\Entity\Activity	15
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Activity	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://kinderhobby.com/

Configuration Settings

Theme

Page Width