| 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` = 'qpcqkthro2iqri7le28sk5g8v5' 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` = 'qpcqkthro2iqri7le28sk5g8v5' LIMIT 1 | 0 | 0 | 60 | 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 ('qpcqkthro2iqri7le28sk5g8v5', 78666, 221, NULL, '2024-07-27 05:55:13', '2024-07-27 05:55:13') | 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` = 111813 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` > 78666 AND `Parasha`.`slug` = 'tikunei-zohar' LIMIT 2 | 1 | 1 | 0 | |
| SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 78667
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 0 | 0 | 31 | 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` = (78667) | 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` = (78667) | 0 | 0 | 823 | 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` > 78666 AND `Parasha`.`slug` = 'tikunei-zohar' LIMIT 2 | 1 | 1 | 0 | |
| SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 78667
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 0 | 0 | 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` = (78667) | 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` = (78667) | 0 | 0 | 0 | |
| BEGIN | | | | |
| SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE `TikunimCycle`.`id` = 111813 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`tikunim_cycles` AS `TikunimCycle` WHERE `TikunimCycle`.`id` = 111813 | 1 | 1 | 0 | |
| UPDATE `unityzohar_unityzohar2`.`tikunim_cycles` SET `zohar_id` = 78667, `modified` = '2024-07-27 05:55:14' WHERE `unityzohar_unityzohar2`.`tikunim_cycles`.`id` = '111813' | 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 | 1 | |
| 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` <= 78667 AND `Parasha`.`slug` = 'tikunei-zohar' | 1 | 1 | 3 | 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 | 1 | 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` = 'qpcqkthro2iqri7le28sk5g8v5' 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 | 285 | maybe slow |
Unity Zohar
San José-Costa Rica
Mugla-Türkiye
Costa Mesa-United States
Ramat HaSharon-Israel
Temixco-Mexico
Wedel-Germany
Cascais-Portugal
Lima-Peru
Cúcuta-Colombia
