Нужна помощь в оптимизации запроса mysql

Hello! Our website hcdut.ks.ua (running on Joomla) has been hacked — the attackers defaced the main page. Our hosting is UAhosting. Unfortunately, our developer is no longer handling this and forwarded us the following (we apologize for the Russian): During a scheduled security check, we discovered that there is a Joomla site on your hosting account using the SP Page component. In recent days, we have been recording mass attacks on Joomla sites using SP Page Builder. In some cases, the result of the attack was the placement of malicious PHP files or the addition of external JavaScript code to the Joomla database, which could cause a deface "Hacked by...". What needs to be done now, while the site is still functioning correctly: 1. Make a complete backup of the site and database. 2. Update Joomla to the latest supported version. 3. Update SP Page Builder to the latest version or reinstall it from a clean official distribution. 4. Update the template, template framework, and all installed components/modules/plugins. 5. Remove unused, old, or unknown extensions. 6. Check the users in the Joomla admin area and remove unnecessary or unknown accounts. 7. Change passwords in cPanel, FTP, database, and Joomla admin area. 8. Check for public files in the root of the site like info.php, phpinfo.php, adminer.php, administrator.zip, or other archives/service files. 9. After updating, clear the Joomla cache and optimizer caches. 10. Hand over the site to a developer for a complete check of the CMS, template, and extensions. Important: if the site is not updated, the risk of repeated attacks remains high. The hosting may block individual malicious requests or clean detected files, but complete elimination of vulnerabilities must be done at the CMS and its extensions level. Please let us know if you can take this on soon and what the estimated cost would be?

A website needs to be created for a dental clinic. There is an approved design that needs to be coded. 4 pages: home, services, doctor, contacts, without online booking, a simple contact form. The design will be sent in a private message. Please provide your prices for the work.

Main tasks: Conduct an audit of the current version of the site, template, modules, components, and plugins. Check the compatibility of the current functionality with the new version of Joomla. Prepare a backup of the site and database before starting work. Perform the migration of the site to the new version of Joomla. Update or replace incompatible extensions. Check the correctness of the template, pages, menus, forms, modules, and administrative panel. Fix any errors that arise after the update. Conduct final testing of the site after migration. Readiness criteria: The site operates on the current version of Joomla. The main functionality of the site is preserved. Pages, menus, forms, and modules work correctly. The admin panel is accessible and operates without critical errors. Site data is not lost during migration.

A website needs to be coded according to the design. The layout is a bit crooked, so pixel perfect is not required. Coding, responsive for mobile devices, opening pages via links, and the site in three languages. All texts in blocks in other languages will be sent later. Additionally: optimization for Google PageSpeed 100 / 100 for mobile and desktop. Or at least 98 out of 100, no less!!! Propose timelines and costs. Layout: https://www.figma.com/design/AkM2GAvaLAPw7IAOtkGPIy/DSL-2010--%D0%9F%D1%80%D0%B0%D0%B2%D0%BA%D0%B8-1-?node-id=6177-908&t=u7qPBPqxIifkwaug-0

Good day. We are looking for a specialist who understands e-commerce websites for selling products abroad. We need not just a website developer who will "make a beautiful page," but a person who understands: — how websites for custom-sized products should work; — how to properly implement a size chart / price calculator / product parameter selection; — how to design a product card so that the client understands how to order; — how to make the website convenient for advertising, SEO, and further promotion; — how to launch such websites in foreign markets. We have made-to-order products where the client must choose parameters: size, color, type of fabric, installation option, etc. Therefore, it is important that the specialist has practical experience with similar projects. These do not necessarily have to be curtains. Experience with any custom-made products will be suitable, for example: — custom-sized furniture; — blinds / shades / pleated shades; — windows / doors; — clothing with a size chart; — mattresses; — products with a price calculator; — any product where the price depends on the client's parameters. At the first stage, we need to get a consultation / audit and understand: What type of website is best to create for our product. Which platform is better to launch on: Shopify, WordPress/WooCommerce, PrestaShop, OpenCart, or others. How to properly implement the selection of size and product parameters. How the product card should look so that the client does not get confused. How to best create a price calculator or order form. What must be on the website to build client trust. How to prepare the website for Google / Meta advertising. How to prepare the website for the foreign market. What mistakes should not be made at the start. What is the minimum version of the website that can be created for demand testing. It is important for us not just to "make a website," but to understand the correct launch strategy: structure, logic, functionality, technical base, promotion, and further scaling. We expect from the specialist: — practical cases of similar websites; — understanding of e-commerce abroad; — experience with custom-made products or products with a size chart; — the ability to explain in simple terms what is best to do at the start; — preferably experience with websites that were launched for advertising or SEO. At the first stage, we want to conduct a consultation of 60–90 minutes or receive a brief audit/launch plan. In your response, please write: Do you have experience with websites for custom-sized products? What specific projects can you show? What platforms have you worked on? What would you recommend for the start: a full-fledged website or a test version? What is the cost of the consultation or initial audit? When can you have a short call?