Однокомнатные квартиры посуточно в Вологде. на карте

Debugging Information

User Agent:

Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])

Lucee (Gelert) Os 6.1.1.118 (CFML Version 2016,0,03,300357)
Time Stamp	21 нояб. 2024 г. 19:11
Time Zone	Europe/Moscow
Locale	Ru_ru
Remote IP	3.142.98.60
Host Name	gorkvartira.ru
Architecture	64bit

Execution Time

103.1 ms Total

0.06 ms	Startup/Compilation
59.5 ms	Application
43.5 ms	Query

Templates

363 Templates Executed

Total (ms)	Load (ms)	App (ms)	Count	Average (ms)	Template	Order
44.7	0	44.7	1	-	/opt/v2/html/models/Apartment.cfc$getApartments2	176
7.99	0	7.98	1	-	/opt/v2/html/wheels/index.cfm	89
3.74	0	3.74	1	-	/opt/v2/html/controllers/City.cfc$compressHtml	319
8.36	0	8.36	3	2.78	/opt/v2/html/views/city/_map.cfm$each	309
2.36	0	2.36	2	1.18	/opt/v2/html/models/Apartment.cfc$map	178
0.815	0	0.815	1	-	/opt/v2/html/views/city/_weather.cfm$$invoke	328
1.27	0	1.27	2	0.635	/opt/v2/html/views/layout.cfm$urlFor	349
0.6	0	0.6	1	-	/opt/v2/html/views/city/_map.cfm$yMap3	315
2.79	0	2.79	5	0.559	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$executeQuery	74
3.4	0	3.4	8	0.425	/opt/v2/html/controllers/City.cfc$$invoke	144
1.2	0	1.2	3	0.402	/opt/v2/html/Application.cfc$$invoke	36
0.278	0	0.278	1	-	/opt/v2/html/models/Amenity.cfc$findAll	188
0.246	0	0.246	1	-	/opt/v2/html/controllers/City.cfc$$runVerifications	158
0.241	0	0.241	1	-	/opt/v2/html/models/Metro.cfc$findAll	206
0.215	0	0.215	1	-	/opt/v2/html/wheels/functions.cfm	3
0.211	0	0.211	1	-	/opt/v2/html/events/onsessionstart.cfm$$invoke	44
0.211	0	0.21	1	-	/opt/v2/html/events/onrequeststart.cfm	85
0.202	0	0.202	1	-	/opt/v2/html/wheels/Dispatch.cfc$$invoke	111
0.168	0.002	0.166	1	-	/opt/v2/html/views/layout.cfm	331
0.312	0	0.312	2	0.156	/opt/v2/html/controllers/City.cfc$getResponse	226
0.464	0	0.464	3	0.154	/opt/v2/html/models/City.cfc$findAll	58
0.154	0.001	0.152	1	-	/opt/v2/html/views/city/_searchArea.cfm	262
0.142	0	0.142	1	-	/opt/v2/html/models/Apartment.cfc$setPagination	182
0.679	0	0.679	5	0.135	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$performQuery	71
0.137	0.002	0.134	1	-	/opt/v2/html/views/city/index.cfm	238
0.13	0	0.13	1	-	/opt/v2/html/views/city/index.cfm$urlfor	251
0.114	0.002	0.111	1	-	/opt/v2/html/views/city/_map.cfm	297
0.11	0	0.11	1	-	/opt/v2/html/wheels/Dispatch.cfc$$findMatchingRoute	96
0.109	0	0.109	1	-	/opt/v2/html/controllers/City.cfc$setPagination	222
0.104	0	0.104	1	-	/opt/v2/html/views/city/_weather.cfm$$hashedKey	326
0.203	0	0.203	2	0.101	/opt/v2/html/models/Amenity.cfc$$hashedKey	195
0.098	0	0.098	1	-	/opt/v2/html/Application.cfc$getRequest	82
0.189	0	0.189	2	0.094	/opt/v2/html/models/Metro.cfc$$hashedKey	213
0.091	0	0.091	1	-	/opt/v2/html/views/city/index.cfm$$tag	248
0.089	0	0.089	1	-	/opt/v2/html/views/city/_map.cfm$urlFor	298
0.084	0	0.084	1	-	/opt/v2/html/events/onsessionstart.cfm$setCity	41
0.082	0	0.082	1	-	/opt/v2/html/views/city/_searchArea.cfm$startFormTag	263
0.399	0	0.399	5	0.079	/opt/v2/html/views/city/_searchArea.cfm$uRLFor	267
0.073	0	0.073	1	-	/opt/v2/html/views/city/_map.cfm$uRLFor	304
0.148	0.002	0.145	2	0.072	/opt/v2/html/wheels/plugins/standalone/injection.cfm	84
0.071	0	0.071	1	-	/opt/v2/html/controllers/City.cfc$$generateAuthenticityToken	150
0.071	0	0.071	1	-	/opt/v2/html/models/Metro.cfc$$addWhereClauseParameters	215
2.57	0	2.57	41	0.062	/opt/v2/html/views/city/_searchArea.cfm$$tag	270
0.058	0	0.058	1	-	/opt/v2/html/views/layout.cfm$javaScriptIncludeTag	344
0.115	0	0.115	2	0.057	/opt/v2/html/models/Apartment.cfc$valueList	186
0.057	0	0.057	1	-	/opt/v2/html/views/city/_map.cfm$$tag	307
0.056	0	0.056	1	-	/opt/v2/html/Application.cfc$$cgiScope	81
0.055	0	0.055	1	-	/opt/v2/html/views/layout.cfm$styleSheetLinkTag	333
0.85	0	0.85	16	0.053	/opt/v2/html/views/city/_searchArea.cfm$$createLabel	288
0.298	0	0.298	6	0.049	/opt/v2/html/models/City.cfc$$hashedKey	62
0.182	0	0.182	4	0.045	/opt/v2/html/views/city/_searchArea.cfm$textField	277
0.044	0	0.044	1	-	/opt/v2/html/views/city/_weather.cfm$$doubleCheckedLock	327
0.043	0	0.043	1	-	/opt/v2/html/controllers/City.cfc$$dollarify	229
0.041	0	0.041	1	-	/opt/v2/html/views/city/_map.cfm$linkTo	303
0.578	0	0.578	14	0.041	/opt/v2/html/views/city/_searchArea.cfm$checkBox	290
0.044	0.003	0.04	1	-	/opt/v2/html/views/city/_weather.cfm	320
0.037	0	0.037	1	-	/opt/v2/html/views/city/index.cfm$stylesheetlinkTag	239
0.146	0	0.146	4	0.036	/opt/v2/html/views/city/_searchArea.cfm$linkTo	273
0.036	0	0.036	1	-	/opt/v2/html/views/layout.cfm$$findRoute	351
0.071	0	0.071	2	0.035	/opt/v2/html/controllers/City.cfc$getStatus	227
0.641	0	0.641	18	0.035	/opt/v2/html/views/city/_searchArea.cfm$$formBeforeElement	281
0.069	0	0.069	2	0.034	/opt/v2/html/controllers/City.cfc$setCity	172
0.242	0	0.242	7	0.034	/opt/v2/html/views/layout.cfm$$tag	342
0.098	0	0.098	3	0.032	/opt/v2/html/models/City.cfc$$addWhereClauseParameters	64
0.097	0	0.097	3	0.032	/opt/v2/html/views/city/index.cfm$$dollarify	255
0.031	0	0.031	1	-	/opt/v2/html/controllers/City.cfc$renderView	224
0.03	0	0.03	1	-	/opt/v2/html/views/city/index.cfm$$constructParams	253
0.029	0	0.029	1	-	/opt/v2/html/models/Metro.cfc$$getFromCache	214
0.029	0	0.029	1	-	/opt/v2/html/Application.cfc$getRequestURL	83
0.058	0	0.058	2	0.029	/opt/v2/html/views/layout.cfm$hyphenize	350
0.027	0	0.027	1	-	/opt/v2/html/views/city/index.cfm$url_params	250
0.027	0	0.027	1	-	/opt/v2/html/views/city/_searchArea.cfm$hiddenField	294
0.053	0	0.053	2	0.026	/opt/v2/html/controllers/City.cfc$$simpleLock	143
0.133	0	0.133	5	0.026	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$moveAggregateToHaving	69
0.079	0	0.079	3	0.026	/opt/v2/html/views/city/index.cfm$$generateIncludeTemplatePath	258
0.026	0	0.026	1	-	/opt/v2/html/models/Amenity.cfc$$timeSpanForCache	200
0.026	0	0.026	1	-	/opt/v2/html/views/city/_weather.cfm$imageTag	322
0.026	0	0.026	1	-	/opt/v2/html/wheels/Dispatch.cfc$$ensureControllerAndAction	106
0.05	0	0.05	2	0.025	/opt/v2/html/controllers/City.cfc$$generateIncludeTemplatePath	235
0.075	0	0.075	3	0.025	/opt/v2/html/Application.cfc$$simpleLock	35
0.025	0	0.025	1	-	/opt/v2/html/models/Amenity.cfc$$getFromCache	196
0.024	0	0.024	1	-	/opt/v2/html/wheels/Dispatch.cfc$$request	91
0.024	0	0.024	1	-	/opt/v2/html/controllers/City.cfc$contentFor	330
0.024	0	0.024	1	-	/opt/v2/html/models/Amenity.cfc$$setDebugName	190
0.024	0	0.024	1	-	/opt/v2/html/controllers/City.cfc$$callAction	166
0.43	0	0.43	18	0.023	/opt/v2/html/views/city/_searchArea.cfm$$formAfterElement	284
0.046	0	0.046	2	0.023	/opt/v2/html/models/City.cfc$findByKey	46
0.023	0	0.023	1	-	/opt/v2/html/models/Amenity.cfc$$args	189
0.022	0	0.022	1	-	/opt/v2/html/controllers/City.cfc$$renderView	234
0.022	0	0.022	1	-	/opt/v2/html/views/city/_searchArea.cfm$submitTag	292
0.022	0	0.022	1	-	/opt/v2/html/models/Metro.cfc$$timeSpanForCache	218
0.296	0	0.296	14	0.021	/opt/v2/html/views/city/_searchArea.cfm$checkBoxTag	289
0.02	0	0.02	1	-	/opt/v2/html/models/Metro.cfc$$listClean	209
0.02	0	0.02	1	-	/opt/v2/html/controllers/City.cfc$processAction	147
0.019	0	0.019	1	-	/opt/v2/html/controllers/City.cfc$url_params	167
0.019	0	0.019	1	-	/opt/v2/html/models/Apartment.cfc$min	180
0.058	0	0.058	3	0.019	/opt/v2/html/views/city/index.cfm$$renderPartial	257
0.038	0	0.038	2	0.019	/opt/v2/html/views/layout.cfm$$listClean	336
0.018	0	0.018	1	-	/opt/v2/html/views/city/index.cfm$$findRoute	252
0.018	0	0.018	1	-	/opt/v2/html/models/Metro.cfc$$args	207
0.054	0	0.054	3	0.018	/opt/v2/html/models/City.cfc$$getFromCache	63
0.035	0	0.035	2	0.017	/opt/v2/html/Application.cfc$$initializeRequestScope	37
0.017	0	0.017	1	-	/opt/v2/html/wheels/Dispatch.cfc$$mergeRoutePattern	101
0.017	0	0.017	1	-	/opt/v2/html/controllers/City.cfc$$getStatusCodes	233
0.084	0	0.084	5	0.016	/opt/v2/html/views/city/index.cfm$$args	240
0.016	0	0.016	1	-	/opt/v2/html/wheels/Dispatch.cfc$controller	109
0.05	0	0.05	3	0.016	/opt/v2/html/views/city/index.cfm$$argumentsForPartial	259
0.016	0	0.016	1	-	/opt/v2/html/models/Apartment.cfc$max	181
0.016	0	0.016	1	-	/opt/v2/html/models/Metro.cfc$$setDebugName	208
0.065	0	0.065	4	0.016	/opt/v2/html/views/city/index.cfm$$tagAttribute	249
0.016	0	0.016	1	-	/opt/v2/html/views/city/_searchArea.cfm$endFormTag	295
0.015	0	0.015	1	-	/opt/v2/html/views/city/index.cfm$$listClean	242
0.015	0	0.015	1	-	/opt/v2/html/controllers/City.cfc$$args	228
0.044	0	0.044	3	0.014	/opt/v2/html/views/city/_searchArea.cfm$$constructParams	275
0.074	0	0.074	5	0.014	/opt/v2/html/views/layout.cfm$$args	334
0.03	0	0.029	2	0.014	/opt/v2/html/wheels/global/internal.cfm	19
0.029	0	0.029	2	0.014	/opt/v2/html/wheels/Dispatch.cfc$$createParams	98
0.014	0	0.014	1	-	/opt/v2/html/models/Metro.cfc$$appKey	212
0.057	0	0.057	4	0.014	/opt/v2/html/views/city/_searchArea.cfm$textFieldTag	276
0.014	0	0.014	1	-	/opt/v2/html/views/city/_map.cfm$$tagAttribute	308
0.043	0	0.043	3	0.014	/opt/v2/html/models/City.cfc$findOne	57
0.057	0	0.057	4	0.014	/opt/v2/html/views/city/_searchArea.cfm$$maxLength	286
0.014	0	0.014	1	-	/opt/v2/html/models/Amenity.cfc$$cleanInList	192
0.014	0	0.014	1	-	/opt/v2/html/events/onsessionstart.cfm$model	42
0.013	0	0.013	1	-	/opt/v2/html/controllers/City.cfc$$renderLayout	329
0.19	0	0.19	14	0.013	/opt/v2/html/views/city/_searchArea.cfm$$canonicalize	291
0.013	0	0.013	1	-	/opt/v2/html/views/city/_weather.cfm$$args	323
0.013	0	0.013	1	-	/opt/v2/html/controllers/City.cfc$$objectFileName	114
0.065	0	0.065	5	0.013	/opt/v2/html/controllers/City.cfc$model	169
0.273	0	0.273	21	0.013	/opt/v2/html/views/layout.cfm$$tagAttribute	343
1.77	0	1.77	136	0.013	/opt/v2/html/views/city/_searchArea.cfm$$tagAttribute	271
0.038	0	0.038	3	0.012	/opt/v2/html/views/city/index.cfm$includePartial	254
0.026	0.001	0.025	2	0.012	/opt/v2/html/global/functions.cfm	22
0.126	0	0.126	10	0.012	/opt/v2/html/views/city/_searchArea.cfm$$findRoute	268
0.24	0	0.24	19	0.012	/opt/v2/html/views/city/_searchArea.cfm$$formValue	287
0.037	0	0.037	3	0.012	/opt/v2/html/views/city/_map.cfm$$findRoute	300
0.012	0	0.012	1	-	/opt/v2/html/models/Apartment.cfc$pagination	183
0.012	0	0.012	1	-	/opt/v2/html/models/Amenity.cfc$$listClean	191
0.012	0	0.012	1	-	/opt/v2/html/controllers/City.cfc$$initControllerObject	140
0.026	0.001	0.024	2	0.012	/opt/v2/html/wheels/global/misc.cfm	20
0.234	0	0.234	19	0.012	/opt/v2/html/views/city/_searchArea.cfm$$objectName	278
0.012	0	0.012	1	-	/opt/v2/html/wheels/view/functions.cfm	124
0.036	0	0.036	3	0.012	/opt/v2/html/views/city/index.cfm$$includeFile	260
0.012	0	0.012	1	-	/opt/v2/html/wheels/controller/functions.cfm	121
0.011	0	0.011	1	-	/opt/v2/html/views/layout.cfm$csrfMetaTags	346
0.011	0	0.011	1	-	/opt/v2/html/views/city/_weather.cfm$keyExists	321
0.023	0	0.023	2	0.011	/opt/v2/html/models/City.cfc$$keyWhereString	53
0.011	0	0.011	1	-	/opt/v2/html/views/city/index.cfm$$assetDomain	245
0.011	0	0.011	1	-	/opt/v2/html/models/Amenity.cfc$$callback	204
0.057	0	0.057	5	0.011	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$querySetup	66
0.045	0	0.045	4	0.011	/opt/v2/html/Application.cfc$$include	38
0.011	0	0.011	1	-	/opt/v2/html/models/Metro.cfc$$callback	220
0.034	0	0.034	3	0.011	/opt/v2/html/views/city/index.cfm$$includeOrRenderPartial	256
0.011	0	0.011	1	-	/opt/v2/html/models/Metro.cfc$$cleanInList	210
0.011	0	0.011	1	-	/opt/v2/html/models/Apartment.cfc$$get	184
0.401	0	0.401	36	0.011	/opt/v2/html/views/city/_searchArea.cfm$$getFieldLabel	282
0.011	0	0.011	1	-	/opt/v2/html/Application.cfc$onSessionStart	34
0.023	0.001	0.021	2	0.01	/opt/v2/html/wheels/controller/rendering.cfm	15
0.384	0	0.384	36	0.01	/opt/v2/html/views/city/_searchArea.cfm$$formHasError	283
0.011	0	0.01	1	-	/opt/v2/html/wheels/controller/appfunctions.cfm	5
0.01	0	0.01	1	-	/opt/v2/html/controllers/City.cfc$pagination	223
0.05	0	0.05	5	0.01	/opt/v2/html/controllers/City.cfc$$doubleCheckedLock	170
0.02	0	0.02	2	0.01	/opt/v2/html/controllers/City.cfc$$includeFile	236
0.19	0	0.19	19	0.01	/opt/v2/html/views/city/_searchArea.cfm$$tagId	280
0.009	0	0.009	1	-	/opt/v2/html/views/layout.cfm$includeContent	352
0.049	0	0.049	5	0.009	/opt/v2/html/views/city/_searchArea.cfm$$routeVariables	269
0.009	0	0.009	1	-	/opt/v2/html/models/Apartment.cfc$$appKey	185
0.029	0	0.029	3	0.009	/opt/v2/html/views/city/index.cfm$$renderLayout	296
0.019	0	0.019	2	0.009	/opt/v2/html/views/layout.cfm$$combineArguments	335
0.029	0	0.029	3	0.009	/opt/v2/html/models/City.cfc$$cleanInList	59
0.029	0	0.029	3	0.009	/opt/v2/html/views/layout.cfm$$element	345
0.009	0	0.009	1	-	/opt/v2/html/views/city/_searchArea.cfm$hiddenFieldTag	293
0.009	0	0.009	1	-	/opt/v2/html/views/city/_map.cfm$$element	306
0.009	0	0.009	1	-	/opt/v2/html/views/city/_map.cfm$$routeVariables	305
0.19	0	0.19	20	0.009	/opt/v2/html/views/city/_searchArea.cfm$$element	274
0.009	0	0.009	1	-	/opt/v2/html/controllers/City.cfc$setCityByName	168
0.455	0	0.455	49	0.009	/opt/v2/html/views/city/_searchArea.cfm$$args	264
0.009	0	0.009	1	-	/opt/v2/html/Application.cfc$onRequestEnd	361
0.045	0	0.045	5	0.009	/opt/v2/html/views/layout.cfm$$assetDomain	339
0.009	0	0.009	1	-	/opt/v2/html/Application.cfc$onRequestStart	79
0.008	0	0.008	1	-	/opt/v2/html/Application.cfc$$restoreTestRunnerApplicationScope	362
0.008	0	0.008	1	-	/opt/v2/html/controllers/City.cfc$$setRequestStatusCode	231
0.043	0	0.043	5	0.008	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$removeColumnAliasesInOrderClause	68
0.017	0	0.017	2	0.008	/opt/v2/html/controllers/City.cfc$$statusCode	225
0.042	0	0.042	5	0.008	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$identitySelect	76
0.008	0	0.008	1	-	/opt/v2/html/views/city/index.cfm$$combineArguments	241
0.017	0.001	0.016	2	0.008	/opt/v2/html/wheels/global/cfml.cfm	18
0.024	0	0.024	3	0.008	/opt/v2/html/views/city/_map.cfm$$args	299
0.016	0	0.016	2	0.008	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$columnAlias	202
0.008	0	0.008	1	-	/opt/v2/html/controllers/City.cfc$$returnStatusText	232
0.007	0	0.007	1	-	/opt/v2/html/models/Amenity.cfc$$callbacks	205
0.007	0	0.007	1	-	/opt/v2/html/models/Amenity.cfc$$get	193
0.007	0	0.007	1	-	/opt/v2/html/wheels/Dispatch.cfc$$paramParser	94
0.28	0	0.28	38	0.007	/opt/v2/html/views/city/_searchArea.cfm$$combineArguments	279
0.007	0	0.007	1	-	/opt/v2/html/models/Amenity.cfc$$appKey	194
0.007	0	0.007	1	-	/opt/v2/html/models/Metro.cfc$$callbacks	221
0.007	0	0.007	1	-	/opt/v2/html/models/Amenity.cfc$primaryKeys	198
0.007	0	0.007	1	-	/opt/v2/html/Application.cfc$$abortInvalidRequest	80
0.006	0	0.006	1	-	/opt/v2/html/models/Amenity.cfc$$addWhereClauseParameters	197
0.02	0	0.02	3	0.006	/opt/v2/html/models/City.cfc$$callback	77
0.055	0	0.055	8	0.006	/opt/v2/html/models/City.cfc$$args	47
0.006	0	0.006	1	-	/opt/v2/html/controllers/City.cfc$$writeFlash	357
0.013	0	0.013	2	0.006	/opt/v2/html/controllers/City.cfc$$runFilters	161
0.006	0	0.006	1	-	/opt/v2/html/views/city/_map.cfm$compressHtml	318
0.013	0	0.013	2	0.006	/opt/v2/html/models/Apartment.cfc$keyExists	179
0.007	0	0.006	1	-	/opt/v2/html/wheels/global/functions.cfm	123
0.006	0	0.006	1	-	/opt/v2/html/wheels/Dispatch.cfc$$translateBlankCheckBoxSubmissions	103
0.006	0	0.006	1	-	/opt/v2/html/wheels/Dispatch.cfc$$doubleCheckedLock	110
0.006	0	0.006	1	-	/opt/v2/html/events/onsessionstart.cfm$$doubleCheckedLock	43
0.006	0	0.006	1	-	/opt/v2/html/wheels/Dispatch.cfc$$mergeUrlAndFormScopes	99
0.006	0	0.006	1	-	/opt/v2/html/controllers/City.cfc$$runCsrfProtection	148
0.006	0	0.006	1	-	/opt/v2/html/models/Amenity.cfc$primaryKey	199
0.018	0	0.018	3	0.006	/opt/v2/html/views/layout.cfm$keyExists	332
0.012	0	0.012	2	0.006	/opt/v2/html/controllers/City.cfc$filterChain	162
0.024	0	0.024	4	0.006	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$queryParams	75
0.006	0	0.005	1	-	/opt/v2/html/wheels/view/miscellaneous.cfm	136
0.005	0	0.005	1	-	/opt/v2/html/models/Metro.cfc$primaryKey	217
0.045	0	0.045	8	0.005	/opt/v2/html/models/City.cfc$$setDebugName	48
0.005	0	0.005	1	-	/opt/v2/html/views/city/_searchArea.cfm$$isRequestProtectedFromForgery	272
0.011	0	0.011	2	0.005	/opt/v2/html/controllers/City.cfc$findAll	187
0.012	0.001	0.011	2	0.005	/opt/v2/html/wheels/global/util.cfm	21
0.005	0	0.005	1	-	/opt/v2/html/controllers/City.cfc$keyExists	174
0.005	0	0.005	1	-	/opt/v2/html/controllers/City.cfc$$createControllerObject	113
0.012	0.001	0.01	2	0.005	/opt/v2/html/wheels/controller/caching.cfm	6
0.005	0	0.005	1	-	/opt/v2/html/views/city/_weather.cfm$$get	324
0.005	0	0.005	1	-	/opt/v2/html/wheels/Dispatch.cfc$$translateDatePartSubmissions	104
0.005	0	0.005	1	-	/opt/v2/html/views/city/index.cfm$$appendQueryString	247
0.005	0	0.005	1	-	/opt/v2/html/models/Metro.cfc$primaryKeys	216
0.005	0	0.005	1	-	/opt/v2/html/controllers/City.cfc$$flashClear	355
0.005	0	0.005	1	-	/opt/v2/html/models/Metro.cfc$$get	211
0.011	0.001	0.01	2	0.005	/opt/v2/html/wheels/controller/flash.cfm	8
0.005	0	0.005	1	-	/opt/v2/html/models/Amenity.cfc$$querySetup	201
0.024	0	0.024	5	0.004	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$convertMaxRowsToLimit	67
0.004	0	0.004	1	-	/opt/v2/html/controllers/City.cfc$isAjax	230
0.009	0	0.009	2	0.004	/opt/v2/html/views/city/_map.cfm$$get	301
0.005	0	0.004	1	-	/opt/v2/html/views/helpers.cfm	138
0.005	0.001	0.004	1	-	/opt/v2/html/config/app.cfm	4
0.01	0.001	0.009	2	0.004	/opt/v2/html/wheels/controller/miscellaneous.cfm	11
0.004	0	0.004	1	-	/opt/v2/html/wheels/view/formsdateplain.cfm	132
0.005	0	0.004	1	-	/opt/v2/html/events/onsessionstart.cfm	39
0.008	0	0.008	2	0.004	/opt/v2/html/models/City.cfc$validationTypeForProperty	54
0.008	0	0.008	2	0.004	/opt/v2/html/events/onrequeststart.cfm$keyExists	86
0.004	0	0.004	1	-	/opt/v2/html/wheels/controller/csrf.cfm	122
0.008	0	0.008	2	0.004	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$quoteValue	56
0.058	0	0.058	14	0.004	/opt/v2/html/controllers/City.cfc$$get	141
0.083	0	0.083	20	0.004	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$isAggregateFunction	70
0.004	0	0.004	1	-	/opt/v2/html/views/city/_weather.cfm$$appKey	325
0.004	0	0.004	1	-	/opt/v2/html/controllers/City.cfc$capitalize	115
0.008	0	0.008	2	0.004	/opt/v2/html/views/layout.cfm$$generateAuthenticityToken	347
0.02	0	0.02	5	0.004	/opt/v2/html/views/layout.cfm$$appendQueryString	341
0.008	0	0.008	2	0.004	/opt/v2/html/events/onsessionstart.cfm$keyExists	40
0.004	0	0.004	1	-	/opt/v2/html/views/city/index.cfm$isSecure	246
0.008	0	0.008	2	0.004	/opt/v2/html/controllers/City.cfc$$performedRenderOrRedirect	163
0.027	0	0.027	7	0.003	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$get	72
0.011	0	0.011	3	0.003	/opt/v2/html/models/City.cfc$$callbacks	78
0.055	0	0.055	14	0.003	/opt/v2/html/controllers/City.cfc$$appKey	142
0.003	0	0.003	1	-	/opt/v2/html/wheels/Dispatch.cfc$$performedRedirect	353
0.004	0	0.003	1	-	/opt/v2/html/wheels/view/forms.cfm	128
0.003	0	0.003	1	-	/opt/v2/html/controllers/City.cfc$flashClear	356
0.003	0	0.003	1	-	/opt/v2/html/models/Metro.cfc$$querySetup	219
0.031	0	0.031	8	0.003	/opt/v2/html/models/City.cfc$$listClean	49
0.007	0	0.007	2	0.003	/root/.CommandBox/server/898B3A89B85F2E1434049D1C125A4336-v2/lucee-6.0.1.83/WEB-INF/lucee-server/context/components/org/lucee/cfml/Component.cfc	2
0.004	0	0.003	1	-	/opt/v2/html/wheels/view/formsplain.cfm	134
0.082	0	0.082	22	0.003	/opt/v2/html/views/city/index.cfm$$get	243
0.01	0	0.01	3	0.003	/opt/v2/html/models/City.cfc$$get	60
0.017	0	0.017	5	0.003	/opt/v2/html/views/layout.cfm$isSecure	340
0.003	0	0.003	1	-	/opt/v2/html/views/layout.cfm$authenticityToken	348
0.003	0	0.003	1	-	/opt/v2/html/wheels/Dispatch.cfc$$getPathFromRequest	95
0.007	0	0.007	2	0.003	/opt/v2/html/views/city/_map.cfm$$appKey	302
0.004	0	0.003	1	-	/opt/v2/html/wheels/view/formsobject.cfm	133
0.024	0	0.024	7	0.003	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$appKey	73
0.007	0	0.007	2	0.003	/opt/v2/html/models/City.cfc$$keyLengthCheck	50
0.003	0	0.003	1	-	/opt/v2/html/controllers/City.cfc$response	360
0.666	0	0.666	197	0.003	/opt/v2/html/views/city/_searchArea.cfm$$get	265
0.009	0	0.009	3	0.003	/opt/v2/html/wheels/Dispatch.cfc$$get	92
0.072	0	0.072	22	0.003	/opt/v2/html/views/city/index.cfm$$appKey	244
0.009	0	0.009	3	0.003	/opt/v2/html/models/City.cfc$$appKey	61
0.003	0	0.003	1	-	/opt/v2/html/wheels/view/assets.cfm	125
0.003	0	0.003	1	-	/opt/v2/html/controllers/City.cfc$getApartments2	175
0.003	0	0.003	1	-	/opt/v2/html/events/onsessionstart.cfm$findByKey	45
0.003	0	0.003	1	-	/opt/v2/html/wheels/view/formsdate.cfm	130
0.009	0	0.009	3	0.003	/opt/v2/html/wheels/Dispatch.cfc$$appKey	93
0.154	0	0.154	49	0.003	/opt/v2/html/views/layout.cfm$$get	337
0.003	0	0.003	1	-	/opt/v2/html/wheels/global/appfunctions.cfm	17
0.438	0	0.438	144	0.003	/opt/v2/html/views/city/_map.cfm$member_link	313
0.006	0	0.006	2	0.003	/opt/v2/html/controllers/City.cfc$$getFlashStorage	358
0.007	0.001	0.006	2	0.003	/opt/v2/html/wheels/controller/verifies.cfm	16
0.003	0	0.003	1	-	/opt/v2/html/wheels/index.cfm$$request	90
0.002	0	0.002	1	-	/opt/v2/html/controllers/City.cfc$findOne	171
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$response	359
0.002	0	0.002	1	-	/opt/v2/html/models/Apartment.cfc$listlen	177
0.003	0	0.002	1	-	/opt/v2/html/wheels/view/links.cfm	135
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$$flashClear	354
0.551	0	0.551	197	0.002	/opt/v2/html/views/city/_searchArea.cfm$$appKey	266
0.002	0	0.002	1	-	/opt/v2/html/views/city/_map.cfm$isEmpty	317
0.135	0	0.135	49	0.002	/opt/v2/html/views/layout.cfm$$appKey	338
0.006	0.001	0.005	2	0.002	/opt/v2/html/wheels/controller/filters.cfm	7
0.005	0	0.005	2	0.002	/opt/v2/html/controllers/Controller.cfc$keyExists	139
0.005	0	0.005	2	0.002	/opt/v2/html/wheels/model/adapters/MySQL.cfc$$comment	203
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$$createNestedParamStruct	105
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$$parseJsonBody	100
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$$getRequestMethod	97
0.002	0	0.002	1	-	/opt/v2/html/controllers/City.cfc$$abortIssued	160
0.016	0	0.016	7	0.002	/opt/v2/html/models/City.cfc$primaryKey	52
0.002	0	0.002	1	-	/opt/v2/html/controllers/City.cfc$verificationChain	159
0.329	0	0.329	144	0.002	/opt/v2/html/views/city/_map.cfm$object_url	310
0.043	0	0.043	19	0.002	/opt/v2/html/views/city/_searchArea.cfm$$tagName	285
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$$createControllerObject	112
0.015	0	0.015	7	0.002	/opt/v2/html/models/City.cfc$primaryKeys	51
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$$addRouteName	108
0.002	0	0.002	1	-	/opt/v2/html/controllers/City.cfc$findByKey	173
0.002	0	0.002	1	-	/opt/v2/html/wheels/view/formsassociation.cfm	129
0.002	0	0.002	1	-	/opt/v2/html/wheels/Dispatch.cfc$$deobfuscateParams	102
0.002	0	0.002	1	-	/opt/v2/html/controllers/City.cfc$$storeAuthenticityToken	149
0.006	0	0.006	3	0.002	/opt/v2/html/models/City.cfc$$querySetup	65
0.003	0	0.003	2	0.001	/opt/v2/html/models/City.cfc$$quoteValue	55
0.005	0.001	0.003	2	0.001	/opt/v2/html/wheels/controller/provides.cfm	13
0.001	0	0.001	1	-	/opt/v2/html/wheels/Dispatch.cfc$$addRouteFormat	107
0.007	0	0.007	4	0.001	/opt/v2/html/controllers/City.cfc$$performedRender	164
0.005	0	0.005	3	0.001	/opt/v2/html/controllers/City.cfc$$performedRedirect	165
0.004	0.001	0.003	2	0.001	/opt/v2/html/wheels/controller/initialization.cfm	9
0.003	0	0.003	2	0.001	/opt/v2/html/controllers/City.cfc$isGet	154
0.004	0.001	0.003	2	0.001	/opt/v2/html/wheels/controller/layouts.cfm	10
0.001	0	0.001	1	-	/opt/v2/html/controllers/City.cfc$$flagRequestAsProtected	151
0.718	0	0.718	432	0.001	/opt/v2/html/views/city/_map.cfm$replace	311
0.001	0	0.001	1	-	/opt/v2/html/controllers/City.cfc$$hasCachableActions	156
0.002	0	0.001	1	-	/opt/v2/html/wheels/view/formsdateobject.cfm	131
0.002	0	0.001	1	-	/opt/v2/html/wheels/events/onmissingtemplate.cfm	28
0.001	0	0.001	1	-	/opt/v2/html/controllers/City.cfc$$cachableActions	157
0.004	0.001	0.003	2	0.001	/opt/v2/html/global/_ymap.cfm	23
0.003	0	0.003	2	0.001	/opt/v2/html/controllers/City.cfc$$getControllerClassData	145
0.001	0	0.001	1	-	/opt/v2/html/wheels/Dispatch.cfc$processAction	146
0.214	0	0.214	144	0.001	/opt/v2/html/views/city/_map.cfm$keyExists	312
0.004	0.001	0.002	2	0.001	/opt/v2/html/wheels/controller/processing.cfm	12
0.001	0	0.001	1	-	/opt/v2/html/wheels/view/errors.cfm	127
0.001	0	0.001	1	-	/opt/v2/html/wheels/events/onsessionend.cfm	29
0.001	0	0.001	1	-	/opt/v2/html/wheels/events/onerror.cfm	26
0.003	0.002	0.001	1	-	/opt/v2/html/events/onrequestend.cfm	363
0.001	0	0.001	1	-	/opt/v2/html/wheels/events/onrequeststart.cfm	33
0.001	0	0.001	1	-	/opt/v2/html/wheels/view/csrf.cfm	126
0.172	0	0.172	144	0.001	/opt/v2/html/views/city/_map.cfm$append	314
0.001	0	0.001	1	-	/opt/v2/html/wheels/events/onrequestend.cfm	32
0.001	0	0.001	1	-	/opt/v2/html/wheels/events/onapplicationstart.cfm	25
0.003	0.001	0.002	2	0.001	/opt/v2/html/wheels/controller/redirection.cfm	14
0.001	0	0.001	1	-	/opt/v2/html/wheels/events/onapplicationend.cfm	24
0.001	0	0.001	1	-	/opt/v2/html/wheels/events/onsessionstart.cfm	30
0.001	0	0.001	1	-	/opt/v2/html/wheels/view/sanitize.cfm	137
0.002	0	0.002	2	0.001	/opt/v2/html/controllers/City.cfc$$isVerifiedRequest	153
0.144	0	0.144	143	0.001	/opt/v2/html/views/helpers.cfm$len	316
0	0	0	1	-	/opt/v2/html/controllers/City.cfc$$setAuthenticityToken	152
0.001	0	0	1	-	/opt/v2/html/wheels/events/onabort.cfm	27
0	0	0	1	-	/opt/v2/html/controllers/City.cfc$$verifyAuthenticityToken	155
0.001	0	0	1	-	/opt/v2/html/wheels/events/onrequest.cfm	31
0	0	0	1	-	/opt/v2/html/root.cfm	117
0	0	0	1	-	/opt/v2/html/rewrite.cfm	88
0	0	0	1	-	/opt/v2/html/Application.cfc	1
0	0	0	1	-	/opt/v2/html/controllers/Controller.cfc	119
0	0	0	1	-	/opt/v2/html/wheels/Controller.cfc	120
0	0	0	1	-	/opt/v2/html/controllers/City.cfc	118
0	0	0	3	0	/opt/v2/html/views/city/index.cfm$$includeAndReturnOutput	261
0	0	0	1	-	/opt/v2/html/Application.cfc$onRequest	87
0	0	0	1	-	/opt/v2/html/controllers/City.cfc$$createObjectFromRoot	116
0	0	0	2	0	/opt/v2/html/controllers/City.cfc$$includeAndReturnOutput	237

