Query Metrics

4 Database Queries
4 Different statements
309.24 ms Query time
0 Invalid entities
16 Cache hits
1 Cache misses
1 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 120.39 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 50.87 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM document_category d0_ WHERE d0_.slug = ?
Parameters:
[
  "GUFERO"
]
3 56.87 ms
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM document d0_ LEFT JOIN document_category d1_ ON d0_.category = d1_.id WHERE d0_.enabled = 1 AND d1_.slug = ?
Parameters:
[
  "GUFERO"
]
4 81.10 ms
SELECT DISTINCT d0_.id AS id_0, d1_.name AS name_1 FROM document d0_ LEFT JOIN document_category d1_ ON d0_.category = d1_.id WHERE d0_.enabled = 1 AND d1_.slug = ? ORDER BY d1_.name ASC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
Parameters:
[
  "GUFERO"
]

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

16 Hits
1 Misses
1 Puts

Number of cache hits

Region Hits
public 16

Number of cache misses

Region Misses
public 1

Number of cache puts

Region Puts
public 1

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\PageTranslation No errors.
App\Entity\SEO\Seo No errors.
App\Entity\Media\Media No errors.
App\Entity\Content\Page No errors.
App\Entity\Content\DocumentCategory No errors.
App\Entity\Content\Document No errors.

client_rel_management entity manager

No loaded entities.

client_rel_web_management entity manager

No loaded entities.