Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.active AS active_8,
  t0.created_at AS created_at_9,
  t0.last_login_at AS last_login_at_10,
  t0.customer_id AS customer_id_11
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.last_login_at AS last_login_at_10, t0.customer_id AS customer_id_11 FROM user t0 WHERE t0.id = 6;

SELECT
  DISTINCT s0_.ip AS ip_0
FROM
  shield_attack s0_
WHERE
  s0_.status = ?
  AND s0_.ip IS NOT NULL

SELECT DISTINCT s0_.ip AS ip_0 FROM shield_attack s0_ WHERE s0_.status = 'active' AND s0_.ip IS NOT NULL;

SELECT
  s0_.id AS id_0,
  s0_.cidr AS cidr_1,
  s0_.label AS label_2,
  s0_.created_at AS created_at_3,
  s1_.id AS id_4,
  s1_.name AS name_5,
  s1_.number AS number_6,
  s1_.email AS email_7,
  s1_.notes AS notes_8,
  s1_.active AS active_9,
  s1_.self_blackhole AS self_blackhole_10,
  s1_.created_at AS created_at_11,
  s0_.customer_id AS customer_id_12
FROM
  shield_customer_network s0_
  INNER JOIN shield_customer s1_ ON s0_.customer_id = s1_.id

SELECT s0_.id AS id_0, s0_.cidr AS cidr_1, s0_.label AS label_2, s0_.created_at AS created_at_3, s1_.id AS id_4, s1_.name AS name_5, s1_.number AS number_6, s1_.email AS email_7, s1_.notes AS notes_8, s1_.active AS active_9, s1_.self_blackhole AS self_blackhole_10, s1_.created_at AS created_at_11, s0_.customer_id AS customer_id_12 FROM shield_customer_network s0_ INNER JOIN shield_customer s1_ ON s0_.customer_id = s1_.id;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.scope AS scope_2,
  s0_.ip AS ip_3,
  s0_.hostgroup AS hostgroup_4,
  s0_.network AS network_5,
  s0_.action AS action_6,
  s0_.status AS status_7,
  s0_.direction AS direction_8,
  s0_.threshold_type AS threshold_type_9,
  s0_.severity AS severity_10,
  s0_.detection_source AS detection_source_11,
  s0_.protocol_version AS protocol_version_12,
  s0_.started_at AS started_at_13,
  s0_.ended_at AS ended_at_14,
  s0_.updated_at AS updated_at_15,
  s0_.in_pps AS in_pps_16,
  s0_.in_bps AS in_bps_17,
  s0_.in_flows AS in_flows_18,
  s0_.out_pps AS out_pps_19,
  s0_.out_bps AS out_bps_20,
  s0_.peak_pps AS peak_pps_21,
  s0_.peak_bps AS peak_bps_22,
  s0_.protocols AS protocols_23,
  s0_.flowspec_rules AS flowspec_rules_24,
  s0_.analysis AS analysis_25,
  s0_.packets AS packets_26,
  s0_.hostgroup_networks AS hostgroup_networks_27,
  s0_.test AS test_28,
  s1_.id AS id_29,
  s1_.name AS name_30,
  s1_.number AS number_31,
  s1_.email AS email_32,
  s1_.notes AS notes_33,
  s1_.active AS active_34,
  s1_.self_blackhole AS self_blackhole_35,
  s1_.created_at AS created_at_36,
  s0_.customer_id AS customer_id_37
FROM
  shield_attack s0_
  LEFT JOIN shield_customer s1_ ON s0_.customer_id = s1_.id
WHERE
  s0_.status = ?
  AND s0_.test = 0
ORDER BY
  s0_.started_at DESC
LIMIT
  50

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.scope AS scope_2, s0_.ip AS ip_3, s0_.hostgroup AS hostgroup_4, s0_.network AS network_5, s0_.action AS action_6, s0_.status AS status_7, s0_.direction AS direction_8, s0_.threshold_type AS threshold_type_9, s0_.severity AS severity_10, s0_.detection_source AS detection_source_11, s0_.protocol_version AS protocol_version_12, s0_.started_at AS started_at_13, s0_.ended_at AS ended_at_14, s0_.updated_at AS updated_at_15, s0_.in_pps AS in_pps_16, s0_.in_bps AS in_bps_17, s0_.in_flows AS in_flows_18, s0_.out_pps AS out_pps_19, s0_.out_bps AS out_bps_20, s0_.peak_pps AS peak_pps_21, s0_.peak_bps AS peak_bps_22, s0_.protocols AS protocols_23, s0_.flowspec_rules AS flowspec_rules_24, s0_.analysis AS analysis_25, s0_.packets AS packets_26, s0_.hostgroup_networks AS hostgroup_networks_27, s0_.test AS test_28, s1_.id AS id_29, s1_.name AS name_30, s1_.number AS number_31, s1_.email AS email_32, s1_.notes AS notes_33, s1_.active AS active_34, s1_.self_blackhole AS self_blackhole_35, s1_.created_at AS created_at_36, s0_.customer_id AS customer_id_37 FROM shield_attack s0_ LEFT JOIN shield_customer s1_ ON s0_.customer_id = s1_.id WHERE s0_.status = 'active' AND s0_.test = 0 ORDER BY s0_.started_at DESC LIMIT 50;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.scope AS scope_2,
  s0_.ip AS ip_3,
  s0_.hostgroup AS hostgroup_4,
  s0_.network AS network_5,
  s0_.action AS action_6,
  s0_.status AS status_7,
  s0_.direction AS direction_8,
  s0_.threshold_type AS threshold_type_9,
  s0_.severity AS severity_10,
  s0_.detection_source AS detection_source_11,
  s0_.protocol_version AS protocol_version_12,
  s0_.started_at AS started_at_13,
  s0_.ended_at AS ended_at_14,
  s0_.updated_at AS updated_at_15,
  s0_.in_pps AS in_pps_16,
  s0_.in_bps AS in_bps_17,
  s0_.in_flows AS in_flows_18,
  s0_.out_pps AS out_pps_19,
  s0_.out_bps AS out_bps_20,
  s0_.peak_pps AS peak_pps_21,
  s0_.peak_bps AS peak_bps_22,
  s0_.protocols AS protocols_23,
  s0_.flowspec_rules AS flowspec_rules_24,
  s0_.analysis AS analysis_25,
  s0_.packets AS packets_26,
  s0_.hostgroup_networks AS hostgroup_networks_27,
  s0_.test AS test_28,
  s1_.id AS id_29,
  s1_.name AS name_30,
  s1_.number AS number_31,
  s1_.email AS email_32,
  s1_.notes AS notes_33,
  s1_.active AS active_34,
  s1_.self_blackhole AS self_blackhole_35,
  s1_.created_at AS created_at_36,
  s0_.customer_id AS customer_id_37
