Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_verified AS is_verified_7,
  t0.photo AS photo_8,
  t0.google_id AS google_id_9,
  t0.facebook_id AS facebook_id_10,
  t0.last_login AS last_login_11,
  t0.phone AS phone_12,
  t0.is_active AS is_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.company_id AS company_id_17
FROM
  "user" t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_verified AS is_verified_7, t0.photo AS photo_8, t0.google_id AS google_id_9, t0.facebook_id AS facebook_id_10, t0.last_login AS last_login_11, t0.phone AS phone_12, t0.is_active AS is_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.company_id AS company_id_17 FROM "user" t0 WHERE t0.id = '01992059-a69e-b8f2-43ea-25bd0d56f6a9' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.size AS size_4,
  t0.logo AS logo_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.mobile AS mobile_8,
  t0.fax AS fax_9,
  t0.description AS description_10,
  t0.website AS website_11,
  t0.facebook AS facebook_12,
  t0.twitter AS twitter_13,
  t0.instagram AS instagram_14,
  t0.youtube AS youtube_15,
  t0.tiktok AS tiktok_16,
  t0.rc AS rc_17,
  t0.nif AS nif_18,
  t0.nis AS nis_19,
  t0.is_active AS is_active_20,
  t0.date_format AS date_format_21,
  t0.languege AS languege_22,
  t0.currencie AS currencie_23,
  t0.time_zone AS time_zone_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.deleted_at AS deleted_at_27,
  t0.address_id AS address_id_28
FROM
  company t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.size AS size_4, t0.logo AS logo_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile AS mobile_8, t0.fax AS fax_9, t0.description AS description_10, t0.website AS website_11, t0.facebook AS facebook_12, t0.twitter AS twitter_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.tiktok AS tiktok_16, t0.rc AS rc_17, t0.nif AS nif_18, t0.nis AS nis_19, t0.is_active AS is_active_20, t0.date_format AS date_format_21, t0.languege AS languege_22, t0.currencie AS currencie_23, t0.time_zone AS time_zone_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.deleted_at AS deleted_at_27, t0.address_id AS address_id_28 FROM company t0 WHERE t0.id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.owner_id AS owner_id_10
FROM
  season t0
WHERE
  t0.owner_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.owner_id AS owner_id_10 FROM season t0 WHERE t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61' AND ((t0.deleted_at IS NULL));

SELECT
  NEXTVAL('activity_id_seq')

