← 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 14:31:06 2016
Reported on Fri Jan 8 14:31:38 2016

Filename/home/vagrant/kohaclone/Koha/Schema/Result/BorrowerModification.pm
StatementsExecuted 12 statements in 1.47ms
Subroutines
Calls P F Exclusive
Time		 Inclusive
Time		 Subroutine
11142µs47µsClass::C3::Componentised::::BEGIN@1.2378 Class::C3::Componentised::BEGIN@1.2378
11113µs26µsKoha::Schema::Result::BorrowerModification::::BEGIN@13Koha::Schema::Result::BorrowerModification::BEGIN@13
11111µs97µsKoha::Schema::Result::BorrowerModification::::BEGIN@16Koha::Schema::Result::BorrowerModification::BEGIN@16
11111µs21µsKoha::Schema::Result::BorrowerModification::::BEGIN@14Koha::Schema::Result::BorrowerModification::BEGIN@14
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments		 Time
on line		 Calls Time
in subs		 Code
12171µs252µs
# spent 47µs (42+5) within Class::C3::Componentised::BEGIN@1.2378 which was called: # once (42µs+5µs) by Class::C3::Componentised::ensure_class_loaded at line 1
use utf8;
# spent 47µs making 1 call to Class::C3::Componentised::BEGIN@1.2378 # spent 5µs making 1 call to utf8::import
2package Koha::Schema::Result::BorrowerModification;
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::BorrowerModification
10
11=cut
12
13247µs240µs
# spent 26µs (13+14) within Koha::Schema::Result::BorrowerModification::BEGIN@13 which was called: # once (13µs+14µs) by Class::C3::Componentised::ensure_class_loaded at line 13
use strict;
# spent 26µs making 1 call to Koha::Schema::Result::BorrowerModification::BEGIN@13 # spent 14µs making 1 call to strict::import
14246µs231µs
# spent 21µs (11+10) within Koha::Schema::Result::BorrowerModification::BEGIN@14 which was called: # once (11µs+10µs) by Class::C3::Componentised::ensure_class_loaded at line 14
use warnings;
# spent 21µs making 1 call to Koha::Schema::Result::BorrowerModification::BEGIN@14 # spent 10µs making 1 call to warnings::import
15
162974µs2183µs
# spent 97µs (11+86) within Koha::Schema::Result::BorrowerModification::BEGIN@16 which was called: # once (11µs+86µs) by Class::C3::Componentised::ensure_class_loaded at line 16
use base 'DBIx::Class::Core';
# spent 97µs making 1 call to Koha::Schema::Result::BorrowerModification::BEGIN@16 # spent 86µs making 1 call to base::import
17
18=head1 TABLE: C<borrower_modifications>
19
20=cut
21
22144µs1392µs__PACKAGE__->table("borrower_modifications");
# spent 392µs making 1 call to DBIx::Class::ResultSourceProxy::Table::table
23
24=head1 ACCESSORS
25
26=head2 timestamp
27
28 data_type: 'timestamp'
29 datetime_undef_if_invalid: 1
30 default_value: current_timestamp
31 is_nullable: 0
32
33=head2 verification_token
34
35 data_type: 'varchar'
36 default_value: (empty string)
37 is_nullable: 0
38 size: 255
39
40=head2 borrowernumber
41
42 data_type: 'integer'
43 default_value: 0
44 is_nullable: 0
45
46=head2 cardnumber
47
48 data_type: 'varchar'
49 is_nullable: 1
50 size: 16
51
52=head2 surname
53
54 data_type: 'mediumtext'
55 is_nullable: 1
56
57=head2 firstname
58
59 data_type: 'text'
60 is_nullable: 1
61
62=head2 title
63
64 data_type: 'mediumtext'
65 is_nullable: 1
66
67=head2 othernames
68
69 data_type: 'mediumtext'
70 is_nullable: 1
71
72=head2 initials
73
74 data_type: 'text'
75 is_nullable: 1
76
77=head2 streetnumber
78
79 data_type: 'varchar'
80 is_nullable: 1
81 size: 10
82
83=head2 streettype
84
85 data_type: 'varchar'
86 is_nullable: 1
87 size: 50
88
89=head2 address
90
91 data_type: 'mediumtext'
92 is_nullable: 1
93
94=head2 address2
95
96 data_type: 'text'
97 is_nullable: 1
98
99=head2 city
100
101 data_type: 'mediumtext'
102 is_nullable: 1
103
104=head2 state
105
106 data_type: 'text'
107 is_nullable: 1
108
109=head2 zipcode
110
111 data_type: 'varchar'
112 is_nullable: 1
113 size: 25
114
115=head2 country
116
117 data_type: 'text'
118 is_nullable: 1
119
120=head2 email
121
122 data_type: 'mediumtext'
123 is_nullable: 1
124
125=head2 phone
126
127 data_type: 'text'
128 is_nullable: 1
129
130=head2 mobile
131
132 data_type: 'varchar'
133 is_nullable: 1
134 size: 50
135
136=head2 fax
137
138 data_type: 'mediumtext'
139 is_nullable: 1
140
141=head2 emailpro
142
143 data_type: 'text'
144 is_nullable: 1
145
146=head2 phonepro
147
148 data_type: 'text'
149 is_nullable: 1
150
151=head2 B_streetnumber
152
153 accessor: 'b_streetnumber'
154 data_type: 'varchar'
155 is_nullable: 1
156 size: 10
157
158=head2 B_streettype
159
160 accessor: 'b_streettype'
161 data_type: 'varchar'
162 is_nullable: 1
163 size: 50
164
165=head2 B_address
166
167 accessor: 'b_address'
168 data_type: 'varchar'
169 is_nullable: 1
170 size: 100
171
172=head2 B_address2
173
174 accessor: 'b_address2'
175 data_type: 'text'
176 is_nullable: 1
177
178=head2 B_city
179
180 accessor: 'b_city'
181 data_type: 'mediumtext'
182 is_nullable: 1
183
184=head2 B_state
185
186 accessor: 'b_state'
187 data_type: 'text'
188 is_nullable: 1
189
190=head2 B_zipcode
191
192 accessor: 'b_zipcode'
193 data_type: 'varchar'
194 is_nullable: 1
195 size: 25
196
197=head2 B_country
198
199 accessor: 'b_country'
200 data_type: 'text'
201 is_nullable: 1
202
203=head2 B_email
204
205 accessor: 'b_email'
206 data_type: 'text'
207 is_nullable: 1
208
209=head2 B_phone
210
211 accessor: 'b_phone'
212 data_type: 'mediumtext'
213 is_nullable: 1
214
215=head2 dateofbirth
216
217 data_type: 'date'
218 datetime_undef_if_invalid: 1
219 is_nullable: 1
220
221=head2 branchcode
222
223 data_type: 'varchar'
224 is_nullable: 1
225 size: 10
226
227=head2 categorycode
228
229 data_type: 'varchar'
230 is_nullable: 1
231 size: 10
232
233=head2 dateenrolled
234
235 data_type: 'date'
236 datetime_undef_if_invalid: 1
237 is_nullable: 1
238
239=head2 dateexpiry
240
241 data_type: 'date'
242 datetime_undef_if_invalid: 1
243 is_nullable: 1
244
245=head2 gonenoaddress
246
247 data_type: 'tinyint'
248 is_nullable: 1
249
250=head2 lost
251
252 data_type: 'tinyint'
253 is_nullable: 1
254
255=head2 debarred
256
257 data_type: 'date'
258 datetime_undef_if_invalid: 1
259 is_nullable: 1
260
261=head2 debarredcomment
262
263 data_type: 'varchar'
264 is_nullable: 1
265 size: 255
266
267=head2 contactname
268
269 data_type: 'mediumtext'
270 is_nullable: 1
271
272=head2 contactfirstname
273
274 data_type: 'text'
275 is_nullable: 1
276
277=head2 contacttitle
278
279 data_type: 'text'
280 is_nullable: 1
281
282=head2 guarantorid
283
284 data_type: 'integer'
285 is_nullable: 1
286
287=head2 borrowernotes
288
289 data_type: 'mediumtext'
290 is_nullable: 1
291
292=head2 relationship
293
294 data_type: 'varchar'
295 is_nullable: 1
296 size: 100
297
298=head2 sex
299
300 data_type: 'varchar'
301 is_nullable: 1
302 size: 1
303
304=head2 password
305
306 data_type: 'varchar'
307 is_nullable: 1
308 size: 30
309
310=head2 flags
311
312 data_type: 'integer'
313 is_nullable: 1
314
315=head2 userid
316
317 data_type: 'varchar'
318 is_nullable: 1
319 size: 75
320
321=head2 opacnote
322
323 data_type: 'mediumtext'
324 is_nullable: 1
325
326=head2 contactnote
327
328 data_type: 'varchar'
329 is_nullable: 1
330 size: 255
331
332=head2 sort1
333
334 data_type: 'varchar'
335 is_nullable: 1
336 size: 80
337
338=head2 sort2
339
340 data_type: 'varchar'
341 is_nullable: 1
342 size: 80
343
344=head2 altcontactfirstname
345
346 data_type: 'varchar'
347 is_nullable: 1
348 size: 255
349
350=head2 altcontactsurname
351
352 data_type: 'varchar'
353 is_nullable: 1
354 size: 255
355
356=head2 altcontactaddress1
357
358 data_type: 'varchar'
359 is_nullable: 1
360 size: 255
361
362=head2 altcontactaddress2
363
364 data_type: 'varchar'
365 is_nullable: 1
366 size: 255
367
368=head2 altcontactaddress3
369
370 data_type: 'varchar'
371 is_nullable: 1
372 size: 255
373
374=head2 altcontactstate
375
376 data_type: 'text'
377 is_nullable: 1
378
379=head2 altcontactzipcode
380
381 data_type: 'varchar'
382 is_nullable: 1
383 size: 50
384
385=head2 altcontactcountry
386
387 data_type: 'text'
388 is_nullable: 1
389
390=head2 altcontactphone
391
392 data_type: 'varchar'
393 is_nullable: 1
394 size: 50
395
396=head2 smsalertnumber
397
398 data_type: 'varchar'
399 is_nullable: 1
400 size: 50
401
402=head2 privacy
403
404 data_type: 'integer'
405 is_nullable: 1
406
407=cut
408
4091100µs111.7ms__PACKAGE__->add_columns(
# spent 11.7ms making 1 call to DBIx::Class::ResultSourceProxy::add_columns
410 "timestamp",
411 {
412 data_type => "timestamp",
413 datetime_undef_if_invalid => 1,
414 default_value => \"current_timestamp",
415 is_nullable => 0,
416 },
417 "verification_token",
418 { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
419 "borrowernumber",
420 { data_type => "integer", default_value => 0, is_nullable => 0 },
421 "cardnumber",
422 { data_type => "varchar", is_nullable => 1, size => 16 },
423 "surname",
424 { data_type => "mediumtext", is_nullable => 1 },
425 "firstname",
426 { data_type => "text", is_nullable => 1 },
427 "title",
428 { data_type => "mediumtext", is_nullable => 1 },
429 "othernames",
430 { data_type => "mediumtext", is_nullable => 1 },
431 "initials",
432 { data_type => "text", is_nullable => 1 },
433 "streetnumber",
434 { data_type => "varchar", is_nullable => 1, size => 10 },
435 "streettype",
436 { data_type => "varchar", is_nullable => 1, size => 50 },
437 "address",
438 { data_type => "mediumtext", is_nullable => 1 },
439 "address2",
440 { data_type => "text", is_nullable => 1 },
441 "city",
442 { data_type => "mediumtext", is_nullable => 1 },
443 "state",
444 { data_type => "text", is_nullable => 1 },
445 "zipcode",
446 { data_type => "varchar", is_nullable => 1, size => 25 },
447 "country",
448 { data_type => "text", is_nullable => 1 },
449 "email",
450 { data_type => "mediumtext", is_nullable => 1 },
451 "phone",
452 { data_type => "text", is_nullable => 1 },
453 "mobile",
454 { data_type => "varchar", is_nullable => 1, size => 50 },
455 "fax",
456 { data_type => "mediumtext", is_nullable => 1 },
457 "emailpro",
458 { data_type => "text", is_nullable => 1 },
459 "phonepro",
460 { data_type => "text", is_nullable => 1 },
461 "B_streetnumber",
462 {
463 accessor => "b_streetnumber",
464 data_type => "varchar",
465 is_nullable => 1,
466 size => 10,
467 },
468 "B_streettype",
469 {
470 accessor => "b_streettype",
471 data_type => "varchar",
472 is_nullable => 1,
473 size => 50,
474 },
475 "B_address",
476 {
477 accessor => "b_address",
478 data_type => "varchar",
479 is_nullable => 1,
480 size => 100,
481 },
482 "B_address2",
483 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
484 "B_city",
485 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
486 "B_state",
487 { accessor => "b_state", data_type => "text", is_nullable => 1 },
488 "B_zipcode",
489 {
490 accessor => "b_zipcode",
491 data_type => "varchar",
492 is_nullable => 1,
493 size => 25,
494 },
495 "B_country",
496 { accessor => "b_country", data_type => "text", is_nullable => 1 },
497 "B_email",
498 { accessor => "b_email", data_type => "text", is_nullable => 1 },
499 "B_phone",
500 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
501 "dateofbirth",
502 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
503 "branchcode",
504 { data_type => "varchar", is_nullable => 1, size => 10 },
505 "categorycode",
506 { data_type => "varchar", is_nullable => 1, size => 10 },
507 "dateenrolled",
508 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
509 "dateexpiry",
510 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
511 "gonenoaddress",
512 { data_type => "tinyint", is_nullable => 1 },
513 "lost",
514 { data_type => "tinyint", is_nullable => 1 },
515 "debarred",
516 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
517 "debarredcomment",
518 { data_type => "varchar", is_nullable => 1, size => 255 },
519 "contactname",
520 { data_type => "mediumtext", is_nullable => 1 },
521 "contactfirstname",
522 { data_type => "text", is_nullable => 1 },
523 "contacttitle",
524 { data_type => "text", is_nullable => 1 },
525 "guarantorid",
526 { data_type => "integer", is_nullable => 1 },
527 "borrowernotes",
528 { data_type => "mediumtext", is_nullable => 1 },
529 "relationship",
530 { data_type => "varchar", is_nullable => 1, size => 100 },
531 "sex",
532 { data_type => "varchar", is_nullable => 1, size => 1 },
533 "password",
534 { data_type => "varchar", is_nullable => 1, size => 30 },
535 "flags",
536 { data_type => "integer", is_nullable => 1 },
537 "userid",
538 { data_type => "varchar", is_nullable => 1, size => 75 },
539 "opacnote",
540 { data_type => "mediumtext", is_nullable => 1 },
541 "contactnote",
542 { data_type => "varchar", is_nullable => 1, size => 255 },
543 "sort1",
544 { data_type => "varchar", is_nullable => 1, size => 80 },
545 "sort2",
546 { data_type => "varchar", is_nullable => 1, size => 80 },
547 "altcontactfirstname",
548 { data_type => "varchar", is_nullable => 1, size => 255 },
549 "altcontactsurname",
550 { data_type => "varchar", is_nullable => 1, size => 255 },
551 "altcontactaddress1",
552 { data_type => "varchar", is_nullable => 1, size => 255 },
553 "altcontactaddress2",
554 { data_type => "varchar", is_nullable => 1, size => 255 },
555 "altcontactaddress3",
556 { data_type => "varchar", is_nullable => 1, size => 255 },
557 "altcontactstate",
558 { data_type => "text", is_nullable => 1 },
559 "altcontactzipcode",
560 { data_type => "varchar", is_nullable => 1, size => 50 },
561 "altcontactcountry",
562 { data_type => "text", is_nullable => 1 },
563 "altcontactphone",
564 { data_type => "varchar", is_nullable => 1, size => 50 },
565 "smsalertnumber",
566 { data_type => "varchar", is_nullable => 1, size => 50 },
567 "privacy",
568 { data_type => "integer", is_nullable => 1 },
569);
570
571=head1 PRIMARY KEY
572
573=over 4
574
575=item * L</verification_token>
576
577=item * L</borrowernumber>
578
579=back
580
581=cut
582
583144µs1148µs__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
# spent 148µs making 1 call to DBIx::Class::ResultSourceProxy::set_primary_key
584
585
586# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-06 10:38:42
587# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vZ9XjkjQv0q6l2kW3KMsLg
588
589
590# You can replace this text with custom content, and it will be preserved on regeneration
591144µs1;
Report produced by the NYTProf 6.02 Perl profiler, developed by Tim Bunce and Adam Kaplan.