Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.32 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.32 ms

SELECT t0_.id AS id_0, t0_.betname AS betname_1, t0_.platform AS platform_2, t0_.name1 AS name1_3, t0_.name2 AS name2_4, t0_.player1_odds60 AS player1_odds60_5, t0_.player1_odds61 AS player1_odds61_6, t0_.player1_odds62 AS player1_odds62_7, t0_.player1_odds63 AS player1_odds63_8, t0_.player1_odds64 AS player1_odds64_9, t0_.player1_odds75 AS player1_odds75_10, t0_.player1_odds76 AS player1_odds76_11, t0_.player2_odds60 AS player2_odds60_12, t0_.player2_odds61 AS player2_odds61_13, t0_.player2_odds62 AS player2_odds62_14, t0_.player2_odds63 AS player2_odds63_15, t0_.player2_odds64 AS player2_odds64_16, t0_.player2_odds75 AS player2_odds75_17, t0_.player2_odds76 AS player2_odds76_18, t0_.player1_lay60 AS player1_lay60_19, t0_.player1_lay61 AS player1_lay61_20, t0_.player1_lay62 AS player1_lay62_21, t0_.player1_lay63 AS player1_lay63_22, t0_.player1_lay64 AS player1_lay64_23, t0_.player1_lay75 AS player1_lay75_24, t0_.player1_lay76 AS player1_lay76_25, t0_.player2_lay60 AS player2_lay60_26, t0_.player2_lay61 AS player2_lay61_27, t0_.player2_lay62 AS player2_lay62_28, t0_.player2_lay63 AS player2_lay63_29, t0_.player2_lay64 AS player2_lay64_30, t0_.player2_lay75 AS player2_lay75_31, t0_.player2_lay76 AS player2_lay76_32, t0_.date AS date_33 FROM tennis_set1_score t0_ WHERE ((t0_.player1_lay60 > 0 AND t0_.player1_lay60 < 300) OR (t0_.player1_lay61 > 0 AND t0_.player1_lay61 < 300) OR (t0_.player1_lay62 > 0 AND t0_.player1_lay62 < 300) OR (t0_.player1_lay63 > 0 AND t0_.player1_lay63 < 300) OR (t0_.player1_lay64 > 0 AND t0_.player1_lay64 < 300) OR (t0_.player1_lay75 > 0 AND t0_.player1_lay75 < 300) OR (t0_.player1_lay76 > 0 AND t0_.player1_lay76 < 300) OR (t0_.player2_lay60 > 0 AND t0_.player2_lay60 < 300) OR (t0_.player2_lay61 > 0 AND t0_.player2_lay61 < 300) OR (t0_.player2_lay62 > 0 AND t0_.player2_lay62 < 300) OR (t0_.player2_lay63 > 0 AND t0_.player2_lay63 < 300) OR (t0_.player2_lay64 > 0 AND t0_.player2_lay64 < 300) OR (t0_.player2_lay75 > 0 AND t0_.player2_lay75 < 300) OR (t0_.player2_lay76 > 0 AND t0_.player2_lay76 < 300)) AND t0_.platform = ? GROUP BY t0_.name1 ORDER BY t0_.name1 ASC

Parameters:

[
  "orbitx"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.betname AS betname_1,
  t0_.platform AS platform_2,
  t0_.name1 AS name1_3,
  t0_.name2 AS name2_4,
  t0_.player1_odds60 AS player1_odds60_5,
  t0_.player1_odds61 AS player1_odds61_6,
  t0_.player1_odds62 AS player1_odds62_7,
  t0_.player1_odds63 AS player1_odds63_8,
  t0_.player1_odds64 AS player1_odds64_9,
  t0_.player1_odds75 AS player1_odds75_10,
  t0_.player1_odds76 AS player1_odds76_11,
  t0_.player2_odds60 AS player2_odds60_12,
  t0_.player2_odds61 AS player2_odds61_13,
  t0_.player2_odds62 AS player2_odds62_14,
  t0_.player2_odds63 AS player2_odds63_15,
  t0_.player2_odds64 AS player2_odds64_16,
  t0_.player2_odds75 AS player2_odds75_17,
  t0_.player2_odds76 AS player2_odds76_18,
  t0_.player1_lay60 AS player1_lay60_19,
  t0_.player1_lay61 AS player1_lay61_20,
  t0_.player1_lay62 AS player1_lay62_21,
  t0_.player1_lay63 AS player1_lay63_22,
  t0_.player1_lay64 AS player1_lay64_23,
  t0_.player1_lay75 AS player1_lay75_24,
  t0_.player1_lay76 AS player1_lay76_25,
  t0_.player2_lay60 AS player2_lay60_26,
  t0_.player2_lay61 AS player2_lay61_27,
  t0_.player2_lay62 AS player2_lay62_28,
  t0_.player2_lay63 AS player2_lay63_29,
  t0_.player2_lay64 AS player2_lay64_30,
  t0_.player2_lay75 AS player2_lay75_31,
  t0_.player2_lay76 AS player2_lay76_32,
  t0_.date AS date_33
FROM
  tennis_set1_score t0_
WHERE
  (
    (
      t0_.player1_lay60 > 0
      AND t0_.player1_lay60 < 300
    )
    OR (
      t0_.player1_lay61 > 0
      AND t0_.player1_lay61 < 300
    )
    OR (
      t0_.player1_lay62 > 0
      AND t0_.player1_lay62 < 300
    )
    OR (
      t0_.player1_lay63 > 0
      AND t0_.player1_lay63 < 300
    )
    OR (
      t0_.player1_lay64 > 0
      AND t0_.player1_lay64 < 300
    )
    OR (
      t0_.player1_lay75 > 0
      AND t0_.player1_lay75 < 300
    )
    OR (
      t0_.player1_lay76 > 0
      AND t0_.player1_lay76 < 300
    )
    OR (
      t0_.player2_lay60 > 0
      AND t0_.player2_lay60 < 300
    )
    OR (
      t0_.player2_lay61 > 0
      AND t0_.player2_lay61 < 300
    )
    OR (
      t0_.player2_lay62 > 0
      AND t0_.player2_lay62 < 300
    )
    OR (
      t0_.player2_lay63 > 0
      AND t0_.player2_lay63 < 300
    )
    OR (
      t0_.player2_lay64 > 0
      AND t0_.player2_lay64 < 300
    )
    OR (
      t0_.player2_lay75 > 0
      AND t0_.player2_lay75 < 300
    )
    OR (
      t0_.player2_lay76 > 0
      AND t0_.player2_lay76 < 300
    )
  )
  AND t0_.platform = ?
GROUP BY
  t0_.name1
ORDER BY
  t0_.name1 ASC

SELECT t0_.id AS id_0, t0_.betname AS betname_1, t0_.platform AS platform_2, t0_.name1 AS name1_3, t0_.name2 AS name2_4, t0_.player1_odds60 AS player1_odds60_5, t0_.player1_odds61 AS player1_odds61_6, t0_.player1_odds62 AS player1_odds62_7, t0_.player1_odds63 AS player1_odds63_8, t0_.player1_odds64 AS player1_odds64_9, t0_.player1_odds75 AS player1_odds75_10, t0_.player1_odds76 AS player1_odds76_11, t0_.player2_odds60 AS player2_odds60_12, t0_.player2_odds61 AS player2_odds61_13, t0_.player2_odds62 AS player2_odds62_14, t0_.player2_odds63 AS player2_odds63_15, t0_.player2_odds64 AS player2_odds64_16, t0_.player2_odds75 AS player2_odds75_17, t0_.player2_odds76 AS player2_odds76_18, t0_.player1_lay60 AS player1_lay60_19, t0_.player1_lay61 AS player1_lay61_20, t0_.player1_lay62 AS player1_lay62_21, t0_.player1_lay63 AS player1_lay63_22, t0_.player1_lay64 AS player1_lay64_23, t0_.player1_lay75 AS player1_lay75_24, t0_.player1_lay76 AS player1_lay76_25, t0_.player2_lay60 AS player2_lay60_26, t0_.player2_lay61 AS player2_lay61_27, t0_.player2_lay62 AS player2_lay62_28, t0_.player2_lay63 AS player2_lay63_29, t0_.player2_lay64 AS player2_lay64_30, t0_.player2_lay75 AS player2_lay75_31, t0_.player2_lay76 AS player2_lay76_32, t0_.date AS date_33 FROM tennis_set1_score t0_ WHERE ((t0_.player1_lay60 > 0 AND t0_.player1_lay60 < 300) OR (t0_.player1_lay61 > 0 AND t0_.player1_lay61 < 300) OR (t0_.player1_lay62 > 0 AND t0_.player1_lay62 < 300) OR (t0_.player1_lay63 > 0 AND t0_.player1_lay63 < 300) OR (t0_.player1_lay64 > 0 AND t0_.player1_lay64 < 300) OR (t0_.player1_lay75 > 0 AND t0_.player1_lay75 < 300) OR (t0_.player1_lay76 > 0 AND t0_.player1_lay76 < 300) OR (t0_.player2_lay60 > 0 AND t0_.player2_lay60 < 300) OR (t0_.player2_lay61 > 0 AND t0_.player2_lay61 < 300) OR (t0_.player2_lay62 > 0 AND t0_.player2_lay62 < 300) OR (t0_.player2_lay63 > 0 AND t0_.player2_lay63 < 300) OR (t0_.player2_lay64 > 0 AND t0_.player2_lay64 < 300) OR (t0_.player2_lay75 > 0 AND t0_.player2_lay75 < 300) OR (t0_.player2_lay76 > 0 AND t0_.player2_lay76 < 300)) AND t0_.platform = 'orbitx' GROUP BY t0_.name1 ORDER BY t0_.name1 ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 53)
7	App\Repository\TennisSet1ScoreRepository->findTennisMatches (line 496)
8	App\Controller\HomeController->tennis (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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

Entities Mapping

Class	Mapping errors
App\Entity\TennisSet1Score	No errors.

Symfony Profiler

GET https://osd2.orbix.fr/tennis

Configuration Settings

Theme

Page Width