Branches CMS : complexity simplified : Errors

Notice (8): Undefined offset: 2 [APP/Plugin/retail/Controller/Component/RetailCommonComponent.php, line 13981]

Code Context

            for($i=0; $i<count($items); $i++)
            {
                if($items[$i]['Catalogueitem']['prototype_id'] == $prototypes['id']['category'])

$pass = array(
	(int) 0 => 'colorama'
)
$type = 'brochure'
$chosen_options = array()
$categoryListAjax = (int) 0
$productListAjax = (int) 0
$st = (float) 1728400485.9772
$tax = array(
	'currency' => 'GBP',
	'currency_iso' => '826',
	'currency_name' => 'Pound Sterling',
	'currency_symbol' => '£',
	'currency_exponent' => '2',
	'tax_id' => '1',
	'tax_rate' => '20',
	'tax_name' => 'VAT',
	'tax_description' => 'Value Added Tax',
	'tax_list' => 'Standard',
	'tax_override' => false,
	'default_price_display' => 'inctax'
)
$tax_id = '1'
$tax_rate = '20'
$tax_name = 'VAT'
$currency_symbol = '£'
$currency_exponent = '2'
$default_price_display = 'inctax'
$page_stamp = '44_192_95_161_1728400485_978'
$prototypes = array(
	'prototypes' => array(
		(int) 0 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		)
	),
	'supplier' => array(
		'Ptype' => array(
			'id' => '354',
			'parent_id' => '498',
			'name' => 'supplier',
			'datatype' => null,
			'listview' => null,
			'created' => '2014-10-23 20:57:59',
			'modified' => '2014-10-23 20:57:59'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	'brand' => array(
		'Ptype' => array(
			'id' => '346',
			'parent_id' => '498',
			'name' => 'brand',
			'datatype' => null,
			'listview' => null,
			'created' => '2014-10-23 12:24:39',
			'modified' => '2014-10-23 12:24:39'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	'producttab' => array(
		'Ptype' => array(
			'id' => '408',
			'parent_id' => '498',
			'name' => 'producttab',
			'datatype' => null,
			'listview' => null,
			'created' => '2016-03-24 06:56:42',
			'modified' => '2016-03-24 06:57:13'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		)
	),
	'errors' => array(
		'Ptype' => array(
			'id' => '468',
			'parent_id' => '498',
			'name' => 'errors',
			'datatype' => null,
			'listview' => null,
			'created' => '2016-07-22 20:55:29',
			'modified' => '2016-07-22 20:55:29'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		)
	),
	'category' => array(
		'Ptype' => array(
			'id' => '1',
			'parent_id' => '498',
			'name' => 'category',
			'datatype' => null,
			'listview' => true,
			'created' => null,
			'modified' => null
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			)
		)
	),
	'product' => array(
		'Ptype' => array(
			'id' => '2',
			'parent_id' => '498',
			'name' => 'product',
			'datatype' => null,
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-23 12:07:52'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			),
			(int) 23 => array(
				[maximum depth reached]
			),
			(int) 24 => array(
				[maximum depth reached]
			),
			(int) 25 => array(
				[maximum depth reached]
			),
			(int) 26 => array(
				[maximum depth reached]
			),
			(int) 27 => array(
				[maximum depth reached]
			)
		)
	),
	'price' => array(
		'Ptype' => array(
			'id' => '20',
			'parent_id' => '2',
			'name' => 'price',
			'datatype' => 'find_current',
			'listview' => false,
			'created' => null,
			'modified' => '2014-10-20 04:06:21',
			'prototype_name' => 'Price',
			'prototype_type' => 'price'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			)
		)
	),
	'product_image' => array(
		'Ptype' => array(
			'id' => '13',
			'parent_id' => '2',
			'name' => 'product_image',
			'datatype' => 'allow_multiple',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-22 04:36:57',
			'prototype_name' => 'Product Images',
			'prototype_type' => 'product_image'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			)
		)
	),
	'product_image_weight' => array(
		'Ptype' => array(
			'id' => '19',
			'parent_id' => '13',
			'name' => 'weight',
			'datatype' => 'int5',
			'listview' => true,
			'created' => null,
			'modified' => null
		),
		'children' => array()
	),
	'sku' => array(
		'Ptype' => array(
			'id' => '7',
			'parent_id' => '2',
			'name' => 'sku',
			'datatype' => 'varchar255',
			'listview' => false,
			'created' => null,
			'modified' => '2016-03-05 02:10:44',
			'prototype_name' => 'SKU',
			'prototype_type' => 'sku'
		),
		'children' => array()
	),
	'short_code' => array(
		'Ptype' => array(
			'id' => '8',
			'parent_id' => '2',
			'name' => 'short_code',
			'datatype' => 'varchar255',
			'listview' => true,
			'created' => null,
			'modified' => '2016-03-05 00:09:58',
			'prototype_name' => 'Short Code',
			'prototype_type' => 'short_code'
		),
		'children' => array()
	),
	'moq' => array(
		'Ptype' => array(
			'id' => '103',
			'parent_id' => '2',
			'name' => 'moq',
			'datatype' => 'int11',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-20 06:10:57',
			'prototype_name' => 'Minimum Order Quantity',
			'prototype_type' => 'short_number'
		),
		'children' => array()
	),
	'multiple' => array(
		'Ptype' => array(
			'id' => '104',
			'parent_id' => '2',
			'name' => 'multiple',
			'datatype' => 'int11',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-20 06:11:22',
			'prototype_name' => 'Pack Multiple',
			'prototype_type' => 'short_number'
		),
		'children' => array()
	),
	'pl_pid' => array(
		'Ptype' => array(
			'id' => '454',
			'parent_id' => '447',
			'name' => 'product_id',
			'datatype' => 'int11',
			'listview' => null,
			'created' => null,
			'modified' => null
		),
		'children' => array()
	),
	'pl_discount' => array(
		'Ptype' => array(
			'id' => '497',
			'parent_id' => '447',
			'name' => 'discount',
			'datatype' => 'float',
			'listview' => null,
			'created' => null,
			'modified' => '2015-05-21 21:09:48'
		),
		'children' => array()
	),
	'price_enable' => array(
		'Ptype' => array(
			'id' => '404',
			'parent_id' => '2',
			'name' => 'price_enable',
			'datatype' => 'tinyint1',
			'listview' => true,
			'created' => '2016-03-20 17:42:29',
			'modified' => '2016-03-20 17:42:29',
			'prototype_name' => 'Enable Price',
			'prototype_type' => 'YesOrNo'
		),
		'children' => array()
	),
	'id' => array(
		'category' => '1',
		'product' => '2',
		'category_url' => '77',
		'subcategories' => '85',
		'url' => '78',
		'product_option' => '23',
		'product_option_value' => '27',
		'product_link' => '443',
		'product_link_value' => '447',
		'associated_product' => '455',
		'price' => '20',
		'category_name' => '366',
		'product_name' => '370',
		'product_image' => '13',
		'sku' => '7',
		'barcode' => '461',
		'short_code' => '8',
		'moq' => '103',
		'multiple' => '104',
		'price_enable' => '404',
		'product_public' => '10',
		'category_weight' => '56',
		'product_weight' => '362',
		'product_category_id' => '4',
		'category_status' => '378',
		'product_status' => '9',
		'product_display' => '437'
	)
)
$ShopData = array(
	'prototype' => array(
		'prototypes' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		),
		'supplier' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'brand' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'producttab' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'errors' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'category' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'price' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product_image' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product_image_weight' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'sku' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'short_code' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'moq' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'multiple' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'pl_pid' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'pl_discount' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'price_enable' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'id' => array(
			'category' => '1',
			'product' => '2',
			'category_url' => '77',
			'subcategories' => '85',
			'url' => '78',
			'product_option' => '23',
			'product_option_value' => '27',
			'product_link' => '443',
			'product_link_value' => '447',
			'associated_product' => '455',
			'price' => '20',
			'category_name' => '366',
			'product_name' => '370',
			'product_image' => '13',
			'sku' => '7',
			'barcode' => '461',
			'short_code' => '8',
			'moq' => '103',
			'multiple' => '104',
			'price_enable' => '404',
			'product_public' => '10',
			'category_weight' => '56',
			'product_weight' => '362',
			'product_category_id' => '4',
			'category_status' => '378',
			'product_status' => '9',
			'product_display' => '437'
		)
	),
	'breadcrumbs' => array(
		(int) 0 => array(
			'name' => 'Catalogue',
			'url' => ''
		),
		(int) 1 => array(
			'name' => 'Colorama',
			'url' => 'colorama/'
		)
	),
	'parent_category' => array(
		'id' => '3942',
		'name' => 'Colorama',
		'status' => '20',
		'public' => (int) 1,
		'display' => '1',
		'description_short' => '<p>Colorama Photographic Backgrounds and Accessories</p>',
		'description_long' => '<p>Colorama Photographic Backgrounds and Accessories</p>',
		'category_image' => array(
			'description' => 'Colorama',
			'title' => 'Colorama',
			'thumbnail' => array(
				[maximum depth reached]
			),
			'tile' => array(
				[maximum depth reached]
			),
			'list' => array(
				[maximum depth reached]
			),
			'standard' => array(
				[maximum depth reached]
			),
			'zoom' => array(
				[maximum depth reached]
			),
			'original' => '//static.swpm.net/onlineshop/original/colorama_3942_vBOcIWFU.jpg'
		),
		'spec_id' => null,
		'url' => 'colorama',
		'subcategories' => '0',
		'weight' => '5'
	)
)
$customer_user = 'G2205161-Guest'
$list = true
$foundSKUSC = false
$structure_parent = array(
	'Catalogueitem' => array(
		'id' => '1011',
		'parent_id' => null,
		'prototype_id' => null,
		'value' => 'structure',
		'created' => null,
		'modified' => null
	)
)
$pub = array(
	'Catalogueitem' => array(
		'id' => '1013',
		'parent_id' => '1011',
		'prototype_id' => null,
		'value' => 'published',
		'created' => null,
		'modified' => '2020-08-21 08:13:29'
	)
)
$pub_root = array(
	'Catalogueitem' => array(
		'id' => '130246',
		'parent_id' => '1013',
		'prototype_id' => null,
		'value' => 'root',
		'created' => '2020-05-28 13:20:05',
		'modified' => '2020-05-28 13:20:05'
	)
)
$draft = array(
	'Catalogueitem' => array(
		'id' => '1014',
		'parent_id' => '1011',
		'prototype_id' => null,
		'value' => 'draft',
		'created' => null,
		'modified' => '2020-08-21 08:13:29'
	)
)
$draft_root = array(
	'Catalogueitem' => array(
		'id' => '133439',
		'parent_id' => '1014',
		'prototype_id' => null,
		'value' => 'root',
		'created' => '2020-11-17 09:48:35',
		'modified' => '2020-11-17 09:48:35'
	)
)
$root_id = '130246'
$bc_count = (int) 2
$breadcrumbs = array(
	(int) 0 => array(
		'name' => 'Catalogue',
		'url' => ''
	),
	(int) 1 => array(
		'name' => 'Colorama',
		'url' => 'colorama/'
	)
)
$version_type = (int) 1
$ret = array(
	'renderview' => 'brochure_category_list'
)
$prototype_id = '1'
$item_parent_id = '130277'
$product_id = null
$testforsku = (int) 1
$lookup = 'colorama'
$p = array(
	'Ptype' => array(
		'id' => '362',
		'parent_id' => '2',
		'name' => 'weight',
		'datatype' => 'int5',
		'listview' => true,
		'created' => '2014-10-25 11:07:49',
		'modified' => '2014-10-25 11:07:49',
		'prototype_name' => 'weight',
		'prototype_type' => 'short_number'
	),
	'children' => array()
)
$scp = array(
	'Ptype' => array(
		'id' => '8',
		'parent_id' => '2',
		'name' => 'short_code',
		'datatype' => 'varchar255',
		'listview' => true,
		'created' => null,
		'modified' => '2016-03-05 00:09:58',
		'prototype_name' => 'Short Code',
		'prototype_type' => 'short_code'
	),
	'children' => array()
)
$skup = array(
	'Ptype' => array(
		'id' => '7',
		'parent_id' => '2',
		'name' => 'sku',
		'datatype' => 'varchar255',
		'listview' => false,
		'created' => null,
		'modified' => '2016-03-05 02:10:44',
		'prototype_name' => 'SKU',
		'prototype_type' => 'sku'
	),
	'children' => array()
)
$find = array()
$item = array(
	'Catalogueitem' => array(
		'id' => '3942',
		'parent_id' => null,
		'prototype_id' => '1',
		'value' => 'Colorama',
		'created' => '2016-07-19 15:19:40',
		'modified' => '2022-06-21 17:03:03',
		'structure_id' => '130279',
		'structure_type' => 'categories'
	)
)
$parent_id = '130277'
$i = (int) 2
$catalogueversion_id = '1780'
$url = 'colorama'
$next_part = 'category'
$prototype_url_id = '77'
$part = 'colorama'
$items = array(
	(int) -1 => array(
		'Catalogueitem' => array(
			'id' => '4070',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Background Accessories',
			'created' => '2016-07-22 04:28:11',
			'modified' => '2016-08-01 15:05:59'
		)
	),
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '3192',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Colorama Backgrounds',
			'created' => '2016-07-04 23:25:19',
			'modified' => '2016-07-22 14:10:09'
		)
	),
	(int) 1 => array(
		'Catalogueitem' => array(
			'id' => '4795',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Product Photography',
			'created' => '2016-08-01 16:03:11',
			'modified' => '2016-08-01 16:07:17'
		)
	)
)
$itms = array(
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '3942',
			'parent_id' => null,
			'prototype_id' => '1',
			'value' => 'Colorama',
			'created' => '2016-07-19 15:19:40',
			'modified' => '2022-06-21 17:03:03',
			'structure_id' => '130279',
			'structure_type' => 'categories'
		)
	)
)
$children = array(
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '4070',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Background Accessories',
			'created' => '2016-07-22 04:28:11',
			'modified' => '2016-08-01 15:05:59'
		)
	),
	(int) 1 => array(
		'Catalogueitem' => array(
			'id' => '3192',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Colorama Backgrounds',
			'created' => '2016-07-04 23:25:19',
			'modified' => '2016-07-22 14:10:09'
		)
	),
	(int) 2 => array(
		'Catalogueitem' => array(
			'id' => '4795',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Product Photography',
			'created' => '2016-08-01 16:03:11',
			'modified' => '2016-08-01 16:07:17'
		)
	)
)
$child = array(
	'Catalogueitem' => array(
		'id' => '4795',
		'parent_id' => '3942',
		'prototype_id' => '1',
		'value' => 'Product Photography',
		'created' => '2016-08-01 16:03:11',
		'modified' => '2016-08-01 16:07:17'
	)
)
$id = '3942'
$weight = '2'
$match = true
$parent_item = array(
	'Catalogueitem' => array(
		'id' => '3942',
		'parent_id' => null,
		'prototype_id' => '1',
		'value' => 'Colorama',
		'created' => '2016-07-19 15:19:40',
		'modified' => '2022-06-21 17:03:03',
		'structure_id' => '130277',
		'structure_type' => 'category_cc'
	)
)
$item_parent = array(
	'Catalogueitem' => array(
		'id' => '130277',
		'parent_id' => '130246',
		'prototype_id' => null,
		'value' => 'category_cc',
		'created' => '2020-05-28 13:20:06',
		'modified' => '2020-05-28 13:20:06'
	)
)
$all_products = (int) 0

