Symfony Profiler

INSERT INTO pixel_dates (
  FunctionName, StartEnde, UpdateDatetime
)
VALUES
  (?, ?, ?)

INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime)
                VALUES('import/customers','Start','2024-09-21 14:20:03');

INSERT INTO pixel_dates (
  FunctionName, StartEnde, UpdateDatetime
)
VALUES
  (?, ?, ?)

INSERT INTO pixel_dates (FunctionName,StartEnde,UpdateDatetime)
                VALUES('import/customers','ENDE','2024-09-21 14:20:12');

SELECT
  *,
  customers.customer_number as customer_number,
  customers.email as customer_email,
  k1.key_text as price_list,
  k2.key_text as salesman,
  k3.key_text as salesarea,
  k4.key_text as tour,
  k5.key_text as payment_term,
  k6.key_text as delivery_term,
  k7.key_text as `group`
FROM
  customers
  LEFT JOIN contacts ON (
    customers.customer_number = contacts.customer_number
  )
  LEFT JOIN `keys` as k1 ON (
    k1.key_number = customers.price_list
    AND k1.key_kind = 7
  )
  LEFT JOIN `keys` as k2 ON (
    k2.key_number = customers.salesman
    AND k2.key_kind = 8
  )
  LEFT JOIN `keys` as k3 ON (
    k3.key_number = customers.sales_area
    AND k3.key_kind = 9
  )
  LEFT JOIN `keys` as k4 ON (
    k4.key_number = customers.tour
    AND k4.key_kind = 52
  )
  LEFT JOIN `keys` as k5 ON (
    k5.key_number = customers.payment_term
    AND k5.key_kind = 4
  )
  LEFT JOIN `keys` as k6 ON (
    k6.key_number = customers.delivery_term
    AND k6.key_kind = 5
  )
  LEFT JOIN `keys` as k7 ON (
    k7.key_number = customers.group
    AND k7.key_kind = 3
  )
WHERE
  customers.customer_number IS NOT NULL
  AND customers.street IS NOT NULL
  AND customers.street != ''
  AND customers.email IS NOT NULL
  AND customers.email != ''
  AND customers.email LIKE '%@%'
  AND name_1 IS NOT NULL
  AND name_1 != ''
  AND upload_done IS NULL -- AND customers.customer_number = '14254' -- #TODO: REMOVE THIS LINE!!!

LIMIT
  50;

SELECT *
        , customers.customer_number as customer_number
        , customers.email as customer_email
        , k1.key_text as price_list
        , k2.key_text as salesman
        , k3.key_text as salesarea
        , k4.key_text as tour
        , k5.key_text as payment_term
        , k6.key_text as delivery_term
        , k7.key_text as `group`
            FROM customers
            LEFT JOIN contacts ON (customers.customer_number = contacts.customer_number)
            LEFT JOIN `keys` as k1 ON (k1.key_number = customers.price_list AND k1.key_kind = 7)
            LEFT JOIN `keys` as k2 ON (k2.key_number = customers.salesman AND k2.key_kind = 8)
            LEFT JOIN `keys` as k3 ON (k3.key_number = customers.sales_area AND k3.key_kind = 9)
            LEFT JOIN `keys` as k4 ON (k4.key_number = customers.tour AND k4.key_kind = 52)
            LEFT JOIN `keys` as k5 ON (k5.key_number = customers.payment_term AND k5.key_kind = 4)
            LEFT JOIN `keys` as k6 ON (k6.key_number = customers.delivery_term AND k6.key_kind = 5)
            LEFT JOIN `keys` as k7 ON (k7.key_number = customers.group AND k7.key_kind = 3)
            WHERE customers.customer_number IS NOT NULL
            AND customers.street IS NOT NULL AND customers.street !=''
            AND customers.email IS NOT NULL AND customers.email !='' AND customers.email LIKE '%@%'
            AND name_1 IS NOT NULL AND name_1 != ''
            AND upload_done IS NULL
            -- AND customers.customer_number = '14254' -- #TODO: REMOVE THIS LINE!!!

            LIMIT 50
        ;;

UPDATE
  customers
SET
  upload_done = 1,
  upload_failed = 1
WHERE
  customer_number = ''
  OR (
    upload_done IS NULL
    AND upload_failed IS NULL
  );

UPDATE customers
                SET upload_done = 1, upload_failed = 1
                WHERE customer_number = ''
                OR (upload_done IS NULL AND upload_failed IS NULL)
                ;;