Однокомнатные квартиры посуточно в Уфе. Страница 9

Фото 1-комнатная квартира в Уфе, Менделеева 138

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

2500 ₽/сутки

42 м² 11/14 этаж до 3 чел.

Множество вариантов, 1-2 комнатные квартиры, см другие предложения арендодателя. Уникальный "лофт", для ценителей искусства и новых ощущений, 4 метра потолки, большое иллюминаторное окно с прекрасным видом на город, дизайнерский ремонт с искусной отделкой. Кровать Кинг сайз ручной работы, из массив...

Григорий (16 квартир)

Фото 1-комнатная квартира в Уфе, кирова 52

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

2000 ₽/сутки

53 м² 11/16 этаж до 2 чел.

кирова 52 | Центр, Центральный рынок

1-2 комнатные квартиры евроуровня, Wi-Fi, нал-безнал, кабельное. Квартира с авторским дизайном интерьера от Анжелы Подрядовой, многоуровневые потолки, декоративные стеллажи ручной работы, детальное освещение, см. фото. Просторная квартира в 50 квадратных метров с большой лоджией и потрясающим видом...

Генадий (16 квартир)

Total (ms)

Load (ms)

App (ms)

Query (ms)

Count

Average (ms)

Template

Order

22.8

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

177

10.8

0.023

10.7

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

240

9.04

0.017

9.03

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

264

3.2

0.011

3.19

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

319

9.25

3.08

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

252

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

167

12.8

1.6

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

144

8.12

0.812

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

317

0.732

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

1.22

0.027

1.19

0.596

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

2.48

0.497

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

0.982

0.491

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

179

0.482

0.009

0.472

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

334

0.777

0.388

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

172

0.385

0.008

0.377

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

0.261

0.014

0.246

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

0.244

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

158

0.218

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

0.392

0.196

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

352

0.164

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

190

0.318

0.159

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

143

0.477

0.159

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

0.149

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

208

0.142

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

312

0.137

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

326

0.629

0.125

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

0.114

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

253

0.337

0.112

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

0.174

0.087

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

197

0.171

0.085

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

215

0.085

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

299

0.083

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

265

0.411

0.082

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

269

0.155

0.077

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

0.074

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

183

0.388

0.064

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

0.061

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

2.36

0.057

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

272

0.055

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

217

0.155

0.051

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

0.05

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

0.049

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

304

0.049

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

224

0.787

0.049

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

290

0.048

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

150

0.133

0.044

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

263

0.174

0.043

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

275

0.043

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

226

0.172

0.043

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

279

0.042

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

111

0.203

0.04

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

300

0.563

0.04

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

292

0.037

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

231

0.036

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

0.646

0.035

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

283

0.107

0.035

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

0.046

0.011

0.035

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

0.033

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

241

0.397

0.03

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

250

0.028

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

216

0.028

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

296

0.028

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

198

0.166

0.027

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

320

0.027

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

106

0.026

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

202

0.026

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

191

0.026

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

114

0.025

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

0.4

0.025

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

255

0.049

0.024

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

0.338

0.024

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

291

0.024

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

166

0.071

0.023

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

277

0.023

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

101

0.422

0.023

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

286

0.069

0.023

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

0.022

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

307

0.022

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

220

0.06

0.016

0.044

0.022

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

0.044

0.022

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

0.061

0.017

0.043

0.021

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

0.021

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

147

0.021

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

181

0.064

0.021

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

0.021

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

294

0.02

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

209

0.02

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

230

0.059

0.019

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

257

0.019

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

303

0.093

0.018

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

0.018

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

192

0.018

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

297

0.018

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

310

0.053

0.017

0.035

0.017

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

0.017

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

182

0.052

0.016

0.035

0.017

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

0.027

0.01

0.017

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

0.352

0.017

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

318

0.017

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

236

0.017

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

347

0.026

0.009

0.017

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

121

0.017

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

187

0.016

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

140

0.016

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

316

0.064

0.016

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

278

0.016

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

168

0.767

0.015

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

266

0.015

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

336

0.024

0.009

0.015

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

124

0.043

0.014

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

260

0.014

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

109

0.434

0.014

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

242

0.028

0.014

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

237

0.014

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

235

0.014

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

0.056

0.014

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

328

0.013

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

331

0.013

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

305

0.013

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

184

0.188

0.013

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

293

0.026

0.013

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

0.065

0.013

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

314

0.063

0.012

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

0.012

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

210

0.012

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

295

0.012

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

194

0.04

0.016

0.024

0.012

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

0.012

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

211

0.012

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

306

0.229

0.012

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

280

0.059

0.011

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

170

0.011

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

0.034

0.011

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

259

0.011

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

313

0.055

0.011

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

169

0.055

0.011

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

0.11

0.011

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

270

0.076

0.01

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

345

1.47

136

0.01

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

273

0.043

0.01

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

288

0.01

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

0.053

0.01

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

0.084

0.01

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

0.01

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

0.021

0.01

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

204

0.01

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

0.198

0.01

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

289

0.01

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

354

0.192

0.01

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

282

0.03

0.01

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

261

0.359

0.009

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

284

0.019

0.009

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

353

0.019

0.009

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

308

0.017

0.008

0.009

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

136

0.025

0.015

0.009

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

0.009

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

206

0.019

0.009

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

309

0.009

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

185

0.036

0.017

0.019

0.009

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

0.189

0.009

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

276

0.056

0.009

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

322

0.028

0.009

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

0.017

0.008

0.009

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

122

0.009

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

0.328

0.009

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

285

0.009

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

193

0.008

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

349

0.017

0.008

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

244

0.043

0.008

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

271

0.214

0.008

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

251

0.008

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

186

0.008

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

212

0.008

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

148

0.034

0.017

0.016

0.008

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

0.008

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

103

0.015

0.007

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

180

0.039

0.007

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

337

0.007

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

0.031

0.007

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

243

0.022

0.007

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

0.007

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

222

0.018

0.011

0.007

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

0.007

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

225

0.007

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

332

0.017

0.009

0.007

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

138

0.032

0.017

0.014

0.007

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

0.021

0.007

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

256

0.274

0.007

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

281

0.007

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

333

0.007

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

330

0.007

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

105

0.007

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

110

0.014

0.007

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

0.007

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

0.014

0.007

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

247

0.014

0.007

0.006

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

128

0.029

0.016

0.013

0.006

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

0.006

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

360

0.006

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

234

0.013

0.006

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

227

0.006

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

233

0.006

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

195

0.019

0.006

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

258

0.019

0.006

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

262

0.006

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

104

0.006

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

232

0.006

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

200

0.006

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

113

0.006

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

274

0.006

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

199

0.006

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

302

0.025

0.006

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

0.068

0.006

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

315

0.012

0.006

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

0.006

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

0.072

0.006

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

254

0.006

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

207

0.005

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

174

0.029

0.005

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

0.005

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

355

0.035

0.005

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

321

0.011

0.005

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

175

0.011

0.005

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

238

0.045

0.005

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

0.005

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

364

0.017

0.005

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

298

0.005

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

223

0.005

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

100

0.013

0.008

0.005

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

132

0.005

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

201

0.013

0.008

0.005

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

133

0.013

0.008

0.005

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

130

0.005

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

219

0.005

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

196

0.01

0.005

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

188

0.005

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

176

0.009

0.004

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

189

0.009

0.004

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

0.014

0.004

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

0.004

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

213

0.004

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

115

0.013

0.004

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

0.009

0.004

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

228

0.004

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

365

0.009

0.004

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

229

0.012

0.007

0.004

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

134

0.008

0.004

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

161

0.004

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

218

0.008

0.004

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

248

0.012

0.007

0.004

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

125

0.087

0.004

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

0.008

0.004

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

339

0.008

0.004

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

0.024

0.016

0.008

0.004

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

0.027

0.018

0.008

0.004

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

0.004

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

203

0.008

0.004

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

0.02

0.004

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

301

0.012

0.004

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

0.015

0.003

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

0.003

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

214

0.007

0.003

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

154

0.011

0.003

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

0.025

0.003

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

0.007

0.003

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

338

0.007

0.003

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

139

0.007

0.003

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

162

0.003

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

178

0.007

0.003

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

325

0.011

0.007

0.003

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

135

0.025

0.018

0.007

0.003

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

0.003

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

0.027

0.003

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

0.023

0.003

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

0.069

0.003

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

346

0.006

0.003

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

249

0.003

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

221

0.024

0.018

0.006

0.003

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

0.003

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

156

0.012

0.009

0.003

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

129

0.006

0.003

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

350

0.022

0.016

0.006

0.003

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

0.003

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

151

0.009

0.003

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

0.012

0.009

0.003

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

123

0.02

0.002

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

0.002

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

363

0.002

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

171

0.002

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

160

0.002

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

358

0.579

197

0.002

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

267

0.002

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

102

0.002

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

108

0.002

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

0.008

0.002

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

348

0.281

100

0.002

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

245

0.008

0.002

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

0.038

0.002

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

141

0.005

0.002

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

327

0.52

197

0.002

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

268

0.002

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

0.002

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

107

0.002

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

159

0.017

0.002

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

0.012

0.002

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

342

0.033

0.002

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

142

0.004

0.002

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

205

0.022

0.017

0.004

0.002

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

0.01

0.008

0.002

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

131

0.01

0.008

0.002

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

0.231

100

0.002

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

246

0.002

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

311

0.002

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

359

0.004

0.002

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

0.01

0.008

0.002

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

0.002

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

112

0.041

0.002

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

287

0.01

0.008

0.002

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

137

0.004

0.002

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

163

0.006

0.002

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

335

0.02

0.016

0.004

0.002

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

0.006

0.002

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

0.002

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

173

0.002

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

149

0.01

0.008

0.002

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

127

0.001

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

356

0.012

0.01

0.001

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

329

0.01

0.008

0.001

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

0.009

0.007

0.001

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

0.009

0.007

0.001

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

0.001

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

157

0.01

0.008

0.001

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

0.003

0.001

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

145

0.009

0.007

0.001

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

0.009

0.007

0.001

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

126

0.009

0.001

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

323

0.003

0.001

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

153

0.009

0.001

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

324

0.001

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

351

0.001

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

152

0.009

0.007

0.001

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

0.006

0.001

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

343

0.005

0.001

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

344

0.01

0.009

0.001

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

0.001

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

155

0.009

0.008

0.001

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

0.018

0.016

0.002

0.001

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

0.001

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

362

0.003

0.001

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

165

0.001

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

146

0.003

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

164

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

357

0.001

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

361

0.044

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

340

0.01

0.009

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

366

0.036

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

341

0.013

/opt/v2/html/root.cfm

117

0.009

/opt/v2/html/rewrite.cfm

0.008

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

1.85

/opt/v2/html/Application.cfc

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

119

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

120

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

118

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

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

116

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

239

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

params_string

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

variables

canonicalLink

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

variables

params_string

/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

140

variables

header

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

141

variables

keywords

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

142

variables

description

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

143

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

186

variables

params

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

187

variables

params

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

188

variables

params

/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

261

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

showTo

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

variables

showFrom

/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/helpers.cfm

104

variables

item

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

105

variables

item

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

106

variables

item

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

107

variables

item

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

108

variables

item

/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.543 ms

100%

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='5b3f6593-3066-421a-8095-51f086100c41' AND name='gorkvartira' AND expires > '1751290114894'

SQL (Explicit Parameters)

SELECT data FROM cf_session_data WHERE cfid={type: "CF_SQL_VARCHAR", value: '5b3f6593-3066-421a-8095-51f086100c41'} AND name={type: "CF_SQL_VARCHAR", value: 'gorkvartira'} AND expires > {type: "CF_SQL_VARCHAR", value: '1751290114894'}

Query column usage
All columns are used

0.561 ms

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='dcf9d5a9-cdd3-4d3c-9578-519698235d98' AND name='gorkvartira' AND expires > '1751290117558'

SQL (Explicit Parameters)

SELECT data FROM cf_session_data WHERE cfid={type: "CF_SQL_VARCHAR", value: 'dcf9d5a9-cdd3-4d3c-9578-519698235d98'} AND name={type: "CF_SQL_VARCHAR", value: 'gorkvartira'} AND expires > {type: "CF_SQL_VARCHAR", value: '1751290117558'}

Query column usage
None of the columns are used

0.281 ms

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='dcf9d5a9-cdd3-4d3c-9578-519698235d98' AND name='gorkvartira' AND expires > '1751290117559'

SQL (Explicit Parameters)

Query column usage
None of the columns are used

0.463 ms

sstorage

/opt/v2/html/Application.cfc

SQL (Merged Parameters)

SELECT data FROM cf_session_data WHERE cfid='dcf9d5a9-cdd3-4d3c-9578-519698235d98' AND name='gorkvartira' AND expires > '1751290117559'

SQL (Explicit Parameters)

Query column usage
None of the columns are used

local.cityFindByKeyQuery

0.621 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.56 ms

100%

maindb

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

SQL (Merged Parameters)

SELECT cities.cityid FROM cities WHERE cities.city_en = 'ufa' LIMIT 1

SQL (Explicit Parameters)

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

Query column usage
All columns are used

local.cityFindByKeyQuery

0.506 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

230

14.2 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 a.dayPrice >= 1990 AND EXISTS(SELECT 1 FROM photos WHERE photos.objectId = a.apartmentId) AND a.cityId = 11 GROUP BY a.apartmentId

SQL (Explicit Parameters)

Query column usage
All columns are used

sRoomsResult.one

162

0.263 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.116 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.1 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

162

0.449 ms

100%

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

261

SQL

SELECT * FROM whatToQuery WHERE rooms = 1

Query column usage
All columns are used

whatToQuery

162

0.338 ms

100%

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

272

SQL

SELECT * FROM whatToQuery WHERE dayPrice BETWEEN 0 AND 15000

Query column usage
All columns are used

whatToQuery

162

0.615 ms

100%

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

290

SQL

SELECT * FROM whatToQuery ORDER BY position ASC

Query column usage
All columns are used

local.getData

1.66 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 (237393,51364) GROUP BY a.apartmentId ORDER BY FIELD(apartmentId, 237393,51364)

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 ms

maindb

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

Yes

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 = 11 ORDER BY metro.stationName ASC

SQL (Explicit Parameters)

Query column usage
None of the columns are used