Query Metrics
59
Database Queries
13
Different statements
4135.18 ms
Query time
6
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.52 ms |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.password AS password_5, t0.phone_number AS phone_number_6, t0.roles AS roles_7, t0.is_actif AS is_actif_8, t0.registration_token AS registration_token_9, t0.avatar AS avatar_10, t0.forgotpwd_token AS forgotpwd_token_11, t0.googleAuthenticatorSecret AS googleAuthenticatorSecret_12, t0.is_enabled2_fa AS is_enabled2_fa_13, t0.is_enable_notif AS is_enable_notif_14, t0.is_deleted AS is_deleted_15, t0.attempt_recover_pwd AS attempt_recover_pwd_16, t0.forgot_pwd_expire_at AS forgot_pwd_expire_at_17, t0.api_token AS api_token_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"[email protected]"
]
|
2 | 0.60 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.title AS title_3, t0.website AS website_4, t0.country AS country_5, t0.address AS address_6, t0.num_employees AS num_employees_7, t0.is_added AS is_added_8, t0.is_demo AS is_demo_9, t0.avatar AS avatar_10, t0.quota AS quota_11, t0.industry_id AS industry_id_12 FROM organisation t0 INNER JOIN user_organisation ON t0.id = user_organisation.organisation_id WHERE user_organisation.user_id = ?
Parameters:
[
125
]
|
3 | 0.55 ms |
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.is_actif AS is_actif_4, t0.plan_id AS plan_id_5, t6.id AS id_7, t6.nbr_domains AS nbr_domains_8, t6.name AS name_9, t6.price AS price_10, t6.color AS color_11, t6.is_deleted AS is_deleted_12, t6.created_at AS created_at_13, t6.updated_at AS updated_at_14, t0.organisation_id AS organisation_id_15, t16.id AS id_17, t16.uuid AS uuid_18, t16.title AS title_19, t16.website AS website_20, t16.country AS country_21, t16.address AS address_22, t16.num_employees AS num_employees_23, t16.is_added AS is_added_24, t16.is_demo AS is_demo_25, t16.avatar AS avatar_26, t16.quota AS quota_27, t16.industry_id AS industry_id_28 FROM subscription t0 INNER JOIN plan t6 ON t0.plan_id = t6.id INNER JOIN organisation t16 ON t0.organisation_id = t16.id WHERE t0.organisation_id IN (?)
Parameters:
[
118
]
|
4 | 3.67 ms |
SELECT s0_.id AS id_0, s0_.start_date AS start_date_1, s0_.end_date AS end_date_2, s0_.is_actif AS is_actif_3, s0_.plan_id AS plan_id_4, s0_.organisation_id AS organisation_id_5 FROM subscription s0_ INNER JOIN organisation o1_ ON s0_.organisation_id = o1_.id WHERE o1_.is_added = ? AND s0_.is_actif = ? AND o1_.id = ? AND DATE_FORMAT(s0_.end_date, '%Y-%m-%d') >= ? ORDER BY s0_.id ASC
Parameters:
[ 1 1 118 "2025-04-27" ] |
5 | 5.89 ms |
SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ INNER JOIN user_organisation u2_ ON u0_.id = u2_.user_id INNER JOIN organisation o1_ ON o1_.id = u2_.organisation_id WHERE u0_.id = ?
Parameters:
[
125
]
|
6 | 0.45 ms |
SELECT d0_.id AS id_0, d0_.url AS url_1, d0_.is_enabled AS is_enabled_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.organisation_id AS organisation_id_5 FROM domain d0_ INNER JOIN organisation o1_ ON d0_.organisation_id = o1_.id INNER JOIN user_organisation u3_ ON o1_.id = u3_.organisation_id INNER JOIN user u2_ ON u2_.id = u3_.user_id WHERE u2_.id = ? AND o1_.is_added = 1 AND d0_.id = ?
Parameters:
[ 125 163 ] |
7 | 9.82 ms |
SELECT s0_.id AS id_0, s0_.start_date AS start_date_1, s0_.end_date AS end_date_2, s0_.is_actif AS is_actif_3, s0_.plan_id AS plan_id_4, s0_.organisation_id AS organisation_id_5 FROM subscription s0_ INNER JOIN organisation o1_ ON s0_.organisation_id = o1_.id WHERE o1_.is_added = ? AND s0_.is_actif = ? AND o1_.id = ? AND DATE_FORMAT(s0_.end_date, '%Y-%m-%d') >= ? ORDER BY s0_.id ASC
Parameters:
[ 1 1 118 "2025-04-27" ] |
8 | 4003.10 ms |
SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM dark_owl d0_ INNER JOIN domain d1_ ON d0_.domain_id = d1_.id INNER JOIN organisation o2_ ON d1_.organisation_id = o2_.id INNER JOIN user_organisation u4_ ON o2_.id = u4_.organisation_id INNER JOIN user u3_ ON u3_.id = u4_.user_id WHERE (LOWER(d0_.title) LIKE ? OR LOWER(d0_.body) LIKE ? OR LOWER(d0_.source) LIKE ? OR LOWER(d0_.crawl_date) LIKE ? OR LOWER(d0_.url) LIKE ? OR LOWER(d0_.document_id) LIKE ?) AND u3_.id = ? AND o2_.is_added = 1 AND d1_.id = ?
Parameters:
[ "%%" "%%" "%%" "%%" "%%" "%%" 125 "163" ] |
9 | 2.62 ms |
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.body AS body_2, d0_.source AS source_3, d0_.crawl_date AS crawl_date_4, d0_.hackishness AS hackishness_5, d0_.url AS url_6, d0_.file_size AS file_size_7, d0_.document_id AS document_id_8, d0_.domain_id AS domain_id_9, d0_.leak_info_id AS leak_info_id_10 FROM dark_owl d0_ INNER JOIN domain d1_ ON d0_.domain_id = d1_.id INNER JOIN organisation o2_ ON d1_.organisation_id = o2_.id INNER JOIN user_organisation u4_ ON o2_.id = u4_.organisation_id INNER JOIN user u3_ ON u3_.id = u4_.user_id WHERE (LOWER(d0_.title) LIKE ? OR LOWER(d0_.body) LIKE ? OR LOWER(d0_.source) LIKE ? OR LOWER(d0_.crawl_date) LIKE ? OR LOWER(d0_.url) LIKE ? OR LOWER(d0_.document_id) LIKE ?) AND u3_.id = ? AND o2_.is_added = 1 AND d1_.id = ? LIMIT 11
Parameters:
[ "%%" "%%" "%%" "%%" "%%" "%%" 125 "163" ] |
10 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
2798
]
|
11 | 12.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
2798
]
|
12 | 0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
2798
]
|
13 | 1.90 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
2798
]
|
14 | 3.25 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
2798
]
|
15 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
2799
]
|
16 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
2799
]
|
17 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
2799
]
|
18 | 0.29 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
2799
]
|
19 | 38.69 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
2799
]
|
20 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
2800
]
|
21 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
2800
]
|
22 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
2800
]
|
23 | 0.31 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
2800
]
|
24 | 2.11 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
2800
]
|
25 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
2801
]
|
26 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
2801
]
|
27 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
2801
]
|
28 | 0.30 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
2801
]
|
29 | 14.42 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
2801
]
|
30 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
2802
]
|
31 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
2802
]
|
32 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
2802
]
|
33 | 0.32 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
2802
]
|
34 | 14.65 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
2802
]
|
35 | 0.54 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
13710
]
|
36 | 1.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
13710
]
|
37 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
13710
]
|
38 | 0.30 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
13710
]
|
39 | 5.51 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
13710
]
|
40 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
13711
]
|
41 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
13711
]
|
42 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
13711
]
|
43 | 0.30 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
13711
]
|
44 | 0.29 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
13711
]
|
45 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
13712
]
|
46 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
13712
]
|
47 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
13712
]
|
48 | 0.26 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
13712
]
|
49 | 0.32 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
13712
]
|
50 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
13713
]
|
51 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
13713
]
|
52 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
13713
]
|
53 | 0.28 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
13713
]
|
54 | 0.27 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
13713
]
|
55 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.host AS host_3, t0.file_path AS file_path_4, t0.file_name AS file_name_5 FROM leak_info t0 WHERE t0.id = ?
Parameters:
[
13714
]
|
56 | 0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_actor t0 WHERE t0.leak_info_id = ?
Parameters:
[
13714
]
|
57 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.leak_info_id AS leak_info_id_3 FROM leak_association t0 WHERE t0.leak_info_id = ?
Parameters:
[
13714
]
|
58 | 0.26 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.leak_info_id AS leak_info_id_3 FROM leak_download t0 WHERE t0.leak_info_id = ?
Parameters:
[
13714
]
|
59 | 0.27 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.dark_owl_id AS dark_owl_id_3 FROM leak_email t0 WHERE t0.dark_owl_id = ?
Parameters:
[
13714
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
App\Entity\RefreshToken | No errors. |
App\Entity\User | No errors. |
App\Entity\Service | No errors. |
App\Entity\Organisation | No errors. |
App\Entity\WebServiceLog | No errors. |
App\Entity\Industry | No errors. |
App\Entity\BankIdentification | No errors. |
App\Entity\LeakedIp | No errors. |
App\Entity\Cryptocurrency | No errors. |
App\Entity\Domain |
|
App\Entity\GitDepot | No errors. |
App\Entity\ExposedIp | No errors. |
App\Entity\Subscription | No errors. |
App\Entity\LeakedPassword | No errors. |
App\Entity\UserToNotify | No errors. |
App\Entity\CronLog | No errors. |
App\Entity\InternalSecurityAnswer |
|
App\Entity\Plan | No errors. |
App\Entity\ExposedSubDomain | No errors. |
App\Entity\Vulnerability |
|
App\Entity\DarkOwl | No errors. |
App\Entity\DomainScore | No errors. |
App\Entity\Recommendation |
|
App\Entity\Score | No errors. |
App\Entity\GenericRecommendation |
|
App\Entity\Notification |
|
App\Entity\Ransomware | No errors. |
App\Entity\LeakInfo | No errors. |
App\Entity\LeakEmail | No errors. |
App\Entity\LeakActor | No errors. |
App\Entity\LeakAssociation | No errors. |
App\Entity\LeakDownload | No errors. |