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` = '7snmk4vcijmjiphlan83ect852' LIMIT 1 | 0 | 0 | 0 | |
SELECT `PinchasCycle`.`id`, `PinchasCycle`.`cycle`, `PinchasCycle`.`unity_session_id`, `PinchasCycle`.`ip_address`, `PinchasCycle`.`zohar_id`, `PinchasCycle`.`lng`, `PinchasCycle`.`lat`, `PinchasCycle`.`country`, `PinchasCycle`.`country_iso`, `PinchasCycle`.`state`, `PinchasCycle`.`city`, `PinchasCycle`.`token`, `PinchasCycle`.`created`, `PinchasCycle`.`modified` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE `PinchasCycle`.`unity_session_id` = '7snmk4vcijmjiphlan83ect852' LIMIT 1 | 0 | 0 | 85 | maybe slow |
SELECT `PinchasCycle`.`id`, `PinchasCycle`.`cycle`, `PinchasCycle`.`unity_session_id`, `PinchasCycle`.`ip_address`, `PinchasCycle`.`zohar_id`, `PinchasCycle`.`lng`, `PinchasCycle`.`lat`, `PinchasCycle`.`country`, `PinchasCycle`.`country_iso`, `PinchasCycle`.`state`, `PinchasCycle`.`city`, `PinchasCycle`.`token`, `PinchasCycle`.`created`, `PinchasCycle`.`modified` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE 1 = 1 ORDER BY `id` DESC LIMIT 1 | 1 | 1 | 0 | |
BEGIN | | | | |
INSERT INTO `unityzohar_unityzohar2`.`pinchas_cycles` (`unity_session_id`, `zohar_id`, `cycle`, `token`, `modified`, `created`) VALUES ('7snmk4vcijmjiphlan83ect852', 31775, 750, NULL, '2024-04-19 05:02:08', '2024-04-19 05:02:08') | 1 | 1 | 1 | |
COMMIT | | | | |
SELECT `PinchasCycle`.`id`, `PinchasCycle`.`cycle`, `PinchasCycle`.`unity_session_id`, `PinchasCycle`.`ip_address`, `PinchasCycle`.`zohar_id`, `PinchasCycle`.`lng`, `PinchasCycle`.`lat`, `PinchasCycle`.`country`, `PinchasCycle`.`country_iso`, `PinchasCycle`.`state`, `PinchasCycle`.`city`, `PinchasCycle`.`token`, `PinchasCycle`.`created`, `PinchasCycle`.`modified` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE `PinchasCycle`.`id` = 161572 LIMIT 1 | 1 | 1 | 0 | |
SELECT `PinchasCycle`.`id`, `PinchasCycle`.`cycle`, `PinchasCycle`.`unity_session_id`, `PinchasCycle`.`ip_address`, `PinchasCycle`.`zohar_id`, `PinchasCycle`.`lng`, `PinchasCycle`.`lat`, `PinchasCycle`.`country`, `PinchasCycle`.`country_iso`, `PinchasCycle`.`state`, `PinchasCycle`.`city`, `PinchasCycle`.`token`, `PinchasCycle`.`created`, `PinchasCycle`.`modified` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE 1 = 1 ORDER BY `PinchasCycle`.`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` > 31775 AND `Parasha`.`slug` = 'pinchas' LIMIT 2 | 2 | 2 | 2 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 31776
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 1 | 1 | 1 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 31777
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 1 | 1 | 25 | 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 (31776, 31777) | 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 (31776, 31777) | 0 | 0 | 757 | maybe slow |
SELECT `PinchasCycle`.`id`, `PinchasCycle`.`cycle`, `PinchasCycle`.`unity_session_id`, `PinchasCycle`.`ip_address`, `PinchasCycle`.`zohar_id`, `PinchasCycle`.`lng`, `PinchasCycle`.`lat`, `PinchasCycle`.`country`, `PinchasCycle`.`country_iso`, `PinchasCycle`.`state`, `PinchasCycle`.`city`, `PinchasCycle`.`token`, `PinchasCycle`.`created`, `PinchasCycle`.`modified` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE 1 = 1 ORDER BY `PinchasCycle`.`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` > 31775 AND `Parasha`.`slug` = 'pinchas' LIMIT 2 | 2 | 2 | 0 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 31776
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 = 31777
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 (31776, 31777) | 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 (31776, 31777) | 0 | 0 | 0 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE `PinchasCycle`.`id` = 161572 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE `PinchasCycle`.`id` = 161572 | 1 | 1 | 0 | |
UPDATE `unityzohar_unityzohar2`.`pinchas_cycles` SET `zohar_id` = 31777, `modified` = '2024-04-19 05:02:09' WHERE `unityzohar_unityzohar2`.`pinchas_cycles`.`id` = '161572' | 1 | 1 | 0 | |
COMMIT | | | | |
SELECT `PinchasCycle`.`id`, `PinchasCycle`.`cycle`, `PinchasCycle`.`unity_session_id`, `PinchasCycle`.`ip_address`, `PinchasCycle`.`zohar_id`, `PinchasCycle`.`lng`, `PinchasCycle`.`lat`, `PinchasCycle`.`country`, `PinchasCycle`.`country_iso`, `PinchasCycle`.`state`, `PinchasCycle`.`city`, `PinchasCycle`.`token`, `PinchasCycle`.`created`, `PinchasCycle`.`modified` FROM `unityzohar_unityzohar2`.`pinchas_cycles` AS `PinchasCycle` WHERE 1 = 1 ORDER BY `PinchasCycle`.`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` = 'pinchas' | 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` <= 31777 AND `Parasha`.`slug` = 'pinchas' | 1 | 1 | 1 | |
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 AND `Candle`.`sponsor_type` = 'refua' 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 | 17 | 17 | 1 | maybe slow |
SELECT `UnitySession`.`id`, `UnitySession`.`data`, `UnitySession`.`expires`, `UnitySession`.`created`, `UnitySession`.`modified` FROM `unityzohar_unityzohar2`.`unity_sessions` AS `UnitySession` WHERE `UnitySession`.`id` = '7snmk4vcijmjiphlan83ect852' 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 | 272 | maybe slow |