Query time 0.00122
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "21.77"
},
"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": "companies",
"access_type": "ALL",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 5,
"rows_produced_per_join": 1,
"filtered": "20.00",
"cost_info": {
"read_cost": "3.05",
"eval_cost": "0.20",
"prefix_cost": "3.25",
"data_read_per_join": "6K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`atulecarter_atul_demo2`.`companies`.`status` = 'A')"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 11,
"rows_produced_per_join": 11,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.25",
"eval_cost": "2.20",
"prefix_cost": "6.70",
"data_read_per_join": "176"
},
"used_columns": [
"product_id",
"category_id"
]
}
},
{
"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": [
"atulecarter_atul_demo2.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.47",
"cost_info": {
"read_cost": "11.00",
"eval_cost": "0.12",
"prefix_cost": "19.90",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`atulecarter_atul_demo2`.`products`.`company_id` = `atulecarter_atul_demo2`.`companies`.`company_id`) and (`atulecarter_atul_demo2`.`products`.`parent_product_id` = 0) and ((`atulecarter_atul_demo2`.`products`.`usergroup_ids` = '') or find_in_set(0,`atulecarter_atul_demo2`.`products`.`usergroup_ids`) or find_in_set(1,`atulecarter_atul_demo2`.`products`.`usergroup_ids`)) and (`atulecarter_atul_demo2`.`products`.`status` = 'A') and (`atulecarter_atul_demo2`.`products`.`product_type` <> 'D'))"
}
},
{
"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_demo2.products_categories.product_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.60",
"eval_cost": "0.12",
"prefix_cost": "20.62",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"full_description"
]
}
},
{
"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_demo2.products_categories.product_id"
],
"rows_examined_per_scan": 4,
"rows_produced_per_join": 2,
"filtered": "98.35",
"using_index": true,
"cost_info": {
"read_cost": "0.66",
"eval_cost": "0.47",
"prefix_cost": "21.77",
"data_read_per_join": "56"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`atulecarter_atul_demo2`.`prices`.`lower_limit` = 1) and (`atulecarter_atul_demo2`.`prices`.`usergroup_id` in (0,0,1)))"
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 11 |
Collegiate 72 Tee |
CS-Cart test |
P |
0 |
<p>It's not how old you are, it's how stylish, and this men's adidas Originals Collegiate 72 Tee shirt feels just as fresh as it was the day the Trefoil was born in 1972. That's why this t-shirt features a collegiate "72" on the front.</p> |
| 15 |
Nike Chambray Super Runner Men's Jacket |
ACME Corp |
P |
0 |
<div class="text description black-white">
<div class="product-description-component">
<p><strong>The Nike Chambray Super Runner Jacket: A durable, updated classic </strong></p>
<br />
<p>The timeless Windrunner design gets a premium upgrade in the Nike Chambray Super Runner Men's Jacket. Created with tough, water-resistant fabric and a mesh lining, this jacket combines breathability and protection from the elements.</p>
<br />
<p><strong>Benefits</strong></p>
<li>Hood with drawcord for an adjustable fit</li>
<li>Overlay at yoke and raglan sleeves for style and enhanced protection</li>
<li>Rib cuffs and hem for a fit that stays in place</li>
<li>Mesh lining for enhanced ventilation</li>
<li>Durable, wind-resistant fabric to protect against the elements</li>
<br />
<p><strong>Additional Details</strong></p>
<li>Side zip pockets for secure storage</li>
<li>Fabric: Body: 100% cotton. Lining and overlay: 100% polyester.</li>
<li>Machine wash</li>
<li>Imported</li>
</div>
</div> |
| 280 |
T-shirt, Color: Black |
CS-Cart test |
P |
0 |
|
| 282 |
T-shirt, Color: Blue |
CS-Cart test |
P |
0 |
|
| 278 |
T-shirt, Color: White |
CS-Cart test |
P |
0 |
|
| 7 |
Trefoil Hoodie |
CS-Cart test |
P |
0 |
<p>The adidas Originals Trefoil Hoodie has been a streetwear essential for decades, with its characteristic big hood, kangaroo pocket and large Trefoil. Now it's your turn to join the Trefoil men's hoodie crew and carry the legend forward.</p> |