Code Context 'BannerCode'=>$this->banner_code,
'Slug'=>$division,
'DivisionProductId'=>$selected_category[0][0]['DivisionProductId']))[0][0];
$greatDivision = 'dcade'
$division = 'certificats-cadeaux'
$subDivision = ''
$title = ''
$description = ''
$db = object(Sybase) {
description => 'Sybase DBO Driver'
startQuote => '['
endQuote => ']'
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'numeric' => array(
[maximum depth reached]
),
'decimal' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'real' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 2
configKeyName => 'default'
virtualFieldSeparator => '__'
tableParameters => array()
fieldParameters => array()
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => '',
'datasource' => 'SybaseDB.Sybase',
'className' => 'Cake\Database\Connection',
'timezone' => 'UTC',
'cacheMetadata' => true,
'prefix' => ''
)
cacheSources => true
map => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
),
(int) 4 => array(
[maximum depth reached]
),
(int) 5 => array(
[maximum depth reached]
),
(int) 6 => array(
[maximum depth reached]
),
(int) 7 => array(
[maximum depth reached]
),
(int) 8 => array(
[maximum depth reached]
),
(int) 9 => array(
[maximum depth reached]
),
(int) 10 => array(
[maximum depth reached]
),
(int) 11 => array(
[maximum depth reached]
),
(int) 12 => array(
[maximum depth reached]
),
(int) 13 => array(
[maximum depth reached]
),
(int) 14 => array(
[maximum depth reached]
),
(int) 15 => array(
[maximum depth reached]
),
(int) 16 => array(
[maximum depth reached]
),
(int) 17 => array(
[maximum depth reached]
),
(int) 18 => array(
[maximum depth reached]
),
(int) 19 => array(
[maximum depth reached]
),
(int) 20 => array(
[maximum depth reached]
),
(int) 21 => array(
[maximum depth reached]
),
(int) 22 => array(
[maximum depth reached]
),
(int) 23 => array(
[maximum depth reached]
),
(int) 24 => array(
[maximum depth reached]
),
(int) 25 => array(
[maximum depth reached]
),
(int) 26 => array(
[maximum depth reached]
),
(int) 27 => array(
[maximum depth reached]
),
(int) 28 => array(
[maximum depth reached]
),
(int) 29 => array(
[maximum depth reached]
)
)
[protected] _fieldMappings => array()
[protected] _lastAffected => false
[protected] _serverVersion => null
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'schema' => ''
)
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 4
[protected] _queriesTime => (float) 6
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
),
(int) 1 => array(
[maximum depth reached]
),
(int) 2 => array(
[maximum depth reached]
),
(int) 3 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array(
'
SELECT DimSubDivisionProduct.*, DimSubDivisionProductInfo.*
FROM DimSubDivisionProduct
INNER JOIN DimSubDivisionProductInfo ON DimSubDivisionProductInfo.SubDivisionProductId = DimSubDivisionProduct.SubDivisionProductId
INNER JOIN DimDivisionProduct ON DimDivisionProduct.DivisionProductId = DimSubDivisionProduct.DivisionProductId
WHERE DimSubDivisionProductInfo.BannerCode = :BannerCode
AND DimSubDivisionProductInfo.StoreCode = :StoreCode
AND SubDivisionProductIsActive = 1
AND DimSubDivisionProduct.DivisionProductId = 1078
AND DimSubDivisionProduct.SubDivisionParentId is null
ORDER BY DimSubDivisionProductInfo.SubDivisionProductInfoNameFr
' => array(
[maximum depth reached]
),
'
SELECT
DivisionProductInfoID As Id,
DimDivisionProductInfo.DivisionProductId,
DimDivisionProductInfo.BannerCode,
DimDivisionProductInfo.StoreCode,
DivisionProductInfoNameFr As NameFr,
DivisionProductInfoNameEn As NameEn,
DivisionProductInfoDescriptionFr As DescriptionFr,
DivisionProductInfoDescriptionEn As DescriptionEn,
DivisionProductInfoVideoFr As VideoFr,
DivisionProductInfoVideoEn As VideoEn,
DivisionProductInfoImagePathFr As ImagePathFr,
DivisionProductInfoImagePathEn As ImagePathEn,
DivisionProductInfoSlugFr As SlugFr,
DivisionProductInfoSlugEn As SlugEn
FROM DimDivisionProductInfo
INNER JOIN DimDivisionProduct ON DimDivisionProductInfo.DivisionProductId = DimDivisionProduct.DivisionProductId
WHERE
DimDivisionProductInfo.StoreCode = :StoreCode
AND DimDivisionProductInfo.BannerCode = :BannerCode
AND DivisionProductInfoSlugEn = :Slug
AND DivisionProductIsActive = 1
' => array(
[maximum depth reached]
),
'
SELECT *
FROM DimSubDivisionProductInfo
INNER JOIN DimSubDivisionProduct
ON DimSubDivisionProductInfo.SubDivisionProductId = DimSubDivisionProduct.SubDivisionProductId
WHERE DimSubDivisionProduct.BannerCode = :BannerCode
AND DimSubDivisionProduct.StoreCode = :StoreCode
AND DivisionProductId = :DivisionProductId
AND SubDivisionParentId IS NULL
AND SubDivisionProductIsActive = 1
AND SubDivisionProductInfoSlugEn = :Slug
' => array(
[maximum depth reached]
)
)
[protected] _connection => object(PDO) {}
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'rlike',
(int) 3 => 'or',
(int) 4 => 'not',
(int) 5 => 'in',
(int) 6 => 'between',
(int) 7 => 'regexp',
(int) 8 => 'similar to'
)
[protected] _sqlBoolOps => array(
(int) 0 => 'and',
(int) 1 => 'or',
(int) 2 => 'not',
(int) 3 => 'and not',
(int) 4 => 'or not',
(int) 5 => 'xor',
(int) 6 => '||',
(int) 7 => '&&'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => true
[protected] _descriptions => array(
'DimStoreInfo' => array(
[maximum depth reached]
)
)
[protected] _sources => array(
(int) 0 => 'DimTaxeInfo',
(int) 1 => 'DimTime',
(int) 2 => 'DimFeatureCategories',
(int) 3 => 'DimRealisationImages',
(int) 4 => 'DimTimeSlice',
(int) 5 => 'DimUsersFavorites',
(int) 6 => 'DimRealisationTypes',
(int) 7 => 'FactAchalandage',
(int) 8 => 'FactCancel',
(int) 9 => 'FactOrder',
(int) 10 => 'FactOrderAddress',
(int) 11 => 'FactOrderDelivery',
(int) 12 => 'FactOrderDetail',
(int) 13 => 'FactOrderPayment',
(int) 14 => 'FactSale',
(int) 15 => 'FactSaleHeader',
(int) 16 => 'DimFeature',
(int) 17 => 'FactSalePayment',
(int) 18 => 'FactSalePaymentNotice',
(int) 19 => 'DimPostFile',
(int) 20 => 'FactTimeSchedule',
(int) 21 => 'License',
(int) 22 => 'system_logging',
(int) 23 => 'FactInformationRequest',
(int) 24 => 'DimProductFeatures',
(int) 25 => 'DimPost',
(int) 26 => 'DimPostType',
(int) 27 => 'DimProduct',
(int) 28 => 'DimCarrier',
(int) 29 => 'DimCity',
(int) 30 => 'DimCustomer',
(int) 31 => 'dimCustomerType',
(int) 32 => 'DimQuestions',
(int) 33 => 'DimOwners',
(int) 34 => 'DimDate',
(int) 35 => 'FactOrderReservationPayment',
(int) 36 => 'DimDepartment',
(int) 37 => 'DimTripType',
(int) 38 => 'DimDepartmentInfo',
(int) 39 => 'DimReservationQuestion',
(int) 40 => 'DimMealType',
(int) 41 => 'DimDiscount',
(int) 42 => 'DimDiscountInfo',
(int) 43 => 'DimDivisionProduct',
(int) 44 => 'DimPromoCode',
(int) 45 => 'DimDivisionProductInfo',
(int) 46 => 'DimEmployee',
(int) 47 => 'DimReservation',
(int) 48 => 'DimItemType',
(int) 49 => 'DimMode',
(int) 50 => 'DimModeInfo',
(int) 51 => 'DimOrderDetailNote',
(int) 52 => 'DimPayment',
(int) 53 => 'DimPaymentInfo',
(int) 54 => 'DimStoreInfo',
(int) 55 => 'DimPOS',
(int) 56 => 'FactInformationRequestNote',
(int) 57 => 'DimPriceLevel',
(int) 58 => 'DimProductUnavailabilities',
(int) 59 => 'DimProductBrand',
(int) 60 => 'DimProductInfo',
(int) 61 => 'DimProductFeature',
(int) 62 => 'DimInformedBy',
(int) 63 => 'DimProductFile',
(int) 64 => 'DimProvenance',
(int) 65 => 'DimProductImage',
(int) 66 => 'DimFeatureReservations',
(int) 67 => 'DimProductReservations',
(int) 68 => 'DimPromotion',
(int) 69 => 'DimPromotionType',
(int) 70 => 'DimProvider',
(int) 71 => 'DimProviderType',
(int) 72 => 'FactAchalandageAnalytic',
(int) 73 => 'DimPunchEmployee',
(int) 74 => 'DimPasswordReset',
(int) 75 => 'OauthAccounts',
(int) 76 => 'DimRelatedProduct',
(int) 77 => 'FactProfiles',
(int) 78 => 'DimSource',
(int) 79 => 'DimStoreImage',
(int) 80 => 'DimSubDivisionProduct',
(int) 81 => 'DimSubDivisionProductInfo',
(int) 82 => 'DimOrderReservation',
(int) 83 => 'DimTask',
(int) 84 => 'DimTaxe',
(int) 85 => 'DimRealisations'
)
[protected] _transactionStarted => false
}
$selected_category = array(
(int) 0 => array(
(int) 0 => array(
'Id' => '29',
'DivisionProductId' => '1078',
'BannerCode' => '1006',
'StoreCode' => '10012',
'NameFr' => 'Dcade',
'NameEn' => 'Dcade',
'DescriptionFr' => 'Accessoire et item provenant de l'ancienne boutique Dcade-',
'DescriptionEn' => 'Item and accessory from the old Dcade boutique',
'VideoFr' => '',
'VideoEn' => '',
'ImagePathFr' => '',
'ImagePathEn' => '',
'SlugFr' => 'dcade',
'SlugEn' => 'dcade'
)
)
)CategoriesController::products() - APP/Controller/CategoriesController.php, line 111
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110
