Query time 0.00471
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` = 286711) 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>((286711 = 286711)), 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 |
| 286711 |
WM1872BI |
P |
A |
598 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1661158101 |
1694434408 |
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 |
2269705044 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
Aesthetic Prophylaxis Filler Botox Mesotherapy |
|
|
|
<h5>We all love beauty and no one would forget a perfect smile. And precisely to give you such a smile, Aesthetic Stonatology was born. In general, it is used to refer to any dental work that improves the appearance of the teeth or gums. Cosmetic dentistry focuses primarily on improving dental aesthetics in color, position, shape, size, alignment and the overall appearance of your smile. It includes dental implants, white fillings, porcelain veneers, crowns and bridges, and whitening.</h5> |
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 |
Aesthetic Prophylaxis Filler Botox Mesotherapy- 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 |
22587 |
Pearl Dent |
|
|
|
|
|
profilaksi-estetike-filler-botox-mesoterap |
4001/4254 |
B |
|
|
N |
11/09/2023 |
11/09/2023 |
0 |
0 |
|
N |
N |
|
|