Query Metrics
5
Database Queries
5
Different statements
677.67 ms
Query time
2
Invalid entities
Grouped Statements
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 |
|
App\Ox\HoardBundle\Entity\Coin |
|