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 = 175 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] => 175
)
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', 175, '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: