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

Class Mapping errors
App\Entity\StringTranslations No errors.
App\Entity\Languages No errors.
App\Entity\Product No errors.
App\Entity\Gallery No errors.
App\Entity\Category No errors.
App\Entity\Contact No errors.
App\Entity\ProductTranslation No errors.
App\Entity\Orders No errors.