2024-10-22T17:29:40.270012Z 191 Close stmt
2024-10-22T17:29:40.270235Z 191 Prepare /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/
SELECT
core_badges.*,
core_member_badges.member,
core_member_badges.badge,
core_member_badges.datetime,
core_member_badges.rule,
core_member_badges.action_log,
core_member_badges.actor,
core_member_badges.recognize
FROM
`core_member_badges` AS `core_member_badges`
LEFT JOIN
`core_badges` AS `core_badges`
ON
core_member_badges.badge = core_badges.id
WHERE
`member` = ?
ORDER BY
datetime DESC
LIMIT 5
2024-10-22T17:29:40.270384Z 191 Prepare /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/
SELECT
core_badges.*,
core_member_badges.member,
core_member_badges.badge,
core_member_badges.datetime,
core_member_badges.rule,
core_member_badges.action_log,
core_member_badges.actor,
core_member_badges.recognize
FROM
`core_member_badges` AS `core_member_badges`
LEFT JOIN
`core_badges` AS `core_badges`
ON
core_member_badges.badge = core_badges.id
WHERE
`member` = ?
ORDER BY
datetime DESC
LIMIT 5
2024-10-22T17:29:40.270408Z 191 Execute /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/
SELECT
core_badges.*,
core_member_badges.member,
core_member_badges.badge,
core_member_badges.datetime,
core_member_badges.rule,
core_member_badges.action_log,
core_member_badges.actor,
core_member_badges.recognize
FROM
`core_member_badges` AS `core_member_badges`
LEFT JOIN
`core_badges` AS `core_badges`
ON
core_member_badges.badge = core_badges.id
WHERE
`member` = 1
ORDER BY
datetime DESC
LIMIT 5
2024-10-22T17:29:40.271097Z 191 Prepare /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/
SELECT
core_badges.*,
core_member_badges.member,
core_member_badges.badge,
core_member_badges.datetime,
core_member_badges.rule,
core_member_badges.action_log,
core_member_badges.actor,
core_member_badges.recognize
FROM
`core_member_badges` AS `core_member_badges`
LEFT JOIN
`core_badges` AS `core_badges`
ON
core_member_badges.badge = core_badges.id
WHERE
`member` = ?
ORDER BY
datetime DESC
LIMIT 5
2024-10-22T17:29:40.271223Z 191 Prepare /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/
SELECT
core_badges.*,
core_member_badges.member,
core_member_badges.badge,
core_member_badges.datetime,
core_member_badges.rule,
core_member_badges.action_log,
core_member_badges.actor,
core_member_badges.recognize
FROM
`core_member_badges` AS `core_member_badges`
LEFT JOIN
`core_badges` AS `core_badges`
ON
core_member_badges.badge = core_badges.id
WHERE
`member` = ?
ORDER BY
datetime DESC
LIMIT 5
2024-10-22T17:29:40.271238Z 191 Execute /*::IPS\Theme\Cache\class_core_front_profile::profile:61*/
SELECT
core_badges.*,
core_member_badges.member,
core_member_badges.badge,
core_member_badges.datetime,
core_member_badges.rule,
core_member_badges.action_log,
core_member_badges.actor,
core_member_badges.recognize
FROM
`core_member_badges` AS `core_member_badges`
LEFT JOIN
`core_badges` AS `core_badges`
ON
core_member_badges.badge = core_badges.id
WHERE
`member` = 1
ORDER BY
datetime DESC
LIMIT 5
2024-10-22T17:29:40.271749Z 191 Prepare /*::IPS\core\Achievements\_Badge::awardDescription:100*/
SELECT
word_key,
word_default,
word_custom
FROM
`core_sys_lang_words` AS `core_sys_lang_words`
WHERE
lang_id = ?
AND
(word_key LIKE 'core_award_subject_badge_%' OR word_key LIKE 'core_award_other_badge_%')
2024-10-22T17:29:40.271838Z 191 Prepare /*::IPS\core\Achievements\_Badge::awardDescription:100*/
SELECT
word_key,
word_default,
word_custom
FROM
`core_sys_lang_words` AS `core_sys_lang_words`
WHERE
lang_id = ?
AND
(word_key LIKE 'core_award_subject_badge_%' OR word_key LIKE 'core_award_other_badge_%')
2024-10-22T17:29:40.271853Z 191 Execute /*::IPS\core\Achievements\_Badge::awardDescription:100*/
SELECT
word_key,
word_default,
word_custom
FROM
`core_sys_lang_words` AS `core_sys_lang_words`
WHERE
lang_id = 28
AND
(word_key LIKE 'core_award_subject_badge_%' OR word_key LIKE 'core_award_other_badge_%')
2024-10-22T17:29:40.273654Z 191 Close stmt
2024-10-22T17:29:40.274939Z 191 Close stmt
2024-10-22T17:29:40.275266Z 191 Close stmt
2024-10-22T17:29:40.275481Z 191 Prepare /*::IPS\Dispatcher\_Front::finish:155*/
SELECT
*
FROM
`core_widget_areas` AS `core_widget_areas`
WHERE
app = ?
AND
module = ?
AND
controller = ?
2024-10-22T17:29:40.275575Z 191 Execute /*::IPS\Dispatcher\_Front::finish:155*/
SELECT
*
FROM
`core_widget_areas` AS `core_widget_areas`
WHERE
app = 'core'
AND
module = 'members'
AND
controller = 'profile'
2024-10-22T17:29:40.275861Z 191 Close stmt
2024-10-22T17:29:40.277203Z 191 Prepare /*::IPS\core\Alerts\_Alert::getNextAlertForMember:835*/
SELECT
*
FROM
`core_alerts` AS `core_alerts`
WHERE
alert_enabled = ?
AND
alert_start < ?
AND
(alert_end = 0 OR alert_end > ?)
AND
(alert_recipient_type = ? OR (alert_recipient_type = ? AND alert_recipient_user IS NULL))
AND
alert_id NOT IN (
SELECT
seen_alert_id
FROM
`core_alerts_seen` AS `core_alerts_seen`
WHERE
seen_member_id IS NULL
)
ORDER BY
alert_start ASC
2024-10-22T17:29:40.277354Z 191 Prepare /*::IPS\core\Alerts\_Alert::getNextAlertForMember:835*/
SELECT
*
FROM
`core_alerts` AS `core_alerts`
WHERE
alert_enabled = ?
AND
alert_start < ?
AND
(alert_end = 0 OR alert_end > ?)
AND
(alert_recipient_type = ? OR (alert_recipient_type = ? AND alert_recipient_user IS NULL))
AND
alert_id NOT IN (
SELECT
seen_alert_id
FROM
`core_alerts_seen` AS `core_alerts_seen`
WHERE
seen_member_id IS NULL
)
ORDER BY
alert_start ASC
2024-10-22T17:29:40.277396Z 191 Execute /*::IPS\core\Alerts\_Alert::getNextAlertForMember:835*/
SELECT
*
FROM
`core_alerts` AS `core_alerts`
WHERE
alert_enabled = 1
AND
alert_start < 1697993417
AND
(alert_end = 0 OR alert_end > 1697993417)
AND
(alert_recipient_type = 1 OR (alert_recipient_type = 0 AND alert_recipient_user IS NULL))
AND
alert_id NOT IN (
SELECT
seen_alert_id
FROM
`core_alerts_seen` AS `core_alerts_seen`
WHERE
seen_member_id IS NULL
)
ORDER BY
alert_start ASC
В том то и дело, я не могу понять, полезно это или нет.
Я конечно же обновлюсь на пятерку (Только чуть позже), но пока я тут, и вижу такой лайк как полезно…. Слушайте я вангую что это может сбросить неплохо так размер в БД, ну и какую то нагрузку может быть… Хочу дать вам идею на размышление. Смотрите, лайк и лайк полезно, это разные вещи. Делаем логичный вывод, зачем два разных лайка на одном посте? То есть с новым типом лайка можно спокойно старый лайк отключить, и репутацию в принципе тоже отключить…. И я наверное так и поступлю…
