SQL query executed 3 times (not wanted)

[eluser]Jelenik[/eluser]
Hi guys,

i am experiencing a strange behaviour. I want to insert one row to database everytime is shown detail of video. But sql query seems to be executed 3 times - in profiler there is only 1 sql. I tried everything - i tried to remove all code which i dont use - only problematic part remains. I simplified functions - for example that function $this->Hlavny->zvys_pocet_zobrazeni do more (it actually updates detail of video too, but thats not important - it creates duplicity sql queries with simplified version too). It seems that there are some redirects or something, because i am experiencing this only when my url ends with slash. Lets get to the point.

My routes.php

Code:

$route['default_controller'] = "something";
$route['(:any)'] = "something";

- as you can see - everything is redirected to one controller and actions are based on segments - i had to use this because client want to have everything in first segment - categories, detail and so on - so i have to check if first segment isnt category and if isnt it will be propably video...
- i tried to use new feature and force to use only that one controller through settings in main controller index.php - but it didnt work either - and i found that there is a error with example -> There is: The controller class file name. Example: Mycontroller.php -> but it didnt work with .php at the end for me - i dont know if it depends on server on which codeigniter runs or its only bug.

I have this controller:

Code:

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Something extends CI_Controller {

    function __construct()
    {
        parent::__construct();
    }

    function index()
    {
            $data = $this->project->inicializacia();
            $data['kategorie'] = $this->Hlavny->kategorie();

            if ($this->uri->segment(1) != '') {
                    $seo = $this->uri->segment(1);
                    $data['polozka'] = $this->Hlavny->video(array('seo'=>$seo));
                    $this->Hlavny->zvys_pocet_zobrazeni($data['polozka']->id);
                    $this->load->view('header', $data);
                    $this->load->view('detail_videa', $data);
                    $this->load->view('footer', $data);

            }

    }

}

/* End of file */

$this->project->inicializacia() - this is simple inicialization function, which is used only for setting up meta tags + profiler as you can see

Code:

function inicializacia()
    {
            $default_title = 'Example.com';
            $data['meta_tagy']['title'] = 'The best - '.$default_title;
            $data['meta_tagy']['description'] = 'You you :)';
            $data['meta_tagy']['kw'] = 'kw1, kw2';

            if (($_SERVER['HTTP_HOST'] == 'localhost' OR $_SERVER['HTTP_HOST'] == '127.0.0.1') AND ($this->_CI->uri->segment(1) != 'ajaxik')) $this->_CI->output->enable_profiler(TRUE);
            if ($_SERVER['HTTP_HOST'] == 'localhost' OR $_SERVER['HTTP_HOST'] == '127.0.0.1') $data['localhost'] = TRUE;
            else $data['localhost'] = FALSE;

            return $data;
    }

I am using model Hlavny.php:

Code:

<?php

class Hlavny extends CI_Model {

    function __construct()
    {
        parent::__construct();
        $this->load->database();
    }
    
    function kategorie()
    {
        $polozky = $this->db->get_where('kategorie');
        if ($polozky->num_rows() > 0) return $vysledok;
        else return FALSE;
    }

    function video($where = array())
    {
        $polozka = $this->db->get_where('videa',$where);
        if ($polozka->num_rows() == 1) {
            $polozka = $polozka->row();
            return $polozka;
        }
        else return FALSE;
    }

    function zvys_pocet_zobrazeni($video_id)
    {
         $this->db->insert('videa_zobrazenia', array('video_id'=>$video_id, 'ip'=>$this->input->ip_address(),'cas'=>date("Y-m-d H:i:s", time())));
    }

}

/* End of file hlavny.php */

I found that there are 2 similiar thread on this forum with this kind of issue (both arent resolved as you can see):
http://ellislab.com/forums/viewthread/68585/
http://ellislab.com/forums/viewthread/64160/

Knows somebody where can be that problem?

I have lost 2 hours trying everything in code and on the end i noticed that without slash on the end it works - but this is not solution.