Symfony Profiler

Query Metrics

52 Database Queries

22 Different statements

39.92 ms Query time

0 Invalid entities

15 Managed entities

Queries


SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT @@character_set_database, @@collation_database
SELECT DATABASE()
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 DATABASE()
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 DATABASE()
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 DATABASE()
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 DATABASE()
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 * FROM migration_versions
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
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 DATABASE()
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 DATABASE()
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 DATABASE()
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 DATABASE()
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 * FROM migration_versions
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 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.quote_id AS quote_id_2, t0.uuid AS uuid_3, t0.status AS status_4, t0.total_amount AS total_amount_5, t0.baseTotal_amount AS baseTotal_amount_6, t0.tax_amount AS tax_amount_7, t0.withholding_amount AS withholding_amount_8, t0.payable_amount AS payable_amount_9, t0.terms AS terms_10, t0.notes AS notes_11, t0.due AS due_12, t0.archived AS archived_13, t0.created AS created_14, t0.updated AS updated_15, t0.discount_valueMoney_amount AS discount_valueMoney_amount_16, t0.discount_value_percentage AS discount_value_percentage_17, t0.discount_type AS discount_type_18, t0.client_id AS client_id_19, t20.total_amount AS total_amount_21, t20.baseTotal_amount AS baseTotal_amount_22, t20.tax_amount AS tax_amount_23, t20.terms AS terms_24, t20.notes AS notes_25, t20.withholding_amount AS withholding_amount_26, t20.payable_amount AS payable_amount_27, t20.status AS status_28, t20.id AS id_29, t20.invoice_id AS invoice_id_30, t20.uuid AS uuid_31, t20.balance_amount AS balance_amount_32, t20.due AS due_33, t20.invoice_date AS invoice_date_34, t20.paid_date AS paid_date_35, t20.archived AS archived_36, t20.created AS created_37, t20.updated AS updated_38, t20.discount_valueMoney_amount AS discount_valueMoney_amount_39, t20.discount_value_percentage AS discount_value_percentage_40, t20.discount_type AS discount_type_41, t20.company_id AS company_id_42, t20.client_id AS client_id_43, t20.quote_id AS quote_id_44, t20.recurring_invoice_id AS recurring_invoice_id_45, t0.company_id AS company_id_46 FROM quotes t0 LEFT JOIN invoices t20 ON t20.quote_id = t0.id AND (((t20.archived IS NULL OR t20.archived = 0)) AND (HEX(t20.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 = ? AND (((t0.archived IS NULL OR t0.archived = 0)) AND (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 = ? 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 = ? 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 = ? 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 = ? 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 = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1
SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.value AS value_2, t0_.is_primary AS is_primary_3, t0_.created AS created_4, t0_.updated AS updated_5, t0_.client_id AS client_id_6, t0_.company_id AS company_id_7 FROM tax_identifier t0_ WHERE (t0_.client_id IS NULL AND t0_.company_id = ?) AND (HEX(t0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126') ORDER BY t0_.is_primary DESC, t0_.label ASC
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 = ? 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 = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1
SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.is_primary AS is_primary_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM tax_identifier t0 WHERE t0.client_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))
SELECT t0.id AS id_1, t0.street1 AS street1_2, t0.street2 AS street2_3, t0.city AS city_4, t0.state AS state_5, t0.zip AS zip_6, t0.country AS country_7, t0.created AS created_8, t0.updated AS updated_9, t0.client_id AS client_id_10, t0.company_id AS company_id_11 FROM addresses t0 WHERE t0.client_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))
SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.email AS email_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM contacts t0 INNER JOIN quote_contact ON t0.id = quote_contact.contact_id WHERE quote_contact.quote_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))
SELECT t0.id AS id_1, t0.description AS description_2, t0.price_amount AS price_amount_3, t0.qty AS qty_4, t0.total_amount AS total_amount_5, t0.created AS created_6, t0.updated AS updated_7, t0.quote_id AS quote_id_8, t0.company_id AS company_id_9 FROM quote_lines t0 WHERE t0.quote_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))
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 t0.id AS id_1, t0.name_snapshot AS name_snapshot_2, t0.rate_snapshot AS rate_snapshot_3, t0.category_snapshot AS category_snapshot_4, t0.type_snapshot AS type_snapshot_5, t0.compound AS compound_6, t0.sequence AS sequence_7, t0.amount AS amount_8, t0.snapshotted_at AS snapshotted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.tax_id AS tax_id_12, t0.invoice_line_id AS invoice_line_id_13, t0.quote_line_id AS quote_line_id_14, t0.company_id AS company_id_15 FROM line_tax t0 WHERE t0.quote_line_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.name_snapshot AS name_snapshot_3, t0.rate_snapshot AS rate_snapshot_4, t0.category_snapshot AS category_snapshot_5, t0.type_snapshot AS type_snapshot_6, t0.amount AS amount_7, t0.note AS note_8, t0.sequence AS sequence_9, t0.snapshotted_at AS snapshotted_at_10, t0.created AS created_11, t0.updated AS updated_12, t0.tax_id AS tax_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.recurring_invoice_id AS recurring_invoice_id_16, t0.company_id AS company_id_17 FROM invoice_tax t0 WHERE t0.quote_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))

