スマホ・携帯で見よう！

QRコード

スマホや携帯からも高収入アルバイトをチェック！もちろんお店に応募や質問もできちゃうよ♪※左の2次元コードを読み取って簡単アクセス！

画像横文言<br />

サイトを通して安心お問い合わせ※18歳未満の方はご利用できません

お問い合わせの際は、はじめに「ガールズヘブンを見ました」と言うとスムーズです。
直接、お電話・メールでも応募できます。携帯からの場合、ドメイン指定受信を解除してください。

画像横文言

求人ムービー

"こんばんは！'"ありがとう！""AAADF#Q#"\"\\\#!\"aa

aaaaaa

求人ムービー一覧へ

応募情報

店名
東北テスト店舗１２３４５６７８９０２２３４５６７８９０
勤務地
会津
住所
福島県会津若松市  アクセスはこちら

電話番号
電話番号 090-9031-5900
電話番号 080-6045-6324
SNS
受付時間
営業時間ならいつでもOK♪
担当者
店長
オフィシャルサイト
ヘブンネット掲載中
http://devwww.cityheaven.net/th/2013_11_05_01_7/ (東北テスト店舗１２３４５６７８９０２２３４５６７８９０)
メールアドレス
待遇
  • 見学のみOK
  • 体験入店OK
  • 店外面接OK
  • 面接交通費支給
  • 友達と面接可
  • オンライン面接○
  • 出張面接○
  • 写メ面接○
  • 自由出勤
  • 短期OK
  • 保証制度あり
  • 入店祝い金あり
  • 完全日払い
  • 交通費支給
  • ボーナスあり
  • マスコミ手当
  • 指名料バック
  • 無料駐車場あり
  • 掛け持ちOK
  • 講習なし
  • マニュアル講習
  • 女性店長
  • 生理休暇
  • 寮完備
  • 託児所完備
  • 個室待機
  • 自宅待機
  • アリバイ対策対応可能
  • 未経験者歓迎
応募資格
18歳以上　高校生不可
※18歳未満（高校生を含む）の応募はお断りします。
勤務期間
お好きな時間に働けます。
給与
お気軽にお問い合わせください。給与補足 その他手当あり
勤務日
年中無休お好きな日に働けます。週1からでもOK
勤務時間
AM13：00～翌05：00 お好きな時間に働けます。
POINT
POINT

画像横文言<br />

サイトを通して安心お問い合わせ※18歳未満の方はご利用できません

お問い合わせの際は、はじめに「ガールズヘブンを見ました」と言うとスムーズです。
直接、お電話・メールでも応募できます。携帯からの場合、ドメイン指定受信を解除してください。

画像横文言

 SNS応募方法

東北テスト店舗１２３４５６７８９０２２３４５６７８９０様のSNSID

12345

SNS IDをコピーする

SNSサービスから上のIDにお問い合わせください。
「ガールズヘブンを見ました」とお伝えすると対応がスムーズになります。

お電話・メールから応募する場合

 TEL 090-9031-5900
求人受付番号
 メールでお問い合わせ

採用担当：  店長   受付時間： 営業時間ならいつでもOK♪

閉じる

編集部に通報 情報提供フォーム

編集部に通報

こちらはサイト内及び、各お店ページ内において、事実と相違があると思しき記載や掲示を編集部に通報するフォームです。 以下の内容に該当する通報は当編集部は介入することはできません。直接お店にお問い合わせください。 ・個人とお店間のトラブル ・お店で働くもしくは働いていた方とお店間のトラブル ※通報に対して、編集部が個別に回答することはありません。 ※通報に基づき、適宜調査・対応させていただきますが、すべての報告に対して対応するものではありません。また記載・掲示内容の相違について責任、及び賠償の責を負うものではありません。 ※報告された方の個人情報を第三者へ知らせることはありません。 ※この通報をおこなう際は、下記のメッセージを当編集部に開示することについてご承諾いただいたものとさせていただきます。 ※土日、祝祭日および年末年始等にいただいたお問い合わせの対応は数日かかる場合がございますので、あらかじめご了承ください。
続きを見る
以下の内容で編集部に通報いたしました。
内容を選択してください。
店舗名 東北テスト店舗１２３４５６７８９０２２３４５６７８９０
内容
【必須】
下記より該当項目にチェックを入れて下さい。
連絡先

詳細
店舗名
東北テスト店舗１２３４５６７８９０２２３４５６７８９０
内容【必須】
連絡先

ご提供内容の確認をさせて頂くことが発生した際にのみ使用致します
詳細
送信する

閉じる
/var/GirlsApp/application/modules/GirlsUtil.php | 6468行 | Application_Model_Front_GuideDao | selectGuideInfo


