GET https://qa-efinancials.online/public/business/1/products?limit=20&page=1

Query Metrics

7 Database Queries
3 Different statements
8.63 ms Query time
0 Invalid entities
35 Managed entities

Queries

Group similar statements

# Time Info
1 1.13 ms
SELECT DISTINCT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.stock AS stock_4, p0_.minimum_stock AS minimum_stock_5, p0_.price AS price_6, p0_.discount_type AS discount_type_7, p0_.discount_value AS discount_value_8, p0_.active AS active_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.category_id AS category_id_12, p0_.business_id AS business_id_13 FROM product p0_ WHERE p0_.active = 1 AND p0_.business_id = ? AND p0_.stock > 0 ORDER BY p0_.id ASC LIMIT 20
Parameters:
[
  1
]
2 0.78 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.active = 1 AND p0_.business_id = ? AND p0_.stock > 0
Parameters:
[
  1
]
3 0.99 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
4 2.67 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
5 0.42 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
6 2.26 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
7 0.38 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.is_default AS is_default_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  5
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ProductImage 26
App\Entity\Product 5
App\Entity\Category 3
App\Entity\Business 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Business No errors.
App\Entity\ProductImage No errors.
App\Entity\User No errors.
App\Entity\OptionValue No errors.