Last Query :

SELECT product_master_option.`master_option_id`, product_master_option.`option_key`, product_master_option.`options_type`, product_master_option.`status` As master_status, product_master_option.`pricing_method`, product_master_option.`linear_formula`, product_master_option.`weight_setting`, product_master_option.`price_range_lookup`, product_master_option.`custom_lookup`, product_master_option.`formula`, product_master_option.`sort_order` AS master_sort_order, product_master_option.`hire_designer_option` AS master_hire_designer_option, product_master_option.`prod_add_opt_export_group_id`, product_master_option.`custom_txtbox_opt_id`, product_master_option.`min_default_value`, product_master_option.`presentation_settings`, product_master_option.`master_option_tag`, product_master_option.`custom_weight_txtbox_opt_id`, product_master_option.`additional_lookup_details`, product_master_option_description.title, product_master_option_description.description, product_master_option_attributes.master_attribute_id, product_master_option_attributes.attribute_key, product_master_option_attributes.default_attribute, product_master_option_attributes.setup_cost AS attr_setup_cost, product_master_option_attributes.multiplier as attr_multiplier, product_master_option_attributes.weight, product_master_option_attributes.material_thickness, product_master_option_attributes.production_days, product_master_option_attributes.attributes_image, product_master_option_attributes.sort_order AS attr_sort_order, product_master_option_attributes.status AS attr_status, product_master_option_attributes.material_thickness, product_master_option_attributes_description.label, product_master_option_attributes.metadata, products_additional_option.`sort_order` AS option_sort_order, products_additional_option.`setup_cost` as option_setup_cost, products_additional_option.`multiplier` as option_multiplier, products_additional_option.`status`, products_additional_option.`prod_add_opt_id` FROM product_master_option LEFT JOIN product_master_option_description ON product_master_option_description.master_option_id = product_master_option.master_option_id AND product_master_option_description.site_language_id = 1 LEFT JOIN product_master_option_attributes ON product_master_option_attributes.master_option_id = product_master_option.master_option_id AND product_master_option_attributes.status = '1' LEFT JOIN product_master_option_attributes_description ON product_master_option_attributes_description.master_attribute_id = product_master_option_attributes.master_attribute_id AND product_master_option_attributes_description.site_language_id = 1 INNER JOIN products_additional_option ON products_additional_option.option_key = product_master_option.option_key AND products_additional_option.products_id = 73 WHERE product_master_option.status = '1'

Prepared Statement :

SELECT product_master_option.`master_option_id`, product_master_option.`option_key`, product_master_option.`options_type`, product_master_option.`status` As master_status, product_master_option.`pricing_method`, product_master_option.`linear_formula`, product_master_option.`weight_setting`, product_master_option.`price_range_lookup`, product_master_option.`custom_lookup`, product_master_option.`formula`, product_master_option.`sort_order` AS master_sort_order, product_master_option.`hire_designer_option` AS master_hire_designer_option, product_master_option.`prod_add_opt_export_group_id`, product_master_option.`custom_txtbox_opt_id`, product_master_option.`min_default_value`, product_master_option.`presentation_settings`, product_master_option.`master_option_tag`, product_master_option.`custom_weight_txtbox_opt_id`, product_master_option.`additional_lookup_details`, product_master_option_description.title, product_master_option_description.description, product_master_option_attributes.master_attribute_id, product_master_option_attributes.attribute_key, product_master_option_attributes.default_attribute, product_master_option_attributes.setup_cost AS attr_setup_cost, product_master_option_attributes.multiplier as attr_multiplier, product_master_option_attributes.weight, product_master_option_attributes.material_thickness, product_master_option_attributes.production_days, product_master_option_attributes.attributes_image, product_master_option_attributes.sort_order AS attr_sort_order, product_master_option_attributes.status AS attr_status, product_master_option_attributes.material_thickness, product_master_option_attributes_description.label, product_master_option_attributes.metadata, products_additional_option.`sort_order` AS option_sort_order, products_additional_option.`setup_cost` as option_setup_cost, products_additional_option.`multiplier` as option_multiplier, products_additional_option.`status`, products_additional_option.`prod_add_opt_id` FROM product_master_option LEFT JOIN product_master_option_description ON product_master_option_description.master_option_id = product_master_option.master_option_id AND product_master_option_description.site_language_id = :opt_site_language_id LEFT JOIN product_master_option_attributes ON product_master_option_attributes.master_option_id = product_master_option.master_option_id AND product_master_option_attributes.status = '1' LEFT JOIN product_master_option_attributes_description ON product_master_option_attributes_description.master_attribute_id = product_master_option_attributes.master_attribute_id AND product_master_option_attributes_description.site_language_id = :attr_site_language_id INNER JOIN products_additional_option ON products_additional_option.option_key = product_master_option.option_key AND products_additional_option.products_id = :products_id WHERE product_master_option.status = :status