[SQL(Time=37.01305ms, Records=1]

SELECT 
  G.LARGE_AREA_ID, 
  G.SHOP_RANKING_DISP_PATTERN, 
  G.BLOG_RANKING_DISP_PATTERN, 
  G.GUIDETOP_SHOPRANKING_CNT, 
  G.GUIDETOP_BLOGRANKING_CNT, 
  L.MAINAREA_ID, 
  L.AREA_NAME LARGE_AREA_NAME 
FROM 
  rcuser.M_GUIDE G 
  INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = G.LARGE_AREA_ID 
  AND L.STATUS_FLG = : status_flg 
WHERE 
  G.LARGE_AREA_ID = : large_area_id

[Parameter]
Array
(
    [large_area_id] => 52
    [status_flg] => 1
)


/var/GirlsApp/application/modules/GirlsUtil.php | 2065行 | Application_Model_Front_DivideMainareaDao | selectDivideMainArea


[SQL(Time=0.61607ms, Records=0]

SELECT 
  S.URL_DIRECTORY, 
  D.NEW_MAINAREA_ID 
FROM 
  rcuser.M_SHOP S 
  INNER JOIN rcuser.M_DIVIDE_MAINAREA D ON D.SHOP_ID = S.SHOP_ID 
  AND D.OLD_MAINAREA_ID = : old_mainarea_id 
  AND D.STATUS_FLG = : d_status_flg 
WHERE 
  S.URL_DIRECTORY = : url_directory 
  AND S.STATUS_FLG = : s_status_flg

[Parameter]
Array
(
    [old_mainarea_id] => 2
    [d_status_flg] => 1
    [s_status_flg] => 1
    [url_directory] => 'prettyprincessandmrsagehaaizuten'
)


/var/GirlsApp/application/modules/GirlsUtil.php | 2086行 | Application_Model_Front_JobDao | selectJobUrlDirectory


[SQL(Time=3.47209ms, Records=1]

SELECT 
  J.SHOP_ID, 
  J.GYOUSYU_ID, 
  J.KEN_JIS, 
  J.AREA_ID, 
  J.STATUS_FLG, 
  J.JOB_ID, 
  J.SHIGOTO_NO, 
  J.DX_TEMPLATE_FLG, 
  J.SNS_ID, 
  J.SNS_LINK, 
  S.SHOP_ORG_ID, 
  S.SHOP_NAME, 
  S.MAINAREA_ID, 
  S.OFFICE_NAME, 
  S.ADV_TYPE, 
  S.EMAIL_TENSOU, 
  S.EMAIL_TENSOU_2, 
  S.EMAIL_TENSOU_3, 
  S.OFFICIALIZE_FLG, 
  S.URL_DIRECTORY, 
  S.DX_OPTION_FLG, 
  S.DX_DESIGN_FLG, 
  S.DX_PC_LINK_FLG, 
  G.GYOUSYU_NAME, 
  K.KEN_NAME, 
  A.AREA_NAME, 
  J.AREA_ID SMALL_AREA_ID, 
  A.MIDDLE_AREA_ID, 
  MA.LARGE_AREA_ID, 
  GYOUSYU.BUSINESS_FIRST_ID BUSINESS_FIRST_ID, 
  NVL(
    BFTO.BUSINESS_FIRST_SUB_NAME, GYOUSYU.BUSINESS_FIRST_NAME
  ) BUSINESS_FIRST_NAME_SEO, 
  NVL(
    BSTO.BUSINESS_SECOND_SUB_NAME, GYOUSYU.BUSINESS_SECOND_NAME
  ) BUSINESS_SECOND_NAME 
FROM 
  rcuser.T_JOB J 
  LEFT JOIN rcuser.M_SHOP S ON J.SHOP_ID = S.SHOP_ID 
  AND S.STATUS_FLG = : s_status_flg 
  LEFT JOIN rcuser.M_GYOUSYU G ON J.GYOUSYU_ID = G.GYOUSYU_ID 
  AND G.STATUS_FLG = : g_status_flg 
  LEFT JOIN rcuser.M_KEN K ON J.KEN_JIS = K.KEN_JIS 
  LEFT JOIN rcuser.M_AREA A ON J.AREA_ID = A.AREA_ID 
  AND A.STATUS_FLG = : a_status_flg 
  LEFT JOIN (
    SELECT 
      BS.JOB_ID, 
      BFT.BUSINESS_FIRST_ID, 
      BFT.BUSINESS_FIRST_NAME, 
      BST.BUSINESS_SECOND_ID, 
      BST.BUSINESS_SECOND_NAME 
    FROM 
      rcuser.T_PYD_BUSINESS_SEARCH BS 
      INNER JOIN rcuser.M_PYD_BUSINESS_SECOND_TYPE BST ON BS.BUSINESS_SECOND_ID = BST.BUSINESS_SECOND_ID 
      AND BST.STATUS_FLG = : bst_status_flg 
      INNER JOIN rcuser.M_PYD_BUSINESS_FIRST_TYPE BFT ON BFT.BUSINESS_FIRST_ID = BST.BUSINESS_FIRST_ID 
      AND BFT.STATUS_FLG = : bft_status_flg
  ) GYOUSYU ON GYOUSYU.JOB_ID = J.JOB_ID 
  LEFT JOIN rcuser.M_MIDDLE_AREA MA ON MA.AREA_ID = A.MIDDLE_AREA_ID 
  AND MA.STATUS_FLG = : ma_status_flg 
  LEFT JOIN rcuser.M_PYD_BIZ_FIRST_TYPE_OTHER BFTO ON BFTO.AREA_ID = MA.LARGE_AREA_ID 
  AND BFTO.BUSINESS_FIRST_ID = GYOUSYU.BUSINESS_FIRST_ID 
  LEFT JOIN rcuser.M_PYD_BIZ_SECOND_TYPE_OTHER BSTO ON BSTO.AREA_ID = MA.LARGE_AREA_ID 
  AND BSTO.BUSINESS_SECOND_ID = GYOUSYU.BUSINESS_SECOND_ID 
  LEFT JOIN rcuser.M_LARGE_AREA LA ON LA.AREA_ID = MA.LARGE_AREA_ID 
  AND LA.STATUS_FLG = : la_status_flg 
WHERE 
  S.URL_DIRECTORY = : sgtdir 
  AND S.STATUS_FLG = : s_status_flg 
  AND S.MAINAREA_ID = : main_area 
  AND J.KEISAI_DT <= SYSDATE 
  AND J.STATUS_FLG = : j_status_flg

[Parameter]
Array
(
    [main_area] => 2
    [sgtdir] => 'prettyprincessandmrsagehaaizuten'
    [s_status_flg] => 1
    [g_status_flg] => 1
    [a_status_flg] => 1
    [bst_status_flg] => 1
    [bft_status_flg] => 1
    [ma_status_flg] => 1
    [la_status_flg] => 1
    [j_status_flg] => 1
)


/var/GirlsApp/application/modules/GirlsUtil.php | 6468行 | Application_Model_Front_GuideDao | selectGuideInfo


[SQL(Time=0.38290ms, Records=1]

SELECT 
  G.LARGE_AREA_ID, 
  G.SHOP_RANKING_DISP_PATTERN, 
  G.BLOG_RANKING_DISP_PATTERN, 
  G.GUIDETOP_SHOPRANKING_CNT, 
  G.GUIDETOP_BLOGRANKING_CNT, 
  L.MAINAREA_ID, 
  L.AREA_NAME LARGE_AREA_NAME 
FROM 
  rcuser.M_GUIDE G 
  INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = G.LARGE_AREA_ID 
  AND L.STATUS_FLG = : status_flg 
WHERE 
  G.LARGE_AREA_ID = : large_area_id

[Parameter]
Array
(
    [large_area_id] => 52
    [status_flg] => 1
)


/var/GirlsApp/application/modules/GirlsUtil.php | 6506行 | Application_Model_Front_JobDao | selectJobCountAllLargeArea


[SQL(Time=63.40909ms, Records=49]

SELECT 
  L.AREA_ID LARGE_AREA_ID, 
  L.AREA_NAME LARGE_AREA_NAME, 
  L.MAINAREA_ID, 
  NVL(T.COUNT, 0) COUNT 
FROM 
  rcuser.M_LARGE_AREA L 
  LEFT JOIN (
    SELECT 
      L.AREA_ID, 
      COUNT(0) AS COUNT 
    FROM 
      rcuser.T_JOB J 
      INNER JOIN rcuser.M_SHOP S ON J.SHOP_ID = S.SHOP_ID 
      AND S.STATUS_FLG = : status_flg 
      INNER JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
      AND A.STATUS_FLG = : status_flg 
      AND A.MAINAREA_ID = S.MAINAREA_ID 
      INNER JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
      AND M.STATUS_FLG = : status_flg 
      AND M.MAINAREA_ID = S.MAINAREA_ID 
      INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = M.LARGE_AREA_ID 
      AND L.STATUS_FLG = : status_flg 
      AND L.MAINAREA_ID = S.MAINAREA_ID 
    WHERE 
      J.STATUS_FLG = : status_flg 
      AND J.KEISAI_DT <= SYSDATE 
    GROUP BY 
      L.AREA_ID
  ) T ON T.AREA_ID = L.AREA_ID 
WHERE 
  L.STATUS_FLG = : status_flg 
ORDER BY 
  L.ORDER_NUM

[Parameter]
Array
(
    [status_flg] => 1
)


/var/GirlsApp/application/modules/GirlsUtil.php | 6862行 | Application_Model_Front_ShopDao | selectShopAreaId


[SQL(Time=21.72494ms, Records=1]

SELECT 
  M.LARGE_AREA_ID, 
  A.MIDDLE_AREA_ID, 
  J.AREA_ID, 
  S.MAINAREA_ID, 
  S.URL_DIRECTORY 
FROM 
  rcuser.T_JOB J 
  LEFT JOIN rcuser.M_SHOP S ON S.SHOP_ID = J.SHOP_ID 
  AND S.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
  AND A.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
  AND M.STATUS_FLG = : status_flg 
WHERE 
  S.MAINAREA_ID = : mainarea_id 
  AND S.URL_DIRECTORY = : url_directory

[Parameter]
Array
(
    [mainarea_id] => 2
    [url_directory] => 'prettyprincessandmrsagehaaizuten'
    [status_flg] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 153行 | Application_Model_Front_JobDao | selectJobDetail


[SQL(Time=140.72895ms, Records=1]

SELECT 
  J.JOB_ID, 
  J.SHOP_ID, 
  J.SHIGOTO_NO, 
  J.KEISAI_DT, 
  J.GYOUSYU_ID, 
  J.AREA_ID, 
  LA.AREA_ID AS LARGE_AREA_ID, 
  LA.AREA_NAME AS LARGE_AREA_NAME, 
  MA.AREA_ID AS MIDDLE_AREA_ID, 
  MA.AREA_NAME AS MIDDLE_AREA_NAME, 
  J.KEN_JIS, 
  J.ADDRESS, 
  J.MOYORIEKI, 
  J.MAIN_CATCH, 
  J.MAIN_SETUMEI_OLD, 
  J.STATUS_FLG, 
  J.REG_DT, 
  J.REG_AGENT_ID, 
  J.UPDATE_DT, 
  J.UPDATE_AGENT_ID, 
  J.PIC_MAIN, 
  J.PIC_SUB1, 
  J.PIC_SUB2, 
  J.PIC_SUB3, 
  J.PIC_MAIN_COMMENT, 
  J.PIC_SUB1_COMMENT, 
  J.PIC_SUB2_COMMENT, 
  J.PIC_SUB3_COMMENT, 
  J.LOGO_NAME, 
  J.B_PIC, 
  J.B_PIC2, 
  J.B_PIC3, 
  J.B_PIC4, 
  J.B_PIC5, 
  J.B_PIC6, 
  J.B_PIC7, 
  J.B_PIC8, 
  J.B_PIC9, 
  J.B_PIC10, 
  J.TEL_1, 
  J.TEL_TYPE_1, 
  J.TEL_2, 
  J.TEL_TYPE_2, 
  J.TEL_3, 
  J.TEL_TYPE_3, 
  J.TEL_4, 
  J.TEL_TYPE_4, 
  J.OFFICIAL_SITE_URL_1, 
  J.OFFICIAL_SITE_URL_2, 
  J.OFFICIAL_SITE_URL_3, 
  J.OFFICIAL_SITE_STR_1, 
  J.OFFICIAL_SITE_STR_2, 
  J.OFFICIAL_SITE_STR_3, 
  J.OUBO_DISP_EMAIL_1, 
  J.OUBO_DISP_EMAIL_2, 
  J.OUBO_DISP_EMAIL_3, 
  J.OUBO_DISP_EMAIL_STR_1, 
  J.OUBO_DISP_EMAIL_STR_2, 
  J.OUBO_DISP_EMAIL_STR_3, 
  J.COLUMN_TEL, 
  J.UKETUKEJIKAN, 
  J.TANTOU_NAME, 
  J.OUBO_JYOKEN_STR, 
  J.KIKAN_STR, 
  J.KINMU_KEITAI_STR, 
  J.KINMU_KYUJITU_STR, 
  J.KINMU_KYUYO_STR, 
  J.FREESPACE_TITLE_1, 
  J.FREE_SPACE_PIC_1, 
  J.FREESPACE_TITLE_2, 
  J.FREE_SPACE_PIC_2, 
  J.FREEWORD_STR, 
  J.REG_SHOP_DT, 
  J.REG_SHOP_ID, 
  J.UPDATE_SHOP_DT, 
  J.UPDATE_SHOP_ID, 
  J.KINMU_BIKOU_STR, 
  J.FREE_SPACE_HONBAN_1, 
  J.FREE_SPACE_HONBAN_2, 
  J.OFFICIAL_SITE_URL_4, 
  J.OFFICIAL_SITE_STR_4, 
  J.MAIN_SETUMEI, 
  J.FREESPACE_TITLE_3, 
  J.FREE_SPACE_PIC_3, 
  J.FREE_SPACE_HONBAN_3, 
  J.FREESPACE_TITLE_4, 
  J.FREE_SPACE_PIC_4, 
  J.FREE_SPACE_HONBAN_4, 
  J.FREESPACE_TITLE_5, 
  J.FREE_SPACE_PIC_5, 
  J.FREE_SPACE_HONBAN_5, 
  J.FREESPACE_TITLE_6, 
  J.FREE_SPACE_PIC_6, 
  J.FREE_SPACE_HONBAN_6, 
  J.FREESPACE_TITLE_7, 
  J.FREE_SPACE_PIC_7, 
  J.FREE_SPACE_HONBAN_7, 
  J.FREESPACE_TITLE_8, 
  J.FREE_SPACE_PIC_8, 
  J.FREE_SPACE_HONBAN_8, 
  J.FREESPACE_TITLE_9, 
  J.FREE_SPACE_PIC_9, 
  J.FREE_SPACE_HONBAN_9, 
  J.FREESPACE_TITLE_10, 
  J.FREE_SPACE_PIC_10, 
  J.FREE_SPACE_HONBAN_10, 
  J.SHOP_INFO_TITLE, 
  J.INTERVIEW_LATITUDE || ':' || J.INTERVIEW_LONGITUDE AS MAP_INTERVIEW, 
  J.INTERVIEW_LATITUDE, 
  J.INTERVIEW_LONGITUDE, 
  J.DX_TEMPLATE_FLG, 
  J.SNS_ID, 
  J.SNS_TEXT, 
  J.SNS_LINK, 
  J.KININARU_TEXT, 
  S.ADV_TYPE, 
  S.SHOP_NAME, 
  S.OFFICE_NAME, 
  S.EMAIL_TENSOU, 
  S.OFFICIALIZE_FLG, 
  S.URL_DIRECTORY, 
  CASE WHEN S.DECO_OPTION_FLG = 0 
  OR S.DECO_OPTION_FLG IS NULL THEN (
    SELECT 
      CASE WHEN MDO.DECO_OPTION_FLG = 1 THEN 1 ELSE 2 END 
    FROM 
      M_DECO_OPTION MDO 
    WHERE 
      MDO.MAINAREA_ID = S.MAINAREA_ID 
      AND MDO.ADV_TYPE = S.ADV_TYPE
  ) ELSE S.DECO_OPTION_FLG END As DECO_OPTION_FLG, 
  S.DX_OPTION_FLG, 
  S.DX_PC_LINK_FLG, 
  S.TAINYU_FLG, 
  A.AREA_NAME, 
  K.KEN_NAME, 
  G.GYOUSYU_NAME, 
  C.SHOP_TYPE, 
  C.MAP_LATITUDE || ':' || C.MAP_LONGITUDE || ':' || C.MAP_ZOOM AS MAP, 
  C.MAP_LATITUDE, 
  C.MAP_LONGITUDE, 
  C.MAP_ZOOM, 
  C.SHOP_DIRECTRY_NAME, 
  C.DISTRICT_ID, 
  C.KEISAI_STATE, 
  CASE WHEN JE.POINT_PC_FLG IS NULL THEN 0 ELSE JE.POINT_PC_FLG END POINT_PC_ELLIPSIS_FLG, 
  CASE WHEN JE.POINT_SP_FLG IS NULL THEN 0 ELSE JE.POINT_SP_FLG END POINT_SP_ELLIPSIS_FLG, 
  J.OFFICIAL_SITE_URL_5, 
  J.OFFICIAL_SITE_URL_6, 
  J.OFFICIAL_SITE_STR_5, 
  J.OFFICIAL_SITE_STR_6, 
  NVL(
    BSTO.BUSINESS_SECOND_SUB_NAME, GYOUSYU.BUSINESS_SECOND_NAME
  ) BUSINESS_SECOND_NAME, 
  GYOUSYU.BUSINESS_FIRST_ID, 
  GYOUSYU.BUSINESS_FIRST_NAME, 
  NVL(
    BFTO.BUSINESS_FIRST_SUB_NAME, GYOUSYU.BUSINESS_FIRST_NAME
  ) BUSINESS_FIRST_NAME_SEO, 
  GYOUSYU.BUSINESS_SECOND_NAME BUSINESS_SECOND_NAME_ORI, 
  NVL(
    BSTO.BUSINESS_SECOND_SUB_NAME, GYOUSYU.BUSINESS_SECOND_NAME
  ) BUSINESS_SECOND_NAME, 
  TPL.LIMITED_COMMENT 
FROM 
  rcuser.T_JOB J 
  INNER JOIN rcuser.M_SHOP S ON S.SHOP_ID = J.SHOP_ID 
  AND S.STATUS_FLG = : s_status_flg 
  AND S.MAINAREA_ID = : main_area 
  LEFT JOIN rcuser.M_GYOUSYU G ON G.GYOUSYU_ID = J.GYOUSYU_ID 
  AND G.STATUS_FLG = : g_status_flg 
  LEFT JOIN rcuser.M_KEN K ON K.KEN_JIS = J.KEN_JIS 
  LEFT JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
  AND A.STATUS_FLG = : a_status_flg 
  LEFT JOIN rcuser.VIEW_SIA_C_COMMU C ON C.C_COMMU_ID = S.SHOP_ORG_ID 
  LEFT JOIN rcuser.T_JOB_ELLIPSIS JE ON JE.JOB_ID = J.JOB_ID 
  LEFT JOIN (
    SELECT 
      BS.JOB_ID, 
      BFT.BUSINESS_FIRST_ID, 
      BFT.BUSINESS_FIRST_NAME, 
      BST.BUSINESS_SECOND_ID, 
      BST.BUSINESS_SECOND_NAME 
    FROM 
      rcuser.T_PYD_BUSINESS_SEARCH BS 
      INNER JOIN rcuser.M_PYD_BUSINESS_SECOND_TYPE BST ON BS.BUSINESS_SECOND_ID = BST.BUSINESS_SECOND_ID 
      AND BST.STATUS_FLG = : bst_status_flg 
      INNER JOIN rcuser.M_PYD_BUSINESS_FIRST_TYPE BFT ON BFT.BUSINESS_FIRST_ID = BST.BUSINESS_FIRST_ID 
      AND BFT.STATUS_FLG = : bft_status_flg
  ) GYOUSYU ON GYOUSYU.JOB_ID = J.JOB_ID 
  LEFT JOIN rcuser.M_MIDDLE_AREA MA ON MA.AREA_ID = A.MIDDLE_AREA_ID 
  AND MA.STATUS_FLG = : ma_status_flg 
  LEFT JOIN rcuser.M_PYD_BIZ_FIRST_TYPE_OTHER BFTO ON BFTO.AREA_ID = MA.LARGE_AREA_ID 
  AND BFTO.BUSINESS_FIRST_ID = GYOUSYU.BUSINESS_FIRST_ID 
  LEFT JOIN rcuser.M_PYD_BIZ_SECOND_TYPE_OTHER BSTO ON BSTO.AREA_ID = MA.LARGE_AREA_ID 
  AND BSTO.BUSINESS_SECOND_ID = GYOUSYU.BUSINESS_SECOND_ID 
  LEFT JOIN rcuser.M_LARGE_AREA LA ON LA.AREA_ID = MA.LARGE_AREA_ID 
  AND LA.STATUS_FLG = : la_status_flg 
  LEFT JOIN rcuser.T_PRI_LIMITED TPL ON TPL.SHIGOTO_NO = J.SHIGOTO_NO 
  AND TPL.STATUS_FLG = : tpl_status_flg 
WHERE 
  J.SHIGOTO_NO = : shigoto_no 
  AND J.KEISAI_DT <= SYSDATE 
  AND J.STATUS_FLG IN (: j_status_flg1)

[Parameter]
Array
(
    [main_area] => 2
    [shigoto_no] => 1100000863
    [s_status_flg] => 1
    [g_status_flg] => 1
    [a_status_flg] => 1
    [bst_status_flg] => 1
    [bft_status_flg] => 1
    [ma_status_flg] => 1
    [la_status_flg] => 1
    [tpl_status_flg] => 1
    [j_status_flg1] => 1
)


/var/GirlsApp/application/modules/DecoOptionUtil.php | 271行 | Application_Model_Front_JobDao | selectJobDeco


[SQL(Time=8.66914ms, Records=1]

SELECT 
  JB.JOB_ID, 
  JB.SHIGOTO_NO, 
  JB.LOGO_NAME, 
  JB.LOGO_NAME_M, 
  GREATEST(
    NVL(
      JB.UPDATE_DT, 
      TO_DATE('2000/01/01', 'YYYY/MM/DD')
    ), 
    NVL(
      JB.UPDATE_SHOP_DT, 
      TO_DATE('2000/01/01', 'YYYY/MM/DD')
    )
  ) AS JOB_LAST_UPDATE_DT, 
  JB.TEL_1, 
  JB.TEL_2, 
  JB.TEL_3, 
  JB.TEL_4, 
  JB.TEL_TYPE_1, 
  JB.TEL_TYPE_2, 
  JB.TEL_TYPE_3, 
  JB.TEL_TYPE_4, 
  JB.OFFICIAL_SITE_URL_1, 
  JB.OFFICIAL_SITE_URL_2, 
  JB.OFFICIAL_SITE_STR_1, 
  JB.OFFICIAL_SITE_STR_2, 
  JB.OUBO_DISP_EMAIL_1, 
  JB.OUBO_DISP_EMAIL_2, 
  JB.OUBO_DISP_EMAIL_3, 
  JB.OUBO_DISP_EMAIL_STR_1, 
  JB.OUBO_DISP_EMAIL_STR_2, 
  JB.OUBO_DISP_EMAIL_STR_3, 
  SH.SHOP_ID, 
  SH.SHOP_ORG_ID, 
  SH.SHOP_NAME_ORG, 
  SH.SHOP_NAME_KANA_ORG, 
  SH.SHOP_NAME, 
  SH.OFFICE_NAME, 
  SH.MAINAREA_ID, 
  SH.STATUS_FLG, 
  SH.ADV_TYPE, 
  SH.ORDER_NUM, 
  SH.LOGIN_ID_M, 
  SH.LOGIN_PASS_M, 
  TO_CHAR(
    SH.REG_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS REG_DT, 
  SH.REG_AGENT_ID, 
  TO_CHAR(
    SH.UPDATE_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS UPDATE_DT, 
  SH.UPDATE_AGENT_ID, 
  TO_CHAR(
    SH.REG_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS REG_SHOP_DT, 
  SH.REG_SHOP_ID, 
  TO_CHAR(
    SH.UPDATE_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS UPDATE_SHOP_DT, 
  SH.UPDATE_SHOP_ID, 
  SH.ACCESSLOG_FLG, 
  SH.URL_DIRECTORY, 
  SH.EMAIL_TENSOU, 
  SH.EMAIL_TENSOU_2, 
  SH.EMAIL_TENSOU_3, 
  SH.OFFICIALIZE_FLG, 
  SH.MOVIE_FLG, 
  SH.DECO_OPTION_FLG, 
  NVL(DO.DECO_OPTION_FLG, 2) AS AREA_DECO_OPTION_FLG, 
  NVL(VO.VOICE_OPTION_FLG, 2) AS VOICE_OPTION_FLG, 
  NVL(VO.CONTRIBUTE_LIMIT, 0) AS CONTRIBUTE_LIMIT, 
  NVL(VO.PC_VIEW_CNT, 0) AS PC_VIEW_CNT, 
  NVL(VO.MOBILE_VIEW_CNT, 0) AS MOBILE_VIEW_CNT, 
  NVL(VO.SMART_VIEW_CNT, 0) AS SMART_VIEW_CNT, 
  DL.LOGO_PIC_NAME, 
  TO_CHAR(
    DL.LOGO_PIC_IMG_REG_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS LOGO_PIC_IMG_REG_DT, 
  SH.DX_OPTION_FLG, 
  SH.DX_DESIGN_FLG, 
  DX.DX_LOGO_PIC_NAME, 
  TO_CHAR(
    DX.DX_LOGO_PIC_IMG_REG_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS DX_LOGO_PIC_IMG_REG_DT 
FROM 
  rcuser.T_JOB JB 
  LEFT JOIN rcuser.M_SHOP SH ON SH.SHOP_ID = JB.SHOP_ID 
  LEFT JOIN rcuser.M_DECO_OPTION DO ON DO.MAINAREA_ID = SH.MAINAREA_ID 
  AND DO.ADV_TYPE = SH.ADV_TYPE 
  LEFT JOIN rcuser.M_VOICE_OPTION VO ON VO.MAINAREA_ID = SH.MAINAREA_ID 
  AND VO.ADV_TYPE = SH.ADV_TYPE 
  LEFT JOIN rcuser.T_DECO_LOGO DL ON DL.JOB_ID = JB.JOB_ID 
  LEFT JOIN rcuser.T_DX_LOGO DX ON DX.JOB_ID = JB.JOB_ID 
WHERE 
  JB.SHIGOTO_NO = : shigoto_no 
  AND JB.STATUS_FLG != : job_status_flg

[Parameter]
Array
(
    [shigoto_no] => 1100000863
    [job_status_flg] => 0
)


/var/GirlsApp/application/modules/DecoOptionUtil.php | 498行 | Application_Model_Front_VoiceDao | selectJobVoice


[SQL(Time=1.25980ms, Records=0]

SELECT 
  * 
FROM 
  (
    SELECT 
      VO.JOB_ID, 
      VO.VOICE_ID, 
      TO_CHAR(
        VO.CONTRIBUTE_DT, 'yyyy/mm/dd hh24:mi:ss'
      ) AS CONTRIBUTE_DT, 
      VO.VOICE_NAME, 
      VO.VOICE_CONTENT, 
      VO.LINK_URL, 
      VO.NEW_WINDOW_FLG, 
      VO.MOVIE_FILE, 
      VO.MOVIE_THUMBNAIL, 
      CASE WHEN VO.PIC_APPROVAL_FLG IS NULL THEN VO.PIC_NAME_PC ELSE VO.PIC_NAME_PC END AS PIC_NAME_PC, 
      CASE WHEN VO.PIC_APPROVAL_FLG IS NULL THEN VO.PIC_NAME_MB ELSE VO.PIC_NAME_MB END AS PIC_NAME_MB, 
      VO.PIC_APPROVAL_FLG, 
      TO_CHAR(
        VO.PIC_IMG_REG_DT, 'yyyy/mm/dd hh24:mi:ss'
      ) AS PIC_IMG_REG_DT, 
      VO.STATUS_FLG, 
      TO_CHAR(
        VO.REG_DT, 'yyyy/mm/dd hh24:mi:ss'
      ) AS REG_DT, 
      VO.REG_AGENT_ID, 
      TO_CHAR(
        VO.UPDATE_DT, 'yyyy/mm/dd hh24:mi:ss'
      ) AS UPDATE_DT, 
      VO.UPDATE_AGENT_ID, 
      TO_CHAR(
        VO.REG_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
      ) AS REG_SHOP_DT, 
      VO.REG_SHOP_ID, 
      TO_CHAR(
        VO.UPDATE_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
      ) AS UPDATE_SHOP_DT, 
      VO.UPDATE_SHOP_ID, 
      GREATEST(
        NVL(
          VO.UPDATE_DT, 
          TO_DATE('2000/01/01', 'YYYY/MM/DD')
        ), 
        NVL(
          VO.UPDATE_SHOP_DT, 
          TO_DATE('2000/01/01', 'YYYY/MM/DD')
        )
      ) AS LAST_UPDATE_DT 
    FROM 
      rcuser.T_VOICE VO 
    WHERE 
      VO.JOB_ID = : job_id 
      AND VO.STATUS_FLG = : status_flg 
      AND VO.CONTRIBUTE_DT <= SYSDATE 
    ORDER BY 
      VO.CONTRIBUTE_DT DESC, 
      LAST_UPDATE_DT DESC, 
      VO.VOICE_ID ASC
  ) 
WHERE 
  ROWNUM <= : view_cnt

[Parameter]
Array
(
    [job_id] => 42915
    [status_flg] => 1
    [view_cnt] => 10
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 234行 | Application_Model_Front_MovieDao | selectShopMovieListCnt


[SQL(Time=1.25694ms, Records=1]

SELECT 
  COUNT(*) AS COUNT 
FROM 
  rcuser.T_MOVIE M 
WHERE 
  M.SHOP_ID = : shop_id 
  AND M.STATUS_FLG = : status_flg 
  AND M.KEISAI_DT <= SYSDATE 
  AND M.MOVIE_FILE_PC IS NOT NULL

[Parameter]
Array
(
    [shop_id] => 42992
    [status_flg] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 244行 | Application_Model_Front_ChokusouDao | selectShopChokusouListCnt


[SQL(Time=0.57602ms, Records=1]

SELECT 
  COUNT(*) AS COUNT 
FROM 
  rcuser.T_CHOKUSOU C 
WHERE 
  C.STATUS_FLG = : status_flg 
  AND C.SHOP_ID = : shop_id 
  AND C.KEISAI_DT <= SYSDATE 
  AND C.KEISAI_DT > ADD_MONTHS(SYSDATE, : display_months)

[Parameter]
Array
(
    [shop_id] => 42992
    [status_flg] => 1
    [display_months] => -6
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 255行 | Application_Model_Front_ReviewDao | selectReviewCnt


[SQL(Time=8.79002ms, Records=1]

SELECT 
  COUNT(T1.REVIEW_ID) 
FROM 
  (
    SELECT 
      R.REVIEW_ID, 
      R.REVIEW_CATEGORY_ID, 
      R.REVIEW_DT 
    FROM 
      rcuser.T_GIRLS_REVIEW R 
    WHERE 
      R.JOB_ID = : job_id 
      AND R.APPROVAL_FLG = : approval_flg 
      AND R.STATUS_FLG = : status_flg 
      AND R.REVIEW_GOOD_COMMENT IS NOT NULL 
    UNION ALL 
    SELECT 
      R.REVIEW_ID, 
      R.REVIEW_CATEGORY_ID, 
      R.REVIEW_DT 
    FROM 
      rcuser.T_GIRLS_REVIEW R 
    WHERE 
      R.JOB_ID = : job_id 
      AND R.APPROVAL_FLG = : approval_flg 
      AND R.STATUS_FLG = : status_flg 
      AND R.REVIEW_BAD_COMMENT IS NOT NULL
  ) T1 
WHERE 
  T1.REVIEW_DT > ADD_MONTHS(SYSDATE, : display_months) 
  AND T1.REVIEW_DT <= SYSDATE

[Parameter]
Array
(
    [job_id] => 42915
    [status_flg] => 1
    [approval_flg] => 1
    [display_months] => -36
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 288行 | Application_Model_Front_JobDao | selectAddSearch


[SQL(Time=30.02691ms, Records=10]

SELECT 
  * 
FROM 
  (
    SELECT 
      * 
    FROM 
      (
        SELECT 
          J1.JOB_ID, 
          J1.SHIGOTO_NO, 
          LAR.AREA_ID AS LARGE_AREA_ID, 
          MAR.AREA_ID AS MIDDLE_AREA_ID, 
          0 AS BUSINESS_FIRST_ID, 
          J1.AREA_ID AS KEY_ID, 
          AR.AREA_NAME AS KEY_NAME, 
          '1' AS TYPE 
        FROM 
          rcuser.T_JOB J1 
          INNER JOIN rcuser.M_AREA AR ON J1.AREA_ID = AR.AREA_ID 
          AND AR.STATUS_FLG = : ar_status_flg 
          INNER JOIN rcuser.M_MIDDLE_AREA MAR ON AR.MIDDLE_AREA_ID = MAR.AREA_ID 
          AND MAR.STATUS_FLG = : mar_status_flg 
          INNER JOIN rcuser.M_LARGE_AREA LAR ON MAR.LARGE_AREA_ID = LAR.AREA_ID 
          AND LAR.STATUS_FLG = : lar_status_flg 
        WHERE 
          J1.SHIGOTO_NO = : shigoto_no 
          AND J1.STATUS_FLG = : j1_status_flg 
        UNION ALL 
        SELECT 
          J2.JOB_ID, 
          J2.SHIGOTO_NO, 
          0 AS LARGE_AREA_ID, 
          0 AS MIDDLE_AREA_ID, 
          FS.BUSINESS_FIRST_ID AS BUSINESS_FIRST_ID, 
          PBS.BUSINESS_SECOND_ID AS KEY_ID, 
          CASE WHEN BSTO.BUSINESS_SECOND_SUB_NAME IS NULL THEN SE.BUSINESS_SECOND_NAME ELSE BSTO.BUSINESS_SECOND_SUB_NAME END AS KEY_NAME, 
          '2' AS TYPE 
        FROM 
          rcuser.T_JOB J2 
          INNER JOIN rcuser.T_PYD_BUSINESS_SEARCH PBS ON J2.JOB_ID = PBS.JOB_ID 
          INNER JOIN rcuser.M_PYD_BUSINESS_SECOND_TYPE SE ON SE.BUSINESS_SECOND_ID = PBS.BUSINESS_SECOND_ID 
          AND SE.STATUS_FLG = : se_status_flg 
          INNER JOIN rcuser.M_PYD_BUSINESS_FIRST_TYPE FS ON FS.BUSINESS_FIRST_ID = SE.BUSINESS_FIRST_ID 
          AND FS.STATUS_FLG = : fs_status_flg 
          INNER JOIN rcuser.M_AREA AR ON J2.AREA_ID = AR.AREA_ID 
          AND AR.STATUS_FLG = : ar_status_flg 
          INNER JOIN rcuser.M_MIDDLE_AREA MAR ON AR.MIDDLE_AREA_ID = MAR.AREA_ID 
          AND MAR.STATUS_FLG = : mar_status_flg 
          INNER JOIN rcuser.M_LARGE_AREA LAR ON MAR.LARGE_AREA_ID = LAR.AREA_ID 
          AND LAR.STATUS_FLG = : lar_status_flg 
          LEFT JOIN rcuser.M_PYD_BIZ_SECOND_TYPE_OTHER BSTO ON BSTO.AREA_ID = LAR.AREA_ID 
          AND BSTO.BUSINESS_SECOND_ID = PBS.BUSINESS_SECOND_ID 
        WHERE 
          J2.SHIGOTO_NO = : shigoto_no 
          AND J2.STATUS_FLG = : j2_status_flg 
        UNION ALL 
        SELECT 
          J3.JOB_ID, 
          J3.SHIGOTO_NO, 
          0 AS LARGE_AREA_ID, 
          0 AS MIDDLE_AREA_ID, 
          0 AS BUSINESS_FIRST_ID, 
          PCS.BUSINESS_CATEGORY_ID AS KEY_ID, 
          BC.BUSINESS_CATEGORY_NAME AS KEY_NAME, 
          '3' AS TYPE 
        FROM 
          rcuser.T_JOB J3 
          INNER JOIN rcuser.T_PYD_CATEGORY_SEARCH PCS ON J3.JOB_ID = PCS.JOB_ID 
          INNER JOIN rcuser.M_PYD_BUSINESS_CATEGORY BC ON BC.BUSINESS_CATEGORY_ID = PCS.BUSINESS_CATEGORY_ID 
          AND BC.STATUS_FLG = : gt_status_flg 
        WHERE 
          J3.SHIGOTO_NO = : shigoto_no 
          AND J3.STATUS_FLG = : j3_status_flg
      ) 
    ORDER BY 
      dbms_random.normal()
  ) 
WHERE 
  ROWNUM BETWEEN : startrow 
  AND : endrow

[Parameter]
Array
(
    [shigoto_no] => 1100000863
    [j1_status_flg] => 1
    [ar_status_flg] => 1
    [mar_status_flg] => 1
    [lar_status_flg] => 1
    [j2_status_flg] => 1
    [se_status_flg] => 1
    [fs_status_flg] => 1
    [gt_status_flg] => 1
    [j3_status_flg] => 1
    [startrow] => 1
    [endrow] => 10
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 324行 | Application_Model_Front_DXFreeSpaceDao | selectDXFreeSpaceList


[SQL(Time=1.73092ms, Records=0]

SELECT 
  DXFS.DTL_NO, 
  DXFS.TITLE, 
  DXFS.BODY, 
  DXFS.DISP_TYPE, 
  CASE WHEN DXFS.PC_ELLIPSIS_FLG IS NULL THEN 0 ELSE DXFS.PC_ELLIPSIS_FLG END PC_ELLIPSIS_FLG, 
  CASE WHEN DXFS.SP_ELLIPSIS_FLG IS NULL THEN 0 ELSE DXFS.SP_ELLIPSIS_FLG END SP_ELLIPSIS_FLG, 
  TO_CHAR(
    UPDATE_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS UPDATE_DT, 
  TO_CHAR(
    REG_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS REG_SHOP_DT, 
  TO_CHAR(
    UPDATE_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS UPDATE_SHOP_DT 
FROM 
  rcuser.T_DX_FREESPACE DXFS 
WHERE 
  DXFS.SHOP_ID = : shopId 
  AND DXFS.JOB_ID = : jobId 
ORDER BY 
  DXFS.DTL_NO, 
  DXFS.TERMINAL_TYPE

[Parameter]
Array
(
    [shopId] => 42992
    [jobId] => 42915
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 350行 | Application_Model_Front_DxItemDao | selectDxItemQaList


[SQL(Time=1.55091ms, Records=0]

SELECT 
  DI.DX_ITEM_ID, 
  DI.TITLE 
FROM 
  rcuser.T_DX_ITEM DI 
  INNER JOIN rcuser.T_DX_ITEM_QA DIQ ON DI.JOB_ID = DIQ.JOB_ID 
  AND DI.DX_ITEM_ID = DIQ.DX_ITEM_ID 
WHERE 
  DI.JOB_ID = : job_id 
  AND DI.STATUS_FLG = : status_flg 
  AND DI.DX_ITEM_TYPE = : item_type 
  AND DIQ.QUESTION IS NOT NULL 
  AND DIQ.ANSWER IS NOT NULL 
ORDER BY 
  DI.DX_ITEM_ID

[Parameter]
Array
(
    [job_id] => 42915
    [item_type] => 1
    [status_flg] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 366行 | Application_Model_Front_MovieDao | selectShopMovieList


[SQL(Time=1.15585ms, Records=1]

SELECT 
  * 
FROM 
  (
    SELECT 
      M.MOVIE_ID, 
      M.SHOP_ID, 
      M.KEISAI_DT, 
      M.MOVIE_TITLE, 
      M.MOVIE_CONTENTS, 
      M.MOVIE_FILE_PC, 
      M.MOVIE_FILE_D, 
      M.MOVIE_FILE_A, 
      M.MOVIE_FILE_S, 
      M.MOVIE_FILE_S_COUNT, 
      M.MOVIE_THUMBNAIL, 
      M.STATUS_FLG, 
      M.REG_DT, 
      M.REG_AGENT_ID, 
      M.UPDATE_DT, 
      M.UPDATE_AGENT_ID, 
      M.REG_SHOP_DT, 
      M.REG_SHOP_ID, 
      M.UPDATE_SHOP_DT, 
      M.UPDATE_SHOP_ID, 
      M.APPROVAL_FLG, 
      M.UPLOAD_PATH_FLG, 
      M.MOVIE_FILE_PC_MP4, 
      ROW_NUMBER() OVER (
        ORDER BY 
          M.KEISAI_DT DESC, 
          M.MOVIE_ID DESC
      ) AS MOVIE_ROW 
    FROM 
      rcuser.T_MOVIE M 
    WHERE 
      M.SHOP_ID = : shop_id 
      AND M.STATUS_FLG = : status_flg 
      AND M.KEISAI_DT <= SYSDATE 
      AND M.MOVIE_FILE_PC IS NOT NULL
  ) 
WHERE 
  MOVIE_ROW BETWEEN : startrow 
  AND : endrow 
ORDER BY 
  MOVIE_ROW

[Parameter]
Array
(
    [shop_id] => 42992
    [status_flg] => 1
    [startrow] => 1
    [endrow] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 387行 | Application_Model_Front_ChokusouDao | selectShopChokusouListCnt


[SQL(Time=1.79100ms, Records=1]

SELECT 
  COUNT(*) AS COUNT 
FROM 
  rcuser.T_CHOKUSOU C 
WHERE 
  C.STATUS_FLG = : status_flg 
  AND C.SHOP_ID = : shop_id 
  AND C.KEISAI_DT <= SYSDATE 
  AND C.KEISAI_DT > ADD_MONTHS(SYSDATE, : display_months) 
  AND PIC_MAIN IS NOT NULL

[Parameter]
Array
(
    [shop_id] => 42992
    [status_flg] => 1
    [display_months] => -6
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 395行 | Application_Model_Front_ChokusouDao | selectShopChokusouListCnt


[SQL(Time=0.31590ms, Records=1]

SELECT 
  COUNT(*) AS COUNT 
FROM 
  rcuser.T_CHOKUSOU C 
WHERE 
  C.STATUS_FLG = : status_flg 
  AND C.SHOP_ID = : shop_id 
  AND C.KEISAI_DT <= SYSDATE 
  AND C.KEISAI_DT > ADD_MONTHS(SYSDATE, : display_months)

[Parameter]
Array
(
    [shop_id] => 42992
    [status_flg] => 1
    [display_months] => -6
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 433行 | Application_Model_Front_JobDao | selectJobGroup


[SQL(Time=37.16016ms, Records=0]

SELECT 
  JG.SHIGOTO_NO, 
  JG.GROUP_JOB_ID, 
  JG.GROUP_SHIGOTO_NO, 
  JG.ORDER_NUM, 
  J.PIC_MAIN, 
  S.MAINAREA_ID, 
  S.SHOP_NAME, 
  S.ADV_TYPE, 
  A.AREA_NAME, 
  G.GYOUSYU_NAME, 
  S.URL_DIRECTORY, 
  C.DISTRICT_ID, 
  C.SHOP_DIRECTRY_NAME, 
  C.KEISAI_STATE, 
  J.AREA_ID AREA_ID, 
  MA.AREA_ID MIDDLE_AREA_ID, 
  MA.LARGE_AREA_ID LARGE_AREA_ID, 
  J.LOGO_NAME, 
  CASE S.DECO_OPTION_FLG WHEN 1 THEN DL.LOGO_PIC_NAME WHEN 0 THEN CASE DO.DECO_OPTION_FLG WHEN 1 THEN DL.LOGO_PIC_NAME ELSE '' END ELSE '' END LOGO_PIC_NAME, 
  NVL(
    BSTO.BUSINESS_SECOND_SUB_NAME, GYOUSYU.BUSINESS_SECOND_NAME
  ) BUSINESS_SECOND_NAME 
FROM 
  rcuser.T_JOB_GROUP JG 
  INNER JOIN rcuser.T_JOB J ON JG.GROUP_SHIGOTO_NO = J.SHIGOTO_NO 
  AND J.KEISAI_DT <= SYSDATE 
  INNER JOIN rcuser.M_SHOP S ON J.SHOP_ID = S.SHOP_ID 
  AND S.STATUS_FLG = : s_status_flg 
  INNER JOIN rcuser.VIEW_SIA_C_COMMU C ON S.SHOP_ORG_ID = C.C_COMMU_ID 
  LEFT JOIN rcuser.M_AREA A ON J.AREA_ID = A.AREA_ID 
  AND A.STATUS_FLG = : a_status_flg 
  LEFT JOIN rcuser.M_GYOUSYU G ON J.GYOUSYU_ID = G.GYOUSYU_ID 
  AND G.STATUS_FLG = : g_status_flg 
  LEFT JOIN rcuser.M_DECO_OPTION DO ON DO.MAINAREA_ID = S.MAINAREA_ID 
  AND DO.ADV_TYPE = S.ADV_TYPE 
  LEFT JOIN rcuser.T_DECO_LOGO DL ON DL.JOB_ID = J.JOB_ID 
  LEFT JOIN (
    SELECT 
      BS.JOB_ID, 
      BST.BUSINESS_SECOND_ID, 
      BST.BUSINESS_SECOND_NAME 
    FROM 
      rcuser.T_PYD_BUSINESS_SEARCH BS 
      INNER JOIN rcuser.M_PYD_BUSINESS_SECOND_TYPE BST ON BS.BUSINESS_SECOND_ID = BST.BUSINESS_SECOND_ID 
      AND BST.STATUS_FLG = : bst_status_flg 
      INNER JOIN rcuser.M_PYD_BUSINESS_FIRST_TYPE BFT ON BFT.BUSINESS_FIRST_ID = BST.BUSINESS_FIRST_ID 
      AND BFT.STATUS_FLG = : bft_status_flg
  ) GYOUSYU ON GYOUSYU.JOB_ID = J.JOB_ID 
  LEFT JOIN rcuser.M_MIDDLE_AREA MA ON MA.AREA_ID = A.MIDDLE_AREA_ID 
  AND MA.STATUS_FLG = : ma_status_flg 
  LEFT JOIN rcuser.M_PYD_BIZ_SECOND_TYPE_OTHER BSTO ON BSTO.AREA_ID = MA.LARGE_AREA_ID 
  AND BSTO.BUSINESS_SECOND_ID = GYOUSYU.BUSINESS_SECOND_ID 
WHERE 
  JG.SHIGOTO_NO = : shigoto_no 
  AND J.STATUS_FLG = : j_status_flg 
ORDER BY 
  JG.SHIGOTO_NO, 
  JG.ORDER_NUM

[Parameter]
Array
(
    [shigoto_no] => 1100000863
    [s_status_flg] => 1
    [g_status_flg] => 1
    [a_status_flg] => 1
    [j_status_flg] => 1
    [bst_status_flg] => 1
    [bft_status_flg] => 1
    [ma_status_flg] => 1
)


/var/GirlsApp/application/models/front/MainareaMappingDao.php | 38行 | Application_Model_BaseDao | executeSelect


[SQL(Time=0.99897ms, Records=18]

SELECT 
  MAINAREA_ID, 
  DISTRICT_ID, 
  DISTRICT_CD 
FROM 
  rcuser.M_MAINAREA_MAPPING 
WHERE 
  STATUS_FLG = : status_flg 
ORDER BY 
  MAINAREA_ID ASC

[Parameter]
Array
(
    [status_flg] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 473行 | Application_Model_Front_BusinessCategoryDao | selectBusinessCategory


[SQL(Time=1.10102ms, Records=29]

SELECT 
  BC.BUSINESS_CATEGORY_NAME, 
  CS.BUSINESS_CATEGORY_ID T_BUSINESS_CATEGORY_ID 
FROM 
  rcuser.M_PYD_BUSINESS_CATEGORY BC 
  LEFT JOIN rcuser.T_PYD_CATEGORY_SEARCH CS ON CS.BUSINESS_CATEGORY_ID = BC.BUSINESS_CATEGORY_ID 
  AND CS.JOB_ID = : job_id 
WHERE 
  BC.STATUS_FLG = : status_flg 
  AND (
    CS.BUSINESS_CATEGORY_ID IS NOT NULL 
    OR BC.UNSELECTED_FRONT_DISPLAY_FLG = : display_flg
  ) 
  AND BC.BUSINESS_CATEGORY_GROUP_ID NOT LIKE : business_category_group_id 
ORDER BY 
  BC.BUSINESS_CATEGORY_GROUP_ID, 
  BC.ORDER_NUM

[Parameter]
Array
(
    [status_flg] => 1
    [display_flg] => 1
    [job_id] => 42915
    [business_category_group_id] => 3
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 479行 | Application_Model_Front_BusinessCategoryDao | selectBusinessCategorySalaryStandard


[SQL(Time=0.53287ms, Records=0]

SELECT 
  BC.BUSINESS_CATEGORY_NAME 
FROM 
  rcuser.T_PYD_CATEGORY_SEARCH CS 
  INNER JOIN M_PYD_BUSINESS_CATEGORY BC ON BC.BUSINESS_CATEGORY_ID = CS.BUSINESS_CATEGORY_ID 
  AND BC.STATUS_FLG = : status_flg 
WHERE 
  CS.JOB_ID = : job_id 
  AND BC.BUSINESS_CATEGORY_GROUP_ID = : business_category_group_id

[Parameter]
Array
(
    [job_id] => 42915
    [status_flg] => 1
    [business_category_group_id] => 3
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 520行 | Application_Model_Front_ShopContentsSortDao | selectShopContentsSort


[SQL(Time=1.22213ms, Records=0]

SELECT 
  CATEGORY_ID, 
  CONTENTS_ID, 
  USE_FLG 
FROM 
  rcuser.T_SHOP_CONTENTS_SORT 
WHERE 
  SHOP_ID = : shop_id 
  AND JOB_ID = : job_id 
ORDER BY 
  ORDER_NUM

[Parameter]
Array
(
    [shop_id] => 42992
    [job_id] => 42915
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 547行 | Application_Model_Front_DiaryDao | selectShopDiaryCnt


[SQL(Time=6.31785ms, Records=1]

SELECT 
  COUNT(0) 
FROM 
  rcuser.C_DIARY D, 
  rcuser.C_MEMBER M, 
  rcuser.M_SHOP S, 
  rcuser.C_COMMU C 
WHERE 
  S.SHOP_ID = : shopId 
  AND S.SHOP_ORG_ID = M.C_COMMU_ID 
  AND M.C_MEMBER_ID = D.C_MEMBER_ID 
  AND M.LOGICAL_DEL_FLG = 0 
  AND M.DATA_STATUS = '01' 
  AND M.MEMBER_ATTRIBUTE = '02' 
  AND M.GIRLS_DISP_FLG IN ('01', '02') 
  AND C.C_COMMU_ID = M.C_COMMU_ID 
  AND C.LOGICAL_DEL_FLG = 0 
  AND C.KEISAI_STATE = '01' 
  AND D.LOGICAL_DEL_FLG = 0 
  AND D.CREATE_DATE > SYSDATE + (: display_days)

[Parameter]
Array
(
    [shopId] => 42992
    [display_days] => -7
)


/var/GirlsApp/application/controllers/chunk/www/FpJobDetailAction.php | 561行 | Application_Model_Front_PrivilegeDao | selectPrivilege


[SQL(Time=3.81398ms, Records=0]

SELECT 
  J.CM_DEKASEGI_FLG, 
  P.PIC_DEKASEGI, 
  P.PIC_DEKASEGI_COMMENT, 
  P.DEKASEGI_STATUS_FLG, 
  J.CM_HAJIMETE_FLG, 
  P.PIC_HAJIMETE, 
  P.PIC_HAJIMETE_COMMENT, 
  P.HAJIMETE_STATUS_FLG, 
  J.CM_STORE_FLG, 
  P.PIC_STORE, 
  P.PIC_STORE_COMMENT, 
  P.STORE_STATUS_FLG, 
  J.CM_HITODUMA_FLG, 
  P.PIC_HITODUMA, 
  P.PIC_HITODUMA_COMMENT, 
  P.HITODUMA_STATUS_FLG, 
  J.CM_HOSHOKIN_FLG, 
  P.PIC_HOSHOKIN, 
  P.PIC_HOSHOKIN_COMMENT, 
  P.HOSHOKIN_STATUS_FLG 
FROM 
  rcuser.T_JOB J 
  INNER JOIN rcuser.T_PRIVILEGE P ON P.SHOP_ID = J.SHOP_ID 
WHERE 
  J.SHOP_ID = : shop_id 
  AND J.STATUS_FLG = : j_status_flg1 
  AND J.KEISAI_DT <= SYSDATE

[Parameter]
Array
(
    [shop_id] => 42992
    [j_status_flg1] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpInnerHeadAction.php | 378行 | Application_Model_Front_LargeareaDao | selectLargeAreaFromSmallArea


[SQL(Time=0.86904ms, Records=1]

SELECT 
  LARGE.AREA_ID LARGE_AREA_ID, 
  LARGE.AREA_NAME LARGE_AREA_NAME, 
  MIDDLE.AREA_ID MIDDLE_AREA_ID, 
  MIDDLE.AREA_NAME MIDDLE_AREA_NAME, 
  SMALL.AREA_ID SMALL_AREA_ID, 
  SMALL.AREA_NAME SMALL_AREA_NAME 
FROM 
  rcuser.M_AREA SMALL 
  INNER JOIN rcuser.M_MIDDLE_AREA MIDDLE ON MIDDLE.AREA_ID = SMALL.MIDDLE_AREA_ID 
  AND MIDDLE.STATUS_FLG = : status_flg 
  INNER JOIN rcuser.M_LARGE_AREA LARGE ON LARGE.AREA_ID = MIDDLE.LARGE_AREA_ID 
  AND LARGE.STATUS_FLG = : status_flg 
WHERE 
  SMALL.STATUS_FLG = : status_flg 
  AND SMALL.AREA_ID = : area_id 
ORDER BY 
  LARGE.ORDER_NUM, 
  MIDDLE.ORDER_NUM, 
  SMALL.ORDER_NUM

[Parameter]
Array
(
    [area_id] => 238
    [status_flg] => 1
)


/var/GirlsApp/application/modules/GirlsUtil.php | 6862行 | Application_Model_Front_ShopDao | selectShopAreaId


[SQL(Time=1.41096ms, Records=1]

SELECT 
  M.LARGE_AREA_ID, 
  A.MIDDLE_AREA_ID, 
  J.AREA_ID, 
  S.MAINAREA_ID, 
  S.URL_DIRECTORY 
FROM 
  rcuser.T_JOB J 
  LEFT JOIN rcuser.M_SHOP S ON S.SHOP_ID = J.SHOP_ID 
  AND S.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
  AND A.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
  AND M.STATUS_FLG = : status_flg 
WHERE 
  S.MAINAREA_ID = : mainarea_id 
  AND S.URL_DIRECTORY = : url_directory

[Parameter]
Array
(
    [mainarea_id] => 2
    [url_directory] => 'prettyprincessandmrsagehaaizuten'
    [status_flg] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpHeaderAction.php | 361行 | Application_Model_Front_PydThemeDao | selectThemeInfoCnt


[SQL(Time=8.10385ms, Records=1]

SELECT 
  COUNT(0) AS COUNT 
FROM 
  rcuser.M_PYD_THEME PT 
WHERE 
  PT.STATUS_FLG = : status_flg 
  AND PT.MAINAREA_ID = : mainarea_id 
  AND PT.KEISAI_START_DT <= SYSDATE 
  AND (
    PT.KEISAI_END_DT > SYSDATE 
    OR PT.INDEFINITE_FLG = : status_flg
  ) 
  AND EXISTS (
    SELECT 
      'X' 
    FROM 
      rcuser.M_PYD_THEME_TARGET PTT 
      INNER JOIN rcuser.T_JOB J ON J.SHIGOTO_NO = PTT.SHIGOTO_NO 
      AND J.STATUS_FLG = : status_flg 
      AND J.KEISAI_DT <= SYSDATE 
      INNER JOIN rcuser.M_SHOP S ON S.SHOP_ID = J.SHOP_ID 
      AND S.STATUS_FLG = : status_flg 
      AND S.MAINAREA_ID = : mainarea_id 
      INNER JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
      AND A.STATUS_FLG = : status_flg 
      INNER JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
      AND M.STATUS_FLG = : status_flg 
      INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = M.LARGE_AREA_ID 
      AND L.STATUS_FLG = : status_flg 
      AND L.AREA_ID = : large_area_id 
    WHERE 
      PTT.PYD_THEME_ID = PT.PYD_THEME_ID
  )

[Parameter]
Array
(
    [mainarea_id] => 2
    [large_area_id] => 52
    [status_flg] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpHeaderAction.php | 375行 | Application_Model_Front_JobDao | selectJobCount


[SQL(Time=2.37608ms, Records=1]

SELECT 
  NVL(
    COUNT(1), 
    0
  ) AS JOB_CNT 
FROM 
  rcuser.T_JOB TJ 
  INNER JOIN rcuser.M_SHOP MS ON TJ.SHOP_ID = MS.SHOP_ID 
  AND MS.STATUS_FLG = : s_status_flg 
  AND MS.MAINAREA_ID = : mainareaId 
  INNER JOIN rcuser.M_AREA A ON A.AREA_ID = TJ.AREA_ID 
  AND A.STATUS_FLG = : s_status_flg 
  INNER JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
  AND M.STATUS_FLG = : s_status_flg 
  INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = M.LARGE_AREA_ID 
  AND L.STATUS_FLG = : s_status_flg 
  AND L.AREA_ID = : large_area_id 
WHERE 
  TJ.STATUS_FLG = : j_status_flg 
  AND TJ.KEISAI_DT <= SYSDATE

[Parameter]
Array
(
    [large_area_id] => 52
    [j_status_flg] => 1
    [s_status_flg] => 1
    [mainareaId] => 2
)


/var/GirlsApp/application/modules/GirlsUtil.php | 6486行 | Application_Model_Front_GuideNearLargeAreaDao | selectNearList


[SQL(Time=6.65116ms, Records=5]

SELECT 
  G.LARGE_AREA_ID, 
  G.NEAR_LARGE_AREA_ID, 
  L.AREA_NAME LARGE_AREA_NAME, 
  L.MAINAREA_ID, 
  NVL(T.COUNT, 0) COUNT 
FROM 
  rcuser.M_GUIDE_NEAR_LARGE_AREA G 
  INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = G.NEAR_LARGE_AREA_ID 
  AND L.STATUS_FLG = : status_flg 
  INNER JOIN (
    SELECT 
      L.AREA_ID, 
      COUNT(0) AS COUNT 
    FROM 
      rcuser.T_JOB J 
      INNER JOIN rcuser.M_SHOP S ON J.SHOP_ID = S.SHOP_ID 
      AND S.STATUS_FLG = : status_flg 
      INNER JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
      AND A.STATUS_FLG = : status_flg 
      AND A.MAINAREA_ID = S.MAINAREA_ID 
      INNER JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
      AND M.STATUS_FLG = : status_flg 
      AND M.MAINAREA_ID = S.MAINAREA_ID 
      INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = M.LARGE_AREA_ID 
      AND L.STATUS_FLG = : status_flg 
      AND L.MAINAREA_ID = S.MAINAREA_ID 
    WHERE 
      J.STATUS_FLG = : status_flg 
      AND J.KEISAI_DT <= SYSDATE 
    GROUP BY 
      L.AREA_ID
  ) T ON T.AREA_ID = G.NEAR_LARGE_AREA_ID 
WHERE 
  G.LARGE_AREA_ID = : large_area_id 
  AND G.STATUS_FLG = : status_flg 
ORDER BY 
  G.ORDER_NUM

[Parameter]
Array
(
    [large_area_id] => 52
    [status_flg] => 1
)


/var/GirlsApp/application/modules/GirlsUtil.php | 6862行 | Application_Model_Front_ShopDao | selectShopAreaId


[SQL(Time=1.04904ms, Records=1]

SELECT 
  M.LARGE_AREA_ID, 
  A.MIDDLE_AREA_ID, 
  J.AREA_ID, 
  S.MAINAREA_ID, 
  S.URL_DIRECTORY 
FROM 
  rcuser.T_JOB J 
  LEFT JOIN rcuser.M_SHOP S ON S.SHOP_ID = J.SHOP_ID 
  AND S.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
  AND A.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
  AND M.STATUS_FLG = : status_flg 
WHERE 
  S.MAINAREA_ID = : mainarea_id 
  AND S.URL_DIRECTORY = : url_directory

[Parameter]
Array
(
    [mainarea_id] => 2
    [url_directory] => 'prettyprincessandmrsagehaaizuten'
    [status_flg] => 1
)


/var/GirlsApp/application/modules/DecoOptionUtil.php | 515行 | Application_Model_Front_ShopDecoOptionDao | selectShopDecoOption


[SQL(Time=1.48296ms, Records=0]

SELECT 
  SD.SHIGOTO_NO, 
  SD.DECO_TERMINAL_TYPE, 
  SD.MENU_COLOR_RGB, 
  SD.BG_CHOICE_FLG, 
  SD.BG_COLOR_RGB, 
  SD.BG_COLLECTION_ID, 
  SD.BG_IMG_FILE_NAME, 
  SD.BG_IMG_APPROVAL_FLG, 
  TO_CHAR(
    SD.BG_IMG_REG_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS BG_IMG_REG_DT, 
  SD.MAIN_FONT_COLOR_RGB, 
  SD.MAIN_LINK_COLOR_RGB, 
  SD.SHOP_LINK_COLOR_RGB, 
  SD.HEADLINE_COLOR_RGB, 
  SD.HEADLINE_FONT_COLOR_RGB, 
  SD.LINE_COLOR_RGB, 
  TO_CHAR(
    SD.REG_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS REG_DT, 
  SD.REG_AGENT_ID, 
  TO_CHAR(
    SD.UPDATE_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS UPDATE_DT, 
  SD.UPDATE_AGENT_ID, 
  TO_CHAR(
    SD.REG_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS REG_SHOP_DT, 
  SD.REG_SHOP_ID, 
  TO_CHAR(
    SD.UPDATE_SHOP_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS UPDATE_SHOP_DT, 
  SD.UPDATE_SHOP_ID, 
  GC.COLLECTION_NAME, 
  GC.COLLECTION_PIC_NAME, 
  GC.COLLECTION_TYPE, 
  GC.CATEGORY_ID, 
  TO_CHAR(
    GC.UPDATE_DT, 'yyyy/mm/dd hh24:mi:ss'
  ) AS GC_UPDATE_DT, 
  C1.COLOR_ID AS MENU_COLOR_ID, 
  C1.COLOR_CODE AS MENU_COLOR_CODE, 
  C2.COLOR_ID AS BG_COLOR_ID, 
  C2.COLOR_CODE AS BG_COLOR_CODE, 
  C3.COLOR_ID AS MAIN_FONT_COLOR_ID, 
  C3.COLOR_CODE AS MAIN_FONT_COLOR_CODE, 
  C4.COLOR_ID AS MAIN_LINK_COLOR_ID, 
  C4.COLOR_CODE AS MAIN_LINK_COLOR_CODE, 
  C5.COLOR_ID AS SHOP_LINK_COLOR_ID, 
  C5.COLOR_CODE AS SHOP_LINK_COLOR_CODE, 
  C6.COLOR_ID AS HEADLINE_COLOR_ID, 
  C6.COLOR_CODE AS HEADLINE_COLOR_CODE, 
  C7.COLOR_ID AS HEADLINE_FONT_COLOR_ID, 
  C7.COLOR_CODE AS HEADLINE_FONT_COLOR_CODE, 
  C8.COLOR_ID AS LINE_COLOR_ID, 
  C8.COLOR_CODE AS LINE_COLOR_CODE 
FROM 
  rcuser.T_SHOP_DECO_OPTION SD 
  LEFT JOIN rcuser.M_GIRLS_COLLECTION GC ON GC.COLLECTION_ID = SD.BG_COLLECTION_ID 
  AND GC.COLLECTION_TYPE IN (0, : deco_terminal_type) 
  AND GC.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C1 ON C1.COLOR_ID = SD.MENU_COLOR_ID 
  AND C1.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C2 ON C2.COLOR_ID = SD.BG_COLOR_ID 
  AND C2.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C3 ON C3.COLOR_ID = SD.MAIN_FONT_COLOR_ID 
  AND C3.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C4 ON C4.COLOR_ID = SD.MAIN_LINK_COLOR_ID 
  AND C4.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C5 ON C5.COLOR_ID = SD.SHOP_LINK_COLOR_ID 
  AND C5.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C6 ON C6.COLOR_ID = SD.HEADLINE_COLOR_ID 
  AND C6.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C7 ON C7.COLOR_ID = SD.HEADLINE_FONT_COLOR_ID 
  AND C7.STATUS_FLG = : status_flg 
  LEFT JOIN rcuser.M_DECO_COLOR C8 ON C8.COLOR_ID = SD.LINE_COLOR_ID 
  AND C8.STATUS_FLG = : status_flg 
WHERE 
  SD.SHIGOTO_NO = : shigoto_no 
  AND SD.DECO_TERMINAL_TYPE = : deco_terminal_type

[Parameter]
Array
(
    [shigoto_no] => 1100000863
    [deco_terminal_type] => 1
    [status_flg] => 1
)


/var/GirlsApp/application/controllers/chunk/www/FpFooterAction.php | 78行 | Application_Model_Front_JobTainyuDao | countJobTainyu


[SQL(Time=2.86913ms, Records=1]

SELECT 
  COUNT(0) 
FROM 
  rcuser.T_JOB J 
  INNER JOIN rcuser.M_SHOP S ON S.SHOP_ID = J.SHOP_ID 
  AND S.STATUS_FLG = : status_flg 
  AND S.TAINYU_FLG = : tainyu_flg 
  AND S.ADV_TYPE < : adv_type_d 
  AND S.MAINAREA_ID = : mainarea_id 
  INNER JOIN rcuser.M_AREA A ON A.AREA_ID = J.AREA_ID 
  AND A.STATUS_FLG = : status_flg 
  INNER JOIN rcuser.M_MIDDLE_AREA M ON M.AREA_ID = A.MIDDLE_AREA_ID 
  AND M.STATUS_FLG = : status_flg 
  INNER JOIN rcuser.M_LARGE_AREA L ON L.AREA_ID = M.LARGE_AREA_ID 
  AND L.STATUS_FLG = : status_flg 
  AND L.AREA_ID = : large_area_id 
  INNER JOIN rcuser.T_JOB_TAINYU T ON T.SHIGOTO_NO = J.SHIGOTO_NO 
  AND T.STATUS_FLG = : status_flg 
WHERE 
  J.STATUS_FLG = : status_flg 
  AND J.KEISAI_DT <= SYSDATE

[Parameter]
Array
(
    [mainarea_id] => 2
    [large_area_id] => 52
    [status_flg] => 1
    [tainyu_flg] => 1
    [adv_type_d] => 4
)


/var/GirlsApp/application/modules/GirlsUtil.php | 2086行 | Application_Model_Front_JobDao | selectJobUrlDirectory


[SQL(Time=2.26593ms, Records=1]

SELECT 
  J.SHOP_ID, 
  J.GYOUSYU_ID, 
  J.KEN_JIS, 
  J.AREA_ID, 
  J.STATUS_FLG, 
  J.JOB_ID, 
  J.SHIGOTO_NO, 
  J.DX_TEMPLATE_FLG, 
  J.SNS_ID, 
  J.SNS_LINK, 
  S.SHOP_ORG_ID, 
  S.SHOP_NAME, 
  S.MAINAREA_ID, 
  S.OFFICE_NAME, 
  S.ADV_TYPE, 
  S.EMAIL_TENSOU, 
  S.EMAIL_TENSOU_2, 
  S.EMAIL_TENSOU_3, 
  S.OFFICIALIZE_FLG, 
  S.URL_DIRECTORY, 
  S.DX_OPTION_FLG, 
  S.DX_DESIGN_FLG, 
  S.DX_PC_LINK_FLG, 
  G.GYOUSYU_NAME, 
  K.KEN_NAME, 
  A.AREA_NAME, 
  J.AREA_ID SMALL_AREA_ID, 
  A.MIDDLE_AREA_ID, 
  MA.LARGE_AREA_ID, 
  GYOUSYU.BUSINESS_FIRST_ID BUSINESS_FIRST_ID, 
  NVL(
    BFTO.BUSINESS_FIRST_SUB_NAME, GYOUSYU.BUSINESS_FIRST_NAME
  ) BUSINESS_FIRST_NAME_SEO, 
  NVL(
    BSTO.BUSINESS_SECOND_SUB_NAME, GYOUSYU.BUSINESS_SECOND_NAME
  ) BUSINESS_SECOND_NAME 
FROM 
  rcuser.T_JOB J 
  LEFT JOIN rcuser.M_SHOP S ON J.SHOP_ID = S.SHOP_ID 
  AND S.STATUS_FLG = : s_status_flg 
  LEFT JOIN rcuser.M_GYOUSYU G ON J.GYOUSYU_ID = G.GYOUSYU_ID 
  AND G.STATUS_FLG = : g_status_flg 
  LEFT JOIN rcuser.M_KEN K ON J.KEN_JIS = K.KEN_JIS 
  LEFT JOIN rcuser.M_AREA A ON J.AREA_ID = A.AREA_ID 
  AND A.STATUS_FLG = : a_status_flg 
  LEFT JOIN (
    SELECT 
      BS.JOB_ID, 
      BFT.BUSINESS_FIRST_ID, 
      BFT.BUSINESS_FIRST_NAME, 
      BST.BUSINESS_SECOND_ID, 
      BST.BUSINESS_SECOND_NAME 
    FROM 
      rcuser.T_PYD_BUSINESS_SEARCH BS 
      INNER JOIN rcuser.M_PYD_BUSINESS_SECOND_TYPE BST ON BS.BUSINESS_SECOND_ID = BST.BUSINESS_SECOND_ID 
      AND BST.STATUS_FLG = : bst_status_flg 
      INNER JOIN rcuser.M_PYD_BUSINESS_FIRST_TYPE BFT ON BFT.BUSINESS_FIRST_ID = BST.BUSINESS_FIRST_ID 
      AND BFT.STATUS_FLG = : bft_status_flg
  ) GYOUSYU ON GYOUSYU.JOB_ID = J.JOB_ID 
  LEFT JOIN rcuser.M_MIDDLE_AREA MA ON MA.AREA_ID = A.MIDDLE_AREA_ID 
  AND MA.STATUS_FLG = : ma_status_flg 
  LEFT JOIN rcuser.M_PYD_BIZ_FIRST_TYPE_OTHER BFTO ON BFTO.AREA_ID = MA.LARGE_AREA_ID 
  AND BFTO.BUSINESS_FIRST_ID = GYOUSYU.BUSINESS_FIRST_ID 
  LEFT JOIN rcuser.M_PYD_BIZ_SECOND_TYPE_OTHER BSTO ON BSTO.AREA_ID = MA.LARGE_AREA_ID 
  AND BSTO.BUSINESS_SECOND_ID = GYOUSYU.BUSINESS_SECOND_ID 
  LEFT JOIN rcuser.M_LARGE_AREA LA ON LA.AREA_ID = MA.LARGE_AREA_ID 
  AND LA.STATUS_FLG = : la_status_flg 
WHERE 
  S.URL_DIRECTORY = : sgtdir 
  AND S.STATUS_FLG = : s_status_flg 
  AND S.MAINAREA_ID = : main_area 
  AND J.KEISAI_DT <= SYSDATE 
  AND J.STATUS_FLG = : j_status_flg

[Parameter]
Array
(
    [main_area] => 2
    [sgtdir] => 'prettyprincessandmrsagehaaizuten'
    [s_status_flg] => 1
    [g_status_flg] => 1
    [a_status_flg] => 1
    [bst_status_flg] => 1
    [bft_status_flg] => 1
    [ma_status_flg] => 1
    [la_status_flg] => 1
    [j_status_flg] => 1
)


/var/GirlsApp/application/models/front/CrawlerDao.php | 74行 | Application_Model_BaseDao | executeSelect


[SQL(Time=1.47891ms, Records=1]

SELECT 
  COUNT(0) 
FROM 
  rcuser.Z_CRAWLER 
WHERE 
  (
    : crawler_str LIKE '%' || CRAWLER_STR || '%' 
    AND CRAWLER_METHOD IN (
      : crawler_method0, : crawler_method1
    )
  ) 
  OR (
    : http_remoteaddr LIKE '%' || CRAWLER_STR || '%' 
    AND : crawler_type = crawler_type 
    AND CRAWLER_METHOD IN (
      : crawler_method0, : crawler_method1
    )
  )

[Parameter]
Array
(
    [crawler_str] => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
    [crawler_type] => 'ipaddress'
    [http_remoteaddr] => '10.100.115.252'
    [crawler_method0] => 'contains'
    [crawler_method1] => 'starts_with'
)