Symfony Profiler

Query Metrics

52 Database Queries

19 Different statements

42.10 ms Query time

0 Invalid entities

9 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.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 MAX(ABS(q0_.quote_id)) AS sclr_0 FROM quotes q0_ WHERE (HEX(q0_.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 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 COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.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 (?)) 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 COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.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 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(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))
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 COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'))

#▲	Time	Info
1	0.35 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	1.85 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.72 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.45 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.48 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.33 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
9	1.41 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.31 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
11	2.22 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.26 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
13	1.13 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.23 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
15	1.53 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.48 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;
17	0.44 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	1.94 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.26 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
20	1.54 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.25 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
22	2.85 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.31 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
24	1.59 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.28 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
26	1.86 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.17 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
28	0.95 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.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
30	1.56 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.36 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;
32	0.74 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.48 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.75 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'));
35	0.79 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;
36	0.65 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.65 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/id_generation/strategy"`] 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/id_generation/strategy' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
38	0.30 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/id_generation/id_prefix"`] 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/id_generation/id_prefix' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
39	0.29 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/id_generation/id_suffix"`] 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/id_generation/id_suffix' AND ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) LIMIT 1;
40	0.36 ms	SELECT MAX(ABS(q0_.quote_id)) AS sclr_0 FROM quotes q0_ WHERE (HEX(q0_.company_id) = '019EF3D970DCDCFC2B9CFACB01688126') Parameters: [] View formatted query View runnable query Explain query 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');
41	0.57 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;
42	0.71 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;
43	0.55 ms	SELECT COUNT() FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM tax_rates t0 WHERE ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
44	0.62 ms	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') Parameters: [`b"\x01žóìZnŽlí›ÁI†Þë"`] View formatted query View runnable query Explain query 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');
45	0.52 ms	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') Parameters: [`b"\x01žóìZnŽlí›ÁI†Þë"`] View formatted query View runnable query Explain query 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');
46	0.66 ms	SELECT COUNT() FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM tax_rates t0 WHERE ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
47	0.55 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
48	0.85 ms	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') Parameters: [] View formatted query View runnable query Explain query 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');
49	0.69 ms	SELECT COUNT() FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM tax_rates t0 WHERE ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
50	0.38 ms	SELECT COUNT() FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM tax_rates t0 WHERE ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
51	0.76 ms	SELECT COUNT() FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM tax_rates t0 WHERE ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT COUNT(*) FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126'));
52	0.42 ms	SELECT COUNT() FROM tax_rates t0 WHERE ((HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126')) Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM tax_rates t0 WHERE ( ( HEX(t0.company_id) = '019EF3D970DCDCFC2B9CFACB01688126' ) ) SELECT COUNT(*) FROM tax_rates t0 WHERE ((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	4
SolidInvoice\UserBundle\Entity\User	1
SolidInvoice\CoreBundle\Entity\Company	1
SolidInvoice\ClientBundle\Entity\Client	1
SolidInvoice\ClientBundle\Entity\Credit	1
SolidInvoice\ClientBundle\Entity\Contact	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\TaxIdentifier	No errors.
SolidInvoice\CoreBundle\Entity\CustomField\CustomField	No errors.

Symfony Profiler

POST https://finances.ddsteelfabrication.co.za/_components/CreateQuote

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping