Query Metrics
18
Database Queries
7
Different statements
5.76 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |