Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

61.99 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

55.32 ms
(89.24%)

SELECT tag, COUNT(*) as tag_count
                FROM (
                    SELECT DISTINCT json_array_elements_text(tags) as tag
                    FROM user_request 
                    WHERE is_public = true 
                    AND status IN (:pending, :in_progress)
                    AND tags IS NOT NULL
                ) as tags_table
                GROUP BY tag
                ORDER BY tag_count DESC
                LIMIT :limit

Parameters:

[
  "pending" => 1
  "in_progress" => 2
  "limit" => 20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  tag,
  COUNT(*) as tag_count
FROM
  (
    SELECT
      DISTINCT json_array_elements_text(tags) as tag
    FROM
      user_request
    WHERE
      is_public = true
      AND status IN (:pending, :in_progress)
      AND tags IS NOT NULL
  ) as tags_table
GROUP BY
  tag
ORDER BY
  tag_count DESC
LIMIT
  :limit

SELECT tag, COUNT(*) as tag_count
                FROM (
                    SELECT DISTINCT json_array_elements_text(tags) as tag
                    FROM user_request 
                    WHERE is_public = true 
                    AND status IN (1, 2)
                    AND tags IS NOT NULL
                ) as tags_table
                GROUP BY tag
                ORDER BY tag_count DESC
                LIMIT 20
            ;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Statement->execute (line 190)
3	Doctrine\DBAL\Statement->executeQuery (line 224)
4	App\Repository\UserRequestRepository->getPopularTags (line 247)
5	App\Controller\UserRequestController->index (line 84)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

5.43 ms
(8.76%)

SELECT u0_.id AS id_0, u0_.unique_id AS unique_id_1, u0_.title AS title_2, u0_.description AS description_3, u0_.type AS type_4, u0_.category AS category_5, u0_.tags AS tags_6, u0_.budget AS budget_7, u0_.currency AS currency_8, u0_.priority AS priority_9, u0_.status AS status_10, u0_.location AS location_11, u0_.city AS city_12, u0_.country AS country_13, u0_.is_public AS is_public_14, u0_.allow_remote_work AS allow_remote_work_15, u0_.deadline AS deadline_16, u0_.created_at AS created_at_17, u0_.updated_at AS updated_at_18, u0_.attachments AS attachments_19, u0_.notes AS notes_20, u0_.ai_questions AS ai_questions_21, u0_.ai_answers AS ai_answers_22, u0_.suggested_categories AS suggested_categories_23, u0_.suggested_tags AS suggested_tags_24, u0_.view_count AS view_count_25, u0_.is_ai_processed AS is_ai_processed_26, u0_.company_code AS company_code_27, u0_.hide_company_code AS hide_company_code_28, u0_.valid_until AS valid_until_29, u0_.include_vat AS include_vat_30, u0_.allow_partial_bids AS allow_partial_bids_31, u0_.user_id AS user_id_32, u0_.company_id AS company_id_33 FROM user_request u0_ WHERE u0_.is_public = ? AND u0_.status IN (?, ?) ORDER BY u0_.created_at DESC LIMIT 20

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.unique_id AS unique_id_1,
  u0_.title AS title_2,
  u0_.description AS description_3,
  u0_.type AS type_4,
  u0_.category AS category_5,
  u0_.tags AS tags_6,
  u0_.budget AS budget_7,
  u0_.currency AS currency_8,
  u0_.priority AS priority_9,
  u0_.status AS status_10,
  u0_.location AS location_11,
  u0_.city AS city_12,
  u0_.country AS country_13,
  u0_.is_public AS is_public_14,
  u0_.allow_remote_work AS allow_remote_work_15,
  u0_.deadline AS deadline_16,
  u0_.created_at AS created_at_17,
  u0_.updated_at AS updated_at_18,
  u0_.attachments AS attachments_19,
  u0_.notes AS notes_20,
  u0_.ai_questions AS ai_questions_21,
  u0_.ai_answers AS ai_answers_22,
  u0_.suggested_categories AS suggested_categories_23,
  u0_.suggested_tags AS suggested_tags_24,
  u0_.view_count AS view_count_25,
  u0_.is_ai_processed AS is_ai_processed_26,
  u0_.company_code AS company_code_27,
  u0_.hide_company_code AS hide_company_code_28,
  u0_.valid_until AS valid_until_29,
  u0_.include_vat AS include_vat_30,
  u0_.allow_partial_bids AS allow_partial_bids_31,
  u0_.user_id AS user_id_32,
  u0_.company_id AS company_id_33
FROM
  user_request u0_
WHERE
  u0_.is_public = ?
  AND u0_.status IN (?, ?)
ORDER BY
  u0_.created_at DESC
LIMIT
  20

SELECT u0_.id AS id_0, u0_.unique_id AS unique_id_1, u0_.title AS title_2, u0_.description AS description_3, u0_.type AS type_4, u0_.category AS category_5, u0_.tags AS tags_6, u0_.budget AS budget_7, u0_.currency AS currency_8, u0_.priority AS priority_9, u0_.status AS status_10, u0_.location AS location_11, u0_.city AS city_12, u0_.country AS country_13, u0_.is_public AS is_public_14, u0_.allow_remote_work AS allow_remote_work_15, u0_.deadline AS deadline_16, u0_.created_at AS created_at_17, u0_.updated_at AS updated_at_18, u0_.attachments AS attachments_19, u0_.notes AS notes_20, u0_.ai_questions AS ai_questions_21, u0_.ai_answers AS ai_answers_22, u0_.suggested_categories AS suggested_categories_23, u0_.suggested_tags AS suggested_tags_24, u0_.view_count AS view_count_25, u0_.is_ai_processed AS is_ai_processed_26, u0_.company_code AS company_code_27, u0_.hide_company_code AS hide_company_code_28, u0_.valid_until AS valid_until_29, u0_.include_vat AS include_vat_30, u0_.allow_partial_bids AS allow_partial_bids_31, u0_.user_id AS user_id_32, u0_.company_id AS company_id_33 FROM user_request u0_ WHERE u0_.is_public = 1 AND u0_.status IN (1, 2) ORDER BY u0_.created_at DESC LIMIT 20;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\UserRequestRepository->findPublicRequests (line 55)
9	App\Controller\UserRequestController->index (line 76)
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)

