← 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:35 2016

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