#▲	Time	Info
1	0.38 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	1.31 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"finances_dds"`] View formatted query View runnable query Explain query 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;
3	0.31 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
4	1.37 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"finances_dds"`] View formatted query View runnable query Explain query 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;
5	0.41 ms	SELECT @@character_set_database, @@collation_database Parameters: [] View formatted query View runnable query Explain query SELECT @@character_set_database, @@collation_database SELECT @@character_set_database, @@collation_database;
6	0.24 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
7	2.01 ms	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 Parameters: [`"finances_dds" "finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
8	0.24 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
9	0.96 ms	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' Parameters: [`"finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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';
10	0.27 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
11	1.52 ms	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 Parameters: [`"finances_dds" "finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
12	0.22 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
13	0.83 ms	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 Parameters: [`"finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
14	0.19 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
15	1.15 ms	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 Parameters: [`"finances_dds" "finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
16	0.32 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;
17	0.45 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	1.91 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"finances_dds"`] View formatted query View runnable query Explain query 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;
19	0.27 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
20	1.57 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"finances_dds"`] View formatted query View runnable query Explain query 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;
21	0.26 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
22	2.59 ms	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 Parameters: [`"finances_dds" "finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
23	0.29 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
24	1.61 ms	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' Parameters: [`"finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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';
25	0.26 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
26	1.94 ms	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 Parameters: [`"finances_dds" "finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
27	0.28 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
28	1.24 ms	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 Parameters: [`"finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
29	0.21 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
30	2.01 ms	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 Parameters: [`"finances_dds" "finances_dds" "migration_versions"`] View formatted query View runnable query Explain query 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;
31	0.38 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;
32	0.91 ms	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 = ? Parameters: [`"admin@ddsteelfabrication.co.za" 1`] View formatted query View runnable query Explain query 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;
33	0.60 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.custom_domain AS custom_domain_3 FROM companies t0 WHERE t0.id = ? Parameters: [`b"\x01žóÙpÜÜü+œúË\x01h&"`] View formatted query View runnable query Explain query 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;
34	0.88 ms	SELECT t0.id AS id_1, t0.quote_id AS quote_id_2, t0.uuid AS uuid_3, t0.status AS status_4, t0.total_amount AS total_amount_5, t0.baseTotal_amount AS baseTotal_amount_6, t0.tax_amount AS tax_amount_7, t0.withholding_amount AS withholding_amount_8, t0.payable_amount AS payable_amount_9, t0.terms AS terms_10, t0.notes AS notes_11, t0.due AS due_12, t0.archived AS archived_13, t0.created AS created_14, t0.updated AS updated_15, t0.discount_valueMoney_amount AS discount_valueMoney_amount_16, t0.discount_value_percentage AS discount_value_percentage_17, t0.discount_type AS discount_type_18, t0.client_id AS client_id_19, t20.total_amount AS total_amount_21, t20.baseTotal_amount AS baseTotal_amount_22, t20.tax_amount AS tax_amount_23, t20.terms AS terms_24, t20.notes AS notes_25, t20.withholding_amount AS withholding_amount_26, t20.payable_amount AS payable_amount_27, t20.status AS status_28, t20.id AS id_29, t20.invoice_id AS invoice_id_30, t20.uuid AS uuid_31, t20.balance_amount AS balance_amount_32, t20.due AS due_33, t20.invoice_date AS invoice_date_34, t20.paid_date AS paid_date_35, t20.archived AS archived_36, t20.created AS created_37, t20.updated AS updated_38, t20.discount_valueMoney_amount AS discount_valueMoney_amount_39, t20.discount_value_percentage AS discount_value_percentage_40, t20.discount_type AS discount_type_41, t20.company_id AS company_id_42, t20.client_id AS client_id_43, t20.quote_id AS quote_id_44, t20.recurring_invoice_id AS recurring_invoice_id_45, t0.company_id AS company_id_46 FROM quotes t0 LEFT JOIN invoices t20 ON t20.quote_id = t0.id AND (((t20.archived IS NULL OR t20.archived = 0)) AND (HEX(t20.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) WHERE t0.id = ? AND (((t0.archived IS NULL OR t0.archived = 0)) AND (HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [`b"\x01žóõŒŠAÒ&\x08e7\eëS‡"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.quote_id AS quote_id_2, t0.uuid AS uuid_3, t0.status AS status_4, t0.total_amount AS total_amount_5, t0.baseTotal_amount AS baseTotal_amount_6, t0.tax_amount AS tax_amount_7, t0.withholding_amount AS withholding_amount_8, t0.payable_amount AS payable_amount_9, t0.terms AS terms_10, t0.notes AS notes_11, t0.due AS due_12, t0.archived AS archived_13, t0.created AS created_14, t0.updated AS updated_15, t0.discount_valueMoney_amount AS discount_valueMoney_amount_16, t0.discount_value_percentage AS discount_value_percentage_17, t0.discount_type AS discount_type_18, t0.client_id AS client_id_19, t20.total_amount AS total_amount_21, t20.baseTotal_amount AS baseTotal_amount_22, t20.tax_amount AS tax_amount_23, t20.terms AS terms_24, t20.notes AS notes_25, t20.withholding_amount AS withholding_amount_26, t20.payable_amount AS payable_amount_27, t20.status AS status_28, t20.id AS id_29, t20.invoice_id AS invoice_id_30, t20.uuid AS uuid_31, t20.balance_amount AS balance_amount_32, t20.due AS due_33, t20.invoice_date AS invoice_date_34, t20.paid_date AS paid_date_35, t20.archived AS archived_36, t20.created AS created_37, t20.updated AS updated_38, t20.discount_valueMoney_amount AS discount_valueMoney_amount_39, t20.discount_value_percentage AS discount_value_percentage_40, t20.discount_type AS discount_type_41, t20.company_id AS company_id_42, t20.client_id AS client_id_43, t20.quote_id AS quote_id_44, t20.recurring_invoice_id AS recurring_invoice_id_45, t0.company_id AS company_id_46 FROM quotes t0 LEFT JOIN invoices t20 ON t20.quote_id = t0.id AND ( ( ( t20.archived IS NULL OR t20.archived = 0 ) ) AND ( HEX(t20.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.quote_id AS quote_id_2, t0.uuid AS uuid_3, t0.status AS status_4, t0.total_amount AS total_amount_5, t0.baseTotal_amount AS baseTotal_amount_6, t0.tax_amount AS tax_amount_7, t0.withholding_amount AS withholding_amount_8, t0.payable_amount AS payable_amount_9, t0.terms AS terms_10, t0.notes AS notes_11, t0.due AS due_12, t0.archived AS archived_13, t0.created AS created_14, t0.updated AS updated_15, t0.discount_valueMoney_amount AS discount_valueMoney_amount_16, t0.discount_value_percentage AS discount_value_percentage_17, t0.discount_type AS discount_type_18, t0.client_id AS client_id_19, t20.total_amount AS total_amount_21, t20.baseTotal_amount AS baseTotal_amount_22, t20.tax_amount AS tax_amount_23, t20.terms AS terms_24, t20.notes AS notes_25, t20.withholding_amount AS withholding_amount_26, t20.payable_amount AS payable_amount_27, t20.status AS status_28, t20.id AS id_29, t20.invoice_id AS invoice_id_30, t20.uuid AS uuid_31, t20.balance_amount AS balance_amount_32, t20.due AS due_33, t20.invoice_date AS invoice_date_34, t20.paid_date AS paid_date_35, t20.archived AS archived_36, t20.created AS created_37, t20.updated AS updated_38, t20.discount_valueMoney_amount AS discount_valueMoney_amount_39, t20.discount_value_percentage AS discount_value_percentage_40, t20.discount_type AS discount_type_41, t20.company_id AS company_id_42, t20.client_id AS client_id_43, t20.quote_id AS quote_id_44, t20.recurring_invoice_id AS recurring_invoice_id_45, t0.company_id AS company_id_46 FROM quotes t0 LEFT JOIN invoices t20 ON t20.quote_id = t0.id AND (((t20.archived IS NULL OR t20.archived = 0)) AND (HEX(t20.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) WHERE t0.id = 0x019EF3F58C8A41D2260865371BEB5387 AND (((t0.archived IS NULL OR t0.archived = 0)) AND (HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
35	1.18 ms	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')) Parameters: [`b"\x01žóìZnŽlí›ÁI†Þë"`] View formatted query View runnable query Explain query 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'));
36	0.74 ms	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 Parameters: [`"system/company/currency"`] View formatted query View runnable query Explain query 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;
37	0.77 ms	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 Parameters: [`"system/company/primary_color"`] View formatted query View runnable query Explain query 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/primary_color' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
38	0.43 ms	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 Parameters: [`"quote/watermark"`] View formatted query View runnable query Explain query 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 = 'quote/watermark' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
39	0.76 ms	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 Parameters: [`"system/company/logo"`] View formatted query View runnable query Explain query 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/logo' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
40	0.49 ms	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 Parameters: [`"system/company/logo"`] View formatted query View runnable query Explain query 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/logo' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
41	0.50 ms	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 Parameters: [`"system/company/company_name"`] View formatted query View runnable query Explain query 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/company_name' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
42	0.58 ms	SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.value AS value_2, t0_.is_primary AS is_primary_3, t0_.created AS created_4, t0_.updated AS updated_5, t0_.client_id AS client_id_6, t0_.company_id AS company_id_7 FROM tax_identifier t0_ WHERE (t0_.client_id IS NULL AND t0_.company_id = ?) AND (HEX(t0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126') ORDER BY t0_.is_primary DESC, t0_.label ASC Parameters: [`b"\x01žóÙpÜÜü+œúË\x01h&"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.value AS value_2, t0_.is_primary AS is_primary_3, t0_.created AS created_4, t0_.updated AS updated_5, t0_.client_id AS client_id_6, t0_.company_id AS company_id_7 FROM tax_identifier t0_ WHERE ( t0_.client_id IS NULL AND t0_.company_id = ? ) AND ( HEX(t0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ORDER BY t0_.is_primary DESC, t0_.label ASC SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.value AS value_2, t0_.is_primary AS is_primary_3, t0_.created AS created_4, t0_.updated AS updated_5, t0_.client_id AS client_id_6, t0_.company_id AS company_id_7 FROM tax_identifier t0_ WHERE (t0_.client_id IS NULL AND t0_.company_id = 0x019EF3D970DCDCFC2B9CFACB01688126) AND (HEX(t0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126') ORDER BY t0_.is_primary DESC, t0_.label ASC;
43	0.52 ms	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 Parameters: [`"system/company/contact_details/email"`] View formatted query View runnable query Explain query 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/contact_details/email' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
44	0.32 ms	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 Parameters: [`"system/company/contact_details/phone_number"`] View formatted query View runnable query Explain query 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/contact_details/phone_number' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
45	0.28 ms	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 Parameters: [`"system/company/contact_details/address"`] View formatted query View runnable query Explain query 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/contact_details/address' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
46	0.74 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.is_primary AS is_primary_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM tax_identifier t0 WHERE t0.client_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [`b"\x01žóìZnŽlí›ÁI†Þë"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.is_primary AS is_primary_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM tax_identifier t0 WHERE t0.client_id = ? AND ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT t0.id AS id_1, t0.label AS label_2, t0.value AS value_3, t0.is_primary AS is_primary_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM tax_identifier t0 WHERE t0.client_id = 0x019EF3ECAD5A6E8D6CED9BC14986DEEB AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
47	0.49 ms	SELECT t0.id AS id_1, t0.street1 AS street1_2, t0.street2 AS street2_3, t0.city AS city_4, t0.state AS state_5, t0.zip AS zip_6, t0.country AS country_7, t0.created AS created_8, t0.updated AS updated_9, t0.client_id AS client_id_10, t0.company_id AS company_id_11 FROM addresses t0 WHERE t0.client_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [`b"\x01žóìZnŽlí›ÁI†Þë"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.street1 AS street1_2, t0.street2 AS street2_3, t0.city AS city_4, t0.state AS state_5, t0.zip AS zip_6, t0.country AS country_7, t0.created AS created_8, t0.updated AS updated_9, t0.client_id AS client_id_10, t0.company_id AS company_id_11 FROM addresses t0 WHERE t0.client_id = ? AND ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT t0.id AS id_1, t0.street1 AS street1_2, t0.street2 AS street2_3, t0.city AS city_4, t0.state AS state_5, t0.zip AS zip_6, t0.country AS country_7, t0.created AS created_8, t0.updated AS updated_9, t0.client_id AS client_id_10, t0.company_id AS company_id_11 FROM addresses t0 WHERE t0.client_id = 0x019EF3ECAD5A6E8D6CED9BC14986DEEB AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
48	0.50 ms	SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.email AS email_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM contacts t0 INNER JOIN quote_contact ON t0.id = quote_contact.contact_id WHERE quote_contact.quote_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [`b"\x01žóõŒŠAÒ&\x08e7\eëS‡"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.email AS email_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM contacts t0 INNER JOIN quote_contact ON t0.id = quote_contact.contact_id WHERE quote_contact.quote_id = ? AND ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.email AS email_4, t0.created AS created_5, t0.updated AS updated_6, t0.client_id AS client_id_7, t0.company_id AS company_id_8 FROM contacts t0 INNER JOIN quote_contact ON t0.id = quote_contact.contact_id WHERE quote_contact.quote_id = 0x019EF3F58C8A41D2260865371BEB5387 AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
49	0.43 ms	SELECT t0.id AS id_1, t0.description AS description_2, t0.price_amount AS price_amount_3, t0.qty AS qty_4, t0.total_amount AS total_amount_5, t0.created AS created_6, t0.updated AS updated_7, t0.quote_id AS quote_id_8, t0.company_id AS company_id_9 FROM quote_lines t0 WHERE t0.quote_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [`b"\x01žóõŒŠAÒ&\x08e7\eëS‡"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.description AS description_2, t0.price_amount AS price_amount_3, t0.qty AS qty_4, t0.total_amount AS total_amount_5, t0.created AS created_6, t0.updated AS updated_7, t0.quote_id AS quote_id_8, t0.company_id AS company_id_9 FROM quote_lines t0 WHERE t0.quote_id = ? AND ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT t0.id AS id_1, t0.description AS description_2, t0.price_amount AS price_amount_3, t0.qty AS qty_4, t0.total_amount AS total_amount_5, t0.created AS created_6, t0.updated AS updated_7, t0.quote_id AS quote_id_8, t0.company_id AS company_id_9 FROM quote_lines t0 WHERE t0.quote_id = 0x019EF3F58C8A41D2260865371BEB5387 AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
50	0.76 ms	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 Parameters: [`"QUOTE"`] View formatted query View runnable query Explain query 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;
51	0.64 ms	SELECT t0.id AS id_1, t0.name_snapshot AS name_snapshot_2, t0.rate_snapshot AS rate_snapshot_3, t0.category_snapshot AS category_snapshot_4, t0.type_snapshot AS type_snapshot_5, t0.compound AS compound_6, t0.sequence AS sequence_7, t0.amount AS amount_8, t0.snapshotted_at AS snapshotted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.tax_id AS tax_id_12, t0.invoice_line_id AS invoice_line_id_13, t0.quote_line_id AS quote_line_id_14, t0.company_id AS company_id_15 FROM line_tax t0 WHERE t0.quote_line_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [`b"\x01žõ<ý2\ef©^®\x1D.Š/¿"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name_snapshot AS name_snapshot_2, t0.rate_snapshot AS rate_snapshot_3, t0.category_snapshot AS category_snapshot_4, t0.type_snapshot AS type_snapshot_5, t0.compound AS compound_6, t0.sequence AS sequence_7, t0.amount AS amount_8, t0.snapshotted_at AS snapshotted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.tax_id AS tax_id_12, t0.invoice_line_id AS invoice_line_id_13, t0.quote_line_id AS quote_line_id_14, t0.company_id AS company_id_15 FROM line_tax t0 WHERE t0.quote_line_id = ? AND ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT t0.id AS id_1, t0.name_snapshot AS name_snapshot_2, t0.rate_snapshot AS rate_snapshot_3, t0.category_snapshot AS category_snapshot_4, t0.type_snapshot AS type_snapshot_5, t0.compound AS compound_6, t0.sequence AS sequence_7, t0.amount AS amount_8, t0.snapshotted_at AS snapshotted_at_9, t0.created AS created_10, t0.updated AS updated_11, t0.tax_id AS tax_id_12, t0.invoice_line_id AS invoice_line_id_13, t0.quote_line_id AS quote_line_id_14, t0.company_id AS company_id_15 FROM line_tax t0 WHERE t0.quote_line_id = 0x019EF53CFD321B66A95EAE1D2E8A2FBF AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
52	0.41 ms	SELECT t0.id AS id_1, t0.direction AS direction_2, t0.name_snapshot AS name_snapshot_3, t0.rate_snapshot AS rate_snapshot_4, t0.category_snapshot AS category_snapshot_5, t0.type_snapshot AS type_snapshot_6, t0.amount AS amount_7, t0.note AS note_8, t0.sequence AS sequence_9, t0.snapshotted_at AS snapshotted_at_10, t0.created AS created_11, t0.updated AS updated_12, t0.tax_id AS tax_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.recurring_invoice_id AS recurring_invoice_id_16, t0.company_id AS company_id_17 FROM invoice_tax t0 WHERE t0.quote_id = ? AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [`b"\x01žóõŒŠAÒ&\x08e7\eëS‡"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.direction AS direction_2, t0.name_snapshot AS name_snapshot_3, t0.rate_snapshot AS rate_snapshot_4, t0.category_snapshot AS category_snapshot_5, t0.type_snapshot AS type_snapshot_6, t0.amount AS amount_7, t0.note AS note_8, t0.sequence AS sequence_9, t0.snapshotted_at AS snapshotted_at_10, t0.created AS created_11, t0.updated AS updated_12, t0.tax_id AS tax_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.recurring_invoice_id AS recurring_invoice_id_16, t0.company_id AS company_id_17 FROM invoice_tax t0 WHERE t0.quote_id = ? AND ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT t0.id AS id_1, t0.direction AS direction_2, t0.name_snapshot AS name_snapshot_3, t0.rate_snapshot AS rate_snapshot_4, t0.category_snapshot AS category_snapshot_5, t0.type_snapshot AS type_snapshot_6, t0.amount AS amount_7, t0.note AS note_8, t0.sequence AS sequence_9, t0.snapshotted_at AS snapshotted_at_10, t0.created AS created_11, t0.updated AS updated_12, t0.tax_id AS tax_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.recurring_invoice_id AS recurring_invoice_id_16, t0.company_id AS company_id_17 FROM invoice_tax t0 WHERE t0.quote_id = 0x019EF3F58C8A41D2260865371BEB5387 AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
SolidInvoice\SettingsBundle\Entity\Setting	8
SolidInvoice\UserBundle\Entity\User	1
SolidInvoice\CoreBundle\Entity\Company	1
SolidInvoice\QuoteBundle\Entity\Quote	1
SolidInvoice\ClientBundle\Entity\Client	1
SolidInvoice\ClientBundle\Entity\Credit	1
SolidInvoice\ClientBundle\Entity\Contact	1
SolidInvoice\QuoteBundle\Entity\Line	1

Entities Mapping

Class	Mapping errors
SolidInvoice\UserBundle\Entity\User	No errors.
SolidInvoice\UserBundle\Entity\ApiToken	No errors.
SolidInvoice\CoreBundle\Entity\Company	No errors.
SolidInvoice\UserBundle\Entity\ApiTokenHistory	No errors.
SolidInvoice\TaxBundle\Entity\Tax	No errors.
SolidInvoice\ClientBundle\Entity\Address	No errors.
SolidInvoice\ClientBundle\Entity\Client	No errors.
SolidInvoice\ClientBundle\Entity\Contact	No errors.
SolidInvoice\ClientBundle\Entity\Credit	No errors.
SolidInvoice\UserBundle\Entity\UserInvitation	No errors.
SolidInvoice\SettingsBundle\Entity\Setting	No errors.
SolidInvoice\CoreBundle\Entity\Discount	No errors.
SolidInvoice\QuoteBundle\Entity\Quote	No errors.
SolidInvoice\QuoteBundle\Entity\Line	No errors.
SolidInvoice\PaymentBundle\Entity\PaymentMethod	No errors.
Payum\Core\Model\Payment	No errors.
SolidInvoice\PaymentBundle\Entity\Payment	No errors.
SolidInvoice\NotificationBundle\Entity\UserNotification	No errors.
SolidInvoice\NotificationBundle\Entity\TransportSetting	No errors.
SolidInvoice\InvoiceBundle\Entity\BaseInvoice	No errors.
SolidInvoice\InvoiceBundle\Entity\Invoice	No errors.
SolidInvoice\InvoiceBundle\Entity\RecurringInvoice	No errors.
SolidInvoice\InvoiceBundle\Entity\Line	No errors.
SolidInvoice\InvoiceBundle\Entity\InvoiceReminder	No errors.
SolidInvoice\TaxBundle\Entity\InvoiceTax	No errors.
SolidInvoice\TaxBundle\Entity\TaxIdentifier	No errors.
SolidInvoice\TaxBundle\Entity\LineTax	No errors.
SolidInvoice\CoreBundle\Entity\CustomField\CustomField	No errors.

Symfony Profiler

GET https://finances.ddsteelfabrication.co.za/quotes/view/01KVSZB34A8792C2356WDYPMW7.pdf

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping