| 0.0008 s |
get_user_typen |
SELECT *
FROM zanew_user_typ |
| 0.0017 s |
get_user |
SELECT *
FROM zanew_user
LEFT JOIN zanew_user_typ ut on ut.typ_id = user_user_typ
LEFT JOIN zanew_userimages i ON i.userimages_id = user_profilbild_id
WHERE
user_id = 474
LIMIT 1; |
| 0.0002 s |
get_user_ort |
SELECT *
FROM zanew_orte
WHERE ort_id = 2201
limit 1 |
| 0.0002 s |
get_last_emp_all |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0011 s |
get_user |
SELECT *
FROM zanew_user
LEFT JOIN zanew_user_typ ut on ut.typ_id = user_user_typ
LEFT JOIN zanew_userimages i ON i.userimages_id = user_profilbild_id
WHERE
user_id = 474
LIMIT 1; |
| 0.0003 s |
get_user_ort |
SELECT *
FROM zanew_orte
WHERE ort_id = 2201
limit 1 |
| 0.0003 s |
get_last_emp_all |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0013 s |
get_user_award |
SELECT *
FROM zanew_award_data
JOIN zanew_award on award_id = useraward_award_id
WHERE useraward_user_id = 474
|
| 0.0013 s |
get_danke_cluster |
SELECT *
FROM zanew_danke_cluster
JOIN zanew_danke_type on danketype_id = cluster_danke_type_id
WHERE cluster_user_id = 474
AND danketype_open = 1
ORDER BY cluster_count desc ; |
| 0.0013 s |
get_last_emp |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_danke_type_id = 3
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0012 s |
get_last_emp |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_danke_type_id = 10
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0012 s |
get_last_emp |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_danke_type_id = 16
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0012 s |
get_last_emp |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_danke_type_id = 14
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0012 s |
get_last_emp |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_danke_type_id = 2
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0012 s |
get_last_emp |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_danke_type_id = 1
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0012 s |
get_last_emp |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 474
AND empf_danke_type_id = 9
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0004 s |
get_danke_cluster_not_in |
SELECT *
FROM zanew_danke_type
WHERE danketype_id not in (3,10,16,14,2,1,9)
AND danketype_open = 1
ORDER BY danketype_id asc ; |
