15 - Query:
select * from alc_third_party_code
Rows: 2
Headers: [id, name, description, script, tag_target, cookies_names, cookies_type, disable]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/page_content_ev.php line 27
14 - Query:
select alice_menus_items.*, alice_pages.name as page_name, alice_pages_languages.title, alice_pages_languages.slug, alice_pages_languages.url_redirect,alice_pages.disable_menu_link, alice_pages_languages.meta_image,alice_pages_languages.meta_title from alice_menus_items join alice_pages on alice_pages.id = alice_menus_items.id_alice_page join alice_pages_languages on alice_pages_languages.id_alice_pages = alice_pages.id where `alice_menus_items`.`id_alice_menu`= '2' and `alice_pages`.`published`= '1' and `alice_pages_languages`.`id_alice_languages`= '1' order by `index`
Rows: 0
Headers: []
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/menu_web_tree_ev.php line 46
13 - Query:
select * from alice_social_follow order by alice_social_follow.index
Rows: 2
Headers: [id, title, image, url, disable, index]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/blocks/social_follow_block.php line 13
12 - Query:
select alice_menus_items.*, alice_pages.name as page_name, alice_pages_languages.title, alice_pages_languages.slug, alice_pages_languages.url_redirect,alice_pages.disable_menu_link, alice_pages_languages.meta_image,alice_pages_languages.meta_title from alice_menus_items join alice_pages on alice_pages.id = alice_menus_items.id_alice_page join alice_pages_languages on alice_pages_languages.id_alice_pages = alice_pages.id where `alice_menus_items`.`id_alice_menu`= '1' and `alice_pages`.`published`= '1' and `alice_pages_languages`.`id_alice_languages`= '1' order by `index`
Rows: 152
Headers: [id, name, id_alice_menu, id_alice_page, id_alice_menu_items_parent, index, hidden, target, custom_class, anchor, ev, page_name, title, slug, url_redirect, disable_menu_link, meta_image, meta_title]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/menu_web_tree_ev.php line 46
11 - Query:
select * from alice_social_follow order by alice_social_follow.index
Rows: 2
Headers: [id, title, image, url, disable, index]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/blocks/social_follow_block.php line 13
10 - Query:
select prod_product_attributes.product_id,prod_product_attributes.price,prod_product_attributes.value,prod_attributes.name,prod_attributes.image as attribute,prod_attribute_languages.text as attribute_lang,prod_attributes.id as attribute_id from prod_product_attributes join prod_attributes on prod_attributes.id = prod_product_attributes.attribute_id join prod_attribute_languages on prod_attribute_languages.attribute_id = prod_attributes.id where `prod_product_attributes`.`product_id` in ('8448','8447','9947','2512','2526','2529','2530','2533','6379','9970','9972','19213','2534','5329','9944','2527','7491','9946','9973','2528','4194','9723','9746','10079','6381','2513','3474','5274','1950','2292','2517','2684','3470','3472','4945','5733','5736','5879','6263','6265') and `prod_attribute_languages`.`alice_language_id`= '1' order by prod_product_attributes.index
Rows: 0
Headers: []
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/products/entity_views/prod_product_list_ev.php line 175
9 - Query:
select prod_products.id,prod_products.slug,prod_products.title,prod_products.description,prod_products.photo,prod_products.sticker,prod_product_fee.price,prod_products.discounted_price,prod_products.discount_percentage,prod_products.title as category,prod_products.title as category_slug,prod_products.publication_date,prod_products.tags,prod_brands.name as brand_name,prod_brands.logo as brand_logo,prod_products.product_type_id,prod_product_states.name as state,prod_products.taxes_percentage,i.stock from prod_products left join prod_brands on brand_id=prod_brands.id left join prod_product_states on state_id=prod_product_states.id left join prod_product_fee on prod_product_fee.product_id = prod_products.id LEFT JOIN (
select product_id ,stock from prod_inventory
where id in (SELECT max(id) from prod_inventory GROUP BY product_id)
) i on i.product_id = prod_products.id where `prod_products`.`published`= '1' and `prod_products`.`sale_in_eshop`= '1' and `prod_product_fee`.`fee_id`= '1' and prod_product_fee.price > 0 group by prod_products.id order by i.stock desc limit 0, 40
Rows: 40
Headers: [id, slug, title, description, photo, sticker, price, discounted_price, discount_percentage, category, category_slug, publication_date, tags, brand_name, brand_logo, product_type_id, state, taxes_percentage, stock]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/products/entity_views/prod_product_list_ev.php line 30
8 - Query:
select alice_pages.name,alice_pages_languages.id_alice_pages,alice_pages_languages.slug,alice_pages_languages.title,alice_pages.id_alice_page_parent,alice_pages.disable_breadcrumb_link,alice_pages.published,alice_pages_languages.meta_description,alice_pages_languages.meta_keyword,alice_pages_languages.meta_title,alice_pages_languages.meta_image from alice_pages join alice_pages_languages on alice_pages_languages.id_alice_pages = alice_pages.id where `alice_pages_languages`.`id_alice_languages`= '1' order by alice_pages.index
Rows: 311
Headers: [name, id_alice_pages, slug, title, id_alice_page_parent, disable_breadcrumb_link, published, meta_description, meta_keyword, meta_title, meta_image]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/get_page_slug_ev.php line 11
7 - Query:
select prod_product_types_options.*,
prod_attributes.name as attribute,
prod_attribute_languages.text as attribute_lang,
prod_attribute_types.name as attribute_type,
prod_attribute_types.selector_type
from prod_product_types_options join prod_attributes on attribute_id = prod_attributes.id join prod_attribute_languages on prod_attribute_languages.attribute_id = prod_attributes.id join prod_attribute_types on prod_attributes.attribute_type_id = prod_attribute_types.id where `prod_product_types_options`.`product_type_id` in ('1','2','7','8','9','10','11','12','13','14','15','16','17','18') and `prod_attribute_languages`.`alice_language_id`= '1' order by prod_product_types_options.index
Rows: 0
Headers: []
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/products/entity_views/prod_product_list_ev.php line 27
6 - Query:
select * from prod_product_types
Rows: 14
Headers: [id, name, slug, attributes, options, measure_id, sale_measure_id, quantity_min, photo]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/products/entity_views/prod_product_list_ev.php line 27
5 - Query:
select * from prod_product_list_configs where `prod_product_list_configs`.`name`= '4303' and `prod_product_list_configs`.`alice_pages_id`= '1390'
Rows: 1
Headers: [id, name, num_products, paged, alice_pages_id, next_text, back_text, category_id, category_from_slug, brand_id, brand_from_slug, collection_id, collection_from_slug, listing_style, target_page, group_id, group_from_slug, type_id, type_from_slug, state_id, state_from_slug, compatibilities_field, compatibilities_value, compatibilities_from_slug, filter, attribute, order]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/products/entity_views/prod_product_list_ev.php line 407
4 - Query:
select * from alice_pages_section_blocks where `alice_pages_section_blocks`.`id_alice_pages`= '1390' order by alice_pages_section_blocks.section,alice_pages_section_blocks.index
Rows: 2
Headers: [id, id_alice_pages, section, index, block, value_reference, properties, last_updated]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/page_content_ev.php line 23
3 - Query:
select * from alice_pages_languages_images where `alice_pages_languages_images`.`id_pages_languages`= '4556'
Rows: 0
Headers: []
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/page_content_ev.php line 20
2 - Query:
select * from alice_pages_languages_contents where `alice_pages_languages_contents`.`id_pages_languages`= '4556'
Rows: 1
Headers: [id, name, id_pages_languages, content]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/page_content_ev.php line 18
1 - Query:
select alice_generictext_language.id,alice_generictexts.name,alice_generictext_language.value from alice_generictext_language join alice_generictexts on alice_generictext_language.id_generaltext = alice_generictexts.id where `alice_generictext_language`.`id_alice_language`= '1'
Rows: 117
Headers: [id, name, value]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/page_content_ev.php line 16
0 - Query:
select alice_pages.*,alice_pages_languages.*, alice_languages.name as language_name, alice_pages_languages.url_redirect,alice_languages.visible from alice_pages join alice_pages_languages on alice_pages_languages.id_alice_pages = alice_pages.id join alice_languages on alice_pages_languages.id_alice_languages = alice_languages.id where `alice_pages_languages`.`slug`= 'estestlistprod' and `alice_pages`.`published`= '1' order by alice_pages.index
Rows: 1
Headers: [id, name, description, layout, id_alice_page_parent, hide_header, hide_footer, published, debug_mode, cache_mode, custom_header, custom_footer, last_updated, publish_date, disable_menu_link, disable_breadcrumb_link, notinmenu, private, body_script_end, custom_webconfig_json, index, custom_css, slug, title, meta_title, meta_description, meta_keyword, meta_image, no_index, no_follow, id_alice_pages, id_alice_languages, url_redirect, head_scripts, body_class, language_name, visible]
From: /var/www/vhosts/flordepatch.es/eshop_alcware/alice/apps/web/entity_views/page_content_ev.php line 96
