WA_MySQLi_RS Object ( [Connection] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 31 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.6.51-log [server_version] => 50651 [stat] => Uptime: 252740 Threads: 51 Questions: 737796184 Slow queries: 1409 Opens: 14621 Flush tables: 1 Open tables: 3864 Queries per second avg: 2919.190 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 6828052 [warning_count] => 0 ) [CurrentPage] => /index.php [CrossSiteProtect] => 1 [Debug] => [EncryptionAlgorithm] => blowfish [EncryptionKey] => Change Me [EncryptionMode] => cbc [FilterValues] => Array ( ) [Index] => 0 [LastRow] => 1 [MaxRows] => 1 [Name] => rsURLPath [NextPage] => 0 [PageNum] => 0 [ParamTypes] => Array ( [0] => s [1] => s [2] => s ) [ParamValues] => Array ( [0] => air-conditioners [1] => air-conditioners [2] => less-than-5600-btu-air-conditioner ) [ParamDefaults] => Array ( [0] => [1] => [2] => ) [Prepared] => 1 [PrevPage] => 0 [QueryString] => &totalRows_rsURLPath=1&&view=list [Results] => Array ( [0] => Array ( [cDescription] => Less Than 5,600 Btu Air Conditioner [cSlug] => less-than-5600-btu-air-conditioner [mhDescription] => Air Conditioners [mhSlug] => air-conditioners [cgDescription] => Air Conditioners [cgSlug] => air-conditioners ) ) [StartLimit] => 0 [StartRow] => 1 [Statement] => SELECT c.ConsumerDescription AS cDescription, c.slug AS cSlug, IF(mh.description='Washers/Dryers','Laundry',IF(mh.description='Grills','Outdoor',IF(mh.description='packages','Packages',IF(mh.description='Refrigeration','Refrigerators',mh.description)))) AS mhDescription, mh.slug AS mhSlug, REPLACE(cg.Description, 'Mattresses ', '') AS cgDescription, cg.slug AS cgSlug FROM Categories AS c INNER JOIN Category_Groups AS cg ON (c.Category_Group=cg.CategoryCode) INNER JOIN menu_heading AS mh ON (cg.MenuHeading = mh.id) WHERE ((`mh`.`slug` = ?) and (`cg`.`slug` = ?) and (`c`.`slug` = ?)) [Table] => [TotalPages] => 0 [TotalRows] => 1 )