SELECT `prefectures`.* FROM `prefectures`Connection name: default Speed: 0.311 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.200 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: 0.184 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: 2.087 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: 0.190 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: 0.110 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.082 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.221 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) 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: 350.889 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) 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: 637.462 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` = 14454 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 50.508 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` = 15768 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 6.824 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` = 15769 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 7.979 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` = 15770 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 6.878 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` = 3896 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 10.647 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` = 3903 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 12.305 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` = 3888 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 12.401 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` = 3905 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 12.331 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` = 15765 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 12.662 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` = 9654 ORDER BY `jobDisplayOrder` ASC LIMIT 3Connection name: default Speed: 11.752 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: 0.973 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 |