Query time 0.00115
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "3.34"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"units_in_product",
"show_price_per_x_units",
"is_mobilede",
"seller_id",
"mdc_product_id"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`danishecarter_25_march`.`cscart_product_prices`.`lower_limit` = 1) and (`danishecarter_25_march`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "1.40",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"unit_name"
]
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "1.60",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "1.80",
"data_read_per_join": "7K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`danishecarter_25_march`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "3.00",
"data_read_per_join": "16"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"danishecarter_25_march.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.20",
"data_read_per_join": "172"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`danishecarter_25_march`.`cscart_categories`.`storefront_id` in (0,1)) and ((`danishecarter_25_march`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`danishecarter_25_march`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`danishecarter_25_march`.`cscart_categories`.`usergroup_ids`)) and (`danishecarter_25_march`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.01",
"prefix_cost": "3.26",
"data_read_per_join": "86"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "point_prices",
"access_type": "range",
"possible_keys": [
"unique_key",
"src_k"
],
"key": "unique_key",
"used_key_parts": [
"lower_limit",
"usergroup_id",
"product_id"
],
"key_length": "8",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.01",
"prefix_cost": "3.32",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"point_price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(point_prices), 1, true) and <if>(is_not_null_compl(point_prices), ((`danishecarter_25_march`.`point_prices`.`lower_limit` = 1) and (`danishecarter_25_march`.`point_prices`.`product_id` = 191) and (`danishecarter_25_march`.`point_prices`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.33",
"data_read_per_join": "1"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.01",
"prefix_cost": "3.34",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
facebook_obj_type |
parent_product_id |
buy_now_url |
units_in_product |
show_price_per_x_units |
is_mobilede |
seller_id |
mdc_product_id |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
unit_name |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
point_price |
discussion_type |
average_rating |
product_reviews_count |
| 191 |
Q0191PBM44 |
P |
A |
1 |
0.00 |
45 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1328644800 |
1328702508 |
0 |
N |
N |
N |
|
N |
|
Y |
N |
N |
Y |
10 |
0 |
N |
|
|
|
|
|
6 |
N |
0 |
|
|
default |
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
|
0 |
|
0.000 |
1.000 |
N |
0 |
0 |
en |
Esperanza Spalding - Radio Music Society |
|
|
<p>
<p>THIS IS A PRE ORDER ITEM.</p>
<p>IF PURCHASED, YOUR ITEM(S) WILL SHIP ON OR FOR DELIVERY ON MARCH 20, 2012</p>
<p> </p>
<p>ESPERANZA SPALDING RELEASES RADIO MUSIC SOCIETY,</p>
<p>A KALEIDOSCOPIC COLLECTION CELEBRATING THE POWER OF SONG</p>
<p> </p>
<p> </p>
<p> </p>
<p>CD With ADDED Value Download Card Card To Download 11 Music Videos</p>
<p> </p>
<p>“Radio Song,” the new disc’s opening track, both sets the tone and confirms the aptness of Spalding’s “radio music” metaphor. “Everyone has the experience of turning on a car radio,” she explains,” mindlessly flipping through the dial and suddenly a fragment grabs you and you’re totally digging it. I wanted to capture that moment when the music just sinks in. It’s about the power of song, and how at the least it can save the day.”</p>
<p> </p>
<p>Fleshing out the concept with original music was second nature to Spalding. “I have this book of music that I’ve written, and so much of it fit either the Chamber Music or Radio Music concept. Songs develop for me in fragments, so for these projects, I took my notes and organized them into coherent works of music.”</p>
<p> </p>
<p>In the process, Spalding added her original, affirmative perspective to classic radio music themes. Songs about love run a full gamut. “Hold On Me” is a narrative of unrequited love, inspired by people who cling to dreams of relationships that can never be realized. “Let Her,” one of Spalding’s older compositions, was inspired by “different people I’ve known who are in miserable situations, then complain when they end.” “Cinnamon Tree,” written to cheer up a friend, celebrates platonic love, and Spalding’s belief that “the love between friends is just as important as romantic love.”</p>
<p> </p>
<p>“Crowned and Kissed,” with references to King Arthur and Midas, is about “the unsung royalty in your life, men and women who quietly, every day do the most honorable things, and who deserve to be honored even if they don’t end up with castles and thrones.” The edgy “Smile Like That” marks the moment a person realizes that his or her partner has developed other interests. “I’m saying, `Okay, I get it, let’s not beat around the bush,”’ Spalding explains.</p>
<p> </p>
<p>Her takes on the state of our country and our culture are equally fresh and insightful. “Vague Suspicions” confronts society’s short attention span and our habit of absorbing horrific events and celebrity gossip as part of the same media overload. The brief “Land Of The Free” speaks to the sinister system of false imprisonment by outlining the case of one innocent victim who spent 30 years in jail for a crime he did not commit.</p>
<p> </p>
<p>“Black Gold” is specifically addressed to young boys of color. “So much of our strength is drawn from resistance and endurance,” she explains, “but black pride didn’t just start with the slave trade. I wanted to address our nobility, going back to our incredible ancestors in pre-colonial Africa. I remember meetings when I was in elementary school about being strong as young black women, and I don’t think the boys had those meetings. This song is meant to speak to those young men, and I imagined it might one day be something that a parent could sing to his or her son.”</p>
<p> </p>
<p>Radio Music Society also features “City of Roses,” a celebration of her native Portland, Oregon that Spalding was commissioned to write by Banana Republic, and two cover tunes. Taking the advice of one of her mentors, tenor saxophone giant Joe Lovano: “When you do a classic, you have to find your own reason for doing it.” Spalding charges Stevie Wonder’s “I Can’t Help It” with the energy of apprehensive new love and adds original lyrics to Wayne Shorter’s “Endangered Species”.</p>
<p> </p>
<p>The music is realized by many of the brilliant musicians who are part of Spalding’s ever-expanding universe. In addition to longtime partners Lovano, keyboard player Leo Genovese and drummer Terri Lyne Carrington, the ranks contain jazz legends Jack DeJohnette and Billy Hart; guitar heroes Jef Lee Johnson and Lionel Loueke; an array of master vocalists including Algebra Blessett, Lalah Hathaway, Gretchen Parlato, Leni Stern and Becca Stevens; hip-hop giant Q-Tip (who performs on and co-produced two tracks); and two Portland-based musicians, Janice Scroggins and Dr. Thara Memory, who provided essential mentorship in Spalding’s youth.</p>
<p> </p>
<p>Four tracks feature the horn section of the American Music Program, a youth big band of musicians age 12 to 18 directed by her longtime mentor and teacher Dr. Memory, who conducts and provides horn arrangements; while the soulful pianist on “Hold on Me” is Ms. Scroggins, who Spalding studied with as a child. “Both of them are phenomenal artists who aren’t well known outside of the Northwest,” Spalding emphasizes. “Janice Scroggins was, quite honestly, too deep for me when I was eight years old. She unifies completely the sounds of gospel, blues and jazz, our American roots music. And Dr. Thara Memory, the teacher I came up through, has dedicated his life to spreading the message of this music. I had to have his youth band on the record, because they’re part of my Music Society, too.”</p>
<p> </p>
<p>Among its many strengths, Radio Music Society is a celebration of the men and women who have helped cultivate Spalding’s talent, as well as those who have nurtured her vision and inspired her along the way. “I’ve had the honor and blessing of working with so many phenomenal jazz musicians over the years,” she says. “As I’ve gotten to know them and their music, I’ve grown to love them as family and colleagues. I wished for an opportunity for us all to interpret songs together, so that they can be heard and received by a larger audience. All my personal heroes who are revered in the jazz world – like Joe Lovano and Terri Lyne Carrington – should be heard by a mainstream audience, because what they manifest in their music is so beautiful, sincere and uplifting. I think they literally bring good into the lives of the people who hear them. So I’ve tried to put together a program of music that speaks to the non-jazz listener, but can still provide a viable foundation for my jazz heroes to express themselves. Hopefully, people can enjoy all the elements of my music without being told which genres it is ‘supposedly’ a blend of. Everyone is invited to listen with no pre-conceived notions. It’s a journey. Think and feel for yourself. But, most importantly, ENJOY!”</p>
</p> |
|
|
|
|
|
<p class="product-promo-text"><span class="product-promo-header">FREE US shipping over $100!</span><span class="product-promo-body">Orders within next 2 days will be shipped on Monday</span></p> |
|
11.98000000 |
231M |
18 |
CS-Cart |
|
esperanza-spalding-radio-music-society |
228/231 |
|
|
|
|