Query time 0.00134
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "6.10"
},
"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": "products_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"rows_examined_per_scan": 6,
"rows_produced_per_join": 3,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.05",
"eval_cost": "0.60",
"prefix_cost": "1.65",
"data_read_per_join": "48"
},
"used_columns": [
"product_id",
"category_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`products_categories`.`category_id` = 236) and (`atulecarter_atul_demo1`.`products_categories`.`product_id` <> 71))"
}
},
{
"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": "17.03",
"cost_info": {
"read_cost": "3.00",
"eval_cost": "0.10",
"prefix_cost": "5.25",
"data_read_per_join": "2K"
},
"used_columns": [
"product_id",
"product_type",
"status",
"company_id",
"amount",
"usergroup_ids",
"tracking",
"parent_product_id"
],
"attached_condition": "((`atulecarter_atul_demo1`.`products`.`parent_product_id` = 0) and ((`atulecarter_atul_demo1`.`products`.`amount` > 0) or (`atulecarter_atul_demo1`.`products`.`tracking` = 'D')) 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.51",
"eval_cost": "0.02",
"prefix_cost": "5.87",
"data_read_per_join": "613"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`atulecarter_atul_demo1`.`companies`.`status` = 'A')"
}
},
{
"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": "29.30",
"using_index": true,
"cost_info": {
"read_cost": "0.09",
"eval_cost": "0.01",
"prefix_cost": "6.01",
"data_read_per_join": "1"
},
"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)))"
}
},
{
"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": "6.10",
"data_read_per_join": "349"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"full_description"
]
}
}
]
}
}
}
}
Result
| product_id |
product |
company_name |
product_type |
parent_product_id |
full_description |
| 70 |
EVO Design 4G |
CS-Cart |
P |
0 |
<p>The HTC EVO Design 4G is a high-end smartphone that is packed full of the latest features! Powered by Android 2.3, this device comes pre-loaded with the newest Android Platform for smartphones. You can choose from thousands of apps and games at the Android Marketplace. The HTC EVO Design 4G also comes loaded with a 4.0” qHD capacitive touch display, with the latest version of HTC Sense, and international phone capabilities. With a 5 megapixel main camera, you will have the ability to capture, record and playback in HD. This smartphone also features a 1.3 megapixel front-facing camera for video chats! Quickly download movies and create user generated content with a flash-enabled web browsing experience running on Sprint's 4G network and the power of a 1.2 GHz processor.</p> |
| 67 |
HTC Wildfire S - White (T-Mobile) |
CS-Cart |
P |
0 |
<p>The HTC Wildfire S for T-Mobile is a 3G capable smartphone that adds style to a practical device. This sleek device runs on the Android™ 2.3 platform, so you can have the latest Android™ technology and access to thousands of apps. It also features a 3.2 inch capacitive touchscreen, a 5 megapixel camera for capturing important moments and Wi-Fi calling/hotspot capabilities! Weighing only 3.7 ounces, the Wildfire S is extremely portable. If you are looking for a stylish and fun smartphone that is easy to use, the HTC Wildfire S could be the phone for you!</p> |
| 69 |
Rhyme |
CS-Cart |
P |
0 |
<p>HTC Rhyme™ and its suite of innovative accessories<br /> deliver seamless experiences.<br /><br />Docking Station<br />Effortlessly slide the HTC Rhyme into the Docking Station to charge it and automatically activate Dock Mode, turning your phone into an all-in-one alarm clock, music player, and picture frame.<br /><br /> Charm<br /> Attached to your bag, the Charm alerts you of calls, missed calls, and messages. It also keeps your phone within easy reach and goes with anything.<br /><br /> Tangle–free Headphones<br /> These headphones don’t just sound amazing—they’re virtually tangle-free, thanks to flat wires.<br /><br />Exclusive HTC Sense™ experience<br /> The HTC Rhyme delivers a visually refined and intuitive <br /> HTC Sense experience. Find what you want faster with streamlined menus across HTC Sense apps and get the live info you care about on the home screen with the Quick Launch widget. Stay on top of all your to-dos by creating tasks from emails and messages, then sync those tasks with your Microsoft® Exchange account for one to-do list on phone and PC.</p> |
| 68 |
Titan |
CS-Cart |
P |
0 |
<p>In the right hands, amazing things happen.<br /><br />Put emails in their place<br /> Combine your personal inboxes while keeping your work account separate.<br /><br />Plenty of room in the office<br /> Microsoft® Office Mobile and multitasking on a huge <br /> 4.7" screen makes plenty of room for work, wherever you go.<br /><br />Focus on thoughts, not thumbs<br /> With such a spacious keypad, you can stop focusing on your fingers and start focusing on ideas.<br /><br />Expansive display, infinite possibility<br /> Whether you’re taking care of business or taking a break from it all, you can see the big picture on the 4.7" LCD screen.<br /><br />Pocket-sized profile<br /> At 9.9mm, it’s slim enough to fit comfortably in your pocket. But considering everything the HTC TITAN with Windows Phone is capable of, it won’t be spending much time there.</p> |