Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires`, `Session`.`created`, `Session`.`modified` FROM `unityzohar_unityzohar2`.`unity_sessions` AS `Session` WHERE `Session`.`id` = 'hlj9krkf7if6r82i9cr6130br1' LIMIT 1 | 0 | 0 | 0 | |
SELECT `TikunimCycle`.`id`, `TikunimCycle`.`cycle`, `TikunimCycle`.`unity_session_id`, `TikunimCycle`.`ip_address`, `TikunimCycle`.`zohar_id`, `TikunimCycle`.`lng`, `TikunimCycle`.`lat`, `TikunimCycle`.`country`, `TikunimCycle`.`country_iso`, `TikunimCycle`.`state`, `TikunimCycle`.`city`, `TikunimCycle`.`token`, `TikunimCycle`.`created`, `TikunimCycle`.`modified` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE `TikunimCycle`.`unity_session_id` = 'hlj9krkf7if6r82i9cr6130br1' LIMIT 1 | 0 | 0 | 58 | maybe slow |
SELECT `TikunimCycle`.`id`, `TikunimCycle`.`cycle`, `TikunimCycle`.`unity_session_id`, `TikunimCycle`.`ip_address`, `TikunimCycle`.`zohar_id`, `TikunimCycle`.`lng`, `TikunimCycle`.`lat`, `TikunimCycle`.`country`, `TikunimCycle`.`country_iso`, `TikunimCycle`.`state`, `TikunimCycle`.`city`, `TikunimCycle`.`token`, `TikunimCycle`.`created`, `TikunimCycle`.`modified` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE 1 = 1 ORDER BY `id` DESC LIMIT 1 | 1 | 1 | 0 | |
BEGIN | | | | |
INSERT INTO `unityzohar_unityzohar2`.`tikunim_cycles` (`unity_session_id`, `zohar_id`, `cycle`, `token`, `modified`, `created`) VALUES ('hlj9krkf7if6r82i9cr6130br1', 76836, 222, NULL, '2024-07-27 10:49:01', '2024-07-27 10:49:01') | 1 | 1 | 1 | |
COMMIT | | | | |
SELECT `TikunimCycle`.`id`, `TikunimCycle`.`cycle`, `TikunimCycle`.`unity_session_id`, `TikunimCycle`.`ip_address`, `TikunimCycle`.`zohar_id`, `TikunimCycle`.`lng`, `TikunimCycle`.`lat`, `TikunimCycle`.`country`, `TikunimCycle`.`country_iso`, `TikunimCycle`.`state`, `TikunimCycle`.`city`, `TikunimCycle`.`token`, `TikunimCycle`.`created`, `TikunimCycle`.`modified` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE `TikunimCycle`.`id` = 111816 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TikunimCycle`.`id`, `TikunimCycle`.`cycle`, `TikunimCycle`.`unity_session_id`, `TikunimCycle`.`ip_address`, `TikunimCycle`.`zohar_id`, `TikunimCycle`.`lng`, `TikunimCycle`.`lat`, `TikunimCycle`.`country`, `TikunimCycle`.`country_iso`, `TikunimCycle`.`state`, `TikunimCycle`.`city`, `TikunimCycle`.`token`, `TikunimCycle`.`created`, `TikunimCycle`.`modified` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE 1 = 1 ORDER BY `TikunimCycle`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Zohar`.`id`, `Zohar`.`parasha_id`, `Zohar`.`tikun`, `Zohar`.`tikun_name`, `Zohar`.`daf`, `Zohar`.`amud`, `Zohar`.`paragraph_num_h`, `Zohar`.`paragraph_num`, `Zohar`.`text_aramaic`, `Zohar`.`text_hebrew`, `Zohar`.`floating_text_aramaic`, `Zohar`.`floating_text_hebrew`, `Zohar`.`text_english`, `Zohar`.`notes`, `Zohar`.`created`, `Zohar`.`modified`, `Zohar`.`user_id`, `Parasha`.`id`, `Parasha`.`name`, `Parasha`.`name_hebrew`, `Parasha`.`termid`, `Parasha`.`slug`, `Parasha`.`dz_slug`, `Parasha`.`order`, `Parasha`.`active`, `Parasha`.`created`, `Parasha`.`modified`, `Parasha`.`audio_name`, `Parasha`.`ebook`, `Parasha`.`estudyurl1`, `Parasha`.`estudyurl2`, `Parasha`.`seq`, `Parasha`.`parcount` FROM `unityzohar_unityzohar2`.`zohars` AS `Zohar` LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`Zohar`.`parasha_id` = `Parasha`.`id`) WHERE `Zohar`.`id` > 76836 AND `Parasha`.`slug` = 'tikunei-zohar' LIMIT 2 | 2 | 2 | 0 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 76837
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 1 | 1 | 27 | maybe slow |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 76838
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 1 | 1 | 13 | maybe slow |
SELECT `Translation`.`id`, `Translation`.`zohar_id`, `Translation`.`text`, `Translation`.`language_id`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`created`, `Translation`.`modified` FROM `unityzohar_unityzohar2`.`translations` AS `Translation` WHERE `Translation`.`zohar_id` IN (76837, 76838) | 0 | 0 | 8 | maybe slow |
SELECT `ZoharCycle`.`id`, `ZoharCycle`.`cycle`, `ZoharCycle`.`unity_session_id`, `ZoharCycle`.`ip_address`, `ZoharCycle`.`zohar_id`, `ZoharCycle`.`parasha_id`, `ZoharCycle`.`paragraph`, `ZoharCycle`.`lng`, `ZoharCycle`.`lat`, `ZoharCycle`.`country`, `ZoharCycle`.`country_iso`, `ZoharCycle`.`state`, `ZoharCycle`.`city`, `ZoharCycle`.`token`, `ZoharCycle`.`created`, `ZoharCycle`.`modified` FROM `unityzohar_unityzohar2`.`zohar_cycles` AS `ZoharCycle` WHERE `ZoharCycle`.`zohar_id` IN (76837, 76838) | 0 | 0 | 817 | maybe slow |
SELECT `TikunimCycle`.`id`, `TikunimCycle`.`cycle`, `TikunimCycle`.`unity_session_id`, `TikunimCycle`.`ip_address`, `TikunimCycle`.`zohar_id`, `TikunimCycle`.`lng`, `TikunimCycle`.`lat`, `TikunimCycle`.`country`, `TikunimCycle`.`country_iso`, `TikunimCycle`.`state`, `TikunimCycle`.`city`, `TikunimCycle`.`token`, `TikunimCycle`.`created`, `TikunimCycle`.`modified` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE 1 = 1 ORDER BY `TikunimCycle`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Zohar`.`id`, `Zohar`.`parasha_id`, `Zohar`.`tikun`, `Zohar`.`tikun_name`, `Zohar`.`daf`, `Zohar`.`amud`, `Zohar`.`paragraph_num_h`, `Zohar`.`paragraph_num`, `Zohar`.`text_aramaic`, `Zohar`.`text_hebrew`, `Zohar`.`floating_text_aramaic`, `Zohar`.`floating_text_hebrew`, `Zohar`.`text_english`, `Zohar`.`notes`, `Zohar`.`created`, `Zohar`.`modified`, `Zohar`.`user_id`, `Parasha`.`id`, `Parasha`.`name`, `Parasha`.`name_hebrew`, `Parasha`.`termid`, `Parasha`.`slug`, `Parasha`.`dz_slug`, `Parasha`.`order`, `Parasha`.`active`, `Parasha`.`created`, `Parasha`.`modified`, `Parasha`.`audio_name`, `Parasha`.`ebook`, `Parasha`.`estudyurl1`, `Parasha`.`estudyurl2`, `Parasha`.`seq`, `Parasha`.`parcount` FROM `unityzohar_unityzohar2`.`zohars` AS `Zohar` LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`Zohar`.`parasha_id` = `Parasha`.`id`) WHERE `Zohar`.`id` > 76836 AND `Parasha`.`slug` = 'tikunei-zohar' LIMIT 2 | 2 | 2 | 0 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 76837
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 1 | 1 | 0 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 76838
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 1 | 1 | 0 | |
SELECT `Translation`.`id`, `Translation`.`zohar_id`, `Translation`.`text`, `Translation`.`language_id`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`created`, `Translation`.`modified` FROM `unityzohar_unityzohar2`.`translations` AS `Translation` WHERE `Translation`.`zohar_id` IN (76837, 76838) | 0 | 0 | 0 | |
SELECT `ZoharCycle`.`id`, `ZoharCycle`.`cycle`, `ZoharCycle`.`unity_session_id`, `ZoharCycle`.`ip_address`, `ZoharCycle`.`zohar_id`, `ZoharCycle`.`parasha_id`, `ZoharCycle`.`paragraph`, `ZoharCycle`.`lng`, `ZoharCycle`.`lat`, `ZoharCycle`.`country`, `ZoharCycle`.`country_iso`, `ZoharCycle`.`state`, `ZoharCycle`.`city`, `ZoharCycle`.`token`, `ZoharCycle`.`created`, `ZoharCycle`.`modified` FROM `unityzohar_unityzohar2`.`zohar_cycles` AS `ZoharCycle` WHERE `ZoharCycle`.`zohar_id` IN (76837, 76838) | 0 | 0 | 0 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE `TikunimCycle`.`id` = 111816 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE `TikunimCycle`.`id` = 111816 | 1 | 1 | 0 | |
UPDATE `unityzohar_unityzohar2`.`tikunim_cycles` SET `zohar_id` = 76838, `modified` = '2024-07-27 10:49:02' WHERE `unityzohar_unityzohar2`.`tikunim_cycles`.`id` = '111816' | 1 | 1 | 0 | |
COMMIT | | | | |
SELECT `TikunimCycle`.`id`, `TikunimCycle`.`cycle`, `TikunimCycle`.`unity_session_id`, `TikunimCycle`.`ip_address`, `TikunimCycle`.`zohar_id`, `TikunimCycle`.`lng`, `TikunimCycle`.`lat`, `TikunimCycle`.`country`, `TikunimCycle`.`country_iso`, `TikunimCycle`.`state`, `TikunimCycle`.`city`, `TikunimCycle`.`token`, `TikunimCycle`.`created`, `TikunimCycle`.`modified` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE 1 = 1 ORDER BY `TikunimCycle`.`id` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`zohars` AS `Zohar` LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`Zohar`.`parasha_id` = `Parasha`.`id`) WHERE `Parasha`.`slug` = 'tikunei-zohar' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`zohars` AS `Zohar` LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`Zohar`.`parasha_id` = `Parasha`.`id`) WHERE `Zohar`.`id` <= 76838 AND `Parasha`.`slug` = 'tikunei-zohar' | 1 | 1 | 4 | maybe slow |
SELECT `Candle`.`id`, `Candle`.`user_id`, `Candle`.`payment_id`, `Candle`.`donation`, `Candle`.`sponsor_type`, `Candle`.`name`, `Candle`.`gender`, `Candle`.`from`, `Candle`.`parent_name`, `Candle`.`created`, `Candle`.`modified` FROM `unityzohar_unityzohar2`.`candles` AS `Candle` WHERE `Candle`.`from` + INTERVAL `Candle`.`donation` DAY >= current_date ORDER BY RAND() ASC LIMIT 3 | 3 | 3 | 2 | maybe slow |
SELECT `Candle`.`id`, `Candle`.`user_id`, `Candle`.`payment_id`, `Candle`.`donation`, `Candle`.`sponsor_type`, `Candle`.`name`, `Candle`.`gender`, `Candle`.`from`, `Candle`.`parent_name`, `Candle`.`created`, `Candle`.`modified` FROM `unityzohar_unityzohar2`.`candles` AS `Candle` WHERE `Candle`.`from` + INTERVAL `Candle`.`donation` DAY >= current_date ORDER BY RAND() ASC LIMIT 90 | 14 | 14 | 1 | maybe slow |
SELECT `UnitySession`.`id`, `UnitySession`.`data`, `UnitySession`.`expires`, `UnitySession`.`created`, `UnitySession`.`modified` FROM `unityzohar_unityzohar2`.`unity_sessions` AS `UnitySession` WHERE `UnitySession`.`id` = 'hlj9krkf7if6r82i9cr6130br1' LIMIT 1 | 0 | 0 | 0 | |
SELECT DISTINCT `PinchasCycle`.`ip_address`, `PinchasCycle`.`country`, `PinchasCycle`.`city`, `PinchasCycle`.`lat`, `PinchasCycle`.`lng`, `PinchasCycle`.`country_iso` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE `ip_address` IS NOT NULL ORDER BY `PinchasCycle`.`modified` DESC LIMIT 20 | 20 | 20 | 288 | maybe slow |