Query Metrics
13
Database Queries
12
Different statements
89.90 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 10.57 ms |
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-Beistelltische"
]
|
||||||||||||||||||||||||||||
| 2 | 16.36 ms |
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
]
|
||||||||||||||||||||||||||||
| 3 | 3.44 ms |
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
]
|
||||||||||||||||||||||||||||
| 4 | 4.46 ms |
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
]
|
||||||||||||||||||||||||||||
| 5 | 5.76 ms |
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.1.7"
]
|
||||||||||||||||||||||||||||
| 6 | 5.61 ms |
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:
[
38
]
|
||||||||||||||||||||||||||||
| 7 | 4.36 ms |
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
]
|
||||||||||||||||||||||||||||
| 8 | 12.01 ms |
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:
[] |
||||||||||||||||||||||||||||
| 9 | 4.08 ms |
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:
[]
|
||||||||||||||||||||||||||||
| 10 | 10.62 ms |
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
]
|
||||||||||||||||||||||||||||
| 11 | 4.68 ms |
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
]
|
||||||||||||||||||||||||||||
| 12 | 5.56 ms |
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
]
|
||||||||||||||||||||||||||||
| 13 | 2.37 ms |
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:
[
38
]
|
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\Categories | No errors. |
| App\Entity\CategoriesBanner | No errors. |
| App\Entity\CategoriesIcon | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductAssociation | No errors. |
| App\Entity\CategoryWarranty | No errors. |
| App\Entity\PlatformData | No errors. |
| App\Entity\PlatformLogo | No errors. |
| App\Entity\PlatformFavicon | No errors. |
| App\Entity\Currency | No errors. |
| App\Entity\Locale | No errors. |
| App\Entity\PageConfig | No errors. |
| App\Entity\Countries | No errors. |
| App\Entity\ShippingMethodChannel | No errors. |
| App\Entity\ShippingMethod | No errors. |
| App\Entity\ShippingMethodRate | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\CategoryAssociation |
|
| App\Entity\ProductPrice | No errors. |
| App\Entity\ProductAvailability | No errors. |
| App\Entity\ProductCondition | No errors. |
| App\Entity\ProductSupplier | No errors. |
| App\Entity\LegalPages | No errors. |