Query time 0.00166
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "10.24"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "cscart_products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "5K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_timestamp",
"usergroup_ids",
"is_edp",
"edp_shipping",
"unlimited_download",
"tracking",
"free_shipping",
"zero_price_action",
"is_pbp",
"is_op",
"is_oper",
"is_returnable",
"return_period",
"avail_since",
"out_of_stock_actions",
"localization",
"min_qty",
"max_qty",
"qty_step",
"list_qty_count",
"tax_ids",
"age_verification",
"age_limit",
"options_type",
"exceptions_type",
"details_layout",
"shipping_params",
"facebook_obj_type",
"parent_product_id",
"buy_now_url",
"is_stock_split_by_warehouses",
"is_view_only",
"ab__stickers_manual_ids",
"ab__stickers_generated_ids",
"is_discount",
"xero_product_id",
"is_tookan_sameday",
"cost_price",
"sg_extra",
"updated_by",
"sg_old_product",
"sg_locations"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_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": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cscart_product_sales",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"pa"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id",
"product_id"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"unique_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 4,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.40",
"prefix_cost": "1.40",
"data_read_per_join": "96"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_product_prices), ((`dev_yourmart_co_bw`.`cscart_product_prices`.`lower_limit` = 1) and (`dev_yourmart_co_bw`.`cscart_product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "cscart_product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "9",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.40",
"prefix_cost": "1.80",
"data_read_per_join": "15K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text"
]
}
},
{
"table": {
"table_name": "company_descr",
"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": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.40",
"prefix_cost": "2.20",
"data_read_per_join": "6K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"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": 4,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.40",
"prefix_cost": "2.60",
"data_read_per_join": "24K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`dev_yourmart_co_bw`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "cscart_products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 4,
"rows_produced_per_join": 16,
"filtered": "100.00",
"cost_info": {
"read_cost": "4.00",
"eval_cost": "1.60",
"prefix_cost": "8.20",
"data_read_per_join": "256"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "cscart_categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"dev_yourmart_co_bw.cscart_products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.08",
"prefix_cost": "9.80",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`dev_yourmart_co_bw`.`cscart_categories`.`storefront_id` in (0,1)) and ((`dev_yourmart_co_bw`.`cscart_categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`dev_yourmart_co_bw`.`cscart_categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`dev_yourmart_co_bw`.`cscart_categories`.`usergroup_ids`))) and (`dev_yourmart_co_bw`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.20",
"eval_cost": "0.08",
"prefix_cost": "10.08",
"data_read_per_join": "1K"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "cscart_booking_and_reservation",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.08",
"prefix_cost": "10.16",
"data_read_per_join": "121"
},
"used_columns": [
"product_id",
"booking_type",
"date_from",
"date_to",
"book_time",
"break_time",
"week_data"
],
"attached_condition": "<if>(is_not_null_compl(cscart_booking_and_reservation), <cache>((17126 = 17126)), true)"
}
},
{
"table": {
"table_name": "cscart_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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.08",
"prefix_cost": "10.24",
"data_read_per_join": "19"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_timestamp |
usergroup_ids |
is_edp |
edp_shipping |
unlimited_download |
tracking |
free_shipping |
zero_price_action |
is_pbp |
is_op |
is_oper |
is_returnable |
return_period |
avail_since |
out_of_stock_actions |
localization |
min_qty |
max_qty |
qty_step |
list_qty_count |
tax_ids |
age_verification |
age_limit |
options_type |
exceptions_type |
details_layout |
shipping_params |
facebook_obj_type |
parent_product_id |
buy_now_url |
is_stock_split_by_warehouses |
is_view_only |
ab__stickers_manual_ids |
ab__stickers_generated_ids |
is_discount |
xero_product_id |
is_tookan_sameday |
cost_price |
sg_extra |
updated_by |
sg_old_product |
sg_locations |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
price |
category_ids |
popularity |
company_name |
sales_amount |
seo_name |
seo_path |
booking_type |
date_from |
date_to |
book_time |
break_time |
week_data |
discussion_type |
| 17126 |
Inta074 |
P |
A |
118 |
399.00 |
25 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1743673528 |
1743673544 |
0 |
N |
N |
N |
B |
N |
P |
N |
N |
N |
Y |
10 |
1743631200 |
N |
|
0 |
0 |
0 |
0 |
9 |
N |
0 |
P |
F |
default |
a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} |
|
0 |
|
N |
N |
|
|
N |
|
N |
0.00 |
|
V |
N |
|
en |
Stellar Lighting Camping Lantern String Light 100 RGB LED 10m Warm White |
|
<p>10m retractable string Light, 100 RGB LED's 36 SMD front Light, power bank 2000 mAh battery, XTE LED BackLight</p> |
<p>Stellar Lighting offers premium range lighting for South Africans, designed by South Africans. We understand the importance of creating brighter moments in our lives. Our team combines modern trends with vintage principles to generate premium lighting products for that special occasion.</p><p>Product Description:<br />Base Material: PC + ABS + Magnet<br />Brightness: 80-250 LM<br />Light Colour: 10 Meters Warm White + RGB String light + 36 SMD + XTE LEDs<br />Endurance: 5-12h<br />Waterproof: IP 44<br />Battery Capacity: Li-Polymer 2000 mah<br />Charging Type: Type-C 5V 1A<br />Output: USB<br />Product Size: 108*33mm<br />Weight: 210g</p>
<p>Gear Operation Instructions:<br />Press the button to switch the cycle gear: String lights warm light -> string lights RGB alternative flashing -> String lights RGB breathing - SMD warm white + String light warm white -> SMD strong light-off<br />Press and hold for three seconds XTE strong light -> Weak Light -> Strobe<br />After 8 seconds of lighting in any mode, press the switch to turn off</p><p></p> |
10m retractable string Light, 100 RGB LED's 36 SMD front Light, power bank 2000 mAh battery, XTE LED BackLight |
10m retractable string Light, 100 RGB LED's 36 SMD front Light, power bank 2000 mAh battery, XTE LED BackLight |
10m retractable string Light, 100 RGB LED's 36 SMD front Light, power bank 2000 mAh battery, XTE LED BackLight |
Stellar Lighting Camping Lantern String Light 100 RGB LED 10m Warm White |
|
|
349.00000000 |
329M,538,512 |
894 |
INTA-STELLAR GROUP |
|
stellar-lighting-camping-lantern-string-light-100-rgb-led-10m-warm-white |
512/329 |
|
|
|
|
|
|
B |