Symfony Profiler

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='sys_config';

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='sys_config';

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='sys_config';

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='ticket_settings';

SELECT
  sc.*
FROM
  gfc_dm_sys_catalog sc
WHERE
  sc.deleted = 0
ORDER BY
  sc.id_group,
  sc.order_key,
  sc.title

SELECT sc.*
                FROM gfc_dm_sys_catalog sc
                WHERE sc.deleted = 0 ORDER BY sc.id_group, sc.order_key, sc.title ;

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='sys_config';

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='ticket_settings';

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='app_settings';

SELECT
  *
FROM
  gfc_dm_sys_collector_themes

SELECT * FROM gfc_dm_sys_collector_themes ;

SELECT
  *
FROM
  gfc_dm_sys_collector_themes_fields
WHERE
  deleted = 0
  AND id_collector_theme = 1
ORDER BY
  order_key

SELECT * FROM gfc_dm_sys_collector_themes_fields WHERE deleted = 0 AND id_collector_theme = 1 ORDER BY order_key;

SELECT
  *
FROM
  gfc_dm_sys_collector_themes_fields
WHERE
  deleted = 0
  AND id_collector_theme = 2
ORDER BY
  order_key

SELECT * FROM gfc_dm_sys_collector_themes_fields WHERE deleted = 0 AND id_collector_theme = 2 ORDER BY order_key;

SELECT
  *
FROM
  gfc_dm_sys_collector_themes_fields
WHERE
  deleted = 0
  AND id_collector_theme = 3
ORDER BY
  order_key

SELECT * FROM gfc_dm_sys_collector_themes_fields WHERE deleted = 0 AND id_collector_theme = 3 ORDER BY order_key;

SELECT
  *
FROM
  gfc_dm_options
WHERE
  option_name = :option

SELECT * FROM gfc_dm_options WHERE option_name='ticket_settings';

SELECT
  d.*,
  l.id_institution,
  p.identifier AS p_identifier,
  p.title AS p_title,
  pa.company as disposal_partner_display,
  pa2.company as acquisition_partner_display,
  pa3.company as service_partner_display,
  pc.id_product_category,
  pc.title AS pc_title,
  tr.title AS acquisition_tax_rate_title,
  tr.tax_rate AS acquisition_tax_rate_rate,
  tr2.title AS disposal_tax_rate_title,
  tr2.tax_rate AS disposal_tax_rate_rate,
  UNIX_TIMESTAMP(
    IF(
      UNIX_TIMESTAMP(d.acquisition_date) IS NOT NULL,
      d.acquisition_date,
      d.date_add
    )
  ) AS maintenance_start_ts,
  IF(
    d.publisher > 0,
    IF(
      scpe.id_product IS NOT NULL
      AND scpe.id_product > 0,
      scpe.id_product,
      d.id_product
    ),
    IF(
      mp.id_category_default IS NOT NULL
      AND mp.id_category_default > 0,
      mp.id_category_default,
      d.id_product
    )
  ) as id_product,
  p.maintenance AS p_maintenance,
  p.maintenance_relevance AS p_maintenance_relevance,
  p.maintenance_interval AS p_maintenance_interval,
  if(
    p.maintenance = 1, p.maintenance, d.maintenance
  ) AS maintenance,
  if(
    p.maintenance = 1, p.maintenance_relevance,
    d.maintenance_relevance
  ) AS maintenance_relevance,
  if(
    p.maintenance = 1, p.maintenance_interval,
    d.maintenance_interval
  ) AS maintenance_interval,
  m.company AS m_company,
  mp.title AS mp_title,
  mp.article_nr AS mp_article_nr,
  mp.ean13,
  mp.upc,
  dm.meta_value AS alt_title,
  l.company AS l_company,
  l.company2 AS l_company2,
  l.slug AS l_slug,
  l.location_specification AS location_specification,
  b.title AS b_title,
  r.title as r_title,
  r.designation as r_designation,
  COUNT(DISTINCT t.id_ticket) AS active_ticket_count
