## in view i have called print_r($this->paginator)and get this
Zend_Paginator Object
(
    [_adapter:protected] => Zend_Paginator_Adapter_DbSelect Object
        (
            [_select:protected] => Zend_Db_Select Object
                (
                    [_adapter:protected] => Zend_Db_Adapter_Pdo_Mysql Object
                        (
                            [_pdoType:protected] => mysql
                            [_numericDataTypes:protected] => Array
                                (
                                    [0] => 0
                                    [1] => 1
                                    [2] => 2
                                    [INT] => 0
                                    [INTEGER] => 0
                                    [MEDIUMINT] => 0
                                    [SMALLINT] => 0
                                    [TINYINT] => 0
                                    [BIGINT] => 1
                                    [SERIAL] => 1
                                    [DEC] => 2
                                    [DECIMAL] => 2
                                    [DOUBLE] => 2
                                    [DOUBLE PRECISION] => 2
                                    [FIXED] => 2
                                    [FLOAT] => 2
                                )

                            [_defaultStmtClass:protected] => Zend_Db_Statement_Pdo
                            [_config:protected] => Array
                                (
                                    [host] => arslan-ali
                                    [username] => root
                                    [password] =>
                                    [dbname] => wlm
                                    [options] => Array
                                        (
                                            [caseFolding] => 0
                                            [autoQuoteIdentifiers] => 1
                                        )

                                    [driver_options] => Array
                                        (
                                        )

                                )

                            [_fetchMode:protected] => 2
                            [_profiler:protected] => Zend_Db_Profiler Object
                                (
                                    [_queryProfiles:protected] => Array
                                        (
                                            [0] => Zend_Db_Profiler_Query Object
                                                (
                                                    [_query:protected] => DESCRIBE `products`
                                                    [_queryType:protected] => 2
                                                    [_startedMicrotime:protected] => 1242655452.92
                                                    [_endedMicrotime:protected] => 1242655452.93
                                                    [_boundParams:protected] => Array
                                                        (
                                                        )

                                                )

                                            [1] => Zend_Db_Profiler_Query Object
                                                (
                                                    [_query:protected] => SELECT COUNT(*) AS `num` FROM `products` LIMIT 1
                                                    [_queryType:protected] => 32
                                                    [_startedMicrotime:protected] => 1242655452.93
                                                    [_endedMicrotime:protected] => 1242655452.93
                                                    [_boundParams:protected] => Array
                                                        (
                                                        )

                                                )

                                            [2] => Zend_Db_Profiler_Query Object
                                                (
                                                    [_query:protected] => SELECT COUNT(*) AS `zend_paginator_row_count` FROM `products`
 INNER JOIN `product_categories` ON products.product_cat_id = product_categories.id
                                                    [_queryType:protected] => 32
                                                    [_startedMicrotime:protected] => 1242655452.99
                                                    [_endedMicrotime:protected] => 1242655453.01
                                                    [_boundParams:protected] => Array
                                                        (
                                                        )

                                                )

                                            [3] => Zend_Db_Profiler_Query Object
                                                (
                                                    [_query:protected] => DESCRIBE `product_status`
                                                    [_queryType:protected] => 2
                                                    [_startedMicrotime:protected] => 1242655453.02
                                                    [_endedMicrotime:protected] => 1242655453.02
                                                    [_boundParams:protected] => Array
                                                        (
                                                        )

                                                )

                                            [4] => Zend_Db_Profiler_Query Object
                                                (
                                                    [_query:protected] => SELECT `product_status`.* FROM `product_status`
                                                    [_queryType:protected] => 32
                                                    [_startedMicrotime:protected] => 1242655453.02
                                                    [_endedMicrotime:protected] => 1242655453.04
                                                    [_boundParams:protected] => Array
                                                        (
                                                        )

                                                )

                                        )

                                    [_enabled:protected] => 1
                                    [_filterElapsedSecs:protected] =>
                                    [_filterTypes:protected] =>
                                )

                            [_defaultProfilerClass:protected] => Zend_Db_Profiler
                            [_connection:protected] => PDO Object
                                (
                                )

                            [_caseFolding:protected] => 0
                            [_autoQuoteIdentifiers:protected] => 1
                        )

                    [_parts:protected] => Array
                        (
                            [distinct] =>
                            [columns] => Array
                                (
                                    [0] => Array
                                        (
                                            [0] => products
                                            [1] => *
                                            [2] =>
                                        )

                                    [1] => Array
                                        (
                                            [0] => product_categories
                                            [1] => *
                                            [2] =>
                                        )

                                )

                            [union] => Array
                                (
                                )

                            [from] => Array
                                (
                                    [products] => Array
                                        (
                                            [joinType] => inner join
                                            [schema] =>
                                            [tableName] => products
                                            [joinCondition] =>
                                        )

                                    [product_categories] => Array
                                        (
                                            [joinType] => inner join
                                            [schema] =>
                                            [tableName] => product_categories
                                            [joinCondition] => products.product_cat_id = product_categories.id
                                        )

                                )

                            [where] => Array
                                (
                                )

                            [group] => Array
                                (
                                )

                            [having] => Array
                                (
                                )

                            [order] => Array
                                (
                                    [0] => Array
                                        (
                                            [0] => products.id
                                            [1] => DESC
                                        )

                                )

                            [limitcount] =>
                            [limitoffset] =>
                            [forupdate] =>
                        )

                    [_tableCols:protected] => Array
                        (
                        )

                )

            [_rowCount:protected] => 4884
        )

    [_currentItemCount:protected] =>
    [_currentItems:protected] =>
    [_currentPageNumber:protected] => 0
    [_itemCountPerPage:protected] => 10
    [_pageCount:protected] => 489
    [_pageItems:protected] => Array
        (
        )

    [_pageRange:protected] => 5
    [_pages:protected] =>
    [_view:protected] =>
)