Query time 0.00232
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "13.49"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"rows_examined_per_scan": 5,
"rows_produced_per_join": 0,
"filtered": "4.00",
"index_condition": "(`atulecarter_atul_demo1`.`cscart_categories`.`category_id` in (196,199,197,198,200))",
"cost_info": {
"read_cost": "11.97",
"eval_cost": "0.04",
"prefix_cost": "12.01",
"data_read_per_join": "534"
},
"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": 0,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "0.21",
"eval_cost": "0.12",
"prefix_cost": "12.34",
"data_read_per_join": "9"
},
"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": "42.58",
"cost_info": {
"read_cost": "0.60",
"eval_cost": "0.05",
"prefix_cost": "13.06",
"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`.`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.26",
"eval_cost": "0.01",
"prefix_cost": "13.37",
"data_read_per_join": "306"
},
"used_columns": [
"company_id",
"status",
"company"
],
"attached_condition": "(`atulecarter_atul_demo1`.`companies`.`status` = 'A')"
}
},
{
"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.04",
"eval_cost": "0.01",
"prefix_cost": "13.42",
"data_read_per_join": "198"
},
"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.05",
"eval_cost": "0.02",
"prefix_cost": "13.49",
"data_read_per_join": "2"
},
"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 |
| 180 |
18-55mm Portrait Lens |
CS-Cart |
P |
0 |
<p>Certain photos vividly remind you of memorable moments even at a quick glance. You can treasure such everlasting, memories with the 18-55mm lens. This lens enables you to create diverse images from any scene, including wide-angle and portrait shots, making your precious moments last forever.</p> |
| 190 |
AF-S DX NIKKOR 10-24mm f/3.5-4.5G ED |
CS-Cart |
P |
0 |
<p>This ultra wide-angle lens, designed exclusively for use with Nikon’s DX-format, provides a versatile wide-angle zoom perspective.</p> |
| 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> |
| 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> |
| 168 |
D300S (Body Only) |
CS-Cart |
P |
0 |
<p>Extraordinary still and HD video imaging performance converge in the fast and agile 12.3-megapixel, DX-format D300S, delivering D-SLR versatility.</p> |
| 167 |
D3100 + 18-55 VR Lens Kit |
CS-Cart |
P |
0 |
<p>
Beautiful pictures–Amazing movies–Incredibly Easy with the 14 Megapixel DX sensor and learn-as-you-grow Guide Mode.
</p> |
| 169 |
D5100 + AF-S DX NIKKOR 18-55mm f/3.5-5.6G VR Lens Kit |
CS-Cart |
P |
0 |
<p>Creativity from any point of view. <br />Pictures that amaze. Movies that inspire.</p> |
| 175 |
F50 Flash Memory 52x Zoom Camcorder (Silver) |
CS-Cart |
P |
0 |
<p>2.7” LCD Touch Panel display gives you a clearer picture of what you are shooting. By leveraging the latest in LCD display technology, the Touch Panel delivers clean, crisp images that are saturated with natural color and deep, dynamic detail, enabling you to shoot with enhanced comfort and confidence in any external light condition.</p> |
| 246 |
GoPro - Hero3+ Black Edition Camera |
CS-Cart |
P |
0 |
<p>
Take smooth video with up to 4K resolution with this GoPro Hero3+ Black Edition CHDHX-302 camera that features a waterproof housing and a wearable, mountable design that lets you easily film yourself engaging in your favorite activities.
</p> |
| 173 |
H300 Long Zoom Compact Full HD Camcorder (Black) |
CS-Cart |
P |
0 |
<p>3.0" LCD Touch Panel display gives you a clearer picture of what you are shooting. By leveraging the latest in LCD display technology, the Touch Panel delivers clean, crisp images that are saturated with natural color and deep, dynamic detail, enabling you to shoot with enhanced comfort and confidence in any external light condition. With the large 3.0" display, it’s much easier to browse through content and find the exact features you’re looking for. Most useful, the extra large LCD screen makes it easier to select the features you need.</p> |
| 161 |
MV800 16.1 Megapixel MultiView Compact Digital Camera |
CS-Cart |
P |
0 |
<p>The 3.0" Flip-Out Display lets you take and view great pictures from multiple angles. Easily adjust the LCD from 0 to 180 degrees and make any shot possible. Snap a picture over a crowd or get waist-level candids of kids and pets, or spin the display for perfectly framed self-portraits. Choose from 3 shutter options to comfortably snap pics from any position.</p> |
| 165 |
Nikon 1 J1 One-Lens Kit White |
CS-Cart |
P |
0 |
<p>For your very mobile lifestyle comes a completely new imaging system with freedom to create and express as never before. Highly compact and portable, the Nikon 1 J1 goes everywhere you go. Moments from your amazing world are captured using a highly responsive autofocus and super fast shooting speed. In one touch you can work in Full HD (1080p) movie record mode. A camera so versatile you can even snap photos while recording movies. Unleash your creativity with Nikon 1—offering a balance of high performance, advanced features, portability and a newly designed interchangeable lens system. Infuse your world with photos from every moment and connect as never before.</p> |