Symfony Profiler

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'finances_dds'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  c.TABLE_NAME,
  c.COLUMN_NAME,
  c.DATA_TYPE,
  c.COLUMN_TYPE,
  c.CHARACTER_MAXIMUM_LENGTH,
  c.CHARACTER_OCTET_LENGTH,
  c.NUMERIC_PRECISION,
  c.NUMERIC_SCALE,
  c.IS_NULLABLE,
  c.COLUMN_DEFAULT,
  c.EXTRA,
  c.COLUMN_COMMENT,
  c.CHARACTER_SET_NAME,
  c.COLLATION_NAME
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY
  c.TABLE_NAME,
  c.ORDINAL_POSITION

SELECT c.TABLE_NAME,
       c.COLUMN_NAME,
       c.DATA_TYPE,
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE,
       c.COLUMN_DEFAULT,
       c.EXTRA,
       c.COLUMN_COMMENT,
       c.CHARACTER_SET_NAME,
       c.COLLATION_NAME
FROM information_schema.COLUMNS c
         INNER JOIN information_schema.TABLES t
                    ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = 'finances_dds' AND t.TABLE_SCHEMA = 'finances_dds' AND t.TABLE_NAME = 'migration_versions'
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION;

SELECT
  tc.TABLE_NAME,
  tc.CONSTRAINT_NAME,
  kcu.COLUMN_NAME
FROM
  information_schema.TABLE_CONSTRAINTS tc
  INNER JOIN information_schema.KEY_COLUMN_USAGE kcu ON kcu.TABLE_NAME = tc.TABLE_NAME
  AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE
  tc.TABLE_SCHEMA = ?
  AND kcu.TABLE_SCHEMA = ?
  AND tc.TABLE_NAME = ?
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY
  TABLE_NAME,
  kcu.ORDINAL_POSITION

SELECT tc.TABLE_NAME,
       tc.CONSTRAINT_NAME,
       kcu.COLUMN_NAME
FROM information_schema.TABLE_CONSTRAINTS tc
         INNER JOIN information_schema.KEY_COLUMN_USAGE kcu
                    ON kcu.TABLE_NAME = tc.TABLE_NAME
                        AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE tc.TABLE_SCHEMA = 'finances_dds' AND kcu.TABLE_SCHEMA = 'finances_dds' AND tc.TABLE_NAME = 'migration_versions'
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY TABLE_NAME,
    kcu.ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  COUNT(*)
FROM
  tax_rates t0
WHERE
  (
    (
      HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
    )
  )

SELECT COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3,
  t0.description AS description_4,
  t0.field_type AS field_type_5,
  t0.form_options AS form_options_6,
  t0.default_value AS default_value_7,
  t0.company_id AS company_id_8
FROM
  app_config t0
