Query Metrics

8 Database Queries
3 Different statements
5.98 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.31 ms
(55.37%)
1
SELECT s0_.id AS id_0, s0_.string AS string_1, s0_.value AS value_2, s0_.image AS image_3, s0_.image_alt AS image_alt_4 FROM string_translations s0_ LEFT JOIN languages l1_ ON s0_.language_id = l1_.id WHERE l1_.locale = ? ORDER BY s0_.id DESC
Parameters:
[
  "hr"
]
2.15 ms
(36.03%)
6
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.slug AS slug_4, t0.title_tag AS title_tag_5, t0.meta_description AS meta_description_6, t0.description AS description_7, t0.item_text AS item_text_8, t0.product_id AS product_id_9 FROM product_translation t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
0.51 ms
(8.60%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.title_tag AS title_tag_2, p0_.meta_description AS meta_description_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.price AS price_6, p0_.created AS created_7, p0_.is_active AS is_active_8, p0_.extracted_home AS extracted_home_9, p0_.image AS image_10, p0_.description_link AS description_link_11, p0_.pdf AS pdf_12, p0_.most_sold AS most_sold_13, p0_.new AS new_14, p0_.item_text AS item_text_15, p0_.type AS type_16, p0_.alias AS alias_17, p0_.sequence AS sequence_18, p0_.old_price AS old_price_19, p0_.show_only_user AS show_only_user_20, p0_.extract AS extract_21, p0_.subscription_type AS subscription_type_22, p0_.yearly_extra_month AS yearly_extra_month_23, p0_.channel_count AS channel_count_24, p0_.gallery_id AS gallery_id_25, p0_.category_id AS category_id_26 FROM product p0_ WHERE (p0_.show_only_user IS NULL AND p0_.is_active = ?) OR p0_.show_only_user = ? ORDER BY p0_.sequence ASC, p0_.price ASC
Parameters:
[
  1
  0
]

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.

Entities Mapping