<?php
class ThesaurusesController extends AppController
{
public function index($get_data = NULL)
{
debug($this->Thesaurus->find('all', array('recursive' => 10, 'limit'=>1, 'conditions'=>array('id'=>12055))));
// ...
class Thesaurus extends AppModel
{
public $actsAs = array('Containable');
public $hasAndBelongsToMany = array(
'Synonym' => array(
'className' => 'Synonym',
'foreignKey' => 'thesaurus_id',
'associationForeignKey' => 'synonym_id'
)
);
// ...
class Synonym extends AppModel
{
public $useTable = 'thesauruses';
public $actsAs = array('Containable');
public $hasAndBelongsToMany = array(
'Thesaurus' => array(
'className' => 'Thesaurus',
'foreignKey' => 'synonym_id',
'associationForeignKey' => 'thesaurus_id'
)
);
public $hasOne = array(
'Meaning' => array(
'foreignKey' => 'synonym_id',
//'fields' => 'test',
//'conditions' => array('Meaning.synonym_id = Synonym.id')
),
'Property' => array(
'foreignKey' => false,
'type' => 'LEFT'
//'fields' => 'test',
//'conditions' => array('Meaning.synonym_id = Synonym.id')
)
);
// ...
/*
app\controllers\thesauruses_controller.php (line 29)
Array
(
[0] => Array
(
[Thesaurus] => Array
(
[id] => 12055
[word] => nosis
)
[Synonym] => Array
(
[0] => Array
(
[id] => 12056
[word] => snapas
[ThesaurusesThesaurus] => Array
(
[id] => 12473
[thesaurus_id] => 12055
[synonym_id] => 12056
)
[Meaning] => Array
(
[synonym_id] => 12056
[group] => 1
)
[Property] => Array
(
[id] => 1
[name] => hibr
[description] => hibridas
)
)
[1] => Array
(
[id] => 12057
[word] => knabė
[ThesaurusesThesaurus] => Array
(
[id] => 12474
[thesaurus_id] => 12055
[synonym_id] => 12057
)
[Meaning] => Array
(
[synonym_id] => 12057
[group] => 1
)
[Property] => Array
(
[id] => 1
[name] => hibr
[description] => hibridas
)
)
[2] => Array
(
[id] => 12058
[word] => šnipis
[ThesaurusesThesaurus] => Array
(
[id] => 12475
[thesaurus_id] => 12055
[synonym_id] => 12058
)
[Meaning] => Array
(
[synonym_id] => 12058
[group] => 1
)
[Property] => Array
(
[id] => 1
[name] => hibr
[description] => hibridas
)
)
[3] => Array
(
[id] => 12059
[word] => knyslė
[ThesaurusesThesaurus] => Array
(
[id] => 12476
[thesaurus_id] => 12055
[synonym_id] => 12059
)
[Meaning] => Array
(
[synonym_id] => 12059
[group] => 1
)
[Property] => Array
(
[id] => 1
[name] => hibr
[description] => hibridas
)
)
[4] => Array
(
[id] => 12060
[word] => knisas
[ThesaurusesThesaurus] => Array
(
[id] => 12477
[thesaurus_id] => 12055
[synonym_id] => 12060
)
[Meaning] => Array
(
[synonym_id] => 12060
[group] => 1
)
[Property] => Array
(
[id] => 1
[name] => hibr
[description] => hibridas
)
)
)
)
)
(default) 16 queries took 28 ms Nr Query Error Affected Num. rows Took (ms)
1 DESCRIBE `thesauruses` 2 2 4
2 DESCRIBE `meanings` 2 2 4
3 DESCRIBE `properties` 3 3 4
4 DESCRIBE `thesauruses_thesauruses` 3 3 4
5 SELECT `Thesaurus`.`id`, `Thesaurus`.`word` FROM `thesauruses` AS `Thesaurus` WHERE `id` = 12055 LIMIT 1 1 1 1
6 SELECT `Synonym`.`id`, `Synonym`.`word`, `ThesaurusesThesaurus`.`id`, `ThesaurusesThesaurus`.`thesaurus_id`, `ThesaurusesThesaurus`.`synonym_id` FROM `thesauruses` AS `Synonym` JOIN `thesauruses_thesauruses` AS `ThesaurusesThesaurus` ON (`ThesaurusesThesaurus`.`thesaurus_id` = 12055 AND `ThesaurusesThesaurus`.`synonym_id` = `Synonym`.`id`) WHERE 1 = 1 5 5 1
7 SELECT `Meaning`.`synonym_id`, `Meaning`.`group` FROM `meanings` AS `Meaning` WHERE `Meaning`.`synonym_id` = 12056 1 1 1
8 SELECT `Meaning`.`synonym_id`, `Meaning`.`group` FROM `meanings` AS `Meaning` WHERE `Meaning`.`synonym_id` = 12057 1 1 1
9 SELECT `Meaning`.`synonym_id`, `Meaning`.`group` FROM `meanings` AS `Meaning` WHERE `Meaning`.`synonym_id` = 12058 1 1 1
10 SELECT `Meaning`.`synonym_id`, `Meaning`.`group` FROM `meanings` AS `Meaning` WHERE `Meaning`.`synonym_id` = 12059 1 1 1
11 SELECT `Meaning`.`synonym_id`, `Meaning`.`group` FROM `meanings` AS `Meaning` WHERE `Meaning`.`synonym_id` = 12060 1 1 1
12 SELECT `Property`.`id`, `Property`.`name`, `Property`.`description` FROM `properties` AS `Property` WHERE 1 = 1 30 30 1
13 SELECT `Property`.`id`, `Property`.`name`, `Property`.`description` FROM `properties` AS `Property` WHERE 1 = 1 30 30 1
14 SELECT `Property`.`id`, `Property`.`name`, `Property`.`description` FROM `properties` AS `Property` WHERE 1 = 1 30 30 1
15 SELECT `Property`.`id`, `Property`.`name`, `Property`.`description` FROM `properties` AS `Property` WHERE 1 = 1 30 30 1
16 SELECT `Property`.`id`, `Property`.`name`, `Property`.`description` FROM `properties` AS `Property` WHERE 1 = 1 30 30 1
*/