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` = '9ku132v9goip94k11ek2mp83v6' LIMIT 1 | 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`.`unity_session_id` = '9ku132v9goip94k11ek2mp83v6' LIMIT 1 | 0 | 0 | 782 | 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 1 = 1 ORDER BY `id` DESC LIMIT 1 | 1 | 1 | 0 | |
BEGIN | | | | |
INSERT INTO `unityzohar_unityzohar2`.`zohar_cycles` (`paragraph`, `unity_session_id`, `zohar_id`, `cycle`, `parasha_id`, `token`, `modified`, `created`) VALUES (239, '9ku132v9goip94k11ek2mp83v6', 0, 136, 17, NULL, '2024-07-27 10:57:53', '2024-07-27 10:57:53') | 1 | 1 | 0 | |
COMMIT | | | | |
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`.`id` = 1434752 LIMIT 1 | 1 | 1 | 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`, `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`.`zohar_cycles` AS `ZoharCycle` LEFT JOIN `unityzohar_unityzohar2`.`zohars` AS `Zohar` ON (`ZoharCycle`.`zohar_id` = `Zohar`.`id`) LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`ZoharCycle`.`parasha_id` = `Parasha`.`id`) WHERE 1 = 1 ORDER BY `ZoharCycle`.`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`.`paragraph_num` > 239 AND `Zohar`.`parasha_id` = 17 ORDER BY `Parasha`.`order` ASC, `Zohar`.`paragraph_num` ASC LIMIT 2 | 2 | 2 | 2 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 9496
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 0 | 0 | 28 | maybe slow |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 9497
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 0 | 0 | 28 | 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 (9496, 9497) | 2 | 2 | 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`, `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`.`zohar_cycles` AS `ZoharCycle` LEFT JOIN `unityzohar_unityzohar2`.`zohars` AS `Zohar` ON (`ZoharCycle`.`zohar_id` = `Zohar`.`id`) LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`ZoharCycle`.`parasha_id` = `Parasha`.`id`) WHERE 1 = 1 ORDER BY `ZoharCycle`.`id` DESC LIMIT 1 | 1 | 1 | 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`, `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`.`zohar_cycles` AS `ZoharCycle` LEFT JOIN `unityzohar_unityzohar2`.`zohars` AS `Zohar` ON (`ZoharCycle`.`zohar_id` = `Zohar`.`id`) LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`ZoharCycle`.`parasha_id` = `Parasha`.`id`) WHERE 1 = 1 ORDER BY `ZoharCycle`.`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`.`paragraph_num` > 239 AND `Zohar`.`parasha_id` = 17 ORDER BY `Parasha`.`order` ASC, `Zohar`.`paragraph_num` ASC LIMIT 2 | 2 | 2 | 0 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 9496
WHERE ZoharCommentary.zoharp = Zohar.parasha_id and ZoharCommentary.zoharparag = Zohar.paragraph_num and ZoharCommentary.active = 1 limit 1 | 0 | 0 | 0 | |
SELECT ZoharCommentary.*, Zohar.parasha_id
FROM ZoharCommentary as ZoharCommentary JOIN zohars as Zohar on Zohar.id = 9497
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` IN (9496, 9497) | 2 | 2 | 0 | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`zohar_cycles` AS `ZoharCycle` WHERE `ZoharCycle`.`id` = 1434752 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`zohar_cycles` AS `ZoharCycle` WHERE `ZoharCycle`.`id` = 1434752 | 1 | 1 | 0 | |
UPDATE `unityzohar_unityzohar2`.`zohar_cycles` SET `paragraph` = 241, `modified` = '2024-07-27 10:57:53' WHERE `unityzohar_unityzohar2`.`zohar_cycles`.`id` = '1434752' | 1 | 1 | 0 | |
COMMIT | | | | |
BEGIN | | | | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`zohar_cycles` AS `ZoharCycle` WHERE `ZoharCycle`.`id` = 1434752 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `unityzohar_unityzohar2`.`zohar_cycles` AS `ZoharCycle` WHERE `ZoharCycle`.`id` = 1434752 | 1 | 1 | 0 | |
UPDATE `unityzohar_unityzohar2`.`zohar_cycles` SET `parasha_id` = 17, `modified` = '2024-07-27 10:57:53' WHERE `unityzohar_unityzohar2`.`zohar_cycles`.`id` = '1434752' | 0 | 0 | 0 | |
COMMIT | | | | |
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`.`active` = 1 | 1 | 1 | 0 | |
SELECT `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`.`parashot` AS `Parasha` WHERE `Parasha`.`id` = 17 LIMIT 1 | 1 | 1 | 0 | |
SELECT count(Zohar.id) AS count FROM unityzohar_unityzohar2.zohars AS Zohar
LEFT JOIN
unityzohar_unityzohar2.parashot AS Parasha ON (Zohar.parasha_id = Parasha.id)
WHERE Parasha.id in (select p.id from parashot p where p.order < 18)
UNION
SELECT count(Zohar.id) AS count FROM unityzohar_unityzohar2.zohars AS Zohar
WHERE Zohar.parasha_id = 17 and Zohar.paragraph_num < '239' | 2 | 2 | 6 | maybe slow |
SELECT `Language`.`id`, `Language`.`language` FROM `unityzohar_unityzohar2`.`languages` AS `Language` WHERE 1 = 1 | 10 | 10 | 0 | |
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` = '9ku132v9goip94k11ek2mp83v6' LIMIT 1 | 0 | 0 | 0 | |
SELECT DISTINCT `ZoharCycle`.`ip_address`, `ZoharCycle`.`country`, `ZoharCycle`.`city`, `ZoharCycle`.`lat`, `ZoharCycle`.`lng`, `ZoharCycle`.`country_iso` FROM `unityzohar_unityzohar2`.`zohar_cycles` AS `ZoharCycle` LEFT JOIN `unityzohar_unityzohar2`.`zohars` AS `Zohar` ON (`ZoharCycle`.`zohar_id` = `Zohar`.`id`) LEFT JOIN `unityzohar_unityzohar2`.`parashot` AS `Parasha` ON (`ZoharCycle`.`parasha_id` = `Parasha`.`id`) WHERE `ip_address` IS NOT NULL AND `lat` <> '0' AND `lng` <> '0' ORDER BY `ZoharCycle`.`modified` DESC LIMIT 100 | 100 | 100 | 5299 | maybe slow |