https://www.adriabliss.com/marken/abi

Query Metrics

18 Database Queries
7 Different statements
5.76 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.website AS website_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.display_order AS display_order_9 FROM brand t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "abi"
  1
]
2 0.59 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.slug AS slug_3, t0.name AS name_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.model AS model_7, t0.price AS price_8, t0.old_price AS old_price_9, t0.currency AS currency_10, t0.status AS status_11, t0.`condition` AS condition_12, t0.availability AS availability_13, t0.stock_quantity AS stock_quantity_14, t0.main_image AS main_image_15, t0.surface AS surface_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.weight AS weight_20, t0.bedrooms AS bedrooms_21, t0.bathrooms AS bathrooms_22, t0.sleeping_places AS sleeping_places_23, t0.year AS year_24, t0.location AS location_25, t0.manufacturer AS manufacturer_26, t0.mpn AS mpn_27, t0.gtin AS gtin_28, t0.google_product_category AS google_product_category_29, t0.product_type AS product_type_30, t0.item_group_id AS item_group_id_31, t0.is_featured AS is_featured_32, t0.views_count AS views_count_33, t0.meta_title AS meta_title_34, t0.meta_description AS meta_description_35, t0.canonical_url AS canonical_url_36, t0.robots AS robots_37, t0.structured_data_enabled AS structured_data_enabled_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.brand_id AS brand_id_41, t0.category_id AS category_id_42 FROM product t0 WHERE t0.brand_id = ? AND t0.status = ? ORDER BY t0.price ASC
Parameters:
[
  25
  "active"
]
3 0.38 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.logo AS logo_4, b0_.website AS website_5, b0_.country AS country_6, b0_.is_active AS is_active_7, b0_.display_order AS display_order_8 FROM brand b0_ WHERE b0_.id <> ? AND b0_.is_active = 1 ORDER BY b0_.name ASC
Parameters:
[
  25
]
4 0.27 ms
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.canonical_url AS canonical_url_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.og_image AS og_image_8, t0.twitter_card AS twitter_card_9, t0.robots AS robots_10 FROM seo_setting t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "app_brand_detail"
]
5 0.34 ms
SELECT t0.id AS id_1, t0.merchant_center_id AS merchant_center_id_2, t0.merchant_account_id AS merchant_account_id_3, t0.api_client_id AS api_client_id_4, t0.api_client_secret AS api_client_secret_5, t0.refresh_token AS refresh_token_6, t0.feed_url AS feed_url_7, t0.ga_measurement_id AS ga_measurement_id_8, t0.ga_property_id AS ga_property_id_9, t0.gsc_property AS gsc_property_10, t0.gsc_verification_method AS gsc_verification_method_11, t0.gsc_verification_code AS gsc_verification_code_12, t0.gtm_id AS gtm_id_13, t0.google_site_verification_meta AS google_site_verification_meta_14, t0.is_connected AS is_connected_15, t0.last_tested_at AS last_tested_at_16, t0.last_sync_at AS last_sync_at_17, t0.last_sync_status AS last_sync_status_18, t0.updated_at AS updated_at_19 FROM google_integration t0 LIMIT 1
Parameters:
[]
6 0.27 ms
SELECT t0.id AS id_1, t0.merchant_center_id AS merchant_center_id_2, t0.merchant_account_id AS merchant_account_id_3, t0.api_client_id AS api_client_id_4, t0.api_client_secret AS api_client_secret_5, t0.refresh_token AS refresh_token_6, t0.feed_url AS feed_url_7, t0.ga_measurement_id AS ga_measurement_id_8, t0.ga_property_id AS ga_property_id_9, t0.gsc_property AS gsc_property_10, t0.gsc_verification_method AS gsc_verification_method_11, t0.gsc_verification_code AS gsc_verification_code_12, t0.gtm_id AS gtm_id_13, t0.google_site_verification_meta AS google_site_verification_meta_14, t0.is_connected AS is_connected_15, t0.last_tested_at AS last_tested_at_16, t0.last_sync_at AS last_sync_at_17, t0.last_sync_status AS last_sync_status_18, t0.updated_at AS updated_at_19 FROM google_integration t0 LIMIT 1
Parameters:
[]
7 0.36 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]
8 0.23 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]
9 0.30 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "opening_hours"
]
10 0.32 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]
11 0.15 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]
12 0.44 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.slug AS slug_3, t0.name AS name_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.model AS model_7, t0.price AS price_8, t0.old_price AS old_price_9, t0.currency AS currency_10, t0.status AS status_11, t0.`condition` AS condition_12, t0.availability AS availability_13, t0.stock_quantity AS stock_quantity_14, t0.main_image AS main_image_15, t0.surface AS surface_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.weight AS weight_20, t0.bedrooms AS bedrooms_21, t0.bathrooms AS bathrooms_22, t0.sleeping_places AS sleeping_places_23, t0.year AS year_24, t0.location AS location_25, t0.manufacturer AS manufacturer_26, t0.mpn AS mpn_27, t0.gtin AS gtin_28, t0.google_product_category AS google_product_category_29, t0.product_type AS product_type_30, t0.item_group_id AS item_group_id_31, t0.is_featured AS is_featured_32, t0.views_count AS views_count_33, t0.meta_title AS meta_title_34, t0.meta_description AS meta_description_35, t0.canonical_url AS canonical_url_36, t0.robots AS robots_37, t0.structured_data_enabled AS structured_data_enabled_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.brand_id AS brand_id_41, t0.category_id AS category_id_42 FROM product t0 WHERE t0.brand_id = ?
Parameters:
[
  28
]
13 0.36 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.slug AS slug_3, t0.name AS name_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.model AS model_7, t0.price AS price_8, t0.old_price AS old_price_9, t0.currency AS currency_10, t0.status AS status_11, t0.`condition` AS condition_12, t0.availability AS availability_13, t0.stock_quantity AS stock_quantity_14, t0.main_image AS main_image_15, t0.surface AS surface_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.weight AS weight_20, t0.bedrooms AS bedrooms_21, t0.bathrooms AS bathrooms_22, t0.sleeping_places AS sleeping_places_23, t0.year AS year_24, t0.location AS location_25, t0.manufacturer AS manufacturer_26, t0.mpn AS mpn_27, t0.gtin AS gtin_28, t0.google_product_category AS google_product_category_29, t0.product_type AS product_type_30, t0.item_group_id AS item_group_id_31, t0.is_featured AS is_featured_32, t0.views_count AS views_count_33, t0.meta_title AS meta_title_34, t0.meta_description AS meta_description_35, t0.canonical_url AS canonical_url_36, t0.robots AS robots_37, t0.structured_data_enabled AS structured_data_enabled_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.brand_id AS brand_id_41, t0.category_id AS category_id_42 FROM product t0 WHERE t0.brand_id = ?
Parameters:
[
  27
]
14 0.32 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.slug AS slug_3, t0.name AS name_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.model AS model_7, t0.price AS price_8, t0.old_price AS old_price_9, t0.currency AS currency_10, t0.status AS status_11, t0.`condition` AS condition_12, t0.availability AS availability_13, t0.stock_quantity AS stock_quantity_14, t0.main_image AS main_image_15, t0.surface AS surface_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.weight AS weight_20, t0.bedrooms AS bedrooms_21, t0.bathrooms AS bathrooms_22, t0.sleeping_places AS sleeping_places_23, t0.year AS year_24, t0.location AS location_25, t0.manufacturer AS manufacturer_26, t0.mpn AS mpn_27, t0.gtin AS gtin_28, t0.google_product_category AS google_product_category_29, t0.product_type AS product_type_30, t0.item_group_id AS item_group_id_31, t0.is_featured AS is_featured_32, t0.views_count AS views_count_33, t0.meta_title AS meta_title_34, t0.meta_description AS meta_description_35, t0.canonical_url AS canonical_url_36, t0.robots AS robots_37, t0.structured_data_enabled AS structured_data_enabled_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.brand_id AS brand_id_41, t0.category_id AS category_id_42 FROM product t0 WHERE t0.brand_id = ?
Parameters:
[
  26
]
15 0.33 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.slug AS slug_3, t0.name AS name_4, t0.short_description AS short_description_5, t0.description AS description_6, t0.model AS model_7, t0.price AS price_8, t0.old_price AS old_price_9, t0.currency AS currency_10, t0.status AS status_11, t0.`condition` AS condition_12, t0.availability AS availability_13, t0.stock_quantity AS stock_quantity_14, t0.main_image AS main_image_15, t0.surface AS surface_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.weight AS weight_20, t0.bedrooms AS bedrooms_21, t0.bathrooms AS bathrooms_22, t0.sleeping_places AS sleeping_places_23, t0.year AS year_24, t0.location AS location_25, t0.manufacturer AS manufacturer_26, t0.mpn AS mpn_27, t0.gtin AS gtin_28, t0.google_product_category AS google_product_category_29, t0.product_type AS product_type_30, t0.item_group_id AS item_group_id_31, t0.is_featured AS is_featured_32, t0.views_count AS views_count_33, t0.meta_title AS meta_title_34, t0.meta_description AS meta_description_35, t0.canonical_url AS canonical_url_36, t0.robots AS robots_37, t0.structured_data_enabled AS structured_data_enabled_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.brand_id AS brand_id_41, t0.category_id AS category_id_42 FROM product t0 WHERE t0.brand_id = ?
Parameters:
[
  24
]
16 0.15 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]
17 0.16 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]
18 0.37 ms
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
  "contact_phone"
]

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\Brand No errors.
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\SeoSetting No errors.
App\Entity\GoogleIntegration No errors.
App\Entity\SiteSetting No errors.
App\Entity\ProductImage No errors.
App\Entity\ProductFeature No errors.