| 0.0004 s |
get_user_typen |
SELECT *
FROM zanew_user_typ |
| 0.0012 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 = 3050
LIMIT 1; |
| 0.0003 s |
get_user_ort |
SELECT *
FROM zanew_orte
WHERE ort_id = 502
limit 1 |
| 0.0006 s |
get_last_emp_all |
SELECT *
FROM zanew_danke
JOIN zanew_danke_type on danketype_id = empf_danke_type_id
WHERE empf_user_id = 3050
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0005 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 = 3050
LIMIT 1; |
| 0.0001 s |
get_user_ort |
SELECT *
FROM zanew_orte
WHERE ort_id = 502
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 = 3050
AND empf_text != ""
ORDER BY empf_forum_id asc, empf_id desc limit 1 ; |
| 0.0008 s |
get_user_award |
SELECT *
FROM zanew_award_data
JOIN zanew_award on award_id = useraward_award_id
WHERE useraward_user_id = 3050
|
| 0.0010 s |
get_danke_cluster |
SELECT *
FROM zanew_danke_cluster
JOIN zanew_danke_type on danketype_id = cluster_danke_type_id
WHERE cluster_user_id = 3050
AND danketype_open = 1
ORDER BY cluster_count desc ; |
| 0.0001 s |
get_danke_typen |
SELECT *
FROM zanew_danke_type
where danketype_open = 1 |
