Symfony Profiler

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.subdomain AS subdomain_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8,
  t0.deleted_by_id AS deleted_by_id_9
FROM
  complex t0
WHERE
  t0.subdomain = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.subdomain AS subdomain_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.deleted_by_id AS deleted_by_id_9 FROM complex t0 WHERE t0.subdomain = 'imag' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.tax AS tax_5,
  t0.subdomain AS subdomain_6,
  t0.pms_connection AS pms_connection_7,
  t0.pms_forbidden_email_domains AS pms_forbidden_email_domains_8,
  t0.address1 AS address1_9,
  t0.address2 AS address2_10,
  t0.postal_code AS postal_code_11,
  t0.city AS city_12,
  t0.state AS state_13,
  t0.country AS country_14,
  t0.tin AS tin_15,
  t0.fiscal_name AS fiscal_name_16,
  t0.invoice_serie AS invoice_serie_17,
  t0.reply_to_email AS reply_to_email_18,
  t0.order_emails_to AS order_emails_to_19,
  t0.count_infants_for_restaurant_reserves AS count_infants_for_restaurant_reserves_20,
  t0.errors_muted AS errors_muted_21,
  t0.stripe_publishable_key AS stripe_publishable_key_22,
  t0.stripe_secret_key AS stripe_secret_key_23,
  t0.google_tag_stream_id AS google_tag_stream_id_24,
  t0.google_tag_measurement_id AS google_tag_measurement_id_25,
  t0.restaurant_reserve_home_position AS restaurant_reserve_home_position_26,
  t0.create_ticket_home_position AS create_ticket_home_position_27,
  t0.restaurant_reserve_home_image AS restaurant_reserve_home_image_28,
  t0.create_ticket_home_image AS create_ticket_home_image_29,
  t0.last_pms_updated_at AS last_pms_updated_at_30,
  t0.green_api_active AS green_api_active_31,
  t0.green_api_id AS green_api_id_32,
  t0.green_api_token AS green_api_token_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35,
  t0.created_by_id AS created_by_id_36,
  t0.updated_by_id AS updated_by_id_37,
  t0.deleted_by_id AS deleted_by_id_38,
  t0.complex_id AS complex_id_39,
  t0.blameable_user_id AS blameable_user_id_40,
  t41.deleted_at AS deleted_at_42,
  t41.id AS id_43,
  t41.username AS username_44,
  t41.email AS email_45,
  t41.enabled AS enabled_46,
  t41.password AS password_47,
  t41.first_name AS first_name_48,
  t41.last_name AS last_name_49,
  t41.roles AS roles_50,
  t41.type AS type_51,
  t41.order_ticket_printer AS order_ticket_printer_52,
  t41.restaurant_ticket_printer AS restaurant_ticket_printer_53,
  t41.phone AS phone_54,
  t41.created_at AS created_at_55,
  t41.updated_at AS updated_at_56,
  t41.created_by_id AS created_by_id_57,
  t41.updated_by_id AS updated_by_id_58,
  t41.deleted_by_id AS deleted_by_id_59,
  t0.ticket_call_assigned_user_id AS ticket_call_assigned_user_id_60
FROM
  hotel t0
  INNER JOIN user t41 ON t0.blameable_user_id = t41.id
  AND (
    (t41.deleted_at IS NULL)
  )
WHERE
  t0.subdomain = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.name AS name_3, t0.description AS description_4, t0.tax AS tax_5, t0.subdomain AS subdomain_6, t0.pms_connection AS pms_connection_7, t0.pms_forbidden_email_domains AS pms_forbidden_email_domains_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.postal_code AS postal_code_11, t0.city AS city_12, t0.state AS state_13, t0.country AS country_14, t0.tin AS tin_15, t0.fiscal_name AS fiscal_name_16, t0.invoice_serie AS invoice_serie_17, t0.reply_to_email AS reply_to_email_18, t0.order_emails_to AS order_emails_to_19, t0.count_infants_for_restaurant_reserves AS count_infants_for_restaurant_reserves_20, t0.errors_muted AS errors_muted_21, t0.stripe_publishable_key AS stripe_publishable_key_22, t0.stripe_secret_key AS stripe_secret_key_23, t0.google_tag_stream_id AS google_tag_stream_id_24, t0.google_tag_measurement_id AS google_tag_measurement_id_25, t0.restaurant_reserve_home_position AS restaurant_reserve_home_position_26, t0.create_ticket_home_position AS create_ticket_home_position_27, t0.restaurant_reserve_home_image AS restaurant_reserve_home_image_28, t0.create_ticket_home_image AS create_ticket_home_image_29, t0.last_pms_updated_at AS last_pms_updated_at_30, t0.green_api_active AS green_api_active_31, t0.green_api_id AS green_api_id_32, t0.green_api_token AS green_api_token_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.created_by_id AS created_by_id_36, t0.updated_by_id AS updated_by_id_37, t0.deleted_by_id AS deleted_by_id_38, t0.complex_id AS complex_id_39, t0.blameable_user_id AS blameable_user_id_40, t41.deleted_at AS deleted_at_42, t41.id AS id_43, t41.username AS username_44, t41.email AS email_45, t41.enabled AS enabled_46, t41.password AS password_47, t41.first_name AS first_name_48, t41.last_name AS last_name_49, t41.roles AS roles_50, t41.type AS type_51, t41.order_ticket_printer AS order_ticket_printer_52, t41.restaurant_ticket_printer AS restaurant_ticket_printer_53, t41.phone AS phone_54, t41.created_at AS created_at_55, t41.updated_at AS updated_at_56, t41.created_by_id AS created_by_id_57, t41.updated_by_id AS updated_by_id_58, t41.deleted_by_id AS deleted_by_id_59, t0.ticket_call_assigned_user_id AS ticket_call_assigned_user_id_60 FROM hotel t0 INNER JOIN user t41 ON t0.blameable_user_id = t41.id AND ((t41.deleted_at IS NULL)) WHERE t0.subdomain = 'imag' AND ((t0.deleted_at IS NULL)) LIMIT 1;