GET https://outdoor.twentepc.nl/saleslead/countOpenLeads

Query Metrics

12 Database Queries
4 Different statements
7.79 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.96 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[]
3 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0
Parameters:
[]
4 0.88 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_order_delivery_info"
]
5 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_sales_lead"
]
6 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_ticket"
]
7 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_chatbot"
]
8 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_shopify"
]
9 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_delivery_capacity"
]
10 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_addresscheck"
]
11 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "module_transport_calculation"
]
12 1.22 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM sales_lead s0_ LEFT JOIN sales_lead_log s1_ ON s0_.id = s1_.sales_lead_id LEFT JOIN sales_lead_log s2_ ON s0_.id = s2_.sales_lead_id AND (s0_.id = s2_.sales_lead_id AND s1_.id < s2_.id AND s2_.is_deleted = 0) WHERE s2_.id IS NULL AND s0_.is_deleted = 0 AND s0_.lead_responsible_id = ? AND ((s1_.is_deleted = 0 AND s1_.is_finished = 0) OR s1_.id IS NULL)
Parameters:
[
  1
]

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.