Query time 0.00174
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.40"
},
"nested_loop": [
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "6K"
},
"used_columns": [
"company_id",
"status",
"company",
"lang_code",
"address",
"city",
"state",
"country",
"zipcode",
"email",
"phone",
"url",
"storefront",
"secure_storefront",
"entry_page",
"redirect_customer",
"countries_list",
"timestamp",
"shippings",
"logos",
"request_user_id",
"request_account_name",
"request_account_data",
"tax_number",
"registered_from_storefront_id",
"plan_id",
"pre_moderation",
"pre_moderation_edit",
"pre_moderation_edit_vendors",
"suspend_date",
"grace_period_start",
"last_time_suspended",
"last_debt_notification_time",
"cp_profile_type",
"upload_kyc_request_sent",
"upload_kyc_request_time",
"wk_upload_exp",
"categories",
"wk_plan_type"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description",
"i18n_company",
"i18n_address",
"i18n_city",
"terms"
]
}
},
{
"table": {
"table_name": "ushop_vendor_plan_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "792"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"table": {
"table_name": "ushop_seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.35",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "ushop_discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "0.70",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "ushop_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id",
"used_key_parts": [
"thread_id"
],
"key_length": "3",
"ref": [
"marketplace.ushop_discussion.thread_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "1.05",
"data_read_per_join": "448"
},
"used_columns": [
"post_id",
"thread_id",
"status"
],
"attached_condition": "<if>(is_not_null_compl(ushop_discussion_posts), (`marketplace`.`ushop_discussion_posts`.`status` = 'A'), true)"
}
},
{
"table": {
"table_name": "ushop_discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"marketplace.ushop_discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.25",
"eval_cost": "0.10",
"prefix_cost": "1.40",
"data_read_per_join": "16"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(ushop_discussion_rating), (`marketplace`.`ushop_discussion_rating`.`thread_id` = `marketplace`.`ushop_discussion`.`thread_id`), true)"
}
}
]
}
}
Result
| company_id |
lang_code |
company_description |
i18n_company |
i18n_address |
i18n_city |
terms |
status |
company |
address |
city |
state |
country |
zipcode |
email |
phone |
url |
storefront |
secure_storefront |
entry_page |
redirect_customer |
countries_list |
timestamp |
shippings |
logos |
request_user_id |
request_account_name |
request_account_data |
tax_number |
registered_from_storefront_id |
plan_id |
pre_moderation |
pre_moderation_edit |
pre_moderation_edit_vendors |
suspend_date |
grace_period_start |
last_time_suspended |
last_debt_notification_time |
cp_profile_type |
upload_kyc_request_sent |
upload_kyc_request_time |
wk_upload_exp |
categories |
wk_plan_type |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 1 |
es |
<p>La empresa con las mejores herramientas del mundo.</p> |
Ferrequipo |
Boston street |
Boston |
<p>Por favor, lee detenidamente los Términos y Condiciones de CS-Cart ("Términos", "Términos y Condiciones") antes de comprar productos.</p>
<p><strong>Al enviar el pedido, aceptas estar sujeto a estos Términos. Si no estás de acuerdo con alguna parte de los Términos, no podrás acceder al Servicio.</strong></p>
<p><strong>Compras</strong></p>
<p>Si deseas comprar algún producto o servicio disponible a través del Servicio ("Compra"), es posible que te soliciten ciertos datos relevantes para tu Compra, incluyendo, sin limitación, tu ...</p>
<p><span></span><strong>Contenido</strong></p>
<p>Nuestro Servicio te permite publicar, enlazar, almacenar, compartir y poner a disposición cierta información, texto, gráficos, videos u otro material ("Contenido").</p>
<p><span></span><strong>Cambios</strong></p>
<p>Nos reservamos el derecho, a nuestra exclusiva discreción, de modificar o reemplazar estos Términos en cualquier momento. Si una revisión es importante, intentaremos proporcionar al menos 30 días de aviso antes de que los nuevos términos entren en vigor. Lo que se considera un cambio material será determinado a nuestra exclusiva discreción.</p>
<p><span></span><strong>Contáctanos</strong></p>
<p>Si tienes alguna pregunta sobre estos Términos, por favor contáctanos.</p> |
A |
Ferrequipo |
Boston street |
Boston |
MA |
US |
02125 |
sebas-lpe@hotmail.com |
+16175556985 |
http://example.com |
|
|
none |
Y |
|
1269610462 |
|
|
0 |
|
|
|
|
3 |
N |
N |
N |
1758922717 |
0 |
1762235821 |
0 |
S |
1 |
1758983748 |
0 |
|
month |
Oro |
cs-cart |
|
|
1_0 |