Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.port AS port_2,
  t0.is_active AS is_active_3,
  t0.last_seen AS last_seen_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.exposed_ip_id AS exposed_ip_id_7,
  t0.status_id AS status_id_8
FROM
  open_port t0
WHERE
  t0.exposed_ip_id = ?

SELECT t0.id AS id_1, t0.port AS port_2, t0.is_active AS is_active_3, t0.last_seen AS last_seen_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.exposed_ip_id AS exposed_ip_id_7, t0.status_id AS status_id_8 FROM open_port t0 WHERE t0.exposed_ip_id = 3494;

SELECT
  t0.id AS id_1,
  t0.sub_domain AS sub_domain_2,
  t0.is_normal AS is_normal_3,
  t0.is_active AS is_active_4,
  t0.last_seen AS last_seen_5,
  t0.is_deleted AS is_deleted_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.domain_id AS domain_id_9,
  t0.exposed_ip_id AS exposed_ip_id_10,
  t0.status_id AS status_id_11
FROM
  exposed_sub_domain t0
WHERE
  t0.domain_id = ?

SELECT t0.id AS id_1, t0.sub_domain AS sub_domain_2, t0.is_normal AS is_normal_3, t0.is_active AS is_active_4, t0.last_seen AS last_seen_5, t0.is_deleted AS is_deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.domain_id AS domain_id_9, t0.exposed_ip_id AS exposed_ip_id_10, t0.status_id AS status_id_11 FROM exposed_sub_domain t0 WHERE t0.domain_id = 15;

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

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 = 1 AND s0_.is_actif = 1 AND o1_.id = 14 AND DATE_FORMAT(s0_.end_date, '%Y-%m-%d') >= '2025-04-26' ORDER BY s0_.id ASC;

SELECT
  *
FROM
  (
    SELECT
      id,
      domain_id,
      score,
      TYPE,
      label,
      DATE_FORMAT(created_at, '%Y-%m-%d') AS created_at,
      DENSE_RANK() OVER (
        PARTITION BY
          domain_id
        ORDER BY
          DATE_FORMAT(created_at, '%Y-%m-%d') DESC
      ) AS date_rank
    FROM
      score
    WHERE
      domain_id = :domainId
  ) AS ranked
WHERE
  date_rank = :last

SELECT *  FROM(
            SELECT 
                id,
                domain_id,
                score,
                TYPE,
                label,
                DATE_FORMAT(created_at,'%Y-%m-%d') AS created_at,
              DENSE_RANK() OVER (PARTITION BY domain_id ORDER BY DATE_FORMAT(created_at,'%Y-%m-%d') DESC) AS date_rank
            FROM score
            WHERE domain_id = 15
          ) AS ranked
          WHERE date_rank = 1
        ;

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
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 = ?

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 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 = 14 AND o1_.is_added = 1 AND d0_.id = 15;

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 (?)

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 (14);

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.is_exposed AS is_exposed_3,
  t0.is_normal AS is_normal_4,
  t0.is_cdn AS is_cdn_5,
  t0.is_active AS is_active_6,
  t0.last_seen AS last_seen_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.organisation_id AS organisation_id_10,
  t0.domain_id AS domain_id_11,
  t0.status_id AS status_id_12
FROM
  exposed_ip t0
WHERE
  t0.domain_id = ?

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.is_exposed AS is_exposed_3, t0.is_normal AS is_normal_4, t0.is_cdn AS is_cdn_5, t0.is_active AS is_active_6, t0.last_seen AS last_seen_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.organisation_id AS organisation_id_10, t0.domain_id AS domain_id_11, t0.status_id AS status_id_12 FROM exposed_ip t0 WHERE t0.domain_id = 15;

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

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 = '[email protected]' LIMIT 1;

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 = ?

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 = 14;

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 = ?
LIMIT
  101

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 = 14 AND o1_.is_added = 1 AND d0_.id = 15 LIMIT 101;

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 = ?

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 = 14;

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 = ?

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 = 14 AND o1_.is_added = 1 AND d0_.id = 15;