Query time 0.00336
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1.74"
},
"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` = 286710) 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": "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.56",
"data_read_per_join": "975"
},
"used_columns": [
"company_id",
"status",
"company",
"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.68",
"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.70",
"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.72",
"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.74",
"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>((286710 = 286710)), 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 |
| 286710 |
WM8591HZ |
P |
A |
598 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1661157675 |
1694434396 |
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 |
2982315010 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
Orthodontics |
|
|
|
<h5> Orthodontics is the special field of dentistry that corrects teeth and jaw alignment problems. It deals with the direction or movement of teeth improving the aesthetics and function of your teeth. Through orthodontic treatment, it becomes possible to straighten the teeth, to improve their aesthetic appearance, but also to facilitate the maintenance of dental hygiene, which is more difficult to maintain when the teeth are crooked. This treatment can be started from childhood, but it is best to wait for the emergence of as many teeth as possible before placement. While recently there are more and more adults who turn to this treatment.</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 |
Orthodontics - 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 |
27486 |
Pearl Dent |
|
|
|
|
|
ortodonci |
4001/4254 |
B |
|
|
N |
11/09/2023 |
11/09/2023 |
0 |
0 |
|
N |
N |
|
|