Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.maximal_area AS maximal_area_1,
  p0_.minimal_area AS minimal_area_2,
  p0_.minimal_price AS minimal_price_3,
  p0_.maximum_price AS maximum_price_4,
  p0_.rooms_number AS rooms_number_5,
  p0_.is_available AS is_available_6,
  p0_.date_availability AS date_availability_7,
  p0_.construction_year AS construction_year_8,
  p0_.floors_number AS floors_number_9,
  p0_.is_furnished AS is_furnished_10,
  p0_.has_guardian AS has_guardian_11,
  p0_.has_intercom AS has_intercom_12,
  p0_.has_elevator AS has_elevator_13,
  p0_.has_terrace AS has_terrace_14,
  p0_.has_balcony AS has_balcony_15,
  p0_.has_garage AS has_garage_16,
  p0_.has_park_car AS has_park_car_17,
  p0_.has_park_car_outside AS has_park_car_outside_18,
  p0_.has_cellar AS has_cellar_19,
  p0_.has_basement AS has_basement_20,
  p0_.has_bathroom AS has_bathroom_21,
  p0_.description AS description_22,
  p0_.archived_at AS archived_at_23,
  p0_.property_title_number AS property_title_number_24,
  p0_.booking_number AS booking_number_25,
  p0_.floor AS floor_26,
  p0_.bathroom_number AS bathroom_number_27,
  p0_.number_of_rooms AS number_of_rooms_28,
  p0_.number_of_pieces AS number_of_pieces_29,
  p0_.reference AS reference_30,
  p0_.is_shared AS is_shared_31,
  p0_.has_titled_parking AS has_titled_parking_32,
  p0_.parking_area AS parking_area_33,
  p0_.has_mezzanine AS has_mezzanine_34,
  p0_.mezzanine_area AS mezzanine_area_35,
  p0_.description_mandate AS description_mandate_36,
  p0_.is_short_term_rental AS is_short_term_rental_37,
  p0_.date_start_rental AS date_start_rental_38,
  p0_.date_end_rental AS date_end_rental_39,
  p0_.video_link AS video_link_40,
  p0_.created_at AS created_at_41,
  p0_.updated_at AS updated_at_42,
  p0_.property_address_id AS property_address_id_43,
  p0_.collaborator_id AS collaborator_id_44,
  p0_.contact_id AS contact_id_45,
  p0_.prescriber_id AS prescriber_id_46,
  p0_.manager_id AS manager_id_47,
  p0_.reference_property_domain_id AS reference_property_domain_id_48,
  p0_.refrence_property_state_id AS refrence_property_state_id_49,
  p0_.reference_property_contract_type_id AS reference_property_contract_type_id_50,
  p0_.reference_property_land_type_id AS reference_property_land_type_id_51,
  p0_.reference_property_destination_id AS reference_property_destination_id_52,
  p0_.reference_property_construction_type_id AS reference_property_construction_type_id_53,
  p0_.reference_property_orientation_type_id AS reference_property_orientation_type_id_54,
  p0_.reference_property_status_id AS reference_property_status_id_55,
  p0_.reference_service_type_id AS reference_service_type_id_56,
  p0_.reference_property_type_id AS reference_property_type_id_57,
  p0_.recommendation_id AS recommendation_id_58
FROM
  property p0_
  INNER JOIN reference_property_status r1_ ON p0_.reference_property_status_id = r1_.id
  LEFT JOIN property_property_diffusion_mode_reference p3_ ON p0_.id = p3_.property_id
  LEFT JOIN property_diffusion_mode_reference p2_ ON p2_.id = p3_.property_diffusion_mode_reference_id
  LEFT JOIN reference_property_service_type r4_ ON p0_.reference_service_type_id = r4_.id
