Ускорить SQL запрос

Main functionality Laravel 11/12 PHP 8.3+ MySQL Responsive design High performance SEO-friendly Admin panelCatalog categories brands products search filters sorting product pagesTecDoc Integration with the TecDoc module is required: VIN search car search TecDoc catalog analog selection specifications photos cross-references (Experience with TecDoc integration will be a significant advantage.)Personal account registration authorization order history wishlistCart order placement Nova Poshta delivery online payment promo codesSEO SEO-friendly URLs Meta Title Meta Description Schema.org XML Sitemap robots.txt Open GraphAdmin panel product management category management brand management order management user management SEO bannersIntegrations Telegram notifications Nova Poshta API payment system (LiqPay or WayForPay)Requirements clean code Git documented codeFrom the contractor, we need examples of websites on Laravel experience with TecDoc approximate timelines cost technology stack

It is necessary to create a complete English-language copy of the existing online store on 1C-Bitrix. Tasks: copy the structure, design, and functionality of the site; translate all content and interface into English; transfer the catalog, categories, products, images, and specifications; translate the menu, forms, buttons, system messages, and personal account; maintain the functionality of the cart, search, filters, comparison, and favorites; set up English URLs, Title, Description, and other SEO elements; check the correct operation of the site on computers and mobile devices. A developer with experience in 1C-Bitrix, PHP, and multilingual online stores is required. In your response, please indicate the cost, deadlines, and examples of similar projects.

1) Change the label for the amount for free shipping - from 2000 UAH 2) Increase the website speed (not inflated metrics) 3) Remove duplicates (when searching for a product, all variations and products that should not be displayed are shown) 4) Fix the filters (I will send screenshots) remove the bra size filter where it is not needed. Where it is needed, the sizes are incorrect 5) Create a full integration of WP with SalesDrive (currently only orders are coming, but products are without photos, sizes, and colors) 6) Create an xlsx file export with products from WP for the accounting program

Project Description We are looking for an experienced developer or a small team to create a modern online store for an optical salon. The goal is not just to update the design, but to create an effective online sales tool that will become the main sales channel for the company in the future. The current website is already operational and has an SEO history, so it is important to maintain Google rankings as much as possible during the transition to the new site. We will base the UX and functionality on modern global optical online stores (for example, Warby Parker), but the solutions must be adapted to the Ukrainian market.Required Functionality WordPress + WooCommerce modern responsive design product catalog with filters Mega Menu selection of frames and lenses glasses order builder ability to upload a prescription online appointment for vision check online payment integration with Nova Poshta simple administrative panel product import SEO-friendly structure possibility of further integration of an AI consultantImportant A specialist is needed who has experience in creating online stores, understands UX, SEO, conversion, and can offer their own solutions for improving the project. A detailed technical task will be provided after the preliminary selection of candidates.Please include in your response Links to 3–5 similar implemented online stores. Your experience with WooCommerce. How you plan to maintain SEO during the site transfer. What improvements you recommend to increase conversion. Estimated cost of the project. Estimated completion time.Specialization ✅ Website creation ✅ Online stores and e-commerce ✅ WordPress ✅ WooCommerce ✅ PHP

It is necessary to migrate a custom project from CodeIgniter 2 to Laravel 12. I will provide details in private messages.