Symfony Profiler

SELECT
  t0.created_at AS created_at_1,
  t0.phone AS phone_2,
  t0.first_name AS first_name_3,
  t0.sure_name AS sure_name_4,
  t0.father_name AS father_name_5,
  t0.farpost_login AS farpost_login_6,
  t0.email AS email_7,
  t0.mango_contact_id AS mango_contact_id_8,
  t0.id AS id_9,
  t0.user_id AS user_id_10
FROM
  customers__customers t0
WHERE
  t0.phone = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.first_name AS first_name_3, t0.sure_name AS sure_name_4, t0.father_name AS father_name_5, t0.farpost_login AS farpost_login_6, t0.email AS email_7, t0.mango_contact_id AS mango_contact_id_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM customers__customers t0 WHERE t0.phone = '9997419252' LIMIT 1;

SELECT
  t0.created_at AS created_at_1,
  t0.phone AS phone_2,
  t0.sip_id AS sip_id_3,
  t0.recording_id AS recording_id_4,
  t0.status AS status_5,
  t0.duration AS duration_6,
  t0.direction AS direction_7,
  t0.missed_status AS missed_status_8,
  t0.id AS id_9,
  t0.updated AS updated_10,
  t0.manager_id AS manager_id_11,
  t0.customer_id AS customer_id_12,
  t13.created_at AS created_at_14,
  t13.canceled_at AS canceled_at_15,
  t13.transmission_time AS transmission_time_16,
  t13.phone AS phone_17,
  t13.car_brand AS car_brand_18,
  t13.car_model AS car_model_19,
  t13.car_vin AS car_vin_20,
  t13.town_name AS town_name_21,
  t13.comment AS comment_22,
  t13.confirmed AS confirmed_23,
  t13.deprecated_order_id AS deprecated_order_id_24,
  t13.id AS id_25,
  t13.customer_id AS customer_id_26,
  t13.user_id AS user_id_27,
  t13.mango_call_id AS mango_call_id_28,
  t13.order_id AS order_id_29
FROM
  mango__calls t0
  LEFT JOIN leads__leads t13 ON t13.mango_call_id = t0.id
WHERE
  t0.sip_id = ?
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.sip_id AS sip_id_3, t0.recording_id AS recording_id_4, t0.status AS status_5, t0.duration AS duration_6, t0.direction AS direction_7, t0.missed_status AS missed_status_8, t0.id AS id_9, t0.updated AS updated_10, t0.manager_id AS manager_id_11, t0.customer_id AS customer_id_12, t13.created_at AS created_at_14, t13.canceled_at AS canceled_at_15, t13.transmission_time AS transmission_time_16, t13.phone AS phone_17, t13.car_brand AS car_brand_18, t13.car_model AS car_model_19, t13.car_vin AS car_vin_20, t13.town_name AS town_name_21, t13.comment AS comment_22, t13.confirmed AS confirmed_23, t13.deprecated_order_id AS deprecated_order_id_24, t13.id AS id_25, t13.customer_id AS customer_id_26, t13.user_id AS user_id_27, t13.mango_call_id AS mango_call_id_28, t13.order_id AS order_id_29 FROM mango__calls t0 LEFT JOIN leads__leads t13 ON t13.mango_call_id = t0.id WHERE t0.sip_id = 'MjI2OTE4MjIyOTM=' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  mango__calls
SET
  status = ?,
  duration = ?,
  updated = ?
WHERE
  id = ?

UPDATE mango__calls SET status = 'ANSWERED', duration = 18, updated = '2025-01-23 13:19:29' WHERE id = 22897;

"COMMIT"

"COMMIT";

SELECT
  t0.created_at AS created_at_1,
  t0.phone AS phone_2,
  t0.sip_id AS sip_id_3,
  t0.recording_id AS recording_id_4,
  t0.status AS status_5,
  t0.duration AS duration_6,
  t0.direction AS direction_7,
  t0.missed_status AS missed_status_8,
  t0.id AS id_9,
  t0.updated AS updated_10,
  t0.manager_id AS manager_id_11,
  t0.customer_id AS customer_id_12,
  t13.created_at AS created_at_14,
  t13.canceled_at AS canceled_at_15,
  t13.transmission_time AS transmission_time_16,
  t13.phone AS phone_17,
  t13.car_brand AS car_brand_18,
  t13.car_model AS car_model_19,
  t13.car_vin AS car_vin_20,
  t13.town_name AS town_name_21,
  t13.comment AS comment_22,
  t13.confirmed AS confirmed_23,
  t13.deprecated_order_id AS deprecated_order_id_24,
  t13.id AS id_25,
  t13.customer_id AS customer_id_26,
  t13.user_id AS user_id_27,
  t13.mango_call_id AS mango_call_id_28,
  t13.order_id AS order_id_29
FROM
  mango__calls t0
  LEFT JOIN leads__leads t13 ON t13.mango_call_id = t0.id
WHERE
  t0.phone = ?
  AND t0.missed_status = ?

SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.sip_id AS sip_id_3, t0.recording_id AS recording_id_4, t0.status AS status_5, t0.duration AS duration_6, t0.direction AS direction_7, t0.missed_status AS missed_status_8, t0.id AS id_9, t0.updated AS updated_10, t0.manager_id AS manager_id_11, t0.customer_id AS customer_id_12, t13.created_at AS created_at_14, t13.canceled_at AS canceled_at_15, t13.transmission_time AS transmission_time_16, t13.phone AS phone_17, t13.car_brand AS car_brand_18, t13.car_model AS car_model_19, t13.car_vin AS car_vin_20, t13.town_name AS town_name_21, t13.comment AS comment_22, t13.confirmed AS confirmed_23, t13.deprecated_order_id AS deprecated_order_id_24, t13.id AS id_25, t13.customer_id AS customer_id_26, t13.user_id AS user_id_27, t13.mango_call_id AS mango_call_id_28, t13.order_id AS order_id_29 FROM mango__calls t0 LEFT JOIN leads__leads t13 ON t13.mango_call_id = t0.id WHERE t0.phone = '9997419252' AND t0.missed_status = 'missed';