FROM
  shield_attack s0_
  LEFT JOIN shield_customer s1_ ON s0_.customer_id = s1_.id
WHERE
  s0_.test = 0
ORDER BY
  s0_.started_at DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.scope AS scope_2, s0_.ip AS ip_3, s0_.hostgroup AS hostgroup_4, s0_.network AS network_5, s0_.action AS action_6, s0_.status AS status_7, s0_.direction AS direction_8, s0_.threshold_type AS threshold_type_9, s0_.severity AS severity_10, s0_.detection_source AS detection_source_11, s0_.protocol_version AS protocol_version_12, s0_.started_at AS started_at_13, s0_.ended_at AS ended_at_14, s0_.updated_at AS updated_at_15, s0_.in_pps AS in_pps_16, s0_.in_bps AS in_bps_17, s0_.in_flows AS in_flows_18, s0_.out_pps AS out_pps_19, s0_.out_bps AS out_bps_20, s0_.peak_pps AS peak_pps_21, s0_.peak_bps AS peak_bps_22, s0_.protocols AS protocols_23, s0_.flowspec_rules AS flowspec_rules_24, s0_.analysis AS analysis_25, s0_.packets AS packets_26, s0_.hostgroup_networks AS hostgroup_networks_27, s0_.test AS test_28, s1_.id AS id_29, s1_.name AS name_30, s1_.number AS number_31, s1_.email AS email_32, s1_.notes AS notes_33, s1_.active AS active_34, s1_.self_blackhole AS self_blackhole_35, s1_.created_at AS created_at_36, s0_.customer_id AS customer_id_37 FROM shield_attack s0_ LEFT JOIN shield_customer s1_ ON s0_.customer_id = s1_.id WHERE s0_.test = 0 ORDER BY s0_.started_at DESC LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.uuid AS uuid_1,
  s0_.scope AS scope_2,
  s0_.ip AS ip_3,
  s0_.hostgroup AS hostgroup_4,
  s0_.network AS network_5,
  s0_.action AS action_6,
  s0_.status AS status_7,
  s0_.direction AS direction_8,
  s0_.threshold_type AS threshold_type_9,
  s0_.severity AS severity_10,
  s0_.detection_source AS detection_source_11,
  s0_.protocol_version AS protocol_version_12,
  s0_.started_at AS started_at_13,
  s0_.ended_at AS ended_at_14,
  s0_.updated_at AS updated_at_15,
  s0_.in_pps AS in_pps_16,
  s0_.in_bps AS in_bps_17,
  s0_.in_flows AS in_flows_18,
  s0_.out_pps AS out_pps_19,
  s0_.out_bps AS out_bps_20,
  s0_.peak_pps AS peak_pps_21,
  s0_.peak_bps AS peak_bps_22,
  s0_.protocols AS protocols_23,
  s0_.flowspec_rules AS flowspec_rules_24,
  s0_.analysis AS analysis_25,
  s0_.packets AS packets_26,
  s0_.hostgroup_networks AS hostgroup_networks_27,
  s0_.test AS test_28,
  s0_.customer_id AS customer_id_29
FROM
  shield_attack s0_
WHERE
  s0_.test = 0
  AND (
    s0_.ended_at IS NULL
    OR s0_.ended_at >= ?
  )
ORDER BY
  s0_.started_at ASC
LIMIT
  200

SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.scope AS scope_2, s0_.ip AS ip_3, s0_.hostgroup AS hostgroup_4, s0_.network AS network_5, s0_.action AS action_6, s0_.status AS status_7, s0_.direction AS direction_8, s0_.threshold_type AS threshold_type_9, s0_.severity AS severity_10, s0_.detection_source AS detection_source_11, s0_.protocol_version AS protocol_version_12, s0_.started_at AS started_at_13, s0_.ended_at AS ended_at_14, s0_.updated_at AS updated_at_15, s0_.in_pps AS in_pps_16, s0_.in_bps AS in_bps_17, s0_.in_flows AS in_flows_18, s0_.out_pps AS out_pps_19, s0_.out_bps AS out_bps_20, s0_.peak_pps AS peak_pps_21, s0_.peak_bps AS peak_bps_22, s0_.protocols AS protocols_23, s0_.flowspec_rules AS flowspec_rules_24, s0_.analysis AS analysis_25, s0_.packets AS packets_26, s0_.hostgroup_networks AS hostgroup_networks_27, s0_.test AS test_28, s0_.customer_id AS customer_id_29 FROM shield_attack s0_ WHERE s0_.test = 0 AND (s0_.ended_at IS NULL OR s0_.ended_at >= '2026-10-07 17:34:58') ORDER BY s0_.started_at ASC LIMIT 200;