Timings

Timing

Action	Time Spent
Render Time	2.9678 ms
Controller Time	12.2631 ms
Total Time	23.7019 ms

Template

Total Time	Engine	Count	Template	Content Type
2.9678 ms	kajiki	-	jacwud_dev.modules.dealer.template.find-a-dealer	text/html
2.8770 ms	kajiki	1	jacwud_dev.modules.dealer.template.find-a-dealer

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.003	0.0030	12.244	12.2440	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.011	0.0110	12.241	12.2410	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
2	0.159	0.0795	10.873	5.4365	<sqlalchemy/orm/query.py:3162(all)>
1	0.006	0.0060	7.507	7.5070	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
203	0.358	0.0018	6.814	0.0336	<sqlalchemy/orm/loading.py:35(instances)>
1	0.009	0.0090	4.723	4.7230	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
201	1.41	0.0070	4.09	0.0203	<sqlalchemy/orm/loading.py:492(_instance)>
2	0.013	0.0065	3.9	1.9500	<sqlalchemy/orm/query.py:3319(__iter__)>
2	0.013	0.0065	3.297	1.6485	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.009	0.0045	2.843	1.4215	<sqlalchemy/engine/base.py:922(execute)>
2	0.007	0.0035	2.832	1.4160	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	0.05	0.0250	2.825	1.4125	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
2	0.072	0.0360	1.728	0.8640	<sqlalchemy/engine/base.py:1163(_execute_context)>
201	0.732	0.0036	1.61	0.0080	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
2	0.015	0.0075	1.342	0.6710	<sqlalchemy/orm/scoping.py:161(do)>
2	1.121	0.5605	1.3	0.6500	<sqlalchemy/orm/query.py:4159(row_processor)>
3	0.02	0.0067	1.269	0.4230	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.01	0.0050	1.126	0.5630	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.015	0.0150	1.116	1.1160	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.028	0.0280	1.069	1.0690	<sqlalchemy/orm/session.py:646(__init__)>
2	0.007	0.0035	1.034	0.5170	<sqlalchemy/engine/default.py:549(do_execute)>
2	1.027	0.5135	1.027	0.5135	{method 'execute' of 'psycopg2.extensions.cursor' objects}
2	0.008	0.0040	0.974	0.4870	<string>:1(<lambda>)
2	0.008	0.0040	0.966	0.4830	<sqlalchemy/sql/elements.py:399(compile)>
2	0.008	0.0040	0.958	0.4790	<sqlalchemy/sql/elements.py:464(_compiler)>
2	0.028	0.0140	0.95	0.4750	<sqlalchemy/sql/compiler.py:500(__init__)>
1	0.055	0.0550	0.945	0.9450	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
2	0.01	0.0050	0.916	0.4580	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.007	0.0035	0.906	0.4530	<sqlalchemy/sql/compiler.py:349(process)>
22/2	0.064	0.0029	0.899	0.4495	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
2	0.05	0.0250	0.889	0.4445	<sqlalchemy/sql/compiler.py:2001(visit_select)>
6	0.482	0.0803	0.853	0.1422	<sqlalchemy/util/_collections.py:755(unique_list)>
6	0.018	0.0030	0.783	0.1305	<sqlalchemy/event/api.py:34(listen)>
6	0.084	0.0140	0.644	0.1073	<sqlalchemy/event/registry.py:193(listen)>
201	0.584	0.0029	0.584	0.0029	<sqlalchemy/orm/state.py:89(__init__)>
2	0.063	0.0315	0.573	0.2865	<sqlalchemy/orm/query.py:3828(_compile_context)>
9	0.074	0.0082	0.547	0.0608	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
201	0.516	0.0026	0.516	0.0026	<sqlalchemy/orm/loading.py:677(_populate_full)>
2	0.01	0.0050	0.441	0.2205	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
2	0.007	0.0035	0.396	0.1980	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
2	0.009	0.0045	0.389	0.1945	<sqlalchemy/orm/session.py:1048(connection)>
9	0.097	0.0108	0.385	0.0428	<sqlalchemy/sql/compiler.py:780(visit_label)>
2	0.021	0.0105	0.371	0.1855	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
2	0.016	0.0080	0.35	0.1750	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
6	0.012	0.0020	0.316	0.0527	<sqlalchemy/event/base.py:243(_listen)>
7	0.04	0.0057	0.307	0.0439	<sqlalchemy/event/attr.py:291(__call__)>
6	0.028	0.0047	0.304	0.0507	<sqlalchemy/event/registry.py:243(base_listen)>
152/142	0.195	0.0013	0.274	0.0019	{getattr}
2	0.027	0.0135	0.259	0.1295	<sqlalchemy/orm/query.py:3953(_simple_statement)>
2	0.015	0.0075	0.247	0.1235	<sqlalchemy/engine/result.py:1195(fetchall)>
428	0.238	0.0006	0.238	0.0006	{id}
1	0.008	0.0080	0.227	0.2270	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
2	0.018	0.0090	0.224	0.1120	<string>:1(select)
201	0.208	0.0010	0.208	0.0010	{method 'issuperset' of 'frozenset' objects}
2	0.023	0.0115	0.206	0.1030	<string>:1(__init__)
2	0.007	0.0035	0.2	0.1000	<sqlalchemy/orm/session.py:1540(query)>
2	0.004	0.0020	0.193	0.0965	<sqlalchemy/orm/query.py:141(__init__)>
2	0.018	0.0090	0.189	0.0945	<sqlalchemy/orm/query.py:170(_set_entities)>
2	0.01	0.0050	0.185	0.0925	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
6	0.011	0.0018	0.185	0.0308	<sqlalchemy/event/attr.py:374(append)>
2	0.085	0.0425	0.175	0.0875	<sqlalchemy/orm/loading.py:337(_instance_processor)>
201	0.175	0.0009	0.175	0.0009	<sqlalchemy/orm/identity.py:163(get)>
6	0.023	0.0038	0.174	0.0290	<sqlalchemy/event/registry.py:264(append_to_list)>
2	0.013	0.0065	0.173	0.0865	<sqlalchemy/orm/query.py:4194(setup_context)>
2	0.056	0.0280	0.173	0.0865	<sqlalchemy/sql/selectable.py:2691(__init__)>
2	0.006	0.0030	0.173	0.0865	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
2	0.009	0.0045	0.171	0.0855	<sqlalchemy/engine/result.py:714(__init__)>
2	0.044	0.0220	0.171	0.0855	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
201	0.171	0.0009	0.171	0.0009	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
201	0.169	0.0008	0.169	0.0008	<string>:1(set)
2	0.167	0.0835	0.167	0.0835	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
2	0.014	0.0070	0.162	0.0810	<sqlalchemy/engine/result.py:740(_init_metadata)>
2	0.033	0.0165	0.158	0.0790	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
116	0.113	0.0010	0.153	0.0013	{isinstance}
2	0.017	0.0085	0.149	0.0745	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
9	0.072	0.0080	0.147	0.0163	<sqlalchemy/sql/compiler.py:834(visit_column)>
2	0.044	0.0220	0.146	0.0730	<sqlalchemy/engine/result.py:215(__init__)>
10	0.03	0.0030	0.144	0.0144	<sqlalchemy/util/langhelpers.py:852(__get__)>
6	0.056	0.0093	0.141	0.0235	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
2	0.056	0.0280	0.134	0.0670	<sqlalchemy/engine/default.py:636(_init_compiled)>
210	0.132	0.0006	0.132	0.0006	{built-in method __new__ of type object at 0x7f0c46c013c0}
222	0.132	0.0006	0.132	0.0006	{method 'add' of 'set' objects}
6	0.013	0.0022	0.125	0.0208	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
6	0.024	0.0040	0.121	0.0202	<sqlalchemy/event/api.py:23(_event_key)>
2	0.012	0.0060	0.121	0.0605	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
6	0.014	0.0023	0.112	0.0187	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
1	0.017	0.0170	0.111	0.1110	<sqlalchemy/engine/base.py:69(__init__)>
1	0.004	0.0040	0.108	0.1080	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
2	0.059	0.0295	0.107	0.0535	<sqlalchemy/sql/selectable.py:2963(_froms)>
1	0.004	0.0040	0.104	0.1040	<sqlalchemy/pool/base.py:354(connect)>
11	0.041	0.0037	0.103	0.0094	<sqlalchemy/orm/interfaces.py:546(setup)>
1	0.01	0.0100	0.1	0.1000	<sqlalchemy/pool/base.py:757(_checkout)>
2	0.029	0.0145	0.09	0.0450	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
1	0.014	0.0140	0.088	0.0880	<sqlalchemy/pool/base.py:490(checkout)>
6	0.022	0.0037	0.086	0.0143	<sqlalchemy/event/attr.py:234(for_modify)>
2	0.021	0.0105	0.085	0.0425	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
2	0.017	0.0085	0.082	0.0410	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
5	0.022	0.0044	0.082	0.0164	<sqlalchemy/util/_collections.py:802(to_list)>
6	0.034	0.0057	0.082	0.0137	<sqlalchemy/event/base.py:266(__getattr__)>
29	0.048	0.0017	0.076	0.0026	<sqlalchemy/sql/compiler.py:3541(quote)>
4	0.029	0.0073	0.075	0.0187	<sqlalchemy/event/base.py:295(__get__)>
2	0.019	0.0095	0.071	0.0355	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
10	0.023	0.0023	0.066	0.0066	<sqlalchemy/inspection.py:38(inspect)>
6	0.038	0.0063	0.066	0.0110	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
2	0.014	0.0070	0.061	0.0305	<sqlalchemy/orm/query.py:4045(__new__)>
9	0.03	0.0033	0.059	0.0066	<sqlalchemy/engine/default.py:1049(get_result_processor)>
6	0.026	0.0043	0.057	0.0095	<sqlalchemy/orm/events.py:1235(_accept_with)>
6	0.011	0.0018	0.056	0.0093	<tg/request_local.py:232(_current_obj)>
40/38	0.033	0.0008	0.054	0.0014	{setattr}
6	0.038	0.0063	0.054	0.0090	<sqlalchemy/event/attr.py:330(__init__)>
8	0.036	0.0045	0.051	0.0064	<sqlalchemy/event/registry.py:154(__init__)>
1	0.004	0.0040	0.051	0.0510	<sqlalchemy/orm/session.py:884(begin)>
1	0.005	0.0050	0.051	0.0510	<sqlalchemy/pool/impl.py:112(_do_get)>
16	0.04	0.0025	0.05	0.0031	<sqlalchemy/event/base.py:94(__getattr__)>
20	0.034	0.0017	0.049	0.0024	<sqlalchemy/event/attr.py:264(__iter__)>
1	0.003	0.0030	0.049	0.0490	<sqlalchemy/engine/base.py:596(begin)>
1	0.004	0.0040	0.048	0.0480	<zope/sqlalchemy/datamanager.py:245(after_begin)>
1	0.01	0.0100	0.047	0.0470	<sqlalchemy/orm/session.py:220(__init__)>
2	0.021	0.0105	0.047	0.0235	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
1	0.006	0.0060	0.046	0.0460	<sqlalchemy/engine/base.py:1737(__init__)>
2	0.011	0.0055	0.046	0.0230	<sqlalchemy/util/_collections.py:361(__init__)>
4	0.009	0.0023	0.046	0.0115	<sqlalchemy/event/base.py:119(_for_instance)>
1	0.013	0.0130	0.046	0.0460	<sqlalchemy/util/queue.py:135(get)>
1	0.007	0.0070	0.044	0.0440	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
2	0.021	0.0105	0.044	0.0220	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
2	0.008	0.0040	0.044	0.0220	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
8/6	0.021	0.0026	0.044	0.0073	<tg/support/objectproxy.py:18(__getattr__)>
4	0.008	0.0020	0.043	0.0107	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
2	0.043	0.0215	0.043	0.0215	<sqlalchemy/engine/result.py:1178(process_rows)>
9	0.029	0.0032	0.043	0.0048	<sqlalchemy/engine/result.py:724(_getter)>
13	0.041	0.0032	0.041	0.0032	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
9	0.031	0.0034	0.041	0.0046	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
5	0.024	0.0048	0.04	0.0080	<abc.py:128(__instancecheck__)>
9	0.018	0.0020	0.04	0.0044	<sqlalchemy/sql/compiler.py:3610(format_label)>
28	0.038	0.0014	0.038	0.0014	<weakref.py:362(__getitem__)>
2	0.009	0.0045	0.038	0.0190	<sqlalchemy/engine/default.py:1032(create_cursor)>
1	0.011	0.0110	0.038	0.0380	<sqlalchemy/engine/base.py:713(_begin_impl)>
9	0.025	0.0028	0.037	0.0041	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
4	0.014	0.0035	0.037	0.0092	<sqlalchemy/event/base.py:116(_for_class)>
10	0.022	0.0022	0.036	0.0036	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
4	0.014	0.0035	0.035	0.0087	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
2	0.01	0.0050	0.035	0.0175	<sqlalchemy/orm/query.py:399(_bind_mapper)>
6	0.011	0.0018	0.033	0.0055	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
1	0.013	0.0130	0.033	0.0330	<sqlalchemy/orm/session.py:337(_take_snapshot)>
1	0.012	0.0120	0.032	0.0320	<zope/sqlalchemy/datamanager.py:73(__init__)>
6	0.016	0.0027	0.031	0.0052	<sqlalchemy/event/registry.py:169(with_wrapper)>
4	0.028	0.0070	0.03	0.0075	<sqlalchemy/sql/base.py:38(_from_objects)>
2	0.018	0.0090	0.03	0.0150	<sqlalchemy/orm/query.py:4079(setup_entity)>
7	0.029	0.0041	0.029	0.0041	{_warnings.warn}
9	0.017	0.0019	0.029	0.0032	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
9	0.024	0.0027	0.028	0.0031	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
10	0.018	0.0018	0.027	0.0027	<sqlalchemy/event/attr.py:400(listeners)>
47	0.027	0.0006	0.027	0.0006	{method 'append' of 'list' objects}
9	0.021	0.0023	0.026	0.0029	<sqlalchemy/orm/strategies.py:173(setup_query)>
2	0.024	0.0120	0.026	0.0130	<sqlalchemy/orm/query.py:4650(__init__)>
3	0.015	0.0050	0.024	0.0080	<sqlalchemy/util/langhelpers.py:1157(_next)>
4	0.016	0.0040	0.023	0.0057	<sqlalchemy/event/base.py:77(__init__)>
1	0.015	0.0150	0.023	0.0230	<sqlalchemy/log.py:59(_should_log_info)>
4	0.013	0.0032	0.023	0.0057	<sqlalchemy/event/attr.py:302(__iter__)>
2	0.007	0.0035	0.023	0.0115	<tg/support/objectproxy.py:21(__setattr__)>
4	0.009	0.0023	0.023	0.0057	<logging/__init__.py:1367(isEnabledFor)>
2	0.01	0.0050	0.022	0.0110	<sqlalchemy/orm/path_registry.py:63(set)>
4	0.005	0.0012	0.022	0.0055	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
2	0.006	0.0030	0.022	0.0110	<sqlalchemy/pool/base.py:958(cursor)>
9	0.014	0.0016	0.021	0.0023	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
3	0.008	0.0027	0.02	0.0067	<sqlalchemy/orm/session.py:2425(flush)>
2	0.006	0.0030	0.02	0.0100	<sqlalchemy/orm/query.py:379(_entity_zero)>
2	0.01	0.0050	0.02	0.0100	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
9	0.014	0.0016	0.019	0.0021	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
15	0.019	0.0013	0.019	0.0013	{method 'update' of 'dict' objects}
24	0.018	0.0008	0.018	0.0008	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.013	0.0065	0.018	0.0090	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
2	0.011	0.0055	0.018	0.0090	<webob/request.py:1399(__setattr__)>
2	0.005	0.0025	0.017	0.0085	<sqlalchemy/orm/session.py:1574(_autoflush)>
2	0.008	0.0040	0.017	0.0085	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
2	0.007	0.0035	0.016	0.0080	<sqlalchemy/engine/result.py:869(_soft_close)>
4	0.009	0.0023	0.016	0.0040	<sqlalchemy/orm/base.py:228(manager_of_class)>
2	0.005	0.0025	0.016	0.0080	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
22	0.016	0.0007	0.016	0.0007	{iter}
2	0.016	0.0080	0.016	0.0080	{method 'cursor' of 'psycopg2.extensions.connection' objects}
2	0.013	0.0065	0.016	0.0080	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
12	0.016	0.0013	0.016	0.0013	{hasattr}
6	0.01	0.0017	0.015	0.0025	<sqlalchemy/event/registry.py:165(_key)>
25	0.015	0.0006	0.015	0.0006	{len}
2	0.009	0.0045	0.015	0.0075	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
9	0.014	0.0016	0.014	0.0016	<sqlalchemy/engine/result.py:643(_getter)>
2	0.014	0.0070	0.014	0.0070	<sqlalchemy/orm/query.py:371(_query_entity_zero)>
4	0.011	0.0027	0.014	0.0035	<string>:8(__new__)
9	0.014	0.0016	0.014	0.0016	<sqlalchemy/event/attr.py:267(__bool__)>
4	0.014	0.0035	0.014	0.0035	<logging/__init__.py:1353(getEffectiveLevel)>
2	0.011	0.0055	0.013	0.0065	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
9	0.012	0.0013	0.012	0.0013	<sqlalchemy/sql/compiler.py:410(__init__)>
1	0.005	0.0050	0.012	0.0120	<weakref.py:115(__setitem__)>
2	0.004	0.0020	0.012	0.0060	<logging/__init__.py:1152(debug)>
3	0.009	0.0030	0.012	0.0040	<sqlalchemy/orm/session.py:2471(_is_clean)>
11	0.012	0.0011	0.012	0.0011	{method 'intersection' of 'set' objects}
1	0.008	0.0080	0.011	0.0110	<threading.py:147(acquire)>
4	0.011	0.0027	0.011	0.0027	<weakref.py:330(__init__)>
9	0.011	0.0012	0.011	0.0012	<sqlalchemy/sql/elements.py:3939(_get_table)>
2	0.006	0.0030	0.011	0.0055	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
4	0.011	0.0027	0.011	0.0027	{method 'join' of 'str' objects}
1	0.006	0.0060	0.011	0.0110	<transaction/_transaction.py:176(join)>
1	0.007	0.0070	0.01	0.0100	<sqlalchemy/event/base.py:123(_join)>
6	0.01	0.0017	0.01	0.0017	<sqlalchemy/event/attr.py:393(__init__)>
1	0.003	0.0030	0.01	0.0100	<sqlalchemy/log.py:56(_should_log_debug)>
2	0.005	0.0025	0.01	0.0050	<sqlalchemy/sql/compiler.py:2313(visit_table)>
6	0.01	0.0017	0.01	0.0017	<_weakrefset.py:70(__contains__)>
9	0.009	0.0010	0.009	0.0010	<sqlalchemy/sql/compiler.py:419(type)>
2	0.008	0.0040	0.009	0.0045	<sqlalchemy/engine/default.py:945(should_autocommit)>
1	0.005	0.0050	0.009	0.0090	<threading.py:373(notify)>
4	0.006	0.0015	0.009	0.0023	<inspect.py:67(ismethod)>
2	0.007	0.0035	0.009	0.0045	<sqlalchemy/orm/session.py:1417(get_bind)>
4	0.008	0.0020	0.009	0.0023	<inspect.py:142(isfunction)>
11	0.009	0.0008	0.009	0.0008	{method 'update' of 'set' objects}
1	0.008	0.0080	0.009	0.0090	<sqlalchemy/pool/base.py:589(get_connection)>
6	0.009	0.0015	0.009	0.0015	<weakref.py:400(__contains__)>
12	0.009	0.0008	0.009	0.0008	{method 'pop' of 'dict' objects}
2	0.006	0.0030	0.009	0.0045	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
6	0.008	0.0013	0.008	0.0013	<tg/support/registry.py:52(_current_obj)>
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/orm/query.py:4067(__init__)>
8	0.008	0.0010	0.008	0.0010	{method 'startswith' of 'str' objects}
6	0.007	0.0012	0.007	0.0012	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
5	0.007	0.0014	0.007	0.0014	{time.time}
4	0.007	0.0018	0.007	0.0018	{method 'get' of 'dictproxy' objects}
9	0.007	0.0008	0.007	0.0008	{method 'get' of 'dict' objects}
2	0.007	0.0035	0.007	0.0035	<webob/request.py:1406(__getattr__)>
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/orm/loading.py:880(for_context)>
2	0.006	0.0030	0.007	0.0035	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
1	0.005	0.0050	0.007	0.0070	<threading.py:187(release)>
2	0.007	0.0035	0.007	0.0035	<sqlalchemy/orm/query.py:3470(_select_args)>
2	0.004	0.0020	0.006	0.0030	<inspect.py:226(isbuiltin)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/sql/selectable.py:2124(__init__)>
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
2	0.006	0.0030	0.006	0.0030	{method 'encode' of 'unicode' objects}
8	0.006	0.0008	0.006	0.0008	<sqlalchemy/orm/mapper.py:731(mapper)>
2	0.004	0.0020	0.005	0.0025	<sqlalchemy/util/_collections.py:396(__iter__)>
7	0.005	0.0007	0.005	0.0007	{method 'setdefault' of 'dict' objects}
2	0.003	0.0015	0.005	0.0025	<sqlalchemy/engine/default.py:941(no_parameters)>
2	0.004	0.0020	0.005	0.0025	<inspect.py:208(iscode)>
1	0.004	0.0040	0.005	0.0050	<weakref.py:390(get)>
9	0.005	0.0006	0.005	0.0006	<sqlalchemy/sql/elements.py:748(_select_iterable)>
4	0.005	0.0012	0.005	0.0012	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
6	0.005	0.0008	0.005	0.0008	<sqlalchemy/event/base.py:112(_listen)>
9	0.005	0.0006	0.005	0.0006	<sqlalchemy/sql/elements.py:4204(apply_map)>
2	0.004	0.0020	0.004	0.0020	{sqlalchemy.cutils._distill_params}
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/sql/compiler.py:641(construct_params)>
4	0.004	0.0010	0.004	0.0010	{method 'acquire' of 'thread.lock' objects}
1	0.004	0.0040	0.004	0.0040	<sqlalchemy/orm/identity.py:17(__init__)>
1	0.003	0.0030	0.004	0.0040	<weakref.py:310(__new__)>
1	0.003	0.0030	0.004	0.0040	<sqlalchemy/util/queue.py:203(_get)>
1	0.003	0.0030	0.004	0.0040	<transaction/_transaction.py:50(myhasattr)>
3	0.004	0.0013	0.004	0.0013	{method 'items' of 'dict' objects}
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/dialects/postgresql/psycopg2.py:535(_log_notices)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/path_registry.py:71(get)>
1	0.002	0.0020	0.004	0.0040	<transaction/_manager.py:245(get)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/session.py:267(_assert_active)>
6	0.004	0.0007	0.004	0.0007	{method 'append' of 'collections.deque' objects}
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/orm/identity.py:56(check_modified)>
3	0.003	0.0010	0.003	0.0010	<threading.py:64(_note)>
3	0.003	0.0010	0.003	0.0010	{next}
1	0.003	0.0030	0.003	0.0030	<weakref.py:315(__init__)>
1	0.003	0.0030	0.003	0.0030	<sqlalchemy/pool/base.py:724(__init__)>
1	0.003	0.0030	0.003	0.0030	<sqlalchemy/event/base.py:261(__init__)>
1	0.002	0.0020	0.003	0.0030	<threading.py:238(_is_owned)>
4	0.003	0.0008	0.003	0.0008	{method 'values' of 'dict' objects}
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/base.py:370(connection)>
2	0.003	0.0015	0.003	0.0015	{method 'close' of 'psycopg2.extensions.cursor' objects}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/sql/selectable.py:143(selectable)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/mapper.py:2132(_with_polymorphic_mappers)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
3	0.003	0.0010	0.003	0.0010	{thread.get_ident}
6	0.003	0.0005	0.003	0.0005	{method 'copy' of 'dict' objects}
4	0.003	0.0008	0.003	0.0008	{method 'release' of 'thread.lock' objects}
2	0.002	0.0010	0.002	0.0010	{delattr}
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/dialects/postgresql/base.py:1658(get_select_precolumns)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/interfaces.py:744(setup_query)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/mapper.py:2263(selectable)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/default.py:1046(post_exec)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/selectable.py:1937(_from_objects)>
1	0.002	0.0020	0.002	0.0020	<transaction/_manager.py:82(get)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/engine/base.py:1674(__init__)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/engine/default.py:496(do_begin)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/default.py:727(<genexpr>)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/compiler.py:352(__str__)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/util/_collections.py:151(union)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/result.py:864(_cursor_description)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/compiler.py:625(<genexpr>)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/event/attr.py:255(__call__)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/orm/session.py:319(_iterate_self_and_parents)>
2	0.002	0.0010	0.002	0.0010	{method 'pop' of 'list' objects}
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/default.py:1043(pre_exec)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/util/queue.py:191(_empty)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/query.py:4684(<genexpr>)>
2	0.002	0.0010	0.002	0.0010	{zip}
1	0.002	0.0020	0.002	0.0020	<weakref.py:368(__setitem__)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/util/_collections.py:730(__init__)>
2	0.001	0.0005	0.001	0.0005	{method 'union' of 'set' objects}
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/orm/session.py:306(_is_transaction_boundary)>
2	0.001	0.0005	0.001	0.0005	{method 'keys' of 'dict' objects}
1	0.001	0.0010	0.001	0.0010	{method 'popleft' of 'collections.deque' objects}
1	0.001	0.0010	0.001	0.0010	{method 'disable' of '_lsprof.Profiler' objects}