RetailCommonComponent::findProducts() - APP/Plugin/retail/Controller/Component/RetailCommonComponent.php, line 13981
ShopController::brochure() - APP/Plugin/retail/Controller/ShopController.php, line 2366
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/SWPM/web/swpm.net/public_html/index.php, line 182

Notice (8): Undefined offset: 2 [APP/Plugin/retail/Controller/Component/RetailCommonComponent.php, line 14028]

Code Context

                    
                    $p = array();
                    if($items[$i]['Catalogueitem']['prototype_id'] == $prototypes['id']['category'])

$pass = array(
	(int) 0 => 'colorama'
)
$type = 'brochure'
$chosen_options = array()
$categoryListAjax = (int) 0
$productListAjax = (int) 0
$st = (float) 1728400485.9772
$tax = array(
	'currency' => 'GBP',
	'currency_iso' => '826',
	'currency_name' => 'Pound Sterling',
	'currency_symbol' => '£',
	'currency_exponent' => '2',
	'tax_id' => '1',
	'tax_rate' => '20',
	'tax_name' => 'VAT',
	'tax_description' => 'Value Added Tax',
	'tax_list' => 'Standard',
	'tax_override' => false,
	'default_price_display' => 'inctax'
)
$tax_id = '1'
$tax_rate = '20'
$tax_name = 'VAT'
$currency_symbol = '£'
$currency_exponent = '2'
$default_price_display = 'inctax'
$page_stamp = '44_192_95_161_1728400485_978'
$prototypes = array(
	'prototypes' => array(
		(int) 0 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		)
	),
	'supplier' => array(
		'Ptype' => array(
			'id' => '354',
			'parent_id' => '498',
			'name' => 'supplier',
			'datatype' => null,
			'listview' => null,
			'created' => '2014-10-23 20:57:59',
			'modified' => '2014-10-23 20:57:59'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	'brand' => array(
		'Ptype' => array(
			'id' => '346',
			'parent_id' => '498',
			'name' => 'brand',
			'datatype' => null,
			'listview' => null,
			'created' => '2014-10-23 12:24:39',
			'modified' => '2014-10-23 12:24:39'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	'producttab' => array(
		'Ptype' => array(
			'id' => '408',
			'parent_id' => '498',
			'name' => 'producttab',
			'datatype' => null,
			'listview' => null,
			'created' => '2016-03-24 06:56:42',
			'modified' => '2016-03-24 06:57:13'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		)
	),
	'errors' => array(
		'Ptype' => array(
			'id' => '468',
			'parent_id' => '498',
			'name' => 'errors',
			'datatype' => null,
			'listview' => null,
			'created' => '2016-07-22 20:55:29',
			'modified' => '2016-07-22 20:55:29'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		)
	),
	'category' => array(
		'Ptype' => array(
			'id' => '1',
			'parent_id' => '498',
			'name' => 'category',
			'datatype' => null,
			'listview' => true,
			'created' => null,
			'modified' => null
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			)
		)
	),
	'product' => array(
		'Ptype' => array(
			'id' => '2',
			'parent_id' => '498',
			'name' => 'product',
			'datatype' => null,
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-23 12:07:52'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			),
			(int) 23 => array(
				[maximum depth reached]
			),
			(int) 24 => array(
				[maximum depth reached]
			),
			(int) 25 => array(
				[maximum depth reached]
			),
			(int) 26 => array(
				[maximum depth reached]
			),
			(int) 27 => array(
				[maximum depth reached]
			)
		)
	),
	'price' => array(
		'Ptype' => array(
			'id' => '20',
			'parent_id' => '2',
			'name' => 'price',
			'datatype' => 'find_current',
			'listview' => false,
			'created' => null,
			'modified' => '2014-10-20 04:06:21',
			'prototype_name' => 'Price',
			'prototype_type' => 'price'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			)
		)
	),
	'product_image' => array(
		'Ptype' => array(
			'id' => '13',
			'parent_id' => '2',
			'name' => 'product_image',
			'datatype' => 'allow_multiple',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-22 04:36:57',
			'prototype_name' => 'Product Images',
			'prototype_type' => 'product_image'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			)
		)
	),
	'product_image_weight' => array(
		'Ptype' => array(
			'id' => '19',
			'parent_id' => '13',
			'name' => 'weight',
			'datatype' => 'int5',
			'listview' => true,
			'created' => null,
			'modified' => null
		),
		'children' => array()
	),
	'sku' => array(
		'Ptype' => array(
			'id' => '7',
			'parent_id' => '2',
			'name' => 'sku',
			'datatype' => 'varchar255',
			'listview' => false,
			'created' => null,
			'modified' => '2016-03-05 02:10:44',
			'prototype_name' => 'SKU',
			'prototype_type' => 'sku'
		),
		'children' => array()
	),
	'short_code' => array(
		'Ptype' => array(
			'id' => '8',
			'parent_id' => '2',
			'name' => 'short_code',
			'datatype' => 'varchar255',
			'listview' => true,
			'created' => null,
			'modified' => '2016-03-05 00:09:58',
			'prototype_name' => 'Short Code',
			'prototype_type' => 'short_code'
		),
		'children' => array()
	),
	'moq' => array(
		'Ptype' => array(
			'id' => '103',
			'parent_id' => '2',
			'name' => 'moq',
			'datatype' => 'int11',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-20 06:10:57',
			'prototype_name' => 'Minimum Order Quantity',
			'prototype_type' => 'short_number'
		),
		'children' => array()
	),
	'multiple' => array(
		'Ptype' => array(
			'id' => '104',
			'parent_id' => '2',
			'name' => 'multiple',
			'datatype' => 'int11',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-20 06:11:22',
			'prototype_name' => 'Pack Multiple',
			'prototype_type' => 'short_number'
		),
		'children' => array()
	),
	'pl_pid' => array(
		'Ptype' => array(
			'id' => '454',
			'parent_id' => '447',
			'name' => 'product_id',
			'datatype' => 'int11',
			'listview' => null,
			'created' => null,
			'modified' => null
		),
		'children' => array()
	),
	'pl_discount' => array(
		'Ptype' => array(
			'id' => '497',
			'parent_id' => '447',
			'name' => 'discount',
			'datatype' => 'float',
			'listview' => null,
			'created' => null,
			'modified' => '2015-05-21 21:09:48'
		),
		'children' => array()
	),
	'price_enable' => array(
		'Ptype' => array(
			'id' => '404',
			'parent_id' => '2',
			'name' => 'price_enable',
			'datatype' => 'tinyint1',
			'listview' => true,
			'created' => '2016-03-20 17:42:29',
			'modified' => '2016-03-20 17:42:29',
			'prototype_name' => 'Enable Price',
			'prototype_type' => 'YesOrNo'
		),
		'children' => array()
	),
	'id' => array(
		'category' => '1',
		'product' => '2',
		'category_url' => '77',
		'subcategories' => '85',
		'url' => '78',
		'product_option' => '23',
		'product_option_value' => '27',
		'product_link' => '443',
		'product_link_value' => '447',
		'associated_product' => '455',
		'price' => '20',
		'category_name' => '366',
		'product_name' => '370',
		'product_image' => '13',
		'sku' => '7',
		'barcode' => '461',
		'short_code' => '8',
		'moq' => '103',
		'multiple' => '104',
		'price_enable' => '404',
		'product_public' => '10',
		'category_weight' => '56',
		'product_weight' => '362',
		'product_category_id' => '4',
		'category_status' => '378',
		'product_status' => '9',
		'product_display' => '437'
	)
)
$ShopData = array(
	'prototype' => array(
		'prototypes' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		),
		'supplier' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'brand' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'producttab' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'errors' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'category' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'price' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product_image' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product_image_weight' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'sku' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'short_code' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'moq' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'multiple' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'pl_pid' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'pl_discount' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'price_enable' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'id' => array(
			'category' => '1',
			'product' => '2',
			'category_url' => '77',
			'subcategories' => '85',
			'url' => '78',
			'product_option' => '23',
			'product_option_value' => '27',
			'product_link' => '443',
			'product_link_value' => '447',
			'associated_product' => '455',
			'price' => '20',
			'category_name' => '366',
			'product_name' => '370',
			'product_image' => '13',
			'sku' => '7',
			'barcode' => '461',
			'short_code' => '8',
			'moq' => '103',
			'multiple' => '104',
			'price_enable' => '404',
			'product_public' => '10',
			'category_weight' => '56',
			'product_weight' => '362',
			'product_category_id' => '4',
			'category_status' => '378',
			'product_status' => '9',
			'product_display' => '437'
		)
	),
	'breadcrumbs' => array(
		(int) 0 => array(
			'name' => 'Catalogue',
			'url' => ''
		),
		(int) 1 => array(
			'name' => 'Colorama',
			'url' => 'colorama/'
		)
	),
	'parent_category' => array(
		'id' => '3942',
		'name' => 'Colorama',
		'status' => '20',
		'public' => (int) 1,
		'display' => '1',
		'description_short' => '<p>Colorama Photographic Backgrounds and Accessories</p>',
		'description_long' => '<p>Colorama Photographic Backgrounds and Accessories</p>',
		'category_image' => array(
			'description' => 'Colorama',
			'title' => 'Colorama',
			'thumbnail' => array(
				[maximum depth reached]
			),
			'tile' => array(
				[maximum depth reached]
			),
			'list' => array(
				[maximum depth reached]
			),
			'standard' => array(
				[maximum depth reached]
			),
			'zoom' => array(
				[maximum depth reached]
			),
			'original' => '//static.swpm.net/onlineshop/original/colorama_3942_vBOcIWFU.jpg'
		),
		'spec_id' => null,
		'url' => 'colorama',
		'subcategories' => '0',
		'weight' => '5'
	),
	'category' => array(
		(int) 0 => array(
			'id' => '3192',
			'name' => 'Colorama Backgrounds',
			'status' => '20',
			'public' => (int) 1,
			'display' => '1',
			'description_short' => '<p>Colorado Backgrounds</p>',
			'category_image' => array(
				[maximum depth reached]
			),
			'spec_id' => null,
			'url' => 'colorama_backgrounds',
			'subcategories' => '0',
			'weight' => '1'
		)
	)
)
$customer_user = 'G2205161-Guest'
$list = true
$foundSKUSC = false
$structure_parent = array(
	'Catalogueitem' => array(
		'id' => '1011',
		'parent_id' => null,
		'prototype_id' => null,
		'value' => 'structure',
		'created' => null,
		'modified' => null
	)
)
$pub = array(
	'Catalogueitem' => array(
		'id' => '1013',
		'parent_id' => '1011',
		'prototype_id' => null,
		'value' => 'published',
		'created' => null,
		'modified' => '2020-08-21 08:13:29'
	)
)
$pub_root = array(
	'Catalogueitem' => array(
		'id' => '130246',
		'parent_id' => '1013',
		'prototype_id' => null,
		'value' => 'root',
		'created' => '2020-05-28 13:20:05',
		'modified' => '2020-05-28 13:20:05'
	)
)
$draft = array(
	'Catalogueitem' => array(
		'id' => '1014',
		'parent_id' => '1011',
		'prototype_id' => null,
		'value' => 'draft',
		'created' => null,
		'modified' => '2020-08-21 08:13:29'
	)
)
$draft_root = array(
	'Catalogueitem' => array(
		'id' => '133439',
		'parent_id' => '1014',
		'prototype_id' => null,
		'value' => 'root',
		'created' => '2020-11-17 09:48:35',
		'modified' => '2020-11-17 09:48:35'
	)
)
$root_id = '130246'
$bc_count = (int) 2
$breadcrumbs = array(
	(int) 0 => array(
		'name' => 'Catalogue',
		'url' => ''
	),
	(int) 1 => array(
		'name' => 'Colorama',
		'url' => 'colorama/'
	)
)
$version_type = (int) 1
$ret = array(
	'renderview' => 'brochure_category_list'
)
$prototype_id = '1'
$item_parent_id = '130277'
$product_id = null
$testforsku = (int) 1
$lookup = 'colorama'
$p = array()
$scp = array(
	'Ptype' => array(
		'id' => '8',
		'parent_id' => '2',
		'name' => 'short_code',
		'datatype' => 'varchar255',
		'listview' => true,
		'created' => null,
		'modified' => '2016-03-05 00:09:58',
		'prototype_name' => 'Short Code',
		'prototype_type' => 'short_code'
	),
	'children' => array()
)
$skup = array(
	'Ptype' => array(
		'id' => '7',
		'parent_id' => '2',
		'name' => 'sku',
		'datatype' => 'varchar255',
		'listview' => false,
		'created' => null,
		'modified' => '2016-03-05 02:10:44',
		'prototype_name' => 'SKU',
		'prototype_type' => 'sku'
	),
	'children' => array()
)
$find = array()
$item = array(
	'Catalogueitem' => array(
		'id' => '3942',
		'parent_id' => null,
		'prototype_id' => '1',
		'value' => 'Colorama',
		'created' => '2016-07-19 15:19:40',
		'modified' => '2022-06-21 17:03:03',
		'structure_id' => '130279',
		'structure_type' => 'categories'
	)
)
$parent_id = '130277'
$i = (int) 2
$catalogueversion_id = '1780'
$url = 'colorama'
$next_part = 'category'
$prototype_url_id = '77'
$part = 'colorama'
$items = array(
	(int) -1 => array(
		'Catalogueitem' => array(
			'id' => '4070',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Background Accessories',
			'created' => '2016-07-22 04:28:11',
			'modified' => '2016-08-01 15:05:59'
		)
	),
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '3192',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Colorama Backgrounds',
			'created' => '2016-07-04 23:25:19',
			'modified' => '2016-07-22 14:10:09'
		)
	),
	(int) 1 => array(
		'Catalogueitem' => array(
			'id' => '4795',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Product Photography',
			'created' => '2016-08-01 16:03:11',
			'modified' => '2016-08-01 16:07:17'
		)
	)
)
$itms = array(
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '3942',
			'parent_id' => null,
			'prototype_id' => '1',
			'value' => 'Colorama',
			'created' => '2016-07-19 15:19:40',
			'modified' => '2022-06-21 17:03:03',
			'structure_id' => '130279',
			'structure_type' => 'categories'
		)
	)
)
$children = array(
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '4070',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Background Accessories',
			'created' => '2016-07-22 04:28:11',
			'modified' => '2016-08-01 15:05:59'
		)
	),
	(int) 1 => array(
		'Catalogueitem' => array(
			'id' => '3192',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Colorama Backgrounds',
			'created' => '2016-07-04 23:25:19',
			'modified' => '2016-07-22 14:10:09'
		)
	),
	(int) 2 => array(
		'Catalogueitem' => array(
			'id' => '4795',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Product Photography',
			'created' => '2016-08-01 16:03:11',
			'modified' => '2016-08-01 16:07:17'
		)
	)
)
$child = array(
	'Catalogueitem' => array(
		'id' => '4795',
		'parent_id' => '3942',
		'prototype_id' => '1',
		'value' => 'Product Photography',
		'created' => '2016-08-01 16:03:11',
		'modified' => '2016-08-01 16:07:17'
	)
)
$id = '3942'
$weight = '2'
$match = true
$parent_item = array(
	'Catalogueitem' => array(
		'id' => '3942',
		'parent_id' => null,
		'prototype_id' => '1',
		'value' => 'Colorama',
		'created' => '2016-07-19 15:19:40',
		'modified' => '2022-06-21 17:03:03',
		'structure_id' => '130277',
		'structure_type' => 'category_cc'
	)
)
$item_parent = array(
	'Catalogueitem' => array(
		'id' => '130277',
		'parent_id' => '130246',
		'prototype_id' => null,
		'value' => 'category_cc',
		'created' => '2020-05-28 13:20:06',
		'modified' => '2020-05-28 13:20:06'
	)
)
$all_products = (int) 0
$process_list = (int) 1