FROM
  gfc_dm_devices d
  LEFT JOIN gfc_dm_devices_meta dm ON d.id_device = dm.id_device
  AND dm.meta_key = 'alt_title'
  LEFT JOIN gfc_dm_manufacturer m ON d.id_manufacturer = m.id_manufacturer
  LEFT JOIN gfc_dm_manufacturer_products mp ON d.model_number = mp.uid
  LEFT JOIN gfc_dm_sys_catalog_publisher_editions scpe ON d.model_number = scpe.uid
  LEFT JOIN gfc_dm_products p ON IF(
    d.publisher > 0,
    IF(
      scpe.id_product IS NOT NULL
      AND scpe.id_product > 0,
      scpe.id_product,
      d.id_product
    ),
    IF(
      mp.id_category_default IS NOT NULL
      AND mp.id_category_default > 0,
      mp.id_category_default,
      d.id_product
    )
  ) = p.id_product
  LEFT JOIN gfc_dm_location l ON d.id_location = l.id_location
  LEFT JOIN gfc_dm_buildings b ON d.id_building = b.id_building
  LEFT JOIN gfc_dm_rooms r ON d.id_room = r.id_room
  LEFT JOIN gfc_dm_partner pa ON d.disposal_partner = pa.id_partner
  LEFT JOIN gfc_dm_partner pa2 ON d.acquisition_partner = pa2.id_partner
  LEFT JOIN gfc_dm_partner pa3 ON d.service_partner = pa3.id_partner
  LEFT JOIN gfc_dm_products_product_categories_mm ppm ON ppm.id_product = p.id_product
  LEFT JOIN gfc_dm_product_categories pc ON ppm.id_product_category = pc.id_product_category
  LEFT JOIN gfc_dm_sys_taxrates tr ON d.acquisition_tax_rate = tr.id_taxrate
  LEFT JOIN gfc_dm_sys_taxrates tr2 ON d.disposal_tax_rate = tr2.id_taxrate
  LEFT JOIN gfc_dm_tickets t ON d.id_device = t.id_device
  AND t.status != 76
WHERE
  d.id_device = :uid

