Query Metrics

5 Database Queries
5 Different statements
372.62 ms Query time
1 Invalid entities
0 Cache hits
2 Cache misses
11 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 74.12 ms
SELECT c0_.code AS code_0, c0_.name AS name_1, c0_.rate AS rate_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.synced_at AS synced_at_5, c0_.index_at AS index_at_6 FROM currency c0_ WHERE c0_.code = ?
Parameters:
[
  "RSD"
]
2 74.70 ms
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ LEFT JOIN blog_media b2_ ON b0_.id = b2_.blog_id LEFT JOIN media m1_ ON m1_.id = b2_.media_id LEFT JOIN blog_translation b3_ ON b0_.id = b3_.translatable_id WHERE b3_.locale = ?
Parameters:
[
  "sr"
]
3 76.65 ms
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM blog b0_ LEFT JOIN blog_media b2_ ON b0_.id = b2_.blog_id LEFT JOIN media m1_ ON m1_.id = b2_.media_id LEFT JOIN blog_translation b3_ ON b0_.id = b3_.translatable_id WHERE b3_.locale = ? ORDER BY b0_.created_at DESC OFFSET 0 ROWS FETCH NEXT 6 ROWS ONLY
Parameters:
[
  "sr"
]
4 68.43 ms
SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.created_at AS created_at_2, b0_.updated_at AS updated_at_3, b0_.synced_at AS synced_at_4, b0_.index_at AS index_at_5, m1_.id AS id_6, m1_.title AS title_7, m1_.caption AS caption_8, m1_.path AS path_9, m1_.url AS url_10, m1_.type AS type_11, m1_.featured AS featured_12, m1_.created_at AS created_at_13, m1_.updated_at AS updated_at_14, m1_.synced_at AS synced_at_15, m1_.index_at AS index_at_16, b2_.id AS id_17, b2_.title AS title_18, b2_.slug AS slug_19, b2_.excerpt AS excerpt_20, b2_.content AS content_21, b2_.created_at AS created_at_22, b2_.updated_at AS updated_at_23, b2_.synced_at AS synced_at_24, b2_.index_at AS index_at_25, b2_.locale AS locale_26, b0_.category AS category_27, b2_.translatable_id AS translatable_id_28 FROM blog b0_ LEFT JOIN blog_media b3_ ON b0_.id = b3_.blog_id LEFT JOIN media m1_ ON m1_.id = b3_.media_id LEFT JOIN blog_translation b2_ ON b0_.id = b2_.translatable_id WHERE b2_.locale = ? AND b0_.id IN (?) ORDER BY b0_.created_at DESC
Parameters:
[
  "sr"
  [
    23
    22
    21
    18
    17
    14
  ]
]
5 78.72 ms
SELECT t0.id AS id_1, t0.approved AS approved_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.synced_at AS synced_at_6, t0.index_at AS index_at_7, t0.blog_id AS blog_id_8, t0.author_id AS author_id_9 FROM blog_comment t0 WHERE t0.blog_id IN (?)
Parameters:
[
  [
    23
    22
    21
    18
    17
    14
  ]
]

client_rel_management connection

No database queries were performed.

client_rel_web_management connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
client_rel_management doctrine.dbal.client_rel_management_connection
client_rel_web_management doctrine.dbal.client_rel_web_management_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
client_rel_management doctrine.orm.client_rel_management_entity_manager
client_rel_web_management doctrine.orm.client_rel_web_management_entity_manager

Second Level Cache

0 Hits
2 Misses
11 Puts

Number of cache misses

Region Misses
public 2

Number of cache puts

Region Puts
public 11

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\ECommerce\Currency No errors.
App\Entity\ECommerce\Depot No errors.
App\Entity\ECommerce\Client No errors.
App\Entity\ECommerce\Shipping No errors.
App\Entity\Content\Blog No errors.
App\Entity\Media\Media No errors.
App\Entity\Content\BlogTranslation No errors.
App\Entity\Content\Tag No errors.
App\Entity\Content\BlogCategory No errors.
App\Entity\Content\BlogComment
  • The association App\Entity\Content\BlogComment#author refers to the inverse side field App\Entity\App\User#blogComments which does not exist.
App\Entity\SEO\Seo No errors.
App\Entity\App\User No errors.

client_rel_management entity manager

No loaded entities.

client_rel_web_management entity manager

No loaded entities.