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

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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

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
  t0.policy_id AS policy_id_1,
  t0.name AS name_2,
  t0.content_text AS content_text_3,
  t0.policycol AS policycol_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.client_id AS client_id_7,
  t0.created_by AS created_by_8
FROM
  policy t0
WHERE
  t0.is_active = ?
  AND t0.client_id = ?

SELECT t0.policy_id AS policy_id_1, t0.name AS name_2, t0.content_text AS content_text_3, t0.policycol AS policycol_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.client_id AS client_id_7, t0.created_by AS created_by_8 FROM policy t0 WHERE t0.is_active = 1 AND t0.client_id = 1;

SELECT
  t0.brand_id AS brand_id_1,
  t0.name AS name_2,
  t0.image_path AS image_path_3,
  t0.is_active AS is_active_4,
  t0.featured AS featured_5,
  t0.featured_menu AS featured_menu_6,
  t0.created_at AS created_at_7,
  t0.client_id AS client_id_8,
  t0.created_by AS created_by_9
FROM
  brand t0
WHERE
  t0.is_active = ?
  AND t0.client_id = ?

SELECT t0.brand_id AS brand_id_1, t0.name AS name_2, t0.image_path AS image_path_3, t0.is_active AS is_active_4, t0.featured AS featured_5, t0.featured_menu AS featured_menu_6, t0.created_at AS created_at_7, t0.client_id AS client_id_8, t0.created_by AS created_by_9 FROM brand t0 WHERE t0.is_active = 1 AND t0.client_id = 1;

SELECT
  DATABASE()

SELECT DATABASE();