SELECT d.*, l.id_institution, p.identifier AS p_identifier, p.title AS p_title, pa.company as disposal_partner_display, pa2.company as acquisition_partner_display, pa3.company as service_partner_display, pc.id_product_category, pc.title AS pc_title,
                                        tr.title AS acquisition_tax_rate_title,  tr.tax_rate AS acquisition_tax_rate_rate,   
                                        tr2.title AS disposal_tax_rate_title,  tr2.tax_rate AS disposal_tax_rate_rate,
                                        UNIX_TIMESTAMP( IF(UNIX_TIMESTAMP(d.acquisition_date) IS NOT NULL, d.acquisition_date, d.date_add) ) AS maintenance_start_ts,
                                        IF(d.publisher > 0,IF(scpe.id_product IS NOT NULL AND scpe.id_product > 0,scpe.id_product,d.id_product),IF(mp.id_category_default IS NOT NULL AND mp.id_category_default > 0,mp.id_category_default,d.id_product)) as id_product,
                                        p.maintenance AS p_maintenance, p.maintenance_relevance  AS p_maintenance_relevance, p.maintenance_interval  AS p_maintenance_interval,
                                        if(p.maintenance = 1, p.maintenance, d.maintenance) AS maintenance, if(p.maintenance = 1, p.maintenance_relevance, d.maintenance_relevance) AS maintenance_relevance, if(p.maintenance = 1, p.maintenance_interval, d.maintenance_interval) AS maintenance_interval,
                                        m.company AS m_company, mp.title AS mp_title, mp.article_nr AS mp_article_nr, mp.ean13, mp.upc, dm.meta_value AS alt_title,
                                        l.company AS l_company, l.company2 AS l_company2, l.slug AS l_slug, l.location_specification AS location_specification,  b.title AS b_title, r.title as r_title, r.designation as r_designation,  COUNT(DISTINCT t.id_ticket) AS active_ticket_count  FROM gfc_dm_devices d 
                                        LEFT JOIN gfc_dm_devices_meta dm ON d.id_device = dm.id_device AND dm.meta_key = 'alt_title'
                                        LEFT JOIN gfc_dm_manufacturer m ON d.id_manufacturer = m.id_manufacturer
                                        LEFT JOIN gfc_dm_manufacturer_products mp ON d.model_number = mp.uid 
                                        LEFT JOIN gfc_dm_sys_catalog_publisher_editions scpe ON d.model_number = scpe.uid
                                        LEFT JOIN gfc_dm_products p ON IF(d.publisher > 0,IF(scpe.id_product IS NOT NULL AND scpe.id_product > 0,scpe.id_product,d.id_product),IF(mp.id_category_default IS NOT NULL AND mp.id_category_default > 0,mp.id_category_default,d.id_product))  = p.id_product  
                                        LEFT JOIN gfc_dm_location l ON d.id_location = l.id_location
                                        LEFT JOIN gfc_dm_buildings b ON d.id_building = b.id_building
                                        LEFT JOIN gfc_dm_rooms r ON d.id_room = r.id_room
                                        LEFT JOIN gfc_dm_partner pa ON d.disposal_partner = pa.id_partner  
                                        LEFT JOIN gfc_dm_partner pa2 ON d.acquisition_partner = pa2.id_partner 
                                        LEFT JOIN gfc_dm_partner pa3 ON d.service_partner = pa3.id_partner 
                                        LEFT JOIN gfc_dm_products_product_categories_mm ppm ON ppm.id_product = p.id_product  
                                        LEFT JOIN gfc_dm_product_categories pc ON ppm.id_product_category = pc.id_product_category 
                                        LEFT JOIN gfc_dm_sys_taxrates tr ON d.acquisition_tax_rate = tr.id_taxrate 
                                        LEFT JOIN gfc_dm_sys_taxrates tr2 ON d.disposal_tax_rate = tr2.id_taxrate 
                                        LEFT JOIN gfc_dm_tickets t ON d.id_device = t.id_device AND t.status != 76
                                        WHERE d.id_device = '155506';

SELECT
  pm.*
FROM
  gfc_dm_devices_meta pm
WHERE
  pm.id_device = :uid

SELECT pm.*
                        FROM gfc_dm_devices_meta pm 
                        WHERE pm.id_device = '155506';

SELECT
  *
FROM
  gfc_dm_files
WHERE
  ref_table = 'devices'
  AND ref_uid = :uid

SELECT * FROM gfc_dm_files WHERE ref_table = 'devices' AND ref_uid = '155506';

SELECT
  d.*,
  UNIX_TIMESTAMP(d.acquisition_date) AS acquisition_date_ts,
  p.identifier AS p_identifier,
  p.title AS p_title,
  m.company AS m_company,
  mp.title AS mp_title,
  mp.article_nr AS mp_article_nr,
  mp.ean13,
  mp.upc
FROM
  gfc_dm_devices d
  LEFT JOIN gfc_dm_products p ON d.id_product = p.id_product
  LEFT JOIN gfc_dm_manufacturer m ON d.id_manufacturer = m.id_manufacturer
  LEFT JOIN gfc_dm_manufacturer_products mp ON d.model_number = mp.uid
WHERE
  d.id_parent = :uid

SELECT d.*, UNIX_TIMESTAMP(d.acquisition_date) AS acquisition_date_ts,
                                        p.identifier AS p_identifier, p.title AS p_title,
                                        m.company AS m_company, mp.title AS mp_title, mp.article_nr AS mp_article_nr, mp.ean13, mp.upc
                                        FROM gfc_dm_devices d 
                                        LEFT JOIN gfc_dm_products p ON d.id_product = p.id_product  
                                        LEFT JOIN gfc_dm_manufacturer m ON d.id_manufacturer = m.id_manufacturer
                                        LEFT JOIN gfc_dm_manufacturer_products mp ON d.model_number = mp.uid
                                        WHERE d.id_parent = '155506';

SELECT
  d.id_device,
  d.inventory_number,
  d.serial_number,
  d.title,
  d.additional_equipment,
  d.device_status,
  d.last_scan,
  UNIX_TIMESTAMP(d.last_scan) AS last_scan_ts,
  d.is_missing,
  UNIX_TIMESTAMP(d.missing_alert_date) AS missing_alert_date_ts,
  p.identifier AS p_identifier,
  p.title AS p_title,
  m.company AS m_company,
  mp.title AS mp_title,
  mp.article_nr AS mp_article_nr,
  mp.ean13,
  mp.upc,
  (
    SELECT
      meta_value
    FROM
      gfc_dm_devices_meta
    WHERE
      meta_key = 'rack_HE'
      AND id_device = d.id_device
  ) AS rack_HE,
  COUNT(DISTINCT t.id_ticket) AS active_ticket_count
FROM
  gfc_dm_devices d
  LEFT JOIN gfc_dm_products p ON d.id_product = p.id_product
  LEFT JOIN gfc_dm_manufacturer m ON d.id_manufacturer = m.id_manufacturer
  LEFT JOIN gfc_dm_manufacturer_products mp ON d.model_number = mp.uid
  LEFT JOIN gfc_dm_tickets t ON d.id_device = t.id_device
  AND t.status != 76
WHERE
  d.id_collection_device = :uid
  OR d.id_device = :id_collection_device
GROUP BY
  d.id_device

SELECT d.id_device, d.inventory_number, d.serial_number, d.title, d.additional_equipment, d.device_status, d.last_scan, UNIX_TIMESTAMP(d.last_scan) AS last_scan_ts, d.is_missing, UNIX_TIMESTAMP(d.missing_alert_date) AS missing_alert_date_ts,
                                    p.identifier AS p_identifier, p.title AS p_title,
                                    m.company AS m_company, mp.title AS mp_title, mp.article_nr AS mp_article_nr, mp.ean13, mp.upc, 
                                    (SELECT meta_value FROM gfc_dm_devices_meta WHERE meta_key = 'rack_HE' AND id_device = d.id_device) AS rack_HE,
                                     COUNT(DISTINCT t.id_ticket) AS active_ticket_count 
                                    FROM gfc_dm_devices d 
                                    LEFT JOIN gfc_dm_products p ON d.id_product = p.id_product  
                                    LEFT JOIN gfc_dm_manufacturer m ON d.id_manufacturer = m.id_manufacturer
                                    LEFT JOIN gfc_dm_manufacturer_products mp ON d.model_number = mp.uid LEFT JOIN gfc_dm_tickets t ON d.id_device = t.id_device AND t.status != 76
                                    WHERE d.id_collection_device = '155506' OR d.id_device = -1
                                    GROUP BY d.id_device;

SELECT
  d.id_device,
  d.title,
  d.inventory_number,
  dr.contract_number,
  dr.unlimited,
  dr.handing_over_type,
  dr.current_state,
  dr.date_handing_over,
  dr.date_return,
  UNIX_TIMESTAMP(dr.date_handing_over) AS date_handing_over_ts,
  UNIX_TIMESTAMP(dr.date_return) AS date_return_ts,
  dr.date_start,
  dr.date_end,
  UNIX_TIMESTAMP(dr.date_start) AS date_start_ts,
  UNIX_TIMESTAMP(dr.date_end) AS date_end_ts
FROM
  gfc_dm_devices d
  LEFT JOIN gfc_dm_devices_repair dr ON d.id_device = dr.id_device
