Query time 0.00360
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "29.01"
},
"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": "ALL",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"rows_examined_per_scan": 86,
"rows_produced_per_join": 1,
"filtered": "1.63",
"cost_info": {
"read_cost": "20.36",
"eval_cost": "0.28",
"prefix_cost": "20.64",
"data_read_per_join": "3K"
},
"used_columns": [
"category_id",
"storefront_id",
"usergroup_ids",
"status"
],
"attached_condition": "((`atulecarter_atul_demo1`.`cscart_categories`.`category_id` in (166,174,175,176,177,178,179,180,181,182,199,185,186,187,188,189,190,191,194,193,195,196,197,198,200,202,234,235,236,237,238,240,254,255,263)) and ((`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": 4,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.48",
"eval_cost": "0.84",
"prefix_cost": "22.95",
"data_read_per_join": "67"
},
"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": "4.20",
"eval_cost": "0.07",
"prefix_cost": "27.99",
"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`.`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.36",
"eval_cost": "0.07",
"prefix_cost": "28.42",
"data_read_per_join": "1K"
},
"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": 1,
"filtered": "97.36",
"using_index": true,
"cost_info": {
"read_cost": "0.38",
"eval_cost": "0.21",
"prefix_cost": "29.02",
"data_read_per_join": "25"
},
"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 |
| 163 |
NX200 20.3 Megapixel Compact System Camera |
CS-Cart |
P |
0 |
<p>Capture every moment in true-to-life quality. With the best-in-class resolution of the extra large 20.3 MP APS-C CMOS sensor, shots are rich, deep and exquisitely detailed. For active subjects, stills can be captured beautifully with 7fps Continuous Shot/100ms AF Speed. Then review your shot on the large 3.0” AMOLED display—made for sharper images and glare reduction.</p> |
| 155 |
Porta Pro KTC On-Ear Headphone |
CS-Cart |
P |
0 |
<p>Koss Porta Pro KTC, the most sophisticated version of the Porta Pro, features a new technological upgrade which brings listeners closer to the music they love. Koss Touch Control (KTC) remote and microphone technology, made for iPhone®, iPad® and iPod®, gives listeners more control in fewer steps. Listeners are now able to stay connected, shuffle song and adjust volume with the flick of a switch.</p> |
| 55 |
PRS-D800 |
CS-Cart |
P |
0 |
<p>The PRS-D800 2-channel amplifier contains audiophile grade components that were carefully selected and design perfected to achieve highest audio quality.</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> |
| 184 |
Samsung 30mm NX Pancake Lens |
CS-Cart |
P |
0 |
<p>Samsung’s compact 30mm pancake lens is the brightest in its class. With its 30mm fixed focal length and maximum aperture of F/2, you can capture exceptionally bright images — even in low-light situations such as shady forest paths and indoor weddings. You can also create striking, images with shallow depth of field in a variety of settings. And since it’s incredibly slim and lightweight, you can take it with you everywhere.</p> |
| 183 |
Samsung 50-200mm NX Telephoto OIS Lens |
CS-Cart |
P |
0 |
<p>The Samsung T50200SB 50-200mm Telephoto OIS Lens is a long telephoto zoom lens compatible with our NX Series of digital cameras.</p> |
| 133 |
Samsung Galaxy Player 4.0 |
CS-Cart |
P |
0 |
<p>Easily connect via Wi-Fi without any monthly service fees. The Samsung Galaxy Player can access the internet and apps anywhere there is an available hotspot. The sleek, lightweight 4.27 oz. design fits in any pocket and the brilliant 4” Super Clear LCD delivers incredible viewing quality.</p> |
| 132 |
Samsung Galaxy Player 5.0 |
CS-Cart |
P |
0 |
<p>Easily connect via Wi-Fi without any monthly service fees. The Samsung Galaxy Player can access the internet and apps anywhere there is an available hotspot. The sleek, lightweight 6.42 oz. design fits in any pocket and the brilliant 5” LCD delivers incredible viewing quality.</p> |
| 125 |
Samsung Galaxy S II |
CS-Cart |
P |
0 |
<dl><dt>The Galaxy S II has an amazing 4.27" Super AMOLED Plus screen. This superb display has razor sharp clarity and breathtaking color. See every detail of videos and pictures. See the full range of hues in all their subtlety and brilliance. And with its superior wide viewing angle, you don't have to be directly in front of the screen to see a perfect image. Truth is, you really have to see it to believe it.</dt></dl> |
| 120 |
Samsung Galaxy S II, Epic 4G Touch (Black) |
CS-Cart |
P |
0 |
<p>The fastest, state-of-the-art networks are 4G, so naturally, the Epic™ 4G Touch is designed for speed. With 4G, every download, upload, app, game, connection and feature runs almost as fast as you can push the button.</p> |
| 146 |
Sansa Clip+ MP3 Player (Blue) - 4GB |
CS-Cart |
P |
0 |
<p>Small but powerful, the Sansa Clip+ is a tiny MP3 player that boasts an array of cool features, as well as distinctively big sound for its small size. Rock out with up to 1,000 songs on this blue player. † Enjoy even more play when you use the expandable memory slot to play preloaded microSDHC™ cards**. slotRadio™ and slotMusic cards** are preloaded with tunes ready to pop into the player’s memory card slot. Rock on with a 15-hour battery life. † †</p> |
| 147 |
Sansa Clip+ MP3 Player (Red) - 4GB |
CS-Cart |
P |
0 |
<p>Small but powerful, the Sansa Clip+ is a tiny MP3 player that boasts an array of cool features, as well as distinctively big sound for its small size. Rock out with up to 1,000 songs on this red player. Enjoy even more play when you use the expandable memory slot to play preloaded microSDHC cards. slotRadio and slotMusic cards are preloaded with tunes ready to pop into the player’s memory card slot. Rock on with a 15-hour battery life.</p> |