Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.price AS price_6,
  t0.sale_price AS sale_price_7,
  t0.original_price AS original_price_8,
  t0.rating AS rating_9,
  t0.review_count AS review_count_10,
  t0.in_stock AS in_stock_11,
  t0.stock_quantity AS stock_quantity_12,
  t0.low_stock_threshold AS low_stock_threshold_13,
  t0.tags AS tags_14,
  t0.weight AS weight_15,
  t0.length AS length_16,
  t0.width AS width_17,
  t0.height AS height_18,
  t0.sku AS sku_19,
  t0.reference AS reference_20,
  t0.is_featured AS is_featured_21,
  t0.status AS status_22,
  t0.product_type AS product_type_23,
  t0.product_condition AS product_condition_24,
  t0.disabled_for_return AS disabled_for_return_25,
  t0.is_made_to_order AS is_made_to_order_26,
  t0.production_notes AS production_notes_27,
  t0.production_duration AS production_duration_28,
  t0.production_duration_unit AS production_duration_unit_29,
  t0.show_price AS show_price_30,
  t0.only_contact AS only_contact_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.vendor_id AS vendor_id_34,
  t0.category_id AS category_id_35,
  t0.main_image_id AS main_image_id_36
FROM
  product t0
WHERE
  t0.slug = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.price AS price_6, t0.sale_price AS sale_price_7, t0.original_price AS original_price_8, t0.rating AS rating_9, t0.review_count AS review_count_10, t0.in_stock AS in_stock_11, t0.stock_quantity AS stock_quantity_12, t0.low_stock_threshold AS low_stock_threshold_13, t0.tags AS tags_14, t0.weight AS weight_15, t0.length AS length_16, t0.width AS width_17, t0.height AS height_18, t0.sku AS sku_19, t0.reference AS reference_20, t0.is_featured AS is_featured_21, t0.status AS status_22, t0.product_type AS product_type_23, t0.product_condition AS product_condition_24, t0.disabled_for_return AS disabled_for_return_25, t0.is_made_to_order AS is_made_to_order_26, t0.production_notes AS production_notes_27, t0.production_duration AS production_duration_28, t0.production_duration_unit AS production_duration_unit_29, t0.show_price AS show_price_30, t0.only_contact AS only_contact_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.vendor_id AS vendor_id_34, t0.category_id AS category_id_35, t0.main_image_id AS main_image_id_36 FROM product t0 WHERE t0.slug = 'ugo-console' AND t0.status = 'PUBLISHED' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.description AS description_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.is_public AS is_public_8,
  t0.address AS address_9
FROM
  `settings` t0

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_public AS is_public_8, t0.address AS address_9 FROM `settings` t0;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.production_notes AS production_notes_6,
  t0.slug AS slug_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.product_id AS product_id_10
FROM
  product_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.production_notes AS production_notes_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM product_translation t0 WHERE t0.product_id = 707;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.website AS website_8,
  t0.rating AS rating_9,
  t0.total_reviews AS total_reviews_10,
  t0.total_products AS total_products_11,
  t0.total_sales AS total_sales_12,
  t0.total_revenue AS total_revenue_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.is_verified AS is_verified_16,
  t0.is_approved AS is_approved_17,
  t0.is_active AS is_active_18,
  t0.is_public AS is_public_19,
  t0.status AS status_20,
  t0.settings AS settings_21,
  t0.location AS location_22,
  t0.address AS address_23,
  t0.bank_info AS bank_info_24,
  t0.shipping_options AS shipping_options_25,
  t0.member_since AS member_since_26,
  t0.user_id AS user_id_27,
  t0.logo_image_id AS logo_image_id_28,
  t0.banner_image_id AS banner_image_id_29,
  t0.main_image_id AS main_image_id_30,
  t0.avatar_image_id AS avatar_image_id_31,
  t0.country_id AS country_id_32,
  t33.id AS id_34,
  t33.vendor_name AS vendor_name_35,
  t33.drive_folder_id AS drive_folder_id_36,
  t33.drive_folder_name AS drive_folder_name_37,
  t33.products_csv_id AS products_csv_id_38,
  t33.products_csv_name AS products_csv_name_39,
  t33.images_folder_id AS images_folder_id_40,
  t33.images_folder_name AS images_folder_name_41,
  t33.is_active AS is_active_42,
  t33.auto_sync AS auto_sync_43,
  t33.last_sync AS last_sync_44,
  t33.total_products AS total_products_45,
  t33.total_images AS total_images_46,
  t33.sync_status AS sync_status_47,
  t33.created_at AS created_at_48,
  t33.updated_at AS updated_at_49,
  t33.vendor_id AS vendor_id_50,
  t0.biography_pdf AS biography_pdf_51
