GET https://eterna-home.fr/shop

Query Metrics

16 Database Queries
5 Different statements
6.95 ms Query time
0 Invalid entities
76 Managed entities

Queries

Group similar statements

# Time Info
1 1.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.description AS description_5 FROM category t0
Parameters:
[]
2 0.58 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.is_active = 1
Parameters:
[]
3 0.39 ms
SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1 FROM product p0_ WHERE p0_.is_active = 1 ORDER BY p0_.name ASC LIMIT 12
Parameters:
[]
4 0.64 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.is_active AS is_active_4, p0_.slug AS slug_5, p0_.created_at AS created_at_6, p0_.stock AS stock_7, p0_.updated_at AS updated_at_8, p0_.features AS features_9, p0_.sku AS sku_10, p0_.sku_distributor AS sku_distributor_11, p0_.ean13 AS ean13_12, p0_.price_distributor AS price_distributor_13, p0_.tva AS tva_14, p0_.tva_distributor AS tva_distributor_15, p0_.weight AS weight_16, p0_.category_id AS category_id_17, p0_.brand_id AS brand_id_18 FROM product p0_ WHERE p0_.is_active = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.name ASC
Parameters:
[
  8
  29
  34
  35
  28
  36
  31
  6
  30
  33
  32
  2
]
5 0.56 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  8
]
6 0.33 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  29
]
7 0.27 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  34
]
8 0.27 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  35
]
9 0.26 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  28
]
10 0.29 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  36
]
11 0.28 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  31
]
12 0.28 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  6
]
13 0.27 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  30
]
14 0.28 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  33
]
15 0.26 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  32
]
16 0.27 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.thumbnail AS thumbnail_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sort_order AS sort_order_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  2
]

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 59
App\Entity\Product 12
App\Entity\Category 5

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Brand No errors.
App\Entity\ProductImage No errors.
App\Entity\OrderItem No errors.
App\Entity\Distributor No errors.
App\Entity\InvoiceItem No errors.