RetailCommonComponent::findProducts() - APP/Plugin/retail/Controller/Component/RetailCommonComponent.php, line 14028
ShopController::brochure() - APP/Plugin/retail/Controller/ShopController.php, line 2366
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/SWPM/web/swpm.net/public_html/index.php, line 182

Notice (8): Undefined offset: 2 [APP/Plugin/retail/Controller/Component/RetailCommonComponent.php, line 14062]

Code Context

                        $dt.= ' list3.3:' . (microtime(true) - $st);
                    }
                    else if($items[$i]['Catalogueitem']['prototype_id'] == $prototypes['id']['product'])

$pass = array(
	(int) 0 => 'colorama'
)
$type = 'brochure'
$chosen_options = array()
$categoryListAjax = (int) 0
$productListAjax = (int) 0
$st = (float) 1728400485.9772
$tax = array(
	'currency' => 'GBP',
	'currency_iso' => '826',
	'currency_name' => 'Pound Sterling',
	'currency_symbol' => '£',
	'currency_exponent' => '2',
	'tax_id' => '1',
	'tax_rate' => '20',
	'tax_name' => 'VAT',
	'tax_description' => 'Value Added Tax',
	'tax_list' => 'Standard',
	'tax_override' => false,
	'default_price_display' => 'inctax'
)
$tax_id = '1'
$tax_rate = '20'
$tax_name = 'VAT'
$currency_symbol = '£'
$currency_exponent = '2'
$default_price_display = 'inctax'
$page_stamp = '44_192_95_161_1728400485_978'
$prototypes = array(
	'prototypes' => array(
		(int) 0 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 4 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		(int) 5 => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		)
	),
	'supplier' => array(
		'Ptype' => array(
			'id' => '354',
			'parent_id' => '498',
			'name' => 'supplier',
			'datatype' => null,
			'listview' => null,
			'created' => '2014-10-23 20:57:59',
			'modified' => '2014-10-23 20:57:59'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	'brand' => array(
		'Ptype' => array(
			'id' => '346',
			'parent_id' => '498',
			'name' => 'brand',
			'datatype' => null,
			'listview' => null,
			'created' => '2014-10-23 12:24:39',
			'modified' => '2014-10-23 12:24:39'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	),
	'producttab' => array(
		'Ptype' => array(
			'id' => '408',
			'parent_id' => '498',
			'name' => 'producttab',
			'datatype' => null,
			'listview' => null,
			'created' => '2016-03-24 06:56:42',
			'modified' => '2016-03-24 06:57:13'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		)
	),
	'errors' => array(
		'Ptype' => array(
			'id' => '468',
			'parent_id' => '498',
			'name' => 'errors',
			'datatype' => null,
			'listview' => null,
			'created' => '2016-07-22 20:55:29',
			'modified' => '2016-07-22 20:55:29'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		)
	),
	'category' => array(
		'Ptype' => array(
			'id' => '1',
			'parent_id' => '498',
			'name' => 'category',
			'datatype' => null,
			'listview' => true,
			'created' => null,
			'modified' => null
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			)
		)
	),
	'product' => array(
		'Ptype' => array(
			'id' => '2',
			'parent_id' => '498',
			'name' => 'product',
			'datatype' => null,
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-23 12:07:52'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			),
			(int) 9 => array(
				[maximum depth reached]
			),
			(int) 10 => array(
				[maximum depth reached]
			),
			(int) 11 => array(
				[maximum depth reached]
			),
			(int) 12 => array(
				[maximum depth reached]
			),
			(int) 13 => array(
				[maximum depth reached]
			),
			(int) 14 => array(
				[maximum depth reached]
			),
			(int) 15 => array(
				[maximum depth reached]
			),
			(int) 16 => array(
				[maximum depth reached]
			),
			(int) 17 => array(
				[maximum depth reached]
			),
			(int) 18 => array(
				[maximum depth reached]
			),
			(int) 19 => array(
				[maximum depth reached]
			),
			(int) 20 => array(
				[maximum depth reached]
			),
			(int) 21 => array(
				[maximum depth reached]
			),
			(int) 22 => array(
				[maximum depth reached]
			),
			(int) 23 => array(
				[maximum depth reached]
			),
			(int) 24 => array(
				[maximum depth reached]
			),
			(int) 25 => array(
				[maximum depth reached]
			),
			(int) 26 => array(
				[maximum depth reached]
			),
			(int) 27 => array(
				[maximum depth reached]
			)
		)
	),
	'price' => array(
		'Ptype' => array(
			'id' => '20',
			'parent_id' => '2',
			'name' => 'price',
			'datatype' => 'find_current',
			'listview' => false,
			'created' => null,
			'modified' => '2014-10-20 04:06:21',
			'prototype_name' => 'Price',
			'prototype_type' => 'price'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			)
		)
	),
	'product_image' => array(
		'Ptype' => array(
			'id' => '13',
			'parent_id' => '2',
			'name' => 'product_image',
			'datatype' => 'allow_multiple',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-22 04:36:57',
			'prototype_name' => 'Product Images',
			'prototype_type' => 'product_image'
		),
		'children' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			),
			(int) 8 => array(
				[maximum depth reached]
			)
		)
	),
	'product_image_weight' => array(
		'Ptype' => array(
			'id' => '19',
			'parent_id' => '13',
			'name' => 'weight',
			'datatype' => 'int5',
			'listview' => true,
			'created' => null,
			'modified' => null
		),
		'children' => array()
	),
	'sku' => array(
		'Ptype' => array(
			'id' => '7',
			'parent_id' => '2',
			'name' => 'sku',
			'datatype' => 'varchar255',
			'listview' => false,
			'created' => null,
			'modified' => '2016-03-05 02:10:44',
			'prototype_name' => 'SKU',
			'prototype_type' => 'sku'
		),
		'children' => array()
	),
	'short_code' => array(
		'Ptype' => array(
			'id' => '8',
			'parent_id' => '2',
			'name' => 'short_code',
			'datatype' => 'varchar255',
			'listview' => true,
			'created' => null,
			'modified' => '2016-03-05 00:09:58',
			'prototype_name' => 'Short Code',
			'prototype_type' => 'short_code'
		),
		'children' => array()
	),
	'moq' => array(
		'Ptype' => array(
			'id' => '103',
			'parent_id' => '2',
			'name' => 'moq',
			'datatype' => 'int11',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-20 06:10:57',
			'prototype_name' => 'Minimum Order Quantity',
			'prototype_type' => 'short_number'
		),
		'children' => array()
	),
	'multiple' => array(
		'Ptype' => array(
			'id' => '104',
			'parent_id' => '2',
			'name' => 'multiple',
			'datatype' => 'int11',
			'listview' => true,
			'created' => null,
			'modified' => '2014-10-20 06:11:22',
			'prototype_name' => 'Pack Multiple',
			'prototype_type' => 'short_number'
		),
		'children' => array()
	),
	'pl_pid' => array(
		'Ptype' => array(
			'id' => '454',
			'parent_id' => '447',
			'name' => 'product_id',
			'datatype' => 'int11',
			'listview' => null,
			'created' => null,
			'modified' => null
		),
		'children' => array()
	),
	'pl_discount' => array(
		'Ptype' => array(
			'id' => '497',
			'parent_id' => '447',
			'name' => 'discount',
			'datatype' => 'float',
			'listview' => null,
			'created' => null,
			'modified' => '2015-05-21 21:09:48'
		),
		'children' => array()
	),
	'price_enable' => array(
		'Ptype' => array(
			'id' => '404',
			'parent_id' => '2',
			'name' => 'price_enable',
			'datatype' => 'tinyint1',
			'listview' => true,
			'created' => '2016-03-20 17:42:29',
			'modified' => '2016-03-20 17:42:29',
			'prototype_name' => 'Enable Price',
			'prototype_type' => 'YesOrNo'
		),
		'children' => array()
	),
	'id' => array(
		'category' => '1',
		'product' => '2',
		'category_url' => '77',
		'subcategories' => '85',
		'url' => '78',
		'product_option' => '23',
		'product_option_value' => '27',
		'product_link' => '443',
		'product_link_value' => '447',
		'associated_product' => '455',
		'price' => '20',
		'category_name' => '366',
		'product_name' => '370',
		'product_image' => '13',
		'sku' => '7',
		'barcode' => '461',
		'short_code' => '8',
		'moq' => '103',
		'multiple' => '104',
		'price_enable' => '404',
		'product_public' => '10',
		'category_weight' => '56',
		'product_weight' => '362',
		'product_category_id' => '4',
		'category_status' => '378',
		'product_status' => '9',
		'product_display' => '437'
	)
)
$ShopData = array(
	'prototype' => array(
		'prototypes' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			)
		),
		'supplier' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'brand' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'producttab' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'errors' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'category' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'price' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product_image' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array(
				[maximum depth reached]
			)
		),
		'product_image_weight' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'sku' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'short_code' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'moq' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'multiple' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'pl_pid' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'pl_discount' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'price_enable' => array(
			'Ptype' => array(
				[maximum depth reached]
			),
			'children' => array([maximum depth reached])
		),
		'id' => array(
			'category' => '1',
			'product' => '2',
			'category_url' => '77',
			'subcategories' => '85',
			'url' => '78',
			'product_option' => '23',
			'product_option_value' => '27',
			'product_link' => '443',
			'product_link_value' => '447',
			'associated_product' => '455',
			'price' => '20',
			'category_name' => '366',
			'product_name' => '370',
			'product_image' => '13',
			'sku' => '7',
			'barcode' => '461',
			'short_code' => '8',
			'moq' => '103',
			'multiple' => '104',
			'price_enable' => '404',
			'product_public' => '10',
			'category_weight' => '56',
			'product_weight' => '362',
			'product_category_id' => '4',
			'category_status' => '378',
			'product_status' => '9',
			'product_display' => '437'
		)
	),
	'breadcrumbs' => array(
		(int) 0 => array(
			'name' => 'Catalogue',
			'url' => ''
		),
		(int) 1 => array(
			'name' => 'Colorama',
			'url' => 'colorama/'
		)
	),
	'parent_category' => array(
		'id' => '3942',
		'name' => 'Colorama',
		'status' => '20',
		'public' => (int) 1,
		'display' => '1',
		'description_short' => '<p>Colorama Photographic Backgrounds and Accessories</p>',
		'description_long' => '<p>Colorama Photographic Backgrounds and Accessories</p>',
		'category_image' => array(
			'description' => 'Colorama',
			'title' => 'Colorama',
			'thumbnail' => array(
				[maximum depth reached]
			),
			'tile' => array(
				[maximum depth reached]
			),
			'list' => array(
				[maximum depth reached]
			),
			'standard' => array(
				[maximum depth reached]
			),
			'zoom' => array(
				[maximum depth reached]
			),
			'original' => '//static.swpm.net/onlineshop/original/colorama_3942_vBOcIWFU.jpg'
		),
		'spec_id' => null,
		'url' => 'colorama',
		'subcategories' => '0',
		'weight' => '5'
	),
	'category' => array(
		(int) 0 => array(
			'id' => '3192',
			'name' => 'Colorama Backgrounds',
			'status' => '20',
			'public' => (int) 1,
			'display' => '1',
			'description_short' => '<p>Colorado Backgrounds</p>',
			'category_image' => array(
				[maximum depth reached]
			),
			'spec_id' => null,
			'url' => 'colorama_backgrounds',
			'subcategories' => '0',
			'weight' => '1'
		)
	)
)
$customer_user = 'G2205161-Guest'
$list = true
$foundSKUSC = false
$structure_parent = array(
	'Catalogueitem' => array(
		'id' => '1011',
		'parent_id' => null,
		'prototype_id' => null,
		'value' => 'structure',
		'created' => null,
		'modified' => null
	)
)
$pub = array(
	'Catalogueitem' => array(
		'id' => '1013',
		'parent_id' => '1011',
		'prototype_id' => null,
		'value' => 'published',
		'created' => null,
		'modified' => '2020-08-21 08:13:29'
	)
)
$pub_root = array(
	'Catalogueitem' => array(
		'id' => '130246',
		'parent_id' => '1013',
		'prototype_id' => null,
		'value' => 'root',
		'created' => '2020-05-28 13:20:05',
		'modified' => '2020-05-28 13:20:05'
	)
)
$draft = array(
	'Catalogueitem' => array(
		'id' => '1014',
		'parent_id' => '1011',
		'prototype_id' => null,
		'value' => 'draft',
		'created' => null,
		'modified' => '2020-08-21 08:13:29'
	)
)
$draft_root = array(
	'Catalogueitem' => array(
		'id' => '133439',
		'parent_id' => '1014',
		'prototype_id' => null,
		'value' => 'root',
		'created' => '2020-11-17 09:48:35',
		'modified' => '2020-11-17 09:48:35'
	)
)
$root_id = '130246'
$bc_count = (int) 2
$breadcrumbs = array(
	(int) 0 => array(
		'name' => 'Catalogue',
		'url' => ''
	),
	(int) 1 => array(
		'name' => 'Colorama',
		'url' => 'colorama/'
	)
)
$version_type = (int) 1
$ret = array(
	'renderview' => 'brochure_category_list'
)
$prototype_id = '1'
$item_parent_id = '130277'
$product_id = null
$testforsku = (int) 1
$lookup = 'colorama'
$p = array()
$scp = array(
	'Ptype' => array(
		'id' => '8',
		'parent_id' => '2',
		'name' => 'short_code',
		'datatype' => 'varchar255',
		'listview' => true,
		'created' => null,
		'modified' => '2016-03-05 00:09:58',
		'prototype_name' => 'Short Code',
		'prototype_type' => 'short_code'
	),
	'children' => array()
)
$skup = array(
	'Ptype' => array(
		'id' => '7',
		'parent_id' => '2',
		'name' => 'sku',
		'datatype' => 'varchar255',
		'listview' => false,
		'created' => null,
		'modified' => '2016-03-05 02:10:44',
		'prototype_name' => 'SKU',
		'prototype_type' => 'sku'
	),
	'children' => array()
)
$find = array()
$item = array(
	'Catalogueitem' => array(
		'id' => '3942',
		'parent_id' => null,
		'prototype_id' => '1',
		'value' => 'Colorama',
		'created' => '2016-07-19 15:19:40',
		'modified' => '2022-06-21 17:03:03',
		'structure_id' => '130279',
		'structure_type' => 'categories'
	)
)
$parent_id = '130277'
$i = (int) 2
$catalogueversion_id = '1780'
$url = 'colorama'
$next_part = 'category'
$prototype_url_id = '77'
$part = 'colorama'
$items = array(
	(int) -1 => array(
		'Catalogueitem' => array(
			'id' => '4070',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Background Accessories',
			'created' => '2016-07-22 04:28:11',
			'modified' => '2016-08-01 15:05:59'
		)
	),
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '3192',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Colorama Backgrounds',
			'created' => '2016-07-04 23:25:19',
			'modified' => '2016-07-22 14:10:09'
		)
	),
	(int) 1 => array(
		'Catalogueitem' => array(
			'id' => '4795',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Product Photography',
			'created' => '2016-08-01 16:03:11',
			'modified' => '2016-08-01 16:07:17'
		)
	)
)
$itms = array(
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '3942',
			'parent_id' => null,
			'prototype_id' => '1',
			'value' => 'Colorama',
			'created' => '2016-07-19 15:19:40',
			'modified' => '2022-06-21 17:03:03',
			'structure_id' => '130279',
			'structure_type' => 'categories'
		)
	)
)
$children = array(
	(int) 0 => array(
		'Catalogueitem' => array(
			'id' => '4070',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Background Accessories',
			'created' => '2016-07-22 04:28:11',
			'modified' => '2016-08-01 15:05:59'
		)
	),
	(int) 1 => array(
		'Catalogueitem' => array(
			'id' => '3192',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Colorama Backgrounds',
			'created' => '2016-07-04 23:25:19',
			'modified' => '2016-07-22 14:10:09'
		)
	),
	(int) 2 => array(
		'Catalogueitem' => array(
			'id' => '4795',
			'parent_id' => '3942',
			'prototype_id' => '1',
			'value' => 'Product Photography',
			'created' => '2016-08-01 16:03:11',
			'modified' => '2016-08-01 16:07:17'
		)
	)
)
$child = array(
	'Catalogueitem' => array(
		'id' => '4795',
		'parent_id' => '3942',
		'prototype_id' => '1',
		'value' => 'Product Photography',
		'created' => '2016-08-01 16:03:11',
		'modified' => '2016-08-01 16:07:17'
	)
)
$id = '3942'
$weight = '2'
$match = true
$parent_item = array(
	'Catalogueitem' => array(
		'id' => '3942',
		'parent_id' => null,
		'prototype_id' => '1',
		'value' => 'Colorama',
		'created' => '2016-07-19 15:19:40',
		'modified' => '2022-06-21 17:03:03',
		'structure_id' => '130277',
		'structure_type' => 'category_cc'
	)
)
$item_parent = array(
	'Catalogueitem' => array(
		'id' => '130277',
		'parent_id' => '130246',
		'prototype_id' => null,
		'value' => 'category_cc',
		'created' => '2020-05-28 13:20:06',
		'modified' => '2020-05-28 13:20:06'
	)
)
$all_products = (int) 0
$process_list = (int) 1

