Tzadikim

Hillulot | Biographies | Prayers | Virtual Candle

DAILY ZOHAR LINKS:
Holidays |
Studies |
Books |
Tools |
Audio |
Videos

"Spreading The Light and Protection of The Zohar to All People"

Email comments and suggestions to: zion@rabbiShimon.com

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerevents
- actionbio
- named(empty)
- pass(array)
  0492
  1Rabbi-Yaakov-Chaim-Sofer
- id492
- slugRabbi-Yaakov-Chaim-Sofer
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0slug
  1id
- options(array)
  pass(array)
  0id
  1slug
  id[0-9]+
- defaults(array)
  controllerevents
  actionbio
  plugin(null)
- template/:id-:slug
====

Sql Log

Sql Logs

default

Total Time: 297 ms
Total Queries: 85 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info`, `Event`.`info`, `Event`.`link_page`, `photo` AS `image_url`, `latitud` AS `lat`, `longitud` AS `lng`, `Event`.`unknown_hilulah` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`id` = 492 AND `Event`.`active` = '1' LIMIT 1	1	1	1
SELECT `Candle`.`id`, `Candle`.`user_id`, `Candle`.`event_id`, `Candle`.`payment_id`, `Candle`.`donation`, `Candle`.`sponsor_type`, `Candle`.`name`, `Candle`.`gender`, `Candle`.`from`, `Candle`.`all`, `Candle`.`parent_name`, `Candle`.`active`, `Candle`.`invoice`, `Candle`.`email`, `Candle`.`user_name`, `Candle`.`created`, `Candle`.`modified` FROM `dailyzohar_tzad`.`candles` AS `Candle` WHERE ( ( (DATE_ADD(`Candle`.`from`, INTERVAL `Candle`.`donation` DAY) >= CURDATE()) AND `Candle`.`all` = '1') ) OR DATE_ADD(`Candle`.`from`, INTERVAL `Candle`.`donation` DAY) > CURDATE() AND `Candle`.`event_id` = (492)	26	26	14	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`photo`, `EventImage`.`photo_dir`, `EventImage`.`active`, `EventImage`.`created` FROM `dailyzohar_tzad`.`event_images` AS `EventImage` WHERE `EventImage`.`active` = 1 AND `EventImage`.`event_id` = (492)	0	0	6	maybe slow
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (492)	2	2	200	maybe slow
SELECT `Gallery`.`id`, `Gallery`.`email`, `Gallery`.`name`, `Gallery`.`gtype`, `Gallery`.`description`, `Gallery`.`location`, `Gallery`.`lat`, `Gallery`.`lng`, `Gallery`.`at_location`, `Gallery`.`picture`, `Gallery`.`picture_dir`, `Gallery`.`tzadik_id`, `Gallery`.`user_id`, `Gallery`.`active`, `Gallery`.`created` FROM `dailyzohar_tzad`.`galleries` AS `Gallery` WHERE `Gallery`.`tzadik_id` <> 0 AND `Gallery`.`tzadik_id` = (492)	0	0	1	maybe slow
SELECT `Prayer`.`id`, `Prayer`.`name`, `Prayer`.`prayer`, `Prayer`.`created`, `Prayer`.`modified`, `EventsPrayer`.`id`, `EventsPrayer`.`event_id`, `EventsPrayer`.`prayer_id` FROM `dailyzohar_tzad`.`prayers` AS `Prayer` JOIN `dailyzohar_tzad`.`events_prayers` AS `EventsPrayer` ON (`EventsPrayer`.`event_id` = 492 AND `EventsPrayer`.`prayer_id` = `Prayer`.`id`)	0	0	0
SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `dailyzohar_tzad`.`tags` AS `Tag` JOIN `dailyzohar_tzad`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` = 492 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Event'	0	0	2	maybe slow
SELECT `Candle`.`id`, `Candle`.`user_id`, `Candle`.`event_id`, `Candle`.`payment_id`, `Candle`.`donation`, `Candle`.`sponsor_type`, `Candle`.`name`, `Candle`.`gender`, `Candle`.`from`, `Candle`.`all`, `Candle`.`parent_name`, `Candle`.`active`, `Candle`.`invoice`, `Candle`.`email`, `Candle`.`user_name`, `Candle`.`created`, `Candle`.`modified` FROM `dailyzohar_tzad`.`candles` AS `Candle` WHERE ( ( (DATE_ADD(`Candle`.`from`, INTERVAL `Candle`.`donation` DAY) > CURDATE()) AND `Candle`.`all` = '1') ) OR DATE_ADD(`Candle`.`from`, INTERVAL `Candle`.`donation` DAY) > CURDATE() AND `Candle`.`event_id` = 492 ORDER BY RAND() ASC	23	23	4	maybe slow
UPDATE `dailyzohar_tzad`.`events` AS `Event` SET `Event`.`hits` = Event.hits+1, `Event`.`last_visit` = '2026-08-27 12:07:53' WHERE `Event`.`id` = 492	1	1	2	maybe slow
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 18 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	3	3	53	maybe slow
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (14, 213, 825)	5	5	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 19 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	3	3	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (16, 1175, 1244)	8	8	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 20 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (739, 927)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 21 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (385)	1	1	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 22 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (386)	1	1	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 23 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 24 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (388)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 25 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	3	3	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (817, 831, 366)	5	5	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 26 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	1	maybe slow
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (18, 19)	4	4	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 27 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (1235)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 28 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (20, 1174)	4	4	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 2 AND `Event`.`hilulah_day` = 29 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (1112, 1028)	5	5	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 1 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (1072)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 2 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 3 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	3	3	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (389, 1284, 215)	9	9	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 4 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 5 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 6 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	4	4	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (21, 24, 1298, 1230)	9	9	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 7 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	3	3	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (1299, 22, 1167)	7	7	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 8 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (1212)	1	1	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 9 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	4	4	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (492, 991, 216, 1001)	9	9	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 10 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (669)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 11 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (1034, 1222)	4	4	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 12 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (395)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 13 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (672)	3	3	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 14 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (25, 530)	6	6	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 15 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	3	3	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (270, 195, 1055)	6	6	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 16 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (1130)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 17 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (26)	4	4	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 18 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	4	4	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (521, 782, 27, 666)	10	10	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 19 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (28)	4	4	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 20 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 21 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 22 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 23 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (1013)	2	2	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 24 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	0	0	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 25 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	5	5	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (30, 31, 32, 605, 845)	19	19	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 26 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (33, 1184)	7	7	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 27 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	3	3	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (34, 400, 1224)	7	7	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 28 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	2	2	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` IN (426, 626)	4	4	0
SELECT `Event`.`id`, `Event`.`hilulah_month`, `Event`.`hilulah_day`, `Event`.`name`, `Event`.`alias`, `Event`.`type`, `Event`.`place_born`, `Event`.`year_born`, `Event`.`place_passed`, `Event`.`year_passed`, `Event`.`year_passed_h`, `Event`.`short_info` FROM `dailyzohar_tzad`.`events` AS `Event` WHERE `Event`.`hilulah_month` = 3 AND `Event`.`hilulah_day` = 29 AND `Event`.`active` = '1' ORDER BY `Event`.`year_passed_h` ASC	1	1	0
SELECT `Translation`.`id`, `Translation`.`master_id`, `Translation`.`title`, `Translation`.`text`, `Translation`.`short_text`, `Translation`.`name`, `Translation`.`alias`, `Translation`.`language_id`, `Translation`.`language_abbr`, `Translation`.`notes`, `Translation`.`user_id`, `Translation`.`model`, `Translation`.`created`, `Translation`.`modified` FROM `dailyzohar_tzad`.`translations` AS `Translation` WHERE `Translation`.`master_id` = (402)	2	2	0
SELECT `Candle`.`id`, `Candle`.`user_id`, `Candle`.`event_id`, `Candle`.`payment_id`, `Candle`.`donation`, `Candle`.`sponsor_type`, `Candle`.`name`, `Candle`.`gender`, `Candle`.`from`, `Candle`.`all`, `Candle`.`parent_name`, `Candle`.`active`, `Candle`.`invoice`, `Candle`.`email`, `Candle`.`user_name`, `Candle`.`created`, `Candle`.`modified` FROM `dailyzohar_tzad`.`candles` AS `Candle` WHERE `Candle`.`from` + INTERVAL `Candle`.`donation` DAY >= current_date AND `Candle`.`active` = '1' AND ((`Candle`.`event_id` = 492) OR (`Candle`.`all` = '1')) ORDER BY RAND() ASC	26	26	13	maybe slow
SELECT `Language`.`id`, `Language`.`language`, `Language`.`apply_app`, `Language`.`abbreviation`, `Language`.`created`, `Language`.`modified` FROM `dailyzohar_tzad`.`languages` AS `Language` WHERE 1 = 1	7	7	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 9.86 MB

Message	Memory use
Component initialization	4.93 MB
Controller action start	5.32 MB
Controller render start	6.64 MB
View render complete	7.51 MB

Timers

Total Request Time: 384 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	23.15
Event: Controller.initialize	0.42
Event: Controller.startup	0.45
Controller action	336.74
Event: Controller.beforeRender	2.61
» Processing toolbar data	2.52
Rendering View	2.93
» Event: View.beforeRender	0.01
» Rendering APP/View/Events/bio.ctp	1.64
» » Rendering APP/View/Elements/web-header.ctp	0.07
» » Rendering APP/View/Elements/web-pre-footer.ctp	0.04
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	0.94
» » Rendering APP/View/Elements/web_navbar.ctp	0.04
» » Rendering APP/View/Elements/web-footer.ctp	0.04
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- event(array)
 Event(array)
 id492
 hilulah_monthSivan
 hilulah_day9
 nameRabbi Yaakov Chaim Sofer
 aliasKaf Hachaim
 typetzadik
 place_born1870, Baghdad
 year_born(empty)
 place_passedJerusalem, Israel
 year_passed1939
 year_passed_h(null)
 short_infoRabbi Yaakov Chaim Sofer (Hebrew: יעקב חיים סופר) was a Sephardi Rabbi, Kabbalist, Talmudist and posek. He is the author of Kaf Hachaim, a work of halakha that he came to be known by.
 infoRabbi Sofer was born in Baghdad, Iraq. He studied the Torah under Abdallah Somekh and the Ben Ish Hai. In 1904, he journeyed to Ottoman Palestine together with colleagues Sadqa Hussein and the Asei HaYa'ar in order to meet with the Rishon LeZion, known as the Yisa Berakha, and to pray at the graves of the righteous. After visiting Jerusalem, he decided to settle there permanently. He studied in the Bet El yeshiva in the Old City of Jerusalem, well known for the study of kabbalah. In 1909 he moved to the newly founded Shoshanim leDavid yeshiva. It was here that he composed his works. Sofer authored several works of halakha and aggadah. His books are known for discussing the original traditions of Iraqi Jews. <h2>Works</h2> In Kaf Hachaim (כף החיים), Sofer discusses the halakha in light of the Rishonim and Acharonim. Kaf Hachaim, usually published in ten volumes, covers Orach Chayim (8 vol.) and parts of Yoreh De'ah (2 vol.). It is often compared to the Mishna Berura in terms of scope and approach, but differs in its more extensive reliance upon quotations. This work also surveys the views of many kabbalistic sages (particularly Isaac Luria), when these impact the Halakha. Shinun Halacha is a work summarising the Halakhic conclusions presented in Kaf Hachaim. In addition to the Kaf Hachaim, Sofer authored: <ul> <li>Kol Yaakov: on the laws of writing torah scrolls, tefillin, and mezuzot, as well as on the tefillin in general</li> <li>Yagel Yaakov: a compendium of Shabbat drashot (sermons) delivered while in mourning for his father</li> <li>Yismach Yisrael: novellae on the parsha, the weekly Torah reading.</li> <li>Chayim Ad Haolam on the aggadah of the Talmud</li> </ul> May the merit of the tzadik Rabbi Yaakov Chaim Sofer protect us all. Amen
 link_page(empty)
 image_urlhttps://www.dailyzohar.com/tzadikim/files/event/photo/thumb_612cc621aaf1e33230ec3a588e77c75a.jpg
 lat(empty)
 lng(empty)
 unknown_hilulah(false)
 tags(empty)
 date2026-5-25
 date225th May
 Candle(array)
 0(array)
 id7210
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameרבי שלום יהודה
 genderben
 from2026-08-20
 all1
 parent_nameאסתר
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-20 08:21:17
 modified2026-08-20 08:26:36
 1(array)
 id7065
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typerefua
 nameLori Fisher
 genderbat
 from2026-03-12
 all1
 parent_namePhyllis
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-03-12 21:18:06
 modified2026-03-12 21:20:10
 2(array)
 id7066
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typewish
 namePatricia
 genderbat
 from2026-03-13
 all1
 parent_name(john) Avraham
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-03-13 09:07:52
 modified2026-03-13 09:07:52
 3(array)
 id7190
 user_id16
 event_id0
 payment_id0
 donation160
 sponsor_typewish
 nameIhor Moshe
 genderben
 from2026-07-26
 all1
 parent_nameValentina
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-26 11:52:28
 modified2026-07-26 11:52:28
 4(array)
 id7165
 user_id16
 event_id0
 payment_id0
 donation108
 sponsor_typebless
 nameציון
 genderben
 from2026-07-15
 all1
 parent_nameחביבה
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-15 17:32:34
 modified2026-07-15 17:32:34
 5(array)
 id7202
 user_id16
 event_id0
 payment_id0
 donation42
 sponsor_typerefua
 nameMeirav
 genderbat
 from2026-08-05
 all1
 parent_nameElisheba
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-05 21:26:19
 modified2026-08-05 21:26:19
 6(array)
 id7205
 user_id6
 event_id0
 payment_id0
 donation120
 sponsor_typebless
 nameYvonne
 genderbat
 from2026-08-17
 all1
 parent_nameSultana
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-17 09:52:49
 modified2026-08-17 09:52:49
 7(array)
 id7154
 user_id6
 event_id0
 payment_id0
 donation91
 sponsor_typewish
 nameYitzak Benjamin
 genderben
 from2026-06-18
 all1
 parent_nameMordehai.
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-18 20:49:24
 modified2026-06-18 20:49:24
 8(array)
 id7186
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameAdelaide
 genderbat
 from2026-07-24
 all1
 parent_nameElena
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-24 12:29:43
 modified2026-07-24 12:29:43
 9(array)
 id6746
 user_id16
 event_id0
 payment_id6011
 donation365
 sponsor_typewish
 nameCarol Cari Chanah Dinah
 genderbat
 from2026-07-31
 all1
 parent_nameJoseph
 active(true)
 invoice(null)
 emailcari2672@gmail.com
 user_nameCarol Sredni
 created2025-06-10 17:25:06
 modified2026-07-31 09:36:37
 10(array)
 id7138
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typerefua
 nameצבי
 genderben
 from2026-05-18
 all1
 parent_nameתמר
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-05-18 16:00:58
 modified2026-05-18 16:00:58
 11(array)
 id7148
 user_id16
 event_id0
 payment_id0
 donation365
 sponsor_typewish
 nameLeo
 genderben
 from2026-06-09
 all1
 parent_nameJosephine
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-09 10:23:44
 modified2026-06-09 10:23:44
 12(array)
 id7185
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameAshlynn
 genderbat
 from2026-07-24
 all1
 parent_nameJoy
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-24 12:29:15
 modified2026-07-24 12:29:15
 13(array)
 id7131
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typebless
 nameShoshana
 genderbat
 from2026-05-15
 all1
 parent_nameEliahu Michael
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-05-15 15:47:17
 modified2026-05-15 15:47:17
 14(array)
 id7111
 user_id6
 event_id0
 payment_id0
 donation180
 sponsor_typebless
 nameWilliam
 genderben
 from2026-04-27
 all1
 parent_nameRicardo
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-04-27 06:11:25
 modified2026-04-28 21:37:30
 15(array)
 id7153
 user_id6
 event_id0
 payment_id0
 donation91
 sponsor_typewish
 nameChanah Dinah
 genderbat
 from2026-06-18
 all1
 parent_nameJoseph
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-18 20:48:53
 modified2026-06-18 20:48:53
 16(array)
 id7200
 user_id5
 event_id274
 payment_id6379
 donation32
 sponsor_typerefua
 nameGerson
 genderben
 from2026-08-03
 all1
 parent_nameLaudete
 active(true)
 invoice(null)
 emailelizabethfarinelli_2000@yahoo.it
 user_nameElizabeth
 created2026-08-03 11:37:13
 modified2026-08-03 11:37:13
 17(array)
 id7209
 user_id16
 event_id0
 payment_id0
 donation42
 sponsor_typerefua
 nameIsaac
 genderben
 from2026-08-19
 all1
 parent_nameKeith
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-19 14:51:14
 modified2026-08-19 14:51:14
 18(array)
 id7203
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameAyala
 genderbat
 from2026-08-05
 all1
 parent_nameSarah Chaya.
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-05 21:29:00
 modified2026-08-05 21:29:45
 19(array)
 id7151
 user_id16
 event_id0
 payment_id0
 donation365
 sponsor_typewish
 nameNatalia Nechama Feyga
 genderbat
 from2026-06-11
 all1
 parent_nameJanna
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-11 09:23:09
 modified2026-06-11 09:23:09
 20(array)
 id7127
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typerefua
 nameMichael
 genderben
 from2026-05-12
 all1
 parent_nameIhor
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-05-12 19:49:35
 modified2026-05-12 19:49:35
 21(array)
 id7166
 user_id16
 event_id0
 payment_id0
 donation108
 sponsor_typebless
 nameYvonne
 genderbat
 from2026-07-15
 all1
 parent_nameSultana
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-15 17:33:12
 modified2026-07-15 17:33:51
 22(array)
 id7064
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typewish
 nameHarrison Patrick
 genderben
 from2026-03-12
 all1
 parent_namePatricia
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-03-12 21:14:42
 modified2026-03-12 21:14:42
 EventImage(empty)
 Translation(array)
 0(array)
 id412
 master_id492
 title(null)
 textהרב יעקב חיים סופר נולד בבגדאד בירת עיראק, לרב יצחק ברוך ממשפחת "מוסה" ולאסתר. למד מאביו תורה וכתיבת סת"ם. התחנך בישיבת "מדרש בית זלכה" בראשות הרב עבדאללהה סומך, ולמד בין היתר אצל הרב אלישע דנגור. הושפע בלימוד תורה וקבלה מהרב <a href="https://he.wikipedia.org/wiki/%D7%99%D7%95%D7%A1%D7%A3_%D7%97%D7%99%D7%99%D7%9D">י</a>וסף חיים - בעל ה"בן איש חי", והוסמך על-ידו למו"צ. נשא לאשה את פרחה בדהובא. לפרנסתו עבד כסופר סת"ם, ומכאן שם משפחתו "סופר". בראש חודש סיוון ה'תרס"ד (1904) עלה לארץ ישראל עם חבריו הרבנים יחזקאל עזרא רחמים וצדקה חוצין. גר בשכונת בית ישראל בירושלים ולמד בישיבת המקובלים בית אל. בשנת ה'תרס"ט הקים עם רבנים יוצאי בגדד אתבית הכנסת "שושנים לדוד" שבו דרש בשבתות וימים טובים. למד וחיבר את ספריו בעליית בית הכנסת (כיום היא עזרת נשים). מאוחר יותר הצטרף ללומדי הקבלה בישיבת רחובות הנהר, שם היה תלמיד חבר לרב חיים שאול הכהן דוויק. נפטר בגיל 69, ביום שבת, ט' סיוון ה'תרצ"ט (1939). נקבר בחלקת החסידים שבהר הזיתים. נינו הוא הרב יעקב חיים סופר, שעומד בראש ישיבת 'כף החיים' שהוקמה על שמו. <h2 style="text-align:right">ספרו כף החיים</h2> ערך מורחב – <a href="https://he.wikipedia.org/wiki/%D7%9B%D7%A3_%D7%94%D7%97%D7%99%D7%99%D7%9D">כף החיים</a> במשך קרוב לארבעים שנה, החל מהיותו כבן שלושים עד פטירתו, עסק הרב סופר בכתיבת והדפסת חיבורו "כף החיים" על השלחן ערוך, בשמונה כרכים על חלק אורח חיים וכרך אחד על יורה דעה. לאחר פטירתו, בשנת ה'תשי"ז, הדפיסו בניו, שלום ומשה סופר, מהדורה חדשה של החיבור, והוסיפו כרך נוסף על יורה דעה, מתוך כתב ידו. החיבור הוגה ותוקן על ידי הרב עובדיה יוסף, שגם כתב את החלק החסר בכרך החדש (מסימן קיז אות יג עד סוף סימן קיט), בסגנון הספר. ויחד עם רבו הרב עזרא עטיה כתב את ההקדמה למהדורה. בשנת ה'תשע"ה יצאו כרכי החיבור במהדורה חדשה, כולל השלמות רבות מכתב ידו, שנמצא לאחר 78 שנים בגניזת גג בית הכנסת בבא תמא. הספר דומה במבנהו ל"משנה ברורה", באשר שניהם מבארים את דברי השלחן ערוך והפוסקים בנושאים הנידונים, על בסיס הספרות ההלכתית לאורך הדורות; אך בשונה מהמשנה ברורה, ה"כף החיים" אינו מתמקד בהבאת ההלכה הפסוקה, אלא מביא את מגוון הדעות שבעניין, ולבסוף מכריע. כמו כן בניגוד ל"משנה ברורה", ה"כף החיים" מביא בהרחבה גם את שיטות ופסקי המקובלים, בפרט האר"י והרש"ש. בכך הוא ממשיך את שיטת הפסיקה של רבו הרב יוסף חיים. <h2 style="text-align:right">ספריו</h2> ספרים נוספים שלו מצויים בכתב יד, בהם: באר מים חיים - שו"ת; בית יעקב - דרשות על פרשת השבוע; חפץ בחיים - דרשות; עדות ביעקב - דרשות לארבע פרשיות, שבת הגדול ועוד וביאור פרקי אבות; חזיונות חיים - קרוב ל-800 חלומות וגילויים; הערות והארות על ספר זבחי צדק; קונטרס קטן כוונות הפסח על הגדה של פסח.כף החיים - י' חלקים, על כל שולחן ערוך אורח חיים, ושולחן ערוך יורה דעה עד סוף סימן קי"ט <ul> <li style="text-align:right">קול יעקב - על הלכות סת"ם, ירושלים ה'תר"ע</li> <li style="text-align:right">חיים עד העולם - דרשות וביאורים לסיומי מסכתות הש"ס, ירושלים ה'תרפ"א</li> <li style="text-align:right">יגל יעקב - דרשות על סדר פרשת השבוע, ירושלים ה'תרס"ו</li> <li style="text-align:right">ישמח ישראל - ב' חלקים, דרשות על סדר פרשת השבוע, ירושלים ה'תשמ"ט</li> <li style="text-align:right">חוקי חיים - דרשות בציבור, ירושלים ה'תרע"א</li> <li style="text-align:right">קובץ תשובות (י' תשובות בהלכה) נדפסו לראשונה בספר שיח שושנים</li> </ul>
 short_textהרב יעקב חיים סופר ( ט' בסיון ה'תרצ"ט, 27 במאי 1939) היה מקובל, מחבר ופוסק הלכה, כתב את סדרת ספרי ההלכה כף החיים.
 nameרב יעקב חיים סופר
 aliasכף החיים
 language_id4
 language_abbrhe
 notes(empty)
 user_id4
 model(null)
 created2017-09-11 05:38:31
 modified2018-05-20 14:25:49
 1(array)
 id865
 master_id492
 title(null)
 textRabí Sofer nacio en Bagdad, Iraq. Estudio la Tora bajo Abdallah Somek y el Ben Ish. En 1904 viajo a Otoman Palestina junto con su colega Sadga Hussein y el Asei HaYa’ra para encontrarse con el Rishon Le Zion, conocido como el Yisa Berakha, para rezar en la tumba de los justos. Después de visitar a Jerusalén el decidido establecerse allí permanentemente. Estudio en Bet El yeshiva en la vieja ciudad de Jerusalén, muy conocido por el estudio de Cábala. En 1909 se mudó a la recién fundada , Shoshanim leDavid. Fue aquí donde el compuso sus trabajos. Sofer fue autor de varios trabajos de halakha y Aggadah. Sus libros son conocidos por discutir las tradiciones de los Judíos Iraquíes. <h3>Trabajos</h3> En Kaf Hachaim (כף החיים), Sofer discute el halakha a la luz de Rishonim y Acharonim. Kaf Hachaim, usulamente ha sido publicado en 10 volúmenes. cubre Orach Chayim (8 vol.) y partes De Yoreh De'ah (2 vol.). Es comparado frecuentemente con El Mishna Berura en términos del alcance y enfoque, pero difiere en su más amplia dependencia de las citas. Este trabajo también muestra el punto de vista de muchos sabios cabalistas (particularmente Isaac Luria) cuando estos impactan la Halakha. Shinun Halacha is es un trabajo que resume las conclusiones presentadas en Kaf Hachaim. Adicional a Kaf Hachaim, Sofer es autor de; <ul> <li>Kol Yaakov: sobre las leyes de escribir pergaminos de tora, tefillin y mezuzot, y también del tefilín en general</li> <li>Yagel Yaakov: un compendio de sermones de shabbat adrashot (sermones) Entregado mientras estaba en el luto de su padre.</li> <li>Yismach Yisrael: novela acerca de parashá, la porción semanal de la tora.</li> <li>Chayim Ad Haolam en la aggadah del Talmud</li> </ul> Que el mérito de tzadik Rabbi Yaakov Chaim Sofer nos proteja a todos. Amen 
 short_textRabino Yaakov Chaim Sofer.( Hebrew) fue un Rabino, Cabalista, Talmudista y Posek. El es el autor de Kaf Hachaim, un trabajo por el que fue conocido.
 nameRabino Yaakov Chaim Sofer
 aliasKaf Hachaim
 language_id2
 language_abbres
 notes(empty)
 user_id4
 modelEvent
 created2019-05-20 15:15:20
 modified2019-05-20 15:15:58
 Gallery(empty)
 Prayer(empty)
 Tag(empty)
- favs(empty)
- candles(array)
 0(array)
 Candle(array)
 id7194
 user_id16
 event_id0
 payment_id6373
 donation30
 sponsor_typerefua
 nameJacklyne
 genderbat
 from2026-07-28
 all1
 parent_nameMagda
 active(true)
 invoice(null)
 emailTziviaGallegos@gmail.com
 user_nameTzivia Gallegos García
 created2026-07-28 22:28:34
 modified2026-07-31 09:29:30
 hebrew0
 1(array)
 Candle(array)
 id7127
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typerefua
 nameMichael
 genderben
 from2026-05-12
 all1
 parent_nameIhor
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-05-12 19:49:35
 modified2026-05-12 19:49:35
 hebrew0
 2(array)
 Candle(array)
 id7185
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameAshlynn
 genderbat
 from2026-07-24
 all1
 parent_nameJoy
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-24 12:29:15
 modified2026-07-24 12:29:15
 hebrew0
 3(array)
 Candle(array)
 id7065
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typerefua
 nameLori Fisher
 genderbat
 from2026-03-12
 all1
 parent_namePhyllis
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-03-12 21:18:06
 modified2026-03-12 21:20:10
 hebrew0
 4(array)
 Candle(array)
 id7209
 user_id16
 event_id0
 payment_id0
 donation42
 sponsor_typerefua
 nameIsaac
 genderben
 from2026-08-19
 all1
 parent_nameKeith
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-19 14:51:14
 modified2026-08-19 14:51:14
 hebrew0
 5(array)
 Candle(array)
 id7148
 user_id16
 event_id0
 payment_id0
 donation365
 sponsor_typewish
 nameLeo
 genderben
 from2026-06-09
 all1
 parent_nameJosephine
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-09 10:23:44
 modified2026-06-09 10:23:44
 hebrew0
 6(array)
 Candle(array)
 id7165
 user_id16
 event_id0
 payment_id0
 donation108
 sponsor_typebless
 nameציון
 genderבן
 from2026-07-15
 all1
 parent_nameחביבה
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-15 17:32:34
 modified2026-07-15 17:32:34
 hebrew1
 7(array)
 Candle(array)
 id7186
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameAdelaide
 genderbat
 from2026-07-24
 all1
 parent_nameElena
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-24 12:29:43
 modified2026-07-24 12:29:43
 hebrew0
 8(array)
 Candle(array)
 id7153
 user_id6
 event_id0
 payment_id0
 donation91
 sponsor_typewish
 nameChanah Dinah
 genderbat
 from2026-06-18
 all1
 parent_nameJoseph
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-18 20:48:53
 modified2026-06-18 20:48:53
 hebrew0
 9(array)
 Candle(array)
 id7151
 user_id16
 event_id0
 payment_id0
 donation365
 sponsor_typewish
 nameNatalia Nechama Feyga
 genderbat
 from2026-06-11
 all1
 parent_nameJanna
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-11 09:23:09
 modified2026-06-11 09:23:09
 hebrew0
 10(array)
 Candle(array)
 id7111
 user_id6
 event_id0
 payment_id0
 donation180
 sponsor_typebless
 nameWilliam
 genderben
 from2026-04-27
 all1
 parent_nameRicardo
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-04-27 06:11:25
 modified2026-04-28 21:37:30
 hebrew0
 11(array)
 Candle(array)
 id7064
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typewish
 nameHarrison Patrick
 genderben
 from2026-03-12
 all1
 parent_namePatricia
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-03-12 21:14:42
 modified2026-03-12 21:14:42
 hebrew0
 12(array)
 Candle(array)
 id7191
 user_id16
 event_id0
 payment_id6370
 donation30
 sponsor_typerefua
 namejuan
 genderben
 from2026-07-28
 all1
 parent_nameMagda
 active(true)
 invoice(null)
 emailTziviaGallegos@gmail.com
 user_nameTzivia Gallegos García
 created2026-07-28 21:43:19
 modified2026-07-31 09:28:53
 hebrew0
 13(array)
 Candle(array)
 id7166
 user_id16
 event_id0
 payment_id0
 donation108
 sponsor_typebless
 nameYvonne
 genderbat
 from2026-07-15
 all1
 parent_nameSultana
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-15 17:33:12
 modified2026-07-15 17:33:51
 hebrew0
 14(array)
 Candle(array)
 id7210
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameרבי שלום יהודה
 genderבן
 from2026-08-20
 all1
 parent_nameאסתר
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-20 08:21:17
 modified2026-08-20 08:26:36
 hebrew1
 15(array)
 Candle(array)
 id7203
 user_id16
 event_id0
 payment_id0
 donation91
 sponsor_typerefua
 nameAyala
 genderbat
 from2026-08-05
 all1
 parent_nameSarah Chaya.
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-05 21:29:00
 modified2026-08-05 21:29:45
 hebrew0
 16(array)
 Candle(array)
 id7154
 user_id6
 event_id0
 payment_id0
 donation91
 sponsor_typewish
 nameYitzak Benjamin
 genderben
 from2026-06-18
 all1
 parent_nameMordehai.
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-06-18 20:49:24
 modified2026-06-18 20:49:24
 hebrew0
 17(array)
 Candle(array)
 id7066
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typewish
 namePatricia
 genderbat
 from2026-03-13
 all1
 parent_name(john) Avraham
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-03-13 09:07:52
 modified2026-03-13 09:07:52
 hebrew0
 18(array)
 Candle(array)
 id7190
 user_id16
 event_id0
 payment_id0
 donation160
 sponsor_typewish
 nameIhor Moshe
 genderben
 from2026-07-26
 all1
 parent_nameValentina
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-07-26 11:52:28
 modified2026-07-26 11:52:28
 hebrew0
 19(array)
 Candle(array)
 id7192
 user_id6
 event_id0
 payment_id6371
 donation30
 sponsor_typerefua
 nameMarcos
 genderben
 from2026-07-28
 all1
 parent_nameDionisio
 active(true)
 invoice(null)
 emailziviagarcia@gmail.com
 user_nameTzivia Gallegos García
 created2026-07-28 22:13:03
 modified2026-07-31 09:33:48
 hebrew0
 20(array)
 Candle(array)
 id7200
 user_id5
 event_id274
 payment_id6379
 donation32
 sponsor_typerefua
 nameGerson
 genderben
 from2026-08-03
 all1
 parent_nameLaudete
 active(true)
 invoice(null)
 emailelizabethfarinelli_2000@yahoo.it
 user_nameElizabeth
 created2026-08-03 11:37:13
 modified2026-08-03 11:37:13
 hebrew0
 21(array)
 Candle(array)
 id7202
 user_id16
 event_id0
 payment_id0
 donation42
 sponsor_typerefua
 nameMeirav
 genderbat
 from2026-08-05
 all1
 parent_nameElisheba
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-05 21:26:19
 modified2026-08-05 21:26:19
 hebrew0
 22(array)
 Candle(array)
 id7131
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typebless
 nameShoshana
 genderbat
 from2026-05-15
 all1
 parent_nameEliahu Michael
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-05-15 15:47:17
 modified2026-05-15 15:47:17
 hebrew0
 23(array)
 Candle(array)
 id7205
 user_id6
 event_id0
 payment_id0
 donation120
 sponsor_typebless
 nameYvonne
 genderbat
 from2026-08-17
 all1
 parent_nameSultana
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-08-17 09:52:49
 modified2026-08-17 09:52:49
 hebrew0
 24(array)
 Candle(array)
 id6746
 user_id16
 event_id0
 payment_id6011
 donation365
 sponsor_typewish
 nameCarol Cari Chanah Dinah
 genderbat
 from2026-07-31
 all1
 parent_nameJoseph
 active(true)
 invoice(null)
 emailcari2672@gmail.com
 user_nameCarol Sredni
 created2025-06-10 17:25:06
 modified2026-07-31 09:36:37
 hebrew0
 25(array)
 Candle(array)
 id7138
 user_id16
 event_id0
 payment_id0
 donation180
 sponsor_typerefua
 nameצבי
 genderבן
 from2026-05-18
 all1
 parent_nameתמר
 active(true)
 invoice(null)
 email(null)
 user_name(null)
 created2026-05-18 16:00:58
 modified2026-05-18 16:00:58
 hebrew1
- languages(array)
 0(array)
 Language(array)
 id1
 languageEnglish
 apply_app(true)
 abbreviationen
 created2016-02-22 10:11:48
 modified2016-02-22 10:12:18
 1(array)
 Language(array)
 id2
 languageSpanish
 apply_app(true)
 abbreviationes
 created2016-02-22 10:11:59
 modified2016-02-22 10:11:59
 2(array)
 Language(array)
 id4
 languageHebrew
 apply_app(true)
 abbreviationhe
 created2016-03-02 09:07:29
 modified2016-03-02 09:07:29
- siblings(array)
 prev(array)
 Event(array)
 id1212
 hilulah_monthSivan
 hilulah_day8th
 nameRabbi Moshe Nehemiah Kahanov
 alias(empty)
 typetzadik
 place_bornKastiukovic, Belarus 1817
 year_born(empty)
 place_passedJerusalem, Israel
 year_passed1887
 year_passed_h5647
 tags(empty)
 date2026-5-24
 date224th May
 next(array)
 Event(array)
 id991
 hilulah_monthSivan
 hilulah_day9th
 nameRabbi Yisroel (Israel) ben Shmuel of Shklov
 alias(empty)
 typetzadik
 place_bornShklov , 1770
 year_born(empty)
 place_passedTiberias, Israel
 year_passed1839
 year_passed_h5599
 tags(empty)
 date2026-5-25
 date225th May
- $request->data(empty)
- $this->validationErrors(array)
 Event(empty)
 Tag(empty)
 Comment(empty)
 Candle(empty)
 EventImage(empty)
 Translation(empty)
 Gallery(empty)
 Prayer(empty)
 EventsPrayer(empty)
 Tagged(empty)
 Language(empty)
- Loaded Helpers(array)
 0TagCloud
 1Number
 2SimpleGraph
 3Session
 4DebugTimer
 5Toolbar
 6Html
 7App
 8Js
 9JqueryEngine
 10HtmlToolbar
 11Form
====

Environment

App Constants

Constant	Value
CONFIG	/home/dailyzohar/public_html/tzadikim/app/Config/

CakePHP Constants

Constant	Value
APP	/home/dailyzohar/public_html/tzadikim/app/
APP_DIR	app
APPLIBS	/home/dailyzohar/public_html/tzadikim/app/Lib/
CACHE	/home/dailyzohar/public_html/tzadikim/app/tmp/cache/
CAKE	/home/dailyzohar/public_html/tzadikim/core/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/dailyzohar/public_html/tzadikim/core/lib
CORE_PATH	/home/dailyzohar/public_html/tzadikim/core/lib/
CAKE_VERSION	2.10.24
CSS	/home/dailyzohar/public_html/tzadikim/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.dailyzohar.com
IMAGES	/home/dailyzohar/public_html/tzadikim/app/webroot/img/
IMAGES_URL	img/
JS	/home/dailyzohar/public_html/tzadikim/app/webroot/js/
JS_URL	js/
LOGS	/home/dailyzohar/public_html/tzadikim/app/tmp/logs/
ROOT	/home/dailyzohar/public_html/tzadikim
TESTS	/home/dailyzohar/public_html/tzadikim/app/Test/
TMP	/home/dailyzohar/public_html/tzadikim/app/tmp/
VENDORS	/home/dailyzohar/public_html/tzadikim/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/dailyzohar/public_html/tzadikim/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	8.2.33
User	dailyzohar
Home	/home/dailyzohar
Script Name	/tzadikim/app/webroot/index.php
Request Uri	/tzadikim/492-Rabbi-Yaakov-Chaim-Sofer
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/tzadikim/app/webroot/492-Rabbi-Yaakov-Chaim-Sofer
Remote Port	62434
Script Filename	/home/dailyzohar/public_html/tzadikim/app/webroot/index.php
Server Admin	webmaster@dailyzohar.com
Context Document Root	/home/dailyzohar/public_html
Context Prefix
Request Scheme	https
Document Root	/home/dailyzohar/public_html
Remote Addr	216.73.216.52
Server Port	443
Server Addr	209.182.199.87
Server Name	www.dailyzohar.com
Server Software	Apache
Server Signature
Path	/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
Http X Https	1
Http Host	www.dailyzohar.com
Http Accept Encoding	gzip, br, zstd, deflate
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Proxy-nokeepalive	1
Ssl Tls Sni	www.dailyzohar.com
Https	on
Http Authorization
Script Uri	https://www.dailyzohar.com/tzadikim/492-Rabbi-Yaakov-Chaim-Sofer
Script Url	/tzadikim/492-Rabbi-Yaakov-Chaim-Sofer
Unique Id	apBg2VK98RNeDHSpQC2YRgAAAAI
Redirect Status	200
Redirect Ssl Tls Sni	www.dailyzohar.com
Redirect Https	on
Redirect Script Uri	https://www.dailyzohar.com/tzadikim/492-Rabbi-Yaakov-Chaim-Sofer
Redirect Script Url	/tzadikim/492-Rabbi-Yaakov-Chaim-Sofer
Redirect Unique Id	apBg2VK98RNeDHSpQC2YRgAAAAI
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	www.dailyzohar.com
Redirect Redirect Https	on
Redirect Redirect Script Uri	https://www.dailyzohar.com/tzadikim/492-Rabbi-Yaakov-Chaim-Sofer
Redirect Redirect Script Url	/tzadikim/492-Rabbi-Yaakov-Chaim-Sofer
Redirect Redirect Unique Id	apBg2VK98RNeDHSpQC2YRgAAAAI
Fcgi Role	RESPONDER
Php Self	/tzadikim/app/webroot/index.php
Request Time Float	1787846873.6464
Request Time	1787846873
Argc	0
Php Auth User
Php Auth Pw

====

Include
+
Included Files

Include Paths
- 0/home/dailyzohar/public_html/tzadikim/core/lib
- 2/opt/cpanel/ea-php82/root/usr/share/pear
- 3-> /home/dailyzohar/public_html/tzadikim/core/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/AuthComponent.php
  2CORE/Controller/Component/PaginatorComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Core/CakeObject.php
  6CORE/Event/CakeEventListener.php
  7CORE/Event/CakeEventManager.php
  8CORE/Event/CakeEvent.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/ClassRegistry.php
  4CORE/Utility/Folder.php
  5CORE/Utility/Debugger.php
  6CORE/Utility/CakeText.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/HeadersComponent.php
  1APP/Controller/Component/HebrewComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/EventsController.php
  1APP/Controller/AppController.php
  Error(array)
  0APP/Vendor/stripe-php/lib/Error/Base.php
  1APP/Vendor/stripe-php/lib/Error/Api.php
  2APP/Vendor/stripe-php/lib/Error/ApiConnection.php
  3APP/Vendor/stripe-php/lib/Error/Authentication.php
  4APP/Vendor/stripe-php/lib/Error/Card.php
  5APP/Vendor/stripe-php/lib/Error/InvalidRequest.php
  6APP/Vendor/stripe-php/lib/Error/Permission.php
  7APP/Vendor/stripe-php/lib/Error/RateLimit.php
  8APP/Vendor/stripe-php/lib/Error/SignatureVerification.php
  9APP/Vendor/stripe-php/lib/Error/OAuth/OAuthBase.php
  10APP/Vendor/stripe-php/lib/Error/OAuth/InvalidGrant.php
  11APP/Vendor/stripe-php/lib/Error/OAuth/InvalidRequest.php
  12APP/Vendor/stripe-php/lib/Error/OAuth/InvalidScope.php
  13APP/Vendor/stripe-php/lib/Error/OAuth/UnsupportedGrantType.php
  14APP/Vendor/stripe-php/lib/Error/OAuth/UnsupportedResponseType.php
  Model(array)
  0APP/Model/Event.php
  1APP/Model/AppModel.php
  2APP/Model/Comment.php
  3APP/Model/Candle.php
  4APP/Model/EventImage.php
  5APP/Model/Translation.php
  6APP/Model/Gallery.php
  7APP/Model/Prayer.php
  8APP/Model/Language.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/stripe-php/init.php
  2APP/Vendor/stripe-php/lib/Stripe.php
  3APP/Vendor/stripe-php/lib/Util/AutoPagingIterator.php
  4APP/Vendor/stripe-php/lib/Util/LoggerInterface.php
  5APP/Vendor/stripe-php/lib/Util/DefaultLogger.php
  6APP/Vendor/stripe-php/lib/Util/RequestOptions.php
  7APP/Vendor/stripe-php/lib/Util/Set.php
  8APP/Vendor/stripe-php/lib/Util/Util.php
  9APP/Vendor/stripe-php/lib/HttpClient/ClientInterface.php
  10APP/Vendor/stripe-php/lib/HttpClient/CurlClient.php
  11APP/Vendor/stripe-php/lib/ApiResponse.php
  12APP/Vendor/stripe-php/lib/JsonSerializable.php
  13APP/Vendor/stripe-php/lib/StripeObject.php
  14APP/Vendor/stripe-php/lib/ApiRequestor.php
  15APP/Vendor/stripe-php/lib/ApiResource.php
  16APP/Vendor/stripe-php/lib/SingletonApiResource.php
  17APP/Vendor/stripe-php/lib/AttachedObject.php
  18APP/Vendor/stripe-php/lib/ExternalAccount.php
  19APP/Vendor/stripe-php/lib/Account.php
  20APP/Vendor/stripe-php/lib/AlipayAccount.php
  21APP/Vendor/stripe-php/lib/ApplePayDomain.php
  22APP/Vendor/stripe-php/lib/ApplicationFee.php
  23APP/Vendor/stripe-php/lib/ApplicationFeeRefund.php
  24APP/Vendor/stripe-php/lib/Balance.php
  25APP/Vendor/stripe-php/lib/BalanceTransaction.php
  26APP/Vendor/stripe-php/lib/BankAccount.php
  27APP/Vendor/stripe-php/lib/BitcoinReceiver.php
  28APP/Vendor/stripe-php/lib/BitcoinTransaction.php
  29APP/Vendor/stripe-php/lib/Card.php
  30APP/Vendor/stripe-php/lib/Charge.php
  31APP/Vendor/stripe-php/lib/Collection.php
  32APP/Vendor/stripe-php/lib/CountrySpec.php
  33APP/Vendor/stripe-php/lib/Coupon.php
  34APP/Vendor/stripe-php/lib/Customer.php
  35APP/Vendor/stripe-php/lib/Dispute.php
  36APP/Vendor/stripe-php/lib/EphemeralKey.php
  37APP/Vendor/stripe-php/lib/Event.php
  38APP/Vendor/stripe-php/lib/FileUpload.php
  39APP/Vendor/stripe-php/lib/Invoice.php
  40APP/Vendor/stripe-php/lib/InvoiceItem.php
  41APP/Vendor/stripe-php/lib/LoginLink.php
  42APP/Vendor/stripe-php/lib/Order.php
  43APP/Vendor/stripe-php/lib/OrderReturn.php
  44APP/Vendor/stripe-php/lib/Payout.php
  45APP/Vendor/stripe-php/lib/Plan.php
  46APP/Vendor/stripe-php/lib/Product.php
  47APP/Vendor/stripe-php/lib/Recipient.php
  48APP/Vendor/stripe-php/lib/RecipientTransfer.php
  49APP/Vendor/stripe-php/lib/Refund.php
  50APP/Vendor/stripe-php/lib/SKU.php
  51APP/Vendor/stripe-php/lib/Source.php
  52APP/Vendor/stripe-php/lib/Subscription.php
  53APP/Vendor/stripe-php/lib/SubscriptionItem.php
  54APP/Vendor/stripe-php/lib/ThreeDSecure.php
  55APP/Vendor/stripe-php/lib/Token.php
  56APP/Vendor/stripe-php/lib/Transfer.php
  57APP/Vendor/stripe-php/lib/TransferReversal.php
  58APP/Vendor/stripe-php/lib/OAuth.php
  59APP/Vendor/stripe-php/lib/Webhook.php
  60APP/Vendor/stripe-php/lib/WebhookSignature.php
  61APP/Event/EventListener.php
- plugins(array)
  CsvView(array)
  Component(array)
  0CsvView/Controller/Component/CsvViewComponent.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Model(array)
  0Tags/Model/Tag.php
  1Tags/Model/TagsAppModel.php
  2Tags/Model/Tagged.php
  Upload(array)
  Behavior(array)
  0Upload/Model/Behavior/UploadBehavior.php
====

Tzadikim

Rabbi Yaakov Chaim Sofer

Rabbi Yaakov Chaim Sofer (Hebrew: יעקב חיים סופר) was a Sephardi Rabbi, Kabbalist, Talmudist and posek. He is the author of Kaf Hachaim, a work of halakha that he came to be known by.

Works

Soul Elevations

Healing

Success in life

Tzadikim App

"Spreading The Light and Protection of The Zohar to All People"

default

Total Time: 297 ms
Total Queries: 85 queries

Query Explain:

Memory

Timers

Tzadikim

Rabbi Yaakov Chaim Sofer

Rabbi Yaakov Chaim Sofer (Hebrew: יעקב חיים סופר) was a Sephardi Rabbi, Kabbalist, Talmudist and posek. He is the author of Kaf Hachaim, a work of halakha that he came to be known by.

Works

Soul Elevations

Healing

Success in life

Tzadikim App

"Spreading The Light and Protection of The Zohar to All People"

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 297 ms Total Queries: 85 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 297 ms
Total Queries: 85 queries