Query time 0.00155
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "13.21"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"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": "7K"
},
"used_columns": [
"company_id",
"status",
"company"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"rows_examined_per_scan": 5,
"rows_produced_per_join": 0,
"filtered": "4.00",
"index_condition": "(`atulecarter_atul_demo1`.`cscart_categories`.`category_id` in (223,224,225,226,227))",
"cost_info": {
"read_cost": "11.97",
"eval_cost": "0.04",
"prefix_cost": "12.01",
"data_read_per_join": "534"
},
"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": 0,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.21",
"eval_cost": "0.12",
"prefix_cost": "12.34",
"data_read_per_join": "9"
},
"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_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "8.52",
"cost_info": {
"read_cost": "0.60",
"eval_cost": "0.01",
"prefix_cost": "13.06",
"data_read_per_join": "250"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`products`.`parent_product_id` = 0) and (`atulecarter_atul_demo1`.`products`.`company_id` = 1) 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": "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.05",
"eval_cost": "0.01",
"prefix_cost": "13.12",
"data_read_per_join": "238"
},
"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_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "97.36",
"using_index": true,
"cost_info": {
"read_cost": "0.05",
"eval_cost": "0.03",
"prefix_cost": "13.21",
"data_read_per_join": "3"
},
"used_columns": [
"product_id",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`prices`.`lower_limit` = 1) and (`atulecarter_atul_demo1`.`prices`.`usergroup_id` in (0,0,1)))"
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 31 |
Nike Classic Solid Women's Jersey Shorts |
CS-Cart |
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> |
| 38 |
Nike Futura Unravel Women's T-Shirt |
CS-Cart |
P |
0 |
<div class="text black-gold description">
<div class="product-description-component">
<p><strong>The Nike Futura Shirt: A flattering fit with bold pops of color</strong></p>
<br />
<p>It's a style explosion in the Nike Futura Unravel Women's T-Shirt, a high-energy essential with a flattering design and playful bursts of color.</p>
<br />
<p><strong>Benefits</strong></p>
<li>Extended rib V-neck for a flattering, comfortable fit</li>
<li>Reflective screen-print at front for a pop of color</li>
<li>A slim fit that's contoured to your body</li>
<br />
<p><strong>Additional Details</strong></p>
<li>Fabric: 100% cotton</li>
<li>Machine wash</li>
<li>Imported</li>
</div>
</div> |
| 80 |
Nike Tenkay Slip TXTL Women's Shoe |
CS-Cart |
P |
0 |
<div class="black-white-black-white text description">
<div class="product-description-component">
<p><strong>The Nike Tenkay Slip TXTL: Casual-cool with a sporty side</strong></p>
Versatile and super comfortable, the Nike Tenkay Slip TXTL Women's Shoe looks as good as it feels. With a soft textile upper and a durable rubber outsole, this shoe provides excellent traction on a variety of surfaces.<br />
<p><strong>Benefits</strong></p>
<li>Textile upper with suede overlays for a comfortable fit</li>
<li>Elastic slip-on entry for easy on and off</li>
<li>Flex grooves at outsole for enhanced flexibility</li>
<br />
<p><strong>Additional Details</strong></p>
<li>Removable ankle strap for a versatile fit</li>
<li>Rubber outsole for durability</li>
</div>
</div> |
| 102 |
PR 100 Women's White Quartz Watch |
CS-Cart |
P |
0 |
<p>Unrivaled best seller that is true to its name, the PR 100 is certainly precise and hugely popular.<br /> <br /> A combination of tradition with up-to-the-minute looks using quality materials on the outside and Swiss reliability on the inside. This ironic watch family offers lady and gent sizes to prevent any rivalry, although as far as style is concerned, the race is on! The Swiss made quartz ETA movement has battery end-of-life indicator, a scratch resistant sapphire crystal and date indicator. Features include a stainless steel bracelet, a magnificent white dial, and water resistance up to 100 meters.</p> |
| 28 |
Run Perf 7/8 Ti |
CS-Cart |
P |
0 |
<p>adidas Run Perf 7/8 Ti , new to site, more details coming soon.</p> |
| 280 |
T-shirt, Color: Black |
CS-Cart |
P |
0 |
|
| 282 |
T-shirt, Color: Blue |
CS-Cart |
P |
0 |
|
| 278 |
T-shirt, Color: White |
CS-Cart |
P |
0 |
|
| 287 |
Trefoil Hoodie |
CS-Cart |
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> |
| 27 |
Trefoil Logo Hoodie |
CS-Cart |
P |
0 |
<div class="productText" style="display: block;">
<div class="prodDesc">This classic women's adidas Originals Trefoil Logo Hoodie is made of comfortable fleece with a drawcord hood, a kangaroo pocket and an outsize logo. The pullover hoodie also features extra-long cuffs and hem for feminine style.</div>
<div class="prodDetail">
<h3>Details</h3>
<ul>
<li>Kangaroo pocket</li>
<li>Drawcord-adjustable hood</li>
<li>Ribbed long cuffs and wider hem</li>
<li>Large Trefoil on front</li>
<li>70% cotton / 30% polyester fleece</li>
<li>Imported</li>
</ul>
</div>
</div> |