Query Metrics

22 Database Queries
7 Different statements
1057.42 ms Query time
1 Invalid entities
5 Cache hits
2 Cache misses
2 Cache puts

Grouped Statements

Show all queries

default connection

Time Count Info
690.92 ms
(65.34%)
15
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
]
101.66 ms
(9.61%)
2
SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.attributes AS attributes_2, m0_.title AS title_3, m0_.locale AS locale_4, m0_.url AS url_5, m0_.path AS path_6, m0_.parameters AS parameters_7, m0_.widget AS widget_8, m0_.item_order AS item_order_9, m0_.has_right AS has_right_10, m0_.user_right AS user_right_11, m1_.id AS id_12, m1_.slug AS slug_13, m1_.attributes AS attributes_14, m1_.title AS title_15, m1_.locale AS locale_16, m1_.url AS url_17, m1_.path AS path_18, m1_.parameters AS parameters_19, m1_.widget AS widget_20, m1_.item_order AS item_order_21, m1_.has_right AS has_right_22, m1_.user_right AS user_right_23, m0_.menu AS menu_24, m1_.menu AS menu_25 FROM menu m0_ LEFT JOIN menu m1_ ON m0_.id = m1_.menu WHERE m0_.menu IS NULL AND m0_.slug = ? AND m0_.locale = ? ORDER BY m0_.item_order ASC, m1_.item_order ASC
Parameters:
[
  "footer_left"
  "sr"
]
74.78 ms
(7.07%)
1
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.quantity AS quantity_3, t0.minimal_quantity AS minimal_quantity_4, t0.optimal_quantity AS optimal_quantity_5, t0.price AS price_6, t0.tax_rate AS tax_rate_7, t0.location AS location_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.synced_at AS synced_at_11, t0.index_at AS index_at_12, t0.product AS product_13, t0.depot AS depot_14 FROM depot_product t0 WHERE t0.product = ?
Parameters:
[
  58
]
48.68 ms
(4.60%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.sorting_priority AS sorting_priority_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.remote_id AS remote_id_8 FROM product_manufacturer t0 WHERE t0.id = ?
Parameters:
[
  12
]
47.75 ms
(4.52%)
1
SELECT t0.id AS id_1, t0.info AS info_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.synced_at AS synced_at_5, t0.index_at AS index_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM depot_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
46.85 ms
(4.43%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.colors AS colors_4, t0.deliver_at AS deliver_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synced_at AS synced_at_8, t0.index_at AS index_at_9, t0.currency AS currency_10 FROM depot t0 WHERE t0.id = ?
Parameters:
[
  1
]
46.78 ms
(4.42%)
1
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"
]

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

5 Hits
2 Misses
2 Puts

Number of cache hits

Region Hits
public 5

Number of cache misses

Region Misses
public 2

Number of cache puts

Region Puts
public 2

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\ECommerce\Product 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\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\ECommerce\ProductAlternative No errors.
App\Entity\ECommerce\ProductInfo No errors.
App\Entity\ECommerce\Unit No errors.
App\Entity\ECommerce\ProductTranslation 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\Content\Document No errors.
App\Entity\ECommerce\ProductCategoryTranslation No errors.
App\Entity\ECommerce\Rebate No errors.
App\Entity\ECommerce\ProductInfoTranslation No errors.
App\Entity\ECommerce\IndividualOrder No errors.
App\Entity\ECommerce\CartItem No errors.
App\Entity\ECommerce\Invoice No errors.
App\Entity\ECommerce\BankAccount No errors.
App\Entity\Content\DocumentCategory No errors.
App\Entity\Content\DocumentTranslation No errors.
App\Entity\ECommerce\BillItem No errors.
App\Entity\ECommerce\Bill No errors.
App\Entity\SEO\Seo No errors.
App\Entity\App\Menu No errors.

client_rel_management entity manager

No loaded entities.

client_rel_web_management entity manager

No loaded entities.