GET https://onodprd01.optindata.fr/

Query Metrics

10 Database Queries
7 Different statements
1.70 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.56 ms
(33.27%)
2
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.description AS description_3 FROM system_setting s0_ WHERE s0_.name = ?
Parameters:
[
  "api.gocad.username"
]
0.25 ms
(14.79%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.page AS page_4, t0.title AS title_5, t0.text AS text_6, t0.active AS active_7, t0.local AS local_8, t0.created_by_id AS created_by_id_9 FROM publicite t0 WHERE t0.page = ? AND t0.local = ? AND t0.active = ?
Parameters:
[
  "/"
  "actus"
  1
]
0.23 ms
(13.37%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.top_target AS top_target_5, t0.type_id AS type_id_6, t0.created_by_id AS created_by_id_7, t0.network_id AS network_id_8 FROM target t0 WHERE t0.network_id IS NULL ORDER BY t0.created_at DESC
Parameters:
[]
0.23 ms
(13.36%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.top_target AS top_target_5, t0.type_id AS type_id_6, t0.created_by_id AS created_by_id_7, t0.network_id AS network_id_8 FROM target t0 WHERE t0.network_id IS NULL AND t0.type_id IN (?, ?) AND t0.top_target = ? ORDER BY t0.created_at DESC
Parameters:
[
  1
  2
  1
]
0.21 ms
(12.43%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.discr FROM referential t0 WHERE t0.id = ? AND t0.discr IN ('refType')
Parameters:
[
  2
]
0.11 ms
(6.54%)
1
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.page AS page_3, p0_.title AS title_4, p0_.text AS text_5, p0_.active AS active_6, p0_.local AS local_7, p0_.created_by_id AS created_by_id_8 FROM publicite p0_ WHERE p0_.active = ? AND p0_.local = ?
Parameters:
[
  1
  "side_bar"
]
0.11 ms
(6.24%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.data AS data_4, t0.top_target AS top_target_5, t0.type_id AS type_id_6, t0.created_by_id AS created_by_id_7, t0.network_id AS network_id_8 FROM target t0 WHERE t0.network_id IS NULL AND t0.type_id IN (?, ?) AND t0.top_target = ? AND t0.created_by_id IS NULL ORDER BY t0.created_at DESC
Parameters:
[
  1
  2
  0
]

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.

Entities Mapping

Class Mapping errors
App\Entity\SystemSetting No errors.
App\Entity\Target No errors.
App\Entity\Referential No errors.
App\Entity\RefType No errors.
App\Entity\User
  • The association App\Entity\User#loginMessage refers to the inverse side field App\Entity\LoginMessage#viewedUsers which does not exist.
App\Entity\Network No errors.
App\Entity\Publicite No errors.