object(Cake\ORM\Query) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT Categories.id AS Categories__id, Categories.type AS Categories__type, Categories.parent_id AS Categories__parent_id, Categories.image_avatar AS Categories__image_avatar, Categories.images AS Categories__images, Categories.url_video AS Categories__url_video, Categories.type_video AS Categories__type_video, Categories.status AS Categories__status, Categories.created_by AS Categories__created_by, Categories.created AS Categories__created, Categories.position AS Categories__position, CategoriesContent.name AS CategoriesContent__name, CategoriesContent.description AS CategoriesContent__description, CategoriesContent.lang AS CategoriesContent__lang, Links.id AS Links__id, Links.url AS Links__url FROM categories Categories LEFT JOIN categories_content CategoriesContent ON Categories.id = CategoriesContent.category_id LEFT JOIN links Links ON Categories.id = Links.foreign_id WHERE (Categories.deleted = :c0 AND CategoriesContent.lang = :c1 AND Links.lang = :c2 AND Links.type = :c3 AND Links.deleted = :c4 AND Categories.type = :c5 AND Categories.id in (:c6,:c7,:c8,:c9,:c10,:c11,:c12,:c13,:c14,:c15,:c16,:c17,:c18,:c19,:c20,:c21,:c22,:c23,:c24,:c25,:c26,:c27,:c28,:c29,:c30,:c31,:c32,:c33,:c34,:c35,:c36,:c37,:c38,:c39,:c40,:c41,:c42,:c43,:c44,:c45,:c46,:c47,:c48,:c49,:c50,:c51,:c52,:c53,:c54,:c55,:c56,:c57,:c58,:c59,:c60,:c61,:c62,:c63,:c64,:c65,:c66,:c67,:c68,:c69,:c70,:c71,:c72,:c73,:c74,:c75,:c76,:c77,:c78,:c79,:c80,:c81,:c82,:c83,:c84,:c85,:c86,:c87,:c88,:c89,:c90,:c91,:c92,:c93,:c94,:c95,:c96,:c97,:c98,:c99,:c100,:c101,:c102,:c103,:c104,:c105,:c106,:c107,:c108,:c109,:c110,:c111,:c112,:c113,:c114,:c115,:c116,:c117,:c118,:c119,:c120,:c121,:c122,:c123,:c124,:c125,:c126,:c127,:c128,:c129,:c130,:c131,:c132,:c133,:c134,:c135,:c136,:c137,:c138,:c139,:c140,:c141,:c142,:c143,:c144,:c145,:c146,:c147,:c148) AND Categories.status = :c149) GROUP BY Categories.id ORDER BY Categories.position ASC, Categories.id ASC'
'params' => [
':c0' => [
'value' => (int) 0,
'type' => 'integer',
'placeholder' => 'c0',
],
':c1' => [
'value' => 'vi',
'type' => 'string',
'placeholder' => 'c1',
],
':c2' => [
'value' => 'vi',
'type' => 'string',
'placeholder' => 'c2',
],
':c3' => [
'value' => 'category_product',
'type' => 'string',
'placeholder' => 'c3',
],
':c4' => [
'value' => (int) 0,
'type' => 'boolean',
'placeholder' => 'c4',
],
':c5' => [
'value' => 'product',
'type' => 'string',
'placeholder' => 'c5',
],
':c6' => [
'value' => '159',
'type' => 'integer',
'placeholder' => 'c6',
],
':c7' => [
'value' => '216',
'type' => 'integer',
'placeholder' => 'c7',
],
':c8' => [
'value' => '218',
'type' => 'integer',
'placeholder' => 'c8',
],
':c9' => [
'value' => '217',
'type' => 'integer',
'placeholder' => 'c9',
],
':c10' => [
'value' => '161',
'type' => 'integer',
'placeholder' => 'c10',
],
':c11' => [
'value' => '213',
'type' => 'integer',
'placeholder' => 'c11',
],
':c12' => [
'value' => '212',
'type' => 'integer',
'placeholder' => 'c12',
],
':c13' => [
'value' => '160',
'type' => 'integer',
'placeholder' => 'c13',
],
':c14' => [
'value' => '215',
'type' => 'integer',
'placeholder' => 'c14',
],
':c15' => [
'value' => '214',
'type' => 'integer',
'placeholder' => 'c15',
],
':c16' => [
'value' => '16',
'type' => 'integer',
'placeholder' => 'c16',
],
':c17' => [
'value' => '22',
'type' => 'integer',
'placeholder' => 'c17',
],
':c18' => [
'value' => '211',
'type' => 'integer',
'placeholder' => 'c18',
],
':c19' => [
'value' => '208',
'type' => 'integer',
'placeholder' => 'c19',
],
':c20' => [
'value' => '192',
'type' => 'integer',
'placeholder' => 'c20',
],
':c21' => [
'value' => '21',
'type' => 'integer',
'placeholder' => 'c21',
],
':c22' => [
'value' => '275',
'type' => 'integer',
'placeholder' => 'c22',
],
':c23' => [
'value' => '197',
'type' => 'integer',
'placeholder' => 'c23',
],
':c24' => [
'value' => '196',
'type' => 'integer',
'placeholder' => 'c24',
],
':c25' => [
'value' => '20',
'type' => 'integer',
'placeholder' => 'c25',
],
':c26' => [
'value' => '325',
'type' => 'integer',
'placeholder' => 'c26',
],
':c27' => [
'value' => '321',
'type' => 'integer',
'placeholder' => 'c27',
],
':c28' => [
'value' => '207',
'type' => 'integer',
'placeholder' => 'c28',
],
':c29' => [
'value' => '206',
'type' => 'integer',
'placeholder' => 'c29',
],
':c30' => [
'value' => '19',
'type' => 'integer',
'placeholder' => 'c30',
],
':c31' => [
'value' => '18',
'type' => 'integer',
'placeholder' => 'c31',
],
':c32' => [
'value' => '17',
'type' => 'integer',
'placeholder' => 'c32',
],
':c33' => [
'value' => '13',
'type' => 'integer',
'placeholder' => 'c33',
],
':c34' => [
'value' => '15',
'type' => 'integer',
'placeholder' => 'c34',
],
':c35' => [
'value' => '14',
'type' => 'integer',
'placeholder' => 'c35',
],
':c36' => [
'value' => '143',
'type' => 'integer',
'placeholder' => 'c36',
],
':c37' => [
'value' => '144',
'type' => 'integer',
'placeholder' => 'c37',
],
':c38' => [
'value' => '257',
'type' => 'integer',
'placeholder' => 'c38',
],
':c39' => [
'value' => '252',
'type' => 'integer',
'placeholder' => 'c39',
],
':c40' => [
'value' => '244',
'type' => 'integer',
'placeholder' => 'c40',
],
':c41' => [
'value' => '243',
'type' => 'integer',
'placeholder' => 'c41',
],
':c42' => [
'value' => '242',
'type' => 'integer',
'placeholder' => 'c42',
],
':c43' => [
'value' => '241',
'type' => 'integer',
'placeholder' => 'c43',
],
':c44' => [
'value' => '240',
'type' => 'integer',
'placeholder' => 'c44',
],
':c45' => [
'value' => '239',
'type' => 'integer',
'placeholder' => 'c45',
],
':c46' => [
'value' => '238',
'type' => 'integer',
'placeholder' => 'c46',
],
':c47' => [
'value' => '253',
'type' => 'integer',
'placeholder' => 'c47',
],
':c48' => [
'value' => '254',
'type' => 'integer',
'placeholder' => 'c48',
],
':c49' => [
'value' => '247',
'type' => 'integer',
'placeholder' => 'c49',
],
':c50' => [
'value' => '246',
'type' => 'integer',
'placeholder' => 'c50',
],
':c51' => [
'value' => '23',
'type' => 'integer',
'placeholder' => 'c51',
],
':c52' => [
'value' => '28',
'type' => 'integer',
'placeholder' => 'c52',
],
':c53' => [
'value' => '127',
'type' => 'integer',
'placeholder' => 'c53',
],
':c54' => [
'value' => '135',
'type' => 'integer',
'placeholder' => 'c54',
],
':c55' => [
'value' => '138',
'type' => 'integer',
'placeholder' => 'c55',
],
':c56' => [
'value' => '137',
'type' => 'integer',
'placeholder' => 'c56',
],
':c57' => [
'value' => '136',
'type' => 'integer',
'placeholder' => 'c57',
],
':c58' => [
'value' => '128',
'type' => 'integer',
'placeholder' => 'c58',
],
':c59' => [
'value' => '134',
'type' => 'integer',
'placeholder' => 'c59',
],
':c60' => [
'value' => '133',
'type' => 'integer',
'placeholder' => 'c60',
],
':c61' => [
'value' => '132',
'type' => 'integer',
'placeholder' => 'c61',
],
':c62' => [
'value' => '131',
'type' => 'integer',
'placeholder' => 'c62',
],
':c63' => [
'value' => '26',
'type' => 'integer',
'placeholder' => 'c63',
],
':c64' => [
'value' => '24',
'type' => 'integer',
'placeholder' => 'c64',
],
':c65' => [
'value' => '29',
'type' => 'integer',
'placeholder' => 'c65',
],
':c66' => [
'value' => '315',
'type' => 'integer',
'placeholder' => 'c66',
],
':c67' => [
'value' => '305',
'type' => 'integer',
'placeholder' => 'c67',
],
':c68' => [
'value' => '301',
'type' => 'integer',
'placeholder' => 'c68',
],
':c69' => [
'value' => '33',
'type' => 'integer',
'placeholder' => 'c69',
],
':c70' => [
'value' => '32',
'type' => 'integer',
'placeholder' => 'c70',
],
':c71' => [
'value' => '31',
'type' => 'integer',
'placeholder' => 'c71',
],
':c72' => [
'value' => '30',
'type' => 'integer',
'placeholder' => 'c72',
],
':c73' => [
'value' => '34',
'type' => 'integer',
'placeholder' => 'c73',
],
':c74' => [
'value' => '147',
'type' => 'integer',
'placeholder' => 'c74',
],
':c75' => [
'value' => '36',
'type' => 'integer',
'placeholder' => 'c75',
],
':c76' => [
'value' => '35',
'type' => 'integer',
'placeholder' => 'c76',
],
':c77' => [
'value' => '37',
'type' => 'integer',
'placeholder' => 'c77',
],
':c78' => [
'value' => '351',
'type' => 'integer',
'placeholder' => 'c78',
],
':c79' => [
'value' => '354',
'type' => 'integer',
'placeholder' => 'c79',
],
':c80' => [
'value' => '352',
'type' => 'integer',
'placeholder' => 'c80',
],
':c81' => [
'value' => '188',
'type' => 'integer',
'placeholder' => 'c81',
],
':c82' => [
'value' => '183',
'type' => 'integer',
'placeholder' => 'c82',
],
':c83' => [
'value' => '185',
'type' => 'integer',
'placeholder' => 'c83',
],
':c84' => [
'value' => '184',
'type' => 'integer',
'placeholder' => 'c84',
],
':c85' => [
'value' => '40',
'type' => 'integer',
'placeholder' => 'c85',
],
':c86' => [
'value' => '76',
'type' => 'integer',
'placeholder' => 'c86',
],
':c87' => [
'value' => '336',
'type' => 'integer',
'placeholder' => 'c87',
],
':c88' => [
'value' => '335',
'type' => 'integer',
'placeholder' => 'c88',
],
':c89' => [
'value' => '110',
'type' => 'integer',
'placeholder' => 'c89',
],
':c90' => [
'value' => '85',
'type' => 'integer',
'placeholder' => 'c90',
],
':c91' => [
'value' => '79',
'type' => 'integer',
'placeholder' => 'c91',
],
':c92' => [
'value' => '75',
'type' => 'integer',
'placeholder' => 'c92',
],
':c93' => [
'value' => '346',
'type' => 'integer',
'placeholder' => 'c93',
],
':c94' => [
'value' => '334',
'type' => 'integer',
'placeholder' => 'c94',
],
':c95' => [
'value' => '175',
'type' => 'integer',
'placeholder' => 'c95',
],
':c96' => [
'value' => '109',
'type' => 'integer',
'placeholder' => 'c96',
],
':c97' => [
'value' => '108',
'type' => 'integer',
'placeholder' => 'c97',
],
':c98' => [
'value' => '107',
'type' => 'integer',
'placeholder' => 'c98',
],
':c99' => [
'value' => '106',
'type' => 'integer',
'placeholder' => 'c99',
],
':c100' => [
'value' => '105',
'type' => 'integer',
'placeholder' => 'c100',
],
':c101' => [
'value' => '103',
'type' => 'integer',
'placeholder' => 'c101',
],
':c102' => [
'value' => '102',
'type' => 'integer',
'placeholder' => 'c102',
],
':c103' => [
'value' => '39',
'type' => 'integer',
'placeholder' => 'c103',
],
':c104' => [
'value' => '86',
'type' => 'integer',
'placeholder' => 'c104',
],
':c105' => [
'value' => '118',
'type' => 'integer',
'placeholder' => 'c105',
],
':c106' => [
'value' => '114',
'type' => 'integer',
'placeholder' => 'c106',
],
':c107' => [
'value' => '71',
'type' => 'integer',
'placeholder' => 'c107',
],
':c108' => [
'value' => '87',
'type' => 'integer',
'placeholder' => 'c108',
],
':c109' => [
'value' => '112',
'type' => 'integer',
'placeholder' => 'c109',
],
':c110' => [
'value' => '111',
'type' => 'integer',
'placeholder' => 'c110',
],
':c111' => [
'value' => '38',
'type' => 'integer',
'placeholder' => 'c111',
],
':c112' => [
'value' => '41',
'type' => 'integer',
'placeholder' => 'c112',
],
':c113' => [
'value' => '353',
'type' => 'integer',
'placeholder' => 'c113',
],
':c114' => [
'value' => '99',
'type' => 'integer',
'placeholder' => 'c114',
],
':c115' => [
'value' => '140',
'type' => 'integer',
'placeholder' => 'c115',
],
':c116' => [
'value' => '139',
'type' => 'integer',
'placeholder' => 'c116',
],
':c117' => [
'value' => '43',
'type' => 'integer',
'placeholder' => 'c117',
],
':c118' => [
'value' => '360',
'type' => 'integer',
'placeholder' => 'c118',
],
':c119' => [
'value' => '176',
'type' => 'integer',
'placeholder' => 'c119',
],
':c120' => [
'value' => '90',
'type' => 'integer',
'placeholder' => 'c120',
],
':c121' => [
'value' => '42',
'type' => 'integer',
'placeholder' => 'c121',
],
':c122' => [
'value' => '191',
'type' => 'integer',
'placeholder' => 'c122',
],
':c123' => [
'value' => '141',
'type' => 'integer',
'placeholder' => 'c123',
],
':c124' => [
'value' => '94',
'type' => 'integer',
'placeholder' => 'c124',
],
':c125' => [
'value' => '44',
'type' => 'integer',
'placeholder' => 'c125',
],
':c126' => [
'value' => '338',
'type' => 'integer',
'placeholder' => 'c126',
],
':c127' => [
'value' => '323',
'type' => 'integer',
'placeholder' => 'c127',
],
':c128' => [
'value' => '47',
'type' => 'integer',
'placeholder' => 'c128',
],
':c129' => [
'value' => '358',
'type' => 'integer',
'placeholder' => 'c129',
],
':c130' => [
'value' => '357',
'type' => 'integer',
'placeholder' => 'c130',
],
':c131' => [
'value' => '356',
'type' => 'integer',
'placeholder' => 'c131',
],
':c132' => [
'value' => '231',
'type' => 'integer',
'placeholder' => 'c132',
],
':c133' => [
'value' => '230',
'type' => 'integer',
'placeholder' => 'c133',
],
':c134' => [
'value' => '229',
'type' => 'integer',
'placeholder' => 'c134',
],
':c135' => [
'value' => '57',
'type' => 'integer',
'placeholder' => 'c135',
],
':c136' => [
'value' => '148',
'type' => 'integer',
'placeholder' => 'c136',
],
':c137' => [
'value' => '46',
'type' => 'integer',
'placeholder' => 'c137',
],
':c138' => [
'value' => '88',
'type' => 'integer',
'placeholder' => 'c138',
],
':c139' => [
'value' => '70',
'type' => 'integer',
'placeholder' => 'c139',
],
':c140' => [
'value' => '68',
'type' => 'integer',
'placeholder' => 'c140',
],
':c141' => [
'value' => '67',
'type' => 'integer',
'placeholder' => 'c141',
],
':c142' => [
'value' => '66',
'type' => 'integer',
'placeholder' => 'c142',
],
':c143' => [
'value' => '52',
'type' => 'integer',
'placeholder' => 'c143',
],
':c144' => [
'value' => '45',
'type' => 'integer',
'placeholder' => 'c144',
],
':c145' => [
'value' => '65',
'type' => 'integer',
'placeholder' => 'c145',
],
':c146' => [
'value' => '74',
'type' => 'integer',
'placeholder' => 'c146',
],
':c147' => [
'value' => '73',
'type' => 'integer',
'placeholder' => 'c147',
],
':c148' => [
'value' => '64',
'type' => 'integer',
'placeholder' => 'c148',
],
':c149' => [
'value' => (int) 1,
'type' => 'integer',
'placeholder' => 'c149',
],
]
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__type' => 'string',
'Categories.type' => 'string',
'type' => 'string',
'Categories__parent_id' => 'integer',
'Categories.parent_id' => 'integer',
'parent_id' => 'integer',
'Categories__path_id' => 'string',
'Categories.path_id' => 'string',
'path_id' => 'string',
'Categories__image_avatar' => 'string',
'Categories.image_avatar' => 'string',
'image_avatar' => 'string',
'Categories__images' => 'text',
'Categories.images' => 'text',
'images' => 'text',
'Categories__url_video' => 'string',
'Categories.url_video' => 'string',
'url_video' => 'string',
'Categories__type_video' => 'string',
'Categories.type_video' => 'string',
'type_video' => 'string',
'Categories__created_by' => 'integer',
'Categories.created_by' => 'integer',
'created_by' => 'integer',
'Categories__created' => 'integer',
'Categories.created' => 'integer',
'created' => 'integer',
'Categories__updated' => 'integer',
'Categories.updated' => 'integer',
'updated' => 'integer',
'Categories__position' => 'integer',
'Categories.position' => 'integer',
'position' => 'integer',
'Categories__status' => 'integer',
'Categories.status' => 'integer',
'status' => 'integer',
'Categories__deleted' => 'integer',
'Categories.deleted' => 'integer',
'deleted' => 'integer',
'CategoriesContent__id' => 'integer',
'CategoriesContent.id' => 'integer',
'CategoriesContent__category_id' => 'integer',
'CategoriesContent.category_id' => 'integer',
'category_id' => 'integer',
'CategoriesContent__name' => 'string',
'CategoriesContent.name' => 'string',
'name' => 'string',
'CategoriesContent__search_unicode' => 'text',
'CategoriesContent.search_unicode' => 'text',
'search_unicode' => 'text',
'CategoriesContent__description' => 'text',
'CategoriesContent.description' => 'text',
'description' => 'text',
'CategoriesContent__content' => 'text',
'CategoriesContent.content' => 'text',
'content' => 'text',
'CategoriesContent__seo_title' => 'string',
'CategoriesContent.seo_title' => 'string',
'seo_title' => 'string',
'CategoriesContent__seo_description' => 'string',
'CategoriesContent.seo_description' => 'string',
'seo_description' => 'string',
'CategoriesContent__seo_keyword' => 'string',
'CategoriesContent.seo_keyword' => 'string',
'seo_keyword' => 'string',
'CategoriesContent__lang' => 'string',
'CategoriesContent.lang' => 'string',
'lang' => 'string',
'Links__id' => 'integer',
'Links.id' => 'integer',
'Links__foreign_id' => 'integer',
'Links.foreign_id' => 'integer',
'foreign_id' => 'integer',
'Links__type' => 'string',
'Links.type' => 'string',
'Links__url' => 'string',
'Links.url' => 'string',
'url' => 'string',
'Links__lang' => 'string',
'Links.lang' => 'string',
'Links__created' => 'integer',
'Links.created' => 'integer',
'Links__updated' => 'integer',
'Links.updated' => 'integer',
'Links__deleted' => 'boolean',
'Links.deleted' => 'boolean',
]
'decorators' => (int) 0
'executed' => false
'hydrate' => true
'buffered' => true
'formatters' => (int) 0
'mapReducers' => (int) 0
'contain' => [
'CategoriesContent' => [
],
'Links' => [
],
]
'matching' => [
]
'extraOptions' => [
]
'repository' => object(App\Model\Table\CategoriesTable) id:1 {
'registryAlias' => 'Categories'
'table' => 'categories'
'alias' => 'Categories'
'entityClass' => 'Cake\ORM\Entity'
'associations' => [
(int) 0 => 'CategoriesContent',
(int) 1 => 'Links',
(int) 2 => 'User',
(int) 3 => 'ContentMutiple',
(int) 4 => 'LinksMutiple',
(int) 5 => 'CategoriesAttribute',
]
'behaviors' => [
(int) 0 => 'UnixTimestamp',
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}