https://viglager.optima.rs/sr/blog/by_type/photo?page=1

Query Metrics

29 Database Queries
6 Different statements
1486.60 ms Query time
2 Invalid entities
21 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

default connection

# Time Info
1 75.67 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 90.94 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 79.18 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 54.51 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
    11
    10
    9
    8
  ]
]
5 51.75 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  9
]
6 45.78 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  10
]
7 45.48 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  11
]
8 45.78 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  12
]
9 46.47 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  13
]
10 45.94 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  30
]
11 45.74 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  14
]
12 67.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  23
]
13 45.54 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  22
]
14 47.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  21
]
15 46.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  18
]
16 45.48 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  17
]
17 48.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  14
]
18 49.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  11
]
19 45.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  10
]
20 45.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  9
]
21 45.71 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.caption AS caption_3, t0.path AS path_4, t0.url AS url_5, t0.type AS type_6, t0.featured AS featured_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.synced_at AS synced_at_10, t0.index_at AS index_at_11 FROM media t0 INNER JOIN blog_media ON t0.id = blog_media.media_id WHERE blog_media.blog_id = ?
Parameters:
[
  8
]
22 45.42 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  35
]
23 45.80 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  36
]
24 45.97 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  37
]
25 46.22 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  38
]
26 46.75 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  39
]
27 45.69 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  40
]
28 47.46 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  41
]
29 49.56 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.attributes AS attributes_3, t0.title AS title_4, t0.locale AS locale_5, t0.url AS url_6, t0.path AS path_7, t0.parameters AS parameters_8, t0.widget AS widget_9, t0.item_order AS item_order_10, t0.has_right AS has_right_11, t0.user_right AS user_right_12, t0.menu AS menu_13 FROM menu t0 WHERE t0.menu = ? ORDER BY t0.item_order ASC
Parameters:
[
  42
]

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

21 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
public 21

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\SEO\Seo 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\Media\Media No errors.
App\Entity\ECommerce\DepotProduct
  • The field 'App\Entity\ECommerce\DepotProduct#taxRate' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
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.
App\Entity\Content\Document No errors.
App\Entity\ECommerce\ProductCategoryTranslation No errors.
App\Entity\ECommerce\ProductInfoTranslation No errors.
App\Entity\App\Menu No errors.
App\Entity\Content\DocumentCategory No errors.
App\Entity\Content\DocumentTranslation No errors.

client_rel_management entity manager

No loaded entities.

client_rel_web_management entity manager

No loaded entities.