Oops, we found a bug!
ERR0DP
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 431]Code Context$this->viewPath = 'CategoryInCounty';
$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$_routeParam5 = 'ca' $url = '/abc-donuts/bakeries/claremont//ca' $expURL = array( (int) 0 => '', (int) 1 => 'abc-donuts', (int) 2 => 'bakeries', (int) 3 => 'claremont', (int) 4 => '', (int) 5 => 'ca' ) $_routeParam1Orig = 'abc-donuts' $_routeParam2Orig = 'bakeries' $_routeParam3Orig = 'claremont' $_routeParam4Orig = '' $_routeParam5Orig = 'ca' $_routeParam1 = 'abcdonuts' $_routeParam2 = 'bakeries' $_routeParam3 = 'claremont' $_routeParam4 = '' $_ipAddress = '162.158.166.252' $conn = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $conn2 = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $queryBusinesses = 'SELECT category_id, category AS category_name, category_condensed, name, name_condensed , address, city, city_condensed, county AS county_name, county_condensed, state, zip FROM bl_business_profile WHERE county_condensed='bakeries' AND state ='claremont' AND category_condensed='abcdonuts' ORDER BY city LIMIT 50' $queryTopCategories = '' $bizProf = array() $query0 = 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' $stmt0 = object(PDOStatement) { queryString => 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' } $bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 431 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 431]Code Context$this->viewPath = 'CategoryInCounty';
$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$_routeParam5 = 'ca' $url = '/abc-donuts/bakeries/claremont//ca' $expURL = array( (int) 0 => '', (int) 1 => 'abc-donuts', (int) 2 => 'bakeries', (int) 3 => 'claremont', (int) 4 => '', (int) 5 => 'ca' ) $_routeParam1Orig = 'abc-donuts' $_routeParam2Orig = 'bakeries' $_routeParam3Orig = 'claremont' $_routeParam4Orig = '' $_routeParam5Orig = 'ca' $_routeParam1 = 'abcdonuts' $_routeParam2 = 'bakeries' $_routeParam3 = 'claremont' $_routeParam4 = '' $_ipAddress = '162.158.166.252' $conn = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $conn2 = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $queryBusinesses = 'SELECT category_id, category AS category_name, category_condensed, name, name_condensed , address, city, city_condensed, county AS county_name, county_condensed, state, zip FROM bl_business_profile WHERE county_condensed='bakeries' AND state ='claremont' AND category_condensed='abcdonuts' ORDER BY city LIMIT 50' $queryTopCategories = '' $bizProf = array() $query0 = 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' $stmt0 = object(PDOStatement) { queryString => 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' } $bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 431 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 431]Code Context$this->viewPath = 'CategoryInCounty';
$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$_routeParam5 = 'ca' $url = '/abc-donuts/bakeries/claremont//ca' $expURL = array( (int) 0 => '', (int) 1 => 'abc-donuts', (int) 2 => 'bakeries', (int) 3 => 'claremont', (int) 4 => '', (int) 5 => 'ca' ) $_routeParam1Orig = 'abc-donuts' $_routeParam2Orig = 'bakeries' $_routeParam3Orig = 'claremont' $_routeParam4Orig = '' $_routeParam5Orig = 'ca' $_routeParam1 = 'abcdonuts' $_routeParam2 = 'bakeries' $_routeParam3 = 'claremont' $_routeParam4 = '' $_ipAddress = '162.158.166.252' $conn = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $conn2 = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $queryBusinesses = 'SELECT category_id, category AS category_name, category_condensed, name, name_condensed , address, city, city_condensed, county AS county_name, county_condensed, state, zip FROM bl_business_profile WHERE county_condensed='bakeries' AND state ='claremont' AND category_condensed='abcdonuts' ORDER BY city LIMIT 50' $queryTopCategories = '' $bizProf = array() $query0 = 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' $stmt0 = object(PDOStatement) { queryString => 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' } $bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 431 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 432]Code Context$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$this->set('resultsHeaderTitle', "Favorite Local ".$bizProf0[0]["category_name"]." in<br> <a href='https://www.beelocal.io/".$_routeParam2Orig."/".$_routeParam3Orig."'>".$bizProf0[0]["county_name"]."</a>" );
$_routeParam5 = 'ca' $url = '/abc-donuts/bakeries/claremont//ca' $expURL = array( (int) 0 => '', (int) 1 => 'abc-donuts', (int) 2 => 'bakeries', (int) 3 => 'claremont', (int) 4 => '', (int) 5 => 'ca' ) $_routeParam1Orig = 'abc-donuts' $_routeParam2Orig = 'bakeries' $_routeParam3Orig = 'claremont' $_routeParam4Orig = '' $_routeParam5Orig = 'ca' $_routeParam1 = 'abcdonuts' $_routeParam2 = 'bakeries' $_routeParam3 = 'claremont' $_routeParam4 = '' $_ipAddress = '162.158.166.252' $conn = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $conn2 = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $queryBusinesses = 'SELECT category_id, category AS category_name, category_condensed, name, name_condensed , address, city, city_condensed, county AS county_name, county_condensed, state, zip FROM bl_business_profile WHERE county_condensed='bakeries' AND state ='claremont' AND category_condensed='abcdonuts' ORDER BY city LIMIT 50' $queryTopCategories = '' $bizProf = array() $query0 = 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' $stmt0 = object(PDOStatement) { queryString => 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' } $bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 432 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 432]Code Context$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$this->set('resultsHeaderTitle', "Favorite Local ".$bizProf0[0]["category_name"]." in<br> <a href='https://www.beelocal.io/".$_routeParam2Orig."/".$_routeParam3Orig."'>".$bizProf0[0]["county_name"]."</a>" );
$_routeParam5 = 'ca' $url = '/abc-donuts/bakeries/claremont//ca' $expURL = array( (int) 0 => '', (int) 1 => 'abc-donuts', (int) 2 => 'bakeries', (int) 3 => 'claremont', (int) 4 => '', (int) 5 => 'ca' ) $_routeParam1Orig = 'abc-donuts' $_routeParam2Orig = 'bakeries' $_routeParam3Orig = 'claremont' $_routeParam4Orig = '' $_routeParam5Orig = 'ca' $_routeParam1 = 'abcdonuts' $_routeParam2 = 'bakeries' $_routeParam3 = 'claremont' $_routeParam4 = '' $_ipAddress = '162.158.166.252' $conn = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $conn2 = object(Mysql) { description => 'MySQL DBO Driver' startQuote => '`' endQuote => '`' fieldParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'comment' => array( [maximum depth reached] ) ) tableParameters => array( 'charset' => array( [maximum depth reached] ), 'collate' => array( [maximum depth reached] ), 'engine' => array( [maximum depth reached] ) ) columns => array( 'primary_key' => array( [maximum depth reached] ), 'string' => array( [maximum depth reached] ), 'text' => array( [maximum depth reached] ), 'biginteger' => array( [maximum depth reached] ), 'integer' => array( [maximum depth reached] ), 'float' => array( [maximum depth reached] ), 'datetime' => array( [maximum depth reached] ), 'timestamp' => array( [maximum depth reached] ), 'time' => array( [maximum depth reached] ), 'date' => array( [maximum depth reached] ), 'binary' => array( [maximum depth reached] ), 'boolean' => array( [maximum depth reached] ) ) index => array( 'PRI' => 'primary', 'MUL' => 'index', 'UNI' => 'unique' ) alias => 'AS ' cacheMethods => true useNestedTransactions => false fullDebug => true affected => (int) 0 numRows => (int) 0 took => (float) 1 configKeyName => 'default' virtualFieldSeparator => '__' connected => true config => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'prefix' => '*****', 'persistent' => false, 'datasource' => 'Database/Mysql' ) cacheSources => true map => 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] ), (int) 28 => array( [maximum depth reached] ), (int) 29 => array( [maximum depth reached] ), (int) 30 => array( [maximum depth reached] ), (int) 31 => array( [maximum depth reached] ), (int) 32 => array( [maximum depth reached] ), (int) 33 => array( [maximum depth reached] ), (int) 34 => array( [maximum depth reached] ), (int) 35 => array( [maximum depth reached] ), (int) 36 => array( [maximum depth reached] ), (int) 37 => array( [maximum depth reached] ), (int) 38 => array( [maximum depth reached] ), (int) 39 => array( [maximum depth reached] ), (int) 40 => array( [maximum depth reached] ), (int) 41 => array( [maximum depth reached] ), (int) 42 => array( [maximum depth reached] ), (int) 43 => array( [maximum depth reached] ), (int) 44 => array( [maximum depth reached] ), (int) 45 => array( [maximum depth reached] ), (int) 46 => array( [maximum depth reached] ), (int) 47 => array( [maximum depth reached] ), (int) 48 => array( [maximum depth reached] ), (int) 49 => array( [maximum depth reached] ), (int) 50 => array( [maximum depth reached] ), (int) 51 => array( [maximum depth reached] ), (int) 52 => array( [maximum depth reached] ), (int) 53 => array( [maximum depth reached] ), (int) 54 => array( [maximum depth reached] ), (int) 55 => array( [maximum depth reached] ), (int) 56 => array( [maximum depth reached] ), (int) 57 => array( [maximum depth reached] ), (int) 58 => array( [maximum depth reached] ), (int) 59 => array( [maximum depth reached] ), (int) 60 => array( [maximum depth reached] ), (int) 61 => array( [maximum depth reached] ), (int) 62 => array( [maximum depth reached] ), (int) 63 => array( [maximum depth reached] ), (int) 64 => array( [maximum depth reached] ), (int) 65 => array( [maximum depth reached] ), (int) 66 => array( [maximum depth reached] ), (int) 67 => array( [maximum depth reached] ), (int) 68 => array( [maximum depth reached] ), (int) 69 => array( [maximum depth reached] ), (int) 70 => array( [maximum depth reached] ), (int) 71 => array( [maximum depth reached] ), (int) 72 => array( [maximum depth reached] ), (int) 73 => array( [maximum depth reached] ), (int) 74 => array( [maximum depth reached] ), (int) 75 => array( [maximum depth reached] ), (int) 76 => array( [maximum depth reached] ), (int) 77 => array( [maximum depth reached] ), (int) 78 => array( [maximum depth reached] ), (int) 79 => array( [maximum depth reached] ), (int) 80 => array( [maximum depth reached] ), (int) 81 => array( [maximum depth reached] ), (int) 82 => array( [maximum depth reached] ), (int) 83 => array( [maximum depth reached] ), (int) 84 => array( [maximum depth reached] ), (int) 85 => array( [maximum depth reached] ), (int) 86 => array( [maximum depth reached] ), (int) 87 => array( [maximum depth reached] ), (int) 88 => array( [maximum depth reached] ), (int) 89 => array( [maximum depth reached] ), (int) 90 => array( [maximum depth reached] ), (int) 91 => array( [maximum depth reached] ), (int) 92 => array( [maximum depth reached] ), (int) 93 => array( [maximum depth reached] ), (int) 94 => array( [maximum depth reached] ), (int) 95 => array( [maximum depth reached] ), (int) 96 => array( [maximum depth reached] ), (int) 97 => array( [maximum depth reached] ), (int) 98 => array( [maximum depth reached] ), (int) 99 => array( [maximum depth reached] ), (int) 100 => array( [maximum depth reached] ), (int) 101 => array( [maximum depth reached] ), (int) 102 => array( [maximum depth reached] ), (int) 103 => array( [maximum depth reached] ), (int) 104 => array( [maximum depth reached] ), (int) 105 => array( [maximum depth reached] ), (int) 106 => array( [maximum depth reached] ), (int) 107 => array( [maximum depth reached] ), (int) 108 => array( [maximum depth reached] ), (int) 109 => array( [maximum depth reached] ), (int) 110 => array( [maximum depth reached] ), (int) 111 => array( [maximum depth reached] ), (int) 112 => array( [maximum depth reached] ), (int) 113 => array( [maximum depth reached] ), (int) 114 => array( [maximum depth reached] ), (int) 115 => array( [maximum depth reached] ), (int) 116 => array( [maximum depth reached] ), (int) 117 => array( [maximum depth reached] ), (int) 118 => array( [maximum depth reached] ), (int) 119 => array( [maximum depth reached] ), (int) 120 => array( [maximum depth reached] ), (int) 121 => array( [maximum depth reached] ), (int) 122 => array( [maximum depth reached] ), (int) 123 => array( [maximum depth reached] ), (int) 124 => array( [maximum depth reached] ), (int) 125 => array( [maximum depth reached] ), (int) 126 => array( [maximum depth reached] ), (int) 127 => array( [maximum depth reached] ), (int) 128 => array( [maximum depth reached] ), (int) 129 => array( [maximum depth reached] ), (int) 130 => array( [maximum depth reached] ), (int) 131 => array( [maximum depth reached] ), (int) 132 => array( [maximum depth reached] ), (int) 133 => array( [maximum depth reached] ), (int) 134 => array( [maximum depth reached] ), (int) 135 => array( [maximum depth reached] ), (int) 136 => array( [maximum depth reached] ), (int) 137 => array( [maximum depth reached] ), (int) 138 => array( [maximum depth reached] ), (int) 139 => array( [maximum depth reached] ), (int) 140 => array( [maximum depth reached] ), (int) 141 => array( [maximum depth reached] ), (int) 142 => array( [maximum depth reached] ), (int) 143 => array( [maximum depth reached] ), (int) 144 => array( [maximum depth reached] ), (int) 145 => array( [maximum depth reached] ), (int) 146 => array( [maximum depth reached] ), (int) 147 => array( [maximum depth reached] ), (int) 148 => array( [maximum depth reached] ), (int) 149 => array( [maximum depth reached] ), (int) 150 => array( [maximum depth reached] ), (int) 151 => array( [maximum depth reached] ), (int) 152 => array( [maximum depth reached] ), (int) 153 => array( [maximum depth reached] ), (int) 154 => array( [maximum depth reached] ), (int) 155 => array( [maximum depth reached] ), (int) 156 => array( [maximum depth reached] ), (int) 157 => array( [maximum depth reached] ), (int) 158 => array( [maximum depth reached] ), (int) 159 => array( [maximum depth reached] ), (int) 160 => array( [maximum depth reached] ), (int) 161 => array( [maximum depth reached] ), (int) 162 => array( [maximum depth reached] ), (int) 163 => array( [maximum depth reached] ), (int) 164 => array( [maximum depth reached] ), (int) 165 => array( [maximum depth reached] ), (int) 166 => array( [maximum depth reached] ), (int) 167 => array( [maximum depth reached] ), (int) 168 => array( [maximum depth reached] ), (int) 169 => array( [maximum depth reached] ), (int) 170 => array( [maximum depth reached] ), (int) 171 => array( [maximum depth reached] ), (int) 172 => array( [maximum depth reached] ), (int) 173 => array( [maximum depth reached] ), (int) 174 => array( [maximum depth reached] ), (int) 175 => array( [maximum depth reached] ), (int) 176 => array( [maximum depth reached] ), (int) 177 => array( [maximum depth reached] ), (int) 178 => array( [maximum depth reached] ), (int) 179 => array( [maximum depth reached] ), (int) 180 => array( [maximum depth reached] ), (int) 181 => array( [maximum depth reached] ), (int) 182 => array( [maximum depth reached] ), (int) 183 => array( [maximum depth reached] ), (int) 184 => array( [maximum depth reached] ), (int) 185 => array( [maximum depth reached] ), (int) 186 => array( [maximum depth reached] ), (int) 187 => array( [maximum depth reached] ), (int) 188 => array( [maximum depth reached] ), (int) 189 => array( [maximum depth reached] ) ) [protected] _baseConfig => array( 'password' => '*****', 'login' => '*****', 'host' => '*****', 'database' => '*****', 'port' => '*****', 'persistent' => true ) [protected] _connection => object(PDO) {} [protected] _useAlias => true [protected] _charsets => array( 'latin1_swedish_ci' => 'latin1' ) [protected] _result => object(PDOStatement) {} [protected] _queriesCnt => (int) 2 [protected] _queriesTime => (float) 9 [protected] _queriesLog => array( (int) 0 => array( [maximum depth reached] ), (int) 1 => array( [maximum depth reached] ) ) [protected] _queriesLogMax => (int) 200 [protected] _queryCache => array() [protected] _sqlOps => array( (int) 0 => 'like', (int) 1 => 'ilike', (int) 2 => 'or', (int) 3 => 'not', (int) 4 => 'in', (int) 5 => 'between', (int) 6 => 'regexp', (int) 7 => 'similar to' ) [protected] _transactionNesting => (int) 0 [protected] _queryDefaults => array( 'conditions' => array([maximum depth reached]), 'fields' => null, 'table' => null, 'alias' => null, 'order' => null, 'limit' => null, 'joins' => array([maximum depth reached]), 'group' => null, 'offset' => null ) [protected] _methodCacheChange => true [protected] _descriptions => array( 'beelocal_beelocal.bl_business_profile' => array( [maximum depth reached] ) ) [protected] _sources => array( (int) 0 => '_CACOUNTIES', (int) 1 => '_OLD_bl_business_category', (int) 2 => '_bak_blch_business', (int) 3 => '_bak_blch_business_2013_10_18', (int) 4 => '_temp', (int) 5 => 'bak_bl_business_registration', (int) 6 => 'bl_GHS_application_account_activity_per_user', (int) 7 => 'bl_TOS', (int) 8 => 'bl_admin_user', (int) 9 => 'bl_app_contact', (int) 10 => 'bl_app_event', (int) 11 => 'bl_app_event_per_user', (int) 12 => 'bl_app_localized_content', (int) 13 => 'bl_app_mobile_pushnotifications_user', (int) 14 => 'bl_app_newsletter', (int) 15 => 'bl_app_prelaunch_analytics', (int) 16 => 'bl_app_prelaunch_contact', (int) 17 => 'bl_app_pushnotification', (int) 18 => 'bl_app_ratereview', (int) 19 => 'bl_app_user', (int) 20 => 'bl_app_user_inbox', (int) 21 => 'bl_application', (int) 22 => 'bl_biz_formContactSubmittal', (int) 23 => 'bl_bus_order_per_business', (int) 24 => 'bl_business', (int) 25 => 'bl_business_aboutus_herobanner_media', (int) 26 => 'bl_business_aboutus_subview_media', (int) 27 => 'bl_business_appointment_request', (int) 28 => 'bl_business_banner', (int) 29 => 'bl_business_cart_item_per_user', (int) 30 => 'bl_business_cart_per_user', (int) 31 => 'bl_business_category', (int) 32 => 'bl_business_content', (int) 33 => 'bl_business_deal', (int) 34 => 'bl_business_deals_herobanner', (int) 35 => 'bl_business_featured_category_per_region', (int) 36 => 'bl_business_food_category', (int) 37 => 'bl_business_fooditem', (int) 38 => 'bl_business_gallery_image_comment_per_user', (int) 39 => 'bl_business_gallery_per_business', (int) 40 => 'bl_business_gallery_per_user', (int) 41 => 'bl_business_location', (int) 42 => 'bl_business_manager', (int) 43 => 'bl_business_order', (int) 44 => 'bl_business_order_item', (int) 45 => 'bl_business_per_manager', (int) 46 => 'bl_business_product', (int) 47 => 'bl_business_product_category', (int) 48 => 'bl_business_product_disliked_per_user', (int) 49 => 'bl_business_product_favorited_per_user', (int) 50 => 'bl_business_product_followed_per_user', (int) 51 => 'bl_business_product_image', (int) 52 => 'bl_business_product_liked_per_user', (int) 53 => 'bl_business_product_rating_per_user', (int) 54 => 'bl_business_product_ratingreview_per_user', (int) 55 => 'bl_business_product_subcategory', (int) 56 => 'bl_business_profile', (int) 57 => 'bl_business_profile_US_bak', (int) 58 => 'bl_business_profile_fulltext', (int) 59 => 'bl_business_promotion', (int) 60 => 'bl_business_ratingreview_per_user', (int) 61 => 'bl_business_registration', (int) 62 => 'bl_business_service', (int) 63 => 'bl_business_service_category', (int) 64 => 'bl_business_service_image', (int) 65 => 'bl_business_service_tree', (int) 66 => 'bl_business_servicegallery_per_business', (int) 67 => 'bl_business_staff', (int) 68 => 'bl_business_testimonial_per_user', (int) 69 => 'bl_city', (int) 70 => 'bl_city_original', (int) 71 => 'bl_city_zip_geo', (int) 72 => 'bl_contact', (int) 73 => 'bl_country', (int) 74 => 'bl_county', (int) 75 => 'bl_county_bak', (int) 76 => 'bl_county_ops', (int) 77 => 'bl_debug', (int) 78 => 'bl_email_outgoing_queue', (int) 79 => 'bl_email_template', (int) 80 => 'bl_favorite_businesses_per_user', (int) 81 => 'bl_image_server', (int) 82 => 'bl_item', (int) 83 => 'bl_menu', (int) 84 => 'bl_mobile_account_activity_per_user', (int) 85 => 'bl_onboarding_business_claim', (int) 86 => 'bl_onboarding_transaction_log', (int) 87 => 'bl_ops_storedproc_debug', (int) 88 => 'bl_order', (int) 89 => 'bl_order_item', (int) 90 => 'bl_payment_method', (int) 91 => 'bl_paymentmethod_per_business', (int) 92 => 'bl_paymentmethod_per_user', (int) 93 => 'bl_plan', (int) 94 => 'bl_plan_details', (int) 95 => 'bl_prelaunch_leads', (int) 96 => 'bl_qrcode_request', (int) 97 => 'bl_sql_error', (int) 98 => 'bl_state', (int) 99 => 'bl_subcategory', (int) 100 => 'bl_subcategory_media_asset', (int) 101 => 'bl_topcategories_per_city', (int) 102 => 'bl_topcategories_per_county', (int) 103 => 'bl_topcitiesincounty_per_category', (int) 104 => 'bl_user', (int) 105 => 'bl_zip_per_city', (int) 106 => 'blplat_security_authorization_bizProfileComponent_per_userRole', (int) 107 => 'blplat_security_bizProfileComponent', (int) 108 => 'blplat_security_userRole', (int) 109 => 'ops_business_staging', (int) 110 => 'ops_category_mapping', (int) 111 => 'ops_outstanding_gps_businesses', (int) 112 => 'orig_bl_email_outgoing_queue' ) [protected] _transactionStarted => false } $queryBusinesses = 'SELECT category_id, category AS category_name, category_condensed, name, name_condensed , address, city, city_condensed, county AS county_name, county_condensed, state, zip FROM bl_business_profile WHERE county_condensed='bakeries' AND state ='claremont' AND category_condensed='abcdonuts' ORDER BY city LIMIT 50' $queryTopCategories = '' $bizProf = array() $query0 = 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' $stmt0 = object(PDOStatement) { queryString => 'SELECT county_name , category_name, state FROM bl_topcategories_per_county WHERE state='claremont' and county_condensed='bakeries' and category_condensed='abcdonuts' LIMIT 1' } $bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 432 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160 [main] - APP/webroot/index.php, line 108