WHERE
  r1_.code IN (?, ?, ?)
  AND p2_.code IS NOT NULL
  AND p2_.code NOT LIKE ?
  AND r4_.code IN (?, ?)
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.maximal_area AS maximal_area_1, p0_.minimal_area AS minimal_area_2, p0_.minimal_price AS minimal_price_3, p0_.maximum_price AS maximum_price_4, p0_.rooms_number AS rooms_number_5, p0_.is_available AS is_available_6, p0_.date_availability AS date_availability_7, p0_.construction_year AS construction_year_8, p0_.floors_number AS floors_number_9, p0_.is_furnished AS is_furnished_10, p0_.has_guardian AS has_guardian_11, p0_.has_intercom AS has_intercom_12, p0_.has_elevator AS has_elevator_13, p0_.has_terrace AS has_terrace_14, p0_.has_balcony AS has_balcony_15, p0_.has_garage AS has_garage_16, p0_.has_park_car AS has_park_car_17, p0_.has_park_car_outside AS has_park_car_outside_18, p0_.has_cellar AS has_cellar_19, p0_.has_basement AS has_basement_20, p0_.has_bathroom AS has_bathroom_21, p0_.description AS description_22, p0_.archived_at AS archived_at_23, p0_.property_title_number AS property_title_number_24, p0_.booking_number AS booking_number_25, p0_.floor AS floor_26, p0_.bathroom_number AS bathroom_number_27, p0_.number_of_rooms AS number_of_rooms_28, p0_.number_of_pieces AS number_of_pieces_29, p0_.reference AS reference_30, p0_.is_shared AS is_shared_31, p0_.has_titled_parking AS has_titled_parking_32, p0_.parking_area AS parking_area_33, p0_.has_mezzanine AS has_mezzanine_34, p0_.mezzanine_area AS mezzanine_area_35, p0_.description_mandate AS description_mandate_36, p0_.is_short_term_rental AS is_short_term_rental_37, p0_.date_start_rental AS date_start_rental_38, p0_.date_end_rental AS date_end_rental_39, p0_.video_link AS video_link_40, p0_.created_at AS created_at_41, p0_.updated_at AS updated_at_42, p0_.property_address_id AS property_address_id_43, p0_.collaborator_id AS collaborator_id_44, p0_.contact_id AS contact_id_45, p0_.prescriber_id AS prescriber_id_46, p0_.manager_id AS manager_id_47, p0_.reference_property_domain_id AS reference_property_domain_id_48, p0_.refrence_property_state_id AS refrence_property_state_id_49, p0_.reference_property_contract_type_id AS reference_property_contract_type_id_50, p0_.reference_property_land_type_id AS reference_property_land_type_id_51, p0_.reference_property_destination_id AS reference_property_destination_id_52, p0_.reference_property_construction_type_id AS reference_property_construction_type_id_53, p0_.reference_property_orientation_type_id AS reference_property_orientation_type_id_54, p0_.reference_property_status_id AS reference_property_status_id_55, p0_.reference_service_type_id AS reference_service_type_id_56, p0_.reference_property_type_id AS reference_property_type_id_57, p0_.recommendation_id AS recommendation_id_58 FROM property p0_ INNER JOIN reference_property_status r1_ ON p0_.reference_property_status_id = r1_.id LEFT JOIN property_property_diffusion_mode_reference p3_ ON p0_.id = p3_.property_id LEFT JOIN property_diffusion_mode_reference p2_ ON p2_.id = p3_.property_diffusion_mode_reference_id LEFT JOIN reference_property_service_type r4_ ON p0_.reference_service_type_id = r4_.id WHERE r1_.code IN ('10', '0', '2') AND p2_.code IS NOT NULL AND p2_.code NOT LIKE 'NONE' AND r4_.code IN ('2', '3') ORDER BY p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.first_address AS first_address_2,
  t0.second_address AS second_address_3,
  t0.zip_code AS zip_code_4,
  t0.city_id AS city_id_5,
  t6.id AS id_7,
  t6.maximal_area AS maximal_area_8,
  t6.minimal_area AS minimal_area_9,
  t6.minimal_price AS minimal_price_10,
  t6.maximum_price AS maximum_price_11,
  t6.rooms_number AS rooms_number_12,
  t6.is_available AS is_available_13,
  t6.date_availability AS date_availability_14,
  t6.construction_year AS construction_year_15,
  t6.floors_number AS floors_number_16,
  t6.is_furnished AS is_furnished_17,
  t6.has_guardian AS has_guardian_18,
  t6.has_intercom AS has_intercom_19,
  t6.has_elevator AS has_elevator_20,
  t6.has_terrace AS has_terrace_21,
  t6.has_balcony AS has_balcony_22,
  t6.has_garage AS has_garage_23,
  t6.has_park_car AS has_park_car_24,
  t6.has_park_car_outside AS has_park_car_outside_25,
  t6.has_cellar AS has_cellar_26,
  t6.has_basement AS has_basement_27,
  t6.has_bathroom AS has_bathroom_28,
  t6.description AS description_29,
  t6.archived_at AS archived_at_30,
  t6.property_title_number AS property_title_number_31,
  t6.booking_number AS booking_number_32,
  t6.floor AS floor_33,
  t6.bathroom_number AS bathroom_number_34,
  t6.number_of_rooms AS number_of_rooms_35,
  t6.number_of_pieces AS number_of_pieces_36,
  t6.reference AS reference_37,
  t6.is_shared AS is_shared_38,
  t6.has_titled_parking AS has_titled_parking_39,
  t6.parking_area AS parking_area_40,
  t6.has_mezzanine AS has_mezzanine_41,
  t6.mezzanine_area AS mezzanine_area_42,
  t6.description_mandate AS description_mandate_43,
  t6.is_short_term_rental AS is_short_term_rental_44,
  t6.date_start_rental AS date_start_rental_45,
  t6.date_end_rental AS date_end_rental_46,
  t6.video_link AS video_link_47,
  t6.created_at AS created_at_48,
  t6.updated_at AS updated_at_49,
  t6.property_address_id AS property_address_id_50,
  t6.collaborator_id AS collaborator_id_51,
  t6.contact_id AS contact_id_52,
  t6.prescriber_id AS prescriber_id_53,
  t6.manager_id AS manager_id_54,
  t6.reference_property_domain_id AS reference_property_domain_id_55,
  t6.refrence_property_state_id AS refrence_property_state_id_56,
  t6.reference_property_contract_type_id AS reference_property_contract_type_id_57,
  t6.reference_property_land_type_id AS reference_property_land_type_id_58,
  t6.reference_property_destination_id AS reference_property_destination_id_59,
  t6.reference_property_construction_type_id AS reference_property_construction_type_id_60,
  t6.reference_property_orientation_type_id AS reference_property_orientation_type_id_61,
  t6.reference_property_status_id AS reference_property_status_id_62,
  t6.reference_service_type_id AS reference_service_type_id_63,
  t6.reference_property_type_id AS reference_property_type_id_64,
  t6.recommendation_id AS recommendation_id_65,
  t0.neighborhood_id AS neighborhood_id_66
