← 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/Issue.pm
StatementsExecuted 18 statements in 766µs
Subroutines
Calls P F Exclusive
Time		 Inclusive
Time		 Subroutine
11112µs25µsKoha::Schema::Result::Issue::::BEGIN@13Koha::Schema::Result::Issue::BEGIN@13
11112µs98µsKoha::Schema::Result::Issue::::BEGIN@16Koha::Schema::Result::Issue::BEGIN@16
1119µs18µsKoha::Schema::Result::Issue::::BEGIN@14Koha::Schema::Result::Issue::BEGIN@14
111100ns100nsClass::C3::Componentised::::BEGIN@1.677 Class::C3::Componentised::BEGIN@1.677
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments		 Time
on line		 Calls Time
in subs		 Code
1259µs2100ns
# spent 100ns within Class::C3::Componentised::BEGIN@1.677 which was called: # once (100ns+0s) by Class::C3::Componentised::ensure_class_loaded at line 1
use utf8;
# spent 100ns making 1 call to Class::C3::Componentised::BEGIN@1.677 # spent 0s making 1 call to utf8::import
2package Koha::Schema::Result::Issue;
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::Issue
10
11=cut
12
13243µs237µs
# spent 25µs (12+12) within Koha::Schema::Result::Issue::BEGIN@13 which was called: # once (12µs+12µs) by Class::C3::Componentised::ensure_class_loaded at line 13
use strict;
# spent 25µs making 1 call to Koha::Schema::Result::Issue::BEGIN@13 # spent 12µs making 1 call to strict::import
14242µs228µs
# spent 18µs (9+10) within Koha::Schema::Result::Issue::BEGIN@14 which was called: # once (9µs+10µs) by Class::C3::Componentised::ensure_class_loaded at line 14
use warnings;
# spent 18µs making 1 call to Koha::Schema::Result::Issue::BEGIN@14 # spent 10µs making 1 call to warnings::import
15
162454µs2183µs
# spent 98µs (12+85) within Koha::Schema::Result::Issue::BEGIN@16 which was called: # once (12µs+85µs) by Class::C3::Componentised::ensure_class_loaded at line 16
use base 'DBIx::Class::Core';
# spent 98µs making 1 call to Koha::Schema::Result::Issue::BEGIN@16 # spent 85µs making 1 call to base::import
17
18=head1 TABLE: C<issues>
19
20=cut
21
22134µs1376µs__PACKAGE__->table("issues");
# spent 376µs making 1 call to DBIx::Class::ResultSourceProxy::Table::table
23
24=head1 ACCESSORS
25
26=head2 issue_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 is_foreign_key: 1
36 is_nullable: 1
37
38=head2 itemnumber
39
40 data_type: 'integer'
41 is_foreign_key: 1
42 is_nullable: 1
43
44=head2 date_due
45
46 data_type: 'datetime'
47 datetime_undef_if_invalid: 1
48 is_nullable: 1
49
50=head2 branchcode
51
52 data_type: 'varchar'
53 is_nullable: 1
54 size: 10
55
56=head2 returndate
57
58 data_type: 'datetime'
59 datetime_undef_if_invalid: 1
60 is_nullable: 1
61
62=head2 lastreneweddate
63
64 data_type: 'datetime'
65 datetime_undef_if_invalid: 1
66 is_nullable: 1
67
68=head2 return
69
70 data_type: 'varchar'
71 is_nullable: 1
72 size: 4
73
74=head2 renewals
75
76 data_type: 'tinyint'
77 is_nullable: 1
78
79=head2 auto_renew
80
81 data_type: 'tinyint'
82 default_value: 0
83 is_nullable: 1
84
85=head2 timestamp
86
87 data_type: 'timestamp'
88 datetime_undef_if_invalid: 1
89 default_value: current_timestamp
90 is_nullable: 0
91
92=head2 issuedate
93
94 data_type: 'datetime'
95 datetime_undef_if_invalid: 1
96 is_nullable: 1
97
98=head2 onsite_checkout
99
100 data_type: 'integer'
101 default_value: 0
102 is_nullable: 0
103
104=cut
105
106134µs15.63ms__PACKAGE__->add_columns(
# spent 5.63ms making 1 call to DBIx::Class::ResultSourceProxy::add_columns
107 "issue_id",
108 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
109 "borrowernumber",
110 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
111 "itemnumber",
112 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
113 "date_due",
114 {
115 data_type => "datetime",
116 datetime_undef_if_invalid => 1,
117 is_nullable => 1,
118 },
119 "branchcode",
120 { data_type => "varchar", is_nullable => 1, size => 10 },
121 "returndate",
122 {
123 data_type => "datetime",
124 datetime_undef_if_invalid => 1,
125 is_nullable => 1,
126 },
127 "lastreneweddate",
128 {
129 data_type => "datetime",
130 datetime_undef_if_invalid => 1,
131 is_nullable => 1,
132 },
133 "return",
134 { data_type => "varchar", is_nullable => 1, size => 4 },
135 "renewals",
136 { data_type => "tinyint", is_nullable => 1 },
137 "auto_renew",
138 { data_type => "tinyint", default_value => 0, is_nullable => 1 },
139 "timestamp",
140 {
141 data_type => "timestamp",
142 datetime_undef_if_invalid => 1,
143 default_value => \"current_timestamp",
144 is_nullable => 0,
145 },
146 "issuedate",
147 {
148 data_type => "datetime",
149 datetime_undef_if_invalid => 1,
150 is_nullable => 1,
151 },
152 "onsite_checkout",
153 { data_type => "integer", default_value => 0, is_nullable => 0 },
154);
155
156=head1 PRIMARY KEY
157
158=over 4
159
160=item * L</issue_id>
161
162=back
163
164=cut
165
166120µs193µs__PACKAGE__->set_primary_key("issue_id");
# spent 93µs making 1 call to DBIx::Class::ResultSourceProxy::set_primary_key
167
168=head1 UNIQUE CONSTRAINTS
169
170=head2 C<itemnumber>
171
172=over 4
173
174=item * L</itemnumber>
175
176=back
177
178=cut
179
180119µs128µs__PACKAGE__->add_unique_constraint("itemnumber", ["itemnumber"]);
# spent 28µs making 1 call to DBIx::Class::ResultSourceProxy::add_unique_constraint
181
182=head1 RELATIONS
183
184=head2 borrowernumber
185
186Type: belongs_to
187
188Related object: L<Koha::Schema::Result::Borrower>
189
190=cut
191
192112µs1416µs__PACKAGE__->belongs_to(
# spent 416µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
193 "borrowernumber",
194 "Koha::Schema::Result::Borrower",
195 { borrowernumber => "borrowernumber" },
196 {
197 is_deferrable => 1,
198 join_type => "LEFT",
199 on_delete => "RESTRICT",
200 on_update => "CASCADE",
201 },
202);
203
204=head2 itemnumber
205
206Type: belongs_to
207
208Related object: L<Koha::Schema::Result::Item>
209
210=cut
211
21216µs1618µs__PACKAGE__->belongs_to(
# spent 618µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
213 "itemnumber",
214 "Koha::Schema::Result::Item",
215 { itemnumber => "itemnumber" },
216 {
217 is_deferrable => 1,
218 join_type => "LEFT",
219 on_delete => "RESTRICT",
220 on_update => "CASCADE",
221 },
222);
223
224
225# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-11-04 12:00:58
226# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kREecsHr6wZPiokS946BHw
227
228110µs1276µs__PACKAGE__->belongs_to(
# spent 276µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
229 "borrower",
230 "Koha::Schema::Result::Borrower",
231 { borrowernumber => "borrowernumber" },
232 { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
233);
234
23515µs1170µs__PACKAGE__->belongs_to(
# spent 170µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
236 "item",
237 "Koha::Schema::Result::Item",
238 { itemnumber => "itemnumber" },
239 {
240 is_deferrable => 1,
241 join_type => "LEFT",
242 on_delete => "CASCADE",
243 on_update => "CASCADE",
244 },
245);
246
24714µs1160µs__PACKAGE__->belongs_to(
# spent 160µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
248 "branch",
249 "Koha::Schema::Result::Branch",
250 { branchcode => "branchcode" },
251 {
252 is_deferrable => 1,
253 join_type => "LEFT",
254 on_delete => "CASCADE",
255 on_update => "CASCADE",
256 },
257);
258
259124µs1;
Report produced by the NYTProf 6.02 Perl profiler, developed by Tim Bunce and Adam Kaplan.