Query time 0.00237
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` = 286709) 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>((286709 = 286709)), 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 |
| 286709 |
WM2607QK |
P |
A |
598 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1661157465 |
1694435874 |
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 |
2303686213 |
|
Letter |
|
N |
N |
day |
|
P |
|
en |
Orthopedics |
|
|
|
<h5>The absence of one or more teeth is not only an aesthetic problem, but also a concern in terms of damage to chewing skills. For this reason, their replacement should be done as soon as possible, using alternative methods. Replacement can be done through bridges or plants. In other cases, when the tooth presents extensive crown damage, replacement can be done using a pinlay and case. Tooth replacement alternatives are provided through: Kellefave: metal, metal-porcelain, full-porcelain, zircon; Bridges (when the teeth are on the side of the defect); Inlay, onlay, pinlay implants; Removable partial dentures. At Pearl dent you will find maximum care for your smile..</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 |
Orthopedics - 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 |
26475 |
Pearl Dent |
|
|
|
|
|
ortopedi |
4001/4254 |
B |
|
|
N |
11/09/2023 |
11/09/2023 |
0 |
0 |
|
N |
N |
|
|