Query time 0.00147
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "12.46"
},
"ordering_operation": {
"using_filesort": true,
"grouping_operation": {
"using_temporary_table": true,
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "absolute_rating",
"access_type": "system",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "112"
},
"used_columns": [
"object_id",
"object_type",
"rating"
]
}
},
{
"table": {
"table_name": "cscart_companies",
"access_type": "ALL",
"rows_examined_per_scan": 6,
"rows_produced_per_join": 1,
"filtered": "16.67",
"cost_info": {
"read_cost": "3.27",
"eval_cost": "0.20",
"prefix_cost": "3.47",
"data_read_per_join": "7K"
},
"used_columns": [
"company_id",
"status",
"lang_code",
"email",
"timestamp",
"tax_number",
"plan_id",
"suspend_date",
"last_time_suspended",
"hotel_name",
"facilities"
],
"attached_condition": "(`atulecarter_atul_demo1`.`cscart_companies`.`status` = 'A')"
}
},
{
"table": {
"table_name": "cscart_vendor_plans",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_id"
],
"key_length": "4",
"ref": [
"atulecarter_atul_demo1.cscart_companies.plan_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "80.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.16",
"prefix_cost": "3.67",
"data_read_per_join": "83"
},
"used_columns": [
"plan_id",
"ec_pos_plan_type"
],
"attached_condition": "(`atulecarter_atul_demo1`.`cscart_vendor_plans`.`ec_pos_plan_type` <> 'P')"
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"atulecarter_atul_demo1.cscart_companies.company_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.16",
"prefix_cost": "3.83",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"table": {
"table_name": "cscart_company_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"atulecarter_atul_demo1.cscart_companies.company_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.16",
"prefix_cost": "3.99",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description"
]
}
},
{
"table": {
"table_name": "cscart_vendor_plan_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_id",
"lang_code"
],
"key_length": "10",
"ref": [
"atulecarter_atul_demo1.cscart_companies.plan_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.16",
"prefix_cost": "4.15",
"data_read_per_join": "633"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"table": {
"table_name": "cscart_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"atulecarter_atul_demo1.cscart_companies.company_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.59",
"eval_cost": "0.16",
"prefix_cost": "5.90",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "<if>(is_not_null_compl(cscart_seo_names), (`atulecarter_atul_demo1`.`cscart_seo_names`.`object_id` = `atulecarter_atul_demo1`.`cscart_companies`.`company_id`), true)"
}
},
{
"table": {
"table_name": "cscart_discussion",
"access_type": "eq_ref",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"atulecarter_atul_demo1.cscart_companies.company_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.16",
"prefix_cost": "6.06",
"data_read_per_join": "19"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion), (`atulecarter_atul_demo1`.`cscart_discussion`.`object_id` = `atulecarter_atul_demo1`.`cscart_companies`.`company_id`), true)"
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"atulecarter_atul_demo1.cscart_discussion.thread_id"
],
"rows_examined_per_scan": 6,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "4.48",
"eval_cost": "0.96",
"prefix_cost": "11.50",
"data_read_per_join": "2K"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), (`atulecarter_atul_demo1`.`cscart_discussion_posts`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"atulecarter_atul_demo1.cscart_discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.96",
"prefix_cost": "12.46",
"data_read_per_join": "76"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), (`atulecarter_atul_demo1`.`cscart_discussion_rating`.`thread_id` = `atulecarter_atul_demo1`.`cscart_discussion`.`thread_id`), true)"
}
}
]
}
}
}
}
Result
| company_id |
lang_code |
email |
timestamp |
status |
company |
tax_number |
company_description |
absolute_vendor_rating |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
hotel_name |
facilities |
suspend_date |
last_time_suspended |
| 5 |
en |
super12@gmail.com |
1754982536 |
A |
super hotel |
|
|
|
Gold |
super-hotel |
|
3.0000 |
5_3788 |
super hotel |
1,3,4 |
0 |
1755491261 |
| 4 |
en |
demo3332@gmail.com |
1754982462 |
A |
prime hotel |
87678 |
|
|
Gold |
prime-hotel |
|
4.0000 |
4_3786 |
ITC Maurya, a Luxury Collection Hotel |
1,2,3 |
0 |
1755491261 |
| 3 |
en |
tiktokn603@gmail.com |
1754980363 |
A |
king hotel |
87678 |
<h3>Experience World-class Service at Hilton Hua Hin Resort & Spa</h3>
<p>Overlooking the Gulf of Thailand, Hilton Hua Hin offers prime beachfront accommodation with stunning views and access to a first-rate spa. It features a beach-side pool and 5 dining options.</p><p>Hilton Hua Hin Resort and Spa offers 5-star luxury, a short 15-minute drive from the Hua Hin Airport. It is a 2.5-hour drive from lively Bangkok.</p><p>Boasting stunning ocean views from floor-to-ceiling windows, Hua Hin Hilton's modern rooms offer the comfort of spacious layouts and a sofa.</p><p>They feature a private balcony, cable TV and full-sized fridge.
Relax with a Thai herbal steam bath at the spa after an active workout at the tennis courts or fitness centre.</p><p>Multilingual staff can provide concierge, tour and childcare services.
Experience fine Chinese specialities with panoramic ocean views at the Rooftop Bar and White Lotus restaurant.</p><p>Enjoy the essence of Asia with an unforgettable culinary journey at our newest all-day dining restaurant, "Ginger fire".</p> |
|
Gold |
king-hotel |
|
4.0000 |
3_3785 |
King Hotel |
1,2,3,4,5,6 |
0 |
1755150643 |
| 1 |
en |
cs-cart@example.com |
1269610461 |
A |
CS-Cart |
|
The company that makes the best shopping cart software in the world |
|
Gold |
cs-cart |
|
|
1_0 |
Sterlings Mac Hotel |
|
1756988689 |
1758105342 |
| 2 |
en |
acme_corp@example.com |
1269610461 |
A |
ACME Corp |
|
<p>A Company that Makes Everything</p> |
|
Bronze |
acme-corp |
|
|
2_0 |
Caravela Beach Resort |
2,3,5 |
0 |
0 |