Query time 0.00158
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "128.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "54.00"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_bm_snapping",
"access_type": "range",
"possible_keys": [
"grid_id"
],
"key": "grid_id",
"used_key_parts": [
"grid_id"
],
"key_length": "4",
"rows_examined_per_scan": 27,
"rows_produced_per_join": 27,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`cscart_bm_snapping`.`grid_id` in (191,195,200,201,194,196,199,197,329,513,212,213,541,538,188,539,542,498,540,543,545,544,548))",
"cost_info": {
"read_cost": "15.21",
"eval_cost": "2.70",
"prefix_cost": "17.91",
"data_read_per_join": "20K"
},
"used_columns": [
"snapping_id",
"block_id",
"grid_id",
"wrapper",
"user_class",
"order",
"status"
]
}
},
{
"table": {
"table_name": "cscart_bm_block_statuses",
"access_type": "ref",
"possible_keys": [
"snapping_id"
],
"key": "snapping_id",
"used_key_parts": [
"snapping_id"
],
"key_length": "4",
"ref": [
"cscartdb.cscart_bm_snapping.snapping_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 27,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.75",
"eval_cost": "2.70",
"prefix_cost": "27.36",
"data_read_per_join": "3K"
},
"used_columns": [
"snapping_id",
"object_ids",
"object_type"
],
"attached_condition": "<if>(is_not_null_compl(cscart_bm_block_statuses), ((`cscartdb`.`cscart_bm_snapping`.`snapping_id` = `cscartdb`.`cscart_bm_block_statuses`.`snapping_id`) and (`cscartdb`.`cscart_bm_block_statuses`.`object_type` like 'products')), true)"
}
},
{
"table": {
"table_name": "cscart_bm_blocks",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"block_id"
],
"key_length": "4",
"ref": [
"cscartdb.cscart_bm_snapping.block_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 27,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.75",
"eval_cost": "2.70",
"prefix_cost": "36.81",
"data_read_per_join": "5K"
},
"used_columns": [
"block_id",
"type",
"properties",
"company_id",
"storefront_id"
]
}
},
{
"table": {
"table_name": "cscart_bm_blocks_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"block_id",
"lang_code"
],
"key_length": "10",
"ref": [
"cscartdb.cscart_bm_snapping.block_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 27,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.75",
"eval_cost": "2.70",
"prefix_cost": "46.26",
"data_read_per_join": "5K"
},
"used_columns": [
"block_id",
"lang_code",
"name"
]
}
},
{
"table": {
"table_name": "default_content",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"block_id",
"snapping_id",
"lang_code",
"object_id"
],
"key_length": "18",
"ref": [
"cscartdb.cscart_bm_snapping.block_id",
"const",
"cscartdb.cscart_bm_blocks_descriptions.lang_code",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 27,
"filtered": "100.00",
"cost_info": {
"read_cost": "6.75",
"eval_cost": "2.70",
"prefix_cost": "55.71",
"data_read_per_join": "5K"
},
"used_columns": [
"snapping_id",
"object_id",
"object_type",
"block_id",
"lang_code",
"content"
],
"attached_condition": "<if>(is_not_null_compl(default_content), (`cscartdb`.`default_content`.`object_type` like ''), true)"
}
},
{
"table": {
"table_name": "dynamic_object_content",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"block_id"
],
"key_length": "4",
"ref": [
"cscartdb.cscart_bm_snapping.block_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 54,
"filtered": "100.00",
"cost_info": {
"read_cost": "13.50",
"eval_cost": "5.40",
"prefix_cost": "74.61",
"data_read_per_join": "11K"
},
"used_columns": [
"object_id",
"object_type",
"block_id",
"lang_code",
"content"
],
"attached_condition": "<if>(is_not_null_compl(dynamic_object_content), ((`cscartdb`.`dynamic_object_content`.`object_id` = 7378) and (`cscartdb`.`dynamic_object_content`.`lang_code` = `cscartdb`.`cscart_bm_blocks_descriptions`.`lang_code`) and (`cscartdb`.`dynamic_object_content`.`object_type` like 'products')), true)"
}
}
]
}
}
}
Result
grid_id |
block_id |
content |
object_id |
object_type |
object_ids |
snapping_id |
wrapper |
user_class |
order |
status |
type |
properties |
company_id |
storefront_id |
lang_code |
name |
540 |
4 |
|
0 |
|
|
601 |
blocks/wrappers/onclick_dropdown.tpl |
my-account-section |
0 |
A |
my_account |
a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} |
0 |
1 |
en |
Account |
538 |
9 |
a:1:{s:4:"menu";s:1:"5";} |
0 |
|
|
602 |
|
burger |
0 |
A |
menu |
a:3:{s:8:"template";s:35:"blocks/menu/dropdown_horizontal.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:1:"0";} |
0 |
1 |
en |
Burger Menu |
212 |
10 |
|
0 |
|
|
236 |
|
|
0 |
A |
breadcrumbs |
a:1:{s:8:"template";s:22:"common/breadcrumbs.tpl";} |
0 |
1 |
en |
Breadcrumbs |
213 |
11 |
|
0 |
|
|
237 |
|
|
0 |
A |
main |
|
0 |
1 |
en |
Main Content |
195 |
65 |
a:1:{s:5:"items";a:3:{s:7:"filling";s:13:"full_tree_cat";s:18:"parent_category_id";s:0:"";s:7:"sort_by";s:8:"position";}} |
0 |
|
|
609 |
blocks/wrappers/footer_general.tpl |
footer-menu-items |
0 |
A |
categories |
a:3:{s:8:"template";s:52:"blocks/categories/categories_dropdown_horizontal.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:1:"6";} |
0 |
1 |
en |
Shop |
539 |
65 |
a:1:{s:5:"items";a:3:{s:7:"filling";s:13:"full_tree_cat";s:18:"parent_category_id";s:0:"";s:7:"sort_by";s:8:"position";}} |
0 |
|
|
599 |
|
main-nav |
0 |
A |
categories |
a:3:{s:8:"template";s:52:"blocks/categories/categories_dropdown_horizontal.tpl";s:30:"dropdown_second_level_elements";s:2:"12";s:29:"dropdown_third_level_elements";s:1:"6";} |
0 |
1 |
en |
Shop |
329 |
66 |
|
0 |
|
|
216 |
blocks/wrappers/footer_general.tpl |
|
0 |
A |
template |
a:1:{s:8:"template";s:56:"addons/newsletters/blocks/static_templates/subscribe.tpl";} |
0 |
1 |
en |
Sign Up For News & Updates |
196 |
67 |
|
0 |
|
|
608 |
blocks/wrappers/footer_general.tpl |
|
0 |
A |
template |
a:1:{s:8:"template";s:44:"blocks/static_templates/my_account_links.tpl";} |
0 |
1 |
en |
Account |
513 |
150 |
a:1:{s:7:"content";s:89:"<div class="scroll-to-top">
<span class="btn btn-position btn-style"></span>
</div>";} |
0 |
|
|
581 |
|
|
0 |
A |
html_block |
a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} |
0 |
1 |
en |
Scroll to Top Btn |
191 |
171 |
a:1:{s:7:"content";s:317:"<div class="proudly" id="map-container" style="padding-top:41px;padding-bottom:31px">
<h3>Now welcoming international shops shipping to the United States</h3>
<img style="display:block; margin:auto; margin-top:31px; margin-bottom:31px" src="https://static.spicycdn.com/Group 1079.png" alt="Spicerack World">
</div>";} |
0 |
|
|
610 |
|
|
0 |
A |
html_block |
a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} |
0 |
1 |
en |
Proudly Featuring... |
545 |
189 |
|
0 |
|
|
629 |
|
|
0 |
A |
template |
a:1:{s:8:"template";s:46:"blocks/static_templates/header_burger_menu.tpl";} |
0 |
1 |
en |
Custom Burger Menu |
544 |
207 |
|
0 |
|
|
656 |
|
|
0 |
A |
template |
a:1:{s:8:"template";s:51:"blocks/static_templates/shop_portal_header_icon.tpl";} |
0 |
1 |
en |
Shop Portal Login |
329 |
5 |
|
0 |
|
|
370 |
|
|
1 |
A |
template |
a:2:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";s:11:"enable_link";s:1:"Y";} |
0 |
1 |
en |
Logo |
544 |
208 |
|
0 |
|
|
657 |
|
|
1 |
A |
template |
a:1:{s:8:"template";s:42:"blocks/static_templates/favorites_list.tpl";} |
0 |
1 |
en |
Wishlist |
542 |
5 |
|
0 |
|
|
209 |
|
top-logo |
2 |
A |
template |
a:2:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";s:11:"enable_link";s:1:"Y";} |
0 |
1 |
en |
Logo |
543 |
7 |
|
0 |
|
|
210 |
|
top-search |
2 |
A |
template |
a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} |
0 |
1 |
en |
Search |
329 |
13 |
a:1:{s:7:"content";s:1217:"<div class="footer-social-links ty-social-link-block">
<div class="ty-social-link reddit">
<a target="_blank" href="https://www.reddit.com/r/spicerackcommunity" aria-label="Visit us on Reddit">
<i class="fa-brands fa-reddit-alien"></i>
</a>
</div>
<div class="ty-social-link instagram">
<a target="_blank" href="https://www.instagram.com/spicerackmarket/" aria-label="Visit us on Instagram">
<i class="fa-brands fa-instagram"></i>
</a>
</div>
<div class="ty-social-link twitter">
<a target="_blank" href="https://twitter.com/spicerackmarket" aria-label="Visit us on Twitter">
<i class="fa-brands fa-x-twitter"></i>
</a>
</div>
<div class="ty-social-link youtube">
<a target="_blank" href="https://www.youtube.com/@SpiceRackMarket" aria-label="Visit us on YouTube">
<i class="fa-brands fa-youtube"></i>
</a>
</div>
<div class="ty-social-link tiktok">
<a target="_blank" href="https://www.tiktok.com/@spicerack.market" aria-label="Visit us on TikTok">
<i class="fa-brands fa-tiktok"></i>
</a>
</div>
</div>";} |
0 |
|
|
217 |
|
|
2 |
A |
safe_smarty_block |
a:1:{s:8:"template";s:28:"blocks/safe_smarty_block.tpl";} |
0 |
1 |
en |
Social links |
200 |
18 |
|
0 |
|
|
223 |
|
|
2 |
A |
template |
a:1:{s:8:"template";s:37:"blocks/static_templates/copyright.tpl";} |
0 |
1 |
en |
Copyright |
201 |
19 |
|
0 |
|
|
224 |
|
|
2 |
A |
template |
a:1:{s:8:"template";s:41:"blocks/static_templates/payment_icons.tpl";} |
0 |
1 |
en |
Payment icons |
197 |
69 |
a:1:{s:7:"content";s:1350:"<ul id="demo_store_links">
<li class="ty-footer-menu__item"><a href="{"pages.view?page_id=1"|fn_url}">About Us</a></li>
<li class="ty-footer-menu__item"><a href="https://support.spicerack.market/hc/en-us/requests/new?ticket_form_id=20958920807565">Contact</a></li>
<li class="ty-footer-menu__item"><a href="https://support.spicerack.market">FAQ</a></li>
<li class="ty-footer-menu__item"><a href="?dispatch=pages.view&page_id=27">Become a Seller</a></li>
<li class="ty-footer-menu__item"><a href="https://support.spicerack.market/hc/en-us/sections/21071699167117-Seller-Guide-Policies" target="_blank" rel="noopener" aria-label="Visit us on Help Desk">Seller Guide</a></li>
<!--<li class="ty-footer-menu__item"><a href="{"product_features.view_all?filter_id=10"|fn_url}">Our Brands</a></li>-->
<li class="ty-footer-menu__item"><a href="https://blog.spicerack.market" target="_blank" rel="noopener">Blog</a></li>
{if $auth.user_id}<li class="ty-footer-menu__item"><a href="{"orders.search"|fn_url}">Order Status</a></li>{/if}
{if $settings.General.enable_compare_products == 'Y'}
<li class="ty-footer-menu__item"><a href="{"product_features.compare"|fn_url}">Comparison List</a></li>
{/if}
</ul>";} |
0 |
|
|
220 |
blocks/wrappers/footer_general.tpl |
footer-no-wysiwyg |
2 |
A |
safe_smarty_block |
a:1:{s:8:"template";s:28:"blocks/safe_smarty_block.tpl";} |
0 |
1 |
en |
Information |
498 |
170 |
a:3:{s:5:"width";s:4:"100%";s:6:"height";s:4:"20px";s:5:"items";a:2:{s:7:"filling";s:8:"manually";s:8:"item_ids";s:2:"23";}} |
0 |
|
|
605 |
|
a-banner-container |
2 |
A |
banners |
a:1:{s:8:"template";s:34:"addons/banners/blocks/original.tpl";} |
0 |
1 |
en |
Announcement Banner |
544 |
209 |
|
0 |
|
|
658 |
|
|
2 |
A |
template |
a:1:{s:8:"template";s:41:"blocks/static_templates/messages_icon.tpl";} |
0 |
1 |
en |
Messages |
544 |
8 |
|
0 |
|
|
212 |
|
top-cart-content |
3 |
A |
cart_content |
a:5:{s:8:"template";s:23:"blocks/cart_content.tpl";s:22:"display_bottom_buttons";s:1:"Y";s:20:"display_delete_icons";s:1:"Y";s:19:"products_links_type";s:5:"thumb";s:20:"generate_block_title";s:1:"Y";} |
0 |
1 |
en |
Cart content |
544 |
216 |
a:1:{s:7:"content";s:142:"<span class="search_ico"><i class="fa-solid fa-magnifying-glass"></i></span><br><span class="menu_ico"><i class="fa-solid fa-bars"></i></span>";} |
0 |
|
|
671 |
|
icons_top_menu |
4 |
A |
html_block |
a:1:{s:8:"template";s:21:"blocks/html_block.tpl";} |
0 |
1 |
en |
Search Icon & Menu |