Query time 0.00273
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.76"
},
"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.20",
"prefix_cost": "0.00",
"data_read_per_join": "7K"
},
"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",
"master_product_id",
"master_product_status",
"master_product_offers_count",
"prestashop_product_id",
"prestashop_account_id",
"prestashop_is_parent",
"amz_condition",
"amz_condition_note",
"amz_product_id",
"amz_product_id_type",
"transfer_price",
"tax_value",
"ebay_template_id",
"product_hash",
"ebay_price",
"package_type",
"ebay_status",
"ebay_override_price",
"subscription_product",
"interval",
"interval_count",
"ec_rfq_product_type",
"ec_rfq_service_options"
]
}
},
{
"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.20",
"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.20",
"prefix_cost": "0.00",
"data_read_per_join": "16"
},
"used_columns": [
"category_id",
"product_id",
"amount"
]
}
},
{
"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": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "16"
},
"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": [
"webmarco.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.01",
"prefix_cost": "1.40",
"data_read_per_join": "303"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`webmarco`.`cscart_categories`.`storefront_id` in (0,1)) and ((`webmarco`.`cscart_categories`.`usergroup_ids` = '') or find_in_set(0,`webmarco`.`cscart_categories`.`usergroup_ids`) or find_in_set(1,`webmarco`.`cscart_categories`.`usergroup_ids`)) and (`webmarco`.`cscart_categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "cscart_product_prices",
"access_type": "range",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "usergroup",
"used_key_parts": [
"product_id",
"usergroup_id",
"lower_limit"
],
"key_length": "9",
"rows_examined_per_scan": 2,
"rows_produced_per_join": 0,
"filtered": "100.00",
"using_join_buffer": "Block Nested Loop",
"cost_info": {
"read_cost": "0.10",
"eval_cost": "0.02",
"prefix_cost": "1.52",
"data_read_per_join": "6"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "(<if>(found_match(cscart_product_prices), 1, true) and <if>(is_not_null_compl(cscart_product_prices), ((`webmarco`.`cscart_product_prices`.`lower_limit` = 1) and (`webmarco`.`cscart_product_prices`.`product_id` = 286707) and (`webmarco`.`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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.54",
"data_read_per_join": "699"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"ab__spt_short_name",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"ab__custom_product_h1",
"ebay_title",
"ebay_description",
"override",
"cls_stop_words",
"ec_rfq_request_btn_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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.56",
"data_read_per_join": "406"
},
"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": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.02",
"prefix_cost": "1.58",
"data_read_per_join": "975"
},
"used_columns": [
"company_id",
"status",
"ec_rfq_whatsapp_number",
"ec_rfq_phone_number",
"ec_rfq_bhf",
"ec_rfq_bht"
],
"attached_condition": "<if>(found_match(companies), ((`webmarco`.`companies`.`status` = 'A') or 0), true)"
}
},
{
"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.10",
"eval_cost": "0.02",
"prefix_cost": "1.70",
"data_read_per_join": "173"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"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.02",
"prefix_cost": "1.72",
"data_read_per_join": "2"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
},
{
"table": {
"table_name": "cscart_product_review_prepared_data",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"storefront_id"
],
"key_length": "7",
"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.02",
"prefix_cost": "1.74",
"data_read_per_join": "1"
},
"used_columns": [
"product_id",
"storefront_id",
"average_rating",
"reviews_count"
]
}
},
{
"table": {
"table_name": "cscart_ec_table_booking_system",
"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.02",
"prefix_cost": "1.76",
"data_read_per_join": "17"
},
"used_columns": [
"product_id",
"booking_type",
"quantity_selector",
"show_price_date",
"blocked_date",
"from_date",
"to_date",
"slot_time",
"free_time",
"days_data",
"minimum_booking_time"
],
"attached_condition": "<if>(is_not_null_compl(cscart_ec_table_booking_system), <cache>((286707 = 286707)), true)"
}
}
]
}
}
}
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 |
master_product_id |
master_product_status |
master_product_offers_count |
prestashop_product_id |
prestashop_account_id |
prestashop_is_parent |
amz_condition |
amz_condition_note |
amz_product_id |
amz_product_id_type |
transfer_price |
tax_value |
ebay_template_id |
product_hash |
ebay_price |
package_type |
ebay_status |
ebay_override_price |
subscription_product |
interval |
interval_count |
ec_rfq_product_type |
ec_rfq_service_options |
lang_code |
product |
shortname |
ab__spt_short_name |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
ab__custom_product_h1 |
ebay_title |
ebay_description |
override |
cls_stop_words |
ec_rfq_request_btn_text |
price |
category_ids |
popularity |
company_name |
ec_rfq_whatsapp_number |
ec_rfq_phone_number |
ec_rfq_bhf |
ec_rfq_bht |
sales_amount |
seo_name |
seo_path |
discussion_type |
average_rating |
product_reviews_count |
booking_type |
from_date |
to_date |
slot_time |
free_time |
days_data |
quantity_selector |
show_price_date |
blocked_date |
minimum_booking_time |
| 286707 |
WM5642TX |
P |
A |
598 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1661156214 |
1694508067 |
0 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
0 |
0 |
|
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;} |
activity |
0 |
|
0 |
A |
0 |
0 |
0 |
Y |
|
|
|
|
0.00 |
0.00 |
0 |
1130134915 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
Therapy |
|
|
|
<h4>Therapy includes root canal treatment by the dentist. Once a scary experience for patients, but now with modern dental techniques, it has become one of the most common practices. Advanced decay, tooth fractures or gum disease can kill the tooth and cause root canal symptoms such as root pain or tooth abscess. Pearl dent, with a long experience in therapy, and through the use of the latest materials and techniques, makes it possible for you not to feel any kind of annoyance or discomfort after the treatment of the tooth.</h4> |
dental, dentist, dentistry, smile, teeth, webmarco, Pearl Dent, L52101261V, dentists, odontology, dental care, tooth, dental clinic, dental hygienist, orthodontics, oral health, dental implants, dental hygiene, dental photography, paleness |
Dental and Aesthetic Clinic!
All kinds of services!
Therapy Surgery Orthopedics Orthodontics Aesthetic Prophylaxis Filler Botox Mesotherapy. |
dental, dentist, dentistry, smile, teeth, webmarco, Pearl Dent, L52101261V, dentists, odontology, dental care, tooth, dental clinic, dental hygienist, orthodontics, oral health, dental implants, dental hygiene, dental photography, paleness |
Therapy - Pearl Dent |
|
<button id="btnOpenForm">Book Now</button>
<div class="form-popup-bg">
<div class="form-container">
<button id="btnCloseForm" class="close-button">X</button>
<h1>Book a appointment</h1>
<form action="https://klinikadentarepearldent.com/" method="post" name="forms_form"
enctype="multipart/form-data" class="cm-processed-form">
<input type="hidden" name="fake" value="1">
<input type="hidden" name="page_id" value="308">
<div class="et-columns-wrapper wrap">
<div class="ty-control-group et-column2">
<label for="elm_1025" class="ty-control-group__title cm-required ">Name /
Surname</label>
<input id="elm_1025" class="ty-form-builder__input-text ty-input-text" size="50" type="text"
name="form_values[1025]" value="">
</div>
<div class="ty-control-group et-column2">
<label for="elm_1026" class="ty-control-group__title cm-required ">City </label>
<input id="elm_1026" class="ty-form-builder__input-text ty-input-text" size="50" type="text"
name="form_values[1026]" value="">
</div>
<div class="ty-control-group et-column2">
<label for="elm_1027" class="ty-control-group__title cm-required ">Phone</label>
<input id="elm_1027" class="ty-input-text " size="50" type="text" name="form_values[1027]" value="">
</div>
<div class="ty-control-group et-column2">
<label for="elm_1028" class="ty-control-group__title cm-required cm-email ">E-mail</label>
<input type="hidden" name="customer_email" value="1028">
<input id="elm_1028" class="ty-input-text " size="50" type="text" name="form_values[1028]" value="">
</div>
<div class="ty-control-group et-column2">
<label for="elm_1029" class="ty-control-group__title cm-required ">Dental
care</label>
<select id="elm_1029" class="ty-form-builder__select" name="form_values[1029]">
<option label="" value="">- Select -</option>
<option value="1036">Therapy</option>
<option value="1037">Surgery</option>
<option value="1038">Orthopedic</option>
<option value="1039">Orthodontic</option>
<option value="1040">Aesthetic Prophylaxis Filler Botox Mesotherapy</option>
</select>
</div>
<div class="ty-control-group et-column1">
<label for="elm_1030" class="ty-control-group__title cm-required ">Description</label>
<textarea id="elm_1030" class="ty-form-builder__textarea" name="form_values[1030]" cols="67"
rows="10"></textarea>
</div>
<div class="ty-control-group et-column2">
<label for="type_94c9e88749a5b093a03b3d6ead39f766"
class="ty-control-group__title cm-required ">Upload your ID Card</label>
<!-- Inline script moved to the bottom of the page -->
<!-- Inline script moved to the bottom of the page -->
<!-- Inline script moved to the bottom of the page -->
<div class="ty-fileuploader cm-fileuploader cm-field-container">
<input type="hidden" id="" value="">
<div class="ty-nowrap" id="file_uploader_94c9e88749a5b093a03b3d6ead39f766">
<div class="ty-fileuploader__file-section" id="message_94c9e88749a5b093a03b3d6ead39f766"
title="">
<p class="cm-fu-file hidden">
<i id="clean_selection_94c9e88749a5b093a03b3d6ead39f766" title="Remove this item"
onclick="Tygh.fileuploader.clean_selection(this.id); Tygh.fileuploader.toggle_links(this.id, 'show'); Tygh.fileuploader.check_required_field('94c9e88749a5b093a03b3d6ead39f766', '');"
class="ty-icon-cancel-circle ty-fileuploader__icon"></i>
<span class="ty-fileuploader__filename ty-filename-link"></span>
</p>
</div>
<div class="ty-fileuploader__file-link "
id="link_container_94c9e88749a5b093a03b3d6ead39f766"><input type="hidden"
name="file_fb_files[1031]" value="" id="file_94c9e88749a5b093a03b3d6ead39f766"
class="cm-fileuploader-field"><input type="hidden" name="type_fb_files[1031]"
value="" id="type_94c9e88749a5b093a03b3d6ead39f766" class="cm-fileuploader-field">
<div class="ty-fileuploader__file-local upload-file-local"><input type="file"
class="ty-fileuploader__file-input" name="file_fb_files[1031]"
id="local_94c9e88749a5b093a03b3d6ead39f766"
onchange="Tygh.fileuploader.show_loader(this.id); Tygh.fileuploader.toggle_links(this.id, 'hide'); Tygh.fileuploader.check_required_field('94c9e88749a5b093a03b3d6ead39f766', '');"
data-ca-empty-file=""
onclick="Tygh.$(this).removeAttr('data-ca-empty-file');"><a target="_top"
data-ca-multi="Y" class="hidden">Upload
another file</a><a target="_top"
data-ca-target-id="local_94c9e88749a5b093a03b3d6ead39f766" data-ca-multi="N"
class="ty-fileuploader__a">Upload file</a>
</div>
</div>
</div>
</div>
<!--fileuploader-->
</div>
</div>
<div class="ty-form-builder__buttons buttons-container1">
<button class="ty-btn__primary ty-btn" type="submit" name="dispatch[pages.send_form]">Submit</button>
</div>
<input type="hidden" name="security_hash" class="cm-no-hide-input" value="18d02155c53ce5de9df6318133393f54">
</form>
</div>
</div>
<style>
.form-popup-bg {
position: absolute;
top: 0;
left: 0;
right: 0;
bottom: 0;
display: flex;
flex-direction: column;
align-content: center;
justify-content: center;
}
.form-popup-bg {
position: fixed;
left: 0;
top: 0;
height: 100%;
width: 100%;
background-color: rgba(94, 110, 141, 0.9);
opacity: 0;
visibility: hidden;
-webkit-transition: opacity 0.3s 0s, visibility 0s 0.3s;
-moz-transition: opacity 0.3s 0s, visibility 0s 0.3s;
transition: opacity 0.3s 0s, visibility 0s 0.3s;
overflow-y: auto;
z-index: 11000;
}
.form-popup-bg.is-visible {
opacity: 1;
visibility: visible;
-webkit-transition: opacity 0.3s 0s, visibility 0s 0s;
-moz-transition: opacity 0.3s 0s, visibility 0s 0s;
transition: opacity 0.3s 0s, visibility 0s 0s;
}
@media screen and (max-width: 1024px) {
.form-container {
max-width: 300px !important;
}
}
.form-container {
background-color: rgb(247 247 247);
border-radius: 10px;
box-shadow: 0 10px 20px rgba(0, 0, 0, 0.19), 0 6px 6px rgba(0, 0, 0, 0.23);
display: flex;
flex-direction: column;
width: 100%;
max-width: 900px;
margin-left: auto;
margin-right: auto;
position: relative;
padding: 40px;
color: #fff;
}
.close-button {
background: none;
color: #fff;
width: 40px;
height: 40px;
position: absolute;
top: 0;
right: 0;
border: none;
font-weight: bolder;
}
.form-popup-bg:before {
content: '';
background-color: #fff;
opacity: .25;
position: absolute;
top: 0;
left: 0;
right: 0;
bottom: 0;
}
#et-product-page .et-promo-text *,
#et-quick-view .et-promo-text * {
color: rgb(0, 0, 0);
}
#btnCloseForm {
color: black;
}
.ty-btn__primary:hover,
.ty-btn__secondary:hover,
.ty-btn:hover,
.ty-btn-go:hover {
background: #48afa9;
color: #fff !important;
}
.ty-btn__primary,
.ty-btn__secondary,
.ty-btn,
.ty-btn-go {
background: #327975;
color: #fff !important;
}
@media (max-width: 979px) {
.ty-form-builder__textarea {
max-width: 300px;
height: 100px;
}
input[type="text"],
input[type="password"],
input[type="tel"],
input[type="number"],
select {
height: 40px;
max-width: 300px;
}
}
button#btnOpenForm {
background-color: #48afa9;
color: white !important;
border: none;
padding: 15px;
width: 100%;
font-size: 17px;
font-weight: bold;
}
.buttons-container1 {
padding: 17px 20px 17px 0px;
background: #f7f7f7;
}
#et-product-page.et-product-page-big .et-price-wrapper {
margin: 0 0 10px;
display: none;
}
</style>
<script>
function closeForm() {
$('.form-popup-bg').removeClass('is-visible');
}
$(document).ready(function ($) {
/* Contact Form Interactions */
$('#btnOpenForm').on('click', function (event) {
event.preventDefault();
$('.form-popup-bg').addClass('is-visible');
});
//close popup when clicking x or off popup
$('.form-popup-bg').on('click', function (event) {
if ($(event.target).is('.form-popup-bg') || $(event.target).is('#btnCloseForm')) {
event.preventDefault();
$(this).removeClass('is-visible');
}
});
});
</script> |
|
|
|
|
|
|
0.00000000 |
4254M |
23541 |
Pearl Dent |
|
|
|
|
|
terapi |
4001/4254 |
B |
|
|
N |
11/09/2023 |
11/09/2023 |
0 |
0 |
|
N |
N |
|
|