Квартиры и апартаменты посуточно в Каменске-Шахтинском.

Фото 2-комнатная квартира в Каменске-Шахтинском, ул. Освобождения,13

2-комнатная квартира на сутки

3000 ₽/сутки

50 м² 2/5 этаж до 4 чел.

Чистая уютная квартира, находится в районе хлебозавода, рядом центр.рынок, "Магнит", аптека, сауна, воинская часть, автобусные остановки, во дворе дома имеются парковочные места. Хороший ремонт ,бытовая техника, два двухспальных дивана + дополнительно, если нужна, раскладная 1-спальная кровать с доп...

Лилия (2 квартиры)

Фото 2-комнатная квартира в Каменске-Шахтинском, ул. Освобождения,10

2-комнатная квартира посуточно

3000 ₽/сутки

50 м² 2/2 этаж до 4 чел.

ул. Освобождения,10 | Центральный рынок

Чистая уютная квартира, в каждой комнате стоит двухспальная кровать. Квартира находится в центре города, в районе центрального рынка , рядом центр.рынок, воинская часть, "Магнит", аптека и сауна. Хороший ремонт.Бытовая техника(кондиционер,холодильник,газовая плита , микроволновая печь,фен), Wi-Fi, 2...

Лилия (2 квартиры)

Фото 1-комнатная квартира в Каменске-Шахтинском, Красная 35/3

1-комнатная квартира посуточно

1500 ₽/сутки

35 м² 1/5 этаж до 4 чел.

Красная 35/3

Сдаётся 1-на комнатная квартира студия в новом доме,сделан дорогой качественный ремонт, индивидуальное отопление. Мебель,техника,вай-фай,телевизор, сплит система. Kвapтиpа комфoртна для пpoживания сeмьe с двумя детьми ( двухспальная кровать +диван-кровать)....

Екатерина

Фото 2-комнатная квартира в Каменске-Шахтинском, Халтурина, 4

2-комнатная квартира на сутки

1500 ₽/сутки

48 м² 6/9 этаж

Халтурина, 4 | ж/д вокзал

Сдам посуточно 2-комн. квартиру, район ж/д вокзала, ремонт, уютная, вся необходимая мебель, телевизор, микроволновая печь, (стиральной машины нет), Wi-Fi, кабельное, домофон, сплит, рядом рынок, супермаркет, парковка. Спальные места 2+2. Цена от 1500 ₽. Залог 500 руб. за ключи. КВАРТИРА НЕ СДАЁТСЯ...

Ольга

Total (ms)

Load (ms)

App (ms)

Query (ms)

Count

Average (ms)

Template

Order

11.3

0.023

11.3

/opt/v2/html/views/city/index.cfm

240

9.11

0.016

9.09

/opt/v2/html/views/city/_searchArea.cfm

264

8.56

0.021

8.54

/opt/v2/html/views/city/_list.cfm

319

8.1

/opt/v2/html/models/Apartment.cfc$getApartments2

177

/opt/v2/html/controllers/City.cfc$$invoke

144

1.05

/opt/v2/html/events/onsessionstart.cfm$setCity

1.96

0.04

1.92

0.961

/opt/v2/html/wheels/plugins/standalone/injection.cfm

8.93

0.893

/opt/v2/html/views/city/index.cfm$urlFor

317

3.76

0.752

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$executeQuery

1.16

0.584

/opt/v2/html/controllers/City.cfc$setCity

172

0.449

0.013

0.436

/opt/v2/html/wheels/index.cfm

0.444

0.008

0.435

/opt/v2/html/views/layout.cfm

333

0.366

/opt/v2/html/wheels/Dispatch.cfc$$findMatchingRoute

0.336

/opt/v2/html/controllers/City.cfc$$runVerifications

158

0.698

0.232

/opt/v2/html/Application.cfc$$simpleLock

0.397

0.198

/opt/v2/html/controllers/City.cfc$$simpleLock

143

0.367

0.183

/opt/v2/html/views/layout.cfm$urlFor

351

0.166

/opt/v2/html/models/Metro.cfc$findAll

207

0.499

0.166

/opt/v2/html/models/City.cfc$findAll

0.165

/opt/v2/html/models/Amenity.cfc$findAll

189

0.19

0.034

0.155

/opt/v2/html/wheels/functions.cfm

0.687

0.137

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$performQuery

0.127

/opt/v2/html/views/city/index.cfm$$optionsForSelect

312

0.25

0.125

/opt/v2/html/models/Apartment.cfc$map

179

0.245

0.122

/opt/v2/html/wheels/Dispatch.cfc$$createParams

0.118

/opt/v2/html/views/city/index.cfm$urlfor

253

0.1

/opt/v2/html/views/city/index.cfm$uRLFor

300

0.599

0.099

/opt/v2/html/models/City.cfc$$hashedKey

0.087

/opt/v2/html/Application.cfc$$cgiScope

0.085

/opt/v2/html/views/city/_searchArea.cfm$startFormTag

265

0.17

0.085

/opt/v2/html/models/Amenity.cfc$$hashedKey

196

0.424

0.084

/opt/v2/html/views/city/_searchArea.cfm$uRLFor

269

0.08

/opt/v2/html/views/city/index.cfm$startFormTag

299

0.158

0.079

/opt/v2/html/models/Metro.cfc$$hashedKey

214

0.078

/opt/v2/html/events/onsessionstart.cfm$$invoke

0.078

/opt/v2/html/controllers/City.cfc$$generateAuthenticityToken

150

0.069

/opt/v2/html/models/Apartment.cfc$setPagination

183

0.194

0.064

/opt/v2/html/Application.cfc$$invoke

0.063

/opt/v2/html/wheels/Dispatch.cfc$$invoke

111

2.35

0.057

/opt/v2/html/views/city/_searchArea.cfm$$tag

272

0.168

0.056

/opt/v2/html/models/City.cfc$$addWhereClauseParameters

