Timings

Timing

Action	Time Spent
Render Time	3.4130 ms
Controller Time	129.7731 ms
Total Time	141.1870 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.019	0.0190	129.746	129.7460	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.011	0.0110	129.727	129.7270	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
2	0.177	0.0885	124.941	62.4705	<sqlalchemy/orm/query.py:3162(all)>
1	0.01	0.0100	121.831	121.8310	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
2	0.016	0.0080	117.699	58.8495	<sqlalchemy/orm/query.py:3319(__iter__)>
2	0.018	0.0090	117.094	58.5470	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.009	0.0045	116.7	58.3500	<sqlalchemy/engine/base.py:922(execute)>
2	0.009	0.0045	116.689	58.3445	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	0.719	0.3595	116.68	58.3400	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
2	0.096	0.0480	114.841	57.4205	<sqlalchemy/engine/base.py:1163(_execute_context)>
2	0.012	0.0060	112.879	56.4395	<sqlalchemy/engine/default.py:549(do_execute)>
2	112.867	56.4335	112.867	56.4335	{method 'execute' of 'psycopg2.extensions.cursor' objects}
1	0.008	0.0080	7.885	7.8850	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
203	0.415	0.0020	7.065	0.0348	<sqlalchemy/orm/loading.py:35(instances)>
2	0.017	0.0085	4.757	2.3785	<sqlalchemy/orm/scoping.py:161(do)>
3	0.023	0.0077	4.616	1.5387	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.013	0.0065	4.467	2.2335	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.014	0.0140	4.454	4.4540	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.029	0.0290	4.404	4.4040	<sqlalchemy/orm/session.py:646(__init__)>
201	1.482	0.0074	4.35	0.0216	<sqlalchemy/orm/loading.py:492(_instance)>
1	0.058	0.0580	4.272	4.2720	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
6	0.025	0.0042	4.113	0.6855	<sqlalchemy/event/api.py:34(listen)>
6	0.082	0.0137	3.952	0.6587	<sqlalchemy/event/registry.py:193(listen)>
6	0.015	0.0025	3.567	0.5945	<sqlalchemy/event/base.py:243(_listen)>
6	0.028	0.0047	3.552	0.5920	<sqlalchemy/event/registry.py:243(base_listen)>
6	0.012	0.0020	3.427	0.5712	<sqlalchemy/event/attr.py:374(append)>
6	0.027	0.0045	3.415	0.5692	<sqlalchemy/event/registry.py:264(append_to_list)>
6	3.278	0.5463	3.379	0.5632	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
201	0.723	0.0036	1.758	0.0087	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
2	0.015	0.0075	1.252	0.6260	<sqlalchemy/engine/result.py:1195(fetchall)>
2	0.065	0.0325	1.232	0.6160	<sqlalchemy/engine/default.py:636(_init_compiled)>
2	0.008	0.0040	1.101	0.5505	<sqlalchemy/engine/default.py:1032(create_cursor)>
2	1.087	0.5435	1.087	0.5435	<sqlalchemy/engine/result.py:1178(process_rows)>
2	1.061	0.5305	1.084	0.5420	<sqlalchemy/pool/base.py:958(cursor)>
2	0.008	0.0040	1.039	0.5195	<string>:1(<lambda>)
2	0.009	0.0045	1.031	0.5155	<sqlalchemy/sql/elements.py:399(compile)>
2	0.011	0.0055	1.022	0.5110	<sqlalchemy/sql/elements.py:464(_compiler)>
2	0.031	0.0155	1.011	0.5055	<sqlalchemy/sql/compiler.py:500(__init__)>
2	0.013	0.0065	0.972	0.4860	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.008	0.0040	0.959	0.4795	<sqlalchemy/sql/compiler.py:349(process)>
22/2	0.072	0.0033	0.951	0.4755	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
2	0.055	0.0275	0.94	0.4700	<sqlalchemy/sql/compiler.py:2001(visit_select)>
6	0.451	0.0752	0.893	0.1488	<sqlalchemy/util/_collections.py:755(unique_list)>
201	0.688	0.0034	0.688	0.0034	<sqlalchemy/orm/state.py:89(__init__)>
9	0.083	0.0092	0.579	0.0643	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
2	0.036	0.0180	0.57	0.2850	<sqlalchemy/orm/query.py:3828(_compile_context)>
201	0.545	0.0027	0.545	0.0027	<sqlalchemy/orm/loading.py:677(_populate_full)>
9	0.088	0.0098	0.403	0.0448	<sqlalchemy/sql/compiler.py:780(visit_label)>
7	0.044	0.0063	0.388	0.0554	<sqlalchemy/event/attr.py:291(__call__)>
2	0.01	0.0050	0.376	0.1880	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
2	0.009	0.0045	0.342	0.1710	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
2	0.011	0.0055	0.333	0.1665	<sqlalchemy/orm/session.py:1048(connection)>
152/142	0.221	0.0015	0.327	0.0023	{getattr}
2	0.007	0.0035	0.314	0.1570	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
2	0.015	0.0075	0.307	0.1535	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
2	0.007	0.0035	0.271	0.1355	<sqlalchemy/orm/session.py:1540(query)>
428	0.27	0.0006	0.27	0.0006	{id}
2	0.006	0.0030	0.264	0.1320	<sqlalchemy/orm/query.py:141(__init__)>
2	0.022	0.0110	0.258	0.1290	<sqlalchemy/orm/query.py:170(_set_entities)>
2	0.027	0.0135	0.255	0.1275	<sqlalchemy/orm/query.py:3953(_simple_statement)>
2	0.065	0.0325	0.224	0.1120	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
2	0.012	0.0060	0.221	0.1105	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
2	0.016	0.0080	0.219	0.1095	<string>:1(select)
201	0.214	0.0011	0.214	0.0011	<string>:1(set)
201	0.21	0.0010	0.21	0.0010	{method 'issuperset' of 'frozenset' objects}
2	0.01	0.0050	0.204	0.1020	<sqlalchemy/engine/result.py:714(__init__)>
2	0.012	0.0060	0.203	0.1015	<string>:1(__init__)
2	0.028	0.0140	0.194	0.0970	<sqlalchemy/engine/result.py:740(_init_metadata)>
2	0.017	0.0085	0.193	0.0965	<sqlalchemy/orm/query.py:4194(setup_context)>
201	0.193	0.0010	0.193	0.0010	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
2	0.023	0.0115	0.19	0.0950	<sqlalchemy/orm/query.py:4159(row_processor)>
1	0.013	0.0130	0.187	0.1870	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
116	0.138	0.0012	0.179	0.0015	{isinstance}
2	0.056	0.0280	0.179	0.0895	<sqlalchemy/sql/selectable.py:2691(__init__)>
10	0.037	0.0037	0.177	0.0177	<sqlalchemy/util/langhelpers.py:852(__get__)>
6	0.014	0.0023	0.177	0.0295	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
2	0.036	0.0180	0.174	0.0870	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
9	0.088	0.0098	0.168	0.0187	<sqlalchemy/sql/compiler.py:834(visit_column)>
222	0.168	0.0008	0.168	0.0008	{method 'add' of 'set' objects}
2	0.082	0.0410	0.163	0.0815	<sqlalchemy/orm/loading.py:337(_instance_processor)>
6	0.027	0.0045	0.163	0.0272	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
2	0.051	0.0255	0.163	0.0815	<sqlalchemy/engine/result.py:215(__init__)>
201	0.162	0.0008	0.162	0.0008	<sqlalchemy/orm/identity.py:163(get)>
2	0.023	0.0115	0.149	0.0745	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
210	0.142	0.0007	0.142	0.0007	{built-in method __new__ of type object at 0x7f914ca583c0}
6	0.039	0.0065	0.136	0.0227	<sqlalchemy/event/api.py:23(_event_key)>
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}
2	0.012	0.0060	0.115	0.0575	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
11	0.046	0.0042	0.113	0.0103	<sqlalchemy/orm/interfaces.py:546(setup)>
2	0.025	0.0125	0.108	0.0540	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
5	0.02	0.0040	0.108	0.0216	<sqlalchemy/util/_collections.py:802(to_list)>
1	0.004	0.0040	0.101	0.1010	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
2	0.044	0.0220	0.101	0.0505	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
2	0.05	0.0250	0.1	0.0500	<sqlalchemy/sql/selectable.py:2963(_froms)>
6	0.037	0.0062	0.1	0.0167	<sqlalchemy/event/base.py:266(__getattr__)>
1	0.004	0.0040	0.097	0.0970	<sqlalchemy/pool/base.py:354(connect)>
6	0.03	0.0050	0.094	0.0157	<sqlalchemy/event/attr.py:234(for_modify)>
1	0.009	0.0090	0.093	0.0930	<sqlalchemy/pool/base.py:757(_checkout)>
2	0.023	0.0115	0.092	0.0460	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
2	0.019	0.0095	0.086	0.0430	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
1	0.013	0.0130	0.083	0.0830	<sqlalchemy/pool/base.py:490(checkout)>
6	0.046	0.0077	0.081	0.0135	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
29	0.052	0.0018	0.081	0.0028	<sqlalchemy/sql/compiler.py:3541(quote)>
10	0.027	0.0027	0.077	0.0077	<sqlalchemy/inspection.py:38(inspect)>
6	0.008	0.0013	0.075	0.0125	<tg/request_local.py:232(_current_obj)>
2	0.013	0.0065	0.075	0.0375	<sqlalchemy/orm/query.py:4045(__new__)>
1	0.016	0.0160	0.073	0.0730	<sqlalchemy/engine/base.py:69(__init__)>
4	0.015	0.0037	0.064	0.0160	<sqlalchemy/event/base.py:295(__get__)>
8/6	0.036	0.0045	0.063	0.0105	<tg/support/objectproxy.py:18(__getattr__)>
16	0.047	0.0029	0.061	0.0038	<sqlalchemy/event/base.py:94(__getattr__)>
2	0.036	0.0180	0.061	0.0305	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
40/38	0.039	0.0010	0.06	0.0016	{setattr}
6	0.039	0.0065	0.058	0.0097	<sqlalchemy/orm/events.py:1235(_accept_with)>
2	0.013	0.0065	0.058	0.0290	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
20	0.04	0.0020	0.057	0.0028	<sqlalchemy/event/attr.py:264(__iter__)>
6	0.04	0.0067	0.056	0.0093	<sqlalchemy/event/attr.py:330(__init__)>
9	0.021	0.0023	0.055	0.0061	<sqlalchemy/engine/default.py:1049(get_result_processor)>
1	0.005	0.0050	0.055	0.0550	<sqlalchemy/orm/session.py:884(begin)>
2	0.023	0.0115	0.051	0.0255	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
1	0.005	0.0050	0.051	0.0510	<sqlalchemy/pool/impl.py:112(_do_get)>
1	0.01	0.0100	0.05	0.0500	<sqlalchemy/orm/session.py:220(__init__)>
8	0.035	0.0044	0.05	0.0062	<sqlalchemy/event/registry.py:154(__init__)>
2	0.013	0.0065	0.05	0.0250	<sqlalchemy/util/_collections.py:361(__init__)>
4	0.01	0.0025	0.05	0.0125	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
1	0.005	0.0050	0.049	0.0490	<sqlalchemy/engine/base.py:596(begin)>
4	0.011	0.0027	0.049	0.0123	<sqlalchemy/event/base.py:119(_for_instance)>
10	0.023	0.0023	0.048	0.0048	<sqlalchemy/event/attr.py:400(listeners)>
13	0.046	0.0035	0.046	0.0035	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
2	0.033	0.0165	0.046	0.0230	<sqlalchemy/orm/query.py:4079(setup_entity)>
1	0.005	0.0050	0.046	0.0460	<zope/sqlalchemy/datamanager.py:245(after_begin)>
1	0.014	0.0140	0.046	0.0460	<sqlalchemy/util/queue.py:135(get)>
9	0.034	0.0038	0.045	0.0050	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
1	0.006	0.0060	0.044	0.0440	<sqlalchemy/engine/base.py:1737(__init__)>
1	0.006	0.0060	0.041	0.0410	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
5	0.024	0.0048	0.041	0.0082	<abc.py:128(__instancecheck__)>
6	0.013	0.0022	0.04	0.0067	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
4	0.015	0.0037	0.04	0.0100	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
28	0.039	0.0014	0.039	0.0014	<weakref.py:362(__getitem__)>
9	0.015	0.0017	0.039	0.0043	<sqlalchemy/sql/compiler.py:3610(format_label)>
4	0.012	0.0030	0.038	0.0095	<sqlalchemy/event/base.py:116(_for_class)>
9	0.021	0.0023	0.037	0.0041	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
7	0.037	0.0053	0.037	0.0053	{_warnings.warn}
10	0.022	0.0022	0.037	0.0037	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
1	0.012	0.0120	0.036	0.0360	<sqlalchemy/engine/base.py:713(_begin_impl)>
2	0.03	0.0150	0.036	0.0180	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
1	0.015	0.0150	0.035	0.0350	<sqlalchemy/orm/session.py:337(_take_snapshot)>
9	0.023	0.0026	0.034	0.0038	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
6	0.017	0.0028	0.032	0.0053	<sqlalchemy/event/registry.py:169(with_wrapper)>
2	0.028	0.0140	0.031	0.0155	<sqlalchemy/orm/query.py:4650(__init__)>
47	0.03	0.0006	0.03	0.0006	{method 'append' of 'list' objects}
25	0.03	0.0012	0.03	0.0012	{len}
1	0.012	0.0120	0.03	0.0300	<zope/sqlalchemy/datamanager.py:73(__init__)>
9	0.013	0.0014	0.029	0.0032	<sqlalchemy/engine/result.py:724(_getter)>
9	0.023	0.0026	0.028	0.0031	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
2	0.012	0.0060	0.028	0.0140	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
9	0.02	0.0022	0.027	0.0030	<sqlalchemy/orm/strategies.py:173(setup_query)>
4	0.02	0.0050	0.026	0.0065	<sqlalchemy/event/base.py:77(__init__)>
4	0.015	0.0037	0.025	0.0062	<sqlalchemy/event/attr.py:302(__iter__)>
2	0.009	0.0045	0.025	0.0125	<sqlalchemy/orm/path_registry.py:63(set)>
4	0.005	0.0012	0.024	0.0060	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
2	0.011	0.0055	0.024	0.0120	<sqlalchemy/orm/query.py:399(_bind_mapper)>
2	0.006	0.0030	0.023	0.0115	<tg/support/objectproxy.py:21(__setattr__)>
2	0.012	0.0060	0.023	0.0115	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
2	0.023	0.0115	0.023	0.0115	{method 'cursor' of 'psycopg2.extensions.connection' objects}
3	0.015	0.0050	0.023	0.0077	<sqlalchemy/util/langhelpers.py:1157(_next)>
9	0.018	0.0020	0.022	0.0024	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
9	0.013	0.0014	0.022	0.0024	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
3	0.008	0.0027	0.021	0.0070	<sqlalchemy/orm/session.py:2425(flush)>
2	0.014	0.0070	0.021	0.0105	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
2	0.008	0.0040	0.02	0.0100	<sqlalchemy/engine/result.py:869(_soft_close)>
4	0.012	0.0030	0.02	0.0050	<sqlalchemy/orm/base.py:228(manager_of_class)>
2	0.007	0.0035	0.019	0.0095	<sqlalchemy/orm/session.py:1574(_autoflush)>
24	0.019	0.0008	0.019	0.0008	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.011	0.0055	0.019	0.0095	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
15	0.019	0.0013	0.019	0.0013	{method 'update' of 'dict' objects}
4	0.011	0.0027	0.019	0.0047	<logging/__init__.py:1367(isEnabledFor)>
11	0.018	0.0016	0.018	0.0016	{method 'update' of 'set' objects}
22	0.018	0.0008	0.018	0.0008	{iter}
2	0.01	0.0050	0.018	0.0090	<webob/request.py:1399(__setattr__)>
2	0.005	0.0025	0.017	0.0085	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
4	0.015	0.0037	0.017	0.0043	<sqlalchemy/sql/base.py:38(_from_objects)>
12	0.017	0.0014	0.017	0.0014	{hasattr}
9	0.016	0.0018	0.016	0.0018	<sqlalchemy/engine/result.py:643(_getter)>
4	0.012	0.0030	0.016	0.0040	<string>:8(__new__)
2	0.013	0.0065	0.016	0.0080	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
2	0.005	0.0025	0.016	0.0080	<logging/__init__.py:1152(debug)>
11	0.016	0.0015	0.016	0.0015	{method 'intersection' of 'set' objects}
9	0.015	0.0017	0.015	0.0017	<sqlalchemy/sql/compiler.py:410(__init__)>
1	0.009	0.0090	0.015	0.0150	<weakref.py:115(__setitem__)>
6	0.011	0.0018	0.014	0.0023	<sqlalchemy/event/registry.py:165(_key)>
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	<sqlalchemy/event/attr.py:393(__init__)>
9	0.012	0.0013	0.012	0.0013	<sqlalchemy/event/attr.py:267(__bool__)>
2	0.006	0.0030	0.012	0.0060	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
2	0.008	0.0040	0.012	0.0060	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
2	0.007	0.0035	0.011	0.0055	<sqlalchemy/sql/compiler.py:2313(visit_table)>
1	0.007	0.0070	0.011	0.0110	<threading.py:147(acquire)>
8	0.011	0.0014	0.011	0.0014	{method 'startswith' of 'str' objects}
6	0.011	0.0018	0.011	0.0018	<_weakrefset.py:70(__contains__)>
6	0.01	0.0017	0.01	0.0017	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
6	0.01	0.0017	0.01	0.0017	<tg/support/registry.py:52(_current_obj)>
4	0.007	0.0018	0.01	0.0025	<inspect.py:67(ismethod)>
4	0.006	0.0015	0.01	0.0025	<inspect.py:142(isfunction)>
2	0.01	0.0050	0.01	0.0050	<sqlalchemy/orm/query.py:4067(__init__)>
4	0.01	0.0025	0.01	0.0025	<weakref.py:330(__init__)>
9	0.01	0.0011	0.01	0.0011	<sqlalchemy/sql/elements.py:3939(_get_table)>
4	0.01	0.0025	0.01	0.0025	{method 'join' of 'str' objects}
6	0.01	0.0017	0.01	0.0017	<weakref.py:400(__contains__)>
1	0.005	0.0050	0.01	0.0100	<transaction/_transaction.py:176(join)>
2	0.009	0.0045	0.009	0.0045	{sqlalchemy.cutils._distill_params}
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.007	0.0035	0.009	0.0045	<sqlalchemy/orm/query.py:379(_entity_zero)>
2	0.009	0.0045	0.009	0.0045	<webob/request.py:1406(__getattr__)>
2	0.007	0.0035	0.009	0.0045	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
1	0.008	0.0080	0.009	0.0090	<sqlalchemy/pool/base.py:589(get_connection)>
2	0.004	0.0020	0.008	0.0040	<sqlalchemy/orm/session.py:1417(get_bind)>
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}
4	0.008	0.0020	0.008	0.0020	<logging/__init__.py:1353(getEffectiveLevel)>
12	0.008	0.0007	0.008	0.0007	{method 'pop' of 'dict' objects}
9	0.007	0.0008	0.007	0.0008	<sqlalchemy/sql/compiler.py:419(type)>
1	0.005	0.0050	0.007	0.0070	<sqlalchemy/event/base.py:123(_join)>
2	0.005	0.0025	0.007	0.0035	<inspect.py:226(isbuiltin)>
1	0.003	0.0030	0.007	0.0070	<sqlalchemy/log.py:59(_should_log_info)>
5	0.007	0.0014	0.007	0.0014	{time.time}
1	0.003	0.0030	0.007	0.0070	<sqlalchemy/log.py:56(_should_log_debug)>
7	0.007	0.0010	0.007	0.0010	{method 'setdefault' of 'dict' objects}
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/orm/loading.py:880(for_context)>
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.004	0.0040	0.007	0.0070	<threading.py:187(release)>
2	0.007	0.0035	0.007	0.0035	<sqlalchemy/orm/query.py:3470(_select_args)>
2	0.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__)>
4	0.006	0.0015	0.006	0.0015	{method 'acquire' of 'thread.lock' objects}
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
6	0.006	0.0010	0.006	0.0010	<sqlalchemy/event/base.py:112(_listen)>
2	0.006	0.0030	0.006	0.0030	{method 'encode' of 'unicode' objects}
6	0.006	0.0010	0.006	0.0010	{method 'append' of 'collections.deque' objects}
3	0.005	0.0017	0.005	0.0017	<sqlalchemy/orm/identity.py:56(check_modified)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/sql/compiler.py:641(construct_params)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/dialects/postgresql/psycopg2.py:535(_log_notices)>
2	0.003	0.0015	0.005	0.0025	<sqlalchemy/engine/default.py:941(no_parameters)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/orm/path_registry.py:71(get)>
1	0.004	0.0040	0.005	0.0050	<weakref.py:390(get)>
4	0.005	0.0012	0.005	0.0012	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
8	0.005	0.0006	0.005	0.0006	<sqlalchemy/orm/mapper.py:731(mapper)>
6	0.005	0.0008	0.005	0.0008	{method 'copy' of 'dict' objects}
1	0.004	0.0040	0.004	0.0040	<sqlalchemy/orm/identity.py:17(__init__)>
1	0.004	0.0040	0.004	0.0040	<sqlalchemy/util/queue.py:203(_get)>
1	0.002	0.0020	0.004	0.0040	<transaction/_transaction.py:50(myhasattr)>
2	0.002	0.0010	0.004	0.0020	<inspect.py:208(iscode)>
4	0.004	0.0010	0.004	0.0010	{method 'values' of 'dict' objects}
1	0.003	0.0030	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	<sqlalchemy/orm/session.py:267(_assert_active)>
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.002	0.0020	0.003	0.0030	<weakref.py:310(__new__)>
3	0.003	0.0010	0.003	0.0010	{method 'items' of 'dict' objects}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
1	0.002	0.0020	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)>
2	0.003	0.0015	0.003	0.0015	{method 'pop' of 'list' objects}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
3	0.003	0.0010	0.003	0.0010	{thread.get_ident}
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/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)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/event/base.py:261(__init__)>
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	<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:352(__str__)>
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__)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/orm/session.py:319(_iterate_self_and_parents)>
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)>
2	0.002	0.0010	0.002	0.0010	{zip}
4	0.002	0.0005	0.002	0.0005	{method 'release' of 'thread.lock' objects}
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	{method 'keys' of 'dict' objects}
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/util/queue.py:191(_empty)>
1	0.001	0.0010	0.001	0.0010	<weakref.py:368(__setitem__)>
1	0.001	0.0010	0.001	0.0010	{method 'disable' of '_lsprof.Profiler' objects}
2	0.0	0.0000	0.0	0.0000	<sqlalchemy/engine/default.py:1043(pre_exec)>
1	0.0	0.0000	0.0	0.0000	{method 'popleft' of 'collections.deque' 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	'18.223.213.76'
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 0x7f91461a0c10>
webob._parsed_query_vars	(GET([]), '')
beaker.get_session	<bound method SessionApplicationWrapper._get_session of <tg.appwrappers.session.SessionApplicationWrapper object at 0x7f91483c65d0>>
SCRIPT_NAME	''
webob.adhoc_attrs	{'identity': None, 'tgdb_sqla_queries': [{'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f91432f77d0>, 'duration': 112.59984970092773, 'engine_id': 140261923095440, '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 0x7f91432f7c50>, 'duration': 0.45108795166015625, 'engine_id': 140261923095440, '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 0x7f91432f7d10>
REQUEST_METHOD	'GET'
PATH_INFO	'/dealer/find_a_dealer'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
repoze.who.plugins	{'cookie': <AuthTktCookiePlugin 140261922748432>, 'form': <FastFormPlugin:/login_handler 140261922804624>, 'main_identifier': <FastFormPlugin:/login_handler 140261922804624>, 'tgappauth': <tg.configuration.auth.metadata._AuthMetadataAuthenticator object at 0x7f91461b5410>}
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	'18.223.213.76'
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 0x7f91439bf690>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': 'db8949a913894ee393aa497980586f51'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7f914bee1d90>
REQUEST_URI	'/dealer/find_a_dealer'
HTTP_ACCEPT	'/'
wsgi.version	(1, 0)
paste.registry	<tg.support.registry.Registry object at 0x7f91432f78d0>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7f914c3e16f0>
REMOTE_PORT	'38520'
REQUEST_SCHEME	'https'
paste.cookies	(<SimpleCookie: >, '')
uwsgi.version	'2.0.18'
CONTENT_TYPE	''
tg.locals	<tg.wsgiapp.RequestLocals object at 0x7f91433d8b50>
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	{}	112.5998 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.4511 ms	Results Explain

Query

Params

Time

Actions

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

{}

112.5998 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.4511 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