Query time 0.00911
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` <> 35)"
}
},
{
"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` >= 30.39) and (`atulecarter_atul_demo1`.`prices`.`price` <= 33.59))"
}
},
{
"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 |
| 31 |
Nike Classic Solid Women's Jersey Shorts |
CS-Cart |
32.00000000 |
31 |
P |
0 |
P |
0 |
<div class="text dark-grey-heather-white description">
<div class="product-description-component">
<p><strong>The Nike Classic Women's Shorts: Versatile comfort</strong></p>
<br />
<p>With a simple and sporty design, the comfortable Nike Classic Solid Women's Jersey Shorts are a must-have for every gym bag.</p>
<br />
<p><strong>Benefits</strong></p>
<li>Elastic waist with drawcord for an athletic fit</li>
<li>Vented hem for a full range of motion</li>
<br />
<p><strong>Additional Details</strong></p>
<li>Fabric: 61% cotton/33% polyester/6% spandex</li>
<li>Machine wash</li>
<li>Imported</li>
</div>
</div> |
| 118 |
Smallville: The Complete Tenth Season |
CS-Cart |
30.99000000 |
118 |
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>Lazarus</p>
<p>Shield</p>
<p>Supergirl</p>
<p>Homecoming</p>
<p>Isis</p>
<p>Harvest</p>
<p>Ambush</p>
<p>Abandoned</p>
<p>Patriot</p>
<p>Luthor</p>
<p>Icarus</p>
<p>Collateral</p>
<p>Beacon</p>
<p>Masquerade</p>
<p>Fortune</p>
<p>Scion</p>
<p>Kent</p>
<p>Booster</p>
<p>Dominion</p>
<p>Prophecy</p>
<p>Finale Part 1</p>
<p>Finale Part 2</p>
<p>Special Features:</p>
<p>Commentaries on 2 Key Episodes</p>
<p>Unaired Scenes</p>
<p>Smallville: Coming Home: Cast and Creators Reflect on the Landmark 200th Episode Homecoming, in Which Clark Kent Experiences</p>
<p>Transformative Events on the Way to His Final Destiny</p>
<p>My Fathers, My Son: How Clark Kent’s Fathers/Son Relationships Evolved over the Series’ 10 Years</p>
<p>How Do We Do Music Video</p>
<p>Media Quantity: Multi D</p>
<p>Packaging Type: VIVA 6 Disc 25mm Case</p>
<p>Subtitle Languages:</p>
<p>Chinese</p>
<p>French</p>
<p>Portuguese</p>
<p>Spanish</p>
<p>Copyright:</p>
<p>SMALLVILLE and all related characters and elements are trademarks of and © DC Comics.</p>
<p>Genre: Drama, Television</p>
<p>Synopsis:</p>
<p>The series that redefines the origins of the world’s greatest hero reaches its powerful conclusion with more revelations, more fascinating characters from DC Comics lore and a mind-blowing, spirit-lifting finale that is everything fans could want. In this 22-Episode Season 10, super heroes emerge from the shadows, only to be driven underground by a public that labels them vigilantes. At the same time, otherworld forces of darkness gather, presenting Clark Kent with the greatest challenge of his young life. The world he calls home and the people he loves – including Lois Lane, who now shares his secret and his life – need a champion. They shall have one. Don’t miss all the hopes, heartaches and heroics of a final season to remember. They will lift you up, up and away.</p>
</p> |