FROM
  vendor t0
  LEFT JOIN drive_vendor_folder t33 ON t33.vendor_id = t0.id
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.short_description AS short_description_5, t0.email AS email_6, t0.phone AS phone_7, t0.website AS website_8, t0.rating AS rating_9, t0.total_reviews AS total_reviews_10, t0.total_products AS total_products_11, t0.total_sales AS total_sales_12, t0.total_revenue AS total_revenue_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.is_verified AS is_verified_16, t0.is_approved AS is_approved_17, t0.is_active AS is_active_18, t0.is_public AS is_public_19, t0.status AS status_20, t0.settings AS settings_21, t0.location AS location_22, t0.address AS address_23, t0.bank_info AS bank_info_24, t0.shipping_options AS shipping_options_25, t0.member_since AS member_since_26, t0.user_id AS user_id_27, t0.logo_image_id AS logo_image_id_28, t0.banner_image_id AS banner_image_id_29, t0.main_image_id AS main_image_id_30, t0.avatar_image_id AS avatar_image_id_31, t0.country_id AS country_id_32, t33.id AS id_34, t33.vendor_name AS vendor_name_35, t33.drive_folder_id AS drive_folder_id_36, t33.drive_folder_name AS drive_folder_name_37, t33.products_csv_id AS products_csv_id_38, t33.products_csv_name AS products_csv_name_39, t33.images_folder_id AS images_folder_id_40, t33.images_folder_name AS images_folder_name_41, t33.is_active AS is_active_42, t33.auto_sync AS auto_sync_43, t33.last_sync AS last_sync_44, t33.total_products AS total_products_45, t33.total_images AS total_images_46, t33.sync_status AS sync_status_47, t33.created_at AS created_at_48, t33.updated_at AS updated_at_49, t33.vendor_id AS vendor_id_50, t0.biography_pdf AS biography_pdf_51 FROM vendor t0 LEFT JOIN drive_vendor_folder t33 ON t33.vendor_id = t0.id WHERE t0.id = 32;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.short_description AS short_description_5,
  t0.slug AS slug_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.vendor_id AS vendor_id_9
FROM
  vendor_translation t0
