Skip to content

Instantly share code, notes, and snippets.

@alexknowshtml
Created May 24, 2012 03:49
Show Gist options
  • Save alexknowshtml/2779330 to your computer and use it in GitHub Desktop.
Save alexknowshtml/2779330 to your computer and use it in GitHub Desktop.
Connected to ChoiceShirts FTP server
Skipping Orders020112183600.csv - already in status=Finished
Skipping Orders020212183615.csv - already in status=Finished
Skipping Orders020312183609.csv - already in status=Finished
Skipping Orders020612183604.csv - already in status=Finished
Skipping Orders020712183548.csv - already in status=Finished
Skipping Orders020812183604.csv - already in status=Finished
Skipping Orders020912183554.csv - already in status=Finished
Skipping Orders021012183612.csv - already in status=Finished
Skipping Orders021312183440.csv - already in status=Finished
Skipping Orders021412183620.csv - already in status=Finished
Skipping Orders021512183554.csv - already in status=Finished
Skipping Orders021812174949.csv - already in status=Finished
Skipping Orders022012184128.csv - already in status=Finished
Skipping Orders022112183611.csv - already in status=Finished
Skipping Orders022212183558.csv - already in status=Finished
Skipping Orders022312183556.csv - already in status=Finished
Skipping Orders022412183448.csv - already in status=Finished
Skipping Orders022712183653.csv - already in status=Finished
Skipping Orders022812183725.csv - already in status=Finished
Skipping Orders022912183606.csv - already in status=Finished
Skipping Orders030112184037.csv - already in status=Finished
Skipping Orders030212183602.csv - already in status=Finished
Skipping Orders030512183721.csv - already in status=Finished
Skipping Orders030612183618.csv - already in status=Finished
Skipping Orders030712183626.csv - already in status=Finished
Skipping Orders030812183622.csv - already in status=Finished
Skipping Orders030912183632.csv - already in status=Finished
Skipping Orders031212183341.csv - already in status=Finished
Skipping Orders031312183333.csv - already in status=Finished
Skipping Orders031412183306.csv - already in status=Finished
Skipping Orders031512183338.csv - already in status=Finished
Skipping Orders031612183334.csv - already in status=Finished
Skipping Orders031912183351.csv - already in status=Finished
Skipping Orders032012183315.csv - already in status=Finished
Skipping Orders032112183404.csv - already in status=Finished
Skipping Orders032212183313.csv - already in status=Finished
Skipping Orders032312183350.csv - already in status=Finished
Skipping Orders032612183331.csv - already in status=Finished
Downloading Orders032712183323.csv to /tmp/dw-orderstatusihNrE1
Downloading Orders032812183333.csv to /tmp/dw-orderstatusIXmX7k
Downloading Orders032912183407.csv to /tmp/dw-orderstatusZJWlUL
Downloading Orders033012183353.csv to /tmp/dw-orderstatushPMtJj
Skipping unparsable custominfo on line #76400: Swag BlackJunior
- Found fully-shipped order: 109
<h1 style='color:red'>Exception caught</h1>
<p>Shopify API error: [API] Invalid API key or access token (unrecognized login or wrong password)</p>
<h2>Details</h2>
<pre>Exception Object
(
[message:protected] => Shopify API error: [API] Invalid API key or access token (unrecognized login or wrong password)
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/mics/sites/dynamicwear/data/4094
[line:protected] => 126
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/mics/sites/dynamicwear/data/3884
[line] => 83
[function] => getOrder
[class] => ShopifyStoreLink
[type] => ->
[args] => Array
(
[0] => OrderLink Object
(
[_record:protected] => Array
(
[ID] => 104
[Class] => OrderLink
[Created] => 2012-03-12 12:25:45
[CreatorID] => 10
[StoreLinkID] => 14
[ExternalIdentifier] => 127412420
[OrderID] => 109
[Memo] => Webhook POST from 204.93.213.120
)
[_convertedValues:protected] =>
[_relatedObjects:protected] => Array
(
[StoreLink] => ShopifyStoreLink Object
(
[_record:protected] => Array
(
[ID] => 14
[Class] => ShopifyStoreLink
[Created] => 2012-02-11 17:23:22
[CreatorID] => 15
[StoreID] => 11
[ExternalIdentifier] => 1418642
[APIToken] => 8415e4c020bc25ca6592279fbc6e78a0
[Host] => jlin
[LastOrdersImport] => 2012-04-24 02:20:04
[LastProductsImport] =>
[LastProductsExport] =>
[Status] => Inactive
)
[_convertedValues:protected] =>
[_relatedObjects:protected] => Array
(
)
[_isDirty:protected] =>
[_isPhantom:protected] =>
[_isValid:protected] => 1
[_isNew:protected] =>
[_isUpdated:protected] =>
[_validator:protected] =>
[_validationErrors:protected] => Array
(
)
[_originalValues:protected] => Array
(
)
)
)
[_isDirty:protected] =>
[_isPhantom:protected] =>
[_isValid:protected] => 1
[_isNew:protected] =>
[_isUpdated:protected] =>
[_validator:protected] =>
[_validationErrors:protected] => Array
(
)
[_originalValues:protected] => Array
(
)
)
)
)
[1] => Array
(
[file] => /var/mics/sites/dynamicwear/data/3891
[line] => 181
[function] => getRemote
[class] => OrderLink
[type] => ->
[args] => Array
(
)
)
[2] => Array
(
[file] => /emergence/lib/Site.class.php
[line] => 207
[args] => Array
(
[0] => /var/mics/sites/dynamicwear/data/3891
)
[function] => require
)
[3] => Array
(
[file] => /emergence/root/index.php
[line] => 3
[function] => handleRequest
[class] => Site
[type] => ::
[args] => Array
(
)
)
)
[previous:Exception:private] =>
)
</pre>
<h2>URI</h2>
<p>/cron/get-orders-status.php</p>
<h2>_SERVER</h2>
<pre>Array
(
[REDIRECT_UNIQUE_ID] => T72vo8ckH-gAAGyEUscAAABr
[REDIRECT_SITE_ID] => 135
[REDIRECT_SITE_ROOT] => /var/mics/sites/dynamicwear
[REDIRECT_STATUS] => 200
[UNIQUE_ID] => T72vo8ckH-gAAGyEUscAAABr
[SITE_ID] => 135
[SITE_ROOT] => /var/mics/sites/dynamicwear
[HTTP_HOST] => getdynamicwear.com
[HTTP_CONNECTION] => keep-alive
[HTTP_CACHE_CONTROL] => max-age=0
[HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.46 Safari/536.5
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_ACCEPT_ENCODING] => gzip,deflate,sdch
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.8
[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.3
[HTTP_COOKIE] => _jsuid=2660499073560377516; __utma=144046883.1490232403.1314380975.1315841058.1315846070.44; s=548f4783fd93fafd8543054f065d9ea9
[PATH] => /lib64/rc/sbin:/lib64/rc/bin:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/opt/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => getdynamicwear.com
[SERVER_ADDR] => 199.36.31.231
[SERVER_PORT] => 80
[REMOTE_ADDR] => 173.12.5.73
[DOCUMENT_ROOT] => /emergence/root
[SERVER_ADMIN] => [no address given]
[SCRIPT_FILENAME] => /emergence/root/index.php
[REMOTE_PORT] => 59828
[REDIRECT_URL] => /cron/get-orders-status.php
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] =>
[REQUEST_URI] => /cron/get-orders-status.php
[SCRIPT_NAME] => /index.php
[PHP_SELF] => /index.php
[REQUEST_TIME] => 1337831331
)
</pre>
<h2>User</h2>
<pre>Array
(
[ID] => 10
[Class] => User
[Created] => 1296978413
[CreatorID] => 4
[RevisionID] =>
[FirstName] => Alex
[LastName] => Hillman
[Gender] =>
[BirthDate] =>
[Email] => alex@choiceshirts.com
[Phone] =>
[Location] => Philadelphia
[About] => I'm a JFDI.
[PrimaryPhotoID] =>
[Username] => ahillman
[Password] =>
[AccountLevel] => Developer
)
</pre>
<h1>Backtrace:</h1><pre>#0 /var/mics/sites/dynamicwear/data/3884(83): ShopifyStoreLink->getOrder(Object(OrderLink))
#1 /var/mics/sites/dynamicwear/data/3891(181): OrderLink->getRemote()
#2 /emergence/lib/Site.class.php(207): require('/var/mics/sites...')
#3 /emergence/root/index.php(3): Site::handleRequest()
#4 {main}</pre><h2>Debug Log</h2><pre>Array
(
[0] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderStatusImport.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831332.048285
[time_finish] => 1337831332.049472
[time_duration_ms] => 1.1870861053467
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.049585
)
[1] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "OrderStatusImport.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831332.049630
[time_finish] => 1337831332.051286
[time_duration_ms] => 1.6560554504395
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.051341
)
[2] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderStatusImport.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831332.051557
[time_finish] => 1337831332.052464
[time_duration_ms] => 0.90694427490234
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.052535
)
[3] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "OrderStatusImport.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831332.052576
[time_finish] => 1337831332.052888
[time_duration_ms] => 0.31185150146484
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.052945
)
[4] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831332.052995
[time_finish] => 1337831332.053081
[time_duration_ms] => 0.086069107055664
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.053145
)
[5] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderStatusImport.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831332.053196
[time_finish] => 1337831332.054080
[time_duration_ms] => 0.88405609130859
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.054143
)
[6] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "OrderStatusImport.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831332.054174
[time_finish] => 1337831332.054345
[time_duration_ms] => 0.17094612121582
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.054402
)
[7] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders020112183600.csv" LIMIT 1
[time_start] => 1337831332.054597
[time_finish] => 1337831332.054878
[time_duration_ms] => 0.28109550476074
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.054928
)
[8] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders020212183615.csv" LIMIT 1
[time_start] => 1337831332.055021
[time_finish] => 1337831332.055202
[time_duration_ms] => 0.18095970153809
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.055251
)
[9] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders020312183609.csv" LIMIT 1
[time_start] => 1337831332.055323
[time_finish] => 1337831332.055464
[time_duration_ms] => 0.14114379882812
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.055512
)
[10] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders020612183604.csv" LIMIT 1
[time_start] => 1337831332.055583
[time_finish] => 1337831332.055769
[time_duration_ms] => 0.18596649169922
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.055817
)
[11] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders020712183548.csv" LIMIT 1
[time_start] => 1337831332.055888
[time_finish] => 1337831332.056022
[time_duration_ms] => 0.13399124145508
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.056070
)
[12] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders020812183604.csv" LIMIT 1
[time_start] => 1337831332.056141
[time_finish] => 1337831332.056272
[time_duration_ms] => 0.13113021850586
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.056320
)
[13] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders020912183554.csv" LIMIT 1
[time_start] => 1337831332.056390
[time_finish] => 1337831332.056526
[time_duration_ms] => 0.13589859008789
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.056574
)
[14] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders021012183612.csv" LIMIT 1
[time_start] => 1337831332.056655
[time_finish] => 1337831332.056796
[time_duration_ms] => 0.14114379882812
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.056845
)
[15] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders021312183440.csv" LIMIT 1
[time_start] => 1337831332.056916
[time_finish] => 1337831332.057055
[time_duration_ms] => 0.13899803161621
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.057103
)
[16] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders021412183620.csv" LIMIT 1
[time_start] => 1337831332.057174
[time_finish] => 1337831332.057317
[time_duration_ms] => 0.14305114746094
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.057365
)
[17] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders021512183554.csv" LIMIT 1
[time_start] => 1337831332.057436
[time_finish] => 1337831332.057564
[time_duration_ms] => 0.12803077697754
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.057612
)
[18] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders021812174949.csv" LIMIT 1
[time_start] => 1337831332.057683
[time_finish] => 1337831332.057914
[time_duration_ms] => 0.23102760314941
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.057962
)
[19] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022012184128.csv" LIMIT 1
[time_start] => 1337831332.058033
[time_finish] => 1337831332.058170
[time_duration_ms] => 0.1370906829834
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.058217
)
[20] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022112183611.csv" LIMIT 1
[time_start] => 1337831332.058287
[time_finish] => 1337831332.058433
[time_duration_ms] => 0.14615058898926
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.058482
)
[21] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022212183558.csv" LIMIT 1
[time_start] => 1337831332.058552
[time_finish] => 1337831332.058701
[time_duration_ms] => 0.14901161193848
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.058749
)
[22] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022312183556.csv" LIMIT 1
[time_start] => 1337831332.058819
[time_finish] => 1337831332.058957
[time_duration_ms] => 0.1380443572998
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.059006
)
[23] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022412183448.csv" LIMIT 1
[time_start] => 1337831332.059076
[time_finish] => 1337831332.059205
[time_duration_ms] => 0.12898445129395
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.059253
)
[24] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022712183653.csv" LIMIT 1
[time_start] => 1337831332.059323
[time_finish] => 1337831332.059470
[time_duration_ms] => 0.14686584472656
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.059517
)
[25] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022812183725.csv" LIMIT 1
[time_start] => 1337831332.059588
[time_finish] => 1337831332.059733
[time_duration_ms] => 0.14495849609375
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.059781
)
[26] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders022912183606.csv" LIMIT 1
[time_start] => 1337831332.059851
[time_finish] => 1337831332.059989
[time_duration_ms] => 0.1380443572998
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.060037
)
[27] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders030112184037.csv" LIMIT 1
[time_start] => 1337831332.060107
[time_finish] => 1337831332.060242
[time_duration_ms] => 0.13494491577148
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.060290
)
[28] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders030212183602.csv" LIMIT 1
[time_start] => 1337831332.060360
[time_finish] => 1337831332.060489
[time_duration_ms] => 0.12898445129395
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.060537
)
[29] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders030512183721.csv" LIMIT 1
[time_start] => 1337831332.060607
[time_finish] => 1337831332.060750
[time_duration_ms] => 0.14305114746094
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.060798
)
[30] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders030612183618.csv" LIMIT 1
[time_start] => 1337831332.060868
[time_finish] => 1337831332.061020
[time_duration_ms] => 0.1518726348877
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.061068
)
[31] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders030712183626.csv" LIMIT 1
[time_start] => 1337831332.061138
[time_finish] => 1337831332.061267
[time_duration_ms] => 0.12898445129395
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.061315
)
[32] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders030812183622.csv" LIMIT 1
[time_start] => 1337831332.061386
[time_finish] => 1337831332.061522
[time_duration_ms] => 0.13589859008789
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.061571
)
[33] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders030912183632.csv" LIMIT 1
[time_start] => 1337831332.061642
[time_finish] => 1337831332.061786
[time_duration_ms] => 0.14400482177734
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.061834
)
[34] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders031212183341.csv" LIMIT 1
[time_start] => 1337831332.061904
[time_finish] => 1337831332.062040
[time_duration_ms] => 0.13613700866699
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.062089
)
[35] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders031312183333.csv" LIMIT 1
[time_start] => 1337831332.062158
[time_finish] => 1337831332.062285
[time_duration_ms] => 0.12683868408203
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.062334
)
[36] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders031412183306.csv" LIMIT 1
[time_start] => 1337831332.062408
[time_finish] => 1337831332.062550
[time_duration_ms] => 0.14209747314453
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.062598
)
[37] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders031512183338.csv" LIMIT 1
[time_start] => 1337831332.062668
[time_finish] => 1337831332.062814
[time_duration_ms] => 0.14591217041016
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.062862
)
[38] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders031612183334.csv" LIMIT 1
[time_start] => 1337831332.062932
[time_finish] => 1337831332.063081
[time_duration_ms] => 0.14901161193848
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.063130
)
[39] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders031912183351.csv" LIMIT 1
[time_start] => 1337831332.063200
[time_finish] => 1337831332.063340
[time_duration_ms] => 0.13995170593262
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.063387
)
[40] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032012183315.csv" LIMIT 1
[time_start] => 1337831332.063457
[time_finish] => 1337831332.063599
[time_duration_ms] => 0.14209747314453
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.063647
)
[41] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032112183404.csv" LIMIT 1
[time_start] => 1337831332.063718
[time_finish] => 1337831332.063862
[time_duration_ms] => 0.14400482177734
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.063911
)
[42] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032212183313.csv" LIMIT 1
[time_start] => 1337831332.063981
[time_finish] => 1337831332.064133
[time_duration_ms] => 0.1518726348877
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.064182
)
[43] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032312183350.csv" LIMIT 1
[time_start] => 1337831332.064252
[time_finish] => 1337831332.064393
[time_duration_ms] => 0.14114379882812
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.064442
)
[44] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032612183331.csv" LIMIT 1
[time_start] => 1337831332.064512
[time_finish] => 1337831332.064644
[time_duration_ms] => 0.13208389282227
[affected_rows] => 1
[result_fields] => 11
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.064692
)
[45] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032712183323.csv" LIMIT 1
[time_start] => 1337831332.064773
[time_finish] => 1337831332.064892
[time_duration_ms] => 0.11897087097168
[affected_rows] => 0
[result_fields] => 11
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831332.064941
)
[46] => Array
(
[query] => INSERT INTO `order_status_imports` SET `Class` = "OrderStatusImport",`Created` = "2012-05-23 23:48:52",`CreatorID` = "10",`Filename` = "Orders032712183323.csv",`Status` = "Processing"
[time_start] => 1337831332.065636
[time_finish] => 1337831332.066024
[time_duration_ms] => 0.38814544677734
[affected_rows] => 1
[method] => nonQuery
[source] => DB
[time] => 1337831332.066068
)
[47] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "SpreadsheetReader.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831333.698234
[time_finish] => 1337831333.699478
[time_duration_ms] => 1.2438297271729
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831333.699614
)
[48] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "SpreadsheetReader.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831333.699661
[time_finish] => 1337831333.701547
[time_duration_ms] => 1.8858909606934
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831333.701604
)
[49] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "SpreadsheetReader.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831333.744248
[time_finish] => 1337831333.745335
[time_duration_ms] => 1.0871887207031
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831333.745438
)
[50] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "SpreadsheetReader.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831333.745478
[time_finish] => 1337831333.745834
[time_duration_ms] => 0.35619735717773
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831333.745893
)
[51] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831333.745948
[time_finish] => 1337831333.746015
[time_duration_ms] => 0.066995620727539
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831333.746080
)
[52] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "SpreadsheetReader.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831333.746137
[time_finish] => 1337831333.747040
[time_duration_ms] => 0.90312957763672
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831333.747107
)
[53] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "SpreadsheetReader.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831333.747139
[time_finish] => 1337831333.747326
[time_duration_ms] => 0.18692016601562
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831333.747385
)
[54] => Array
(
[query] => UPDATE `order_status_imports` SET `ID` = "74",`Class` = "OrderStatusImport",`Created` = "2012-05-23 23:48:52",`CreatorID` = "10",`Filename` = "Orders032712183323.csv",`Status` = "Finished",`LinesRead` = "19708",`ItemsRead` = "0",`ItemsShipped` = "0",`OrdersUpdated` = "0",`ShipmentsUpdated` = "0" WHERE `ID` = 74
[time_start] => 1337831334.763127
[time_finish] => 1337831334.763538
[time_duration_ms] => 0.41079521179199
[affected_rows] => 1
[method] => nonQuery
[source] => DB
[time] => 1337831334.763606
)
[55] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032812183333.csv" LIMIT 1
[time_start] => 1337831334.763655
[time_finish] => 1337831334.763929
[time_duration_ms] => 0.2739429473877
[affected_rows] => 0
[result_fields] => 11
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831334.763985
)
[56] => Array
(
[query] => INSERT INTO `order_status_imports` SET `Class` = "OrderStatusImport",`Created` = "2012-05-23 23:48:54",`CreatorID` = "10",`Filename` = "Orders032812183333.csv",`Status` = "Processing"
[time_start] => 1337831334.764539
[time_finish] => 1337831334.764706
[time_duration_ms] => 0.16689300537109
[affected_rows] => 1
[method] => nonQuery
[source] => DB
[time] => 1337831334.764750
)
[57] => Array
(
[query] => UPDATE `order_status_imports` SET `ID` = "75",`Class` = "OrderStatusImport",`Created` = "2012-05-23 23:48:54",`CreatorID` = "10",`Filename` = "Orders032812183333.csv",`Status` = "Finished",`LinesRead` = "40048",`ItemsRead` = "0",`ItemsShipped` = "0",`OrdersUpdated` = "0",`ShipmentsUpdated` = "0" WHERE `ID` = 75
[time_start] => 1337831337.272565
[time_finish] => 1337831337.273004
[time_duration_ms] => 0.43916702270508
[affected_rows] => 1
[method] => nonQuery
[source] => DB
[time] => 1337831337.273075
)
[58] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders032912183407.csv" LIMIT 1
[time_start] => 1337831337.273122
[time_finish] => 1337831337.273366
[time_duration_ms] => 0.2439022064209
[affected_rows] => 0
[result_fields] => 11
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831337.273423
)
[59] => Array
(
[query] => INSERT INTO `order_status_imports` SET `Class` = "OrderStatusImport",`Created` = "2012-05-23 23:48:57",`CreatorID` = "10",`Filename` = "Orders032912183407.csv",`Status` = "Processing"
[time_start] => 1337831337.274002
[time_finish] => 1337831337.274172
[time_duration_ms] => 0.16999244689941
[affected_rows] => 1
[method] => nonQuery
[source] => DB
[time] => 1337831337.274215
)
[60] => Array
(
[query] => UPDATE `order_status_imports` SET `ID` = "76",`Class` = "OrderStatusImport",`Created` = "2012-05-23 23:48:57",`CreatorID` = "10",`Filename` = "Orders032912183407.csv",`Status` = "Finished",`LinesRead` = "59585",`ItemsRead` = "0",`ItemsShipped` = "0",`OrdersUpdated` = "0",`ShipmentsUpdated` = "0" WHERE `ID` = 76
[time_start] => 1337831339.692438
[time_finish] => 1337831339.692891
[time_duration_ms] => 0.45299530029297
[affected_rows] => 1
[method] => nonQuery
[source] => DB
[time] => 1337831339.692966
)
[61] => Array
(
[query] => SELECT * FROM `order_status_imports` WHERE `Filename` = "Orders033012183353.csv" LIMIT 1
[time_start] => 1337831339.693017
[time_finish] => 1337831339.693294
[time_duration_ms] => 0.27704238891602
[affected_rows] => 0
[result_fields] => 11
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831339.693351
)
[62] => Array
(
[query] => INSERT INTO `order_status_imports` SET `Class` = "OrderStatusImport",`Created` = "2012-05-23 23:48:59",`CreatorID` = "10",`Filename` = "Orders033012183353.csv",`Status` = "Processing"
[time_start] => 1337831339.693950
[time_finish] => 1337831339.694132
[time_duration_ms] => 0.18215179443359
[affected_rows] => 1
[method] => nonQuery
[source] => DB
[time] => 1337831339.694176
)
[63] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "Order.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.515485
[time_finish] => 1337831342.516663
[time_duration_ms] => 1.1780261993408
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.516773
)
[64] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "Order.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.516815
[time_finish] => 1337831342.519736
[time_duration_ms] => 2.9211044311523
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.519793
)
[65] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "Order.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.520044
[time_finish] => 1337831342.520979
[time_duration_ms] => 0.93483924865723
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.521056
)
[66] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "Order.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.521086
[time_finish] => 1337831342.521423
[time_duration_ms] => 0.33712387084961
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.521480
)
[67] => Array
(
[query] => SELECT * FROM `orders` WHERE `ID` = "109" LIMIT 1
[time_start] => 1337831342.521841
[time_finish] => 1337831342.522225
[time_duration_ms] => 0.38385391235352
[affected_rows] => 1
[result_fields] => 21
[result_rows] => 1
[method] => query/oneRecordCached
[source] => DB
[time] => 1337831342.522280
)
[68] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderItem.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.522442
[time_finish] => 1337831342.523340
[time_duration_ms] => 0.89788436889648
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.523411
)
[69] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "OrderItem.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.523441
[time_finish] => 1337831342.526660
[time_duration_ms] => 3.2188892364502
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.526849
)
[70] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderItem.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.527151
[time_finish] => 1337831342.528354
[time_duration_ms] => 1.2028217315674
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.528529
)
[71] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "OrderItem.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.528622
[time_finish] => 1337831342.529055
[time_duration_ms] => 0.43320655822754
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.529123
)
[72] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.529201
[time_finish] => 1337831342.529281
[time_duration_ms] => 0.079870223999023
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.529345
)
[73] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderItem.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.529410
[time_finish] => 1337831342.530497
[time_duration_ms] => 1.0871887207031
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.530562
)
[74] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "OrderItem.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.530593
[time_finish] => 1337831342.530827
[time_duration_ms] => 0.23412704467773
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.530886
)
[75] => Array
(
[query] => SELECT Item.* FROM order_items Item JOIN varieties Variety ON (Variety.ID=Item.VarietyID) JOIN products Product ON (Product.ID = Variety.ProductID) JOIN garments Garment ON (Garment.ID=Variety.GarmentID) WHERE Item.OrderID = 109 AND Product.FrontArtworkID = 50 AND Product.BackArtworkID IS NULL AND Garment.SKU = "CSB002001TAV-1"
[time_start] => 1337831342.531154
[time_finish] => 1337831342.532754
[time_duration_ms] => 1.6000270843506
[affected_rows] => 1
[result_fields] => 12
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.532805
)
[76] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ProductOrderItem.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.532925
[time_finish] => 1337831342.533817
[time_duration_ms] => 0.89216232299805
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.533903
)
[77] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "ProductOrderItem.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.533936
[time_finish] => 1337831342.535241
[time_duration_ms] => 1.3048648834229
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.535303
)
[78] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ProductOrderItem.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.535488
[time_finish] => 1337831342.536386
[time_duration_ms] => 0.89812278747559
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.536463
)
[79] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "ProductOrderItem.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.536495
[time_finish] => 1337831342.536802
[time_duration_ms] => 0.30708312988281
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.536888
)
[80] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.536932
[time_finish] => 1337831342.536997
[time_duration_ms] => 0.065088272094727
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.537068
)
[81] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ProductOrderItem.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.537119
[time_finish] => 1337831342.538046
[time_duration_ms] => 0.92697143554688
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.538123
)
[82] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "ProductOrderItem.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.538155
[time_finish] => 1337831342.538301
[time_duration_ms] => 0.14591217041016
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.538369
)
[83] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "Shipment.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.538602
[time_finish] => 1337831342.539489
[time_duration_ms] => 0.88691711425781
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.539550
)
[84] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "Shipment.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831342.539582
[time_finish] => 1337831342.541189
[time_duration_ms] => 1.6069412231445
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831342.541244
)
[85] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "Shipment.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.141274
[time_finish] => 1337831343.142488
[time_duration_ms] => 1.2140274047852
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.142623
)
[86] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "Shipment.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.142667
[time_finish] => 1337831343.143036
[time_duration_ms] => 0.36883354187012
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.143119
)
[87] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.143174
[time_finish] => 1337831343.143235
[time_duration_ms] => 0.06103515625
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.143301
)
[88] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "Shipment.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.143357
[time_finish] => 1337831343.144243
[time_duration_ms] => 0.88596343994141
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.144308
)
[89] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "Shipment.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.144338
[time_finish] => 1337831343.144518
[time_duration_ms] => 0.18000602722168
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.144577
)
[90] => Array
(
[query] => SELECT * FROM `shipments` WHERE `TrackingNo` = "9102122474450100385970" LIMIT 1
[time_start] => 1337831343.157026
[time_finish] => 1337831343.205307
[time_duration_ms] => 48.280954360962
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.205452
)
[91] => Array
(
[query] => UPDATE `order_items` SET `ID` = "547",`Class` = "ProductOrderItem",`Created` = "2012-03-12 12:25:45",`CreatorID` = "10",`Status` = "Pending",`OrderID` = "109",`ShipmentID` = "98",`SalePrice` = "25.00",`Quantity` = "1",`VarietyID` = "213" WHERE `ID` = 547
[time_start] => 1337831343.206075
[time_finish] => 1337831343.227303
[time_duration_ms] => 21.228075027466
[affected_rows] => 0
[method] => nonQuery
[source] => DB
[time] => 1337831343.227356
)
[92] => Array
(
[query] => SELECT Item.* FROM order_items Item JOIN varieties Variety ON (Variety.ID=Item.VarietyID) JOIN products Product ON (Product.ID = Variety.ProductID) JOIN garments Garment ON (Garment.ID=Variety.GarmentID) WHERE Item.OrderID = 109 AND Product.FrontArtworkID = 49 AND Product.BackArtworkID IS NULL AND Garment.SKU = "CSB002001TAB-3"
[time_start] => 1337831343.227459
[time_finish] => 1337831343.228824
[time_duration_ms] => 1.3649463653564
[affected_rows] => 1
[result_fields] => 12
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.228878
)
[93] => Array
(
[query] => UPDATE `order_items` SET `ID` = "548",`Class` = "ProductOrderItem",`Created` = "2012-03-12 12:25:45",`CreatorID` = "10",`Status` = "Pending",`OrderID` = "109",`ShipmentID` = "98",`SalePrice` = "25.00",`Quantity` = "1",`VarietyID` = "211" WHERE `ID` = 548
[time_start] => 1337831343.229363
[time_finish] => 1337831343.229488
[time_duration_ms] => 0.12493133544922
[affected_rows] => 0
[method] => nonQuery
[source] => DB
[time] => 1337831343.229533
)
[94] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderLink.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.229657
[time_finish] => 1337831343.230574
[time_duration_ms] => 0.91695785522461
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.230671
)
[95] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "OrderLink.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.230707
[time_finish] => 1337831343.232219
[time_duration_ms] => 1.5120506286621
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.232296
)
[96] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderLink.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.232487
[time_finish] => 1337831343.233363
[time_duration_ms] => 0.87594985961914
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.233445
)
[97] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "OrderLink.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.233480
[time_finish] => 1337831343.233786
[time_duration_ms] => 0.30612945556641
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.233853
)
[98] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.233904
[time_finish] => 1337831343.233971
[time_duration_ms] => 0.067234039306641
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.234046
)
[99] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "OrderLink.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.234098
[time_finish] => 1337831343.234972
[time_duration_ms] => 0.87404251098633
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.235048
)
[100] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "OrderLink.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.235080
[time_finish] => 1337831343.235221
[time_duration_ms] => 0.14090538024902
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.235290
)
[101] => Array
(
[query] => SELECT `OrderLink`.* FROM `order_links` AS `OrderLink` WHERE (`OrderID` = "109")
[time_start] => 1337831343.235506
[time_finish] => 1337831343.260198
[time_duration_ms] => 24.692058563232
[affected_rows] => 1
[result_fields] => 8
[result_rows] => 1
[method] => query/allRecords
[source] => DB
[time] => 1337831343.260406
)
[102] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "StoreLink.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.260842
[time_finish] => 1337831343.262024
[time_duration_ms] => 1.1818408966064
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.262228
)
[103] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "StoreLink.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.262287
[time_finish] => 1337831343.269552
[time_duration_ms] => 7.2650909423828
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.269619
)
[104] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "StoreLink.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.269827
[time_finish] => 1337831343.270721
[time_duration_ms] => 0.89406967163086
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.270805
)
[105] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "StoreLink.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.270838
[time_finish] => 1337831343.271142
[time_duration_ms] => 0.30398368835449
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.271209
)
[106] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.271258
[time_finish] => 1337831343.271321
[time_duration_ms] => 0.062942504882812
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.271395
)
[107] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "StoreLink.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.271448
[time_finish] => 1337831343.272327
[time_duration_ms] => 0.87904930114746
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.272401
)
[108] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "StoreLink.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.272435
[time_finish] => 1337831343.272584
[time_duration_ms] => 0.14901161193848
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.272741
)
[109] => Array
(
[query] => SELECT * FROM `store_links` WHERE `ID` = "14" LIMIT 1
[time_start] => 1337831343.272947
[time_finish] => 1337831343.273219
[time_duration_ms] => 0.27203559875488
[affected_rows] => 1
[result_fields] => 12
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.273277
)
[110] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ShopifyStoreLink.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.273360
[time_finish] => 1337831343.274307
[time_duration_ms] => 0.94699859619141
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.274391
)
[111] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "ShopifyStoreLink.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.274424
[time_finish] => 1337831343.274777
[time_duration_ms] => 0.35285949707031
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.274846
)
[112] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ShopifyStoreLink.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.274993
[time_finish] => 1337831343.275872
[time_duration_ms] => 0.87904930114746
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.275956
)
[113] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "ShopifyStoreLink.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.275989
[time_finish] => 1337831343.276275
[time_duration_ms] => 0.28586387634277
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.276347
)
[114] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "php-config") AND (Status = "Normal") AND (ParentID IS NULL) AND (SiteID = 2) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.276391
[time_finish] => 1337831343.276451
[time_duration_ms] => 0.060081481933594
[affected_rows] => 1
[result_fields] => 9
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.276531
)
[115] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ShopifyStoreLink.config.php") AND (Status = "Normal") AND (ParentID = 4) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.276582
[time_finish] => 1337831343.277479
[time_duration_ms] => 0.89693069458008
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.277560
)
[116] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 4 AND Handle = "ShopifyStoreLink.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.277594
[time_finish] => 1337831343.277737
[time_duration_ms] => 0.14281272888184
[affected_rows] => 0
[result_fields] => 10
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.277811
)
[117] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ShopifyAPI.class.php") AND (Status = "Normal") AND (ParentID = 1) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.278060
[time_finish] => 1337831343.278949
[time_duration_ms] => 0.88906288146973
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.279014
)
[118] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 1 AND Handle = "ShopifyAPI.class.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.279046
[time_finish] => 1337831343.280436
[time_duration_ms] => 1.3899803161621
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.280496
)
[119] => Array
(
[query] => SELECT * FROM `_e_file_collections` WHERE (Handle = "ShopifyAPI.config.php") AND (Status = "Normal") AND (ParentID = 3) ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.280599
[time_finish] => 1337831343.281487
[time_duration_ms] => 0.88787078857422
[affected_rows] => 0
[result_fields] => 9
[result_rows] => 0
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.281554
)
[120] => Array
(
[query] => SELECT * FROM `_e_files` WHERE CollectionID = 3 AND Handle = "ShopifyAPI.config.php" ORDER BY ID DESC LIMIT 1
[time_start] => 1337831343.281586
[time_finish] => 1337831343.281891
[time_duration_ms] => 0.30517578125
[affected_rows] => 1
[result_fields] => 10
[result_rows] => 1
[method] => query/oneRecord
[source] => DB
[time] => 1337831343.281952
)
)
</pre>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment