Array
(
[0] => Array
(
[id] => 75376
[region_id] => 70
[locality_id] => 33701
[price_level] => 0
[url] => unified-grocers-inc-4
[name] => Unified Grocers Inc
[zip] => 97222
[address] => 6433 Southeast Lake Road
[phone] => +1 503-833-1000
[website] => unifiedgrocers.com
[hours] =>
[utc_offset] => -420
[lat] => 45.4284777
[lng] => -122.5945073
[near_items] => a:6:{i:0;i:9256;i:1;i:73025;i:2;i:96063;i:3;i:123349;i:4;i:123290;i:5;i:95977;}
[count_views] => 132
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[1] => Array
(
[id] => 75377
[region_id] => 70
[locality_id] => 33615
[price_level] => 3
[url] => taco-time-52
[name] => Taco Time
[zip] => 97086
[address] => 12000 Southeast 82nd Avenue #2093
[phone] => +1 503-653-2250
[website] => tacotime.com
[hours] =>
[utc_offset] => -420
[lat] => 45.4363974
[lng] => -122.5740467
[near_items] => a:6:{i:0;i:96629;i:1;i:96814;i:2;i:53557;i:3;i:9274;i:4;i:94566;i:5;i:110480;}
[count_views] => 17
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[2] => Array
(
[id] => 75378
[region_id] => 70
[locality_id] => 33627
[price_level] => 3
[url] => hot-pot-n-sushi
[name] => Hot Pot 'N Sushi
[zip] => 97124
[address] => 7212 Northeast Cornell Road
[phone] => +1 503-640-0900
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 45.5381321
[lng] => -122.9042687
[near_items] => a:6:{i:0;i:32177;i:1;i:105551;i:2;i:107395;i:3;i:75413;i:4;i:54548;i:5;i:75371;}
[count_views] => 13
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[3] => Array
(
[id] => 75379
[region_id] => 70
[locality_id] => 33757
[price_level] => 2
[url] => papa-murphys-take-n-bake-pizza-325
[name] => Papa Murphy's Take 'N' Bake Pizza
[zip] => 97219
[address] => 4350 Southwest Multnomah Boulevard
[phone] => +1 503-244-6423
[website] => papamurphys.com
[hours] =>
[utc_offset] => -420
[lat] => 45.4671781
[lng] => -122.7224679
[near_items] => a:6:{i:0;i:114529;i:1;i:114319;i:2;i:114939;i:3;i:133318;i:4;i:141823;i:5;i:114597;}
[count_views] => 102
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[4] => Array
(
[id] => 75380
[region_id] => 70
[locality_id] => 33523
[price_level] => 3
[url] => wan-lung-restaurant
[name] => Wan Lung Restaurant
[zip] => 97015
[address] => 12062 Southeast Sunnyside Road
[phone] => +1 503-698-8210
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 45.4279555
[lng] => -122.5387597
[near_items] => a:6:{i:0;i:39693;i:1;i:73024;i:2;i:96485;i:3;i:140394;i:4;i:30310;i:5;i:52947;}
[count_views] => 28
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[5] => Array
(
[id] => 75381
[region_id] => 70
[locality_id] => 33701
[price_level] => 0
[url] => mocha-express-5
[name] => Mocha Express
[zip] => 97267
[address] => 14813 Southeast Webster Road
[phone] => +1 503-654-5177
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 45.4153579
[lng] => -122.5931587
[near_items] => a:6:{i:0;i:72984;i:1;i:95284;i:2;i:95363;i:3;i:60114;i:4;i:123100;i:5;i:94688;}
[count_views] => 29
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[6] => Array
(
[id] => 75382
[region_id] => 70
[locality_id] => 33611
[price_level] => 3
[url] => safeway-240
[name] => Safeway
[zip] => 97030
[address] => 1455 Northeast Division Street
[phone] => +1 503-492-7270
[website] => local.safeway.com
[hours] =>
[utc_offset] => -420
[lat] => 45.5059124
[lng] => -122.4169555
[near_items] => a:6:{i:0;i:37894;i:1;i:60217;i:2;i:111214;i:3;i:109403;i:4;i:60210;i:5;i:108719;}
[count_views] => 46
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[7] => Array
(
[id] => 75383
[region_id] => 70
[locality_id] => 33523
[price_level] => 2
[url] => menchies-frozen-yogurt-192
[name] => Menchie's Frozen Yogurt
[zip] => 97015
[address] => 8950 Southeast Sunnyside Road
[phone] => +1 503-654-1188
[website] => menchies.com
[hours] =>
[utc_offset] => -420
[lat] => 45.4309502
[lng] => -122.5717013
[near_items] => a:6:{i:0;i:110649;i:1;i:96758;i:2;i:138065;i:3;i:39476;i:4;i:39486;i:5;i:30928;}
[count_views] => 87
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[8] => Array
(
[id] => 75384
[region_id] => 70
[locality_id] => 33523
[price_level] => 2
[url] => wendys-1643
[name] => Wendy's
[zip] => 97015
[address] => 16220 Southeast 82nd Drive
[phone] => +1 503-657-4368
[website] => locations.wendys.com
[hours] =>
[utc_offset] => -420
[lat] => 45.4052264
[lng] => -122.5684112
[near_items] => a:6:{i:0;i:94681;i:1;i:96889;i:2;i:137646;i:3;i:94967;i:4;i:52974;i:5;i:110614;}
[count_views] => 29
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[9] => Array
(
[id] => 75385
[region_id] => 70
[locality_id] => 33757
[price_level] => 3
[url] => starbucks-5579
[name] => Starbucks
[zip] => 97086
[address] => 12000 SE 82nd Avenue, Space #H125 (For Mailing purposes #1148)
[phone] => +1 503-659-0953
[website] => starbucks.com
[hours] =>
[utc_offset] => -420
[lat] => 45.4355836
[lng] => -122.5722429
[near_items] => a:6:{i:0;i:52491;i:1;i:75383;i:2;i:52345;i:3;i:75867;i:4;i:94566;i:5;i:9191;}
[count_views] => 9
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[10] => Array
(
[id] => 75386
[region_id] => 70
[locality_id] => 33523
[price_level] => 0
[url] => kleenair-products-co
[name] => Kleenair Products Co
[zip] => 97015
[address] => 14230 Southeast 98th Court
[phone] => +1 503-653-6925
[website] => kleenairusa.com
[hours] =>
[utc_offset] => -420
[lat] => 45.4200275
[lng] => -122.5609921
[near_items] => a:6:{i:0;i:96649;i:1;i:30303;i:2;i:95783;i:3;i:52597;i:4;i:95466;i:5;i:95640;}
[count_views] => 10
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
[11] => Array
(
[id] => 75387
[region_id] => 70
[locality_id] => 33827
[price_level] => 0
[url] => thompson-orchards
[name] => Thompson Orchards
[zip] => 97058
[address] => 3200-, 3284 Doane Road
[phone] =>
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 45.5679023
[lng] => -121.1557576
[near_items] => a:6:{i:0;i:76199;i:1;i:76200;i:2;i:34266;i:3;i:80132;i:4;i:36164;i:5;i:15051;}
[count_views] => 14
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 75375.961849316
)
)
1 | SELECT * FROM `item` WHERE url = 'ponderosa-pines-lodge' LIMIT 1 |
0 | SELECT * FROM `region` WHERE id IN ('70') LIMIT 1 |
0 | SELECT * FROM `locality` WHERE id IN ('33818') LIMIT 1 |
0 | SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('22608') |
0 | SELECT * FROM `category` WHERE id IN ('189','214','215','216') LIMIT 4 |
1 | SELECT * FROM `locality` WHERE url = 'sunriver-or' LIMIT 1 |
1 | SELECT * FROM `region` WHERE id = 70 LIMIT 1 |
1 | SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 22608 AND `date` < '2024-05-09 09:07:14' ORDER BY `date` DESC |
0 | SELECT * FROM `photos` WHERE `item_id` IN ('22608') |
1 | SELECT * FROM `item` WHERE id IN ('23142','120732','21917','103321','22612','103287') LIMIT 6 |
0 | SELECT * FROM `region` WHERE id IN ('70') LIMIT 1 |
0 | SELECT * FROM `locality` WHERE id IN ('33818') LIMIT 1 |
0 | SELECT * FROM `photos` WHERE `item_id` IN ('21917','22612','23142','103287','103321','120732') |
0 | SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('21917','22612','23142','103287','103321','120732') |
0 | SELECT * FROM `category` WHERE id IN ('189','214','215','216') LIMIT 4 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'news' |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'news' |
0 | SELECT * FROM `category` ORDER BY name |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 1134, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
0 | SELECT * FROM `photos` LIMIT 134, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 1094, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 1729, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 1621, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
2 | SELECT * FROM `photos` LIMIT 4035, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 3228, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 2973, 1 |
1 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
2 | SELECT * FROM `photos` LIMIT 2995, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
2 | SELECT * FROM `photos` LIMIT 3619, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 161, 1 |
1 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 2831, 1 |
2 | SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m
WHERE f.id >= m.max_id
ORDER BY f.id ASC
LIMIT 12 |
2 | SELECT * FROM `item` WHERE `id` IN ('58384','69616','42497','49362','75541','12352','46739','115577','141592','25497','71999','91969') |
0 | SELECT * FROM `region` WHERE id IN ('70') LIMIT 1 |
0 | SELECT * FROM `locality` WHERE id IN ('33858','33799','33576','33768','33657','33473','33475','33629','33757') LIMIT 9 |
1 | SELECT * FROM `photos` WHERE `item_id` IN ('12352','25497','42497','46739','49362','58384','69616','71999','75541','91969','115577','141592') |
1 | SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('12352','25497','42497','46739','49362','58384','69616','71999','75541','91969','115577','141592') |
0 | SELECT * FROM `category` WHERE id IN ('189','219','206','207','243','208','259','213','203','204','226','246','236') LIMIT 13 |
0 | SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m
WHERE f.id >= m.max_id
ORDER BY f.id ASC
LIMIT 16 |
0 | SELECT * FROM `region` WHERE id IN ('70') LIMIT 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'locality' |
2 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'item' |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'reviews' |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |