Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.97 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼	Count	Info
1.26 ms (63.71%)	1	SELECT id, url, auth_token FROM credential_settings WHERE type = :type AND (DATE(limit_date) < NOW() OR limit_date IS NULL) ORDER BY RAND() LIMIT 1; Parameters: [`"type" => "surveymonkey_proxy"`] View formatted query View runnable query Explain query SELECT id, url, auth_token FROM credential_settings WHERE type = :type AND ( DATE(limit_date) < NOW() OR limit_date IS NULL ) ORDER BY RAND() LIMIT 1; SELECT id, url, auth_token FROM credential_settings WHERE type = 'surveymonkey_proxy' AND (DATE(limit_date) < NOW() OR limit_date IS NULL) ORDER BY RAND() LIMIT 1;;
0.72 ms (36.29%)	1	SELECT count(id) as cnt FROM credential_settings WHERE type = :type AND limit_date < NOW() Parameters: [`"type" => "surveymonkey_proxy"`] View formatted query View runnable query Explain query SELECT count(id) as cnt FROM credential_settings WHERE type = :type AND limit_date < NOW() SELECT count(id) as cnt FROM credential_settings WHERE type = 'surveymonkey_proxy' AND limit_date < NOW();

Time▼

Count

Info

1.26 ms
(63.71%)

SELECT id, url, auth_token FROM credential_settings
    WHERE type = :type AND (DATE(limit_date) < NOW() OR limit_date IS NULL)
    ORDER BY RAND() LIMIT 1;

Parameters:

[
  "type" => "surveymonkey_proxy"
]

View formatted query View runnable query Explain query

SELECT
  id,
  url,
  auth_token
FROM
  credential_settings
WHERE
  type = :type
  AND (
    DATE(limit_date) < NOW()
    OR limit_date IS NULL
  )
ORDER BY
  RAND()
LIMIT
  1;

SELECT id, url, auth_token FROM credential_settings
    WHERE type = 'surveymonkey_proxy' AND (DATE(limit_date) < NOW() OR limit_date IS NULL)
    ORDER BY RAND() LIMIT 1;;

0.72 ms
(36.29%)

SELECT count(id) as cnt FROM credential_settings WHERE type = :type AND limit_date < NOW()

Parameters:

[
  "type" => "surveymonkey_proxy"
]

View formatted query View runnable query Explain query

SELECT
  count(id) as cnt
FROM
  credential_settings
WHERE
  type = :type
  AND limit_date < NOW()

SELECT count(id) as cnt FROM credential_settings WHERE type = 'surveymonkey_proxy' AND limit_date < NOW();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

Class	Mapping errors
CodersLab\Lms\Modules\Materials\Domain\Quiz	No errors.
CodersLab\Lms\Modules\Materials\Domain\Pill\Material	No errors.
CodersLab\Lms\Modules\Materials\Domain\Pill\Version	No errors.
CodersLab\Lms\Modules\Materials\Domain\Pill\Review	No errors.
CodersLab\Lms\Modules\Materials\Domain\Pill\MaterialCriterion	No errors.
CodersLab\Lms\Modules\Materials\Domain\Pill\Tag	No errors.

Symfony Profiler

https://dev-lms.coderslab.pl/webhooks/quiz/result/411504148

Configuration Settings

Theme