Whisky

InitBlock BlockName: category.products.list BlockId: BlockUiId: data-ui-id="category-products-list" InitBlockSession 81bca752a976325c40f2600a789ec077 SELECT STATEMENT: SELECT `e`.*, IF(at_ptile_date_from.value_id > 0, at_ptile_date_from.value, at_ptile_date_from_default.value) AS `ptile_date_from`, IF(at_ptile_date_to.value_id > 0, at_ptile_date_to.value, at_ptile_date_to_default.value) AS `ptile_date_to`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_ptile_categories.value_id > 0, at_ptile_categories.value, at_ptile_categories_default.value) AS `ptile_categories` FROM `blackbird_contenttype_entity` AS `e` LEFT JOIN `blackbird_contenttype` AS `contenttype` ON contenttype.ct_id = e.ct_id INNER JOIN `blackbird_contenttype_entity_datetime` AS `at_ptile_date_from_default` ON (`at_ptile_date_from_default`.`entity_id` = `e`.`entity_id`) AND (`at_ptile_date_from_default`.`attribute_id` = '287') AND `at_ptile_date_from_default`.`store_id` = 0 LEFT JOIN `blackbird_contenttype_entity_datetime` AS `at_ptile_date_from` ON (`at_ptile_date_from`.`entity_id` = `e`.`entity_id`) AND (`at_ptile_date_from`.`attribute_id` = '287') AND (`at_ptile_date_from`.`store_id` = 1) INNER JOIN `blackbird_contenttype_entity_datetime` AS `at_ptile_date_to_default` ON (`at_ptile_date_to_default`.`entity_id` = `e`.`entity_id`) AND (`at_ptile_date_to_default`.`attribute_id` = '288') AND `at_ptile_date_to_default`.`store_id` = 0 LEFT JOIN `blackbird_contenttype_entity_datetime` AS `at_ptile_date_to` ON (`at_ptile_date_to`.`entity_id` = `e`.`entity_id`) AND (`at_ptile_date_to`.`attribute_id` = '288') AND (`at_ptile_date_to`.`store_id` = 1) INNER JOIN `blackbird_contenttype_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '197') AND `at_status_default`.`store_id` = 0 LEFT JOIN `blackbird_contenttype_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '197') AND (`at_status`.`store_id` = 1) INNER JOIN `blackbird_contenttype_entity_text` AS `at_ptile_categories_default` ON (`at_ptile_categories_default`.`entity_id` = `e`.`entity_id`) AND (`at_ptile_categories_default`.`attribute_id` = '282') AND `at_ptile_categories_default`.`store_id` = 0 LEFT JOIN `blackbird_contenttype_entity_text` AS `at_ptile_categories` ON (`at_ptile_categories`.`entity_id` = `e`.`entity_id`) AND (`at_ptile_categories`.`attribute_id` = '282') AND (`at_ptile_categories`.`store_id` = 1) WHERE (contenttype.identifier IN ('ptile')) AND (IF(at_ptile_date_from.value_id > 0, at_ptile_date_from.value, at_ptile_date_from_default.value) <= '2018-04-25 12:18:56') AND (IF(at_ptile_date_to.value_id > 0, at_ptile_date_to.value, at_ptile_date_to_default.value) >= '2018-04-25 12:18:56') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (FIND_IN_SET('20', IF(at_ptile_categories.value_id > 0, at_ptile_categories.value, at_ptile_categories_default.value))) GetMapSession TileIds: Array ( [29] => Array ( [size] => 1 [id] => 29 ) [27] => Array ( [size] => 1 [id] => 27 ) [31] => Array ( [size] => 1 [id] => 31 ) [43] => Array ( [size] => 1 [id] => 43 ) [30] => Array ( [size] => 1 [id] => 30 ) [24] => Array ( [size] => 1 [id] => 24 ) [39] => Array ( [size] => 1 [id] => 39 ) [28] => Array ( [size] => 1 [id] => 28 ) [32] => Array ( [size] => 2 [id] => 32 ) ) Recalculate TileMapArray ( [29] => Array ( [size] => 1 [id] => 29 ) [27] => Array ( [size] => 1 [id] => 27 ) [31] => Array ( [size] => 1 [id] => 31 ) [43] => Array ( [size] => 1 [id] => 43 ) [30] => Array ( [size] => 1 [id] => 30 ) [24] => Array ( [size] => 1 [id] => 24 ) [39] => Array ( [size] => 1 [id] => 39 ) [28] => Array ( [size] => 1 [id] => 28 ) [32] => Array ( [size] => 2 [id] => 32 ) ) Calculate Tile Map: Array ( [4] => Array ( [size] => 1 [id] => 29 ) [6] => Array ( [size] => 1 [id] => 27 ) [13] => Array ( [size] => 1 [id] => 31 ) [16] => Array ( [size] => 1 [id] => 43 ) [20] => Array ( [size] => 1 [id] => 30 ) [27] => Array ( [size] => 1 [id] => 24 ) [34] => Array ( [size] => 1 [id] => 39 ) [35] => Array ( [size] => 1 [id] => 28 ) [40] => Array ( [size] => 2 [id] => 32 ) ) CurrentPage: 1 PageSize: 20 ProductCount: 20, 20 BlockSession: InitialDisplayIndex: 0 InitialTileOffset: 0 ShowPager: false IndexStart: 0 ShowTiles: true AddTile to colleciton: 29 AddTile to colleciton: 27 AddTile to colleciton: 31 AddTile to colleciton: 43 AddTile to colleciton: 30 CloseBlockSession 81bca752a976325c40f2600a789ec077 BlockSessionData: Array ( [tile_map] => Array ( [4] => Array ( [size] => 1 [id] => 29 ) [6] => Array ( [size] => 1 [id] => 27 ) [13] => Array ( [size] => 1 [id] => 31 ) [16] => Array ( [size] => 1 [id] => 43 ) [20] => Array ( [size] => 1 [id] => 30 ) [27] => Array ( [size] => 1 [id] => 24 ) [34] => Array ( [size] => 1 [id] => 39 ) [35] => Array ( [size] => 1 [id] => 28 ) [40] => Array ( [size] => 2 [id] => 32 ) ) [page_1] => Array ( [tileOffset] => 5 [itemCount] => 20 ) )