Cake\ORM\Query Object
(
[(help)] => This is a Query object, to get the results execute or iterate it.
[sql] => SELECT p.attribute_value AS `merk`, q.attribute_value AS `model`, Products.id AS `Products__id`, Products.menu_id AS `Products__menu_id`, Products.product_name AS `Products__product_name`, Products.slug AS `Products__slug`, Products.serial_no AS `Products__serial_no`, Products.meta_title AS `Products__meta_title`, Products.meta_keyword AS `Products__meta_keyword`, Products.meta_description AS `Products__meta_description`, Products.meta_robot_indexed AS `Products__meta_robot_indexed`, Products.title AS `Products__title`, Products.short_description AS `Products__short_description`, Products.long_description AS `Products__long_description`, Products.content_image AS `Products__content_image`, Products.image_position AS `Products__image_position`, Products.header_image AS `Products__header_image`, Products.header_text AS `Products__header_text`, Products.header_subtext AS `Products__header_subtext`, Products.header_button_text AS `Products__header_button_text`, Products.header_button_url AS `Products__header_button_url`, Products.banner_image AS `Products__banner_image`, Products.banner_text AS `Products__banner_text`, Products.banner_subtext AS `Products__banner_subtext`, Products.banner_button_text AS `Products__banner_button_text`, Products.banner_button_url AS `Products__banner_button_url`, Products.images AS `Products__images`, Products.status AS `Products__status`, Products.created_by AS `Products__created_by`, Products.created_at AS `Products__created_at`, Products.modified_by AS `Products__modified_by`, Products.modified_at AS `Products__modified_at`, Products.view_count AS `Products__view_count` FROM products Products LEFT JOIN product_attributes p ON (p.product_id = Products.id AND p.attribute_field_name = "merk") LEFT JOIN product_attributes q ON (q.product_id = Products.id AND q.attribute_field_name = "model") WHERE Products.status = :c0 ORDER BY Products.modified_at DESC LIMIT 1000
[params] => Array
(
[:c0] => Array
(
[value] => Y
[type] => string
[placeholder] => c0
)
)
[defaultTypes] => Array
(
[Products__id] => integer
[Products.id] => integer
[id] => integer
[Products__menu_id] => integer
[Products.menu_id] => integer
[menu_id] => integer
[Products__product_name] => string
[Products.product_name] => string
[product_name] => string
[Products__slug] => text
[Products.slug] => text
[slug] => text
[Products__serial_no] => integer
[Products.serial_no] => integer
[serial_no] => integer
[Products__meta_title] => string
[Products.meta_title] => string
[meta_title] => string
[Products__meta_keyword] => text
[Products.meta_keyword] => text
[meta_keyword] => text
[Products__meta_description] => text
[Products.meta_description] => text
[meta_description] => text
[Products__meta_robot_indexed] => integer
[Products.meta_robot_indexed] => integer
[meta_robot_indexed] => integer
[Products__title] => string
[Products.title] => string
[title] => string
[Products__short_description] => text
[Products.short_description] => text
[short_description] => text
[Products__long_description] => text
[Products.long_description] => text
[long_description] => text
[Products__content_image] => text
[Products.content_image] => text
[content_image] => text
[Products__image_position] => string
[Products.image_position] => string
[image_position] => string
[Products__header_image] => text
[Products.header_image] => text
[header_image] => text
[Products__header_text] => string
[Products.header_text] => string
[header_text] => string
[Products__header_subtext] => string
[Products.header_subtext] => string
[header_subtext] => string
[Products__header_button_text] => string
[Products.header_button_text] => string
[header_button_text] => string
[Products__header_button_url] => text
[Products.header_button_url] => text
[header_button_url] => text
[Products__banner_image] => text
[Products.banner_image] => text
[banner_image] => text
[Products__banner_text] => string
[Products.banner_text] => string
[banner_text] => string
[Products__banner_subtext] => string
[Products.banner_subtext] => string
[banner_subtext] => string
[Products__banner_button_text] => string
[Products.banner_button_text] => string
[banner_button_text] => string
[Products__banner_button_url] => text
[Products.banner_button_url] => text
[banner_button_url] => text
[Products__images] => text
[Products.images] => text
[images] => text
[Products__status] => string
[Products.status] => string
[status] => string
[Products__created_by] => integer
[Products.created_by] => integer
[created_by] => integer
[Products__created_at] => datetime
[Products.created_at] => datetime
[created_at] => datetime
[Products__modified_by] => integer
[Products.modified_by] => integer
[modified_by] => integer
[Products__modified_at] => datetime
[Products.modified_at] => datetime
[modified_at] => datetime
[Products__view_count] => integer
[Products.view_count] => integer
[view_count] => integer
)
[decorators] => 0
[executed] => 1
[hydrate] => 1
[buffered] => 1
[formatters] => 0
[mapReducers] => 0
[contain] => Array
(
)
[matching] => Array
(
)
[extraOptions] => Array
(
)
[repository] => App\Model\Table\ProductsTable Object
(
[registryAlias] => Products
[table] => products
[alias] => Products
[entityClass] => App\Model\Entity\Product
[associations] => Array
(
[0] => menus
[1] => productattributes
[2] => productheaders
[3] => productothercontents
)
[behaviors] => Array
(
)
[defaultConnection] => default
[connectionName] => default
)
)
