SaleCamel.com

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

                )

        )

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

                    [1] => Array
                        (
                            [news_api_call] => http://hyperlocal-api.outside.in/v1.1/states/TN/cities/Old%20Hickory/stories?dev_key=6at3bn2z23e33eu92utrq6pt&sig=403a4fa9728db892e99026e02bd69642&no-vertical=obituaries
                        )

                    [2] => Array
                        (
                            [mysql_query] => SELECT data FROM cache_news 
		WHERE locality = 'Old Hickory' 
		AND region = 'TN' 
		AND country = 'United States' 
		AND expires > '1369366979'
                            [execution_time] => 0.00040698051452637
                        )

                    [3] => Array
                        (
                            [mysql_query] => SELECT data FROM cache_weather 
		WHERE locality = 'Old Hickory' 
		AND region = 'TN' 
		AND country = 'United States' 
		AND expires > '1369366979'
                            [execution_time] => 0.0003960132598877
                        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                    [21] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '309812' ORDER BY item_per_off
                            [execution_time] => 0.011173009872437
                        )

                    [22] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '337646' ORDER BY item_per_off
                            [execution_time] => 0.010647773742676
                        )

                    [23] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '137107' ORDER BY item_per_off
                            [execution_time] => 0.0120530128479
                        )

                    [24] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '334401' ORDER BY item_per_off
                            [execution_time] => 0.01203989982605
                        )

                    [25] => Array
                        (
                            [mysql_query] => SELECT * FROM items_local WHERE merch_id = '312281' ORDER BY item_per_off
                            [execution_time] => 0.011940002441406
                        )

                )

        )

)