Timings

Timing

Action	Time Spent
Render Time	44.1709 ms
Controller Time	21.4171 ms
Total Time	79.0579 ms

Template

Total Time	Engine	Count	Template	Content Type
44.1709 ms	kajiki	-	jacwud_dev.modules.mediacenter.template.videos	text/html
44.0040 ms	kajiki	1	jacwud_dev.modules.mediacenter.template.videos

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.002	0.0020	21.4	21.4000	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.008	0.0080	21.398	21.3980	<jacwud_dev/modules/mediacenter/controller/root.py:102(videos)>
1	0.025	0.0250	21.39	21.3900	<jacwud_dev/modules/mediacenter/controller/videos.py:55(index)>
3	0.056	0.0187	19.042	6.3473	<sqlalchemy/orm/query.py:3162(all)>
3	0.018	0.0060	16.699	5.5663	<sqlalchemy/orm/query.py:3319(__iter__)>
3	0.022	0.0073	14.238	4.7460	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
1	0.027	0.0270	13.873	13.8730	<jacwud_dev/modules/mediacenter/model/mediacenter.py:529(get_all_active)>
3	0.012	0.0040	13.8	4.6000	<sqlalchemy/engine/base.py:922(execute)>
3	0.011	0.0037	13.783	4.5943	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
3	0.067	0.0223	13.772	4.5907	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
3	0.014	0.0047	7.191	2.3970	<string>:1(<lambda>)
3	0.025	0.0083	7.177	2.3923	<sqlalchemy/sql/elements.py:399(compile)>
3	0.013	0.0043	7.152	2.3840	<sqlalchemy/sql/elements.py:464(_compiler)>
3	0.036	0.0120	7.139	2.3797	<sqlalchemy/sql/compiler.py:500(__init__)>
3	0.016	0.0053	7.094	2.3647	<sqlalchemy/sql/compiler.py:274(__init__)>
5/3	0.027	0.0054	7.078	2.3593	<sqlalchemy/sql/compiler.py:349(process)>
106/3	0.323	0.0030	7.056	2.3520	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
3	0.125	0.0417	7.027	2.3423	<sqlalchemy/sql/compiler.py:2001(visit_select)>
3	0.151	0.0503	6.396	2.1320	<sqlalchemy/engine/base.py:1163(_execute_context)>
48	0.478	0.0100	4.878	0.1016	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
3	0.012	0.0040	4.783	1.5943	<sqlalchemy/engine/default.py:549(do_execute)>
3	4.771	1.5903	4.771	1.5903	{method 'execute' of 'psycopg2.extensions.cursor' objects}
1	0.016	0.0160	3.98	3.9800	<jacwud_dev/modules/mediacenter/model/mediacenter.py:78(get_first_n_sort_desc)>
1	0.014	0.0140	3.474	3.4740	<jacwud_dev/modules/mediacenter/model/mediacenter.py:81(get_first_n_active_sort_desc)>
48	0.437	0.0091	2.591	0.0540	<sqlalchemy/sql/compiler.py:780(visit_label)>
3	0.047	0.0157	2.419	0.8063	<sqlalchemy/orm/query.py:3828(_compile_context)>
17	0.079	0.0046	2.287	0.1345	<sqlalchemy/orm/loading.py:35(instances)>
11	0.047	0.0043	1.941	0.1765	<sqlalchemy/util/deprecations.py:117(warned)>
104/72	0.294	0.0028	1.559	0.0217	<sqlalchemy/util/langhelpers.py:852(__get__)>
4	0.026	0.0065	1.548	0.3870	<sqlalchemy/orm/scoping.py:161(do)>
3	1.068	0.3560	1.513	0.5043	<sqlalchemy/orm/query.py:4159(row_processor)>
50	0.168	0.0034	1.41	0.0282	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
3	0.02	0.0067	1.369	0.4563	<sqlalchemy/orm/query.py:4194(setup_context)>
3	0.13	0.0433	1.346	0.4487	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
32	0.166	0.0052	1.259	0.0393	<sqlalchemy/sql/type_api.py:505(_dialect_info)>
4	0.012	0.0030	1.165	0.2913	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.019	0.0190	1.153	1.1530	<sqlalchemy/orm/session.py:3196(__call__)>
52	0.183	0.0035	1.132	0.0218	<sqlalchemy/orm/interfaces.py:546(setup)>
1	0.028	0.0280	1.107	1.1070	<sqlalchemy/orm/session.py:646(__init__)>
3	0.062	0.0207	1.082	0.3607	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
1	0.062	0.0620	0.977	0.9770	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
155	0.271	0.0017	0.974	0.0063	<sqlalchemy/sql/compiler.py:3541(quote)>
52	0.437	0.0084	0.908	0.0175	<sqlalchemy/sql/compiler.py:834(visit_column)>
3	0.036	0.0120	0.882	0.2940	<sqlalchemy/orm/query.py:3953(_simple_statement)>
3	0.034	0.0113	0.834	0.2780	<string>:1(select)
48	0.12	0.0025	0.829	0.0173	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
6	0.019	0.0032	0.821	0.1368	<sqlalchemy/event/api.py:34(listen)>
16	0.049	0.0031	0.818	0.0511	<sqlalchemy/sql/type_api.py:524(adapt)>
56	0.152	0.0027	0.804	0.0144	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
3	0.018	0.0060	0.8	0.2667	<string>:1(__init__)
3	0.015	0.0050	0.782	0.2607	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
16	0.103	0.0064	0.769	0.0481	<sqlalchemy/util/langhelpers.py:1136(constructor_copy)>
3	0.165	0.0550	0.767	0.2557	<sqlalchemy/sql/selectable.py:2691(__init__)>
3	0.012	0.0040	0.76	0.2533	<sqlalchemy/engine/result.py:714(__init__)>
3	0.022	0.0073	0.748	0.2493	<sqlalchemy/engine/result.py:740(_init_metadata)>
48	0.08	0.0017	0.732	0.0152	<sqlalchemy/sql/compiler.py:3610(format_label)>
3	0.124	0.0413	0.723	0.2410	<sqlalchemy/engine/result.py:215(__init__)>
78/60	0.36	0.0046	0.699	0.0116	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
6	0.084	0.0140	0.678	0.1130	<sqlalchemy/event/registry.py:193(listen)>
18	0.037	0.0021	0.652	0.0362	<sqlalchemy/orm/path_registry.py:302(__missing__)>
443/428	0.522	0.0012	0.619	0.0014	{getattr}
18	0.157	0.0087	0.615	0.0342	<sqlalchemy/orm/path_registry.py:205(__init__)>
3	0.114	0.0380	0.56	0.1867	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
17	0.127	0.0075	0.559	0.0329	<sqlalchemy/sql/compiler.py:3489(_requires_quotes)>
16	0.056	0.0035	0.544	0.0340	<sqlalchemy/sql/elements.py:3970(_label)>
544	0.472	0.0009	0.534	0.0010	{isinstance}
16	0.122	0.0076	0.488	0.0305	<sqlalchemy/sql/elements.py:3978(_gen_label)>
3	0.058	0.0193	0.47	0.1567	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
3	0.028	0.0093	0.449	0.1497	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
14	0.165	0.0118	0.445	0.0318	<sqlalchemy/orm/loading.py:492(_instance)>
48	0.12	0.0025	0.444	0.0092	<sqlalchemy/engine/default.py:1049(get_result_processor)>
2	0.018	0.0090	0.443	0.2215	<sqlalchemy/orm/query.py:1769(filter_by)>
3	0.19	0.0633	0.442	0.1473	<sqlalchemy/orm/loading.py:337(_instance_processor)>
11	0.063	0.0057	0.439	0.0399	<sqlalchemy/event/attr.py:291(__call__)>
43/16	0.266	0.0062	0.42	0.0262	<sqlalchemy/util/langhelpers.py:273(get_cls_kwargs)>
3	0.013	0.0043	0.416	0.1387	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
3	0.02	0.0067	0.406	0.1353	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
3	0.139	0.0463	0.383	0.1277	<sqlalchemy/sql/selectable.py:2963(_froms)>
3	0.012	0.0040	0.372	0.1240	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
3	0.013	0.0043	0.36	0.1200	<sqlalchemy/orm/session.py:1048(connection)>
10/6	0.06	0.0060	0.349	0.0582	<sqlalchemy/sql/visitors.py:97(_compiler_dispatch)>
3	0.01	0.0033	0.347	0.1157	<sqlalchemy/orm/session.py:1540(query)>
3	0.008	0.0027	0.337	0.1123	<sqlalchemy/orm/query.py:141(__init__)>
3	0.008	0.0027	0.335	0.1117	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
6	0.011	0.0018	0.332	0.0553	<sqlalchemy/event/base.py:243(_listen)>
3	0.026	0.0087	0.329	0.1097	<sqlalchemy/orm/query.py:170(_set_entities)>
3	0.018	0.0060	0.327	0.1090	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
48	0.163	0.0034	0.324	0.0067	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
6	0.026	0.0043	0.321	0.0535	<sqlalchemy/event/registry.py:243(base_listen)>
8/2	0.023	0.0029	0.31	0.1550	<sqlalchemy/sql/operators.py:358(__eq__)>
2	0.005	0.0025	0.303	0.1515	<sqlalchemy/orm/attributes.py:216(operate)>
6/2	0.015	0.0025	0.298	0.1490	{operator.eq}
50	0.173	0.0035	0.289	0.0058	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
2	0.012	0.0060	0.287	0.1435	<sqlalchemy/orm/properties.py:314(operate)>
99	0.168	0.0017	0.278	0.0028	{hasattr}
3	0.03	0.0100	0.267	0.0890	<sqlalchemy/sql/selectable.py:2124(__init__)>
3	0.07	0.0233	0.254	0.0847	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
3	0.089	0.0297	0.238	0.0793	<sqlalchemy/engine/default.py:636(_init_compiled)>
18	0.087	0.0048	0.238	0.0132	<sqlalchemy/util/langhelpers.py:935(oneshot)>
16	0.035	0.0022	0.223	0.0139	<sqlalchemy/sql/elements.py:4320(_as_truncated)>
6	0.039	0.0065	0.219	0.0365	<sqlalchemy/orm/base.py:215(generate)>
6	0.014	0.0023	0.199	0.0332	<sqlalchemy/event/attr.py:374(append)>
1	0.008	0.0080	0.198	0.1980	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
73	0.143	0.0020	0.197	0.0027	{method 'update' of 'dict' objects}
18	0.054	0.0030	0.195	0.0108	<sqlalchemy/sql/elements.py:4196(__new__)>
9	0.096	0.0107	0.195	0.0217	<sqlalchemy/util/_collections.py:755(unique_list)>
16	0.036	0.0023	0.186	0.0116	<sqlalchemy/sql/type_api.py:521(_gen_dialect_impl)>
6	0.024	0.0040	0.185	0.0308	<sqlalchemy/event/registry.py:264(append_to_list)>
8	0.051	0.0064	0.176	0.0220	<sqlalchemy/sql/base.py:38(_from_objects)>
2	0.01	0.0050	0.168	0.0840	<sqlalchemy/sql/annotation.py:102(__eq__)>
3	0.042	0.0140	0.156	0.0520	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
3	0.014	0.0047	0.154	0.0513	<sqlalchemy/engine/result.py:1195(fetchall)>
48	0.116	0.0024	0.153	0.0032	<sqlalchemy/orm/strategies.py:173(setup_query)>
2	0.007	0.0035	0.152	0.0760	<sqlalchemy/sql/elements.py:723(operate)>
6	0.053	0.0088	0.152	0.0253	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
127	0.151	0.0012	0.151	0.0012	<weakref.py:362(__getitem__)>
16	0.042	0.0026	0.15	0.0094	<sqlalchemy/engine/default.py:407(type_descriptor)>
9	0.054	0.0060	0.15	0.0167	<sqlalchemy/util/_collections.py:802(to_list)>
2	0.006	0.0030	0.14	0.0700	<string>:1(order_by)
208	0.139	0.0007	0.139	0.0007	{method 'append' of 'list' objects}
2	0.007	0.0035	0.137	0.0685	<sqlalchemy/sql/compiler.py:2285(order_by_clause)>
6	0.014	0.0023	0.134	0.0223	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
48	0.075	0.0016	0.13	0.0027	<sqlalchemy/engine/result.py:724(_getter)>
8	0.04	0.0050	0.129	0.0161	{method 'join' of 'str' objects}
35	0.064	0.0018	0.126	0.0036	<sqlalchemy/inspection.py:38(inspect)>
6	0.03	0.0050	0.124	0.0207	<sqlalchemy/event/api.py:23(_event_key)>
6	0.017	0.0028	0.12	0.0200	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
4	0.035	0.0087	0.119	0.0297	<sqlalchemy/sql/elements.py:4433(_literal_as_label_reference)>
2	0.011	0.0055	0.118	0.0590	<sqlalchemy/sql/type_api.py:64(operate)>
2	0.008	0.0040	0.117	0.0585	<sqlalchemy/sql/compiler.py:963(visit_clauselist)>
2	0.022	0.0110	0.114	0.0570	<sqlalchemy/sql/elements.py:1861(__init__)>
48	0.076	0.0016	0.114	0.0024	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
3	0.081	0.0270	0.112	0.0373	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
1	0.003	0.0030	0.112	0.1120	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
48	0.077	0.0016	0.112	0.0023	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
100/97	0.079	0.0008	0.11	0.0011	{setattr}
1	0.004	0.0040	0.109	0.1090	<sqlalchemy/pool/base.py:354(connect)>
16	0.092	0.0057	0.108	0.0067	<sqlalchemy/sql/type_api.py:1440(adapt_type)>
2	0.008	0.0040	0.108	0.0540	<sqlalchemy/dialects/postgresql/base.py:1643(limit_clause)>
96	0.108	0.0011	0.108	0.0011	<sqlalchemy/sql/elements.py:3939(_get_table)>
2	0.012	0.0060	0.108	0.0540	<sqlalchemy/sql/compiler.py:1263(visit_binary)>
2	0.019	0.0095	0.107	0.0535	<sqlalchemy/sql/default_comparator.py:41(_boolean_compare)>
2	0.008	0.0040	0.107	0.0535	<sqlalchemy/orm/query.py:1800(order_by)>
11	0.046	0.0042	0.106	0.0096	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
7	0.035	0.0050	0.106	0.0151	<sqlalchemy/sql/sqltypes.py:411(__init__)>
3	0.01	0.0033	0.106	0.0353	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
1	0.008	0.0080	0.105	0.1050	<sqlalchemy/pool/base.py:757(_checkout)>
2	0.008	0.0040	0.098	0.0490	<sqlalchemy/orm/query.py:310(_adapt_col_list)>
2	0.027	0.0135	0.098	0.0490	<sqlalchemy/sql/selectable.py:81(_offset_or_limit_clause)>
3	0.096	0.0320	0.096	0.0320	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
1	0.014	0.0140	0.095	0.0950	<sqlalchemy/pool/base.py:490(checkout)>
6	0.042	0.0070	0.092	0.0153	<sqlalchemy/event/base.py:266(__getattr__)>
114	0.091	0.0008	0.091	0.0008	{method 'add' of 'set' objects}
6	0.028	0.0047	0.09	0.0150	<sqlalchemy/event/attr.py:234(for_modify)>
2	0.022	0.0110	0.089	0.0445	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
4	0.006	0.0015	0.089	0.0222	<sqlalchemy/sql/compiler.py:970(<genexpr>)>
3	0.017	0.0057	0.089	0.0297	<sqlalchemy/orm/query.py:4045(__new__)>
2	0.009	0.0045	0.089	0.0445	<sqlalchemy/sql/type_api.py:720(adapt)>
2	0.017	0.0085	0.087	0.0435	<sqlalchemy/sql/compiler.py:1320(_generate_generic_binary)>
9	0.013	0.0014	0.086	0.0096	<tg/request_local.py:232(_current_obj)>
2	0.016	0.0080	0.084	0.0420	<sqlalchemy/sql/compiler.py:1447(visit_bindparam)>
81	0.084	0.0010	0.084	0.0010	{method 'startswith' of 'str' objects}
16	0.051	0.0032	0.083	0.0052	<sqlalchemy/sql/base.py:601(__contains__)>
18	0.053	0.0029	0.083	0.0046	<sqlalchemy/sql/elements.py:4151(__new__)>
4	0.007	0.0018	0.083	0.0208	<sqlalchemy/sql/compiler.py:972(<genexpr>)>
4	0.014	0.0035	0.082	0.0205	<sqlalchemy/sql/annotation.py:78(_compiler_dispatch)>
3	0.024	0.0080	0.08	0.0267	<sqlalchemy/orm/query.py:4079(setup_entity)>
1	0.019	0.0190	0.078	0.0780	<sqlalchemy/engine/base.py:69(__init__)>
1	0.012	0.0120	0.077	0.0770	<sqlalchemy/orm/properties.py:287(_memoized_method___clause_element__)>
12	0.024	0.0020	0.076	0.0063	<sqlalchemy/sql/elements.py:4479(_literal_as_text)>
5	0.018	0.0036	0.076	0.0152	<sqlalchemy/event/base.py:295(__get__)>
2	0.006	0.0030	0.074	0.0370	<sqlalchemy/sql/type_api.py:709(adapt_to_emulated)>
28	0.055	0.0020	0.073	0.0026	<sqlalchemy/event/attr.py:264(__iter__)>
2	0.013	0.0065	0.07	0.0350	<sqlalchemy/sql/elements.py:4443(_literal_and_labels_as_label_reference)>
2	0.006	0.0030	0.068	0.0340	<string>:1(desc)
12/9	0.033	0.0027	0.068	0.0076	<tg/support/objectproxy.py:18(__getattr__)>
2	0.005	0.0025	0.067	0.0335	<string>:1(filter)
48	0.067	0.0014	0.067	0.0014	<sqlalchemy/sql/compiler.py:410(__init__)>
3	0.015	0.0050	0.066	0.0220	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
3	0.016	0.0053	0.065	0.0217	<sqlalchemy/util/_collections.py:361(__init__)>
2	0.009	0.0045	0.065	0.0325	<sqlalchemy/sql/compiler.py:1178(visit_unary)>
1	0.021	0.0210	0.063	0.0630	<sqlalchemy/sql/elements.py:254(_annotate)>
8	0.033	0.0041	0.063	0.0079	<sqlalchemy/event/registry.py:154(__init__)>
9	0.037	0.0041	0.062	0.0069	<abc.py:128(__instancecheck__)>
2	0.011	0.0055	0.062	0.0310	<sqlalchemy/sql/elements.py:2746(_create_desc)>
6	0.009	0.0015	0.062	0.0103	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
1	0.004	0.0040	0.062	0.0620	<sqlalchemy/pool/impl.py:112(_do_get)>
2	0.03	0.0150	0.061	0.0305	<sqlalchemy/sql/elements.py:908(__init__)>
19	0.049	0.0026	0.06	0.0032	<sqlalchemy/event/base.py:94(__getattr__)>
72	0.059	0.0008	0.059	0.0008	{method 'update' of 'set' objects}
5	0.013	0.0026	0.058	0.0116	<sqlalchemy/event/base.py:119(_for_instance)>
1	0.015	0.0150	0.058	0.0580	<sqlalchemy/util/queue.py:135(get)>
74	0.058	0.0008	0.058	0.0008	{len}
17	0.044	0.0026	0.058	0.0034	<sqlalchemy/sql/elements.py:4171(_memoized_method_lower)>
58	0.057	0.0010	0.057	0.0010	{id}
4	0.036	0.0090	0.056	0.0140	<sqlalchemy/sql/elements.py:714(__getattr__)>
3	0.012	0.0040	0.056	0.0187	<sqlalchemy/engine/default.py:1032(create_cursor)>
11	0.056	0.0051	0.056	0.0051	<sqlalchemy/orm/loading.py:677(_populate_full)>
1	0.006	0.0060	0.055	0.0550	<sqlalchemy/orm/session.py:884(begin)>
6	0.039	0.0065	0.055	0.0092	<sqlalchemy/event/attr.py:330(__init__)>
48	0.055	0.0011	0.055	0.0011	<sqlalchemy/engine/result.py:643(_getter)>
53	0.054	0.0010	0.054	0.0010	<sqlalchemy/util/langhelpers.py:1145(<genexpr>)>
49	0.054	0.0011	0.054	0.0011	{method 'get' of 'dictproxy' objects}
18	0.041	0.0023	0.053	0.0029	<sqlalchemy/orm/path_registry.py:296(__getitem__)>
6	0.022	0.0037	0.053	0.0088	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
2	0.008	0.0040	0.053	0.0265	<sqlalchemy/sql/compiler.py:1531(_truncate_bindparam)>
12	0.028	0.0023	0.052	0.0043	<sqlalchemy/sql/elements.py:4463(_literal_as)>
1	0.004	0.0040	0.051	0.0510	<sqlalchemy/engine/base.py:596(begin)>
2	0.025	0.0125	0.05	0.0250	<sqlalchemy/sql/elements.py:3063(__init__)>
1	0.019	0.0190	0.05	0.0500	<sqlalchemy/orm/mapper.py:2291(_polymorphic_properties)>
17	0.035	0.0021	0.05	0.0029	<sqlalchemy/sql/elements.py:3948(_from_objects)>
1	0.009	0.0090	0.049	0.0490	<sqlalchemy/orm/session.py:220(__init__)>
1	0.005	0.0050	0.048	0.0480	<zope/sqlalchemy/datamanager.py:245(after_begin)>
1	0.006	0.0060	0.047	0.0470	<sqlalchemy/engine/base.py:1737(__init__)>
2	0.006	0.0030	0.046	0.0230	<sqlalchemy/sql/compiler.py:1344(_generate_generic_unary_modifier)>
47	0.046	0.0010	0.046	0.0010	{built-in method __new__ of type object at 0x7f45e236b3c0}
5	0.016	0.0032	0.045	0.0090	<sqlalchemy/event/base.py:116(_for_class)>
19	0.044	0.0023	0.044	0.0023	<sqlalchemy/util/langhelpers.py:253(_inspect_func_args)>
2	0.02	0.0100	0.044	0.0220	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
1	0.006	0.0060	0.043	0.0430	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
6	0.023	0.0038	0.043	0.0072	<sqlalchemy/orm/events.py:1235(_accept_with)>
48	0.043	0.0009	0.043	0.0009	<sqlalchemy/sql/elements.py:4204(apply_map)>
38	0.042	0.0011	0.042	0.0011	<weakref.py:400(__contains__)>
48	0.041	0.0009	0.041	0.0009	<sqlalchemy/sql/compiler.py:419(type)>
16	0.025	0.0016	0.041	0.0026	<sqlalchemy/sql/elements.py:3974(_render_label_in_columns_clause)>
3	0.008	0.0027	0.039	0.0130	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
1	0.012	0.0120	0.039	0.0390	<sqlalchemy/engine/base.py:713(_begin_impl)>
14	0.028	0.0020	0.039	0.0028	<sqlalchemy/event/attr.py:400(listeners)>
3	0.013	0.0043	0.038	0.0127	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
1	0.01	0.0100	0.037	0.0370	<sqlalchemy/sql/elements.py:4630(__init__)>
4	0.017	0.0043	0.036	0.0090	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
3	0.032	0.0107	0.036	0.0120	<sqlalchemy/orm/query.py:4650(__init__)>
18	0.036	0.0020	0.036	0.0020	<sqlalchemy/orm/interfaces.py:507(_memoized_attr__default_path_loader_key)>
6	0.012	0.0020	0.035	0.0058	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
56	0.035	0.0006	0.035	0.0006	{method 'intersection' of 'set' objects}
1	0.013	0.0130	0.035	0.0350	<sqlalchemy/orm/session.py:337(_take_snapshot)>
6	0.02	0.0033	0.035	0.0058	<sqlalchemy/event/attr.py:302(__iter__)>
10	0.022	0.0022	0.035	0.0035	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
3	0.008	0.0027	0.034	0.0113	<tg/support/objectproxy.py:21(__setattr__)>
2	0.01	0.0050	0.033	0.0165	<sqlalchemy/sql/elements.py:4311(apply_map)>
3	0.02	0.0067	0.033	0.0110	<sqlalchemy/orm/state.py:685(unloaded)>
3	0.011	0.0037	0.033	0.0110	<sqlalchemy/pool/base.py:958(cursor)>
1	0.015	0.0150	0.033	0.0330	<zope/sqlalchemy/datamanager.py:73(__init__)>
17	0.033	0.0019	0.033	0.0019	{method 'match' of '_sre.SRE_Pattern' objects}
6	0.016	0.0027	0.032	0.0053	<sqlalchemy/event/registry.py:169(with_wrapper)>
3	0.02	0.0067	0.031	0.0103	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
19	0.014	0.0007	0.031	0.0016	<sqlalchemy/orm/mapper.py:2299(_iterate_polymorphic_properties)>
48	0.031	0.0006	0.031	0.0006	<sqlalchemy/sql/elements.py:748(_select_iterable)>
5	0.01	0.0020	0.031	0.0062	<sqlalchemy/orm/session.py:2425(flush)>
6	0.009	0.0015	0.031	0.0052	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
3	0.024	0.0080	0.031	0.0103	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
3	0.012	0.0040	0.031	0.0103	<sqlalchemy/orm/query.py:399(_bind_mapper)>
4	0.018	0.0045	0.031	0.0077	<sqlalchemy/util/langhelpers.py:1157(_next)>
7	0.03	0.0043	0.03	0.0043	{_warnings.warn}
3	0.01	0.0033	0.03	0.0100	<sqlalchemy/orm/path_registry.py:63(set)>
6	0.018	0.0030	0.03	0.0050	<sqlalchemy/orm/query.py:518(_clone)>
5	0.019	0.0038	0.029	0.0058	<sqlalchemy/event/base.py:77(__init__)>
2	0.01	0.0050	0.028	0.0140	<sqlalchemy/orm/base.py:379(_entity_descriptor)>
12	0.028	0.0023	0.028	0.0023	<sqlalchemy/orm/state.py:89(__init__)>
2	0.012	0.0060	0.028	0.0140	<sqlalchemy/orm/query.py:1734(filter)>
2	0.004	0.0020	0.027	0.0135	<string>:1(limit)
6	0.024	0.0040	0.027	0.0045	<sqlalchemy/event/registry.py:165(_key)>
3	0.014	0.0047	0.027	0.0090	<webob/request.py:1399(__setattr__)>
2	0.006	0.0030	0.026	0.0130	<sqlalchemy/sql/elements.py:3124(self_group)>
1	0.016	0.0160	0.026	0.0260	<sqlalchemy/orm/mapper.py:989(_path_registry)>
22	0.025	0.0011	0.025	0.0011	{method 'difference' of 'set' objects}
3	0.008	0.0027	0.025	0.0083	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
6	0.015	0.0025	0.024	0.0040	<sqlalchemy/orm/base.py:228(manager_of_class)>
7	0.024	0.0034	0.024	0.0034	<sqlalchemy/sql/sqltypes.py:294(result_processor)>
3	0.007	0.0023	0.024	0.0080	<sqlalchemy/orm/session.py:1574(_autoflush)>
3	0.015	0.0050	0.024	0.0080	<sqlalchemy/orm/state.py:771(_commit)>
28	0.024	0.0009	0.024	0.0009	{method 'get' of 'dict' objects}
2	0.005	0.0025	0.023	0.0115	<sqlalchemy/util/_collections.py:733(__missing__)>
18	0.022	0.0012	0.022	0.0012	<sqlalchemy/orm/interfaces.py:501(_memoized_attr__wildcard_token)>
3	0.011	0.0037	0.022	0.0073	<sqlalchemy/engine/result.py:869(_soft_close)>
5	0.014	0.0028	0.022	0.0044	<logging/__init__.py:1367(isEnabledFor)>
3	0.022	0.0073	0.022	0.0073	<sqlalchemy/orm/loading.py:734(_populate_partial)>
3	0.01	0.0033	0.022	0.0073	<sqlalchemy/sql/selectable.py:55(_interpret_as_from)>
3	0.022	0.0073	0.022	0.0073	{method 'cursor' of 'psycopg2.extensions.connection' objects}
32	0.021	0.0007	0.021	0.0007	{iter}
5	0.015	0.0030	0.021	0.0042	<sqlalchemy/orm/session.py:2471(_is_clean)>
17	0.02	0.0012	0.02	0.0012	<weakref.py:368(__setitem__)>
2	0.008	0.0040	0.02	0.0100	<sqlalchemy/sql/operators.py:1486(is_precedent)>
16	0.02	0.0012	0.02	0.0012	<sqlalchemy/sql/type_api.py:307(_has_column_expression)>
24	0.02	0.0008	0.02	0.0008	{method 'pop' of 'dict' objects}
3	0.005	0.0017	0.02	0.0067	<logging/__init__.py:1152(debug)>
4	0.011	0.0027	0.02	0.0050	<sqlalchemy/sql/operators.py:1399(is_boolean)>
4	0.011	0.0027	0.019	0.0047	<sqlalchemy/sql/compiler.py:1170(_get_operator_dispatch)>
1	0.004	0.0040	0.019	0.0190	<threading.py:187(release)>
1	0.007	0.0070	0.018	0.0180	<sqlalchemy/orm/state.py:431(_initialize_instance)>
2	0.018	0.0090	0.018	0.0090	<sqlalchemy/sql/elements.py:2871(_order_by_label_element)>
24	0.018	0.0008	0.018	0.0008	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.011	0.0055	0.018	0.0090	<sqlalchemy/orm/query.py:396(_joinpoint_zero)>
2	0.012	0.0060	0.018	0.0090	<sqlalchemy/sql/compiler.py:1566(_process_anon)>
16	0.018	0.0011	0.018	0.0011	<sqlalchemy/util/_collections.py:214(__contains__)>
2	0.011	0.0055	0.018	0.0090	<sqlalchemy/sql/elements.py:2641(__init__)>
10	0.018	0.0018	0.018	0.0018	<_weakrefset.py:70(__contains__)>
2	0.017	0.0085	0.017	0.0085	<sqlalchemy/util/_collections.py:316(values)>
5	0.008	0.0016	0.017	0.0034	<sqlalchemy/sql/compiler.py:625(<genexpr>)>
16	0.017	0.0011	0.017	0.0011	<sqlalchemy/sql/elements.py:3963(_key_label)>
5	0.012	0.0024	0.017	0.0034	<sqlalchemy/orm/query.py:379(_entity_zero)>
1	0.006	0.0060	0.017	0.0170	<sqlalchemy/orm/mapper.py:2055(iterate_properties)>
22	0.016	0.0007	0.016	0.0007	{method 'setdefault' of 'dict' objects}
4	0.012	0.0030	0.016	0.0040	<string>:8(__new__)
36	0.015	0.0004	0.015	0.0004	{method 'discard' of 'set' objects}
3	0.01	0.0033	0.015	0.0050	<sqlalchemy/sql/elements.py:702(comparator)>
18	0.015	0.0008	0.015	0.0008	<sqlalchemy/orm/path_registry.py:168(__getitem__)>
3	0.007	0.0023	0.015	0.0050	<sqlalchemy/sql/compiler.py:2313(visit_table)>
16	0.015	0.0009	0.015	0.0009	{method 'copy' of 'dict' objects}
13	0.015	0.0012	0.015	0.0012	<sqlalchemy/event/attr.py:267(__bool__)>
2	0.011	0.0055	0.014	0.0070	<sqlalchemy/event/legacy.py:26(_wrap_fn_for_legacy)>
3	0.014	0.0047	0.014	0.0047	<threading.py:64(_note)>
1	0.008	0.0080	0.014	0.0140	<sqlalchemy/sql/annotation.py:52(__init__)>
17	0.014	0.0008	0.014	0.0008	{method 'lower' of 'unicode' objects}
6	0.014	0.0023	0.014	0.0023	<sqlalchemy/sql/elements.py:681(self_group)>
4	0.013	0.0032	0.013	0.0032	<weakref.py:330(__init__)>
14	0.013	0.0009	0.013	0.0009	<sqlalchemy/orm/identity.py:163(get)>
16	0.013	0.0008	0.013	0.0008	<sqlalchemy/orm/mapper.py:731(mapper)>
11	0.013	0.0012	0.013	0.0012	{method 'issuperset' of 'frozenset' objects}
3	0.011	0.0037	0.013	0.0043	<sqlalchemy/engine/default.py:945(should_autocommit)>
11	0.013	0.0012	0.013	0.0012	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
7	0.013	0.0019	0.013	0.0019	<sqlalchemy/sql/sqltypes.py:140(__init__)>
1	0.006	0.0060	0.013	0.0130	<sqlalchemy/orm/mapper.py:1705(_prop_set)>
1	0.006	0.0060	0.013	0.0130	<weakref.py:115(__setitem__)>
9	0.012	0.0013	0.012	0.0013	<tg/support/registry.py:52(_current_obj)>
1	0.005	0.0050	0.012	0.0120	<sqlalchemy/orm/instrumentation.py:200(_state_constructor)>
3	0.007	0.0023	0.012	0.0040	<sqlalchemy/orm/mapper.py:2263(selectable)>
3	0.012	0.0040	0.012	0.0040	<sqlalchemy/orm/query.py:4067(__init__)>
2	0.004	0.0020	0.012	0.0060	<sqlalchemy/sql/elements.py:4459(_expression_literal_as_text)>
5	0.009	0.0018	0.012	0.0024	<sqlalchemy/engine/default.py:727(<genexpr>)>
3	0.008	0.0027	0.012	0.0040	<sqlalchemy/orm/session.py:1417(get_bind)>
3	0.012	0.0040	0.012	0.0040	{method 'encode' of 'unicode' objects}
12	0.012	0.0010	0.012	0.0010	<string>:1(set)
1	0.006	0.0060	0.012	0.0120	<sqlalchemy/orm/instrumentation.py:358(_new_state_if_none)>
3	0.012	0.0040	0.012	0.0040	<sqlalchemy/engine/result.py:1178(process_rows)>
1	0.007	0.0070	0.011	0.0110	<threading.py:147(acquire)>
3	0.007	0.0023	0.011	0.0037	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
1	0.005	0.0050	0.011	0.0110	<transaction/_transaction.py:176(join)>
3	0.008	0.0027	0.011	0.0037	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
6	0.01	0.0017	0.01	0.0017	<sqlalchemy/event/attr.py:393(__init__)>
4	0.008	0.0020	0.01	0.0025	<inspect.py:67(ismethod)>
1	0.005	0.0050	0.01	0.0100	<sqlalchemy/orm/path_registry.py:134(per_mapper)>
3	0.007	0.0023	0.01	0.0033	<sqlalchemy/orm/loading.py:880(for_context)>
2	0.005	0.0025	0.01	0.0050	<sqlalchemy/sql/elements.py:3095(_from_objects)>
4	0.006	0.0015	0.01	0.0025	<inspect.py:142(isfunction)>
2	0.006	0.0030	0.009	0.0045	<sqlalchemy/sql/type_api.py:473(_cached_bind_processor)>
3	0.009	0.0030	0.009	0.0030	<sqlalchemy/orm/query.py:3470(_select_args)>
1	0.008	0.0080	0.009	0.0090	<sqlalchemy/pool/base.py:589(get_connection)>
7	0.009	0.0013	0.009	0.0013	{time.time}
4	0.008	0.0020	0.009	0.0023	<sqlalchemy/sql/operators.py:1376(is_comparison)>
1	0.005	0.0050	0.008	0.0080	<threading.py:373(notify)>
1	0.004	0.0040	0.008	0.0080	<sqlalchemy/util/langhelpers.py:858(_reset)>
4	0.008	0.0020	0.008	0.0020	<sqlalchemy/orm/query.py:326(_adapt_clause)>
3	0.008	0.0027	0.008	0.0027	<webob/request.py:1406(__getattr__)>
1	0.006	0.0060	0.008	0.0080	<sqlalchemy/event/base.py:123(_join)>
4	0.006	0.0015	0.008	0.0020	<sqlalchemy/sql/type_api.py:1430(to_instance)>
3	0.006	0.0020	0.008	0.0027	<sqlalchemy/util/_collections.py:396(__iter__)>
5	0.008	0.0016	0.008	0.0016	<logging/__init__.py:1353(getEffectiveLevel)>
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/orm/attributes.py:179(__clause_element__)>
2	0.005	0.0025	0.007	0.0035	<inspect.py:226(isbuiltin)>
2	0.006	0.0030	0.007	0.0035	<sqlalchemy/sql/sqltypes.py:2823(_resolve_value_to_type)>
1	0.003	0.0030	0.007	0.0070	<sqlalchemy/log.py:56(_should_log_debug)>
5	0.007	0.0014	0.007	0.0014	{method 'acquire' of 'thread.lock' objects}
6	0.007	0.0012	0.007	0.0012	<sqlalchemy/orm/query.py:474(_no_statement_condition)>
3	0.007	0.0023	0.007	0.0023	<sqlalchemy/dialects/postgresql/psycopg2.py:535(_log_notices)>
3	0.007	0.0023	0.007	0.0023	{sqlalchemy.cutils._distill_params}
6	0.007	0.0012	0.007	0.0012	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
2	0.007	0.0035	0.007	0.0035	<sqlalchemy/sql/compiler.py:1572(bindparam_string)>
2	0.004	0.0020	0.007	0.0035	<sqlalchemy/sql/elements.py:4595(_const_expr)>
4	0.007	0.0018	0.007	0.0018	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
1	0.004	0.0040	0.007	0.0070	<sqlalchemy/log.py:59(_should_log_info)>
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/query.py:486(_no_limit_offset)>
6	0.006	0.0010	0.006	0.0010	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
5	0.006	0.0012	0.006	0.0012	<sqlalchemy/orm/identity.py:56(check_modified)>
3	0.006	0.0020	0.006	0.0020	<sqlalchemy/orm/session.py:267(_assert_active)>
6	0.006	0.0010	0.006	0.0010	{method 'values' of 'dict' objects}
6	0.006	0.0010	0.006	0.0010	<sqlalchemy/event/base.py:112(_listen)>
3	0.006	0.0020	0.006	0.0020	<sqlalchemy/sql/compiler.py:641(construct_params)>
6	0.006	0.0010	0.006	0.0010	<sqlalchemy/event/attr.py:49(_memoized_attr_ref)>
3	0.006	0.0020	0.006	0.0020	<sqlalchemy/orm/path_registry.py:71(get)>
2	0.005	0.0025	0.005	0.0025	{method 'split' of 'unicode' objects}
1	0.003	0.0030	0.005	0.0050	<transaction/_transaction.py:50(myhasattr)>
5	0.005	0.0010	0.005	0.0010	<sqlalchemy/orm/query.py:371(_query_entity_zero)>
3	0.005	0.0017	0.005	0.0017	<sqlalchemy/sql/type_api.py:60(__init__)>
1	0.003	0.0030	0.005	0.0050	<sqlalchemy/sql/annotation.py:38(__new__)>
1	0.005	0.0050	0.005	0.0050	<sqlalchemy/orm/path_registry.py:261(__init__)>
5	0.005	0.0010	0.005	0.0010	{method 'release' of 'thread.lock' objects}
1	0.004	0.0040	0.005	0.0050	<sqlalchemy/orm/mapper.py:3344(_event_on_init)>
6	0.005	0.0008	0.005	0.0008	{method 'append' of 'collections.deque' objects}
4	0.004	0.0010	0.004	0.0010	<sqlalchemy/orm/interfaces.py:744(setup_query)>
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__)>
3	0.004	0.0013	0.004	0.0013	{method 'pop' of 'list' objects}
1	0.003	0.0030	0.004	0.0040	<transaction/_manager.py:245(get)>
3	0.004	0.0013	0.004	0.0013	<sqlalchemy/util/_collections.py:730(__init__)>
6	0.004	0.0007	0.004	0.0007	{method 'items' of 'dict' objects}
2	0.004	0.0020	0.004	0.0020	<inspect.py:208(iscode)>
1	0.003	0.0030	0.004	0.0040	<weakref.py:390(get)>
1	0.003	0.0030	0.004	0.0040	<sqlalchemy/util/langhelpers.py:861(reset)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/sql/sqltypes.py:1707(__init__)>
2	0.004	0.0020	0.004	0.0020	<sqlalchemy/util/langhelpers.py:1111(asint)>
3	0.004	0.0013	0.004	0.0013	<sqlalchemy/orm/mapper.py:2132(_with_polymorphic_mappers)>
3	0.004	0.0013	0.004	0.0013	{zip}
3	0.004	0.0013	0.004	0.0013	{method 'close' of 'psycopg2.extensions.cursor' objects}
1	0.003	0.0030	0.004	0.0040	<sqlalchemy/util/queue.py:203(_get)>
4	0.004	0.0010	0.004	0.0010	{next}
4	0.004	0.0010	0.004	0.0010	<sqlalchemy/orm/attributes.py:274(__get__)>
3	0.004	0.0013	0.004	0.0013	<sqlalchemy/orm/state.py:412(dict)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/dialects/postgresql/base.py:1658(get_select_precolumns)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/base.py:370(connection)>
1	0.002	0.0020	0.003	0.0030	<threading.py:238(_is_owned)>
3	0.003	0.0010	0.003	0.0010	{delattr}
1	0.002	0.0020	0.003	0.0030	<sqlalchemy/orm/mapper.py:3330(_event_on_first_init)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/sql/selectable.py:143(selectable)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/default.py:1043(pre_exec)>
2	0.003	0.0015	0.003	0.0015	{_codecs.utf_8_encode}
3	0.003	0.0010	0.003	0.0010	{method 'union' of 'set' objects}
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/result.py:864(_cursor_description)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/sql/compiler.py:352(__str__)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/orm/query.py:4684(<genexpr>)>
7	0.003	0.0004	0.003	0.0004	<sqlalchemy/sql/type_api.py:269(result_processor)>
1	0.003	0.0030	0.003	0.0030	<weakref.py:315(__init__)>
3	0.003	0.0010	0.003	0.0010	{thread.get_ident}
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/util/langhelpers.py:938(memo)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/sql/selectable.py:1937(_from_objects)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/sql/compiler.py:951(visit_true)>
3	0.002	0.0007	0.002	0.0007	<sqlalchemy/sql/sqltypes.py:785(__init__)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/query.py:3061(limit)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/elements.py:2920(self_group)>
3	0.002	0.0007	0.002	0.0007	{method 'difference_update' of 'set' objects}
3	0.002	0.0007	0.002	0.0007	<sqlalchemy/util/_collections.py:151(union)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/orm/mapper.py:2140(_with_polymorphic_selectable)>
3	0.002	0.0007	0.002	0.0007	{method 'keys' of 'dict' objects}
2	0.002	0.0010	0.002	0.0010	{callable}
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/sqltypes.py:1789(result_processor)>
2	0.002	0.0010	0.002	0.0010	{issubclass}
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/event/base.py:261(__init__)>
3	0.002	0.0007	0.002	0.0007	<sqlalchemy/engine/default.py:1046(post_exec)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/engine/base.py:1674(__init__)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/ext/declarative/base.py:826(_declarative_constructor)>
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/pool/base.py:724(__init__)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/orm/interfaces.py:389(adapter)>
1	0.001	0.0010	0.002	0.0020	<sqlalchemy/engine/default.py:941(no_parameters)>
1	0.001	0.0010	0.001	0.0010	{hash}
1	0.001	0.0010	0.001	0.0010	{method 'popleft' of 'collections.deque' objects}
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/orm/session.py:306(_is_transaction_boundary)>
1	0.001	0.0010	0.001	0.0010	<transaction/_manager.py:82(get)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/engine/default.py:496(do_begin)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/util/queue.py:191(_empty)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/orm/mapper.py:2123(_single_table_criterion)>
1	0.0	0.0000	0.0	0.0000	{method 'disable' of '_lsprof.Profiler' objects}

Request

GET

Nothing here.

POST

Nothing here.

Cookies

Nothing here.

Headers

Name	Value
SCRIPT_NAME	''
HTTP_IF_MODIFIED_SINCE	'Fri, 08 Nov 2024 10:35:15 GMT'
REQUEST_METHOD	'GET'
PATH_INFO	'/media/videos'
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	'18.97.9.171'
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
paginators	{'_tg_paginators_params': {'page': None}, 'all_videos': {'paginate_items_per_page': 12, 'paginate_page': 1, 'paginate_params': {'page': None}}}
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 0x7f45dbab3c10>
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, 'paginators': {'_tg_paginators_params': {'page': None}, 'all_videos': {'paginate_items_per_page': 12, 'paginate_page': 1, 'paginate_params': {'page': None}}}, 'tgdb_sqla_queries': [{'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f45da454850>, 'duration': 3.8590431213378906, 'engine_id': 139938014901136, 'parameters': {}, 'statement': 'SELECT video.id AS video_id, video.title AS video_title, video.meta_title AS video_meta_title, video.description AS video_description, video.page_url AS video_page_url, video.album_cover AS video_album_cover, video.document_id AS video_document_id, video.album_id AS video_album_id, video.keywords AS video_keywords, video."order" AS video_order, video.is_published AS video_is_published, video.is_active AS video_is_active, video.created_by AS video_created_by, video.created AS video_created, video.last_updated AS video_last_updated, video.published_on AS video_published_on \nFROM video \nWHERE video.is_active = true'}, {'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f45da4ee9d0>, 'duration': 0.7719993591308594, 'engine_id': 139938014901136, 'parameters': {'param_1': 5}, 'statement': 'SELECT news.id AS news_id, news.title AS news_title, news.meta_title AS news_meta_title, news.description AS news_description, news.keywords AS news_keywords, news.page_url AS news_page_url, news.thumbnail_image AS news_thumbnail_image, news.document_id AS news_document_id, news."order" AS news_order, news.is_published AS news_is_published, news.is_active AS news_is_active, news.is_featured AS news_is_featured, news.created_by AS news_created_by, news.created AS news_created, news.last_updated AS news_last_updated, news.published_on AS news_published_on \nFROM news ORDER BY news.created DESC \n LIMIT %(param_1)s'}, {'context': <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f45da5b7c50>, 'duration': 0.308990478515625, 'engine_id': 139938014901136, 'parameters': {'param_1': 5}, 'statement': 'SELECT news.id AS news_id, news.title AS news_title, news.meta_title AS news_meta_title, news.description AS news_description, news.keywords AS news_keywords, news.page_url AS news_page_url, news.thumbnail_image AS news_thumbnail_image, news.document_id AS news_document_id, news."order" AS news_order, news.is_published AS news_is_published, news.is_active AS news_is_active, news.is_featured AS news_is_featured, news.created_by AS news_created_by, news.created AS news_created, news.last_updated AS news_last_updated, news.published_on AS news_published_on \nFROM news \nWHERE news.is_active = true ORDER BY news.created DESC \n LIMIT %(param_1)s'}]}
HTTP_IF_MODIFIED_SINCE	'Fri, 08 Nov 2024 10:35:15 GMT'
REQUEST_METHOD	'GET'
PATH_INFO	'/media/videos'
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	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_CONNECTION	'Keep-Alive'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'18.97.9.171'
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 0x7f45dadc5070>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': 'bdc011300ca642fa8365457b9909d3d6'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7f45e17f4d90>
REQUEST_URI	'/media/videos'
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 0x7f45da465750>
repoze.who.api	<repoze.who.api.API object at 0x7f45da4ee950>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7f45e1cf46f0>
REMOTE_PORT	'60070'
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 0x7f45da5c1550>
wsgi.file_wrapper	<built-in function uwsgi_sendfile>
HTTP_ACCEPT_ENCODING	'br,gzip'
webob._parsed_cookies	({}, '')

SQLAlchemy

Queries Performed

Query	Params	Time	Actions
SELECT video.id AS video_id, video.title AS video_title, video.meta_title AS video_meta_title, video.description AS video_description, video.page_url AS video_page_url, video.album_cover AS video_album_cover, video.document_id AS video_document_id, video.album_id AS video_album_id, video.keywords AS video_keywords, video."order" AS video_order, video.is_published AS video_is_published, video.is_active AS video_is_active, video.created_by AS video_created_by, video.created AS video_created, video.last_updated AS video_last_updated, video.published_on AS video_published_on FROM video WHERE video.is_active = true	{}	3.8590 ms	Results Explain
SELECT news.id AS news_id, news.title AS news_title, news.meta_title AS news_meta_title, news.description AS news_description, news.keywords AS news_keywords, news.page_url AS news_page_url, news.thumbnail_image AS news_thumbnail_image, news.document_id AS news_document_id, news."order" AS news_order, news.is_published AS news_is_published, news.is_active AS news_is_active, news.is_featured AS news_is_featured, news.created_by AS news_created_by, news.created AS news_created, news.last_updated AS news_last_updated, news.published_on AS news_published_on FROM news ORDER BY news.created DESC LIMIT %(param_1)s	{"param_1": 5}	0.7720 ms	Results Explain
SELECT news.id AS news_id, news.title AS news_title, news.meta_title AS news_meta_title, news.description AS news_description, news.keywords AS news_keywords, news.page_url AS news_page_url, news.thumbnail_image AS news_thumbnail_image, news.document_id AS news_document_id, news."order" AS news_order, news.is_published AS news_is_published, news.is_active AS news_is_active, news.is_featured AS news_is_featured, news.created_by AS news_created_by, news.created AS news_created, news.last_updated AS news_last_updated, news.published_on AS news_published_on FROM news WHERE news.is_active = true ORDER BY news.created DESC LIMIT %(param_1)s	{"param_1": 5}	0.3090 ms	Results Explain

Query

Params

Time

Actions

SELECT video.id AS video_id, video.title AS video_title, video.meta_title AS video_meta_title, video.description AS video_description, video.page_url AS video_page_url, video.album_cover AS video_album_cover, video.document_id AS video_document_id, video.album_id AS video_album_id, video.keywords AS video_keywords, video."order" AS video_order, video.is_published AS video_is_published, video.is_active AS video_is_active, video.created_by AS video_created_by, video.created AS video_created, video.last_updated AS video_last_updated, video.published_on AS video_published_on 
FROM video 
WHERE video.is_active = true

{}

3.8590 ms

Results

Explain

SELECT news.id AS news_id, news.title AS news_title, news.meta_title AS news_meta_title, news.description AS news_description, news.keywords AS news_keywords, news.page_url AS news_page_url, news.thumbnail_image AS news_thumbnail_image, news.document_id AS news_document_id, news."order" AS news_order, news.is_published AS news_is_published, news.is_active AS news_is_active, news.is_featured AS news_is_featured, news.created_by AS news_created_by, news.created AS news_created, news.last_updated AS news_last_updated, news.published_on AS news_published_on 
FROM news ORDER BY news.created DESC 
 LIMIT %(param_1)s

{"param_1": 5}

0.7720 ms

Results

Explain

SELECT news.id AS news_id, news.title AS news_title, news.meta_title AS news_meta_title, news.description AS news_description, news.keywords AS news_keywords, news.page_url AS news_page_url, news.thumbnail_image AS news_thumbnail_image, news.document_id AS news_document_id, news."order" AS news_order, news.is_published AS news_is_published, news.is_active AS news_is_active, news.is_featured AS news_is_featured, news.created_by AS news_created_by, news.created AS news_created, news.last_updated AS news_last_updated, news.published_on AS news_published_on 
FROM news 
WHERE news.is_active = true ORDER BY news.created DESC 
 LIMIT %(param_1)s

{"param_1": 5}

0.3090 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.

Videos

Timing

Template

Profiling

GET

POST

Cookies

Headers

Request Attributes

Environ

Queries Performed

Mounted Controllers

Log Messages

Inventing Mode