[РЕШЕНО] Сложное where в msProducts

{'msProducts' | snippet: [
                'includeTVs' => 'catalog_images,logo_franchise,abs_views,priority',
                'limit' => 2,
                'tpl' =>  '@FILE chunks/filters/filterResultRow.html',
                'showLog' => 1,
                'where' => [
                            'msProduct.parent' => $parent,
                            'msProduct.id:!=' => $id,
                            'msProduct.published' => 1,
                            'msProduct.deleted' => 0,
                            'OR:Data.made_in:=' => $madeIn,
                            'OR:Data.price:=' => $price
                            ]
            ]}

<pre class="msProductsLog">0.0000539: pdoTools loaded. 0.0001791: Conditions prepared 0.0000229: xPDO query object created 0.0003340: Included list of tvs: <b>abs_views, catalog_images, logo_franchise, priority</b> 0.0001149: leftJoined <i>msProductData</i> as <b>Data</b> 0.0000739: leftJoined <i>msVendor</i> as <b>Vendor</b> 0.0000710: leftJoined <i>modTemplateVarResource</i> as <b>TVabs_views</b> 0.0000689: leftJoined <i>modTemplateVarResource</i> as <b>TVcatalog_images</b> 0.0000689: leftJoined <i>modTemplateVarResource</i> as <b>TVlogo_franchise</b> 0.0000679: leftJoined <i>modTemplateVarResource</i> as <b>TVpriority</b> 0.0000010: Grouped by <b>msProduct.id</b> 0.0001211: Added selection of <b>msProduct</b>: <small>`id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `alias_visible`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `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`</small> 0.0000570: Added selection of <b>msProductData</b>: <small>`article`, `price`, `old_price`, `weight`, `image`, `thumb`, `vendor`, `made_in`, `new`, `popular`, `favorite`, `tags`, `color`, `size`, `source`, `own_firm`, `franchise_firm`, `lump_sum`, `royalty`, `payback`, `contact_person`, `phone_number`, `email_address`, `promo`, `place`</small> 0.0000482: Added selection of <b>msVendor</b>: <small>`name` AS `vendor.name`, `resource` AS `vendor.resource`, `country` AS `vendor.country`, `logo` AS `vendor.logo`, `address` AS `vendor.address`, `phone` AS `vendor.phone`, `fax` AS `vendor.fax`, `email` AS `vendor.email`, `description` AS `vendor.description`, `properties` AS `vendor.properties`</small> 0.0000069: Added selection of <b>modTemplateVarResource</b>: <small>IFNULL(`value`, '0') AS `abs_views`</small> 0.0000060: Added selection of <b>modTemplateVarResource</b>: <small>IFNULL(`value`, '') AS `catalog_images`</small> 0.0000041: Added selection of <b>modTemplateVarResource</b>: <small>IFNULL(`value`, '') AS `logo_franchise`</small> 0.0000050: Added selection of <b>modTemplateVarResource</b>: <small>IFNULL(`value`, '') AS `priority`</small> 0.0000632: Replaced TV conditions 0.0000319: Processed additional conditions 0.0002871: Added where condition: <b>class_key=msProduct, msProduct.parent=43, msProduct.id:!==132, msProduct.published=1, msProduct.deleted=0, OR:Data.made_in:==Краснодарский край, OR:Data.price:==8000000</b> 0.0000029: Replaced TV conditions 0.0000391: Sorted by <b>msProduct.id</b>, <b>ASC</b> 0.0000010: Limited to <b>2</b>, offset <b>0</b> 0.0005159: SQL prepared <small>"SELECT `msProduct`.`id`, `msProduct`.`type`, `msProduct`.`contentType`, `msProduct`.`pagetitle`, `msProduct`.`longtitle`, `msProduct`.`description`, `msProduct`.`alias`, `msProduct`.`alias_visible`, `msProduct`.`link_attributes`, `msProduct`.`published`, `msProduct`.`pub_date`, `msProduct`.`unpub_date`, `msProduct`.`parent`, `msProduct`.`isfolder`, `msProduct`.`introtext`, `msProduct`.`richtext`, `msProduct`.`template`, `msProduct`.`menuindex`, `msProduct`.`searchable`, `msProduct`.`cacheable`, `msProduct`.`createdby`, `msProduct`.`createdon`, `msProduct`.`editedby`, `msProduct`.`editedon`, `msProduct`.`deleted`, `msProduct`.`deletedon`, `msProduct`.`deletedby`, `msProduct`.`publishedon`, `msProduct`.`publishedby`, `msProduct`.`menutitle`, `msProduct`.`donthit`, `msProduct`.`privateweb`, `msProduct`.`privatemgr`, `msProduct`.`content_dispo`, `msProduct`.`hidemenu`, `msProduct`.`class_key`, `msProduct`.`context_key`, `msProduct`.`content_type`, `msProduct`.`uri`, `msProduct`.`uri_override`, `msProduct`.`hide_children_in_tree`, `msProduct`.`show_in_tree`, `msProduct`.`properties`, `Data`.`article`, `Data`.`price`, `Data`.`old_price`, `Data`.`weight`, `Data`.`image`, `Data`.`thumb`, `Data`.`vendor`, `Data`.`made_in`, `Data`.`new`, `Data`.`popular`, `Data`.`favorite`, `Data`.`tags`, `Data`.`color`, `Data`.`size`, `Data`.`source`, `Data`.`own_firm`, `Data`.`franchise_firm`, `Data`.`lump_sum`, `Data`.`royalty`, `Data`.`payback`, `Data`.`contact_person`, `Data`.`phone_number`, `Data`.`email_address`, `Data`.`promo`, `Data`.`place`, `Vendor`.`name` AS `vendor.name`, `Vendor`.`resource` AS `vendor.resource`, `Vendor`.`country` AS `vendor.country`, `Vendor`.`logo` AS `vendor.logo`, `Vendor`.`address` AS `vendor.address`, `Vendor`.`phone` AS `vendor.phone`, `Vendor`.`fax` AS `vendor.fax`, `Vendor`.`email` AS `vendor.email`, `Vendor`.`description` AS `vendor.description`, `Vendor`.`properties` AS `vendor.properties`, IFNULL(`TVabs_views`.`value`, '0') AS `abs_views`, IFNULL(`TVcatalog_images`.`value`, '') AS `catalog_images`, IFNULL(`TVlogo_franchise`.`value`, '') AS `logo_franchise`, IFNULL(`TVpriority`.`value`, '') AS `priority` FROM `fran_site_content` AS `msProduct` LEFT JOIN `fran_ms2_products` `Data` ON `msProduct`.`id` = `Data`.`id` LEFT JOIN `fran_ms2_vendors` `Vendor` ON Data.vendor=Vendor.id LEFT JOIN `fran_site_tmplvar_contentvalues` `TVabs_views` ON `TVabs_views`.`contentid` = `msProduct`.`id` AND `TVabs_views`.`tmplvarid` = 22 LEFT JOIN `fran_site_tmplvar_contentvalues` `TVcatalog_images` ON `TVcatalog_images`.`contentid` = `msProduct`.`id` AND `TVcatalog_images`.`tmplvarid` = 3 LEFT JOIN `fran_site_tmplvar_contentvalues` `TVlogo_franchise` ON `TVlogo_franchise`.`contentid` = `msProduct`.`id` AND `TVlogo_franchise`.`tmplvarid` = 2 LEFT JOIN `fran_site_tmplvar_contentvalues` `TVpriority` ON `TVpriority`.`contentid` = `msProduct`.`id` AND `TVpriority`.`tmplvarid` = 28 WHERE ( `msProduct`.`class_key` = 'msProduct' AND `msProduct`.`parent` = 43 AND `msProduct`.`id` != 132 AND `msProduct`.`published` = 1 AND `msProduct`.`deleted` = 0 OR `Data`.`made_in` = 'Краснодарский край' OR `Data`.`price` = '8000000' ) GROUP BY msProduct.id ORDER BY msProduct.id ASC LIMIT 2 "</small> 0.0024779: SQL executed 0.0000238: Rows fetched 0.0000370: Returning raw data 0.0006521: Checked the active modifiers 0.0005829: Created "modChunk" from file "core/templates/chunks/filters/filterResultRow.html" 0.0027871: Compiled Fenom chunk with name "modchunk/f274287bd999472fd03acafb38210b64" 0.0009439: Loaded "modSnippet" with name "pThumb" 0.0007551: Time to load products options 0.0148249: <b>Total time</b> 6 291 456: <b>Memory usage</b> </pre>

{'msProducts' | snippet: [
            'includeTVs' => 'catalog_images,logo_franchise,abs_views,priority',
            'limit' => 2,
            'tpl' =>  '@FILE chunks/filters/filterResultRow.html',
            'showLog' => 1,
            'where' =>[
                [
                'msProduct.id:!=' => $id,
                'msProduct.parent' => $parent,
                'msProduct.published' => 1,
                'msProduct.deleted' => 0,
                'Data.price:>' => 0,
                ],[
                'OR:Data.made_in:=' => $made_in,
                'msProduct.id:!=' => $id,
                'msProduct.parent' => $parent,
                ],[
                'OR:Data.price:=' => $price,
                'msProduct.id:!=' => $id,
                'msProduct.parent' => $parent,
                ]
            ]
            ]}