SELECT NEXTVAL('activity_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO activity (
  id, action, context, ip, method, path,
  locale, query, route, created_at,
  updated_at, deleted_at, owner_id,
  made_by_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO activity (id, action, context, ip, method, path, locale, query, route, created_at, updated_at, deleted_at, owner_id, made_by_id) VALUES (15144, '', '[]', '162.158.23.46', 'GET', '/app/payment/', 'fr', '{\"q\":\"\\/app\\/payment\\/\"}', 'app_payment_index', '2025-09-14 10:04:20', '2025-09-14 10:04:20', NULL, '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61', '01992059-a69e-b8f2-43ea-25bd0d56f6a9');

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.date AS date_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.subscription_id AS subscription_id_8,
  t0.payed_by_id AS payed_by_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.owner_id AS owner_id_11,
  t0.season_id AS season_id_12
FROM
  payment t0
WHERE
  (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (
      t0.season_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e60'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date AS date_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.subscription_id AS subscription_id_8, t0.payed_by_id AS payed_by_id_9, t0.created_by_id AS created_by_id_10, t0.owner_id AS owner_id_11, t0.season_id AS season_id_12 FROM payment t0 WHERE ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.season_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e60') AND (t0.deleted_at IS NULL));

SELECT
  s0_.id AS id_0,
  s0_.start_date AS start_date_1,
  s0_.expire_date AS expire_date_2,
  s0_.price AS price_3,
  s0_.quantity AS quantity_4,
  s0_.total AS total_5,
  s0_.status AS status_6,
  s0_.status_payment AS status_payment_7,
  s0_.discount AS discount_8,
  s0_.description AS description_9,
  s0_.created_at AS created_at_10,
  s0_.updated_at AS updated_at_11,
  s0_.deleted_at AS deleted_at_12,
  s0_.service_id AS service_id_13,
  s0_.child_id AS child_id_14,
  s0_.created_by_id AS created_by_id_15,
  s0_.owner_id AS owner_id_16,
  s0_.season_id AS season_id_17
FROM
  subscription s0_
WHERE
  (
    s0_.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
  )
  AND (
    s0_.season_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e60'
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.start_date AS start_date_1, s0_.expire_date AS expire_date_2, s0_.price AS price_3, s0_.quantity AS quantity_4, s0_.total AS total_5, s0_.status AS status_6, s0_.status_payment AS status_payment_7, s0_.discount AS discount_8, s0_.description AS description_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.deleted_at AS deleted_at_12, s0_.service_id AS service_id_13, s0_.child_id AS child_id_14, s0_.created_by_id AS created_by_id_15, s0_.owner_id AS owner_id_16, s0_.season_id AS season_id_17 FROM subscription s0_ WHERE (s0_.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (s0_.season_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e60') AND (s0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.gender AS gender_4,
  t0.birth_date AS birth_date_5,
  t0.birth_place AS birth_place_6,
  t0.blood AS blood_7,
  t0.diseases AS diseases_8,
  t0.allergies AS allergies_9,
  t0.food_habit AS food_habit_10,
  t0.behavior AS behavior_11,
  t0.fears AS fears_12,
  t0.interests AS interests_13,
  t0.description AS description_14,
  t0.status AS status_15,
  t0.photo AS photo_16,
  t0.first_name_ar AS first_name_ar_17,
  t0.last_name_ar AS last_name_ar_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.deleted_at AS deleted_at_21,
  t0.section_id AS section_id_22,
  t0.owner_id AS owner_id_23,
  t0.address_id AS address_id_24,
  t0.season_id AS season_id_25
FROM
  child t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (
      t0.season_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e60'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.gender AS gender_4, t0.birth_date AS birth_date_5, t0.birth_place AS birth_place_6, t0.blood AS blood_7, t0.diseases AS diseases_8, t0.allergies AS allergies_9, t0.food_habit AS food_habit_10, t0.behavior AS behavior_11, t0.fears AS fears_12, t0.interests AS interests_13, t0.description AS description_14, t0.status AS status_15, t0.photo AS photo_16, t0.first_name_ar AS first_name_ar_17, t0.last_name_ar AS last_name_ar_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.deleted_at AS deleted_at_21, t0.section_id AS section_id_22, t0.owner_id AS owner_id_23, t0.address_id AS address_id_24, t0.season_id AS season_id_25 FROM child t0 WHERE t0.id = '01992061-e190-f9ed-14b2-a4c2ba06c324' AND ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.season_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e60') AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.duration AS duration_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.owner_id AS owner_id_9
FROM
  service t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.owner_id AS owner_id_9 FROM service t0 WHERE t0.id = '01992334-facd-b924-f932-6ffa25f4762c' AND ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.date AS date_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.subscription_id AS subscription_id_8,
  t0.payed_by_id AS payed_by_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.owner_id AS owner_id_11,
  t0.season_id AS season_id_12
FROM
  payment t0
WHERE
  t0.subscription_id = ?
  AND (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (
      t0.season_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e60'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date AS date_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.subscription_id AS subscription_id_8, t0.payed_by_id AS payed_by_id_9, t0.created_by_id AS created_by_id_10, t0.owner_id AS owner_id_11, t0.season_id AS season_id_12 FROM payment t0 WHERE t0.subscription_id = '0199232f-f7d5-0ab2-1cfb-99781443eda3' AND ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.season_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e60') AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.duration AS duration_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.owner_id AS owner_id_9
FROM
  service t0
WHERE
  t0.id = ?
  AND (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.duration AS duration_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.owner_id AS owner_id_9 FROM service t0 WHERE t0.id = '0199205a-8a6f-c94d-36aa-7b60d42bb97d' AND ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.date AS date_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.subscription_id AS subscription_id_8,
  t0.payed_by_id AS payed_by_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.owner_id AS owner_id_11,
  t0.season_id AS season_id_12
FROM
  payment t0
WHERE
  t0.subscription_id = ?
  AND (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (
      t0.season_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e60'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date AS date_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.subscription_id AS subscription_id_8, t0.payed_by_id AS payed_by_id_9, t0.created_by_id AS created_by_id_10, t0.owner_id AS owner_id_11, t0.season_id AS season_id_12 FROM payment t0 WHERE t0.subscription_id = '01992337-6976-a08a-8b72-074eae2798a7' AND ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.season_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e60') AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.date AS date_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.subscription_id AS subscription_id_8,
  t0.payed_by_id AS payed_by_id_9,
  t0.created_by_id AS created_by_id_10,
  t0.owner_id AS owner_id_11,
  t0.season_id AS season_id_12
FROM
  payment t0
WHERE
  t0.subscription_id = ?
  AND (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (
      t0.season_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e60'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.date AS date_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.subscription_id AS subscription_id_8, t0.payed_by_id AS payed_by_id_9, t0.created_by_id AS created_by_id_10, t0.owner_id AS owner_id_11, t0.season_id AS season_id_12 FROM payment t0 WHERE t0.subscription_id = '01992640-ed9f-ac95-db3a-70ea60b0b480' AND ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.season_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e60') AND (t0.deleted_at IS NULL));

SELECT
  f0_.id AS id_0,
  f0_.type AS type_1,
  f0_.first_name AS first_name_2,
  f0_.last_name AS last_name_3,
  f0_.email AS email_4,
  f0_.phone AS phone_5,
  f0_.mobile AS mobile_6,
  f0_.job AS job_7,
  f0_.legal_guardian AS legal_guardian_8,
  f0_.description AS description_9,
  f0_.photo AS photo_10,
  f0_.family_situation AS family_situation_11,
  f0_.created_at AS created_at_12,
  f0_.updated_at AS updated_at_13,
  f0_.deleted_at AS deleted_at_14,
  f0_.address_id AS address_id_15,
  f0_.owner_id AS owner_id_16,
  f0_.season_id AS season_id_17
FROM
  family_member f0_
WHERE
  (
    f0_.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
  )
  AND (
    f0_.season_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e60'
  )
  AND (f0_.deleted_at IS NULL)

SELECT f0_.id AS id_0, f0_.type AS type_1, f0_.first_name AS first_name_2, f0_.last_name AS last_name_3, f0_.email AS email_4, f0_.phone AS phone_5, f0_.mobile AS mobile_6, f0_.job AS job_7, f0_.legal_guardian AS legal_guardian_8, f0_.description AS description_9, f0_.photo AS photo_10, f0_.family_situation AS family_situation_11, f0_.created_at AS created_at_12, f0_.updated_at AS updated_at_13, f0_.deleted_at AS deleted_at_14, f0_.address_id AS address_id_15, f0_.owner_id AS owner_id_16, f0_.season_id AS season_id_17 FROM family_member f0_ WHERE (f0_.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (f0_.season_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e60') AND (f0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.expire_date AS expire_date_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.product_id AS product_id_7,
  t0.owner_id AS owner_id_8
FROM
  abonnement t0
WHERE
  t0.owner_id = ?
  AND (
    (
      t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61'
    )
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.expire_date AS expire_date_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.product_id AS product_id_7, t0.owner_id AS owner_id_8 FROM abonnement t0 WHERE t0.owner_id = '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61' AND ((t0.owner_id='0199205a-8a6c-bf1f-9fcb-1ffd49a71e61') AND (t0.deleted_at IS NULL));

SELECT
  NEXTVAL('activity_id_seq')

SELECT NEXTVAL('activity_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO activity (
  id, action, context, ip, method, path,
  locale, query, route, created_at,
  updated_at, deleted_at, owner_id,
  made_by_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO activity (id, action, context, ip, method, path, locale, query, route, created_at, updated_at, deleted_at, owner_id, made_by_id) VALUES (15145, '', '[]', '162.158.23.46', 'GET', '/app/payment/', 'fr', '{\"q\":\"\\/app\\/payment\\/\"}', NULL, '2025-09-14 10:04:20', '2025-09-14 10:04:20', NULL, '0199205a-8a6c-bf1f-9fcb-1ffd49a71e61', '01992059-a69e-b8f2-43ea-25bd0d56f6a9');

"COMMIT"

"COMMIT";

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 = 'clevernursery'
  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 = 'clevernursery'
  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 = 18311
  AND attnum IN (1)
ORDER BY
  attnum ASC

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