Symfony Profiler

SELECT
  COUNT(*)
FROM
  permission t0

SELECT COUNT(*) FROM permission t0;

SELECT
  COUNT(*)
FROM
  osint_report t0

SELECT COUNT(*) FROM osint_report t0;

SELECT
  t0.id AS id_1,
  t0.search_type AS search_type_2,
  t0.search_query AS search_query_3,
  t0.search_parameters AS search_parameters_4,
  t0.results AS results_5,
  t0.status AS status_6,
  t0.credits_used AS credits_used_7,
  t0.created_at AS created_at_8,
  t0.completed_at AS completed_at_9,
  t0.execution_time AS execution_time_10,
  t0.error_message AS error_message_11,
  t0.ip_address AS ip_address_12,
  t0.user_agent AS user_agent_13,
  t0.user_id AS user_id_14
FROM
  osint_search t0
ORDER BY
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.search_type AS search_type_2, t0.search_query AS search_query_3, t0.search_parameters AS search_parameters_4, t0.results AS results_5, t0.status AS status_6, t0.credits_used AS credits_used_7, t0.created_at AS created_at_8, t0.completed_at AS completed_at_9, t0.execution_time AS execution_time_10, t0.error_message AS error_message_11, t0.ip_address AS ip_address_12, t0.user_agent AS user_agent_13, t0.user_id AS user_id_14 FROM osint_search t0 ORDER BY t0.created_at DESC LIMIT 5;

SELECT
  t0_.id AS id_0,
  t0_.translation_key AS translation_key_1,
  t0_.value AS value_2,
  t0_.language AS language_3,
  t0_.domain AS domain_4,
  t0_.is_active AS is_active_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7
FROM
  translation t0_
WHERE
  t0_.language = ?
  AND t0_.domain = ?
  AND t0_.is_active = ?
ORDER BY
  t0_.translation_key ASC

SELECT t0_.id AS id_0, t0_.translation_key AS translation_key_1, t0_.value AS value_2, t0_.language AS language_3, t0_.domain AS domain_4, t0_.is_active AS is_active_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM translation t0_ WHERE t0_.language = 'fr' AND t0_.domain = 'messages' AND t0_.is_active = 1 ORDER BY t0_.translation_key ASC;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.username AS username_4,
  u0_.first_name AS first_name_5,
  u0_.last_name AS last_name_6,
  u0_.birth_date AS birth_date_7,
  u0_.street AS street_8,
  u0_.house_number AS house_number_9,
  u0_.box AS box_10,
  u0_.postal_code AS postal_code_11,
  u0_.city AS city_12,
  u0_.created_at AS created_at_13,
  u0_.updated_at AS updated_at_14,
  u0_.last_login_at AS last_login_at_15,
  u0_.is_active AS is_active_16,
  u0_.is_verified AS is_verified_17,
  u0_.is_approved AS is_approved_18,
  u0_.verification_token AS verification_token_19,
  u0_.deleted_at AS deleted_at_20
FROM
  `user` u0_
WHERE
  u0_.roles LIKE ?
ORDER BY
  u0_.created_at DESC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.username AS username_4, u0_.first_name AS first_name_5, u0_.last_name AS last_name_6, u0_.birth_date AS birth_date_7, u0_.street AS street_8, u0_.house_number AS house_number_9, u0_.box AS box_10, u0_.postal_code AS postal_code_11, u0_.city AS city_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u0_.last_login_at AS last_login_at_15, u0_.is_active AS is_active_16, u0_.is_verified AS is_verified_17, u0_.is_approved AS is_approved_18, u0_.verification_token AS verification_token_19, u0_.deleted_at AS deleted_at_20 FROM `user` u0_ WHERE u0_.roles LIKE '%\"ROLE_ADMIN\"%' ORDER BY u0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.birth_date AS birth_date_8,
  t0.street AS street_9,
  t0.house_number AS house_number_10,
  t0.box AS box_11,
  t0.postal_code AS postal_code_12,
  t0.city AS city_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.last_login_at AS last_login_at_16,
  t0.is_active AS is_active_17,
  t0.is_verified AS is_verified_18,
  t0.is_approved AS is_approved_19,
  t0.verification_token AS verification_token_20,
  t0.deleted_at AS deleted_at_21
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.street AS street_9, t0.house_number AS house_number_10, t0.box AS box_11, t0.postal_code AS postal_code_12, t0.city AS city_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.last_login_at AS last_login_at_16, t0.is_active AS is_active_17, t0.is_verified AS is_verified_18, t0.is_approved AS is_approved_19, t0.verification_token AS verification_token_20, t0.deleted_at AS deleted_at_21 FROM `user` t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.birth_date AS birth_date_8,
  t0.street AS street_9,
  t0.house_number AS house_number_10,
  t0.box AS box_11,
  t0.postal_code AS postal_code_12,
  t0.city AS city_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.last_login_at AS last_login_at_16,
  t0.is_active AS is_active_17,
  t0.is_verified AS is_verified_18,
  t0.is_approved AS is_approved_19,
  t0.verification_token AS verification_token_20,
  t0.deleted_at AS deleted_at_21
FROM
  `user` t0
ORDER BY
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.street AS street_9, t0.house_number AS house_number_10, t0.box AS box_11, t0.postal_code AS postal_code_12, t0.city AS city_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.last_login_at AS last_login_at_16, t0.is_active AS is_active_17, t0.is_verified AS is_verified_18, t0.is_approved AS is_approved_19, t0.verification_token AS verification_token_20, t0.deleted_at AS deleted_at_21 FROM `user` t0 ORDER BY t0.created_at DESC LIMIT 5;

SELECT
  COUNT(*)
FROM
  osint_search t0

SELECT COUNT(*) FROM osint_search t0;

SELECT
  COUNT(*)
FROM
  `user` t0

SELECT COUNT(*) FROM `user` t0;

SELECT
  COUNT(*)
FROM
  `user` t0
WHERE
  t0.is_active = ?

SELECT COUNT(*) FROM `user` t0 WHERE t0.is_active = 1;

SELECT
  COUNT(*)
FROM
  `user` t0
WHERE
  t0.is_verified = ?

SELECT COUNT(*) FROM `user` t0 WHERE t0.is_verified = 1;