Query Metrics
8
Database Queries
3
Different statements
5.98 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.31 ms |
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 | 0.51 ms |
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 ] |
3 | 0.47 ms |
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
]
|
4 | 0.34 ms |
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:
[
16
]
|
5 | 0.35 ms |
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:
[
21
]
|
6 | 0.34 ms |
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:
[
4
]
|
7 | 0.29 ms |
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:
[
15
]
|
8 | 0.38 ms |
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:
[
22
]
|
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. |
App\Entity\Article | No errors. |
App\Entity\Image | No errors. |
App\Entity\CategoryTranslation | No errors. |
App\Entity\User | No errors. |
App\Entity\Bills | No errors. |
App\Entity\Offer | No errors. |
App\Entity\SellerCode | No errors. |
App\Entity\InvoiceItem | No errors. |