Gamme de produits
TOUS NOS PRODUITS SE DÉCLINENT DANS LES 2 GAMMES
Code Context
" alt="COGNAC"/>
COGNAC
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 10,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => null,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => '',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 0include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98
Code Context
" alt="PINEAU"/>
PINEAU
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 11,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => null,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => '',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {},
(int) 1 => object(Media\Model\Entity\Media) {},
(int) 2 => object(Media\Model\Entity\Media) {},
(int) 3 => object(Media\Model\Entity\Media) {},
(int) 4 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 1include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98
Code Context
" alt="LIQUEURS"/>
LIQUEURS
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 12,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => null,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => '',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {},
(int) 1 => object(Media\Model\Entity\Media) {},
(int) 2 => object(Media\Model\Entity\Media) {},
(int) 3 => object(Media\Model\Entity\Media) {},
(int) 4 => object(Media\Model\Entity\Media) {},
(int) 5 => object(Media\Model\Entity\Media) {},
(int) 6 => object(Media\Model\Entity\Media) {},
(int) 7 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 2include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98
Code Context
" alt="VINS"/>
VINS
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 13,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => null,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => '',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 3include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98
Code Context
" alt="RHUM"/>
RHUM
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 14,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => null,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => '',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {},
(int) 1 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 4include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98
Code Context
" alt="CHAMPAGNE"/>
CHAMPAGNE
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 15,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => null,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => '',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 5include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98
Code Context
" alt="SPIRITUEUX DIVERS"/>
SPIRITUEUX DIVERS
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 16,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => (int) 209,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => '',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 6include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98
Code Context
" alt="PRODUITS DIVERS"/>
PRODUITS DIVERS
<span class="overlay-link"><img src="<?= $v->thumb->file ?>" alt="<?= $v->translation($lang)->name ?>"/><span class="overlay-info">
$viewFile = '/home/opurecreation/chollet/src/Template/Categories/show.ctp'
$dataForView = [
'medias' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [[maximum depth reached]],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(Media\Model\Table\MediasTable) {}
},
'works' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\WorksTable) {}
},
'categories' => object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
[maximum depth reached]
],
'defaultTypes' => [
[maximum depth reached]
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
[maximum depth reached]
],
'matching' => [[maximum depth reached]],
'extraOptions' => [[maximum depth reached]],
'repository' => object(App\Model\Table\CategoriesTable) {}
},
'cat' => object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
[maximum depth reached]
],
'thumb' => null,
'media' => [
[maximum depth reached]
],
'_locale' => 'en_FR',
'_translations' => [
[maximum depth reached]
],
'[new]' => false,
'[accessible]' => [
[maximum depth reached]
],
'[dirty]' => [
[maximum depth reached]
],
'[original]' => [[maximum depth reached]],
'[virtual]' => [[maximum depth reached]],
'[errors]' => [[maximum depth reached]],
'[invalid]' => [[maximum depth reached]],
'[repository]' => 'Categories'
},
'lang' => 'fr'
]
$medias = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Media.id AS `Media__id`, Media.ref AS `Media__ref`, Media.ref_id AS `Media__ref_id`, Media.file AS `Media__file`, Media.position AS `Media__position`, Media.name AS `Media__name`, Media.active AS `Media__active`, Media.accueil AS `Media__accueil`, Media.portrait AS `Media__portrait`, Media.content AS `Media__content`, Media.lien AS `Media__lien`, Media.large AS `Media__large`, Media.background AS `Media__background` FROM medias Media WHERE (Media.ref_id = :c0 AND Media.ref = :c1) ORDER BY position ASC',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Media__id' => 'integer',
'Media.id' => 'integer',
'id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 0,
'mapReducers' => (int) 0,
'contain' => [],
'matching' => [],
'extraOptions' => [],
'repository' => object(Media\Model\Table\MediasTable) {}
}
$works = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Works.id AS `Works__id`, Works.name AS `Works__name`, Works.content AS `Works__content`, Works.content2 AS `Works__content2`, Works.online AS `Works__online`, Works.media_id AS `Works__media_id`, Works.category_id AS `Works__category_id`, Works.type AS `Works__type`, Works.slug AS `Works__slug`, Works.meta AS `Works__meta`, Works.keywords AS `Works__keywords`, Works.position AS `Works__position`, Works.portrait AS `Works__portrait`, Works.accueil AS `Works__accueil`, Works.fournisseur AS `Works__fournisseur`, Works.optiontexte AS `Works__optiontexte`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Works_name_translation.id AS `Works_name_translation__id`, Works_name_translation.locale AS `Works_name_translation__locale`, Works_name_translation.model AS `Works_name_translation__model`, Works_name_translation.foreign_key AS `Works_name_translation__foreign_key`, Works_name_translation.field AS `Works_name_translation__field`, Works_name_translation.content AS `Works_name_translation__content`, Works_slug_translation.id AS `Works_slug_translation__id`, Works_slug_translation.locale AS `Works_slug_translation__locale`, Works_slug_translation.model AS `Works_slug_translation__model`, Works_slug_translation.foreign_key AS `Works_slug_translation__foreign_key`, Works_slug_translation.field AS `Works_slug_translation__field`, Works_slug_translation.content AS `Works_slug_translation__content`, Works_content_translation.id AS `Works_content_translation__id`, Works_content_translation.locale AS `Works_content_translation__locale`, Works_content_translation.model AS `Works_content_translation__model`, Works_content_translation.foreign_key AS `Works_content_translation__foreign_key`, Works_content_translation.field AS `Works_content_translation__field`, Works_content_translation.content AS `Works_content_translation__content`, Works_content2_translation.id AS `Works_content2_translation__id`, Works_content2_translation.locale AS `Works_content2_translation__locale`, Works_content2_translation.model AS `Works_content2_translation__model`, Works_content2_translation.foreign_key AS `Works_content2_translation__foreign_key`, Works_content2_translation.field AS `Works_content2_translation__field`, Works_content2_translation.content AS `Works_content2_translation__content` FROM works Works LEFT JOIN medias Thumb ON Thumb.id = (Works.media_id) LEFT JOIN i18n Works_name_translation ON (Works_name_translation.model = :c0 AND Works_name_translation.field = :c1 AND Works_name_translation.locale = :c2 AND Works.id = (Works_name_translation.foreign_key)) LEFT JOIN i18n Works_slug_translation ON (Works_slug_translation.model = :c3 AND Works_slug_translation.field = :c4 AND Works_slug_translation.locale = :c5 AND Works.id = (Works_slug_translation.foreign_key)) LEFT JOIN i18n Works_content_translation ON (Works_content_translation.model = :c6 AND Works_content_translation.field = :c7 AND Works_content_translation.locale = :c8 AND Works.id = (Works_content_translation.foreign_key)) LEFT JOIN i18n Works_content2_translation ON (Works_content2_translation.model = :c9 AND Works_content2_translation.field = :c10 AND Works_content2_translation.locale = :c11 AND Works.id = (Works_content2_translation.foreign_key)) WHERE (Works.category_id = :c12 AND Works.online = :c13)',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
],
':c12' => [
[maximum depth reached]
],
':c13' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Works__id' => 'integer',
'Works.id' => 'integer',
'id' => 'integer',
'Works__name' => 'string',
'Works.name' => 'string',
'name' => 'string',
'Works__content' => 'text',
'Works.content' => 'text',
'content' => 'text',
'Works__content2' => 'text',
'Works.content2' => 'text',
'content2' => 'text',
'Works__online' => 'integer',
'Works.online' => 'integer',
'online' => 'integer',
'Works__media_id' => 'integer',
'Works.media_id' => 'integer',
'media_id' => 'integer',
'Works__category_id' => 'integer',
'Works.category_id' => 'integer',
'category_id' => 'integer',
'Works__type' => 'string',
'Works.type' => 'string',
'type' => 'string',
'Works__slug' => 'string',
'Works.slug' => 'string',
'slug' => 'string',
'Works__meta' => 'string',
'Works.meta' => 'string',
'meta' => 'string',
'Works__keywords' => 'string',
'Works.keywords' => 'string',
'keywords' => 'string',
'Works__position' => 'integer',
'Works.position' => 'integer',
'position' => 'integer',
'Works__portrait' => 'integer',
'Works.portrait' => 'integer',
'portrait' => 'integer',
'Works__accueil' => 'integer',
'Works.accueil' => 'integer',
'accueil' => 'integer',
'Works__fournisseur' => 'integer',
'Works.fournisseur' => 'integer',
'fournisseur' => 'integer',
'Works__optiontexte' => 'string',
'Works.optiontexte' => 'string',
'optiontexte' => 'string',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Works_name_translation__id' => 'integer',
'Works_name_translation.id' => 'integer',
'Works_name_translation__locale' => 'string',
'Works_name_translation.locale' => 'string',
'Works_name_translation__model' => 'string',
'Works_name_translation.model' => 'string',
'Works_name_translation__foreign_key' => 'integer',
'Works_name_translation.foreign_key' => 'integer',
'Works_name_translation__field' => 'string',
'Works_name_translation.field' => 'string',
'Works_name_translation__content' => 'text',
'Works_name_translation.content' => 'text',
'Works_slug_translation__id' => 'integer',
'Works_slug_translation.id' => 'integer',
'Works_slug_translation__locale' => 'string',
'Works_slug_translation.locale' => 'string',
'Works_slug_translation__model' => 'string',
'Works_slug_translation.model' => 'string',
'Works_slug_translation__foreign_key' => 'integer',
'Works_slug_translation.foreign_key' => 'integer',
'Works_slug_translation__field' => 'string',
'Works_slug_translation.field' => 'string',
'Works_slug_translation__content' => 'text',
'Works_slug_translation.content' => 'text',
'Works_content_translation__id' => 'integer',
'Works_content_translation.id' => 'integer',
'Works_content_translation__locale' => 'string',
'Works_content_translation.locale' => 'string',
'Works_content_translation__model' => 'string',
'Works_content_translation.model' => 'string',
'Works_content_translation__foreign_key' => 'integer',
'Works_content_translation.foreign_key' => 'integer',
'Works_content_translation__field' => 'string',
'Works_content_translation.field' => 'string',
'Works_content_translation__content' => 'text',
'Works_content_translation.content' => 'text',
'Works_content2_translation__id' => 'integer',
'Works_content2_translation.id' => 'integer',
'Works_content2_translation__locale' => 'string',
'Works_content2_translation.locale' => 'string',
'Works_content2_translation__model' => 'string',
'Works_content2_translation.model' => 'string',
'Works_content2_translation__foreign_key' => 'integer',
'Works_content2_translation.foreign_key' => 'integer',
'Works_content2_translation__field' => 'string',
'Works_content2_translation.field' => 'string',
'Works_content2_translation__content' => 'text',
'Works_content2_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => true,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Works_name_translation' => [
[maximum depth reached]
],
'Works_slug_translation' => [
[maximum depth reached]
],
'Works_content_translation' => [
[maximum depth reached]
],
'Works_content2_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\WorksTable) {}
}
$categories = object(Cake\ORM\Query) {
'(help)' => 'This is a Query object, to get the results execute or iterate it.',
'sql' => 'SELECT Categories.id AS `Categories__id`, Categories.name AS `Categories__name`, Categories.content AS `Categories__content`, Categories.online AS `Categories__online`, Categories.media_id AS `Categories__media_id`, Categories.slug AS `Categories__slug`, Categories.content2 AS `Categories__content2`, Thumb.id AS `Thumb__id`, Thumb.ref AS `Thumb__ref`, Thumb.ref_id AS `Thumb__ref_id`, Thumb.file AS `Thumb__file`, Thumb.position AS `Thumb__position`, Thumb.name AS `Thumb__name`, Thumb.active AS `Thumb__active`, Thumb.accueil AS `Thumb__accueil`, Thumb.portrait AS `Thumb__portrait`, Thumb.content AS `Thumb__content`, Thumb.lien AS `Thumb__lien`, Thumb.large AS `Thumb__large`, Thumb.background AS `Thumb__background`, Categories_name_translation.id AS `Categories_name_translation__id`, Categories_name_translation.locale AS `Categories_name_translation__locale`, Categories_name_translation.model AS `Categories_name_translation__model`, Categories_name_translation.foreign_key AS `Categories_name_translation__foreign_key`, Categories_name_translation.field AS `Categories_name_translation__field`, Categories_name_translation.content AS `Categories_name_translation__content`, Categories_content_translation.id AS `Categories_content_translation__id`, Categories_content_translation.locale AS `Categories_content_translation__locale`, Categories_content_translation.model AS `Categories_content_translation__model`, Categories_content_translation.foreign_key AS `Categories_content_translation__foreign_key`, Categories_content_translation.field AS `Categories_content_translation__field`, Categories_content_translation.content AS `Categories_content_translation__content`, Categories_content2_translation.id AS `Categories_content2_translation__id`, Categories_content2_translation.locale AS `Categories_content2_translation__locale`, Categories_content2_translation.model AS `Categories_content2_translation__model`, Categories_content2_translation.foreign_key AS `Categories_content2_translation__foreign_key`, Categories_content2_translation.field AS `Categories_content2_translation__field`, Categories_content2_translation.content AS `Categories_content2_translation__content`, Categories_slug_translation.id AS `Categories_slug_translation__id`, Categories_slug_translation.locale AS `Categories_slug_translation__locale`, Categories_slug_translation.model AS `Categories_slug_translation__model`, Categories_slug_translation.foreign_key AS `Categories_slug_translation__foreign_key`, Categories_slug_translation.field AS `Categories_slug_translation__field`, Categories_slug_translation.content AS `Categories_slug_translation__content` FROM categories Categories LEFT JOIN medias Thumb ON Thumb.id = (Categories.media_id) LEFT JOIN i18n Categories_name_translation ON (Categories_name_translation.model = :c0 AND Categories_name_translation.field = :c1 AND Categories_name_translation.locale = :c2 AND Categories.id = (Categories_name_translation.foreign_key)) LEFT JOIN i18n Categories_content_translation ON (Categories_content_translation.model = :c3 AND Categories_content_translation.field = :c4 AND Categories_content_translation.locale = :c5 AND Categories.id = (Categories_content_translation.foreign_key)) LEFT JOIN i18n Categories_content2_translation ON (Categories_content2_translation.model = :c6 AND Categories_content2_translation.field = :c7 AND Categories_content2_translation.locale = :c8 AND Categories.id = (Categories_content2_translation.foreign_key)) LEFT JOIN i18n Categories_slug_translation ON (Categories_slug_translation.model = :c9 AND Categories_slug_translation.field = :c10 AND Categories_slug_translation.locale = :c11 AND Categories.id = (Categories_slug_translation.foreign_key))',
'params' => [
':c0' => [
[maximum depth reached]
],
':c1' => [
[maximum depth reached]
],
':c2' => [
[maximum depth reached]
],
':c3' => [
[maximum depth reached]
],
':c4' => [
[maximum depth reached]
],
':c5' => [
[maximum depth reached]
],
':c6' => [
[maximum depth reached]
],
':c7' => [
[maximum depth reached]
],
':c8' => [
[maximum depth reached]
],
':c9' => [
[maximum depth reached]
],
':c10' => [
[maximum depth reached]
],
':c11' => [
[maximum depth reached]
]
],
'defaultTypes' => [
'Categories__id' => 'integer',
'Categories.id' => 'integer',
'id' => 'integer',
'Categories__name' => 'string',
'Categories.name' => 'string',
'name' => 'string',
'Categories__content' => 'text',
'Categories.content' => 'text',
'content' => 'text',
'Categories__online' => 'integer',
'Categories.online' => 'integer',
'online' => 'integer',
'Categories__media_id' => 'integer',
'Categories.media_id' => 'integer',
'media_id' => 'integer',
'Categories__slug' => 'string',
'Categories.slug' => 'string',
'slug' => 'string',
'Categories__content2' => 'text',
'Categories.content2' => 'text',
'content2' => 'text',
'I18n__id' => 'integer',
'I18n.id' => 'integer',
'I18n__locale' => 'string',
'I18n.locale' => 'string',
'locale' => 'string',
'I18n__model' => 'string',
'I18n.model' => 'string',
'model' => 'string',
'I18n__foreign_key' => 'integer',
'I18n.foreign_key' => 'integer',
'foreign_key' => 'integer',
'I18n__field' => 'string',
'I18n.field' => 'string',
'field' => 'string',
'I18n__content' => 'text',
'I18n.content' => 'text',
'Media__id' => 'integer',
'Media.id' => 'integer',
'Media__ref' => 'string',
'Media.ref' => 'string',
'ref' => 'string',
'Media__ref_id' => 'integer',
'Media.ref_id' => 'integer',
'ref_id' => 'integer',
'Media__file' => 'string',
'Media.file' => 'string',
'file' => 'string',
'Media__position' => 'integer',
'Media.position' => 'integer',
'position' => 'integer',
'Media__name' => 'string',
'Media.name' => 'string',
'Media__active' => 'string',
'Media.active' => 'string',
'active' => 'string',
'Media__accueil' => 'string',
'Media.accueil' => 'string',
'accueil' => 'string',
'Media__portrait' => 'integer',
'Media.portrait' => 'integer',
'portrait' => 'integer',
'Media__content' => 'text',
'Media.content' => 'text',
'Media__lien' => 'string',
'Media.lien' => 'string',
'lien' => 'string',
'Media__large' => 'integer',
'Media.large' => 'integer',
'large' => 'integer',
'Media__background' => 'string',
'Media.background' => 'string',
'background' => 'string',
'Thumb__id' => 'integer',
'Thumb.id' => 'integer',
'Thumb__ref' => 'string',
'Thumb.ref' => 'string',
'Thumb__ref_id' => 'integer',
'Thumb.ref_id' => 'integer',
'Thumb__file' => 'string',
'Thumb.file' => 'string',
'Thumb__position' => 'integer',
'Thumb.position' => 'integer',
'Thumb__name' => 'string',
'Thumb.name' => 'string',
'Thumb__active' => 'string',
'Thumb.active' => 'string',
'Thumb__accueil' => 'string',
'Thumb.accueil' => 'string',
'Thumb__portrait' => 'integer',
'Thumb.portrait' => 'integer',
'Thumb__content' => 'text',
'Thumb.content' => 'text',
'Thumb__lien' => 'string',
'Thumb.lien' => 'string',
'Thumb__large' => 'integer',
'Thumb.large' => 'integer',
'Thumb__background' => 'string',
'Thumb.background' => 'string',
'Categories_name_translation__id' => 'integer',
'Categories_name_translation.id' => 'integer',
'Categories_name_translation__locale' => 'string',
'Categories_name_translation.locale' => 'string',
'Categories_name_translation__model' => 'string',
'Categories_name_translation.model' => 'string',
'Categories_name_translation__foreign_key' => 'integer',
'Categories_name_translation.foreign_key' => 'integer',
'Categories_name_translation__field' => 'string',
'Categories_name_translation.field' => 'string',
'Categories_name_translation__content' => 'text',
'Categories_name_translation.content' => 'text',
'Categories_content_translation__id' => 'integer',
'Categories_content_translation.id' => 'integer',
'Categories_content_translation__locale' => 'string',
'Categories_content_translation.locale' => 'string',
'Categories_content_translation__model' => 'string',
'Categories_content_translation.model' => 'string',
'Categories_content_translation__foreign_key' => 'integer',
'Categories_content_translation.foreign_key' => 'integer',
'Categories_content_translation__field' => 'string',
'Categories_content_translation.field' => 'string',
'Categories_content_translation__content' => 'text',
'Categories_content_translation.content' => 'text',
'Categories_content2_translation__id' => 'integer',
'Categories_content2_translation.id' => 'integer',
'Categories_content2_translation__locale' => 'string',
'Categories_content2_translation.locale' => 'string',
'Categories_content2_translation__model' => 'string',
'Categories_content2_translation.model' => 'string',
'Categories_content2_translation__foreign_key' => 'integer',
'Categories_content2_translation.foreign_key' => 'integer',
'Categories_content2_translation__field' => 'string',
'Categories_content2_translation.field' => 'string',
'Categories_content2_translation__content' => 'text',
'Categories_content2_translation.content' => 'text',
'Categories_slug_translation__id' => 'integer',
'Categories_slug_translation.id' => 'integer',
'Categories_slug_translation__locale' => 'string',
'Categories_slug_translation.locale' => 'string',
'Categories_slug_translation__model' => 'string',
'Categories_slug_translation.model' => 'string',
'Categories_slug_translation__foreign_key' => 'integer',
'Categories_slug_translation.foreign_key' => 'integer',
'Categories_slug_translation__field' => 'string',
'Categories_slug_translation.field' => 'string',
'Categories_slug_translation__content' => 'text',
'Categories_slug_translation.content' => 'text'
],
'decorators' => (int) 0,
'executed' => false,
'hydrate' => true,
'buffered' => true,
'formatters' => (int) 2,
'mapReducers' => (int) 0,
'contain' => [
'I18n' => [
[maximum depth reached]
],
'Media' => [[maximum depth reached]],
'Thumb' => [[maximum depth reached]],
'Categories_name_translation' => [
[maximum depth reached]
],
'Categories_content_translation' => [
[maximum depth reached]
],
'Categories_content2_translation' => [
[maximum depth reached]
],
'Categories_slug_translation' => [
[maximum depth reached]
]
],
'matching' => [],
'extraOptions' => [],
'repository' => object(App\Model\Table\CategoriesTable) {}
}
$cat = object(App\Model\Entity\Category) {
'id' => (int) 4,
'name' => null,
'content' => null,
'online' => (int) 1,
'media_id' => null,
'slug' => '',
'content2' => null,
'works' => [
(int) 0 => object(App\Model\Entity\Work) {},
(int) 1 => object(App\Model\Entity\Work) {},
(int) 2 => object(App\Model\Entity\Work) {},
(int) 3 => object(App\Model\Entity\Work) {},
(int) 4 => object(App\Model\Entity\Work) {},
(int) 5 => object(App\Model\Entity\Work) {},
(int) 6 => object(App\Model\Entity\Work) {},
(int) 7 => object(App\Model\Entity\Work) {}
],
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Category) {},
'en' => object(App\Model\Entity\Category) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [
'_translations' => true
],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Categories'
}
$lang = 'fr'
$v = object(App\Model\Entity\Work) {
'id' => (int) 17,
'name' => null,
'content' => null,
'content2' => null,
'online' => (int) 1,
'media_id' => null,
'category_id' => (int) 4,
'type' => 'work',
'slug' => '',
'meta' => 'various-product',
'keywords' => null,
'position' => (int) 0,
'portrait' => (int) 0,
'accueil' => (int) 0,
'fournisseur' => (int) 0,
'optiontexte' => '',
'thumb' => null,
'media' => [
(int) 0 => object(Media\Model\Entity\Media) {}
],
'_locale' => 'en_FR',
'_translations' => [
'fr' => object(App\Model\Entity\Work) {},
'en' => object(App\Model\Entity\Work) {}
],
'[new]' => false,
'[accessible]' => [
'*' => true
],
'[dirty]' => [],
'[original]' => [],
'[virtual]' => [],
'[errors]' => [],
'[invalid]' => [],
'[repository]' => 'Works'
}
$k = (int) 7include - APP/Template/Categories/show.ctp, line 77 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1240 Cake\View\View::_render() - CORE/src/View/View.php, line 1201 Cake\View\View::render() - CORE/src/View/View.php, line 803 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 790 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 235 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\RoutingMiddleware::__invoke() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 156 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Routing\Middleware\AssetMiddleware::__invoke() - CORE/src/Routing/Middleware/AssetMiddleware.php, line 88 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Error\Middleware\ErrorHandlerMiddleware::__invoke() - CORE/src/Error/Middleware/ErrorHandlerMiddleware.php, line 98 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::run() - CORE/src/Http/Runner.php, line 51 Cake\Http\Server::run() - CORE/src/Http/Server.php, line 98