WHERE
  dr.current_state <= 2
  AND dr.id_device IN (155506)
  AND (
    dr.uid IS NOT NULL
    AND (
      (
        dr.unlimited = 1
        AND (
          IF(
            dr.date_handing_over IS NULL
            OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
            OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
            dr.date_start,
            dr.date_handing_over
          ) <= '2025-12-16'
          OR IF(
            dr.date_handing_over IS NULL
            OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
            OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
            dr.date_start,
            dr.date_handing_over
          ) <= '2025-12-16'
        )
      )
      OR (
        dr.unlimited = 0
        AND (
          (
            IF(
              dr.date_return IS NULL
              OR UNIX_TIMESTAMP(dr.date_return) <= 0
              OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
              dr.date_end,
              dr.date_return
            ) >= '2025-12-16'
            AND IF(
              dr.date_handing_over IS NULL
              OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
              OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
              dr.date_start,
              dr.date_handing_over
            ) <= '2025-12-16'
          )
          OR (
            IF(
              dr.date_return IS NULL
              OR UNIX_TIMESTAMP(dr.date_return) <= 0
              OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
              dr.date_end,
              dr.date_return
            ) >= '2025-12-16'
            AND IF(
              dr.date_handing_over IS NULL
              OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
              OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
              dr.date_start,
              dr.date_handing_over
            ) <= '2025-12-16'
          )
          OR (
            IF(
              dr.date_return IS NULL
              OR UNIX_TIMESTAMP(dr.date_return) <= 0
              OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
              dr.date_end,
              dr.date_return
            ) <= '2025-12-16'
            AND IF(
              dr.date_handing_over IS NULL
              OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
              OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
              dr.date_start,
              dr.date_handing_over
            ) >= '2025-12-16'
          )
        )
      )
    )
  )

SELECT d.id_device, d.title, d.inventory_number,  dr.contract_number, dr.unlimited, dr.handing_over_type, dr.current_state,
                                        dr.date_handing_over, dr.date_return,UNIX_TIMESTAMP(dr.date_handing_over) AS date_handing_over_ts, UNIX_TIMESTAMP(dr.date_return) AS date_return_ts,
                                        dr.date_start, dr.date_end, UNIX_TIMESTAMP(dr.date_start) AS date_start_ts, UNIX_TIMESTAMP(dr.date_end) AS date_end_ts
                                        FROM gfc_dm_devices d
                                        LEFT JOIN gfc_dm_devices_repair dr ON d.id_device = dr.id_device
                                        WHERE dr.current_state <= 2  AND dr.id_device IN (155506)
                                        AND ( dr.uid IS NOT NULL
                                            AND ( 
                                                    ( 
                                                    dr.unlimited = 1
                                                    AND ( IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,dr.date_start,dr.date_handing_over)  <= '2025-12-16' 
                                                        OR IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,dr.date_start,dr.date_handing_over)  <= '2025-12-16' 
                                                        )
                                                    )
                                                    OR
                                                    (dr.unlimited = 0 AND
                                                    ( 
                                                        ( IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,dr.date_end,dr.date_return) >= '2025-12-16'
                                                        AND IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,dr.date_start,dr.date_handing_over)  <= '2025-12-16'
                                                        )
                                                        OR
                            ( IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,dr.date_end,dr.date_return) >= '2025-12-16'
                            AND IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,dr.date_start,dr.date_handing_over)  <= '2025-12-16'
                            )
                            OR
                            ( IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,dr.date_end,dr.date_return) <= '2025-12-16'
                            AND IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,dr.date_start,dr.date_handing_over)  >= '2025-12-16'
                            )
                            
                                                    )
                                                    )
                                                    
                                                )
                                            )
                                        ;

