← Index
NYTProf Performance Profile   « line view »
For starman worker -M FindBin --max-requests 50 --workers 2 --user=kohadev-koha --group kohadev-koha --pid /var/run/koha/kohadev/plack.pid --daemonize --access-log /var/log/koha/kohadev/plack.log --error-log /var/log/koha/kohadev/plack-error.log -E deployment --socket /var/run/koha/kohadev/plack.sock /etc/koha/sites/kohadev/plack.psgi
  Run on Fri Jan 8 13:01:18 2016
Reported on Fri Jan 8 13:01:36 2016

Filename/home/vagrant/kohaclone/Koha/Schema/Result/Reserve.pm
StatementsExecuted 18 statements in 699µs
Subroutines
Calls P F Exclusive
Time
Inclusive
Time
Subroutine
11125µs28µsClass::C3::Componentised::::BEGIN@1.1866 Class::C3::Componentised::BEGIN@1.1866
284113µs13µsClass::C3::Componentised::::CORE:match Class::C3::Componentised::CORE:match (opcode)
11111µs72µsKoha::Schema::Result::Reserve::::BEGIN@16Koha::Schema::Result::Reserve::BEGIN@16
11110µs17µsKoha::Schema::Result::Reserve::::BEGIN@13Koha::Schema::Result::Reserve::BEGIN@13
1118µs8µsClass::C3::Componentised::::CORE:qr Class::C3::Componentised::CORE:qr (opcode)
1118µs14µsKoha::Schema::Result::Reserve::::BEGIN@14Koha::Schema::Result::Reserve::BEGIN@14
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments
Time
on line
Calls Time
in subs
Code
1267µs231µs
# spent 28µs (25+3) within Class::C3::Componentised::BEGIN@1.1866 which was called: # once (25µs+3µs) by Class::C3::Componentised::ensure_class_loaded at line 1
use utf8;
# spent 28µs making 1 call to Class::C3::Componentised::BEGIN@1.1866 # spent 3µs making 1 call to utf8::import
2package Koha::Schema::Result::Reserve;
3
4# Created by DBIx::Class::Schema::Loader
5# DO NOT MODIFY THE FIRST PART OF THIS FILE
6
7=head1 NAME
8
9Koha::Schema::Result::Reserve
10
11=cut
12
13235µs225µs
# spent 17µs (10+8) within Koha::Schema::Result::Reserve::BEGIN@13 which was called: # once (10µs+8µs) by Class::C3::Componentised::ensure_class_loaded at line 13
use strict;
# spent 17µs making 1 call to Koha::Schema::Result::Reserve::BEGIN@13 # spent 8µs making 1 call to strict::import
14235µs219µs
# spent 14µs (8+5) within Koha::Schema::Result::Reserve::BEGIN@14 which was called: # once (8µs+5µs) by Class::C3::Componentised::ensure_class_loaded at line 14
use warnings;
# spent 14µs making 1 call to Koha::Schema::Result::Reserve::BEGIN@14 # spent 5µs making 1 call to warnings::import
15
162442µs2134µs
# spent 72µs (11+61) within Koha::Schema::Result::Reserve::BEGIN@16 which was called: # once (11µs+61µs) by Class::C3::Componentised::ensure_class_loaded at line 16
use base 'DBIx::Class::Core';
# spent 72µs making 1 call to Koha::Schema::Result::Reserve::BEGIN@16 # spent 61µs making 1 call to base::import
17
18=head1 TABLE: C<reserves>
19
20=cut
21
22120µs1297µs__PACKAGE__->table("reserves");
# spent 297µs making 1 call to DBIx::Class::ResultSourceProxy::Table::table
23
24=head1 ACCESSORS
25
26=head2 reserve_id
27
28 data_type: 'integer'
29 is_auto_increment: 1
30 is_nullable: 0
31
32=head2 borrowernumber
33
34 data_type: 'integer'
35 default_value: 0
36 is_foreign_key: 1
37 is_nullable: 0
38
39=head2 reservedate
40
41 data_type: 'date'
42 datetime_undef_if_invalid: 1
43 is_nullable: 1
44
45=head2 biblionumber
46
47 data_type: 'integer'
48 default_value: 0
49 is_foreign_key: 1
50 is_nullable: 0
51
52=head2 branchcode
53
54 data_type: 'varchar'
55 is_foreign_key: 1
56 is_nullable: 1
57 size: 10
58
59=head2 notificationdate
60
61 data_type: 'date'
62 datetime_undef_if_invalid: 1
63 is_nullable: 1
64
65=head2 reminderdate
66
67 data_type: 'date'
68 datetime_undef_if_invalid: 1
69 is_nullable: 1
70
71=head2 cancellationdate
72
73 data_type: 'date'
74 datetime_undef_if_invalid: 1
75 is_nullable: 1
76
77=head2 reservenotes
78
79 data_type: 'mediumtext'
80 is_nullable: 1
81
82=head2 priority
83
84 data_type: 'smallint'
85 is_nullable: 1
86
87=head2 found
88
89 data_type: 'varchar'
90 is_nullable: 1
91 size: 1
92
93=head2 timestamp
94
95 data_type: 'timestamp'
96 datetime_undef_if_invalid: 1
97 default_value: current_timestamp
98 is_nullable: 0
99
100=head2 itemnumber
101
102 data_type: 'integer'
103 is_foreign_key: 1
104 is_nullable: 1
105
106=head2 waitingdate
107
108 data_type: 'date'
109 datetime_undef_if_invalid: 1
110 is_nullable: 1
111
112=head2 expirationdate
113
114 data_type: 'date'
115 datetime_undef_if_invalid: 1
116 is_nullable: 1
117
118=head2 lowestPriority
119
120 accessor: 'lowest_priority'
121 data_type: 'tinyint'
122 is_nullable: 0
123
124=head2 suspend
125
126 data_type: 'tinyint'
127 default_value: 0
128 is_nullable: 0
129
130=head2 suspend_until
131
132 data_type: 'datetime'
133 datetime_undef_if_invalid: 1
134 is_nullable: 1
135
136=cut
137
138132µs11.56ms__PACKAGE__->add_columns(
# spent 1.56ms making 1 call to DBIx::Class::ResultSourceProxy::add_columns
139 "reserve_id",
140 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
141 "borrowernumber",
142 {
143 data_type => "integer",
144 default_value => 0,
145 is_foreign_key => 1,
146 is_nullable => 0,
147 },
148 "reservedate",
149 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
150 "biblionumber",
151 {
152 data_type => "integer",
153 default_value => 0,
154 is_foreign_key => 1,
155 is_nullable => 0,
156 },
157 "branchcode",
158 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
159 "notificationdate",
160 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
161 "reminderdate",
162 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
163 "cancellationdate",
164 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
165 "reservenotes",
166 { data_type => "mediumtext", is_nullable => 1 },
167 "priority",
168 { data_type => "smallint", is_nullable => 1 },
169 "found",
170 { data_type => "varchar", is_nullable => 1, size => 1 },
171 "timestamp",
172 {
173 data_type => "timestamp",
174 datetime_undef_if_invalid => 1,
175 default_value => \"current_timestamp",
176 is_nullable => 0,
177 },
178 "itemnumber",
179 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
180 "waitingdate",
181 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
182 "expirationdate",
183 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
184 "lowestPriority",
185 { accessor => "lowest_priority", data_type => "tinyint", is_nullable => 0 },
186 "suspend",
187 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
188 "suspend_until",
189 {
190 data_type => "datetime",
191 datetime_undef_if_invalid => 1,
192 is_nullable => 1,
193 },
194);
195
196=head1 PRIMARY KEY
197
198=over 4
199
200=item * L</reserve_id>
201
202=back
203
204=cut
205
206119µs187µs__PACKAGE__->set_primary_key("reserve_id");
# spent 87µs making 1 call to DBIx::Class::ResultSourceProxy::set_primary_key
207
208=head1 RELATIONS
209
210=head2 biblionumber
211
212Type: belongs_to
213
214Related object: L<Koha::Schema::Result::Biblio>
215
216=cut
217
218110µs1352µs__PACKAGE__->belongs_to(
# spent 352µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
219 "biblionumber",
220 "Koha::Schema::Result::Biblio",
221 { biblionumber => "biblionumber" },
222 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
223);
224
225=head2 borrowernumber
226
227Type: belongs_to
228
229Related object: L<Koha::Schema::Result::Borrower>
230
231=cut
232
23314µs1206µs__PACKAGE__->belongs_to(
# spent 206µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
234 "borrowernumber",
235 "Koha::Schema::Result::Borrower",
236 { borrowernumber => "borrowernumber" },
237 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
238);
239
240=head2 branchcode
241
242Type: belongs_to
243
244Related object: L<Koha::Schema::Result::Branch>
245
246=cut
247
24814µs1196µs__PACKAGE__->belongs_to(
# spent 196µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
249 "branchcode",
250 "Koha::Schema::Result::Branch",
251 { branchcode => "branchcode" },
252 {
253 is_deferrable => 1,
254 join_type => "LEFT",
255 on_delete => "CASCADE",
256 on_update => "CASCADE",
257 },
258);
259
260=head2 itemnumber
261
262Type: belongs_to
263
264Related object: L<Koha::Schema::Result::Item>
265
266=cut
267
26814µs1194µs__PACKAGE__->belongs_to(
# spent 194µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
269 "itemnumber",
270 "Koha::Schema::Result::Item",
271 { itemnumber => "itemnumber" },
272 {
273 is_deferrable => 1,
274 join_type => "LEFT",
275 on_delete => "CASCADE",
276 on_update => "CASCADE",
277 },
278);
279
280
281# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-06-30 08:51:40
282# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uHHqseJ56g3nDyKnNncyUA
283
28413µs1200µs__PACKAGE__->belongs_to(
# spent 200µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
285 "item",
286 "Koha::Schema::Result::Item",
287 { itemnumber => "itemnumber" },
288 {
289 is_deferrable => 1,
290 join_type => "LEFT",
291 on_delete => "CASCADE",
292 on_update => "CASCADE",
293 },
294);
295
29614µs1159µs__PACKAGE__->belongs_to(
# spent 159µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
297 "biblio",
298 "Koha::Schema::Result::Biblio",
299 { biblionumber => "biblionumber" },
300 {
301 is_deferrable => 1,
302 join_type => "LEFT",
303 on_delete => "CASCADE",
304 on_update => "CASCADE",
305 },
306);
307
308119µs1;
 
# spent 13µs within Class::C3::Componentised::CORE:match which was called 28 times, avg 468ns/call: # 11 times (4µs+0s) by Class::C3::Componentised::load_components at line 72 of Class/C3/Componentised.pm, avg 400ns/call # 11 times (2µs+0s) by Class::C3::Componentised::load_components at line 71 of Class/C3/Componentised.pm, avg 227ns/call # 5 times (1µs+0s) by Class::C3::Componentised::load_own_components at line 87 of Class/C3/Componentised.pm, avg 280ns/call # once (5µs+0s) by base::import at line 55 of Class/C3/Componentised.pm
sub Class::C3::Componentised::CORE:match; # opcode
# spent 8µs within Class::C3::Componentised::CORE:qr which was called: # once (8µs+0s) by base::import at line 57 of Class/C3/Componentised.pm
sub Class::C3::Componentised::CORE:qr; # opcode