FROM
  property_address t0
  LEFT JOIN property t6 ON t6.property_address_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_address AS first_address_2, t0.second_address AS second_address_3, t0.zip_code AS zip_code_4, t0.city_id AS city_id_5, t6.id AS id_7, t6.maximal_area AS maximal_area_8, t6.minimal_area AS minimal_area_9, t6.minimal_price AS minimal_price_10, t6.maximum_price AS maximum_price_11, t6.rooms_number AS rooms_number_12, t6.is_available AS is_available_13, t6.date_availability AS date_availability_14, t6.construction_year AS construction_year_15, t6.floors_number AS floors_number_16, t6.is_furnished AS is_furnished_17, t6.has_guardian AS has_guardian_18, t6.has_intercom AS has_intercom_19, t6.has_elevator AS has_elevator_20, t6.has_terrace AS has_terrace_21, t6.has_balcony AS has_balcony_22, t6.has_garage AS has_garage_23, t6.has_park_car AS has_park_car_24, t6.has_park_car_outside AS has_park_car_outside_25, t6.has_cellar AS has_cellar_26, t6.has_basement AS has_basement_27, t6.has_bathroom AS has_bathroom_28, t6.description AS description_29, t6.archived_at AS archived_at_30, t6.property_title_number AS property_title_number_31, t6.booking_number AS booking_number_32, t6.floor AS floor_33, t6.bathroom_number AS bathroom_number_34, t6.number_of_rooms AS number_of_rooms_35, t6.number_of_pieces AS number_of_pieces_36, t6.reference AS reference_37, t6.is_shared AS is_shared_38, t6.has_titled_parking AS has_titled_parking_39, t6.parking_area AS parking_area_40, t6.has_mezzanine AS has_mezzanine_41, t6.mezzanine_area AS mezzanine_area_42, t6.description_mandate AS description_mandate_43, t6.is_short_term_rental AS is_short_term_rental_44, t6.date_start_rental AS date_start_rental_45, t6.date_end_rental AS date_end_rental_46, t6.video_link AS video_link_47, t6.created_at AS created_at_48, t6.updated_at AS updated_at_49, t6.property_address_id AS property_address_id_50, t6.collaborator_id AS collaborator_id_51, t6.contact_id AS contact_id_52, t6.prescriber_id AS prescriber_id_53, t6.manager_id AS manager_id_54, t6.reference_property_domain_id AS reference_property_domain_id_55, t6.refrence_property_state_id AS refrence_property_state_id_56, t6.reference_property_contract_type_id AS reference_property_contract_type_id_57, t6.reference_property_land_type_id AS reference_property_land_type_id_58, t6.reference_property_destination_id AS reference_property_destination_id_59, t6.reference_property_construction_type_id AS reference_property_construction_type_id_60, t6.reference_property_orientation_type_id AS reference_property_orientation_type_id_61, t6.reference_property_status_id AS reference_property_status_id_62, t6.reference_service_type_id AS reference_service_type_id_63, t6.reference_property_type_id AS reference_property_type_id_64, t6.recommendation_id AS recommendation_id_65, t0.neighborhood_id AS neighborhood_id_66 FROM property_address t0 LEFT JOIN property t6 ON t6.property_address_id = t0.id WHERE t0.id = 11359;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.rank AS rank_5,
  t0.country_id AS country_id_6
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 WHERE t0.id = 2087;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.currency_id AS currency_id_4
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.currency_id AS currency_id_4 FROM country t0 WHERE t0.id = 2365;