SELECT
  d.id_device,
  d.title,
  d.inventory_number,
  dr.id_parent,
  drp.uid AS main_rental_id,
  drp.contract_number,
  drp.unlimited,
  dr.uid AS rental_id,
  dr.date_handing_over,
  dr.date_return,
  UNIX_TIMESTAMP(dr.date_handing_over) AS date_handing_over_ts,
  UNIX_TIMESTAMP(dr.date_return) AS date_return_ts,
  drp.date_start,
  drp.date_end,
  UNIX_TIMESTAMP(drp.date_start) AS date_start_ts,
  UNIX_TIMESTAMP(drp.date_end) AS date_end_ts,
  IF(
    dr.date_handing_over IS NULL
    OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
    OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
    drp.date_start,
    dr.date_handing_over
  ) AS main_date_start,
  IF(
    dr.date_return IS NULL
    OR UNIX_TIMESTAMP(dr.date_return) <= 0
    OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
    drp.date_end,
    dr.date_return
  ) AS main_date_end,
  IF(
    dr.date_handing_over IS NULL
    OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
    OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
    drp.date_handing_over,
    dr.date_handing_over
  ) AS main_date_handing_over,
  IF(
    dr.date_return IS NULL
    OR UNIX_TIMESTAMP(dr.date_return) <= 0
    OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
    drp.date_return,
    dr.date_return
  ) AS main_date_return,
  IF(
    dr.date_handing_over IS NULL
    OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
    OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
    UNIX_TIMESTAMP(drp.date_start),
    UNIX_TIMESTAMP(dr.date_handing_over)
  ) AS main_date_start_ts,
  IF(
    dr.date_return IS NULL
    OR UNIX_TIMESTAMP(dr.date_return) <= 0
    OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
    UNIX_TIMESTAMP(drp.date_end),
    UNIX_TIMESTAMP(dr.date_return)
  ) AS main_date_end_ts,
  IF(
    dr.date_handing_over IS NULL
    OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
    OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
    UNIX_TIMESTAMP(drp.date_handing_over),
    UNIX_TIMESTAMP(dr.date_handing_over)
  ) AS main_date_handing_over_ts,
  IF(
    dr.date_return IS NULL
    OR UNIX_TIMESTAMP(dr.date_return) <= 0
    OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
    UNIX_TIMESTAMP(drp.date_return),
    UNIX_TIMESTAMP(dr.date_return)
  ) AS main_date_return_ts
FROM
  gfc_dm_devices d
  LEFT JOIN gfc_dm_devices_rental dr ON d.id_device = dr.id_device
  AND dr.id_parent != 0
  LEFT JOIN gfc_dm_devices_rental drp ON dr.id_parent = drp.uid
WHERE
  1 = 1
  AND dr.id_device IN (155506)
  AND (
    drp.uid IS NOT NULL
    AND (
      (
        drp.unlimited = 1
        AND (
          IF(
            dr.date_handing_over IS NULL
            OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
            OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
            drp.date_start,
            dr.date_handing_over
          ) <= '2025-12-16 15:27:41'
          OR IF(
            dr.date_handing_over IS NULL
            OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
            OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
            drp.date_start,
            dr.date_handing_over
          ) <= '2025-12-16 15:27:41'
        )
      )
      OR (
        drp.unlimited = 0
        AND (
          (
            IF(
              dr.date_return IS NULL
              OR UNIX_TIMESTAMP(dr.date_return) <= 0
              OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
              drp.date_end,
              dr.date_return
            ) >= '2025-12-16 15:27:41'
            AND IF(
              dr.date_handing_over IS NULL
              OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
              OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
              drp.date_start,
              dr.date_handing_over
            ) <= '2025-12-16 15:27:41'
          )
          OR (
            IF(
              dr.date_return IS NULL
              OR UNIX_TIMESTAMP(dr.date_return) <= 0
              OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
              drp.date_end,
              dr.date_return
            ) >= '2025-12-16 15:27:41'
            AND IF(
              dr.date_handing_over IS NULL
              OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
              OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
              drp.date_start,
              dr.date_handing_over
            ) <= '2025-12-16 15:27:41'
          )
          OR (
            IF(
              dr.date_return IS NULL
              OR UNIX_TIMESTAMP(dr.date_return) <= 0
              OR UNIX_TIMESTAMP(dr.date_return) IS NULL,
              drp.date_end,
              dr.date_return
            ) <= '2025-12-16 15:27:41'
            AND IF(
              dr.date_handing_over IS NULL
              OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0
              OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,
              drp.date_start,
              dr.date_handing_over
            ) >= '2025-12-16 15:27:41'
          )
        )
      )
    )
  )

