Symfony Profiler

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_slide_id AS web_slide_id_1,
  t0.image_path AS image_path_2,
  t0.text_1 AS text_1_3,
  t0.text_1_color AS text_1_color_4,
  t0.text_2 AS text_2_5,
  t0.text_2_color AS text_2_color_6,
  t0.text_3 AS text_3_7,
  t0.text_3_color AS text_3_color_8,
  t0.text_alignment AS text_alignment_9,
  t0.created_at AS created_at_10,
  t0.is_active AS is_active_11,
  t0.gradient_higher AS gradient_higher_12,
  t0.gradient_lower AS gradient_lower_13,
  t0.client_id AS client_id_14,
  t0.created_by AS created_by_15
FROM
  web_slide t0
WHERE
  t0.client_id = ?
  AND t0.is_active = ?

SELECT t0.web_slide_id AS web_slide_id_1, t0.image_path AS image_path_2, t0.text_1 AS text_1_3, t0.text_1_color AS text_1_color_4, t0.text_2 AS text_2_5, t0.text_2_color AS text_2_color_6, t0.text_3 AS text_3_7, t0.text_3_color AS text_3_color_8, t0.text_alignment AS text_alignment_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.gradient_higher AS gradient_higher_12, t0.gradient_lower AS gradient_lower_13, t0.client_id AS client_id_14, t0.created_by AS created_by_15 FROM web_slide t0 WHERE t0.client_id = 1 AND t0.is_active = 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
  (
    select
      count(*)
    from
      product
    where
      brand_id = c.brand_id
      and product.is_active = 1
      AND product.client_id = '1'
  ) as brand_count,
  c.*
FROM
  brand c
WHERE
  is_active = 1
  AND featured = 1
  AND client_id = '1'

SELECT 
                    (select count(*) from product where brand_id = c.brand_id and product.is_active = 1 AND product.client_id = '1') as brand_count,
                    c.* 					
                        FROM brand c 					
                            WHERE is_active = 1
                            AND featured = 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 
                    (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 = ?
  AND t0.client_id = ?

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 AND t0.client_id = 1;

SELECT
  t0.blog_id AS blog_id_1,
  t0.title AS title_2,
  t0.short_header AS short_header_3,
  t0.short_content AS short_content_4,
  t0.featured AS featured_5,
  t0.video_path AS video_path_6,
  t0.image_path AS image_path_7,
  t0.cover_path AS cover_path_8,
  t0.content_text AS content_text_9,
  t0.content AS content_10,
  t0.is_published AS is_published_11,
  t0.is_active AS is_active_12,
  t0.created_at AS created_at_13,
  t0.client_id AS client_id_14,
  t0.blog_category_id AS blog_category_id_15,
  t0.created_by AS created_by_16
FROM
  blog t0
WHERE
  t0.is_active = ?
  AND t0.is_published = ?
  AND t0.featured = ?
  AND t0.client_id = ?

SELECT t0.blog_id AS blog_id_1, t0.title AS title_2, t0.short_header AS short_header_3, t0.short_content AS short_content_4, t0.featured AS featured_5, t0.video_path AS video_path_6, t0.image_path AS image_path_7, t0.cover_path AS cover_path_8, t0.content_text AS content_text_9, t0.content AS content_10, t0.is_published AS is_published_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.client_id AS client_id_14, t0.blog_category_id AS blog_category_id_15, t0.created_by AS created_by_16 FROM blog t0 WHERE t0.is_active = 1 AND t0.is_published = 1 AND t0.featured = 1 AND t0.client_id = 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 = 12 LIMIT 1;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

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 = 12 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 = ?
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.category_id AS category_id_1,
  t0.name AS name_2,
  t0.image_path AS image_path_3,
  t0.featured AS featured_4,
  t0.featured_menu AS featured_menu_5,
  t0.is_active AS is_active_6,
  t0.is_deleted AS is_deleted_7,
  t0.created_at AS created_at_8,
  t0.client_id AS client_id_9,
  t0.field_list_id AS field_list_id_10,
  t0.created_by AS created_by_11
FROM
  category t0
WHERE
  t0.client_id = ?
  AND t0.is_active = ?
  AND t0.featured_menu = ?

SELECT t0.category_id AS category_id_1, t0.name AS name_2, t0.image_path AS image_path_3, t0.featured AS featured_4, t0.featured_menu AS featured_menu_5, t0.is_active AS is_active_6, t0.is_deleted AS is_deleted_7, t0.created_at AS created_at_8, t0.client_id AS client_id_9, t0.field_list_id AS field_list_id_10, t0.created_by AS created_by_11 FROM category t0 WHERE t0.client_id = 1 AND t0.is_active = 1 AND t0.featured_menu = 1;

SELECT
  *
FROM
  brand
WHERE
  is_active = 1
  AND featured_menu = 1
  AND client_id = '1'
ORDER BY
  name ASC

SELECT * FROM brand WHERE is_active = 1 AND featured_menu = 1 AND client_id = '1' ORDER BY name ASC;