Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
96.60 ms
(34.10%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.file_name AS file_name_3, t0.tries AS tries_4, t0.error AS error_5, t0.original AS original_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.synced_at AS synced_at_9, t0.index_at AS index_at_10, t0.product AS product_11 FROM product_photo t0 WHERE t0.product IN (?)
Parameters:
[
  [
    4
  ]
]
84.47 ms
(29.82%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.barcode AS barcode_3, t0.title AS title_4, t0.original_title AS original_title_5, t0.search_title AS search_title_6, t0.slug AS slug_7, t0.origin AS origin_8, t0.link AS link_9, t0.inner_diameter_min AS inner_diameter_min_10, t0.inner_diameter_max AS inner_diameter_max_11, t0.outer_diameter_min AS outer_diameter_min_12, t0.outer_diameter_max AS outer_diameter_max_13, t0.width_min AS width_min_14, t0.width_max AS width_max_15, t0.weight AS weight_16, t0.gross_price AS gross_price_17, t0.minimal_quantity AS minimal_quantity_18, t0.disabled AS disabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.synced_at AS synced_at_22, t0.index_at AS index_at_23, t0.remote_id AS remote_id_24, t0.category AS category_25, t0.sub_category AS sub_category_26, t0.product_group AS product_group_27, t0.manufacturer AS manufacturer_28, t0.unit_of_measurement AS unit_of_measurement_29 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
52.29 ms
(18.46%)
1
SELECT t0.id AS id_1, t0.page AS page_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.document AS document_7, t0.product AS product_8 FROM product_document t0 WHERE t0.product IN (?)
Parameters:
[
  [
    4
  ]
]
49.93 ms
(17.62%)
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

0 Hits
3 Misses
3 Puts

Number of cache misses

Region Misses
public 3

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\ECommerce\Product 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\Unit No errors.
App\Entity\ECommerce\ProductPhoto No errors.
App\Entity\ECommerce\ProductDocument 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\ProductTranslation No errors.
App\Entity\Content\Document 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\ProductCategoryTranslation No errors.
App\Entity\ECommerce\Rebate No errors.
App\Entity\ECommerce\ProductInfoTranslation 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.