Symfony Profiler

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
  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_variant'
  AND m.entity_id = ?
  AND m.role = 'gallery'
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_variant'
            AND m.entity_id = 1158
            AND m.role = 'gallery'
            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 = ?
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.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
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.product_variant_id AS product_variant_id_6
FROM
  product_variant_translation t0
WHERE
  t0.product_variant_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_variant_id AS product_variant_id_6 FROM product_variant_translation t0 WHERE t0.product_variant_id = 1158;

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.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.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
  s0_.id AS id_0,
  s0_.owner_type AS owner_type_1,
  s0_.owner_id AS owner_id_2,
  s0_.meta_title AS meta_title_3,
  s0_.meta_description AS meta_description_4,
  s0_.meta_robots AS meta_robots_5,
  s0_.canonical_url AS canonical_url_6,
  s0_.og_title AS og_title_7,
  s0_.og_description AS og_description_8,
  s0_.og_image_url AS og_image_url_9,
  s0_.twitter_card AS twitter_card_10,
  s0_.hreflangs AS hreflangs_11,
  s0_.schema_json_ld AS schema_json_ld_12,
  s0_.sitemap_priority AS sitemap_priority_13,
  s0_.sitemap_change_freq AS sitemap_change_freq_14,
  s0_.custom_meta AS custom_meta_15,
  s0_.noindex AS noindex_16,
  s0_.noarchive AS noarchive_17,
  s0_.last_audited_at AS last_audited_at_18,
  s0_.created_at AS created_at_19,
  s0_.updated_at AS updated_at_20
FROM
  seo s0_
WHERE
  s0_.owner_type = ?
  AND s0_.owner_id = ?

SELECT s0_.id AS id_0, s0_.owner_type AS owner_type_1, s0_.owner_id AS owner_id_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.meta_robots AS meta_robots_5, s0_.canonical_url AS canonical_url_6, s0_.og_title AS og_title_7, s0_.og_description AS og_description_8, s0_.og_image_url AS og_image_url_9, s0_.twitter_card AS twitter_card_10, s0_.hreflangs AS hreflangs_11, s0_.schema_json_ld AS schema_json_ld_12, s0_.sitemap_priority AS sitemap_priority_13, s0_.sitemap_change_freq AS sitemap_change_freq_14, s0_.custom_meta AS custom_meta_15, s0_.noindex AS noindex_16, s0_.noarchive AS noarchive_17, s0_.last_audited_at AS last_audited_at_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20 FROM seo s0_ WHERE s0_.owner_type = 'product' AND s0_.owner_id = 707;

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.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.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.sku AS sku_2,
  t0.description AS description_3,
  t0.attributes AS attributes_4,
  t0.price_cents AS price_cents_5,
  t0.compare_at_price_cents AS compare_at_price_cents_6,
  t0.tax_rate AS tax_rate_7,
  t0.weight_grams AS weight_grams_8,
  t0.dimensions AS dimensions_9,
  t0.production_days AS production_days_10,
  t0.status AS status_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.product_id AS product_id_14,
  t15.id AS id_16,
  t15.quantity AS quantity_17,
  t15.low_stock_threshold AS low_stock_threshold_18,
  t15.updated_at AS updated_at_19,
  t15.variant_id AS variant_id_20,
  t0.main_image_id AS main_image_id_21
FROM
  product_variant t0
  LEFT JOIN inventory t15 ON t15.variant_id = t0.id
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.description AS description_3, t0.attributes AS attributes_4, t0.price_cents AS price_cents_5, t0.compare_at_price_cents AS compare_at_price_cents_6, t0.tax_rate AS tax_rate_7, t0.weight_grams AS weight_grams_8, t0.dimensions AS dimensions_9, t0.production_days AS production_days_10, t0.status AS status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.product_id AS product_id_14, t15.id AS id_16, t15.quantity AS quantity_17, t15.low_stock_threshold AS low_stock_threshold_18, t15.updated_at AS updated_at_19, t15.variant_id AS variant_id_20, t0.main_image_id AS main_image_id_21 FROM product_variant t0 LEFT JOIN inventory t15 ON t15.variant_id = t0.id WHERE t0.product_id = 707;

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.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.og_title AS og_title_5,
  t0.og_description AS og_description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.seo_id AS seo_id_9
FROM
  seo_translation t0
WHERE
  t0.seo_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.og_title AS og_title_5, t0.og_description AS og_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.seo_id AS seo_id_9 FROM seo_translation t0 WHERE t0.seo_id = 602;

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.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;