Query time 0.00223
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1004.70"
},
"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": 490,
"rows_produced_per_join": 49,
"filtered": "10.00",
"cost_info": {
"read_cost": "130.91",
"eval_cost": "9.80",
"prefix_cost": "140.71",
"data_read_per_join": "334K"
},
"used_columns": [
"company_id",
"status",
"lang_code",
"email",
"timestamp",
"tax_number",
"plan_id",
"robokassa_store_id",
"robokassa_account_number"
],
"attached_condition": "(`cscart`.`cscart_companies`.`status` = 'A')"
}
},
{
"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": [
"cscart.cscart_companies.company_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 49,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "9.80",
"prefix_cost": "150.51",
"data_read_per_join": "84K"
},
"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": [
"cscart.cscart_companies.company_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 49,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "9.80",
"prefix_cost": "160.31",
"data_read_per_join": "84K"
},
"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": [
"cscart.cscart_companies.plan_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 49,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "9.80",
"prefix_cost": "170.11",
"data_read_per_join": "37K"
},
"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": [
"cscart.cscart_companies.company_id",
"const",
"const",
"const"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 147,
"filtered": "100.00",
"cost_info": {
"read_cost": "181.79",
"eval_cost": "29.40",
"prefix_cost": "381.30",
"data_read_per_join": "249K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
],
"attached_condition": "<if>(is_not_null_compl(cscart_seo_names), (`cscart`.`cscart_seo_names`.`object_id` = `cscart`.`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": [
"cscart.cscart_companies.company_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 147,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "29.40",
"prefix_cost": "410.70",
"data_read_per_join": "3K"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion), (`cscart`.`cscart_discussion`.`object_id` = `cscart`.`cscart_companies`.`company_id`), true)"
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ALL",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"rows_examined_per_scan": 10,
"rows_produced_per_join": 1470,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "6.00",
"eval_cost": "294.00",
"prefix_cost": "710.70",
"data_read_per_join": "643K"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_posts), ((`cscart`.`cscart_discussion_posts`.`thread_id` = `cscart`.`cscart_discussion`.`thread_id`) and (`cscart`.`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": [
"cscart.cscart_discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1470,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "294.00",
"prefix_cost": "1004.70",
"data_read_per_join": "22K"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), (`cscart`.`cscart_discussion_rating`.`thread_id` = `cscart`.`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 |
robokassa_store_id |
robokassa_account_number |
| 1 |
ru |
cs-cart@example.com |
1269610461 |
A |
Тестовый производитель |
|
Компания, которая делает лучшее на свете ПО для электронной коммерции |
|
Голд |
cs-cart |
|
|
1_0 |
|
0 |
| 2 |
ru |
acme_corp@example.com |
1269610461 |
A |
Лазурит |
|
<p>Компания, которая делает все на свете</p> |
|
Базовый |
acme-corp |
|
|
2_0 |
|
0 |
| 4 |
ru |
megaton@example.com |
1404900515 |
A |
|
|
<p><span style="background-color: initial;">ООО "Мегатон"</span></p><h2><span style="background-color: initial;">Описание компании</span></h2><p>ОАО “Мегатон” – компания, специализирующаяся на торговле одеждой и аксессуарами. Более 10 лет она занимает одну из ведущих позиций на российском рынке. В компании ОАО “Мегатон” в настоящий момент насчитывает около 500 торговых точек в более чем 180 городах.</p><p>В нашем магазине одежды любой посетитель найдет то, что ему нужно! Мы делаем все возможное, чтобы вы остались довольны покупками!</p><h2>Реквизиты компании<span style="color: rgb(51, 51, 51); background-color: initial;"></span></h2><table><tbody><tr> <td> <span style="background-color: initial;">Наименование:</span></td> <td> <span style="background-color: initial;">Общество с ограниченной ответственностью «Мегатон», ООО «Мегатон»</span></td></tr><tr><td>Юридический адрес:</td> <td>г. Череповец, ул. Молодежная д. 7 </td></tr><tr><td>Фактический адрес:</td> <td><p> г. Череповец, ул. Молодежная д. 7 </p></td></tr><tr><td>ИНН/КПП:</td> <td> <span style="background-color: initial;">3013002771/581101441</span> </td></tr><tr><td> <span style="background-color: initial;">ОГРН:</span></td> <td> <span style="background-color: initial;">110110272331</span> </td></tr></tbody></table><h2>Банковские реквизиты</h2><table><tbody><tr><td> Полное наименование: </td> <td> ООО "Мегатон"</td></tr><tr><td> ИНН: </td> <td> 570912199352 </td></tr><tr><td> ОГРН:</td> <td> 302213182350174</td></tr><tr><td> Банк:</td> <td><p> ОАО "Локо-Банк" </p></td></tr><tr><td> Р/С: </td> <td> 80285110707424730081 </td></tr><tr><td> БИК</td> <td> 031104721</td></tr><tr><td> К/С</td> <td> 55040710505158993081 </td></tr></tbody></table> |
|
Базовый |
megaton |
|
|
4_0 |
|
|