GET https://www.main.postmark.co.za/products/019e1ad3-d9b3-79f9-91cd-fe45af1022f8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.26 ms
(28.66%)
3
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ÓÊ¿yc¶÷¾™\x07^r\x11"
]
2.01 ms
(25.45%)
3
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ÓÊ¿yc¶÷¾™\x07^r\x11"
]
1.93 ms
(24.42%)
3
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ÓÊ¿yc¶÷¾™\x07^r\x11"
]
0.79 ms
(9.95%)
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ÓÙ³yù‘ÍþE¯\x10"
  0
]
0.49 ms
(6.22%)
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ÓÙ³yù‘ÍþE¯\x10"
]
0.42 ms
(5.31%)
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ÓÙ+t™;ú\x04÷“\x00g"
]

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

Entities Mapping