RetailCommonComponent::findProducts() - APP/Plugin/retail/Controller/Component/RetailCommonComponent.php, line 14062
ShopController::brochure() - APP/Plugin/retail/Controller/ShopController.php, line 2366
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/SWPM/web/swpm.net/public_html/index.php, line 182

Missing View

Error: The view for ShopController::brochure() was not found.

Error: Confirm you have created the file: Shop/brochure_category_list.ctp

Stack Trace

CORE/Cake/View/View.php line 470 → View->_getViewFileName(string)

            return null;
        }

        if ($view !== false && $viewFileName = $this->_getViewFileName($view)) {
            $this->_currentType = static::TYPE_VIEW;

'Shop/brochure_category_list'

CORE/Cake/Controller/Controller.php line 968 → View->render(string, null)

        }

        $this->autoRender = false;
        $this->response->body($this->View->render($view, $layout));
        return $this->response;

'brochure_category_list'
null

APP/Plugin/retail/Controller/ShopController.php line 2378 → Controller->render(string)

        
        //print_r($return);
        
        $this->render($return['renderview']);
    }

'brochure_category_list'

[internal function] → ShopController->brochure(string)
```
'colorama'
```

CORE/Cake/Controller/Controller.php line 499 → ReflectionMethod->invokeArgs(ShopController, array)

                    'action' => $request->params['action']
                ));
            }
            return $method->invokeArgs($this, $request->params['pass']);

object(ShopController) {
	name => 'Shop'
	uses => array(
		(int) 0 => 'User',
		(int) 1 => 'Userdetail',
		(int) 2 => 'Messagelist',
		(int) 3 => 'Swpmcm.Client',
		(int) 4 => 'Retail.Float_retail_attribute',
		(int) 5 => 'Retail.Tinyint1_retail_attribute',
		(int) 6 => 'Retail.Int5_retail_attribute',
		(int) 7 => 'Retail.Int11_retail_attribute',
		(int) 8 => 'Retail.Int20_retail_attribute',
		(int) 9 => 'Retail.Varchar255_retail_attribute',
		(int) 10 => 'Retail.Varchar500_retail_attribute',
		(int) 11 => 'Retail.Text_retail_attribute',
		(int) 12 => 'Retail.Datetime_retail_attribute',
		(int) 13 => 'Retail.Catalogueitem',
		(int) 14 => 'Retail.Ptype',
		(int) 15 => 'Retail.Cataloguetoversion',
		(int) 16 => 'Retail.Order',
		(int) 17 => 'Retail.Payment',
		(int) 18 => 'Retail.Banktransaction',
		(int) 19 => 'Retail.Cardtransaction',
		(int) 20 => 'Retail.Paymenttransaction',
		(int) 21 => 'Retail.Invoice',
		(int) 22 => 'Retail.Pickingnote',
		(int) 23 => 'Retail.Country',
		(int) 24 => 'Branch',
		(int) 25 => 'Variable',
		(int) 26 => 'Module'
	)
	components => array(
		'Acl' => null,
		'Session' => null,
		'RequestHandler' => null,
		'BranchesCommon' => null,
		'Flash' => null,
		'Retail.RetailCommon' => null,
		'Paginator' => null,
		'Retail.AddressBook' => null,
		'Retail.PaymentProcessor' => null
	)
	helpers => array()
	request => object(CakeRequest) {
		params => array(
			[maximum depth reached]
		)
		data => array([maximum depth reached])
		query => array([maximum depth reached])
		url => 'albums/catalogue/colorama/'
		base => ''
		webroot => '/'
		here => '/albums/catalogue/colorama/'
		[protected] _detectors => array(
			[maximum depth reached]
		)
		[protected] _input => ''
	}
	response => object(CakeResponse) {
		[protected] _statusCodes => array(
			[maximum depth reached]
		)
		[protected] _mimeTypes => array(
			[maximum depth reached]
		)
		[protected] _protocol => 'HTTP/1.1'
		[protected] _status => (int) 200
		[protected] _contentType => 'text/html'
		[protected] _headers => array([maximum depth reached])
		[protected] _body => null
		[protected] _file => null
		[protected] _fileRange => null
		[protected] _charset => 'UTF-8'
		[protected] _cacheDirectives => array([maximum depth reached])
		[protected] _cookies => array(
			[maximum depth reached]
		)
	}
	viewPath => 'Shop'
	layoutPath => null
	viewVars => array(
		'ShopData' => array(
			'prototype' => array(
				[maximum depth reached]
			),
			'breadcrumbs' => array(
				[maximum depth reached]
			),
			'parent_category' => array(
				[maximum depth reached]
			),
			'category' => array(
				[maximum depth reached]
			),
			'PageStamp' => '44_192_95_161_1728400485_978'
		),
		'user' => array(
			'type' => 'Guest',
			'group_id' => 'Guest',
			'id' => 'G2205161',
			'raw_id' => '2205161'
		),
		'froala_key' => 'AsvrnC5kcs==',
		'website_author' => 'Custom Creative Solutions Limited 2010',
		'website_www' => 'www.swpm.net',
		'copyright_startdate' => '2011',
		'copyright_footer' => 'South West Photo Mounts. All Rights Reserved.',
		'website_keywords' => 'South West Photo Mounts, swpm.net, Mifsud, Mifsuds, Jorgensen, Art, Studio, Pro Bound, Styla, Bespoke, JAD, Jorgensen Album Designer, Pro: dashboard, Professional, Photographer, UK, Ireland, Wedding Photography, Wedding Album, Portrait Photographer, Commercial Photographer, Album Assembly, Custom Mats',
		'website_description' => 'South West Photo Mounts. With over 25 years of experience supplying professional photographers, SWPM has a comprehensive range of products to suite all needs from CD folios, folders, through to beautiful bespoke albums.',
		'website_coding' => 'Custom Creative Solutions Limited 2010',
		'website_design' => 'Custom Creative Solutions Limited 2010',
		'branches_starttime' => (int) 1728400485,
		'branch_id' => '164',
		'allow_guest' => '1',
		'BranchesPageVars' => null,
		'breadcrumb_depth' => '3',
		'breadcrumb_separator' => '&raquo;',
		'breadcrumbs' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			)
		),
		'title_for_layout' => 'South West Photo Mounts',
		'generated_url' => 'NULL',
		'requested_url' => '/albums/catalogue/colorama/',
		'trackback' => array(
			(int) 0 => '0',
			(int) 1 => '18',
			(int) 2 => '164'
		),
		'admin_menu' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			)
		),
		'menu' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			)
		),
		'branches_copyright' => '&copy; 2008-2024 Custom Creative Solutions Limited. All Rights Reserved.',
		'branches_version' => '2.3.0.0',
		'client_name_long' => 'South West Photo Mounts',
		'client_name_short' => 'SWPM',
		'SVNRevision' => '977
