Symfony Profiler

SELECT
  count(*) AS NUMERO
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = 'UVESCO_alejandria_academy_40'
  AND TABLE_NAME = 'alejandria_configuration'

SELECT count(*) AS NUMERO FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'UVESCO_alejandria_academy_40' AND TABLE_NAME = 'alejandria_configuration';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.section AS section_4,
  t0.rank AS rank_5,
  t0.event AS event_6
FROM
  alejandria_configuration t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.section AS section_4, t0.rank AS rank_5, t0.event AS event_6 FROM alejandria_configuration t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.email_naming AS email_naming_4,
  t0.theme AS theme_5,
  t0.color AS color_6,
  t0.text_color AS text_color_7,
  t0.domain AS domain_8,
  t0.is_active AS is_active_9,
  t0.active_user_limit AS active_user_limit_10,
  t0.registered_user_limit AS registered_user_limit_11,
  t0.title AS title_12,
  t0.location AS location_13,
  t0.description AS description_14,
  t0.subdomain AS subdomain_15,
  t0.logo_png_name AS logo_png_name_16,
  t0.logo_svg_name AS logo_svg_name_17,
  t0.icon_name AS icon_name_18,
  t0.logo_transparent_name AS logo_transparent_name_19,
  t0.primary_color AS primary_color_20,
  t0.secondary_color AS secondary_color_21,
  t0.primary_typography AS primary_typography_22,
  t0.secondary_typography AS secondary_typography_23,
  t0.locales AS locales_24,
  t0.is_default AS is_default_25,
  t0.signature_name AS signature_name_26,
  t0.signatory AS signatory_27,
  t0.signatory_position AS signatory_position_28,
  t0.menu_transparency AS menu_transparency_29,
  t0.color_mode AS color_mode_30,
  t0.pre_header_bg AS pre_header_bg_31,
  t0.pre_header_color_mode AS pre_header_color_mode_32,
  t0.header_bg AS header_bg_33,
  t0.header_color_mode AS header_color_mode_34,
  t0.pre_footer_bg AS pre_footer_bg_35,
  t0.footer_color_mode AS footer_color_mode_36,
  t0.footer_bg AS footer_bg_37,
  t0.social_x AS social_x_38,
  t0.social_facebook AS social_facebook_39,
  t0.social_youtube AS social_youtube_40,
  t0.social_instagram AS social_instagram_41,
  t0.social_linkedin AS social_linkedin_42,
  t0.social_tiktok AS social_tiktok_43,
  t0.social_whatsapp AS social_whatsapp_44,
  t0.social_telegram AS social_telegram_45,
  t0.landing_pre_titulo AS landing_pre_titulo_46,
  t0.landing_titulo AS landing_titulo_47,
  t0.landing_descripcion AS landing_descripcion_48,
  t0.compiled_version AS compiled_version_49,
  t0.footer_signature AS footer_signature_50,
  t0.created_at AS created_at_51,
  t0.updated_at AS updated_at_52,
  t0.type_line_id AS type_line_id_53,
  t54.id AS id_55,
  t54.mail_provider AS mail_provider_56,
  t54.mail_api_provider AS mail_api_provider_57,
  t54.mail_from_address AS mail_from_address_58,
  t54.mail_from_name AS mail_from_name_59,
  t54.mail_host AS mail_host_60,
  t54.mail_port AS mail_port_61,
  t54.mail_encryption AS mail_encryption_62,
  t54.mail_username AS mail_username_63,
  t54.mail_password AS mail_password_64,
  t54.mail_api_key AS mail_api_key_65,
  t54.mail_domain AS mail_domain_66,
  t54.mail_region AS mail_region_67,
  t54.mail_aws_secret_key AS mail_aws_secret_key_68,
  t54.sms_provider AS sms_provider_69,
  t54.sms_wsdl_url AS sms_wsdl_url_70,
  t54.sms_username AS sms_username_71,
  t54.sms_password AS sms_password_72,
  t54.created_at AS created_at_73,
  t54.updated_at AS updated_at_74,
  t54.company_id AS company_id_75
