Query time 0.00126
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "24.19"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"cost_info": {
"sort_cost": "4.40"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_bm_snapping",
"access_type": "ALL",
"possible_keys": [
"grid_id"
],
"rows_examined_per_scan": 76,
"rows_produced_per_join": 21,
"filtered": "28.95",
"cost_info": {
"read_cost": "6.09",
"eval_cost": "2.20",
"prefix_cost": "8.29",
"data_read_per_join": "17K"
},
"used_columns": [
"snapping_id",
"block_id",
"grid_id",
"wrapper",
"user_class",
"order",
"status"
],
"attached_condition": "(`gaseus`.`cscart_bm_snapping`.`grid_id` in (1,2,3,4,7,8,9,10,81,13,14,15,20,22,16,21,32,33,34,35))"
}
},
{
"table": {
"table_name": "cscart_bm_blocks",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"block_id"
],
"key_length": "4",
"ref": [
"gaseus.cscart_bm_snapping.block_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "10.00",
"cost_info": {
"read_cost": "5.50",
"eval_cost": "0.22",
"prefix_cost": "15.99",
"data_read_per_join": "492"
},
"used_columns": [
"block_id",
"type",
"properties",
"company_id",
"storefront_id"
],
"attached_condition": "(`gaseus`.`cscart_bm_blocks`.`company_id` = 1)"
}
},
{
"table": {
"table_name": "cscart_bm_block_statuses",
"access_type": "ALL",
"possible_keys": [
"snapping_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"using_join_buffer": "hash join",
"cost_info": {
"read_cost": "0.51",
"eval_cost": "0.22",
"prefix_cost": "16.71",
"data_read_per_join": "264"
},
"used_columns": [
"snapping_id",
"object_ids",
"object_type"
],
"attached_condition": "<if>(is_not_null_compl(cscart_bm_block_statuses), ((`gaseus`.`cscart_bm_snapping`.`snapping_id` = `gaseus`.`cscart_bm_block_statuses`.`snapping_id`) and (`gaseus`.`cscart_bm_block_statuses`.`object_type` like 'products')), true)"
}
},
{
"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": [
"gaseus.cscart_bm_snapping.block_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.55",
"eval_cost": "0.22",
"prefix_cost": "17.48",
"data_read_per_join": "457"
},
"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": [
"gaseus.cscart_bm_snapping.block_id",
"const",
"gaseus.cscart_bm_blocks_descriptions.lang_code",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 2,
"filtered": "100.00",
"index_condition": "<if>(is_not_null_compl(default_content), (`gaseus`.`default_content`.`object_type` like ''), true)",
"cost_info": {
"read_cost": "0.55",
"eval_cost": "0.22",
"prefix_cost": "18.25",
"data_read_per_join": "492"
},
"used_columns": [
"snapping_id",
"object_id",
"object_type",
"block_id",
"lang_code",
"content"
]
}
},
{
"table": {
"table_name": "dynamic_object_content",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"block_id"
],
"key_length": "4",
"ref": [
"gaseus.cscart_bm_snapping.block_id"
],
"rows_examined_per_scan": 2,
"rows_produced_per_join": 4,
"filtered": "100.00",
"index_condition": "<if>(is_not_null_compl(dynamic_object_content), ((`gaseus`.`dynamic_object_content`.`object_id` = 3823) and (`gaseus`.`dynamic_object_content`.`lang_code` = `gaseus`.`cscart_bm_blocks_descriptions`.`lang_code`) and (`gaseus`.`dynamic_object_content`.`object_type` like 'products')), true)",
"cost_info": {
"read_cost": "1.10",
"eval_cost": "0.44",
"prefix_cost": "19.79",
"data_read_per_join": "985"
},
"used_columns": [
"object_id",
"object_type",
"block_id",
"lang_code",
"content"
]
}
}
]
}
}
}
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 |
| 3 |
4 |
|
0 |
|
|
4 |
|
|
0 |
D |
geo_maps_customer_location |
a:1:{s:8:"template";s:44:"addons/geo_maps/blocks/customer_location.tpl";} |
1 |
1 |
en |
Customer location |
| 9 |
8 |
|
0 |
|
|
8 |
|
top-search |
0 |
A |
template |
a:1:{s:8:"template";s:34:"blocks/static_templates/search.tpl";} |
1 |
1 |
en |
Search |
| 32 |
11 |
|
0 |
|
|
31 |
|
|
0 |
A |
breadcrumbs |
a:1:{s:8:"template";s:22:"common/breadcrumbs.tpl";} |
1 |
1 |
en |
Breadcrumbs |
| 33 |
12 |
|
0 |
|
|
32 |
|
|
0 |
A |
main |
|
1 |
1 |
en |
Main Content |
| 20 |
18 |
a:1:{s:7:"content";s:1302:"<ul style="list-style:none;margin:0;padding:0;display:flex;flex-direction:column;gap:12px;">
<li>
<img src="https://test.gaseus.es/images/logos/8/Gaseus_logo.png" alt="Gaseus" style="max-height:25px;display:block;">
</li>
<li style="display:flex;align-items:center;gap:10px;">
<!-- phone icon -->
<svg width="18" height="18" viewBox="0 0 24 24" fill="#13007B" xmlns="http://www.w3.org/2000/svg" aria-hidden="true">
<path d="M6.62 10.79a15.09 15.09 0 006.59 6.59l2.2-2.2a1 1 0 011.02-.24 11.36 11.36 0 003.56.57 1 1 0 011 1v3.61a1 1 0 01-1 1A17.79 17.79 0 014 6a1 1 0 011-1h3.61a1 1 0 011 1 11.36 11.36 0 00.57 3.56 1 1 0 01-.24 1.02l-2.32 2.21z"/>
</svg>
<a href="tel:+34655269608" style="font-size:16px;line-height:1;color:#13007B;text-decoration:none;">+34 655 269 608</a>
</li>
<li style="display:flex;align-items:center;gap:10px;">
<!-- mail icon -->
<svg width="18" height="18" viewBox="0 0 24 24" fill="#13007B" xmlns="http://www.w3.org/2000/svg" aria-hidden="true">
<path d="M20 4H4a2 2 0 00-2 2v12a2 2 0 002 2h16a2 2 0 002-2V6a2 2 0 00-2-2zm0 4l-8 5-8-5V6l8 5 8-5v2z"/>
</svg>
<a href="mailto:info@gaseus.es" style="font-size:16px;line-height:1;color:#13007B;text-decoration:none;">info@gaseus.es</a>
</li>
</ul>";} |
0 |
|
|
18 |
blocks/wrappers/footer_general.tpl |
footer-no-wysiwyg footer-contacts |
0 |
A |
safe_smarty_block |
a:1:{s:8:"template";s:28:"blocks/safe_smarty_block.tpl";} |
1 |
1 |
en |
Buy direct. Integrate to SAP. |
| 8 |
6 |
|
0 |
|
|
89 |
|
|
1 |
A |
template |
a:2:{s:8:"template";s:32:"blocks/static_templates/logo.tpl";s:11:"enable_link";s:1:"Y";} |
1 |
1 |
en |
Logo |
| 20 |
57 |
a:1:{s:4:"menu";s:1:"5";} |
0 |
|
|
98 |
blocks/wrappers/footer_general.tpl |
|
1 |
A |
menu |
a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"N";} |
1 |
1 |
en |
MAIN MENU |
| 1 |
1 |
a:1:{s:4:"text";s:0:"";} |
0 |
|
|
1 |
|
top-languages |
2 |
D |
languages |
a:3:{s:8:"template";s:20:"blocks/languages.tpl";s:6:"format";s:4:"icon";s:14:"dropdown_limit";s:1:"0";} |
1 |
1 |
en |
Languages |
| 4 |
5 |
|
0 |
|
|
5 |
blocks/wrappers/onclick_dropdown.tpl |
top-my-account |
2 |
A |
my_account |
a:1:{s:8:"template";s:21:"blocks/my_account.tpl";} |
1 |
1 |
en |
My Account |
| 81 |
9 |
|
0 |
|
|
9 |
|
top-cart-content |
2 |
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";} |
1 |
1 |
en |
Cart content |
| 10 |
10 |
a:1:{s:4:"menu";s:1:"2";} |
0 |
|
|
10 |
|
top-menu |
2 |
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:"6";} |
1 |
1 |
en |
Main menu |
| 22 |
19 |
|
0 |
|
|
19 |
|
|
2 |
A |
template |
a:1:{s:8:"template";s:37:"blocks/static_templates/copyright.tpl";} |
1 |
1 |
en |
Copyright |
| 34 |
30 |
a:1:{s:5:"items";a:6:{s:7:"filling";s:7:"similar";s:5:"limit";s:1:"4";s:13:"percent_range";s:0:"";s:16:"similar_category";s:1:"Y";s:15:"similar_subcats";s:1:"Y";s:16:"similar_in_stock";s:1:"Y";}} |
0 |
|
|
33 |
blocks/wrappers/mainbox_simple.tpl |
|
2 |
A |
products |
a:4:{s:8:"template";s:41:"blocks/products/products_multicolumns.tpl";s:11:"item_number";s:1:"N";s:17:"number_of_columns";s:1:"2";s:23:"hide_add_to_cart_button";s:1:"Y";} |
1 |
1 |
en |
Similar products |
| 35 |
31 |
a:1:{s:5:"items";a:6:{s:7:"filling";s:7:"similar";s:5:"limit";s:1:"3";s:13:"percent_range";s:1:"5";s:16:"similar_category";s:1:"N";s:15:"similar_subcats";s:1:"N";s:16:"similar_in_stock";s:1:"N";}} |
0 |
|
|
34 |
blocks/wrappers/mainbox_simple.tpl |
|
2 |
A |
products |
a:2:{s:8:"template";s:30:"blocks/products/short_list.tpl";s:23:"hide_add_to_cart_button";s:1:"Y";} |
1 |
1 |
en |
At the same price! |
| 20 |
59 |
a:1:{s:4:"menu";s:1:"6";} |
0 |
|
|
101 |
blocks/wrappers/footer_general.tpl |
|
2 |
A |
menu |
a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"N";} |
1 |
1 |
en |
LEGAL |
| 2 |
3 |
a:1:{s:4:"menu";s:1:"1";} |
0 |
|
|
3 |
|
top-quick-links |
3 |
D |
menu |
a:2:{s:8:"template";s:26:"blocks/menu/text_links.tpl";s:18:"show_items_in_line";s:1:"Y";} |
1 |
1 |
en |
Quick links |