Timings

Timing

Action	Time Spent
Render Time	8.7109 ms
Controller Time	57.2560 ms
Total Time	75.6099 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.003	0.0030	57.237	57.2370	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.012	0.0120	57.234	57.2340	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
2	0.187	0.0935	55.042	27.5210	<sqlalchemy/orm/query.py:3162(all)>
1	0.008	0.0080	48.811	48.8110	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
2	0.011	0.0055	48.459	24.2295	<sqlalchemy/orm/query.py:3319(__iter__)>
2	0.039	0.0195	47.875	23.9375	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.01	0.0050	47.443	23.7215	<sqlalchemy/engine/base.py:922(execute)>
2	0.005	0.0025	47.431	23.7155	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	1.174	0.5870	47.426	23.7130	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
2	0.075	0.0375	44.993	22.4965	<sqlalchemy/engine/base.py:1163(_execute_context)>
2	0.014	0.0070	41.856	20.9280	<sqlalchemy/engine/default.py:549(do_execute)>
2	41.842	20.9210	41.842	20.9210	{method 'execute' of 'psycopg2.extensions.cursor' objects}
1	0.006	0.0060	8.411	8.4110	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
203	0.379	0.0019	6.396	0.0315	<sqlalchemy/orm/loading.py:35(instances)>
201	1.429	0.0071	4.193	0.0209	<sqlalchemy/orm/loading.py:492(_instance)>
2	0.063	0.0315	2.532	1.2660	<sqlalchemy/engine/default.py:636(_init_compiled)>
2	0.01	0.0050	2.423	1.2115	<sqlalchemy/engine/default.py:1032(create_cursor)>
2	1.324	0.6620	2.404	1.2020	<sqlalchemy/pool/base.py:958(cursor)>
2	0.013	0.0065	2.166	1.0830	<sqlalchemy/orm/scoping.py:161(do)>
3	0.021	0.0070	2.053	0.6843	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.01	0.0050	1.899	0.9495	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.015	0.0150	1.889	1.8890	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.025	0.0250	1.833	1.8330	<sqlalchemy/orm/session.py:646(__init__)>
1	0.063	0.0630	1.709	1.7090	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
6	0.02	0.0033	1.55	0.2583	<sqlalchemy/event/api.py:34(listen)>
201	0.726	0.0036	1.549	0.0077	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
6	0.094	0.0157	1.405	0.2342	<sqlalchemy/event/registry.py:193(listen)>
2	0.013	0.0065	1.16	0.5800	<string>:1(<lambda>)
2	0.01	0.0050	1.147	0.5735	<sqlalchemy/sql/elements.py:399(compile)>
2	0.012	0.0060	1.137	0.5685	<sqlalchemy/sql/elements.py:464(_compiler)>
2	0.043	0.0215	1.125	0.5625	<sqlalchemy/sql/compiler.py:500(__init__)>
2	1.08	0.5400	1.08	0.5400	{method 'cursor' of 'psycopg2.extensions.connection' objects}
2	0.014	0.0070	1.073	0.5365	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.01	0.0050	1.059	0.5295	<sqlalchemy/sql/compiler.py:349(process)>
22/2	0.086	0.0039	1.049	0.5245	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
2	0.064	0.0320	1.035	0.5175	<sqlalchemy/sql/compiler.py:2001(visit_select)>
6	0.012	0.0020	1.023	0.1705	<sqlalchemy/event/base.py:243(_listen)>
6	0.024	0.0040	1.011	0.1685	<sqlalchemy/event/registry.py:243(base_listen)>
6	0.012	0.0020	0.892	0.1487	<sqlalchemy/event/attr.py:374(append)>
6	0.026	0.0043	0.88	0.1467	<sqlalchemy/event/registry.py:264(append_to_list)>
6	0.442	0.0737	0.864	0.1440	<sqlalchemy/util/_collections.py:755(unique_list)>
6	0.753	0.1255	0.846	0.1410	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
2	0.013	0.0065	0.818	0.4090	<sqlalchemy/engine/result.py:1195(fetchall)>
2	0.007	0.0035	0.73	0.3650	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
2	0.723	0.3615	0.723	0.3615	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
201	0.625	0.0031	0.625	0.0031	<sqlalchemy/orm/loading.py:677(_populate_full)>
9	0.095	0.0106	0.594	0.0660	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
2	0.03	0.0150	0.555	0.2775	<sqlalchemy/orm/query.py:3828(_compile_context)>
201	0.472	0.0023	0.472	0.0023	<sqlalchemy/orm/state.py:89(__init__)>
9	0.079	0.0088	0.405	0.0450	<sqlalchemy/sql/compiler.py:780(visit_label)>
2	0.01	0.0050	0.393	0.1965	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
2	0.007	0.0035	0.35	0.1750	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
2	0.01	0.0050	0.343	0.1715	<sqlalchemy/orm/session.py:1048(connection)>
7	0.042	0.0060	0.334	0.0477	<sqlalchemy/event/attr.py:291(__call__)>
2	0.005	0.0025	0.325	0.1625	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
2	0.013	0.0065	0.32	0.1600	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
428	0.296	0.0007	0.296	0.0007	{id}
152/142	0.199	0.0013	0.278	0.0020	{getattr}
2	0.007	0.0035	0.252	0.1260	<sqlalchemy/orm/session.py:1540(query)>
2	0.024	0.0120	0.249	0.1245	<sqlalchemy/orm/query.py:3953(_simple_statement)>
2	0.017	0.0085	0.245	0.1225	<sqlalchemy/orm/query.py:141(__init__)>
201	0.237	0.0012	0.237	0.0012	{method 'issuperset' of 'frozenset' objects}
2	0.021	0.0105	0.228	0.1140	<sqlalchemy/orm/query.py:170(_set_entities)>
2	0.012	0.0060	0.216	0.1080	<string>:1(select)
1	0.01	0.0100	0.205	0.2050	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
2	0.012	0.0060	0.204	0.1020	<string>:1(__init__)
2	0.063	0.0315	0.198	0.0990	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
2	0.03	0.0150	0.196	0.0980	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
2	0.015	0.0075	0.193	0.0965	<sqlalchemy/orm/query.py:4194(setup_context)>
201	0.192	0.0010	0.192	0.0010	<string>:1(set)
2	0.011	0.0055	0.191	0.0955	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
2	0.051	0.0255	0.183	0.0915	<sqlalchemy/sql/selectable.py:2691(__init__)>
116	0.138	0.0012	0.182	0.0016	{isinstance}
201	0.181	0.0009	0.181	0.0009	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
10	0.045	0.0045	0.176	0.0176	<sqlalchemy/util/langhelpers.py:852(__get__)>
2	0.035	0.0175	0.176	0.0880	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
2	0.01	0.0050	0.175	0.0875	<sqlalchemy/engine/result.py:714(__init__)>
2	0.019	0.0095	0.175	0.0875	<sqlalchemy/orm/query.py:4159(row_processor)>
201	0.172	0.0009	0.172	0.0009	<sqlalchemy/orm/identity.py:163(get)>
210	0.169	0.0008	0.169	0.0008	{built-in method __new__ of type object at 0x7f45e236b3c0}
9	0.082	0.0091	0.166	0.0184	<sqlalchemy/sql/compiler.py:834(visit_column)>
2	0.014	0.0070	0.165	0.0825	<sqlalchemy/engine/result.py:740(_init_metadata)>
6	0.012	0.0020	0.154	0.0257	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
2	0.073	0.0365	0.153	0.0765	<sqlalchemy/orm/loading.py:337(_instance_processor)>
2	0.02	0.0100	0.148	0.0740	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
2	0.047	0.0235	0.148	0.0740	<sqlalchemy/engine/result.py:215(__init__)>
6	0.016	0.0027	0.142	0.0237	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
222	0.142	0.0006	0.142	0.0006	{method 'add' of 'set' objects}
6	0.028	0.0047	0.125	0.0208	<sqlalchemy/event/api.py:23(_event_key)>
2	0.071	0.0355	0.123	0.0615	<sqlalchemy/sql/selectable.py:2963(_froms)>
1	0.002	0.0020	0.122	0.1220	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
1	0.004	0.0040	0.12	0.1200	<sqlalchemy/pool/base.py:354(connect)>
1	0.01	0.0100	0.116	0.1160	<sqlalchemy/pool/base.py:757(_checkout)>
2	0.035	0.0175	0.112	0.0560	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
11	0.044	0.0040	0.106	0.0096	<sqlalchemy/orm/interfaces.py:546(setup)>
1	0.025	0.0250	0.105	0.1050	<sqlalchemy/pool/base.py:490(checkout)>
6	0.032	0.0053	0.096	0.0160	<sqlalchemy/event/base.py:266(__getattr__)>
5	0.021	0.0042	0.095	0.0190	<sqlalchemy/util/_collections.py:802(to_list)>
6	0.025	0.0042	0.089	0.0148	<sqlalchemy/event/attr.py:234(for_modify)>
2	0.02	0.0100	0.088	0.0440	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
2	0.033	0.0165	0.088	0.0440	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
2	0.019	0.0095	0.081	0.0405	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
29	0.05	0.0017	0.076	0.0026	<sqlalchemy/sql/compiler.py:3541(quote)>
1	0.017	0.0170	0.073	0.0730	<sqlalchemy/engine/base.py:69(__init__)>
6	0.041	0.0068	0.072	0.0120	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
10	0.023	0.0023	0.069	0.0069	<sqlalchemy/inspection.py:38(inspect)>
2	0.039	0.0195	0.065	0.0325	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
8	0.032	0.0040	0.064	0.0080	<sqlalchemy/event/registry.py:154(__init__)>
2	0.011	0.0055	0.062	0.0310	<sqlalchemy/orm/query.py:4045(__new__)>
1	0.004	0.0040	0.062	0.0620	<sqlalchemy/pool/impl.py:112(_do_get)>
40/38	0.041	0.0010	0.061	0.0016	{setattr}
4	0.015	0.0037	0.061	0.0152	<sqlalchemy/event/base.py:295(__get__)>
6	0.009	0.0015	0.059	0.0098	<tg/request_local.py:232(_current_obj)>
2	0.059	0.0295	0.059	0.0295	<sqlalchemy/engine/result.py:1178(process_rows)>
1	0.014	0.0140	0.058	0.0580	<sqlalchemy/util/queue.py:135(get)>
6	0.041	0.0068	0.055	0.0092	<sqlalchemy/event/attr.py:330(__init__)>
2	0.033	0.0165	0.055	0.0275	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
9	0.019	0.0021	0.054	0.0060	<sqlalchemy/engine/default.py:1049(get_result_processor)>
20	0.036	0.0018	0.051	0.0025	<sqlalchemy/event/attr.py:264(__iter__)>
1	0.005	0.0050	0.051	0.0510	<sqlalchemy/orm/session.py:884(begin)>
16	0.035	0.0022	0.049	0.0031	<sqlalchemy/event/base.py:94(__getattr__)>
2	0.012	0.0060	0.048	0.0240	<sqlalchemy/util/_collections.py:361(__init__)>
1	0.005	0.0050	0.047	0.0470	<sqlalchemy/engine/base.py:596(begin)>
9	0.034	0.0038	0.047	0.0052	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
2	0.008	0.0040	0.047	0.0235	<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.009	0.0090	0.046	0.0460	<sqlalchemy/orm/session.py:220(__init__)>
4	0.01	0.0025	0.046	0.0115	<sqlalchemy/event/base.py:119(_for_instance)>
4	0.008	0.0020	0.046	0.0115	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
2	0.019	0.0095	0.046	0.0230	<sqlalchemy/orm/query.py:4079(setup_entity)>
1	0.004	0.0040	0.045	0.0450	<zope/sqlalchemy/datamanager.py:245(after_begin)>
6	0.026	0.0043	0.044	0.0073	<sqlalchemy/orm/events.py:1235(_accept_with)>
5	0.028	0.0056	0.044	0.0088	<abc.py:128(__instancecheck__)>
28	0.043	0.0015	0.043	0.0015	<weakref.py:362(__getitem__)>
1	0.005	0.0050	0.042	0.0420	<sqlalchemy/engine/base.py:1737(__init__)>
1	0.006	0.0060	0.041	0.0410	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
7	0.041	0.0059	0.041	0.0059	{_warnings.warn}
13	0.04	0.0031	0.04	0.0031	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
6	0.013	0.0022	0.038	0.0063	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
9	0.023	0.0026	0.038	0.0042	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
47	0.038	0.0008	0.038	0.0008	{method 'append' of 'list' objects}
9	0.016	0.0018	0.038	0.0042	<sqlalchemy/sql/compiler.py:3610(format_label)>
4	0.015	0.0037	0.038	0.0095	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
10	0.02	0.0020	0.036	0.0036	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
4	0.014	0.0035	0.036	0.0090	<sqlalchemy/event/base.py:116(_for_class)>
1	0.013	0.0130	0.036	0.0360	<sqlalchemy/engine/base.py:713(_begin_impl)>
2	0.021	0.0105	0.035	0.0175	<sqlalchemy/orm/path_registry.py:63(set)>
9	0.022	0.0024	0.035	0.0039	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
24	0.033	0.0014	0.033	0.0014	<sqlalchemy/event/registry.py:260(_listen_fn)>
1	0.013	0.0130	0.033	0.0330	<sqlalchemy/orm/session.py:337(_take_snapshot)>
2	0.009	0.0045	0.033	0.0165	<sqlalchemy/orm/query.py:399(_bind_mapper)>
6	0.016	0.0027	0.032	0.0053	<sqlalchemy/event/registry.py:169(with_wrapper)>
1	0.012	0.0120	0.03	0.0300	<zope/sqlalchemy/datamanager.py:73(__init__)>
9	0.012	0.0013	0.03	0.0033	<sqlalchemy/engine/result.py:724(_getter)>
3	0.016	0.0053	0.03	0.0100	<sqlalchemy/util/langhelpers.py:1157(_next)>
10	0.02	0.0020	0.028	0.0028	<sqlalchemy/event/attr.py:400(listeners)>
9	0.024	0.0027	0.028	0.0031	<sqlalchemy/orm/strategies.py:173(setup_query)>
2	0.026	0.0130	0.028	0.0140	<sqlalchemy/orm/query.py:4650(__init__)>
9	0.021	0.0023	0.025	0.0028	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
4	0.021	0.0052	0.024	0.0060	<sqlalchemy/sql/base.py:38(_from_objects)>
4	0.007	0.0018	0.024	0.0060	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
9	0.015	0.0017	0.022	0.0024	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
4	0.014	0.0035	0.022	0.0055	<sqlalchemy/event/base.py:77(__init__)>
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__)>
15	0.022	0.0015	0.022	0.0015	{method 'update' of 'dict' objects}
3	0.008	0.0027	0.021	0.0070	<sqlalchemy/orm/session.py:2425(flush)>
2	0.012	0.0060	0.021	0.0105	<webob/request.py:1399(__setattr__)>
9	0.016	0.0018	0.021	0.0023	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
2	0.009	0.0045	0.02	0.0100	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
2	0.017	0.0085	0.019	0.0095	<sqlalchemy/orm/query.py:379(_entity_zero)>
4	0.012	0.0030	0.018	0.0045	<sqlalchemy/orm/base.py:228(manager_of_class)>
2	0.005	0.0025	0.018	0.0090	<sqlalchemy/orm/session.py:1574(_autoflush)>
1	0.017	0.0170	0.018	0.0180	<sqlalchemy/util/queue.py:203(_get)>
9	0.018	0.0020	0.018	0.0020	<sqlalchemy/engine/result.py:643(_getter)>
2	0.012	0.0060	0.018	0.0090	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
2	0.012	0.0060	0.018	0.0090	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
2	0.007	0.0035	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)>
22	0.017	0.0008	0.017	0.0008	{iter}
2	0.017	0.0085	0.017	0.0085	<sqlalchemy/orm/mapper.py:2132(_with_polymorphic_mappers)>
2	0.014	0.0070	0.017	0.0085	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
4	0.01	0.0025	0.017	0.0043	<logging/__init__.py:1367(isEnabledFor)>
2	0.007	0.0035	0.016	0.0080	<sqlalchemy/engine/result.py:869(_soft_close)>
12	0.016	0.0013	0.016	0.0013	{hasattr}
6	0.01	0.0017	0.015	0.0025	<sqlalchemy/event/registry.py:165(_key)>
25	0.015	0.0006	0.015	0.0006	{len}
4	0.01	0.0025	0.015	0.0037	<string>:8(__new__)
11	0.015	0.0014	0.015	0.0014	{method 'intersection' of 'set' objects}
9	0.014	0.0016	0.014	0.0016	<sqlalchemy/sql/compiler.py:410(__init__)>
2	0.012	0.0060	0.014	0.0070	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
11	0.014	0.0013	0.014	0.0013	{method 'update' of 'set' objects}
2	0.005	0.0025	0.014	0.0070	<logging/__init__.py:1152(debug)>
2	0.013	0.0065	0.013	0.0065	{sqlalchemy.cutils._distill_params}
9	0.013	0.0014	0.013	0.0014	<sqlalchemy/event/attr.py:267(__bool__)>
3	0.008	0.0027	0.013	0.0043	<sqlalchemy/orm/session.py:2471(_is_clean)>
1	0.005	0.0050	0.012	0.0120	<weakref.py:115(__setitem__)>
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:393(__init__)>
4	0.006	0.0015	0.01	0.0025	<inspect.py:142(isfunction)>
2	0.005	0.0025	0.01	0.0050	<sqlalchemy/sql/compiler.py:2313(visit_table)>
1	0.007	0.0070	0.01	0.0100	<threading.py:147(acquire)>
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)>
2	0.004	0.0020	0.01	0.0050	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
1	0.005	0.0050	0.01	0.0100	<transaction/_transaction.py:176(join)>
9	0.009	0.0010	0.009	0.0010	<sqlalchemy/sql/compiler.py:419(type)>
6	0.009	0.0015	0.009	0.0015	<tg/support/registry.py:52(_current_obj)>
2	0.007	0.0035	0.009	0.0045	<sqlalchemy/util/_collections.py:396(__iter__)>
1	0.006	0.0060	0.009	0.0090	<threading.py:373(notify)>
5	0.009	0.0018	0.009	0.0018	{time.time}
2	0.008	0.0040	0.009	0.0045	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
4	0.009	0.0023	0.009	0.0023	{method 'join' of 'str' objects}
1	0.007	0.0070	0.009	0.0090	<sqlalchemy/pool/base.py:589(get_connection)>
12	0.009	0.0008	0.009	0.0008	{method 'pop' of 'dict' objects}
2	0.006	0.0030	0.009	0.0045	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
1	0.005	0.0050	0.008	0.0080	<sqlalchemy/event/base.py:123(_join)>
6	0.008	0.0013	0.008	0.0013	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/engine/default.py:945(should_autocommit)>
4	0.005	0.0012	0.008	0.0020	<inspect.py:67(ismethod)>
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/orm/session.py:1417(get_bind)>
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/orm/query.py:4067(__init__)>
8	0.008	0.0010	0.008	0.0010	{method 'startswith' of 'str' objects}
3	0.007	0.0023	0.007	0.0023	{next}
7	0.007	0.0010	0.007	0.0010	{method 'setdefault' of 'dict' objects}
9	0.007	0.0008	0.007	0.0008	{method 'get' of 'dict' objects}
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/engine/default.py:941(no_parameters)>
2	0.007	0.0035	0.007	0.0035	<webob/request.py:1406(__getattr__)>
2	0.006	0.0030	0.007	0.0035	<sqlalchemy/orm/loading.py:880(for_context)>
4	0.007	0.0018	0.007	0.0018	<logging/__init__.py:1353(getEffectiveLevel)>
6	0.007	0.0012	0.007	0.0012	<weakref.py:400(__contains__)>
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)>
9	0.007	0.0008	0.007	0.0008	<sqlalchemy/sql/elements.py:4204(apply_map)>
2	0.007	0.0035	0.007	0.0035	<sqlalchemy/orm/query.py:3470(_select_args)>
2	0.004	0.0020	0.006	0.0030	<inspect.py:226(isbuiltin)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/sql/selectable.py:2124(__init__)>
1	0.002	0.0020	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>)>
1	0.002	0.0020	0.006	0.0060	<sqlalchemy/log.py:56(_should_log_debug)>
4	0.006	0.0015	0.006	0.0015	{method 'get' of 'dictproxy' objects}
9	0.006	0.0007	0.006	0.0007	<sqlalchemy/sql/elements.py:748(_select_iterable)>
6	0.006	0.0010	0.006	0.0010	<sqlalchemy/event/base.py:112(_listen)>
1	0.005	0.0050	0.006	0.0060	<threading.py:187(release)>
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	{method 'acquire' of 'thread.lock' objects}
4	0.005	0.0012	0.005	0.0012	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
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	<inspect.py:208(iscode)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
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)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/sql/compiler.py:641(construct_params)>
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.004	0.0020	0.004	0.0020	{method 'pop' of 'list' objects}
1	0.002	0.0020	0.004	0.0040	<transaction/_manager.py:245(get)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/session.py:267(_assert_active)>
6	0.004	0.0007	0.004	0.0007	{method 'append' of 'collections.deque' objects}
6	0.004	0.0007	0.004	0.0007	{method 'copy' of 'dict' objects}
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/util/_collections.py:730(__init__)>
3	0.003	0.0010	0.003	0.0010	<threading.py:64(_note)>
2	0.003	0.0015	0.003	0.0015	{method 'union' of 'set' objects}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/dialects/postgresql/base.py:1658(get_select_precolumns)>
1	0.003	0.0030	0.003	0.0030	<weakref.py:315(__init__)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/sql/selectable.py:1937(_from_objects)>
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/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 'close' of 'psycopg2.extensions.cursor' objects}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
2	0.003	0.0015	0.003	0.0015	{zip}
4	0.003	0.0008	0.003	0.0008	{method 'release' of 'thread.lock' objects}
2	0.002	0.0010	0.002	0.0010	{delattr}
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/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)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/orm/session.py:306(_is_transaction_boundary)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/query.py:371(_query_entity_zero)>
1	0.002	0.0020	0.002	0.0020	<transaction/_manager.py:82(get)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/default.py:727(<genexpr>)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/compiler.py:352(__str__)>
1	0.002	0.0020	0.002	0.0020	<threading.py:238(_is_owned)>
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>)>
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)>
1	0.002	0.0020	0.002	0.0020	<weakref.py:368(__setitem__)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/engine/base.py:1674(__init__)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/engine/default.py:496(do_begin)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/event/attr.py:255(__call__)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/orm/session.py:319(_iterate_self_and_parents)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/util/queue.py:191(_empty)>
3	0.001	0.0003	0.001	0.0003	<sqlalchemy/engine/base.py:370(connection)>
1	0.001	0.0010	0.001	0.0010	{method 'popleft' of 'collections.deque' objects}
3	0.001	0.0003	0.001	0.0003	{thread.get_ident}
1	0.0	0.0000	0.0	0.0000	{method 'disable' of '_lsprof.Profiler' objects}

Request

GET

Nothing here.

POST

Nothing here.

Cookies

Name	Value
tudorwatch_lang	it
PHPSESSID	4jakno9f1bml2i6b3k4uh2du86
care_did	0df28e37-63e3-46fb-a17d-09cc8eab44b0
cartid	6d6da9fcc220250312042342.8b8d11

Headers

Name	Value
HTTP_COOKIE	'tudorwatch_lang=it; PHPSESSID=4jakno9f1bml2i6b3k4uh2du86; cartid=6d6da9fcc220250312042342.8b8d11; care_did=0df28e37-63e3-46fb-a17d-09cc8eab44b0'
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	'13.58.29.205'
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
HTTP_COOKIE	'tudorwatch_lang=it; PHPSESSID=4jakno9f1bml2i6b3k4uh2du86; cartid=6d6da9fcc220250312042342.8b8d11; care_did=0df28e37-63e3-46fb-a17d-09cc8eab44b0'
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 0x7f45d7a0f6d0>, 'duration': 41.361093521118164, '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 0x7f45d7a0fad0>, 'duration': 0.6020069122314453, '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 0x7f45d79f1d10>
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)'
beaker.cache	<beaker.cache.CacheManager object at 0x7f45dbab3c10>
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'13.58.29.205'
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 0x7f45d8fccdd0>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': '73e3bffdb50c4e7c8b49d371974c8ad6'}
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 0x7f45d7a33550>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7f45e1cf46f0>
REMOTE_PORT	'65091'
REQUEST_SCHEME	'https'
paste.cookies	(<SimpleCookie: PHPSESSID='4jakno9f1bml2i6b3k4uh2du86' care_did='0df28e37-63e3-46fb-a17d-09cc8eab44b0' cartid='6d6da9fcc220250312042342.8b8d11' tudorwatch_lang='it'>, 'tudorwatch_lang=it; PHPSESSID=4jakno9f1bml2i6b3k4uh2du86; cartid=6d6da9fcc220250312042342.8b8d11; care_did=0df28e37-63e3-46fb-a17d-09cc8eab44b0')
uwsgi.version	'2.0.18'
CONTENT_TYPE	''
tg.locals	<tg.wsgiapp.RequestLocals object at 0x7f45d7c4c450>
wsgi.file_wrapper	<built-in function uwsgi_sendfile>
HTTP_ACCEPT_ENCODING	'gzip, br, zstd, deflate'
webob._parsed_cookies	({u'PHPSESSID': u'4jakno9f1bml2i6b3k4uh2du86', u'care_did': u'0df28e37-63e3-46fb-a17d-09cc8eab44b0', u'cartid': u'6d6da9fcc220250312042342.8b8d11', u'tudorwatch_lang': u'it'}, 'tudorwatch_lang=it; PHPSESSID=4jakno9f1bml2i6b3k4uh2du86; cartid=6d6da9fcc220250312042342.8b8d11; care_did=0df28e37-63e3-46fb-a17d-09cc8eab44b0')

SQLAlchemy

Queries Performed

Query	Params	Time	Actions
SELECT state.state_id AS state_state_id, state.state_name AS state_state_name FROM state	{}	41.3611 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.6020 ms	Results Explain

Query

Params

Time

Actions

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

{}

41.3611 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.6020 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.