Query Metrics
7
Database Queries
5
Different statements
2.92 ms
Query time
0
Invalid entities
Queries
tenant_manager_connection connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.29 ms |
SELECT t0.id_funcionario AS id_funcionario_1, t0.ulid AS ulid_2, t0.url_code AS url_code_3, t0.nome AS nome_4, t0.state AS state_5, t0.nome_comercial AS nome_comercial_6, t0.cargo AS cargo_7, t0.num_contribuinte AS num_contribuinte_8, t0.id_reparticoesfinancas AS id_reparticoesfinancas_9, t0.id_equipa AS id_equipa_10, t0.id_perfil AS id_perfil_11, t0.email AS email_12, t0.telefone AS telefone_13, t0.telemovel AS telemovel_14, t0.colaboradores AS colaboradores_15, t0.importador AS importador_16, t0.isento_irpc AS isento_irpc_17, t0.morada AS morada_18, t0.chave AS chave_19, t0.admin_created AS admin_created_20, t0.trial_ends_at AS trial_ends_at_21, t0.OAuth_client_secret AS OAuth_client_secret_22, t0.codigoPostal AS codigoPostal_23, t0.id_concelho AS id_concelho_24, t0.ano_contab AS ano_contab_25, t0.settings AS settings_26, t0.mw AS mw_27, t0.mw_token_status AS mw_token_status_28, t0.mw_token_checked_at AS mw_token_checked_at_29, t0.emitir_dfe AS emitir_dfe_30, t0.rodape_fatura AS rodape_fatura_31, t0.fotografia AS fotografia_32, t0.info_banco AS info_banco_33, t0.file_id AS file_id_34, t0.provisioning_status AS provisioning_status_35, t0.deleted_at AS deleted_at_36 FROM company t0 WHERE t0.id_funcionario = ?
Parameters:
[
1375
]
|
| 2 | 0.35 ms |
SELECT COUNT(p.id) FROM permission p INNER JOIN company_has_permission chp ON chp.permission_id = p.id AND chp.company_id = ? INNER JOIN company_profile_has_permission cphp ON cphp.permission_id = p.id AND cphp.company_profile_id = ? WHERE p.name = ?
Parameters:
[ 1375 6 "associated_companies.list" ] |
| 3 | 0.89 ms |
SELECT COUNT(*) FROM (SELECT company.id_funcionario as id, company.ulid as ulid, tax_regime.name as tax_regime, company.nome as name, company.cargo as vat_number, company.ano_contab as accounting_year, company.chave as `key`, company.state as state, company.admin_created as admin_created, GROUP_CONCAT(DISTINCT user.nome ORDER BY user.nome SEPARATOR ', ') as associated_user_name, (SELECT COUNT(u.id_utilizador) FROM user_has_company u WHERE u.id_funcionario = company.id_funcionario AND u.deleted_at IS NULL) as num_users FROM company company INNER JOIN user_has_company user_has_company ON user_has_company.id_funcionario = company.id_funcionario AND user_has_company.deleted_at IS NULL LEFT JOIN tax_regime tax_regime ON tax_regime.id = company.id_equipa LEFT JOIN user user ON user.id_utilizador = user_has_company.id_utilizador AND user.deleted_at IS NULL WHERE (company.deleted_at IS NULL) AND (user_has_company.id_utilizador IN (SELECT id_utilizador FROM user WHERE user.id_funcionario = ?)) AND (company.state = ?) AND (user_has_company.id_utilizador = ?) GROUP BY company.id_funcionario ORDER BY company.nome asc) AS total_count
Parameters:
[ 1375 "1" "46" ] |
| 4 | 0.58 ms |
SELECT company.id_funcionario as id, company.ulid as ulid, tax_regime.name as tax_regime, company.nome as name, company.cargo as vat_number, company.ano_contab as accounting_year, company.chave as `key`, company.state as state, company.admin_created as admin_created, GROUP_CONCAT(DISTINCT user.nome ORDER BY user.nome SEPARATOR ', ') as associated_user_name, (SELECT COUNT(u.id_utilizador) FROM user_has_company u WHERE u.id_funcionario = company.id_funcionario AND u.deleted_at IS NULL) as num_users FROM company company INNER JOIN user_has_company user_has_company ON user_has_company.id_funcionario = company.id_funcionario AND user_has_company.deleted_at IS NULL LEFT JOIN tax_regime tax_regime ON tax_regime.id = company.id_equipa LEFT JOIN user user ON user.id_utilizador = user_has_company.id_utilizador AND user.deleted_at IS NULL WHERE (company.deleted_at IS NULL) AND (user_has_company.id_utilizador IN (SELECT id_utilizador FROM user WHERE user.id_funcionario = ?)) AND (company.state = ?) AND (user_has_company.id_utilizador = ?) GROUP BY company.id_funcionario ORDER BY company.nome asc LIMIT 25
Parameters:
[ 1375 "1" "46" ] |
| 5 | 0.23 ms |
SELECT t0.id_utilizador AS id_utilizador_1, t0.nome AS nome_2, t0.id_funcionario AS id_funcionario_3, t0.hashed_password AS hashed_password_4, t0.email AS email_5, t0.activo AS activo_6, t0.gerente AS gerente_7, t0.session_id AS session_id_8, t0.email_confirmation_token AS email_confirmation_token_9, t0.email_confirmed AS email_confirmed_10, t0.email_confirmation_date AS email_confirmation_date_11, t0.forgot_password_token AS forgot_password_token_12, t0.forgot_password_expires_at AS forgot_password_expires_at_13, t0.deleted_at AS deleted_at_14 FROM user t0 WHERE t0.id_utilizador = ?
Parameters:
[
46
]
|
| 6 | 0.31 ms |
SELECT COUNT(p.id) FROM permission p INNER JOIN company_has_permission chp ON chp.permission_id = p.id AND chp.company_id = ? INNER JOIN company_profile_has_permission cphp ON cphp.permission_id = p.id AND cphp.company_profile_id = ? WHERE p.name = ?
Parameters:
[ 1375 6 "associated_companies.action" ] |
| 7 | 0.29 ms |
SELECT COUNT(p.id) FROM permission p INNER JOIN company_has_permission chp ON chp.permission_id = p.id AND chp.company_id = ? INNER JOIN company_profile_has_permission cphp ON cphp.permission_id = p.id AND cphp.company_profile_id = ? WHERE p.name = ?
Parameters:
[ 1375 6 "associated_companies.action" ] |
Database Connections
| Name | Service |
|---|---|
| app_connection | doctrine.dbal.app_connection_connection |
| tenant_manager_connection | doctrine.dbal.tenant_manager_connection_connection |
| provisioning_connection | doctrine.dbal.provisioning_connection_connection |
| queue_connection | doctrine.dbal.queue_connection_connection |
Entity Managers
| Name | Service |
|---|---|
| app | doctrine.orm.app_entity_manager |
| tenantManager | doctrine.orm.tenantManager_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
app entity manager
No loaded entities.