object(Cake\ORM\Query) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT Company.pr_title AS Company__pr_title, Company.pr_body AS Company__pr_body, Company.updated AS Company__updated, Company.main_image AS Company__main_image, Company.appeal_label AS Company__appeal_label, Company.appeal_text AS Company__appeal_text, Company.senior_voice_label1 AS Company__senior_voice_label1, Company.senior_voice_text1 AS Company__senior_voice_text1, Company.senior_voice_img1 AS Company__senior_voice_img1, Company.senior_voice_label2 AS Company__senior_voice_label2, Company.senior_voice_text2 AS Company__senior_voice_text2, Company.senior_voice_img2 AS Company__senior_voice_img2, Company.senior_voice_label3 AS Company__senior_voice_label3, Company.senior_voice_text3 AS Company__senior_voice_text3, Company.senior_voice_img3 AS Company__senior_voice_img3, Company.business_desc AS Company__business_desc, Company.recruit_desc AS Company__recruit_desc, Company.employ_desc AS Company__employ_desc, Company.apply_desc AS Company__apply_desc, Company.address1 AS Company__address1, Company.address2 AS Company__address2, Company.address3 AS Company__address3, Company.address4 AS Company__address4, Company.work_time AS Company__work_time, Company.salary_type AS Company__salary_type, Company.salary AS Company__salary, Company.treatment AS Company__treatment, Company.holiday AS Company__holiday, Company.loan AS Company__loan, Company.apply_tel AS Company__apply_tel, Company.apply_howto AS Company__apply_howto, Company.apply_message AS Company__apply_message, Company.work_type1 AS Company__work_type1, Company.work_type1_notice AS Company__work_type1_notice, Company.work_type2 AS Company__work_type2, Company.work_type2_notice AS Company__work_type2_notice, Company.work_type3 AS Company__work_type3, Company.work_type3_notice AS Company__work_type3_notice, Company.appeal_sub_text1 AS Company__appeal_sub_text1, Company.appeal_sub_img1 AS Company__appeal_sub_img1, Company.appeal_sub_text2 AS Company__appeal_sub_text2, Company.appeal_sub_img2 AS Company__appeal_sub_img2, Company.seo_title1 AS Company__seo_title1, Company.seo_desc1 AS Company__seo_desc1, Company.seo_keyword1 AS Company__seo_keyword1, Company.seo_h1_1 AS Company__seo_h1_1, Company.built_date_text AS Company__built_date_text, Company.representative AS Company__representative, Company.capital AS Company__capital, Company.num_cars AS Company__num_cars, Company.num_employees AS Company__num_employees, Company.office AS Company__office, Company.access_train AS Company__access_train, RegionCode.description AS RegionCode__description, RegionCode.city_name AS RegionCode__city_name, Prefecture.name AS Prefecture__name, Prefecture.name_en AS Prefecture__name_en, LocalArea.name_en AS LocalArea__name_en, Pickup2.id AS Pickup2__id, Company.id AS Company__id, Company.name AS Company__name, Company.sales_name AS Company__sales_name, Company.catch_text AS Company__catch_text, Company.thumb_image AS Company__thumb_image, CompanyAppeal.template_type AS CompanyAppeal__template_type, Company.movie_id1 AS Company__movie_id1, Company.movie_id2 AS Company__movie_id2, Company.movie_id3 AS Company__movie_id3, Company.movie_id4 AS Company__movie_id4, Company.preview_flg AS Company__preview_flg, Company.lp_img1 AS Company__lp_img1, Company.publish_plan1_id AS Company__publish_plan1_id, Company.publish_plan2_id AS Company__publish_plan2_id, Company.freetel AS Company__freetel, Company.salary_amount AS Company__salary_amount, Company.lat AS Company__lat, Company.lng AS Company__lng, RadioGroup.name AS RadioGroup__name, Company.public_taiken AS Company__public_taiken, Company.taiken_id AS Company__taiken_id, CompanySalesGroup.logo_image AS CompanySalesGroup__logo_image, Company.info AS Company__info, Company.search_condition46 AS Company__search_condition46, Company.search_condition7 AS Company__search_condition7, Company.search_condition27 AS Company__search_condition27, Company.search_condition2 AS Company__search_condition2, Company.search_condition28 AS Company__search_condition28, Company.search_condition3 AS Company__search_condition3, Company.search_condition8 AS Company__search_condition8, Company.search_condition1 AS Company__search_condition1, Company.search_condition29 AS Company__search_condition29, Company.search_condition30 AS Company__search_condition30, Company.search_condition15 AS Company__search_condition15, Company.search_condition31 AS Company__search_condition31, Company.search_condition10 AS Company__search_condition10, Company.search_condition32 AS Company__search_condition32, Company.search_condition12 AS Company__search_condition12, Company.search_condition33 AS Company__search_condition33, Company.search_condition20 AS Company__search_condition20, Company.search_condition21 AS Company__search_condition21, Company.search_condition34 AS Company__search_condition34, Company.search_condition24 AS Company__search_condition24, Company.search_condition25 AS Company__search_condition25, Company.search_condition26 AS Company__search_condition26, Company.search_condition35 AS Company__search_condition35, Company.search_condition36 AS Company__search_condition36, Company.search_condition22 AS Company__search_condition22, Company.search_condition37 AS Company__search_condition37, Company.search_condition14 AS Company__search_condition14, Company.search_condition23 AS Company__search_condition23, Company.search_condition19 AS Company__search_condition19, Company.search_condition40 AS Company__search_condition40, Company.search_condition41 AS Company__search_condition41, Company.search_condition39 AS Company__search_condition39, Company.search_condition42 AS Company__search_condition42, Company.search_condition43 AS Company__search_condition43, Company.search_condition44 AS Company__search_condition44, Company.search_condition45 AS Company__search_condition45, Company.search_condition11 AS Company__search_condition11, Company.search_condition38 AS Company__search_condition38 FROM company Company LEFT JOIN company_appeal CompanyAppeal ON Company.id = (CompanyAppeal.company_id) LEFT JOIN radio_group RadioGroup ON RadioGroup.id = (Company.radio_group_id) LEFT JOIN company_sales_group CompanySalesGroup ON CompanySalesGroup.id = (Company.sales_group_id) WHERE (Company.public_flg = :c0 AND Company.public_end_flg = :c1 AND Company.id = :c2) LIMIT 1'
'params' => [
':c0' => [
'value' => (int) 0,
'type' => 'integer',
'placeholder' => 'c0',
],
':c1' => [
'value' => (int) 1,
'type' => 'boolean',
'placeholder' => 'c1',
],
':c2' => [
'value' => '4541',
'type' => 'integer',
'placeholder' => 'c2',
],
]
'defaultTypes' => [
'Company__id' => 'integer',
'Company.id' => 'integer',
'id' => 'integer',
'Company__login_id' => 'string',
'Company.login_id' => 'string',
'login_id' => 'string',
'Company__password' => 'string',
'Company.password' => 'string',
'password' => 'string',
'Company__name' => 'string',
'Company.name' => 'string',
'name' => 'string',
'Company__sales_name' => 'string',
'Company.sales_name' => 'string',
'sales_name' => 'string',
'Company__entry_email1' => 'string',
'Company.entry_email1' => 'string',
'entry_email1' => 'string',
'Company__entry_email2' => 'string',
'Company.entry_email2' => 'string',
'entry_email2' => 'string',
'Company__entry_email3' => 'string',
'Company.entry_email3' => 'string',
'entry_email3' => 'string',
'Company__entry_email4' => 'string',
'Company.entry_email4' => 'string',
'entry_email4' => 'string',
'Company__tel' => 'string',
'Company.tel' => 'string',
'tel' => 'string',
'Company__freetel' => 'tinyinteger',
'Company.freetel' => 'tinyinteger',
'freetel' => 'tinyinteger',
'Company__publish_plan1_id' => 'integer',
'Company.publish_plan1_id' => 'integer',
'publish_plan1_id' => 'integer',
'Company__publish_plan2_id' => 'integer',
'Company.publish_plan2_id' => 'integer',
'publish_plan2_id' => 'integer',
'Company__switch_message' => 'boolean',
'Company.switch_message' => 'boolean',
'switch_message' => 'boolean',
'Company__public_flg' => 'integer',
'Company.public_flg' => 'integer',
'public_flg' => 'integer',
'Company__public_pc_flg' => 'integer',
'Company.public_pc_flg' => 'integer',
'public_pc_flg' => 'integer',
'Company__public_smp_flg' => 'integer',
'Company.public_smp_flg' => 'integer',
'public_smp_flg' => 'integer',
'Company__public_mobile_flg' => 'integer',
'Company.public_mobile_flg' => 'integer',
'public_mobile_flg' => 'integer',
'Company__public_work_flg' => 'integer',
'Company.public_work_flg' => 'integer',
'public_work_flg' => 'integer',
'Company__public_call_flg' => 'integer',
'Company.public_call_flg' => 'integer',
'public_call_flg' => 'integer',
'Company__preview_flg' => 'integer',
'Company.preview_flg' => 'integer',
'preview_flg' => 'integer',
'Company__public_end_flg' => 'boolean',
'Company.public_end_flg' => 'boolean',
'public_end_flg' => 'boolean',
'Company__radio_group_id' => 'integer',
'Company.radio_group_id' => 'integer',
'radio_group_id' => 'integer',
'Company__pr_title' => 'text',
'Company.pr_title' => 'text',
'pr_title' => 'text',
'Company__pr_body' => 'text',
'Company.pr_body' => 'text',
'pr_body' => 'text',
'Company__catch_text' => 'text',
'Company.catch_text' => 'text',
'catch_text' => 'text',
'Company__thumb_image' => 'string',
'Company.thumb_image' => 'string',
'thumb_image' => 'string',
'Company__main_image' => 'string',
'Company.main_image' => 'string',
'main_image' => 'string',
'Company__pickup5_image' => 'string',
'Company.pickup5_image' => 'string',
'pickup5_image' => 'string',
'Company__sales_group_id' => 'integer',
'Company.sales_group_id' => 'integer',
'sales_group_id' => 'integer',
'Company__seo_title1' => 'text',
'Company.seo_title1' => 'text',
'seo_title1' => 'text',
'Company__seo_title2' => 'text',
'Company.seo_title2' => 'text',
'seo_title2' => 'text',
'Company__seo_title3' => 'text',
'Company.seo_title3' => 'text',
'seo_title3' => 'text',
'Company__seo_title4' => 'text',
'Company.seo_title4' => 'text',
'seo_title4' => 'text',
'Company__seo_title5' => 'text',
'Company.seo_title5' => 'text',
'seo_title5' => 'text',
'Company__seo_desc1' => 'text',
'Company.seo_desc1' => 'text',
'seo_desc1' => 'text',
'Company__seo_desc2' => 'text',
'Company.seo_desc2' => 'text',
'seo_desc2' => 'text',
'Company__seo_desc3' => 'text',
'Company.seo_desc3' => 'text',
'seo_desc3' => 'text',
'Company__seo_desc4' => 'text',
'Company.seo_desc4' => 'text',
'seo_desc4' => 'text',
'Company__seo_desc5' => 'text',
'Company.seo_desc5' => 'text',
'seo_desc5' => 'text',
'Company__seo_keyword1' => 'text',
'Company.seo_keyword1' => 'text',
'seo_keyword1' => 'text',
'Company__seo_keyword2' => 'text',
'Company.seo_keyword2' => 'text',
'seo_keyword2' => 'text',
'Company__seo_keyword3' => 'text',
'Company.seo_keyword3' => 'text',
'seo_keyword3' => 'text',
'Company__seo_keyword4' => 'text',
'Company.seo_keyword4' => 'text',
'seo_keyword4' => 'text',
'Company__seo_keyword5' => 'text',
'Company.seo_keyword5' => 'text',
'seo_keyword5' => 'text',
'Company__seo_h1_1' => 'text',
'Company.seo_h1_1' => 'text',
'seo_h1_1' => 'text',
'Company__seo_h1_2' => 'text',
'Company.seo_h1_2' => 'text',
'seo_h1_2' => 'text',
'Company__seo_h1_3' => 'text',
'Company.seo_h1_3' => 'text',
'seo_h1_3' => 'text',
'Company__seo_h1_4' => 'text',
'Company.seo_h1_4' => 'text',
'seo_h1_4' => 'text',
'Company__seo_h1_5' => 'text',
'Company.seo_h1_5' => 'text',
'seo_h1_5' => 'text',
'Company__movie_id1' => 'string',
'Company.movie_id1' => 'string',
'movie_id1' => 'string',
'Company__movie_title1' => 'string',
'Company.movie_title1' => 'string',
'movie_title1' => 'string',
'Company__movie_text1' => 'text',
'Company.movie_text1' => 'text',
'movie_text1' => 'text',
'Company__movie_id2' => 'string',
'Company.movie_id2' => 'string',
'movie_id2' => 'string',
'Company__movie_title2' => 'string',
'Company.movie_title2' => 'string',
'movie_title2' => 'string',
'Company__movie_text2' => 'text',
'Company.movie_text2' => 'text',
'movie_text2' => 'text',
'Company__movie_id3' => 'string',
'Company.movie_id3' => 'string',
'movie_id3' => 'string',
'Company__movie_title3' => 'string',
'Company.movie_title3' => 'string',
'movie_title3' => 'string',
'Company__movie_text3' => 'text',
'Company.movie_text3' => 'text',
'movie_text3' => 'text',
'Company__movie_id4' => 'string',
'Company.movie_id4' => 'string',
'movie_id4' => 'string',
'Company__movie_title4' => 'string',
'Company.movie_title4' => 'string',
'movie_title4' => 'string',
'Company__movie_text4' => 'text',
'Company.movie_text4' => 'text',
'movie_text4' => 'text',
'Company__search_condition1' => 'integer',
'Company.search_condition1' => 'integer',
'search_condition1' => 'integer',
'Company__search_condition2' => 'integer',
'Company.search_condition2' => 'integer',
'search_condition2' => 'integer',
'Company__search_condition3' => 'integer',
'Company.search_condition3' => 'integer',
'search_condition3' => 'integer',
'Company__search_condition4' => 'integer',
'Company.search_condition4' => 'integer',
'search_condition4' => 'integer',
'Company__search_condition5' => 'integer',
'Company.search_condition5' => 'integer',
'search_condition5' => 'integer',
'Company__search_condition6' => 'integer',
'Company.search_condition6' => 'integer',
'search_condition6' => 'integer',
'Company__search_condition7' => 'integer',
'Company.search_condition7' => 'integer',
'search_condition7' => 'integer',
'Company__search_condition8' => 'integer',
'Company.search_condition8' => 'integer',
'search_condition8' => 'integer',
'Company__search_condition9' => 'integer',
'Company.search_condition9' => 'integer',
'search_condition9' => 'integer',
'Company__search_condition10' => 'integer',
'Company.search_condition10' => 'integer',
'search_condition10' => 'integer',
'Company__search_condition11' => 'integer',
'Company.search_condition11' => 'integer',
'search_condition11' => 'integer',
'Company__search_condition12' => 'integer',
'Company.search_condition12' => 'integer',
'search_condition12' => 'integer',
'Company__search_condition13' => 'integer',
'Company.search_condition13' => 'integer',
'search_condition13' => 'integer',
'Company__search_condition14' => 'integer',
'Company.search_condition14' => 'integer',
'search_condition14' => 'integer',
'Company__search_condition15' => 'integer',
'Company.search_condition15' => 'integer',
'search_condition15' => 'integer',
'Company__search_condition16' => 'integer',
'Company.search_condition16' => 'integer',
'search_condition16' => 'integer',
'Company__search_condition17' => 'integer',
'Company.search_condition17' => 'integer',
'search_condition17' => 'integer',
'Company__search_condition18' => 'integer',
'Company.search_condition18' => 'integer',
'search_condition18' => 'integer',
'Company__search_condition19' => 'integer',
'Company.search_condition19' => 'integer',
'search_condition19' => 'integer',
'Company__search_condition20' => 'integer',
'Company.search_condition20' => 'integer',
'search_condition20' => 'integer',
'Company__search_condition21' => 'integer',
'Company.search_condition21' => 'integer',
'search_condition21' => 'integer',
'Company__search_condition22' => 'integer',
'Company.search_condition22' => 'integer',
'search_condition22' => 'integer',
'Company__search_condition23' => 'integer',
'Company.search_condition23' => 'integer',
'search_condition23' => 'integer',
'Company__search_condition24' => 'integer',
'Company.search_condition24' => 'integer',
'search_condition24' => 'integer',
'Company__search_condition25' => 'integer',
'Company.search_condition25' => 'integer',
'search_condition25' => 'integer',
'Company__search_condition26' => 'integer',
'Company.search_condition26' => 'integer',
'search_condition26' => 'integer',
'Company__search_condition27' => 'integer',
'Company.search_condition27' => 'integer',
'search_condition27' => 'integer',
'Company__search_condition28' => 'integer',
'Company.search_condition28' => 'integer',
'search_condition28' => 'integer',
'Company__search_condition29' => 'integer',
'Company.search_condition29' => 'integer',
'search_condition29' => 'integer',
'Company__search_condition30' => 'integer',
'Company.search_condition30' => 'integer',
'search_condition30' => 'integer',
'Company__search_condition31' => 'integer',
'Company.search_condition31' => 'integer',
'search_condition31' => 'integer',
'Company__search_condition32' => 'integer',
'Company.search_condition32' => 'integer',
'search_condition32' => 'integer',
'Company__search_condition33' => 'integer',
'Company.search_condition33' => 'integer',
'search_condition33' => 'integer',
'Company__search_condition34' => 'integer',
'Company.search_condition34' => 'integer',
'search_condition34' => 'integer',
'Company__search_condition35' => 'integer',
'Company.search_condition35' => 'integer',
'search_condition35' => 'integer',
'Company__search_condition36' => 'integer',
'Company.search_condition36' => 'integer',
'search_condition36' => 'integer',
'Company__search_condition37' => 'integer',
'Company.search_condition37' => 'integer',
'search_condition37' => 'integer',
'Company__search_condition38' => 'integer',
'Company.search_condition38' => 'integer',
'search_condition38' => 'integer',
'Company__search_condition39' => 'integer',
'Company.search_condition39' => 'integer',
'search_condition39' => 'integer',
'Company__search_condition40' => 'integer',
'Company.search_condition40' => 'integer',
'search_condition40' => 'integer',
'Company__search_condition41' => 'integer',
'Company.search_condition41' => 'integer',
'search_condition41' => 'integer',
'Company__search_condition42' => 'integer',
'Company.search_condition42' => 'integer',
'search_condition42' => 'integer',
'Company__search_condition43' => 'integer',
'Company.search_condition43' => 'integer',
'search_condition43' => 'integer',
'Company__search_condition44' => 'integer',
'Company.search_condition44' => 'integer',
'search_condition44' => 'integer',
'Company__search_condition45' => 'integer',
'Company.search_condition45' => 'integer',
'search_condition45' => 'integer',
'Company__search_condition46' => 'integer',
'Company.search_condition46' => 'integer',
'search_condition46' => 'integer',
'Company__search_condition47' => 'integer',
'Company.search_condition47' => 'integer',
'search_condition47' => 'integer',
'Company__appeal_label' => 'text',
'Company.appeal_label' => 'text',
'appeal_label' => 'text',
'Company__appeal_text' => 'text',
'Company.appeal_text' => 'text',
'appeal_text' => 'text',
'Company__senior_voice_label1' => 'text',
'Company.senior_voice_label1' => 'text',
'senior_voice_label1' => 'text',
'Company__senior_voice_text1' => 'text',
'Company.senior_voice_text1' => 'text',
'senior_voice_text1' => 'text',
'Company__senior_voice_img1' => 'string',
'Company.senior_voice_img1' => 'string',
'senior_voice_img1' => 'string',
'Company__senior_voice_year_work1' => 'string',
'Company.senior_voice_year_work1' => 'string',
'senior_voice_year_work1' => 'string',
'Company__senior_voice_name1' => 'string',
'Company.senior_voice_name1' => 'string',
'senior_voice_name1' => 'string',
'Company__senior_voice_movie1' => 'string',
'Company.senior_voice_movie1' => 'string',
'senior_voice_movie1' => 'string',
'Company__senior_voice_label2' => 'text',
'Company.senior_voice_label2' => 'text',
'senior_voice_label2' => 'text',
'Company__senior_voice_text2' => 'text',
'Company.senior_voice_text2' => 'text',
'senior_voice_text2' => 'text',
'Company__senior_voice_img2' => 'string',
'Company.senior_voice_img2' => 'string',
'senior_voice_img2' => 'string',
'Company__senior_voice_year_work2' => 'string',
'Company.senior_voice_year_work2' => 'string',
'senior_voice_year_work2' => 'string',
'Company__senior_voice_name2' => 'string',
'Company.senior_voice_name2' => 'string',
'senior_voice_name2' => 'string',
'Company__senior_voice_movie2' => 'string',
'Company.senior_voice_movie2' => 'string',
'senior_voice_movie2' => 'string',
'Company__senior_voice_label3' => 'text',
'Company.senior_voice_label3' => 'text',
'senior_voice_label3' => 'text',
'Company__senior_voice_text3' => 'text',
'Company.senior_voice_text3' => 'text',
'senior_voice_text3' => 'text',
'Company__senior_voice_img3' => 'string',
'Company.senior_voice_img3' => 'string',
'senior_voice_img3' => 'string',
'Company__senior_voice_year_work3' => 'string',
'Company.senior_voice_year_work3' => 'string',
'senior_voice_year_work3' => 'string',
'Company__senior_voice_name3' => 'string',
'Company.senior_voice_name3' => 'string',
'senior_voice_name3' => 'string',
'Company__senior_voice_movie3' => 'string',
'Company.senior_voice_movie3' => 'string',
'senior_voice_movie3' => 'string',
'Company__business_desc' => 'text',
'Company.business_desc' => 'text',
'business_desc' => 'text',
'Company__app_requirements' => 'text',
'Company.app_requirements' => 'text',
'app_requirements' => 'text',
'Company__recruit_desc' => 'text',
'Company.recruit_desc' => 'text',
'recruit_desc' => 'text',
'Company__employ_desc' => 'text',
'Company.employ_desc' => 'text',
'employ_desc' => 'text',
'Company__apply_desc' => 'text',
'Company.apply_desc' => 'text',
'apply_desc' => 'text',
'Company__postal_code' => 'string',
'Company.postal_code' => 'string',
'postal_code' => 'string',
'Company__address1' => 'integer',
'Company.address1' => 'integer',
'address1' => 'integer',
'Company__address2' => 'string',
'Company.address2' => 'string',
'address2' => 'string',
'Company__address3' => 'string',
'Company.address3' => 'string',
'address3' => 'string',
'Company__address4' => 'string',
'Company.address4' => 'string',
'address4' => 'string',
'Company__district' => 'string',
'Company.district' => 'string',
'district' => 'string',
'Company__lng' => 'string',
'Company.lng' => 'string',
'lng' => 'string',
'Company__lat' => 'string',
'Company.lat' => 'string',
'lat' => 'string',
'Company__work_time' => 'text',
'Company.work_time' => 'text',
'work_time' => 'text',
'Company__salary_type' => 'string',
'Company.salary_type' => 'string',
'salary_type' => 'string',
'Company__salary' => 'text',
'Company.salary' => 'text',
'salary' => 'text',
'Company__salary_amount' => 'integer',
'Company.salary_amount' => 'integer',
'salary_amount' => 'integer',
'Company__treatment' => 'text',
'Company.treatment' => 'text',
'treatment' => 'text',
'Company__holiday' => 'text',
'Company.holiday' => 'text',
'holiday' => 'text',
'Company__loan' => 'text',
'Company.loan' => 'text',
'loan' => 'text',
'Company__apply_tel' => 'string',
'Company.apply_tel' => 'string',
'apply_tel' => 'string',
'Company__apply_howto' => 'text',
'Company.apply_howto' => 'text',
'apply_howto' => 'text',
'Company__apply_message' => 'text',
'Company.apply_message' => 'text',
'apply_message' => 'text',
'Company__work_type1' => 'string',
'Company.work_type1' => 'string',
'work_type1' => 'string',
'Company__work_type1_notice' => 'text',
'Company.work_type1_notice' => 'text',
'work_type1_notice' => 'text',
'Company__work_type2' => 'string',
'Company.work_type2' => 'string',
'work_type2' => 'string',
'Company__work_type2_notice' => 'text',
'Company.work_type2_notice' => 'text',
'work_type2_notice' => 'text',
'Company__work_type3' => 'string',
'Company.work_type3' => 'string',
'work_type3' => 'string',
'Company__work_type3_notice' => 'text',
'Company.work_type3_notice' => 'text',
'work_type3_notice' => 'text',
'Company__appeal_sub_text1' => 'text',
'Company.appeal_sub_text1' => 'text',
'appeal_sub_text1' => 'text',
'Company__appeal_sub_img1' => 'string',
'Company.appeal_sub_img1' => 'string',
'appeal_sub_img1' => 'string',
'Company__appeal_sub_text2' => 'text',
'Company.appeal_sub_text2' => 'text',
'appeal_sub_text2' => 'text',
'Company__appeal_sub_img2' => 'string',
'Company.appeal_sub_img2' => 'string',
'appeal_sub_img2' => 'string',
'Company__sort_num' => 'integer',
'Company.sort_num' => 'integer',
'sort_num' => 'integer',
'Company__profile_img1' => 'string',
'Company.profile_img1' => 'string',
'profile_img1' => 'string',
'Company__profile_desc1' => 'text',
'Company.profile_desc1' => 'text',
'profile_desc1' => 'text',
'Company__profile_img2' => 'string',
'Company.profile_img2' => 'string',
'profile_img2' => 'string',
'Company__profile_desc2' => 'text',
'Company.profile_desc2' => 'text',
'profile_desc2' => 'text',
'Company__profile_img3' => 'string',
'Company.profile_img3' => 'string',
'profile_img3' => 'string',
'Company__profile_desc3' => 'text',
'Company.profile_desc3' => 'text',
'profile_desc3' => 'text',
'Company__profile_img4' => 'string',
'Company.profile_img4' => 'string',
'profile_img4' => 'string',
'Company__profile_desc4' => 'text',
'Company.profile_desc4' => 'text',
'profile_desc4' => 'text',
'Company__built_date_text' => 'text',
'Company.built_date_text' => 'text',
'built_date_text' => 'text',
'Company__representative' => 'text',
'Company.representative' => 'text',
'representative' => 'text',
'Company__capital' => 'text',
'Company.capital' => 'text',
'capital' => 'text',
'Company__sales' => 'text',
'Company.sales' => 'text',
'sales' => 'text',
'Company__num_cars' => 'text',
'Company.num_cars' => 'text',
'num_cars' => 'text',
'Company__num_employees' => 'text',
'Company.num_employees' => 'text',
'num_employees' => 'text',
'Company__office' => 'text',
'Company.office' => 'text',
'office' => 'text',
'Company__pc_url' => 'text',
'Company.pc_url' => 'text',
'pc_url' => 'text',
'Company__one_message_person' => 'text',
'Company.one_message_person' => 'text',
'one_message_person' => 'text',
'Company__one_message_head' => 'text',
'Company.one_message_head' => 'text',
'one_message_head' => 'text',
'Company__one_message_text' => 'text',
'Company.one_message_text' => 'text',
'one_message_text' => 'text',
'Company__one_message_img' => 'string',
'Company.one_message_img' => 'string',
'one_message_img' => 'string',
'Company__access_train' => 'text',
'Company.access_train' => 'text',
'access_train' => 'text',
'Company__access_bus' => 'text',
'Company.access_bus' => 'text',
'access_bus' => 'text',
'Company__access_other' => 'text',
'Company.access_other' => 'text',
'access_other' => 'text',
'Company__scout_point' => 'integer',
'Company.scout_point' => 'integer',
'scout_point' => 'integer',
'Company__job_merit' => 'integer',
'Company.job_merit' => 'integer',
'job_merit' => 'integer',
'Company__chart1' => 'integer',
'Company.chart1' => 'integer',
'chart1' => 'integer',
'Company__chart2' => 'integer',
'Company.chart2' => 'integer',
'chart2' => 'integer',
'Company__chart3' => 'integer',
'Company.chart3' => 'integer',
'chart3' => 'integer',
'Company__chart4' => 'integer',
'Company.chart4' => 'integer',
'chart4' => 'integer',
'Company__chart5' => 'integer',
'Company.chart5' => 'integer',
'chart5' => 'integer',
'Company__lp_img1' => 'string',
'Company.lp_img1' => 'string',
'lp_img1' => 'string',
'Company__lp_img2' => 'string',
'Company.lp_img2' => 'string',
'lp_img2' => 'string',
'Company__lp_img3' => 'string',
'Company.lp_img3' => 'string',
'lp_img3' => 'string',
'Company__lp_img4' => 'string',
'Company.lp_img4' => 'string',
'lp_img4' => 'string',
'Company__c_workshop' => 'text',
'Company.c_workshop' => 'text',
'c_workshop' => 'text',
'Company__c_summary' => 'text',
'Company.c_summary' => 'text',
'c_summary' => 'text',
'Company__c_accsess' => 'text',
'Company.c_accsess' => 'text',
'c_accsess' => 'text',
'Company__c_mobilesite' => 'text',
'Company.c_mobilesite' => 'text',
'c_mobilesite' => 'text',
'Company__c_charge' => 'text',
'Company.c_charge' => 'text',
'c_charge' => 'text',
'Company__c_plan' => 'text',
'Company.c_plan' => 'text',
'c_plan' => 'text',
'Company__c_ex' => 'text',
'Company.c_ex' => 'text',
'c_ex' => 'text',
'Company__c_logosingle' => 'integer',
'Company.c_logosingle' => 'integer',
'c_logosingle' => 'integer',
'Company__c_originalmap' => 'integer',
'Company.c_originalmap' => 'integer',
'c_originalmap' => 'integer',
'Company__c_calltel' => 'text',
'Company.c_calltel' => 'text',
'c_calltel' => 'text',
'Company__c_hire' => 'integer',
'Company.c_hire' => 'integer',
'c_hire' => 'integer',
'Company__c_area' => 'text',
'Company.c_area' => 'text',
'c_area' => 'text',
'Company__c_pcedit' => 'integer',
'Company.c_pcedit' => 'integer',
'c_pcedit' => 'integer',
'Company__c_worktype2f' => 'tinyinteger',
'Company.c_worktype2f' => 'tinyinteger',
'c_worktype2f' => 'tinyinteger',
'Company__c_movie' => 'integer',
'Company.c_movie' => 'integer',
'c_movie' => 'integer',
'Company__point_image' => 'string',
'Company.point_image' => 'string',
'point_image' => 'string',
'Company__point' => 'string',
'Company.point' => 'string',
'point' => 'string',
'Company__created' => 'datetime',
'Company.created' => 'datetime',
'created' => 'datetime',
'Company__updated' => 'datetime',
'Company.updated' => 'datetime',
'updated' => 'datetime',
'Company__last_edit' => 'datetime',
'Company.last_edit' => 'datetime',
'last_edit' => 'datetime',
'Company__chiebukuro_alert' => 'integer',
'Company.chiebukuro_alert' => 'integer',
'chiebukuro_alert' => 'integer',
'Company__public_taiken' => 'boolean',
'Company.public_taiken' => 'boolean',
'public_taiken' => 'boolean',
'Company__taiken_id' => 'string',
'Company.taiken_id' => 'string',
'taiken_id' => 'string',
'Company__info' => 'text',
'Company.info' => 'text',
'info' => 'text',
'Company__group_id' => 'integer',
'Company.group_id' => 'integer',
'group_id' => 'integer',
'Company__year_fee' => 'integer',
'Company.year_fee' => 'integer',
'year_fee' => 'integer',
'Company__top5_fee' => 'integer',
'Company.top5_fee' => 'integer',
'top5_fee' => 'integer',
'Company__entrypage_flg' => 'boolean',
'Company.entrypage_flg' => 'boolean',
'entrypage_flg' => 'boolean',
'Company__iole_flg' => 'boolean',
'Company.iole_flg' => 'boolean',
'iole_flg' => 'boolean',
'Company__jobbox_flg' => 'boolean',
'Company.jobbox_flg' => 'boolean',
'jobbox_flg' => 'boolean',
'Company__google_feed_flg' => 'boolean',
'Company.google_feed_flg' => 'boolean',
'google_feed_flg' => 'boolean',
'Company__shigoto_flg' => 'boolean',
'Company.shigoto_flg' => 'boolean',
'shigoto_flg' => 'boolean',
'Company__indeed_flg' => 'tinyinteger',
'Company.indeed_flg' => 'tinyinteger',
'indeed_flg' => 'tinyinteger',
'Company__contract_start' => 'timestamp',
'Company.contract_start' => 'timestamp',
'contract_start' => 'timestamp',
'Company__contract_end' => 'timestamp',
'Company.contract_end' => 'timestamp',
'contract_end' => 'timestamp',
'Company__contract_plan' => 'integer',
'Company.contract_plan' => 'integer',
'contract_plan' => 'integer',
'Company__view' => 'biginteger',
'Company.view' => 'biginteger',
'view' => 'biginteger',
'Company__tanka_rank' => 'string',
'Company.tanka_rank' => 'string',
'tanka_rank' => 'string',
'Company__social_media' => 'text',
'Company.social_media' => 'text',
'social_media' => 'text',
'Company__note' => 'text',
'Company.note' => 'text',
'note' => 'text',
'Company__contractor' => 'string',
'Company.contractor' => 'string',
'contractor' => 'string',
'Company__annual_fee' => 'decimal',
'Company.annual_fee' => 'decimal',
'annual_fee' => 'decimal',
'Company__monthly_charge' => 'integer',
'Company.monthly_charge' => 'integer',
'monthly_charge' => 'integer',
'Company__contract_memo' => 'text',
'Company.contract_memo' => 'text',
'contract_memo' => 'text',
'Company__google_index_status' => 'tinyinteger',
'Company.google_index_status' => 'tinyinteger',
'google_index_status' => 'tinyinteger',
'CompanyAppeal__id' => 'integer',
'CompanyAppeal.id' => 'integer',
'CompanyAppeal__company_id' => 'integer',
'CompanyAppeal.company_id' => 'integer',
'company_id' => 'integer',
'CompanyAppeal__template_type' => 'integer',
'CompanyAppeal.template_type' => 'integer',
'template_type' => 'integer',
'CompanyAppeal__title' => 'string',
'CompanyAppeal.title' => 'string',
'title' => 'string',
'CompanyAppeal__tpl1_head1' => 'string',
'CompanyAppeal.tpl1_head1' => 'string',
'tpl1_head1' => 'string',
'CompanyAppeal__tpl1_text1' => 'text',
'CompanyAppeal.tpl1_text1' => 'text',
'tpl1_text1' => 'text',
'CompanyAppeal__tpl1_img1' => 'string',
'CompanyAppeal.tpl1_img1' => 'string',
'tpl1_img1' => 'string',
'CompanyAppeal__tpl1_head2' => 'string',
'CompanyAppeal.tpl1_head2' => 'string',
'tpl1_head2' => 'string',
'CompanyAppeal__tpl1_text2' => 'text',
'CompanyAppeal.tpl1_text2' => 'text',
'tpl1_text2' => 'text',
'CompanyAppeal__tpl1_img2' => 'string',
'CompanyAppeal.tpl1_img2' => 'string',
'tpl1_img2' => 'string',
'CompanyAppeal__tpl1_head3' => 'string',
'CompanyAppeal.tpl1_head3' => 'string',
'tpl1_head3' => 'string',
'CompanyAppeal__tpl1_text3' => 'text',
'CompanyAppeal.tpl1_text3' => 'text',
'tpl1_text3' => 'text',
'CompanyAppeal__tpl1_img3' => 'string',
'CompanyAppeal.tpl1_img3' => 'string',
'tpl1_img3' => 'string',
'CompanyAppeal__tpl2_head1' => 'string',
'CompanyAppeal.tpl2_head1' => 'string',
'tpl2_head1' => 'string',
'CompanyAppeal__tpl2_text1' => 'text',
'CompanyAppeal.tpl2_text1' => 'text',
'tpl2_text1' => 'text',
'CompanyAppeal__tpl2_img1' => 'string',
'CompanyAppeal.tpl2_img1' => 'string',
'tpl2_img1' => 'string',
'CompanyAppeal__tpl2_head2' => 'string',
'CompanyAppeal.tpl2_head2' => 'string',
'tpl2_head2' => 'string',
'CompanyAppeal__tpl2_text2' => 'text',
'CompanyAppeal.tpl2_text2' => 'text',
'tpl2_text2' => 'text',
'CompanyAppeal__tpl2_img2' => 'string',
'CompanyAppeal.tpl2_img2' => 'string',
'tpl2_img2' => 'string',
'CompanyAppeal__tpl3_head1' => 'string',
'CompanyAppeal.tpl3_head1' => 'string',
'tpl3_head1' => 'string',
'CompanyAppeal__tpl3_text1' => 'text',
'CompanyAppeal.tpl3_text1' => 'text',
'tpl3_text1' => 'text',
'CompanyAppeal__tpl3_img1' => 'string',
'CompanyAppeal.tpl3_img1' => 'string',
'tpl3_img1' => 'string',
'CompanyAppeal__created' => 'datetime',
'CompanyAppeal.created' => 'datetime',
'CompanyAppeal__updated' => 'datetime',
'CompanyAppeal.updated' => 'datetime',
'RadioGroup__id' => 'integer',
'RadioGroup.id' => 'integer',
'RadioGroup__logo_image' => 'string',
'RadioGroup.logo_image' => 'string',
'logo_image' => 'string',
'RadioGroup__original' => 'integer',
'RadioGroup.original' => 'integer',
'original' => 'integer',
'RadioGroup__name' => 'string',
'RadioGroup.name' => 'string',
'RadioGroup__description' => 'string',
'RadioGroup.description' => 'string',
'description' => 'string',
'RadioGroup__tel' => 'string',
'RadioGroup.tel' => 'string',
'RadioGroup__iarea' => 'text',
'RadioGroup.iarea' => 'text',
'iarea' => 'text',
'RadioGroup__map_icon_image' => 'string',
'RadioGroup.map_icon_image' => 'string',
'map_icon_image' => 'string',
'RadioGroup__map_icon_clicked_image' => 'string',
'RadioGroup.map_icon_clicked_image' => 'string',
'map_icon_clicked_image' => 'string',
'RadioGroup__created' => 'datetime',
'RadioGroup.created' => 'datetime',
'RadioGroup__updated' => 'datetime',
'RadioGroup.updated' => 'datetime',
'CompanySalesGroup__id' => 'integer',
'CompanySalesGroup.id' => 'integer',
'CompanySalesGroup__name' => 'string',
'CompanySalesGroup.name' => 'string',
'CompanySalesGroup__associated_office' => 'text',
'CompanySalesGroup.associated_office' => 'text',
'associated_office' => 'text',
'CompanySalesGroup__logo_image' => 'string',
'CompanySalesGroup.logo_image' => 'string',
'CompanySalesGroup__created' => 'datetime',
'CompanySalesGroup.created' => 'datetime',
'CompanySalesGroup__updated' => 'datetime',
'CompanySalesGroup.updated' => 'datetime',
]
'decorators' => (int) 0
'executed' => false
'hydrate' => true
'buffered' => true
'formatters' => (int) 0
'mapReducers' => (int) 0
'contain' => [
'CompanyAppeal' => [
],
'RadioGroup' => [
],
'CompanySalesGroup' => [
],
]
'matching' => [
]
'extraOptions' => [
]
'repository' => object(App\Model\Table\CompanyTable) id:1 {
'registryAlias' => 'Company'
'table' => 'company'
'alias' => 'Company'
'entityClass' => 'App\Model\Entity\Company'
'associations' => [
(int) 0 => 'Prefecture',
(int) 1 => 'CompanyBlock',
(int) 2 => 'RegionCode',
(int) 3 => 'CompanyAppeal',
(int) 4 => 'Pickup2',
(int) 5 => 'CompanyExportData',
(int) 6 => 'CompanyAgent',
(int) 7 => 'PublishPlan1',
(int) 8 => 'PublishPlan2',
(int) 9 => 'RadioGroup',
(int) 10 => 'CompanySalesGroup',
(int) 11 => 'CompanyCategory',
(int) 12 => 'CompanyRoute',
(int) 13 => 'CompanyGroup',
(int) 14 => 'Entry',
(int) 15 => 'Route',
(int) 16 => 'LocalLpGroup',
(int) 17 => 'SocialNetwork',
]
'behaviors' => [
(int) 0 => 'Common',
(int) 1 => 'Timestamp',
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}