Request

GET

Nothing here.

POST

Nothing here.

Cookies

Nothing here.

Headers

Name	Value
SCRIPT_NAME	''
REQUEST_METHOD	'GET'
PATH_INFO	'/dealer/find_a_dealer'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
HTTP_USER_AGENT	'claudebot'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'13.59.82.167'
SERVER_PORT	'443'
HTTP_HOST	'jacwud.com'
HTTP_ACCEPT	'/'
CONTENT_TYPE	''

Request Attributes

Name	Value
response	"{'_app_iter': [''], '_status': '200 OK', '_headers': ResponseHeaders([('Content-Length', '0'), ('Pragma', 'no-cache'), ('Cache-Control', 'no-cache'), ('Content-Type', 'text/html; charset=utf-8')]), 'conditional_response': False, '_headerlist': [('Content-Length', '0'), ('Pragma', 'no-cache'), ('Cache-Control', 'no-cache'), ('Content-Type', 'text/html; charset=utf-8')]}"
identity	None

Environ

Name	Value
wsgi.multiprocess	False
beaker.cache	<beaker.cache.CacheManager object at 0x7f0c40349bd0>
webob._parsed_query_vars	(GET([]), '')
beaker.get_session	<bound method SessionApplicationWrapper._get_session of <tg.appwrappers.session.SessionApplicationWrapper object at 0x7f0c40e1f850>>
SCRIPT_NAME	''
webob.adhoc_attrs	{'identity': None, 'tgdb_sqla_queries': [{'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f0c3f8f6650>, 'duration': 0.5631446838378906, 'engine_id': 139690593522512, 'parameters': {}, 'statement': 'SELECT state.state_id AS state_state_id, state.state_name AS state_state_name \nFROM state'}, {'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f0c3f90dd50>, 'duration': 0.5698204040527344, 'engine_id': 139690593522512, 'parameters': {}, 'statement': 'SELECT shop.shop_id AS shop_shop_id, shop.shop_name AS shop_shop_name, shop.phone_number AS shop_phone_number, shop.email AS shop_email, shop.address_line1 AS shop_address_line1, shop.address_line2 AS shop_address_line2, shop.city_id AS shop_city_id \nFROM shop'}]}
repoze.who.api	<repoze.who.api.API object at 0x7f0c3f90d190>
REQUEST_METHOD	'GET'
PATH_INFO	'/dealer/find_a_dealer'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
repoze.who.plugins	{'cookie': <AuthTktCookiePlugin 139690593175504>, 'form': <FastFormPlugin:/login_handler 139690593231696>, 'main_identifier': <FastFormPlugin:/login_handler 139690593231696>, 'tgappauth': <tg.configuration.auth.metadata._AuthMetadataAuthenticator object at 0x7f0c4035e3d0>}
CONTENT_LENGTH	''
HTTP_USER_AGENT	'claudebot'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'13.59.82.167'
wsgi.url_scheme	'https'
SERVER_PORT	'443'
uwsgi.node	'ip-172-26-0-159'
DOCUMENT_ROOT	'/usr/share/nginx/html'
wsgi.input	<uwsgi._Input object at 0x7f0c3f69e090>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': '2fb2a75f3ce348e78131f533202cc550'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7f0c4608bd50>
REQUEST_URI	'/dealer/find_a_dealer'
HTTP_ACCEPT	'/'
wsgi.version	(1, 0)
paste.registry	<tg.support.registry.Registry object at 0x7f0c3f84ee50>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7f0c4658a6f0>
REMOTE_PORT	'51000'
REQUEST_SCHEME	'https'
paste.cookies	(<SimpleCookie: >, '')
uwsgi.version	'2.0.18'
CONTENT_TYPE	''
tg.locals	<tg.wsgiapp.RequestLocals object at 0x7f0c40004a50>
wsgi.file_wrapper	<built-in function uwsgi_sendfile>
webob._parsed_cookies	({}, '')

SQLAlchemy

Queries Performed

Query	Params	Time	Actions
SELECT state.state_id AS state_state_id, state.state_name AS state_state_name FROM state	{}	0.5631 ms	Results Explain
SELECT shop.shop_id AS shop_shop_id, shop.shop_name AS shop_shop_name, shop.phone_number AS shop_phone_number, shop.email AS shop_email, shop.address_line1 AS shop_address_line1, shop.address_line2 AS shop_address_line2, shop.city_id AS shop_city_id FROM shop	{}	0.5698 ms	Results Explain

Query

Params

Time

Actions

SELECT state.state_id AS state_state_id, state.state_name AS state_state_name 
FROM state

{}

0.5631 ms

Results

Explain

SELECT shop.shop_id AS shop_shop_id, shop.shop_name AS shop_shop_name, shop.phone_number AS shop_phone_number, shop.email AS shop_email, shop.address_line1 AS shop_address_line1, shop.address_line2 AS shop_address_line2, shop.city_id AS shop_city_id 
FROM shop

{}

0.5698 ms

Results

Explain

Controllers

Mounted Controllers

Path	Controller	Exposed Methods
/	<class 'jacwud_dev.controllers.root.RootController'>	jacwud_superd_hdf, post_login, manage_logs, media_manage, jac_veneers, index, jacwud_cement_boards, videos, contacts, jacwud_anti_cockroach_mdf, jacwud_hardwud_mdf, manage_permission_only, privacy_policy, jacwud_osb, editor_user_only, master_web, jac_doors, manage_dealer, post_logout, photos, jacteek_beech_lumber, news, data, contact_submission, articles, about, jacwud_wpc_board, environ, dashboard, login, jacwud_veneered_mdf, jacwud_pre_lam_mdf, jacteek_solid_wood
/_debugbar	<class 'tgext.debugbar.controller.DebugBarController'>	perform_ming, perform_sql
/_debugbar/statics	<class 'tgext.debugbar.controller.StaticsController'>	_default
/secc	<class 'jacwud_dev.controllers.secure.SecureController'>	index, some_where
/webpages	<class 'jacwud_dev.modules.mediacenter.controller.webpage.WebPageController'>	update_intro, get_image_store_path, update_description, edit_webpages, index, delete_webpages, publish, get_file_store_path, display_webpages_intro_detail, update_title, manage_webpages, get_web_file_path, remove_image, update_webpages_date, update_thumbnail, get_web_image_path, unpublish, update_content, save_image, save_file, update_meta_title, display_webpages_detail, error, update_active, remove_file, update_url, update_keywords
/dealer	<class 'jacwud_dev.modules.dealer.controller.root.DealerController'>	index, save_city, get_district, save_shop, save_district, manage_district, edit_city, remove_city, remove_state, save_state, edit_state, get_city, manage_state, manage_city, manage_shop, remove_shop, edit_shop, remove_district, edit_district, find_a_dealer, get_shop
/category	<class 'jacwud_dev.modules.mediacenter.controller.category.CategoryController'>	update_category_name, index, edit_category, delete_category
/media	<class 'jacwud_dev.modules.mediacenter.controller.root.MediaCenterController'>	index, videos, articles, photos, webpages, news
/media/manage_articles	<class 'jacwud_dev.modules.mediacenter.controller.articles.ArticleController'>	update_intro, get_image_store_path, display_articles_detail, update_description, edit_articles, display_articles_intro_detail, delete_articles, index, update_category, publish, get_file_store_path, update_title, get_web_file_path, remove_image, update_thumbnail, get_web_image_path, unpublish, update_articles_date, update_content, save_image, save_file, update_meta_title, manage_articles, update_active, remove_file, update_url, update_keywords
/media/manage_videos	<class 'jacwud_dev.modules.mediacenter.controller.videos.VideoController'>	update_intro, display_videos_intro_detail, get_image_store_path, update_description, delete_section, upload_videos, index, display_video_detail, edit_videos, publish, update_title, remove_image, update_thumbnail, save_sections, get_web_image_path, unpublish, update_videos_date, save_image, update_meta_title, delete_video, manage_videos, update_active, update_url, edit_section, update_keywords
/media/manage_photos	<class 'jacwud_dev.modules.mediacenter.controller.photos.PhotoController'>	update_intro, get_image_store_path, display_photos_intro_detail, update_description, manage_photos, upload_photos, index, publish, update_photos_date, update_title, delete_photo, add_photo, remove_image, update_thumbnail, save_sections, get_web_image_path, unpublish, delete_section, display_photo_detail, save_image, edit_photos, update_meta_title, update_active, update_url, edit_section, update_keywords
/media/manage_news	<class 'jacwud_dev.modules.mediacenter.controller.news.NewsController'>	update_intro, get_image_store_path, update_description, index, update_featured, display_news_intro_detail, publish, get_file_store_path, delete_news, update_title, get_web_file_path, update_news_date, remove_image, update_thumbnail, edit_news, get_web_image_path, manage_news, unpublish, update_content, save_image, display_news_detail, save_file, update_meta_title, update_active, remove_file, update_url, update_keywords
/media/manage_webpages	<class 'jacwud_dev.modules.mediacenter.controller.webpage.WebPageController'>	update_intro, get_image_store_path, update_description, edit_webpages, index, delete_webpages, publish, get_file_store_path, display_webpages_intro_detail, update_title, manage_webpages, get_web_file_path, remove_image, update_webpages_date, update_thumbnail, get_web_image_path, unpublish, update_content, save_image, save_file, update_meta_title, display_webpages_detail, error, update_active, remove_file, update_url, update_keywords
/error	<class 'jacwud_dev.controllers.error.ErrorController'>	document
/webdocu	<class 'jacwud_dev.modules.webdocu.controllers.root.WebDocu'>	index, get_image_store_path, save_image, ae, ae_delete, md, dd, get_web_image_path, dc, publish, unpublish, ae_edit
/managecontact	<class 'jacwud_dev.modules.contact.controller.root.ContactFormSubmissionsController'>	index, mailer, submissions
/admin	<class 'tgext.admin.controller.AdminController'>	index, lookup, _lookup

Logging

Log Messages

Level	Time	Message	Location

Inventing

Inventing Mode

Invending mode permits to see on the fly the result of your changes by automatically reloading the web page whenever your python code or the page template changes.

It is meant as a way to improve developer experience when experimenting with changes to the source code, just put your browser and your test editor one near the other and enable inventing mode to start experimenting.

Turn On

To permanently enable inventing mode when in debug add debugbar.inventing=True option to your application configuration.

Find a dealer

Choose state, district and city to locate the nearest dealer.

Timing

Template

Profiling

GET

POST

Cookies

Headers

Request Attributes

Environ

Queries Performed

Mounted Controllers

Log Messages

Inventing Mode