CFTimer Times

1 Timer Set

Label	Time (ms)	Template
contains	0	/opt/v2/html/events/onrequeststart.cfm

Datasource Information

13 Queries Executed (Total Records: 946; Total Time: 43.5 ms; Total Open Connections: 2)

General

Name	Open Connections	Max Connections
pgsql	3	INF
sstorage	0	INF
maindb	2	INF

SQL Queries

	Name	Records	Time	Usage	Datasource	Source	Line	Cached
	local.cityFindByKeyQuery	1	0.507 ms	-	maindb	/opt/v2/html/wheels/model/adapters/cfquery.cfm	17	No
SQL (Merged Parameters) SELECT cities.cityId,cities.countryId,cities.regionId,cities.city,cities.city1,cities.city_en,cities.city_alias,cities.population,cities.lat,cities.lng,cities.zoomLevel,cities.timezone,cities.tz,cities.zip,cities.isvisible,cities.seoText,cities.seoHeader,cities.perPage,cities.isCapital,cities.weather,cities.isNmap,cities.minprice FROM cities WHERE cities.cityId = 1 LIMIT 1 SQL (Explicit Parameters) SELECT cities.cityId,cities.countryId,cities.regionId,cities.city,cities.city1,cities.city_en,cities.city_alias,cities.population,cities.lat,cities.lng,cities.zoomLevel,cities.timezone,cities.tz,cities.zip,cities.isvisible,cities.seoText,cities.seoHeader,cities.perPage,cities.isCapital,cities.weather,cities.isNmap,cities.minprice FROM cities WHERE cities.cityId = {type: "CF_SQL_BIGINT", value: 1} LIMIT 1
	local.cityfindOneQuery	1	0.407 ms	-	maindb	/opt/v2/html/wheels/model/adapters/cfquery.cfm	17	No
