Query time 0.00316
JSON explain
{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "p.product_id",
"temporary_table": {
"nested_loop": [
{
"table": {
"table_name": "dp",
"access_type": "ALL",
"possible_keys": ["thread_id", "thread_id_2"],
"rows": 287,
"filtered": 100,
"attached_condition": "dp.`status` = 'A'"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY", "object_id", "idx_company_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["thread_id"],
"ref": ["lillyshop_lillyshop.dp.thread_id"],
"rows": 1,
"filtered": 99.99187469,
"attached_condition": "cscart_discussion.company_id = 1 and cscart_discussion.object_type = 'P'"
}
},
{
"table": {
"table_name": "p",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["lillyshop_lillyshop.cscart_discussion.object_id"],
"rows": 1,
"filtered": 100,
"attached_condition": "p.product_id in (12084,11676,12958,12518,11873,13219,12481,13229,11746,13202,13406,13097,13495,12052,8903,12894,11867,11858,13262,12229,13498,11734,11687,13075,13098,11941,7658,12519,11693,13390,12218,12083,11675,12956,12487,11872,13220,12480,13349,11745,13195,13407,13096,13496,12051,8892,12893,11865,11857,13263,12228,11733,11686,13074,13095,11926,7541,12517,11691,11819,13391,12217,13408,12081,11674,12955,12422,11871,13221,12479,13384,11744,13194,13094,13497,12032,8889,12892,11864,11856,13264,12227,11732,11685,13012,11925,18703,12516,11684,11818,13392,12216,13409,12080,11673,12954,12380,11870,13223,12423,13385,11743,13192,13093,13685,12031,8516,12891,11863,11855,13347,12226,11731,11683,12965,13073,11924,7278,12490,9699,11817,18422,13393,12214,13410,12079,11672,12953,12215,11869,13224,12421,13387,11741,13189,13092,13686,11965,8377,12889,11853,11854,13350,12225,11710,11682,12964,12957,11921,7161,12489,8893,11816,11851,13394,12209,13411,12078,11671,12952,11947,11868,13225,12382,13395,11740,13171,11703,13091,18018,11964,8159,12888,11826,11852,13351,12224,11681,12963,12951,11919,6943,12486,8890,11814,13209,13396,12208,13412,12077,19519,12950,11923,11866,13226,12381,13399,11739,13170,11694,13090,18099,11946,8068,12887,11824,11850,13382,12223,11680,12962,12947,11879,6940,12485,8062,11815,13207,13397,12166,13413,12076,18071,12949,11922,11862,13227,12379,13400,11738,13169,11692,13089,18100,11945,8031,12525,11822,11827,13383,12222,12165,11679,12961,12890,11878,6887,12484,8009,11807,13205,13398,13452,12075,9980,12948,11920,11861,13230,13403,11737,13168,11690,13087,18101,11944,7995,12523,11805,11825,13386,12221,12164,11678,12960,12524,11877,6864,12482,13222,11806,13204,13401,13487,12073,9271,12946,11875,11860,13240,12231,13404,11736,13155,11689,13077,18136,11943,7896,12521,11747,11823,13388,12220,12085,11677,12959,12522,11876,6858,12483,13228,11751,13203,13402,13099,13488,12074,9252,12944,11874,11859,13241,12230,13405,11735,11688,13076,13134,11942,7778,12520,11742,11821,13389,12219,11820,13088,12364)",
"using_index": true
}
}
]
}
}
}
}
Result
| product_id |
discussion_amount_posts |
| 11751 |
1 |