Symfony Profiler

SELECT
  p.product_id,
  p.main_price,
  p.name,
  p.category_id,
  p.description,
  p.subcategory_id,
  p.main_picture,
  p.call_to_action,
  pi.available AS stock,
  p.has_inventory,
  p.show_price,
  (
    SELECT
      offer_id
    FROM
      offer
    WHERE
      category_id = p.category_id
      AND is_active = 1
      AND p.category_id is not NULL
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as has_category_offer,
  (
    SELECT
      offer_name
    FROM
      offer
    WHERE
      category_id = p.category_id
      AND is_active = 1
      AND p.category_id is not NULL
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as category_offer_name,
  (
    SELECT
      offer_id
    FROM
      offer
    WHERE
      subcategory_id = p.subcategory_id
      AND is_active = 1
      AND p.subcategory_id is not NULL
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as has_subcategory_offer,
  (
    SELECT
      offer_name
    FROM
      offer
    WHERE
      subcategory_id = p.subcategory_id
      AND is_active = 1
      AND p.subcategory_id is not NULL
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as subcategory_offer_name,
  (
    SELECT
      offer_id
    FROM
      offer
    WHERE
      brand_id = p.brand_id
      AND is_active = 1
      AND p.brand_id is not NULL
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as has_brand_offer,
  (
    SELECT
      offer_name
    FROM
      offer
    WHERE
      brand_id = p.brand_id
      AND is_active = 1
      AND p.brand_id is not NULL
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as brand_offer_name,
  (
    SELECT
      offer_id
    FROM
      offer
    WHERE
      product_id = p.product_id
      AND is_active = 1
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as has_offer,
  (
    SELECT
      offer_name
    FROM
      offer
    WHERE
      product_id = p.product_id
      AND is_active = 1
      AND is_published = 1
      AND date(now()) BETWEEN date(start_date)
      AND date(end_date)
    ORDER BY
      offer_id DESC
    LIMIT
      1
  ) as offer_name,
  (
    SELECT
      name
    FROM
      category
    WHERE
      category_id = p.category_id
  ) as category_name,
  (
    SELECT
      name
    FROM
      subcategory
    WHERE
      subcategory_id = p.subcategory_id
  ) as subcategory_name,
  (
    SELECT
      name
    FROM
      brand
    WHERE
      brand_id = p.brand_id
  ) as brand_name,
  (
    SELECT
      field_list_id
    FROM
      category
    WHERE
      category_id = p.category_id
  ) as field_list,
  (
    SELECT
      field_list_id
    FROM
      subcategory
    WHERE
      subcategory_id = p.subcategory_id
  ) as field_list_subcategory
FROM
  product p
  LEFT JOIN product_inventory pi ON pi.product_id = p.product_id
WHERE
  p.is_active = 1
  AND p.client_id = '1'

SELECT
                                p.product_id,
                                p.main_price,
                                p.name,
                                p.category_id,
                            p.description,
                                p.subcategory_id,        		   		        		   		
                                p.main_picture,
                                p.call_to_action,
                                pi.available AS stock,
                                p.has_inventory,
                                p.show_price,
                                (SELECT offer_id FROM offer WHERE category_id = p.category_id AND is_active = 1 AND p.category_id is not NULL AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as has_category_offer,
                                (SELECT offer_name FROM offer WHERE category_id = p.category_id AND is_active = 1 AND p.category_id is not NULL AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as category_offer_name,    
                    (SELECT offer_id FROM offer WHERE subcategory_id = p.subcategory_id AND is_active = 1 AND p.subcategory_id is not NULL AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as has_subcategory_offer,
                                (SELECT offer_name FROM offer WHERE subcategory_id = p.subcategory_id AND is_active = 1 AND p.subcategory_id is not NULL AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as subcategory_offer_name,  
                                (SELECT offer_id FROM offer WHERE brand_id = p.brand_id AND is_active = 1 AND p.brand_id is not NULL AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as has_brand_offer,
                (SELECT offer_name FROM offer WHERE brand_id = p.brand_id AND is_active = 1 AND p.brand_id is not NULL AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as brand_offer_name,	
                (SELECT offer_id FROM offer WHERE product_id = p.product_id AND is_active = 1 AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as has_offer,
                (SELECT offer_name FROM offer WHERE product_id = p.product_id AND is_active = 1 AND is_published = 1 AND date(now()) BETWEEN date(start_date) AND date(end_date) ORDER BY offer_id DESC LIMIT 1) as offer_name,		
                (SELECT name FROM category WHERE category_id = p.category_id) as category_name,
                    (SELECT name FROM subcategory WHERE subcategory_id = p.subcategory_id) as subcategory_name,
                                (SELECT name FROM brand WHERE brand_id = p.brand_id) as brand_name,
                                (SELECT field_list_id FROM category WHERE category_id = p.category_id) as field_list,
                                (SELECT field_list_id FROM subcategory WHERE subcategory_id = p.subcategory_id) as field_list_subcategory
                        
                    FROM product p
                                LEFT JOIN product_inventory pi ON pi.product_id = p.product_id
                    WHERE p.is_active = 1 AND p.client_id = '1';

SELECT
  t0.client_id AS client_id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.facebook AS facebook_4,
  t0.instagram AS instagram_5,
  t0.platform_type AS platform_type_6,
  t0.website AS website_7,
  t0.slogan AS slogan_8,
  t0.email AS email_9,
  t0.phones AS phones_10,
  t0.whatsapp_active AS whatsapp_active_11,
  t0.whatsapp_phone AS whatsapp_phone_12,
  t0.only_customers_registered AS only_customers_registered_13,
  t0.about_us AS about_us_14,
  t0.chat_widget AS chat_widget_15,
  t0.has_locations AS has_locations_16,
  t0.location_image AS location_image_17,
  t0.map_center_view AS map_center_view_18,
  t0.map_center_zoom AS map_center_zoom_19,
  t0.has_app AS has_app_20,
  t0.has_web AS has_web_21,
  t0.closed_notice AS closed_notice_22,
  t0.is_active AS is_active_23,
  t0.created_at AS created_at_24,
  t0.allow_sales_closed_store AS allow_sales_closed_store_25,
  t0.invitation_message_create_account AS invitation_message_create_account_26,
  t0.welcome_message_new_users AS welcome_message_new_users_27,
  t0.is_payment_prod AS is_payment_prod_28,
  t0.slug AS slug_29,
  t0.service_fee AS service_fee_30,
  t0.currency_id AS currency_id_31,
  t0.country_id AS country_id_32,
  t0.created_by AS created_by_33
FROM
  client t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.client_id AS client_id_1, t0.name AS name_2, t0.address AS address_3, t0.facebook AS facebook_4, t0.instagram AS instagram_5, t0.platform_type AS platform_type_6, t0.website AS website_7, t0.slogan AS slogan_8, t0.email AS email_9, t0.phones AS phones_10, t0.whatsapp_active AS whatsapp_active_11, t0.whatsapp_phone AS whatsapp_phone_12, t0.only_customers_registered AS only_customers_registered_13, t0.about_us AS about_us_14, t0.chat_widget AS chat_widget_15, t0.has_locations AS has_locations_16, t0.location_image AS location_image_17, t0.map_center_view AS map_center_view_18, t0.map_center_zoom AS map_center_zoom_19, t0.has_app AS has_app_20, t0.has_web AS has_web_21, t0.closed_notice AS closed_notice_22, t0.is_active AS is_active_23, t0.created_at AS created_at_24, t0.allow_sales_closed_store AS allow_sales_closed_store_25, t0.invitation_message_create_account AS invitation_message_create_account_26, t0.welcome_message_new_users AS welcome_message_new_users_27, t0.is_payment_prod AS is_payment_prod_28, t0.slug AS slug_29, t0.service_fee AS service_fee_30, t0.currency_id AS currency_id_31, t0.country_id AS country_id_32, t0.created_by AS created_by_33 FROM client t0 WHERE t0.slug = 'teatro' LIMIT 1;

SELECT
  t0.web_setting_id AS web_setting_id_1,
  t0.main_title AS main_title_2,
  t0.main_subtitle AS main_subtitle_3,
  t0.category_title AS category_title_4,
  t0.category_subtitle AS category_subtitle_5,
  t0.brand_title AS brand_title_6,
  t0.brand_subtitle AS brand_subtitle_7,
  t0.blog_title AS blog_title_8,
  t0.blog_subtitle AS blog_subtitle_9,
  t0.brand_menu_featured AS brand_menu_featured_10,
  t0.brand_menu_title AS brand_menu_title_11,
  t0.category_menu_featured AS category_menu_featured_12,
  t0.category_menu_title AS category_menu_title_13,
  t0.main_color AS main_color_14,
  t0.background_color AS background_color_15,
  t0.logo_path AS logo_path_16,
  t0.client_id AS client_id_17,
  t0.menu_style_id AS menu_style_id_18
FROM
  web_setting t0
WHERE
  t0.client_id = ?
LIMIT
  1

SELECT t0.web_setting_id AS web_setting_id_1, t0.main_title AS main_title_2, t0.main_subtitle AS main_subtitle_3, t0.category_title AS category_title_4, t0.category_subtitle AS category_subtitle_5, t0.brand_title AS brand_title_6, t0.brand_subtitle AS brand_subtitle_7, t0.blog_title AS blog_title_8, t0.blog_subtitle AS blog_subtitle_9, t0.brand_menu_featured AS brand_menu_featured_10, t0.brand_menu_title AS brand_menu_title_11, t0.category_menu_featured AS category_menu_featured_12, t0.category_menu_title AS category_menu_title_13, t0.main_color AS main_color_14, t0.background_color AS background_color_15, t0.logo_path AS logo_path_16, t0.client_id AS client_id_17, t0.menu_style_id AS menu_style_id_18 FROM web_setting t0 WHERE t0.client_id = 1 LIMIT 1;

SELECT
  t0.settings_id AS settings_id_1,
  t0.background_home AS background_home_2,
  t0.logo_path AS logo_path_3,
  t0.logo_size AS logo_size_4,
  t0.primary_color AS primary_color_5,
  t0.secondary_color AS secondary_color_6,
  t0.tertiary_color AS tertiary_color_7,
  t0.menu_style AS menu_style_8,
  t0.cart_page_title AS cart_page_title_9,
  t0.item_list_page_title AS item_list_page_title_10,
  t0.cart_add_btn AS cart_add_btn_11,
  t0.cart_finish_btn_label AS cart_finish_btn_label_12,
  t0.cart_text_confirm AS cart_text_confirm_13,
  t0.cart_confirm_btn_label AS cart_confirm_btn_label_14,
  t0.cart_order_success_text AS cart_order_success_text_15,
  t0.cart_hide_empty_stock AS cart_hide_empty_stock_16,
  t0.cart_amount_free_shipping AS cart_amount_free_shipping_17,
  t0.cart_allow_coupon_whith_offers AS cart_allow_coupon_whith_offers_18,
  t0.direct_add_btn AS direct_add_btn_19,
  t0.direct_page_title AS direct_page_title_20,
  t0.direct_text_confirm AS direct_text_confirm_21,
  t0.direct_confirm_btn_label AS direct_confirm_btn_label_22,
  t0.cart_minimun_purchase AS cart_minimun_purchase_23,
  t0.direct_success_text AS direct_success_text_24,
  t0.closed_notice AS closed_notice_25,
  t0.logo_width AS logo_width_26,
  t0.email_notification_order AS email_notification_order_27,
  t0.email_notification_inventory AS email_notification_inventory_28,
  t0.time_notification_inventory AS time_notification_inventory_29,
  t0.template_confirmation_orders AS template_confirmation_orders_30,
  t0.template_alert_inventory AS template_alert_inventory_31,
  t0.direct_template_confirmation_orders AS direct_template_confirmation_orders_32,
  t0.direct_email_notification_order AS direct_email_notification_order_33,
  t0.minimum_stock_alert_inventory AS minimum_stock_alert_inventory_34,
  t0.client_id AS client_id_35,
  t0.cart_style_id AS cart_style_id_36,
  t0.category_style_id AS category_style_id_37,
  t0.subcategory_style_id AS subcategory_style_id_38,
  t0.cart_field_list_id AS cart_field_list_id_39,
  t0.closed_cart_field_list_id AS closed_cart_field_list_id_40,
  t0.closed_direct_field_list_id AS closed_direct_field_list_id_41
FROM
  setting t0
WHERE
  t0.client_id = ?
LIMIT
  1

SELECT t0.settings_id AS settings_id_1, t0.background_home AS background_home_2, t0.logo_path AS logo_path_3, t0.logo_size AS logo_size_4, t0.primary_color AS primary_color_5, t0.secondary_color AS secondary_color_6, t0.tertiary_color AS tertiary_color_7, t0.menu_style AS menu_style_8, t0.cart_page_title AS cart_page_title_9, t0.item_list_page_title AS item_list_page_title_10, t0.cart_add_btn AS cart_add_btn_11, t0.cart_finish_btn_label AS cart_finish_btn_label_12, t0.cart_text_confirm AS cart_text_confirm_13, t0.cart_confirm_btn_label AS cart_confirm_btn_label_14, t0.cart_order_success_text AS cart_order_success_text_15, t0.cart_hide_empty_stock AS cart_hide_empty_stock_16, t0.cart_amount_free_shipping AS cart_amount_free_shipping_17, t0.cart_allow_coupon_whith_offers AS cart_allow_coupon_whith_offers_18, t0.direct_add_btn AS direct_add_btn_19, t0.direct_page_title AS direct_page_title_20, t0.direct_text_confirm AS direct_text_confirm_21, t0.direct_confirm_btn_label AS direct_confirm_btn_label_22, t0.cart_minimun_purchase AS cart_minimun_purchase_23, t0.direct_success_text AS direct_success_text_24, t0.closed_notice AS closed_notice_25, t0.logo_width AS logo_width_26, t0.email_notification_order AS email_notification_order_27, t0.email_notification_inventory AS email_notification_inventory_28, t0.time_notification_inventory AS time_notification_inventory_29, t0.template_confirmation_orders AS template_confirmation_orders_30, t0.template_alert_inventory AS template_alert_inventory_31, t0.direct_template_confirmation_orders AS direct_template_confirmation_orders_32, t0.direct_email_notification_order AS direct_email_notification_order_33, t0.minimum_stock_alert_inventory AS minimum_stock_alert_inventory_34, t0.client_id AS client_id_35, t0.cart_style_id AS cart_style_id_36, t0.category_style_id AS category_style_id_37, t0.subcategory_style_id AS subcategory_style_id_38, t0.cart_field_list_id AS cart_field_list_id_39, t0.closed_cart_field_list_id AS closed_cart_field_list_id_40, t0.closed_direct_field_list_id AS closed_direct_field_list_id_41 FROM setting t0 WHERE t0.client_id = 1 LIMIT 1;

SELECT
  t0.client_id AS client_id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.facebook AS facebook_4,
  t0.instagram AS instagram_5,
  t0.platform_type AS platform_type_6,
  t0.website AS website_7,
  t0.slogan AS slogan_8,
  t0.email AS email_9,
  t0.phones AS phones_10,
  t0.whatsapp_active AS whatsapp_active_11,
  t0.whatsapp_phone AS whatsapp_phone_12,
  t0.only_customers_registered AS only_customers_registered_13,
  t0.about_us AS about_us_14,
  t0.chat_widget AS chat_widget_15,
  t0.has_locations AS has_locations_16,
  t0.location_image AS location_image_17,
  t0.map_center_view AS map_center_view_18,
  t0.map_center_zoom AS map_center_zoom_19,
  t0.has_app AS has_app_20,
  t0.has_web AS has_web_21,
  t0.closed_notice AS closed_notice_22,
  t0.is_active AS is_active_23,
  t0.created_at AS created_at_24,
  t0.allow_sales_closed_store AS allow_sales_closed_store_25,
  t0.invitation_message_create_account AS invitation_message_create_account_26,
  t0.welcome_message_new_users AS welcome_message_new_users_27,
  t0.is_payment_prod AS is_payment_prod_28,
  t0.slug AS slug_29,
  t0.service_fee AS service_fee_30,
  t0.currency_id AS currency_id_31,
  t0.country_id AS country_id_32,
  t0.created_by AS created_by_33
FROM
  client t0
WHERE
  t0.client_id = ?
LIMIT
  1

SELECT t0.client_id AS client_id_1, t0.name AS name_2, t0.address AS address_3, t0.facebook AS facebook_4, t0.instagram AS instagram_5, t0.platform_type AS platform_type_6, t0.website AS website_7, t0.slogan AS slogan_8, t0.email AS email_9, t0.phones AS phones_10, t0.whatsapp_active AS whatsapp_active_11, t0.whatsapp_phone AS whatsapp_phone_12, t0.only_customers_registered AS only_customers_registered_13, t0.about_us AS about_us_14, t0.chat_widget AS chat_widget_15, t0.has_locations AS has_locations_16, t0.location_image AS location_image_17, t0.map_center_view AS map_center_view_18, t0.map_center_zoom AS map_center_zoom_19, t0.has_app AS has_app_20, t0.has_web AS has_web_21, t0.closed_notice AS closed_notice_22, t0.is_active AS is_active_23, t0.created_at AS created_at_24, t0.allow_sales_closed_store AS allow_sales_closed_store_25, t0.invitation_message_create_account AS invitation_message_create_account_26, t0.welcome_message_new_users AS welcome_message_new_users_27, t0.is_payment_prod AS is_payment_prod_28, t0.slug AS slug_29, t0.service_fee AS service_fee_30, t0.currency_id AS currency_id_31, t0.country_id AS country_id_32, t0.created_by AS created_by_33 FROM client t0 WHERE t0.client_id = 1 LIMIT 1;

SELECT
  (
    select
      count(*)
    from
      product
    where
      category_id = c.category_id
      AND product.is_active = 1
      AND product.client_id = '1'
  ) as category_count,
  (
    select
      count(*)
    from
      subcategory
    where
      category_id = c.category_id
  ) as subcategory_count,
  c.*
FROM
  category c
WHERE
  is_active = 1
  AND featured = 1
  AND is_deleted <> 1
  AND client_id = '1'

SELECT 
                    (select count(*) from product where category_id = c.category_id AND product.is_active = 1 AND product.client_id = '1') as category_count,
                    (select count(*) from subcategory where category_id = c.category_id ) as subcategory_count,                    					
                    c.* 					
                        FROM category c 					
                            WHERE is_active = 1
                            AND featured = 1 
                            AND is_deleted <> 1 AND client_id = '1';

SELECT
  t0.subcategory_id AS subcategory_id_1,
  t0.is_active AS is_active_2,
  t0.name AS name_3,
  t0.image_path AS image_path_4,
  t0.created_at AS created_at_5,
  t0.category_id AS category_id_6,
  t0.client_id AS client_id_7,
  t0.field_list_id AS field_list_id_8,
  t0.created_by AS created_by_9
FROM
  subcategory t0
WHERE
  t0.is_active = ?

SELECT t0.subcategory_id AS subcategory_id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.image_path AS image_path_4, t0.created_at AS created_at_5, t0.category_id AS category_id_6, t0.client_id AS client_id_7, t0.field_list_id AS field_list_id_8, t0.created_by AS created_by_9 FROM subcategory t0 WHERE t0.is_active = 1;

SELECT
  count(*) as product_count
FROM
  product
WHERE
  is_active = 1

SELECT count(*) as product_count FROM product WHERE is_active = 1 ;