Array
(
[all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price_lbg WHERE status = '1' AND stone = 'LAB' AND shape = 'RND' AND weight >= 0.2 AND weight <= 0.7 AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') ORDER BY weight ASC, total_price ASC limit 0,1
[center_stone_price] => 64.228122
[multi_stone_price] => 0
[side_stone_price] => 0
[price_before_markup] => 328
[all_stone_price] => 64.228122
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 328
[metal_price_gm] => 60.0000
[metal_price] => 166.11096774194
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 279
[setting_final_price] => 201
[metal_weight] => 2.7685161290323
[no_price] => 0
[stone_ids] => Array
(
[0] => 1930627
)
[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.015 AND crt_to >= 0.015 ORDER BY weight ASC, carat_price ASC limit 0,1
[center_stone_price] => 0
[multi_stone_price] => 60.6396375
[side_stone_price] => 0
[price_before_markup] => 449
[all_stone_price] => 60.6396375
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 449
[metal_price_gm] => 121.0000
[metal_price] => 254.1
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 382
[setting_final_price] => 308
[metal_weight] => 2.1
[no_price] => 0
[stone_ids] => Array
(
[0] => 1945272
)
[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_lbg WHERE status='1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.025 AND crt_to >= 0.025 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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.02 AND crt_to >= 0.02 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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.03 AND crt_to >= 0.03 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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.05 AND crt_to >= 0.05 ORDER BY weight ASC, carat_price ASC limit 0,1
[center_stone_price] => 0
[multi_stone_price] => 53.3319699
[side_stone_price] => 0
[price_before_markup] => 356
[all_stone_price] => 53.3319699
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 356
[metal_price_gm] => 93.0000
[metal_price] => 196.344
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 303
[setting_final_price] => 238
[metal_weight] => 2.1112258064516
[no_price] => 0
[stone_ids] => Array
(
[0] => 1929884
[1] => 1929884
[2] => 1929884
[3] => 1930027
)
[no_option] => 0
[no_option_comb] =>
)
Array
(
[all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price_lbg WHERE status = '1' AND stone = 'LAB' AND shape = 'RND' AND weight >= 0.2 AND weight <= 0.7 AND clarity = 'IF' AND color = 'D' AND lab = 'GIA' ORDER BY weight ASC, total_price ASC limit 0,1
[center_stone_price] => 0
[multi_stone_price] => 0
[side_stone_price] => 0
[price_before_markup] => 0
[all_stone_price] => 0
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 0
[metal_price_gm] => 93.0000
[metal_price] => 195.048
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 0
[setting_final_price] => 0
[metal_weight] => 2.0972903225806
[no_price] => 1
[stone_ids] => Array
(
)
[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_lbg WHERE status='1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.025 AND crt_to >= 0.025 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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.03 AND crt_to >= 0.03 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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') 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] => 105.714279
[side_stone_price] => 0
[price_before_markup] => 798
[all_stone_price] => 105.714279
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 798
[metal_price_gm] => 93.0000
[metal_price] => 453.6
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 678
[setting_final_price] => 550
[metal_weight] => 4.8774193548387
[no_price] => 0
[stone_ids] => Array
(
[0] => 1929884
[1] => 1929884
[2] => 1930027
)
[no_option] => 0
[no_option_comb] =>
)
Array
(
[all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price_lbg WHERE status = '1' AND stone = 'LAB' AND shape = 'RND' AND weight >= 0.2 AND weight <= 0.7 AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') ORDER BY weight ASC, total_price ASC limit 0,1
[center_stone_price] => 64.228122
[multi_stone_price] => 0
[side_stone_price] => 0
[price_before_markup] => 375
[all_stone_price] => 64.228122
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 375
[metal_price_gm] => 60.0000
[metal_price] => 198.44129032258
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 319
[setting_final_price] => 241
[metal_weight] => 3.3073548387097
[no_price] => 0
[stone_ids] => Array
(
[0] => 1930627
)
[no_option] => 0
[no_option_comb] =>
)
Array
(
[all_sql] => CENTER:SELECT stone_price_id, total_price, color, clarity FROM dd_stone_price WHERE status = '1' AND stone = 'DI' AND shape = 'RND' AND weight >= 0.1 AND weight <= 0.6 AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') ORDER BY weight ASC, total_price ASC limit 0,1SIDE: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',' SI1','SI2') AND color IN ('D','E','F','G') AND lab IN ('SUNSHINE','GIA') AND crt_from <= 0.004 AND crt_to >= 0.004 ORDER BY weight ASC, carat_price ASC limit 0,1
[center_stone_price] => 46.736
[multi_stone_price] => 0
[side_stone_price] => 61.1231532
[price_before_markup] => 366
[all_stone_price] => 107.8591532
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 366
[metal_price_gm] => 60.0000
[metal_price] => 148.64516129032
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 311
[setting_final_price] => 180
[metal_weight] => 2.4774193548387
[no_price] => 0
[stone_ids] => Array
(
[0] => 1941924
[1] => 1945270
)
[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_lbg WHERE status='1' AND stone='LAB' AND shape='RND' AND clarity IN ('IF','VVS1','VVS2','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE','IGI') AND (weight >= 0.33 AND weight <= 0.83) ORDER BY weight ASC, carat_price ASC limit 1,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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE','IGI') AND (weight >= 0.25 AND weight <= 0.75) ORDER BY weight ASC, carat_price ASC limit 1,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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND (weight >= 0.2 AND weight <= 0.7) 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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.15 AND crt_to >= 0.15 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','VS1','VS2','SI1','SI2') AND color IN ('I','H','G','F','E','D') AND lab IN ('SUNSHINE') AND crt_from <= 0.1 AND crt_to >= 0.1 ORDER BY weight ASC, carat_price ASC limit 0,1
[center_stone_price] => 0
[multi_stone_price] => 601.62115661088
[side_stone_price] => 0
[price_before_markup] => 1326
[all_stone_price] => 601.62115661088
[all_stone_price_original] => 0
[all_stone_price_discount] => 0
[making_charges] => 0
[all_chain_price] => 0
[original_price] => 1326
[metal_price_gm] => 93.0000
[metal_price] => 328.536
[chain_price] => 0
[back_price] => 0
[stone_price] => 0
[sidestone_price] => 0
[multistone_price] => 0
[final_price] => 1127
[setting_final_price] => 398
[metal_weight] => 3.5326451612903
[no_price] => 0
[stone_ids] => Array
(
[0] => 1619282
[1] => 1930715
[2] => 1930627
[3] => 1930373
[4] => 1930204
)
[no_option] => 0
[no_option_comb] =>
)