Query time 0.00434
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "40.34"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": true,
"buffer_result": {
"using_temporary_table": true,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "ALL",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 1,
"filtered": "50.00",
"cost_info": {
"read_cost": "2.29",
"eval_cost": "0.20",
"prefix_cost": "2.49",
"data_read_per_join": "8K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`pankajecarter_systemsix`.`companies`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 85,
"rows_produced_per_join": 3,
"filtered": "4.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "19.80",
"eval_cost": "0.68",
"prefix_cost": "22.97",
"data_read_per_join": "11K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`pankajecarter_systemsix`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemsix`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemsix`.`cscart_categories`.`usergroup_ids`)) and (`pankajecarter_systemsix`.`cscart_categories`.`status` in ('A','H')) and (`pankajecarter_systemsix`.`cscart_categories`.`storefront_id` in (0,1)))"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemsix.cscart_categories.category_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 6,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "3.54",
"eval_cost": "1.36",
"prefix_cost": "27.87",
"data_read_per_join": "108"
},
"used_columns": [
"product_id",
"category_id"
],
"attached_condition": "(`pankajecarter_systemsix`.`products_categories`.`product_id` <> 199)"
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "8.82",
"cost_info": {
"read_cost": "6.80",
"eval_cost": "0.12",
"prefix_cost": "36.03",
"data_read_per_join": "3K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`products`.`company_id` = `pankajecarter_systemsix`.`companies`.`company_id`) and ((`pankajecarter_systemsix`.`products`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemsix`.`products`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemsix`.`products`.`usergroup_ids`)) and (`pankajecarter_systemsix`.`products`.`status` = 'A') and (`pankajecarter_systemsix`.`products`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "3.08",
"index_condition": "((`pankajecarter_systemsix`.`prices`.`lower_limit` = 1) and (`pankajecarter_systemsix`.`prices`.`usergroup_id` in (0,0,1)))",
"cost_info": {
"read_cost": "1.52",
"eval_cost": "0.01",
"prefix_cost": "37.79",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`prices`.`price` >= 28.48) and (`pankajecarter_systemsix`.`prices`.`price` <= 31.48))"
}
},
{
"table": {
"table_name": "prices_2",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "9.25",
"not_exists": true,
"cost_info": {
"read_cost": "0.09",
"eval_cost": "0.00",
"prefix_cost": "37.90",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(prices_2), isnull(`pankajecarter_systemsix`.`prices_2`.`price`), true) and <if>(is_not_null_compl(prices_2), ((`pankajecarter_systemsix`.`prices_2`.`lower_limit` = 1) and (`pankajecarter_systemsix`.`prices_2`.`price` < `pankajecarter_systemsix`.`prices`.`price`) and (`pankajecarter_systemsix`.`prices_2`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "epd",
"access_type": "ALL",
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "33.33",
"not_exists": true,
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "2.42",
"eval_cost": "0.00",
"prefix_cost": "40.33",
"data_read_per_join": "0"
},
"used_columns": [
"product_id"
],
"attached_condition": "(<if>(found_match(epd), isnull(`pankajecarter_systemsix`.`epd`.`product_id`), true) and <if>(is_not_null_compl(epd), (`pankajecarter_systemsix`.`epd`.`product_id` = `pankajecarter_systemsix`.`products_categories`.`product_id`), true))"
}
},
{
"table": {
"table_name": "descr1",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"pankajecarter_systemsix.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.01",
"eval_cost": "0.00",
"prefix_cost": "40.34",
"data_read_per_join": "37"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"full_description"
]
}
}
]
}
}
}
}
}
Result
| product_id |
product |
company_name |
price |
product_ids |
product_types |
parent_product_ids |
product_type |
parent_product_id |
full_description |
| 11 |
Collegiate 72 Tee |
CS-Cart |
30.00000000 |
11 |
P |
0 |
P |
0 |
<p>It's not how old you are, it's how stylish, and this men's adidas Originals Collegiate 72 Tee shirt feels just as fresh as it was the day the Trefoil was born in 1972. That's why this t-shirt features a collegiate "72" on the front.</p> |
| 195 |
Crossroads Guitar Festival 2010 (2DVD) |
CS-Cart |
29.99000000 |
195 |
P |
0 |
P |
0 |
<p>
<p>2DVD edition of the 2010 Crossroads Guitar Festival. Featuring: Eric Clapton, Jeff Beck,Sheryl Crow,Vince Gill, Buddy Guy, B.B. King,John Mayer, Bill Murray,Steve Winwood,Ronnie Wood, ZZ Top,and more PLUS behind-the-scenes footage and interviews.</p>
<p> </p>
<p>DVD 1</p>
<p> </p>
<p>01 Promise Land - By Sonny Landreth with Eric Clapton</p>
<p>02 Z. Rider - By Sonny Landreth with Eric Clapton</p>
<p>03 Traveling Shoes - By Robert Randolph & The Family Band</p>
<p>04 Going Down - By Pino Daniele, Joe Bonamassa, Robert Randolph & The Family Band</p>
<p>05 Killing Floor - By Robert Cray with Jimmie Vaughan & Hubert Sumlin</p>
<p>06 Six Strings Down - By Jimmie Vaughan with Robert Cray & Hubert Sumlin</p>
<p>07 Waiting For The Bus - By ZZ Top</p>
<p>08 Jesus Just Left Chicago - By ZZ Top</p>
<p>09 Gypsy Blood - By Doyle Bramhall II</p>
<p>10 In My Time Of Dying (Jesus Make Up My Dying Bed) - By Doyle Bramhall II</p>
<p>11 Bright Lights - By Gary Clark Jr.</p>
<p>12 Long Road Home - By Sheryl Crow with Derek Trucks, Susan Tedeschi, Doyle Bramhall II & Gary Clark Jr.</p>
<p>13 Our Love Is Fading - By Sheryl Crow with Eric Clapton, Doyle Bramhall II & Gary Clark Jr.</p>
<p>14 Blackwaterside - By Bert Jansch</p>
<p>15 Mississippi Blues - By Stefan Grossman & Keb' Mo'</p>
<p>16 Roll And Tumble Blues - By Stefan Grossman</p>
<p>17 One More Last Chance - By Vince Gill with Keb' Mo', James Burton, Earl Klugh & Albert Lee</p>
<p>18 Mystery Train - By Vince Gill with James Burton, Albert Lee, Keb' Mo' & Earl Klugh</p>
<p>19 Lay Down Sally - By Vince Gill with Sheryl Crow, Keb' Mo', Albert Lee, James Burton & Earl Klugh</p>
<p>20 Angelina - By Earl Klugh</p>
<p>21 Vonetta - By Earl Klugh</p>
<p>22 Who Did You Think I Was - By John Mayer Trio</p>
<p>23 Ain't No Sunshine - By John Mayer Trio</p>
<p> </p>
<p>DVD 2</p>
<p> </p>
<p>01 Midnight In Harlem - By Derek Trucks & Susan Tedeschi Band</p>
<p>02 Coming Home - By Derek Trucks & Susan Tedeschi Band with Warren Haynes</p>
<p>03 Soulshine - By Warren Haynes</p>
<p>04 Don't Keep Me Wondering - By David Hidalgo & Cesar Rosas with Derek Trucks</p>
<p>05 Space Captain - By Derek Trucks & Susan Tedeschi Band with Warren Haynes, David Hidalgo, Cesar Rosas & Chris Stainton</p>
<p>06 Five Long Years - By Buddy Guy with Jonny Lang & Ronnie Wood</p>
<p>07 Miss You - By Buddy Guy with Jonny Lang & Ronnie Wood</p>
<p>08 Hammerhead - By Jeff Beck</p>
<p>09 Nessun Dorma - By Jeff Beck</p>
<p>10 Crossroads</p>
<p>11 Hands Of The Saints - By Citizen Cope & Eric Clapton</p>
<p>12 I Shot The Sheriff</p>
<p>13 Shake Your Money Maker - By Eric Clapton & Jeff Beck</p>
<p>14 Had To Cry Today - By Steve Winwood & Eric Clapton</p>
<p>15 Voodoo Chile - By Eric Clapton & Steve Winwood</p>
<p>16 Dear Mr. Fantasy - By Steve Winwood & Eric Clapton</p>
<p>17 The Thrill Is Gone - By B.B. King & Ensemble</p>
<div></div>
</p> |
| 104 |
Final Destination 5 (Blu-ray) |
CS-Cart |
29.95000000 |
104 |
P |
0 |
P |
0 |
<p>
<p>Studio: Warner Bros.</p>
<p>Theatrical Release Date: 08/11/2011</p>
<p>Special Features:</p>
<p>- Now includes Instant Streaming with UltraViolet Digital Copy</p>
<p>MUST REDEEM DIGITAL COPY OFFER BY 12/27/2013</p>
<p>- Circle of Death</p>
<p>- Alternate Death Scenes</p>
<p>- Visual Effects of Death: Collapsing Bridge</p>
<p>- Visual Effects of Death: Airplane Crash</p>
<p>Packaging Type: O-Sleeve BD Case</p>
<p>Copyright:</p>
<p>© 2011 New Line Productions, Inc.</p>
<p>Genre: Horror</p>
<p>Synopsis:</p>
<p>Death is just as omnipresent as ever, and in Final Destination 5 it strikes again. During the bus ride to a corporate retreat, Sam (Nicholas D’Agosto) has a premonition in which he and most of his friends — as well as numerous others — die in a horrific bridge collapse. When his vision ends, events begin to mirror what he had seen, and he frantically ushers as many of his colleagues — including his friend, Peter (Miles Fisher), and girlfriend, Molly (Emma Bell) — away from the disaster before Death can claim them. But these unsuspecting souls were never supposed to survive, and in a terrifying race against time, the ill-fated group tries to discover a way to escape Death’s sinister agenda.</p>
</p> |