Array
(
[0] => Array
(
[id] => 82731
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => g-j-painting-2
[name] => G & J Painting
[zip] => 97330
[address] => Corvallis
[phone] => +1 541-929-7739
[website] => gandjpainting.com
[hours] => a:6:{i:1;a:1:{i:0;s:11:"07:30-18:00";}i:2;a:1:{i:0;s:11:"07:30-18:00";}i:3;a:1:{i:0;s:11:"07:30-18:00";}i:4;a:1:{i:0;s:11:"07:30-18:00";}i:5;a:1:{i:0;s:11:"07:30-18:00";}i:6;a:1:{i:0;s:11:"07:30-18:00";}}
[utc_offset] => -420
[lat] => 44.5645659
[lng] => -123.2620435
[near_items] => a:6:{i:0;i:8673;i:1;i:74393;i:2;i:74439;i:3;i:82724;i:4;i:51261;i:5;i:82260;}
[count_views] => 19
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[1] => Array
(
[id] => 82732
[region_id] => 70
[locality_id] => 33704
[price_level] => 0
[url] => shango-premium-cannabis
[name] => Shango Premium Cannabis
[zip] => 97038
[address] => 109 West Main Street
[phone] => +1 503-829-7717
[website] => goshango.com
[hours] => a:7:{i:0;a:1:{i:0;s:11:"10:00-18:00";}i:1;a:1:{i:0;s:11:"10:00-20:00";}i:2;a:1:{i:0;s:11:"10:00-20:00";}i:3;a:1:{i:0;s:11:"10:00-20:00";}i:4;a:1:{i:0;s:11:"10:00-20:00";}i:5;a:1:{i:0;s:11:"10:00-21:00";}i:6;a:1:{i:0;s:11:"10:00-21:00";}}
[utc_offset] => -420
[lat] => 45.1477987
[lng] => -122.5775209
[near_items] => a:6:{i:0;i:62211;i:1;i:68651;i:2;i:82459;i:3;i:40473;i:4;i:72437;i:5;i:72473;}
[count_views] => 11
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[2] => Array
(
[id] => 82733
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => jiffy-fix
[name] => Jiffy Fix
[zip] => 97333
[address] => 275 Southwest Avery Avenue Space B
[phone] => +1 541-757-9611
[website] => facebook.com
[hours] => a:5:{i:1;a:1:{i:0;s:11:"08:30-17:00";}i:2;a:1:{i:0;s:11:"08:30-17:00";}i:3;a:1:{i:0;s:11:"08:30-17:00";}i:4;a:1:{i:0;s:11:"08:30-17:00";}i:5;a:1:{i:0;s:11:"08:30-17:00";}}
[utc_offset] => -420
[lat] => 44.5523261
[lng] => -123.2675206
[near_items] => a:6:{i:0;i:77433;i:1;i:77548;i:2;i:82249;i:3;i:79386;i:4;i:68162;i:5;i:68165;}
[count_views] => 26
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[3] => Array
(
[id] => 82734
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => linn-benton-excavation-inc
[name] => Linn Benton Excavation Inc
[zip] => 97333
[address] => 33810 Southeast Terra Circle
[phone] => +1 541-758-6309
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 44.5600140
[lng] => -123.2204330
[near_items] => a:6:{i:0;i:130806;i:1;i:25628;i:2;i:25483;i:3;i:130665;i:4;i:74454;i:5;i:26168;}
[count_views] => 18
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[4] => Array
(
[id] => 82735
[region_id] => 70
[locality_id] => 33704
[price_level] => 0
[url] => avison-lumber-co
[name] => Avison Lumber Co
[zip] => 97038
[address] => 410 East 5th Street
[phone] => +1 503-829-9330
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 45.1429053
[lng] => -122.5747496
[near_items] => a:6:{i:0;i:82668;i:1;i:28862;i:2;i:28806;i:3;i:82422;i:4;i:14640;i:5;i:28863;}
[count_views] => 28
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[5] => Array
(
[id] => 82736
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => serrano-grill
[name] => Serrano Grill
[zip] => 97331
[address] => 351 Southwest 30th Street
[phone] => +1 541-737-4771
[website] => uhds.oregonstate.edu
[hours] => a:7:{i:0;a:1:{i:0;s:11:"12:00-20:00";}i:1;a:1:{i:0;s:11:"11:00-20:00";}i:2;a:1:{i:0;s:11:"11:00-20:00";}i:3;a:1:{i:0;s:11:"11:00-14:30";}i:4;a:1:{i:0;s:11:"11:00-14:30";}i:5;a:1:{i:0;s:11:"11:00-20:00";}i:6;a:1:{i:0;s:11:"12:00-20:00";}}
[utc_offset] => -420
[lat] => 44.5639511
[lng] => -123.2832108
[near_items] => a:6:{i:0;i:74372;i:1;i:74379;i:2;i:74390;i:3;i:25131;i:4;i:82835;i:5;i:51283;}
[count_views] => 42
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[6] => Array
(
[id] => 82737
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => memorial-union-quad
[name] => Memorial Union Quad
[zip] => 97331
[address] => 2501 Southwest Jefferson Way
[phone] => +1 541-737-2416
[website] =>
[hours] => a:7:{i:0;a:1:{i:0;s:11:"00:00-23:59";}i:1;a:1:{i:0;s:11:"00:00-23:59";}i:2;a:1:{i:0;s:11:"00:00-23:59";}i:3;a:1:{i:0;s:11:"00:00-23:59";}i:4;a:1:{i:0;s:11:"00:00-23:59";}i:5;a:1:{i:0;s:11:"00:00-23:59";}i:6;a:1:{i:0;s:11:"00:00-23:59";}}
[utc_offset] => -420
[lat] => 44.5649238
[lng] => -123.2789169
[near_items] => a:6:{i:0;i:104415;i:1;i:104397;i:2;i:104485;i:3;i:64652;i:4;i:82304;i:5;i:82572;}
[count_views] => 22
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[7] => Array
(
[id] => 82738
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => red-stem-landscp-maintenance-design
[name] => Red Stem Landscp Maintenance Design
[zip] => 97339
[address] => Corvallis
[phone] => +1 541-207-5614
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 44.5619717
[lng] => -123.2608573
[near_items] => a:6:{i:0;i:82210;i:1;i:56269;i:2;i:82235;i:3;i:82623;i:4;i:51358;i:5;i:64655;}
[count_views] => 7
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[8] => Array
(
[id] => 82739
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => la-fuente-2-2
[name] => La Fuente 2
[zip] => 97333
[address] => 1750 Southwest 3rd Street # A
[phone] => +1 541-738-6520
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 44.5483671
[lng] => -123.2661129
[near_items] => a:6:{i:0;i:82469;i:1;i:82669;i:2;i:104424;i:3;i:82878;i:4;i:58595;i:5;i:58580;}
[count_views] => 16
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[9] => Array
(
[id] => 82740
[region_id] => 70
[locality_id] => 33535
[price_level] => 2
[url] => beaver-hut-dam-growlers
[name] => The Beaver Hut Dam Growlers
[zip] => 97330
[address] => 1603 Northwest Monroe Avenue
[phone] => +1 541-752-2328
[website] =>
[hours] => a:5:{i:0;a:1:{i:0;s:11:"09:00-21:00";}i:1;a:1:{i:0;s:11:"08:00-21:00";}i:2;a:1:{i:0;s:11:"08:00-21:00";}i:3;a:1:{i:0;s:11:"08:00-21:00";}i:4;a:1:{i:0;s:11:"08:00-21:00";}}
[utc_offset] => -420
[lat] => 44.5680166
[lng] => -123.2741466
[near_items] => a:6:{i:0;i:25094;i:1;i:40106;i:2;i:104517;i:3;i:82938;i:4;i:40146;i:5;i:40124;}
[count_views] => 16
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[10] => Array
(
[id] => 82741
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => guempel-chris
[name] => Guempel Chris
[zip] => 97330
[address] => 2314 Northwest Kings Boulevard # B
[phone] => +1 541-758-2235
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 44.5896555
[lng] => -123.2774113
[near_items] => a:6:{i:0;i:82331;i:1;i:82335;i:2;i:82351;i:3;i:82420;i:4;i:70090;i:5;i:82674;}
[count_views] => 17
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
[11] => Array
(
[id] => 82742
[region_id] => 70
[locality_id] => 33535
[price_level] => 0
[url] => edward-l-worthington-pharm
[name] => Edward L. Worthington, PHARM
[zip] => 97330
[address] => 530 Northwest 27th Street
[phone] => +1 541-752-4636
[website] =>
[hours] =>
[utc_offset] => -420
[lat] => 44.5732713
[lng] => -123.2815160
[near_items] => a:6:{i:0;i:64603;i:1;i:64608;i:2;i:64625;i:3;i:64596;i:4;i:104520;i:5;i:82898;}
[count_views] => 20
[count_reviews] => 0
[reviews_mark] => 0
[description] =>
[website_title] =>
[website_keywords] =>
[website_description] =>
[website_og_img] =>
[max_id] => 82730.8059546983
)
)
1 | SELECT * FROM `item` WHERE url = 'delozier-accounting-inc' LIMIT 1 |
0 | SELECT * FROM `region` WHERE id IN ('70') LIMIT 1 |
0 | SELECT * FROM `locality` WHERE id IN ('33627') LIMIT 1 |
1 | SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('118368') |
0 | SELECT * FROM `category` WHERE id IN ('189','207') LIMIT 2 |
0 | SELECT * FROM `locality` WHERE url = 'hillsboro-or' LIMIT 1 |
0 | SELECT * FROM `region` WHERE id = 70 LIMIT 1 |
0 | SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 118368 AND `date` < '2024-05-09 09:07:06' ORDER BY `date` DESC |
0 | SELECT * FROM `photos` WHERE `item_id` IN ('118368') |
2 | SELECT * FROM `item` WHERE id IN ('34470','118512','118655','118338','43970','59585') LIMIT 6 |
0 | SELECT * FROM `region` WHERE id IN ('70') LIMIT 1 |
0 | SELECT * FROM `locality` WHERE id IN ('33627') LIMIT 1 |
0 | SELECT * FROM `photos` WHERE `item_id` IN ('34470','43970','59585','118338','118512','118655') |
0 | SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('34470','43970','59585','118338','118512','118655') |
0 | SELECT * FROM `category` WHERE id IN ('189','193','213','207','218','191','194') LIMIT 7 |
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' |
3 | SELECT * FROM `photos` LIMIT 1665, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
0 | SELECT * FROM `photos` LIMIT 687, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 2002, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 2636, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 3287, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 3055, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 3358, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
2 | SELECT * FROM `photos` LIMIT 4104, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
0 | SELECT * FROM `photos` LIMIT 543, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
0 | SELECT * FROM `photos` LIMIT 587, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 920, 1 |
0 | SELECT * FROM counts where updated="2024-05-09" and table_name like 'photos' |
1 | SELECT * FROM `photos` LIMIT 1047, 1 |
3 | 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 ('51081','94581','49711','107814','2742','140825','134246','19652','14080','19138','99344','100015') |
0 | SELECT * FROM `region` WHERE id IN ('70') LIMIT 1 |
0 | SELECT * FROM `locality` WHERE id IN ('33779','33499','33510','33876','33691','33646','33523','33576','33757','33785') LIMIT 10 |
0 | SELECT * FROM `photos` WHERE `item_id` IN ('2742','14080','19138','19652','49711','51081','94581','99344','100015','107814','134246','140825') |
0 | SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('2742','14080','19138','19652','49711','51081','94581','99344','100015','107814','134246','140825') |
0 | SELECT * FROM `category` WHERE id IN ('189','213','191','217','197','219','208','212','240','209','239','261','266','235','236') LIMIT 15 |
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' |
0 | 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' |