SQL (Merged Parameters) SELECT cities.cityid FROM cities WHERE cities.city_en = 'vologda' LIMIT 1 SQL (Explicit Parameters) SELECT cities.cityid FROM cities WHERE cities.city_en = {type: "CF_SQL_VARCHAR", value: 'vologda'} LIMIT 1
	local.cityFindByKeyQuery	1	0.402 ms	-	maindb	/opt/v2/html/wheels/model/adapters/cfquery.cfm	17	No
SQL (Merged Parameters) SELECT cities.cityId,cities.countryId,cities.regionId,cities.city,cities.city1,cities.city_en,cities.city_alias,cities.population,cities.lat,cities.lng,cities.zoomLevel,cities.timezone,cities.tz,cities.zip,cities.isvisible,cities.seoText,cities.seoHeader,cities.perPage,cities.isCapital,cities.weather,cities.isNmap,cities.minprice FROM cities WHERE cities.cityId = 64 LIMIT 1 SQL (Explicit Parameters) SELECT cities.cityId,cities.countryId,cities.regionId,cities.city,cities.city1,cities.city_en,cities.city_alias,cities.population,cities.lat,cities.lng,cities.zoomLevel,cities.timezone,cities.tz,cities.zip,cities.isvisible,cities.seoText,cities.seoHeader,cities.perPage,cities.isCapital,cities.weather,cities.isNmap,cities.minprice FROM cities WHERE cities.cityId = {type: "CF_SQL_BIGINT", value: 64} LIMIT 1
	local.whatToQuery	178	21.4 ms	-	maindb	/opt/v2/html/models/Apartment.cfc	195	No
SQL (Merged Parameters) SELECT a.cityId, a.apartmentId,GROUP_CONCAT(apam.amenityid SEPARATOR ',') as amenitiesList, a.rooms, a.dayPrice, a.currency, a.street, a.dateUpdated, 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 = 1 AND m.isActive = 1 AND a.isVisible = 1 AND a.isActive = 1 AND EXISTS(SELECT 1 FROM photos WHERE photos.objectId = a.apartmentId) AND a.cityId = 64 GROUP BY a.apartmentId SQL (Explicit Parameters) SELECT a.cityId, a.apartmentId,GROUP_CONCAT(apam.amenityid SEPARATOR ',') as amenitiesList, a.rooms, a.dayPrice, a.currency, a.street, a.dateUpdated, 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 = 1 AND m.isActive = 1 AND a.isVisible = 1 AND a.isActive = 1 AND EXISTS(SELECT 1 FROM photos WHERE photos.objectId = a.apartmentId) AND a.cityId = {type: "CF_SQL_NUMERIC", value: 64} GROUP BY a.apartmentId
	sRoomsResult.one	144	0.138 ms	-		/opt/v2/html/wheels../models/Apartment.cfc	238	No
SQL SELECT 0 FROM whatToQuery WHERE rooms = 1
	sRoomsResult.two	27	0.058 ms	-		/opt/v2/html/wheels../models/Apartment.cfc	240	No
SQL SELECT 0 FROM whatToQuery WHERE rooms = 2
	sRoomsResult.three	7	0.056 ms	-		/opt/v2/html/wheels../models/Apartment.cfc	242	No
SQL SELECT 0 FROM whatToQuery WHERE rooms >= 3
	whatToQuery	144	0.491 ms	-		/opt/v2/html/wheels../models/Apartment.cfc	253	No
SQL SELECT * FROM whatToQuery WHERE rooms = 1
	whatToQuery	144	0.339 ms	-		/opt/v2/html/wheels../models/Apartment.cfc	264	No
SQL SELECT * FROM whatToQuery WHERE dayPrice BETWEEN 0 AND 1500000
	whatToQuery	144	0.569 ms	-		/opt/v2/html/wheels../models/Apartment.cfc	282	No
SQL SELECT * FROM whatToQuery ORDER BY position ASC
	local.getData	144	19.2 ms	-	maindb	/opt/v2/html/models/Apartment.cfc	311	No
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.dateUpdated,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 = 1) 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, dateAdded 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 (1214138,1208989,1214390,916618,1055333,275946,576385,1211157,828328,1052371,744828,1157342,1213738,1213739,786525,1213911,1213910,1213874,817740,1213737,1213736,817737,1205296,1211158,255009,1037381,1135121,262754,113564,1012654,1199022,456989,658217,936559,989796,281293,82934,879111,1073608,778660,778658,778667,991982,1204182,1211426,1206766,1198860,902834,200481,1054216,606334,700614,896789,1079158,1079157,1079155,1079154,1079153,1079162,1079160,1079161,1209214,1198940,1198941,1204200,1204201,111957,124074,214826,849819,1203219,1203220,1202559,1198939,499138,597273,915350,915359,924949,1192914,1063706,991663,305095,893084,152421,759333,545579,17712,488705,89704,53712,1075412,591362,948728,319502,996824,1056553,762109,503616,1090994,1089952,1082867,1082821,764216,90443,1004585,678826,927213,591373,591355,77801,79151,990588,418253,975750,972059,970484,967992,802630,793950,948526,941622,385995,597792,753684,245698,260780,906800,596697,865288,897378,591369,246297,247676,242716,280643,795289,241442,245697,724934,102306,596987,296077,522916) GROUP BY a.apartmentId ORDER BY FIELD(apartmentId, 1214138,1208989,1214390,916618,1055333,275946,576385,1211157,828328,1052371,744828,1157342,1213738,1213739,786525,1213911,1213910,1213874,817740,1213737,1213736,817737,1205296,1211158,255009,1037381,1135121,262754,113564,1012654,1199022,456989,658217,936559,989796,281293,82934,879111,1073608,778660,778658,778667,991982,1204182,1211426,1206766,1198860,902834,200481,1054216,606334,700614,896789,1079158,1079157,1079155,1079154,1079153,1079162,1079160,1079161,1209214,1198940,1198941,1204200,1204201,111957,124074,214826,849819,1203219,1203220,1202559,1198939,499138,597273,915350,915359,924949,1192914,1063706,991663,305095,893084,152421,759333,545579,17712,488705,89704,53712,1075412,591362,948728,319502,996824,1056553,762109,503616,1090994,1089952,1082867,1082821,764216,90443,1004585,678826,927213,591373,591355,77801,79151,990588,418253,975750,972059,970484,967992,802630,793950,948526,941622,385995,597792,753684,245698,260780,906800,596697,865288,897378,591369,246297,247676,242716,280643,795289,241442,245697,724934,102306,596987,296077,522916)
	local.AmenityfindAllQuery	11	0 ms	-	maindb	/opt/v2/html/wheels/model/adapters/cfquery.cfm	17	No
SQL SELECT amenities.id,amenities.name FROM amenities ORDER BY amenities.sortorder ASC /* cachekey:18ABA2DAF00BC0285840F9CFE4CFD44D */
	local.metrofindAllQuery	0	0 ms	-	maindb	/opt/v2/html/wheels/model/adapters/cfquery.cfm	17	No
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 = 64 ORDER BY metro.stationName ASC SQL (Explicit 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 = {type: "CF_SQL_BIGINT", value: 64} ORDER BY metro.stationName ASC