Timings

Timing

Action	Time Spent
Render Time	3.4571 ms
Controller Time	18.9021 ms
Total Time	31.0202 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.003	0.0030	18.883	18.8830	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.011	0.0110	18.88	18.8800	<jacwud_dev/modules/dealer/controller/root.py:36(find_a_dealer)>
2	0.169	0.0845	17.487	8.7435	<sqlalchemy/orm/query.py:3162(all)>
2	0.012	0.0060	10.358	5.1790	<sqlalchemy/orm/query.py:3319(__iter__)>
1	0.008	0.0080	9.891	9.8910	<jacwud_dev/modules/dealer/model/dealer.py:65(get_all)>
2	0.017	0.0085	9.788	4.8940	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
2	0.009	0.0045	9.404	4.7020	<sqlalchemy/engine/base.py:922(execute)>
2	0.007	0.0035	9.393	4.6965	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
2	0.048	0.0240	9.386	4.6930	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
1	0.006	0.0060	8.978	8.9780	<jacwud_dev/modules/dealer/model/dealer.py:203(get_all)>
2	0.07	0.0350	8.192	4.0960	<sqlalchemy/engine/base.py:1163(_execute_context)>
2	0.009	0.0045	7.458	3.7290	<sqlalchemy/engine/default.py:549(do_execute)>
2	7.449	3.7245	7.449	3.7245	{method 'execute' of 'psycopg2.extensions.cursor' objects}
203	0.385	0.0019	6.96	0.0343	<sqlalchemy/orm/loading.py:35(instances)>
201	1.424	0.0071	4.19	0.0208	<sqlalchemy/orm/loading.py:492(_instance)>
201	0.733	0.0036	1.653	0.0082	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
2	0.014	0.0070	1.368	0.6840	<sqlalchemy/orm/scoping.py:161(do)>
2	0.013	0.0065	1.356	0.6780	<sqlalchemy/engine/result.py:1195(fetchall)>
3	0.042	0.0140	1.283	0.4277	<sqlalchemy/util/deprecations.py:117(warned)>
2	0.008	0.0040	1.281	0.6405	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
2	1.273	0.6365	1.273	0.6365	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
2	0.013	0.0065	1.139	0.5695	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.014	0.0140	1.126	1.1260	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.027	0.0270	1.062	1.0620	<sqlalchemy/orm/session.py:646(__init__)>
2	0.008	0.0040	1.054	0.5270	<string>:1(<lambda>)
2	0.009	0.0045	1.046	0.5230	<sqlalchemy/sql/elements.py:399(compile)>
2	0.011	0.0055	1.037	0.5185	<sqlalchemy/sql/elements.py:464(_compiler)>
2	0.029	0.0145	1.026	0.5130	<sqlalchemy/sql/compiler.py:500(__init__)>
2	0.011	0.0055	0.989	0.4945	<sqlalchemy/sql/compiler.py:274(__init__)>
2	0.007	0.0035	0.978	0.4890	<sqlalchemy/sql/compiler.py:349(process)>
22/2	0.068	0.0031	0.971	0.4855	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
2	0.064	0.0320	0.96	0.4800	<sqlalchemy/sql/compiler.py:2001(visit_select)>
1	0.058	0.0580	0.941	0.9410	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
6	0.464	0.0773	0.889	0.1482	<sqlalchemy/util/_collections.py:755(unique_list)>
6	0.021	0.0035	0.786	0.1310	<sqlalchemy/event/api.py:34(listen)>
6	0.079	0.0132	0.649	0.1082	<sqlalchemy/event/registry.py:193(listen)>
9	0.097	0.0108	0.6	0.0667	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
201	0.563	0.0028	0.563	0.0028	<sqlalchemy/orm/loading.py:677(_populate_full)>
2	0.032	0.0160	0.542	0.2710	<sqlalchemy/orm/query.py:3828(_compile_context)>
201	0.487	0.0024	0.487	0.0024	<sqlalchemy/orm/state.py:89(__init__)>
9	0.101	0.0112	0.415	0.0461	<sqlalchemy/sql/compiler.py:780(visit_label)>
2	0.009	0.0045	0.367	0.1835	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
2	0.008	0.0040	0.336	0.1680	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
2	0.009	0.0045	0.328	0.1640	<sqlalchemy/orm/session.py:1048(connection)>
7	0.04	0.0057	0.325	0.0464	<sqlalchemy/event/attr.py:291(__call__)>
6	0.012	0.0020	0.312	0.0520	<sqlalchemy/event/base.py:243(_listen)>
2	0.006	0.0030	0.31	0.1550	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
2	0.013	0.0065	0.304	0.1520	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
6	0.026	0.0043	0.3	0.0500	<sqlalchemy/event/registry.py:243(base_listen)>
201	0.296	0.0015	0.296	0.0015	<string>:1(set)
428	0.293	0.0007	0.293	0.0007	{id}
152/142	0.196	0.0013	0.277	0.0020	{getattr}
2	0.027	0.0135	0.244	0.1220	<sqlalchemy/orm/query.py:3953(_simple_statement)>
2	0.007	0.0035	0.213	0.1065	<sqlalchemy/orm/session.py:1540(query)>
2	0.012	0.0060	0.209	0.1045	<string>:1(select)
2	0.004	0.0020	0.206	0.1030	<sqlalchemy/orm/query.py:141(__init__)>
2	0.023	0.0115	0.202	0.1010	<sqlalchemy/orm/query.py:170(_set_entities)>
2	0.015	0.0075	0.197	0.0985	<string>:1(__init__)
2	0.018	0.0090	0.188	0.0940	<sqlalchemy/orm/query.py:4194(setup_context)>
201	0.187	0.0009	0.187	0.0009	{method 'issuperset' of 'frozenset' objects}
201	0.187	0.0009	0.187	0.0009	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
10	0.057	0.0057	0.185	0.0185	<sqlalchemy/util/langhelpers.py:852(__get__)>
1	0.007	0.0070	0.184	0.1840	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
2	0.011	0.0055	0.183	0.0915	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
6	0.012	0.0020	0.179	0.0298	<sqlalchemy/event/attr.py:374(append)>
2	0.04	0.0200	0.177	0.0885	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
2	0.067	0.0335	0.176	0.0880	<sqlalchemy/engine/default.py:636(_init_compiled)>
201	0.176	0.0009	0.176	0.0009	<sqlalchemy/orm/identity.py:163(get)>
2	0.019	0.0095	0.173	0.0865	<sqlalchemy/orm/query.py:4159(row_processor)>
2	0.048	0.0240	0.172	0.0860	<sqlalchemy/sql/selectable.py:2691(__init__)>
9	0.08	0.0089	0.17	0.0189	<sqlalchemy/sql/compiler.py:834(visit_column)>
2	0.01	0.0050	0.168	0.0840	<sqlalchemy/engine/result.py:714(__init__)>
6	0.023	0.0038	0.167	0.0278	<sqlalchemy/event/registry.py:264(append_to_list)>
2	0.033	0.0165	0.167	0.0835	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
2	0.013	0.0065	0.158	0.0790	<sqlalchemy/engine/result.py:740(_init_metadata)>
2	0.075	0.0375	0.151	0.0755	<sqlalchemy/orm/loading.py:337(_instance_processor)>
116	0.111	0.0010	0.15	0.0013	{isinstance}
210	0.145	0.0007	0.145	0.0007	{built-in method __new__ of type object at 0x7efe748493c0}
2	0.044	0.0220	0.142	0.0710	<sqlalchemy/engine/result.py:215(__init__)>
222	0.138	0.0006	0.138	0.0006	{method 'add' of 'set' objects}
6	0.013	0.0022	0.136	0.0227	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
2	0.021	0.0105	0.135	0.0675	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
6	0.044	0.0073	0.133	0.0222	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
6	0.017	0.0028	0.123	0.0205	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
6	0.023	0.0038	0.116	0.0193	<sqlalchemy/event/api.py:23(_event_key)>
11	0.047	0.0043	0.111	0.0101	<sqlalchemy/orm/interfaces.py:546(setup)>
2	0.012	0.0060	0.103	0.0515	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
1	0.003	0.0030	0.102	0.1020	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
1	0.005	0.0050	0.099	0.0990	<sqlalchemy/pool/base.py:354(connect)>
2	0.02	0.0100	0.097	0.0485	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
1	0.01	0.0100	0.094	0.0940	<sqlalchemy/pool/base.py:757(_checkout)>
2	0.025	0.0125	0.092	0.0460	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
29	0.063	0.0022	0.09	0.0031	<sqlalchemy/sql/compiler.py:3541(quote)>
6	0.025	0.0042	0.089	0.0148	<sqlalchemy/event/attr.py:234(for_modify)>
2	0.029	0.0145	0.085	0.0425	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
1	0.013	0.0130	0.082	0.0820	<sqlalchemy/pool/base.py:490(checkout)>
2	0.046	0.0230	0.081	0.0405	<sqlalchemy/sql/selectable.py:2963(_froms)>
5	0.022	0.0044	0.08	0.0160	<sqlalchemy/util/_collections.py:802(to_list)>
6	0.033	0.0055	0.079	0.0132	<sqlalchemy/event/base.py:266(__getattr__)>
1	0.017	0.0170	0.075	0.0750	<sqlalchemy/engine/base.py:69(__init__)>
2	0.017	0.0085	0.075	0.0375	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
10	0.025	0.0025	0.072	0.0072	<sqlalchemy/inspection.py:38(inspect)>
6	0.009	0.0015	0.071	0.0118	<tg/request_local.py:232(_current_obj)>
6	0.038	0.0063	0.069	0.0115	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
2	0.01	0.0050	0.064	0.0320	<sqlalchemy/orm/query.py:4045(__new__)>
20	0.048	0.0024	0.063	0.0032	<sqlalchemy/event/attr.py:264(__iter__)>
4	0.016	0.0040	0.062	0.0155	<sqlalchemy/event/base.py:295(__get__)>
8	0.032	0.0040	0.057	0.0071	<sqlalchemy/event/registry.py:154(__init__)>
9	0.021	0.0023	0.055	0.0061	<sqlalchemy/engine/default.py:1049(get_result_processor)>
6	0.038	0.0063	0.055	0.0092	<sqlalchemy/event/attr.py:330(__init__)>
40/38	0.032	0.0008	0.053	0.0014	{setattr}
16	0.041	0.0026	0.051	0.0032	<sqlalchemy/event/base.py:94(__getattr__)>
1	0.004	0.0040	0.051	0.0510	<sqlalchemy/orm/session.py:884(begin)>
1	0.005	0.0050	0.051	0.0510	<sqlalchemy/pool/impl.py:112(_do_get)>
1	0.004	0.0040	0.049	0.0490	<sqlalchemy/engine/base.py:596(begin)>
6	0.026	0.0043	0.048	0.0080	<sqlalchemy/orm/events.py:1235(_accept_with)>
2	0.022	0.0110	0.048	0.0240	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
1	0.005	0.0050	0.048	0.0480	<zope/sqlalchemy/datamanager.py:245(after_begin)>
2	0.009	0.0045	0.048	0.0240	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
1	0.009	0.0090	0.047	0.0470	<sqlalchemy/orm/session.py:220(__init__)>
2	0.012	0.0060	0.047	0.0235	<sqlalchemy/util/_collections.py:361(__init__)>
4	0.008	0.0020	0.047	0.0118	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
8/6	0.022	0.0027	0.047	0.0078	<tg/support/objectproxy.py:18(__getattr__)>
4	0.008	0.0020	0.046	0.0115	<sqlalchemy/event/base.py:119(_for_instance)>
2	0.021	0.0105	0.046	0.0230	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
1	0.013	0.0130	0.046	0.0460	<sqlalchemy/util/queue.py:135(get)>
1	0.005	0.0050	0.045	0.0450	<sqlalchemy/engine/base.py:1737(__init__)>
9	0.031	0.0034	0.044	0.0049	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
2	0.044	0.0220	0.044	0.0220	<sqlalchemy/engine/result.py:1178(process_rows)>
1	0.007	0.0070	0.043	0.0430	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
13	0.043	0.0033	0.043	0.0033	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
2	0.01	0.0050	0.043	0.0215	<sqlalchemy/engine/default.py:1032(create_cursor)>
28	0.041	0.0015	0.041	0.0015	<weakref.py:362(__getitem__)>
9	0.024	0.0027	0.039	0.0043	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
5	0.021	0.0042	0.039	0.0078	<abc.py:128(__instancecheck__)>
4	0.016	0.0040	0.039	0.0097	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
10	0.027	0.0027	0.038	0.0038	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
9	0.016	0.0018	0.038	0.0042	<sqlalchemy/sql/compiler.py:3610(format_label)>
4	0.013	0.0032	0.038	0.0095	<sqlalchemy/event/base.py:116(_for_class)>
1	0.013	0.0130	0.038	0.0380	<sqlalchemy/engine/base.py:713(_begin_impl)>
47	0.037	0.0008	0.037	0.0008	{method 'append' of 'list' objects}
2	0.028	0.0140	0.035	0.0175	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
9	0.022	0.0024	0.034	0.0038	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
6	0.012	0.0020	0.033	0.0055	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
1	0.014	0.0140	0.033	0.0330	<sqlalchemy/orm/session.py:337(_take_snapshot)>
2	0.021	0.0105	0.033	0.0165	<sqlalchemy/orm/query.py:4079(setup_entity)>
1	0.013	0.0130	0.031	0.0310	<zope/sqlalchemy/datamanager.py:73(__init__)>
6	0.015	0.0025	0.031	0.0052	<sqlalchemy/event/registry.py:169(with_wrapper)>
9	0.017	0.0019	0.029	0.0032	<sqlalchemy/engine/result.py:724(_getter)>
10	0.017	0.0017	0.028	0.0028	<sqlalchemy/event/attr.py:400(listeners)>
7	0.028	0.0040	0.028	0.0040	{_warnings.warn}
9	0.021	0.0023	0.027	0.0030	<sqlalchemy/orm/strategies.py:173(setup_query)>
2	0.006	0.0030	0.026	0.0130	<sqlalchemy/pool/base.py:958(cursor)>
2	0.023	0.0115	0.026	0.0130	<sqlalchemy/orm/query.py:4650(__init__)>
4	0.018	0.0045	0.025	0.0062	<sqlalchemy/event/base.py:77(__init__)>
4	0.012	0.0030	0.024	0.0060	<sqlalchemy/event/attr.py:302(__iter__)>
9	0.018	0.0020	0.024	0.0027	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
4	0.006	0.0015	0.024	0.0060	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
9	0.015	0.0017	0.024	0.0027	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
2	0.006	0.0030	0.023	0.0115	<tg/support/objectproxy.py:21(__setattr__)>
2	0.009	0.0045	0.023	0.0115	<sqlalchemy/orm/path_registry.py:63(set)>
3	0.015	0.0050	0.023	0.0077	<sqlalchemy/util/langhelpers.py:1157(_next)>
9	0.015	0.0017	0.022	0.0024	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
2	0.009	0.0045	0.022	0.0110	<sqlalchemy/orm/query.py:399(_bind_mapper)>
15	0.021	0.0014	0.021	0.0014	{method 'update' of 'dict' objects}
2	0.02	0.0100	0.02	0.0100	{method 'cursor' of 'psycopg2.extensions.connection' objects}
3	0.006	0.0020	0.019	0.0063	<sqlalchemy/orm/session.py:2425(flush)>
24	0.019	0.0008	0.019	0.0008	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.009	0.0045	0.019	0.0095	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
2	0.009	0.0045	0.018	0.0090	<sqlalchemy/engine/result.py:869(_soft_close)>
25	0.018	0.0007	0.018	0.0007	{len}
2	0.011	0.0055	0.018	0.0090	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
4	0.01	0.0025	0.017	0.0043	<sqlalchemy/orm/base.py:228(manager_of_class)>
22	0.017	0.0008	0.017	0.0008	{iter}
2	0.011	0.0055	0.017	0.0085	<webob/request.py:1399(__setattr__)>
2	0.005	0.0025	0.016	0.0080	<sqlalchemy/orm/session.py:1574(_autoflush)>
4	0.014	0.0035	0.016	0.0040	<sqlalchemy/sql/base.py:38(_from_objects)>
2	0.013	0.0065	0.016	0.0080	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
4	0.008	0.0020	0.016	0.0040	<logging/__init__.py:1367(isEnabledFor)>
12	0.016	0.0013	0.016	0.0013	{hasattr}
2	0.004	0.0020	0.015	0.0075	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
4	0.011	0.0027	0.015	0.0037	<string>:8(__new__)
2	0.01	0.0050	0.015	0.0075	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
6	0.012	0.0020	0.014	0.0023	<sqlalchemy/event/registry.py:165(_key)>
2	0.01	0.0050	0.014	0.0070	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
2	0.006	0.0030	0.014	0.0070	<logging/__init__.py:1152(debug)>
3	0.009	0.0030	0.013	0.0043	<sqlalchemy/orm/session.py:2471(_is_clean)>
9	0.012	0.0013	0.012	0.0013	<sqlalchemy/engine/result.py:643(_getter)>
1	0.005	0.0050	0.012	0.0120	<weakref.py:115(__setitem__)>
9	0.012	0.0013	0.012	0.0013	<sqlalchemy/sql/elements.py:3939(_get_table)>
9	0.012	0.0013	0.012	0.0013	<sqlalchemy/event/attr.py:267(__bool__)>
6	0.012	0.0020	0.012	0.0020	<_weakrefset.py:70(__contains__)>
6	0.011	0.0018	0.011	0.0018	<tg/support/registry.py:52(_current_obj)>
1	0.008	0.0080	0.011	0.0110	<threading.py:147(acquire)>
2	0.005	0.0025	0.011	0.0055	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
9	0.01	0.0011	0.01	0.0011	<sqlalchemy/sql/compiler.py:410(__init__)>
4	0.008	0.0020	0.01	0.0025	<inspect.py:142(isfunction)>
2	0.005	0.0025	0.01	0.0050	<sqlalchemy/sql/compiler.py:2313(visit_table)>
2	0.01	0.0050	0.01	0.0050	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
6	0.01	0.0017	0.01	0.0017	<weakref.py:400(__contains__)>
1	0.006	0.0060	0.01	0.0100	<transaction/_transaction.py:176(join)>
11	0.01	0.0009	0.01	0.0009	{method 'intersection' of 'set' objects}
6	0.009	0.0015	0.009	0.0015	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
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__)>
2	0.007	0.0035	0.009	0.0045	<sqlalchemy/orm/session.py:1417(get_bind)>
11	0.009	0.0008	0.009	0.0008	{method 'update' of 'set' objects}
4	0.009	0.0023	0.009	0.0023	<weakref.py:330(__init__)>
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)>
2	0.006	0.0030	0.009	0.0045	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
9	0.008	0.0009	0.008	0.0009	<sqlalchemy/sql/compiler.py:419(type)>
2	0.008	0.0040	0.008	0.0040	<sqlalchemy/engine/default.py:945(should_autocommit)>
5	0.008	0.0016	0.008	0.0016	{time.time}
4	0.004	0.0010	0.008	0.0020	<inspect.py:67(ismethod)>
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}
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}
1	0.006	0.0060	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)>
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/orm/query.py:379(_entity_zero)>
1	0.003	0.0030	0.007	0.0070	<sqlalchemy/log.py:56(_should_log_debug)>
4	0.007	0.0018	0.007	0.0018	{method 'get' of 'dictproxy' objects}
2	0.007	0.0035	0.007	0.0035	<webob/request.py:1406(__getattr__)>
2	0.006	0.0030	0.007	0.0035	<sqlalchemy/orm/loading.py:880(for_context)>
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
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)>
6	0.007	0.0012	0.007	0.0012	{method 'append' of 'collections.deque' objects}
2	0.006	0.0030	0.006	0.0030	{sqlalchemy.cutils._distill_params}
2	0.004	0.0020	0.006	0.0030	<sqlalchemy/util/_collections.py:396(__iter__)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/sql/selectable.py:2124(__init__)>
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	<inspect.py:208(iscode)>
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
8	0.006	0.0008	0.006	0.0008	<sqlalchemy/orm/mapper.py:731(mapper)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/orm/query.py:3470(_select_args)>
2	0.004	0.0020	0.005	0.0025	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
7	0.005	0.0007	0.005	0.0007	{method 'setdefault' of 'dict' objects}
9	0.005	0.0006	0.005	0.0006	{method 'get' of 'dict' objects}
2	0.004	0.0020	0.005	0.0025	<sqlalchemy/engine/default.py:941(no_parameters)>
1	0.004	0.0040	0.005	0.0050	<weakref.py:390(get)>
6	0.005	0.0008	0.005	0.0008	<sqlalchemy/event/base.py:112(_listen)>
2	0.005	0.0025	0.005	0.0025	{method 'encode' of 'unicode' objects}
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)>
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.004	0.0040	0.004	0.0040	<sqlalchemy/util/queue.py:203(_get)>
1	0.003	0.0030	0.004	0.0040	<transaction/_transaction.py:50(myhasattr)>
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/path_registry.py:71(get)>
1	0.003	0.0030	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)>
3	0.003	0.0010	0.003	0.0010	<threading.py:64(_note)>
1	0.003	0.0030	0.003	0.0030	<weakref.py:315(__init__)>
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)>
4	0.003	0.0008	0.003	0.0008	{method 'values' of 'dict' objects}
2	0.003	0.0015	0.003	0.0015	{method 'pop' of 'list' objects}
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/base.py:370(connection)>
2	0.003	0.0015	0.003	0.0015	{method 'close' of 'psycopg2.extensions.cursor' objects}
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/orm/mapper.py:2132(_with_polymorphic_mappers)>
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	{zip}
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	{next}
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)>
3	0.002	0.0007	0.002	0.0007	{method 'items' of 'dict' objects}
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	<sqlalchemy/engine/base.py:1674(__init__)>
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)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/event/attr.py:255(__call__)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/orm/session.py:319(_iterate_self_and_parents)>
2	0.002	0.0010	0.002	0.0010	{method '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)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/selectable.py:143(selectable)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/util/_collections.py:730(__init__)>
4	0.002	0.0005	0.002	0.0005	{method 'release' of 'thread.lock' 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/event/base.py:261(__init__)>
1	0.001	0.0010	0.001	0.0010	<transaction/_manager.py:82(get)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/engine/default.py:496(do_begin)>
2	0.001	0.0005	0.001	0.0005	<sqlalchemy/engine/default.py:727(<genexpr>)>
2	0.001	0.0005	0.001	0.0005	<sqlalchemy/sql/compiler.py:625(<genexpr>)>
2	0.001	0.0005	0.001	0.0005	<sqlalchemy/orm/query.py:4684(<genexpr>)>
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}
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	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_CONNECTION	'Keep-Alive'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'3.233.219.103'
SERVER_PORT	'443'
HTTP_HOST	'www.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 0x7efe6df90c10>
webob._parsed_query_vars	(GET([]), '')
beaker.get_session	<bound method SessionApplicationWrapper._get_session of <tg.appwrappers.session.SessionApplicationWrapper object at 0x7efe6ea0b2d0>>
SCRIPT_NAME	''
webob.adhoc_attrs	{'identity': None, 'tgdb_sqla_queries': [{'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7efe6c858610>, 'duration': 6.9141387939453125, 'engine_id': 139631231828880, '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 0x7efe6c858a90>, 'duration': 0.637054443359375, 'engine_id': 139631231828880, '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 0x7efe6c6dc8d0>
REQUEST_METHOD	'GET'
PATH_INFO	'/dealer/find-a-dealer'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
repoze.who.plugins	{'cookie': <AuthTktCookiePlugin 139631231481872>, 'form': <FastFormPlugin:/login_handler 139631231538064>, 'main_identifier': <FastFormPlugin:/login_handler 139631231538064>, 'tgappauth': <tg.configuration.auth.metadata._AuthMetadataAuthenticator object at 0x7efe6dfa5410>}
CONTENT_LENGTH	''
HTTP_USER_AGENT	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_CONNECTION	'Keep-Alive'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'3.233.219.103'
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 0x7efe6c68e230>
HTTP_HOST	'www.jacwud.com'
beaker.session	{'_id': 'ca88c9b7477c4b1a9e454897d0e41760'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7efe73cd1d90>
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 0x7efe6c6dc210>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7efe741d26f0>
REMOTE_PORT	'52234'
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 0x7efe6c7eff50>
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	{}	6.9141 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.6371 ms	Results Explain

Query

Params

Time

Actions

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

{}

6.9141 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.6371 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