/src/Controller/DetailsController.php (line 141) object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Details.id AS `Details__id`, Details.sku AS `Details__sku`, Details.product_id AS `Details__product_id`, Details.size AS `Details__size`, Details.style AS `Details__style`, Details.inventory AS `Details__inventory`, Details.modified AS `Details__modified`, Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.user_id AS `Products__user_id`, Products.brand_id AS `Products__brand_id`, Products.name AS `Products__name`, Products.description AS `Products__description`, Products.price AS `Products__price`, Products.msrp AS `Products__msrp`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Products.status AS `Products__status` FROM details Details INNER JOIN products Products ON Products.id = (Details.product_id)', 'params' => [], 'defaultTypes' => [ 'Details.id' => 'integer', 'id' => 'integer', 'Details.sku' => 'string', 'sku' => 'string', 'Details.product_id' => 'integer', 'product_id' => 'integer', 'Details.size' => 'string', 'size' => 'string', 'Details.style' => 'string', 'style' => 'string', 'Details.inventory' => 'integer', 'inventory' => 'integer', 'Details.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => false, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Products' => [] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\DetailsTable) { 'registryAlias' => 'Details', 'table' => 'details', 'alias' => 'Details', 'entityClass' => 'App\Model\Entity\Detail', 'associations' => [ (int) 0 => 'products' ], 'behaviors' => [ (int) 0 => 'Timestamp' ], 'defaultConnection' => 'default', 'connectionName' => 'default' } } /src/Controller/DetailsController.php (line 142) object(Cake\ORM\ResultSet) { 'query' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Details.id AS `Details__id`, Details.sku AS `Details__sku`, Details.product_id AS `Details__product_id`, Details.size AS `Details__size`, Details.style AS `Details__style`, Details.inventory AS `Details__inventory`, Details.modified AS `Details__modified`, Products.id AS `Products__id`, Products.sku AS `Products__sku`, Products.user_id AS `Products__user_id`, Products.brand_id AS `Products__brand_id`, Products.name AS `Products__name`, Products.description AS `Products__description`, Products.price AS `Products__price`, Products.msrp AS `Products__msrp`, Products.created AS `Products__created`, Products.modified AS `Products__modified`, Products.status AS `Products__status` FROM details Details INNER JOIN products Products ON Products.id = (Details.product_id)', 'params' => [], 'defaultTypes' => [ 'Details.id' => 'integer', 'id' => 'integer', 'Details.sku' => 'string', 'sku' => 'string', 'Details.product_id' => 'integer', 'product_id' => 'integer', 'Details.size' => 'string', 'size' => 'string', 'Details.style' => 'string', 'style' => 'string', 'Details.inventory' => 'integer', 'inventory' => 'integer', 'Details.modified' => 'datetime', 'modified' => 'datetime' ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'Products' => [] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\DetailsTable) { 'registryAlias' => 'Details', 'table' => 'details', 'alias' => 'Details', 'entityClass' => 'App\Model\Entity\Detail', 'associations' => [ (int) 0 => 'products' ], 'behaviors' => [ (int) 0 => 'Timestamp' ], 'defaultConnection' => 'default', 'connectionName' => 'default' } }, 'items' => [ (int) 0 => object(App\Model\Entity\Detail) { 'id' => (int) 1, 'sku' => null, 'product_id' => (int) 1, 'size' => 'M', 'style' => 'red/blue', 'inventory' => (int) 50, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-15T12:48:16+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 1, 'sku' => 'N103', 'user_id' => (int) 1, 'brand_id' => (int) 1, 'name' => 'Pink Pants', 'description' => 'hash', 'price' => (float) 19.5, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-10T18:58:38+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-14T18:54:40+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 1 => object(App\Model\Entity\Detail) { 'id' => (int) 2, 'sku' => null, 'product_id' => (int) 1, 'size' => 'XL', 'style' => 'deco', 'inventory' => (int) 20, 'modified' => null, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 1, 'sku' => 'N103', 'user_id' => (int) 1, 'brand_id' => (int) 1, 'name' => 'Pink Pants', 'description' => 'hash', 'price' => (float) 19.5, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-10T18:58:38+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-14T18:54:40+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 2 => object(App\Model\Entity\Detail) { 'id' => (int) 3, 'sku' => null, 'product_id' => (int) 2, 'size' => 'M', 'style' => 'red/black', 'inventory' => (int) 50, 'modified' => null, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 2, 'sku' => '100', 'user_id' => (int) 1, 'brand_id' => (int) 2, 'name' => 'Red Jacket', 'description' => 'Jacket', 'price' => (float) 100, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-11T20:43:46+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-15T12:53:09+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 3 => object(App\Model\Entity\Detail) { 'id' => (int) 4, 'sku' => null, 'product_id' => (int) 1, 'size' => 'M', 'style' => 'Another style', 'inventory' => (int) 210, 'modified' => null, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 1, 'sku' => 'N103', 'user_id' => (int) 1, 'brand_id' => (int) 1, 'name' => 'Pink Pants', 'description' => 'hash', 'price' => (float) 19.5, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-10T18:58:38+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-14T18:54:40+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 4 => object(App\Model\Entity\Detail) { 'id' => (int) 5, 'sku' => null, 'product_id' => (int) 1, 'size' => 'M', 'style' => 'last style', 'inventory' => (int) 500, 'modified' => null, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 1, 'sku' => 'N103', 'user_id' => (int) 1, 'brand_id' => (int) 1, 'name' => 'Pink Pants', 'description' => 'hash', 'price' => (float) 19.5, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-10T18:58:38+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-14T18:54:40+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 5 => object(App\Model\Entity\Detail) { 'id' => (int) 6, 'sku' => null, 'product_id' => (int) 2, 'size' => 'm', 'style' => 'another one', 'inventory' => (int) 6, 'modified' => null, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 2, 'sku' => '100', 'user_id' => (int) 1, 'brand_id' => (int) 2, 'name' => 'Red Jacket', 'description' => 'Jacket', 'price' => (float) 100, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-11T20:43:46+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-15T12:53:09+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 6 => object(App\Model\Entity\Detail) { 'id' => (int) 7, 'sku' => null, 'product_id' => (int) 2, 'size' => 'XS', 'style' => 'another one', 'inventory' => null, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-15T12:53:41+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 2, 'sku' => '100', 'user_id' => (int) 1, 'brand_id' => (int) 2, 'name' => 'Red Jacket', 'description' => 'Jacket', 'price' => (float) 100, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-11T20:43:46+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-15T12:53:09+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 7 => object(App\Model\Entity\Detail) { 'id' => (int) 8, 'sku' => null, 'product_id' => (int) 1, 'size' => 'S', 'style' => 'red/blue', 'inventory' => (int) 10, 'modified' => null, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 1, 'sku' => 'N103', 'user_id' => (int) 1, 'brand_id' => (int) 1, 'name' => 'Pink Pants', 'description' => 'hash', 'price' => (float) 19.5, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-10T18:58:38+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-14T18:54:40+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 8 => object(App\Model\Entity\Detail) { 'id' => (int) 9, 'sku' => null, 'product_id' => (int) 4, 'size' => 'M', 'style' => 'another one', 'inventory' => (int) 100, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-15T13:05:29+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 4, 'sku' => 'N100', 'user_id' => (int) 1, 'brand_id' => (int) 1, 'name' => 'Red Shirt', 'description' => 'red Shirt', 'price' => (float) 19, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-12T13:07:29+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-12T20:13:10+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' }, (int) 9 => object(App\Model\Entity\Detail) { 'id' => (int) 10, 'sku' => null, 'product_id' => (int) 13, 'size' => 'M', 'style' => 'blank', 'inventory' => (int) 11, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-15T13:10:01+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'product' => object(App\Model\Entity\Product) { 'id' => (int) 13, 'sku' => 'N55cb549ad9476', 'user_id' => (int) 1, 'brand_id' => (int) 2, 'name' => 'Expensive Shirt', 'description' => 'afdsdd', 'price' => (float) 1500.333, 'msrp' => null, 'created' => object(Cake\I18n\Time) { 'time' => '2015-08-12T14:08:53+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\Time) { 'time' => '2015-08-12T20:14:22+0000', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'status' => (int) 2, '[new]' => false, '[accessible]' => [ '*' => true, 'tag_string' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Products' }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[errors]' => [], '[repository]' => 'Details' } ] }