Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alexa_name AS alexa_name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alexa_name AS alexa_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM category t0 WHERE t0.id = 'side-menu-light-button.html';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.major AS major_2,
  t0.minor AS minor_3,
  t0.number AS number_4,
  t0.title AS title_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  last_update t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.major AS major_2, t0.minor AS minor_3, t0.number AS number_4, t0.title AS title_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM last_update t0 ORDER BY t0.id DESC LIMIT 1;

INSERT INTO bug (
  exception_type, message, status_code,
  route, route_params, url, base_url,
  query, user_agent, host, ip_address,
  username, created_at, updated_at,
  created_by, updated_by, update_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO bug (exception_type, message, status_code, route, route_params, url, base_url, query, user_agent, host, ip_address, username, created_at, updated_at, created_by, updated_by, update_id) VALUES ('Doctrine\\DBAL\\Driver\\PDO\\Exception', 'An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"side-menu-light-button.html\"
CONTEXT:  unnamed portal parameter $1 = \'...\'', 500, 'category_edit', '{\"id\":\"side-menu-light-button.html\"}', 'https://lunedi.oimmei.com/category/side-menu-light-button.html/', '', NULL, 'Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; spider-feedback@bytedance.com)', 'lunedi.oimmei.com', '47.128.34.36', 'Anonymous', '2025-10-29 10:47:05', '2025-10-29 10:47:05', NULL, NULL, NULL);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/doctrine/dbal/src/Connection.php', 'Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter->convert', 1815, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/doctrine/dbal/src/Connection.php', 'Doctrine\\DBAL\\Connection->handleDriverException', 1750, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/doctrine/dbal/src/Connection.php', 'Doctrine\\DBAL\\Connection->convertExceptionDuringQuery', 1056, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php', 'Doctrine\\DBAL\\Connection->executeQuery', 747, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php', 'Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->load', 765, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php', 'Doctrine\\ORM\\Persisters\\Entity\\BasicEntityPersister->loadById', 502, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/var/cache/dev/ContainerWH89FUx/EntityManager_9a5be93.php', 'Doctrine\\ORM\\EntityManager->find', 143, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php', 'ContainerWH89FUx\\EntityManager_9a5be93->find', 175, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/DoctrineParamConverter.php', 'Doctrine\\ORM\\EntityRepository->find', 142, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/DoctrineParamConverter.php', 'Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\DoctrineParamConverter->find', 91, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/ParamConverterManager.php', 'Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\DoctrineParamConverter->apply', 84, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/ParamConverterManager.php', 'Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\ParamConverterManager->applyConverter', 48, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/sensio/framework-extra-bundle/src/EventListener/ParamConverterListener.php', 'Sensio\\Bundle\\FrameworkExtraBundle\\Request\\ParamConverter\\ParamConverterManager->apply', 72, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/event-dispatcher/Debug/WrappedListener.php', 'Sensio\\Bundle\\FrameworkExtraBundle\\EventListener\\ParamConverterListener->onKernelController', 117, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/event-dispatcher/EventDispatcher.php', 'Symfony\\Component\\EventDispatcher\\Debug\\WrappedListener->__invoke', 230, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/event-dispatcher/EventDispatcher.php', 'Symfony\\Component\\EventDispatcher\\EventDispatcher->callListeners', 59, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php', 'Symfony\\Component\\EventDispatcher\\EventDispatcher->dispatch', 154, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/http-kernel/HttpKernel.php', 'Symfony\\Component\\EventDispatcher\\Debug\\TraceableEventDispatcher->dispatch', 140, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/http-kernel/HttpKernel.php', 'Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw', 74, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/http-kernel/Kernel.php', 'Symfony\\Component\\HttpKernel\\HttpKernel->handle', 202, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php', 'Symfony\\Component\\HttpKernel\\Kernel->handle', 35, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/vendor/autoload_runtime.php', 'Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run', 35, NULL, 88088);

INSERT INTO bug_trace (file, function, line, path, bug_id)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO bug_trace (file, function, line, path, bug_id) VALUES ('/var/www/lunedi.oimmei.com/public/index.php', 'require_once', 5, NULL, 88088);

INSERT INTO bug_cookie (cookie_key, cookie_value, bug_id)
VALUES
  (?, ?, ?)

INSERT INTO bug_cookie (cookie_key, cookie_value, bug_id) VALUES ('sf_redirect', '{\"token\":\"af76cc\",\"route\":\"category_edit\",\"method\":\"GET\",\"controller\":{\"class\":\"Symfony\\\\Bundle\\\\FrameworkBundle\\\\Controller\\\\RedirectController\",\"method\":\"urlRedirectAction\",\"file\":\"\\/var\\/www\\/lunedi.oimmei.com\\/vendor\\/symfony\\/framework-bundle\\/Controller\\/RedirectController.php\",\"line\":110},\"status_code\":301,\"status_text\":\"Moved Permanently\"}', 88088);

"COMMIT"

"COMMIT";

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

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

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
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type != 'VIEW'

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

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

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,
  pg_class c,
  pg_type t,
  pg_namespace n
WHERE
  n.nspname NOT IN (
    'pg_catalog', 'information_schema',
    'pg_toast'
  )
  AND c.relname = 'doctrine_migration_versions'
  AND n.nspname = ANY(
    current_schemas(false)
  )
  AND a.attnum > 0
  AND a.attrelid = c.oid
  AND a.atttypid = t.oid
  AND n.oid = c.relnamespace
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, pg_class c, pg_type t, pg_namespace n
                    WHERE n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND c.relname = 'doctrine_migration_versions' AND n.nspname = ANY(current_schemas(false))
                        AND a.attnum > 0
                        AND a.attrelid = c.oid
                        AND a.atttypid = t.oid
                        AND n.oid = c.relnamespace
                    ORDER BY a.attnum;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

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

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

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  quote_ident(relname) as relname,
  pg_index.indisunique,
  pg_index.indisprimary,
  pg_index.indkey,
  pg_index.indrelid,
  pg_get_expr(indpred, indrelid) AS
where
FROM
  pg_class,
  pg_index
WHERE
  oid IN (
    SELECT
      indexrelid
    FROM
      pg_index si,
      pg_class sc,
      pg_namespace sn
    WHERE
      sn.nspname NOT IN (
        'pg_catalog', 'information_schema',
        'pg_toast'
      )
      AND sc.relname = 'doctrine_migration_versions'
      AND sn.nspname = ANY(
        current_schemas(false)
      )
      AND sc.oid = si.indrelid
      AND sc.relnamespace = sn.oid
  )
  AND pg_index.indexrelid = oid

SELECT quote_ident(relname) as relname, pg_index.indisunique, pg_index.indisprimary,
                       pg_index.indkey, pg_index.indrelid,
                       pg_get_expr(indpred, indrelid) AS where
                 FROM pg_class, pg_index
                 WHERE oid IN (
                    SELECT indexrelid
                    FROM pg_index si, pg_class sc, pg_namespace sn
                    WHERE sn.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') AND sc.relname = 'doctrine_migration_versions' AND sn.nspname = ANY(current_schemas(false))
                    AND sc.oid=si.indrelid AND sc.relnamespace = sn.oid
                 ) AND pg_index.indexrelid = oid;

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

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

SELECT
  obj_description(
    'doctrine_migration_versions' : :regclass
  ) AS table_comment;

SELECT obj_description('doctrine_migration_versions'::regclass) AS table_comment;;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();