Query time 0.00035
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "0.35"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_pages",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id"
],
"key_length": "3",
"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": "2K"
},
"used_columns": [
"page_id",
"company_id",
"parent_id",
"id_path",
"status",
"page_type",
"position",
"timestamp",
"usergroup_ids",
"localization",
"new_window",
"use_avail_period",
"avail_from_timestamp",
"avail_till_timestamp",
"facebook_obj_type"
]
}
},
{
"table": {
"table_name": "cscart_page_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"page_id",
"lang_code"
],
"key_length": "9",
"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": "3K"
},
"used_columns": [
"page_id",
"lang_code",
"page",
"description",
"meta_keywords",
"meta_description",
"page_title",
"link"
]
}
},
{
"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": [
"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"
]
}
}
]
}
}
Result
| page_id |
company_id |
parent_id |
id_path |
status |
page_type |
position |
timestamp |
usergroup_ids |
localization |
new_window |
use_avail_period |
avail_from_timestamp |
avail_till_timestamp |
facebook_obj_type |
lang_code |
page |
description |
meta_keywords |
meta_description |
page_title |
link |
seo_name |
seo_path |
| 193 |
0 |
153 |
153/193 |
A |
B |
0 |
1738607400 |
0 |
|
0 |
N |
0 |
0 |
|
en |
kindlife’s Offline Leap: Taps Dabur's NewU for nationwide retail expansion, aims to open EBOs |
<p>kindlife, the global beauty platform focusing on health, beauty, and wellness categories, is entering the offline space through a strategic collaboration with NewU stores, operated by H&B Stores Limited, a 100 per cent subsidiary of Dabur India Ltd, Radhika Ghai, founder and CEO at kindlife told ETRetail.</p>
<p>By powering NewU's established offline retail presence of 100+ stores pan India, kindlife aims to extend its curated selection of Korean and Japanese beauty brands to a broader audience.</p>
<p>"Currently, NewU runs 156 stores spread across 36 cities and to begin with, we will be available at the 20 stores of the brand. Most of these stores are in tier I and metro cities," she said.</p>
<p>"At present, we are only launching the around 25 most popular brands at NewU and going ahead, we will be rotating the brands at the store and will also be indulging in some exclusive launches of brands in India with NewU," she further added.</p>
<p>Currently, the e-commerce marketplace has 800 brands listed on its website and out of these 100 are international brands.</p>
<p>"We already work exclusively with about 25 Korean brands and 3 Japanese brands," she stated.</p>
<p>"Going ahead, we are planning to launch 2 more Japanese brands, and we are working to get some more brands from Europe, UK and the US," she further added.</p>
<p>Currently, 40 per cent of the orders of the e-commerce marketplace comes from tier I and metro cities, and the remaining 60 per cent is contributed by tier II and beyond.</p>
<p>"At present our average order value stands at Rs 2,500," she said.</p>
<p>When asked about exploring the quick commerce space, she said, "We have no plans to go full blown on quick commerce, however, we are looking forward to list afew brands on the quick commerce."</p>
<p>"Apart from this, in larger towns and cities, we have a solid 3PL partnership and we do deliver within 12 to 24 hours and that's where we continue to be," she further added.</p>
<p>In the next quarter, the e-commerce marketplace is planning to launch its own offline store in Delhi and Hyderabad. These stores will offer immersive experiences like housing a Korean beauty salon and more.</p>
<p>"Our flagship store will be spanning across 2,500 sq.ft and the smaller format stores will spread across 600-1,000 sq.ft. By this CY end, we plan to open 5-6 stores," she asserted.</p>
<p>"Apart from this, we are also planning to launch private label brand and we are working with a celebrity for that. It will be manufactured in Korea," she urther added.</p>
<p>The brand, which closed the last fiscal with Rs 20 crore in revenue, is currently running on a GMV ARR of Rs 140 crore.</p>
<p>"Right now, at the bottom line, we are not profitable, but we expect to be profitable by this calendar year end," she said.</p>
<p>The e-commerce marketplace, which raised a total funding of $12 million over 3 rounds, is planning to raise Series B in the next quarter.</p> |
|
|
|
|
kindlifes-offline-leap-taps-daburs-newu-for-nationwide-retail-expansion-aims-to-open-ebos |
153 |