0.055

/opt/v2/html/models/Metro.cfc$$addWhereClauseParameters

216

0.054

/opt/v2/html/controllers/City.cfc$setPagination

223

0.05

/opt/v2/html/views/city/index.cfm$paginationLinks

326

0.067

0.016

0.05

/opt/v2/html/events/onrequeststart.cfm

0.799

0.049

/opt/v2/html/views/city/_searchArea.cfm$$createLabel

290

0.048

/opt/v2/html/views/city/index.cfm$select

304

0.048

/opt/v2/html/wheels/Dispatch.cfc$$request

0.184

0.046

/opt/v2/html/views/city/_searchArea.cfm$linkTo

275

0.045

/opt/v2/html/controllers/City.cfc$renderView

226

0.179

0.044

/opt/v2/html/views/city/_searchArea.cfm$textField

279

0.042

/opt/v2/html/wheels/Dispatch.cfc$$ensureControllerAndAction

106

0.042

/opt/v2/html/Application.cfc$onSessionStart

0.585

0.041

/opt/v2/html/views/city/_searchArea.cfm$checkBox

292

0.04

/opt/v2/html/controllers/City.cfc$$dollarify

231

0.112

0.037

/opt/v2/html/views/city/index.cfm$$includeAndReturnOutput

263

0.643

0.035

/opt/v2/html/views/city/_searchArea.cfm$$formBeforeElement

283

0.034

/opt/v2/html/wheels/Dispatch.cfc$$mergeRoutePattern

101

0.418

0.034

/opt/v2/html/views/city/_list.cfm$urlFor

320

0.034

/opt/v2/html/controllers/City.cfc$$callAction

166

0.034

/opt/v2/html/views/city/index.cfm$stylesheetlinkTag

241

0.311

0.034

/opt/v2/html/views/city/index.cfm$$tag

250

0.068

0.034

/opt/v2/html/models/City.cfc$findByKey

0.094

0.026

0.068

0.034

/opt/v2/html/wheels/global/internal.cfm

0.094

0.027

0.067

0.033

/opt/v2/html/global/functions.cfm

0.091

0.03

/opt/v2/html/models/City.cfc$$getFromCache

0.03

/opt/v2/html/controllers/City.cfc$processAction

147

0.03

/opt/v2/html/views/city/_searchArea.cfm$hiddenField

296

0.058

0.029

/opt/v2/html/Application.cfc$$initializeRequestScope

0.083

0.029

0.054

0.027

/opt/v2/html/wheels/global/misc.cfm

0.079

0.025

0.053

0.026

/opt/v2/html/wheels/controller/rendering.cfm

0.041

0.014

0.026

/opt/v2/html/wheels/controller/appfunctions.cfm

0.025

/opt/v2/html/models/Metro.cfc$$getFromCache

215

0.076

0.025

/opt/v2/html/models/City.cfc$findOne

0.039

0.014

0.024

/opt/v2/html/wheels/controller/functions.cfm

121

0.024

/opt/v2/html/models/Amenity.cfc$$timeSpanForCache

201

0.024

/opt/v2/html/models/Amenity.cfc$$getFromCache

197

0.024

/opt/v2/html/controllers/City.cfc$$initControllerObject

140

0.038

0.013

0.024

/opt/v2/html/wheels/view/functions.cfm

124

0.12

0.024

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$moveAggregateToHaving

0.336

0.024

/opt/v2/html/views/city/_searchArea.cfm$checkBoxTag

291

0.423

0.023

/opt/v2/html/views/city/_searchArea.cfm$$formAfterElement

286

0.023

/opt/v2/html/controllers/City.cfc$setCityByName

168

0.022

/opt/v2/html/views/city/_searchArea.cfm$submitTag

294

0.067

0.022

/opt/v2/html/views/city/index.cfm$$dollarify

257

0.022

/opt/v2/html/views/city/index.cfm$$formBeforeElement

307

0.021

/opt/v2/html/controllers/City.cfc$$objectFileName

114

0.021

/opt/v2/html/models/Metro.cfc$$timeSpanForCache

219

0.021

/opt/v2/html/wheels/Dispatch.cfc$controller

109

0.02

/opt/v2/html/models/Amenity.cfc$$setDebugName

191

0.02

/opt/v2/html/wheels/Dispatch.cfc$$paramParser

0.019

/opt/v2/html/models/Amenity.cfc$$args

190

0.039

0.019

/opt/v2/html/models/City.cfc$$keyWhereString

0.065

0.026

0.039

0.019

/opt/v2/html/wheels/global/cfml.cfm

0.389

0.019

/opt/v2/html/views/city/index.cfm$hyphenize

318

0.019

/opt/v2/html/views/city/index.cfm$selectTag

303

0.018

/opt/v2/html/views/city/_searchArea.cfm$endFormTag

297

0.018

/opt/v2/html/views/city/index.cfm$$formAfterElement

310

0.052

0.017

/opt/v2/html/views/city/index.cfm$$generateIncludeTemplatePath

260

0.017

/opt/v2/html/controllers/City.cfc$$renderView

236

0.016

/opt/v2/html/events/onsessionstart.cfm$model

0.08

0.016

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$querySetup

0.016

/opt/v2/html/views/layout.cfm$styleSheetLinkTag

335

0.016

/opt/v2/html/controllers/City.cfc$$args

230

0.063

0.015

/opt/v2/html/views/city/_searchArea.cfm$textFieldTag

278

0.015

/opt/v2/html/views/layout.cfm$javaScriptIncludeTag

346

0.015

/opt/v2/html/models/Metro.cfc$$args

208

0.078

0.015

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$identitySelect

0.015

/opt/v2/html/views/city/index.cfm$endFormTag

316

0.166

0.015

/opt/v2/html/views/city/index.cfm$$constructParams

255

0.015

/opt/v2/html/Application.cfc$onRequestStart

0.044

0.014

/opt/v2/html/views/city/_searchArea.cfm$$constructParams

277

0.028

0.014

/opt/v2/html/controllers/City.cfc$$generateIncludeTemplatePath

237

0.014

/opt/v2/html/controllers/City.cfc$$getStatusCodes

235

0.027

0.013

0.014

/opt/v2/html/wheels/view/miscellaneous.cfm

136

0.013

/opt/v2/html/models/Metro.cfc$$setDebugName

209

0.013

/opt/v2/html/views/city/index.cfm$$objectName

305

0.013

/opt/v2/html/views/city/index.cfm$javascriptIncludeTag

330

0.013

/opt/v2/html/models/Apartment.cfc$pagination

184

0.052

0.025

0.027

0.013

/opt/v2/html/wheels/controller/flash.cfm

0.067

0.013

/opt/v2/html/controllers/City.cfc$$doubleCheckedLock

170

0.013

/opt/v2/html/models/Amenity.cfc$$cleanInList

193

0.186

0.013

/opt/v2/html/views/city/_searchArea.cfm$$canonicalize

293

0.039

0.013

/opt/v2/html/models/City.cfc$$cleanInList

0.065

0.013

/opt/v2/html/controllers/City.cfc$model

169

0.013

/opt/v2/html/Application.cfc$$abortInvalidRequest

0.035

0.022

0.012

/opt/v2/html/events/onsessionstart.cfm

0.038

0.012

/opt/v2/html/views/city/index.cfm$$renderPartial

259

0.025

0.012

/opt/v2/html/wheels/controller/csrf.cfm

122

0.012

/opt/v2/html/controllers/City.cfc$url_params

167

0.012

/opt/v2/html/events/onsessionstart.cfm$$doubleCheckedLock

0.012

/opt/v2/html/Application.cfc$getRequestURL

0.036

0.012

/opt/v2/html/views/city/index.cfm$$argumentsForPartial

261

0.06

0.012

/opt/v2/html/views/city/index.cfm$$option

314

0.012

/opt/v2/html/controllers/City.cfc$$runCsrfProtection

148

0.06

0.012

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$removeColumnAliasesInOrderClause

0.027

0.016

0.011

/opt/v2/html/config/app.cfm

0.011

/opt/v2/html/wheels/Dispatch.cfc$$mergeUrlAndFormScopes

0.011

/opt/v2/html/views/city/_searchArea.cfm$hiddenFieldTag

295

0.011

/opt/v2/html/models/Metro.cfc$$listClean

210

0.094

0.011

/opt/v2/html/models/City.cfc$$args

0.223

0.011

/opt/v2/html/views/city/_searchArea.cfm$$objectName

280

0.011

/opt/v2/html/views/city/index.cfm$$tagId

306

0.215

0.011

/opt/v2/html/views/city/_searchArea.cfm$$formValue

289

0.245

0.011

/opt/v2/html/views/city/index.cfm$$args

242

0.048

0.026

0.022

0.011

/opt/v2/html/wheels/global/util.cfm

0.044

0.011

/opt/v2/html/views/city/index.cfm$$findRoute

254

0.049

0.027

0.022

0.011

/opt/v2/html/wheels/controller/caching.cfm

0.01

/opt/v2/html/views/city/index.cfm$$formValue

313

0.109

0.01

/opt/v2/html/views/city/_searchArea.cfm$$findRoute

270

0.048

0.026

0.021

0.01

/opt/v2/html/wheels/controller/miscellaneous.cfm

0.01

/opt/v2/html/wheels/Dispatch.cfc$$getPathFromRequest

0.01

/opt/v2/html/views/city/index.cfm$$routeVariables

301

0.129

0.01

/opt/v2/html/views/city/_list.cfm$$findRoute

322

1.46

136

0.01

/opt/v2/html/views/city/_searchArea.cfm$$tagAttribute

273

0.01

/opt/v2/html/wheels/Dispatch.cfc$$doubleCheckedLock

110

0.042

0.01

/opt/v2/html/views/city/_searchArea.cfm$$maxLength

288

0.181

0.01

/opt/v2/html/views/city/index.cfm$$tagAttribute

251

0.074

0.01

/opt/v2/html/views/layout.cfm$$tag

344

0.01

/opt/v2/html/models/Metro.cfc$$callback

221

0.03

0.01

/opt/v2/html/models/City.cfc$$callback

0.502

0.01

/opt/v2/html/views/city/_searchArea.cfm$$args

266

0.03

0.01

/opt/v2/html/views/city/index.cfm$url_params

252

0.192

0.01

/opt/v2/html/views/city/_searchArea.cfm$$tagId

282

0.02

0.01

/opt/v2/html/views/city/index.cfm$$getFieldLabel

308

0.019

0.009

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$columnAlias

203

0.347

0.009

/opt/v2/html/views/city/_searchArea.cfm$$getFieldLabel

284

0.009

/opt/v2/html/controllers/City.cfc$plural

225

0.025

0.015

0.009

/opt/v2/html/views/helpers.cfm

138

0.067

0.009

/opt/v2/html/views/city/index.cfm$$element

315

0.018

0.009

/opt/v2/html/views/city/index.cfm$$formHasError

309

0.009

/opt/v2/html/models/Apartment.cfc$$get

185

0.018

0.009

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$quoteValue

0.188

0.009

/opt/v2/html/views/city/_searchArea.cfm$$element

276

0.009

/opt/v2/html/models/Amenity.cfc$$callback

205

0.33

0.009

/opt/v2/html/views/city/_searchArea.cfm$$formHasError

285

0.073

0.009

/opt/v2/html/models/City.cfc$$setDebugName

0.008

/opt/v2/html/wheels/Dispatch.cfc$$parseJsonBody

100

0.008

/opt/v2/html/controllers/City.cfc$pagination

224

0.017

0.008

/opt/v2/html/views/city/index.cfm$$listClean

