Jump to content

Strane query nei log


Madsex

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...