A database error occurred while performing the requested procedure. Please review the database error below for more information.
system/libraries/drivers/Database/Mysqli.php [142]:
There was an SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND tour.tour_id <> 378
GROUP BY tour.tour_id
ORDER BY count DESC
LIMIT 0, 8' at line 11 - SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id
FROM (tour)
JOIN tour_price ON (tour_price.tour_id = tour.tour_id)
JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id)
WHERE tour.tour_categories not like '2'
AND tour.tour_description_jp IS NOT NULL
AND tour_price.begin_date <= 1711558800
AND tour_price.end_date >= 1711558800
AND tour.show_tour like 'yes'
AND tour.place_id=
AND tour.tour_id <> 378
GROUP BY tour.tour_id
ORDER BY count DESC
LIMIT 0, 8
Kohana_Mysqli_Result->__construct( mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 1064 [error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8' at line 11 [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) , 1, SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 )
Database_Mysqli_Driver->query( SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 )
Database_Core->query( SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 )
Database_Core->get( tour )
Tour_Model->tour_correlate( 378 )
Tours_Controller->edit( 378 )
ReflectionMethod->invokeArgs( Tours_Controller Object ( [template] => View Object ( [kohana_filename:protected] => /home/admin/web/toursystem.biz/public_html/application/views/templates/mch/client/frontend_new/tour_detail.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( [content] => View Object ( [kohana_filename:protected] => /home/admin/web/toursystem.biz/public_html/modules/mch_core/views/tour/detail.php [kohana_filetype:protected] => .php [kohana_local_data:protected] => Array ( ) ) ) ) [auto_render] => 1 [db] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) [db2] => [session] => Session Object ( [input:protected] => Input Object ( [use_xss_clean:protected] => 1 [magic_quotes_gpc:protected] => [ip_address] => 54.234.136.147 ) ) [site] => Array ( [site_id] => 1 [site_name] => サザントラベル [site_address] => Airport Plaza Building, No. 1. Bach Dang Str.,, Ward 2, Tan Binh Dist., HCMC, Vietnam [site_city] => [site_state] => [site_zipcode] => [site_logo] => 1376900342logo-dong.gif [site_logo_width] => 250 [site_logo_height] => 88 [site_phone] => +8428-3547-0621 [site_fax] => +8428-3547-0622 [site_slogan] => [site_email] => support@toursystem.biz [site_title] => ベトナム・カンボジア・ラオス・ミャンマーの現地発着ツアー・日本語ガイド送迎付きホテル予約などのお得な旅行情報は、サザントラベル [site_keyword] => ベトナム,ベトナムツアー,ベトナムホテル,ベトナムゴルフ,ベトナム観光,ハノイ観光,ハノイホテル,ハノイスパ,ハノイレストラン,ハノイゴルフ,ハノイ撮影旅行,プノンペンツアー,プノンペン,プノンペンホテル,プノンペン観光,プノンペンゴルフ,プノンペンスパ,プノンペンレストラン,プノンペン撮影旅行,ホーチミン,ホーチミンホテル,ホーチミン観光,ホーチミンゴルフ,ホーチミンスパ,ホーチミンレストラン,ホーチミン撮影旅行,ダナン,ダナンホテル,ダナン観光,ダナンゴルフ,ダナンスパ,ダナンレストラン,ダナンオプシ [site_description] => ベトナム・カンボジア・ラオス・ミャンマーの現地発着ツアー、日本語ガイド送迎付きホテル予約など旅行情報が満載のサザントラベル公式サイト。国内旅行や海外旅行を始め、お食事や車両予約から航空券予約まで、お得で便利な旅行情報を紹介。 [site_rate_tour_fee] => 1 [site_rate_expense] => 21000 [config] => Array ( [BANNER_LEFT] => order [BANNER_TOP] => order [BANNER_RIGHT] => order [BANNER_CENTER_TOP] => order [BANNER_BOTTOM] => order [TEMPLATE] => mch [LOGIN_FRM] => 0 [LEFT_COLUMN] => 1 [RIGHT_COLUMN] => 1 [GOOGLE_CALENDAR] => 0 [ADMIN_NUM_LINE] => 10 [CLIENT_NUM_LINE] => 5 [ADMIN_LANG] => 8 [CLIENT_LANG] => 8 [FORMAT_SHORT_DATE] => Y/m/d [FORMAT_LONG_DATE] => Y/m/d G:i [ADMIN_THEME] => [CLIENT_THEME] => styleMCH [DEF_SREG] => 1 [HOME_NUM_ROW] => 1 [HOME_NUM_COL] => 1 [HOME_NUM_REC_DEF] => 1 [TARGET_MENU] => _blank [BANNER_CENTER_BOTTOM] => order [SUPPORT_FRM] => 0 [MAX_WIDTH_IMAGE_DETAIL] => 450 [MAX_HEIGHT_IMAGE_DETAIL] => 0 [BANNER_LEFT_OUTSIDE] => order [BANNER_RIGHT_OUTSIDE] => order [BANNER_TOP_T] => order [BANNER_TOP_B] => order [BANNER_LEFT_T] => order [BANNER_LEFT_B] => order [BANNER_RIGHT_T] => order [BANNER_RIGHT_B] => order [MAX_WIDTH_BANNER_ADMIN_LIST] => 150 [MAX_HEIGHT_BANNER_ADMIN_LIST] => 60 [PLACE_VIETNAM] => 'KIX','KUL','HKG','NRT','HUI','NHA','CXR','DAD','HOIAN','QUANG NGAI','QUY NHON','KONTUM','MY SON','MYSON','PXU','QUANG BINH','QUANG TRI','QUY NHON','VINH','HAN','LAI CHAU','LAO CAI','HA GIANG','MEOVAC','SON LA','VINH PHUC','VINHPHUC','HOA BINH','HA LONG','HA TINH','HAI PHONG','HPH','HAIPHONG','HAI DUONG','NAM DINH','NAMDINH','NINH BINH','BAC HA','BAC NINH','BHR','BAC GIANG','BAVET','QUANG BINH','THANH HOA','THD','THAI BINH','THAIBINH','SAPA','BAT TRANG','CAT BA','KTB','CHUA HUONG','DONG VAN','DONGVAN','MAI CHAU','MAICHAU','MUONG LAI','MUONG TE','MUONGXAY','TAM COC BICH DONG','YEN MINH','YENMINH','DIN','TUYENQUANG','BACQUANG','BQN','YENBAI','THAN UYEN','TUAN GIAO','MOCCHAU','THAINGUYEN','CAO BANG','VINH YEN','VIETTRI','HOANGSUPHI','MUONGKHUONG','LANGSON','SGN','BIEN HOA','BINH DUONG','BINH PHUOC','CAN GIO','VCA','CHAU DOC','CDC','CU CHI','DONG NAI','DONG THAP','LONG HAI', 'MY THO','NINH CHU','NINH THUAN','PHAN RANG','TAY NINH','VUNG TAU','THU DUC', 'TIEN GIANG','TIG','TRA VINH','BEN TRE','BENTRE','SNW','BUON ME THUOC','BAO LOC','NONGKAI','DAKLAC','DLK','GIA LAI','KONTUM','HA TIEN','SOC TRANG','VINH LONG','XVL','CON DAO' ,'DLI','HAI YEN','PQC','PTT','SOKHA HA TIEN','VKG','BMV','VUNGTAU','AN GIANG','ANG','TBB','NLO','VCS','GIALAI','CAN THO','QNI','VINH YEN','MU','THAH' [PLACE_LAOS] => 'DOKH','KHON','LPQ','LXG','MSIN','PKOU','PKZ','VIXA','NOKI','MUNO','ODY','ZBY','NEU','BOKE','CPSA','HOE','MUKU','PBEN','PASO','VIHA','ZVK','TALO','VAVI','VITH','VTE','XIKO','KLOR','KHAM','SEKO','PXAN','THAK','BANK','XKH','HINB','SAMTAI','TADL' [PLACE_CAMBODIA] => 'KZK','PNH','SHK','KKZ','KMT','KTI','KOS','KOPO','TASA','MDK','KPC','BBM','POPE','PVEN','REP','SPK','ODAR' [PLACE_HAN] => 'BACH','BHR','BGX','BATT','THNG','HAID','HALO','HATI','HAIP','HAIH','HAN','HOBI','LCHA','LAOC','MAIC','MUTE','MXAY','NDIN','NINB','SAPA','SONL','TCBD','THBI','THAD','VPHU','YMIN','DIN','MLAI','MOCC','THAI','YBAI','NLO','BACQ','DONG','VDH','UIH','CAOB','TUYE','QNI','HPH','MEOV','VYEN','VTRI','HOAB','MKHU','LSON','MUONGKHUONG','NGLO','MU','THAH' [PLACE_DAD] => 'DAD','HOIA','MYSO','QBIN','QNGA','QTRI','QNHO','VII','PXU' [PLACE_SGN] => 'SNW','BIEH','BIND','BINP','CANG','VCA','CDC','CUCH','DLK','DLI','DNAI','DONN','HATN','KTUM','LONG','MTHO','NINC','NBIN','PHRA','TBB','PQC','PXU','SGN','SIHO','SOCT','TNIN','TDUC','TAIP','VIXA','VKG','VTAU','VCS','PTT','BMV','GIAL','CANT','XIP','MOCB','ANG','PRO','TIEG','XVL','' [REQUEST_HOTEL_STATUS] => [{"id":"1","value":"Request"},{"id":"2","value":"Waiting"},{"id":"3","value":"Full"},{"id":"4","value":"OK"},{"id":"5","value":"Amend"},{"id":"6","value":"Delete"},{"id":"7","value":"Cancel"},{"id":"8","value":"Dummy OK"},{"id":"9","value":"Stop"}] [BOOKING_STATUS] => [{"id":"1","value":"新規予約"},{"id":"2","value":"お見積もり"},{"id":"3","value":"修正"},{"id":"4","value":"ファイナル"},{"id":"5","value":"削除"},{"id":"6","value":"ノーショー"},{"id":"7","value":"キャンセルチャージ"}] [HOTEL_STANDARD] => [{"id":"2","value":"Economy"},{"id":"3","value":"Economy"},{"id":"4","value":"Superior"},{"id":"5","value":"Deluxe"}] [PLACE_VTE] => 'BOKE','CPSA','HOE','MUKU','PBEN','PASO','VIHA','ZVK','TALO','VAVI','VITH','VTE','XIKO','KLOR','KHAM','SEKO','PXAN','THAK','BANK','XKH','HINB','SAMTAI','TADL' [PLACE_REP] => 'BBM','POPE','PVEN','REP','SPK','ODAR' [PLACE_MYANMAR] => 'RGN','NYU','MDL','HEH','SNW','KYT','HEH','INL','MYANMAR','TAUNGOO' [TOUR_CODE_PRIVATE] => ["SGNF01","SGNF02","SGNH01","SGNH02","HANF01","HANF02","HANH01","HANH02","DADH01","DADH02","DADF01","DADF02","HIAF03","HIAF04","HIAH03","HIAH04","HUIF06","HUIF07","HUIH09","HUIH10","NHAF13","NHAF14","NHAH06","NHAH07","REPF17","REPF18","REPH01","REPH02","PNHF03","PNHF04","PNHH01","PNHH02","LPQF10","LPQF11","LPQH01","LPQH02","VTEF02","VTEF03","VTEH01","VTEH02","PKZH02","PKZH03","PKZF01","PKZF02"] [PLACE_RGN] => 'RGN','NYU','MDL','HEH','SNW','KYT','HEH','INL','MYANMAR','TAUNGOO' [RATE_Y2D] => 120 [RATE_D2Y] => 150 [BOOKING_STATUS_EN] => [{"id":"1","value":"New booking"},{"id":"2","value":"Quotation"},{"id":"3","value":"Correction"},{"id":"4","value":"Final"},{"id":"5","value":"Delete"},{"id":"6","value":"No show"},{"id":"7","value":"Cancel Charge"}] [REQUEST_RES_STATUS] => [{"id":"1","value":"Request"},{"id":"2","value":"Waiting"},{"id":"3","value":"Full"},{"id":"4","value":"OK"},{"id":"5","value":"Cancel"},{"id":"6","value":"Amend"},{"id":"7","value":"Delete"}] [PLACE_HCM] => 'BIEN HOA','BINH DUONG','BINH PHUOC','CAN GIO','VCA','CHAU DOC','CDC','CU CHI','DONG NAI','DONG THAP','LONG HAI', 'MY THO','NINH CHU','NINH THUAN','PHAN RANG','TAY NINH','VUNG TAU','THU DUC', 'TIEN GIANG','TRA VINH','BEN TRE','BENTRE','BENT','SNW','BUON ME THUOC','BAO LOC','NONGKAI','DAKLAC','DLK','GIA LAI','KONTUM','HA TIEN','SOC TRANG','VINH LONG','XVL','CON DAO' ,'DLI','HAI YEN','PQC','PTT','SOKHA HA TIEN','VKG','BMV','VUNGTAU','AN GIANG','ANG','TBB','NLO','QNHO','CAH','BLIX' [PLACE_THAILAND] => 'BKK' [PLACE_LPQ] => 'DOKH','KHON','LPQ','LXG','MSIN','PKOU','PKZ','VIXA','NOKI','MUNO','ODY','ZBY','NEU' [PLACE_PNH] => 'KZK','PNH','SHK','KKZ','KMT','KTI','KOS','KOPO','TASA','MDK','KPC' [RATE_V2D] => 24000 [EMAIL_SUPPORT] => 0622@asdf!1996 [PERCENT_HOTEL_ONLY] => 0.9 [LIMIT_PERIOD_HOTEL_AGENT] => 2024/09/30 [TARIFF_TOUR_PLACE] => 61,72,39,68,116,162,139,153,203,55,96,157,213,43,141,245,154,244,377,255,138,204,210,21,117 [TARIFF_HOTEL_PLACE] => 61,72,39,68,116,162,139,153,203,96,138,204,210,21,117,151,141,245,43,55,157 ) [base_url] => https://www.toursystem.biz/ [theme_url] => https://www.toursystem.biz/themes/client/styleMCH/ [history] => Array ( [back] => https://www.toursystem.biz/ [current] => tours/edit/378 ) [lang_id] => 8 ) [mr] => Array ( ) [mlist] => [warning] => wrong_pid [mycart] => MyCart Object ( [cart] => [items] => [itemsUpdate] => [uniCart] => [str_pattern] => <#> ) [url_chat_server] => https://gina.vn:4000/ [url_connect_server] => http://lpn.tabikobo.com/api_v1/bookingConfirm [uri] => URI Object ( ) [input] => Input Object ( [use_xss_clean:protected] => 1 [magic_quotes_gpc:protected] => [ip_address] => 54.234.136.147 ) [login_model] => Login_model Object ( [table_name:protected] => [primary_key:protected] => [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) [session] => Session Object ( [input:protected] => Input Object ( [use_xss_clean:protected] => 1 [magic_quotes_gpc:protected] => [ip_address] => 54.234.136.147 ) ) ) [segmentUrl] => Array ( [0] => [1] => tours [2] => edit [3] => 378 ) [sess_register] => [sess_cus] => [sess_admin] => [user_model] => User_Model Object ( [table_name:protected] => user [primary_key:protected] => user_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [page_id] => [page_model] => Page_Model Object ( [table_name:protected] => page [primary_key:protected] => page_id [status_key:protected] => page_status [order_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [tour_model] => Tour_Model Object ( [table_name:protected] => tour [primary_key:protected] => tour_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) [configuration_model] => Configuration_Model Object ( [table_name:protected] => configuration [primary_key:protected] => configuration_id [col_key:protected] => configuration_key [col_value:protected] => configuration_value [sorting:protected] => Array ( [configuration_id] => asc ) [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) ) [place_model] => Place_Model Object ( [table_name:protected] => place [primary_key:protected] => place_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [tour_file_model] => Tour_file_Model Object ( [table_name:protected] => tour_file [primary_key:protected] => file_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [tour_price_model] => Tour_price_Model Object ( [table_name:protected] => tour_price [primary_key:protected] => tour_price_id [IS_NEW:protected] => [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [tours_price1_model] => Tours_Price1_Model Object ( [table_name:protected] => tour_price [primary_key:protected] => tour_price_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [orders_model] => Orders_Model Object ( [table_name:protected] => orders [primary_key:protected] => orders_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [configuration_model] => Configuration_Model Object ( [table_name:protected] => configuration [primary_key:protected] => configuration_id [col_key:protected] => configuration_key [col_value:protected] => configuration_value [sorting:protected] => Array ( [configuration_id] => asc ) [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [data_template_model] => Data_template_Model Object ( [table_name:protected] => data_template [primary_key:protected] => configuration_id [col_lang_id:protected] => languages_id [col_key:protected] => configuration_key [col_value:protected] => configuration_value [sorting:protected] => Array ( [configuration_id] => asc ) [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [booking_model] => Booking_Model Object ( [table_name:protected] => booking [primary_key:protected] => booking_id [col_name:protected] => booking_code [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) [configuration_model] => Configuration_Model Object ( [table_name:protected] => configuration [primary_key:protected] => configuration_id [col_key:protected] => configuration_key [col_value:protected] => configuration_value [sorting:protected] => Array ( [configuration_id] => asc ) [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [employee_model] => Employee_Model Object ( [table_name:protected] => employee [primary_key:protected] => employee_id [foriegn_key_user:protected] => user_id [col_status:protected] => user_status [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [agent_model] => Agent_Model Object ( [table_name:protected] => agent [primary_key:protected] => agent_id [foriegn_key_user:protected] => user_id [col_status:protected] => user_status [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [booking_hotel_model] => Booking_hotel_Model Object ( [table_name:protected] => booking_hotel [primary_key:protected] => booking_hotel_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [booking_hotel_to_model] => Booking_hotel_to_Model Object ( [table_name:protected] => booking_hotel_to [primary_key:protected] => booking_hotel_to_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [booking_restaurant_model] => Booking_res_Model Object ( [table_name:protected] => booking_res [primary_key:protected] => booking_res_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [booking_price_model] => Booking_price_Model Object ( [table_name:protected] => booking_price [primary_key:protected] => booking_price_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [booking_tour_model] => Booking_tour_Model Object ( [table_name:protected] => booking_tour [primary_key:protected] => booking_tour_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) [configuration_model] => Configuration_Model Object ( [table_name:protected] => configuration [primary_key:protected] => configuration_id [col_key:protected] => configuration_key [col_value:protected] => configuration_value [sorting:protected] => Array ( [configuration_id] => asc ) [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [aOLB] => Array ( [0] => OLN [1] => OLNT [2] => OLNH [3] => OLNG ) ) [booking_tour_details_model] => Booking_tour_details_Model Object ( [table_name:protected] => booking_tour_details [primary_key:protected] => booking_tour_details_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) [configuration_model] => Configuration_Model Object ( [table_name:protected] => configuration [primary_key:protected] => configuration_id [col_key:protected] => configuration_key [col_value:protected] => configuration_value [sorting:protected] => Array ( [configuration_id] => asc ) [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [placeSGN] => 162,11,12,13,20,21,27,37,45,46,95,111,118,119,128,177,204,184,313,187,307,220,6,40,226,85,56,167,326,210,43,141,213,168,202,296,135,257,0 [placeHAN] => 428,61,89,92,54,312,169,200,67,55,57,59,306,58,114,117,3,4,5,182,180,157,7,286,29,254,102,216,108,109,175,208,215,297,311,253,243,42,209,218,219,279,317,318,319,320,329,303,252,410 [placeDAD] => 39,68,110,147,148,149,284,146 [placeNHA] => 116,38 [placeLPQ] => 44,80,96,99,106,122,138,197,223,224,264,347,381 [placeVTE] => 15,26,70,105,123,124,131,159,174,195,196,203,206,211,222,267,273,292,294,370,437,434,438 [placePNH] => 139,234,239,163,302,84,245,227,310,431,432 ) [hotel_dotoclass] => Hotel_Dotoclass_Model Object ( [table_name:protected] => doto_class [primary_key:protected] => doto_class_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [hotel_model] => Hotel_Model Object ( [table_name:protected] => hotel [primary_key:protected] => hotel_id [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [order_key:protected] => [status_key:protected] => [result_query:protected] => [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [hotel_room_model] => Hotel_room_Model Object ( [table_name:protected] => hotel_room [primary_key:protected] => hotel_room_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [restaurant_model] => Res_Model Object ( [table_name:protected] => res [primary_key:protected] => res_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [guide_model] => Guide_Model Object ( [table_name:protected] => guide [primary_key:protected] => guide_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [booking_cxl_model] => Booking_cancel_pax_Model Object ( [table_name:protected] => booking_cancel_pax [primary_key:protected] => booking_cancel_pax_id [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [hotel_price_model] => Hotel_price_Model Object ( [table_name:protected] => hotel_price [primary_key:protected] => hotel_price_id [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.114</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [order_key:protected] => [status_key:protected] => [result_query:protected] => [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [aFSC] => Array ( [0] => 14 [1] => 98 [2] => 99 ) [aKIS] => Array ( [0] => 35 [1] => 102 [2] => 103 [3] => 104 ) [aWBF] => Array ( [0] => 123 [1] => 124 [2] => 138 ) [aOLB] => Array ( [0] => 133 [1] => 134 [2] => 135 [3] => 208 ) [aAWI] => Array ( [0] => 21 [1] => 161 ) [aGTC] => Array ( [0] => 108 [1] => 269 [2] => 270 ) [aTBK] => Array ( [0] => 94 [1] => 260 [2] => 261 [3] => 262 [4] => 263 [5] => 286 [6] => 382 [7] => 417 ) [aLPJ] => Array ( [0] => 181 [1] => 267 [2] => 268 ) [aNMD] => Array ( [0] => 105 [1] => 143 [2] => 150 [3] => 152 [4] => 205 [5] => 209 [6] => 257 [7] => 264 [8] => 266 [9] => 275 ) [aSBI] => Array ( [0] => 294 [1] => 295 [2] => 296 [3] => 298 ) [aVLT] => Array ( [0] => 52 [1] => 367 [2] => 369 [3] => 490 [4] => 489 [5] => 488 ) [aTBKV] => Array ( [0] => 331 [1] => 336 ) [aDNA] => Array ( [0] => 179 [1] => 386 ) [aWCC] => Array ( [0] => 324 [1] => 404 ) ) [refresh_token_email_model] => Refresh_token_email_Model Object ( [table_name:protected] => refresh_token_email [primary_key:protected] => id [email_value:protected] => email [client_id:protected] => clientId [order_key:protected] => [status_key:protected] => [result_query:protected] => [dsUser:protected] => <NewDataSet> <M023_COMMON_SUP> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <TICKET_FLG>true</TICKET_FLG> <HOTEL_FLG>false</HOTEL_FLG> <LAND_FLG>false</LAND_FLG> <OPERATOR_FLG>false</OPERATOR_FLG> <OPTION_FLG>false</OPTION_FLG> <PACKAGE_FLG>false</PACKAGE_FLG> <RENTACAR_FLG>false</RENTACAR_FLG> <PARENT_COMMON_SUP_CD /> <COMMON_SUP_NM_JP>LEPHONG</COMMON_SUP_NM_JP> <COMMON_SUP_NM_KANA>レフォン</COMMON_SUP_NM_KANA> <COMMON_SUP_NM_E>LEPHONG</COMMON_SUP_NM_E> <CHARGE /> <ZIPCODE /> <PREFECTURE /> <ADDRESS1 /> <ADDRESS2 /> <LOSE_FLG>false</LOSE_FLG> <DB_HOST>192.168.33.120</DB_HOST> <DB_INSTANCE>TRIPHOOWW</DB_INSTANCE> <DB_ID>sa</DB_ID> <DB_PASSWORD>kaeru3!</DB_PASSWORD> <RT_CD /> <PASSWORD /> <PASSWORD_LOSE_FLG>false</PASSWORD_LOSE_FLG> <INFINI_B2B_FLG>false</INFINI_B2B_FLG> <SMTP_SERVER /> <SMTP_PORT /> <SMTP_USER /> <SMTP_PASSWORD /> <B2B_COMPANY_CD /> <B2B_BRANCH_CD /> <EDIT_TIME>2016-06-06T11:11:15+09:00</EDIT_TIME> <EDIT_MGR_CD>SA</EDIT_MGR_CD> </M023_COMMON_SUP> <USER> <COMMON_SUP_CD>LPN</COMMON_SUP_CD> <EMP_CD>SA</EMP_CD> <PASSWORD>pwd</PASSWORD> </USER> </NewDataSet> [client:protected] => [db:protected] => Database Object ( [config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [driver:protected] => Database_Mysqli_Driver Object ( [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [db_config:protected] => Array ( [benchmark] => 1 [persistent] => [connection] => Array ( [type] => mysqli [user] => admin_toursystem [pass] => [host] => 58.84.1.29 [port] => [socket] => [database] => admin_toursystem ) [character_set] => utf8 [table_prefix] => [object] => 1 [cache] => [escape] => 1 ) [statements:protected] => Array ( ) [query_cache:protected] => ) [link:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 3 [host_info] => 58.84.1.29 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.68-MariaDB [server_version] => 50568 [stat] => Uptime: 7541108 Threads: 25 Questions: 425916134 Slow queries: 240 Opens: 365379 Flush tables: 2 Open tables: 256 Queries per second avg: 56.479 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 2840232 [warning_count] => 0 ) [select:protected] => Array ( ) [set:protected] => Array ( ) [from:protected] => Array ( ) [join:protected] => Array ( ) [where:protected] => Array ( ) [orderby:protected] => Array ( ) [order:protected] => Array ( ) [groupby:protected] => Array ( ) [having:protected] => Array ( ) [distinct:protected] => [limit:protected] => [offset:protected] => [last_query:protected] => SELECT tour.*, count(*) as count, tour_price.tour_price2pax_web AS price_sale, tour_price.tour_price_name, tour_price.tour_price_name_en, tour_price.tour_price_id FROM (tour) JOIN tour_price ON (tour_price.tour_id = tour.tour_id) JOIN booking_tour_details ON (tour.tour_id = booking_tour_details.tour_id) WHERE tour.tour_categories not like '2' AND tour.tour_description_jp IS NOT NULL AND tour_price.begin_date <= 1711558800 AND tour_price.end_date >= 1711558800 AND tour.show_tour like 'yes' AND tour.place_id= AND tour.tour_id <> 378 GROUP BY tour.tour_id ORDER BY count DESC LIMIT 0, 8 [query_history:protected] => Array ( ) [in_trans:protected] => ) ) [search] => Array ( [display] => [keyword] => [place] => [name] => ) ) , Array ( [0] => 378 ) )
Kohana::instance( )
call_user_func( Array ( [0] => Kohana [1] => instance ) )
Event::run( system.execute )
require( system/core/Bootstrap.php )