Timings

Timing

Action	Time Spent
Render Time	3.3438 ms
Controller Time	12.4750 ms
Total Time	24.1220 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.003	0.0030	12.455	12.4550	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.01	0.0100	12.452	12.4520	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
2	0.173	0.0865	10.953	5.4765	<sqlalchemy/orm/query.py:3162(all)>
1	0.005	0.0050	8.774	8.7740	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
203	0.37	0.0018	6.833	0.0337	<sqlalchemy/orm/loading.py:35(instances)>
201	1.441	0.0072	5.205	0.0259	<sqlalchemy/orm/loading.py:492(_instance)>
2	0.013	0.0065	3.947	1.9735	<sqlalchemy/orm/query.py:3319(__iter__)>
1	0.01	0.0100	3.668	3.6680	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
2	0.017	0.0085	3.364	1.6820	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.008	0.0040	2.95	1.4750	<sqlalchemy/engine/base.py:922(execute)>
2	0.007	0.0035	2.94	1.4700	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	0.052	0.0260	2.933	1.4665	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
2	0.076	0.0380	1.77	0.8850	<sqlalchemy/engine/base.py:1163(_execute_context)>
201	0.759	0.0038	1.765	0.0088	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
2	0.015	0.0075	1.474	0.7370	<sqlalchemy/orm/scoping.py:161(do)>
3	0.019	0.0063	1.364	0.4547	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.011	0.0055	1.218	0.6090	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.015	0.0150	1.207	1.2070	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.041	0.0410	1.164	1.1640	<sqlalchemy/orm/session.py:646(__init__)>
201	1.088	0.0054	1.088	0.0054	{method 'issuperset' of 'frozenset' objects}
2	0.009	0.0045	1.049	0.5245	<sqlalchemy/engine/default.py:549(do_execute)>
2	1.04	0.5200	1.04	0.5200	{method 'execute' of 'psycopg2.extensions.cursor' objects}
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.01	0.0050	1.014	0.5070	<sqlalchemy/sql/elements.py:464(_compiler)>
1	0.053	0.0530	1.011	1.0110	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
2	0.035	0.0175	1.004	0.5020	<sqlalchemy/sql/compiler.py:500(__init__)>
2	0.01	0.0050	0.964	0.4820	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.007	0.0035	0.954	0.4770	<sqlalchemy/sql/compiler.py:349(process)>
22/2	0.077	0.0035	0.947	0.4735	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
2	0.055	0.0275	0.936	0.4680	<sqlalchemy/sql/compiler.py:2001(visit_select)>
6	0.452	0.0753	0.879	0.1465	<sqlalchemy/util/_collections.py:755(unique_list)>
6	0.022	0.0037	0.844	0.1407	<sqlalchemy/event/api.py:34(listen)>
6	0.078	0.0130	0.714	0.1190	<sqlalchemy/event/registry.py:193(listen)>
201	0.657	0.0033	0.657	0.0033	<sqlalchemy/orm/state.py:89(__init__)>
9	0.085	0.0094	0.596	0.0662	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
2	0.036	0.0180	0.553	0.2765	<sqlalchemy/orm/query.py:3828(_compile_context)>
201	0.544	0.0027	0.544	0.0027	<sqlalchemy/orm/loading.py:677(_populate_full)>
9	0.088	0.0098	0.417	0.0463	<sqlalchemy/sql/compiler.py:780(visit_label)>
2	0.011	0.0055	0.397	0.1985	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
2	0.008	0.0040	0.363	0.1815	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
6	0.013	0.0022	0.361	0.0602	<sqlalchemy/event/base.py:243(_listen)>
2	0.01	0.0050	0.355	0.1775	<sqlalchemy/orm/session.py:1048(connection)>
6	0.043	0.0072	0.348	0.0580	<sqlalchemy/event/registry.py:243(base_listen)>
2	0.006	0.0030	0.336	0.1680	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
2	0.016	0.0080	0.33	0.1650	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
7	0.038	0.0054	0.316	0.0451	<sqlalchemy/event/attr.py:291(__call__)>
428	0.282	0.0007	0.282	0.0007	{id}
152/142	0.191	0.0013	0.271	0.0019	{getattr}
2	0.028	0.0140	0.247	0.1235	<sqlalchemy/orm/query.py:3953(_simple_statement)>
2	0.008	0.0040	0.24	0.1200	<sqlalchemy/orm/session.py:1540(query)>
2	0.005	0.0025	0.232	0.1160	<sqlalchemy/orm/query.py:141(__init__)>
2	0.041	0.0205	0.227	0.1135	<sqlalchemy/orm/query.py:170(_set_entities)>
2	0.014	0.0070	0.223	0.1115	<sqlalchemy/engine/result.py:1195(fetchall)>
2	0.013	0.0065	0.211	0.1055	<string>:1(select)
201	0.206	0.0010	0.206	0.0010	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
201	0.201	0.0010	0.201	0.0010	<string>:1(set)
2	0.011	0.0055	0.2	0.1000	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
2	0.015	0.0075	0.198	0.0990	<string>:1(__init__)
1	0.009	0.0090	0.198	0.1980	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
6	0.011	0.0018	0.196	0.0327	<sqlalchemy/event/attr.py:374(append)>
2	0.022	0.0110	0.19	0.0950	<sqlalchemy/orm/query.py:4159(row_processor)>
2	0.013	0.0065	0.188	0.0940	<sqlalchemy/orm/query.py:4194(setup_context)>
6	0.024	0.0040	0.185	0.0308	<sqlalchemy/event/registry.py:264(append_to_list)>
2	0.01	0.0050	0.184	0.0920	<sqlalchemy/engine/result.py:714(__init__)>
2	0.053	0.0265	0.174	0.0870	<sqlalchemy/sql/selectable.py:2691(__init__)>
2	0.014	0.0070	0.174	0.0870	<sqlalchemy/engine/result.py:740(_init_metadata)>
116	0.135	0.0012	0.173	0.0015	{isinstance}
2	0.037	0.0185	0.172	0.0860	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
9	0.091	0.0101	0.171	0.0190	<sqlalchemy/sql/compiler.py:834(visit_column)>
2	0.045	0.0225	0.169	0.0845	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
2	0.075	0.0375	0.166	0.0830	<sqlalchemy/orm/loading.py:337(_instance_processor)>
201	0.161	0.0008	0.161	0.0008	<sqlalchemy/orm/identity.py:163(get)>
210	0.157	0.0007	0.157	0.0007	{built-in method __new__ of type object at 0x7fed25fef3c0}
2	0.044	0.0220	0.157	0.0785	<sqlalchemy/engine/result.py:215(__init__)>
10	0.031	0.0031	0.156	0.0156	<sqlalchemy/util/langhelpers.py:852(__get__)>
6	0.052	0.0087	0.153	0.0255	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
2	0.006	0.0030	0.149	0.0745	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
222	0.148	0.0007	0.148	0.0007	{method 'add' of 'set' objects}
6	0.017	0.0028	0.148	0.0247	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
2	0.064	0.0320	0.146	0.0730	<sqlalchemy/engine/default.py:636(_init_compiled)>
2	0.143	0.0715	0.143	0.0715	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
6	0.015	0.0025	0.131	0.0218	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
2	0.021	0.0105	0.128	0.0640	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
11	0.046	0.0042	0.114	0.0104	<sqlalchemy/orm/interfaces.py:546(setup)>
1	0.003	0.0030	0.11	0.1100	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
6	0.028	0.0047	0.108	0.0180	<sqlalchemy/event/api.py:23(_event_key)>
1	0.005	0.0050	0.107	0.1070	<sqlalchemy/pool/base.py:354(connect)>
6	0.027	0.0045	0.104	0.0173	<sqlalchemy/event/attr.py:234(for_modify)>
2	0.022	0.0110	0.102	0.0510	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
1	0.011	0.0110	0.102	0.1020	<sqlalchemy/pool/base.py:757(_checkout)>
2	0.035	0.0175	0.098	0.0490	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
2	0.013	0.0065	0.097	0.0485	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
5	0.022	0.0044	0.095	0.0190	<sqlalchemy/util/_collections.py:802(to_list)>
2	0.02	0.0100	0.09	0.0450	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
1	0.014	0.0140	0.09	0.0900	<sqlalchemy/pool/base.py:490(checkout)>
2	0.02	0.0100	0.082	0.0410	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
29	0.054	0.0019	0.082	0.0028	<sqlalchemy/sql/compiler.py:3541(quote)>
2	0.047	0.0235	0.081	0.0405	<sqlalchemy/sql/selectable.py:2963(_froms)>
6	0.05	0.0083	0.081	0.0135	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
1	0.02	0.0200	0.079	0.0790	<sqlalchemy/engine/base.py:69(__init__)>
6	0.031	0.0052	0.078	0.0130	<sqlalchemy/event/base.py:266(__getattr__)>
10	0.024	0.0024	0.073	0.0073	<sqlalchemy/inspection.py:38(inspect)>
6	0.05	0.0083	0.068	0.0113	<sqlalchemy/event/attr.py:330(__init__)>
4	0.014	0.0035	0.063	0.0158	<sqlalchemy/event/base.py:295(__get__)>
2	0.01	0.0050	0.063	0.0315	<sqlalchemy/orm/query.py:4045(__new__)>
9	0.026	0.0029	0.062	0.0069	<sqlalchemy/engine/default.py:1049(get_result_processor)>
40/38	0.038	0.0009	0.058	0.0015	{setattr}
6	0.01	0.0017	0.057	0.0095	<tg/request_local.py:232(_current_obj)>
20	0.038	0.0019	0.056	0.0028	<sqlalchemy/event/attr.py:264(__iter__)>
1	0.005	0.0050	0.056	0.0560	<zope/sqlalchemy/datamanager.py:245(after_begin)>
1	0.005	0.0050	0.054	0.0540	<sqlalchemy/orm/session.py:884(begin)>
16	0.039	0.0024	0.053	0.0033	<sqlalchemy/event/base.py:94(__getattr__)>
1	0.011	0.0110	0.051	0.0510	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
1	0.005	0.0050	0.051	0.0510	<sqlalchemy/pool/impl.py:112(_do_get)>
1	0.004	0.0040	0.05	0.0500	<sqlalchemy/engine/base.py:596(begin)>
1	0.011	0.0110	0.049	0.0490	<sqlalchemy/orm/session.py:220(__init__)>
8	0.033	0.0041	0.049	0.0061	<sqlalchemy/event/registry.py:154(__init__)>
2	0.024	0.0120	0.049	0.0245	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
4	0.01	0.0025	0.049	0.0123	<sqlalchemy/event/base.py:119(_for_instance)>
4	0.01	0.0025	0.049	0.0123	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
2	0.011	0.0055	0.049	0.0245	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
8/6	0.022	0.0027	0.047	0.0078	<tg/support/objectproxy.py:18(__getattr__)>
1	0.005	0.0050	0.046	0.0460	<sqlalchemy/engine/base.py:1737(__init__)>
9	0.034	0.0038	0.046	0.0051	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
2	0.01	0.0050	0.046	0.0230	<sqlalchemy/util/_collections.py:361(__init__)>
1	0.014	0.0140	0.046	0.0460	<sqlalchemy/util/queue.py:135(get)>
2	0.021	0.0105	0.045	0.0225	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
13	0.044	0.0034	0.044	0.0034	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
6	0.024	0.0040	0.043	0.0072	<sqlalchemy/orm/events.py:1235(_accept_with)>
28	0.042	0.0015	0.042	0.0015	<weakref.py:362(__getitem__)>
2	0.042	0.0210	0.042	0.0210	<sqlalchemy/engine/result.py:1178(process_rows)>
47	0.041	0.0009	0.041	0.0009	{method 'append' of 'list' objects}
9	0.026	0.0029	0.04	0.0044	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
10	0.027	0.0027	0.04	0.0040	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
2	0.01	0.0050	0.04	0.0200	<sqlalchemy/engine/default.py:1032(create_cursor)>
9	0.027	0.0030	0.04	0.0044	<sqlalchemy/engine/result.py:724(_getter)>
4	0.013	0.0032	0.039	0.0097	<sqlalchemy/event/base.py:116(_for_class)>
1	0.013	0.0130	0.039	0.0390	<sqlalchemy/engine/base.py:713(_begin_impl)>
4	0.015	0.0037	0.039	0.0097	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
5	0.02	0.0040	0.038	0.0076	<abc.py:128(__instancecheck__)>
9	0.015	0.0017	0.038	0.0042	<sqlalchemy/sql/compiler.py:3610(format_label)>
9	0.024	0.0027	0.036	0.0040	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
6	0.012	0.0020	0.035	0.0058	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
1	0.014	0.0140	0.035	0.0350	<zope/sqlalchemy/datamanager.py:73(__init__)>
2	0.02	0.0100	0.034	0.0170	<sqlalchemy/orm/query.py:4079(setup_entity)>
1	0.013	0.0130	0.033	0.0330	<sqlalchemy/orm/session.py:337(_take_snapshot)>
6	0.016	0.0027	0.033	0.0055	<sqlalchemy/event/registry.py:169(with_wrapper)>
7	0.03	0.0043	0.03	0.0043	{_warnings.warn}
9	0.022	0.0024	0.03	0.0033	<sqlalchemy/orm/strategies.py:173(setup_query)>
9	0.022	0.0024	0.029	0.0032	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
2	0.026	0.0130	0.029	0.0145	<sqlalchemy/orm/query.py:4650(__init__)>
10	0.017	0.0017	0.027	0.0027	<sqlalchemy/event/attr.py:400(listeners)>
4	0.018	0.0045	0.026	0.0065	<sqlalchemy/event/base.py:77(__init__)>
3	0.015	0.0050	0.024	0.0080	<sqlalchemy/util/langhelpers.py:1157(_next)>
9	0.015	0.0017	0.023	0.0026	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
4	0.012	0.0030	0.023	0.0057	<sqlalchemy/event/attr.py:302(__iter__)>
4	0.006	0.0015	0.023	0.0057	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
15	0.023	0.0015	0.023	0.0015	{method 'update' of 'dict' objects}
2	0.008	0.0040	0.023	0.0115	<sqlalchemy/pool/base.py:958(cursor)>
2	0.01	0.0050	0.023	0.0115	<sqlalchemy/orm/query.py:399(_bind_mapper)>
2	0.005	0.0025	0.022	0.0110	<tg/support/objectproxy.py:21(__setattr__)>
4	0.016	0.0040	0.022	0.0055	<logging/__init__.py:1367(isEnabledFor)>
25	0.021	0.0008	0.021	0.0008	{len}
2	0.007	0.0035	0.021	0.0105	<sqlalchemy/orm/path_registry.py:63(set)>
2	0.012	0.0060	0.021	0.0105	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
2	0.01	0.0050	0.021	0.0105	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
9	0.013	0.0014	0.02	0.0022	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
3	0.006	0.0020	0.019	0.0063	<sqlalchemy/orm/session.py:2425(flush)>
2	0.005	0.0025	0.019	0.0095	<inspect.py:226(isbuiltin)>
22	0.019	0.0009	0.019	0.0009	{iter}
12	0.019	0.0016	0.019	0.0016	{hasattr}
2	0.009	0.0045	0.018	0.0090	<sqlalchemy/engine/result.py:869(_soft_close)>
4	0.011	0.0027	0.018	0.0045	<sqlalchemy/orm/base.py:228(manager_of_class)>
2	0.01	0.0050	0.018	0.0090	<webob/request.py:1399(__setattr__)>
2	0.006	0.0030	0.017	0.0085	<sqlalchemy/orm/session.py:1574(_autoflush)>
2	0.005	0.0025	0.017	0.0085	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
2	0.01	0.0050	0.017	0.0085	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
6	0.012	0.0020	0.016	0.0027	<sqlalchemy/event/registry.py:165(_key)>
4	0.014	0.0035	0.016	0.0040	<sqlalchemy/sql/base.py:38(_from_objects)>
24	0.016	0.0007	0.016	0.0007	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.013	0.0065	0.016	0.0080	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
9	0.015	0.0017	0.015	0.0017	<sqlalchemy/sql/compiler.py:410(__init__)>
4	0.011	0.0027	0.015	0.0037	<string>:8(__new__)
2	0.015	0.0075	0.015	0.0075	{method 'cursor' of 'psycopg2.extensions.connection' objects}
2	0.009	0.0045	0.015	0.0075	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
2	0.011	0.0055	0.014	0.0070	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
2	0.005	0.0025	0.014	0.0070	<logging/__init__.py:1152(debug)>
1	0.003	0.0030	0.013	0.0130	<sqlalchemy/log.py:56(_should_log_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__)>
3	0.008	0.0027	0.013	0.0043	<sqlalchemy/orm/session.py:2471(_is_clean)>
6	0.012	0.0020	0.012	0.0020	<_weakrefset.py:70(__contains__)>
2	0.008	0.0040	0.012	0.0060	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
1	0.006	0.0060	0.012	0.0120	<transaction/_transaction.py:176(join)>
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__)>
12	0.011	0.0009	0.011	0.0009	{method 'pop' of 'dict' objects}
4	0.007	0.0018	0.01	0.0025	<inspect.py:67(ismethod)>
2	0.005	0.0025	0.01	0.0050	<sqlalchemy/sql/compiler.py:2313(visit_table)>
9	0.01	0.0011	0.01	0.0011	<sqlalchemy/event/attr.py:267(__bool__)>
6	0.01	0.0017	0.01	0.0017	<weakref.py:400(__contains__)>
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)>
2	0.006	0.0030	0.009	0.0045	<sqlalchemy/orm/session.py:1417(get_bind)>
4	0.006	0.0015	0.009	0.0023	<inspect.py:142(isfunction)>
2	0.008	0.0040	0.009	0.0045	<sqlalchemy/orm/query.py:4067(__init__)>
11	0.009	0.0008	0.009	0.0008	{method 'update' of 'set' objects}
9	0.009	0.0010	0.009	0.0010	<sqlalchemy/sql/elements.py:3939(_get_table)>
8	0.009	0.0011	0.009	0.0011	{method 'startswith' of 'str' objects}
9	0.009	0.0010	0.009	0.0010	<sqlalchemy/sql/elements.py:748(_select_iterable)>
1	0.007	0.0070	0.009	0.0090	<sqlalchemy/pool/base.py:589(get_connection)>
2	0.005	0.0025	0.009	0.0045	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
9	0.008	0.0009	0.008	0.0009	<sqlalchemy/sql/compiler.py:419(type)>
6	0.008	0.0013	0.008	0.0013	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
6	0.008	0.0013	0.008	0.0013	<tg/support/registry.py:52(_current_obj)>
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)>
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/orm/loading.py:880(for_context)>
4	0.008	0.0020	0.008	0.0020	{method 'join' of 'str' objects}
11	0.008	0.0007	0.008	0.0007	{method 'intersection' of 'set' objects}
1	0.004	0.0040	0.007	0.0070	<sqlalchemy/event/base.py:123(_join)>
1	0.004	0.0040	0.007	0.0070	<sqlalchemy/log.py:59(_should_log_info)>
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.006	0.0030	0.007	0.0035	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
2	0.007	0.0035	0.007	0.0035	{method 'encode' of 'unicode' objects}
8	0.007	0.0009	0.007	0.0009	<sqlalchemy/orm/mapper.py:731(mapper)>
1	0.004	0.0040	0.007	0.0070	<threading.py:187(release)>
2	0.005	0.0025	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__)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/engine/default.py:941(no_parameters)>
2	0.004	0.0020	0.006	0.0030	<inspect.py:208(iscode)>
4	0.006	0.0015	0.006	0.0015	<logging/__init__.py:1353(getEffectiveLevel)>
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)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/orm/query.py:3470(_select_args)>
3	0.005	0.0017	0.005	0.0017	<sqlalchemy/orm/identity.py:56(check_modified)>
4	0.005	0.0012	0.005	0.0012	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
1	0.003	0.0030	0.005	0.0050	<transaction/_transaction.py:50(myhasattr)>
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)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/orm/mapper.py:2132(_with_polymorphic_mappers)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/orm/session.py:267(_assert_active)>
9	0.005	0.0006	0.005	0.0006	<sqlalchemy/sql/elements.py:4204(apply_map)>
6	0.005	0.0008	0.005	0.0008	{method 'append' of 'collections.deque' objects}
6	0.005	0.0008	0.005	0.0008	{method 'copy' of 'dict' objects}
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)>
3	0.004	0.0013	0.004	0.0013	{method 'items' of 'dict' objects}
7	0.004	0.0006	0.004	0.0006	{method 'setdefault' of 'dict' objects}
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/path_registry.py:71(get)>
4	0.004	0.0010	0.004	0.0010	{method 'values' of 'dict' objects}
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/strategies.py:884(create_row_processor)>
4	0.004	0.0010	0.004	0.0010	{method 'release' of 'thread.lock' objects}
3	0.003	0.0010	0.003	0.0010	<threading.py:64(_note)>
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)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
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)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/base.py:370(connection)>
2	0.003	0.0015	0.003	0.0015	{zip}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/util/_collections.py:730(__init__)>
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	<transaction/_manager.py:82(get)>
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/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	{method 'keys' of 'dict' objects}
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>)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/selectable.py:143(selectable)>
3	0.002	0.0007	0.002	0.0007	{thread.get_ident}
1	0.002	0.0020	0.002	0.0020	<weakref.py:368(__setitem__)>
2	0.001	0.0005	0.001	0.0005	<sqlalchemy/orm/interfaces.py:744(setup_query)>
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	<sqlalchemy/sql/compiler.py:352(__str__)>
2	0.001	0.0005	0.001	0.0005	<sqlalchemy/util/_collections.py:151(union)>
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.0	0.0000	0.0	0.0000	<sqlalchemy/engine/default.py:496(do_begin)>
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	''
HTTP_IF_MODIFIED_SINCE	'Tue, 06 Dec 2022 03:28:10 GMT'
REQUEST_METHOD	'GET'
PATH_INFO	'/dealer/find-a-dealer'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
HTTP_USER_AGENT	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_CONNECTION	'Keep-Alive'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'44.200.101.84'
SERVER_PORT	'443'
HTTP_HOST	'jacwud.com'
HTTP_ACCEPT	'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'
HTTP_ACCEPT_LANGUAGE	'en-US,en;q=0.5'
CONTENT_TYPE	''
HTTP_ACCEPT_ENCODING	'br,gzip'

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 0x7fed1f737c10>
webob._parsed_query_vars	(GET([]), '')
beaker.get_session	<bound method SessionApplicationWrapper._get_session of <tg.appwrappers.session.SessionApplicationWrapper object at 0x7fed243a3b90>>
SCRIPT_NAME	''
webob.adhoc_attrs	{'identity': None, 'tgdb_sqla_queries': [{'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7fed1d301c50>, 'duration': 0.5819797515869141, 'engine_id': 140656411636624, '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 0x7fed1d2edd10>, 'duration': 0.5669593811035156, 'engine_id': 140656411636624, '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'}]}
HTTP_IF_MODIFIED_SINCE	'Tue, 06 Dec 2022 03:28:10 GMT'
REQUEST_METHOD	'GET'
PATH_INFO	'/dealer/find-a-dealer'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
repoze.who.plugins	{'cookie': <AuthTktCookiePlugin 140656411289616>, 'form': <FastFormPlugin:/login_handler 140656411345808>, 'main_identifier': <FastFormPlugin:/login_handler 140656411345808>, 'tgappauth': <tg.configuration.auth.metadata._AuthMetadataAuthenticator object at 0x7fed1f74c410>}
CONTENT_LENGTH	''
HTTP_USER_AGENT	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_CONNECTION	'Keep-Alive'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'44.200.101.84'
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 0x7fed1f3c2210>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': '420989cd3a4b479090a3140c744a121f'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7fed25478d90>
REQUEST_URI	'/dealer/find-a-dealer'
HTTP_ACCEPT	'text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8'
wsgi.version	(1, 0)
paste.registry	<tg.support.registry.Registry object at 0x7fed1d319810>
repoze.who.api	<repoze.who.api.API object at 0x7fed1d319190>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7fed259786f0>
REMOTE_PORT	'45840'
HTTP_ACCEPT_LANGUAGE	'en-US,en;q=0.5'
REQUEST_SCHEME	'https'
paste.cookies	(<SimpleCookie: >, '')
uwsgi.version	'2.0.18'
CONTENT_TYPE	''
tg.locals	<tg.wsgiapp.RequestLocals object at 0x7fed1d3484d0>
wsgi.file_wrapper	<built-in function uwsgi_sendfile>
HTTP_ACCEPT_ENCODING	'br,gzip'
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.5820 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.5670 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.5820 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.5670 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