SaleCamel.com

Array
(
    [0] => Array
        (
            [api_query] => http://api.salecamel.com?api_key=123456789&do_get=local_locations
            [execution_time] => 0.13716721534729
            [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.047481060028076
                        )

                )

        )

    [1] => Array
        (
            [api_query] => http://api.salecamel.com?api_key=123456789&do_get=get_local&location=Lakewood%2C+WA%2C+US&radius=10&search_limit=15
            [execution_time] => 5.9280090332031
            [from_api] => Array
                (
                    [0] => Array
                        (
                            [mysql_query] => SELECT merch_latitude, merch_longitude 
			FROM merchants_local 
				WHERE merch_locality='Lakewood' AND merch_region='WA'
                            [execution_time] => 0.0078799724578857
                        )

                    [1] => Array
                        (
                            [news_api_call] => http://hyperlocal-api.outside.in/v1.1/states/WA/cities/Lakewood/stories?dev_key=6at3bn2z23e33eu92utrq6pt&sig=5475be6facdfffcfc6afd6d027400ce5&no-vertical=obituaries
                        )

                    [2] => Array
                        (
                            [mysql_query] => SELECT data FROM cache_news 
		WHERE locality = 'Lakewood' 
		AND region = 'WA' 
		AND country = 'US' 
		AND expires > '1368879075'
                            [execution_time] => 0.00031399726867676
                        )

                    [3] => Array
                        (
                            [mysql_query] => SELECT data FROM cache_weather 
		WHERE locality = 'Lakewood' 
		AND region = 'WA' 
		AND country = 'US' 
		AND expires > '1368879075'
                            [execution_time] => 0.00026082992553711
                        )

                    [4] => Array
                        (
                            [mysql_query] => SELECT *, ( 3959 * acos( cos( radians(47.174789) ) * cos( radians( merch_latitude ) ) * cos( radians( merch_longitude ) - radians(-122.484337) ) + sin( radians(47.174789) ) * sin( radians( merch_latitude ) ) ) ) AS distance 
	FROM merchants_local 
		HAVING distance < 10 
			ORDER BY distance
                            [execution_time] => 0.01484489440918
                        )

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

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

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

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

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

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

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

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

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

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

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

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

                )

        )

)