Query time 0.00139
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.06"
},
"nested_loop": [
{
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "9K"
},
"used_columns": [
"company_id",
"status",
"company",
"lang_code",
"address",
"city",
"state",
"country",
"zipcode",
"email",
"phone",
"url",
"storefront",
"secure_storefront",
"entry_page",
"redirect_customer",
"countries_list",
"timestamp",
"shippings",
"logos",
"request_user_id",
"request_account_name",
"request_account_data",
"pre_moderation",
"pre_moderation_edit",
"pre_moderation_edit_vendors",
"plan_id",
"sd_vendor_helper",
"identifier_facebook_pixel",
"stripe_connect_account_id",
"tax_number",
"facebook_pixel_id",
"facebook_api_token",
"handling_time_us",
"handling_time_uk",
"handling_time_it",
"handling_time_in",
"handling_time_mx",
"handling_time_es",
"handling_time_de",
"handling_time_fr",
"handling_time_cn",
"handling_time_ca",
"handling_time_jp",
"handling_time",
"blocked_date",
"booking_data",
"stripe_connect_account_type",
"registered_from_storefront_id",
"ec_rfq_whatsapp_number",
"ec_rfq_phone_number",
"ec_rfq_bhf",
"ec_rfq_bht",
"sd_ga_tracking_code",
"sd_ga_api_secret"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "3K"
},
"used_columns": [
"company_id",
"lang_code",
"company_description",
"terms",
"meta_keywords",
"meta_description",
"page_title",
"i18n_company",
"i18n_address",
"i18n_city"
]
}
},
{
"table": {
"table_name": "cscart_vendor_plan_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"plan_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"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": "792"
},
"used_columns": [
"plan_id",
"lang_code",
"plan"
]
}
},
{
"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": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "1.20",
"data_read_per_join": "1K"
},
"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": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.20",
"prefix_cost": "2.40",
"data_read_per_join": "24"
},
"used_columns": [
"thread_id",
"object_id",
"object_type"
]
}
},
{
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": [
"thread_id",
"thread_id_2"
],
"key": "thread_id_2",
"used_key_parts": [
"thread_id",
"status"
],
"key_length": "6",
"ref": [
"webmarco.cscart_discussion.thread_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.00",
"eval_cost": "0.24",
"prefix_cost": "3.64",
"data_read_per_join": "532"
},
"used_columns": [
"post_id",
"thread_id",
"status"
]
}
},
{
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"thread_id"
],
"key": "PRIMARY",
"used_key_parts": [
"post_id"
],
"key_length": "3",
"ref": [
"webmarco.cscart_discussion_posts.post_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.19",
"eval_cost": "0.24",
"prefix_cost": "5.06",
"data_read_per_join": "19"
},
"used_columns": [
"rating_value",
"post_id",
"thread_id"
],
"attached_condition": "<if>(is_not_null_compl(cscart_discussion_rating), (`webmarco`.`cscart_discussion_rating`.`thread_id` = `webmarco`.`cscart_discussion`.`thread_id`), true)"
}
}
]
}
}
Result
| company_id |
lang_code |
company_description |
terms |
meta_keywords |
meta_description |
page_title |
i18n_company |
i18n_address |
i18n_city |
status |
company |
address |
city |
state |
country |
zipcode |
email |
phone |
url |
storefront |
secure_storefront |
entry_page |
redirect_customer |
countries_list |
timestamp |
shippings |
logos |
request_user_id |
request_account_name |
request_account_data |
pre_moderation |
pre_moderation_edit |
pre_moderation_edit_vendors |
plan_id |
sd_vendor_helper |
identifier_facebook_pixel |
stripe_connect_account_id |
tax_number |
facebook_pixel_id |
facebook_api_token |
handling_time_us |
handling_time_uk |
handling_time_it |
handling_time_in |
handling_time_mx |
handling_time_es |
handling_time_de |
handling_time_fr |
handling_time_cn |
handling_time_ca |
handling_time_jp |
handling_time |
blocked_date |
booking_data |
stripe_connect_account_type |
registered_from_storefront_id |
ec_rfq_whatsapp_number |
ec_rfq_phone_number |
ec_rfq_bhf |
ec_rfq_bht |
sd_ga_tracking_code |
sd_ga_api_secret |
plan |
seo_name |
seo_path |
average_rating |
company_thread_ids |
| 284 |
it |
<h3><span style="color:rgb(79,129,189);"></span></h3>
<h3 class="text-center"><span style="color:rgb(79,129,189);"><img src="https://webmarco.com/images/All%20vendors/Malice%20Profumeria/aboutmelicecrop.png?1626775594769" alt="aboutmelicecrop.png?1626775594769" /></span></h3>
<h1 class="text-center"><span style="color:rgb(79,129,189);">Perfumery, Goldsmith </span></h1>
<h1 class="text-center"><span style="color:rgb(79,129,189);"> and Fashion Accessories ...</span></h1>
<h3 class="text-center"><span style="color:rgb(79,129,189);"> in Manerba del Garda </span></h3>
<h3 class="text-center"><span style="color:rgb(79,129,189);"><br /></span></h3>
<h4 class="text-center">Malice Perfumery in Manerba del Garda offers you not only products of the best brands for beauty and body hygiene but also numerous beauty services for women and men in our Aesthetic Center.<br /> At Malice perfumery, you can buy cosmetics dedicated to all skin types, make-up products, sun creams and oils for the summer and products for the treatment of your hair. <br /> The expert and qualified staff of the perfumery will always be at your disposal to assist you and recommend the products for your every need.<br /> In our Beauty Center we carry out for her and for him: face and body treatments, massages, hair removal, pedicure and manicure, pressotherapy, solarium, day/evening make-up and brides personalized packages and much more.<br /> Call now to find out more about our services and book your session.</h4>
<h4 class="text-justify"><span style="color:rgb(23,54,93);"></span></h4>
<p><span style="color:rgb(34,34,34);font-size:24px;font-weight:700;"></span></p>
<h1 class="text-center"><em><span style="color:rgb(31,73,125);">Aesthetic treatments at the perfumery of Manerba del Garda</span></em></h1>
<h4 class="text-center">The Malice perfumery is located in Manerba del Garda to offer you numerous collections of products for the care,<br /> personal hygiene and beauty of the face, body and hair, selecting for you only the most prestigious and most requested brands in the sector. The perfumery is also a beauty centre <br />and offers numerous treatments, from manicures to pedicures, from pressotherapy to laser hair removal, from bridal make-up to the solarium. Call now to request your beauty treatment.</h4>
<p><br /></p>
<p></p>
<p><br /></p>
<h1 class="text-center"><span style="color:rgb(79,129,189);"><strong><em>Face, body and make-up cosmetics<img src="https://webmarco.com/images/All%20vendors/Malice%20Profumeria/4271feb4-d9ea-4049-a4a2-2b92fe93a5a4-2880w.png?1626782856071" style="width:133px;height:210px;" width="133" height="210" alt="4271feb4-d9ea-4049-a4a2-2b92fe93a5a4-2880w.png?1626782856071" /></em></strong></span></h1><p><br /></p>
<p></p>
<h4 class="text-center">Malice Perfumery offers very high-quality cosmetic items, specific for the face and body and make-up<br /> products of the best brands on the market, to satisfy the requests of the most demanding customers.<br /> Among the brands present you will find Mesauda Milano, Elizabeth Arden, Shiseido, Collistar, Polì, Aesthetic Project and many others.</h4><p><br /></p>
<p></p>
<p><br /></p>
<p><span style="color:rgb(23,54,93);background-color:rgb(255,255,255);"></span></p>
<p><strong><span style="color:rgb(79,129,189);"></span></strong></p> |
|
Malice Profumeria & Estetica, Aesthetic center, beauty services web |
Malice Profumeria & Estetica - Malice Perfumery in Manerba del Garda offers you not only products of the best brands for beauty and body hygiene but also numerous beauty services for women and men in our Aesthetic Center. |
Malice Profumeria & Estetica - Aesthetic treatments |
Malice Profumeria & Estetica |
Via Gassman, 7 CROCIALE |
Manerba del Garda |
A |
Malice Profumeria & Estetica |
Via Gassman, 7 CROCIALE |
Manerba del Garda |
25 |
IT |
25080 |
malice.pgmsrls@gmail.com |
+393486654434 |
https://maliceprofumeriaestetica.it/? |
|
|
none |
Y |
|
1624002233 |
10,9,48,49 |
|
0 |
|
|
N |
N |
N |
10 |
245489369 |
|
|
|
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
Marco 499€ |
malice-profumeria-and-estetico |
|
|
284_0 |