Timings

Timing

Action	Time Spent
Render Time	13.1252 ms
Controller Time	204.1111 ms
Total Time	230.3391 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.005	0.0050	204.051	204.0510	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.012	0.0120	204.046	204.0460	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
2	0.17	0.0850	202.591	101.2955	<sqlalchemy/orm/query.py:3162(all)>
2	0.014	0.0070	193.276	96.6380	<sqlalchemy/orm/query.py:3319(__iter__)>
2	0.021	0.0105	192.557	96.2785	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.01	0.0050	192.158	96.0790	<sqlalchemy/engine/base.py:922(execute)>
2	0.008	0.0040	192.145	96.0725	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	0.801	0.4005	192.137	96.0685	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
2	2.997	1.4985	189.64	94.8200	<sqlalchemy/engine/base.py:1163(_execute_context)>
2	0.696	0.3480	178.397	89.1985	<sqlalchemy/engine/default.py:549(do_execute)>
2	177.701	88.8505	177.701	88.8505	{method 'execute' of 'psycopg2.extensions.cursor' objects}
1	0.01	0.0100	137.799	137.7990	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
1	0.009	0.0090	66.235	66.2350	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
203	0.403	0.0020	9.145	0.0450	<sqlalchemy/orm/loading.py:35(instances)>
7	0.066	0.0094	4.453	0.6361	<sqlalchemy/event/attr.py:291(__call__)>
201	1.519	0.0076	4.409	0.0219	<sqlalchemy/orm/loading.py:492(_instance)>
2	0.078	0.0390	3.932	1.9660	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
2	0.078	0.0390	2.242	1.1210	<sqlalchemy/engine/default.py:636(_init_compiled)>
2	0.01	0.0050	2.112	1.0560	<sqlalchemy/engine/default.py:1032(create_cursor)>
2	1.1	0.5500	2.094	1.0470	<sqlalchemy/pool/base.py:958(cursor)>
2	0.016	0.0080	1.712	0.8560	<sqlalchemy/engine/result.py:1195(fetchall)>
5	1.65	0.3300	1.65	0.3300	{time.time}
152/142	0.217	0.0014	1.582	0.0111	{getattr}
2	0.016	0.0080	1.533	0.7665	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
201	0.728	0.0036	1.525	0.0076	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
2	0.013	0.0065	1.51	0.7550	<sqlalchemy/engine/result.py:714(__init__)>
2	0.027	0.0135	1.497	0.7485	<sqlalchemy/engine/result.py:740(_init_metadata)>
2	0.774	0.3870	1.468	0.7340	<sqlalchemy/engine/result.py:215(__init__)>
2	0.014	0.0070	1.424	0.7120	<sqlalchemy/orm/scoping.py:161(do)>
3	0.022	0.0073	1.348	0.4493	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.012	0.0060	1.175	0.5875	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.015	0.0150	1.163	1.1630	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.03	0.0300	1.113	1.1130	<sqlalchemy/orm/session.py:646(__init__)>
2	0.01	0.0050	1.085	0.5425	<string>:1(<lambda>)
2	0.009	0.0045	1.075	0.5375	<sqlalchemy/sql/elements.py:399(compile)>
2	0.011	0.0055	1.066	0.5330	<sqlalchemy/sql/elements.py:464(_compiler)>
2	0.037	0.0185	1.055	0.5275	<sqlalchemy/sql/compiler.py:500(__init__)>
2	0.014	0.0070	1.01	0.5050	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.008	0.0040	0.996	0.4980	<sqlalchemy/sql/compiler.py:349(process)>
2	0.994	0.4970	0.994	0.4970	{method 'cursor' of 'psycopg2.extensions.connection' objects}
22/2	0.071	0.0032	0.988	0.4940	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
1	0.056	0.0560	0.977	0.9770	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
2	0.059	0.0295	0.977	0.4885	<sqlalchemy/sql/compiler.py:2001(visit_select)>
3	0.022	0.0073	0.931	0.3103	<sqlalchemy/util/langhelpers.py:1157(_next)>
2	0.912	0.4560	0.912	0.4560	<sqlalchemy/engine/result.py:1178(process_rows)>
3	0.903	0.3010	0.903	0.3010	{next}
6	0.448	0.0747	0.879	0.1465	<sqlalchemy/util/_collections.py:755(unique_list)>
2	0.661	0.3305	0.879	0.4395	<sqlalchemy/orm/query.py:4159(row_processor)>
6	0.022	0.0037	0.824	0.1373	<sqlalchemy/event/api.py:34(listen)>
2	0.015	0.0075	0.79	0.3950	<webob/request.py:1399(__setattr__)>
8	0.775	0.0969	0.775	0.0969	{method 'startswith' of 'str' objects}
2	0.609	0.3045	0.761	0.3805	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
6	0.013	0.0022	0.748	0.1247	<tg/request_local.py:232(_current_obj)>
8/6	0.025	0.0031	0.722	0.1203	<tg/support/objectproxy.py:18(__getattr__)>
6	0.088	0.0147	0.693	0.1155	<sqlalchemy/event/registry.py:193(listen)>
2	0.036	0.0180	0.684	0.3420	<sqlalchemy/orm/query.py:3828(_compile_context)>
2	0.045	0.0225	0.679	0.3395	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
6	0.675	0.1125	0.675	0.1125	<tg/support/registry.py:52(_current_obj)>
201	0.656	0.0033	0.656	0.0033	<sqlalchemy/orm/loading.py:677(_populate_full)>
9	0.026	0.0029	0.632	0.0702	<sqlalchemy/engine/default.py:1049(get_result_processor)>
9	0.1	0.0111	0.619	0.0688	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
2	0.616	0.3080	0.616	0.3080	<webob/request.py:1406(__getattr__)>
9	0.589	0.0654	0.606	0.0673	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
2	0.534	0.2670	0.534	0.2670	{sqlalchemy.cutils._distill_params}
201	0.426	0.0021	0.426	0.0021	<sqlalchemy/orm/state.py:89(__init__)>
20	0.042	0.0021	0.412	0.0206	<sqlalchemy/event/attr.py:264(__iter__)>
9	0.095	0.0106	0.408	0.0453	<sqlalchemy/sql/compiler.py:780(visit_label)>
2	0.011	0.0055	0.378	0.1890	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
22	0.372	0.0169	0.372	0.0169	{iter}
201	0.366	0.0018	0.366	0.0018	{method 'issuperset' of 'frozenset' objects}
2	0.009	0.0045	0.343	0.1715	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
2	0.01	0.0050	0.334	0.1670	<sqlalchemy/orm/session.py:1048(connection)>
6	0.011	0.0018	0.319	0.0532	<sqlalchemy/event/base.py:243(_listen)>
2	0.008	0.0040	0.314	0.1570	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
6	0.026	0.0043	0.308	0.0513	<sqlalchemy/event/registry.py:243(base_listen)>
2	0.016	0.0080	0.306	0.1530	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
2	0.032	0.0160	0.281	0.1405	<sqlalchemy/orm/query.py:3953(_simple_statement)>
428	0.274	0.0006	0.274	0.0006	{id}
2	0.08	0.0400	0.266	0.1330	<sqlalchemy/orm/query.py:4194(setup_context)>
2	0.014	0.0070	0.24	0.1200	<string>:1(select)
2	0.008	0.0040	0.233	0.1165	<sqlalchemy/orm/session.py:1540(query)>
2	0.013	0.0065	0.226	0.1130	<string>:1(__init__)
201	0.225	0.0011	0.225	0.0011	<string>:1(set)
2	0.006	0.0030	0.225	0.1125	<sqlalchemy/orm/query.py:141(__init__)>
2	0.023	0.0115	0.219	0.1095	<sqlalchemy/orm/query.py:170(_set_entities)>
2	0.112	0.0560	0.212	0.1060	<sqlalchemy/orm/loading.py:337(_instance_processor)>
2	0.07	0.0350	0.202	0.1010	<sqlalchemy/sql/selectable.py:2691(__init__)>
2	0.037	0.0185	0.184	0.0920	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
1	0.009	0.0090	0.184	0.1840	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
201	0.183	0.0009	0.183	0.0009	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
6	0.012	0.0020	0.182	0.0303	<sqlalchemy/event/attr.py:374(append)>
9	0.086	0.0096	0.172	0.0191	<sqlalchemy/sql/compiler.py:834(visit_column)>
6	0.025	0.0042	0.17	0.0283	<sqlalchemy/event/registry.py:264(append_to_list)>
10	0.037	0.0037	0.166	0.0166	<sqlalchemy/util/langhelpers.py:852(__get__)>
6	0.014	0.0023	0.161	0.0268	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
210	0.16	0.0008	0.16	0.0008	{built-in method __new__ of type object at 0x7f45e236b3c0}
201	0.16	0.0008	0.16	0.0008	<sqlalchemy/orm/identity.py:163(get)>
2	0.152	0.0760	0.152	0.0760	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
116	0.106	0.0009	0.151	0.0013	{isinstance}
222	0.148	0.0007	0.148	0.0007	{method 'add' of 'set' objects}
6	0.033	0.0055	0.147	0.0245	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
2	0.021	0.0105	0.138	0.0690	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
6	0.048	0.0080	0.136	0.0227	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
11	0.047	0.0043	0.12	0.0109	<sqlalchemy/orm/interfaces.py:546(setup)>
6	0.027	0.0045	0.109	0.0182	<sqlalchemy/event/api.py:23(_event_key)>
2	0.016	0.0080	0.105	0.0525	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
2	0.028	0.0140	0.1	0.0500	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
1	0.002	0.0020	0.098	0.0980	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
1	0.004	0.0040	0.096	0.0960	<sqlalchemy/pool/base.py:354(connect)>
6	0.028	0.0047	0.095	0.0158	<sqlalchemy/event/attr.py:234(for_modify)>
1	0.011	0.0110	0.092	0.0920	<sqlalchemy/pool/base.py:757(_checkout)>
6	0.031	0.0052	0.092	0.0153	<sqlalchemy/event/base.py:266(__getattr__)>
2	0.022	0.0110	0.089	0.0445	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
5	0.024	0.0048	0.089	0.0178	<sqlalchemy/util/_collections.py:802(to_list)>
2	0.048	0.0240	0.087	0.0435	<sqlalchemy/sql/selectable.py:2963(_froms)>
29	0.058	0.0020	0.087	0.0030	<sqlalchemy/sql/compiler.py:3541(quote)>
10	0.035	0.0035	0.086	0.0086	<sqlalchemy/inspection.py:38(inspect)>
1	0.013	0.0130	0.08	0.0800	<sqlalchemy/pool/base.py:490(checkout)>
2	0.019	0.0095	0.08	0.0400	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
1	0.021	0.0210	0.077	0.0770	<sqlalchemy/engine/base.py:69(__init__)>
4	0.017	0.0043	0.072	0.0180	<sqlalchemy/event/base.py:295(__get__)>
6	0.042	0.0070	0.07	0.0117	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
2	0.012	0.0060	0.07	0.0350	<sqlalchemy/orm/query.py:4045(__new__)>
40/38	0.037	0.0009	0.06	0.0016	{setattr}
6	0.04	0.0067	0.058	0.0097	<sqlalchemy/event/attr.py:330(__init__)>
2	0.012	0.0060	0.057	0.0285	<sqlalchemy/util/_collections.py:361(__init__)>
16	0.043	0.0027	0.057	0.0036	<sqlalchemy/event/base.py:94(__getattr__)>
4	0.012	0.0030	0.055	0.0137	<sqlalchemy/event/base.py:119(_for_instance)>
2	0.025	0.0125	0.054	0.0270	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
1	0.005	0.0050	0.054	0.0540	<sqlalchemy/orm/session.py:884(begin)>
2	0.01	0.0050	0.053	0.0265	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
13	0.051	0.0039	0.051	0.0039	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
4	0.009	0.0023	0.051	0.0127	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
8	0.035	0.0044	0.05	0.0062	<sqlalchemy/event/registry.py:154(__init__)>
1	0.013	0.0130	0.049	0.0490	<sqlalchemy/orm/session.py:220(__init__)>
1	0.004	0.0040	0.048	0.0480	<sqlalchemy/engine/base.py:596(begin)>
1	0.005	0.0050	0.048	0.0480	<sqlalchemy/pool/impl.py:112(_do_get)>
9	0.034	0.0038	0.047	0.0052	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
1	0.005	0.0050	0.047	0.0470	<zope/sqlalchemy/datamanager.py:245(after_begin)>
28	0.046	0.0016	0.046	0.0016	<weakref.py:362(__getitem__)>
5	0.025	0.0050	0.045	0.0090	<abc.py:128(__instancecheck__)>
2	0.022	0.0110	0.045	0.0225	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
1	0.006	0.0060	0.044	0.0440	<sqlalchemy/engine/base.py:1737(__init__)>
6	0.023	0.0038	0.043	0.0072	<sqlalchemy/orm/events.py:1235(_accept_with)>
4	0.016	0.0040	0.043	0.0107	<sqlalchemy/event/base.py:116(_for_class)>
1	0.012	0.0120	0.043	0.0430	<sqlalchemy/util/queue.py:135(get)>
1	0.008	0.0080	0.042	0.0420	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
4	0.018	0.0045	0.042	0.0105	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
9	0.017	0.0019	0.04	0.0044	<sqlalchemy/sql/compiler.py:3610(format_label)>
9	0.024	0.0027	0.039	0.0043	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
6	0.012	0.0020	0.038	0.0063	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
7	0.037	0.0053	0.037	0.0053	{_warnings.warn}
1	0.012	0.0120	0.037	0.0370	<sqlalchemy/engine/base.py:713(_begin_impl)>
47	0.036	0.0008	0.036	0.0008	{method 'append' of 'list' objects}
10	0.021	0.0021	0.035	0.0035	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
2	0.02	0.0100	0.035	0.0175	<sqlalchemy/orm/query.py:4079(setup_entity)>
9	0.016	0.0018	0.035	0.0039	<sqlalchemy/engine/result.py:724(_getter)>
4	0.007	0.0018	0.033	0.0082	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
2	0.015	0.0075	0.032	0.0160	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
9	0.025	0.0028	0.031	0.0034	<sqlalchemy/orm/strategies.py:173(setup_query)>
1	0.013	0.0130	0.031	0.0310	<sqlalchemy/orm/session.py:337(_take_snapshot)>
2	0.027	0.0135	0.031	0.0155	<sqlalchemy/orm/query.py:4650(__init__)>
6	0.014	0.0023	0.031	0.0052	<sqlalchemy/event/registry.py:169(with_wrapper)>
10	0.02	0.0020	0.03	0.0030	<sqlalchemy/event/attr.py:400(listeners)>
1	0.011	0.0110	0.03	0.0300	<zope/sqlalchemy/datamanager.py:73(__init__)>
4	0.019	0.0047	0.027	0.0067	<sqlalchemy/event/base.py:77(__init__)>
9	0.022	0.0024	0.027	0.0030	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
2	0.009	0.0045	0.027	0.0135	<sqlalchemy/orm/path_registry.py:63(set)>
9	0.026	0.0029	0.026	0.0029	<sqlalchemy/sql/compiler.py:410(__init__)>
2	0.01	0.0050	0.026	0.0130	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
2	0.008	0.0040	0.025	0.0125	<tg/support/objectproxy.py:21(__setattr__)>
2	0.011	0.0055	0.024	0.0120	<sqlalchemy/orm/query.py:399(_bind_mapper)>
2	0.011	0.0055	0.023	0.0115	<sqlalchemy/engine/result.py:869(_soft_close)>
4	0.011	0.0027	0.023	0.0057	<sqlalchemy/event/attr.py:302(__iter__)>
15	0.023	0.0015	0.023	0.0015	{method 'update' of 'dict' objects}
2	0.015	0.0075	0.023	0.0115	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
3	0.008	0.0027	0.022	0.0073	<sqlalchemy/orm/session.py:2425(flush)>
9	0.014	0.0016	0.022	0.0024	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
9	0.014	0.0016	0.021	0.0023	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
2	0.007	0.0035	0.021	0.0105	<sqlalchemy/orm/session.py:1574(_autoflush)>
2	0.013	0.0065	0.021	0.0105	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
4	0.018	0.0045	0.02	0.0050	<sqlalchemy/sql/base.py:38(_from_objects)>
25	0.019	0.0008	0.019	0.0008	{len}
9	0.019	0.0021	0.019	0.0021	<sqlalchemy/engine/result.py:643(_getter)>
24	0.019	0.0008	0.019	0.0008	<sqlalchemy/event/registry.py:260(_listen_fn)>
4	0.01	0.0025	0.019	0.0047	<string>:8(__new__)
4	0.011	0.0027	0.018	0.0045	<sqlalchemy/orm/base.py:228(manager_of_class)>
2	0.006	0.0030	0.018	0.0090	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
4	0.01	0.0025	0.018	0.0045	<logging/__init__.py:1367(isEnabledFor)>
2	0.011	0.0055	0.018	0.0090	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
2	0.006	0.0030	0.018	0.0090	<logging/__init__.py:1152(debug)>
9	0.016	0.0018	0.016	0.0018	<sqlalchemy/event/attr.py:267(__bool__)>
12	0.015	0.0013	0.015	0.0013	{hasattr}
6	0.01	0.0017	0.014	0.0023	<sqlalchemy/event/registry.py:165(_key)>
2	0.012	0.0060	0.014	0.0070	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
6	0.014	0.0023	0.014	0.0023	<_weakrefset.py:70(__contains__)>
3	0.01	0.0033	0.014	0.0047	<sqlalchemy/orm/session.py:2471(_is_clean)>
2	0.011	0.0055	0.012	0.0060	<sqlalchemy/engine/default.py:945(should_autocommit)>
6	0.012	0.0020	0.012	0.0020	<sqlalchemy/event/attr.py:393(__init__)>
1	0.005	0.0050	0.012	0.0120	<weakref.py:115(__setitem__)>
2	0.008	0.0040	0.012	0.0060	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
6	0.012	0.0020	0.012	0.0020	<weakref.py:400(__contains__)>
2	0.012	0.0060	0.012	0.0060	{method 'encode' of 'unicode' objects}
2	0.008	0.0040	0.012	0.0060	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
2	0.006	0.0030	0.011	0.0055	<sqlalchemy/sql/compiler.py:2313(visit_table)>
9	0.011	0.0012	0.011	0.0012	<sqlalchemy/sql/elements.py:3939(_get_table)>
4	0.011	0.0027	0.011	0.0027	{method 'join' of 'str' objects}
1	0.007	0.0070	0.011	0.0110	<transaction/_transaction.py:176(join)>
4	0.006	0.0015	0.01	0.0025	<inspect.py:67(ismethod)>
2	0.007	0.0035	0.01	0.0050	<sqlalchemy/orm/session.py:1417(get_bind)>
4	0.008	0.0020	0.01	0.0025	<inspect.py:142(isfunction)>
11	0.01	0.0009	0.01	0.0009	{method 'update' of 'set' objects}
1	0.007	0.0070	0.01	0.0100	<threading.py:147(acquire)>
1	0.009	0.0090	0.01	0.0100	<sqlalchemy/pool/base.py:589(get_connection)>
12	0.01	0.0008	0.01	0.0008	{method 'pop' of 'dict' objects}
2	0.008	0.0040	0.009	0.0045	<sqlalchemy/orm/query.py:4067(__init__)>
4	0.009	0.0023	0.009	0.0023	<weakref.py:330(__init__)>
11	0.009	0.0008	0.009	0.0008	{method 'intersection' of 'set' objects}
1	0.005	0.0050	0.008	0.0080	<threading.py:373(notify)>
4	0.008	0.0020	0.008	0.0020	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/orm/query.py:379(_entity_zero)>
4	0.008	0.0020	0.008	0.0020	{method 'values' of 'dict' objects}
2	0.007	0.0035	0.008	0.0040	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
4	0.008	0.0020	0.008	0.0020	<logging/__init__.py:1353(getEffectiveLevel)>
9	0.008	0.0009	0.008	0.0009	<sqlalchemy/sql/elements.py:748(_select_iterable)>
2	0.008	0.0040	0.008	0.0040	<sqlalchemy/orm/query.py:3470(_select_args)>
1	0.004	0.0040	0.007	0.0070	<sqlalchemy/event/base.py:123(_join)>
6	0.007	0.0012	0.007	0.0012	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
1	0.004	0.0040	0.007	0.0070	<sqlalchemy/log.py:59(_should_log_info)>
1	0.007	0.0070	0.007	0.0070	<sqlalchemy/orm/identity.py:17(__init__)>
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
7	0.007	0.0010	0.007	0.0010	{method 'setdefault' of 'dict' objects}
2	0.007	0.0035	0.007	0.0035	<sqlalchemy/dialects/postgresql/psycopg2.py:535(_log_notices)>
4	0.007	0.0018	0.007	0.0018	{method 'get' of 'dictproxy' objects}
1	0.005	0.0050	0.007	0.0070	<threading.py:187(release)>
9	0.006	0.0007	0.006	0.0007	<sqlalchemy/sql/compiler.py:419(type)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/util/_collections.py:396(__iter__)>
2	0.004	0.0020	0.006	0.0030	<inspect.py:226(isbuiltin)>
1	0.003	0.0030	0.006	0.0060	<sqlalchemy/log.py:56(_should_log_debug)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/engine/default.py:941(no_parameters)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/orm/path_registry.py:71(get)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/orm/loading.py:880(for_context)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
6	0.006	0.0010	0.006	0.0010	<sqlalchemy/event/base.py:112(_listen)>
8	0.006	0.0008	0.006	0.0008	<sqlalchemy/orm/mapper.py:731(mapper)>
9	0.006	0.0007	0.006	0.0007	<sqlalchemy/sql/elements.py:4204(apply_map)>
6	0.006	0.0010	0.006	0.0010	{method 'copy' of 'dict' objects}
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/sql/selectable.py:2124(__init__)>
4	0.005	0.0012	0.005	0.0012	{method 'acquire' of 'thread.lock' objects}
1	0.004	0.0040	0.005	0.0050	<sqlalchemy/util/queue.py:203(_get)>
9	0.005	0.0006	0.005	0.0006	{method 'get' of 'dict' objects}
2	0.005	0.0025	0.005	0.0025	<inspect.py:208(iscode)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/orm/session.py:267(_assert_active)>
6	0.005	0.0008	0.005	0.0008	{method 'append' of 'collections.deque' objects}
3	0.004	0.0013	0.004	0.0013	<sqlalchemy/orm/identity.py:56(check_modified)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/sql/compiler.py:641(construct_params)>
1	0.003	0.0030	0.004	0.0040	<weakref.py:310(__new__)>
1	0.003	0.0030	0.004	0.0040	<transaction/_transaction.py:50(myhasattr)>
1	0.003	0.0030	0.004	0.0040	<weakref.py:390(get)>
1	0.002	0.0020	0.004	0.0040	<transaction/_manager.py:245(get)>
2	0.004	0.0020	0.004	0.0020	{method 'close' of 'psycopg2.extensions.cursor' objects}
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/mapper.py:2132(_with_polymorphic_mappers)>
2	0.004	0.0020	0.004	0.0020	{zip}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/dialects/postgresql/base.py:1658(get_select_precolumns)>
1	0.003	0.0030	0.003	0.0030	<weakref.py:315(__init__)>
1	0.003	0.0030	0.003	0.0030	<sqlalchemy/event/base.py:261(__init__)>
3	0.003	0.0010	0.003	0.0010	{method 'items' of 'dict' objects}
1	0.002	0.0020	0.003	0.0030	<threading.py:238(_is_owned)>
2	0.003	0.0015	0.003	0.0015	{method 'pop' of 'list' objects}
3	0.003	0.0010	0.003	0.0010	{thread.get_ident}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/util/_collections.py:730(__init__)>
4	0.003	0.0008	0.003	0.0008	{method 'release' of 'thread.lock' objects}
2	0.002	0.0010	0.002	0.0010	{method 'union' of 'set' objects}
2	0.002	0.0010	0.002	0.0010	{delattr}
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)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/pool/base.py:724(__init__)>
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)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/query.py:371(_query_entity_zero)>
1	0.002	0.0020	0.002	0.0020	<transaction/_manager.py:82(get)>
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 'keys' of 'dict' objects}
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/default.py:1043(pre_exec)>
3	0.002	0.0007	0.002	0.0007	<sqlalchemy/engine/base.py:370(connection)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/query.py:4684(<genexpr>)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/selectable.py:143(selectable)>
3	0.001	0.0003	0.001	0.0003	<threading.py:64(_note)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/orm/session.py:306(_is_transaction_boundary)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/engine/base.py:1674(__init__)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/engine/default.py:496(do_begin)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/util/queue.py:191(_empty)>
1	0.001	0.0010	0.001	0.0010	{method 'popleft' of 'collections.deque' objects}
1	0.001	0.0010	0.001	0.0010	<weakref.py:368(__setitem__)>
1	0.0	0.0000	0.0	0.0000	{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	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'3.138.204.67'
SERVER_PORT	'443'
HTTP_HOST	'jacwud.com'
HTTP_ACCEPT	'/'
CONTENT_TYPE	''
HTTP_ACCEPT_ENCODING	'gzip, br, zstd, deflate'

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 0x7f45dbab3c10>
webob._parsed_query_vars	(GET([]), '')
beaker.get_session	<bound method SessionApplicationWrapper._get_session of <tg.appwrappers.session.SessionApplicationWrapper object at 0x7f45dc52f590>>
SCRIPT_NAME	''
webob.adhoc_attrs	{'identity': None, 'tgdb_sqla_queries': [{'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f45d68ccd50>, 'duration': 126.89900398254395, 'engine_id': 139938014901136, '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 0x7f45d6915450>, 'duration': 54.90612983703613, 'engine_id': 139938014901136, '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 0x7f45d68cc490>
REQUEST_METHOD	'GET'
PATH_INFO	'/dealer/find-a-dealer'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
repoze.who.plugins	{'cookie': <AuthTktCookiePlugin 139938014554128>, 'form': <FastFormPlugin:/login_handler 139938014610320>, 'main_identifier': <FastFormPlugin:/login_handler 139938014610320>, 'tgappauth': <tg.configuration.auth.metadata._AuthMetadataAuthenticator object at 0x7f45dbac8410>}
CONTENT_LENGTH	''
HTTP_USER_AGENT	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'3.138.204.67'
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 0x7f45d69022d0>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': 'e57a708dd255489a87c02099c3661e69'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7f45e17f4d90>
REQUEST_URI	'/dealer/find-a-dealer'
HTTP_ACCEPT	'/'
wsgi.version	(1, 0)
paste.registry	<tg.support.registry.Registry object at 0x7f45d68cc2d0>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7f45e1cf46f0>
REMOTE_PORT	'62404'
REQUEST_SCHEME	'https'
paste.cookies	(<SimpleCookie: >, '')
uwsgi.version	'2.0.18'
CONTENT_TYPE	''
tg.locals	<tg.wsgiapp.RequestLocals object at 0x7f45d6917ad0>
wsgi.file_wrapper	<built-in function uwsgi_sendfile>
HTTP_ACCEPT_ENCODING	'gzip, br, zstd, deflate'
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	{}	126.8990 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	{}	54.9061 ms	Results Explain

Query

Params

Time

Actions

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

{}

126.8990 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

{}

54.9061 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