FROM
  company t0
  LEFT JOIN company_notification_config t54 ON t54.company_id = t0.id

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.email_naming AS email_naming_4, t0.theme AS theme_5, t0.color AS color_6, t0.text_color AS text_color_7, t0.domain AS domain_8, t0.is_active AS is_active_9, t0.active_user_limit AS active_user_limit_10, t0.registered_user_limit AS registered_user_limit_11, t0.title AS title_12, t0.location AS location_13, t0.description AS description_14, t0.subdomain AS subdomain_15, t0.logo_png_name AS logo_png_name_16, t0.logo_svg_name AS logo_svg_name_17, t0.icon_name AS icon_name_18, t0.logo_transparent_name AS logo_transparent_name_19, t0.primary_color AS primary_color_20, t0.secondary_color AS secondary_color_21, t0.primary_typography AS primary_typography_22, t0.secondary_typography AS secondary_typography_23, t0.locales AS locales_24, t0.is_default AS is_default_25, t0.signature_name AS signature_name_26, t0.signatory AS signatory_27, t0.signatory_position AS signatory_position_28, t0.menu_transparency AS menu_transparency_29, t0.color_mode AS color_mode_30, t0.pre_header_bg AS pre_header_bg_31, t0.pre_header_color_mode AS pre_header_color_mode_32, t0.header_bg AS header_bg_33, t0.header_color_mode AS header_color_mode_34, t0.pre_footer_bg AS pre_footer_bg_35, t0.footer_color_mode AS footer_color_mode_36, t0.footer_bg AS footer_bg_37, t0.social_x AS social_x_38, t0.social_facebook AS social_facebook_39, t0.social_youtube AS social_youtube_40, t0.social_instagram AS social_instagram_41, t0.social_linkedin AS social_linkedin_42, t0.social_tiktok AS social_tiktok_43, t0.social_whatsapp AS social_whatsapp_44, t0.social_telegram AS social_telegram_45, t0.landing_pre_titulo AS landing_pre_titulo_46, t0.landing_titulo AS landing_titulo_47, t0.landing_descripcion AS landing_descripcion_48, t0.compiled_version AS compiled_version_49, t0.footer_signature AS footer_signature_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.type_line_id AS type_line_id_53, t54.id AS id_55, t54.mail_provider AS mail_provider_56, t54.mail_api_provider AS mail_api_provider_57, t54.mail_from_address AS mail_from_address_58, t54.mail_from_name AS mail_from_name_59, t54.mail_host AS mail_host_60, t54.mail_port AS mail_port_61, t54.mail_encryption AS mail_encryption_62, t54.mail_username AS mail_username_63, t54.mail_password AS mail_password_64, t54.mail_api_key AS mail_api_key_65, t54.mail_domain AS mail_domain_66, t54.mail_region AS mail_region_67, t54.mail_aws_secret_key AS mail_aws_secret_key_68, t54.sms_provider AS sms_provider_69, t54.sms_wsdl_url AS sms_wsdl_url_70, t54.sms_username AS sms_username_71, t54.sms_password AS sms_password_72, t54.created_at AS created_at_73, t54.updated_at AS updated_at_74, t54.company_id AS company_id_75 FROM company t0 LEFT JOIN company_notification_config t54 ON t54.company_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.email_naming AS email_naming_4,
  t0.theme AS theme_5,
  t0.color AS color_6,
  t0.text_color AS text_color_7,
  t0.domain AS domain_8,
  t0.is_active AS is_active_9,
  t0.active_user_limit AS active_user_limit_10,
  t0.registered_user_limit AS registered_user_limit_11,
  t0.title AS title_12,
  t0.location AS location_13,
  t0.description AS description_14,
  t0.subdomain AS subdomain_15,
  t0.logo_png_name AS logo_png_name_16,
  t0.logo_svg_name AS logo_svg_name_17,
  t0.icon_name AS icon_name_18,
  t0.logo_transparent_name AS logo_transparent_name_19,
  t0.primary_color AS primary_color_20,
  t0.secondary_color AS secondary_color_21,
  t0.primary_typography AS primary_typography_22,
  t0.secondary_typography AS secondary_typography_23,
  t0.locales AS locales_24,
  t0.is_default AS is_default_25,
  t0.signature_name AS signature_name_26,
  t0.signatory AS signatory_27,
  t0.signatory_position AS signatory_position_28,
  t0.menu_transparency AS menu_transparency_29,
  t0.color_mode AS color_mode_30,
  t0.pre_header_bg AS pre_header_bg_31,
  t0.pre_header_color_mode AS pre_header_color_mode_32,
  t0.header_bg AS header_bg_33,
  t0.header_color_mode AS header_color_mode_34,
  t0.pre_footer_bg AS pre_footer_bg_35,
  t0.footer_color_mode AS footer_color_mode_36,
  t0.footer_bg AS footer_bg_37,
  t0.social_x AS social_x_38,
  t0.social_facebook AS social_facebook_39,
  t0.social_youtube AS social_youtube_40,
  t0.social_instagram AS social_instagram_41,
  t0.social_linkedin AS social_linkedin_42,
  t0.social_tiktok AS social_tiktok_43,
  t0.social_whatsapp AS social_whatsapp_44,
  t0.social_telegram AS social_telegram_45,
  t0.landing_pre_titulo AS landing_pre_titulo_46,
  t0.landing_titulo AS landing_titulo_47,
  t0.landing_descripcion AS landing_descripcion_48,
  t0.compiled_version AS compiled_version_49,
  t0.footer_signature AS footer_signature_50,
  t0.created_at AS created_at_51,
  t0.updated_at AS updated_at_52,
  t0.type_line_id AS type_line_id_53,
  t54.id AS id_55,
  t54.mail_provider AS mail_provider_56,
  t54.mail_api_provider AS mail_api_provider_57,
  t54.mail_from_address AS mail_from_address_58,
  t54.mail_from_name AS mail_from_name_59,
  t54.mail_host AS mail_host_60,
  t54.mail_port AS mail_port_61,
  t54.mail_encryption AS mail_encryption_62,
  t54.mail_username AS mail_username_63,
  t54.mail_password AS mail_password_64,
  t54.mail_api_key AS mail_api_key_65,
  t54.mail_domain AS mail_domain_66,
  t54.mail_region AS mail_region_67,
  t54.mail_aws_secret_key AS mail_aws_secret_key_68,
  t54.sms_provider AS sms_provider_69,
  t54.sms_wsdl_url AS sms_wsdl_url_70,
  t54.sms_username AS sms_username_71,
  t54.sms_password AS sms_password_72,
  t54.created_at AS created_at_73,
  t54.updated_at AS updated_at_74,
  t54.company_id AS company_id_75