WHERE
  t0.vendor_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.vendor_id AS vendor_id_9 FROM vendor_translation t0 WHERE t0.vendor_id = 32;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.banner_image_id AS banner_image_id_4,
  t0.icon AS icon_5,
  t0.slug AS slug_6,
  t0.color AS color_7,
  t0.is_active AS is_active_8,
  t0.product_count AS product_count_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.parent_id AS parent_id_12
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.banner_image_id AS banner_image_id_4, t0.icon AS icon_5, t0.slug AS slug_6, t0.color AS color_7, t0.is_active AS is_active_8, t0.product_count AS product_count_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.category_id AS category_id_8
FROM
  category_translation t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.category_id AS category_id_8 FROM category_translation t0 WHERE t0.category_id = 14;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_name AS original_name_3,
  t0.url AS url_4,
  t0.type AS type_5,
  t0.mime_type AS mime_type_6,
  t0.size AS size_7,
  t0.dimensions AS dimensions_8,
  t0.uploaded_at AS uploaded_at_9,
  t0.entity_type AS entity_type_10,
  t0.entity_id AS entity_id_11,
  t0.role AS role_12,
  t0.position AS position_13,
  t0.title AS title_14,
  t0.alt AS alt_15,
  t0.caption AS caption_16,
  t0.original_checksum AS original_checksum_17,
  t0.optimized_filename AS optimized_filename_18,
  t0.optimized_url AS optimized_url_19,
  t0.optimized_size AS optimized_size_20,
  t0.optimized_dimensions AS optimized_dimensions_21,
  t0.optimized_at AS optimized_at_22,
  t0.optimized_max_width AS optimized_max_width_23,
  t0.uploaded_by_id AS uploaded_by_id_24,
  t0.product_id AS product_id_25,
  t0.warehouse_id AS warehouse_id_26,
  t0.product_variant_id AS product_variant_id_27
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.url AS url_4, t0.type AS type_5, t0.mime_type AS mime_type_6, t0.size AS size_7, t0.dimensions AS dimensions_8, t0.uploaded_at AS uploaded_at_9, t0.entity_type AS entity_type_10, t0.entity_id AS entity_id_11, t0.role AS role_12, t0.position AS position_13, t0.title AS title_14, t0.alt AS alt_15, t0.caption AS caption_16, t0.original_checksum AS original_checksum_17, t0.optimized_filename AS optimized_filename_18, t0.optimized_url AS optimized_url_19, t0.optimized_size AS optimized_size_20, t0.optimized_dimensions AS optimized_dimensions_21, t0.optimized_at AS optimized_at_22, t0.optimized_max_width AS optimized_max_width_23, t0.uploaded_by_id AS uploaded_by_id_24, t0.product_id AS product_id_25, t0.warehouse_id AS warehouse_id_26, t0.product_variant_id AS product_variant_id_27 FROM media t0 WHERE t0.id = 8810;

SELECT
  m.id as image_id,
  m.url as image_url,
  m.filename as image_filename,
  m.alt as image_alt
FROM
  media m
WHERE
  m.entity_type = 'product'
  AND m.role = 'gallery'
  AND m.entity_id = ?
ORDER BY
  m.id ASC

SELECT 
                m.id as image_id, 
                m.url as image_url, 
                m.filename as image_filename,
                m.alt as image_alt
            FROM media m
            WHERE m.entity_type = 'product' 
            AND m.role = 'gallery' 
            AND m.entity_id = 707
            ORDER BY m.id ASC
        ;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.type AS type_5,
  t0.required AS required_6,
  t0.searchable AS searchable_7,
  t0.filterable AS filterable_8,
  t0.visible AS visible_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  product_attribute t0
  INNER JOIN product_attribute_assignment ON t0.id = product_attribute_assignment.product_attribute_id
WHERE
  product_attribute_assignment.product_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.required AS required_6, t0.searchable AS searchable_7, t0.filterable AS filterable_8, t0.visible AS visible_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM product_attribute t0 INNER JOIN product_attribute_assignment ON t0.id = product_attribute_assignment.product_attribute_id WHERE product_attribute_assignment.product_id = 707;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.product_attribute_id AS product_attribute_id_7
FROM
  product_attribute_translation t0
WHERE
  t0.product_attribute_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_attribute_id AS product_attribute_id_7 FROM product_attribute_translation t0 WHERE t0.product_attribute_id = 9;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.label AS label_3,
  t0.color AS color_4,
  t0.sort_order AS sort_order_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.attribute_id AS attribute_id_9
FROM
  product_attribute_value t0
WHERE
  t0.attribute_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.label AS label_3, t0.color AS color_4, t0.sort_order AS sort_order_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.attribute_id AS attribute_id_9 FROM product_attribute_value t0 WHERE t0.attribute_id = 9;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 138;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 191;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 135;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 171;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 163;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 99;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 237;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 294;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_attribute_value_id AS product_attribute_value_id_6
FROM
  product_attribute_value_translation t0
WHERE
  t0.product_attribute_value_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.label AS label_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_attribute_value_id AS product_attribute_value_id_6 FROM product_attribute_value_translation t0 WHERE t0.product_attribute_value_id = 318;