0.81 ms
(1.31%)

SELECT u0_.category AS category_0, COUNT(u0_.id) AS sclr_1 FROM user_request u0_ WHERE u0_.is_public = ? AND u0_.status IN (?, ?) AND u0_.category IS NOT NULL GROUP BY u0_.category ORDER BY sclr_1 DESC LIMIT 10

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.category AS category_0,
  COUNT(u0_.id) AS sclr_1
FROM
  user_request u0_
WHERE
  u0_.is_public = ?
  AND u0_.status IN (?, ?)
  AND u0_.category IS NOT NULL
GROUP BY
  u0_.category
ORDER BY
  sclr_1 DESC
LIMIT
  10

SELECT u0_.category AS category_0, COUNT(u0_.id) AS sclr_1 FROM user_request u0_ WHERE u0_.is_public = 1 AND u0_.status IN (1, 2) AND u0_.category IS NOT NULL GROUP BY u0_.category ORDER BY sclr_1 DESC LIMIT 10;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	App\Repository\UserRequestRepository->getPopularCategories (line 216)
9	App\Controller\UserRequestController->index (line 83)
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)

0.43 ms
(0.70%)

SELECT COUNT(u0_.id) AS sclr_0 FROM user_request u0_ WHERE u0_.is_public = ? AND u0_.status IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user_request u0_
WHERE
  u0_.is_public = ?
  AND u0_.status IN (?, ?)

SELECT COUNT(u0_.id) AS sclr_0 FROM user_request u0_ WHERE u0_.is_public = 1 AND u0_.status IN (1, 2);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 44)
2	Doctrine\DBAL\Connection->executeQuery (line 1104)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
9	App\Repository\UserRequestRepository->countPublicRequests (line 72)
10	App\Controller\UserRequestController->index (line 77)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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

Entities Mapping

Class	Mapping errors
App\Entity\UserRequest	No errors.
App\Entity\User	No errors.
App\Entity\Company	No errors.

Symfony Profiler

GET http://78.56.202.79/request/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping