Timings

Timing

Action	Time Spent
Render Time	15.7700 ms
Controller Time	148.4139 ms
Total Time	173.7618 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.004	0.0040	148.395	148.3950	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.01	0.0100	148.391	148.3910	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
1	0.01	0.0100	138.868	138.8680	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
2	0.181	0.0905	134.207	67.1035	<sqlalchemy/orm/query.py:3162(all)>
2	0.014	0.0070	125.005	62.5025	<sqlalchemy/orm/query.py:3319(__iter__)>
2	0.018	0.0090	124.352	62.1760	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.011	0.0055	85.324	42.6620	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
2	0.009	0.0045	85.29	42.6450	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
2	0.011	0.0055	85.281	42.6405	<sqlalchemy/orm/session.py:1048(connection)>
2	0.007	0.0035	85.26	42.6300	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
2	0.017	0.0085	85.253	42.6265	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
1	0.009	0.0090	85.121	85.1210	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
1	0.003	0.0030	85.009	85.0090	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
1	0.006	0.0060	85.006	85.0060	<sqlalchemy/pool/base.py:354(connect)>
1	0.008	0.0080	85.0	85.0000	<sqlalchemy/pool/base.py:757(_checkout)>
1	0.017	0.0170	84.99	84.9900	<sqlalchemy/pool/base.py:490(checkout)>
1	0.704	0.7040	84.916	84.9160	<sqlalchemy/pool/base.py:589(get_connection)>
1	0.02	0.0200	51.355	51.3550	<sqlalchemy/pool/base.py:624(__close)>
1	0.008	0.0080	51.332	51.3320	<sqlalchemy/pool/base.py:266(_close_connection)>
1	1.095	1.0950	51.319	51.3190	<sqlalchemy/engine/default.py:505(do_close)>
1	50.224	50.2240	50.224	50.2240	{method 'close' of 'psycopg2.extensions.connection' objects}
2	0.009	0.0045	39.01	19.5050	<sqlalchemy/engine/base.py:922(execute)>
2	0.009	0.0045	38.997	19.4985	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	2.091	1.0455	38.988	19.4940	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
2	0.08	0.0400	33.431	16.7155	<sqlalchemy/engine/base.py:1163(_execute_context)>
1	0.026	0.0260	32.847	32.8470	<sqlalchemy/pool/base.py:631(__connect)>
1	0.009	0.0090	32.726	32.7260	<sqlalchemy/engine/strategies.py:106(connect)>
1	0.009	0.0090	32.717	32.7170	<sqlalchemy/engine/default.py:450(connect)>
1	0.011	0.0110	32.708	32.7080	<psycopg2/__init__.py:82(connect)>
2	0.007	0.0035	32.653	16.3265	<sqlalchemy/engine/default.py:549(do_execute)>
2	32.646	16.3230	32.646	16.3230	{method 'execute' of 'psycopg2.extensions.cursor' objects}
1	32.476	32.4760	32.558	32.5580	{psycopg2._psycopg._connect}
2	0.015	0.0075	14.156	7.0780	<sqlalchemy/orm/scoping.py:161(do)>
3	0.025	0.0083	14.044	4.6813	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.011	0.0055	13.878	6.9390	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.017	0.0170	13.867	13.8670	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.041	0.0410	12.013	12.0130	<sqlalchemy/orm/session.py:646(__init__)>
1	0.008	0.0080	9.513	9.5130	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
203	0.374	0.0018	9.021	0.0444	<sqlalchemy/orm/loading.py:35(instances)>
1	0.084	0.0840	6.593	6.5930	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
6	0.022	0.0037	6.398	1.0663	<sqlalchemy/event/api.py:34(listen)>
6	0.093	0.0155	6.25	1.0417	<sqlalchemy/event/registry.py:193(listen)>
6	0.013	0.0022	5.905	0.9842	<sqlalchemy/event/base.py:243(_listen)>
6	0.025	0.0042	5.892	0.9820	<sqlalchemy/event/registry.py:243(base_listen)>
6	0.027	0.0045	5.661	0.9435	<sqlalchemy/event/attr.py:234(for_modify)>
6	5.595	0.9325	5.613	0.9355	<sqlalchemy/event/attr.py:330(__init__)>
3	0.016	0.0053	5.3	1.7667	<sqlalchemy/util/langhelpers.py:1157(_next)>
3	5.277	1.7590	5.277	1.7590	{next}
201	1.51	0.0075	4.248	0.0211	<sqlalchemy/orm/loading.py:492(_instance)>
2	0.015	0.0075	3.377	1.6885	<string>:1(<lambda>)
2	0.012	0.0060	3.362	1.6810	<sqlalchemy/sql/elements.py:399(compile)>
2	0.013	0.0065	3.35	1.6750	<sqlalchemy/sql/elements.py:464(_compiler)>
2	0.046	0.0230	3.337	1.6685	<sqlalchemy/sql/compiler.py:500(__init__)>
2	0.015	0.0075	3.335	1.6675	<sqlalchemy/engine/result.py:1195(fetchall)>
2	0.018	0.0090	3.28	1.6400	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.009	0.0045	3.262	1.6310	<sqlalchemy/sql/compiler.py:349(process)>
22/2	0.075	0.0034	3.253	1.6265	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
2	0.074	0.0370	3.238	1.6190	<sqlalchemy/sql/compiler.py:2001(visit_select)>
2	2.523	1.2615	2.523	1.2615	<sqlalchemy/engine/result.py:1178(process_rows)>
2	0.025	0.0125	2.387	1.1935	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
2	0.018	0.0090	2.345	1.1725	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
2	0.066	0.0330	2.323	1.1615	<sqlalchemy/sql/selectable.py:2963(_froms)>
11	2.228	0.2025	2.228	0.2025	{method 'intersection' of 'set' objects}
7	1.84	0.2629	1.84	0.2629	{_warnings.warn}
201	0.719	0.0036	1.615	0.0080	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
6	0.473	0.0788	0.906	0.1510	<sqlalchemy/util/_collections.py:755(unique_list)>
2	0.008	0.0040	0.774	0.3870	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
2	0.766	0.3830	0.766	0.3830	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
2	0.049	0.0245	0.619	0.3095	<sqlalchemy/orm/query.py:3828(_compile_context)>
9	0.089	0.0099	0.616	0.0684	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
201	0.556	0.0028	0.556	0.0028	<sqlalchemy/orm/state.py:89(__init__)>
201	0.552	0.0027	0.552	0.0027	<sqlalchemy/orm/loading.py:677(_populate_full)>
9	0.105	0.0117	0.432	0.0480	<sqlalchemy/sql/compiler.py:780(visit_label)>
8	0.045	0.0056	0.41	0.0512	<sqlalchemy/event/attr.py:291(__call__)>
153/143	0.214	0.0014	0.301	0.0021	{getattr}
2	0.027	0.0135	0.281	0.1405	<sqlalchemy/orm/query.py:3953(_simple_statement)>
428	0.279	0.0007	0.279	0.0007	{id}
2	0.009	0.0045	0.26	0.1300	<sqlalchemy/orm/session.py:1540(query)>
2	0.006	0.0030	0.251	0.1255	<sqlalchemy/orm/query.py:141(__init__)>
2	0.023	0.0115	0.245	0.1225	<sqlalchemy/orm/query.py:170(_set_entities)>
2	0.015	0.0075	0.244	0.1220	<string>:1(select)
2	0.026	0.0130	0.229	0.1145	<string>:1(__init__)
201	0.223	0.0011	0.223	0.0011	{method 'issuperset' of 'frozenset' objects}
2	0.043	0.0215	0.221	0.1105	<psycopg2/extensions.py:146(make_dsn)>
201	0.207	0.0010	0.207	0.0010	<string>:1(set)
6	0.013	0.0022	0.201	0.0335	<sqlalchemy/event/attr.py:374(append)>
2	0.012	0.0060	0.194	0.0970	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
201	0.193	0.0010	0.193	0.0010	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
2	0.069	0.0345	0.192	0.0960	<sqlalchemy/sql/selectable.py:2691(__init__)>
2	0.024	0.0120	0.192	0.0960	<sqlalchemy/orm/query.py:4159(row_processor)>
6	0.037	0.0062	0.188	0.0313	<sqlalchemy/event/registry.py:264(append_to_list)>
2	0.013	0.0065	0.187	0.0935	<sqlalchemy/orm/query.py:4194(setup_context)>
2	0.049	0.0245	0.187	0.0935	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
2	0.01	0.0050	0.178	0.0890	<sqlalchemy/engine/result.py:714(__init__)>
9	0.082	0.0091	0.178	0.0198	<sqlalchemy/sql/compiler.py:834(visit_column)>
2	0.037	0.0185	0.17	0.0850	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
2	0.015	0.0075	0.168	0.0840	<sqlalchemy/engine/result.py:740(_init_metadata)>
2	0.077	0.0385	0.165	0.0825	<sqlalchemy/engine/default.py:636(_init_compiled)>
2	0.082	0.0410	0.164	0.0820	<sqlalchemy/orm/loading.py:337(_instance_processor)>
10	0.033	0.0033	0.161	0.0161	<sqlalchemy/util/langhelpers.py:852(__get__)>
116	0.115	0.0010	0.158	0.0014	{isinstance}
222	0.158	0.0007	0.158	0.0007	{method 'add' of 'set' objects}
201	0.155	0.0008	0.155	0.0008	<sqlalchemy/orm/identity.py:163(get)>
2	0.047	0.0235	0.151	0.0755	<sqlalchemy/engine/result.py:215(__init__)>
8	0.024	0.0030	0.15	0.0187	<psycopg2/extensions.py:180(_param_escape)>
6	0.05	0.0083	0.144	0.0240	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
210	0.143	0.0007	0.143	0.0007	{built-in method __new__ of type object at 0x7f914ca583c0}
6	0.014	0.0023	0.131	0.0218	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
6	0.029	0.0048	0.126	0.0210	<sqlalchemy/event/api.py:23(_event_key)>
8	0.073	0.0091	0.117	0.0146	{method 'sub' of '_sre.SRE_Pattern' objects}
6	0.016	0.0027	0.117	0.0195	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
11	0.047	0.0043	0.11	0.0100	<sqlalchemy/orm/interfaces.py:546(setup)>
1	0.022	0.0220	0.103	0.1030	<sqlalchemy/engine/base.py:69(__init__)>
2	0.014	0.0070	0.093	0.0465	<sqlalchemy/orm/query.py:4045(__new__)>
2	0.023	0.0115	0.092	0.0460	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
2	0.032	0.0160	0.091	0.0455	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
5	0.026	0.0052	0.09	0.0180	<sqlalchemy/util/_collections.py:802(to_list)>
4	0.031	0.0077	0.087	0.0217	<sqlalchemy/event/base.py:295(__get__)>
2	0.022	0.0110	0.084	0.0420	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
29	0.054	0.0019	0.082	0.0028	<sqlalchemy/sql/compiler.py:3541(quote)>
2	0.019	0.0095	0.081	0.0405	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
10	0.027	0.0027	0.08	0.0080	<sqlalchemy/inspection.py:38(inspect)>
6	0.032	0.0053	0.08	0.0133	<sqlalchemy/event/base.py:266(__getattr__)>
2	0.029	0.0145	0.075	0.0375	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
1	0.006	0.0060	0.074	0.0740	<sqlalchemy/engine/strategies.py:183(on_connect)>
6	0.041	0.0068	0.071	0.0118	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
6	0.01	0.0017	0.064	0.0107	<tg/request_local.py:232(_current_obj)>
1	0.005	0.0050	0.064	0.0640	<sqlalchemy/dialects/postgresql/psycopg2.py:760(on_connect)>
40/38	0.04	0.0010	0.061	0.0016	{setattr}
6	0.042	0.0070	0.06	0.0100	<sqlalchemy/orm/events.py:1235(_accept_with)>
9	0.023	0.0026	0.058	0.0064	<sqlalchemy/engine/default.py:1049(get_result_processor)>
4	0.01	0.0025	0.056	0.0140	<sqlalchemy/event/base.py:119(_for_instance)>
20	0.038	0.0019	0.054	0.0027	<sqlalchemy/event/attr.py:264(__iter__)>
16	0.038	0.0024	0.054	0.0034	<sqlalchemy/event/base.py:94(__getattr__)>
4	0.008	0.0020	0.053	0.0132	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
1	0.005	0.0050	0.053	0.0530	<sqlalchemy/orm/session.py:884(begin)>
1	0.005	0.0050	0.053	0.0530	<zope/sqlalchemy/datamanager.py:245(after_begin)>
1	0.004	0.0040	0.051	0.0510	<sqlalchemy/engine/base.py:596(begin)>
2	0.024	0.0120	0.05	0.0250	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
8/6	0.024	0.0030	0.05	0.0083	<tg/support/objectproxy.py:18(__getattr__)>
8	0.033	0.0041	0.049	0.0061	<sqlalchemy/event/registry.py:154(__init__)>
2	0.013	0.0065	0.049	0.0245	<sqlalchemy/util/_collections.py:361(__init__)>
1	0.01	0.0100	0.048	0.0480	<sqlalchemy/orm/session.py:220(__init__)>
1	0.007	0.0070	0.048	0.0480	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
1	0.005	0.0050	0.048	0.0480	<sqlalchemy/pool/impl.py:112(_do_get)>
1	0.007	0.0070	0.047	0.0470	<sqlalchemy/engine/base.py:1737(__init__)>
10	0.034	0.0034	0.047	0.0047	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
1	0.004	0.0040	0.047	0.0470	<sqlalchemy/dialects/postgresql/psycopg2.py:713(on_connect)>
4	0.015	0.0037	0.046	0.0115	<sqlalchemy/event/base.py:116(_for_class)>
9	0.032	0.0036	0.045	0.0050	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
4	0.019	0.0047	0.045	0.0112	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
8	0.019	0.0024	0.044	0.0055	<re.py:284(_subx)>
2	0.041	0.0205	0.044	0.0220	<sqlalchemy/orm/query.py:4650(__init__)>
1	0.035	0.0350	0.043	0.0430	<psycopg2/extras.py:667(register_uuid)>
13	0.043	0.0033	0.043	0.0033	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
5	0.024	0.0048	0.043	0.0086	<abc.py:128(__instancecheck__)>
1	0.012	0.0120	0.043	0.0430	<sqlalchemy/util/queue.py:135(get)>
28	0.041	0.0015	0.041	0.0015	<weakref.py:362(__getitem__)>
2	0.02	0.0100	0.041	0.0205	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
2	0.008	0.0040	0.041	0.0205	<sqlalchemy/engine/default.py:1032(create_cursor)>
9	0.026	0.0029	0.04	0.0044	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
9	0.015	0.0017	0.038	0.0042	<sqlalchemy/sql/compiler.py:3610(format_label)>
1	0.014	0.0140	0.038	0.0380	<sqlalchemy/engine/base.py:713(_begin_impl)>
6	0.011	0.0018	0.037	0.0062	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
1	0.014	0.0140	0.037	0.0370	<zope/sqlalchemy/datamanager.py:73(__init__)>
47	0.036	0.0008	0.036	0.0008	{method 'append' of 'list' objects}
2	0.02	0.0100	0.035	0.0175	<sqlalchemy/orm/query.py:4079(setup_entity)>
9	0.023	0.0026	0.035	0.0039	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
7	0.019	0.0027	0.034	0.0049	<logging/__init__.py:1367(isEnabledFor)>
1	0.014	0.0140	0.033	0.0330	<sqlalchemy/orm/session.py:337(_take_snapshot)>
4	0.022	0.0055	0.031	0.0077	<sqlalchemy/event/base.py:77(__init__)>
2	0.018	0.0090	0.03	0.0150	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
10	0.018	0.0018	0.03	0.0030	<sqlalchemy/event/attr.py:400(listeners)>
9	0.016	0.0018	0.03	0.0033	<sqlalchemy/engine/result.py:724(_getter)>
6	0.013	0.0022	0.03	0.0050	<sqlalchemy/event/registry.py:169(with_wrapper)>
4	0.009	0.0023	0.03	0.0075	<logging/__init__.py:1152(debug)>
4	0.016	0.0040	0.029	0.0073	<sqlalchemy/event/attr.py:302(__iter__)>
9	0.022	0.0024	0.029	0.0032	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
9	0.022	0.0024	0.028	0.0031	<sqlalchemy/orm/strategies.py:173(setup_query)>
4	0.023	0.0057	0.025	0.0062	<sqlalchemy/sql/base.py:38(_from_objects)>
8	0.016	0.0020	0.025	0.0031	<re.py:264(_compile_repl)>
2	0.007	0.0035	0.025	0.0125	<sqlalchemy/pool/base.py:958(cursor)>
4	0.006	0.0015	0.024	0.0060	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
25	0.024	0.0010	0.024	0.0010	{len}
2	0.012	0.0060	0.023	0.0115	<sqlalchemy/engine/result.py:869(_soft_close)>
2	0.006	0.0030	0.023	0.0115	<tg/support/objectproxy.py:21(__setattr__)>
2	0.008	0.0040	0.023	0.0115	<sqlalchemy/orm/path_registry.py:63(set)>
2	0.01	0.0050	0.023	0.0115	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
2	0.011	0.0055	0.023	0.0115	<sqlalchemy/orm/query.py:399(_bind_mapper)>
9	0.015	0.0017	0.022	0.0024	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
3	0.008	0.0027	0.021	0.0070	<sqlalchemy/orm/session.py:2425(flush)>
24	0.021	0.0009	0.021	0.0009	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.013	0.0065	0.021	0.0105	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
9	0.017	0.0019	0.021	0.0023	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
4	0.011	0.0027	0.02	0.0050	<sqlalchemy/orm/base.py:228(manager_of_class)>
2	0.006	0.0030	0.02	0.0100	<sqlalchemy/orm/session.py:1574(_autoflush)>
15	0.019	0.0013	0.019	0.0013	{method 'update' of 'dict' objects}
2	0.011	0.0055	0.019	0.0095	<webob/request.py:1399(__setattr__)>
2	0.01	0.0050	0.018	0.0090	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
22	0.018	0.0008	0.018	0.0008	{iter}
2	0.018	0.0090	0.018	0.0090	{method 'cursor' of 'psycopg2.extensions.connection' objects}
6	0.011	0.0018	0.017	0.0028	<sqlalchemy/event/registry.py:165(_key)>
2	0.011	0.0055	0.017	0.0085	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
2	0.011	0.0055	0.017	0.0085	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
17	0.016	0.0009	0.016	0.0009	{method 'get' of 'dict' objects}
2	0.014	0.0070	0.016	0.0080	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
10	0.015	0.0015	0.015	0.0015	<sqlalchemy/event/attr.py:267(__bool__)>
7	0.015	0.0021	0.015	0.0021	<logging/__init__.py:1353(getEffectiveLevel)>
9	0.014	0.0016	0.014	0.0016	<sqlalchemy/sql/compiler.py:410(__init__)>
2	0.014	0.0070	0.014	0.0070	{sqlalchemy.cutils._distill_params}
4	0.009	0.0023	0.014	0.0035	<string>:8(__new__)
9	0.014	0.0016	0.014	0.0016	<sqlalchemy/engine/result.py:643(_getter)>
9	0.014	0.0016	0.014	0.0016	<sqlalchemy/sql/elements.py:3939(_get_table)>
2	0.014	0.0070	0.014	0.0070	{psycopg2._psycopg.parse_dsn}
1	0.006	0.0060	0.013	0.0130	<weakref.py:115(__setitem__)>
12	0.013	0.0011	0.013	0.0011	{hasattr}
3	0.009	0.0030	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.006	0.0030	0.012	0.0060	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
6	0.012	0.0020	0.012	0.0020	<weakref.py:400(__contains__)>
1	0.008	0.0080	0.012	0.0120	<transaction/_transaction.py:176(join)>
6	0.011	0.0018	0.011	0.0018	<tg/support/registry.py:52(_current_obj)>
2	0.009	0.0045	0.011	0.0055	<sqlalchemy/orm/query.py:4067(__init__)>
4	0.011	0.0027	0.011	0.0027	<weakref.py:330(__init__)>
6	0.011	0.0018	0.011	0.0018	{method 'join' of 'str' objects}
2	0.006	0.0030	0.011	0.0055	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
2	0.008	0.0040	0.01	0.0050	<sqlalchemy/orm/session.py:1417(get_bind)>
6	0.01	0.0017	0.01	0.0017	{time.time}
2	0.006	0.0030	0.01	0.0050	<sqlalchemy/sql/compiler.py:2313(visit_table)>
2	0.01	0.0050	0.01	0.0050	<webob/request.py:1406(__getattr__)>
1	0.006	0.0060	0.01	0.0100	<threading.py:147(acquire)>
8	0.01	0.0012	0.01	0.0012	{method 'startswith' of 'str' objects}
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)>
6	0.009	0.0015	0.009	0.0015	<sqlalchemy/event/attr.py:393(__init__)>
4	0.005	0.0012	0.009	0.0023	<inspect.py:67(ismethod)>
8	0.009	0.0011	0.009	0.0011	{method 'search' of '_sre.SRE_Pattern' objects}
4	0.006	0.0015	0.009	0.0023	<inspect.py:142(isfunction)>
4	0.009	0.0023	0.009	0.0023	{method 'get' of 'dictproxy' objects}
13	0.009	0.0007	0.009	0.0007	{method 'pop' of 'dict' objects}
9	0.008	0.0009	0.008	0.0009	<sqlalchemy/sql/compiler.py:419(type)>
4	0.008	0.0020	0.008	0.0020	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
2	0.005	0.0025	0.008	0.0040	<sqlalchemy/orm/query.py:379(_entity_zero)>
7	0.008	0.0011	0.008	0.0011	{method 'items' of 'dict' objects}
11	0.008	0.0007	0.008	0.0007	{method 'update' of 'set' objects}
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
9	0.008	0.0009	0.008	0.0009	<sqlalchemy/sql/elements.py:748(_select_iterable)>
2	0.008	0.0040	0.008	0.0040	<sqlalchemy/orm/query.py:3470(_select_args)>
1	0.005	0.0050	0.007	0.0070	<sqlalchemy/event/base.py:123(_join)>
6	0.007	0.0012	0.007	0.0012	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/util/_collections.py:396(__iter__)>
2	0.007	0.0035	0.007	0.0035	<sqlalchemy/sql/selectable.py:2124(__init__)>
2	0.006	0.0030	0.007	0.0035	<sqlalchemy/orm/loading.py:880(for_context)>
6	0.007	0.0012	0.007	0.0012	<sqlalchemy/event/base.py:112(_listen)>
2	0.007	0.0035	0.007	0.0035	{method 'encode' of 'unicode' objects}
1	0.004	0.0040	0.007	0.0070	<sqlalchemy/dialects/postgresql/psycopg2.py:720(on_connect)>
1	0.002	0.0020	0.007	0.0070	<logging/__init__.py:1164(info)>
1	0.004	0.0040	0.006	0.0060	<threading.py:187(release)>
2	0.005	0.0025	0.006	0.0030	<inspect.py:226(isbuiltin)>
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	{psycopg2._psycopg.register_type}
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/engine/default.py:941(no_parameters)>
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
9	0.006	0.0007	0.006	0.0007	<sqlalchemy/sql/elements.py:4204(apply_map)>
4	0.006	0.0015	0.006	0.0015	{method 'acquire' of 'thread.lock' objects}
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/sql/compiler.py:641(construct_params)>
1	0.004	0.0040	0.005	0.0050	<sqlalchemy/dialects/postgresql/psycopg2.py:728(on_connect)>
1	0.005	0.0050	0.005	0.0050	<sqlalchemy/orm/identity.py:17(__init__)>
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	<transaction/_manager.py:245(get)>
2	0.005	0.0025	0.005	0.0025	{method 'close' of 'psycopg2.extensions.cursor' objects}
2	0.005	0.0025	0.005	0.0025	<psycopg2/extensions.py:164(<dictcomp>)>
6	0.005	0.0008	0.005	0.0008	{method 'copy' of 'dict' objects}
3	0.004	0.0013	0.004	0.0013	<sqlalchemy/orm/identity.py:56(check_modified)>
1	0.003	0.0030	0.004	0.0040	<weakref.py:310(__new__)>
1	0.003	0.0030	0.004	0.0040	<transaction/_transaction.py:50(myhasattr)>
2	0.004	0.0020	0.004	0.0020	{method 'pop' of 'list' objects}
1	0.004	0.0040	0.004	0.0040	<sqlalchemy/event/attr.py:305(__bool__)>
1	0.003	0.0030	0.004	0.0040	<sqlalchemy/util/queue.py:203(_get)>
2	0.004	0.0020	0.004	0.0020	<inspect.py:208(iscode)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
1	0.003	0.0030	0.004	0.0040	<weakref.py:390(get)>
4	0.004	0.0010	0.004	0.0010	{method 'values' of 'dict' 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/dialects/postgresql/psycopg2.py:535(_log_notices)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/orm/session.py:267(_assert_active)>
2	0.004	0.0020	0.004	0.0020	{zip}
8	0.004	0.0005	0.004	0.0005	<sqlalchemy/orm/mapper.py:731(mapper)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/util/_collections.py:730(__init__)>
4	0.004	0.0010	0.004	0.0010	{method 'release' of 'thread.lock' objects}
1	0.003	0.0030	0.003	0.0030	<weakref.py:315(__init__)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/mapper.py:2263(selectable)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/query.py:371(_query_entity_zero)>
7	0.003	0.0004	0.003	0.0004	{method 'setdefault' of 'dict' objects}
1	0.003	0.0030	0.003	0.0030	<threading.py:238(_is_owned)>
1	0.003	0.0030	0.003	0.0030	<sqlalchemy/orm/session.py:319(_iterate_self_and_parents)>
3	0.002	0.0007	0.002	0.0007	<threading.py:64(_note)>
2	0.002	0.0010	0.002	0.0010	{method 'union' of 'set' objects}
2	0.002	0.0010	0.002	0.0010	{delattr}
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/dialects/postgresql/base.py:1658(get_select_precolumns)>
3	0.002	0.0007	0.002	0.0007	{thread.get_ident}
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__)>
6	0.002	0.0003	0.002	0.0003	{method 'append' of 'collections.deque' objects}
1	0.002	0.0020	0.002	0.0020	<psycopg2/extensions.py:103(register_adapter)>
1	0.002	0.0020	0.002	0.0020	{psycopg2._psycopg.new_type}
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/engine/result.py:864(_cursor_description)>
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/sql/compiler.py:625(<genexpr>)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/event/attr.py:255(__call__)>
2	0.002	0.0010	0.002	0.0010	{method 'keys' of 'dict' objects}
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/engine/default.py:1043(pre_exec)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/util/queue.py:191(_empty)>
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)>
1	0.002	0.0020	0.002	0.0020	<weakref.py:368(__setitem__)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/util/langhelpers.py:878(memo)>
1	0.001	0.0010	0.001	0.0010	{method 'clear' of 'dict' objects}
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)>
1	0.001	0.0010	0.001	0.0010	<transaction/_manager.py:82(get)>
1	0.001	0.0010	0.001	0.0010	{psycopg2._psycopg.new_array_type}
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	{method 'popleft' of 'collections.deque' objects}
1	0.001	0.0010	0.001	0.0010	{method 'clear' of 'collections.deque' objects}
1	0.001	0.0010	0.001	0.0010	{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	'Sat, 20 Jul 2024 15:24:40 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	'35.173.48.18'
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 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 0x7f9142411810>, 'duration': 32.14597702026367, '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 0x7f9142411ad0>, 'duration': 0.6110668182373047, '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'}]}
HTTP_IF_MODIFIED_SINCE	'Sat, 20 Jul 2024 15:24:40 GMT'
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	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_CONNECTION	'Keep-Alive'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'35.173.48.18'
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 0x7f9143a8e4d0>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': 'eae4f1a584fd47d29d9996ddff9f157a'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7f914bee1d90>
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 0x7f9142477e10>
repoze.who.api	<repoze.who.api.API object at 0x7f9142477d10>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7f914c3e16f0>
REMOTE_PORT	'33112'
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 0x7f9142558c50>
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	{}	32.1460 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.6111 ms	Results Explain

Query

Params

Time

Actions

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

{}

32.1460 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.6111 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