object(Cake\ORM\Query) id:0 {
'(help)' => 'This is a Query object, to get the results execute or iterate it.'
'sql' => 'SELECT Products.id AS Products__id, Products.state AS Products__state, Products.type AS Products__type, Products.position AS Products__position, Products.name AS Products__name, Products.slug AS Products__slug, Products.model AS Products__model, Products.sku AS Products__sku, Products.summary AS Products__summary, Products.image AS Products__image, Products.alttag AS Products__alttag, Products.gross_margin_group_id AS Products__gross_margin_group_id, Products.active AS Products__active, Products.stock_quantity AS Products__stock_quantity, Products.saleable_quantity AS Products__saleable_quantity, Products.backorder AS Products__backorder, Products.warranty AS Products__warranty, Products.parent_id AS Products__parent_id, Products.idba AS Products__idba, Products.is_default AS Products__is_default, Products.created AS Products__created, Products.modified AS Products__modified, ProductCodes.value AS ProductCodes__value, GrossMarginGroups.margin_value AS GrossMarginGroups__margin_value, GrossMarginGroups.active AS GrossMarginGroups__active, DeliveryMessages.id AS DeliveryMessages__id, DeliveryMessages.name AS DeliveryMessages__name, Products.brand_id AS Products__brand_id, Products.display_price AS Products__display_price, Brands.id AS Brands__id, Brands.name AS Brands__name, Brands.image AS Brands__image, DefaultProduct.id AS DefaultProduct__id, DefaultProduct.name AS DefaultProduct__name, DefaultProduct.summary AS DefaultProduct__summary, DefaultProduct.model AS DefaultProduct__model, DefaultProduct.sku AS DefaultProduct__sku, DefaultProduct.saleable_quantity AS DefaultProduct__saleable_quantity, DefaultProduct.idba AS DefaultProduct__idba, ParentProducts.id AS ParentProducts__id, ParentProducts.brand_id AS ParentProducts__brand_id, ParentProducts.slug AS ParentProducts__slug, ParentProducts.name AS ParentProducts__name FROM products Products LEFT JOIN product_categories_products ProductCategoriesProducts ON Products.id = ProductCategoriesProducts.product_id LEFT JOIN product_categories ProductCategories ON ProductCategoriesProducts.product_category_id = ProductCategories.id LEFT JOIN product_codes ProductCodes ON Products.id = ProductCodes.product_id LEFT JOIN gross_margin_groups GrossMarginGroups ON GrossMarginGroups.id = (Products.gross_margin_group_id) LEFT JOIN product_details ProductDetails ON Products.id = (ProductDetails.product_id) LEFT JOIN brands Brands ON (Brands.id = (Products.brand_id) AND Brands.deleted = :c0) LEFT JOIN products DefaultProduct ON (DefaultProduct.is_default = :c1 AND Products.id = (DefaultProduct.parent_id) AND DefaultProduct.deleted = :c2) LEFT JOIN delivery_messages DeliveryMessages ON (DeliveryMessages.id = (Products.delivery_message_id) AND DeliveryMessages.deleted = :c3) LEFT JOIN products ParentProducts ON (ParentProducts.id = (Products.parent_id) AND ParentProducts.deleted = :c4) WHERE (Products.type != :c5 AND Products.active = :c6 AND Products.parent_id IS NULL AND Products.deleted = :c7) GROUP BY Products.id ORDER BY ProductCategories.level DESC, Products.name ASC, Products.id ASC LIMIT 20 OFFSET 2160'
'params' => [
':c0' => [
'value' => false,
'type' => 'boolean',
'placeholder' => 'c0',
],
':c1' => [
'value' => true,
'type' => 'boolean',
'placeholder' => 'c1',
],
':c2' => [
'value' => false,
'type' => 'boolean',
'placeholder' => 'c2',
],
':c3' => [
'value' => false,
'type' => 'boolean',
'placeholder' => 'c3',
],
':c4' => [
'value' => false,
'type' => 'boolean',
'placeholder' => 'c4',
],
':c5' => [
'value' => 'EXTRA',
'type' => 'string',
'placeholder' => 'c5',
],
':c6' => [
'value' => true,
'type' => 'boolean',
'placeholder' => 'c6',
],
':c7' => [
'value' => false,
'type' => 'boolean',
'placeholder' => 'c7',
],
]
'defaultTypes' => [
'Products__id' => 'biginteger',
'Products.id' => 'biginteger',
'id' => 'biginteger',
'Products__updater_id' => 'biginteger',
'Products.updater_id' => 'biginteger',
'updater_id' => 'biginteger',
'Products__user_id' => 'biginteger',
'Products.user_id' => 'biginteger',
'user_id' => 'biginteger',
'Products__modified_user_id' => 'biginteger',
'Products.modified_user_id' => 'biginteger',
'modified_user_id' => 'biginteger',
'Products__api_client_id' => 'biginteger',
'Products.api_client_id' => 'biginteger',
'api_client_id' => 'biginteger',
'Products__product_status_id' => 'integer',
'Products.product_status_id' => 'integer',
'product_status_id' => 'integer',
'Products__manufacturer_id' => 'integer',
'Products.manufacturer_id' => 'integer',
'manufacturer_id' => 'integer',
'Products__brand_id' => 'integer',
'Products.brand_id' => 'integer',
'brand_id' => 'integer',
'Products__product_additional_content_id' => 'biginteger',
'Products.product_additional_content_id' => 'biginteger',
'product_additional_content_id' => 'biginteger',
'Products__product_shipping_availability_id' => 'integer',
'Products.product_shipping_availability_id' => 'integer',
'product_shipping_availability_id' => 'integer',
'Products__gross_margin_group_id' => 'biginteger',
'Products.gross_margin_group_id' => 'biginteger',
'gross_margin_group_id' => 'biginteger',
'Products__product_unit_id' => 'integer',
'Products.product_unit_id' => 'integer',
'product_unit_id' => 'integer',
'Products__energy_class_id' => 'integer',
'Products.energy_class_id' => 'integer',
'energy_class_id' => 'integer',
'Products__parent_id' => 'biginteger',
'Products.parent_id' => 'biginteger',
'parent_id' => 'biginteger',
'Products__product_delivery_type_id' => 'integer',
'Products.product_delivery_type_id' => 'integer',
'product_delivery_type_id' => 'integer',
'Products__state' => 'string',
'Products.state' => 'string',
'state' => 'string',
'Products__type' => 'string',
'Products.type' => 'string',
'type' => 'string',
'Products__position' => 'integer',
'Products.position' => 'integer',
'position' => 'integer',
'Products__name' => 'string',
'Products.name' => 'string',
'name' => 'string',
'Products__slug' => 'string',
'Products.slug' => 'string',
'slug' => 'string',
'Products__sku' => 'string',
'Products.sku' => 'string',
'sku' => 'string',
'Products__model' => 'string',
'Products.model' => 'string',
'model' => 'string',
'Products__summary' => 'text',
'Products.summary' => 'text',
'summary' => 'text',
'Products__image' => 'string',
'Products.image' => 'string',
'image' => 'string',
'Products__alttag' => 'string',
'Products.alttag' => 'string',
'alttag' => 'string',
'Products__warranty' => 'string',
'Products.warranty' => 'string',
'warranty' => 'string',
'Products__weight' => 'float',
'Products.weight' => 'float',
'weight' => 'float',
'Products__quantity_step' => 'integer',
'Products.quantity_step' => 'integer',
'quantity_step' => 'integer',
'Products__min_quantity' => 'integer',
'Products.min_quantity' => 'integer',
'min_quantity' => 'integer',
'Products__stock_quantity' => 'integer',
'Products.stock_quantity' => 'integer',
'stock_quantity' => 'integer',
'Products__saleable_quantity' => 'integer',
'Products.saleable_quantity' => 'integer',
'saleable_quantity' => 'integer',
'Products__notify_quantity' => 'integer',
'Products.notify_quantity' => 'integer',
'notify_quantity' => 'integer',
'Products__low_stock_quantity' => 'boolean',
'Products.low_stock_quantity' => 'boolean',
'low_stock_quantity' => 'boolean',
'Products__backorder' => 'boolean',
'Products.backorder' => 'boolean',
'backorder' => 'boolean',
'Products__poa' => 'boolean',
'Products.poa' => 'boolean',
'poa' => 'boolean',
'Products__idba' => 'boolean',
'Products.idba' => 'boolean',
'idba' => 'boolean',
'Products__delivery_message_id' => 'integer',
'Products.delivery_message_id' => 'integer',
'delivery_message_id' => 'integer',
'Products__display_price' => 'boolean',
'Products.display_price' => 'boolean',
'display_price' => 'boolean',
'Products__is_hire' => 'boolean',
'Products.is_hire' => 'boolean',
'is_hire' => 'boolean',
'Products__is_default' => 'boolean',
'Products.is_default' => 'boolean',
'is_default' => 'boolean',
'Products__is_model_mandatory' => 'boolean',
'Products.is_model_mandatory' => 'boolean',
'is_model_mandatory' => 'boolean',
'Products__is_root' => 'boolean',
'Products.is_root' => 'boolean',
'is_root' => 'boolean',
'Products__feature' => 'boolean',
'Products.feature' => 'boolean',
'feature' => 'boolean',
'Products__purchasable_online' => 'boolean',
'Products.purchasable_online' => 'boolean',
'purchasable_online' => 'boolean',
'Products__active' => 'boolean',
'Products.active' => 'boolean',
'active' => 'boolean',
'Products__deleted' => 'boolean',
'Products.deleted' => 'boolean',
'deleted' => 'boolean',
'Products__created' => 'timestamp',
'Products.created' => 'timestamp',
'created' => 'timestamp',
'Products__modified' => 'timestamp',
'Products.modified' => 'timestamp',
'modified' => 'timestamp',
'ProductDetails__id' => 'biginteger',
'ProductDetails.id' => 'biginteger',
'ProductDetails__product_id' => 'biginteger',
'ProductDetails.product_id' => 'biginteger',
'product_id' => 'biginteger',
'ProductDetails__views' => 'biginteger',
'ProductDetails.views' => 'biginteger',
'views' => 'biginteger',
'ProductDetails__description' => 'text',
'ProductDetails.description' => 'text',
'description' => 'text',
'ProductDetails__seo_title' => 'string',
'ProductDetails.seo_title' => 'string',
'seo_title' => 'string',
'ProductDetails__seo_keywords' => 'string',
'ProductDetails.seo_keywords' => 'string',
'seo_keywords' => 'string',
'ProductDetails__seo_description' => 'string',
'ProductDetails.seo_description' => 'string',
'seo_description' => 'string',
'ProductDetails__og_title' => 'string',
'ProductDetails.og_title' => 'string',
'og_title' => 'string',
'ProductDetails__og_description' => 'string',
'ProductDetails.og_description' => 'string',
'og_description' => 'string',
'ProductDetails__og_image' => 'string',
'ProductDetails.og_image' => 'string',
'og_image' => 'string',
'ProductDetails__body_script' => 'text',
'ProductDetails.body_script' => 'text',
'body_script' => 'text',
'ProductDetails__image_google' => 'string',
'ProductDetails.image_google' => 'string',
'image_google' => 'string',
'ProductDetails__size_table' => 'string',
'ProductDetails.size_table' => 'string',
'size_table' => 'string',
'ProductDetails__dimm_length' => 'integer',
'ProductDetails.dimm_length' => 'integer',
'dimm_length' => 'integer',
'ProductDetails__dimm_width' => 'integer',
'ProductDetails.dimm_width' => 'integer',
'dimm_width' => 'integer',
'ProductDetails__dimm_height' => 'integer',
'ProductDetails.dimm_height' => 'integer',
'dimm_height' => 'integer',
'ProductDetails__dimm_diameter' => 'string',
'ProductDetails.dimm_diameter' => 'string',
'dimm_diameter' => 'string',
'ProductDetails__created' => 'timestamp',
'ProductDetails.created' => 'timestamp',
'ProductDetails__modified' => 'timestamp',
'ProductDetails.modified' => 'timestamp',
'ProductPrices__id' => 'biginteger',
'ProductPrices.id' => 'biginteger',
'ProductPrices__product_id' => 'biginteger',
'ProductPrices.product_id' => 'biginteger',
'ProductPrices__product_price_type_id' => 'integer',
'ProductPrices.product_price_type_id' => 'integer',
'product_price_type_id' => 'integer',
'ProductPrices__position' => 'tinyinteger',
'ProductPrices.position' => 'tinyinteger',
'ProductPrices__value' => 'decimal',
'ProductPrices.value' => 'decimal',
'value' => 'decimal',
'ProductPrices__discount_percent' => 'decimal',
'ProductPrices.discount_percent' => 'decimal',
'discount_percent' => 'decimal',
'ProductPrices__valid_until' => 'datetime',
'ProductPrices.valid_until' => 'datetime',
'valid_until' => 'datetime',
'ProductPrices__created' => 'timestamp',
'ProductPrices.created' => 'timestamp',
'ProductPrices__modified' => 'timestamp',
'ProductPrices.modified' => 'timestamp',
'GrossMarginGroups__id' => 'biginteger',
'GrossMarginGroups.id' => 'biginteger',
'GrossMarginGroups__name' => 'string',
'GrossMarginGroups.name' => 'string',
'GrossMarginGroups__margin_value' => 'decimal',
'GrossMarginGroups.margin_value' => 'decimal',
'margin_value' => 'decimal',
'GrossMarginGroups__active' => 'boolean',
'GrossMarginGroups.active' => 'boolean',
'GrossMarginGroups__created' => 'timestamp',
'GrossMarginGroups.created' => 'timestamp',
'GrossMarginGroups__modified' => 'timestamp',
'GrossMarginGroups.modified' => 'timestamp',
'ProductPropertyQuickWins__id' => 'biginteger',
'ProductPropertyQuickWins.id' => 'biginteger',
'ProductPropertyQuickWins__name' => 'string',
'ProductPropertyQuickWins.name' => 'string',
'ProductPropertyQuickWins__description' => 'text',
'ProductPropertyQuickWins.description' => 'text',
'ProductPropertyQuickWins__type' => 'string',
'ProductPropertyQuickWins.type' => 'string',
'ProductPropertyQuickWins__icon' => 'string',
'ProductPropertyQuickWins.icon' => 'string',
'icon' => 'string',
'ProductPropertyQuickWins__deleted' => 'boolean',
'ProductPropertyQuickWins.deleted' => 'boolean',
'ProductPropertyQuickWins__created' => 'timestamp',
'ProductPropertyQuickWins.created' => 'timestamp',
'ProductPropertyQuickWins__modified' => 'timestamp',
'ProductPropertyQuickWins.modified' => 'timestamp',
'Brands__id' => 'integer',
'Brands.id' => 'integer',
'Brands__name' => 'string',
'Brands.name' => 'string',
'Brands__image' => 'string',
'Brands.image' => 'string',
'Brands__brands_count' => 'integer',
'Brands.brands_count' => 'integer',
'brands_count' => 'integer',
'Brands__active' => 'boolean',
'Brands.active' => 'boolean',
'Brands__created' => 'timestamp',
'Brands.created' => 'timestamp',
'Brands__modified' => 'timestamp',
'Brands.modified' => 'timestamp',
'Brands__deleted' => 'boolean',
'Brands.deleted' => 'boolean',
'DefaultProduct__id' => 'biginteger',
'DefaultProduct.id' => 'biginteger',
'DefaultProduct__updater_id' => 'biginteger',
'DefaultProduct.updater_id' => 'biginteger',
'DefaultProduct__user_id' => 'biginteger',
'DefaultProduct.user_id' => 'biginteger',
'DefaultProduct__modified_user_id' => 'biginteger',
'DefaultProduct.modified_user_id' => 'biginteger',
'DefaultProduct__api_client_id' => 'biginteger',
'DefaultProduct.api_client_id' => 'biginteger',
'DefaultProduct__product_status_id' => 'integer',
'DefaultProduct.product_status_id' => 'integer',
'DefaultProduct__manufacturer_id' => 'integer',
'DefaultProduct.manufacturer_id' => 'integer',
'DefaultProduct__brand_id' => 'integer',
'DefaultProduct.brand_id' => 'integer',
'DefaultProduct__product_additional_content_id' => 'biginteger',
'DefaultProduct.product_additional_content_id' => 'biginteger',
'DefaultProduct__product_shipping_availability_id' => 'integer',
'DefaultProduct.product_shipping_availability_id' => 'integer',
'DefaultProduct__gross_margin_group_id' => 'biginteger',
'DefaultProduct.gross_margin_group_id' => 'biginteger',
'DefaultProduct__product_unit_id' => 'integer',
'DefaultProduct.product_unit_id' => 'integer',
'DefaultProduct__energy_class_id' => 'integer',
'DefaultProduct.energy_class_id' => 'integer',
'DefaultProduct__parent_id' => 'biginteger',
'DefaultProduct.parent_id' => 'biginteger',
'DefaultProduct__product_delivery_type_id' => 'integer',
'DefaultProduct.product_delivery_type_id' => 'integer',
'DefaultProduct__state' => 'string',
'DefaultProduct.state' => 'string',
'DefaultProduct__type' => 'string',
'DefaultProduct.type' => 'string',
'DefaultProduct__position' => 'integer',
'DefaultProduct.position' => 'integer',
'DefaultProduct__name' => 'string',
'DefaultProduct.name' => 'string',
'DefaultProduct__slug' => 'string',
'DefaultProduct.slug' => 'string',
'DefaultProduct__sku' => 'string',
'DefaultProduct.sku' => 'string',
'DefaultProduct__model' => 'string',
'DefaultProduct.model' => 'string',
'DefaultProduct__summary' => 'text',
'DefaultProduct.summary' => 'text',
'DefaultProduct__image' => 'string',
'DefaultProduct.image' => 'string',
'DefaultProduct__alttag' => 'string',
'DefaultProduct.alttag' => 'string',
'DefaultProduct__warranty' => 'string',
'DefaultProduct.warranty' => 'string',
'DefaultProduct__weight' => 'float',
'DefaultProduct.weight' => 'float',
'DefaultProduct__quantity_step' => 'integer',
'DefaultProduct.quantity_step' => 'integer',
'DefaultProduct__min_quantity' => 'integer',
'DefaultProduct.min_quantity' => 'integer',
'DefaultProduct__stock_quantity' => 'integer',
'DefaultProduct.stock_quantity' => 'integer',
'DefaultProduct__saleable_quantity' => 'integer',
'DefaultProduct.saleable_quantity' => 'integer',
'DefaultProduct__notify_quantity' => 'integer',
'DefaultProduct.notify_quantity' => 'integer',
'DefaultProduct__low_stock_quantity' => 'boolean',
'DefaultProduct.low_stock_quantity' => 'boolean',
'DefaultProduct__backorder' => 'boolean',
'DefaultProduct.backorder' => 'boolean',
'DefaultProduct__poa' => 'boolean',
'DefaultProduct.poa' => 'boolean',
'DefaultProduct__idba' => 'boolean',
'DefaultProduct.idba' => 'boolean',
'DefaultProduct__delivery_message_id' => 'integer',
'DefaultProduct.delivery_message_id' => 'integer',
'DefaultProduct__display_price' => 'boolean',
'DefaultProduct.display_price' => 'boolean',
'DefaultProduct__is_hire' => 'boolean',
'DefaultProduct.is_hire' => 'boolean',
'DefaultProduct__is_default' => 'boolean',
'DefaultProduct.is_default' => 'boolean',
'DefaultProduct__is_model_mandatory' => 'boolean',
'DefaultProduct.is_model_mandatory' => 'boolean',
'DefaultProduct__is_root' => 'boolean',
'DefaultProduct.is_root' => 'boolean',
'DefaultProduct__feature' => 'boolean',
'DefaultProduct.feature' => 'boolean',
'DefaultProduct__purchasable_online' => 'boolean',
'DefaultProduct.purchasable_online' => 'boolean',
'DefaultProduct__active' => 'boolean',
'DefaultProduct.active' => 'boolean',
'DefaultProduct__deleted' => 'boolean',
'DefaultProduct.deleted' => 'boolean',
'DefaultProduct__created' => 'timestamp',
'DefaultProduct.created' => 'timestamp',
'DefaultProduct__modified' => 'timestamp',
'DefaultProduct.modified' => 'timestamp',
'SupplierOrders__id' => 'integer',
'SupplierOrders.id' => 'integer',
'SupplierOrders__product_id' => 'biginteger',
'SupplierOrders.product_id' => 'biginteger',
'SupplierOrders__supplier_id' => 'integer',
'SupplierOrders.supplier_id' => 'integer',
'supplier_id' => 'integer',
'SupplierOrders__supplier_status_id' => 'integer',
'SupplierOrders.supplier_status_id' => 'integer',
'supplier_status_id' => 'integer',
'SupplierOrders__quantity' => 'integer',
'SupplierOrders.quantity' => 'integer',
'quantity' => 'integer',
'SupplierOrders__ordered' => 'datetime',
'SupplierOrders.ordered' => 'datetime',
'ordered' => 'datetime',
'SupplierOrders__deleted' => 'boolean',
'SupplierOrders.deleted' => 'boolean',
'SupplierOrders__created' => 'timestamp',
'SupplierOrders.created' => 'timestamp',
'SupplierOrders__modified' => 'timestamp',
'SupplierOrders.modified' => 'timestamp',
'DeliveryMessages__id' => 'integer',
'DeliveryMessages.id' => 'integer',
'DeliveryMessages__name' => 'string',
'DeliveryMessages.name' => 'string',
'DeliveryMessages__active' => 'boolean',
'DeliveryMessages.active' => 'boolean',
'DeliveryMessages__deleted' => 'boolean',
'DeliveryMessages.deleted' => 'boolean',
'DeliveryMessages__created' => 'timestamp',
'DeliveryMessages.created' => 'timestamp',
'DeliveryMessages__modified' => 'timestamp',
'DeliveryMessages.modified' => 'timestamp',
'ParentProducts__id' => 'biginteger',
'ParentProducts.id' => 'biginteger',
'ParentProducts__updater_id' => 'biginteger',
'ParentProducts.updater_id' => 'biginteger',
'ParentProducts__user_id' => 'biginteger',
'ParentProducts.user_id' => 'biginteger',
'ParentProducts__modified_user_id' => 'biginteger',
'ParentProducts.modified_user_id' => 'biginteger',
'ParentProducts__api_client_id' => 'biginteger',
'ParentProducts.api_client_id' => 'biginteger',
'ParentProducts__product_status_id' => 'integer',
'ParentProducts.product_status_id' => 'integer',
'ParentProducts__manufacturer_id' => 'integer',
'ParentProducts.manufacturer_id' => 'integer',
'ParentProducts__brand_id' => 'integer',
'ParentProducts.brand_id' => 'integer',
'ParentProducts__product_additional_content_id' => 'biginteger',
'ParentProducts.product_additional_content_id' => 'biginteger',
'ParentProducts__product_shipping_availability_id' => 'integer',
'ParentProducts.product_shipping_availability_id' => 'integer',
'ParentProducts__gross_margin_group_id' => 'biginteger',
'ParentProducts.gross_margin_group_id' => 'biginteger',
'ParentProducts__product_unit_id' => 'integer',
'ParentProducts.product_unit_id' => 'integer',
'ParentProducts__energy_class_id' => 'integer',
'ParentProducts.energy_class_id' => 'integer',
'ParentProducts__parent_id' => 'biginteger',
'ParentProducts.parent_id' => 'biginteger',
'ParentProducts__product_delivery_type_id' => 'integer',
'ParentProducts.product_delivery_type_id' => 'integer',
'ParentProducts__state' => 'string',
'ParentProducts.state' => 'string',
'ParentProducts__type' => 'string',
'ParentProducts.type' => 'string',
'ParentProducts__position' => 'integer',
'ParentProducts.position' => 'integer',
'ParentProducts__name' => 'string',
'ParentProducts.name' => 'string',
'ParentProducts__slug' => 'string',
'ParentProducts.slug' => 'string',
'ParentProducts__sku' => 'string',
'ParentProducts.sku' => 'string',
'ParentProducts__model' => 'string',
'ParentProducts.model' => 'string',
'ParentProducts__summary' => 'text',
'ParentProducts.summary' => 'text',
'ParentProducts__image' => 'string',
'ParentProducts.image' => 'string',
'ParentProducts__alttag' => 'string',
'ParentProducts.alttag' => 'string',
'ParentProducts__warranty' => 'string',
'ParentProducts.warranty' => 'string',
'ParentProducts__weight' => 'float',
'ParentProducts.weight' => 'float',
'ParentProducts__quantity_step' => 'integer',
'ParentProducts.quantity_step' => 'integer',
'ParentProducts__min_quantity' => 'integer',
'ParentProducts.min_quantity' => 'integer',
'ParentProducts__stock_quantity' => 'integer',
'ParentProducts.stock_quantity' => 'integer',
'ParentProducts__saleable_quantity' => 'integer',
'ParentProducts.saleable_quantity' => 'integer',
'ParentProducts__notify_quantity' => 'integer',
'ParentProducts.notify_quantity' => 'integer',
'ParentProducts__low_stock_quantity' => 'boolean',
'ParentProducts.low_stock_quantity' => 'boolean',
'ParentProducts__backorder' => 'boolean',
'ParentProducts.backorder' => 'boolean',
'ParentProducts__poa' => 'boolean',
'ParentProducts.poa' => 'boolean',
'ParentProducts__idba' => 'boolean',
'ParentProducts.idba' => 'boolean',
'ParentProducts__delivery_message_id' => 'integer',
'ParentProducts.delivery_message_id' => 'integer',
'ParentProducts__display_price' => 'boolean',
'ParentProducts.display_price' => 'boolean',
'ParentProducts__is_hire' => 'boolean',
'ParentProducts.is_hire' => 'boolean',
'ParentProducts__is_default' => 'boolean',
'ParentProducts.is_default' => 'boolean',
'ParentProducts__is_model_mandatory' => 'boolean',
'ParentProducts.is_model_mandatory' => 'boolean',
'ParentProducts__is_root' => 'boolean',
'ParentProducts.is_root' => 'boolean',
'ParentProducts__feature' => 'boolean',
'ParentProducts.feature' => 'boolean',
'ParentProducts__purchasable_online' => 'boolean',
'ParentProducts.purchasable_online' => 'boolean',
'ParentProducts__active' => 'boolean',
'ParentProducts.active' => 'boolean',
'ParentProducts__deleted' => 'boolean',
'ParentProducts.deleted' => 'boolean',
'ParentProducts__created' => 'timestamp',
'ParentProducts.created' => 'timestamp',
'ParentProducts__modified' => 'timestamp',
'ParentProducts.modified' => 'timestamp',
]
'decorators' => (int) 0
'executed' => true
'hydrate' => true
'buffered' => true
'formatters' => (int) 2
'mapReducers' => (int) 0
'contain' => [
'ProductDetails' => [
],
'ProductPrices' => [
],
'GrossMarginGroups' => [
],
'ProductPropertyQuickWins' => [
'queryBuilder' => object(Closure) id:1 {
},
],
'Brands' => [
],
'DefaultProduct' => [
'queryBuilder' => object(Closure) id:2 {
},
'ProductPropertyQuickWins' => [
'queryBuilder' => object(Closure) id:3 {
},
],
],
'SupplierOrders' => [
],
'DeliveryMessages' => [
],
'ParentProducts' => [
'queryBuilder' => object(Closure) id:4 {
},
'Brands' => [
'queryBuilder' => object(Closure) id:5 {
},
],
],
]
'matching' => [
]
'extraOptions' => [
'active' => true,
'child_product' => false,
'primaryFields' => [
(int) 0 => 'Products.brand_id',
(int) 1 => 'Products.state',
(int) 2 => 'Products.display_price',
(int) 3 => 'Brands.id',
(int) 4 => 'Brands.name',
(int) 5 => 'Brands.image',
],
'query' => [
'page' => '109',
'product_category_id' => null,
],
'allowedParameters' => [
(int) 0 => 'limit',
(int) 1 => 'sort',
(int) 2 => 'page',
(int) 3 => 'direction',
],
'scope' => null,
'sort' => null,
'whitelist' => [
(int) 0 => 'limit',
(int) 1 => 'sort',
(int) 2 => 'page',
(int) 3 => 'direction',
],
]
'repository' => object(App\Model\Table\ProductsTable) id:6 {
'registryAlias' => 'Products'
'table' => 'products'
'alias' => 'Products'
'entityClass' => 'App\Model\Entity\Product'
'associations' => [
(int) 0 => 'Comments',
(int) 1 => 'Manufacturers',
(int) 2 => 'ProductStatuses',
(int) 3 => 'ProductAdditionalContents',
(int) 4 => 'ProductShippingAvailabilities',
(int) 5 => 'Brands',
(int) 6 => 'DeliveryMessages',
(int) 7 => 'ProductUnits',
(int) 8 => 'EnergyClasses',
(int) 9 => 'ProductDetails',
(int) 10 => 'ProductTestimonials',
(int) 11 => 'ProductAttachments',
(int) 12 => 'ProductProperties',
(int) 13 => 'ProductPropertyKeyFeatures',
(int) 14 => 'ProductPropertyFeatureBenefits',
(int) 15 => 'ProductPropertyHighlights',
(int) 16 => 'ProductPropertyRequirements',
(int) 17 => 'ProductPropertyQuickWins',
(int) 18 => 'ProductTabs',
(int) 19 => 'ProductAdditionalInformations',
(int) 20 => 'ProductAttributes',
(int) 21 => 'ProductCodes',
(int) 22 => 'ProductImages',
(int) 23 => 'ProductVideos',
(int) 24 => 'ProductPrices',
(int) 25 => 'ProductReviews',
(int) 26 => 'ProductCategories',
(int) 27 => 'ProductCategoriesProducts',
(int) 28 => 'ProductBadges',
(int) 29 => 'Deliveries',
(int) 30 => 'Related',
(int) 31 => 'Discounts',
(int) 32 => 'GrossMarginGroups',
(int) 33 => 'Wishlist',
(int) 34 => 'ParentProducts',
(int) 35 => 'ChildProducts',
(int) 36 => 'DefaultProduct',
(int) 37 => 'Users',
(int) 38 => 'ModifiedUsers',
(int) 39 => 'ProductCodeManufacturer',
(int) 40 => 'ProductCodeEan',
(int) 41 => 'ProductBadgesProducts',
(int) 42 => 'SupplierOrders',
(int) 43 => 'RelatedExtraProducts',
(int) 44 => 'RelatedAlternativeProducts',
(int) 45 => 'RelatedRelatedProducts',
(int) 46 => 'ProductPropertiesProducts',
]
'behaviors' => [
(int) 0 => 'SoftDelete',
(int) 1 => 'History',
(int) 2 => 'Slugify',
(int) 3 => 'Upload',
(int) 4 => 'CounterCache',
(int) 5 => 'Timestamp',
]
'defaultConnection' => 'default'
'connectionName' => 'default'
}
}