Query time 0.01005
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` <> 34)"
}
},
{
"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` >= 23.75) and (`atulecarter_atul_demo1`.`prices`.`price` <= 26.25))"
}
},
{
"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 |
| 103 |
Fringe: The Complete Third Season (Blu-Ray) |
CS-Cart |
23.99000000 |
103 |
P |
0 |
P |
0 |
<p>
<p>Studio: Warner Bros.</p>
<p>Screen Aspect: 16 X 9 FULL FRAME</p>
<p>Run Time: 1012 minutes</p>
<p>Episodes Info :</p>
<p>Olivia</p>
<p>The Box</p>
<p>The Plateau</p>
<p>Do Shapeshifters Dream of Electric Sheep?</p>
<p>Amber 31422</p>
<p>6955 kHz</p>
<p>The Abducted…</p>
<p>Entrada</p>
<p>Marionette</p>
<p>The Firefly</p>
<p>Reciprocity</p>
<p>Concentrate and Ask Again</p>
<p>Immortality</p>
<p>6 B</p>
<p>Subject 13</p>
<p>Os</p>
<p>Stowaway</p>
<p>Bloodline</p>
<p>Lysergic Acid Diethylamide</p>
<p>6:02 AM EST</p>
<p>The Last Sam Weiss</p>
<p>The Day We Died</p>
<p>Special Features:</p>
<p>Duality of Worlds: Four featurettes exploring The Other You, Visualizing an Alternate World, A Machine of Destiny and The Psychology</p>
<p>of Duality</p>
<p>Animating the “Lysergic Acid Diethylamide” Episode</p>
<p>Constructing an Extrasensory Soundscape</p>
<p>BLU-RAY EXCLUSIVE – Glimmer to the Other Side</p>
<p>Experience “Os” (Episode 316) in Selectable Maximum Episode Mode with Pop-Up Experience-Enhancing Commentaries and Featurettes</p>
<p>Commentary on “The Plateau” with Monica Owusu-Breen, Jeff Pinkner and Timothy Good</p>
<p>Commentary on “Lysergic Acid Diethylamide” with Jay Worth, Luyen Vu, and Tanya Swerling</p>
<p>Unusual Side Effects: Gag Reel</p>
<p>Trailers</p>
<p>Packaging Type: O-Sleeve BD Case</p>
<p>Subtitle Languages:</p>
<p>Danish</p>
<p>English SDH</p>
<p>Finnish</p>
<p>French</p>
<p>Norwegian</p>
<p>Portuguese</p>
<p>Spanish</p>
<p>Swedish</p>
<p>Copyright:</p>
<p>FRINGE and all related characters and elements are trademarks of and © Warner Bros. Entertainment Inc.</p>
<p>Genre: Drama, Television</p>
<p>Synopsis:</p>
<p>Immersive. Compelling. Hypnotic. Brilliantly imaginative. Endlessly thrilling. Pick your term. The mystery of the universes deepens in the critically acclaimed 22-episode third season of television’s most exciting sci-fi. The Fringe team escapes from the parallel universe – except for Olivia, trapped in the other world and replaced in ours by her double, who turns Peter and Olivia’s tentative relationship into a love affair. Then Olivia returns, bonds of trust fray, ever more bizarre and terrifying phenomena occur and secrets that stretch back to 1985 threaten to destroy our universe. Or theirs. “Fringe continues its hot streak known as Season 3. It’s been firing on all cylinders all season” (Andrew Hanson, LATimes.com).</p>
</p> |
| 44 |
U.S. History and Government, Second Edition |
CS-Cart |
25.00000000 |
44 |
P |
0 |
P |
0 |
<p>
<p style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 17px;"><span style="color: #996633; font-family: Georgia, 'Times New Roman', Times, serif; font-size: x-small;"><strong>Purpose:</strong></span></p>
<p style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 17px;"><span style="color: #996633; font-family: Georgia, 'Times New Roman', Times, serif; font-size: x-small;">To provide students taking the 11th-grade New York State course in U.S. history and government and the Regents examination, as well as others taking a similar course, with a concise and comprehensive text. <br /></span></p>
<ul style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 17px;" type="square">
<span style="color: #996633; font-family: Georgia, 'Times New Roman', Times, serif; font-size: x-small;"><strong>Text features include:</strong>
<li>introduction to U.S. geography with an emphasis on how geography has shaped the American experience</li>
<li>summary of the founding, principles, and operations of the U.S. government . lucid historical narrative</li>
<li>emphasis on the modern period</li>
<li>primary source readings in every chapter</li>
<li>emphasis on the experiences and contributions of women and minorities</li>
<li>mid-chapter “in Review” features</li>
<li>end-of-chapter exercises: multiple-choice, thematic-essay, and document-based questions</li>
<li>more maps, charts, and tables</li>
<li>expanded coverage of U.S. Supreme Court landmark cases</li>
<li>“The American People: Changes at the Millennium” - a demographic feature in the last chapter</li>
<li>appendix: annotated Declaration of Independence and U.S. Constitution.</li>
<li>Teacher’s Manual With Answers has guidelines for class presentation of each chapter, answer key, Student’s Study Guide.</li>
<li>Hardbound</li>
</span>
</ul>
</p> |