SaleCamel.com

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

                )

        )

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

                    [1] => Array
                        (
                            [news_api_call] => http://hyperlocal-api.outside.in/v1.1/states/TN/cities/Germantown/stories?dev_key=6at3bn2z23e33eu92utrq6pt&sig=5e18743252010cff3c44232961d66050&no-vertical=obituaries
                        )

                    [2] => Array
                        (
                            [mysql_query] => SELECT data FROM cache_news 
		WHERE locality = 'Germantown' 
		AND region = 'TN' 
		AND country = 'United States' 
		AND expires > '1369349424'
                            [execution_time] => 0.0004580020904541
                        )

                    [3] => Array
                        (
                            [mysql_query] => INSERT INTO cache_news 
			(`locality`, `region`, `country`, `expires`, `data`) 
		VALUES
			(
			'Germantown', 
			'TN', 
			'United States', 
			'1369353024', 
			'
DNS service for this domain has expired with DNS Made Easy
'
			) 
		ON DUPLICATE KEY UPDATE expires = '1369353024', data = '
DNS service for this domain has expired with DNS Made Easy
'
                            [execution_time] => 0.11343002319336
                        )

                    [4] => Array
                        (
                            [mysql_query] => SELECT data FROM cache_weather 
		WHERE locality = 'Germantown' 
		AND region = 'TN' 
		AND country = 'United States' 
		AND expires > '1369349424'
                            [execution_time] => 0.00097203254699707
                        )

                    [5] => Array
                        (
                            [mysql_query] => INSERT INTO cache_weather 
			(`locality`, `region`, `country`, `expires`, `data`) 
		VALUES
			(
			'Germantown', 
			'TN', 
			'United States', 
			'1369353024', 
			'{ \"data\": { \"current_condition\": [ {\"cloudcover\": \"75\", \"humidity\": \"51\", \"observation_time\": \"10:50 PM\", \"precipMM\": \"0.0\", \"pressure\": \"1017\", \"temp_C\": \"28\", \"temp_F\": \"82\", \"visibility\": \"16\", \"weatherCode\": \"116\",  \"weatherDesc\": [ {\"value\": \"Partly Cloudy\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0002_sunny_intervals.png\" } ], \"winddir16Point\": \"W\", \"winddirDegree\": \"280\", \"windspeedKmph\": \"15\", \"windspeedMiles\": \"9\" } ],  \"request\": [ {\"query\": \"Germantown, United States Of America\", \"type\": \"City\" } ],  \"weather\": [ {\"date\": \"2013-05-23\", \"precipMM\": \"0.0\", \"tempMaxC\": \"27\", \"tempMaxF\": \"81\", \"tempMinC\": \"16\", \"tempMinF\": \"60\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"NW\", \"winddirDegree\": \"320\", \"winddirection\": \"NW\", \"windspeedKmph\": \"22\", \"windspeedMiles\": \"14\" }, {\"date\": \"2013-05-24\", \"precipMM\": \"0.0\", \"tempMaxC\": \"23\", \"tempMaxF\": \"73\", \"tempMinC\": \"14\", \"tempMinF\": \"57\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"NNE\", \"winddirDegree\": \"30\", \"winddirection\": \"NNE\", \"windspeedKmph\": \"22\", \"windspeedMiles\": \"14\" }, {\"date\": \"2013-05-25\", \"precipMM\": \"0.0\", \"tempMaxC\": \"23\", \"tempMaxF\": \"74\", \"tempMinC\": \"18\", \"tempMinF\": \"65\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"S\", \"winddirDegree\": \"170\", \"winddirection\": \"S\", \"windspeedKmph\": \"13\", \"windspeedMiles\": \"8\" }, {\"date\": \"2013-05-26\", \"precipMM\": \"0.1\", \"tempMaxC\": \"23\", \"tempMaxF\": \"74\", \"tempMinC\": \"17\", \"tempMinF\": \"62\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"SSE\", \"winddirDegree\": \"150\", \"winddirection\": \"SSE\", \"windspeedKmph\": \"13\", \"windspeedMiles\": \"8\" } ] }}'
			) 
		ON DUPLICATE KEY UPDATE expires = '1369353024', data = '{ \"data\": { \"current_condition\": [ {\"cloudcover\": \"75\", \"humidity\": \"51\", \"observation_time\": \"10:50 PM\", \"precipMM\": \"0.0\", \"pressure\": \"1017\", \"temp_C\": \"28\", \"temp_F\": \"82\", \"visibility\": \"16\", \"weatherCode\": \"116\",  \"weatherDesc\": [ {\"value\": \"Partly Cloudy\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0002_sunny_intervals.png\" } ], \"winddir16Point\": \"W\", \"winddirDegree\": \"280\", \"windspeedKmph\": \"15\", \"windspeedMiles\": \"9\" } ],  \"request\": [ {\"query\": \"Germantown, United States Of America\", \"type\": \"City\" } ],  \"weather\": [ {\"date\": \"2013-05-23\", \"precipMM\": \"0.0\", \"tempMaxC\": \"27\", \"tempMaxF\": \"81\", \"tempMinC\": \"16\", \"tempMinF\": \"60\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"NW\", \"winddirDegree\": \"320\", \"winddirection\": \"NW\", \"windspeedKmph\": \"22\", \"windspeedMiles\": \"14\" }, {\"date\": \"2013-05-24\", \"precipMM\": \"0.0\", \"tempMaxC\": \"23\", \"tempMaxF\": \"73\", \"tempMinC\": \"14\", \"tempMinF\": \"57\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"NNE\", \"winddirDegree\": \"30\", \"winddirection\": \"NNE\", \"windspeedKmph\": \"22\", \"windspeedMiles\": \"14\" }, {\"date\": \"2013-05-25\", \"precipMM\": \"0.0\", \"tempMaxC\": \"23\", \"tempMaxF\": \"74\", \"tempMinC\": \"18\", \"tempMinF\": \"65\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"S\", \"winddirDegree\": \"170\", \"winddirection\": \"S\", \"windspeedKmph\": \"13\", \"windspeedMiles\": \"8\" }, {\"date\": \"2013-05-26\", \"precipMM\": \"0.1\", \"tempMaxC\": \"23\", \"tempMaxF\": \"74\", \"tempMinC\": \"17\", \"tempMinF\": \"62\", \"weatherCode\": \"113\",  \"weatherDesc\": [ {\"value\": \"Sunny\" } ],  \"weatherIconUrl\": [ {\"value\": \"http:\\/\\/www.worldweatheronline.com\\/images\\/wsymbols01_png_64\\/wsymbol_0001_sunny.png\" } ], \"winddir16Point\": \"SSE\", \"winddirDegree\": \"150\", \"winddirection\": \"SSE\", \"windspeedKmph\": \"13\", \"windspeedMiles\": \"8\" } ] }}'
                            [execution_time] => 0.10750484466553
                        )

                    [6] => Array
                        (
                            [mysql_query] => SELECT *, ( 3959 * acos( cos( radians(35.097038) ) * cos( radians( merch_latitude ) ) * cos( radians( merch_longitude ) - radians(-89.806892) ) + sin( radians(35.097038) ) * sin( radians( merch_latitude ) ) ) ) AS distance 
	FROM merchants_local 
		HAVING distance < 10 
			ORDER BY distance
                            [execution_time] => 0.016372919082642
                        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                )

        )

)