',
		'SVNRevisionHistory' => (int) 0,
		'admin_url' => '/dashboard/',
		'asset_path' => 'swpm',
		'sql_dump' => '1'
	)
	view => 'brochure'
	layout => 'swpm/default'
	autoRender => false
	autoLayout => true
	Components => object(ComponentCollection) {
		defaultPriority => (int) 10
		[protected] _Controller => object(ShopController) {}
		[protected] _enabled => array(
			[maximum depth reached]
		)
		[protected] _loaded => array(
			[maximum depth reached]
		)
	}
	viewClass => 'View'
	View => object(View) {
		Helpers => object(HelperCollection) {}
		Blocks => object(ViewBlock) {}
		plugin => 'Retail'
		name => 'Shop'
		passedArgs => array(
			[maximum depth reached]
		)
		helpers => array([maximum depth reached])
		viewPath => 'Shop'
		viewVars => array(
			[maximum depth reached]
		)
		view => 'brochure'
		layout => 'swpm/default'
		layoutPath => null
		autoLayout => true
		ext => '.ctp'
		subDir => null
		theme => null
		cacheAction => false
		validationErrors => array(
			[maximum depth reached]
		)
		hasRendered => false
		uuids => array([maximum depth reached])
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		elementCache => 'default'
		elementCacheSettings => array([maximum depth reached])
		[protected] _passedVars => array(
			[maximum depth reached]
		)
		[protected] _scripts => array([maximum depth reached])
		[protected] _paths => array([maximum depth reached])
		[protected] _pathsForPlugin => array(
			[maximum depth reached]
		)
		[protected] _parents => array([maximum depth reached])
		[protected] _current => null
		[protected] _currentType => ''
		[protected] _stack => array([maximum depth reached])
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _eventManagerConfigured => false
	}
	ext => '.ctp'
	plugin => 'Retail'
	cacheAction => false
	passedArgs => array(
		(int) 0 => 'colorama'
	)
	scaffold => false
	methods => array(
		(int) 0 => 'addressblock',
		(int) 1 => 'paymentblock',
		(int) 2 => 'addpaymentblock',
		(int) 3 => 'countrywordtoshort3',
		(int) 4 => 'continue_shopping',
		(int) 5 => 'catalogue',
		(int) 6 => 'brochure',
		(int) 7 => 'ajax_list_load',
		(int) 8 => 'update_block',
		(int) 9 => 'account',
		(int) 10 => 'register',
		(int) 11 => 'basket',
		(int) 12 => 'getbaskettotals',
		(int) 13 => 'addtobasket',
		(int) 14 => 'removefrombasket',
		(int) 15 => 'deletecurrentbasket',
		(int) 16 => 'gotocheckout',
		(int) 17 => 'gotomotocheckout',
		(int) 18 => 'basketqtychange',
		(int) 19 => 'optionchange',
		(int) 20 => 'quantitychange',
		(int) 21 => 'staffsessionlaunch',
		(int) 23 => 'changeDbSource',
		(int) 25 => '__validateLoginStatus',
		(int) 26 => '__check'
	)
	modelClass => 'User'
	modelKey => 'shop'
	validationErrors => null
	Acl => object(AclComponent) {
		Aro => object(Aro) {}
		Aco => object(Aco) {}
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _Instance => object(DbAcl) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	Session => object(SessionComponent) {
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	RequestHandler => object(RequestHandlerComponent) {
		ajaxLayout => 'ajax'
		enabled => true
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		ext => null
		params => array(
			[maximum depth reached]
		)
		settings => array(
			[maximum depth reached]
		)
		components => array([maximum depth reached])
		[protected] _renderType => null
		[protected] _inputTypeMap => array(
			[maximum depth reached]
		)
		[protected] _viewClassMap => array(
			[maximum depth reached]
		)
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	BranchesCommon => object(BranchesCommonComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		Guest => object(Guest) {}
		User => object(User) {}
		Cookie => object(CookieComponent) {}
		Session => object(SessionComponent) {}
		ContentPrototype => object(ContentPrototype) {}
		Branch => object(Branch) {}
		autoRender => false
		Acl => object(AclComponent) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	Flash => object(FlashComponent) {
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _defaultConfig => array(
			[maximum depth reached]
		)
		[protected] _Collection => null
		[protected] _componentMap => array([maximum depth reached])
	}
	RetailCommon => object(RetailCommonComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		Catalogueitem => object(Catalogueitem) {}
		Cataloguetoversion => object(Cataloguetoversion) {}
		Varchar255_retail_attribute => object(Varchar255_retail_attribute) {}
		Catalogueversion => object(Catalogueversion) {}
		Tax => object(Tax) {}
		Taxrate => object(Taxrate) {}
		Currency => object(Currency) {}
		Ptype => object(Ptype) {}
		Session => object(SessionComponent) {}
		Tinyint1_retail_attribute => object(Tinyint1_retail_attribute) {}
		Int5_retail_attribute => object(Int5_retail_attribute) {}
		Int11_retail_attribute => object(Int11_retail_attribute) {}
		Int20_retail_attribute => object(Int20_retail_attribute) {}
		Float_retail_attribute => object(Float_retail_attribute) {}
		Varchar500_retail_attribute => object(Varchar500_retail_attribute) {}
		Text_retail_attribute => object(Text_retail_attribute) {}
		Datetime_retail_attribute => object(Datetime_retail_attribute) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	Paginator => object(PaginatorComponent) {
		settings => array(
			[maximum depth reached]
		)
		whitelist => array(
			[maximum depth reached]
		)
		components => array([maximum depth reached])
		Controller => object(ShopController) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	AddressBook => object(AddressBookComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	PaymentProcessor => object(PaymentProcessorComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	Module => object(Module) {
		name => 'Module'
		useDbConfig => 'default'
		useTable => 'modules'
		id => false
		data => array([maximum depth reached])
		schemaName => 'SWPM_public'
		table => 'modules'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		alias => 'Module'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	Variable => object(Variable) {
		name => 'Variable'
		useDbConfig => 'default'
		useTable => 'variables'
		id => false
		data => array([maximum depth reached])
		schemaName => 'SWPM_public'
		table => 'variables'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		alias => 'Variable'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	Branch => object(Branch) {
		name => 'Branch'
		useDbConfig => 'default'
		useTable => 'branches'
		id => (int) 1
		data => array(
			[maximum depth reached]
		)
		schemaName => 'SWPM_public'
		table => 'branches'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		alias => 'Branch'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {
		[protected] _generalManager => object(CakeEventManager) {}
		[protected] _listeners => array(
			[maximum depth reached]
		)
		[protected] _isGlobal => false
	}
}
array(
	(int) 0 => 'colorama'
)

CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest)


        $response = $controller->response;
        $render = true;
        $result = $controller->invokeAction($request);
        if ($result instanceof CakeResponse) {

object(CakeRequest) {
	params => array(
		'plugin' => 'retail',
		'controller' => 'shop',
		'action' => 'brochure',
		'named' => array(),
		'pass' => array(
			(int) 0 => 'colorama'
		),
		'isAjax' => false,
		'models' => array(
			'User' => array(
				[maximum depth reached]
			),
			'Userdetail' => array(
				[maximum depth reached]
			),
			'Messagelist' => array(
				[maximum depth reached]
			),
			'Client' => array(
				[maximum depth reached]
			),
			'Float_retail_attribute' => array(
				[maximum depth reached]
			),
			'Tinyint1_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int5_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int11_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int20_retail_attribute' => array(
				[maximum depth reached]
			),
			'Varchar255_retail_attribute' => array(
				[maximum depth reached]
			),
			'Varchar500_retail_attribute' => array(
				[maximum depth reached]
			),
			'Text_retail_attribute' => array(
				[maximum depth reached]
			),
			'Datetime_retail_attribute' => array(
				[maximum depth reached]
			),
			'Catalogueitem' => array(
				[maximum depth reached]
			),
			'Ptype' => array(
				[maximum depth reached]
			),
			'Cataloguetoversion' => array(
				[maximum depth reached]
			),
			'Order' => array(
				[maximum depth reached]
			),
			'Payment' => array(
				[maximum depth reached]
			),
			'Banktransaction' => array(
				[maximum depth reached]
			),
			'Cardtransaction' => array(
				[maximum depth reached]
			),
			'Paymenttransaction' => array(
				[maximum depth reached]
			),
			'Invoice' => array(
				[maximum depth reached]
			),
			'Pickingnote' => array(
				[maximum depth reached]
			),
			'Country' => array(
				[maximum depth reached]
			),
			'Branch' => array(
				[maximum depth reached]
			),
			'Variable' => array(
				[maximum depth reached]
			),
			'Module' => array(
				[maximum depth reached]
			),
			'Permission' => array(
				[maximum depth reached]
			),
			'Aro' => array(
				[maximum depth reached]
			),
			'Aco' => array(
				[maximum depth reached]
			),
			'Guest' => array(
				[maximum depth reached]
			),
			'ContentPrototype' => array(
				[maximum depth reached]
			),
			'Catalogueversion' => array(
				[maximum depth reached]
			),
			'Tax' => array(
				[maximum depth reached]
			),
			'Taxrate' => array(
				[maximum depth reached]
			),
			'Currency' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'albums/catalogue/colorama/'
	base => ''
	webroot => '/'
	here => '/albums/catalogue/colorama/'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'patch' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PATCH'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}

CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(ShopController, CakeRequest)

            ));
        }

        $response = $this->_invoke($controller, $request);
        if (isset($request->params['return'])) {

object(ShopController) {
	name => 'Shop'
	uses => array(
		(int) 0 => 'User',
		(int) 1 => 'Userdetail',
		(int) 2 => 'Messagelist',
		(int) 3 => 'Swpmcm.Client',
		(int) 4 => 'Retail.Float_retail_attribute',
		(int) 5 => 'Retail.Tinyint1_retail_attribute',
		(int) 6 => 'Retail.Int5_retail_attribute',
		(int) 7 => 'Retail.Int11_retail_attribute',
		(int) 8 => 'Retail.Int20_retail_attribute',
		(int) 9 => 'Retail.Varchar255_retail_attribute',
		(int) 10 => 'Retail.Varchar500_retail_attribute',
		(int) 11 => 'Retail.Text_retail_attribute',
		(int) 12 => 'Retail.Datetime_retail_attribute',
		(int) 13 => 'Retail.Catalogueitem',
		(int) 14 => 'Retail.Ptype',
		(int) 15 => 'Retail.Cataloguetoversion',
		(int) 16 => 'Retail.Order',
		(int) 17 => 'Retail.Payment',
		(int) 18 => 'Retail.Banktransaction',
		(int) 19 => 'Retail.Cardtransaction',
		(int) 20 => 'Retail.Paymenttransaction',
		(int) 21 => 'Retail.Invoice',
		(int) 22 => 'Retail.Pickingnote',
		(int) 23 => 'Retail.Country',
		(int) 24 => 'Branch',
		(int) 25 => 'Variable',
		(int) 26 => 'Module'
	)
	components => array(
		'Acl' => null,
		'Session' => null,
		'RequestHandler' => null,
		'BranchesCommon' => null,
		'Flash' => null,
		'Retail.RetailCommon' => null,
		'Paginator' => null,
		'Retail.AddressBook' => null,
		'Retail.PaymentProcessor' => null
	)
	helpers => array()
	request => object(CakeRequest) {
		params => array(
			[maximum depth reached]
		)
		data => array([maximum depth reached])
		query => array([maximum depth reached])
		url => 'albums/catalogue/colorama/'
		base => ''
		webroot => '/'
		here => '/albums/catalogue/colorama/'
		[protected] _detectors => array(
			[maximum depth reached]
		)
		[protected] _input => ''
	}
	response => object(CakeResponse) {
		[protected] _statusCodes => array(
			[maximum depth reached]
		)
		[protected] _mimeTypes => array(
			[maximum depth reached]
		)
		[protected] _protocol => 'HTTP/1.1'
		[protected] _status => (int) 200
		[protected] _contentType => 'text/html'
		[protected] _headers => array([maximum depth reached])
		[protected] _body => null
		[protected] _file => null
		[protected] _fileRange => null
		[protected] _charset => 'UTF-8'
		[protected] _cacheDirectives => array([maximum depth reached])
		[protected] _cookies => array(
			[maximum depth reached]
		)
	}
	viewPath => 'Shop'
	layoutPath => null
	viewVars => array(
		'ShopData' => array(
			'prototype' => array(
				[maximum depth reached]
			),
			'breadcrumbs' => array(
				[maximum depth reached]
			),
			'parent_category' => array(
				[maximum depth reached]
			),
			'category' => array(
				[maximum depth reached]
			),
			'PageStamp' => '44_192_95_161_1728400485_978'
		),
		'user' => array(
			'type' => 'Guest',
			'group_id' => 'Guest',
			'id' => 'G2205161',
			'raw_id' => '2205161'
		),
		'froala_key' => 'AsvrnC5kcs==',
		'website_author' => 'Custom Creative Solutions Limited 2010',
		'website_www' => 'www.swpm.net',
		'copyright_startdate' => '2011',
		'copyright_footer' => 'South West Photo Mounts. All Rights Reserved.',
		'website_keywords' => 'South West Photo Mounts, swpm.net, Mifsud, Mifsuds, Jorgensen, Art, Studio, Pro Bound, Styla, Bespoke, JAD, Jorgensen Album Designer, Pro: dashboard, Professional, Photographer, UK, Ireland, Wedding Photography, Wedding Album, Portrait Photographer, Commercial Photographer, Album Assembly, Custom Mats',
		'website_description' => 'South West Photo Mounts. With over 25 years of experience supplying professional photographers, SWPM has a comprehensive range of products to suite all needs from CD folios, folders, through to beautiful bespoke albums.',
		'website_coding' => 'Custom Creative Solutions Limited 2010',
		'website_design' => 'Custom Creative Solutions Limited 2010',
		'branches_starttime' => (int) 1728400485,
		'branch_id' => '164',
		'allow_guest' => '1',
		'BranchesPageVars' => null,
		'breadcrumb_depth' => '3',
		'breadcrumb_separator' => '&raquo;',
		'breadcrumbs' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			)
		),
		'title_for_layout' => 'South West Photo Mounts',
		'generated_url' => 'NULL',
		'requested_url' => '/albums/catalogue/colorama/',
		'trackback' => array(
			(int) 0 => '0',
			(int) 1 => '18',
			(int) 2 => '164'
		),
		'admin_menu' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			)
		),
		'menu' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			),
			(int) 4 => array(
				[maximum depth reached]
			),
			(int) 5 => array(
				[maximum depth reached]
			),
			(int) 6 => array(
				[maximum depth reached]
			),
			(int) 7 => array(
				[maximum depth reached]
			)
		),
		'branches_copyright' => '&copy; 2008-2024 Custom Creative Solutions Limited. All Rights Reserved.',
		'branches_version' => '2.3.0.0',
		'client_name_long' => 'South West Photo Mounts',
		'client_name_short' => 'SWPM',
		'SVNRevision' => '977
',
		'SVNRevisionHistory' => (int) 0,
		'admin_url' => '/dashboard/',
		'asset_path' => 'swpm',
		'sql_dump' => '1'
	)
	view => 'brochure'
	layout => 'swpm/default'
	autoRender => false
	autoLayout => true
	Components => object(ComponentCollection) {
		defaultPriority => (int) 10
		[protected] _Controller => object(ShopController) {}
		[protected] _enabled => array(
			[maximum depth reached]
		)
		[protected] _loaded => array(
			[maximum depth reached]
		)
	}
	viewClass => 'View'
	View => object(View) {
		Helpers => object(HelperCollection) {}
		Blocks => object(ViewBlock) {}
		plugin => 'Retail'
		name => 'Shop'
		passedArgs => array(
			[maximum depth reached]
		)
		helpers => array([maximum depth reached])
		viewPath => 'Shop'
		viewVars => array(
			[maximum depth reached]
		)
		view => 'brochure'
		layout => 'swpm/default'
		layoutPath => null
		autoLayout => true
		ext => '.ctp'
		subDir => null
		theme => null
		cacheAction => false
		validationErrors => array(
			[maximum depth reached]
		)
		hasRendered => false
		uuids => array([maximum depth reached])
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		elementCache => 'default'
		elementCacheSettings => array([maximum depth reached])
		[protected] _passedVars => array(
			[maximum depth reached]
		)
		[protected] _scripts => array([maximum depth reached])
		[protected] _paths => array([maximum depth reached])
		[protected] _pathsForPlugin => array(
			[maximum depth reached]
		)
		[protected] _parents => array([maximum depth reached])
		[protected] _current => null
		[protected] _currentType => ''
		[protected] _stack => array([maximum depth reached])
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _eventManagerConfigured => false
	}
	ext => '.ctp'
	plugin => 'Retail'
	cacheAction => false
	passedArgs => array(
		(int) 0 => 'colorama'
	)
	scaffold => false
	methods => array(
		(int) 0 => 'addressblock',
		(int) 1 => 'paymentblock',
		(int) 2 => 'addpaymentblock',
		(int) 3 => 'countrywordtoshort3',
		(int) 4 => 'continue_shopping',
		(int) 5 => 'catalogue',
		(int) 6 => 'brochure',
		(int) 7 => 'ajax_list_load',
		(int) 8 => 'update_block',
		(int) 9 => 'account',
		(int) 10 => 'register',
		(int) 11 => 'basket',
		(int) 12 => 'getbaskettotals',
		(int) 13 => 'addtobasket',
		(int) 14 => 'removefrombasket',
		(int) 15 => 'deletecurrentbasket',
		(int) 16 => 'gotocheckout',
		(int) 17 => 'gotomotocheckout',
		(int) 18 => 'basketqtychange',
		(int) 19 => 'optionchange',
		(int) 20 => 'quantitychange',
		(int) 21 => 'staffsessionlaunch',
		(int) 23 => 'changeDbSource',
		(int) 25 => '__validateLoginStatus',
		(int) 26 => '__check'
	)
	modelClass => 'User'
	modelKey => 'shop'
	validationErrors => null
	Acl => object(AclComponent) {
		Aro => object(Aro) {}
		Aco => object(Aco) {}
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _Instance => object(DbAcl) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	Session => object(SessionComponent) {
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	RequestHandler => object(RequestHandlerComponent) {
		ajaxLayout => 'ajax'
		enabled => true
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		ext => null
		params => array(
			[maximum depth reached]
		)
		settings => array(
			[maximum depth reached]
		)
		components => array([maximum depth reached])
		[protected] _renderType => null
		[protected] _inputTypeMap => array(
			[maximum depth reached]
		)
		[protected] _viewClassMap => array(
			[maximum depth reached]
		)
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	BranchesCommon => object(BranchesCommonComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		Guest => object(Guest) {}
		User => object(User) {}
		Cookie => object(CookieComponent) {}
		Session => object(SessionComponent) {}
		ContentPrototype => object(ContentPrototype) {}
		Branch => object(Branch) {}
		autoRender => false
		Acl => object(AclComponent) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	Flash => object(FlashComponent) {
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _defaultConfig => array(
			[maximum depth reached]
		)
		[protected] _Collection => null
		[protected] _componentMap => array([maximum depth reached])
	}
	RetailCommon => object(RetailCommonComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		Catalogueitem => object(Catalogueitem) {}
		Cataloguetoversion => object(Cataloguetoversion) {}
		Varchar255_retail_attribute => object(Varchar255_retail_attribute) {}
		Catalogueversion => object(Catalogueversion) {}
		Tax => object(Tax) {}
		Taxrate => object(Taxrate) {}
		Currency => object(Currency) {}
		Ptype => object(Ptype) {}
		Session => object(SessionComponent) {}
		Tinyint1_retail_attribute => object(Tinyint1_retail_attribute) {}
		Int5_retail_attribute => object(Int5_retail_attribute) {}
		Int11_retail_attribute => object(Int11_retail_attribute) {}
		Int20_retail_attribute => object(Int20_retail_attribute) {}
		Float_retail_attribute => object(Float_retail_attribute) {}
		Varchar500_retail_attribute => object(Varchar500_retail_attribute) {}
		Text_retail_attribute => object(Text_retail_attribute) {}
		Datetime_retail_attribute => object(Datetime_retail_attribute) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	Paginator => object(PaginatorComponent) {
		settings => array(
			[maximum depth reached]
		)
		whitelist => array(
			[maximum depth reached]
		)
		components => array([maximum depth reached])
		Controller => object(ShopController) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	AddressBook => object(AddressBookComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	PaymentProcessor => object(PaymentProcessorComponent) {
		components => array(
			[maximum depth reached]
		)
		settings => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	Module => object(Module) {
		name => 'Module'
		useDbConfig => 'default'
		useTable => 'modules'
		id => false
		data => array([maximum depth reached])
		schemaName => 'SWPM_public'
		table => 'modules'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		alias => 'Module'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	Variable => object(Variable) {
		name => 'Variable'
		useDbConfig => 'default'
		useTable => 'variables'
		id => false
		data => array([maximum depth reached])
		schemaName => 'SWPM_public'
		table => 'variables'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		alias => 'Variable'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	Branch => object(Branch) {
		name => 'Branch'
		useDbConfig => 'default'
		useTable => 'branches'
		id => (int) 1
		data => array(
			[maximum depth reached]
		)
		schemaName => 'SWPM_public'
		table => 'branches'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		alias => 'Branch'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {
		[protected] _generalManager => object(CakeEventManager) {}
		[protected] _listeners => array(
			[maximum depth reached]
		)
		[protected] _isGlobal => false
	}
}
object(CakeRequest) {
	params => array(
		'plugin' => 'retail',
		'controller' => 'shop',
		'action' => 'brochure',
		'named' => array(),
		'pass' => array(
			(int) 0 => 'colorama'
		),
		'isAjax' => false,
		'models' => array(
			'User' => array(
				[maximum depth reached]
			),
			'Userdetail' => array(
				[maximum depth reached]
			),
			'Messagelist' => array(
				[maximum depth reached]
			),
			'Client' => array(
				[maximum depth reached]
			),
			'Float_retail_attribute' => array(
				[maximum depth reached]
			),
			'Tinyint1_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int5_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int11_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int20_retail_attribute' => array(
				[maximum depth reached]
			),
			'Varchar255_retail_attribute' => array(
				[maximum depth reached]
			),
			'Varchar500_retail_attribute' => array(
				[maximum depth reached]
			),
			'Text_retail_attribute' => array(
				[maximum depth reached]
			),
			'Datetime_retail_attribute' => array(
				[maximum depth reached]
			),
			'Catalogueitem' => array(
				[maximum depth reached]
			),
			'Ptype' => array(
				[maximum depth reached]
			),
			'Cataloguetoversion' => array(
				[maximum depth reached]
			),
			'Order' => array(
				[maximum depth reached]
			),
			'Payment' => array(
				[maximum depth reached]
			),
			'Banktransaction' => array(
				[maximum depth reached]
			),
			'Cardtransaction' => array(
				[maximum depth reached]
			),
			'Paymenttransaction' => array(
				[maximum depth reached]
			),
			'Invoice' => array(
				[maximum depth reached]
			),
			'Pickingnote' => array(
				[maximum depth reached]
			),
			'Country' => array(
				[maximum depth reached]
			),
			'Branch' => array(
				[maximum depth reached]
			),
			'Variable' => array(
				[maximum depth reached]
			),
			'Module' => array(
				[maximum depth reached]
			),
			'Permission' => array(
				[maximum depth reached]
			),
			'Aro' => array(
				[maximum depth reached]
			),
			'Aco' => array(
				[maximum depth reached]
			),
			'Guest' => array(
				[maximum depth reached]
			),
			'ContentPrototype' => array(
				[maximum depth reached]
			),
			'Catalogueversion' => array(
				[maximum depth reached]
			),
			'Tax' => array(
				[maximum depth reached]
			),
			'Taxrate' => array(
				[maximum depth reached]
			),
			'Currency' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'albums/catalogue/colorama/'
	base => ''
	webroot => '/'
	here => '/albums/catalogue/colorama/'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'patch' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PATCH'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}

/home/SWPM/web/swpm.net/public_html/index.php line 182 → Dispatcher->dispatch(CakeRequest, CakeResponse)

        App::uses('Dispatcher', 'Routing');

        $Dispatcher = new Dispatcher();
        $Dispatcher->dispatch(new CakeRequest(), new CakeResponse(array('charset' => Configure::read('App.encoding'))));

object(CakeRequest) {
	params => array(
		'plugin' => 'retail',
		'controller' => 'shop',
		'action' => 'brochure',
		'named' => array(),
		'pass' => array(
			(int) 0 => 'colorama'
		),
		'isAjax' => false,
		'models' => array(
			'User' => array(
				[maximum depth reached]
			),
			'Userdetail' => array(
				[maximum depth reached]
			),
			'Messagelist' => array(
				[maximum depth reached]
			),
			'Client' => array(
				[maximum depth reached]
			),
			'Float_retail_attribute' => array(
				[maximum depth reached]
			),
			'Tinyint1_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int5_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int11_retail_attribute' => array(
				[maximum depth reached]
			),
			'Int20_retail_attribute' => array(
				[maximum depth reached]
			),
			'Varchar255_retail_attribute' => array(
				[maximum depth reached]
			),
			'Varchar500_retail_attribute' => array(
				[maximum depth reached]
			),
			'Text_retail_attribute' => array(
				[maximum depth reached]
			),
			'Datetime_retail_attribute' => array(
				[maximum depth reached]
			),
			'Catalogueitem' => array(
				[maximum depth reached]
			),
			'Ptype' => array(
				[maximum depth reached]
			),
			'Cataloguetoversion' => array(
				[maximum depth reached]
			),
			'Order' => array(
				[maximum depth reached]
			),
			'Payment' => array(
				[maximum depth reached]
			),
			'Banktransaction' => array(
				[maximum depth reached]
			),
			'Cardtransaction' => array(
				[maximum depth reached]
			),
			'Paymenttransaction' => array(
				[maximum depth reached]
			),
			'Invoice' => array(
				[maximum depth reached]
			),
			'Pickingnote' => array(
				[maximum depth reached]
			),
			'Country' => array(
				[maximum depth reached]
			),
			'Branch' => array(
				[maximum depth reached]
			),
			'Variable' => array(
				[maximum depth reached]
			),
			'Module' => array(
				[maximum depth reached]
			),
			'Permission' => array(
				[maximum depth reached]
			),
			'Aro' => array(
				[maximum depth reached]
			),
			'Aco' => array(
				[maximum depth reached]
			),
			'Guest' => array(
				[maximum depth reached]
			),
			'ContentPrototype' => array(
				[maximum depth reached]
			),
			'Catalogueversion' => array(
				[maximum depth reached]
			),
			'Tax' => array(
				[maximum depth reached]
			),
			'Taxrate' => array(
				[maximum depth reached]
			),
			'Currency' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'albums/catalogue/colorama/'
	base => ''
	webroot => '/'
	here => '/albums/catalogue/colorama/'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'patch' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PATCH'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}
object(CakeResponse) {
	[protected] _statusCodes => array(
		(int) 100 => 'Continue',
		(int) 101 => 'Switching Protocols',
		(int) 200 => 'OK',
		(int) 201 => 'Created',
		(int) 202 => 'Accepted',
		(int) 203 => 'Non-Authoritative Information',
		(int) 204 => 'No Content',
		(int) 205 => 'Reset Content',
		(int) 206 => 'Partial Content',
		(int) 300 => 'Multiple Choices',
		(int) 301 => 'Moved Permanently',
		(int) 302 => 'Found',
		(int) 303 => 'See Other',
		(int) 304 => 'Not Modified',
		(int) 305 => 'Use Proxy',
		(int) 307 => 'Temporary Redirect',
		(int) 400 => 'Bad Request',
		(int) 401 => 'Unauthorized',
		(int) 402 => 'Payment Required',
		(int) 403 => 'Forbidden',
		(int) 404 => 'Not Found',
		(int) 405 => 'Method Not Allowed',
		(int) 406 => 'Not Acceptable',
		(int) 407 => 'Proxy Authentication Required',
		(int) 408 => 'Request Time-out',
		(int) 409 => 'Conflict',
		(int) 410 => 'Gone',
		(int) 411 => 'Length Required',
		(int) 412 => 'Precondition Failed',
		(int) 413 => 'Request Entity Too Large',
		(int) 414 => 'Request-URI Too Large',
		(int) 415 => 'Unsupported Media Type',
		(int) 416 => 'Requested range not satisfiable',
		(int) 417 => 'Expectation Failed',
		(int) 429 => 'Too Many Requests',
		(int) 500 => 'Internal Server Error',
		(int) 501 => 'Not Implemented',
		(int) 502 => 'Bad Gateway',
		(int) 503 => 'Service Unavailable',
		(int) 504 => 'Gateway Time-out',
		(int) 505 => 'Unsupported Version'
	)
	[protected] _mimeTypes => array(
		'html' => array(
			(int) 0 => 'text/html',
			(int) 1 => '*/*'
		),
		'json' => 'application/json',
		'xml' => array(
			(int) 0 => 'application/xml',
			(int) 1 => 'text/xml'
		),
		'rss' => 'application/rss+xml',
		'ai' => 'application/postscript',
		'bcpio' => 'application/x-bcpio',
		'bin' => 'application/octet-stream',
		'ccad' => 'application/clariscad',
		'cdf' => 'application/x-netcdf',
		'class' => 'application/octet-stream',
		'cpio' => 'application/x-cpio',
		'cpt' => 'application/mac-compactpro',
		'csh' => 'application/x-csh',
		'csv' => array(
			(int) 0 => 'text/csv',
			(int) 1 => 'application/vnd.ms-excel'
		),
		'dcr' => 'application/x-director',
		'dir' => 'application/x-director',
		'dms' => 'application/octet-stream',
		'doc' => 'application/msword',
		'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
		'drw' => 'application/drafting',
		'dvi' => 'application/x-dvi',
		'dwg' => 'application/acad',
		'dxf' => 'application/dxf',
		'dxr' => 'application/x-director',
		'eot' => 'application/vnd.ms-fontobject',
		'eps' => 'application/postscript',
		'exe' => 'application/octet-stream',
		'ez' => 'application/andrew-inset',
		'flv' => 'video/x-flv',
		'gtar' => 'application/x-gtar',
		'gz' => 'application/x-gzip',
		'bz2' => 'application/x-bzip',
		'7z' => 'application/x-7z-compressed',
		'hdf' => 'application/x-hdf',
		'hqx' => 'application/mac-binhex40',
		'ico' => 'image/x-icon',
		'ips' => 'application/x-ipscript',
		'ipx' => 'application/x-ipix',
		'js' => 'application/javascript',
		'jsonapi' => 'application/vnd.api+json',
		'latex' => 'application/x-latex',
		'lha' => 'application/octet-stream',
		'lsp' => 'application/x-lisp',
		'lzh' => 'application/octet-stream',
		'man' => 'application/x-troff-man',
		'me' => 'application/x-troff-me',
		'mif' => 'application/vnd.mif',
		'ms' => 'application/x-troff-ms',
		'nc' => 'application/x-netcdf',
		'oda' => 'application/oda',
		'otf' => 'font/otf',
		'pdf' => 'application/pdf',
		'pgn' => 'application/x-chess-pgn',
		'pot' => 'application/vnd.ms-powerpoint',
		'pps' => 'application/vnd.ms-powerpoint',
		'ppt' => 'application/vnd.ms-powerpoint',
		'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
		'ppz' => 'application/vnd.ms-powerpoint',
		'pre' => 'application/x-freelance',
		'prt' => 'application/pro_eng',
		'ps' => 'application/postscript',
		'roff' => 'application/x-troff',
		'scm' => 'application/x-lotusscreencam',
		'set' => 'application/set',
		'sh' => 'application/x-sh',
		'shar' => 'application/x-shar',
		'sit' => 'application/x-stuffit',
		'skd' => 'application/x-koan',
		'skm' => 'application/x-koan',
		'skp' => 'application/x-koan',
		'skt' => 'application/x-koan',
		'smi' => 'application/smil',
		'smil' => 'application/smil',
		'sol' => 'application/solids',
		'spl' => 'application/x-futuresplash',
		'src' => 'application/x-wais-source',
		'step' => 'application/STEP',
		'stl' => 'application/SLA',
		'stp' => 'application/STEP',
		'sv4cpio' => 'application/x-sv4cpio',
		'sv4crc' => 'application/x-sv4crc',
		'svg' => 'image/svg+xml',
		'svgz' => 'image/svg+xml',
		'swf' => 'application/x-shockwave-flash',
		't' => 'application/x-troff',
		'tar' => 'application/x-tar',
		'tcl' => 'application/x-tcl',
		'tex' => 'application/x-tex',
		'texi' => 'application/x-texinfo',
		'texinfo' => 'application/x-texinfo',
		'tr' => 'application/x-troff',
		'tsp' => 'application/dsptype',
		'ttc' => 'font/ttf',
		'ttf' => 'font/ttf',
		'unv' => 'application/i-deas',
		'ustar' => 'application/x-ustar',
		'vcd' => 'application/x-cdlink',
		'vda' => 'application/vda',
		'xlc' => 'application/vnd.ms-excel',
		'xll' => 'application/vnd.ms-excel',
		'xlm' => 'application/vnd.ms-excel',
		'xls' => 'application/vnd.ms-excel',
		'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
		'xlw' => 'application/vnd.ms-excel',
		'zip' => 'application/zip',
		'aif' => 'audio/x-aiff',
		'aifc' => 'audio/x-aiff',
		'aiff' => 'audio/x-aiff',
		'au' => 'audio/basic',
		'kar' => 'audio/midi',
		'mid' => 'audio/midi',
		'midi' => 'audio/midi',
		'mp2' => 'audio/mpeg',
		'mp3' => 'audio/mpeg',
		'mpga' => 'audio/mpeg',
		'ogg' => 'audio/ogg',
		'oga' => 'audio/ogg',
		'spx' => 'audio/ogg',
		'ra' => 'audio/x-realaudio',
		'ram' => 'audio/x-pn-realaudio',
		'rm' => 'audio/x-pn-realaudio',
		'rpm' => 'audio/x-pn-realaudio-plugin',
		'snd' => 'audio/basic',
		'tsi' => 'audio/TSP-audio',
		'wav' => 'audio/x-wav',
		'aac' => 'audio/aac',
		'asc' => 'text/plain',
		'c' => 'text/plain',
		'cc' => 'text/plain',
		'css' => 'text/css',
		'etx' => 'text/x-setext',
		'f' => 'text/plain',
		'f90' => 'text/plain',
		'h' => 'text/plain',
		'hh' => 'text/plain',
		'htm' => array(
			(int) 0 => 'text/html',
			(int) 1 => '*/*'
		),
		'ics' => 'text/calendar',
		'm' => 'text/plain',
		'rtf' => 'text/rtf',
		'rtx' => 'text/richtext',
		'sgm' => 'text/sgml',
		'sgml' => 'text/sgml',
		'tsv' => 'text/tab-separated-values',
		'tpl' => 'text/template',
		'txt' => 'text/plain',
		'text' => 'text/plain',
		'avi' => 'video/x-msvideo',
		'fli' => 'video/x-fli',
		'mov' => 'video/quicktime',
		'movie' => 'video/x-sgi-movie',
		'mpe' => 'video/mpeg',
		'mpeg' => 'video/mpeg',
		'mpg' => 'video/mpeg',
		'qt' => 'video/quicktime',
		'viv' => 'video/vnd.vivo',
		'vivo' => 'video/vnd.vivo',
		'ogv' => 'video/ogg',
		'webm' => 'video/webm',
		'mp4' => 'video/mp4',
		'm4v' => 'video/mp4',
		'f4v' => 'video/mp4',
		'f4p' => 'video/mp4',
		'm4a' => 'audio/mp4',
		'f4a' => 'audio/mp4',
		'f4b' => 'audio/mp4',
		'gif' => 'image/gif',
		'ief' => 'image/ief',
		'jpg' => 'image/jpeg',
		'jpeg' => 'image/jpeg',
		'jpe' => 'image/jpeg',
		'pbm' => 'image/x-portable-bitmap',
		'pgm' => 'image/x-portable-graymap',
		'png' => 'image/png',
		'pnm' => 'image/x-portable-anymap',
		'ppm' => 'image/x-portable-pixmap',
		'ras' => 'image/cmu-raster',
		'rgb' => 'image/x-rgb',
		'tif' => 'image/tiff',
		'tiff' => 'image/tiff',
		'xbm' => 'image/x-xbitmap',
		'xpm' => 'image/x-xpixmap',
		'xwd' => 'image/x-xwindowdump',
		'psd' => array(
			(int) 0 => 'application/photoshop',
			(int) 1 => 'application/psd',
			(int) 2 => 'image/psd',
			(int) 3 => 'image/x-photoshop',
			(int) 4 => 'image/photoshop',
			(int) 5 => 'zz-application/zz-winassoc-psd'
		),
		'ice' => 'x-conference/x-cooltalk',
		'iges' => 'model/iges',
		'igs' => 'model/iges',
		'mesh' => 'model/mesh',
		'msh' => 'model/mesh',
		'silo' => 'model/mesh',
		'vrml' => 'model/vrml',
		'wrl' => 'model/vrml',
		'mime' => 'www/mime',
		'pdb' => 'chemical/x-pdb',
		'xyz' => 'chemical/x-pdb',
		'javascript' => 'application/javascript',
		'form' => 'application/x-www-form-urlencoded',
		'file' => 'multipart/form-data',
		'xhtml' => array(
			(int) 0 => 'application/xhtml+xml',
			(int) 1 => 'application/xhtml',
			(int) 2 => 'text/xhtml'
		),
		'xhtml-mobile' => 'application/vnd.wap.xhtml+xml',
		'atom' => 'application/atom+xml',
		'amf' => 'application/x-amf',
		'wap' => array(
			(int) 0 => 'text/vnd.wap.wml',
			(int) 1 => 'text/vnd.wap.wmlscript',
			(int) 2 => 'image/vnd.wap.wbmp'
		),
		'wml' => 'text/vnd.wap.wml',
		'wmlscript' => 'text/vnd.wap.wmlscript',
		'wbmp' => 'image/vnd.wap.wbmp',
		'woff' => 'application/x-font-woff',
		'webp' => 'image/webp',
		'appcache' => 'text/cache-manifest',
		'manifest' => 'text/cache-manifest',
		'htc' => 'text/x-component',
		'rdf' => 'application/xml',
		'crx' => 'application/x-chrome-extension',
		'oex' => 'application/x-opera-extension',
		'xpi' => 'application/x-xpinstall',
		'safariextz' => 'application/octet-stream',
		'webapp' => 'application/x-web-app-manifest+json',
		'vcf' => 'text/x-vcard',
		'vtt' => 'text/vtt',
		'mkv' => 'video/x-matroska',
		'pkpass' => 'application/vnd.apple.pkpass',
		'ajax' => 'text/html'
	)
	[protected] _protocol => 'HTTP/1.1'
	[protected] _status => (int) 200
	[protected] _contentType => 'text/html'
	[protected] _headers => array()
	[protected] _body => null
	[protected] _file => null
	[protected] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array()
	[protected] _cookies => array(
		'CakeCookie[User]' => array(
			'name' => 'CakeCookie[User]',
			'value' => 'Q2FrZQ==.+6BcRCUy+x6m8YWjJ6wPfoB19Ye5CYZ6ZP75p87KTNVYjvyNMH8I6TXnxHwSiOzVnbU9',
			'expire' => (int) 0,
			'path' => '/',
			'domain' => '',
			'secure' => false,
			'httpOnly' => false
		)
	)
}

(default) 426 queries took 96 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` IS NULL AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'structure' LIMIT 1	1	1	0
2	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1011 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'published' LIMIT 1	1	1	0
3	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1013 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'root' LIMIT 1	1	1	0
4	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1011 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'draft' LIMIT 1	1	1	0
5	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1014 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'root' LIMIT 1	1	1	0
6	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`value` = 'colorama' AND `Varchar255_retail_attribute`.`prototype_id` = 8 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` ASC LIMIT 1	0	0	9
7	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`value` = 'colorama' AND `Varchar255_retail_attribute`.`prototype_id` = 7 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` ASC LIMIT 1	0	0	10
8	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 130246 LIMIT 1	1	1	0
9	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130246 AND `Catalogueitem`.`value` NOT IN ('id', 'weight')	5	5	0
10	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130271 AND `Catalogueitem`.`value` = 'id' LIMIT 1	1	1	0
11	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130273 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
12	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130271 AND `Catalogueitem`.`value` = 'weight' LIMIT 1	1	1	0
13	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130272 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
14	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 1 LIMIT 1	1	1	0
15	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130265 AND `Catalogueitem`.`value` = 'id' LIMIT 1	1	1	0
16	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130266 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
17	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130265 AND `Catalogueitem`.`value` = 'weight' LIMIT 1	1	1	0
18	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130267 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
19	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 4 LIMIT 1	1	1	0
20	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130259 AND `Catalogueitem`.`value` = 'id' LIMIT 1	1	1	0
21	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130263 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
22	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130259 AND `Catalogueitem`.`value` = 'weight' LIMIT 1	1	1	0
23	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130264 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
24	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3191 LIMIT 1	1	1	0
25	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130247 AND `Catalogueitem`.`value` = 'id' LIMIT 1	1	1	0
26	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130248 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
27	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130247 AND `Catalogueitem`.`value` = 'weight' LIMIT 1	1	1	0
28	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130255 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
29	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3 LIMIT 1	1	1	0
30	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130277 AND `Catalogueitem`.`value` = 'id' LIMIT 1	1	1	0
31	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130282 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
32	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130277 AND `Catalogueitem`.`value` = 'weight' LIMIT 1	1	1	0
33	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130278 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
34	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
35	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 1 LIMIT 1	1	1	0
36	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 1 AND `Catalogueversion`.`status` = 1 LIMIT 1	1	1	0
37	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 1 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 530 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
38	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3 LIMIT 1	1	1	0
39	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 3 AND `Catalogueversion`.`status` = 1 LIMIT 1	1	1	0
40	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1784 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
41	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 4 LIMIT 1	1	1	0
42	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 4 AND `Catalogueversion`.`status` = 1 LIMIT 1	1	1	0
43	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 4 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1505 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
44	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3191 LIMIT 1	1	1	0
45	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 3191 AND `Catalogueversion`.`status` = 1 LIMIT 1	1	1	0
46	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3191 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1005 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
47	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
48	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 3942 AND `Catalogueversion`.`status` = 1 LIMIT 1	1	1	0
49	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3942 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
50	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
51	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
52	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
53	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 3942 AND `Catalogueversion`.`status` = 1 LIMIT 1	1	1	0
54	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
55	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
56	SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 366 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	4
57	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
58	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
59	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 378 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
60	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
61	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
62	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 105 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
63	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
64	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
65	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 433 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
66	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 433 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
67	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
68	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
69	SELECT `Text_retail_attribute`.`id`, `Text_retail_attribute`.`prototype_id`, `Text_retail_attribute`.`item_id`, `Text_retail_attribute`.`value`, `Text_retail_attribute`.`catalogueversion_id`, `Text_retail_attribute`.`created`, `Text_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_text_retail_attributes` AS `Text_retail_attribute` WHERE `Text_retail_attribute`.`prototype_id` = 31 AND `Text_retail_attribute`.`item_id` = 3942 AND `Text_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Text_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
70	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
71	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
72	SELECT `Text_retail_attribute`.`id`, `Text_retail_attribute`.`prototype_id`, `Text_retail_attribute`.`item_id`, `Text_retail_attribute`.`value`, `Text_retail_attribute`.`catalogueversion_id`, `Text_retail_attribute`.`created`, `Text_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_text_retail_attributes` AS `Text_retail_attribute` WHERE `Text_retail_attribute`.`prototype_id` = 32 AND `Text_retail_attribute`.`item_id` = 3942 AND `Text_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Text_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
73	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
74	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
75	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
76	SELECT `Text_retail_attribute`.`id`, `Text_retail_attribute`.`prototype_id`, `Text_retail_attribute`.`item_id`, `Text_retail_attribute`.`value`, `Text_retail_attribute`.`catalogueversion_id`, `Text_retail_attribute`.`created`, `Text_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_text_retail_attributes` AS `Text_retail_attribute` WHERE `Text_retail_attribute`.`prototype_id` = 35 AND `Text_retail_attribute`.`item_id` = 3942 AND `Text_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Text_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
77	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
78	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
79	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 34 AND `Varchar255_retail_attribute`.`item_id` = 3942 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	9
80	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
81	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
82	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
83	SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 86 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	4
84	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
85	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
86	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 37 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
87	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 37 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
88	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
89	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
90	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 38 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
91	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 38 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
92	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
93	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
94	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 39 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
95	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 39 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
96	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
97	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
98	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
99	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 41 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
100	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 41 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
101	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
102	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
103	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 42 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
104	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 42 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
105	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
106	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
107	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 43 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
108	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 43 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
109	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
110	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
111	SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 87 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	4
112	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
113	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
114	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
115	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 45 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
116	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 45 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
117	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
118	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
119	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 46 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
120	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 46 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
121	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
122	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
123	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 47 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
124	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 47 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
125	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
126	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
127	SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 89 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	4
128	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
129	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
130	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
131	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 49 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
132	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 49 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
133	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
134	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
135	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 50 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
136	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 50 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
137	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
138	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
139	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 51 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
140	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 51 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
141	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
142	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
143	SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 90 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	4
144	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
145	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
146	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
147	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 53 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
148	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 53 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
149	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
150	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
151	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 54 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
152	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 54 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
153	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
154	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
155	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 55 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
156	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 55 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
157	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
158	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
159	SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 91 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	4
160	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
161	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
162	SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 383 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	4
163	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
164	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
165	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` = 30 AND `Int11_retail_attribute`.`item_id` = 3942 AND `Int11_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
166	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` = 30 AND `Int11_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
167	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
168	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
169	SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3942 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
170	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
171	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
172	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 85 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	0	0	0
173	SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 85 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1	1	1	0
174	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
175	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` IS NULL LIMIT 1	0	0	0
176	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
177	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 130277 LIMIT 1	1	1	0
178	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130277 AND `Catalogueitem`.`value` NOT IN ('id', 'weight')	1	1	9
179	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130279 AND `Catalogueitem`.`value` = 'id' LIMIT 1	1	1	8
180	SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130281 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
181	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130279 AND `Catalogueitem`.`value` = 'weight' LIMIT 1	1	1	8
182	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130280 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
183	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3942 LIMIT 1	1	1	0
184	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 3942 AND `Catalogueitem`.`prototype_id` = 1 ORDER BY `Catalogueitem`.`value` ASC	3	3	9
185	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 4070 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
186	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 3192 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
187	SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 4795 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1	1	1	0
188	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' LIMIT 1	1	1	0
189	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3192 LIMIT 1	1	1	0
190	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 3192 AND `Catalogueversion`.`status` = 0 LIMIT 1	0	0	0
191	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 3192 LIMIT 1	1	1	0
192	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 3192 AND `Catalogueversion`.`status` = 1 LIMIT 1	1	1	0
193	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' LIMIT 1	1	1	0
194	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 4795 LIMIT 1	1	1	0
195	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 4795 AND `Catalogueversion`.`status` = 0 LIMIT 1	1	1	0
196	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 4795 LIMIT 1	1	1	0
197	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 4795 AND `Catalogueversion`.`status` = 1 LIMIT 1	0	0	0
198	SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0	1	1	0
199	SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`id` = 4795 LIMIT 1	1	1	0
200	SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 4795 AND `Catalogueversion`.`status` = 0 LIMIT 1	1	1	0

(default) 426 queries took 96 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` IS NULL AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'structure' LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1011 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'published' LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1013 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'root' LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1011 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'draft' LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 1014 AND `Catalogueitem`.`prototype_id` IS NULL AND `Catalogueitem`.`value` = 'root' LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`value` = 'colorama' AND `Varchar255_retail_attribute`.`prototype_id` = 8 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` ASC LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`value` = 'colorama' AND `Varchar255_retail_attribute`.`prototype_id` = 7 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` ASC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130246 AND `Catalogueitem`.`value` NOT IN ('id', 'weight')

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130271 AND `Catalogueitem`.`value` = 'id' LIMIT 1

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130273 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130271 AND `Catalogueitem`.`value` = 'weight' LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130272 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130265 AND `Catalogueitem`.`value` = 'id' LIMIT 1

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130266 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130265 AND `Catalogueitem`.`value` = 'weight' LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130267 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130259 AND `Catalogueitem`.`value` = 'id' LIMIT 1

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130263 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130259 AND `Catalogueitem`.`value` = 'weight' LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130264 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130247 AND `Catalogueitem`.`value` = 'id' LIMIT 1

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130248 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130247 AND `Catalogueitem`.`value` = 'weight' LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130255 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130277 AND `Catalogueitem`.`value` = 'id' LIMIT 1

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130282 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130277 AND `Catalogueitem`.`value` = 'weight' LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130278 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Catalogueversion`.`id`, `Catalogueversion`.`catalogueitem_id`, `Catalogueversion`.`version`, `Catalogueversion`.`status`, `Catalogueversion`.`created`, `Catalogueversion`.`modified` FROM `SWPM_public`.`RETAIL_catalogueversions` AS `Catalogueversion` WHERE `Catalogueversion`.`catalogueitem_id` = 1 AND `Catalogueversion`.`status` = 1 LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 1 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 530 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1784 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 4 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1505 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3191 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1005 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3942 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Variable`.`id`, `Variable`.`name`, `Variable`.`value`, `Variable`.`cache`, `Variable`.`module`, `Variable`.`domain_id` FROM `SWPM_public`.`variables` AS `Variable` WHERE `Variable`.`name` = 'BRANCHES_UPDATE' AND `Variable`.`domain_id` = 0

SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 366 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 378 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 105 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 433 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 433 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

SELECT `Text_retail_attribute`.`id`, `Text_retail_attribute`.`prototype_id`, `Text_retail_attribute`.`item_id`, `Text_retail_attribute`.`value`, `Text_retail_attribute`.`catalogueversion_id`, `Text_retail_attribute`.`created`, `Text_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_text_retail_attributes` AS `Text_retail_attribute` WHERE `Text_retail_attribute`.`prototype_id` = 31 AND `Text_retail_attribute`.`item_id` = 3942 AND `Text_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Text_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Text_retail_attribute`.`id`, `Text_retail_attribute`.`prototype_id`, `Text_retail_attribute`.`item_id`, `Text_retail_attribute`.`value`, `Text_retail_attribute`.`catalogueversion_id`, `Text_retail_attribute`.`created`, `Text_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_text_retail_attributes` AS `Text_retail_attribute` WHERE `Text_retail_attribute`.`prototype_id` = 32 AND `Text_retail_attribute`.`item_id` = 3942 AND `Text_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Text_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Text_retail_attribute`.`id`, `Text_retail_attribute`.`prototype_id`, `Text_retail_attribute`.`item_id`, `Text_retail_attribute`.`value`, `Text_retail_attribute`.`catalogueversion_id`, `Text_retail_attribute`.`created`, `Text_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_text_retail_attributes` AS `Text_retail_attribute` WHERE `Text_retail_attribute`.`prototype_id` = 35 AND `Text_retail_attribute`.`item_id` = 3942 AND `Text_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Text_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 34 AND `Varchar255_retail_attribute`.`item_id` = 3942 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 86 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 37 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 37 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 38 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 38 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 39 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 39 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 41 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

100

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 41 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

101

102

103

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 42 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

104

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 42 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

105

106

107

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 43 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

108

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 43 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1

109

110

111

SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 87 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

112

113

114

115

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 45 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

116

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 45 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

117

118

119

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 46 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

120

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 46 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

121

122

123

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 47 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

124

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 47 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1

125

126

127

SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 89 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

128

129

130

131

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 49 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

132

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 49 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

133

134

135

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 50 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

136

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 50 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

137

138

139

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 51 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

140

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 51 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1

141

142

143

SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 90 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

144

145

146

147

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 53 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

148

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 53 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

149

150

151

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 54 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

152

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 54 AND `Int5_retail_attribute`.`item_id` IS NULL LIMIT 1

153

154

155

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 55 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

156

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 55 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1

157

158

159

SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 91 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

160

161

162

SELECT `Varchar500_retail_attribute`.`id`, `Varchar500_retail_attribute`.`prototype_id`, `Varchar500_retail_attribute`.`item_id`, `Varchar500_retail_attribute`.`value`, `Varchar500_retail_attribute`.`catalogueversion_id`, `Varchar500_retail_attribute`.`created`, `Varchar500_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar500_retail_attributes` AS `Varchar500_retail_attribute` WHERE `Varchar500_retail_attribute`.`prototype_id` = 383 AND `Varchar500_retail_attribute`.`item_id` = 3942 AND `Varchar500_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar500_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

163

164

165

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` = 30 AND `Int11_retail_attribute`.`item_id` = 3942 AND `Int11_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

166

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` = 30 AND `Int11_retail_attribute`.`item_id` IS NULL LIMIT 1

167

168

169

SELECT `Varchar255_retail_attribute`.`id`, `Varchar255_retail_attribute`.`prototype_id`, `Varchar255_retail_attribute`.`item_id`, `Varchar255_retail_attribute`.`value`, `Varchar255_retail_attribute`.`catalogueversion_id`, `Varchar255_retail_attribute`.`created`, `Varchar255_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_varchar255_retail_attributes` AS `Varchar255_retail_attribute` WHERE `Varchar255_retail_attribute`.`prototype_id` = 77 AND `Varchar255_retail_attribute`.`item_id` = 3942 AND `Varchar255_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Varchar255_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

170

171

172

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 85 AND `Tinyint1_retail_attribute`.`item_id` = 3942 AND `Tinyint1_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Tinyint1_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

173

SELECT `Tinyint1_retail_attribute`.`id`, `Tinyint1_retail_attribute`.`prototype_id`, `Tinyint1_retail_attribute`.`item_id`, `Tinyint1_retail_attribute`.`value`, `Tinyint1_retail_attribute`.`catalogueversion_id`, `Tinyint1_retail_attribute`.`created`, `Tinyint1_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_tinyint1_retail_attributes` AS `Tinyint1_retail_attribute` WHERE `Tinyint1_retail_attribute`.`prototype_id` = 85 AND `Tinyint1_retail_attribute`.`item_id` IS NULL LIMIT 1

174

175

176

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 3942 AND `Int5_retail_attribute`.`catalogueversion_id` <= 1780 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

177

178

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130277 AND `Catalogueitem`.`value` NOT IN ('id', 'weight')

179

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130279 AND `Catalogueitem`.`value` = 'id' LIMIT 1

180

SELECT `Int11_retail_attribute`.`id`, `Int11_retail_attribute`.`prototype_id`, `Int11_retail_attribute`.`item_id`, `Int11_retail_attribute`.`value`, `Int11_retail_attribute`.`catalogueversion_id`, `Int11_retail_attribute`.`created`, `Int11_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int11_retail_attributes` AS `Int11_retail_attribute` WHERE `Int11_retail_attribute`.`prototype_id` IS NULL AND `Int11_retail_attribute`.`item_id` = 130281 AND `Int11_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int11_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

181

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 130279 AND `Catalogueitem`.`value` = 'weight' LIMIT 1

182

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` IS NULL AND `Int5_retail_attribute`.`item_id` = 130280 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

183

184

SELECT `Catalogueitem`.`id`, `Catalogueitem`.`parent_id`, `Catalogueitem`.`prototype_id`, `Catalogueitem`.`value`, `Catalogueitem`.`created`, `Catalogueitem`.`modified` FROM `SWPM_public`.`RETAIL_catalogueitems` AS `Catalogueitem` WHERE `Catalogueitem`.`parent_id` = 3942 AND `Catalogueitem`.`prototype_id` = 1 ORDER BY `Catalogueitem`.`value` ASC

185

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 4070 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

186

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 3192 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

187

SELECT `Int5_retail_attribute`.`id`, `Int5_retail_attribute`.`prototype_id`, `Int5_retail_attribute`.`item_id`, `Int5_retail_attribute`.`value`, `Int5_retail_attribute`.`catalogueversion_id`, `Int5_retail_attribute`.`created`, `Int5_retail_attribute`.`modified` FROM `SWPM_public`.`RETAIL_int5_retail_attributes` AS `Int5_retail_attribute` WHERE `Int5_retail_attribute`.`prototype_id` = 56 AND `Int5_retail_attribute`.`item_id` = 4795 AND `Int5_retail_attribute`.`catalogueversion_id` <= 0 ORDER BY `Int5_retail_attribute`.`catalogueversion_id` DESC LIMIT 1

188

189

190

191

192

193

194

195

196

197

198

199

200

Oh Dear...

We are very sorry, but something seems to
have fallen over. Sorry for the inconvenience.

Missing View

Stack Trace

Oh Dear...

We are very sorry, but something seems to have fallen over. Sorry for the inconvenience.

Missing View

Stack Trace

We are very sorry, but something seems to
have fallen over. Sorry for the inconvenience.