{
    "tenant_id": "3ca33d94-bf2e-4924-acec-48f7a158eed3",
    "sql": {
        "data": "select wp_orders.*, whatsapp_stores.store_name as wp_store_name from wp_orders join whatsapp_stores on whatsapp_stores.id = wp_orders.wp_store_id where whatsapp_stores.tenant_id = ? order by wp_orders.created_at desc limit 10 offset 0",
        "count": "select count(*) as aggregate from wp_orders join whatsapp_stores on whatsapp_stores.id = wp_orders.wp_store_id where whatsapp_stores.tenant_id = ?"
    },
    "explain": {
        "data": {
            "raw": "{\n  \"query_block\": {\n    \"select_id\": 1,\n    \"cost\": 0.007547307,\n    \"filesort\": {\n      \"sort_key\": \"wp_orders.created_at desc\",\n      \"temporary_table\": {\n        \"nested_loop\": [\n          {\n            \"table\": {\n              \"table_name\": \"whatsapp_stores\",\n              \"access_type\": \"ref\",\n              \"possible_keys\": [\"PRIMARY\", \"whatsapp_stores_tenant_id_foreign\"],\n              \"key\": \"whatsapp_stores_tenant_id_foreign\",\n              \"key_length\": \"1022\",\n              \"used_key_parts\": [\"tenant_id\"],\n              \"ref\": [\"const\"],\n              \"loops\": 1,\n              \"rows\": 1,\n              \"cost\": 0.00345856,\n              \"filtered\": 100,\n              \"index_condition\": \"whatsapp_stores.tenant_id = '3ca33d94-bf2e-4924-acec-48f7a158eed3'\"\n            }\n          },\n          {\n            \"table\": {\n              \"table_name\": \"wp_orders\",\n              \"access_type\": \"ref\",\n              \"possible_keys\": [\n                \"wp_orders_wp_store_id_foreign\",\n                \"wp_orders_store_created_at_idx\"\n              ],\n              \"key\": \"wp_orders_wp_store_id_foreign\",\n              \"key_length\": \"8\",\n              \"used_key_parts\": [\"wp_store_id\"],\n              \"ref\": [\"cloukewl_clixxa26.whatsapp_stores.id\"],\n              \"loops\": 1,\n              \"rows\": 1,\n              \"cost\": 0.00345856,\n              \"filtered\": 100\n            }\n          }\n        ]\n      }\n    }\n  }\n}",
            "decoded": {
                "query_block": {
                    "select_id": 1,
                    "cost": 0.0075473069999999996271267121983328252099454402923583984375,
                    "filesort": {
                        "sort_key": "wp_orders.created_at desc",
                        "temporary_table": {
                            "nested_loop": [
                                {
                                    "table": {
                                        "table_name": "whatsapp_stores",
                                        "access_type": "ref",
                                        "possible_keys": [
                                            "PRIMARY",
                                            "whatsapp_stores_tenant_id_foreign"
                                        ],
                                        "key": "whatsapp_stores_tenant_id_foreign",
                                        "key_length": "1022",
                                        "used_key_parts": [
                                            "tenant_id"
                                        ],
                                        "ref": [
                                            "const"
                                        ],
                                        "loops": 1,
                                        "rows": 1,
                                        "cost": 0.0034585599999999998462041350677509399247355759143829345703125,
                                        "filtered": 100,
                                        "index_condition": "whatsapp_stores.tenant_id = '3ca33d94-bf2e-4924-acec-48f7a158eed3'"
                                    }
                                },
                                {
                                    "table": {
                                        "table_name": "wp_orders",
                                        "access_type": "ref",
                                        "possible_keys": [
                                            "wp_orders_wp_store_id_foreign",
                                            "wp_orders_store_created_at_idx"
                                        ],
                                        "key": "wp_orders_wp_store_id_foreign",
                                        "key_length": "8",
                                        "used_key_parts": [
                                            "wp_store_id"
                                        ],
                                        "ref": [
                                            "cloukewl_clixxa26.whatsapp_stores.id"
                                        ],
                                        "loops": 1,
                                        "rows": 1,
                                        "cost": 0.0034585599999999998462041350677509399247355759143829345703125,
                                        "filtered": 100
                                    }
                                }
                            ]
                        }
                    }
                }
            }
        },
        "count": {
            "raw": "{\n  \"query_block\": {\n    \"select_id\": 1,\n    \"cost\": 0.00358521,\n    \"nested_loop\": [\n      {\n        \"table\": {\n          \"table_name\": \"whatsapp_stores\",\n          \"access_type\": \"ref\",\n          \"possible_keys\": [\"PRIMARY\", \"whatsapp_stores_tenant_id_foreign\"],\n          \"key\": \"whatsapp_stores_tenant_id_foreign\",\n          \"key_length\": \"1022\",\n          \"used_key_parts\": [\"tenant_id\"],\n          \"ref\": [\"const\"],\n          \"loops\": 1,\n          \"rows\": 1,\n          \"cost\": 0.001792605,\n          \"filtered\": 100,\n          \"attached_condition\": \"whatsapp_stores.tenant_id = '3ca33d94-bf2e-4924-acec-48f7a158eed3'\",\n          \"using_index\": true\n        }\n      },\n      {\n        \"table\": {\n          \"table_name\": \"wp_orders\",\n          \"access_type\": \"ref\",\n          \"possible_keys\": [\n            \"wp_orders_wp_store_id_foreign\",\n            \"wp_orders_store_created_at_idx\"\n          ],\n          \"key\": \"wp_orders_wp_store_id_foreign\",\n          \"key_length\": \"8\",\n          \"used_key_parts\": [\"wp_store_id\"],\n          \"ref\": [\"cloukewl_clixxa26.whatsapp_stores.id\"],\n          \"loops\": 1,\n          \"rows\": 1,\n          \"cost\": 0.001792605,\n          \"filtered\": 100,\n          \"using_index\": true\n        }\n      }\n    ]\n  }\n}",
            "decoded": {
                "query_block": {
                    "select_id": 1,
                    "cost": 0.00358521000000000013285816891084323287941515445709228515625,
                    "nested_loop": [
                        {
                            "table": {
                                "table_name": "whatsapp_stores",
                                "access_type": "ref",
                                "possible_keys": [
                                    "PRIMARY",
                                    "whatsapp_stores_tenant_id_foreign"
                                ],
                                "key": "whatsapp_stores_tenant_id_foreign",
                                "key_length": "1022",
                                "used_key_parts": [
                                    "tenant_id"
                                ],
                                "ref": [
                                    "const"
                                ],
                                "loops": 1,
                                "rows": 1,
                                "cost": 0.001792605000000000066429084455421616439707577228546142578125,
                                "filtered": 100,
                                "attached_condition": "whatsapp_stores.tenant_id = '3ca33d94-bf2e-4924-acec-48f7a158eed3'",
                                "using_index": true
                            }
                        },
                        {
                            "table": {
                                "table_name": "wp_orders",
                                "access_type": "ref",
                                "possible_keys": [
                                    "wp_orders_wp_store_id_foreign",
                                    "wp_orders_store_created_at_idx"
                                ],
                                "key": "wp_orders_wp_store_id_foreign",
                                "key_length": "8",
                                "used_key_parts": [
                                    "wp_store_id"
                                ],
                                "ref": [
                                    "cloukewl_clixxa26.whatsapp_stores.id"
                                ],
                                "loops": 1,
                                "rows": 1,
                                "cost": 0.001792605000000000066429084455421616439707577228546142578125,
                                "filtered": 100,
                                "using_index": true
                            }
                        }
                    ]
                }
            }
        }
    },
    "timings_ms": {
        "data": {
            "runs_ms": [
                1.06379700000000010362555258325301110744476318359375,
                0.7396730000000000249116283157491125166416168212890625,
                0.64955799999999996874322505391319282352924346923828125,
                0.611334999999999961772800816106610000133514404296875,
                0.556203000000000002955857780762016773223876953125,
                1.0405569999999999541984152529039420187473297119140625,
                0.75121300000000001961808493433636613190174102783203125,
                0.6512949999999999572963815808179788291454315185546875,
                0.6293130000000000112692077891551889479160308837890625,
                0.69025499999999995193178392582922242581844329833984375
            ],
            "avg_ms": 0.73831989999999991791668207952170632779598236083984375,
            "min_ms": 0.556203000000000002955857780762016773223876953125,
            "max_ms": 1.06379700000000010362555258325301110744476318359375
        },
        "count": {
            "runs_ms": [
                0.27909600000000001074340616469271481037139892578125,
                0.20695099999999999607069867124664597213268280029296875,
                0.219604999999999994653165913405246101319789886474609375,
                0.185771999999999992692067962707369588315486907958984375,
                0.2183549999999999935429428887800895608961582183837890625,
                0.2095809999999999895248237180567230097949504852294921875,
                0.230157000000000000472510919280466623604297637939453125,
                0.2215910000000000101838537602816359139978885650634765625,
                0.207253999999999993786303775777923874557018280029296875,
                0.199257999999999990681232020506286062300205230712890625
            ],
            "avg_ms": 0.217762000000000011112888387287966907024383544921875,
            "min_ms": 0.185771999999999992692067962707369588315486907958984375,
            "max_ms": 0.27909600000000001074340616469271481037139892578125
        }
    }
}