244

0.021

0.012

0.008

/opt/v2/html/wheels/view/forms.cfm

128

0.008

/opt/v2/html/models/Metro.cfc$$cleanInList

211

0.008

/opt/v2/html/views/layout.cfm$$findRoute

353

0.043

0.008

/opt/v2/html/views/city/_searchArea.cfm$$routeVariables

271

0.017

0.008

/opt/v2/html/views/layout.cfm$hyphenize

352

0.008

/opt/v2/html/wheels/Dispatch.cfc$$translateBlankCheckBoxSubmissions

103

0.008

/opt/v2/html/wheels/Dispatch.cfc$$createNestedParamStruct

105

0.008

/opt/v2/html/models/Amenity.cfc$$listClean

192

0.033

0.008

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$queryParams

0.008

/opt/v2/html/models/Apartment.cfc$$appKey

186

0.021

0.013

0.008

/opt/v2/html/wheels/view/formsdate.cfm

130

0.008

/opt/v2/html/controllers/City.cfc$$createControllerObject

113

0.008

/opt/v2/html/Application.cfc$getRequest

0.023

0.007

/opt/v2/html/views/city/index.cfm$$includeFile

262

0.023

0.007

/opt/v2/html/views/city/index.cfm$includePartial

256

0.02

0.012

0.007

/opt/v2/html/wheels/view/formsdateplain.cfm

132

0.02

0.012

0.007

/opt/v2/html/wheels/view/formsobject.cfm

133

0.007

/opt/v2/html/views/layout.cfm$csrfMetaTags

348

0.014

0.007

/opt/v2/html/models/City.cfc$validationTypeForProperty

0.022

0.007

/opt/v2/html/models/City.cfc$$appKey

0.022

0.007

/opt/v2/html/views/city/index.cfm$$includeOrRenderPartial

258

0.036

0.007

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$convertMaxRowsToLimit

0.014

0.007

/opt/v2/html/views/city/index.cfm$$assetDomain

247

0.029

0.007

/opt/v2/html/views/city/index.cfm$$combineArguments

243

0.007

/opt/v2/html/wheels/Dispatch.cfc$$translateDatePartSubmissions

104

0.271

0.007

/opt/v2/html/views/city/_searchArea.cfm$$combineArguments

281

0.013

0.006

/opt/v2/html/controllers/City.cfc$$statusCode

227

0.006

/opt/v2/html/controllers/City.cfc$contentFor

332

0.006

/opt/v2/html/controllers/City.cfc$isAjax

232

0.013

0.006

/opt/v2/html/models/Apartment.cfc$valueList

187

0.013

0.006

/opt/v2/html/models/City.cfc$$keyLengthCheck

0.02

0.006

/opt/v2/html/events/onsessionstart.cfm$keyExists

0.006

/opt/v2/html/controllers/City.cfc$capitalize

115

0.006

/opt/v2/html/models/Amenity.cfc$$addWhereClauseParameters

198

0.006

/opt/v2/html/views/city/_searchArea.cfm$$isRequestProtectedFromForgery

274

0.006

/opt/v2/html/models/Amenity.cfc$primaryKeys

199

0.006

/opt/v2/html/controllers/City.cfc$$setRequestStatusCode

233

0.013

0.006

/root/.CommandBox/server/898B3A89B85F2E1434049D1C125A4336-v2/lucee-6.2.0.321/WEB-INF/lucee-server/context/components/org/lucee/cfml/Component.cfc

0.006

/opt/v2/html/views/city/_weather.cfm$keyExists

329

0.012

0.006

/opt/v2/html/controllers/City.cfc$keyExists

175

0.006

/opt/v2/html/controllers/City.cfc$len

174

0.039

0.026

0.012

0.006

/opt/v2/html/wheels/controller/verifies.cfm

0.019

0.012

0.006

/opt/v2/html/wheels/view/formsplain.cfm

134

0.006

/opt/v2/html/controllers/City.cfc$$returnStatusText

234

0.006

/opt/v2/html/views/city/index.cfm$$isRequestProtectedFromForgery

302

0.006

/opt/v2/html/models/Metro.cfc$$callbacks

222

0.018

0.006

/opt/v2/html/models/City.cfc$$callbacks

0.006

/opt/v2/html/controllers/City.cfc$$writeFlash

359

0.006

/opt/v2/html/models/Amenity.cfc$$get

194

0.039

0.027

0.012

0.006

/opt/v2/html/wheels/controller/layouts.cfm

0.006

/opt/v2/html/models/Apartment.cfc$min

181

0.005

/opt/v2/html/models/Amenity.cfc$$callbacks

206

0.017

0.005

/opt/v2/html/wheels/Dispatch.cfc$$get

0.005

/opt/v2/html/models/Amenity.cfc$primaryKey

200

0.011

0.005

/opt/v2/html/controllers/City.cfc$isGet

154

0.017

0.005

/opt/v2/html/models/City.cfc$$get

0.005

/opt/v2/html/models/Amenity.cfc$$appKey

195

0.011

0.005

/opt/v2/html/controllers/City.cfc$$runFilters

161

0.005

/opt/v2/html/views/layout.cfm$includeContent

354

0.011

0.005

/opt/v2/html/controllers/City.cfc$$includeFile

238

0.111

0.005

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$isAggregateFunction

0.005

/opt/v2/html/controllers/City.cfc$getApartments2

176

0.011

0.005

/opt/v2/html/models/Apartment.cfc$keyExists

180

0.017

0.012

0.005

/opt/v2/html/wheels/view/assets.cfm

125

0.043

0.005

/opt/v2/html/models/City.cfc$$listClean

0.005

/opt/v2/html/events/onsessionstart.cfm$findByKey

0.005

/opt/v2/html/models/Metro.cfc$primaryKey

218

0.01

0.005

/opt/v2/html/events/onrequeststart.cfm$keyExists

0.037

0.026

0.01

0.005

/opt/v2/html/wheels/controller/filters.cfm

0.005

/opt/v2/html/controllers/City.cfc$$renderLayout

331

0.01

0.005

/opt/v2/html/controllers/City.cfc$getResponse

228

0.004

/opt/v2/html/Application.cfc$onRequestEnd

363

0.017

0.012

0.004

/opt/v2/html/wheels/view/links.cfm

135

0.059

0.004

/opt/v2/html/views/city/_list.cfm$$args

321

0.019

0.004

/opt/v2/html/Application.cfc$$include

0.009

0.004

/opt/v2/html/controllers/City.cfc$findAll

188

0.009

0.004

/opt/v2/html/views/city/_list.cfm$plural

325

0.009

0.004

/opt/v2/html/controllers/City.cfc$getStatus

229

0.033

0.004

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$get

0.004

/opt/v2/html/wheels/Dispatch.cfc$$addRouteName

108

0.009

0.004

/opt/v2/html/controllers/Controller.cfc$keyExists

139

0.004

/opt/v2/html/wheels/Dispatch.cfc$$deobfuscateParams

102

0.035

0.026

0.009

0.004

/opt/v2/html/wheels/controller/provides.cfm

0.036

0.027

0.009

0.004

/opt/v2/html/wheels/controller/initialization.cfm

0.032

0.004

/opt/v2/html/models/City.cfc$primaryKey

0.004

/opt/v2/html/controllers/City.cfc$findOne

171

0.004

/opt/v2/html/models/Apartment.cfc$listlen

178

0.023

0.004

/opt/v2/html/views/layout.cfm$$args

336

0.013

0.004

/opt/v2/html/wheels/Dispatch.cfc$$appKey

0.004

/opt/v2/html/models/Metro.cfc$$get

212

0.013

0.004

/opt/v2/html/views/city/index.cfm$$renderLayout

298

0.004

/opt/v2/html/models/Metro.cfc$primaryKeys

217

0.004

/opt/v2/html/controllers/City.cfc$verificationChain

159

0.008

0.004

/opt/v2/html/controllers/City.cfc$filterChain

162

0.008

0.004

/opt/v2/html/views/city/index.cfm$isSecure

248

0.029

0.004

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$appKey

0.004

/opt/v2/html/models/Metro.cfc$$appKey

213

0.004

/opt/v2/html/Application.cfc$$restoreTestRunnerApplicationScope

364

0.018

0.014

0.003

/opt/v2/html/wheels/global/functions.cfm

123

0.003

/opt/v2/html/controllers/City.cfc$$abortIssued

160

0.003

/opt/v2/html/wheels/Dispatch.cfc$$addRouteFormat

107

0.007

0.003

/opt/v2/html/views/layout.cfm$$listClean

338

0.003

/opt/v2/html/controllers/City.cfc$$hasCachableActions

156

0.025

0.003

/opt/v2/html/models/City.cfc$primaryKeys

0.003

/opt/v2/html/wheels/Dispatch.cfc$$getRequestMethod

0.017

0.013

0.003

/opt/v2/html/wheels/view/formsassociation.cfm

129

0.003

/opt/v2/html/wheels/Dispatch.cfc$$createControllerObject

112

0.033

0.026

0.006

0.003

/opt/v2/html/wheels/controller/processing.cfm

0.048

0.003

/opt/v2/html/controllers/City.cfc$$get

141

0.016

0.013

0.003

/opt/v2/html/wheels/events/onsessionstart.cfm

0.069

0.003

/opt/v2/html/views/layout.cfm$$tagAttribute

345

0.016

0.013

0.003

/opt/v2/html/wheels/events/onmissingtemplate.cfm

0.003

/opt/v2/html/models/Metro.cfc$$querySetup

220

0.016

0.013

0.003

/opt/v2/html/wheels/events/onrequestend.cfm

0.006

0.003

/opt/v2/html/views/city/index.cfm$$appendQueryString

249

0.003

/opt/v2/html/models/Amenity.cfc$$querySetup

202

0.043

0.003

/opt/v2/html/controllers/City.cfc$$appKey

142

0.003

/opt/v2/html/wheels/index.cfm$$request

0.003

/opt/v2/html/controllers/City.cfc$findByKey

173

0.003

/opt/v2/html/controllers/City.cfc$$storeAuthenticityToken

149

0.005

0.002

/opt/v2/html/controllers/City.cfc$$getControllerClassData

145

0.261

0.002

/opt/v2/html/views/city/index.cfm$$get

245

0.015

0.012

0.002

/opt/v2/html/wheels/events/onsessionend.cfm

0.005

0.002

/opt/v2/html/views/layout.cfm$$generateAuthenticityToken

349

0.008

0.002

/opt/v2/html/models/City.cfc$$querySetup

0.578

197

0.002

/opt/v2/html/views/city/_searchArea.cfm$$get

267

0.016

0.013

0.002

/opt/v2/html/wheels/events/onerror.cfm

0.002

/opt/v2/html/controllers/City.cfc$response

362

0.005

0.002

/opt/v2/html/models/City.cfc$$quoteValue

0.005

0.002

/opt/v2/html/views/layout.cfm$$combineArguments

337

0.005

0.002

/opt/v2/html/controllers/City.cfc$$performedRenderOrRedirect

163

0.015

0.012

0.002

/opt/v2/html/wheels/events/onrequeststart.cfm

0.008

0.002

/opt/v2/html/views/layout.cfm$$element

347

0.031

0.026

0.005

0.002

/opt/v2/html/global/_ymap.cfm

0.015

0.012

0.002

/opt/v2/html/wheels/view/errors.cfm

127

0.016

0.013

0.002

/opt/v2/html/wheels/view/formsdateobject.cfm

131

0.005

0.002

/opt/v2/html/views/city/index.cfm$pagination

327

0.516

197

0.002

