Query time 0.00099
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "28.71"
},
"nested_loop": [
{
"table": {
"table_name": "cscart_ult_language_values",
"access_type": "system",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "408"
},
"used_columns": [
"lang_code",
"name",
"value",
"company_id"
]
}
},
{
"table": {
"table_name": "lang",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"lang_code",
"name"
],
"key_length": "392",
"rows_examined_per_scan": 41,
"rows_produced_per_join": 41,
"filtered": "100.00",
"index_condition": "((`gaseus`.`lang`.`lang_code` = 'en') and (`gaseus`.`lang`.`name` in ('gdpr.klaro_accept_all','gdpr.klaro_accept_selected','gdpr.klaro_close','gdpr.klaro_consent_modal_description','gdpr.klaro_consent_modal_title','gdpr.klaro_consent_notice_change_description','gdpr.klaro_consent_notice_title','gdpr.klaro_consent_notice_description','gdpr.klaro_consent_notice_learn_more','gdpr.klaro_consent_notice_testing','gdpr.klaro_contextual_consent_accept_always','gdpr.klaro_contextual_consent_accept_once','gdpr.klaro_contextual_consent_description','gdpr.klaro_decline','gdpr.klaro_ok','gdpr.klaro_powered_by','gdpr.klaro_privacy_policy_title','gdpr.klaro_privacy_policy_name','gdpr.klaro_service','gdpr.klaro_services','gdpr.strictly_necessary_cookies_title','gdpr.strictly_necessary_cookies_description','gdpr.performance_cookies_title','gdpr.performance_cookies_description','gdpr.functional_cookies_title','gdpr.functional_cookies_description','gdpr.marketing_cookies_title','gdpr.marketing_cookies_description','gdpr.klaro_service_purpose','gdpr.klaro_service_purposes','gdpr.klaro_service_required_description','gdpr.eway_cookies_title','gdpr.eway_cookies_description','gdpr.disable_all_description','gdpr.disable_all_title','gdpr.opt_out_description','gdpr.opt_out_title','gdpr.klaro_service_required_title','gdpr.uk_cookies_law','gdpr.site_functionality_cookies_title','gdpr.site_functionality_cookies_description','gdpr.klaro_accept_all','gdpr.klaro_accept_selected','gdpr.klaro_close','gdpr.klaro_consent_modal_description','gdpr.klaro_consent_modal_title','gdpr.klaro_consent_notice_change_description','gdpr.klaro_consent_notice_title','gdpr.klaro_consent_notice_description','gdpr.klaro_consent_notice_learn_more','gdpr.klaro_consent_notice_testing','gdpr.klaro_contextual_consent_accept_always','gdpr.klaro_contextual_consent_accept_once','gdpr.klaro_contextual_consent_description','gdpr.klaro_decline','gdpr.klaro_ok','gdpr.klaro_powered_by','gdpr.klaro_privacy_policy_title','gdpr.klaro_privacy_policy_name','gdpr.klaro_service','gdpr.klaro_services','gdpr.strictly_necessary_cookies_title','gdpr.strictly_necessary_cookies_description','gdpr.performance_cookies_title','gdpr.performance_cookies_description','gdpr.functional_cookies_title','gdpr.functional_cookies_description','gdpr.marketing_cookies_title','gdpr.marketing_cookies_description','gdpr.klaro_service_purpose','gdpr.klaro_service_purposes','gdpr.klaro_service_required_description','gdpr.eway_cookies_title','gdpr.eway_cookies_description','gdpr.disable_all_description','gdpr.disable_all_title','gdpr.opt_out_description','gdpr.opt_out_title','gdpr.klaro_service_required_title','gdpr.uk_cookies_law','gdpr.site_functionality_cookies_title','gdpr.site_functionality_cookies_description')))",
"cost_info": {
"read_cost": "24.61",
"eval_cost": "4.10",
"prefix_cost": "28.71",
"data_read_per_join": "16K"
},
"used_columns": [
"lang_code",
"name",
"value"
]
}
}
]
}
}
Result
| name |
value |
| gdpr.disable_all_description |
Use this switch to enable or disable all services. |
| gdpr.disable_all_title |
Enable or disable all services |
| gdpr.eway_cookies_description |
eWAY is a payment provider. It allows us to accept payments, if you choose a payment method powered by eWAY. Here is <a href="https://www.eway.com.au/privacy-policy/" target="_blank">eWAY privacy policy</a>. |
| gdpr.eway_cookies_title |
eWAY |
| gdpr.functional_cookies_description |
These cookies enable additional functionality at the website. They may be set by third-party providers whose services we've added to the website. Those services may include many things, like maps, geolocation for preliminary shipping rate calculation, or the ability to sign in with your social network account. Without functional cookies, the parts of the site associated with these services may not work properly. |
| gdpr.functional_cookies_title |
Functional cookies |
| gdpr.klaro_accept_all |
Accept all |
| gdpr.klaro_accept_selected |
Accept selected |
| gdpr.klaro_close |
Close |
| gdpr.klaro_consent_modal_description |
Cookies we use |
| gdpr.klaro_consent_modal_title |
test.gaseus.es uses cookies that are strictly necessary for the website to function properly (for example, to keep you logged in and to remember your language and privacy preferences). We do not currently use analytics, advertising or social media cookies.
You can review this information at any time in our Privacy & Cookie Policy. If we introduce any additional types of cookies in the future, we will ask you for your consent again. |
| gdpr.klaro_consent_notice_change_description |
There have been changes to the way we use cookies. Please review your cookie settings and renew your consent. |
| gdpr.klaro_consent_notice_description |
Hi! We use only essential cookies on this site so that it works correctly (for example, to remember your session and your privacy preferences). We do not use analytics or advertising cookies.
You can read more in our Privacy & Cookie Policy and update your choices at any time. |
| gdpr.klaro_consent_notice_learn_more |
Let me choose |
| gdpr.klaro_consent_notice_testing |
Testing mode! |
| gdpr.klaro_consent_notice_title |
Cookie Consent |
| gdpr.klaro_contextual_consent_accept_always |
Always |
| gdpr.klaro_contextual_consent_accept_once |
'Yes' |
| gdpr.klaro_contextual_consent_description |
Do you want to load external content supplied by {title}? |
| gdpr.klaro_decline |
I decline |
| gdpr.klaro_ok |
That's ok |
| gdpr.klaro_powered_by |
Realized with Klaro! |
| gdpr.klaro_privacy_policy_name |
Privacy policy |
| gdpr.klaro_privacy_policy_title |
You can find out more in this document: {privacyPolicy}. |
| gdpr.klaro_service |
service |
| gdpr.klaro_services |
services |
| gdpr.klaro_service_purpose |
purpose |
| gdpr.klaro_service_purposes |
purposes |
| gdpr.klaro_service_required_description |
This service is always required |
| gdpr.klaro_service_required_title |
(always required) |
| gdpr.marketing_cookies_description |
These cookies are used by our advertising partners. They help them to measure promotion efficiency and serve you ads that are more relevant and less repetitive. This is usually achieved by remembering the browser and device that saw the ad. Turning these cookies off won't reduce the number of ads you see on the internet, but will make them less personalized. |
| gdpr.marketing_cookies_title |
Marketing cookies |
| gdpr.opt_out_description |
This service is enabled by default (but you can opt out) |
| gdpr.opt_out_title |
(opt-out) |
| gdpr.performance_cookies_description |
These cookies allow us to see how the website works. The information that these cookies help to collect is anonymous; it is typically presented in numbers. For example, these cookies help us see how often errors occur, how many unique visitors we have, or how long each page is viewed on average. Thanks to these cookies, we can improve the site for you. |
| gdpr.performance_cookies_title |
Performance cookies |
| gdpr.site_functionality_cookies_description |
These cookies serve the essential functions of the site. For example, they help the site remember that you put something in the cart or signed into your account. |
| gdpr.site_functionality_cookies_title |
Site functionality |
| gdpr.strictly_necessary_cookies_description |
These cookies are essential for the website to work properly. For example, they let you place an order, or help the site remember that you've signed into your account. That's why they can't be disabled through the site. You can configure your browser to disable even these cookies, but important parts of the site won't work without them. |
| gdpr.strictly_necessary_cookies_title |
Strictly necessary cookies |
| gdpr.uk_cookies_law |
Cookies are used on this site to provide the best possible user experience and to keep the service secure. By continuing to browse or by clicking “Accept all”, you agree to the use of essential cookies. You can change your cookie settings at any time in the Privacy & Cookie Policy. |