Query time 0.00252
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "13.49"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"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": "42.58",
"cost_info": {
"read_cost": "0.60",
"eval_cost": "0.05",
"prefix_cost": "13.06",
"data_read_per_join": "1K"
},
"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`.`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`.`company_id` in ('1','2','3','4','5','6')) and (`atulecarter_atul_demo1`.`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": [
"atulecarter_atul_demo1.products.company_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "16.67",
"cost_info": {
"read_cost": "0.26",
"eval_cost": "0.01",
"prefix_cost": "13.37",
"data_read_per_join": "306"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`atulecarter_atul_demo1`.`companies`.`status` = 'A')"
}
},
{
"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.04",
"eval_cost": "0.01",
"prefix_cost": "13.42",
"data_read_per_join": "198"
},
"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.02",
"prefix_cost": "13.49",
"data_read_per_join": "2"
},
"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 |
| 12 |
100g Pants |
CS-Cart |
P |
0 |
<p>
When coach calls you off the bench, you need warm-up pants that come off in three seconds or less. That’s why these men's adidas 100g basketball pants have tear-away snaps down the sides, so you're ready for action as fast as a superhero.
</p> |
| 325 |
100g Pants |
CS-Cart |
P |
0 |
<p>
When coach calls you off the bench, you need warm-up pants that come off in three seconds or less. That’s why these men's adidas 100g basketball pants have tear-away snaps down the sides, so you're ready for action as fast as a superhero.
</p> |
| 78 |
adizero Rush Shoes |
CS-Cart |
P |
0 |
<p>Get moving in the lightweight adizero™ Rush shoes by adidas. These featherweight, dynamic men's running shoes are just 7.5 ounces of high-mileage style, with adiPRENE®+ support in the forefoot, a light synthetic upper and a thin rubber outsole for a close</p> |
| 79 |
adiZero Tempaia Shoes |
CS-Cart |
P |
0 |
<p>
The adiZero™ Tempaia shoes by adidas are lightweight, breathable tennis shoes designed for multi-court use. They feature a breathable upper, adiPRENE®+ in the forefoot for propulsion, adiPRENE® heel cushioning and EXTENDED TORSION® for support.
</p> |
| 11 |
Collegiate 72 Tee |
CS-Cart |
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> |
| 41 |
Gift Set (Onesie Plus Socks) |
CS-Cart |
P |
0 |
<p>Welcome the new addition with this adidas Originals Gift Set, featuring a one-piece romper and matching socks. The romper has a sleepy-time Trefoil character on the back, while the front bristles with fun in vibrant stripes.</p>
<div class="prodDetail">
<h3>Details</h3>
<ul>
<li>Crewneck</li>
<li>Full snap-button front for easy on and off</li>
<li>Allover yarn-dyed stripe pattern on front</li>
<li>Solid-color back with Trefoil-inspired graphic</li>
<li>Matching socks included</li>
<li>95% cotton / 5% elastane single jersey</li>
<li>Imported</li>
</ul>
</div> |
| 81 |
Minnetonka Original Cowhide Driving Moc |
CS-Cart |
P |
0 |
<div class="linePadding leadingEquity">Authentic designs. Free-spirited heritage. Shaping the moccasin's place in history since 1946.</div>
<div class="linePadding">Leather</div>
<ul class="equityBullets firstSet">
<li>• Genuine leather construction </li>
<li>• Lace-up front </li>
<li>• Long-wearing nub bottom </li>
<li>• Cushioned leather insole </li>
<li>• Contrast stitching </li>
</ul> |
| 107 |
Montblanc Classic Collection Money Clip |
CS-Cart |
P |
0 |
<p>Platinum-plated money clip with black onyx inlay</p> |
| 109 |
Montblanc Contemporary Collection Key Ring with Montblanc emblem |
CS-Cart |
P |
0 |
<p>Stainless steel key ring with brown calf leather</p> |
| 91 |
Montblanc Nicolas Rieussec Chronograph Automatic |
CS-Cart |
P |
0 |
<p>43 mm watch with stainless steel case, Montblanc Calibre MB R200, monopusher chronograph with automatic winding, anthracite-coloured dial with applique hour circle, date display, second time zone with day/night display, chronograph counters with rotating discs.</p> |
| 92 |
Montblanc TimeWalker Automatic |
CS-Cart |
P |
0 |
<p>42 mm stainless steel watch with black dial, red-gold plated hands and numerals, automatic movement, date display, black alligator-skin strap</p> |
| 34 |
Nike "Untouchable" Women's Tank Top |
CS-Cart |
P |
0 |
<div class="text description dark-grey-heather-dark-grey-heather-red">
<div class="product-description-component">
<p><strong>The Nike "Untouchable" Tank Top: Sleeveless tribute to '72</strong></p>
Celebrating a banner year in sports with vibrant print detail, the Nike "Untouchable" Women's Tank Top offers a motion-friendly racerback silhouette in a body-hugging fit.<br />
<p><strong>Benefits</strong></p>
<li>Slim fit contours to your body</li>
<li>Rib scoop-neck and armholes for durability and comfort</li>
<li>Racerback for enhanced range of movement</li>
<li>Screen-print at front</li>
<br />
<p><strong>Additional Details</strong></p>
<li>Fabric: 100% cotton</li>
<li>Machine wash</li>
<li>Imported</li>
</div>
</div> |
| 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>
<p><br></p>
<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>
<p><br></p>
<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>
<p><br></p>
<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> |
| 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> |