Notice (8): Undefined variable: specialties [APP/View/fisiosite/Establishments/show.ctp, line 13]

*/

    $meta_description = __('%s en Fisiosite. %s. %s', $establishment['Establishment']['name'], $establishment['Category']['name'], $specialties);

$viewFile = '/home/bkvtdvl/fisiosite/View/fisiosite/Establishments/show.ctp'
$dataForView = array(
	'validations_errors' => null,
	'establishment' => array(
		'Establishment' => array(
			'id' => '12588',
			'name' => 'Clinica de Prueba para extracción de datos',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => 'Descripción del establecimiento',
			'fiscalnumber' => 'B33861329',
			'address1' => 'Peña Ubiña, 4',
			'address2' => '',
			'email' => 'info@aplicasoluciones.com',
			'fax' => null,
			'mobile' => '',
			'mobile2' => null,
			'phone' => '985518899',
			'phone2' => '617890603',
			'zipcode' => '33405',
			'town' => 'Castrillón',
			'state' => 'Asturias',
			'country' => '',
			'latitude' => null,
			'longitude' => null,
			'slug' => null,
			'canonical' => 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '84875c248a54bbe8f588db54d106f892',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => '13262775',
			'population_id' => '1517',
			'bank' => '',
			'bank_cert' => 'ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
			'bank_cert_dir' => '12588/39/58/92',
			'bank_cert_status' => null,
			'file_dni' => 'pdf_with_something__8_.pdf',
			'file_dni_dir' => '12588/08/40/18',
			'writers' => 'ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
			'writers_dir' => '12588/35/76/19',
			'split_id' => null,
			'created' => '2021-05-12 16:22:49',
			'modified' => '2021-05-17 11:36:11',
			'sms' => null,
			'fulladdress' => 'Peña Ubiña, 4, Castrillón ( 33405 ) , Asturias',
			'link' => 'https://www.fisiosite.com/fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12588/39/58/92/ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12588/08/40/18/pdf_with_something__8_.pdf',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers/12588/35/76/19/ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
			'rating' => false,
			'is_open' => true
		),
		'Category' => array(
			'id' => '1',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia',
			'description' => '',
			'parent_id' => '31',
			'created' => '2016-06-13 12:15:16',
			'modified' => '2016-06-13 12:15:16',
			'lft' => '2',
			'rght' => '3',
			'ParentCategory' => array(
				[maximum depth reached]
			)
		),
		'Population' => array(
			'id' => '1517',
			'town' => 'Castrillón',
			'state' => 'Asturias',
			'canonical' => 'asturias/castrillon',
			'canonical_town' => 'castrillon',
			'is_footer' => '1',
			'capital_population_id' => null,
			'latitude_town' => null,
			'longitude_town' => null
		),
		'Bono' => array(),
		'EstablishmentsCategory' => array(
			(int) 0 => 'FISIOTERAPIA EN LA ACTIVIDAD FISICA Y DEPORTE',
			(int) 1 => 'FISIOTERAPIA RESPIRATORIA',
			(int) 2 => 'FISIOTERAPIA NEUROLÓGICA'
		),
		'Comment' => array(),
		'Service' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'Staff' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'Timetable' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		),
		'News' => array(),
		'Slide' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'Feature' => array(),
		'Specialty' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		),
		'Insurance' => array(),
		'PopulationZone' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'activities' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			),
			(int) 23 => array(
				[maximum depth reached]
			),
			(int) 24 => array(
				[maximum depth reached]
			),
			(int) 25 => array(
				[maximum depth reached]
			),
			(int) 26 => array(
				[maximum depth reached]
			),
			(int) 27 => array(
				[maximum depth reached]
			),
			(int) 28 => array(
				[maximum depth reached]
			),
			(int) 29 => array(
				[maximum depth reached]
			),
			(int) 30 => array(
				[maximum depth reached]
			),
			(int) 31 => array(
				[maximum depth reached]
			),
			(int) 32 => array(
				[maximum depth reached]
			),
			(int) 33 => array(
				[maximum depth reached]
			),
			(int) 34 => array(
				[maximum depth reached]
			),
			(int) 35 => array(
				[maximum depth reached]
			),
			(int) 36 => array(
				[maximum depth reached]
			),
			(int) 37 => array(
				[maximum depth reached]
			),
			(int) 38 => array(
				[maximum depth reached]
			),
			(int) 39 => array(
				[maximum depth reached]
			),
			(int) 40 => array(
				[maximum depth reached]
			),
			(int) 41 => array(
				[maximum depth reached]
			),
			(int) 42 => array(
				[maximum depth reached]
			),
			(int) 43 => array(
				[maximum depth reached]
			),
			(int) 44 => array(
				[maximum depth reached]
			),
			(int) 45 => array(
				[maximum depth reached]
			)
		),
		'ServiceHours' => '<div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Lunes<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Martes<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Miercoles<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Jueves<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Viernes<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Sábado<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle fis_card_schedule_day_close"></i>Domingo<span class="fis_card_schedule_day_close">Cerrado</span></div>'
	),
	'establishmentInfoData' => '{"id":"12588","releases":[],"coupons":[],"budget":[],"offers":[]}',
	'gallery' => '[{"src":"\/files\/slide\/attachment\/12588\/carrousel_titulo-de-la-imagen.png","type":"image","title":"titulo de la imagen"}]',
	'user' => false,
	'near_recommend' => false,
	'total_bonos' => (int) 7,
	'last_bonos' => array(
		(int) 0 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array([maximum depth reached])
		),
		(int) 2 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Bono' => array(
				[maximum depth reached]
			),
			'Establishment' => array(
				[maximum depth reached]
			),
			'Service' => array(
				[maximum depth reached]
			)
		)
	)
)
$validations_errors = null
$establishment = array(
	'Establishment' => array(
		'id' => '12588',
		'name' => 'Clinica de Prueba para extracción de datos',
		'category_id' => '1',
		'establishment_type' => '2',
		'image' => null,
		'image_dir' => null,
		'web' => '',
		'short_description' => null,
		'description' => 'Descripción del establecimiento',
		'fiscalnumber' => 'B33861329',
		'address1' => 'Peña Ubiña, 4',
		'address2' => '',
		'email' => 'info@aplicasoluciones.com',
		'fax' => null,
		'mobile' => '',
		'mobile2' => null,
		'phone' => '985518899',
		'phone2' => '617890603',
		'zipcode' => '33405',
		'town' => 'Castrillón',
		'state' => 'Asturias',
		'country' => '',
		'latitude' => null,
		'longitude' => null,
		'slug' => null,
		'canonical' => 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos',
		'canonical_old' => null,
		'timetable' => null,
		'hash' => '84875c248a54bbe8f588db54d106f892',
		'hash_old' => null,
		'deleted' => false,
		'deleterequest' => null,
		'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
		'plan_id' => '3',
		'next_plan_id' => null,
		'video' => null,
		'pinterest' => null,
		'googleplus' => null,
		'youtube' => null,
		'linkedin' => null,
		'facebook' => null,
		'twitter' => null,
		'status' => '1',
		'subscription_status' => null,
		'subscription_id' => '13262775',
		'population_id' => '1517',
		'bank' => '',
		'bank_cert' => 'ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
		'bank_cert_dir' => '12588/39/58/92',
		'bank_cert_status' => null,
		'file_dni' => 'pdf_with_something__8_.pdf',
		'file_dni_dir' => '12588/08/40/18',
		'writers' => 'ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
		'writers_dir' => '12588/35/76/19',
		'split_id' => null,
		'created' => '2021-05-12 16:22:49',
		'modified' => '2021-05-17 11:36:11',
		'sms' => null,
		'fulladdress' => 'Peña Ubiña, 4, Castrillón ( 33405 ) , Asturias',
		'link' => 'https://www.fisiosite.com/fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos',
		'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12588/39/58/92/ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
		'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12588/08/40/18/pdf_with_something__8_.pdf',
		'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers/12588/35/76/19/ti__tulo_del_proyecto_timberia_nombre_de_la_pieza_timberia.pdf',
		'rating' => false,
		'is_open' => true
	),
	'Category' => array(
		'id' => '1',
		'name' => 'FISIOTERAPIA',
		'slug' => 'fisioterapia',
		'description' => '',
		'parent_id' => '31',
		'created' => '2016-06-13 12:15:16',
		'modified' => '2016-06-13 12:15:16',
		'lft' => '2',
		'rght' => '3',
		'ParentCategory' => array(
			'id' => '31',
			'name' => 'FISIOTERAPIA',
			'slug' => 'fisioterapia-general',
			'description' => '',
			'parent_id' => '0',
			'created' => null,
			'modified' => null,
			'lft' => null,
			'rght' => null
		)
	),
	'Population' => array(
		'id' => '1517',
		'town' => 'Castrillón',
		'state' => 'Asturias',
		'canonical' => 'asturias/castrillon',
		'canonical_town' => 'castrillon',
		'is_footer' => '1',
		'capital_population_id' => null,
		'latitude_town' => null,
		'longitude_town' => null
	),
	'Bono' => array(),
	'EstablishmentsCategory' => array(
		(int) 0 => 'FISIOTERAPIA EN LA ACTIVIDAD FISICA Y DEPORTE',
		(int) 1 => 'FISIOTERAPIA RESPIRATORIA',
		(int) 2 => 'FISIOTERAPIA NEUROLÓGICA'
	),
	'Comment' => array(),
	'Service' => array(
		(int) 0 => array(
			'id' => '468',
			'name' => 'Servicio de prueba',
			'description' => '<p>Servicio de prueba<br></p>',
			'duration_reserved' => '30',
			'duration' => '50',
			'price' => '30',
			'slots' => '1',
			'pay_online' => '1',
			'establishment_id' => '12588',
			'created_status' => '1',
			'tag' => '',
			'created' => '2021-05-17 12:14:23',
			'modified' => '2021-05-17 12:14:23',
			'Timetable' => array(
				[maximum depth reached]
			),
			'Staff' => array(
				[maximum depth reached]
			)
		)
	),
	'Staff' => array(
		(int) 0 => array(
			'id' => '309',
			'name' => 'Fisio Manu',
			'surname' => 'Apellidos Manu',
			'title' => 'Fisioterapeuta',
			'establishment_id' => '12588',
			'status' => '0',
			'image' => null,
			'image_dir' => null,
			'experience' => 'Poca',
			'formation' => null,
			'professional_code' => '',
			'created' => '2021-05-14 09:34:49',
			'modified' => '2021-05-14 09:34:49',
			'fullname' => 'Fisio Manu Apellidos Manu'
		)
	),
	'Timetable' => array(
		(int) 0 => array(
			'id' => '15153',
			'object' => 'Establishment',
			'object_id' => '12588',
			'day' => '0',
			'start' => '09:00:00',
			'end' => '18:00:00',
			'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
			'created' => '2021-05-17 11:33:53',
			'modified' => '2021-05-17 11:33:53'
		),
		(int) 1 => array(
			'id' => '15154',
			'object' => 'Establishment',
			'object_id' => '12588',
			'day' => '1',
			'start' => '09:00:00',
			'end' => '18:00:00',
			'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
			'created' => '2021-05-17 11:33:53',
			'modified' => '2021-05-17 11:33:53'
		),
		(int) 2 => array(
			'id' => '15155',
			'object' => 'Establishment',
			'object_id' => '12588',
			'day' => '2',
			'start' => '09:00:00',
			'end' => '18:00:00',
			'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
			'created' => '2021-05-17 11:33:53',
			'modified' => '2021-05-17 11:33:53'
		),
		(int) 3 => array(
			'id' => '15156',
			'object' => 'Establishment',
			'object_id' => '12588',
			'day' => '3',
			'start' => '09:00:00',
			'end' => '18:00:00',
			'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
			'created' => '2021-05-17 11:33:53',
			'modified' => '2021-05-17 11:33:53'
		),
		(int) 4 => array(
			'id' => '15157',
			'object' => 'Establishment',
			'object_id' => '12588',
			'day' => '4',
			'start' => '09:00:00',
			'end' => '18:00:00',
			'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
			'created' => '2021-05-17 11:33:53',
			'modified' => '2021-05-17 11:33:53'
		),
		(int) 5 => array(
			'id' => '15158',
			'object' => 'Establishment',
			'object_id' => '12588',
			'day' => '5',
			'start' => '09:00:00',
			'end' => '18:00:00',
			'user_id' => '5b928e26-a488-49a2-8056-62a30a3a8879',
			'created' => '2021-05-17 11:33:53',
			'modified' => '2021-05-17 11:33:53'
		)
	),
	'News' => array(),
	'Slide' => array(
		(int) 0 => array(
			'id' => '1649',
			'model' => 'Establishment',
			'foreign_key' => '12588',
			'name' => 'titulo de la imagen',
			'attachment' => 'titulo-de-la-imagen.png',
			'dir' => '12588',
			'type' => 'image/png',
			'size' => '76627',
			'active' => true
		)
	),
	'Feature' => array(),
	'Specialty' => array(
		(int) 0 => array(
			'id' => '268',
			'name' => 'Migraña',
			'description' => '',
			'slug' => 'migrana',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'EstablishmentsSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'id' => '269',
			'name' => 'Radiculopatía',
			'description' => '',
			'slug' => 'radiculopatia',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'EstablishmentsSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'id' => '271',
			'name' => 'Artrosis',
			'description' => '',
			'slug' => 'artrosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:05',
			'modified' => '2017-05-22 16:08:05',
			'EstablishmentsSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'id' => '268',
			'name' => 'Migraña',
			'description' => '',
			'slug' => 'migrana',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'EstablishmentsSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'id' => '269',
			'name' => 'Radiculopatía',
			'description' => '',
			'slug' => 'radiculopatia',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'EstablishmentsSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'id' => '271',
			'name' => 'Artrosis',
			'description' => '',
			'slug' => 'artrosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:05',
			'modified' => '2017-05-22 16:08:05',
			'EstablishmentsSpecialty' => array(
				[maximum depth reached]
			)
		)
	),
	'Insurance' => array(),
	'PopulationZone' => array(
		(int) 0 => array(
			'id' => '1517',
			'town' => 'Castrillón',
			'state' => 'Asturias',
			'canonical' => 'asturias/castrillon',
			'canonical_town' => 'castrillon',
			'is_footer' => '1',
			'capital_population_id' => null,
			'latitude_town' => null,
			'longitude_town' => null,
			'PopulationEstablishment' => array(
				[maximum depth reached]
			)
		)
	),
	'activities' => array(
		(int) 0 => array(
			'id' => '268',
			'name' => 'Migraña',
			'description' => '',
			'slug' => 'migrana',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'id' => '269',
			'name' => 'Radiculopatía',
			'description' => '',
			'slug' => 'radiculopatia',
			'featured' => null,
			'created' => '2017-05-22 16:08:03',
			'modified' => '2017-05-22 16:08:03',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'id' => '270',
			'name' => 'Vértigo',
			'description' => '',
			'slug' => 'vertigo',
			'featured' => null,
			'created' => '2017-05-22 16:08:04',
			'modified' => '2017-05-22 16:08:04',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'id' => '271',
			'name' => 'Artrosis',
			'description' => '',
			'slug' => 'artrosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:05',
			'modified' => '2017-05-22 16:08:05',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'id' => '272',
			'name' => 'Artritis',
			'description' => '',
			'slug' => 'artritis',
			'featured' => null,
			'created' => '2017-05-22 16:08:06',
			'modified' => '2017-05-22 16:08:06',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'id' => '273',
			'name' => 'Cervicalgia',
			'description' => '',
			'slug' => 'cervicalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:07',
			'modified' => '2017-05-22 16:08:07',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 6 => array(
			'id' => '274',
			'name' => 'Dolor de cuello',
			'description' => '',
			'slug' => 'dolor-de-cuello',
			'featured' => null,
			'created' => '2017-05-22 16:08:08',
			'modified' => '2017-05-22 16:08:08',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 7 => array(
			'id' => '275',
			'name' => 'Dorsalgia',
			'description' => '',
			'slug' => 'dorsalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:09',
			'modified' => '2017-05-22 16:08:09',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 8 => array(
			'id' => '276',
			'name' => 'Dolor de espalda',
			'description' => '',
			'slug' => 'dolor-de-espalda',
			'featured' => null,
			'created' => '2017-05-22 16:08:10',
			'modified' => '2017-05-22 16:08:10',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 9 => array(
			'id' => '277',
			'name' => 'Lumbalgia',
			'description' => '',
			'slug' => 'lumbalgia',
			'featured' => null,
			'created' => '2017-05-22 16:08:11',
			'modified' => '2017-05-22 16:08:11',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 10 => array(
			'id' => '278',
			'name' => 'Dolor lumbar',
			'description' => '',
			'slug' => 'dolor-lumbar',
			'featured' => null,
			'created' => '2017-05-22 16:08:12',
			'modified' => '2017-05-22 16:08:12',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 11 => array(
			'id' => '279',
			'name' => 'Diabetes mellitus',
			'description' => '',
			'slug' => 'diabetes-mellitus',
			'featured' => null,
			'created' => '2017-05-22 16:08:13',
			'modified' => '2017-05-22 16:08:13',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 12 => array(
			'id' => '282',
			'name' => 'Dolor crónico',
			'description' => '',
			'slug' => 'dolor-cronico',
			'featured' => null,
			'created' => '2017-05-22 16:08:14',
			'modified' => '2017-05-22 16:08:14',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 13 => array(
			'id' => '283',
			'name' => 'Sd del túnel carpiano',
			'description' => '',
			'slug' => 'sd-del-tunel-carpiano',
			'featured' => null,
			'created' => '2017-05-22 16:08:15',
			'modified' => '2017-05-22 16:08:15',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 14 => array(
			'id' => '284',
			'name' => 'Ciática',
			'description' => '',
			'slug' => 'ciatica',
			'featured' => null,
			'created' => '2017-05-22 16:08:16',
			'modified' => '2017-05-22 16:08:16',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 15 => array(
			'id' => '285',
			'name' => 'Bruxismo',
			'description' => '',
			'slug' => 'bruxismo',
			'featured' => null,
			'created' => '2017-05-22 16:08:17',
			'modified' => '2017-05-22 16:08:17',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 16 => array(
			'id' => '286',
			'name' => 'Mareos',
			'description' => '',
			'slug' => 'mareos',
			'featured' => null,
			'created' => '2017-05-22 16:08:18',
			'modified' => '2017-05-22 16:08:18',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 17 => array(
			'id' => '287',
			'name' => 'Dolor de cabeza',
			'description' => '',
			'slug' => 'dolor-de-cabeza',
			'featured' => null,
			'created' => '2017-05-22 16:08:19',
			'modified' => '2017-05-22 16:08:19',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 18 => array(
			'id' => '288',
			'name' => 'Cefalea',
			'description' => '',
			'slug' => 'cefalea',
			'featured' => null,
			'created' => '2017-05-22 16:08:20',
			'modified' => '2017-05-22 16:08:20',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 19 => array(
			'id' => '289',
			'name' => 'Fascitis plantar',
			'description' => '',
			'slug' => 'fascitis-plantar',
			'featured' => null,
			'created' => '2017-05-22 16:08:21',
			'modified' => '2017-05-22 16:08:21',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 20 => array(
			'id' => '290',
			'name' => 'Cefalea tensional',
			'description' => '',
			'slug' => 'cefalea-tensional',
			'featured' => null,
			'created' => '2017-05-22 16:08:23',
			'modified' => '2017-05-22 16:08:23',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 21 => array(
			'id' => '291',
			'name' => 'Esguince',
			'description' => '',
			'slug' => 'esguince',
			'featured' => null,
			'created' => '2017-05-22 16:08:24',
			'modified' => '2017-05-22 16:08:24',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 22 => array(
			'id' => '292',
			'name' => 'Esguince de tobillo',
			'description' => '',
			'slug' => 'esguince-de-tobillo',
			'featured' => null,
			'created' => '2017-05-22 16:08:25',
			'modified' => '2017-05-22 16:08:25',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 23 => array(
			'id' => '293',
			'name' => 'Desgarro muscular',
			'description' => '',
			'slug' => 'desgarro-muscular',
			'featured' => null,
			'created' => '2017-05-22 16:08:26',
			'modified' => '2017-05-22 16:08:26',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 24 => array(
			'id' => '294',
			'name' => 'Tendinitis',
			'description' => '',
			'slug' => 'tendinitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:27',
			'modified' => '2017-05-22 16:08:27',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 25 => array(
			'id' => '295',
			'name' => 'Tendinosis',
			'description' => '',
			'slug' => 'tendinosis',
			'featured' => null,
			'created' => '2017-05-22 16:08:28',
			'modified' => '2017-05-22 16:08:28',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 26 => array(
			'id' => '296',
			'name' => 'Lesión del manguito rotador',
			'description' => '',
			'slug' => 'lesion-del-manguito-rotador',
			'featured' => null,
			'created' => '2017-05-22 16:08:30',
			'modified' => '2017-05-22 16:08:30',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 27 => array(
			'id' => '297',
			'name' => 'Epicondilitis',
			'description' => '',
			'slug' => 'epicondilitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:31',
			'modified' => '2017-05-22 16:08:31',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 28 => array(
			'id' => '298',
			'name' => 'Epitrocleitis',
			'description' => '',
			'slug' => 'epitrocleitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:32',
			'modified' => '2017-05-22 16:08:32',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 29 => array(
			'id' => '299',
			'name' => 'Periostitis',
			'description' => '',
			'slug' => 'periostitis',
			'featured' => null,
			'created' => '2017-05-22 16:08:33',
			'modified' => '2017-05-22 16:08:33',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 30 => array(
			'id' => '300',
			'name' => 'Lesión meniscal',
			'description' => '',
			'slug' => 'lesion-meniscal',
			'featured' => null,
			'created' => '2017-05-22 16:08:34',
			'modified' => '2017-05-22 16:08:34',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 31 => array(
			'id' => '307',
			'name' => 'Espolón calcáneo',
			'description' => '',
			'slug' => 'espolon-calcaneo',
			'featured' => null,
			'created' => '2017-05-22 16:08:35',
			'modified' => '2017-05-22 16:08:35',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 32 => array(
			'id' => '308',
			'name' => 'Prótesis de rodilla',
			'description' => '',
			'slug' => 'protesis-de-rodilla',
			'featured' => null,
			'created' => '2017-05-22 16:08:36',
			'modified' => '2017-05-22 16:08:36',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 33 => array(
			'id' => '309',
			'name' => 'Prótesis de cadera',
			'description' => '',
			'slug' => 'protesis-de-cadera',
			'featured' => null,
			'created' => '2017-05-22 16:08:37',
			'modified' => '2017-05-22 16:08:37',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 34 => array(
			'id' => '311',
			'name' => 'Fractura de cadera',
			'description' => '',
			'slug' => 'fractura-de-cadera',
			'featured' => null,
			'created' => '2017-05-22 16:08:38',
			'modified' => '2017-05-22 16:08:38',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 35 => array(
			'id' => '312',
			'name' => 'Trastornos de equilibrio',
			'description' => '',
			'slug' => 'trastornos-de-equilibrio',
			'featured' => null,
			'created' => '2017-05-22 16:08:39',
			'modified' => '2017-05-22 16:08:39',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 36 => array(
			'id' => '313',
			'name' => 'Caídas',
			'description' => '',
			'slug' => 'caidas',
			'featured' => null,
			'created' => '2017-05-22 16:08:40',
			'modified' => '2017-05-22 16:08:40',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 37 => array(
			'id' => '323',
			'name' => 'Dolor pélvico',
			'description' => '',
			'slug' => 'dolor-pelvico',
			'featured' => null,
			'created' => '2017-05-22 16:08:41',
			'modified' => '2017-05-22 16:08:41',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 38 => array(
			'id' => '329',
			'name' => 'Fracturas',
			'description' => '',
			'slug' => 'fracturas',
			'featured' => null,
			'created' => '2017-05-22 16:08:42',
			'modified' => '2017-05-22 16:08:42',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 39 => array(
			'id' => '330',
			'name' => 'Lesión LCA (ligamento cruzado anterior)',
			'description' => '',
			'slug' => 'lesion-lca-ligamento-cruzado-anterior',
			'featured' => null,
			'created' => '2017-05-22 16:08:43',
			'modified' => '2017-05-22 16:08:43',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 40 => array(
			'id' => '331',
			'name' => 'Lesión LCP (ligamento cruzado posterior)',
			'description' => '',
			'slug' => 'lesion-lcp-ligamento-cruzado-posterior',
			'featured' => null,
			'created' => '2017-05-22 16:08:44',
			'modified' => '2017-05-22 16:08:44',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 41 => array(
			'id' => '332',
			'name' => 'Rotura del tendón de Aquiles',
			'description' => '',
			'slug' => 'rotura-del-tendon-de-aquiles',
			'featured' => null,
			'created' => '2017-05-22 16:08:45',
			'modified' => '2017-05-22 16:08:45',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 42 => array(
			'id' => '333',
			'name' => 'Luxación',
			'description' => '',
			'slug' => 'luxacion',
			'featured' => null,
			'created' => '2017-05-22 16:08:46',
			'modified' => '2017-05-22 16:08:46',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 43 => array(
			'id' => '334',
			'name' => 'Subluxación',
			'description' => '',
			'slug' => 'subluxacion',
			'featured' => null,
			'created' => '2017-05-22 16:08:47',
			'modified' => '2017-05-22 16:08:47',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 44 => array(
			'id' => '335',
			'name' => 'Condromalacia',
			'description' => '',
			'slug' => 'condromalacia',
			'featured' => null,
			'created' => '2017-05-22 16:08:48',
			'modified' => '2017-05-22 16:08:48',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		),
		(int) 45 => array(
			'id' => '340',
			'name' => 'Linfedema Drenaje linfático',
			'description' => '',
			'slug' => 'linfedema-drenaje-linfatico',
			'featured' => null,
			'created' => '2017-05-22 16:08:49',
			'modified' => '2017-05-22 16:08:49',
			'CategoriesSpecialty' => array(
				[maximum depth reached]
			)
		)
	),
	'ServiceHours' => '<div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Lunes<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Martes<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Miercoles<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Jueves<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Viernes<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle"></i>Sábado<span>De 9:00 a 18:00</span></div><div class="fis_card_schedule_day"><i class="icon fa-circle fis_card_schedule_day_close"></i>Domingo<span class="fis_card_schedule_day_close">Cerrado</span></div>'
)
$establishmentInfoData = '{"id":"12588","releases":[],"coupons":[],"budget":[],"offers":[]}'
$gallery = '[{"src":"\/files\/slide\/attachment\/12588\/carrousel_titulo-de-la-imagen.png","type":"image","title":"titulo de la imagen"}]'
$user = false
$near_recommend = false
$total_bonos = (int) 7
$last_bonos = array(
	(int) 0 => array(
		'Bono' => array(
			'id' => '44',
			'establishment_id' => '12251',
			'name' => 'Bono 5 sesiones',
			'description' => '<p>Bono de 5 sesiones con un 10% de descuento.</p>',
			'num_sessions' => '5',
			'price' => '200',
			'price_old' => '225',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2019-02-28 02:02:00',
			'tag' => '',
			'image' => 'img_20190217_142642_605.jpg',
			'image_dir' => '44/33/51/15',
			'created' => '2019-02-17 17:06:53',
			'modified' => '2019-02-17 17:08:47'
		),
		'Establishment' => array(
			'id' => '12251',
			'name' => 'Fisiopraxis ',
			'category_id' => '1',
			'establishment_type' => '2',
			'image' => null,
			'image_dir' => null,
			'web' => '',
			'short_description' => null,
			'description' => '<p>Centro de Servicios integrales de FISIOTERAPIA, ENTRENAMIENTO PERSONAL,&nbsp;ASESORAMIENTO NUTRICIONAL&nbsp;y PREPARACION FISICA.<br></p><p>-Tratamientos de Fisioterapia adaptados a la patología del paciente:</p><p></p><p>&nbsp; -Recuperación de lesiones</p><p>&nbsp; -Rehabilitación</p><p>&nbsp; -Terapia postural</p><p>&nbsp; -Readaptación del cuerpo</p><p>&nbsp; -Inducción Miofascial</p><p>&nbsp; -Terapia global</p><p>-En los Tratamientos referentes al Entrenamiento Personal y al Asesoramiento Nutricional, evaluamos en primera instancia el estado corporal de cada paciente.&nbsp;Realizamos una evaluación física (IMC, % de agua en el cuerpo, peso, masa grasa, masa muscular, grasa visceral y metabolismo basal saludable),con la que conseguimos&nbsp;los datos necesarios para hacer&nbsp;una estimación del consumo calórico en reposo y el necesario real&nbsp;adaptado a la vida de cada persona.En estos tratamientos, en la primera sesión,&nbsp;entregamos un plan de acción a&nbsp;4 semanas para conseguir los objetivos que nos requiera cada cliente.<br></p><p>-Nuestras recomendaciones siempre estarán enfocadas tanto en el ámbito de la recuperación corporal,&nbsp;preparación física&nbsp;y la nutrición saludable.</p>',
			'fiscalnumber' => '51073539s',
			'address1' => 'Trueba y Fernandez 16, 1D',
			'address2' => 'PROMOCION SEMANAL: VEN Y LLEVATE TU PRIMER ESTUDIO NUTRICIONAL DE FORMA GRATUITA.

Pide tu cita a cualquier hora del día cualquier día de la semana en el Tlf. 24H.(620152075).',
			'email' => 'Lucia.pascual@gmail.com',
			'fax' => null,
			'mobile' => '620152076',
			'mobile2' => null,
			'phone' => '620152076',
			'phone2' => '620152076',
			'zipcode' => '28016',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.454800',
			'longitude' => '-3.679500',
			'slug' => null,
			'canonical' => 'fisioterapia/madrid/fisiopraxis',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => '6421757aee8fc8f44f16a93b2acfe8af',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5c5eed8e-4c38-4903-b7c0-ad520a3a8879',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => 'ES3502340001079015557146',
			'bank_cert' => '1360573960275006783.pdf',
			'bank_cert_dir' => '12251/79/88/01',
			'bank_cert_status' => null,
			'file_dni' => 'zip_dni.zip',
			'file_dni_dir' => '12251/54/87/23',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2019-02-09 16:19:06',
			'modified' => '2019-03-21 18:53:54',
			'sms' => null,
			'fulladdress' => 'Trueba y Fernandez 16, 1D, Madrid ( 28016 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia/madrid/fisiopraxis',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12251/79/88/01/1360573960275006783.pdf',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12251/54/87/23/zip_dni.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array()
	),
	(int) 1 => array(
		'Bono' => array(
			'id' => '38',
			'establishment_id' => '10174',
			'name' => 'Pack 5 sesiones de vapor (infantil)',
			'description' => '<p>

<!--StartFragment--><header class="entry-content-header" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; display: block; color: rgb(102, 102, 102); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"></header><h4 class="av_iconlist_title iconlist_title  " itemprop="headline" style="display: block; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial; box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: inherit; font-variant: inherit; font-weight: 600; font-stretch: inherit; font-size: 18px; line-height: 1.1em; font-family: &quot;Terminal Dosis&quot;, HelveticaNeue, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; vertical-align: baseline; color: rgb(34, 34, 34); text-transform: uppercase; top: 4px; position: relative;">CALOR HÚMEDO (Vapor)</h4><header class="entry-content-header" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; display: block; color: rgb(102, 102, 102); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"></header><div class="iconlist_content  " itemprop="text" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 13px; line-height: 1.65em; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: rgb(141, 141, 141); letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(248, 248, 248); text-decoration-style: initial; text-decoration-color: initial;"><p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px rgb(225, 225, 225); font: inherit; vertical-align: baseline;">Chorro de vapor de agua de mar isotónica que actúa a nivel de las vías respiratorias altas y del oído hidratando y preparando la mucosa para los tratamientos posteriores. El vapor produce una agradable sensación de descongestión y tiene una gran acción mucolítica para ayudar a drenar la mucosidad, sobretodo en el caso de los niños.&nbsp;</p></div></p><p class="sceditor-nlf"><br></p>',
			'num_sessions' => '5',
			'price' => '81',
			'price_old' => '18',
			'status' => '0',
			'start' => null,
			'end' => '2018-11-30 02:00:00',
			'tag' => 'Pack F,Pack Vapores',
			'image' => 'nen_p.jpg',
			'image_dir' => '38/78/37/59',
			'created' => '2018-11-20 10:35:46',
			'modified' => '2018-11-20 10:35:46'
		),
		'Establishment' => array(
			'id' => '10174',
			'name' => 'BALNEARI RESPIRATORI METODE Dr. PROS',
			'category_id' => '6',
			'establishment_type' => '2',
			'image' => 'logo_br_m_dr.pros_nvcat.jpg',
			'image_dir' => '10174/86/81/02',
			'web' => 'http://balnearirespiratori.cat',
			'short_description' => 'En el centro tratamos todas las patologías de las vías respiratorias y del oído utilizando el agua de mar como herramienta terapéutica a través de vapores, nebulizaciones y duchas nasales, así como técnicas de fisioterapia para el drenaje de la mucosidad bronquial.',
			'description' => '<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">En el año 2002 nació el Balneari Respiratori bajo la dirección del Dr. Miquel Pros, prestigioso médico naturista pionero en la introducción en España de las terapias procedentes de la escuela alemana de medicina naturista.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">El Dr. Pros afirma que la acumulación crónica de las mucosidades en el interior de las cavidades nasales las convierte en una zona altamente conflictiva, un foco infeccioso que puede llegar a generar más de 20 patologías respiratorias y del oído, además de afectar a otras partes de nuestro organismo, como el sistema digestivo y el sistema inmunológico. Es su&nbsp;Teoría de la Sinusitis Silenciosa.&nbsp;</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">Esta teoría lo llevó a sistematizar el uso del agua de mar para el tratamiento de las afecciones respiratorias y del oído en lo que hoy conocemos como Balneari Respiratori. A lo largo de estos 15 años y acompañado por la fisioterapeuta Núria Oliver, que actualmente dirige el centro, se ha demostrado la gran eficacia del método terapéutico del Dr. Pros, más de 6.000 pacientes han recibido los tratamientos con agua de mar.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 13px; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; color: #666666; background-color: #f8f8f8;">En el año 2010 se realizó un estudio piloto con un grupo de niños de guardería de 0 a 6 años para constatar científicamente los beneficios de los tratamientos con agua de mar en niños, obteniendo unos resultados altamente satisfactorios, pues 9 de cada 10 niños y niñas mejoraron sus trastornos respiratorios respecto a su situación inicial.</p>
Alergias? Sinusitis? Oídos tapados? Dolor de garganta o de cabeza? Congestión nasal?

&nbsp;



<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">Te podemos ayudar a disminuir y eliminar todos estos síntomas.</p>
<p style="box-sizing: border-box; margin: 0.85em 0px; padding: 0px; border: 0px #e1e1e1; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">Ven y haremos una desensibilización de las mucosas respiratorias con agua de mar natural y INDIBA (hipertermia profunda). A través de nuestros tratamientos ayudamos a drenar la mucosidad estancada y disminuir la inflamación de las mucosas respiratorias.</p>

<p class="sceditor-nlf"><br></p>',
			'fiscalnumber' => '52593943G',
			'address1' => 'Carrer de Muntaner, 411',
			'address2' => '',
			'email' => 'info@balnearirespiratori.cat',
			'fax' => null,
			'mobile' => '',
			'mobile2' => '',
			'phone' => '932 11 07 95',
			'phone2' => '',
			'zipcode' => '08021',
			'town' => 'Barcelona',
			'state' => 'Barcelona',
			'country' => 'España',
			'latitude' => '41.400227',
			'longitude' => '2.141209',
			'slug' => null,
			'canonical' => 'fisioterapia-respiratoria/barcelona/balneari-respiratori-metode-dr-pros',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'b15b72025c53132fa9f4d7177cf636d4',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '59d49439-e0a0-4f05-8bf9-75470a3a8836',
			'plan_id' => '1',
			'next_plan_id' => null,
			'video' => 'https://www.facebook.com/balnearirespiratori/videos/vb.120248087989511/1142642909083352/?type=2&theater',
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => '0',
			'subscription_id' => '0',
			'population_id' => '4957',
			'bank' => '',
			'bank_cert' => null,
			'bank_cert_dir' => null,
			'bank_cert_status' => null,
			'file_dni' => null,
			'file_dni_dir' => null,
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2017-10-02 09:47:34',
			'modified' => '2019-09-16 13:01:21',
			'sms' => null,
			'fulladdress' => 'Carrer de Muntaner, 411, Barcelona ( 08021 ) , Barcelona',
			'link' => 'https://www.fisiosite.com/fisioterapia-respiratoria/barcelona/balneari-respiratori-metode-dr-pros',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert//',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni//',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array()
	),
	(int) 2 => array(
		'Bono' => array(
			'id' => '32',
			'establishment_id' => '12044',
			'name' => '10 SESIONES',
			'description' => '<p><br></p>',
			'num_sessions' => '10',
			'price' => '450',
			'price_old' => '50',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2018-12-31 02:12:00',
			'tag' => '',
			'image' => 'rdhealth.jpg',
			'image_dir' => '32/14/58/99',
			'created' => '2018-11-09 21:17:41',
			'modified' => '2018-11-09 21:19:24'
		),
		'Establishment' => array(
			'id' => '12044',
			'name' => 'Romero Diaz Health S.L.',
			'category_id' => '4',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://rdsalud.com',
			'short_description' => null,
			'description' => '<p><br></p>',
			'fiscalnumber' => 'B87567756',
			'address1' => 'Santa rita 7',
			'address2' => '',
			'email' => 'GUILLERMO.ROMERO@RDSALUD.COM',
			'fax' => null,
			'mobile' => '722212109',
			'mobile2' => null,
			'phone' => '722212109',
			'phone2' => '722212109',
			'zipcode' => '28002',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.445545',
			'longitude' => '-3.667930',
			'slug' => null,
			'canonical' => 'fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e025e0303196ecd8bd96a04f24013201',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5a6ed0f1-1004-4ca6-a938-01b60a3a8836',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => '',
			'bank_cert' => 'dni_guille.jpeg',
			'bank_cert_dir' => '12044/83/52/73',
			'bank_cert_status' => null,
			'file_dni' => 'archivo_comprimido_2.zip',
			'file_dni_dir' => '12044/52/04/64',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2018-08-10 18:11:10',
			'modified' => '2019-05-30 00:59:40',
			'sms' => null,
			'fulladdress' => 'Santa rita 7, Madrid ( 28002 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12044/83/52/73/dni_guille.jpeg',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12044/52/04/64/archivo_comprimido_2.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	),
	(int) 3 => array(
		'Bono' => array(
			'id' => '29',
			'establishment_id' => '12044',
			'name' => '5 SESIONES',
			'description' => '<p><br></p>',
			'num_sessions' => '5',
			'price' => '237.5',
			'price_old' => '50',
			'status' => '1',
			'start' => '1970-01-01 01:01:00',
			'end' => '2018-12-31 02:12:00',
			'tag' => '',
			'image' => 'rdhealth.jpg',
			'image_dir' => '29/68/63/77',
			'created' => '2018-11-09 21:15:55',
			'modified' => '2018-11-09 21:19:10'
		),
		'Establishment' => array(
			'id' => '12044',
			'name' => 'Romero Diaz Health S.L.',
			'category_id' => '4',
			'establishment_type' => '1',
			'image' => null,
			'image_dir' => null,
			'web' => 'http://rdsalud.com',
			'short_description' => null,
			'description' => '<p><br></p>',
			'fiscalnumber' => 'B87567756',
			'address1' => 'Santa rita 7',
			'address2' => '',
			'email' => 'GUILLERMO.ROMERO@RDSALUD.COM',
			'fax' => null,
			'mobile' => '722212109',
			'mobile2' => null,
			'phone' => '722212109',
			'phone2' => '722212109',
			'zipcode' => '28002',
			'town' => 'Madrid',
			'state' => 'Madrid',
			'country' => '',
			'latitude' => '40.445545',
			'longitude' => '-3.667930',
			'slug' => null,
			'canonical' => 'fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'canonical_old' => null,
			'timetable' => null,
			'hash' => 'e025e0303196ecd8bd96a04f24013201',
			'hash_old' => null,
			'deleted' => false,
			'deleterequest' => null,
			'user_id' => '5a6ed0f1-1004-4ca6-a938-01b60a3a8836',
			'plan_id' => '3',
			'next_plan_id' => null,
			'video' => null,
			'pinterest' => null,
			'googleplus' => null,
			'youtube' => null,
			'linkedin' => null,
			'facebook' => null,
			'twitter' => null,
			'status' => '1',
			'subscription_status' => null,
			'subscription_id' => null,
			'population_id' => '6902',
			'bank' => '',
			'bank_cert' => 'dni_guille.jpeg',
			'bank_cert_dir' => '12044/83/52/73',
			'bank_cert_status' => null,
			'file_dni' => 'archivo_comprimido_2.zip',
			'file_dni_dir' => '12044/52/04/64',
			'writers' => null,
			'writers_dir' => null,
			'split_id' => null,
			'created' => '2018-08-10 18:11:10',
			'modified' => '2019-05-30 00:59:40',
			'sms' => null,
			'fulladdress' => 'Santa rita 7, Madrid ( 28002 ) , Madrid',
			'link' => 'https://www.fisiosite.com/fisioterapia-actividad-fisica-deporte/madrid/romero-diaz-health-s-l',
			'path_cert' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/bank_cert/12044/83/52/73/dni_guille.jpeg',
			'path_dni' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/file_dni/12044/52/04/64/archivo_comprimido_2.zip',
			'path_writers' => '/home/bkvtdvl/fisiosite/webroot//files/establishment/writers//'
		),
		'Service' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		)
	)
)

include - APP/View/fisiosite/Establishments/show.ctp, line 13
View::_evaluate() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 971
View::_render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 933
View::render() - APP/Vendor/cakephp/cakephp/lib/Cake/View/View.php, line 473
Controller::render() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 968
EstablishmentsController::show() - APP/Controller/EstablishmentsController.php, line 322
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 135

Clinica de Prueba para extracción de datos

Ver teléfono

FISIOTERAPIA, FISIOTERAPIA EN LA ACTIVIDAD FISICA Y DEPORTE, FISIOTERAPIA RESPIRATORIA, FISIOTERAPIA NEUROLÓGICA

Peña Ubiña, 4, Castrillón ( 33405 ) , Asturias

- / 5

Opiniones (0)

Abierto ahora

PEDIR CITA

Información Servicios Opiniones

Presta servicio a domicilio en: Castrillón

Especialidades: Migraña Radiculopatía Artrosis

Información

Descripción del establecimiento

Profesionales que prestan servicio

Fisio Manu Apellidos Manu Nº Colegiado: -

Experiencia Poca

Formación Fisioterapeuta

Servicios

Servicio de prueba30€

Servicio de prueba

Este establecimiento aún no tiene valoración ¡Puedes ser el primero en valorar!

Limpieza

Profesional

Puntualidad

Calidad / Precio

Inicia sesión

Reserva tu cita

Día
Especialidad
Profesional
Hora

Elige el día para tu cita

Horario

LunesDe 9:00 a 18:00

MartesDe 9:00 a 18:00

MiercolesDe 9:00 a 18:00

JuevesDe 9:00 a 18:00

ViernesDe 9:00 a 18:00

SábadoDe 9:00 a 18:00

DomingoCerrado

Clinica de Prueba para extracción de datos Peña Ubiña, 4, Castrillón ( 33405 ) , Asturias

(default) 35 queries took 51 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Redirect`.`id`, `Redirect`.`old_url`, `Redirect`.`new_url`, `Redirect`.`created`, `Redirect`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_redirects` AS `Redirect` WHERE `old_url` = 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos' LIMIT 1	0	0	5
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`slug` = 'fisioterapia' LIMIT 1	1	1	1
3	SELECT `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` WHERE `Population`.`canonical` = 'castrillon/clinica-de-prueba-para-extraccion-de-datos' LIMIT 1	0	0	8
4	SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` WHERE `Establishment`.`hash` = '84875c248a54bbe8f588db54d106f892' LIMIT 1	1	1	1
5	SELECT `Bono`.`id`, `Bono`.`establishment_id`, `Bono`.`name`, `Bono`.`description`, `Bono`.`num_sessions`, `Bono`.`price`, `Bono`.`price_old`, `Bono`.`status`, `Bono`.`start`, `Bono`.`end`, `Bono`.`tag`, `Bono`.`image`, `Bono`.`image_dir`, `Bono`.`created`, `Bono`.`modified`, `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != '' ORDER BY `Bono`.`created` desc LIMIT 4	4	4	2
6	SELECT `Service`.`id`, `Service`.`name`, `Service`.`description`, `Service`.`duration_reserved`, `Service`.`duration`, `Service`.`price`, `Service`.`slots`, `Service`.`pay_online`, `Service`.`establishment_id`, `Service`.`created_status`, `Service`.`tag`, `Service`.`created`, `Service`.`modified`, `BonosService`.`id`, `BonosService`.`bono_id`, `BonosService`.`service_id` FROM `bkvtdvlfisiosite`.`fisiosite_services` AS `Service` JOIN `bkvtdvlfisiosite`.`fisiosite_bonos_services` AS `BonosService` ON (`BonosService`.`bono_id` IN (44, 38, 32, 29) AND `BonosService`.`service_id` = `Service`.`id`)	4	4	1
7	SELECT COUNT(*) AS `count` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != ''	1	1	1
8	BEGIN	0	0	0
9	INSERT INTO `bkvtdvlfisiosite`.`fisiosite_events` (`object`, `object_id`, `user_id`, `params`, `ipaddress`, `request`, `modified`, `created`) VALUES ('page_view', '12588', NULL, 'a:7:{s:6:\"plugin\";N;s:10:\"controller\";s:14:\"establishments\";s:6:\"action\";s:4:\"show\";s:5:\"named\";a:0:{}s:4:\"pass\";a:1:{s:2:\"id\";s:5:\"12588\";}s:6:\"_Token\";a:2:{s:3:\"key\";s:128:\"8fe6b9c8bb97943649d42a14545dc6e688ea6c3bbbc06e38f643ce830249fcd6ca40cf443243d41f13391eb6858e3af9321752c5af5e8d11f794ab2387abdaa5\";s:14:\"unlockedFields\";a:0:{}}s:6:\"isAjax\";b:0;}', '18.97.14.83', 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos', '2025-06-17 12:52:30', '2025-06-17 12:52:30')	1	1	1
10	COMMIT	0	0	0
11	SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` WHERE `Establishment`.`id` = 12588 LIMIT 1	1	1	1
12	SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght`, `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` ON (`Establishment`.`category_id` = `Category`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` ON (`Establishment`.`population_id` = `Population`.`id`) WHERE `Establishment`.`id` = 12588 AND `Establishment`.`status` = 1 LIMIT 1	1	1	1
13	SELECT `ParentCategory`.`id`, `ParentCategory`.`name`, `ParentCategory`.`slug`, `ParentCategory`.`description`, `ParentCategory`.`parent_id`, `ParentCategory`.`created`, `ParentCategory`.`modified`, `ParentCategory`.`lft`, `ParentCategory`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 31	1	1	0
14	SELECT `Bono`.`id`, `Bono`.`establishment_id`, `Bono`.`name`, `Bono`.`description`, `Bono`.`num_sessions`, `Bono`.`price`, `Bono`.`price_old`, `Bono`.`status`, `Bono`.`start`, `Bono`.`end`, `Bono`.`tag`, `Bono`.`image`, `Bono`.`image_dir`, `Bono`.`created`, `Bono`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` WHERE `Bono`.`establishment_id` = (12588)	0	0	1
15	SELECT `EstablishmentsCategory`.`id`, `EstablishmentsCategory`.`establishment_id`, `EstablishmentsCategory`.`category_id`, `EstablishmentsCategory`.`created`, `EstablishmentsCategory`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_categories` AS `EstablishmentsCategory` WHERE `EstablishmentsCategory`.`establishment_id` = (12588)	3	3	1
16	SELECT `Comment`.`id`, `Comment`.`object_id`, `Comment`.`object`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`clean`, `Comment`.`puntuality`, `Comment`.`professionality`, `Comment`.`quality`, `Comment`.`status`, `Comment`.`modified`, `Comment`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_comments` AS `Comment` WHERE `Comment`.`status` IN ('', '0', '1') AND `Comment`.`object_id` = (12588) ORDER BY `created` DESC	0	0	1
17	SELECT `Service`.`id`, `Service`.`name`, `Service`.`description`, `Service`.`duration_reserved`, `Service`.`duration`, `Service`.`price`, `Service`.`slots`, `Service`.`pay_online`, `Service`.`establishment_id`, `Service`.`created_status`, `Service`.`tag`, `Service`.`created`, `Service`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_services` AS `Service` WHERE `Service`.`establishment_id` = (12588)	1	1	1
18	SELECT `Timetable`.`id`, `Timetable`.`object`, `Timetable`.`object_id`, `Timetable`.`day`, `Timetable`.`start`, `Timetable`.`end`, `Timetable`.`user_id`, `Timetable`.`created`, `Timetable`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_timetables` AS `Timetable` WHERE `Timetable`.`object` = 'Service' AND `Timetable`.`object_id` = (468)	4	4	1
19	SELECT `Staff`.`id`, `Staff`.`name`, `Staff`.`surname`, `Staff`.`title`, `Staff`.`establishment_id`, `Staff`.`status`, `Staff`.`image`, `Staff`.`image_dir`, `Staff`.`experience`, `Staff`.`formation`, `Staff`.`professional_code`, `Staff`.`created`, `Staff`.`modified`, (CONCAT(`Staff`.`name`, " ", `Staff`.`surname`)) AS `Staff__fullname`, `ServicesStaff`.`id`, `ServicesStaff`.`service_id`, `ServicesStaff`.`staff_id`, `ServicesStaff`.`created`, `ServicesStaff`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_staffs` AS `Staff` JOIN `bkvtdvlfisiosite`.`fisiosite_services_staffs` AS `ServicesStaff` ON (`ServicesStaff`.`service_id` = 468 AND `ServicesStaff`.`staff_id` = `Staff`.`id`)	1	1	2
20	SELECT `Staff`.`id`, `Staff`.`name`, `Staff`.`surname`, `Staff`.`title`, `Staff`.`establishment_id`, `Staff`.`status`, `Staff`.`image`, `Staff`.`image_dir`, `Staff`.`experience`, `Staff`.`formation`, `Staff`.`professional_code`, `Staff`.`created`, `Staff`.`modified`, (CONCAT(`Staff`.`name`, " ", `Staff`.`surname`)) AS `Staff__fullname` FROM `bkvtdvlfisiosite`.`fisiosite_staffs` AS `Staff` WHERE `Staff`.`establishment_id` = (12588)	1	1	0
21	SELECT `Timetable`.`id`, `Timetable`.`object`, `Timetable`.`object_id`, `Timetable`.`day`, `Timetable`.`start`, `Timetable`.`end`, `Timetable`.`user_id`, `Timetable`.`created`, `Timetable`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_timetables` AS `Timetable` WHERE `Timetable`.`object` = 'Establishment' AND `Timetable`.`object_id` = (12588)	6	6	1
22	SELECT `News`.`id`, `News`.`user_id`, `News`.`establishment_id`, `News`.`title`, `News`.`description`, `News`.`canonical`, `News`.`image`, `News`.`image_dir`, `News`.`status`, `News`.`role`, `News`.`placement`, `News`.`created`, `News`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_news` AS `News` WHERE `News`.`status` = '1' AND `News`.`establishment_id` = (12588)	0	0	1
23	SELECT `Slide`.`id`, `Slide`.`model`, `Slide`.`foreign_key`, `Slide`.`name`, `Slide`.`attachment`, `Slide`.`dir`, `Slide`.`type`, `Slide`.`size`, `Slide`.`active` FROM `bkvtdvlfisiosite`.`fisiosite_attachments` AS `Slide` WHERE `Slide`.`model` = 'Establishment' AND `Slide`.`foreign_key` = (12588)	1	1	1
24	SELECT `Feature`.`id`, `Feature`.`feature_group_id`, `Feature`.`name`, `Feature`.`description`, `Feature`.`created`, `Feature`.`modified`, `EstablishmentsFeature`.`id`, `EstablishmentsFeature`.`establishment_id`, `EstablishmentsFeature`.`feature_id`, `EstablishmentsFeature`.`created`, `EstablishmentsFeature`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_features` AS `Feature` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_features` AS `EstablishmentsFeature` ON (`EstablishmentsFeature`.`establishment_id` = 12588 AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`)	0	0	1
25	SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `EstablishmentsSpecialty`.`id`, `EstablishmentsSpecialty`.`establishment_id`, `EstablishmentsSpecialty`.`specialty_id` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_specialties` AS `EstablishmentsSpecialty` ON (`EstablishmentsSpecialty`.`establishment_id` = 12588 AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`)	6	6	1
26	SELECT `Insurance`.`id`, `Insurance`.`name`, `Insurance`.`description`, `Insurance`.`slug`, `Insurance`.`featured`, `Insurance`.`created`, `Insurance`.`modified`, `EstablishmentsInsurance`.`id`, `EstablishmentsInsurance`.`establishment_id`, `EstablishmentsInsurance`.`insurance_id`, `EstablishmentsInsurance`.`created`, `EstablishmentsInsurance`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_insurances` AS `Insurance` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_insurances` AS `EstablishmentsInsurance` ON (`EstablishmentsInsurance`.`establishment_id` = 12588 AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`)	0	0	1
27	SELECT `PopulationZone`.`id`, `PopulationZone`.`town`, `PopulationZone`.`state`, `PopulationZone`.`canonical`, `PopulationZone`.`canonical_town`, `PopulationZone`.`is_footer`, `PopulationZone`.`capital_population_id`, `PopulationZone`.`latitude_town`, `PopulationZone`.`longitude_town`, `PopulationEstablishment`.`id`, `PopulationEstablishment`.`establishment_id`, `PopulationEstablishment`.`population_id`, `PopulationEstablishment`.`created`, `PopulationEstablishment`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `PopulationZone` JOIN `bkvtdvlfisiosite`.`fisiosite_population_establishments` AS `PopulationEstablishment` ON (`PopulationEstablishment`.`establishment_id` = 12588 AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`)	1	1	2
28	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`id` = 4 LIMIT 1	1	1	1
29	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`id` = 6 LIMIT 1	1	1	0
30	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`id` = 11 LIMIT 1	1	1	0
31	SELECT AVG( Rating.value ) as average, COUNT(`Rating`.`id`) AS valoraciones FROM `bkvtdvlfisiosite`.`fisiosite_ratings` AS `Rating` WHERE `Rating`.`foreign_key` = '12588' GROUP BY `Rating`.`foreign_key`	0	0	1
32	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`id` = 1	1	1	1
33	SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `CategoriesSpecialty`.`id`, `CategoriesSpecialty`.`specialty_id`, `CategoriesSpecialty`.`category_id`, `CategoriesSpecialty`.`created`, `CategoriesSpecialty`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_categories_specialties` AS `CategoriesSpecialty` ON (`CategoriesSpecialty`.`category_id` = 1 AND `CategoriesSpecialty`.`specialty_id` = `Specialty`.`id`)	46	46	1
34	SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos') OR (CONCAT('/',url) = '/fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos')) LIMIT 1	0	0	5
35	SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos') OR (CONCAT('/',url) = '/fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos')) LIMIT 1	0	0	5

(default) 35 queries took 51 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Redirect`.`id`, `Redirect`.`old_url`, `Redirect`.`new_url`, `Redirect`.`created`, `Redirect`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_redirects` AS `Redirect` WHERE `old_url` = 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos' LIMIT 1

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` WHERE `Category`.`slug` = 'fisioterapia' LIMIT 1

SELECT `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` WHERE `Population`.`canonical` = 'castrillon/clinica-de-prueba-para-extraccion-de-datos' LIMIT 1

SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` WHERE `Establishment`.`hash` = '84875c248a54bbe8f588db54d106f892' LIMIT 1

SELECT `Bono`.`id`, `Bono`.`establishment_id`, `Bono`.`name`, `Bono`.`description`, `Bono`.`num_sessions`, `Bono`.`price`, `Bono`.`price_old`, `Bono`.`status`, `Bono`.`start`, `Bono`.`end`, `Bono`.`tag`, `Bono`.`image`, `Bono`.`image_dir`, `Bono`.`created`, `Bono`.`modified`, `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != '' ORDER BY `Bono`.`created` desc LIMIT 4

SELECT `Service`.`id`, `Service`.`name`, `Service`.`description`, `Service`.`duration_reserved`, `Service`.`duration`, `Service`.`price`, `Service`.`slots`, `Service`.`pay_online`, `Service`.`establishment_id`, `Service`.`created_status`, `Service`.`tag`, `Service`.`created`, `Service`.`modified`, `BonosService`.`id`, `BonosService`.`bono_id`, `BonosService`.`service_id` FROM `bkvtdvlfisiosite`.`fisiosite_services` AS `Service` JOIN `bkvtdvlfisiosite`.`fisiosite_bonos_services` AS `BonosService` ON (`BonosService`.`bono_id` IN (44, 38, 32, 29) AND `BonosService`.`service_id` = `Service`.`id`)

SELECT COUNT(*) AS `count` FROM `bkvtdvlfisiosite`.`fisiosite_bonos` AS `Bono` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` ON (`Bono`.`establishment_id` = `Establishment`.`id`) WHERE 1 AND `Bono`.`image` != ''

BEGIN

INSERT INTO `bkvtdvlfisiosite`.`fisiosite_events` (`object`, `object_id`, `user_id`, `params`, `ipaddress`, `request`, `modified`, `created`) VALUES ('page_view', '12588', NULL, 'a:7:{s:6:\"plugin\";N;s:10:\"controller\";s:14:\"establishments\";s:6:\"action\";s:4:\"show\";s:5:\"named\";a:0:{}s:4:\"pass\";a:1:{s:2:\"id\";s:5:\"12588\";}s:6:\"_Token\";a:2:{s:3:\"key\";s:128:\"8fe6b9c8bb97943649d42a14545dc6e688ea6c3bbbc06e38f643ce830249fcd6ca40cf443243d41f13391eb6858e3af9321752c5af5e8d11f794ab2387abdaa5\";s:14:\"unlockedFields\";a:0:{}}s:6:\"isAjax\";b:0;}', '18.97.14.83', 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos', '2025-06-17 12:52:30', '2025-06-17 12:52:30')

COMMIT

SELECT `Establishment`.`id`, `Establishment`.`name`, `Establishment`.`category_id`, `Establishment`.`establishment_type`, `Establishment`.`image`, `Establishment`.`image_dir`, `Establishment`.`web`, `Establishment`.`short_description`, `Establishment`.`description`, `Establishment`.`fiscalnumber`, `Establishment`.`address1`, `Establishment`.`address2`, `Establishment`.`email`, `Establishment`.`fax`, `Establishment`.`mobile`, `Establishment`.`mobile2`, `Establishment`.`phone`, `Establishment`.`phone2`, `Establishment`.`zipcode`, `Establishment`.`town`, `Establishment`.`state`, `Establishment`.`country`, `Establishment`.`latitude`, `Establishment`.`longitude`, `Establishment`.`slug`, `Establishment`.`canonical`, `Establishment`.`canonical_old`, `Establishment`.`timetable`, `Establishment`.`hash`, `Establishment`.`hash_old`, `Establishment`.`deleted`, `Establishment`.`deleterequest`, `Establishment`.`user_id`, `Establishment`.`plan_id`, `Establishment`.`next_plan_id`, `Establishment`.`video`, `Establishment`.`pinterest`, `Establishment`.`googleplus`, `Establishment`.`youtube`, `Establishment`.`linkedin`, `Establishment`.`facebook`, `Establishment`.`twitter`, `Establishment`.`status`, `Establishment`.`subscription_status`, `Establishment`.`subscription_id`, `Establishment`.`population_id`, `Establishment`.`bank`, `Establishment`.`bank_cert`, `Establishment`.`bank_cert_dir`, `Establishment`.`bank_cert_status`, `Establishment`.`file_dni`, `Establishment`.`file_dni_dir`, `Establishment`.`writers`, `Establishment`.`writers_dir`, `Establishment`.`split_id`, `Establishment`.`created`, `Establishment`.`modified`, `Establishment`.`sms`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`description`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`lft`, `Category`.`rght`, `Population`.`id`, `Population`.`town`, `Population`.`state`, `Population`.`canonical`, `Population`.`canonical_town`, `Population`.`is_footer`, `Population`.`capital_population_id`, `Population`.`latitude_town`, `Population`.`longitude_town` FROM `bkvtdvlfisiosite`.`fisiosite_establishments` AS `Establishment` LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_categories` AS `Category` ON (`Establishment`.`category_id` = `Category`.`id`) LEFT JOIN `bkvtdvlfisiosite`.`fisiosite_populations` AS `Population` ON (`Establishment`.`population_id` = `Population`.`id`) WHERE `Establishment`.`id` = 12588 AND `Establishment`.`status` = 1 LIMIT 1

SELECT `ParentCategory`.`id`, `ParentCategory`.`name`, `ParentCategory`.`slug`, `ParentCategory`.`description`, `ParentCategory`.`parent_id`, `ParentCategory`.`created`, `ParentCategory`.`modified`, `ParentCategory`.`lft`, `ParentCategory`.`rght` FROM `bkvtdvlfisiosite`.`fisiosite_categories` AS `ParentCategory` WHERE `ParentCategory`.`id` = 31

SELECT `EstablishmentsCategory`.`id`, `EstablishmentsCategory`.`establishment_id`, `EstablishmentsCategory`.`category_id`, `EstablishmentsCategory`.`created`, `EstablishmentsCategory`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_establishments_categories` AS `EstablishmentsCategory` WHERE `EstablishmentsCategory`.`establishment_id` = (12588)

SELECT `Comment`.`id`, `Comment`.`object_id`, `Comment`.`object`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`clean`, `Comment`.`puntuality`, `Comment`.`professionality`, `Comment`.`quality`, `Comment`.`status`, `Comment`.`modified`, `Comment`.`created` FROM `bkvtdvlfisiosite`.`fisiosite_comments` AS `Comment` WHERE `Comment`.`status` IN ('', '0', '1') AND `Comment`.`object_id` = (12588) ORDER BY `created` DESC

SELECT `Timetable`.`id`, `Timetable`.`object`, `Timetable`.`object_id`, `Timetable`.`day`, `Timetable`.`start`, `Timetable`.`end`, `Timetable`.`user_id`, `Timetable`.`created`, `Timetable`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_timetables` AS `Timetable` WHERE `Timetable`.`object` = 'Service' AND `Timetable`.`object_id` = (468)

SELECT `Staff`.`id`, `Staff`.`name`, `Staff`.`surname`, `Staff`.`title`, `Staff`.`establishment_id`, `Staff`.`status`, `Staff`.`image`, `Staff`.`image_dir`, `Staff`.`experience`, `Staff`.`formation`, `Staff`.`professional_code`, `Staff`.`created`, `Staff`.`modified`, (CONCAT(`Staff`.`name`, " ", `Staff`.`surname`)) AS `Staff__fullname`, `ServicesStaff`.`id`, `ServicesStaff`.`service_id`, `ServicesStaff`.`staff_id`, `ServicesStaff`.`created`, `ServicesStaff`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_staffs` AS `Staff` JOIN `bkvtdvlfisiosite`.`fisiosite_services_staffs` AS `ServicesStaff` ON (`ServicesStaff`.`service_id` = 468 AND `ServicesStaff`.`staff_id` = `Staff`.`id`)

SELECT `News`.`id`, `News`.`user_id`, `News`.`establishment_id`, `News`.`title`, `News`.`description`, `News`.`canonical`, `News`.`image`, `News`.`image_dir`, `News`.`status`, `News`.`role`, `News`.`placement`, `News`.`created`, `News`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_news` AS `News` WHERE `News`.`status` = '1' AND `News`.`establishment_id` = (12588)

SELECT `Slide`.`id`, `Slide`.`model`, `Slide`.`foreign_key`, `Slide`.`name`, `Slide`.`attachment`, `Slide`.`dir`, `Slide`.`type`, `Slide`.`size`, `Slide`.`active` FROM `bkvtdvlfisiosite`.`fisiosite_attachments` AS `Slide` WHERE `Slide`.`model` = 'Establishment' AND `Slide`.`foreign_key` = (12588)

SELECT `Feature`.`id`, `Feature`.`feature_group_id`, `Feature`.`name`, `Feature`.`description`, `Feature`.`created`, `Feature`.`modified`, `EstablishmentsFeature`.`id`, `EstablishmentsFeature`.`establishment_id`, `EstablishmentsFeature`.`feature_id`, `EstablishmentsFeature`.`created`, `EstablishmentsFeature`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_features` AS `Feature` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_features` AS `EstablishmentsFeature` ON (`EstablishmentsFeature`.`establishment_id` = 12588 AND `EstablishmentsFeature`.`feature_id` = `Feature`.`id`)

SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `EstablishmentsSpecialty`.`id`, `EstablishmentsSpecialty`.`establishment_id`, `EstablishmentsSpecialty`.`specialty_id` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_specialties` AS `EstablishmentsSpecialty` ON (`EstablishmentsSpecialty`.`establishment_id` = 12588 AND `EstablishmentsSpecialty`.`specialty_id` = `Specialty`.`id`)

SELECT `Insurance`.`id`, `Insurance`.`name`, `Insurance`.`description`, `Insurance`.`slug`, `Insurance`.`featured`, `Insurance`.`created`, `Insurance`.`modified`, `EstablishmentsInsurance`.`id`, `EstablishmentsInsurance`.`establishment_id`, `EstablishmentsInsurance`.`insurance_id`, `EstablishmentsInsurance`.`created`, `EstablishmentsInsurance`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_insurances` AS `Insurance` JOIN `bkvtdvlfisiosite`.`fisiosite_establishments_insurances` AS `EstablishmentsInsurance` ON (`EstablishmentsInsurance`.`establishment_id` = 12588 AND `EstablishmentsInsurance`.`insurance_id` = `Insurance`.`id`)

SELECT `PopulationZone`.`id`, `PopulationZone`.`town`, `PopulationZone`.`state`, `PopulationZone`.`canonical`, `PopulationZone`.`canonical_town`, `PopulationZone`.`is_footer`, `PopulationZone`.`capital_population_id`, `PopulationZone`.`latitude_town`, `PopulationZone`.`longitude_town`, `PopulationEstablishment`.`id`, `PopulationEstablishment`.`establishment_id`, `PopulationEstablishment`.`population_id`, `PopulationEstablishment`.`created`, `PopulationEstablishment`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_populations` AS `PopulationZone` JOIN `bkvtdvlfisiosite`.`fisiosite_population_establishments` AS `PopulationEstablishment` ON (`PopulationEstablishment`.`establishment_id` = 12588 AND `PopulationEstablishment`.`population_id` = `PopulationZone`.`id`)

SELECT AVG( Rating.value ) as average, COUNT(`Rating`.`id`) AS valoraciones FROM `bkvtdvlfisiosite`.`fisiosite_ratings` AS `Rating` WHERE `Rating`.`foreign_key` = '12588' GROUP BY `Rating`.`foreign_key`

SELECT `Specialty`.`id`, `Specialty`.`name`, `Specialty`.`description`, `Specialty`.`slug`, `Specialty`.`featured`, `Specialty`.`created`, `Specialty`.`modified`, `CategoriesSpecialty`.`id`, `CategoriesSpecialty`.`specialty_id`, `CategoriesSpecialty`.`category_id`, `CategoriesSpecialty`.`created`, `CategoriesSpecialty`.`modified` FROM `bkvtdvlfisiosite`.`fisiosite_specialties` AS `Specialty` JOIN `bkvtdvlfisiosite`.`fisiosite_categories_specialties` AS `CategoriesSpecialty` ON (`CategoriesSpecialty`.`category_id` = 1 AND `CategoriesSpecialty`.`specialty_id` = `Specialty`.`id`)

SELECT `SeoMeta`.`id`, `SeoMeta`.`url`, `SeoMeta`.`title`, `SeoMeta`.`description`, `SeoMeta`.`keywords` FROM `bkvtdvlfisiosite`.`fisiosite_seo_metas` AS `SeoMeta` WHERE ((`url` = 'fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos') OR (CONCAT('/',url) = '/fisioterapia/castrillon/clinica-de-prueba-para-extraccion-de-datos')) LIMIT 1

Clinica de Prueba para extracción de datos

Nuestros Partners