Array
(
[0] => Array
(
[0] => template
[1] => mar2013
)
[1] => Array
(
[api_query] => http://api.salecamel.com?api_key=123456789&do_get=local_locations
[execution_time] => 0.20224189758301
[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.083720922470093
)
)
)
[2] => Array
(
[api_query] => http://api.salecamel.com?api_key=123456789&do_get=get_local&location=Orlando%2C+FL%2C+US&radius=10&search_limit=15
[execution_time] => 1.741956949234
[from_api] => Array
(
[0] => Array
(
[mysql_query] => SELECT merch_latitude, merch_longitude
FROM merchants_local
WHERE merch_locality='Orlando' AND merch_region='FL'
[execution_time] => 0.013092994689941
)
[1] => Array
(
[news_api_call] => http://hyperlocal-api.outside.in/v1.1/states/FL/cities/Orlando/stories?dev_key=6at3bn2z23e33eu92utrq6pt&sig=b60a2284913d4a33c73d270845e4eeb6&no-vertical=obituaries
)
[2] => Array
(
[mysql_query] => SELECT data FROM cache_news
WHERE locality = 'Orlando'
AND region = 'FL'
AND country = 'US'
AND expires > '1406198345'
[execution_time] => 0.00051093101501465
)
[3] => Array
(
[mysql_query] => INSERT INTO cache_news
(`locality`, `region`, `country`, `expires`, `data`)
VALUES
(
'Orlando',
'FL',
'US',
'1406201945',
''
)
ON DUPLICATE KEY UPDATE expires = '1406201945', data = ''
[execution_time] => 0.12878704071045
)
[4] => Array
(
[mysql_query] => SELECT *, ( 3959 * acos( cos( radians(28.401633) ) * cos( radians( merch_latitude ) ) * cos( radians( merch_longitude ) - radians(-81.404314) ) + sin( radians(28.401633) ) * sin( radians( merch_latitude ) ) ) ) AS distance
FROM merchants_local
HAVING distance < 10
ORDER BY distance
[execution_time] => 0.02502703666687
)
[5] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '132479' ORDER BY item_per_off
[execution_time] => 0.0089559555053711
)
[6] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '656038' ORDER BY item_per_off
[execution_time] => 0.0068168640136719
)
[7] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '688064' ORDER BY item_per_off
[execution_time] => 0.0069179534912109
)
[8] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '690750' ORDER BY item_per_off
[execution_time] => 0.006821870803833
)
[9] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '667484' ORDER BY item_per_off
[execution_time] => 0.0068449974060059
)
[10] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '767007' ORDER BY item_per_off
[execution_time] => 0.0067398548126221
)
[11] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '423848' ORDER BY item_per_off
[execution_time] => 0.0068960189819336
)
[12] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '667485' ORDER BY item_per_off
[execution_time] => 0.0069549083709717
)
[13] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '696880' ORDER BY item_per_off
[execution_time] => 0.0069549083709717
)
[14] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '430045' ORDER BY item_per_off
[execution_time] => 0.0069010257720947
)
[15] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '678607' ORDER BY item_per_off
[execution_time] => 0.0068478584289551
)
[16] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '757330' ORDER BY item_per_off
[execution_time] => 0.0068202018737793
)
[17] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '485997' ORDER BY item_per_off
[execution_time] => 0.0069818496704102
)
[18] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '423866' ORDER BY item_per_off
[execution_time] => 0.0069160461425781
)
[19] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '586164' ORDER BY item_per_off
[execution_time] => 0.0069048404693604
)
[20] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '423840' ORDER BY item_per_off
[execution_time] => 0.0069119930267334
)
[21] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '613096' ORDER BY item_per_off
[execution_time] => 0.0068869590759277
)
[22] => Array
(
[mysql_query] => SELECT * FROM items_local WHERE merch_id = '731060' ORDER BY item_per_off
[execution_time] => 0.0068290233612061
)
)
)
)
