Query time 0.00317
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 |
| 189 |
AF-S NIKKOR 14-24mm f/2.8G ED |
CS-Cart |
P |
0 |
<p>Fast aperture, high-performance, ultra-wide-angle zoom optimized for FX- and DX-format sensors featuring Nikon’s exclusive ED Glass and Nano Crystal Coat.</p> |
| 245 |
Apple - iPhone 5c 32GB Cell Phone - Green |
CS-Cart |
P |
0 |
<p>
A6 chip. 8MP iSight camera. 4-inch Retina display. Ultrafast LTE wireless. iPhone 5c has the things that made iPhone 5 an amazing phone — and more, including iOS 7. All in a completely new design that feels great in your hand.
</p> |
| 238 |
Apple iPhone 4S Black |
CS-Cart |
P |
0 |
<p>
16GB iPhone 4S locked AT&T model. Will work on AT&T. Now you can use your voice to use your iPhone. Just talk to Siri as you would to a person: "Do I need an umbrella?" or "Any great burgers around here?" or "Where's the closest ATM?" Siri not only understands what you say, it knows what you mean.1 It figures out the right apps to use to find the right answer. Then, just like a personal assistant, it answers you. Siri makes phone calls, sends messages, schedules meetings, sets reminders, and more. How much more? Just ask, and Siri tells you that, too. Two cores in the A5 chip deliver up to two times more power and up to seven times faster graphics.2 And you'll feel the effects. Fast. iPhone 4S is quick and responsive, which makes all the difference when you're launching apps, browsing the web, gaming, and doing just about everything. And no matter what you're doing, you can keep on doing it. Because the A5 chip is so power-efficient, iPhone 4S has outstanding battery life. This just might be the best camera ever on a phone. And with all-new optics, it just might be the only camera you need. Because behind every shot, you've got 8-megapixel resolution and a custom lens with a larger f/2.4 aperture. Not to mention an improved backside illumination sensor, excellent auto white balance, advanced color accuracy, face detection, and reduced motion blur. It all means that no matter how many people, how much light, and how much action you capture, everything looks exactly as it should. And just wait until you see the photos. Shoot stunning 1080p HD video everywhere you go. With all-new optics, the light is always right, the color is always vivid, and everything will look even better than you remember. Video stabilization steadies shaky shots. And you can edit video right on iPhone and share your lush life as fast as you shoot.
</p> |
| 239 |
Apple iPhone 4S White |
CS-Cart |
P |
0 |
<p>
16GB iPhone 4S locked AT&T model. Will work on AT&T. Now you can use your voice to use your iPhone. Just talk to Siri as you would to a person: "Do I need an umbrella?" or "Any great burgers around here?" or "Where's the closest ATM?" Siri not only understands what you say, it knows what you mean.1 It figures out the right apps to use to find the right answer. Then, just like a personal assistant, it answers you. Siri makes phone calls, sends messages, schedules meetings, sets reminders, and more. How much more? Just ask, and Siri tells you that, too. Two cores in the A5 chip deliver up to two times more power and up to seven times faster graphics.2 And you'll feel the effects. Fast. iPhone 4S is quick and responsive, which makes all the difference when you're launching apps, browsing the web, gaming, and doing just about everything. And no matter what you're doing, you can keep on doing it. Because the A5 chip is so power-efficient, iPhone 4S has outstanding battery life. This just might be the best camera ever on a phone. And with all-new optics, it just might be the only camera you need. Because behind every shot, you've got 8-megapixel resolution and a custom lens with a larger f/2.4 aperture. Not to mention an improved backside illumination sensor, excellent auto white balance, advanced color accuracy, face detection, and reduced motion blur. It all means that no matter how many people, how much light, and how much action you capture, everything looks exactly as it should. And just wait until you see the photos. Shoot stunning 1080p HD video everywhere you go. With all-new optics, the light is always right, the color is always vivid, and everything will look even better than you remember. Video stabilization steadies shaky shots. And you can edit video right on iPhone and share your lush life as fast as you shoot.
</p> |
| 242 |
Apple iPod Classic Black |
CS-Cart |
P |
0 |
<p>With 160GB of storage, iPod classic can hold up to 40,000 songs, 200 hours of video, or 25,000 photos.** That’s more than enough room for a day’s — or a lifetime’s — worth of entertainment.</p> |
| 243 |
Apple iPod Classic White |
CS-Cart |
P |
0 |
<p>With 160GB of storage, iPod classic can hold up to 40,000 songs, 200 hours of video, or 25,000 photos.** That’s more than enough room for a day’s — or a lifetime’s — worth of entertainment.</p> |
| 59 |
AVH-P4400BH |
CS-Cart |
P |
0 |
<p>The AVH-P4400BH DVD multimedia receiver features a 7" motorized touchscreen display, built-in Bluetooth® for hands-free calling and audio streaming, and an HD Radio™ tuner. The newly updated and innovative user interface makes direct operation of the unit stress-free by eliminating complicated layered selection displays, so access to desired functions is smoother and simpler than ever. A variety of multimedia options ensures that you will be properly entertained. Customizable audio and video functions make it easy to suit your mood.</p> |
| 58 |
AVH-P8400BH |
CS-Cart |
P |
0 |
<p>The AVH-P8400BH is Pioneer's top-of-the-line DVD multimedia receiver that features a beautiful 7" motorized touchscreen interface with our new Advanced Display Resolution technology, built-in Bluetooth® for hands-free calling and audio streaming, an HD Radio™ tuner, and Advanced App Mode for iPhone® 4/4S. The newly designed and innovative user interface makes direct operation of the unit stress-free by eliminating complicated layered selection displays, so access to desired functions is smoother and simpler than ever. A variety of multimedia options ensures that you will be properly entertained. Customizable audio and video functions make it easy to suit your mood.</p> |
| 60 |
AVIC-Z130BT |
CS-Cart |
P |
0 |
<p>Pioneer's flagship navigation receiver, the double-DIN AVIC-Z130BT features built-in navigation with maps of the US, Alaska, Hawaii, Canada, and Puerto Rico. Get there fast with spoken street names, lane guidance, and a wealth of GPS features, and stay in touch on the way with built-in Bluetooth for hands-free calling. The motorized 7-inch WVGA touchscreen display is great for GPS and for navigating your entertainment, whether it's DVDs or CDs, your digital media from USB drives or microSD cards, or content from your iPhone. Speaking of iPhones, the AVIC-Z130BT features enhanced integration with Pandora and Aha Radio apps, along with GPS features through the free AVIC FEEDS app.</p> |
| 172 |
Compact Full HD Camcorder |
CS-Cart |
P |
0 |
<p>
The T10 camcorder was designed to capture memories in comfort and in style. It boasts an ultra compact size, alightweight body and a brushed metal finish creating a subtle but sophisticated look and feel. In fact, its smooth curves fit so comfortably in your hand, it makes shooting video for longer periods of time more enjoyable
</p> |
| 134 |
Creative ZEN Style M300 MP3 Player 16GB (Black) |
CS-Cart |
P |
0 |
<p>Don't let the compact appearance of the Creative ZEN Style M300 MP3 player fool you. For a media player this tiny, you’d be amazed at the array of features it can offer for a remarkably affordable price.</p> |
| 135 |
Creative ZEN Touch 2 MP3 Player 8GB (Black) |
CS-Cart |
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> |