Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.enabled AS enabled_1,
  s0_.remote_id AS remote_id_2,
  s0_.identifier AS identifier_3,
  s0_.serial_number AS serial_number_4,
  s0_.ip AS ip_5,
  s0_.ip_public AS ip_public_6,
  s0_.mac_address AS mac_address_7,
  s0_.port AS port_8,
  s0_.enable_notification AS enable_notification_9,
  s0_.is_remove_processing AS is_remove_processing_10,
  s0_.created_at AS created_at_11,
  s0_.updated_at AS updated_at_12,
  s1_.id AS id_13,
  s1_.title AS title_14,
  s1_.description AS description_15,
  s1_.created_at AS created_at_16,
  s1_.updated_at AS updated_at_17,
  s0_.site_id AS site_id_18,
  s0_.info_id AS info_id_19,
  s0_.status_id AS status_id_20,
  s0_.action_id AS action_id_21,
  s0_.enabled_diffusion_id AS enabled_diffusion_id_22,
  s0_.message_defilant_id AS message_defilant_id_23,
  s0_.stats_id AS stats_id_24,
  s1_.screen_id AS screen_id_25
FROM
  screen s0_
  LEFT JOIN screen_log s1_ ON s0_.id = s1_.screen_id
WHERE
  s0_.mac_address = ?
ORDER BY
  s1_.created_at DESC,
  s1_.id DESC

SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.remote_id AS remote_id_2, s0_.identifier AS identifier_3, s0_.serial_number AS serial_number_4, s0_.ip AS ip_5, s0_.ip_public AS ip_public_6, s0_.mac_address AS mac_address_7, s0_.port AS port_8, s0_.enable_notification AS enable_notification_9, s0_.is_remove_processing AS is_remove_processing_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s1_.id AS id_13, s1_.title AS title_14, s1_.description AS description_15, s1_.created_at AS created_at_16, s1_.updated_at AS updated_at_17, s0_.site_id AS site_id_18, s0_.info_id AS info_id_19, s0_.status_id AS status_id_20, s0_.action_id AS action_id_21, s0_.enabled_diffusion_id AS enabled_diffusion_id_22, s0_.message_defilant_id AS message_defilant_id_23, s0_.stats_id AS stats_id_24, s1_.screen_id AS screen_id_25 FROM screen s0_ LEFT JOIN screen_log s1_ ON s0_.id = s1_.screen_id WHERE s0_.mac_address = 'E8-80-88-B8-A2-B0' ORDER BY s1_.created_at DESC, s1_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.is_tactile AS is_tactile_4,
  t0.width AS width_5,
  t0.height AS height_6,
  t0.size AS size_7,
  t0.brand AS brand_8,
  t0.description AS description_9,
  t0.diffused_media AS diffused_media_10,
  t0.interval_dialog AS interval_dialog_11,
  t0.last_dialog AS last_dialog_12,
  t0.version AS version_13,
  t0.lat AS lat_14,
  t0.lng AS lng_15,
  t0.is_auto_update AS is_auto_update_16,
  t0.asked_version AS asked_version_17,
  t0.enable_stats_law AS enable_stats_law_18,
  t0.os AS os_19,
  t0.version_branch_id AS version_branch_id_20
FROM
  screen_info t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.is_tactile AS is_tactile_4, t0.width AS width_5, t0.height AS height_6, t0.size AS size_7, t0.brand AS brand_8, t0.description AS description_9, t0.diffused_media AS diffused_media_10, t0.interval_dialog AS interval_dialog_11, t0.last_dialog AS last_dialog_12, t0.version AS version_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.is_auto_update AS is_auto_update_16, t0.asked_version AS asked_version_17, t0.enable_stats_law AS enable_stats_law_18, t0.os AS os_19, t0.version_branch_id AS version_branch_id_20 FROM screen_info t0 WHERE t0.id = 2209;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  screen_info
SET
  last_dialog = ?
WHERE
  id = ?

UPDATE screen_info SET last_dialog = '2025-10-13 01:42:28' WHERE id = 2209;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.name AS name_3,
  t0.public AS public_4,
  t0.api_ttl AS api_ttl_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.company_id AS company_id_8,
  t0.info_id AS info_id_9
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.public AS public_4, t0.api_ttl AS api_ttl_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.company_id AS company_id_8, t0.info_id AS info_id_9 FROM site t0 WHERE t0.id = 952;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_law AS is_law_3,
  t0.is_law_statistique AS is_law_statistique_4,
  t0.is_model AS is_model_5,
  t0.is_notification AS is_notification_6,
  t0.code AS code_7,
  t0.api_url AS api_url_8,
  t0.quota AS quota_9,
  t0.isialis_code AS isialis_code_10,
  t0.is_enabled AS is_enabled_11,
  t0.max_enabled_screen AS max_enabled_screen_12,
  t0.api_ttl AS api_ttl_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.info_id AS info_id_16
