← 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/Aqorder.pm
StatementsExecuted 22 statements in 1.14ms
Subroutines
Calls P F Exclusive
Time
Inclusive
Time
Subroutine
11138µs43µsClass::C3::Componentised::::BEGIN@1.2364 Class::C3::Componentised::BEGIN@1.2364
11113µs26µsKoha::Schema::Result::Aqorder::::BEGIN@13Koha::Schema::Result::Aqorder::BEGIN@13
11110µs21µsKoha::Schema::Result::Aqorder::::BEGIN@14Koha::Schema::Result::Aqorder::BEGIN@14
11110µs99µsKoha::Schema::Result::Aqorder::::BEGIN@16Koha::Schema::Result::Aqorder::BEGIN@16
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments
Time
on line
Calls Time
in subs
Code
1291µs248µs
# spent 43µs (38+5) within Class::C3::Componentised::BEGIN@1.2364 which was called: # once (38µs+5µs) by Class::C3::Componentised::ensure_class_loaded at line 1
use utf8;
# spent 43µs making 1 call to Class::C3::Componentised::BEGIN@1.2364 # spent 5µs making 1 call to utf8::import
2package Koha::Schema::Result::Aqorder;
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::Aqorder
10
11=cut
12
13247µs239µs
# spent 26µs (13+13) within Koha::Schema::Result::Aqorder::BEGIN@13 which was called: # once (13µs+13µs) by Class::C3::Componentised::ensure_class_loaded at line 13
use strict;
# spent 26µs making 1 call to Koha::Schema::Result::Aqorder::BEGIN@13 # spent 13µs making 1 call to strict::import
14245µs232µs
# spent 21µs (10+11) within Koha::Schema::Result::Aqorder::BEGIN@14 which was called: # once (10µs+11µs) by Class::C3::Componentised::ensure_class_loaded at line 14
use warnings;
# spent 21µs making 1 call to Koha::Schema::Result::Aqorder::BEGIN@14 # spent 11µs making 1 call to warnings::import
15
162730µs2187µs
# spent 99µs (10+89) within Koha::Schema::Result::Aqorder::BEGIN@16 which was called: # once (10µs+89µs) by Class::C3::Componentised::ensure_class_loaded at line 16
use base 'DBIx::Class::Core';
# spent 99µs making 1 call to Koha::Schema::Result::Aqorder::BEGIN@16 # spent 89µs making 1 call to base::import
17
18=head1 TABLE: C<aqorders>
19
20=cut
21
22126µs1387µs__PACKAGE__->table("aqorders");
# spent 387µs making 1 call to DBIx::Class::ResultSourceProxy::Table::table
23
24=head1 ACCESSORS
25
26=head2 ordernumber
27
28 data_type: 'integer'
29 is_auto_increment: 1
30 is_nullable: 0
31
32=head2 biblionumber
33
34 data_type: 'integer'
35 is_foreign_key: 1
36 is_nullable: 1
37
38=head2 entrydate
39
40 data_type: 'date'
41 datetime_undef_if_invalid: 1
42 is_nullable: 1
43
44=head2 quantity
45
46 data_type: 'smallint'
47 is_nullable: 1
48
49=head2 currency
50
51 data_type: 'varchar'
52 is_nullable: 1
53 size: 3
54
55=head2 listprice
56
57 data_type: 'decimal'
58 is_nullable: 1
59 size: [28,6]
60
61=head2 datereceived
62
63 data_type: 'date'
64 datetime_undef_if_invalid: 1
65 is_nullable: 1
66
67=head2 invoiceid
68
69 data_type: 'integer'
70 is_foreign_key: 1
71 is_nullable: 1
72
73=head2 freight
74
75 data_type: 'decimal'
76 is_nullable: 1
77 size: [28,6]
78
79=head2 unitprice
80
81 data_type: 'decimal'
82 is_nullable: 1
83 size: [28,6]
84
85=head2 quantityreceived
86
87 data_type: 'smallint'
88 default_value: 0
89 is_nullable: 0
90
91=head2 datecancellationprinted
92
93 data_type: 'date'
94 datetime_undef_if_invalid: 1
95 is_nullable: 1
96
97=head2 cancellationreason
98
99 data_type: 'text'
100 is_nullable: 1
101
102=head2 order_internalnote
103
104 data_type: 'mediumtext'
105 is_nullable: 1
106
107=head2 order_vendornote
108
109 data_type: 'mediumtext'
110 is_nullable: 1
111
112=head2 purchaseordernumber
113
114 data_type: 'mediumtext'
115 is_nullable: 1
116
117=head2 basketno
118
119 data_type: 'integer'
120 is_foreign_key: 1
121 is_nullable: 1
122
123=head2 timestamp
124
125 data_type: 'timestamp'
126 datetime_undef_if_invalid: 1
127 default_value: current_timestamp
128 is_nullable: 0
129
130=head2 rrp
131
132 data_type: 'decimal'
133 is_nullable: 1
134 size: [13,2]
135
136=head2 ecost
137
138 data_type: 'decimal'
139 is_nullable: 1
140 size: [13,2]
141
142=head2 gstrate
143
144 data_type: 'decimal'
145 is_nullable: 1
146 size: [6,4]
147
148=head2 discount
149
150 data_type: 'float'
151 is_nullable: 1
152 size: [6,4]
153
154=head2 budget_id
155
156 data_type: 'integer'
157 is_foreign_key: 1
158 is_nullable: 0
159
160=head2 budgetgroup_id
161
162 data_type: 'integer'
163 is_nullable: 0
164
165=head2 budgetdate
166
167 data_type: 'date'
168 datetime_undef_if_invalid: 1
169 is_nullable: 1
170
171=head2 sort1
172
173 data_type: 'varchar'
174 is_nullable: 1
175 size: 80
176
177=head2 sort2
178
179 data_type: 'varchar'
180 is_nullable: 1
181 size: 80
182
183=head2 sort1_authcat
184
185 data_type: 'varchar'
186 is_nullable: 1
187 size: 10
188
189=head2 sort2_authcat
190
191 data_type: 'varchar'
192 is_nullable: 1
193 size: 10
194
195=head2 uncertainprice
196
197 data_type: 'tinyint'
198 is_nullable: 1
199
200=head2 claims_count
201
202 data_type: 'integer'
203 default_value: 0
204 is_nullable: 1
205
206=head2 claimed_date
207
208 data_type: 'date'
209 datetime_undef_if_invalid: 1
210 is_nullable: 1
211
212=head2 subscriptionid
213
214 data_type: 'integer'
215 is_foreign_key: 1
216 is_nullable: 1
217
218=head2 parent_ordernumber
219
220 data_type: 'integer'
221 is_nullable: 1
222
223=head2 orderstatus
224
225 data_type: 'varchar'
226 default_value: 'new'
227 is_nullable: 1
228 size: 16
229
230=cut
231
232152µs113.5ms__PACKAGE__->add_columns(
# spent 13.5ms making 1 call to DBIx::Class::ResultSourceProxy::add_columns
233 "ordernumber",
234 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
235 "biblionumber",
236 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
237 "entrydate",
238 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
239 "quantity",
240 { data_type => "smallint", is_nullable => 1 },
241 "currency",
242 { data_type => "varchar", is_nullable => 1, size => 3 },
243 "listprice",
244 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
245 "datereceived",
246 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
247 "invoiceid",
248 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
249 "freight",
250 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
251 "unitprice",
252 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
253 "quantityreceived",
254 { data_type => "smallint", default_value => 0, is_nullable => 0 },
255 "datecancellationprinted",
256 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
257 "cancellationreason",
258 { data_type => "text", is_nullable => 1 },
259 "order_internalnote",
260 { data_type => "mediumtext", is_nullable => 1 },
261 "order_vendornote",
262 { data_type => "mediumtext", is_nullable => 1 },
263 "purchaseordernumber",
264 { data_type => "mediumtext", is_nullable => 1 },
265 "basketno",
266 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
267 "timestamp",
268 {
269 data_type => "timestamp",
270 datetime_undef_if_invalid => 1,
271 default_value => \"current_timestamp",
272 is_nullable => 0,
273 },
274 "rrp",
275 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
276 "ecost",
277 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
278 "gstrate",
279 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
280 "discount",
281 { data_type => "float", is_nullable => 1, size => [6, 4] },
282 "budget_id",
283 { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
284 "budgetgroup_id",
285 { data_type => "integer", is_nullable => 0 },
286 "budgetdate",
287 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
288 "sort1",
289 { data_type => "varchar", is_nullable => 1, size => 80 },
290 "sort2",
291 { data_type => "varchar", is_nullable => 1, size => 80 },
292 "sort1_authcat",
293 { data_type => "varchar", is_nullable => 1, size => 10 },
294 "sort2_authcat",
295 { data_type => "varchar", is_nullable => 1, size => 10 },
296 "uncertainprice",
297 { data_type => "tinyint", is_nullable => 1 },
298 "claims_count",
299 { data_type => "integer", default_value => 0, is_nullable => 1 },
300 "claimed_date",
301 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
302 "subscriptionid",
303 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
304 "parent_ordernumber",
305 { data_type => "integer", is_nullable => 1 },
306 "orderstatus",
307 {
308 data_type => "varchar",
309 default_value => "new",
310 is_nullable => 1,
311 size => 16,
312 },
313);
314
315=head1 PRIMARY KEY
316
317=over 4
318
319=item * L</ordernumber>
320
321=back
322
323=cut
324
325120µs199µs__PACKAGE__->set_primary_key("ordernumber");
# spent 99µs making 1 call to DBIx::Class::ResultSourceProxy::set_primary_key
326
327=head1 RELATIONS
328
329=head2 aqorder_users
330
331Type: has_many
332
333Related object: L<Koha::Schema::Result::AqorderUser>
334
335=cut
336
33719µs11.12ms__PACKAGE__->has_many(
# spent 1.12ms making 1 call to DBIx::Class::Relationship::HasMany::has_many
338 "aqorder_users",
339 "Koha::Schema::Result::AqorderUser",
340 { "foreign.ordernumber" => "self.ordernumber" },
341 { cascade_copy => 0, cascade_delete => 0 },
342);
343
344=head2 aqorders_items
345
346Type: has_many
347
348Related object: L<Koha::Schema::Result::AqordersItem>
349
350=cut
351
35214µs1261µs__PACKAGE__->has_many(
# spent 261µs making 1 call to DBIx::Class::Relationship::HasMany::has_many
353 "aqorders_items",
354 "Koha::Schema::Result::AqordersItem",
355 { "foreign.ordernumber" => "self.ordernumber" },
356 { cascade_copy => 0, cascade_delete => 0 },
357);
358
359=head2 aqorders_transfers_ordernumber_from
360
361Type: might_have
362
363Related object: L<Koha::Schema::Result::AqordersTransfer>
364
365=cut
366
367110µs1354µs__PACKAGE__->might_have(
# spent 354µs making 1 call to DBIx::Class::Relationship::HasOne::might_have
368 "aqorders_transfers_ordernumber_from",
369 "Koha::Schema::Result::AqordersTransfer",
370 { "foreign.ordernumber_from" => "self.ordernumber" },
371 { cascade_copy => 0, cascade_delete => 0 },
372);
373
374=head2 aqorders_transfers_ordernumber_to
375
376Type: might_have
377
378Related object: L<Koha::Schema::Result::AqordersTransfer>
379
380=cut
381
38216µs1254µs__PACKAGE__->might_have(
# spent 254µs making 1 call to DBIx::Class::Relationship::HasOne::might_have
383 "aqorders_transfers_ordernumber_to",
384 "Koha::Schema::Result::AqordersTransfer",
385 { "foreign.ordernumber_to" => "self.ordernumber" },
386 { cascade_copy => 0, cascade_delete => 0 },
387);
388
389=head2 basketno
390
391Type: belongs_to
392
393Related object: L<Koha::Schema::Result::Aqbasket>
394
395=cut
396
397116µs11.10ms__PACKAGE__->belongs_to(
# spent 1.10ms making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
398 "basketno",
399 "Koha::Schema::Result::Aqbasket",
400 { basketno => "basketno" },
401 {
402 is_deferrable => 1,
403 join_type => "LEFT",
404 on_delete => "CASCADE",
405 on_update => "CASCADE",
406 },
407);
408
409=head2 biblionumber
410
411Type: belongs_to
412
413Related object: L<Koha::Schema::Result::Biblio>
414
415=cut
416
417112µs14.97ms__PACKAGE__->belongs_to(
# spent 4.97ms making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
418 "biblionumber",
419 "Koha::Schema::Result::Biblio",
420 { biblionumber => "biblionumber" },
421 {
422 is_deferrable => 1,
423 join_type => "LEFT",
424 on_delete => "SET NULL",
425 on_update => "CASCADE",
426 },
427);
428
429=head2 budget
430
431Type: belongs_to
432
433Related object: L<Koha::Schema::Result::Aqbudget>
434
435=cut
436
43717µs1260µs__PACKAGE__->belongs_to(
# spent 260µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
438 "budget",
439 "Koha::Schema::Result::Aqbudget",
440 { budget_id => "budget_id" },
441 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
442);
443
444=head2 invoiceid
445
446Type: belongs_to
447
448Related object: L<Koha::Schema::Result::Aqinvoice>
449
450=cut
451
45216µs11.03ms__PACKAGE__->belongs_to(
# spent 1.03ms making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
453 "invoiceid",
454 "Koha::Schema::Result::Aqinvoice",
455 { invoiceid => "invoiceid" },
456 {
457 is_deferrable => 1,
458 join_type => "LEFT",
459 on_delete => "SET NULL",
460 on_update => "CASCADE",
461 },
462);
463
464=head2 subscriptionid
465
466Type: belongs_to
467
468Related object: L<Koha::Schema::Result::Subscription>
469
470=cut
471
472111µs1338µs__PACKAGE__->belongs_to(
# spent 338µs making 1 call to DBIx::Class::Relationship::BelongsTo::belongs_to
473 "subscriptionid",
474 "Koha::Schema::Result::Subscription",
475 { subscriptionid => "subscriptionid" },
476 {
477 is_deferrable => 1,
478 join_type => "LEFT",
479 on_delete => "CASCADE",
480 on_update => "CASCADE",
481 },
482);
483
484=head2 borrowernumbers
485
486Type: many_to_many
487
488Composing rels: L</aqorder_users> -> borrowernumber
489
490=cut
491
49218µs1129µs__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
# spent 129µs making 1 call to DBIx::Class::Relationship::ManyToMany::many_to_many
493
494
495# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-05-14 11:27:15
496# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BCa/SxerJ+zEh8Pg9Jdkaw
497
498
499# You can replace this text with custom content, and it will be preserved on regeneration
500140µs1;