unos_firmi.html loaded from /home/karte/templates/unos_firmi.html
Template path:
/home/karte/../karte/templates
/home/karte/../karte/facebookconnect/templates
SQL executed:
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.004 seconds
SELECT COUNT(*) FROM "gradovi_company" INNER JOIN "gradovi_city" ON ("gradovi_company"."city_id" = "gradovi_city"."id") WHERE "gradovi_city"."name" = E'zagreb'
took 0.029 seconds
SELECT COUNT(*) FROM "gradovi_street" INNER JOIN "gradovi_city" ON ("gradovi_street"."city_id" = "gradovi_city"."id") WHERE "gradovi_city"."name" = E'zagreb'
took 0.003 seconds
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'zagreb' AND NOT ("gradovi_location"."name" = E'dummy' )) ORDER BY RANDOM() LIMIT 6
took 0.002 seconds
SELECT COUNT(*) FROM "gradovi_userlocation"
took 0.001 seconds
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
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" ORDER BY "gradovi_city"."name" ASC
took 0.001 seconds
SELECT "gradovi_region"."id", "gradovi_region"."name", "gradovi_region"."number" FROM "gradovi_region" ORDER BY "gradovi_region"."name" ASC
