Query time 0.00104
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.37"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_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": "2K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
]
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 2,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.04",
"eval_cost": "0.40",
"prefix_cost": "1.44",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"category_id"
],
"attached_condition": "((`pankajecarter_systemfive`.`products_categories`.`category_id` = 222) and (`pankajecarter_systemfive`.`products_categories`.`product_id` <> 13))"
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status",
"idx_parent_product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemfive.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "33.63",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.13",
"prefix_cost": "3.84",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"tracking",
"parent_product_id"
],
"attached_condition": "((`pankajecarter_systemfive`.`products`.`parent_product_id` = 0) and ((`pankajecarter_systemfive`.`products`.`amount` > 0) or (`pankajecarter_systemfive`.`products`.`tracking` = 'D')) and ((`pankajecarter_systemfive`.`products`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemfive`.`products`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemfive`.`products`.`usergroup_ids`)) and (`pankajecarter_systemfive`.`products`.`status` = 'A') and (`pankajecarter_systemfive`.`products`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "companies",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"pankajecarter_systemfive.products.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "50.00",
"cost_info": {
"read_cost": "0.67",
"eval_cost": "0.07",
"prefix_cost": "4.65",
"data_read_per_join": "2K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`pankajecarter_systemfive`.`companies`.`status` = 'A')"
}
},
{
"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_systemfive.products_categories.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "29.03",
"using_index": true,
"cost_info": {
"read_cost": "0.35",
"eval_cost": "0.04",
"prefix_cost": "5.13",
"data_read_per_join": "4"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`pankajecarter_systemfive`.`prices`.`lower_limit` = 1) and (`pankajecarter_systemfive`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"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_systemfive.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.20",
"eval_cost": "0.04",
"prefix_cost": "5.37",
"data_read_per_join": "912"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"full_description"
]
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 17 |
101 Things Everyone Should Know About Economics A Down and Dirty Guide to Everything from Securities and Derivatives to Interest Rates and Hedge Funds—And What They Mean For You |
CS-Cart |
P |
0 |
<p><span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">What you don't know about economics can hurt you—now more than ever. This easy-to-understand guide answers all the questions you need to know to secure your financial future, such as:</span></p>
<ul style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;">
<li style="text-align: left;">What does it mean to my paycheck when the Fed lowers or raises interest rates?</li>
<li style="text-align: left;">What's the difference between bonds, securities, and derivatives—and which should I invest in now?</li>
<li style="text-align: left;">What does Keynesian economics have to do with my savings?</li>
</ul>
<p><span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">For those people whose heads spin when reading the business pages of the newspaper, here's a roadmap through the economic jungle. In simple, plain language, Peter Sander explains how economies work, why they grow, how they contract, and what the government can and can't do to help them. Most important, he tells you how all this affects </span><em style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">you</em><span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">—and what kind of changes you're going to see in your finances as a result.</span></p>
<p style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;">Economics has been called the "dismal" science. But it doesn't need to be gloomy or impenetrable. This book is an essential guide for anyone who wants to understand where the economy is today, where it's going, and what it means for the rest of us.</p>
<p> </p> |
| 20 |
The ABCs of Gold Investing. How to Protect and Build Your Wealth with Gold |
CS-Cart |
P |
0 |
<p><em style="color: #000000; font-family: Verdana; background-color: #ffffff; font-size: small;"><strong>The ABCs of Gold Investing</strong></em><span style="color: #000000; font-family: Verdana; background-color: #ffffff; font-size: small;"> (Second Edition) is a solid resource for investors wishing to understand the benefits of private gold ownership. In this reader-friendly book, author Michael J. Kosares addresses the rapid changes in both the American and world economies and explains why gold is important to you as an investor. And, with thirty years experience in the gold business, he can tell you how to add gold to your portfolio in a safe and economical manner.</span></p> |