Query time 0.00760
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.30"
},
"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": 6,
"rows_produced_per_join": 1,
"filtered": "16.67",
"cost_info": {
"read_cost": "3.27",
"eval_cost": "0.20",
"prefix_cost": "3.47",
"data_read_per_join": "7K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "((`atulecarter_atul_demo1`.`companies`.`status` = 'A') and (`atulecarter_atul_demo1`.`companies`.`company_id` in ('1','2','3','4','5','6')))"
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 86,
"rows_produced_per_join": 3,
"filtered": "4.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "20.01",
"eval_cost": "0.69",
"prefix_cost": "24.16",
"data_read_per_join": "8K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`atulecarter_atul_demo1`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo1`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo1`.`cscart_categories`.`usergroup_ids`)) and (`atulecarter_atul_demo1`.`cscart_categories`.`status` in ('A','H')) and (`atulecarter_atul_demo1`.`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": [
"atulecarter_atul_demo1.cscart_categories.category_id"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 10,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "3.63",
"eval_cost": "2.06",
"prefix_cost": "29.85",
"data_read_per_join": "165"
},
"used_columns": [
"product_id",
"category_id"
],
"attached_condition": "(`atulecarter_atul_demo1`.`products_categories`.`product_id` <> 192)"
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"atulecarter_atul_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "10.32",
"eval_cost": "0.10",
"prefix_cost": "42.24",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`products`.`company_id` = `atulecarter_atul_demo1`.`companies`.`company_id`) and ((`atulecarter_atul_demo1`.`products`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo1`.`products`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo1`.`products`.`usergroup_ids`)) and (`atulecarter_atul_demo1`.`products`.`status` = 'A') and (`atulecarter_atul_demo1`.`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": [
"atulecarter_atul_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "3.26",
"index_condition": "((`atulecarter_atul_demo1`.`prices`.`lower_limit` = 1) and (`atulecarter_atul_demo1`.`prices`.`usergroup_id` in (0,0,1)))",
"cost_info": {
"read_cost": "1.56",
"eval_cost": "0.01",
"prefix_cost": "44.10",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`prices`.`price` >= 14.25) and (`atulecarter_atul_demo1`.`prices`.`price` <= 15.75))"
}
},
{
"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": [
"atulecarter_atul_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "9.74",
"not_exists": true,
"cost_info": {
"read_cost": "0.15",
"eval_cost": "0.00",
"prefix_cost": "44.29",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(prices_2), isnull(`atulecarter_atul_demo1`.`prices_2`.`price`), true) and <if>(is_not_null_compl(prices_2), ((`atulecarter_atul_demo1`.`prices_2`.`lower_limit` = 1) and (`atulecarter_atul_demo1`.`prices_2`.`price` < `atulecarter_atul_demo1`.`prices`.`price`) and (`atulecarter_atul_demo1`.`prices_2`.`usergroup_id` in (0,0,1))), 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": [
"atulecarter_atul_demo1.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": "44.30",
"data_read_per_join": "68"
},
"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 |
| 114 |
Birds of Prey: The Complete Series (DVD) |
CS-Cart |
14.99000000 |
114 |
P |
0 |
P |
0 |
<p>
<p>Studio: Warner Bros.</p>
<p>Screen Aspect: 4 X 3 FULL FRAME</p>
<p>Episodes Info :</p>
<p>13 One-Hour Episodes</p>
<p> </p>
<p>Pilot</p>
<p>Slick</p>
<p>Prey for the Hunter</p>
<p>Three Birds and a Baby</p>
<p>Sins of the Mother</p>
<p>Primal Scream</p>
<p>Split</p>
<p>Lady Shiva</p>
<p>Nature of the Beast</p>
<p>Gladiatrix</p>
<p>Reunion</p>
<p>Feat of Clay</p>
<p>Devil's Eye</p>
<p>Special Features:</p>
<p>GOTHAM GIRLS SEASONS 1-3 - The animated web-based series featuring the</p>
<p>female heroes and rogues from Gotham City.</p>
<p>Media Quantity: Multi D</p>
<p>Packaging Type: VIVA 4 Disc 15mm Case</p>
<p>Genre: Drama, Television</p>
<p>Synopsis:</p>
<p>Who will stand up to villains now that a heartbroken Dark Knight has mysteriously vanished? Never fear, New Gothamites, a trio of champions is ready to take wing – and Helena, the daughter of Batman and Catwoman, is among them. She calls herself Huntress and crime is her prey. Teenaged Dinah is the youngest of the group, learning as she goes and gifted in clairvoyance. And overseeing the awesome threesome’s high-tech nerve center is Batgirl. Left wheelchair-bound by The Joker, she has reinvented herself as Oracle, the team’s cyber expert. Huntress, Dinah, Oracle: They are the Birds of Prey. Fighting together. Living together. And soaring into adventure together in 13 breathtaking live-action episodes.</p>
</p> |
| 197 |
Guitar Man Album Artwork |
CS-Cart |
14.98000000 |
197,197 |
P,P |
0,0 |
P |
0 |
<p>
<p>Guitar Man CD</p>
<p>George Benson - Guitar Man</p>
<p>AUDIO TRACKS:</p>
<p>- Tenderly</p>
<p>- I Want To Hold Your Hand</p>
<p>- My Cherie Amour</p>
<p>- Naima</p>
<p>- Tequila</p>
<p>- Don't Know Why</p>
<p>- Lady In My Life</p>
<p>- My One And Only Love</p>
<p>- Paper Moon</p>
<p>- Danny Boy</p>
<p>- Since I Fell For You</p>
<p>- Fingerlero</p>
<p>FILE:</p>
<p>- George Benson - Guitar Man Digital Album Booklet</p>
<p>George Benson - Guitar Man (Exclusive Bonus Tracks)</p>
<p>AUDIO TRACKS:</p>
<p>- Somewhere</p>
<p>- Maria</p>
<p>MERCHANDISE:</p>
<p>- Guitar Man CD</p>
<p>Type: CD</p>
</p> |
| 97 |
Harry Potter and the Deathly Hallows - Part 2 (Blu-ray+DVD+UltraViolet Digital Copy Combo Pack) |
CS-Cart |
14.99000000 |
97 |
P |
0 |
P |
0 |
<p>
<p>Studio: Warner Bros.</p>
<p>Theatrical Release Date: 07/14/2011</p>
<p>Special Features:</p>
<p>- Disc 1 (Blu-ray): Feature Film and Maximum Movie Mode</p>
<p>- Disc 2 (Blu-ray): Special Features</p>
<p>- Disc 3: (DVD): Standard definition version of the film Also includes an UltraViolet Digital Copy for Instant Streaming (redeemed</p>
<p>via in-packed insert)</p>
<p> </p>
<p>• Maximum Movie Mode hosted by Matthew Lewis (Neville Longbottom) and other cast members - As the epic showdown between Harry</p>
<p>Potter and Lord Voldemort approaches, don’t miss a single detail as the forces of Good and Evil clash one final time throughout the</p>
<p>grounds of Hogwarts.</p>
<p>• A Conversation with JK Rowling and Daniel Radcliffe - Join J.K. Rowling and Daniel Radcliffe for an exclusive conversation</p>
<p>about bringing the character of Harry Potter to life, the last decade of films and how their lives have changed by the fame that</p>
<p>they’ve both experienced.</p>
<p>• The Goblins of Gringotts - Hosted by Warwick Davis, you’ll see the entire process of becoming a goblin” on a Harry Potter</p>
<p>film, from auditions and casting to makeup and prosthetic tests as well as filming the final scenes.</p>
<p>• The Women of Harry Potter – A look at the remarkable women in Harry Potter’s life and the critical role they play in the</p>
<p>films.</p>
<p>• Warner Bros. Leavesden Studios Sneak Peek</p>
<p>• Deleted Scenes </p>
<p> </p>
<p>Packaging Type: O-Sleeve 3-disc Elite BD Case</p>
<p>Copyright:</p>
<p>© 2011 Warner Bros. Ent. Harry Potter Publishing Rights © J.K.R. Harry Potter characters, names and related indicia are trademarks of and © Warner Bros. Ent. All Rights Reserved.</p>
<p>Genre: Drama, Fantasy Adventure, Mystery</p>
<p>Synopsis:</p>
<p>In the epic finale, the battle between the good and evil forces of the wizarding world escalates into an all-out war. The stakes have never been higher and no one is safe. But it is Harry who may be called upon to make the ultimate sacrifice as he draws closer to the climactic showdown with Lord Voldemort. It all ends here.</p>
</p> |