Madsex Posted November 16, 2021 Share Posted November 16, 2021 Salve, da diversi giorni mi ritrovo periodicamente delle query lente nel report del server e tali query sono francamente inutili e incomorensibili, ve ne riporto una, sapete xchè e da cosa vengono eseguite? In pratica vengono fatte query simili su tutte le tabelle: SELECT 1 FROM `_order_detail` WHERE (`id_order_detail` LIKE '%41808809%' OR `id_order` LIKE '%41808809%' OR `id_order_invoice` LIKE '%41808809%' OR `id_warehouse` LIKE '%41808809%' OR `id_shop` LIKE '%41808809%' OR `product_id` LIKE '%41808809%' OR `product_attribute_id` LIKE '%41808809%' OR `id_customization` LIKE '%41808809%' OR `product_name` LIKE '%41808809%' OR `product_quantity` LIKE '%41808809%' OR `product_quantity_in_stock` LIKE '%41808809%' OR `product_quantity_refunded` LIKE '%41808809%' OR `product_quantity_return` LIKE '%41808809%' OR `product_quantity_reinjected` LIKE '%41808809%' OR `product_price` LIKE '%41808809%' OR `reduction_percent` LIKE '%41808809%' OR `reduction_amount` LIKE '%41808809%' OR `reduction_amount_tax_incl` LIKE '%41808809%' OR `reduction_amount_tax_excl` LIKE '%41808809%' OR `group_reduction` LIKE '%41808809%' OR `product_quantity_discount` LIKE '%41808809%' OR `product_ean13` LIKE '%41808809%' OR `product_isbn` LIKE '%41808809%' OR `product_upc` LIKE '%41808809%' OR `product_reference` LIKE '%41808809%' OR `product_supplier_reference` LIKE '%41808809%' OR `product_weight` LIKE '%41808809%' OR `id_tax_rules_group` LIKE '%41808809%' OR `tax_computation_method` LIKE '%41808809%' OR `tax_name` LIKE '%41808809%' OR `tax_rate` LIKE '%41808809%' OR `ecotax` LIKE '%41808809%' OR `ecotax_tax_rate` LIKE '%41808809%' OR `discount_quantity_applied` LIKE '%41808809%' OR `download_hash` LIKE '%41808809%' OR `download_nb` LIKE '%41808809%' OR `download_deadline` LIKE '%41808809%' OR `total_price_tax_incl` LIKE '%41808809%' OR `total_price_tax_excl` LIKE '%41808809%' OR `unit_price_tax_incl` LIKE '%41808809%' OR `unit_price_tax_excl` LIKE '%41808809%' OR `total_shipping_price_tax_incl` LIKE '%41808809%' OR `total_shipping_price_tax_excl` LIKE '%41808809%' OR `purchase_supplier_price` LIKE '%41808809%' OR `original_product_price` LIKE '%41808809%' OR `original_wholesale_price` LIKE '%41808809%') LIMIT 1; Link to comment Share on other sites More sharing options...
codencode Posted November 16, 2021 Share Posted November 16, 2021 Sarà qualche modulo che hai aggiunto ad eseguirle, non mi sembra una query del core di Prestashop Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now