SELECT
  t1.id AS id_2,
  t1.first_name AS first_name_3,
  t1.last_name AS last_name_4,
  t1.email AS email_5,
  t1.professional_email AS professional_email_6,
  t1.birth_day AS birth_day_7,
  t1.phone AS phone_8,
  t1.main_phone AS main_phone_9,
  t1.roles AS roles_10,
  t1.password AS password_11,
  t1.last_connection AS last_connection_12,
  t1.person_type AS person_type_13,
  t1.created_at AS created_at_14,
  t1.updated_at AS updated_at_15,
  t0.cin AS cin_16,
  t0.is_recommender AS is_recommender_17,
  t0.cnss AS cnss_18,
  t0.rc AS rc_19,
  t0.professional_status AS professional_status_20,
  t0.subject_to_vat AS subject_to_vat_21,
  t0.created_qualifiqaution_date AS created_qualifiqaution_date_22,
  t0.company_name AS company_name_23,
  t0.common_company_identifier AS common_company_identifier_24,
  t1.address_id AS address_id_25,
  t1.gender_id AS gender_id_26,
  t1.reference_status_id AS reference_status_id_27,
  t1.reference_marital_status_id AS reference_marital_status_id_28,
  t0.qualification_level_id AS qualification_level_id_29,
  t0.sector_id AS sector_id_30,
  t0.manager_id AS manager_id_31,
  t0.status_id AS status_id_32,
  t0.sponsor_id AS sponsor_id_33,
  t0.nationality_id AS nationality_id_34,
  t1.type
