Array
(
[0] => Array
(
[api_query] => http://api.salecamel.com?api_key=123456789&do_get=local_locations
[execution_time] => 0.13159584999084
[from_api] => Array
(
[0] => Array
(
[mysql_query] => SELECT DISTINCT merch_region, merch_locality, merch_country, merch_id FROM merchants_local ORDER BY merch_region, merch_locality
[execution_time] => 0.048824071884155
)
)
)
[1] => Array
(
[api_query] => http://api.salecamel.com?api_key=123456789&do_get=get_local&location=East%2C+Norwich%2C+NY&radius=10&search_limit=15
[execution_time] => 8.6881849765778
[from_api] => Array
(
[0] => Array
(
[mysql_query] => SELECT merch_latitude, merch_longitude
FROM merchants_local
WHERE merch_locality='East' AND merch_region='Norwich'
[execution_time] => 0.0056369304656982
)
[1] => Array
(
[news_api_call] => http://hyperlocal-api.outside.in/v1.1/states/NY/cities/East%20Norwich/stories?dev_key=6at3bn2z23e33eu92utrq6pt&sig=531798952238ae58e2db914ad11df5de&no-vertical=obituaries
)
[2] => Array
(
[mysql_query] => SELECT data FROM cache_news
WHERE locality = 'East Norwich'
AND region = 'NY'
AND country = 'United States'
AND expires > '1369263744'
[execution_time] => 0.00030398368835449
)
[3] => Array
(
[mysql_query] => INSERT INTO cache_news
(`locality`, `region`, `country`, `expires`, `data`)
VALUES
(
'East Norwich',
'NY',
'United States',
'1369267344',
'DNS Made Easy: Your DNS has expired![\"DNS](\"dnsmelogo.png\")
DNS service for this domain has expired with DNS Made Easy
'
)
ON DUPLICATE KEY UPDATE expires = '1369267344', data = 'DNS Made Easy: Your DNS has expiredDNS service for this domain has expired with DNS Made Easy
'
[execution_time] => 0.046130180358887
)
[4] => Array
(
[mysql_query] => SELECT data FROM cache_weather
WHERE locality = 'East Norwich'
AND region = 'NY'
AND country = 'United States'
AND expires > '1369263744'
[execution_time] => 0.00038504600524902
)
[5] => Array
(
[mysql_query] => INSERT INTO cache_weather
(`locality`, `region`, `country`, `expires`, `data`)
VALUES
(
'East Norwich',
'NY',
'United States',
'1369267344',
'{ \"data\": { \"current_condition\": [ {\"cloudcover\": \"75\", \"humidity\": \"65\", \"observation_time\": \"11:02 PM\", \"precipMM\": \"0.0\", \"pressure\": \"1011\", \"temp_C\": \"26\", \"temp_F\": \"79\", \"visibility\": \"13\", \"weatherCode\": \"116\", \"weatherDesc\": [ {\"value\": \"Partly Cloudy\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0002_sunny_intervals.png\" } ], \"winddir16Point\": \"SSW\", \"winddirDegree\": \"210\", \"windspeedKmph\": \"0\", \"windspeedMiles\": \"0\" } ], \"request\": [ {\"query\": \"East Norwich, United States Of America\", \"type\": \"City\" } ], \"weather\": [ {\"date\": \"2013-05-22\", \"precipMM\": \"0.0\", \"tempMaxC\": \"23\", \"tempMaxF\": \"74\", \"tempMinC\": \"19\", \"tempMinF\": \"67\", \"weatherCode\": \"122\", \"weatherDesc\": [ {\"value\": \"Overcast\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0004_black_low_cloud.png\" } ], \"winddir16Point\": \"SSW\", \"winddirDegree\": \"200\", \"winddirection\": \"SSW\", \"windspeedKmph\": \"17\", \"windspeedMiles\": \"10\" }, {\"date\": \"2013-05-23\", \"precipMM\": \"0.7\", \"tempMaxC\": \"22\", \"tempMaxF\": \"72\", \"tempMinC\": \"17\", \"tempMinF\": \"63\", \"weatherCode\": \"143\", \"weatherDesc\": [ {\"value\": \"Mist\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0006_mist.png\" } ], \"winddir16Point\": \"S\", \"winddirDegree\": \"180\", \"winddirection\": \"S\", \"windspeedKmph\": \"15\", \"windspeedMiles\": \"9\" }, {\"date\": \"2013-05-24\", \"precipMM\": \"10.1\", \"tempMaxC\": \"20\", \"tempMaxF\": \"68\", \"tempMinC\": \"13\", \"tempMinF\": \"55\", \"weatherCode\": \"302\", \"weatherDesc\": [ {\"value\": \"Moderate rain\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0018_cloudy_with_heavy_rain.png\" } ], \"winddir16Point\": \"NNW\", \"winddirDegree\": \"340\", \"winddirection\": \"NNW\", \"windspeedKmph\": \"25\", \"windspeedMiles\": \"16\" }, {\"date\": \"2013-05-25\", \"precipMM\": \"4.3\", \"tempMaxC\": \"17\", \"tempMaxF\": \"62\", \"tempMinC\": \"6\", \"tempMinF\": \"44\", \"weatherCode\": \"113\", \"weatherDesc\": [ {\"value\": \"Sunny\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"NNW\", \"winddirDegree\": \"338\", \"winddirection\": \"NNW\", \"windspeedKmph\": \"33\", \"windspeedMiles\": \"21\" } ] }}'
)
ON DUPLICATE KEY UPDATE expires = '1369267344', data = '{ \"data\": { \"current_condition\": [ {\"cloudcover\": \"75\", \"humidity\": \"65\", \"observation_time\": \"11:02 PM\", \"precipMM\": \"0.0\", \"pressure\": \"1011\", \"temp_C\": \"26\", \"temp_F\": \"79\", \"visibility\": \"13\", \"weatherCode\": \"116\", \"weatherDesc\": [ {\"value\": \"Partly Cloudy\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0002_sunny_intervals.png\" } ], \"winddir16Point\": \"SSW\", \"winddirDegree\": \"210\", \"windspeedKmph\": \"0\", \"windspeedMiles\": \"0\" } ], \"request\": [ {\"query\": \"East Norwich, United States Of America\", \"type\": \"City\" } ], \"weather\": [ {\"date\": \"2013-05-22\", \"precipMM\": \"0.0\", \"tempMaxC\": \"23\", \"tempMaxF\": \"74\", \"tempMinC\": \"19\", \"tempMinF\": \"67\", \"weatherCode\": \"122\", \"weatherDesc\": [ {\"value\": \"Overcast\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0004_black_low_cloud.png\" } ], \"winddir16Point\": \"SSW\", \"winddirDegree\": \"200\", \"winddirection\": \"SSW\", \"windspeedKmph\": \"17\", \"windspeedMiles\": \"10\" }, {\"date\": \"2013-05-23\", \"precipMM\": \"0.7\", \"tempMaxC\": \"22\", \"tempMaxF\": \"72\", \"tempMinC\": \"17\", \"tempMinF\": \"63\", \"weatherCode\": \"143\", \"weatherDesc\": [ {\"value\": \"Mist\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0006_mist.png\" } ], \"winddir16Point\": \"S\", \"winddirDegree\": \"180\", \"winddirection\": \"S\", \"windspeedKmph\": \"15\", \"windspeedMiles\": \"9\" }, {\"date\": \"2013-05-24\", \"precipMM\": \"10.1\", \"tempMaxC\": \"20\", \"tempMaxF\": \"68\", \"tempMinC\": \"13\", \"tempMinF\": \"55\", \"weatherCode\": \"302\", \"weatherDesc\": [ {\"value\": \"Moderate rain\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0018_cloudy_with_heavy_rain.png\" } ], \"winddir16Point\": \"NNW\", \"winddirDegree\": \"340\", \"winddirection\": \"NNW\", \"windspeedKmph\": \"25\", \"windspeedMiles\": \"16\" }, {\"date\": \"2013-05-25\", \"precipMM\": \"4.3\", \"tempMaxC\": \"17\", \"tempMaxF\": \"62\", \"tempMinC\": \"6\", \"tempMinF\": \"44\", \"weatherCode\": \"113\", \"weatherDesc\": [ {\"value\": \"Sunny\" } ], \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"NNW\", \"winddirDegree\": \"338\", \"winddirection\": \"NNW\", \"windspeedKmph\": \"33\", \"windspeedMiles\": \"21\" } ] }}'
[execution_time] => 0.074742078781128
)
[6] => Array
(
[mysql_query] => SELECT *, ( 3959 * acos( cos( radians(40.847302) ) * cos( radians( merch_latitude ) ) * cos( radians( merch_longitude ) - radians(-73.535042) ) + sin( radians(40.847302) ) * sin( radians( merch_latitude ) ) ) ) AS distance
FROM merchants_local
HAVING distance < 10
ORDER BY distance
[execution_time] => 0.019889116287231
)
[7] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '169609' ORDER BY item_per_off
[execution_time] => 0.0085921287536621
)
[8] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '338646' ORDER BY item_per_off
[execution_time] => 0.0074269771575928
)
[9] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '262808' ORDER BY item_per_off
[execution_time] => 0.0074188709259033
)
[10] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '134390' ORDER BY item_per_off
[execution_time] => 0.0087850093841553
)
[11] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '161815' ORDER BY item_per_off
[execution_time] => 0.007439136505127
)
[12] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '161935' ORDER BY item_per_off
[execution_time] => 0.0081751346588135
)
[13] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '314391' ORDER BY item_per_off
[execution_time] => 0.010510921478271
)
[14] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '259219' ORDER BY item_per_off
[execution_time] => 0.0075650215148926
)
[15] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '128175' ORDER BY item_per_off
[execution_time] => 0.0087499618530273
)
[16] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '143690' ORDER BY item_per_off
[execution_time] => 0.0074200630187988
)
[17] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '215485' ORDER BY item_per_off
[execution_time] => 0.012202024459839
)
[18] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '338015' ORDER BY item_per_off
[execution_time] => 0.0076777935028076
)
[19] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '123744' ORDER BY item_per_off
[execution_time] => 0.01249098777771
)
[20] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '127601' ORDER BY item_per_off
[execution_time] => 0.011351108551025
)
[21] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '259195' ORDER BY item_per_off
[execution_time] => 0.012332916259766
)
[22] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '169390' ORDER BY item_per_off
[execution_time] => 0.011476039886475
)
)
)
)
79°F
