Query Metrics
16
Database Queries
15
Different statements
17.35 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
8.76 ms (50.48%) |
2 |
SELECT t0.id AS id_1, t0.platform_title AS platform_title_2, t0.is_active AS is_active_3, t0.description AS description_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6 FROM platform_data t0 WHERE t0.is_active = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
1.32 ms (7.60%) |
1 |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.is_pin = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.85 ms (4.91%) |
1 |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_fr_slug AS title_fr_slug_3, t0.code AS code_4, t0.exchange_rate AS exchange_rate_5, t0.is_enabled AS is_enabled_6, t0.is_default_currency AS is_default_currency_7 FROM currency t0 INNER JOIN platform_data_currency ON t0.id = platform_data_currency.currency_id WHERE platform_data_currency.platform_data_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.80 ms (4.63%) |
1 |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.66 ms (3.79%) |
1 |
SELECT c0_.id AS id_0, c0_.title_fr AS title_fr_1, c0_.identifier_value AS identifier_value_2, c0_.live_stats AS live_stats_3, c0_.description AS description_4, c0_.title_slug_fr AS title_slug_fr_5, c0_.keywords AS keywords_6, c0_.is_enabled AS is_enabled_7, c0_.is_pin AS is_pin_8, c0_.date AS date_9, c0_.icon_library_value AS icon_library_value_10, c0_.parent_identifier_value AS parent_identifier_value_11, c0_.file_created AS file_created_12, c0_.menu_ranking AS menu_ranking_13, c0_.title_de AS title_de_14, c0_.title_slug_de AS title_slug_de_15, c0_.title_en AS title_en_16, c0_.title_slug_en AS title_slug_en_17, c0_.description_de AS description_de_18, c0_.description_en AS description_en_19, c0_.keywords_de AS keywords_de_20, c0_.keywords_en AS keywords_en_21, c0_.seo_title_fr AS seo_title_fr_22, c0_.seo_title_en AS seo_title_en_23, c0_.seo_title_de AS seo_title_de_24, c0_.parent_category_id AS parent_category_id_25 FROM categories c0_
Parameters:
[] |
||||||||||||||||||||||||||||
|
0.64 ms (3.68%) |
1 |
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.title_fr AS title_fr_3, t0.description AS description_4, t0.is_adult AS is_adult_5, t0.date AS date_6, t0.live_stats AS live_stats_7, t0.title_slug_fr AS title_slug_fr_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price_is_active AS price_is_active_11, t0.availability_is_active AS availability_is_active_12, t0.condition_is_active AS condition_is_active_13, t0.long_description AS long_description_14, t0.long_description_html AS long_description_html_15, t0.filter_price AS filter_price_16, t0.title_de AS title_de_17, t0.title_en AS title_en_18, t0.title_slug_de AS title_slug_de_19, t0.title_slug_en AS title_slug_en_20, t0.description_de AS description_de_21, t0.description_en AS description_en_22, t0.keywords_en AS keywords_en_23, t0.keywords_de AS keywords_de_24, t0.long_description_de AS long_description_de_25, t0.long_description_en AS long_description_en_26, t0.long_description_html_en AS long_description_html_en_27, t0.long_description_html_de AS long_description_html_de_28, t0.category_id AS category_id_29, t0.price_id AS price_id_30, t0.product_availability_id AS product_availability_id_31, t0.product_condition_id AS product_condition_id_32, t0.supplier_id AS supplier_id_33 FROM Product t0 WHERE t0.category_id = ?
Parameters:
[
22
]
|
||||||||||||||||||||||||||||
|
0.62 ms (3.56%) |
1 |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.content AS content_4, t0.content_html AS content_html_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enforcement_at AS enforcement_at_8, t0.is_enabled AS is_enabled_9, t0.random_number AS random_number_10, t0.indice AS indice_11 FROM legal_pages t0 WHERE t0.is_enabled = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.59 ms (3.43%) |
1 |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.parent_category_id = ?
Parameters:
[
22
]
|
||||||||||||||||||||||||||||
|
0.52 ms (3.03%) |
1 |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.identifier_value AS identifier_value_3, t0.live_stats AS live_stats_4, t0.description AS description_5, t0.title_slug_fr AS title_slug_fr_6, t0.keywords AS keywords_7, t0.is_enabled AS is_enabled_8, t0.is_pin AS is_pin_9, t0.date AS date_10, t0.icon_library_value AS icon_library_value_11, t0.parent_identifier_value AS parent_identifier_value_12, t0.file_created AS file_created_13, t0.menu_ranking AS menu_ranking_14, t0.title_de AS title_de_15, t0.title_slug_de AS title_slug_de_16, t0.title_en AS title_en_17, t0.title_slug_en AS title_slug_en_18, t0.description_de AS description_de_19, t0.description_en AS description_en_20, t0.keywords_de AS keywords_de_21, t0.keywords_en AS keywords_en_22, t0.seo_title_fr AS seo_title_fr_23, t0.seo_title_en AS seo_title_en_24, t0.seo_title_de AS seo_title_de_25, t0.parent_category_id AS parent_category_id_26 FROM categories t0 WHERE t0.title_slug_de = ? LIMIT 1
Parameters:
[
"Garten-Garnituren-2-teilig"
]
|
||||||||||||||||||||||||||||
|
0.50 ms (2.90%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_logo t0 WHERE t0.platform_data_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.48 ms (2.75%) |
1 |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_slug_fr AS title_slug_fr_3, t0.live_stats AS live_stats_4, t0.identifier_value AS identifier_value_5, t0.category_id AS category_id_6 FROM category_association t0 WHERE t0.identifier_value = ?
Parameters:
[
"1.0.0.0"
]
|
||||||||||||||||||||||||||||
|
0.41 ms (2.37%) |
1 |
SELECT t0.id AS id_1, t0.rating_number AS rating_number_2, t0.full_name AS full_name_3, t0.comment AS comment_4, t0.is_visible AS is_visible_5, t0.user_logged_in AS user_logged_in_6, t0.verified_purchase AS verified_purchase_7, t0.created_at AS created_at_8, t0.customer_email AS customer_email_9, t0.is_fake AS is_fake_10, t0.product_id AS product_id_11 FROM product_review t0 WHERE t0.product_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.41 ms (2.34%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.sale_price AS sale_price_3, t0.is_sale_price AS is_sale_price_4, t0.sale_price_effective_date_start AS sale_price_effective_date_start_5, t0.sale_price_effective_date_end AS sale_price_effective_date_end_6, t0.is_sale_effective_date AS is_sale_effective_date_7 FROM product_price t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.40 ms (2.29%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.platform_data_id AS platform_data_id_3 FROM platform_favicon t0 WHERE t0.platform_data_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.39 ms (2.25%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.product_id AS product_id_3 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
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.