Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

68 Database Queries

68 Different statements

123.47 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

56.15 ms
(45.48%)

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 133)
2	TheatreCore\Repository\ContactsRepository->queryAll (line 90)
3	App\Controller\EditionsController->action_view (line 163)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
6	Symfony\Component\HttpKernel\Kernel->handle (line 20)

49.59 ms
(40.16%)

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1) AND c.organisation REGEXP '^T'  ORDER BY c.organisation

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )
  AND c.organisation REGEXP '^T'
ORDER BY
  c.organisation

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1) AND c.organisation REGEXP '^T'  ORDER BY c.organisation;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 95)
2	TheatreCore\Repository\ContactsRepository->query (line 108)
3	App\Controller\EditionsController->action_view (line 163)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
6	Symfony\Component\HttpKernel\Kernel->handle (line 20)

2.01 ms
(1.62%)

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_bottom = 1
  AND date_start <= NOW()
  AND date_end >= NOW()
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 74)
2	TheatreCore\Repository\BannieresRepository->queryRow (line 597)
3	TheatreCore\Repository\BannieresRepository->getBottomBanniere (line 520)
4	App\ClassTheatre\TheatreController->common (line 166)
5	App\ClassTheatre\TheatreController->view (line 296)
6	App\Controller\EditionsController->action_view (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
9	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.69 ms
(0.56%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=8318

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 8318

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=8318;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.60 ms
(0.49%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.57 ms
(0.46%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=12204

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 12204

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=12204;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.51 ms
(0.41%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=16486

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 16486

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=16486;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.47 ms
(0.38%)

SELECT fr FROM countries WHERE id='US'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'US'

SELECT fr FROM countries WHERE id='US';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.45 ms
(0.37%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=5653

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 5653

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=5653;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.39 ms
(0.32%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2062

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2062

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2062;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.37 ms
(0.30%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1285

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1285

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1285;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.35 ms
(0.29%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=591

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 591

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=591;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.31 ms
(0.25%)

SELECT fr FROM countries WHERE id='PT'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'PT'

SELECT fr FROM countries WHERE id='PT';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.30 ms
(0.25%)

SELECT fr FROM countries WHERE id='GB'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'GB'

SELECT fr FROM countries WHERE id='GB';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.30 ms
(0.25%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17047

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17047

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17047;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.30 ms
(0.25%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=18089

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 18089

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=18089;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.29 ms
(0.23%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=8518

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 8518

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=8518;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.28 ms
(0.23%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=14564

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 14564

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=14564;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.28 ms
(0.23%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=109

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 109

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=109;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.28 ms
(0.23%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2294

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2294

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2294;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.28 ms
(0.22%)

SELECT fr FROM countries WHERE id='AT'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'AT'

SELECT fr FROM countries WHERE id='AT';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.27 ms
(0.22%)

SELECT fr FROM countries WHERE id='KR'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'KR'

SELECT fr FROM countries WHERE id='KR';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.27 ms
(0.22%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=34214

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 34214

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=34214;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.27 ms
(0.22%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=33

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 33

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=33;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.26 ms
(0.21%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28164

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 28164

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28164;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.25 ms
(0.20%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=48

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 48

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=48;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.25 ms
(0.20%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=4453

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 4453

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=4453;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.25 ms
(0.20%)

SELECT fr FROM countries WHERE id='CA'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'CA'

SELECT fr FROM countries WHERE id='CA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.24 ms
(0.20%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3743

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3743

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3743;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.24 ms
(0.19%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3617

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3617

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3617;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.22 ms
(0.18%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=26805

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 26805

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=26805;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.22 ms
(0.18%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2658

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2658

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2658;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.22 ms
(0.18%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=27340

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 27340

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=27340;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.22 ms
(0.18%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=31200

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 31200

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=31200;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.22 ms
(0.18%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1395

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1395

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1395;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.21 ms
(0.17%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1862

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1862

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1862;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.21 ms
(0.17%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=108

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 108

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=108;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.20 ms
(0.16%)

SELECT fr FROM countries WHERE id='CN'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'CN'

SELECT fr FROM countries WHERE id='CN';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.20 ms
(0.16%)

SELECT fr FROM countries WHERE id='IE'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'IE'

SELECT fr FROM countries WHERE id='IE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.20 ms
(0.16%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=411

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 411

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=411;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.20 ms
(0.16%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17863

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17863

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17863;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.19 ms
(0.16%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28906

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 28906

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28906;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.19 ms
(0.15%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6723

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6723

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6723;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.19 ms
(0.15%)

SELECT fr FROM countries WHERE id='TW'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'TW'

SELECT fr FROM countries WHERE id='TW';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.18 ms
(0.15%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3897

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3897

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3897;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.18 ms
(0.15%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3243

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3243

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3243;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.18 ms
(0.15%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=82

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 82

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=82;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.18 ms
(0.14%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6102

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6102

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6102;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.17 ms
(0.14%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6283

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6283

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6283;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.17 ms
(0.14%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2822

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2822

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2822;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.17 ms
(0.14%)

SELECT fr FROM countries WHERE id='MX'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'MX'

SELECT fr FROM countries WHERE id='MX';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.16 ms
(0.13%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=10512

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 10512

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=10512;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.16 ms
(0.13%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=26811

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 26811

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=26811;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.16 ms
(0.13%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2413

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2413

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2413;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.16 ms
(0.13%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20916

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 20916

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20916;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.16 ms
(0.13%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1764

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1764

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1764;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.15 ms
(0.12%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=144

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 144

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=144;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.15 ms
(0.12%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=140

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 140

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=140;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.15 ms
(0.12%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=7707

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 7707

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=7707;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.15 ms
(0.12%)

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=81

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 81

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=81;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 664)
4	TheatreCore\Repository\ContactsRepository->countObjects (line 112)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.15 ms
(0.12%)

SELECT fr FROM countries WHERE id='NL'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'NL'

SELECT fr FROM countries WHERE id='NL';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.14 ms
(0.11%)

SELECT fr FROM countries WHERE id='UY'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'UY'

SELECT fr FROM countries WHERE id='UY';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.13 ms
(0.11%)

SELECT fr FROM countries WHERE id='GP'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'GP'

SELECT fr FROM countries WHERE id='GP';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.11 ms
(0.09%)

SELECT fr FROM countries WHERE id='TR'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'TR'

SELECT fr FROM countries WHERE id='TR';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.11 ms
(0.09%)

SELECT fr FROM countries WHERE id='ES'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'ES'

SELECT fr FROM countries WHERE id='ES';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.11 ms
(0.09%)

SELECT fr FROM countries WHERE id='DE'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'DE'

SELECT fr FROM countries WHERE id='DE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.06 ms
(0.05%)

SELECT fr FROM countries WHERE id='IT'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'IT'

SELECT fr FROM countries WHERE id='IT';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.05 ms
(0.04%)

SELECT fr FROM countries WHERE id='FR'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 59)
3	TheatreCore\Repository\ContactsRepository->queryOne (line 1669)
4	TheatreCore\Repository\ContactsRepository->getNameCountry (line 116)
5	App\Controller\EditionsController->action_view (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 75)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 202)
8	Symfony\Component\HttpKernel\Kernel->handle (line 20)

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
TheatreCore\Entity\Extranetusers	No errors.
TheatreCore\Entity\Spectacles	No errors.
TheatreCore\Entity\Contacts	No errors.
TheatreCore\Entity\Bannieres	No errors.

Symfony Profiler

https://preprod.theatre-contemporain.net/editions?lettre=t&path=editions

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping