Timings

Timing

Action	Time Spent
Render Time	3.5331 ms
Controller Time	14.2250 ms
Total Time	28.7590 ms

Template

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

Profiling

Calls	Total	Percall	Cumu	CumuPer	Func
1	0.004	0.0040	14.209	14.2090	<tg/configurator/components/dispatch.py:113(_call_controller)>
1	0.005	0.0050	14.205	14.2050	<jacwud_dev/modules/mediacenter/controller/root.py:102(videos)>
1	0.028	0.0280	14.2	14.2000	<jacwud_dev/modules/mediacenter/controller/videos.py:55(index)>
3	0.082	0.0273	11.961	3.9870	<sqlalchemy/orm/query.py:3162(all)>
3	0.018	0.0060	9.137	3.0457	<sqlalchemy/orm/query.py:3319(__iter__)>
3	0.021	0.0070	7.408	2.4693	<sqlalchemy/orm/query.py:3344(_execute_and_instances)>
3	0.012	0.0040	6.975	2.3250	<sqlalchemy/engine/base.py:922(execute)>
3	0.009	0.0030	6.959	2.3197	<sqlalchemy/sql/elements.py:285(_execute_on_connection)>
3	0.081	0.0270	6.95	2.3167	<sqlalchemy/engine/base.py:1056(_execute_clauseelement)>
1	0.013	0.0130	5.643	5.6430	<jacwud_dev/modules/mediacenter/model/mediacenter.py:529(get_all_active)>
1	0.015	0.0150	5.102	5.1020	<jacwud_dev/modules/mediacenter/model/mediacenter.py:81(get_first_n_active_sort_desc)>
3	0.014	0.0047	4.326	1.4420	<string>:1(<lambda>)
3	0.01	0.0033	4.312	1.4373	<sqlalchemy/sql/elements.py:399(compile)>
3	0.015	0.0050	4.302	1.4340	<sqlalchemy/sql/elements.py:464(_compiler)>
3	0.049	0.0163	4.287	1.4290	<sqlalchemy/sql/compiler.py:500(__init__)>
3	0.016	0.0053	4.228	1.4093	<sqlalchemy/sql/compiler.py:274(__init__)>
5/3	0.015	0.0030	4.212	1.4040	<sqlalchemy/sql/compiler.py:349(process)>
106/3	0.348	0.0033	4.202	1.4007	<sqlalchemy/sql/visitors.py:85(_compiler_dispatch)>
3	0.12	0.0400	4.187	1.3957	<sqlalchemy/sql/compiler.py:2001(visit_select)>
1	0.014	0.0140	3.364	3.3640	<jacwud_dev/modules/mediacenter/model/mediacenter.py:78(get_first_n_sort_desc)>
48	0.381	0.0079	2.867	0.0597	<sqlalchemy/sql/compiler.py:1763(_label_select_column)>
17	0.076	0.0045	2.742	0.1613	<sqlalchemy/orm/loading.py:35(instances)>
3	0.099	0.0330	2.441	0.8137	<sqlalchemy/engine/base.py:1163(_execute_context)>
48	0.451	0.0094	2.031	0.0423	<sqlalchemy/sql/compiler.py:780(visit_label)>
14	1.645	0.1175	1.962	0.1401	<sqlalchemy/orm/loading.py:492(_instance)>
4	0.027	0.0067	1.898	0.4745	<sqlalchemy/util/deprecations.py:117(warned)>
3	0.05	0.0167	1.687	0.5623	<sqlalchemy/orm/query.py:3828(_compile_context)>
4	0.023	0.0057	1.481	0.3702	<sqlalchemy/orm/scoping.py:161(do)>
4	0.011	0.0027	1.13	0.2825	<sqlalchemy/util/_collections.py:1043(__call__)>
1	0.017	0.0170	1.119	1.1190	<sqlalchemy/orm/session.py:3196(__call__)>
1	0.027	0.0270	1.073	1.0730	<sqlalchemy/orm/session.py:646(__init__)>
3	0.01	0.0033	1.044	0.3480	<sqlalchemy/engine/default.py:549(do_execute)>
3	1.034	0.3447	1.034	0.3447	{method 'execute' of 'psycopg2.extensions.cursor' objects}
1	0.059	0.0590	0.949	0.9490	<sqlalchemy/orm/deprecated_interfaces.py:352(_adapt_listener)>
3	0.054	0.0180	0.91	0.3033	<sqlalchemy/orm/query.py:3953(_simple_statement)>
3	0.017	0.0057	0.844	0.2813	<string>:1(select)
52	0.412	0.0079	0.829	0.0159	<sqlalchemy/sql/compiler.py:834(visit_column)>
3	0.02	0.0067	0.827	0.2757	<string>:1(__init__)
3	0.198	0.0660	0.791	0.2637	<sqlalchemy/sql/selectable.py:2691(__init__)>
6	0.024	0.0040	0.783	0.1305	<sqlalchemy/event/api.py:34(listen)>
6	0.077	0.0128	0.652	0.1087	<sqlalchemy/event/registry.py:193(listen)>
3	0.03	0.0100	0.62	0.2067	<sqlalchemy/orm/query.py:4194(setup_context)>
3	0.105	0.0350	0.587	0.1957	<sqlalchemy/orm/loading.py:287(_setup_entity_query)>
3	0.016	0.0053	0.551	0.1837	<sqlalchemy/dialects/postgresql/psycopg2.py:527(get_result_proxy)>
3	0.014	0.0047	0.529	0.1763	<sqlalchemy/engine/result.py:714(__init__)>
325/310	0.412	0.0013	0.517	0.0017	{getattr}
3	0.021	0.0070	0.515	0.1717	<sqlalchemy/engine/result.py:740(_init_metadata)>
3	0.12	0.0400	0.491	0.1637	<sqlalchemy/engine/result.py:215(__init__)>
15	0.046	0.0031	0.49	0.0327	<sqlalchemy/util/langhelpers.py:852(__get__)>
10	0.069	0.0069	0.49	0.0490	<sqlalchemy/event/attr.py:291(__call__)>
3	0.027	0.0090	0.469	0.1563	<sqlalchemy/orm/query.py:4159(row_processor)>
52	0.168	0.0032	0.453	0.0087	<sqlalchemy/orm/interfaces.py:546(setup)>
416	0.378	0.0009	0.441	0.0011	{isinstance}
3	0.062	0.0207	0.439	0.1463	<sqlalchemy/sql/compiler.py:2188(_compose_select_body)>
3	0.193	0.0643	0.437	0.1457	<sqlalchemy/orm/loading.py:337(_instance_processor)>
3	0.013	0.0043	0.412	0.1373	<sqlalchemy/orm/query.py:3359(_get_bind_args)>
155	0.251	0.0016	0.402	0.0026	<sqlalchemy/sql/compiler.py:3541(quote)>
2	0.021	0.0105	0.386	0.1930	<sqlalchemy/orm/query.py:1769(filter_by)>
3	0.053	0.0177	0.375	0.1250	<sqlalchemy/sql/selectable.py:3657(_columns_plus_names)>
3	0.012	0.0040	0.368	0.1227	<sqlalchemy/orm/query.py:3338(_connection_from_session)>
3	0.026	0.0087	0.359	0.1197	<sqlalchemy/sql/compiler.py:2159(_setup_select_stack)>
3	0.013	0.0043	0.356	0.1187	<sqlalchemy/orm/session.py:1048(connection)>
3	0.007	0.0023	0.331	0.1103	<sqlalchemy/orm/session.py:1127(_connection_for_bind)>
6	0.018	0.0030	0.327	0.0545	<sqlalchemy/event/base.py:243(_listen)>
3	0.099	0.0330	0.326	0.1087	<sqlalchemy/engine/result.py:334(_merge_cursor_description)>
3	0.02	0.0067	0.324	0.1080	<sqlalchemy/orm/session.py:407(_connection_for_bind)>
3	0.019	0.0063	0.321	0.1070	<sqlalchemy/orm/session.py:1540(query)>
10/6	0.045	0.0045	0.32	0.0533	<sqlalchemy/sql/visitors.py:97(_compiler_dispatch)>
3	0.031	0.0103	0.317	0.1057	<sqlalchemy/sql/selectable.py:2992(_get_display_froms)>
6	0.026	0.0043	0.309	0.0515	<sqlalchemy/event/registry.py:243(base_listen)>
3	0.008	0.0027	0.302	0.1007	<sqlalchemy/orm/query.py:141(__init__)>
3	0.072	0.0240	0.298	0.0993	<tgext/debugbar/sections/sqla.py:42(_after_cursor_execute)>
3	0.028	0.0093	0.294	0.0980	<sqlalchemy/orm/query.py:170(_set_entities)>
3	0.148	0.0493	0.283	0.0943	<sqlalchemy/sql/selectable.py:2963(_froms)>
50	0.152	0.0030	0.265	0.0053	<sqlalchemy/sql/compiler.py:1544(_truncated_identifier)>
3	0.026	0.0087	0.257	0.0857	<sqlalchemy/sql/selectable.py:2124(__init__)>
3	0.09	0.0300	0.248	0.0827	<sqlalchemy/engine/default.py:636(_init_compiled)>
8/2	0.032	0.0040	0.236	0.1180	<sqlalchemy/sql/operators.py:358(__eq__)>
48	0.085	0.0018	0.224	0.0047	<sqlalchemy/engine/default.py:1049(get_result_processor)>
2	0.006	0.0030	0.22	0.1100	<sqlalchemy/orm/attributes.py:216(operate)>
6/2	0.017	0.0028	0.214	0.1070	{operator.eq}
6	0.036	0.0060	0.212	0.0353	<sqlalchemy/orm/base.py:215(generate)>
2	0.009	0.0045	0.203	0.1015	<sqlalchemy/orm/properties.py:314(operate)>
48	0.084	0.0017	0.193	0.0040	<sqlalchemy/sql/compiler.py:3610(format_label)>
9	0.094	0.0104	0.187	0.0208	<sqlalchemy/util/_collections.py:755(unique_list)>
2	0.015	0.0075	0.186	0.0930	<sqlalchemy/sql/annotation.py:102(__eq__)>
50	0.115	0.0023	0.179	0.0036	<sqlalchemy/sql/type_api.py:440(dialect_impl)>
6	0.011	0.0018	0.179	0.0298	<sqlalchemy/event/attr.py:374(append)>
1	0.009	0.0090	0.175	0.1750	<sqlalchemy/engine/base.py:2223(_contextual_connect)>
6	0.027	0.0045	0.168	0.0280	<sqlalchemy/event/registry.py:264(append_to_list)>
48	0.11	0.0023	0.165	0.0034	<sqlalchemy/sql/selectable.py:3662(name_for_col)>
2	0.005	0.0025	0.164	0.0820	<sqlalchemy/sql/elements.py:723(operate)>
56	0.16	0.0029	0.16	0.0029	<sqlalchemy/orm/interfaces.py:516(_get_context_loader)>
208	0.144	0.0007	0.144	0.0007	{method 'append' of 'list' objects}
2	0.012	0.0060	0.142	0.0710	<sqlalchemy/sql/type_api.py:64(operate)>
9	0.045	0.0050	0.141	0.0157	<sqlalchemy/util/_collections.py:802(to_list)>
48	0.089	0.0019	0.139	0.0029	<sqlalchemy/sql/type_api.py:483(_cached_result_processor)>
48	0.073	0.0015	0.138	0.0029	<sqlalchemy/engine/result.py:724(_getter)>
48	0.108	0.0022	0.134	0.0028	<sqlalchemy/orm/strategies.py:173(setup_query)>
6	0.041	0.0068	0.134	0.0223	<sqlalchemy/event/registry.py:67(_stored_in_collection)>
2	0.005	0.0025	0.133	0.0665	<string>:1(order_by)
2	0.02	0.0100	0.13	0.0650	<sqlalchemy/sql/default_comparator.py:41(_boolean_compare)>
2	0.006	0.0030	0.13	0.0650	<sqlalchemy/sql/compiler.py:2285(order_by_clause)>
111	0.129	0.0012	0.129	0.0012	<weakref.py:362(__getitem__)>
6	0.012	0.0020	0.129	0.0215	<sqlalchemy/event/attr.py:208(_adjust_fn_spec)>
3	0.015	0.0050	0.129	0.0430	<sqlalchemy/engine/result.py:1195(fetchall)>
8	0.022	0.0027	0.121	0.0151	{method 'join' of 'str' objects}
6	0.016	0.0027	0.117	0.0195	<sqlalchemy/event/attr.py:98(_adjust_fn_spec)>
48	0.086	0.0018	0.115	0.0024	<sqlalchemy/sql/elements.py:4571(_interpret_as_column_or_from)>
48	0.079	0.0016	0.115	0.0024	<sqlalchemy/sql/compiler.py:1760(_add_to_result_map)>
2	0.008	0.0040	0.113	0.0565	<sqlalchemy/sql/compiler.py:963(visit_clauselist)>
4	0.03	0.0075	0.112	0.0280	<sqlalchemy/sql/elements.py:4433(_literal_as_label_reference)>
25	0.05	0.0020	0.11	0.0044	{hasattr}
6	0.025	0.0042	0.107	0.0178	<sqlalchemy/event/api.py:23(_event_key)>
9	0.018	0.0020	0.107	0.0119	<tg/request_local.py:232(_current_obj)>
3	0.026	0.0087	0.105	0.0350	<sqlalchemy/orm/query.py:202(_set_entity_selectables)>
2	0.017	0.0085	0.105	0.0525	<sqlalchemy/sql/selectable.py:81(_offset_or_limit_clause)>
11	0.047	0.0043	0.102	0.0093	<sqlalchemy/orm/instrumentation.py:340(new_instance)>
2	0.025	0.0125	0.102	0.0510	<sqlalchemy/sql/elements.py:1861(__init__)>
2	0.009	0.0045	0.102	0.0510	<sqlalchemy/orm/query.py:1800(order_by)>
2	0.007	0.0035	0.101	0.0505	<sqlalchemy/dialects/postgresql/base.py:1643(limit_clause)>
17	0.037	0.0022	0.101	0.0059	<sqlalchemy/inspection.py:38(inspect)>
6	0.028	0.0047	0.1	0.0167	<sqlalchemy/event/attr.py:234(for_modify)>
4	0.009	0.0023	0.099	0.0247	<sqlalchemy/sql/compiler.py:970(<genexpr>)>
3	0.016	0.0053	0.099	0.0330	<sqlalchemy/orm/query.py:4045(__new__)>
114	0.097	0.0009	0.097	0.0009	{method 'add' of 'set' objects}
1	0.002	0.0020	0.093	0.0930	<sqlalchemy/engine/base.py:2259(_wrap_pool_connect)>
2	0.023	0.0115	0.092	0.0460	<sqlalchemy/orm/query.py:310(_adapt_col_list)>
2	0.012	0.0060	0.092	0.0460	<sqlalchemy/sql/compiler.py:1263(visit_binary)>
1	0.005	0.0050	0.091	0.0910	<sqlalchemy/pool/base.py:354(connect)>
57	0.09	0.0016	0.09	0.0016	{method 'update' of 'dict' objects}
4	0.008	0.0020	0.09	0.0225	<sqlalchemy/sql/compiler.py:972(<genexpr>)>
12/9	0.041	0.0034	0.088	0.0098	<tg/support/objectproxy.py:18(__getattr__)>
2	0.024	0.0120	0.087	0.0435	<sqlalchemy/util/langhelpers.py:327(get_callable_argspec)>
12	0.018	0.0015	0.086	0.0072	<sqlalchemy/sql/elements.py:4479(_literal_as_text)>
1	0.009	0.0090	0.086	0.0860	<sqlalchemy/pool/base.py:757(_checkout)>
3	0.048	0.0160	0.081	0.0270	<sqlalchemy/sql/elements.py:4352(_select_iterables)>
2	0.033	0.0165	0.081	0.0405	<sqlalchemy/sql/elements.py:908(__init__)>
3	0.008	0.0027	0.08	0.0267	<sqlalchemy/engine/result.py:1161(_fetchall_impl)>
2	0.006	0.0030	0.079	0.0395	<string>:1(desc)
2	0.016	0.0080	0.078	0.0390	<sqlalchemy/sql/compiler.py:1447(visit_bindparam)>
4	0.013	0.0032	0.077	0.0192	<sqlalchemy/sql/annotation.py:78(_compiler_dispatch)>
3	0.026	0.0087	0.077	0.0257	<sqlalchemy/orm/base.py:346(_is_mapped_class)>
1	0.013	0.0130	0.076	0.0760	<sqlalchemy/pool/base.py:490(checkout)>
6	0.031	0.0052	0.075	0.0125	<sqlalchemy/event/base.py:266(__getattr__)>
2	0.021	0.0105	0.073	0.0365	<sqlalchemy/sql/compiler.py:1178(visit_unary)>
1	0.017	0.0170	0.073	0.0730	<sqlalchemy/engine/base.py:69(__init__)>
2	0.011	0.0055	0.073	0.0365	<sqlalchemy/sql/elements.py:2746(_create_desc)>
3	0.072	0.0240	0.072	0.0240	{method 'fetchall' of 'psycopg2.extensions.cursor' objects}
2	0.015	0.0075	0.071	0.0355	<sqlalchemy/sql/compiler.py:1320(_generate_generic_binary)>
6	0.044	0.0073	0.071	0.0118	<sqlalchemy/util/langhelpers.py:925(__getattr__)>
5	0.017	0.0034	0.07	0.0140	<sqlalchemy/event/base.py:295(__get__)>
44/41	0.039	0.0009	0.07	0.0017	{setattr}
28	0.045	0.0016	0.07	0.0025	<sqlalchemy/event/attr.py:264(__iter__)>
12	0.041	0.0034	0.068	0.0057	<sqlalchemy/sql/elements.py:4463(_literal_as)>
74	0.068	0.0009	0.068	0.0009	{len}
2	0.005	0.0025	0.067	0.0335	<string>:1(filter)
48	0.065	0.0014	0.065	0.0014	<sqlalchemy/engine/result.py:643(_getter)>
6	0.052	0.0087	0.064	0.0107	<sqlalchemy/event/attr.py:330(__init__)>
3	0.015	0.0050	0.064	0.0213	<sqlalchemy/util/_collections.py:361(__init__)>
6	0.013	0.0022	0.064	0.0107	<sqlalchemy/ext/declarative/api.py:815(_inspect_decl_meta)>
9	0.038	0.0042	0.063	0.0070	<abc.py:128(__instancecheck__)>
1	0.004	0.0040	0.061	0.0610	<sqlalchemy/engine/base.py:596(begin)>
2	0.022	0.0110	0.059	0.0295	<sqlalchemy/sql/elements.py:3063(__init__)>
1	0.004	0.0040	0.059	0.0590	<zope/sqlalchemy/datamanager.py:245(after_begin)>
4	0.036	0.0090	0.058	0.0145	<sqlalchemy/sql/elements.py:714(__getattr__)>
1	0.018	0.0180	0.057	0.0570	<sqlalchemy/engine/base.py:1737(__init__)>
2	0.014	0.0070	0.057	0.0285	<sqlalchemy/sql/elements.py:4443(_literal_and_labels_as_label_reference)>
3	0.013	0.0043	0.057	0.0190	<sqlalchemy/engine/default.py:1032(create_cursor)>
1	0.007	0.0070	0.055	0.0550	<zope/sqlalchemy/datamanager.py:202(join_transaction)>
58	0.054	0.0009	0.054	0.0009	{id}
5	0.011	0.0022	0.053	0.0106	<sqlalchemy/event/base.py:119(_for_instance)>
48	0.052	0.0011	0.052	0.0011	<sqlalchemy/sql/elements.py:3939(_get_table)>
1	0.005	0.0050	0.051	0.0510	<sqlalchemy/orm/session.py:884(begin)>
53	0.051	0.0010	0.051	0.0010	{method 'update' of 'set' objects}
6	0.019	0.0032	0.051	0.0085	<sqlalchemy/orm/base.py:409(_inspect_mapped_class)>
8	0.034	0.0043	0.051	0.0064	<sqlalchemy/event/registry.py:154(__init__)>
48	0.05	0.0010	0.05	0.0010	<sqlalchemy/sql/compiler.py:410(__init__)>
2	0.007	0.0035	0.05	0.0250	<sqlalchemy/sql/compiler.py:1531(_truncate_bindparam)>
17	0.036	0.0021	0.05	0.0029	<sqlalchemy/event/base.py:94(__getattr__)>
11	0.048	0.0044	0.048	0.0044	<sqlalchemy/orm/loading.py:677(_populate_full)>
1	0.005	0.0050	0.047	0.0470	<sqlalchemy/pool/impl.py:112(_do_get)>
1	0.01	0.0100	0.046	0.0460	<sqlalchemy/orm/session.py:220(__init__)>
3	0.032	0.0107	0.046	0.0153	<sqlalchemy/orm/state.py:685(unloaded)>
8	0.038	0.0047	0.046	0.0057	<sqlalchemy/sql/base.py:38(_from_objects)>
4	0.02	0.0050	0.044	0.0110	<sqlalchemy/util/langhelpers.py:1157(_next)>
2	0.006	0.0030	0.043	0.0215	<sqlalchemy/sql/compiler.py:1344(_generate_generic_unary_modifier)>
48	0.043	0.0009	0.043	0.0009	<sqlalchemy/sql/compiler.py:419(type)>
56	0.043	0.0008	0.043	0.0008	{method 'intersection' of 'set' objects}
6	0.023	0.0038	0.043	0.0072	<sqlalchemy/orm/events.py:1235(_accept_with)>
2	0.02	0.0100	0.043	0.0215	<sqlalchemy/util/compat.py:60(inspect_getfullargspec)>
3	0.026	0.0087	0.043	0.0143	<sqlalchemy/orm/query.py:4079(setup_entity)>
2	0.012	0.0060	0.042	0.0210	<sqlalchemy/orm/base.py:379(_entity_descriptor)>
1	0.012	0.0120	0.042	0.0420	<sqlalchemy/util/queue.py:135(get)>
5	0.015	0.0030	0.042	0.0084	<sqlalchemy/event/base.py:116(_for_class)>
11	0.039	0.0035	0.039	0.0035	{method 'issuperset' of 'frozenset' objects}
3	0.015	0.0050	0.039	0.0130	<sqlalchemy/sql/compiler.py:620(_bind_processors)>
6	0.013	0.0022	0.038	0.0063	<sqlalchemy/util/deprecations.py:21(warn_deprecated)>
14	0.025	0.0018	0.038	0.0027	<sqlalchemy/event/attr.py:400(listeners)>
3	0.014	0.0047	0.038	0.0127	<webob/request.py:1399(__setattr__)>
2	0.011	0.0055	0.037	0.0185	<sqlalchemy/sql/elements.py:4196(__new__)>
3	0.019	0.0063	0.037	0.0123	<sqlalchemy/events.py:622(wrap_before_cursor_execute)>
1	0.013	0.0130	0.037	0.0370	<sqlalchemy/engine/base.py:713(_begin_impl)>
10	0.022	0.0022	0.036	0.0036	<sqlalchemy/util/langhelpers.py:750(methods_equivalent)>
4	0.016	0.0040	0.035	0.0087	<sqlalchemy/orm/interfaces.py:556(create_row_processor)>
3	0.03	0.0100	0.035	0.0117	<sqlalchemy/orm/query.py:4650(__init__)>
6	0.017	0.0028	0.034	0.0057	<sqlalchemy/event/attr.py:302(__iter__)>
48	0.034	0.0007	0.034	0.0007	<sqlalchemy/sql/elements.py:4204(apply_map)>
1	0.015	0.0150	0.033	0.0330	<sqlalchemy/orm/session.py:337(_take_snapshot)>
48	0.033	0.0007	0.033	0.0007	<sqlalchemy/sql/elements.py:748(_select_iterable)>
3	0.011	0.0037	0.033	0.0110	<sqlalchemy/pool/base.py:958(cursor)>
3	0.008	0.0027	0.033	0.0110	<tg/support/objectproxy.py:21(__setattr__)>
7	0.032	0.0046	0.032	0.0046	{_warnings.warn}
5	0.013	0.0026	0.032	0.0064	<sqlalchemy/orm/session.py:2425(flush)>
1	0.014	0.0140	0.032	0.0320	<zope/sqlalchemy/datamanager.py:73(__init__)>
2	0.009	0.0045	0.031	0.0155	<sqlalchemy/sql/elements.py:4311(apply_map)>
6	0.014	0.0023	0.031	0.0052	<sqlalchemy/event/registry.py:169(with_wrapper)>
6	0.009	0.0015	0.031	0.0052	<sqlalchemy/sql/selectable.py:2918(<genexpr>)>
3	0.015	0.0050	0.031	0.0103	<sqlalchemy/orm/query.py:399(_bind_mapper)>
6	0.018	0.0030	0.03	0.0050	<sqlalchemy/orm/query.py:518(_clone)>
3	0.01	0.0033	0.029	0.0097	<sqlalchemy/orm/path_registry.py:63(set)>
2	0.014	0.0070	0.029	0.0145	<sqlalchemy/orm/query.py:1734(filter)>
31	0.028	0.0009	0.028	0.0009	{iter}
5	0.018	0.0036	0.027	0.0054	<sqlalchemy/event/base.py:77(__init__)>
1	0.021	0.0210	0.027	0.0270	<sqlalchemy/orm/instrumentation.py:358(_new_state_if_none)>
30	0.026	0.0009	0.026	0.0009	{built-in method __new__ of type object at 0x7fb578bef3c0}
12	0.026	0.0022	0.026	0.0022	<string>:1(set)
6	0.015	0.0025	0.025	0.0042	<sqlalchemy/orm/base.py:228(manager_of_class)>
2	0.003	0.0015	0.025	0.0125	<string>:1(limit)
2	0.005	0.0025	0.025	0.0125	<sqlalchemy/sql/elements.py:3124(self_group)>
3	0.018	0.0060	0.025	0.0083	<sqlalchemy/orm/state.py:771(_commit)>
3	0.018	0.0060	0.024	0.0080	<sqlalchemy/orm/query.py:3983(_adjust_for_single_inheritance)>
12	0.024	0.0020	0.024	0.0020	<sqlalchemy/orm/state.py:89(__init__)>
2	0.019	0.0095	0.024	0.0120	<sqlalchemy/sql/elements.py:4151(__new__)>
3	0.007	0.0023	0.024	0.0080	<sqlalchemy/sql/compiler.py:623(<genexpr>)>
3	0.005	0.0017	0.024	0.0080	<sqlalchemy/orm/session.py:1574(_autoflush)>
3	0.011	0.0037	0.022	0.0073	<sqlalchemy/engine/result.py:869(_soft_close)>
2	0.004	0.0020	0.022	0.0110	<sqlalchemy/util/_collections.py:733(__missing__)>
3	0.015	0.0050	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}
5	0.014	0.0028	0.021	0.0042	<logging/__init__.py:1367(isEnabledFor)>
4	0.019	0.0047	0.021	0.0052	<sqlalchemy/sql/type_api.py:1430(to_instance)>
13	0.021	0.0016	0.021	0.0016	<sqlalchemy/event/attr.py:267(__bool__)>
24	0.02	0.0008	0.02	0.0008	<sqlalchemy/event/registry.py:260(_listen_fn)>
2	0.009	0.0045	0.02	0.0100	<sqlalchemy/sql/operators.py:1486(is_precedent)>
3	0.019	0.0063	0.019	0.0063	<sqlalchemy/sql/compiler.py:641(construct_params)>
5	0.011	0.0022	0.019	0.0038	<sqlalchemy/orm/session.py:2471(_is_clean)>
3	0.006	0.0020	0.019	0.0063	<logging/__init__.py:1152(debug)>
4	0.011	0.0027	0.019	0.0047	<sqlalchemy/sql/operators.py:1399(is_boolean)>
5	0.018	0.0036	0.018	0.0036	{method 'acquire' of 'thread.lock' objects}
1	0.008	0.0080	0.018	0.0180	<sqlalchemy/orm/state.py:431(_initialize_instance)>
4	0.011	0.0027	0.018	0.0045	<sqlalchemy/sql/compiler.py:1170(_get_operator_dispatch)>
2	0.009	0.0045	0.018	0.0090	<sqlalchemy/orm/query.py:396(_joinpoint_zero)>
3	0.012	0.0040	0.018	0.0060	<tgext/debugbar/sections/sqla.py:39(_before_cursor_execute)>
2	0.014	0.0070	0.018	0.0090	<sqlalchemy/sql/compiler.py:1566(_process_anon)>
5	0.013	0.0026	0.018	0.0036	<sqlalchemy/orm/query.py:379(_entity_zero)>
10	0.018	0.0018	0.018	0.0018	<_weakrefset.py:70(__contains__)>
6	0.017	0.0028	0.017	0.0028	<sqlalchemy/orm/state.py:379(_cleanup)>
23	0.017	0.0007	0.017	0.0007	{method 'pop' of 'dict' objects}
5	0.01	0.0020	0.017	0.0034	<sqlalchemy/sql/compiler.py:625(<genexpr>)>
2	0.011	0.0055	0.017	0.0085	<sqlalchemy/sql/elements.py:2641(__init__)>
14	0.016	0.0011	0.016	0.0011	<sqlalchemy/orm/identity.py:163(get)>
1	0.015	0.0150	0.016	0.0160	<weakref.py:390(get)>
6	0.012	0.0020	0.016	0.0027	<sqlalchemy/event/registry.py:165(_key)>
24	0.016	0.0007	0.016	0.0007	{method 'get' of 'dict' objects}
4	0.011	0.0027	0.015	0.0037	<string>:8(__new__)
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	<sqlalchemy/engine/default.py:1046(post_exec)>
15	0.014	0.0009	0.014	0.0009	{method 'copy' of 'dict' objects}
3	0.005	0.0017	0.013	0.0043	<sqlalchemy/sql/compiler.py:2313(visit_table)>
11	0.013	0.0012	0.013	0.0012	<sqlalchemy/orm/identity.py:158(_add_unpresent)>
6	0.013	0.0022	0.013	0.0022	<sqlalchemy/sql/elements.py:681(self_group)>
9	0.012	0.0013	0.012	0.0013	<tg/support/registry.py:52(_current_obj)>
3	0.012	0.0040	0.012	0.0040	{method 'encode' of 'unicode' objects}
3	0.01	0.0033	0.012	0.0040	<sqlalchemy/engine/default.py:945(should_autocommit)>
3	0.008	0.0027	0.012	0.0040	<sqlalchemy/orm/session.py:1417(get_bind)>
1	0.005	0.0050	0.012	0.0120	<weakref.py:115(__setitem__)>
3	0.012	0.0040	0.012	0.0040	<sqlalchemy/engine/result.py:1178(process_rows)>
16	0.011	0.0007	0.011	0.0007	<sqlalchemy/orm/mapper.py:731(mapper)>
3	0.007	0.0023	0.011	0.0037	<sqlalchemy/engine/base.py:1327(_safe_close_cursor)>
3	0.008	0.0027	0.011	0.0037	<sqlalchemy/orm/query.py:4067(__init__)>
2	0.003	0.0015	0.011	0.0055	<sqlalchemy/sql/elements.py:4459(_expression_literal_as_text)>
5	0.008	0.0016	0.011	0.0022	<sqlalchemy/engine/default.py:727(<genexpr>)>
3	0.011	0.0037	0.011	0.0037	<sqlalchemy/orm/loading.py:734(_populate_partial)>
3	0.009	0.0030	0.011	0.0037	<sqlalchemy/engine/default.py:1000(_use_server_side_cursor)>
1	0.007	0.0070	0.01	0.0100	<threading.py:147(acquire)>
3	0.01	0.0033	0.01	0.0033	<sqlalchemy/orm/query.py:3470(_select_args)>
2	0.007	0.0035	0.01	0.0050	<sqlalchemy/sql/elements.py:702(comparator)>
9	0.01	0.0011	0.01	0.0011	{method 'startswith' of 'str' objects}
6	0.01	0.0017	0.01	0.0017	{method 'get' of 'dictproxy' objects}
3	0.008	0.0027	0.01	0.0033	<sqlalchemy/orm/loading.py:880(for_context)>
1	0.005	0.0050	0.01	0.0100	<transaction/_transaction.py:176(join)>
1	0.005	0.0050	0.009	0.0090	<threading.py:373(notify)>
4	0.009	0.0023	0.009	0.0023	<weakref.py:330(__init__)>
4	0.006	0.0015	0.009	0.0023	<inspect.py:67(ismethod)>
6	0.009	0.0015	0.009	0.0015	{method 'difference' of 'set' objects}
7	0.009	0.0013	0.009	0.0013	{time.time}
6	0.008	0.0013	0.008	0.0013	<sqlalchemy/orm/query.py:4139(_get_entity_clauses)>
5	0.008	0.0016	0.008	0.0016	<sqlalchemy/orm/identity.py:56(check_modified)>
6	0.008	0.0013	0.008	0.0013	<sqlalchemy/event/attr.py:393(__init__)>
6	0.008	0.0013	0.008	0.0013	<sqlalchemy/orm/query.py:474(_no_statement_condition)>
2	0.006	0.0030	0.008	0.0040	<sqlalchemy/sql/elements.py:4595(_const_expr)>
6	0.008	0.0013	0.008	0.0013	<weakref.py:400(__contains__)>
4	0.006	0.0015	0.008	0.0020	<inspect.py:142(isfunction)>
4	0.006	0.0015	0.008	0.0020	<sqlalchemy/sql/operators.py:1376(is_comparison)>
2	0.006	0.0030	0.007	0.0035	<sqlalchemy/orm/attributes.py:179(__clause_element__)>
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)>
2	0.005	0.0025	0.007	0.0035	<sqlalchemy/sql/type_api.py:473(_cached_bind_processor)>
6	0.007	0.0012	0.007	0.0012	{method 'items' of 'dict' objects}
1	0.006	0.0060	0.007	0.0070	<sqlalchemy/pool/base.py:589(get_connection)>
3	0.007	0.0023	0.007	0.0023	<webob/request.py:1406(__getattr__)>
6	0.007	0.0012	0.007	0.0012	<sqlalchemy/orm/instrumentation.py:102(is_mapped)>
2	0.005	0.0025	0.007	0.0035	<inspect.py:226(isbuiltin)>
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)>
1	0.003	0.0030	0.007	0.0070	<sqlalchemy/log.py:59(_should_log_info)>
3	0.004	0.0013	0.007	0.0023	<sqlalchemy/util/_collections.py:396(__iter__)>
5	0.007	0.0014	0.007	0.0014	<logging/__init__.py:1353(getEffectiveLevel)>
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/query.py:326(_adapt_clause)>
3	0.006	0.0020	0.006	0.0020	<sqlalchemy/dialects/postgresql/psycopg2.py:535(_log_notices)>
2	0.006	0.0030	0.006	0.0030	<sqlalchemy/sql/compiler.py:1572(bindparam_string)>
1	0.004	0.0040	0.006	0.0060	<threading.py:187(release)>
3	0.006	0.0020	0.006	0.0020	<sqlalchemy/orm/path_registry.py:71(get)>
4	0.006	0.0015	0.006	0.0015	<sqlalchemy/orm/strategies.py:884(create_row_processor)>
3	0.006	0.0020	0.006	0.0020	{zip}
4	0.005	0.0012	0.005	0.0012	<sqlalchemy/orm/query.py:486(_no_limit_offset)>
3	0.005	0.0017	0.005	0.0017	<sqlalchemy/util/_collections.py:730(__init__)>
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/sql/elements.py:2871(_order_by_label_element)>
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.cutils._distill_params}
6	0.005	0.0008	0.005	0.0008	{method 'values' of 'dict' objects}
6	0.005	0.0008	0.005	0.0008	<sqlalchemy/event/base.py:112(_listen)>
5	0.005	0.0010	0.005	0.0010	{method 'release' of 'thread.lock' objects}
2	0.005	0.0025	0.005	0.0025	<sqlalchemy/sql/elements.py:3095(_from_objects)>
3	0.005	0.0017	0.005	0.0017	<sqlalchemy/orm/state.py:412(dict)>
4	0.004	0.0010	0.004	0.0010	<sqlalchemy/orm/interfaces.py:744(setup_query)>
2	0.004	0.0020	0.004	0.0020	{method 'split' of 'unicode' objects}
3	0.004	0.0013	0.004	0.0013	<sqlalchemy/dialects/postgresql/base.py:1658(get_select_precolumns)>
1	0.004	0.0040	0.004	0.0040	<sqlalchemy/orm/identity.py:17(__init__)>
1	0.004	0.0040	0.004	0.0040	<weakref.py:310(__new__)>
1	0.003	0.0030	0.004	0.0040	<transaction/_transaction.py:50(myhasattr)>
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/orm/session.py:267(_assert_active)>
2	0.003	0.0015	0.004	0.0020	<inspect.py:208(iscode)>
8	0.004	0.0005	0.004	0.0005	{method 'setdefault' of 'dict' objects}
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	{method 'close' of 'psycopg2.extensions.cursor' objects}
1	0.003	0.0030	0.004	0.0040	<sqlalchemy/util/queue.py:203(_get)>
1	0.003	0.0030	0.004	0.0040	<sqlalchemy/orm/mapper.py:3344(_event_on_init)>
4	0.004	0.0010	0.004	0.0010	<sqlalchemy/orm/attributes.py:274(__get__)>
1	0.003	0.0030	0.004	0.0040	<sqlalchemy/engine/default.py:941(no_parameters)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/base.py:370(connection)>
3	0.003	0.0010	0.003	0.0010	{delattr}
2	0.003	0.0015	0.003	0.0015	{_codecs.utf_8_encode}
3	0.003	0.0010	0.003	0.0010	<threading.py:64(_note)>
3	0.003	0.0010	0.003	0.0010	{method 'union' of 'set' objects}
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/orm/mapper.py:2263(selectable)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/engine/result.py:864(_cursor_description)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/sql/type_api.py:60(__init__)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/orm/query.py:4684(<genexpr>)>
1	0.003	0.0030	0.003	0.0030	<weakref.py:315(__init__)>
2	0.003	0.0015	0.003	0.0015	<sqlalchemy/util/langhelpers.py:1111(asint)>
4	0.003	0.0008	0.003	0.0008	<sqlalchemy/util/langhelpers.py:938(memo)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/sql/selectable.py:1937(_from_objects)>
4	0.003	0.0008	0.003	0.0008	{next}
1	0.003	0.0030	0.003	0.0030	<threading.py:238(_is_owned)>
3	0.003	0.0010	0.003	0.0010	<sqlalchemy/sql/elements.py:4344(_expand_cloned)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/orm/query.py:3061(limit)>
3	0.002	0.0007	0.002	0.0007	<sqlalchemy/engine/default.py:1043(pre_exec)>
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 'keys' of 'dict' objects}
2	0.002	0.0010	0.002	0.0010	{callable}
3	0.002	0.0007	0.002	0.0007	<sqlalchemy/sql/compiler.py:352(__str__)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/orm/session.py:319(_iterate_self_and_parents)>
1	0.002	0.0020	0.002	0.0020	<sqlalchemy/event/base.py:261(__init__)>
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)>
2	0.002	0.0010	0.002	0.0010	<sqlalchemy/sql/compiler.py:951(visit_true)>
6	0.002	0.0003	0.002	0.0003	{method 'append' of 'collections.deque' objects}
1	0.001	0.0010	0.001	0.0010	{method 'popleft' of 'collections.deque' objects}
3	0.001	0.0003	0.001	0.0003	<sqlalchemy/sql/selectable.py:143(selectable)>
3	0.001	0.0003	0.001	0.0003	{method 'difference_update' of 'set' objects}
1	0.001	0.0010	0.001	0.0010	<weakref.py:368(__setitem__)>
3	0.001	0.0003	0.001	0.0003	<sqlalchemy/util/_collections.py:151(union)>
3	0.001	0.0003	0.001	0.0003	{thread.get_ident}
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/event/attr.py:255(__call__)>
1	0.001	0.0010	0.001	0.0010	<sqlalchemy/pool/base.py:724(__init__)>
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	'Tue, 06 Dec 2022 03:05:57 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	'44.201.94.236'
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 0x7fb572336c10>
webob._parsed_query_vars	(GET([]), '')
beaker.get_session	<bound method SessionApplicationWrapper._get_session of <tg.appwrappers.session.SessionApplicationWrapper object at 0x7fb572db1750>>
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 0x7fb57135dad0>, 'duration': 0.5700588226318359, 'engine_id': 140417281778576, '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 0x7fb571d3b450>, 'duration': 0.29587745666503906, 'engine_id': 140417281778576, '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 0x7fb571d3b190>, 'duration': 0.3299713134765625, 'engine_id': 140417281778576, '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	'Tue, 06 Dec 2022 03:05:57 GMT'
REQUEST_METHOD	'GET'
PATH_INFO	'/media/videos'
SERVER_PROTOCOL	'HTTP/1.1'
QUERY_STRING	''
repoze.who.plugins	{'cookie': <AuthTktCookiePlugin 140417281431568>, 'form': <FastFormPlugin:/login_handler 140417281487760>, 'main_identifier': <FastFormPlugin:/login_handler 140417281487760>, 'tgappauth': <tg.configuration.auth.metadata._AuthMetadataAuthenticator object at 0x7fb57234b410>}
CONTENT_LENGTH	''
HTTP_USER_AGENT	'CCBot/2.0 (https://commoncrawl.org/faq/)'
HTTP_CONNECTION	'Keep-Alive'
SERVER_NAME	'jacwud.com'
REMOTE_ADDR	'44.201.94.236'
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 0x7fb57186a710>
HTTP_HOST	'jacwud.com'
beaker.session	{'_id': '9a7ba88ebef44960a384b0588f6845a4'}
HTTPS	'on'
wsgi.multithread	False
repoze.who.logger	<logging.Logger object at 0x7fb578077d90>
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 0x7fb5713ca890>
repoze.who.api	<repoze.who.api.API object at 0x7fb5713ca790>
wsgi.run_once	False
wsgi.errors	<open file 'wsgi_errors', mode 'w' at 0x7fb5785786f0>
REMOTE_PORT	'37332'
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 0x7fb57123e850>
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	{}	0.5701 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.2959 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.3300 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

{}

0.5701 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.2959 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.3300 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