Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 86.00 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 77.45 ms
SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = ? AND b0_.type = ?
Parameters:
[
  "sr"
  "photo"
]
3 76.93 ms
SELECT DISTINCT b0_.id AS id_0, b0_.created_at AS created_at_1 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = ? AND b0_.type = ? ORDER BY b0_.created_at DESC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
Parameters:
[
  "sr"
  "photo"
]
4 72.21 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, b1_.id AS id_6, b1_.title AS title_7, b1_.slug AS slug_8, b1_.excerpt AS excerpt_9, b1_.content AS content_10, b1_.created_at AS created_at_11, b1_.updated_at AS updated_at_12, b1_.synced_at AS synced_at_13, b1_.index_at AS index_at_14, b1_.locale AS locale_15, b1_.translatable_id AS translatable_id_16 FROM blog b0_ LEFT JOIN blog_translation b1_ ON b0_.id = b1_.translatable_id WHERE b1_.locale = ? AND b0_.type = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC
Parameters:
[
  "sr"
  "photo"
  23
  22
  21
  18
  17
  14
  11
  10
  9
  8
]

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
1 Misses
3 Puts

Number of cache misses

Region Misses
public 1

Number of cache puts

Region Puts
public 3

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\Content\BlogTranslation No errors.
App\Entity\Content\Tag No errors.
App\Entity\Media\Media No errors.
App\Entity\SEO\Seo No errors.
App\Entity\ECommerce\DepotProduct No errors.
App\Entity\App\User No errors.
App\Entity\ECommerce\DepotTranslation No errors.
App\Entity\ECommerce\ClientGroup No errors.
App\Entity\ECommerce\Cart No errors.
App\Entity\ECommerce\Firm No errors.
App\Entity\ECommerce\Product No errors.
App\Entity\ECommerce\IndividualOrder No errors.
App\Entity\ECommerce\Rebate No errors.
App\Entity\ECommerce\CartItem No errors.
App\Entity\ECommerce\Invoice No errors.
App\Entity\ECommerce\BankAccount No errors.
App\Entity\ECommerce\ProductPhoto No errors.
App\Entity\ECommerce\ProductDocument No errors.
App\Entity\ECommerce\ProductCategory No errors.
App\Entity\ECommerce\ProductSubCategory No errors.
App\Entity\ECommerce\ProductGroup No errors.
App\Entity\ECommerce\ProductManufacturer No errors.
App\Entity\ECommerce\ProductAlternative No errors.
App\Entity\ECommerce\ProductInfo No errors.
App\Entity\ECommerce\Unit No errors.
App\Entity\ECommerce\ProductTranslation No errors.
App\Entity\ECommerce\BillItem No errors.
App\Entity\ECommerce\Bill No errors.

client_rel_management entity manager

No loaded entities.

client_rel_web_management entity manager

No loaded entities.