Symfony Profiler

SELECT
  t0.hash AS hash_1,
  t0.details AS details_2,
  t0.after_url AS after_url_3,
  t0.target_url AS target_url_4,
  t0.gateway_name AS gateway_name_5
FROM
  payment_tokens t0
WHERE
  t0.hash = ?

SELECT t0.hash AS hash_1, t0.details AS details_2, t0.after_url AS after_url_3, t0.target_url AS target_url_4, t0.gateway_name AS gateway_name_5 FROM payment_tokens t0 WHERE t0.hash = 'jF9arGDWmeUBx0r5XIAOEkdOeQEk0ROzzacAXZDTCpk';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.factory_name AS factory_name_3,
  t0.gateway_name AS gateway_name_4,
  t0.config AS config_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  payment_gateway_configs t0
WHERE
  t0.gateway_name = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.factory_name AS factory_name_3, t0.gateway_name AS gateway_name_4, t0.config AS config_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_gateway_configs t0 WHERE t0.gateway_name = 'zepllin_ltd';

SELECT
  t0.id AS id_1,
  t0.external_id AS external_id_2,
  t0.description AS description_3,
  t0.amount AS amount_4,
  t0.currency AS currency_5,
  t0.success_url AS success_url_6,
  t0.failure_url AS failure_url_7,
  t0.pending_url AS pending_url_8,
  t0.notification_url AS notification_url_9,
  t0.customer_id AS customer_id_10,
  t0.details AS details_11,
  t0.status AS status_12,
  t0.pisp_status AS pisp_status_13,
  t0.bank_status AS bank_status_14,
  t0.mapping_id AS mapping_id_15,
  t0.payment_type AS payment_type_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t19.id AS id_20,
  t19.ip_address AS ip_address_21,
  t19.name AS name_22,
  t19.created_at AS created_at_23,
  t19.updated_at AS updated_at_24,
  t19.payment_id AS payment_id_25,
  t0.site_id AS site_id_26
FROM
  payments t0
  LEFT JOIN user_payment_info t19 ON t19.payment_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.description AS description_3, t0.amount AS amount_4, t0.currency AS currency_5, t0.success_url AS success_url_6, t0.failure_url AS failure_url_7, t0.pending_url AS pending_url_8, t0.notification_url AS notification_url_9, t0.customer_id AS customer_id_10, t0.details AS details_11, t0.status AS status_12, t0.pisp_status AS pisp_status_13, t0.bank_status AS bank_status_14, t0.mapping_id AS mapping_id_15, t0.payment_type AS payment_type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t19.id AS id_20, t19.ip_address AS ip_address_21, t19.name AS name_22, t19.created_at AS created_at_23, t19.updated_at AS updated_at_24, t19.payment_id AS payment_id_25, t0.site_id AS site_id_26 FROM payments t0 LEFT JOIN user_payment_info t19 ON t19.payment_id = t0.id WHERE t0.id = '11e22c63-d78e-45eb-8020-3bd5c6b3cb7a';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO payment_tokens (
  hash, details, after_url, target_url,
  gateway_name
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO payment_tokens (hash, details, after_url, target_url, gateway_name) VALUES ('r7mbw1_lwrllwbB1ZTivYXe-xKPn53yFGaj0EmFUlcE', 'O:25:\"Payum\\Core\\Model\\Identity\":2:{i:0;s:36:\"11e22c63-d78e-45eb-8020-3bd5c6b3cb7a\";i:1;s:32:\"App\\Domain\\Payment\\Model\\Payment\";}', NULL, 'https://staging.bwire.io/payment/notify/r7mbw1_lwrllwbB1ZTivYXe-xKPn53yFGaj0EmFUlcE', 'zepllin_ltd');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  payments
SET
  details = ?
WHERE
  id = ?

UPDATE payments SET details = '{\"flowType\":\"PIS\",\"userId\":\"testid\",\"html\":\"<div class=\\\"wrapper\\\">${ibanxs}<\\/div>\",\"css\":\"body{background:#0a0e0a !important;}.ibanxs-main-container-wrapper{display:flex;align-items:center;justify-content:center;min-height:100vh;}.ibanXS-main-container{position:relative;background:#141714;border:1px solid rgba(255,255,255,0.08);border-radius:16px;padding:clamp(20px,6vw,36px);max-width:min(94vw,480px);min-width:280px;box-shadow:0 24px 70px rgba(0,0,0,0.55);font-family:-apple-system,BlinkMacSystemFont,\'Segoe UI\',Roboto,sans-serif;}.form-container{padding:0;width:auto;max-width:100%;}.main-form,.ibanxs-transaction-information{display:block;}.ibanxs-transaction-information{margin-bottom:clamp(16px,4vw,24px);max-height:60vh;overflow-y:auto;}.ibanxs-transaction-information-field{display:flex;justify-content:flex-start;align-items:baseline;flex-wrap:wrap;gap:clamp(6px,2vw,10px);padding:6px 0;font-size:clamp(12px,3vw,13px);border-bottom:1px solid rgba(255,255,255,0.06);}.ibanxs-transaction-information-field:last-child{border-bottom:none !important;}.ibanxs-transaction-information-field-title{color:#8a8f8a;font-weight:500;}.ibanxs-transaction-information-field-value{color:#e5e5e5;font-weight:600;text-align:left;}.ibanxs-form-field-container{margin-bottom:clamp(12px,3vw,16px);padding:0;}.ibanxs-text-input{background:#1a1d1a;border:1px solid rgba(255,255,255,0.12);box-shadow:none;}.ibanxs-text-input label{color:#8a8f8a;}.ibanxs-text-input:not(.active) label{top:50%;left:clamp(12px,4vw,16px);line-height:normal;transform:translateY(-50%) !important;}.ibanxs-text-input input{color:#e5e5e5;padding:clamp(12px,3.5vw,14px) clamp(32px,9vw,40px) clamp(12px,3.5vw,14px) clamp(12px,4vw,16px);font-size:clamp(14px,4vw,16px);}.ibanxs-text-input.active label{display:none;}.field-validation-icon.correct{color:#a3e635;}.field-validation-icon.error{color:#5a5f5a !important;}.autocomplete-items{background:#1a1d1a;border:1px solid rgba(255,255,255,0.12);border-radius:12px;margin-top:4px;box-shadow:0 12px 30px rgba(0,0,0,0.4);}.ibanXS-main-container .autocomplete-items{overflow-x:hidden;}.ibanXS-main-container .autocomplete-items > div{background:#1a1d1a;color:#cfd2cf;border-bottom:1px solid rgba(255,255,255,0.06);}.ibanXS-main-container .autocomplete-items > div:hover{background:rgba(163,230,53,0.15) !important;}.ibanxs-submit-button{width:100% !important;box-sizing:border-box;background:#a3e635;color:#0a0e0a;border:none;border-radius:26px;padding:clamp(12px,3.5vw,14px);font-size:clamp(14px,4vw,16px);font-weight:700;transition:opacity .15s ease, transform .1s ease;}.ibanxs-submit-button:hover{opacity:0.92;}.ibanxs-submit-button:active{transform:scale(0.98) !important;}.main-form:has(#countryId:invalid) .ibanxs-submit-button,.main-form:has(#bankId:invalid) .ibanxs-submit-button{opacity:0.35;pointer-events:none;cursor:not-allowed;}.container{color:#e5e5e5;font-size:clamp(13px,3.5vw,14px);}.container input:not(:checked) ~ .ibanxs-checkbox-checkmark::after{display:none;}.container input:checked ~ .ibanxs-checkbox-checkmark{background:#a3e635;border-color:#a3e635;}.ibanxs-language-switch{position:absolute !important;top:clamp(10px,3vw,16px) !important;right:clamp(10px,3vw,16px) !important;background:#1a1d1a !important;border:1px solid rgba(255,255,255,0.12);border-radius:20px !important;color:#e5e5e5;padding:clamp(4px,1.5vw,6px) clamp(8px,3vw,12px);z-index:10;}.ibanxs-language-switch-list{background:#141714 !important;border:1px solid rgba(255,255,255,0.12);border-radius:12px;overflow:hidden;box-shadow:0 12px 30px rgba(0,0,0,0.4) !important;}.ibanxs-language-switch-list-element{padding:8px 12px !important;}.ibanxs-language-switch-list-element:hover{background:rgba(163,230,53,0.12) !important;}.MuiCircularProgress-svg{color:#a3e635 !important;}.MuiCircularProgress-svg circle{stroke:#a3e635 !important;}.ibanxs-transaction-information-field.ibanxs-error-field{min-width:0px;background-color:rgba(163,230,53,0.08);color:rgb(163,230,53);border:1px solid rgba(163,230,53,0.3);border-radius:8px;padding:clamp(12px,4vw,16px) clamp(14px,4vw,18px) !important;margin-top:28px;}.ibanxs-error-field svg{stroke:rgb(163,230,53);fill:rgb(163,230,53);flex-shrink:0;}.ibanxs-error-field a{color:rgb(163,230,53);}\",\"params\":{\"redirectionUrl\":null,\"statusCallback\":\"https:\\/\\/staging.bwire.io\\/payment\\/notify\\/r7mbw1_lwrllwbB1ZTivYXe-xKPn53yFGaj0EmFUlcE\",\"amountToPay\":\"12.34\",\"currency\":\"EUR\",\"description\":\"ag9svthh860s75oag6ve24kvdd\",\"endToEndIdentification\":\"ag9svthh860s75oag6ve24kvdd\",\"creditorName\":null,\"creditorStreet\":null,\"creditorStreetNumber\":null,\"creditorCity\":null,\"creditorPostalCode\":null,\"creditorCountry\":null,\"creditorIban\":null,\"psuIpAddress\":\"80.94.24.121\"}}' WHERE id = '11e22c63-d78e-45eb-8020-3bd5c6b3cb7a';

"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'
ORDER BY
  quote_ident(table_name)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'bwire_staging'
  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'
ORDER BY
  quote_ident(table_name);

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'
ORDER BY
  quote_ident(table_name)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'bwire_staging'
  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'
ORDER BY
  quote_ident(table_name);

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  n.nspname AS schema_name,
  c.relname AS table_name,
  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 n.nspname AS schema_name,
       c.relname AS table_name,
       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'
ORDER BY
  quote_ident(r.conname)

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' ORDER BY quote_ident(r.conname);

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
      CASE WHEN a.attgenerated = 's' THEN
        NULL
      ELSE
        pg_get_expr(adbin, adrelid)
      END
    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
        CASE
            WHEN a.attgenerated = 's' THEN NULL
            ELSE pg_get_expr(adbin, adrelid)
        END
     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'
      )
  )
ORDER BY
  quote_ident(ic.relname)

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')) ORDER BY quote_ident(ic.relname);

SELECT
  attnum,
  quote_ident(attname) AS attname
FROM
  pg_attribute
WHERE
  attrelid = 16483
  AND attnum IN (1)
ORDER BY
  attnum

SELECT attnum,
       quote_ident(attname) AS attname
FROM pg_attribute
WHERE attrelid = 16483
  AND attnum IN (1)
ORDER BY attnum;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();