Query time 0.00704
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": false,
"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"
]
}
},
{
"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": "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`.`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`.`product_type` <> 'D'))"
}
},
{
"table": {
"table_name": "c_var",
"access_type": "ref",
"possible_keys": [
"variant_id",
"lang_code",
"product_id",
"idx_product_feature_variant_id"
],
"key": "idx_product_feature_variant_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"atulecarter_atul_demo1.products_categories.product_id"
],
"rows_examined_per_scan": 11,
"rows_produced_per_join": 0,
"filtered": "1.30",
"using_index": true,
"cost_info": {
"read_cost": "0.72",
"eval_cost": "0.01",
"prefix_cost": "44.09",
"data_read_per_join": "58"
},
"used_columns": [
"product_id",
"variant_id",
"lang_code"
],
"attached_condition": "((`atulecarter_atul_demo1`.`c_var`.`variant_id` = 86) and (`atulecarter_atul_demo1`.`c_var`.`lang_code` = 'en'))"
}
},
{
"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.07",
"eval_cost": "0.01",
"prefix_cost": "44.18",
"data_read_per_join": "344"
},
"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.08",
"eval_cost": "0.04",
"prefix_cost": "44.31",
"data_read_per_join": "5"
},
"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> |
| 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> |
| 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> |