Timings

Timing

Action	Time Spent
Render Time	3.2701 ms
Controller Time	11.1799 ms
Total Time	23.0761 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.004	0.0040	11.162	11.1620	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.008	0.0080	11.158	11.1580	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
2	0.173	0.0865	9.757	4.8785	<sqlalchemy/orm/query.py:3162(all)>
1	0.007	0.0070	7.713	7.7130	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
203	0.38	0.0019	5.937	0.0292	<sqlalchemy/orm/loading.py:35(instances)>
201	1.454	0.0072	4.323	0.0215	<sqlalchemy/orm/loading.py:492(_instance)>
2	0.014	0.0070	3.647	1.8235	<sqlalchemy/orm/query.py:3319(__iter__)>
1	0.009	0.0090	3.437	3.4370	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
2	0.016	0.0080	3.046	1.5230	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.008	0.0040	2.66	1.3300	<sqlalchemy/engine/base.py:922(execute)>
2	0.007	0.0035	2.65	1.3250	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	0.046	0.0230	2.643	1.3215	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
201	0.72	0.0036	1.516	0.0075	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
2	0.067	0.0335	1.489	0.7445	<sqlalchemy/engine/base.py:1163(_execute_context)>
2	0.014	0.0070	1.377	0.6885	<sqlalchemy/orm/scoping.py:161(do)>
3	0.022	0.0073	1.296	0.4320	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.009	0.0045	1.137	0.5685	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.014	0.0140	1.128	1.1280	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.025	0.0250	1.083	1.0830	<sqlalchemy/orm/session.py:646(__init__)>
2	0.008	0.0040	1.031	0.5155	<string>:1(<lambda>)
2	0.009	0.0045	1.023	0.5115	<sqlalchemy/sql/elements.py:399(compile)>
2	0.008	0.0040	1.014	0.5070	<sqlalchemy/sql/elements.py:464(_compiler)>
2	0.029	0.0145	1.006	0.5030	<sqlalchemy/sql/compiler.py:500(__init__)>
2	0.011	0.0055	0.972	0.4860	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.007	0.0035	0.961	0.4805	<sqlalchemy/sql/compiler.py:349(process)>
1	0.069	0.0690	0.958	0.9580	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
22/2	0.064	0.0029	0.954	0.4770	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
2	0.051	0.0255	0.943	0.4715	<sqlalchemy/sql/compiler.py:2001(visit_select)>
6	0.461	0.0768	0.887	0.1478	<sqlalchemy/util/_collections.py:755(unique_list)>
6	0.02	0.0033	0.792	0.1320	<sqlalchemy/event/api.py:34(listen)>
2	0.008	0.0040	0.786	0.3930	<sqlalchemy/engine/default.py:549(do_execute)>
2	0.778	0.3890	0.778	0.3890	{method 'execute' of 'psycopg2.extensions.cursor' objects}
6	0.081	0.0135	0.664	0.1107	<sqlalchemy/event/registry.py:193(listen)>
9	0.08	0.0089	0.581	0.0646	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
2	0.03	0.0150	0.558	0.2790	<sqlalchemy/orm/query.py:3828(_compile_context)>
201	0.526	0.0026	0.526	0.0026	<sqlalchemy/orm/loading.py:677(_populate_full)>
201	0.477	0.0024	0.477	0.0024	<sqlalchemy/orm/state.py:89(__init__)>
201	0.462	0.0023	0.462	0.0023	{method 'issuperset' of 'frozenset' objects}
9	0.091	0.0101	0.411	0.0457	<sqlalchemy/sql/compiler.py:780(visit_label)>
2	0.008	0.0040	0.37	0.1850	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
2	0.009	0.0045	0.339	0.1695	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
2	0.011	0.0055	0.33	0.1650	<sqlalchemy/orm/session.py:1048(connection)>
6	0.012	0.0020	0.326	0.0543	<sqlalchemy/event/base.py:243(_listen)>
6	0.026	0.0043	0.314	0.0523	<sqlalchemy/event/registry.py:243(base_listen)>
7	0.038	0.0054	0.31	0.0443	<sqlalchemy/event/attr.py:291(__call__)>
2	0.004	0.0020	0.31	0.1550	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
428	0.306	0.0007	0.306	0.0007	{id}
2	0.015	0.0075	0.306	0.1530	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
152/142	0.197	0.0013	0.275	0.0019	{getattr}
2	0.026	0.0130	0.256	0.1280	<sqlalchemy/orm/query.py:3953(_simple_statement)>
2	0.008	0.0040	0.224	0.1120	<sqlalchemy/orm/session.py:1540(query)>
2	0.012	0.0060	0.222	0.1110	<string>:1(select)
2	0.016	0.0080	0.216	0.1080	<sqlalchemy/orm/query.py:141(__init__)>
2	0.015	0.0075	0.21	0.1050	<string>:1(__init__)
2	0.013	0.0065	0.209	0.1045	<sqlalchemy/engine/result.py:1195(fetchall)>
2	0.02	0.0100	0.2	0.1000	<sqlalchemy/orm/query.py:170(_set_entities)>
6	0.013	0.0022	0.195	0.0325	<sqlalchemy/event/attr.py:374(append)>
2	0.014	0.0070	0.194	0.0970	<sqlalchemy/orm/query.py:4194(setup_context)>
201	0.193	0.0010	0.193	0.0010	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
201	0.189	0.0009	0.189	0.0009	<string>:1(set)
2	0.01	0.0050	0.187	0.0935	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
2	0.052	0.0260	0.185	0.0925	<sqlalchemy/sql/selectable.py:2691(__init__)>
1	0.008	0.0080	0.184	0.1840	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
6	0.026	0.0043	0.182	0.0303	<sqlalchemy/event/registry.py:264(append_to_list)>
2	0.036	0.0180	0.178	0.0890	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
2	0.039	0.0195	0.177	0.0885	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
2	0.011	0.0055	0.172	0.0860	<sqlalchemy/engine/result.py:714(__init__)>
201	0.172	0.0009	0.172	0.0009	<sqlalchemy/orm/identity.py:163(get)>
2	0.019	0.0095	0.172	0.0860	<sqlalchemy/orm/query.py:4159(row_processor)>
116	0.11	0.0009	0.161	0.0014	{isinstance}
2	0.015	0.0075	0.161	0.0805	<sqlalchemy/engine/result.py:740(_init_metadata)>
9	0.081	0.0090	0.161	0.0179	<sqlalchemy/sql/compiler.py:834(visit_column)>
10	0.033	0.0033	0.154	0.0154	<sqlalchemy/util/langhelpers.py:852(__get__)>
2	0.074	0.0370	0.15	0.0750	<sqlalchemy/orm/loading.py:337(_instance_processor)>
6	0.047	0.0078	0.148	0.0247	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
2	0.02	0.0100	0.147	0.0735	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
2	0.059	0.0295	0.145	0.0725	<sqlalchemy/engine/default.py:636(_init_compiled)>
2	0.047	0.0235	0.143	0.0715	<sqlalchemy/engine/result.py:215(__init__)>
210	0.142	0.0007	0.142	0.0007	{built-in method __new__ of type object at 0x7f45e236b3c0}
6	0.013	0.0022	0.136	0.0227	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
2	0.006	0.0030	0.13	0.0650	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
2	0.124	0.0620	0.124	0.0620	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
6	0.021	0.0035	0.123	0.0205	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
222	0.123	0.0006	0.123	0.0006	{method 'add' of 'set' objects}
11	0.046	0.0042	0.119	0.0108	<sqlalchemy/orm/interfaces.py:546(setup)>
2	0.012	0.0060	0.115	0.0575	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
6	0.026	0.0043	0.108	0.0180	<sqlalchemy/event/api.py:23(_event_key)>
1	0.003	0.0030	0.1	0.1000	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
1	0.005	0.0050	0.097	0.0970	<sqlalchemy/pool/base.py:354(connect)>
5	0.021	0.0042	0.094	0.0188	<sqlalchemy/util/_collections.py:802(to_list)>
1	0.009	0.0090	0.092	0.0920	<sqlalchemy/pool/base.py:757(_checkout)>
2	0.022	0.0110	0.088	0.0440	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
6	0.029	0.0048	0.088	0.0147	<sqlalchemy/event/attr.py:234(for_modify)>
2	0.02	0.0100	0.087	0.0435	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
29	0.051	0.0018	0.084	0.0029	<sqlalchemy/sql/compiler.py:3541(quote)>
2	0.034	0.0170	0.084	0.0420	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
1	0.013	0.0130	0.082	0.0820	<sqlalchemy/pool/base.py:490(checkout)>
6	0.052	0.0087	0.082	0.0137	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
2	0.047	0.0235	0.08	0.0400	<sqlalchemy/sql/selectable.py:2963(_froms)>
1	0.018	0.0180	0.076	0.0760	<sqlalchemy/engine/base.py:69(__init__)>
6	0.031	0.0052	0.076	0.0127	<sqlalchemy/event/base.py:266(__getattr__)>
2	0.018	0.0090	0.075	0.0375	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
10	0.024	0.0024	0.071	0.0071	<sqlalchemy/inspection.py:38(inspect)>
2	0.009	0.0045	0.065	0.0325	<sqlalchemy/orm/query.py:4045(__new__)>
4	0.017	0.0043	0.061	0.0152	<sqlalchemy/event/base.py:295(__get__)>
2	0.036	0.0180	0.06	0.0300	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
40/38	0.036	0.0009	0.056	0.0015	{setattr}
6	0.008	0.0013	0.056	0.0093	<tg/request_local.py:232(_current_obj)>
20	0.036	0.0018	0.052	0.0026	<sqlalchemy/event/attr.py:264(__iter__)>
6	0.038	0.0063	0.052	0.0087	<sqlalchemy/event/attr.py:330(__init__)>
1	0.005	0.0050	0.052	0.0520	<sqlalchemy/orm/session.py:884(begin)>
5	0.037	0.0074	0.051	0.0102	<abc.py:128(__instancecheck__)>
16	0.038	0.0024	0.051	0.0032	<sqlalchemy/event/base.py:94(__getattr__)>
9	0.018	0.0020	0.05	0.0056	<sqlalchemy/engine/default.py:1049(get_result_processor)>
1	0.005	0.0050	0.05	0.0500	<sqlalchemy/pool/impl.py:112(_do_get)>
2	0.011	0.0055	0.05	0.0250	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
8	0.033	0.0041	0.049	0.0061	<sqlalchemy/event/registry.py:154(__init__)>
1	0.004	0.0040	0.049	0.0490	<sqlalchemy/engine/base.py:596(begin)>
1	0.009	0.0090	0.047	0.0470	<sqlalchemy/orm/session.py:220(__init__)>
2	0.01	0.0050	0.047	0.0235	<sqlalchemy/util/_collections.py:361(__init__)>
4	0.008	0.0020	0.047	0.0118	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
2	0.047	0.0235	0.047	0.0235	<sqlalchemy/engine/result.py:1178(process_rows)>
1	0.005	0.0050	0.047	0.0470	<zope/sqlalchemy/datamanager.py:245(after_begin)>
1	0.006	0.0060	0.045	0.0450	<sqlalchemy/engine/base.py:1737(__init__)>
1	0.012	0.0120	0.045	0.0450	<sqlalchemy/util/queue.py:135(get)>
8/6	0.022	0.0027	0.045	0.0075	<tg/support/objectproxy.py:18(__getattr__)>
6	0.026	0.0043	0.044	0.0073	<sqlalchemy/orm/events.py:1235(_accept_with)>
4	0.009	0.0023	0.044	0.0110	<sqlalchemy/event/base.py:119(_for_instance)>
9	0.031	0.0034	0.043	0.0048	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
2	0.021	0.0105	0.043	0.0215	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
1	0.006	0.0060	0.042	0.0420	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
2	0.008	0.0040	0.041	0.0205	<sqlalchemy/engine/default.py:1032(create_cursor)>
9	0.035	0.0039	0.04	0.0044	<sqlalchemy/orm/strategies.py:173(setup_query)>
13	0.039	0.0030	0.039	0.0030	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
10	0.024	0.0024	0.039	0.0039	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
4	0.016	0.0040	0.039	0.0097	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
9	0.024	0.0027	0.038	0.0042	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
9	0.015	0.0017	0.038	0.0042	<sqlalchemy/sql/compiler.py:3610(format_label)>
6	0.013	0.0022	0.037	0.0062	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
1	0.011	0.0110	0.037	0.0370	<sqlalchemy/engine/base.py:713(_begin_impl)>
28	0.036	0.0013	0.036	0.0013	<weakref.py:362(__getitem__)>
9	0.027	0.0030	0.035	0.0039	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
47	0.035	0.0007	0.035	0.0007	{method 'append' of 'list' objects}
4	0.011	0.0027	0.035	0.0087	<sqlalchemy/event/base.py:116(_for_class)>
1	0.014	0.0140	0.033	0.0330	<sqlalchemy/orm/session.py:337(_take_snapshot)>
2	0.02	0.0100	0.033	0.0165	<sqlalchemy/orm/query.py:4079(setup_entity)>
9	0.022	0.0024	0.032	0.0036	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
3	0.006	0.0020	0.031	0.0103	<sqlalchemy/orm/session.py:2425(flush)>
1	0.012	0.0120	0.031	0.0310	<zope/sqlalchemy/datamanager.py:73(__init__)>
9	0.018	0.0020	0.031	0.0034	<sqlalchemy/engine/result.py:724(_getter)>
6	0.015	0.0025	0.031	0.0052	<sqlalchemy/event/registry.py:169(with_wrapper)>
7	0.03	0.0043	0.03	0.0043	{_warnings.warn}
2	0.005	0.0025	0.029	0.0145	<sqlalchemy/orm/session.py:1574(_autoflush)>
9	0.023	0.0026	0.029	0.0032	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
10	0.019	0.0019	0.028	0.0028	<sqlalchemy/event/attr.py:400(listeners)>
2	0.022	0.0110	0.026	0.0130	<sqlalchemy/orm/query.py:4650(__init__)>
2	0.008	0.0040	0.025	0.0125	<sqlalchemy/pool/base.py:958(cursor)>
3	0.016	0.0053	0.025	0.0083	<sqlalchemy/util/langhelpers.py:1157(_next)>
3	0.01	0.0033	0.025	0.0083	<sqlalchemy/orm/session.py:2471(_is_clean)>
4	0.018	0.0045	0.024	0.0060	<sqlalchemy/event/base.py:77(__init__)>
4	0.007	0.0018	0.024	0.0060	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
2	0.009	0.0045	0.023	0.0115	<sqlalchemy/orm/path_registry.py:63(set)>
2	0.023	0.0115	0.023	0.0115	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
2	0.009	0.0045	0.023	0.0115	<sqlalchemy/orm/query.py:399(_bind_mapper)>
4	0.011	0.0027	0.022	0.0055	<sqlalchemy/event/attr.py:302(__iter__)>
2	0.006	0.0030	0.022	0.0110	<tg/support/objectproxy.py:21(__setattr__)>
9	0.015	0.0017	0.021	0.0023	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
2	0.009	0.0045	0.019	0.0095	<sqlalchemy/engine/result.py:869(_soft_close)>
24	0.019	0.0008	0.019	0.0008	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.012	0.0060	0.019	0.0095	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
15	0.019	0.0013	0.019	0.0013	{method 'update' of 'dict' objects}
2	0.009	0.0045	0.019	0.0095	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
4	0.01	0.0025	0.018	0.0045	<sqlalchemy/orm/base.py:228(manager_of_class)>
22	0.018	0.0008	0.018	0.0008	{iter}
2	0.008	0.0040	0.018	0.0090	<webob/request.py:1399(__setattr__)>
4	0.015	0.0037	0.017	0.0043	<sqlalchemy/sql/base.py:38(_from_objects)>
2	0.011	0.0055	0.017	0.0085	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
2	0.017	0.0085	0.017	0.0085	{method 'cursor' of 'psycopg2.extensions.connection' objects}
4	0.011	0.0027	0.017	0.0043	<logging/__init__.py:1367(isEnabledFor)>
2	0.004	0.0020	0.016	0.0080	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
2	0.012	0.0060	0.016	0.0080	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
2	0.01	0.0050	0.016	0.0080	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
12	0.016	0.0013	0.016	0.0013	{hasattr}
3	0.015	0.0050	0.015	0.0050	<sqlalchemy/orm/identity.py:56(check_modified)>
6	0.011	0.0018	0.015	0.0025	<sqlalchemy/event/registry.py:165(_key)>
4	0.01	0.0025	0.015	0.0037	<string>:8(__new__)
25	0.014	0.0006	0.014	0.0006	{len}
2	0.012	0.0060	0.014	0.0070	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
2	0.003	0.0015	0.014	0.0070	<logging/__init__.py:1152(debug)>
9	0.013	0.0014	0.013	0.0014	<sqlalchemy/engine/result.py:643(_getter)>
1	0.006	0.0060	0.013	0.0130	<weakref.py:115(__setitem__)>
9	0.012	0.0013	0.012	0.0013	<sqlalchemy/sql/compiler.py:410(__init__)>
2	0.006	0.0030	0.012	0.0060	<sqlalchemy/sql/compiler.py:2313(visit_table)>
9	0.012	0.0013	0.012	0.0013	<sqlalchemy/event/attr.py:267(__bool__)>
2	0.007	0.0035	0.012	0.0060	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
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__)>
4	0.007	0.0018	0.01	0.0025	<inspect.py:67(ismethod)>
11	0.01	0.0009	0.01	0.0009	{method 'update' of 'set' objects}
9	0.01	0.0011	0.01	0.0011	<sqlalchemy/sql/elements.py:3939(_get_table)>
6	0.01	0.0017	0.01	0.0017	<_weakrefset.py:70(__contains__)>
1	0.005	0.0050	0.01	0.0100	<transaction/_transaction.py:176(join)>
2	0.007	0.0035	0.01	0.0050	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
9	0.009	0.0010	0.009	0.0010	<sqlalchemy/sql/compiler.py:419(type)>
1	0.005	0.0050	0.009	0.0090	<threading.py:373(notify)>
2	0.007	0.0035	0.009	0.0045	<sqlalchemy/orm/session.py:1417(get_bind)>
4	0.005	0.0012	0.009	0.0023	<inspect.py:142(isfunction)>
2	0.007	0.0035	0.009	0.0045	<sqlalchemy/orm/query.py:4067(__init__)>
8	0.009	0.0011	0.009	0.0011	{method 'startswith' of 'str' objects}
4	0.009	0.0023	0.009	0.0023	{method 'join' of 'str' objects}
1	0.008	0.0080	0.009	0.0090	<sqlalchemy/pool/base.py:589(get_connection)>
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/engine/default.py:945(should_autocommit)>
6	0.008	0.0013	0.008	0.0013	<sqlalchemy/event/attr.py:393(__init__)>
2	0.005	0.0025	0.008	0.0040	<sqlalchemy/orm/query.py:379(_entity_zero)>
4	0.008	0.0020	0.008	0.0020	{method 'get' of 'dictproxy' objects}
9	0.008	0.0009	0.008	0.0009	{method 'get' of 'dict' objects}
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
6	0.008	0.0013	0.008	0.0013	<weakref.py:400(__contains__)>
2	0.008	0.0040	0.008	0.0040	{method 'encode' of 'unicode' objects}
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)>
2	0.005	0.0025	0.007	0.0035	<inspect.py:226(isbuiltin)>
5	0.007	0.0014	0.007	0.0014	{time.time}
1	0.004	0.0040	0.007	0.0070	<sqlalchemy/log.py:56(_should_log_debug)>
2	0.006	0.0030	0.007	0.0035	<sqlalchemy/engine/default.py:941(no_parameters)>
9	0.007	0.0008	0.007	0.0008	<sqlalchemy/sql/elements.py:748(_select_iterable)>
9	0.007	0.0008	0.007	0.0008	<sqlalchemy/sql/elements.py:4204(apply_map)>
1	0.005	0.0050	0.007	0.0070	<threading.py:187(release)>
12	0.007	0.0006	0.007	0.0006	{method 'pop' of 'dict' objects}
11	0.007	0.0006	0.007	0.0006	{method 'intersection' of 'set' objects}
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	<sqlalchemy/util/_collections.py:396(__iter__)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/sql/selectable.py:2124(__init__)>
1	0.003	0.0030	0.006	0.0060	<sqlalchemy/log.py:59(_should_log_info)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
7	0.006	0.0009	0.006	0.0009	{method 'setdefault' of 'dict' objects}
2	0.006	0.0030	0.006	0.0030	<webob/request.py:1406(__getattr__)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/orm/loading.py:880(for_context)>
4	0.006	0.0015	0.006	0.0015	<logging/__init__.py:1353(getEffectiveLevel)>
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)>
2	0.005	0.0025	0.005	0.0025	{sqlalchemy.cutils._distill_params}
4	0.005	0.0012	0.005	0.0012	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
1	0.004	0.0040	0.005	0.0050	<sqlalchemy/util/queue.py:203(_get)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/dialects/postgresql/psycopg2.py:535(_log_notices)>
1	0.004	0.0040	0.005	0.0050	<weakref.py:390(get)>
1	0.004	0.0040	0.005	0.0050	<transaction/_manager.py:245(get)>
4	0.005	0.0012	0.005	0.0012	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
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 'copy' of 'dict' objects}
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.002	0.0020	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/orm/path_registry.py:71(get)>
2	0.002	0.0010	0.004	0.0020	<inspect.py:208(iscode)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
2	0.004	0.0020	0.004	0.0020	{zip}
4	0.004	0.0010	0.004	0.0010	{method 'release' of 'thread.lock' objects}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/dialects/postgresql/base.py:1658(get_select_precolumns)>
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/event/base.py:261(__init__)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/query.py:371(_query_entity_zero)>
1	0.003	0.0030	0.003	0.0030	<threading.py:238(_is_owned)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/engine/result.py:864(_cursor_description)>
4	0.003	0.0008	0.003	0.0008	{method 'values' of 'dict' objects}
2	0.003	0.0015	0.003	0.0015	{method 'pop' of 'list' 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/orm/mapper.py:2132(_with_polymorphic_mappers)>
3	0.002	0.0007	0.002	0.0007	<threading.py:64(_note)>
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/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)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/engine/base.py:1674(__init__)>
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/util/_collections.py:151(union)>
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__)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/default.py:1043(pre_exec)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/query.py:4684(<genexpr>)>
3	0.002	0.0007	0.002	0.0007	{thread.get_ident}
6	0.002	0.0003	0.002	0.0003	{method 'append' of 'collections.deque' objects}
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__)>
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	<transaction/_manager.py:82(get)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/engine/default.py:496(do_begin)>
2	0.001	0.0005	0.001	0.0005	<sqlalchemy/sql/compiler.py:352(__str__)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/orm/session.py:319(_iterate_self_and_parents)>
2	0.001	0.0005	0.001	0.0005	{method 'keys' of 'dict' objects}
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/util/queue.py:191(_empty)>
2	0.001	0.0005	0.001	0.0005	<sqlalchemy/sql/selectable.py:143(selectable)>
1	0.001	0.0010	0.001	0.0010	{method 'popleft' of 'collections.deque' objects}
2	0.0	0.0000	0.0	0.0000	<sqlalchemy/orm/interfaces.py:744(setup_query)>
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.137.177.116'
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 0x7f45d9a81a90>, 'duration': 0.44798851013183594, '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 0x7f45d9a81f10>, 'duration': 0.42891502380371094, '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 0x7f45d9aa5ed0>
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.137.177.116'
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 0x7f45dba02a10>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': '2c123c800abe4ad3873b435b78274158'}
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 0x7f45d9aa5d10>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7f45e1cf46f0>
REMOTE_PORT	'1633'
REQUEST_SCHEME	'https'
paste.cookies	(<SimpleCookie: >, '')
uwsgi.version	'2.0.18'
CONTENT_TYPE	''
tg.locals	<tg.wsgiapp.RequestLocals object at 0x7f45d9b154d0>
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	{}	0.4480 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.4289 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.4480 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.4289 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