FROM
  company t0
  LEFT JOIN company_notification_config t54 ON t54.company_id = t0.id
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.email_naming AS email_naming_4, t0.theme AS theme_5, t0.color AS color_6, t0.text_color AS text_color_7, t0.domain AS domain_8, t0.is_active AS is_active_9, t0.active_user_limit AS active_user_limit_10, t0.registered_user_limit AS registered_user_limit_11, t0.title AS title_12, t0.location AS location_13, t0.description AS description_14, t0.subdomain AS subdomain_15, t0.logo_png_name AS logo_png_name_16, t0.logo_svg_name AS logo_svg_name_17, t0.icon_name AS icon_name_18, t0.logo_transparent_name AS logo_transparent_name_19, t0.primary_color AS primary_color_20, t0.secondary_color AS secondary_color_21, t0.primary_typography AS primary_typography_22, t0.secondary_typography AS secondary_typography_23, t0.locales AS locales_24, t0.is_default AS is_default_25, t0.signature_name AS signature_name_26, t0.signatory AS signatory_27, t0.signatory_position AS signatory_position_28, t0.menu_transparency AS menu_transparency_29, t0.color_mode AS color_mode_30, t0.pre_header_bg AS pre_header_bg_31, t0.pre_header_color_mode AS pre_header_color_mode_32, t0.header_bg AS header_bg_33, t0.header_color_mode AS header_color_mode_34, t0.pre_footer_bg AS pre_footer_bg_35, t0.footer_color_mode AS footer_color_mode_36, t0.footer_bg AS footer_bg_37, t0.social_x AS social_x_38, t0.social_facebook AS social_facebook_39, t0.social_youtube AS social_youtube_40, t0.social_instagram AS social_instagram_41, t0.social_linkedin AS social_linkedin_42, t0.social_tiktok AS social_tiktok_43, t0.social_whatsapp AS social_whatsapp_44, t0.social_telegram AS social_telegram_45, t0.landing_pre_titulo AS landing_pre_titulo_46, t0.landing_titulo AS landing_titulo_47, t0.landing_descripcion AS landing_descripcion_48, t0.compiled_version AS compiled_version_49, t0.footer_signature AS footer_signature_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.type_line_id AS type_line_id_53, t54.id AS id_55, t54.mail_provider AS mail_provider_56, t54.mail_api_provider AS mail_api_provider_57, t54.mail_from_address AS mail_from_address_58, t54.mail_from_name AS mail_from_name_59, t54.mail_host AS mail_host_60, t54.mail_port AS mail_port_61, t54.mail_encryption AS mail_encryption_62, t54.mail_username AS mail_username_63, t54.mail_password AS mail_password_64, t54.mail_api_key AS mail_api_key_65, t54.mail_domain AS mail_domain_66, t54.mail_region AS mail_region_67, t54.mail_aws_secret_key AS mail_aws_secret_key_68, t54.sms_provider AS sms_provider_69, t54.sms_wsdl_url AS sms_wsdl_url_70, t54.sms_username AS sms_username_71, t54.sms_password AS sms_password_72, t54.created_at AS created_at_73, t54.updated_at AS updated_at_74, t54.company_id AS company_id_75 FROM company t0 LEFT JOIN company_notification_config t54 ON t54.company_id = t0.id WHERE t0.is_default = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.description AS description_4,
  t0.canonical AS canonical_5,
  t0.robots AS robots_6,
  t0.route AS route_7,
  t0.use_route AS use_route_8,
  t0.hreflang AS hreflang_9,
  t0.company_id AS company_id_10
FROM
  seo t0
WHERE
  t0.company_id = ?
  AND t0.route = ?
  AND t0.use_route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.description AS description_4, t0.canonical AS canonical_5, t0.robots AS robots_6, t0.route AS route_7, t0.use_route AS use_route_8, t0.hreflang AS hreflang_9, t0.company_id AS company_id_10 FROM seo t0 WHERE t0.company_id = 1 AND t0.route = 'login' AND t0.use_route = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.rank AS rank_2,
  t0.is_active AS is_active_3,
  t0.is_open AS is_open_4,
  t0.color AS color_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.parent AS parent_8,
  t0.category_group_id AS category_group_id_9,
  t0.image_home_id AS image_home_id_10,
  t0.image_section_id AS image_section_id_11,
  t0.image_icon_id AS image_icon_id_12
FROM
  category t0

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.is_active AS is_active_3, t0.is_open AS is_open_4, t0.color AS color_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent AS parent_8, t0.category_group_id AS category_group_id_9, t0.image_home_id AS image_home_id_10, t0.image_section_id AS image_section_id_11, t0.image_icon_id AS image_icon_id_12 FROM category t0;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.is_active AS is_active_2,
  m0_.locales AS locales_3,
  m0_.location AS location_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  m0_.company_id AS company_id_7
FROM
  menu m0_
WHERE
  m0_.company_id = ?
  AND m0_.location LIKE ?
  AND m0_.is_active = 1
  AND (
    m0_.locales LIKE ?
    OR m0_.locales LIKE '%all%'
  )

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_active AS is_active_2, m0_.locales AS locales_3, m0_.location AS location_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.company_id AS company_id_7 FROM menu m0_ WHERE m0_.company_id = 1 AND m0_.location LIKE '%s:6:\"header\";%' AND m0_.is_active = 1 AND (m0_.locales LIKE '%es%' OR m0_.locales LIKE '%all%');

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.is_active AS is_active_2,
  m0_.locales AS locales_3,
  m0_.location AS location_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  m0_.company_id AS company_id_7
FROM
  menu m0_
WHERE
  m0_.company_id = ?
  AND m0_.location LIKE ?
  AND m0_.is_active = 1
  AND (
    m0_.locales LIKE ?
    OR m0_.locales LIKE '%all%'
  )

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_active AS is_active_2, m0_.locales AS locales_3, m0_.location AS location_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.company_id AS company_id_7 FROM menu m0_ WHERE m0_.company_id = 1 AND m0_.location LIKE '%s:6:\"footer\";%' AND m0_.is_active = 1 AND (m0_.locales LIKE '%es%' OR m0_.locales LIKE '%all%');