Query Metrics
4
Database Queries
4
Different statements
668.71 ms
Query time
1
Invalid entities
13
Cache hits
0
Cache misses
0
Cache puts
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 46.14 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 | 407.97 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN depot_product d1_ ON p0_.id = d1_.product WHERE p0_.disabled IS NULL AND d1_.quantity > 0
Parameters:
[] |
3 | 81.14 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product p0_ LEFT JOIN depot_product d1_ ON p0_.id = d1_.product WHERE p0_.disabled IS NULL AND d1_.quantity > 0 ORDER BY p0_.id ASC OFFSET 54 ROWS FETCH NEXT 6 ROWS ONLY
Parameters:
[] |
4 | 133.47 ms |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.barcode AS barcode_2, p0_.title AS title_3, p0_.original_title AS original_title_4, p0_.search_title AS search_title_5, p0_.slug AS slug_6, p0_.origin AS origin_7, p0_.link AS link_8, p0_.inner_diameter_min AS inner_diameter_min_9, p0_.inner_diameter_max AS inner_diameter_max_10, p0_.outer_diameter_min AS outer_diameter_min_11, p0_.outer_diameter_max AS outer_diameter_max_12, p0_.width_min AS width_min_13, p0_.width_max AS width_max_14, p0_.weight AS weight_15, p0_.gross_price AS gross_price_16, p0_.minimal_quantity AS minimal_quantity_17, p0_.disabled AS disabled_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.synced_at AS synced_at_21, p0_.index_at AS index_at_22, p0_.remote_id AS remote_id_23, p0_.category AS category_24, p0_.sub_category AS sub_category_25, p0_.product_group AS product_group_26, p0_.manufacturer AS manufacturer_27, p0_.unit_of_measurement AS unit_of_measurement_28 FROM product p0_ LEFT JOIN depot_product d1_ ON p0_.id = d1_.product WHERE p0_.disabled IS NULL AND d1_.quantity > 0 AND p0_.id IN (?) ORDER BY p0_.id ASC
Parameters:
[ [ 64 65 66 71 72 73 ] ] |
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
13
Hits
0
Misses
0
Puts
Number of cache hits
Region | Hits |
---|---|
public | 13 |
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\DepotProduct |
|
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\Content\Document | No errors. |
client_rel_management entity manager
No loaded entities.
client_rel_web_management entity manager
No loaded entities.