SELECT `prefectures`.* FROM `prefectures`Connection name: default Speed: 0.288 ms Query analysis: · Query: SIMPLE on prefectures · Type: ALL · Rows: 47 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 12File: COREPATH/classes/request.php, line 481File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT `prefectures`.* FROM `prefectures` WHERE `prefectureId` = '14' LIMIT 1 OFFSET 0Connection name: default Speed: 0.618 ms Query analysis: · Query: SIMPLE on prefectures · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: COREPATH/classes/model/crud.php, line 101File: APPPATH/classes/controller/search.php, line 127File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT `prefectures`.* FROM `prefectures` WHERE `prefectureId` = '14' LIMIT 1 OFFSET 0Connection name: default Speed: 1.872 ms · DUPLICATE Query analysis: · Query: SIMPLE on prefectures · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: COREPATH/classes/model/crud.php, line 101File: APPPATH/classes/controller/search.php, line 249File: APPPATH/classes/controller/search.php, line 153File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT JSON_OBJECT(
"areaId", areas.areaId,
"areaName", areas.areaName,
"code", areas.code,
"prefectureId", areas.prefectureId,
"areatype", areas.areatype
) AS parentArea, CASE
WHEN areas.areatype = 0 THEN
IFNULL((
SELECT JSON_ARRAYAGG(
JSON_OBJECT(
"areaId", child.areaId,
"areaName", child.areaName,
"code", child.code,
"order", child.`order`,
"prefectureId", child.prefectureId
)
ORDER BY child.`order`
)
FROM areas AS child
WHERE child.parentAreaId = areas.areaId
AND child.areatype = 1
), JSON_ARRAY())
ELSE
JSON_ARRAY(
JSON_OBJECT(
"areaId", areas.areaId,
"areaName", areas.areaName,
"code", areas.code,
"order", areas.`order`,
"prefectureId", areas.prefectureId
)
)
END AS childAreas FROM `areas` WHERE (`areas`.`areatype` = 0 OR (`areas`.`areatype` = 1 AND `areas`.`parentAreaId` IS NULL)) AND `areas`.`prefectureId` = '14' ORDER BY `areas`.`order` ASC, `areas`.`areaId`Connection name: default Speed: 4.531 ms Query analysis: · Query: PRIMARY on areas · Type: ALL · Rows: 1058 (Using where; Using filesort) · Query: DEPENDENT SUBQUERY on child · Type: ALL · Rows: 1058 (Using where) Call trace for this query:File: APPPATH/classes/model/areas.php, line 91File: APPPATH/classes/controller/search.php, line 250File: APPPATH/classes/controller/search.php, line 153File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT `search_salaries`.* FROM `search_salaries` ORDER BY `order` ASCConnection name: default Speed: 1.864 ms Query analysis: · Query: SIMPLE on search_salaries · Type: ALL · Rows: 26 (Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/search.php, line 251File: APPPATH/classes/controller/search.php, line 153File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT `treatments`.* FROM `treatments` ORDER BY `order` ASCConnection name: default Speed: 1.433 ms Query analysis: · Query: SIMPLE on treatments · Type: ALL · Rows: 24 (Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/search.php, line 252File: APPPATH/classes/controller/search.php, line 153File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT `job_employment_status`.* FROM `job_employment_status` ORDER BY `order` ASCConnection name: default Speed: 0.089 ms Query analysis: · Query: SIMPLE on job_employment_status · Type: ALL · Rows: 4 (Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/search.php, line 253File: APPPATH/classes/controller/search.php, line 153File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT
parent.occupationId AS parentId,
parent.occupationName AS parentName,
child.occupationId AS childId,
child.occupationName AS childName
FROM
occupations parent
LEFT JOIN
occupations child
ON
parent.occupationId = child.parentOccupationId
WHERE
parent.occupationType = 0
AND parent.showFlag = 1
AND (child.showFlag = 1 OR child.occupationId IS NULL)
ORDER BY
parent.`order` ASC,
child.`order` ASC;Connection name: default Speed: 0.301 ms Query analysis: · Query: SIMPLE on parent · Type: ALL · Rows: 21 (Using where; Using temporary; Using filesort) · Query: SIMPLE on child · Type: ALL · Rows: 21 (Using where; Using join buffer (flat, BNL join)) Call trace for this query:File: APPPATH/classes/model/occupations.php, line 52File: APPPATH/classes/controller/search.php, line 254File: APPPATH/classes/controller/search.php, line 153File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT `shops`.`name`, `shops`.`level`, `jobs`.*, `prefectures`.`prefectureName`, `prefectures`.`colorCode` FROM `jobs` LEFT JOIN `shops` ON (`jobs`.`shopId` = `shops`.`shopId`) LEFT JOIN `prefectures` ON (`jobs`.`shopWorkingPrefectureId` = `prefectures`.`prefectureId`) LEFT JOIN `occupations` ON (`jobs`.`occupationId` = `occupations`.`occupationId`) WHERE `jobs`.`showFlag` = 1 AND `jobs`.`shopWorkingPrefectureId` = '14' AND ((
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '鶴ヶ峰', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '横浜', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '平沼橋', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '西横浜', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '天王町', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '星川', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '和田町', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '上星川', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '西谷', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '鶴ヶ峰', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '二俣川', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '希望ヶ丘', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '三ツ境', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '瀬谷', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '大和', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '相模大塚', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', 'さがみ野', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', 'かしわ台', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '海老名', 'line', '相模鉄道本線'),
'$'
) = 1)) AND `status` = 0 AND `accountStatus` = 0 AND `jobs`.`jobId` > 0 ORDER BY `shops`.`level` DESC, ISNULL(scOriginalJobId), ISNULL(shops.ownerTel) AND ISNULL(shops.managerTel), `jobs`.`updateDatetime` DESCConnection name: default Speed: 82.832 ms Query analysis: · Query: SIMPLE on jobs · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 7454 (Using where; Using temporary; Using filesort) · Query: SIMPLE on shops · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on prefectures · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobs.php, line 210File: APPPATH/classes/controller/search.php, line 166File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT `shops`.`name`, `shops`.`level`, `jobs`.*, `prefectures`.`prefectureName`, `prefectures`.`colorCode` FROM `jobs` LEFT JOIN `shops` ON (`jobs`.`shopId` = `shops`.`shopId`) LEFT JOIN `prefectures` ON (`jobs`.`shopWorkingPrefectureId` = `prefectures`.`prefectureId`) LEFT JOIN `occupations` ON (`jobs`.`occupationId` = `occupations`.`occupationId`) WHERE `jobs`.`showFlag` = 1 AND `jobs`.`shopWorkingPrefectureId` = '14' AND ((
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '鶴ヶ峰', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '横浜', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '平沼橋', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '西横浜', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '天王町', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '星川', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '和田町', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '上星川', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '西谷', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '鶴ヶ峰', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '二俣川', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '希望ヶ丘', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '三ツ境', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '瀬谷', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '大和', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '相模大塚', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', 'さがみ野', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', 'かしわ台', 'line', '相模鉄道本線'),
'$'
) = 1) OR (
JSON_CONTAINS(
shopNearestStationJson,
JSON_OBJECT('name', '海老名', 'line', '相模鉄道本線'),
'$'
) = 1)) AND `status` = 0 AND `accountStatus` = 0 AND `jobs`.`jobId` > 0 ORDER BY `shops`.`level` DESC, ISNULL(scOriginalJobId), ISNULL(shops.ownerTel) AND ISNULL(shops.managerTel), `jobs`.`updateDatetime` DESC LIMIT 10 OFFSET 0Connection name: default Speed: 268.353 ms Query analysis: · Query: SIMPLE on jobs · Possible keys: PRIMARY · Key Used: PRIMARY · Type: range · Rows: 7454 (Using where; Using temporary; Using filesort) · Query: SIMPLE on shops · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on prefectures · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobs.php, line 227File: APPPATH/classes/controller/search.php, line 166File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 17901 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 50.453 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 17898 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 11.517 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 14506 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 8.987 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 7991 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 9.053 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 17842 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 7.872 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 17840 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 7.295 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 17817 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 8.282 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 17712 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 6.740 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 7448 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 8.067 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `job_photos` JOIN `photos` ON (`job_photos`.`photoId` = `photos`.`photoId`) WHERE `jobId` = 13403 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 7.731 ms Query analysis: · Query: SIMPLE on job_photos · Type: ALL · Rows: 27761 (Using where; Using filesort) · Query: SIMPLE on photos · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: APPPATH/classes/model/jobphotos.php, line 46File: APPPATH/classes/controller/search.php, line 174File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |
SELECT * FROM `banner` WHERE `bannerType` = 2 AND (((`activeDateStart` <= CURDATE() OR `activeDateEnd` >= CURDATE()) OR (`activeDateStart` IS null AND `activeDateEnd` IS null)) AND (`targetPrefectureId` = '14' OR `targetPrefectureId` = 0)) ORDER BY `insertDatetime` ASC, `bannerOrder` ASC, `bannerId` ASCConnection name: default Speed: 1.540 ms Query analysis: · Query: SIMPLE on banner · Type: ALL · Rows: 8 (Using where; Using filesort) Call trace for this query:File: APPPATH/classes/model/banner.php, line 72File: APPPATH/classes/controller/search.php, line 179File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 136File: DOCROOT/index.php, line 175 |