Array
(
[all_sql] => SIDE:SELECT stone_price_id, cert_no, carat_price, color, clarity, lab, stone FROM dd_stone_price WHERE status = '1' AND stone='DI' AND shape='RND' AND clarity IN ('VVS1','VVS2','VS1','VS2') AND color IN ('D','E','F','G') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.062 AND crt_to >= 0.062 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 WHERE status='1' AND stone='DI' AND shape='PER' AND clarity IN ('VVS1','VVS2','VS1','VS2','SI1') AND color IN ('D','E','F','G','H','I') AND lab IN ('GIA') AND (weight >= 0.75 AND weight <= 1.25) ORDER BY weight ASC, carat_price ASC limit 2,1
[center_stone_price] => 0
[multi_stone_price] => 1561.2048
[side_stone_price] => 367.971451296
[price_before_markup] => 3272
[all_stone_price] => 1929.176251296
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 3272
[metal_price_gm] => 93.0000
[metal_price] => 422.4312
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 2781
[setting_final_price] => 500
[metal_weight] => 4.5422709677419
[no_price] => 0
[stone_ids] => Array
(
[0] => 1941502
[1] => 132113
)
[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='DI' AND shape='RND' AND clarity IN ('VVS1','VVS2','VS1','VS2',' SI1','SI2') AND color IN ('D','E','F','G','H','I') AND lab IN ('SUNSHINE','GIA') 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 WHERE status='1' AND stone='DI' AND shape='RND' AND clarity IN ('VVS1','VVS2','VS1','VS2',' SI1','SI2') AND color IN ('D','E','F','G','H','I') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.015 AND crt_to >= 0.015 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 WHERE status='1' AND stone='GT' AND shape='PER' AND lab IN ('SUNSHINE') AND (weight >= 0.3 AND weight <= 0.8) 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 WHERE status='1' AND stone='GT' AND shape='PER' AND lab IN ('SUNSHINE') AND (weight >= 1.5 AND weight <= 2) ORDER BY weight ASC, carat_price ASC limit 0,1
[center_stone_price] => 0
[multi_stone_price] => 589.5945
[side_stone_price] => 0
[price_before_markup] => 1127
[all_stone_price] => 589.5945
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 1127
[metal_price_gm] => 93.0000
[metal_price] => 220.32
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 958
[setting_final_price] => 261
[metal_weight] => 2.3690322580645
[no_price] => 0
[stone_ids] => Array
(
[0] => 1945272
[1] => 1945272
[2] => 1958370
[3] => 1958403
)
[no_option] => 0
[no_option_comb] =>
)