Query time 0.00330
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` = 286708) 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>((286708 = 286708)), 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 |
| 286708 |
WM2261MP |
P |
A |
598 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1661157224 |
1694446300 |
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 |
2492171109 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
Surgery |
|
|
|
<h5>Oral surgery is the branch of dentistry that deals with surgical interventions in the oral cavity. Unfortunately, when a tooth is impossible to save because it may be too damaged and a filling is impossible, it is forced to remove it. The most widespread surgery is the removal of wisdom teeth, the removal of retained teeth. The most frequent interventions performed are biopsies and extractions of the remaining teeth and roots. Tooth extraction is a routine intervention in oral surgery. At Pearl Dent, it becomes possible to calm down and fully heal patients with abscesses and phlegmons of the teeth, with retained (retained) mature molars, which come out with difficulty due to lack of space in the patient's jaw and, as a result, with very strong pain; we fix all types of accidental jaw fractures by reshaping the broken bones to their previous state.</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 |
Surgery -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 |
26301 |
Pearl Dent |
|
|
|
|
|
kirurgji |
4001/4254 |
B |
|
|
N |
11/09/2023 |
11/09/2023 |
0 |
0 |
|
N |
N |
|
|