Server-time taken: 0.23681 seconds

Templates used:

1. karta.html loaded from /home/karte/templates/karta.html

Template path:

1. /home/karte/../karte/templates
2. /home/karte/../karte/facebookconnect/templates

SQL executed:

1. SELECT "gradovi_sponsor"."id", "gradovi_sponsor"."name", "gradovi_sponsor"."image", "gradovi_sponsor"."slug" FROM "gradovi_sponsor" WHERE "gradovi_sponsor"."slug" = E'bebin-svijet' 

   took 0.002 seconds

2. SELECT "gradovi_company"."id", "gradovi_company"."name", "gradovi_company"."lat", "gradovi_company"."lng", "gradovi_company"."address", "gradovi_company"."phone_number", "gradovi_company"."fax", "gradovi_company"."email", "gradovi_company"."mb", "gradovi_company"."oib", "gradovi_company"."url", "gradovi_company"."image", "gradovi_company"."description", "gradovi_company"."service_id", "gradovi_company"."city_id", "gradovi_company"."city2", "gradovi_company"."sponsor_id", "gradovi_company"."slug", "gradovi_company"."region_id" FROM "gradovi_company" WHERE "gradovi_company"."sponsor_id" = 2  
     ORDER BY "gradovi_company"."name" ASC

   took 0.012 seconds

3. SELECT COUNT(DISTINCT "gradovi_company"."city_id") FROM "gradovi_company" WHERE "gradovi_company"."sponsor_id" = 2 

   took 0.008 seconds

4. SELECT "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "gradovi_city" WHERE "gradovi_city"."name" = E'hrvatska'  
     ORDER BY "gradovi_city"."name" ASC LIMIT 1

   took 0.001 seconds

5. SELECT "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "gradovi_city" INNER JOIN "gradovi_city_sites" ON ("gradovi_city"."id" = "gradovi_city_sites"."city_id") WHERE ("gradovi_city_sites"."site_id" = 2  AND NOT ("gradovi_city"."name" IN (E'svijet', E'hrvatska', E'zagreb', E'split', E'rijeka'))) 
     ORDER BY "gradovi_city"."name" ASC

   took 0.002 seconds

6. SELECT COUNT(*) FROM "gradovi_company" INNER JOIN "gradovi_city" ON ("gradovi_company"."city_id" = "gradovi_city"."id") WHERE "gradovi_city"."name" = E'hrvatska' 

   took 0.015 seconds

7. SELECT COUNT(*) FROM "gradovi_street" INNER JOIN "gradovi_city" ON ("gradovi_street"."city_id" = "gradovi_city"."id") WHERE "gradovi_city"."name" = E'hrvatska' 

   took 0.002 seconds

8. SELECT "gradovi_location"."id", "gradovi_location"."name", "gradovi_location"."address", "gradovi_location"."lat", "gradovi_location"."lng", "gradovi_location"."description", "gradovi_location"."city_id", "gradovi_location"."slug", "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "gradovi_location" INNER JOIN "gradovi_city" ON ("gradovi_location"."city_id" = "gradovi_city"."id") WHERE ("gradovi_city"."name" = E'hrvatska'  AND NOT ("gradovi_location"."name" = E'dummy' )) 
     ORDER BY RANDOM() LIMIT 6

   took 0.001 seconds

9. SELECT COUNT(*) FROM "gradovi_userlocation"

   took 0.001 seconds

10. SELECT "gradovi_userlocation"."id", "gradovi_userlocation"."name", "gradovi_userlocation"."lat", "gradovi_userlocation"."lng", "gradovi_userlocation"."added", "gradovi_userlocation"."slug" FROM "gradovi_userlocation" 
      ORDER BY "gradovi_userlocation"."added" DESC LIMIT 15

    took 0.002 seconds

11. SELECT "dogadanja_event"."id", "dogadanja_event"."date", "dogadanja_event"."description", "dogadanja_event"."type_id", "dogadanja_event"."location_id", "dogadanja_event"."ticket_sale", "dogadanja_event"."ticket_sale_url", "dogadanja_event"."eventim_id", "dogadanja_event"."show_event", "dogadanja_eventtype"."id", "dogadanja_eventtype"."name", "gradovi_location"."id", "gradovi_location"."name", "gradovi_location"."address", "gradovi_location"."lat", "gradovi_location"."lng", "gradovi_location"."description", "gradovi_location"."city_id", "gradovi_location"."slug", "gradovi_city"."id", "gradovi_city"."name", "gradovi_city"."lat", "gradovi_city"."lng", "gradovi_city"."start_zoom", "gradovi_city"."min_zoom", "gradovi_city"."max_zoom" FROM "dogadanja_event" INNER JOIN "dogadanja_event_sites" ON ("dogadanja_event"."id" = "dogadanja_event_sites"."event_id") INNER JOIN "dogadanja_eventtype" ON ("dogadanja_event"."type_id" = "dogadanja_eventtype"."id") INNER JOIN "gradovi_location" ON ("dogadanja_event"."location_id" = "gradovi_location"."id") INNER JOIN "gradovi_city" ON ("gradovi_location"."city_id" = "gradovi_city"."id") WHERE ("dogadanja_event_sites"."site_id" = 2  AND "dogadanja_event"."date" >= E'2012-05-18'  AND "dogadanja_event"."show_event" = true ) 
      ORDER BY "dogadanja_event"."date" ASC

    took 0.003 seconds

Total SQL time: 0.049