/opt/v2/html/views/city/_searchArea.cfm$$appKey

268

0.002

/opt/v2/html/controllers/City.cfc$$flashClear

357

0.002

/opt/v2/html/models/Apartment.cfc$max

182

0.226

0.002

/opt/v2/html/views/city/index.cfm$$appKey

246

0.015

0.012

0.002

/opt/v2/html/wheels/view/csrf.cfm

126

0.002

/opt/v2/html/controllers/City.cfc$$setAuthenticityToken

152

0.002

/opt/v2/html/controllers/City.cfc$$cachableActions

157

0.015

0.013

0.002

/opt/v2/html/wheels/events/onapplicationstart.cfm

0.004

0.002

/opt/v2/html/controllers/City.cfc$$isVerifiedRequest

153

0.002

/opt/v2/html/controllers/City.cfc$flashClear

358

0.011

0.002

/opt/v2/html/views/layout.cfm$$assetDomain

341

0.015

0.013

0.002

/opt/v2/html/wheels/view/sanitize.cfm

137

0.002

/opt/v2/html/controllers/City.cfc$$flagRequestAsProtected

151

0.011

0.008

0.002

/opt/v2/html/views/city/_weather.cfm

328

0.042

0.002

/opt/v2/html/views/city/_searchArea.cfm$$tagName

287

0.002

/opt/v2/html/views/city/index.cfm$$tagName

311

0.015

0.013

0.002

/opt/v2/html/wheels/events/onrequest.cfm

0.004

0.002

/opt/v2/html/wheels/model/adapters/MySQL.cfc$$comment

204

0.017

0.015

0.002

/opt/v2/html/wheels/events/onapplicationend.cfm

0.006

0.002

/opt/v2/html/views/layout.cfm$keyExists

334

0.024

0.002

/opt/v2/html/views/city/_list.cfm$$get

323

0.001

/opt/v2/html/wheels/Dispatch.cfc$$performedRedirect

355

0.029

0.026

0.003

0.001

/opt/v2/html/wheels/controller/redirection.cfm

0.001

/opt/v2/html/controllers/City.cfc$$verifyAuthenticityToken

155

0.001

/opt/v2/html/views/layout.cfm$authenticityToken

350

0.015

0.013

0.001

/opt/v2/html/wheels/events/onabort.cfm

0.018

0.001

/opt/v2/html/views/city/_list.cfm$$appKey

324

0.001

/opt/v2/html/wheels/Dispatch.cfc$processAction

146

0.005

0.001

/opt/v2/html/controllers/City.cfc$$performedRender

164

0.001

/opt/v2/html/wheels/Dispatch.cfc$response

361

0.006

0.001

/opt/v2/html/views/layout.cfm$isSecure

342

0.005

0.001

/opt/v2/html/views/layout.cfm$$appendQueryString

343

0.001

/opt/v2/html/wheels/Dispatch.cfc$$flashClear

356

0.003

0.001

/opt/v2/html/controllers/City.cfc$$performedRedirect

165

0.045

/opt/v2/html/views/layout.cfm$$get

339

0.001

/opt/v2/html/controllers/City.cfc$$getFlashStorage

360

0.035

/opt/v2/html/views/layout.cfm$$appKey

340

0.008

0.007

/opt/v2/html/events/onrequestend.cfm

365

0.02

/opt/v2/html/root.cfm

117

0.014

/opt/v2/html/rewrite.cfm

0.013

/opt/v2/html/wheels/global/appfunctions.cfm

/opt/v2/html/wheels/Controller.cfc

120

2.04

/opt/v2/html/Application.cfc

/opt/v2/html/controllers/Controller.cfc

119

/opt/v2/html/controllers/City.cfc

118

/opt/v2/html/controllers/City.cfc$$createObjectFromRoot

116

/opt/v2/html/controllers/City.cfc$$includeAndReturnOutput

239

/opt/v2/html/Application.cfc$onRequest

Template

Line

Scope

Var

Count

/opt/v2/html/controllers/City.cfc

variables

set404

/opt/v2/html/controllers/City.cfc

variables

params_string

/opt/v2/html/controllers/City.cfc

variables

params_string

/opt/v2/html/controllers/City.cfc

variables

canonicalLink

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

perPage

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

perPage

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

objects

/opt/v2/html/controllers/City.cfc

variables

totalRecords

/opt/v2/html/controllers/City.cfc

variables

roomsFound

/opt/v2/html/controllers/City.cfc

variables

showFrom

/opt/v2/html/controllers/City.cfc

variables

showTo

/opt/v2/html/controllers/City.cfc

variables

amenitiesList

/opt/v2/html/controllers/City.cfc

variables

metroStations

/opt/v2/html/controllers/City.cfc

variables

totalRecords

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

params

/opt/v2/html/controllers/City.cfc

variables

sorting_select

/opt/v2/html/controllers/City.cfc

102

variables

params

/opt/v2/html/controllers/City.cfc

106

variables

pgData

/opt/v2/html/controllers/City.cfc

107

variables

params

/opt/v2/html/controllers/City.cfc

107

variables

pgData

/opt/v2/html/controllers/City.cfc

107

variables

totalRecords

/opt/v2/html/controllers/City.cfc

110

variables

totalRecords

/opt/v2/html/controllers/City.cfc

125

variables

set404

/opt/v2/html/controllers/City.cfc

128

variables

canonicalLink

/opt/v2/html/controllers/City.cfc

132

variables

header

/opt/v2/html/controllers/City.cfc

133

variables

keywords

/opt/v2/html/controllers/City.cfc

134

variables

description

/opt/v2/html/controllers/City.cfc

135

variables

title

/opt/v2/html/controllers/City.cfc

138

variables

params

/opt/v2/html/controllers/City.cfc

172

variables

totalRecords

/opt/v2/html/controllers/City.cfc

172

variables

header

/opt/v2/html/controllers/City.cfc

173

variables

keywords

/opt/v2/html/controllers/City.cfc

174

variables

description

/opt/v2/html/controllers/City.cfc

175

variables

title

/opt/v2/html/controllers/City.cfc

179

variables

params

/opt/v2/html/controllers/City.cfc

185

variables

params

/opt/v2/html/controllers/City.cfc

185

variables

objects

/opt/v2/html/controllers/City.cfc

190

variables

params

/opt/v2/html/controllers/City.cfc

197

variables

params

/opt/v2/html/global/functions.cfm

382

variables

cflock

/opt/v2/html/global/functions.cfm

388

variables

localTime

/opt/v2/html/global/functions.cfm

389

variables

localTime

/opt/v2/html/plugins/htmx/htmx.cfc

variables

core

/opt/v2/html/wheels../global/functions.cfm

382

variables

cflock

/opt/v2/html/wheels../global/functions.cfm

388

variables

localTime

/opt/v2/html/wheels../global/functions.cfm

389

variables

localTime

/opt/v2/html/wheels../models/Apartment.cfc

195

arguments

price_from

/opt/v2/html/wheels../models/Apartment.cfc

196

arguments

price_to

/opt/v2/html/wheels../models/Apartment.cfc

232

variables

cfquery

/opt/v2/html/wheels../models/Apartment.cfc

246

variables

cfquery

/opt/v2/html/wheels../models/Apartment.cfc

248

variables

cfquery

/opt/v2/html/wheels../models/Apartment.cfc

250

variables

cfquery

/opt/v2/html/wheels../models/Apartment.cfc

272

variables

cfquery

/opt/v2/html/wheels../models/Apartment.cfc

290

variables

cfquery

/opt/v2/html/wheels../models/Apartment.cfc

307

variables

pgData

/opt/v2/html/wheels../models/Apartment.cfc

309

variables

pgData

/opt/v2/html/wheels../models/Apartment.cfc

333

variables

cfquery

/opt/v2/html/wheels../models/Apartment.cfc

351

variables

pgData

/opt/v2/html/wheels../models/Apartment.cfc

352

variables

pgData

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

filename2x

/opt/v2/html/wheels../views/city/_list.cfm

variables

headerText

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objectLink

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_list.cfm

variables

objects

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

roomsFound

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

roomsFound

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

roomsFound

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

metroStations

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

amenitiesList

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/_searchArea.cfm

variables

params

/opt/v2/html/wheels../views/city/index.cfm

variables

totalRecords

/opt/v2/html/wheels../views/city/index.cfm

variables

totalRecords

/opt/v2/html/wheels../views/city/index.cfm

variables

params

/opt/v2/html/wheels../views/city/index.cfm

variables

params

/opt/v2/html/wheels../views/city/index.cfm

variables

totalRecords

/opt/v2/html/wheels../views/city/index.cfm

variables

totalRecords

/opt/v2/html/wheels../views/city/index.cfm

variables

params

/opt/v2/html/wheels../views/city/index.cfm

variables

sorting_select

/opt/v2/html/wheels../views/city/index.cfm

variables

params

/opt/v2/html/wheels../views/city/index.cfm

variables

key

/opt/v2/html/wheels../views/city/index.cfm

variables

key

/opt/v2/html/wheels../views/city/index.cfm

variables

key

/opt/v2/html/wheels../views/layout.cfm

variables

description

/opt/v2/html/wheels../views/layout.cfm

170

variables

params

/opt/v2/html/wheels../views/layout.cfm

175

variables

params

/opt/v2/html/wheels../views/layout.cfm

190

variables

params

/opt/v2/html/wheels/events/onrequest.cfm

variables

cflock

/opt/v2/html/wheels/global/cfml.cfm

variables

cflock

/opt/v2/html/wheels/global/cfml.cfm

112

variables

local

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

/opt/v2/html/wheels/plugins/standalone/injection.cfm

variables

$wheels

Name

Open Connections

Max Connections

sstorage

INF

maindb

INF

stat

INF

Name

Records

Time

Usage

Datasource

Source

Line

Cached

0.44 ms

100%

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='79d9efb3-4ac1-4f15-bac9-1ed014d9a983' AND name='gorkvartira' AND expires > '1751290526762'

SQL (Explicit Parameters)

SELECT data FROM cf_session_data WHERE cfid={type: "CF_SQL_VARCHAR", value: '79d9efb3-4ac1-4f15-bac9-1ed014d9a983'} AND name={type: "CF_SQL_VARCHAR", value: 'gorkvartira'} AND expires > {type: "CF_SQL_VARCHAR", value: '1751290526762'}

Query column usage
All columns are used

0.732 ms

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='29c6bcb7-44cc-48e3-b95c-45130c13b471' AND name='gorkvartira' AND expires > '1751290531213'

SQL (Explicit Parameters)

SELECT data FROM cf_session_data WHERE cfid={type: "CF_SQL_VARCHAR", value: '29c6bcb7-44cc-48e3-b95c-45130c13b471'} AND name={type: "CF_SQL_VARCHAR", value: 'gorkvartira'} AND expires > {type: "CF_SQL_VARCHAR", value: '1751290531213'}

Query column usage
None of the columns are used

0.385 ms

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='29c6bcb7-44cc-48e3-b95c-45130c13b471' AND name='gorkvartira' AND expires > '1751290531214'

SQL (Explicit Parameters)

Query column usage
None of the columns are used

0.483 ms

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='29c6bcb7-44cc-48e3-b95c-45130c13b471' AND name='gorkvartira' AND expires > '1751290531214'

SQL (Explicit Parameters)

Query column usage
None of the columns are used

local.cityFindByKeyQuery

0.792 ms

21%

maindb

/opt/v2/html/wheels/model/adapters/cfquery.cfm

SQL (Merged Parameters)

SELECT cities.cityid,cities.countryid,cities.regionId,cities.city,cities.city1,cities.city_en,cities.city_alias,cities.lat,cities.lng,cities.zoomlevel,cities.tz,cities.perpage,cities.iscapital,cities.minprice FROM cities WHERE cities.cityId = 1 LIMIT 1

SQL (Explicit Parameters)

Query column usage
the following columns are NOT used:

perpage

city_alias

regionId

city1

countryid

iscapital

lat

zoomlevel

lng

city

minprice

local.cityfindOneQuery

0.611 ms

100%

maindb

/opt/v2/html/wheels/model/adapters/cfquery.cfm

SQL (Merged Parameters)

SELECT cities.cityid FROM cities WHERE cities.city_en = 'kamensk-shahtinsky' LIMIT 1

SQL (Explicit Parameters)

SELECT cities.cityid FROM cities WHERE cities.city_en = {type: "CF_SQL_VARCHAR", value: 'kamensk-shahtinsky'} LIMIT 1

Query column usage
All columns are used

local.cityFindByKeyQuery

0.574 ms

42%

maindb

/opt/v2/html/wheels/model/adapters/cfquery.cfm

SQL (Merged Parameters)

SQL (Explicit Parameters)

Query column usage
the following columns are NOT used:

city_alias

regionId

countryid

iscapital

lat

zoomlevel

lng

minprice

local.whatToQuery

1.36 ms

100%

maindb

/opt/v2/html/models/Apartment.cfc

199

SQL (Merged Parameters)

SELECT a.cityId, a.apartmentId,GROUP_CONCAT(apam.amenityid SEPARATOR ',') as amenitiesList, a.rooms, a.dayPrice, a.currency, a.street, a.updatedAt, a.position FROM apartments a INNER JOIN members m ON a.memberId = m.memberId LEFT OUTER JOIN apartments_amenities apam ON a.apartmentId = apam.apartmentId LEFT OUTER JOIN metro ON a.stationId = metro.stationId WHERE m.isVisible AND m.isActive AND a.isVisible AND a.isActive AND EXISTS(SELECT 1 FROM photos WHERE photos.objectId = a.apartmentId) AND a.cityId = 187 GROUP BY a.apartmentId

SQL (Explicit Parameters)

Query column usage
All columns are used

sRoomsResult.one

0.093 ms

/opt/v2/html/wheels../models/Apartment.cfc

246

SQL

SELECT 0 FROM whatToQuery WHERE rooms = 1

Query column usage
None of the columns are used

sRoomsResult.two

0.039 ms

/opt/v2/html/wheels../models/Apartment.cfc

248

SQL

SELECT 0 FROM whatToQuery WHERE rooms = 2

Query column usage
None of the columns are used

sRoomsResult.three

0.036 ms

/opt/v2/html/wheels../models/Apartment.cfc

250

SQL

SELECT 0 FROM whatToQuery WHERE rooms >= 3

Query column usage
None of the columns are used

whatToQuery

0.123 ms

100%

/opt/v2/html/wheels../models/Apartment.cfc

272

SQL

SELECT * FROM whatToQuery WHERE dayPrice BETWEEN 0 AND 1500000

Query column usage
All columns are used

whatToQuery

0.123 ms

22%

/opt/v2/html/wheels../models/Apartment.cfc

290

SQL

SELECT * FROM whatToQuery ORDER BY position ASC

Query column usage
the following columns are NOT used:

position

amenitiesList

street

cityId

updatedAt

rooms

currency

local.getData

1.92 ms

100%

maindb

/opt/v2/html/models/Apartment.cfc

319

SQL

SELECT a.apartmentId,a.memberId,a.contactName,a.contactTel,a.contactTel2,a.currency,a.district, a.dayPrice,a.hourPrice,a.rooms,a.livingspace,a.floor,a.floors,a.standartGuests,a.street,LEFT(a.descriptiontext, 300) as descriptionText, a.distance,a.lat,a.lng,a.updatedAt,a.dateVerified,a.isVisible,a.rank,a.rankAccount,a.isParking,m.Transfer,m.documents,metro.stationName ,(SELECT count(apartments.apartmentId) FROM apartments WHERE memberid = a.memberid AND a.isVisible) as apartmentsCount /*Сдает apartmentscount квартир */ ,(SELECT count(photoId) FROM photos WHERE objectId = a.apartmentId) as photosCount /*всего photosCount фотографий*/ ,(SELECT filename FROM photos WHERE objectId = a.apartmentId ORDER BY sortOrder ASC, createdAt ASC LIMIT 1) as filename, 1 as smsLimit FROM apartments a INNER JOIN members m ON a.memberId=m.memberId LEFT JOIN metro ON a.stationId = metro.stationId WHERE a.apartmentId IN (1211751,1211752,1199656,48363) GROUP BY a.apartmentId ORDER BY FIELD(apartmentId, 1211751,1211752,1199656,48363)

Query column usage
All columns are used

local.amenityfindAllQuery

0 ms

100%

maindb

/opt/v2/html/wheels/model/adapters/cfquery.cfm

Yes

SQL

SELECT amenities.id,amenities.name FROM amenities ORDER BY amenities.sortorder ASC /* cachekey:E83F9E11C55C774963F385AC2B95D09D */

Query column usage
All columns are used

local.metrofindAllQuery

0.725 ms

maindb

/opt/v2/html/wheels/model/adapters/cfquery.cfm

SQL (Merged Parameters)

SELECT metro.stationName,metro.stationId,metrolines.lineid,metrolines.lineName,metrolines.lineColor FROM metro INNER JOIN metrolines ON metro.metrolineId = metrolines.lineId WHERE metro.cityId = 187 ORDER BY metro.stationName ASC

SQL (Explicit Parameters)

Query column usage
None of the columns are used

4 квартиры посуточно в Каменске-Шахтинском

2-комнатная квартира на сутки

2-комнатная квартира посуточно

1-комнатная квартира посуточно

2-комнатная квартира на сутки