PdoMenu не выводит ресурсы если их менее 6, в чем ошибка?

Question

[medvedgoff]

Вывожу меню в другом ресурсе, соседнему ресурса id 1
Находит, но не выводит ресурсы, если их менее 5 (судя по логу). Когда ресурсов 6 и более выводит без проблем. В чем может быть вопрос? Переставлял, создавал тестово с нуля все уровни, условие совпадения менял, не хочет.

Самое интересное, если в примере ниже, убрать из вывода, изменив на левое значение, т.е. с не попадает ресурс в выборку, в "подкат2" то выводит ресурсы, даже если их менее 5.

Вот примерная структура
-id1
--подкат1
---подподУ
---подподЕ
---подподР
--подкат2 (значение совпадает с условием, если значение поменять, то остальные ресурсы выводит, если даже меньше 5 совпадений с условием. )
---подподФ (значение совпадает с условием)
---подподВ (значение совпадает с условием)
---подподК (значение совпадает с условием)
---подподО (значение совпадает с условием)
-id10050
--рубрикатор
---тема (выводить тут меню это)

Код вывода
[[pdoMenu? &showLog=`1` &parents=`1` &includeTVs=`prv,ib-filt` &where=`{"ib-filt":"[[*ib-filt]]"}`]]

Лог когда выводятся 5 ресурсов (в коментах еще два лога)

0.0020080: pdoTools loaded
0.0000350: xPDO query object created
0.0026438: Included list of tvs: ib-filt, prv
0.0003660: leftJoined modTemplateVarResource as TVib-filt
0.0003390: leftJoined modTemplateVarResource as TVprv
0.0006230: Added selection of modResource: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000169: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `ib-filt`
0.0000138: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `prv`
0.0000670: Replaced TV conditions
0.0047030: Processed additional conditions
0.0055900: Added where condition: `TVib-filt`.`value`=терморегулятор, modResource.parent:IN(1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638), modResource.template:IN(4), modResource.published=1, modResource.hidemenu=0, modResource.deleted=0, modResource.context_key=web
0.0000379: Replaced TV conditions
0.0002100: Sorted by modResource.menuindex, ASC
0.0005128: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`content`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, IFNULL(`TVib-filt`.`value`, '') AS `ib-filt`, IFNULL(`TVprv`.`value`, '') AS `prv` FROM `plan_site_content` AS `modResource` LEFT JOIN `plan_site_tmplvar_contentvalues` `TVib-filt` ON `TVib-filt`.`contentid` = `modResource`.`id` AND `TVib-filt`.`tmplvarid` = 148 LEFT JOIN `plan_site_tmplvar_contentvalues` `TVprv` ON `TVprv`.`contentid` = `modResource`.`id` AND `TVprv`.`tmplvarid` = 10 WHERE  ( `TVib-filt`.`value` = 'терморегулятор' AND `modResource`.`parent` IN (1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638) AND `modResource`.`template` IN (4) AND `modResource`.`published` = 1 AND `modResource`.`hidemenu` = 0 AND `modResource`.`deleted` = 0 AND `modResource`.`context_key` = 'web' )  ORDER BY modResource.menuindex ASC "
0.0026729: SQL executed
0.0000911: Total rows: 5
0.0000501: Rows fetched
0.0001271: Returning raw data
0.0000269: Tree was built
0.0156388: Total time
10 223 616: Memory usage

Answer 1

[medvedgoff]

Вот когда 6 ресурсов:

0.0020678: pdoTools loaded
0.0000370: xPDO query object created
0.0004878: Included list of tvs: ib-filt, prv
0.0004039: leftJoined modTemplateVarResource as TVib-filt
0.0003622: leftJoined modTemplateVarResource as TVprv
0.0008180: Added selection of modResource: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000181: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `ib-filt`
0.0000150: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `prv`
0.0000579: Replaced TV conditions
0.0054069: Processed additional conditions
0.0062709: Added where condition: `TVib-filt`.`value`=терморегулятор, modResource.parent:IN(1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3978,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638), modResource.template:IN(4), modResource.published=1, modResource.hidemenu=0, modResource.deleted=0, modResource.context_key=web
0.0000300: Replaced TV conditions
0.0001950: Sorted by modResource.menuindex, ASC
0.0005128: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`content`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, IFNULL(`TVib-filt`.`value`, '') AS `ib-filt`, IFNULL(`TVprv`.`value`, '') AS `prv` FROM `plan_site_content` AS `modResource` LEFT JOIN `plan_site_tmplvar_contentvalues` `TVib-filt` ON `TVib-filt`.`contentid` = `modResource`.`id` AND `TVib-filt`.`tmplvarid` = 148 LEFT JOIN `plan_site_tmplvar_contentvalues` `TVprv` ON `TVprv`.`contentid` = `modResource`.`id` AND `TVprv`.`tmplvarid` = 10 WHERE  ( `TVib-filt`.`value` = 'терморегулятор' AND `modResource`.`parent` IN (1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3978,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638) AND `modResource`.`template` IN (4) AND `modResource`.`published` = 1 AND `modResource`.`hidemenu` = 0 AND `modResource`.`deleted` = 0 AND `modResource`.`context_key` = 'web' )  ORDER BY modResource.menuindex ASC "
0.0025380: SQL executed
0.0000920: Total rows: 6
0.0000589: Rows fetched
0.0001562: Returning raw data
0.0000448: Tree was built
0.0000260: Start template tree
0.0016122: Created inline "modChunk" with name "ad22a6773e8643db35baf6e56fa79c5d"
0.0033379: Created inline "modChunk" with name "dc6d3757597108f87f958f868cf1591a"
0.0007510: End template tree
0.0201080: Total time
10 223 616: Memory usage

Comments

[medvedgoff]

Вот лог если убрать того родителя из условия выборки, т.е. к выводу 4 ресурса, и они выводятся

0.0020881: pdoTools loaded
0.0000348: xPDO query object created
0.0004830: Included list of tvs: ib-filt, prv
0.0003748: leftJoined modTemplateVarResource as TVib-filt
0.0003269: leftJoined modTemplateVarResource as TVprv
0.0007641: Added selection of modResource: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `content`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000169: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `ib-filt`
0.0000129: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `prv`
0.0000870: Replaced TV conditions
0.0048060: Processed additional conditions
0.0056901: Added where condition: `TVib-filt`.`value`=терморегулятор, modResource.parent:IN(1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3978,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638), modResource.published=1, modResource.hidemenu=0, modResource.deleted=0, modResource.context_key=web
0.0000310: Replaced TV conditions
0.0001819: Sorted by modResource.menuindex, ASC
0.0005071: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`content`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, IFNULL(`TVib-filt`.`value`, '') AS `ib-filt`, IFNULL(`TVprv`.`value`, '') AS `prv` FROM `plan_site_content` AS `modResource` LEFT JOIN `plan_site_tmplvar_contentvalues` `TVib-filt` ON `TVib-filt`.`contentid` = `modResource`.`id` AND `TVib-filt`.`tmplvarid` = 148 LEFT JOIN `plan_site_tmplvar_contentvalues` `TVprv` ON `TVprv`.`contentid` = `modResource`.`id` AND `TVprv`.`tmplvarid` = 10 WHERE  ( `TVib-filt`.`value` = 'терморегулятор' AND `modResource`.`parent` IN (1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3978,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638) AND `modResource`.`published` = 1 AND `modResource`.`hidemenu` = 0 AND `modResource`.`deleted` = 0 AND `modResource`.`context_key` = 'web' )  ORDER BY modResource.menuindex ASC "
0.0026081: SQL executed
0.0000949: Total rows: 4
0.0000441: Rows fetched
0.0001049: Returning raw data
0.0000219: Tree was built
0.0009260: Start template tree
0.0007350: Created inline "modChunk" with name "ad22a6773e8643db35baf6e56fa79c5d"
0.0023210: End template tree
0.0002801: Created inline "modChunk" with name "dc6d3757597108f87f958f868cf1591a"
0.0179291: Total time
9 961 472: Memory usage

[medvedgoff]

Есть вариант через PdoResource, мне не важны уровни вложенности, но не могу там выстроить приоритет, сначала выводить родителя, а потом дочерние ресурсы