Params: Array
(
    [:opt_site_language_id] => 1
    [:status] => 1
    [:attr_site_language_id] => 1
    [:products_id] => 73
)

Show Less...

---

#0 /home/sl/public_html/model/ProductMasterOptionMaster.php(295): RMasterModel->setFrom('product_master_option')

294:         }
295:         $this->setFrom("product_master_option");
296:         $recordSet = $this->exec_query();

#1 /home/sl/public_html/model/ProductMasterOptionMaster.php(289): RMasterModel->setSelect(Array)

288:         }
289:         $this->setSelect($fields);
290:         if (isset($getOptions['master_option_sort']) && $getOptions['master_option_sort'] == true) {

#2 /home/sl/public_html/model/ProductMasterOptionMaster.php(286): RMasterModel->setJoin('INNER JOIN products_additional_option ON products_additional_option.option_key = product_master_option.option_key AND products_additional_option.products_id = :products_id', 73, 'int')

285:             } else {
286:                 $this->setJoin("INNER JOIN products_additional_option ON products_additional_option.option_key = product_master_option.option_key AND products_additional_option.products_id = :products_id", $pId, 'int');
287:             }

#3 /home/sl/public_html/model/ProductMasterOptionMaster.php(265): RMasterModel->setJoin('LEFT JOIN product_master_option_attributes_description ON product_master_option_attributes_description.master_attribute_id = product_master_option_attributes.master_attribute_id AND product_master_option_attributes_description.site_language_id = :attr_site_language_id', 1, 'int')

264:         $this->setJoin("LEFT JOIN product_master_option_attributes ON product_master_option_attributes.master_option_id = product_master_option.master_option_id" . $attrStatus);
265:         $this->setJoin("LEFT JOIN product_master_option_attributes_description ON product_master_option_attributes_description.master_attribute_id = product_master_option_attributes.master_attribute_id AND product_master_option_attributes_description.site_language_id = :attr_site_language_id", $siteLanguageId, 'int');
266:         if (isset($getOptions['canvas_product']) && $getOptions['canvas_product'] == true) {

#4 /home/sl/public_html/model/ProductMasterOptionMaster.php(264): RMasterModel->setJoin('LEFT JOIN product_master_option_attributes ON product_master_option_attributes.master_option_id = product_master_option.master_option_id AND product_master_option_attributes.status = '1'')

263:         }
264:         $this->setJoin("LEFT JOIN product_master_option_attributes ON product_master_option_attributes.master_option_id = product_master_option.master_option_id" . $attrStatus);
265:         $this->setJoin("LEFT JOIN product_master_option_attributes_description ON product_master_option_attributes_description.master_attribute_id = product_master_option_attributes.master_attribute_id AND product_master_option_attributes_description.site_language_id = :attr_site_language_id", $siteLanguageId, 'int');

#5 /home/sl/public_html/model/ProductMasterOptionMaster.php(252): RMasterModel->setWhere('AND product_master_option.status = :status', '1', 'string')

251:         if (isset($getOptions['status']) && $getOptions['status'] == true) {
252:             $this->setWhere("AND product_master_option.status = :status", '1', 'string');
253:             $attrStatus = " AND product_master_option_attributes.status = '1'";

#6 /home/sl/public_html/model/ProductMasterOptionMaster.php(249): RMasterModel->setJoin('LEFT JOIN product_master_option_description ON product_master_option_description.master_option_id = product_master_option.master_option_id AND product_master_option_description.site_language_id = :opt_site_language_id', 1, 'int')

248:         }
249:         $this->setJoin("LEFT JOIN product_master_option_description ON product_master_option_description.master_option_id = product_master_option.master_option_id AND product_master_option_description.site_language_id = :opt_site_language_id", $siteLanguageId, 'int');
250: