Query time 0.00390
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "40.34"
},
"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": 2,
"rows_produced_per_join": 1,
"filtered": "50.00",
"cost_info": {
"read_cost": "2.29",
"eval_cost": "0.20",
"prefix_cost": "2.49",
"data_read_per_join": "8K"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`pankajecarter_systemsix`.`companies`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 85,
"rows_produced_per_join": 3,
"filtered": "4.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "19.80",
"eval_cost": "0.68",
"prefix_cost": "22.97",
"data_read_per_join": "11K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "(((`pankajecarter_systemsix`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemsix`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemsix`.`cscart_categories`.`usergroup_ids`)) and (`pankajecarter_systemsix`.`cscart_categories`.`status` in ('A','H')) and (`pankajecarter_systemsix`.`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": [
"pankajecarter_systemsix.cscart_categories.category_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 6,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "3.54",
"eval_cost": "1.36",
"prefix_cost": "27.87",
"data_read_per_join": "108"
},
"used_columns": [
"product_id",
"category_id"
],
"attached_condition": "(`pankajecarter_systemsix`.`products_categories`.`product_id` <> 136)"
}
},
{
"table": {
"table_name": "products",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "8.82",
"cost_info": {
"read_cost": "6.80",
"eval_cost": "0.12",
"prefix_cost": "36.03",
"data_read_per_join": "3K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"usergroup_ids",
"parent_product_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`products`.`company_id` = `pankajecarter_systemsix`.`companies`.`company_id`) and ((`pankajecarter_systemsix`.`products`.`usergroup_ids` = '') or find_in_set(0,`pankajecarter_systemsix`.`products`.`usergroup_ids`) or find_in_set(1,`pankajecarter_systemsix`.`products`.`usergroup_ids`)) and (`pankajecarter_systemsix`.`products`.`status` = 'A') and (`pankajecarter_systemsix`.`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": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "3.08",
"index_condition": "((`pankajecarter_systemsix`.`prices`.`lower_limit` = 1) and (`pankajecarter_systemsix`.`prices`.`usergroup_id` in (0,0,1)))",
"cost_info": {
"read_cost": "1.52",
"eval_cost": "0.01",
"prefix_cost": "37.79",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "((`pankajecarter_systemsix`.`prices`.`price` >= 0.00) and (`pankajecarter_systemsix`.`prices`.`price` <= 0.00))"
}
},
{
"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": [
"pankajecarter_systemsix.products_categories.product_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "9.25",
"not_exists": true,
"cost_info": {
"read_cost": "0.09",
"eval_cost": "0.00",
"prefix_cost": "37.90",
"data_read_per_join": "0"
},
"used_columns": [
"product_id",
"price",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(prices_2), isnull(`pankajecarter_systemsix`.`prices_2`.`price`), true) and <if>(is_not_null_compl(prices_2), ((`pankajecarter_systemsix`.`prices_2`.`lower_limit` = 1) and (`pankajecarter_systemsix`.`prices_2`.`price` < `pankajecarter_systemsix`.`prices`.`price`) and (`pankajecarter_systemsix`.`prices_2`.`usergroup_id` in (0,0,1))), true))"
}
},
{
"table": {
"table_name": "epd",
"access_type": "ALL",
"rows_examined_per_scan": 3,
"rows_produced_per_join": 0,
"filtered": "33.33",
"not_exists": true,
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "2.42",
"eval_cost": "0.00",
"prefix_cost": "40.33",
"data_read_per_join": "0"
},
"used_columns": [
"product_id"
],
"attached_condition": "(<if>(found_match(epd), isnull(`pankajecarter_systemsix`.`epd`.`product_id`), true) and <if>(is_not_null_compl(epd), (`pankajecarter_systemsix`.`epd`.`product_id` = `pankajecarter_systemsix`.`products_categories`.`product_id`), 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": [
"pankajecarter_systemsix.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": "40.34",
"data_read_per_join": "37"
},
"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 |
| 135 |
Creative ZEN Touch 2 MP3 Player 8GB (Black) |
CS-Cart |
0.00000000 |
135,135 |
P,P |
0,0 |
P |
0 |
<p>The ZEN line of portable media players has long been associated with the highest quality in audio playback, and the Creative ZEN Touch 2 continues to uphold this standard. But that's not all it offers. What makes this player truly stand out from the rest is that you can stream music wirelessly to compatible Bluetooth® headphones or speakers such as Creative's ZiiSound D5 and WP-300, and surf the Internet too.</p> |
| 138 |
Ridge Racer |
CS-Cart |
0.00000000 |
138 |
P |
0 |
P |
0 |
<p>
<p>BEAUTY & HIGH SPEED DRIFTING AROUND THE WORLD!</p>
<p>The high-octane racing franchise drifts onto the PlayStation®Vita delivering stunning graphics and heart-pounding action that players can truly feel. Ridge Racer® features high-speed action, high-performance racing machines, and all-new gameplay additions creating an edge-of-your-seat experience only possible on the PlayStation®Vita. Racing fans can also take the action online and tear up the track against players from around the globe using the PlayStation®Vita “near” and Wi-Fi functionality and race against other players’ ghosts anywhere at anytime.</p>
<p>
<p>Vivid, next generation high-contrast graphics and advanced lighting effects powered by the PlayStation®Vita painting processor</p>
<p>An immersive audio experience with a dynamic soundscape that changes and evolves with each race according to the movement of your machine.</p>
<p>All-new custom drift system enables players to tune the action to suit their style of driving. All new "Machine Upgrade Map" customization allows players to upgrade functional parts and create their own original machines</p>
<p>New introduction of the Planetary League allows players to join in one of four racing teams and race against other players from around the world both at real-time and "anywhere at any time" by exchanging ghosts via "near" functionality.</p>
<p>Compete against up to 7 other players from around the world with online (ad-hoc, Wi-Fi) multiplayer.</p>
</p>
</p> |
| 139 |
Shinobido 2: Revenge of Zen |
CS-Cart |
0.00000000 |
139 |
P |
0 |
P |
0 |
<p>
<p>Shinobido 2: Revenge of Zen is the sequel to Shinobido: Way of the Ninja, featuring the series’ trademark stealth action gameplay with the addition of new stylish assassin moves and a dynamic storyline. Developed by Acquire, the story is set six months after the events of the previous opus, with the Utakata region once again at the center of the storm and embroiled in a civil war involving the mysterious Magic Mirror. Players will take the role of Zen, a man who has suffered betrayal at the hands of his companions and the loss of his home. Saved by the Asuka clan of Utakata, Zen makes up his mind to live as an assassin and begins a perilous journey in search of revenge.</p>
<p>Dynamic Storyline: Interact with three factions with different choices affecting the power balance between the factions and resulting in diverging storylines.</p>
<p>Stealth action gameplay for a master assassin: Employ a variety of deadly finishing moves which vary according to the location. Activate the Zankoku for bullet-time action and use the Ninja Flying ability to freely explore environments.</p>
<p>New ‘near’ network features: Boost your inventory by receiving gift items from other players using the PlayStation®Vita near feature.</p>
<p>Original PS Vita rear touch panel gameplay features: Use the rear touch panel to change to a first person view and launch long range weapons at enemies.</p>
</p> |