WHERE
  t0.setting_key = ?
  AND (
    (
      HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
    )
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.form_options AS form_options_6, t0.default_value AS default_value_7, t0.company_id AS company_id_8 FROM app_config t0 WHERE t0.setting_key = 'system/company/currency' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;

SELECT
  k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.REFERENCED_TABLE_NAME,
  c.UPDATE_RULE,
  c.DELETE_RULE,
  k.COLUMN_NAME,
  k.REFERENCED_COLUMN_NAME
FROM
  information_schema.KEY_COLUMN_USAGE k
  INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME
WHERE
  k.TABLE_SCHEMA = ?
  AND c.CONSTRAINT_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY
  k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.ORDINAL_POSITION

SELECT k.TABLE_NAME,
       k.CONSTRAINT_NAME,
       k.REFERENCED_TABLE_NAME,
       c.UPDATE_RULE,
       c.DELETE_RULE,
       k.COLUMN_NAME,
       k.REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE k
         INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c
                    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
                        AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = 'finances_dds' AND c.CONSTRAINT_SCHEMA = 'finances_dds' AND k.TABLE_NAME = 'migration_versions'
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION;

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'finances_dds' AND t.TABLE_NAME = 'migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  TABLE_NAME,
  INDEX_NAME,
  INDEX_TYPE,
  NON_UNIQUE,
  COLUMN_NAME,
  SUB_PART
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
  AND INDEX_NAME != 'PRIMARY'
ORDER BY
  TABLE_NAME,
  SEQ_IN_INDEX

SELECT TABLE_NAME,
       INDEX_NAME,
       INDEX_TYPE,
       NON_UNIQUE,
       COLUMN_NAME,
       SUB_PART
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = 'finances_dds' AND TABLE_NAME = 'migration_versions'
  AND INDEX_NAME != 'PRIMARY'
ORDER BY TABLE_NAME,
    SEQ_IN_INDEX;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  clients c0_
WHERE
  (
    (
      c0_.archived IS NULL
      OR c0_.archived = 0
    )
  )
  AND (
    HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM clients c0_ WHERE ((c0_.archived IS NULL OR c0_.archived = 0)) AND (HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126');

SELECT
  *
FROM
  migration_versions

SELECT * FROM migration_versions;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.website AS website_3,
  t0.status AS status_4,
  t0.currency AS currency_5,
  t0.archived AS archived_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t9.id AS id_10,
  t9.value_amount AS value_amount_11,
  t9.created AS created_12,
  t9.updated AS updated_13,
  t9.client_id AS client_id_14,
  t9.company_id AS company_id_15,
  t0.company_id AS company_id_16
FROM
  clients t0
  LEFT JOIN client_credit t9 ON t9.client_id = t0.id
  AND (
    (
      HEX(t9.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
    )
  )
WHERE
  t0.id = ?
  AND (
    (
      (
        t0.archived IS NULL
        OR t0.archived = 0
      )
    )
    AND (
      HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
    )
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.status AS status_4, t0.currency AS currency_5, t0.archived AS archived_6, t0.created AS created_7, t0.updated AS updated_8, t9.id AS id_10, t9.value_amount AS value_amount_11, t9.created AS created_12, t9.updated AS updated_13, t9.client_id AS client_id_14, t9.company_id AS company_id_15, t0.company_id AS company_id_16 FROM clients t0 LEFT JOIN client_credit t9 ON t9.client_id = t0.id AND ((HEX(t9.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) WHERE t0.id = 0x019EF3ECAD5A6E8D6CED9BC14986DEEB AND (((t0.archived IS NULL OR t0.archived = 0)) AND (HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));

SELECT
  u0_.id AS id_0,
  u0_.first_name AS first_name_1,
  u0_.last_name AS last_name_2,
  u0_.mobile AS mobile_3,
  u0_.email AS email_4,
  u0_.enabled AS enabled_5,
  u0_.verified AS verified_6,
  u0_.password AS password_7,
  u0_.last_login AS last_login_8,
  u0_.roles AS roles_9,
  u0_.google_id AS google_id_10,
  u0_.created AS created_11,
  u0_.updated AS updated_12,
  u0_.totp_secret AS totp_secret_13,
  u0_.auth_code AS auth_code_14,
  u0_.email_auth_enabled AS email_auth_enabled_15,
  u0_.trusted_version AS trusted_version_16,
  u0_.backup_codes AS backup_codes_17
FROM
  users u0_
WHERE
  (u0_.email = ?)
  AND u0_.enabled = ?

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.mobile AS mobile_3, u0_.email AS email_4, u0_.enabled AS enabled_5, u0_.verified AS verified_6, u0_.password AS password_7, u0_.last_login AS last_login_8, u0_.roles AS roles_9, u0_.google_id AS google_id_10, u0_.created AS created_11, u0_.updated AS updated_12, u0_.totp_secret AS totp_secret_13, u0_.auth_code AS auth_code_14, u0_.email_auth_enabled AS email_auth_enabled_15, u0_.trusted_version AS trusted_version_16, u0_.backup_codes AS backup_codes_17 FROM users u0_ WHERE (u0_.email = 'admin@ddsteelfabrication.co.za') AND u0_.enabled = 1;

SELECT
  c0_.id AS id_0,
  c0_.target AS target_1,
  c0_.label AS label_2,
  c0_.field_key AS field_key_3,
  c0_.type AS type_4,
  c0_.options AS options_5,
  c0_.default_value AS default_value_6,
  c0_.visibility AS visibility_7,
  c0_.required AS required_8,
  c0_.position AS position_9,
  c0_.created AS created_10,
  c0_.updated AS updated_11,
  c0_.company_id AS company_id_12
FROM
  custom_field c0_
WHERE
  (c0_.target = ?)
  AND (
    HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
  )
ORDER BY
  c0_.position ASC,
  c0_.label ASC

SELECT c0_.id AS id_0, c0_.target AS target_1, c0_.label AS label_2, c0_.field_key AS field_key_3, c0_.type AS type_4, c0_.options AS options_5, c0_.default_value AS default_value_6, c0_.visibility AS visibility_7, c0_.required AS required_8, c0_.position AS position_9, c0_.created AS created_10, c0_.updated AS updated_11, c0_.company_id AS company_id_12 FROM custom_field c0_ WHERE (c0_.target = 'QUOTE') AND (HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126') ORDER BY c0_.position ASC, c0_.label ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.website AS website_2,
  c0_.status AS status_3,
  c0_.currency AS currency_4,
  c0_.archived AS archived_5,
  c0_.created AS created_6,
  c0_.updated AS updated_7,
  c0_.company_id AS company_id_8
FROM
  clients c0_
WHERE
  (
    c0_.id IN (?)
  )
  AND (
    (
      c0_.archived IS NULL
      OR c0_.archived = 0
    )
  )
  AND (
    HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
  )

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.website AS website_2, c0_.status AS status_3, c0_.currency AS currency_4, c0_.archived AS archived_5, c0_.created AS created_6, c0_.updated AS updated_7, c0_.company_id AS company_id_8 FROM clients c0_ WHERE (c0_.id IN (0x019EF3ECAD5A6E8D6CED9BC14986DEEB)) AND ((c0_.archived IS NULL OR c0_.archived = 0)) AND (HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126');

SELECT
  c0_.id AS id_0,
  c0_.firstName AS firstName_1,
  c0_.lastName AS lastName_2,
  c0_.email AS email_3,
  c0_.created AS created_4,
  c0_.updated AS updated_5,
  c0_.client_id AS client_id_6,
  c0_.company_id AS company_id_7
FROM
  contacts c0_
WHERE
  (c0_.client_id = ?)
  AND (
    HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
  )

SELECT c0_.id AS id_0, c0_.firstName AS firstName_1, c0_.lastName AS lastName_2, c0_.email AS email_3, c0_.created AS created_4, c0_.updated AS updated_5, c0_.client_id AS client_id_6, c0_.company_id AS company_id_7 FROM contacts c0_ WHERE (c0_.client_id = 0x019EF3ECAD5A6E8D6CED9BC14986DEEB) AND (HEX(c0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.custom_domain AS custom_domain_3
FROM
  companies t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.custom_domain AS custom_domain_3 FROM companies t0 WHERE t0.id = 0x019EF3D970DCDCFC2B9CFACB01688126;

SELECT
  @@character_set_database,
  @@collation_database

SELECT @@character_set_database, @@collation_database;

SELECT
  MAX(
    ABS(q0_.quote_id)
  ) AS sclr_0
FROM
  quotes q0_
WHERE
  (
    HEX(q0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'
  )

SELECT MAX(ABS(q0_.quote_id)) AS sclr_0 FROM quotes q0_ WHERE (HEX(q0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126');