Array
(
[all_sql] => SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price_lbg WHERE status = '1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.005 AND crt_to >= 0.005 ORDER BY weight ASC, carat_price ASC limit 0,1MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price_lbg WHERE status='1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2') AND color IN ('D','E') AND lab IN ('SUNSHINE') AND crt_from <= 0.06 AND crt_to >= 0.06 ORDER BY weight ASC, carat_price ASC limit 0,1
[center_stone_price] => 0
[multi_stone_price] => 32.93784
[side_stone_price] => 15.477735
[price_before_markup] => 419
[all_stone_price] => 48.415575
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 419
[metal_price_gm] => 93.0000
[metal_price] => 252.72
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 356
[setting_final_price] => 299
[metal_weight] => 2.7174193548387
[no_price] => 0
[stone_ids] => Array
(
[0] => 1929905
[1] => 1930176
)
[no_option] => 0
[no_option_comb] =>
)
Array
(
[all_sql] => SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price_lbg WHERE status = '1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.0075 AND crt_to >= 0.0075 ORDER BY weight ASC, carat_price ASC limit 0,1SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price_lbg WHERE status = '1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.005 AND crt_to >= 0.005 ORDER BY weight ASC, carat_price ASC limit 0,1SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price_lbg WHERE status = '1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.004 AND crt_to >= 0.004 ORDER BY weight ASC, carat_price ASC limit 0,1MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price_lbg WHERE status='1' AND stone='LAB' AND shape='CUS' AND clarity IN ('IF','VVS1','VVS2') AND color IN ('D','E') AND lab IN ('SUNSHINE','IGI') AND (weight >= 0.22 AND weight <= 0.72) ORDER BY weight ASC, carat_price ASC limit 1,1
[center_stone_price] => 0
[multi_stone_price] => 310.28712
[side_stone_price] => 27.7880620875
[price_before_markup] => 849
[all_stone_price] => 338.0751820875
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 849
[metal_price_gm] => 93.0000
[metal_price] => 272.16
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 722
[setting_final_price] => 322
[metal_weight] => 2.9264516129032
[no_price] => 0
[stone_ids] => Array
(
[0] => 1929905
[1] => 1929905
[2] => 1929905
[3] => 1768724
)
[no_option] => 0
[no_option_comb] =>
)
Array
(
[all_sql] => MULTI:SELECT stone_price_id, cert_no, carat_price, color, clarity, total_price, lab, stone FROM dd_stone_price WHERE status='1' AND stone='YD' AND shape='CUS' AND clarity IN () AND color IN ('') AND lab IN ('SUNSHINE') AND (weight >= 0.3 AND weight <= 0.8) ORDER BY weight ASC, carat_price ASC limit 0,1
[center_stone_price] => 0
[multi_stone_price] => 0
[side_stone_price] => 0
[price_before_markup] => 214
[all_stone_price] => 0
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 214
[metal_price_gm] => 93.0000
[metal_price] => 153.5112
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 182
[setting_final_price] => 182
[metal_weight] => 1.6506580645161
[no_price] => 1
[stone_ids] => Array
(
)
[no_option] => 0
[no_option_comb] =>
)