http://127.0.0.1/

Query Metrics

5 Database Queries
5 Different statements
677.67 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
354.56 ms
(52.32%)
1
SELECT sum(c0_.quantity) AS sclr_0 FROM coin c0_ LEFT JOIN hoard h1_ ON c0_.hoard_id = h1_.id AND ((h1_.deletedAt IS NULL OR h1_.deletedAt > CURRENT_TIMESTAMP)) WHERE (h1_.id IS NOT NULL AND (h1_.hide_from_id = 3 OR h1_.hide_what_id < 3 OR h1_.hide_what_id IS NULL)) AND ((c0_.deletedAt IS NULL OR c0_.deletedAt > CURRENT_TIMESTAMP))
Parameters:
[]
289.83 ms
(42.77%)
1
SELECT sum(c0_.quantity) AS sclr_0 FROM coin c0_ LEFT JOIN hoard h1_ ON c0_.hoard_id = h1_.id AND ((h1_.deletedAt IS NULL OR h1_.deletedAt > CURRENT_TIMESTAMP)) WHERE (h1_.id IS NOT NULL AND (h1_.hide_from_id = 3 OR h1_.hide_what_id < 3 OR h1_.hide_what_id IS NULL) AND h1_.coin_data_validated_by_user = 1) AND ((c0_.deletedAt IS NULL OR c0_.deletedAt > CURRENT_TIMESTAMP))
Parameters:
[]
21.30 ms
(3.14%)
1
SELECT COUNT(h0_.id) AS sclr_0 FROM hoard h0_ WHERE (h0_.id IS NOT NULL AND (h0_.hide_from_id = 3 OR h0_.hide_what_id < 3 OR h0_.hide_what_id IS NULL) AND h0_.validated_by_user = 1) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP))
Parameters:
[]
11.59 ms
(1.71%)
1
SELECT COUNT(h0_.id) AS sclr_0 FROM hoard h0_ WHERE (h0_.id IS NOT NULL AND (h0_.hide_from_id = 3 OR h0_.hide_what_id < 3 OR h0_.hide_what_id IS NULL)) AND ((h0_.deletedAt IS NULL OR h0_.deletedAt > CURRENT_TIMESTAMP))
Parameters:
[]
0.40 ms
(0.06%)
1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.body AS body_2, c0_.teaser AS teaser_3, c0_.image AS image_4, c0_.path_alias AS path_alias_5, c0_.type AS type_6, c0_.creation_date AS creation_date_7, c0_.modified_date AS modified_date_8, c0_.comment AS comment_9 FROM content_page c0_ WHERE c0_.type = 0 ORDER BY c0_.creation_date DESC LIMIT 2
Parameters:
[]

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\Ox\HoardBundle\Entity\EntityBase No errors.
App\Ox\HoardBundle\Entity\ContentPage No errors.
App\Ox\HoardBundle\Entity\Hoard
  • The field App\Ox\HoardBundle\Entity\Hoard#coinCount is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Ox\HoardBundle\Entity\HoardCoinCount#hoard does not contain the required 'inversedBy="coinCount"' attribute.
  • The field App\Ox\HoardBundle\Entity\Hoard#nameSimple is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Ox\HoardBundle\Entity\HoardNameSimple#hoard does not contain the required 'inversedBy="nameSimple"' attribute.
App\Ox\HoardBundle\Entity\Coin
  • The mappings App\Ox\HoardBundle\Entity\Coin#condition and App\Ox\HoardBundle\Entity\Condition#coins are inconsistent with each other.