Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 89
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.telephone_number AS telephone_number_4, t0.date_add AS date_add_5, t0.date_modify AS date_modify_6 FROM telephone_connections_available t0 WHERE t0.telephone_number = ? LIMIT 1

[
  "500509302"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.telephone_number AS telephone_number_4,
  t0.date_add AS date_add_5,
  t0.date_modify AS date_modify_6
FROM
  telephone_connections_available t0
WHERE
  t0.telephone_number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.telephone_number AS telephone_number_4, t0.date_add AS date_add_5, t0.date_modify AS date_modify_6 FROM telephone_connections_available t0 WHERE t0.telephone_number = '500509302' LIMIT 1;

SELECT l0_.id AS id_0, l0_.first_name AS first_name_1, l0_.last_name AS last_name_2, l0_.phone AS phone_3, l0_.email AS email_4, l0_.rate AS rate_5, l0_.provision AS provision_6, l0_.sms AS sms_7, l0_.offer AS offer_8, l0_.date_reservation AS date_reservation_9, l0_.date_add AS date_add_10, l0_.date_modify AS date_modify_11, l0_.next_contact_date AS next_contact_date_12, l0_.next_contact_time AS next_contact_time_13, l0_.status_id AS status_id_14, l0_.institutions_id AS institutions_id_15, l0_.owner_id AS owner_id_16, l0_.ticket_id AS ticket_id_17 FROM leads l0_ INNER JOIN leads_status l1_ ON l0_.status_id = l1_.id WHERE l0_.phone LIKE ? AND l1_.value <> ? ORDER BY l0_.id DESC

[
  "%535800166%"
  "ended"
]

SELECT
  l0_.id AS id_0,
  l0_.first_name AS first_name_1,
  l0_.last_name AS last_name_2,
  l0_.phone AS phone_3,
  l0_.email AS email_4,
  l0_.rate AS rate_5,
  l0_.provision AS provision_6,
  l0_.sms AS sms_7,
  l0_.offer AS offer_8,
  l0_.date_reservation AS date_reservation_9,
  l0_.date_add AS date_add_10,
  l0_.date_modify AS date_modify_11,
  l0_.next_contact_date AS next_contact_date_12,
  l0_.next_contact_time AS next_contact_time_13,
  l0_.status_id AS status_id_14,
  l0_.institutions_id AS institutions_id_15,
  l0_.owner_id AS owner_id_16,
  l0_.ticket_id AS ticket_id_17
FROM
  leads l0_
  INNER JOIN leads_status l1_ ON l0_.status_id = l1_.id
WHERE
  l0_.phone LIKE ?
  AND l1_.value <> ?
ORDER BY
  l0_.id DESC

SELECT l0_.id AS id_0, l0_.first_name AS first_name_1, l0_.last_name AS last_name_2, l0_.phone AS phone_3, l0_.email AS email_4, l0_.rate AS rate_5, l0_.provision AS provision_6, l0_.sms AS sms_7, l0_.offer AS offer_8, l0_.date_reservation AS date_reservation_9, l0_.date_add AS date_add_10, l0_.date_modify AS date_modify_11, l0_.next_contact_date AS next_contact_date_12, l0_.next_contact_time AS next_contact_time_13, l0_.status_id AS status_id_14, l0_.institutions_id AS institutions_id_15, l0_.owner_id AS owner_id_16, l0_.ticket_id AS ticket_id_17 FROM leads l0_ INNER JOIN leads_status l1_ ON l0_.status_id = l1_.id WHERE l0_.phone LIKE '%535800166%' AND l1_.value <> 'ended' ORDER BY l0_.id DESC;

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.date_add AS date_add_2, t0_.date_modify AS date_modify_3, t0_.content AS content_4, t0_.coordinator AS coordinator_5, t0_.coordinator_phone AS coordinator_phone_6, t0_.coordinator2 AS coordinator2_7, t0_.coordinator_phone2 AS coordinator_phone2_8, t0_.email_poster AS email_poster_9, t0_.date_of_visit AS date_of_visit_10, t0_.date_of_contact AS date_of_contact_11, t0_.kond_of_dome AS kond_of_dome_12, t0_.number_of_children AS number_of_children_13, t0_.rate AS rate_14, t0_.provision AS provision_15, t0_.payment_method AS payment_method_16, t0_.billing_type AS billing_type_17, t0_.number_of_kilometers AS number_of_kilometers_18, t0_.fuel_price AS fuel_price_19, t0_.event_id AS event_id_20, t0_.user_event_id AS user_event_id_21, t0_.number_of_group AS number_of_group_22, t0_.time_of_visit AS time_of_visit_23, t0_.description AS description_24, t0_.other_costs AS other_costs_25, t0_.costs_accommodation AS costs_accommodation_26, t0_.invoices_fuel AS invoices_fuel_27, t0_.downloaded_in_cash AS downloaded_in_cash_28, t0_.add_other_ticket AS add_other_ticket_29, t0_.flexibility AS flexibility_30, t0_.first_contact AS first_contact_31, t0_.status_id AS status_id_32, t0_.institutions_id AS institutions_id_33, t0_.user_id AS user_id_34, t0_.advertisement_poster_id AS advertisement_poster_id_35 FROM tickets t0_ INNER JOIN tickets_status t1_ ON t0_.status_id = t1_.id WHERE (t0_.coordinator_phone LIKE ? OR t0_.coordinator_phone2 LIKE ?) AND t1_.value <> ? ORDER BY t0_.id DESC LIMIT 1

[
  "%535800166%"
  "%535800166%"
  "end"
]

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.date_add AS date_add_2,
  t0_.date_modify AS date_modify_3,
  t0_.content AS content_4,
  t0_.coordinator AS coordinator_5,
  t0_.coordinator_phone AS coordinator_phone_6,
  t0_.coordinator2 AS coordinator2_7,
  t0_.coordinator_phone2 AS coordinator_phone2_8,
  t0_.email_poster AS email_poster_9,
  t0_.date_of_visit AS date_of_visit_10,
  t0_.date_of_contact AS date_of_contact_11,
  t0_.kond_of_dome AS kond_of_dome_12,
  t0_.number_of_children AS number_of_children_13,
  t0_.rate AS rate_14,
  t0_.provision AS provision_15,
  t0_.payment_method AS payment_method_16,
  t0_.billing_type AS billing_type_17,
  t0_.number_of_kilometers AS number_of_kilometers_18,
  t0_.fuel_price AS fuel_price_19,
  t0_.event_id AS event_id_20,
  t0_.user_event_id AS user_event_id_21,
  t0_.number_of_group AS number_of_group_22,
  t0_.time_of_visit AS time_of_visit_23,
  t0_.description AS description_24,
  t0_.other_costs AS other_costs_25,
  t0_.costs_accommodation AS costs_accommodation_26,
  t0_.invoices_fuel AS invoices_fuel_27,
  t0_.downloaded_in_cash AS downloaded_in_cash_28,
  t0_.add_other_ticket AS add_other_ticket_29,
  t0_.flexibility AS flexibility_30,
  t0_.first_contact AS first_contact_31,
  t0_.status_id AS status_id_32,
  t0_.institutions_id AS institutions_id_33,
  t0_.user_id AS user_id_34,
  t0_.advertisement_poster_id AS advertisement_poster_id_35
FROM
  tickets t0_
  INNER JOIN tickets_status t1_ ON t0_.status_id = t1_.id
WHERE
  (
    t0_.coordinator_phone LIKE ?
    OR t0_.coordinator_phone2 LIKE ?
  )
  AND t1_.value <> ?
ORDER BY
  t0_.id DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.date_add AS date_add_2, t0_.date_modify AS date_modify_3, t0_.content AS content_4, t0_.coordinator AS coordinator_5, t0_.coordinator_phone AS coordinator_phone_6, t0_.coordinator2 AS coordinator2_7, t0_.coordinator_phone2 AS coordinator_phone2_8, t0_.email_poster AS email_poster_9, t0_.date_of_visit AS date_of_visit_10, t0_.date_of_contact AS date_of_contact_11, t0_.kond_of_dome AS kond_of_dome_12, t0_.number_of_children AS number_of_children_13, t0_.rate AS rate_14, t0_.provision AS provision_15, t0_.payment_method AS payment_method_16, t0_.billing_type AS billing_type_17, t0_.number_of_kilometers AS number_of_kilometers_18, t0_.fuel_price AS fuel_price_19, t0_.event_id AS event_id_20, t0_.user_event_id AS user_event_id_21, t0_.number_of_group AS number_of_group_22, t0_.time_of_visit AS time_of_visit_23, t0_.description AS description_24, t0_.other_costs AS other_costs_25, t0_.costs_accommodation AS costs_accommodation_26, t0_.invoices_fuel AS invoices_fuel_27, t0_.downloaded_in_cash AS downloaded_in_cash_28, t0_.add_other_ticket AS add_other_ticket_29, t0_.flexibility AS flexibility_30, t0_.first_contact AS first_contact_31, t0_.status_id AS status_id_32, t0_.institutions_id AS institutions_id_33, t0_.user_id AS user_id_34, t0_.advertisement_poster_id AS advertisement_poster_id_35 FROM tickets t0_ INNER JOIN tickets_status t1_ ON t0_.status_id = t1_.id WHERE (t0_.coordinator_phone LIKE '%535800166%' OR t0_.coordinator_phone2 LIKE '%535800166%') AND t1_.value <> 'end' ORDER BY t0_.id DESC LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO telephone_connection (telephone_number, duration, status, device_info, creation_date, is_sms_read, telephone_connections_available_id, lead_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

[
  "535800166"
  0
  "Nieodebrane"
  "{"app_info":{"app_name":"Orbitek Call","version":"4.0","build_number":"4"},"device_info":{"device":"Android","manufacturer":"samsung","model":"SM-A125F","android_version":"12","sdk_version":31}}"
  "2026-07-09 07:27:14"
  null
  1
  null
]

INSERT INTO telephone_connection (
  telephone_number, duration, status,
  device_info, creation_date, is_sms_read,
  telephone_connections_available_id,
  lead_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO telephone_connection (telephone_number, duration, status, device_info, creation_date, is_sms_read, telephone_connections_available_id, lead_id) VALUES ('535800166', 0, 'Nieodebrane', '{\"app_info\":{\"app_name\":\"Orbitek Call\",\"version\":\"4.0\",\"build_number\":\"4\"},\"device_info\":{\"device\":\"Android\",\"manufacturer\":\"samsung\",\"model\":\"SM-A125F\",\"android_version\":\"12\",\"sdk_version\":31}}', '2026-07-09 07:27:14', NULL, 1, NULL);

"COMMIT"

[]

"COMMIT"

"COMMIT";