Query time 0.00042
JSON explain
{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_ab__stickers.position",
"table": {
"table_name": "cscart_ab__stickers",
"access_type": "ref",
"possible_keys": ["PRIMARY", "c_status"],
"key": "c_status",
"key_length": "3",
"used_key_parts": ["status"],
"ref": ["const"],
"rows": 1,
"filtered": 100,
"index_condition": "cscart_ab__stickers.`status` = 'A' and (cscart_ab__stickers.usergroup_ids = '' or find_in_set(0,cscart_ab__stickers.usergroup_ids) or find_in_set(1,cscart_ab__stickers.usergroup_ids))",
"attached_condition": "cscart_ab__stickers.`status` <=> 'A' and find_in_set(1,cscart_ab__stickers.storefront_ids) and (cscart_ab__stickers.from_date <= 1727474400 or cscart_ab__stickers.from_date = 0) and (cscart_ab__stickers.to_date >= 1727474400 or cscart_ab__stickers.to_date = 0) and (cscart_ab__stickers.sticker_id = 0 or cscart_ab__stickers.`type` = 'D') and cscart_ab__stickers.display_on_lists not like '%"blocks/products/abt__yt_products_multicolumns_with_banners.tpl";s:11:"not_display"%'"
}
}
},
"table": {
"table_name": "descriptions",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["sticker_id", "lang_code"],
"ref": ["ymonline_livedata.cscart_ab__stickers.sticker_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(descriptions.lang_code = 'en')"
},
"table": {
"table_name": "images",
"access_type": "eq_ref",
"possible_keys": ["sticker"],
"key": "sticker",
"key_length": "9",
"used_key_parts": ["sticker_id", "lang_code"],
"ref": ["ymonline_livedata.cscart_ab__stickers.sticker_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(images.lang_code = 'en')",
"using_index": true
}
}
}