← 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:50:58 2016
Reported on Fri Jan 8 13:51:28 2016

Filename/home/vagrant/kohaclone/Koha/Schema/Result/Subscription.pm
StatementsExecuted 16 statements in 1.03ms
Subroutines
Calls P F Exclusive
Time
Inclusive
Time
Subroutine
11126µs29µsClass::C3::Componentised::::BEGIN@1.2673 Class::C3::Componentised::BEGIN@1.2673
11115µs26µsKoha::Schema::Result::Subscription::::BEGIN@13Koha::Schema::Result::Subscription::BEGIN@13
1119µs76µsKoha::Schema::Result::Subscription::::BEGIN@16Koha::Schema::Result::Subscription::BEGIN@16
1119µs17µsKoha::Schema::Result::Subscription::::BEGIN@14Koha::Schema::Result::Subscription::BEGIN@14
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments
Time
on line
Calls Time
in subs
Code
12102µs233µs
# spent 29µs (26+3) within Class::C3::Componentised::BEGIN@1.2673 which was called: # once (26µs+3µs) by Class::C3::Componentised::ensure_class_loaded at line 1
use utf8;
# spent 29µs making 1 call to Class::C3::Componentised::BEGIN@1.2673 # spent 3µs making 1 call to utf8::import
2package Koha::Schema::Result::Subscription;
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::Subscription
10
11=cut
12
13244µs237µs
# spent 26µs (15+11) within Koha::Schema::Result::Subscription::BEGIN@13 which was called: # once (15µs+11µs) by Class::C3::Componentised::ensure_class_loaded at line 13
use strict;
# spent 26µs making 1 call to Koha::Schema::Result::Subscription::BEGIN@13 # spent 11µs making 1 call to strict::import
14240µs225µs
# spent 17µs (9+8) within Koha::Schema::Result::Subscription::BEGIN@14 which was called: # once (9µs+8µs) by Class::C3::Componentised::ensure_class_loaded at line 14
use warnings;
# spent 17µs making 1 call to Koha::Schema::Result::Subscription::BEGIN@14 # spent 8µs making 1 call to warnings::import
15
162640µs2142µs
# spent 76µs (9+66) within Koha::Schema::Result::Subscription::BEGIN@16 which was called: # once (9µs+66µs) by Class::C3::Componentised::ensure_class_loaded at line 16
use base 'DBIx::Class::Core';
# spent 76µs making 1 call to Koha::Schema::Result::Subscription::BEGIN@16 # spent 66µs making 1 call to base::import
17
18=head1 TABLE: C<subscription>
19
20=cut
21
22122µs1370µs__PACKAGE__->table("subscription");
# spent 370µs making 1 call to DBIx::Class::ResultSourceProxy::Table::table
23
24=head1 ACCESSORS
25
26=head2 biblionumber
27
28 data_type: 'integer'
29 default_value: 0
30 is_nullable: 0
31
32=head2 subscriptionid
33
34 data_type: 'integer'
35 is_auto_increment: 1
36 is_nullable: 0
37
38=head2 librarian
39
40 data_type: 'varchar'
41 default_value: (empty string)
42 is_nullable: 1
43 size: 100
44
45=head2 startdate
46
47 data_type: 'date'
48 datetime_undef_if_invalid: 1
49 is_nullable: 1
50
51=head2 aqbooksellerid
52
53 data_type: 'integer'
54 default_value: 0
55 is_nullable: 1
56
57=head2 cost
58
59 data_type: 'integer'
60 default_value: 0
61 is_nullable: 1
62
63=head2 aqbudgetid
64
65 data_type: 'integer'
66 default_value: 0
67 is_nullable: 1
68
69=head2 weeklength
70
71 data_type: 'integer'
72 default_value: 0
73 is_nullable: 1
74
75=head2 monthlength
76
77 data_type: 'integer'
78 default_value: 0
79 is_nullable: 1
80
81=head2 numberlength
82
83 data_type: 'integer'
84 default_value: 0
85 is_nullable: 1
86
87=head2 periodicity
88
89 data_type: 'integer'
90 is_foreign_key: 1
91 is_nullable: 1
92
93=head2 countissuesperunit
94
95 data_type: 'integer'
96 default_value: 1
97 is_nullable: 0
98
99=head2 notes
100
101 data_type: 'mediumtext'
102 is_nullable: 1
103
104=head2 status
105
106 data_type: 'varchar'
107 default_value: (empty string)
108 is_nullable: 0
109 size: 100
110
111=head2 lastvalue1
112
113 data_type: 'integer'
114 is_nullable: 1
115
116=head2 innerloop1
117
118 data_type: 'integer'
119 default_value: 0
120 is_nullable: 1
121
122=head2 lastvalue2
123
124 data_type: 'integer'
125 is_nullable: 1
126
127=head2 innerloop2
128
129 data_type: 'integer'
130 default_value: 0
131 is_nullable: 1
132
133=head2 lastvalue3
134
135 data_type: 'integer'
136 is_nullable: 1
137
138=head2 innerloop3
139
140 data_type: 'integer'
141 default_value: 0
142 is_nullable: 1
143
144=head2 firstacquidate
145
146 data_type: 'date'
147 datetime_undef_if_invalid: 1
148 is_nullable: 1
149
150=head2 manualhistory
151
152 data_type: 'tinyint'
153 default_value: 0
154 is_nullable: 0
155
156=head2 irregularity
157
158 data_type: 'text'
159 is_nullable: 1
160
161=head2 skip_serialseq
162
163 data_type: 'tinyint'
164 default_value: 0
165 is_nullable: 0
166
167=head2 letter
168
169 data_type: 'varchar'
170 is_nullable: 1
171 size: 20
172
173=head2 numberpattern
174
175 data_type: 'integer'
176 is_foreign_key: 1
177 is_nullable: 1
178
179=head2 locale
180
181 data_type: 'varchar'
182 is_nullable: 1
183 size: 80
184
185=head2 distributedto
186
187 data_type: 'text'
188 is_nullable: 1
189
190=head2 internalnotes
191
192 data_type: 'longtext'
193 is_nullable: 1
194
195=head2 callnumber
196
197 data_type: 'text'
198 is_nullable: 1
199
200=head2 location
201
202 data_type: 'varchar'
203 default_value: (empty string)
204 is_nullable: 1
205 size: 80
206
207=head2 branchcode
208
209 data_type: 'varchar'
210 default_value: (empty string)
211 is_nullable: 0
212 size: 10
213
214=head2 lastbranch
215
216 data_type: 'varchar'
217 is_nullable: 1
218 size: 10
219
220=head2 serialsadditems
221
222 data_type: 'tinyint'
223 default_value: 0
224 is_nullable: 0
225
226=head2 staffdisplaycount
227
228 data_type: 'varchar'
229 is_nullable: 1
230 size: 10
231
232=head2 opacdisplaycount
233
234 data_type: 'varchar'
235 is_nullable: 1
236 size: 10
237
238=head2 graceperiod
239
240 data_type: 'integer'
241 default_value: 0
242 is_nullable: 0
243
244=head2 enddate
245
246 data_type: 'date'
247 datetime_undef_if_invalid: 1
248 is_nullable: 1
249
250=head2 closed
251
252 data_type: 'integer'
253 default_value: 0
254 is_nullable: 0
255
256=head2 reneweddate
257
258 data_type: 'date'
259 datetime_undef_if_invalid: 1
260 is_nullable: 1
261
262=cut
263
264161µs125.9ms__PACKAGE__->add_columns(
# spent 25.9ms making 1 call to DBIx::Class::ResultSourceProxy::add_columns
265 "biblionumber",
266 { data_type => "integer", default_value => 0, is_nullable => 0 },
267 "subscriptionid",
268 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
269 "librarian",
270 { data_type => "varchar", default_value => "", is_nullable => 1, size => 100 },
271 "startdate",
272 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
273 "aqbooksellerid",
274 { data_type => "integer", default_value => 0, is_nullable => 1 },
275 "cost",
276 { data_type => "integer", default_value => 0, is_nullable => 1 },
277 "aqbudgetid",
278 { data_type => "integer", default_value => 0, is_nullable => 1 },
279 "weeklength",
280 { data_type => "integer", default_value => 0, is_nullable => 1 },
281 "monthlength",
282 { data_type => "integer", default_value => 0, is_nullable => 1 },
283 "numberlength",
284 { data_type => "integer", default_value => 0, is_nullable => 1 },
285 "periodicity",
286 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
287 "countissuesperunit",
288 { data_type => "integer", default_value => 1, is_nullable => 0 },
289 "notes",
290 { data_type => "mediumtext", is_nullable => 1 },
291 "status",
292 { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
293 "lastvalue1",
294 { data_type => "integer", is_nullable => 1 },
295 "innerloop1",
296 { data_type => "integer", default_value => 0, is_nullable => 1 },
297 "lastvalue2",
298 { data_type => "integer", is_nullable => 1 },
299 "innerloop2",
300 { data_type => "integer", default_value => 0, is_nullable => 1 },
301 "lastvalue3",
302 { data_type => "integer", is_nullable => 1 },
303 "innerloop3",
304 { data_type => "integer", default_value => 0, is_nullable => 1 },
305 "firstacquidate",
306 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
307 "manualhistory",
308 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
309 "irregularity",
310 { data_type => "text", is_nullable => 1 },
311 "skip_serialseq",
312 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
313 "letter",
314 { data_type => "varchar", is_nullable => 1, size => 20 },
315 "numberpattern",
316 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
317 "locale",
318 { data_type => "varchar", is_nullable => 1, size => 80 },
319 "distributedto",
320 { data_type => "text", is_nullable => 1 },
321 "internalnotes",
322 { data_type => "longtext", is_nullable => 1 },
323 "callnumber",
324 { data_type => "text", is_nullable => 1 },
325 "location",
326 { data_type => "varchar", default_value => "", is_nullable => 1, size => 80 },
327 "branchcode",
328 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
329 "lastbranch",
330 { data_type => "varchar", is_nullable => 1, size => 10 },
331 "serialsadditems",
332 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
333 "staffdisplaycount",
334 { data_type => "varchar", is_nullable => 1, size => 10 },
335 "opacdisplaycount",
336 { data_type => "varchar", is_nullable => 1, size => 10 },
337 "graceperiod",
338 { data_type => "integer", default_value => 0, is_nullable => 0 },
339 "enddate",
340 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
341 "closed",
342 { data_type => "integer", default_value => 0, is_nullable => 0 },
343 "reneweddate",
344 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
345);
346
347=head1 PRIMARY KEY
348
349=over 4
350
351=item * L</subscriptionid>
352
353=back
354
355=cut
356
357124µs1110µs__PACKAGE__->set_primary_key("subscriptionid");
# spent 110µs making 1 call to DBIx::Class::ResultSourceProxy::set_primary_key
358
359=head1 RELATIONS
360
361=head2 aqorders
362
363Type: has_many
364
365Related object: L<Koha::Schema::Result::Aqorder>
366
367=cut
368
369110µs1435µs__PACKAGE__->has_many(
# spent 435µs making 1 call to DBIx::Class::Relationship::HasMany::has_many
370 "aqorders",
371 "Koha::Schema::Result::Aqorder",
372 { "foreign.subscriptionid" => "self.subscriptionid" },
373 { cascade_copy => 0, cascade_delete => 0 },
374);
375
376=head2 numberpattern
377
378Type: belongs_to
379
380Related object: L<Koha::Schema::Result::SubscriptionNumberpattern>
381
382=cut
383
384118µs11.40ms__PACKAGE__->belongs_to(
# spent 1.40ms making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
385 "numberpattern",
386 "Koha::Schema::Result::SubscriptionNumberpattern",
387 { id => "numberpattern" },
388 {
389 is_deferrable => 1,
390 join_type => "LEFT",
391 on_delete => "SET NULL",
392 on_update => "CASCADE",
393 },
394);
395
396=head2 periodicity
397
398Type: belongs_to
399
400Related object: L<Koha::Schema::Result::SubscriptionFrequency>
401
402=cut
403
404112µs11.75ms__PACKAGE__->belongs_to(
# spent 1.75ms making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
405 "periodicity",
406 "Koha::Schema::Result::SubscriptionFrequency",
407 { id => "periodicity" },
408 {
409 is_deferrable => 1,
410 join_type => "LEFT",
411 on_delete => "SET NULL",
412 on_update => "CASCADE",
413 },
414);
415
416=head2 subscriptionroutinglists
417
418Type: has_many
419
420Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
421
422=cut
423
424110µs1319µs__PACKAGE__->has_many(
# spent 319µs making 1 call to DBIx::Class::Relationship::HasMany::has_many
425 "subscriptionroutinglists",
426 "Koha::Schema::Result::Subscriptionroutinglist",
427 { "foreign.subscriptionid" => "self.subscriptionid" },
428 { cascade_copy => 0, cascade_delete => 0 },
429);
430
431
432# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
433# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:57kc1/B3eNKQXAk9tlOy0A
434
435
436# You can replace this text with custom content, and it will be preserved on regeneration
437147µs1;