Query time 0.00109
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "7.85"
},
"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": "3K"
},
"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": 3,
"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_systemsix`.`products_categories`.`category_id` = 222) and (`pankajecarter_systemsix`.`products_categories`.`product_id` <> 20))"
}
},
{
"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_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "34.13",
"cost_info": {
"read_cost": "2.00",
"eval_cost": "0.14",
"prefix_cost": "3.84",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"tracking",
"parent_product_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`products`.`parent_product_id` = 0) and ((`pankajecarter_systemsix`.`products`.`amount` > 0) or (`pankajecarter_systemsix`.`products`.`tracking` = 'D')) 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": "companies",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"pankajecarter_systemsix.products.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "50.00",
"cost_info": {
"read_cost": "0.68",
"eval_cost": "0.07",
"prefix_cost": "4.66",
"data_read_per_join": "2K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`pankajecarter_systemsix`.`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_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "27.76",
"using_index": true,
"cost_info": {
"read_cost": "0.36",
"eval_cost": "0.04",
"prefix_cost": "5.16",
"data_read_per_join": "4"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`prices`.`lower_limit` = 1) and (`pankajecarter_systemsix`.`prices`.`usergroup_id` in (0,0,1)))"
}
},
{
"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.43",
"eval_cost": "0.04",
"prefix_cost": "7.62",
"data_read_per_join": "7"
},
"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.19",
"eval_cost": "0.04",
"prefix_cost": "7.85",
"data_read_per_join": "1K"
},
"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> |
| 13 |
Your Idea, Inc. 12 Steps to Building a Million Dollar Business -- Starting Today! |
CS-Cart |
P |
0 |
<p style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;">
Every time a new story about how some nobody from nowhere got rich producing some clever new product in his garage, you may think, "Why can't I do that?" Well, anyone can--the trick is to take those good ideas and build them into great products that can succeed in the marketplace. In this book, you will get the 12-step plan you need to make your new product or service a profitable reality. You will learn important skills for success, including how to:
</p>
<ul style="text-align: left; color: #000000; font-size: 12px; background-color: #ffffff;">
<li style="text-align: left;">Refine their idea to attract a target audience</li>
<li style="text-align: left;">Research the competition</li>
<li style="text-align: left;">Find the right manufacturer</li>
<li style="text-align: left;">Create appropriate brand messaging</li>
<li style="text-align: left;">Build buzz online and beyond</li>
<li style="text-align: left;">Work trade shows and conventions</li>
</ul>
<p>
<span style="color: #000000; font-family: Arial, sans-serif; font-size: 12px; background-color: #ffffff;">Written by a woman with no formal business experience who turned her own idea into a million-dollar company, this book is the pragmatic yet inspiring guide every aspiring entrepreneur is looking for.</span>
</p> |