FROM
  agent t0
  INNER JOIN abstract_collaborator t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.first_name AS first_name_3, t1.last_name AS last_name_4, t1.email AS email_5, t1.professional_email AS professional_email_6, t1.birth_day AS birth_day_7, t1.phone AS phone_8, t1.main_phone AS main_phone_9, t1.roles AS roles_10, t1.password AS password_11, t1.last_connection AS last_connection_12, t1.person_type AS person_type_13, t1.created_at AS created_at_14, t1.updated_at AS updated_at_15, t0.cin AS cin_16, t0.is_recommender AS is_recommender_17, t0.cnss AS cnss_18, t0.rc AS rc_19, t0.professional_status AS professional_status_20, t0.subject_to_vat AS subject_to_vat_21, t0.created_qualifiqaution_date AS created_qualifiqaution_date_22, t0.company_name AS company_name_23, t0.common_company_identifier AS common_company_identifier_24, t1.address_id AS address_id_25, t1.gender_id AS gender_id_26, t1.reference_status_id AS reference_status_id_27, t1.reference_marital_status_id AS reference_marital_status_id_28, t0.qualification_level_id AS qualification_level_id_29, t0.sector_id AS sector_id_30, t0.manager_id AS manager_id_31, t0.status_id AS status_id_32, t0.sponsor_id AS sponsor_id_33, t0.nationality_id AS nationality_id_34, t1.type FROM agent t0 INNER JOIN abstract_collaborator t1 ON t0.id = t1.id WHERE t1.id = 3093;

SELECT
  t0.id AS id_1,
  t0.file_path AS file_path_2,
  t0.collaborator_id AS collaborator_id_3
FROM
  avatar t0
WHERE
  t0.collaborator_id = ?

SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.collaborator_id AS collaborator_id_3 FROM avatar t0 WHERE t0.collaborator_id = 3093;

SELECT
  t0.id AS id_1,
  t0.ip_address AS ip_address_2,
  t0.browser AS browser_3,
  t0.is_accepted AS is_accepted_4,
  t0.accepted_at AS accepted_at_5,
  t0.collaborator_id AS collaborator_id_6
FROM
  cgu t0
WHERE
  t0.collaborator_id = ?

SELECT t0.id AS id_1, t0.ip_address AS ip_address_2, t0.browser AS browser_3, t0.is_accepted AS is_accepted_4, t0.accepted_at AS accepted_at_5, t0.collaborator_id AS collaborator_id_6 FROM cgu t0 WHERE t0.collaborator_id = 3093;

SELECT
  t0.id AS id_1,
  t0.main_city_id AS main_city_id_2
FROM
  sector t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.main_city_id AS main_city_id_2 FROM sector t0 WHERE t0.id = 10357;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.rank AS rank_5,
  t0.country_id AS country_id_6
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 WHERE t0.id = 1945;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.rank AS rank_5,
  t0.country_id AS country_id_6
FROM
  city t0
  INNER JOIN sector_city ON t0.id = sector_city.city_id
WHERE
  sector_city.sector_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.rank AS rank_5, t0.country_id AS country_id_6 FROM city t0 INNER JOIN sector_city ON t0.id = sector_city.city_id WHERE sector_city.sector_id = 10357;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.city_id AS city_id_5
FROM
  neighborhood t0
WHERE
  t0.city_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.city_id AS city_id_5 FROM neighborhood t0 WHERE t0.city_id = 1945;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.latitude AS latitude_3,
  t0.longitude AS longitude_4,
  t0.city_id AS city_id_5
FROM
  neighborhood t0
  INNER JOIN sector_neighborhood ON t0.id = sector_neighborhood.neighborhood_id
WHERE
  sector_neighborhood.sector_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.city_id AS city_id_5 FROM neighborhood t0 INNER JOIN sector_neighborhood ON t0.id = sector_neighborhood.neighborhood_id WHERE sector_neighborhood.sector_id = 10357;

SELECT
  t0.id AS id_1,
  t0.level AS level_2,
  t0.recurrence AS recurrence_3,
  t0.label AS label_4,
  t0.qualification_level_goal AS qualification_level_goal_5,
  t0.max_sponsorship_request AS max_sponsorship_request_6