FROM
  user_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_law AS is_law_3, t0.is_law_statistique AS is_law_statistique_4, t0.is_model AS is_model_5, t0.is_notification AS is_notification_6, t0.code AS code_7, t0.api_url AS api_url_8, t0.quota AS quota_9, t0.isialis_code AS isialis_code_10, t0.is_enabled AS is_enabled_11, t0.max_enabled_screen AS max_enabled_screen_12, t0.api_ttl AS api_ttl_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.info_id AS info_id_16 FROM user_company t0 WHERE t0.id = 211;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.date AS date_3,
  t0.due_date AS due_date_4,
  t0.data AS data_5,
  t6.id AS id_7,
  t6.enabled AS enabled_8,
  t6.remote_id AS remote_id_9,
  t6.identifier AS identifier_10,
  t6.serial_number AS serial_number_11,
  t6.ip AS ip_12,
  t6.ip_public AS ip_public_13,
  t6.mac_address AS mac_address_14,
  t6.port AS port_15,
  t6.enable_notification AS enable_notification_16,
  t6.is_remove_processing AS is_remove_processing_17,
  t6.created_at AS created_at_18,
  t6.updated_at AS updated_at_19,
  t6.site_id AS site_id_20,
  t6.info_id AS info_id_21,
  t6.status_id AS status_id_22,
  t6.action_id AS action_id_23,
  t6.enabled_diffusion_id AS enabled_diffusion_id_24,
  t6.message_defilant_id AS message_defilant_id_25,
  t6.stats_id AS stats_id_26,
  t0.screen_actions_id AS screen_actions_id_27
FROM
  screen_action t0
  LEFT JOIN screen t6 ON t6.action_id = t0.id
WHERE
  t0.screen_actions_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.type AS type_2, t0.date AS date_3, t0.due_date AS due_date_4, t0.data AS data_5, t6.id AS id_7, t6.enabled AS enabled_8, t6.remote_id AS remote_id_9, t6.identifier AS identifier_10, t6.serial_number AS serial_number_11, t6.ip AS ip_12, t6.ip_public AS ip_public_13, t6.mac_address AS mac_address_14, t6.port AS port_15, t6.enable_notification AS enable_notification_16, t6.is_remove_processing AS is_remove_processing_17, t6.created_at AS created_at_18, t6.updated_at AS updated_at_19, t6.site_id AS site_id_20, t6.info_id AS info_id_21, t6.status_id AS status_id_22, t6.action_id AS action_id_23, t6.enabled_diffusion_id AS enabled_diffusion_id_24, t6.message_defilant_id AS message_defilant_id_25, t6.stats_id AS stats_id_26, t0.screen_actions_id AS screen_actions_id_27 FROM screen_action t0 LEFT JOIN screen t6 ON t6.action_id = t0.id WHERE t0.screen_actions_id = 2197 ORDER BY t0.date DESC;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.is_on AS is_on_3,
  t0.status AS status_4
FROM
  screen_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.is_on AS is_on_3, t0.status AS status_4 FROM screen_status t0 WHERE t0.id = 2249;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.date AS date_3,
  t0.due_date AS due_date_4,
  t0.data AS data_5,
  t6.id AS id_7,
  t6.enabled AS enabled_8,
  t6.remote_id AS remote_id_9,
  t6.identifier AS identifier_10,
  t6.serial_number AS serial_number_11,
  t6.ip AS ip_12,
  t6.ip_public AS ip_public_13,
  t6.mac_address AS mac_address_14,
  t6.port AS port_15,
  t6.enable_notification AS enable_notification_16,
  t6.is_remove_processing AS is_remove_processing_17,
  t6.created_at AS created_at_18,
  t6.updated_at AS updated_at_19,
  t6.site_id AS site_id_20,
  t6.info_id AS info_id_21,
  t6.status_id AS status_id_22,
  t6.action_id AS action_id_23,
  t6.enabled_diffusion_id AS enabled_diffusion_id_24,
  t6.message_defilant_id AS message_defilant_id_25,
  t6.stats_id AS stats_id_26,
  t0.screen_actions_id AS screen_actions_id_27
FROM
  screen_action t0
  LEFT JOIN screen t6 ON t6.action_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.date AS date_3, t0.due_date AS due_date_4, t0.data AS data_5, t6.id AS id_7, t6.enabled AS enabled_8, t6.remote_id AS remote_id_9, t6.identifier AS identifier_10, t6.serial_number AS serial_number_11, t6.ip AS ip_12, t6.ip_public AS ip_public_13, t6.mac_address AS mac_address_14, t6.port AS port_15, t6.enable_notification AS enable_notification_16, t6.is_remove_processing AS is_remove_processing_17, t6.created_at AS created_at_18, t6.updated_at AS updated_at_19, t6.site_id AS site_id_20, t6.info_id AS info_id_21, t6.status_id AS status_id_22, t6.action_id AS action_id_23, t6.enabled_diffusion_id AS enabled_diffusion_id_24, t6.message_defilant_id AS message_defilant_id_25, t6.stats_id AS stats_id_26, t0.screen_actions_id AS screen_actions_id_27 FROM screen_action t0 LEFT JOIN screen t6 ON t6.action_id = t0.id WHERE t0.id = 2341;