Symfony Profiler

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.slug = ?
  AND t0.status = ?
LIMIT
  1

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.slug = 'cosalt-madeira' AND t0.status = 'active' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  product
SET
  views_count = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE product SET views_count = 11, updated_at = '2026-10-31 17:22:08' WHERE id = 50;

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.sku AS sku_1,
  p0_.slug AS slug_2,
  p0_.name AS name_3,
  p0_.short_description AS short_description_4,
  p0_.description AS description_5,
  p0_.model AS model_6,
  p0_.price AS price_7,
  p0_.old_price AS old_price_8,
  p0_.currency AS currency_9,
  p0_.status AS status_10,
  p0_.`condition` AS condition_11,
  p0_.availability AS availability_12,
  p0_.stock_quantity AS stock_quantity_13,
  p0_.main_image AS main_image_14,
  p0_.surface AS surface_15,
  p0_.length AS length_16,
  p0_.width AS width_17,
  p0_.height AS height_18,
  p0_.weight AS weight_19,
  p0_.bedrooms AS bedrooms_20,
  p0_.bathrooms AS bathrooms_21,
  p0_.sleeping_places AS sleeping_places_22,
  p0_.year AS year_23,
  p0_.location AS location_24,
  p0_.manufacturer AS manufacturer_25,
  p0_.mpn AS mpn_26,
  p0_.gtin AS gtin_27,
  p0_.google_product_category AS google_product_category_28,
  p0_.product_type AS product_type_29,
  p0_.item_group_id AS item_group_id_30,
  p0_.is_featured AS is_featured_31,
  p0_.views_count AS views_count_32,
  p0_.meta_title AS meta_title_33,
  p0_.meta_description AS meta_description_34,
  p0_.canonical_url AS canonical_url_35,
  p0_.robots AS robots_36,
  p0_.structured_data_enabled AS structured_data_enabled_37,
  p0_.created_at AS created_at_38,
  p0_.updated_at AS updated_at_39,
  p0_.brand_id AS brand_id_40,
  p0_.category_id AS category_id_41
FROM
  product p0_
WHERE
  p0_.category_id = ?
  AND p0_.id <> ?
  AND p0_.status = ?
LIMIT
  3

SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.slug AS slug_2, p0_.name AS name_3, p0_.short_description AS short_description_4, p0_.description AS description_5, p0_.model AS model_6, p0_.price AS price_7, p0_.old_price AS old_price_8, p0_.currency AS currency_9, p0_.status AS status_10, p0_.`condition` AS condition_11, p0_.availability AS availability_12, p0_.stock_quantity AS stock_quantity_13, p0_.main_image AS main_image_14, p0_.surface AS surface_15, p0_.length AS length_16, p0_.width AS width_17, p0_.height AS height_18, p0_.weight AS weight_19, p0_.bedrooms AS bedrooms_20, p0_.bathrooms AS bathrooms_21, p0_.sleeping_places AS sleeping_places_22, p0_.year AS year_23, p0_.location AS location_24, p0_.manufacturer AS manufacturer_25, p0_.mpn AS mpn_26, p0_.gtin AS gtin_27, p0_.google_product_category AS google_product_category_28, p0_.product_type AS product_type_29, p0_.item_group_id AS item_group_id_30, p0_.is_featured AS is_featured_31, p0_.views_count AS views_count_32, p0_.meta_title AS meta_title_33, p0_.meta_description AS meta_description_34, p0_.canonical_url AS canonical_url_35, p0_.robots AS robots_36, p0_.structured_data_enabled AS structured_data_enabled_37, p0_.created_at AS created_at_38, p0_.updated_at AS updated_at_39, p0_.brand_id AS brand_id_40, p0_.category_id AS category_id_41 FROM product p0_ WHERE p0_.category_id = 29 AND p0_.id <> 50 AND p0_.status = 'active' LIMIT 3;

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

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 = 'app_product_detail' LIMIT 1;

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

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;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.alt_text AS alt_text_3,
  t0.title AS title_4,
  t0.display_order AS display_order_5,
  t0.is_main AS is_main_6,
  t0.product_id AS product_id_7
FROM
  product_image t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.display_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.alt_text AS alt_text_3, t0.title AS title_4, t0.display_order AS display_order_5, t0.is_main AS is_main_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = 50 ORDER BY t0.display_order ASC, t0.id ASC;

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.id = ?

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.id = 28;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.subtitle AS subtitle_5,
  t0.image AS image_6,
  t0.icon AS icon_7,
  t0.display_order AS display_order_8,
  t0.is_active AS is_active_9
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.subtitle AS subtitle_5, t0.image AS image_6, t0.icon AS icon_7, t0.display_order AS display_order_8, t0.is_active AS is_active_9 FROM category t0 WHERE t0.id = 29;

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

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;

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

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 = 'contact_phone' LIMIT 1;

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

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 = 'contact_phone' LIMIT 1;

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

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 = 'opening_hours' LIMIT 1;

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

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 = 'contact_phone' LIMIT 1;

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

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 = 'contact_phone' LIMIT 1;

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

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 = 'contact_phone' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.category AS category_4,
  t0.icon AS icon_5,
  t0.is_highlighted AS is_highlighted_6
FROM
  product_feature t0
  INNER JOIN product_product_feature ON t0.id = product_product_feature.product_feature_id
WHERE
  product_product_feature.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.category AS category_4, t0.icon AS icon_5, t0.is_highlighted AS is_highlighted_6 FROM product_feature t0 INNER JOIN product_product_feature ON t0.id = product_product_feature.product_feature_id WHERE product_product_feature.product_id = 50;

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

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 = 'contact_phone' LIMIT 1;