FROM
  qualification_level t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.level AS level_2, t0.recurrence AS recurrence_3, t0.label AS label_4, t0.qualification_level_goal AS qualification_level_goal_5, t0.max_sponsorship_request AS max_sponsorship_request_6 FROM qualification_level t0 WHERE t0.id = 76;

SELECT
  t0.id AS id_1,
  t0.option_value AS option_value_2,
  t0.agent_id AS agent_id_3,
  t0.option_id AS option_id_4
FROM
  agents_options t0
WHERE
  t0.agent_id = ?

SELECT t0.id AS id_1, t0.option_value AS option_value_2, t0.agent_id AS agent_id_3, t0.option_id AS option_id_4 FROM agents_options t0 WHERE t0.agent_id = 3093;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.values AS values_4,
  t0.default_value AS default_value_5,
  t0.code AS code_6
FROM
  OPTION t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.values AS values_4, t0.default_value AS default_value_5, t0.code AS code_6 FROM OPTION t0 WHERE t0.id = 1;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'demo_db_property_management'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE';

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SHOW search_path

SHOW search_path;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'demo_db_property_management'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE';

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  c.relname,
  CASE c.relpersistence WHEN 'u' THEN TRUE ELSE false END AS unlogged,
  obj_description(c.oid, 'pg_class') AS COMMENT
FROM
  pg_class c
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE
  c.relkind = 'r'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )

SELECT c.relname,
       CASE c.relpersistence WHEN 'u' THEN TRUE ELSE false END AS unlogged,
       obj_description(c.oid, 'pg_class') AS COMMENT
FROM pg_class c
     INNER JOIN pg_namespace n
         ON n.oid = c.relnamespace WHERE c.relkind = 'r' AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast');

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(r.conname) AS conname,
  pg_get_constraintdef(r.oid, TRUE) AS condef
FROM
  pg_constraint r
  JOIN pg_class AS tc ON tc.oid = r.conrelid
  JOIN pg_namespace tn ON tn.oid = tc.relnamespace
WHERE
  r.conrelid IN (
    SELECT
      c.oid
    FROM
      pg_class c,
      pg_namespace n
    WHERE
      n.oid = c.relnamespace
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND c.relname = 'doctrine_migration_versions'
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )
  AND r.contype = 'f'

SELECT                  quote_ident(r.conname) AS conname,
                  pg_get_constraintdef(r.oid, TRUE) AS condef
                  FROM pg_constraint r
                      JOIN pg_class AS tc ON tc.oid = r.conrelid
                      JOIN pg_namespace tn ON tn.oid = tc.relnamespace
                  WHERE r.conrelid IN
                  (
                      SELECT c.oid
                      FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) AND r.contype = 'f';

SELECT
  a.attnum,
  quote_ident(a.attname) AS field,
  t.typname AS TYPE,
  format_type(a.atttypid, a.atttypmod) AS complete_type,
  (
    SELECT
      tc.collcollate
    FROM
      pg_catalog.pg_collation tc
    WHERE
      tc.oid = a.attcollation
  ) AS COLLATION,
  (
    SELECT
      t1.typname
    FROM
      pg_catalog.pg_type t1
    WHERE
      t1.oid = t.typbasetype
  ) AS domain_type,
  (
    SELECT
      format_type(t2.typbasetype, t2.typtypmod)
    FROM
      pg_catalog.pg_type t2
    WHERE
      t2.typtype = 'd'
      AND t2.oid = a.atttypid
  ) AS domain_complete_type,
  a.attnotnull AS isnotnull,
  (
    SELECT
      't'
    FROM
      pg_index
    WHERE
      c.oid = pg_index.indrelid
      AND pg_index.indkey[0] = a.attnum
      AND pg_index.indisprimary = 't'
  ) AS pri,
  (
    SELECT
      pg_get_expr(adbin, adrelid)
    FROM
      pg_attrdef
    WHERE
      c.oid = pg_attrdef.adrelid
      AND pg_attrdef.adnum = a.attnum
  ) AS DEFAULT,
  (
    SELECT
      pg_description.description
    FROM
      pg_description
    WHERE
      pg_description.objoid = c.oid
      AND a.attnum = pg_description.objsubid
  ) AS COMMENT
FROM
  pg_attribute a
  INNER JOIN pg_class c ON c.oid = a.attrelid
  INNER JOIN pg_type t ON t.oid = a.atttypid
  INNER JOIN pg_namespace n ON n.oid = c.relnamespace
  LEFT JOIN pg_depend d ON d.objid = c.oid
  AND d.deptype = 'e'
  AND d.classid = (
    SELECT
      oid
    FROM
      pg_class
    WHERE
      relname = 'pg_class'
  )
WHERE
  a.attnum > 0
  AND c.relkind = 'r'
  AND d.refobjid IS NULL
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
ORDER BY
  a.attnum

SELECT            a.attnum,
            quote_ident(a.attname) AS field,
            t.typname AS TYPE,
            format_type(a.atttypid, a.atttypmod) AS complete_type,
            (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS COLLATION,
            (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,
            (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM
              pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,
            a.attnotnull AS isnotnull,
            (SELECT 't'
             FROM pg_index
             WHERE c.oid = pg_index.indrelid
                AND pg_index.indkey[0] = a.attnum
                AND pg_index.indisprimary = 't'
            ) AS pri,
            (SELECT pg_get_expr(adbin, adrelid)
             FROM pg_attrdef
             WHERE c.oid = pg_attrdef.adrelid
                AND pg_attrdef.adnum=a.attnum
            ) AS DEFAULT,
            (SELECT pg_description.description
                FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid
            ) AS COMMENT
            FROM pg_attribute a
                INNER JOIN pg_class c
                    ON c.oid = a.attrelid
                INNER JOIN pg_type t
                    ON t.oid = a.atttypid
                INNER JOIN pg_namespace n
                    ON n.oid = c.relnamespace
                LEFT JOIN pg_depend d
                    ON d.objid = c.oid
                        AND d.deptype = 'e'
                        AND d.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class') WHERE a.attnum > 0 AND c.relkind = 'r' AND d.refobjid IS NULL AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') ORDER BY a.attnum;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(ic.relname) AS relname,
  i.indisunique,
  i.indisprimary,
  i.indkey,
  i.indrelid,
  pg_get_expr(indpred, indrelid) AS "where"
FROM
  pg_index i
  JOIN pg_class AS tc ON tc.oid = i.indrelid
  JOIN pg_namespace tn ON tn.oid = tc.relnamespace
  JOIN pg_class AS ic ON ic.oid = i.indexrelid
WHERE
  ic.oid IN (
    SELECT
      indexrelid
    FROM
      pg_index i,
      pg_class c,
      pg_namespace n
    WHERE
      c.oid = i.indrelid
      AND c.relnamespace = n.oid
      AND n.nspname = ANY(
        current_schemas(false)
      )
      AND c.relname = 'doctrine_migration_versions'
      AND n.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
  )

SELECT                   quote_ident(ic.relname) AS relname,
                   i.indisunique,
                   i.indisprimary,
                   i.indkey,
                   i.indrelid,
                   pg_get_expr(indpred, indrelid) AS "where"
              FROM pg_index i
                   JOIN pg_class AS tc ON tc.oid = i.indrelid
                   JOIN pg_namespace tn ON tn.oid = tc.relnamespace
                   JOIN pg_class AS ic ON ic.oid = i.indexrelid
             WHERE ic.oid IN (
                SELECT indexrelid
                FROM pg_index i, pg_class c, pg_namespace n WHERE c.oid = i.indrelid AND c.relnamespace = n.oid AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast'));

SELECT
  attnum,
  attname
FROM
  pg_attribute
WHERE
  attrelid = 501034
  AND attnum IN (1)
ORDER BY
  attnum ASC

SELECT attnum, attname FROM pg_attribute WHERE attrelid=501034 AND attnum IN (1) ORDER BY attnum ASC;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();