SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    286549, 286550, 286548, 286579, 286581, 
    286551, 286580, 114763, 114756, 114755, 
    114747, 114761
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00061

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "16.83"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 12,
      "rows_produced_per_join": 12,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "14.43",
        "eval_cost": "2.40",
        "prefix_cost": "16.83",
        "data_read_per_join": "81K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_descriptions`.`product_id` in (286549,286550,286548,286579,286581,286551,286580,114763,114756,114755,114747,114761)) and (`webmarco`.`cscart_product_descriptions`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id short_description full_description
114747 <p>The anti-slip treatment is now required in all those areas with high traffic in the presence of wet and NOT surfaces: poolside, changing rooms, canteens, gyms, shopping centers, schools, institutes, public buildings, exhibition halls, airports, retirement homes, etc. .</p> <p>How does the anti-slip treatment work? The natural porosity of mineral surfaces is exploited (ceramic, stoneware, clinker, polished terracotta, natural stone, etc.), where, thanks to a "controlled cleaning" operation of the micropores from residual silica (deriving from the production process), invisible and water-sensitive micro-suction cups.</p> <p>With the anti-slip treatment, by intervening on the removable mineralogical structure, the surface is not damaged and increases friction up to 830 times, making the surface extremely safe.</p> <p>Our strengths: Speed, Reliability, Discretion, Accuracy, Experience, Versatility.<br /></p>
114755 <p>Nanotechnology is the science of the future that allows us to enter the world of the infinitely small, we work at an atomic scale of the order of a millionth of a millimeter and in this way we can give the treated surfaces new properties.</p> <p>The protective treatment is based on nano-molecules of Silica or Silicon Dioxide SiO2 and once applied to the substrate to be protected it does not alter its appearance, consistency, color or breathability. Furthermore, the protective treatment is a BIO protection.</p> <p>In fact, silica is a mineral that is used among other things by sugar cane and many cereals to build their structure. It is used in electronic engineering, in the construction of integrated circuits, transistors and other electronic components.</p> <p>In homeopathic medicine, silica is recommended for colds, gum abscesses, headaches and digestive disorders. With good reason it can therefore be considered BIO, with the advantages that it does not leave residues, has no odor, and does not create films.</p> <p>All types of surfaces can be protected, also optimizing the micro porosities of those surfaces that are very smooth to the touch, such as glass, steel, ceramic, natural stones, etc. The nano molecules of silica are conveyed through water or ethanol, and the treated surfaces become therefore water-repellent, oil-repellent, anti-mold, anti-limestone and have a significant reduction of their bacterial load (since bacteria are larger than nano-molecules and therefore tend to "float" on them).</p> <p>Features<br />Resistance to mechanical stress;<br />resistance to extreme temperatures (-35 ° C; +450 ° C);<br />chemical resistance (pH 3 - pH 13);<br />high breathability of the treatment 99.7%;<br />UV stability;<br />ease of application with low costs;<br />reduction of cleaning and maintenance cycles.<br />Duration<br />They last for years in accordance with the wear of the treated surface;<br />a treated surface requires less use of chemicals and abrasives;<br />a reduction in the cycles and intensity of cleaning implies a longer duration of the treatments.</p> <p>Our strengths: Speed, Reliability, Discretion, Accuracy, Experience, Versatility.</p>
114756 <p>PER-CHI has developed an absolutely effective and safe disinfestation and disinfection process that can sanitize objects, furniture, water, water pipes, etc.<br /></p> <p>In the case of the disinfection of environments, furniture and objects, this can be done by injecting a highly disinfecting ozone gas into the rooms for a preset time. The procedure must be carried out when there are no people present in the rooms and it can be carried out in closed and confined environments (classrooms, buses, toilets, etc.) where people are normally stationed and which can therefore be configured as places where a live broadcast.</p> <p>Active oxygen or ozone (O3 is the symbol because its molecules are made up of three oxygen atoms) is a gas with an unmistakable smell (it gives an impression of freshness) that stands out for its disinfecting properties of the air, environments and surfaces.</p> <p>Thanks to its oxidizing power it is effective against insects, bacteria, viruses, molds and eliminates odors. Our company is equipped with portable machinery capable of generating ozone from the oxygen present in the air and using it to disinfect air, environments, surfaces, ducts and ventilation systems, means of transport, etc. and to sanitize water and water pipes.</p> <p>Benefits and advantages<br />Being a gas, ozone disinfects both the air and surfaces and objects that are not disinfected with traditional methods (eg because they are not reached by operators or by the disinfectant).</p> <p>Pest control and disinfection are carried out automatically by the machinery (which produce ozone from the oxygen in the air) and therefore can be carried out in numerous environments simultaneously and without the presence of operators who have to carry out the processes (with considerable savings in times and costs).</p> <p>When it has finished its action, the ozone becomes oxygen again and leaves no residues of any kind and therefore does not require rinsing. It does not require raw materials or chemicals (with consequent cost savings) to be produced, but is produced from the oxygen in the air (oxygen which is returned at the end of the process).</p> <p>The machines are equipped with safety systems, remote management, concentration sensors and everything necessary to operate in safety both towards people and the materials present in the environments.</p> <p>Features<br />It leaves no residue;<br />reduces the purchase costs of chemical sanitizing products;<br />guarantees total sanitation of the environment;<br />reduces the risks to people's health;<br />reduces the costs of electricity consumption;<br />reduces consumption and costs related to the use of water;<br />does not damage the materials.</p> <p>Our strengths: Speed, Reliability, Discretion, Accuracy, Experience, Versatility.<br /></p>
114761 <p>PER-CHI with a view to innovation and cleaning in an ecological sense proposes itself to potential customers with a highly professional cleaning system aimed at numerous sectors.</p> <p>The equipment available is a highly advanced sandblasting and microaeroabrasion system in eco-sustainable cleaning methods, also recognized in the Fine Arts sector. This system reduces processing times, residues to be disposed of, lower intervention costs compared to techniques. of traditional cleaning. Ecological and safe, these systems use only non-toxic and non-polluting materials that guarantee maximum respect for the environment and for operators.</p> <p>Our strengths: Speed, Reliability, Discretion, Accuracy, Experience, Versatility.<br /></p>
114763 <p></p> <p>By cleaning surfaces or objects we mean the mechanical or manual removal of dirt from them. For cleaning, water and detergents diluted in the right quantity are used according to the instructions given by the detergent manufacturer.</p> <p>By sanitation we mean the method by which, through the use of detergents, the number of bacteria present on objects and surfaces is reduced, thus maintaining hygienic levels of safety on objects and surfaces.</p> <p>Cleaning operations include:<br />dirt removal<br />washing with water and detergent<br />abundant rinse<br />The rinsing process is fundamental: in fact, water and soap are not sufficient for the removal of bacteria, but must always be combined with an abundant rinsing action.</p> <p>Cleaning products<br />The products needed for cleaning are surface and floor detergents, abrasive creams for sanitary ware and descalers. Bleach can also be used for the eventual disinfection of particular points such as toilets.</p> <p>Our company avails itself of the collaboration of one of the leading companies at European level in the production of chemical products also with the Ecolabel brand, AR-CO CHIMICA.</p> <p>Our strengths: Speed, Reliability, Discretion, Accuracy, Experience, Versatility.</p>
286548 <p style="color:#000000;font-size:18px;">The septic tank is a well that serves for the collection of sewage (deposit), mainly the septic tanks do not have sewerage for the discharge of waste (faecal), they are hermetic and are cleaned periodically with appropriate and contemporary means. The cleaning of septic tanks is done through machines with a suction process and it is processed from above the pits, it is also the most hygienic method for your environments, whether they are hotels, houses or companies that do not have sewerage systems.</p>
286549 <p style="color:#000000;font-size:18px;">Liquid materials include grease sludge and sewage sludge, which are formed from clean water, and are also found in water wells. Grease pits are tanks or tanks made of plastic or iron material which are placed in various premises such as supermarkets, hotels, etc. They are placed underground or on the surface depending on the adaptation of the environment. The cleaning of the grease pit is done through vacuum suction machines, which is processed in the same way as a septic tank.</p>
286550 <p style="color:#000000;font-size:18px;">Cleaning and unblocking of channels or collectors is done through machines with a high pressure process of water coming out of the machine's pumps, otherwise called unblocking probes. These tools manage to unblock different dimensions of pipes with a width of 100 200_ 250 _400 and up to 1000 and they go up to 200 m in length. </p>
286551 <p style="color:#000000;font-size:18px;">Cleaning and unblocking of channels or collectors is done through machines with a high pressure process of water coming out of the machine's pumps, otherwise called unblocking probes. These tools manage to unblock different dimensions of pipes with a width of 100 200_ 250 _400 and up to 1000 and they go up to 200 m in length.</p>
286579 <p style="color:#000000;font-size:18px;">Liquid materials include grease sludge and sewage sludge, which are formed from clean water, and are also found in water wells. Grease pits are tanks or tanks made of plastic or iron material which are placed in various premises such as supermarkets, hotels, etc. They are placed underground or on the surface depending on the adaptation of the environment. The cleaning of the grease pit is done through vacuum suction machines, which is processed in the same way as a septic tank.</p>
286580
286581