SaleCamel.com

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.23617601394653
            [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.10573315620422
                        )

                )

        )

    [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] => 0.32262182235718
            [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.014916896820068
                        )

                    [1] => Array
                        (
                            [news_api_call] => http://hyperlocal-api.outside.in/v1.1/states/FL/cities/Orlando/stories?dev_key=6at3bn2z23e33eu92utrq6pt&sig=60353f17767aede2cfdde1ecb2ccf494&no-vertical=obituaries
                        )

                    [2] => Array
                        (
                            [mysql_query] => SELECT data FROM cache_news 
		WHERE locality = 'Orlando' 
		AND region = 'FL' 
		AND country = 'US' 
		AND expires > '1422814067'
                            [execution_time] => 0.00046205520629883
                        )

                    [3] => Array
                        (
                            [mysql_query] => INSERT INTO cache_news 
			(`locality`, `region`, `country`, `expires`, `data`) 
		VALUES
			(
			'Orlando', 
			'FL', 
			'US', 
			'1422817667', 
			''
			) 
		ON DUPLICATE KEY UPDATE expires = '1422817667', data = ''
                            [execution_time] => 0.077955007553101
                        )

                    [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.025503158569336
                        )

                    [5] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '132479' ORDER BY item_per_off
                            [execution_time] => 0.0088441371917725
                        )

                    [6] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '423850' ORDER BY item_per_off
                            [execution_time] => 0.008336067199707
                        )

                    [7] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '696027' ORDER BY item_per_off
                            [execution_time] => 0.0081970691680908
                        )

                    [8] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '326953' ORDER BY item_per_off
                            [execution_time] => 0.008275032043457
                        )

                    [9] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '757335' ORDER BY item_per_off
                            [execution_time] => 0.0083379745483398
                        )

                    [10] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '734017' ORDER BY item_per_off
                            [execution_time] => 0.0082838535308838
                        )

                    [11] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '678286' ORDER BY item_per_off
                            [execution_time] => 0.0082919597625732
                        )

                    [12] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '775067' ORDER BY item_per_off
                            [execution_time] => 0.0082790851593018
                        )

                    [13] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '723132' ORDER BY item_per_off
                            [execution_time] => 0.0084230899810791
                        )

                    [14] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '387611' ORDER BY item_per_off
                            [execution_time] => 0.0083389282226562
                        )

                    [15] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '485997' ORDER BY item_per_off
                            [execution_time] => 0.0083060264587402
                        )

                    [16] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '804027' ORDER BY item_per_off
                            [execution_time] => 0.0082559585571289
                        )

                    [17] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '798445' ORDER BY item_per_off
                            [execution_time] => 0.0083739757537842
                        )

                    [18] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '423917' ORDER BY item_per_off
                            [execution_time] => 0.0083968639373779
                        )

                    [19] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '723400' ORDER BY item_per_off
                            [execution_time] => 0.0082900524139404
                        )

                    [20] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '423833' ORDER BY item_per_off
                            [execution_time] => 0.0084519386291504
                        )

                )

        )

)