GET https://www.main.postmark.co.za/products/019e1ad3-da02-7f9b-9090-7337195b83af

Query Metrics

6 Database Queries
6 Different statements
2.61 ms Query time
0 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.52 ms
(19.87%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.minimum_price AS minimum_price_3, t0.maximum_price AS maximum_price_4 FROM product_categories t0 WHERE t0.id = ?
Parameters:
[
  b"\x01ž\x1AÓÙ+uú™;ú\x04÷×=³"
]
0.45 ms
(17.41%)
1
SELECT t1.created_at AS created_at_2, t1.updated_at AS updated_at_3, t1.id AS id_4, t1.roles AS roles_5, t1.password AS password_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.email AS email_9, t1.last_login AS last_login_10, t1.phone AS phone_11, t1.active AS active_12, t0.is_verified AS is_verified_13, t0.confirmation_token AS confirmation_token_14, t0.token_expires_at AS token_expires_at_15, t1.user_type FROM customers t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  b"\x01ž\x1AÓÎØxJš‘\eÚå!1å"
]
0.45 ms
(17.38%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.customer_id = ?
Parameters:
[
  b"\x01ž\x1AÓÎØxJš‘\eÚå!1å"
]
0.45 ms
(17.18%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.rating AS rating_4, t0.comment AS comment_5, t0.is_disabled AS is_disabled_6, t0.customer_id AS customer_id_7, t0.product_id AS product_id_8 FROM reviews t0 WHERE t0.product_id = ? AND t0.is_disabled = ?
Parameters:
[
  b"\x01ž\x1AÓÚ\x02\x7F›s7\x19[ƒ¯"
  0
]
0.40 ms
(15.26%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.name AS name_6, t0.status AS status_7, t0.quantity AS quantity_8, t0.price AS price_9, t0.short_description AS short_description_10, t0.detailed_description AS detailed_description_11, t0.specifications AS specifications_12, t0.category_id AS category_id_13 FROM products t0 WHERE t0.id = ?
Parameters:
[
  b"\x01ž\x1AÓÚ\x02\x7F›s7\x19[ƒ¯"
]
0.34 ms
(12.89%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.customer_id = ?
Parameters:
[
  b"\x01ž\x1AÓÎØxJš‘\eÚå!1å"
]

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\Product 1
App\Entity\ProductCategory 1
App\Entity\Review 1
App\Entity\User 1
App\Entity\Testimonial 1
App\Entity\Cart 1

Entities Mapping