SELECT d.id_device, d.title, d.inventory_number, dr.id_parent, drp.uid AS main_rental_id, drp.contract_number, drp.unlimited,
                                        dr.uid AS rental_id,  dr.date_handing_over, dr.date_return,UNIX_TIMESTAMP(dr.date_handing_over) AS date_handing_over_ts, UNIX_TIMESTAMP(dr.date_return) AS date_return_ts,
                                        drp.date_start, drp.date_end, UNIX_TIMESTAMP(drp.date_start) AS date_start_ts, UNIX_TIMESTAMP(drp.date_end) AS date_end_ts,
                                        IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,drp.date_start,dr.date_handing_over) AS main_date_start,                                 
                                        IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,drp.date_end,dr.date_return) AS main_date_end,
                                        IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,drp.date_handing_over,dr.date_handing_over) AS main_date_handing_over,
                                        IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,drp.date_return,dr.date_return) AS main_date_return,
                                        IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,UNIX_TIMESTAMP(drp.date_start),UNIX_TIMESTAMP(dr.date_handing_over)) AS main_date_start_ts,                                 
                                        IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,UNIX_TIMESTAMP(drp.date_end),UNIX_TIMESTAMP(dr.date_return)) AS main_date_end_ts,
                                        IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,UNIX_TIMESTAMP(drp.date_handing_over),UNIX_TIMESTAMP(dr.date_handing_over)) AS main_date_handing_over_ts,
                                        IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,UNIX_TIMESTAMP(drp.date_return),UNIX_TIMESTAMP(dr.date_return)) AS main_date_return_ts
                                        FROM gfc_dm_devices d
                                        LEFT JOIN gfc_dm_devices_rental dr ON d.id_device = dr.id_device AND dr.id_parent != 0
                                        LEFT JOIN gfc_dm_devices_rental drp ON dr.id_parent = drp.uid 
                                        WHERE 1=1  AND dr.id_device IN (155506)
                                        AND ( drp.uid IS NOT NULL
                                            AND ( 
                                                    ( 
                                                    drp.unlimited = 1
                                                    AND ( IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,drp.date_start,dr.date_handing_over)  <= '2025-12-16 15:27:41' 
                                                        OR IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,drp.date_start,dr.date_handing_over)  <= '2025-12-16 15:27:41' 
                                                        )
                                                    )
                                                    OR
                                                    (drp.unlimited = 0 AND
                                                    ( 
                                                        ( IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,drp.date_end,dr.date_return) >= '2025-12-16 15:27:41'
                                                        AND IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,drp.date_start,dr.date_handing_over)  <= '2025-12-16 15:27:41'
                                                        )
                                                        OR
                            ( IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,drp.date_end,dr.date_return) >= '2025-12-16 15:27:41'
                            AND IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,drp.date_start,dr.date_handing_over)  <= '2025-12-16 15:27:41'
                            )
                            OR
                            ( IF(dr.date_return IS NULL OR UNIX_TIMESTAMP(dr.date_return) <= 0 OR UNIX_TIMESTAMP(dr.date_return) IS NULL,drp.date_end,dr.date_return) <= '2025-12-16 15:27:41'
                            AND IF(dr.date_handing_over IS NULL OR UNIX_TIMESTAMP(dr.date_handing_over) <= 0 OR UNIX_TIMESTAMP(dr.date_handing_over) IS NULL,drp.date_start,dr.date_handing_over)  >= '2025-12-16 15:27:41'
                            )
                            
                                                    )
                                                    )
                                                    
                                                )
                                            )
                                        ;

SELECT
  umm.*,
  u.*
FROM
  gfc_dm_users u
  JOIN gfc_dm_users_mm umm ON umm.id_user = u.id_user
  AND umm.ref_table = 'devices'
  AND umm.ref_uid = :uid
ORDER BY
  u.lastname

SELECT umm.*, u.* 
                                        FROM gfc_dm_users u 
                                        JOIN gfc_dm_users_mm umm ON umm.id_user = u.id_user AND umm.ref_table = 'devices' AND umm.ref_uid = '155506'
                                         ORDER BY u.lastname;