SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  AND cscart_page_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
WHERE 
  1 
  AND cscart_pages.parent_id IN (27) 
  AND cscart_pages.status IN ('A') 
  AND cscart_pages.company_id IN (0, 2, 8, 9, 10) 
  AND cscart_pages.page_type IN ('B') 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND (
    cscart_pages.use_avail_period = 'N' 
    OR (
      cscart_pages.use_avail_period = 'Y' 
      AND cscart_pages.avail_from_timestamp <= 1771812912 
      AND (
        cscart_pages.avail_till_timestamp >= 1771812912 
        OR cscart_pages.avail_till_timestamp = 0
      )
    )
  ) 
ORDER BY 
  cscart_pages.timestamp desc 
LIMIT 
  0, 10

Query time 0.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.78"
    },
    "ordering_operation": {
      "using_filesort": true,
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_pages",
            "access_type": "ref",
            "possible_keys": [
              "parent_id"
            ],
            "key": "parent_id",
            "used_key_parts": [
              "parent_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 2,
            "rows_produced_per_join": 0,
            "filtered": "5.56",
            "cost_info": {
              "read_cost": "0.50",
              "eval_cost": "0.01",
              "prefix_cost": "0.70",
              "data_read_per_join": "281"
            },
            "used_columns": [
              "page_id",
              "company_id",
              "parent_id",
              "id_path",
              "status",
              "page_type",
              "position",
              "timestamp",
              "usergroup_ids",
              "localization",
              "new_window",
              "use_avail_period",
              "avail_from_timestamp",
              "avail_till_timestamp",
              "facebook_obj_type"
            ],
            "attached_condition": "((`nuie_scalesta_net`.`cscart_pages`.`status` = 'A') and (`nuie_scalesta_net`.`cscart_pages`.`company_id` in (0,2,8,9,10)) and (`nuie_scalesta_net`.`cscart_pages`.`page_type` = 'B') and ((`nuie_scalesta_net`.`cscart_pages`.`usergroup_ids` = '') or (0 <> find_in_set(0,`nuie_scalesta_net`.`cscart_pages`.`usergroup_ids`)) or (0 <> find_in_set(1,`nuie_scalesta_net`.`cscart_pages`.`usergroup_ids`))) and ((`nuie_scalesta_net`.`cscart_pages`.`use_avail_period` = 'N') or ((`nuie_scalesta_net`.`cscart_pages`.`use_avail_period` = 'Y') and (`nuie_scalesta_net`.`cscart_pages`.`avail_from_timestamp` <= 1771812912) and ((`nuie_scalesta_net`.`cscart_pages`.`avail_till_timestamp` >= 1771812912) or (`nuie_scalesta_net`.`cscart_pages`.`avail_till_timestamp` = 0)))))"
          }
        },
        {
          "table": {
            "table_name": "cscart_page_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "page_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "nuie_scalesta_net.cscart_pages.page_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.03",
              "eval_cost": "0.01",
              "prefix_cost": "0.74",
              "data_read_per_join": "429"
            },
            "used_columns": [
              "page_id",
              "lang_code",
              "page",
              "description",
              "meta_keywords",
              "meta_description",
              "page_title",
              "link"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_seo_names",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "dispatch"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "type",
              "dispatch",
              "lang_code"
            ],
            "key_length": "206",
            "ref": [
              "nuie_scalesta_net.cscart_pages.page_id",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.03",
              "eval_cost": "0.01",
              "prefix_cost": "0.78",
              "data_read_per_join": "192"
            },
            "used_columns": [
              "name",
              "object_id",
              "company_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        }
      ]
    }
  }
}

Result

page_id company_id parent_id id_path status page_type position timestamp usergroup_ids localization new_window use_avail_period avail_from_timestamp avail_till_timestamp facebook_obj_type lang_code page description meta_keywords meta_description page_title link seo_name seo_path
30 2 27 27/30 A B 0 1659654000 0 0 N 0 0 activity en The Right Tap For You <p><img src="https://nuie.co.uk/images/blog/arv405-arvan-black-mono-tap.jpeg?1659707283392" alt="arv405-arvan-black-mono-tap.jpeg?1659707283392" /></p> <h3>Basin taps come in a range of different styles and functions, from mono mixers to wall mounted and chrome taps to brushed brass taps. Choosing the right tap for your bathroom can therefore be a bit tricky, but don’t worry once you’ve got the basics nailed the choice becomes much clearer. </h3> <h3>First Things First</h3> <p>Like most things, you need to do the groundwork first to make sure the fun steps go smoothly, and you don’t end up with an expensive mistake on your hands. Before choosing your tap, you need to first check what your water pressure is and what central heating system you have as this will impact your choice. Taps come with different operating pressures so fitting the wrong one could result in a tap that only trickles. If you’re unsure about your water pressure or central heating setup, speak to a plumber.</p> <p><!--CUT--></p> <p>You also need to check how many holes your basin has, if there’s only one you’ll need a mono mixer, if there’s two you’ll need a pair of pillar taps etc. Of course, if you’re a fan of the ultra-modern and want something that stands out, a wall mounted tap is perfect for creating this look, just remember you’ll need a basin with no pre-drilled holes. If you were planning on replacing your basin you should keep in mind what kind of tap you want so you can choose the correct basin for that tap.</p> <h3>Types of Taps</h3> <p>There is a wide range of tap types to choose from in a variety of different styles, so depending on the above you can still be sure to find the right one for your set up.</p> <p>Mono taps are a very popular option for modern bathrooms, they come in many minimalist styles and they look superb in any bathroom. Mono mixers are also available in a traditional style if that’s more up your street. Whichever style you choose mono mixers are practical, stylish and they’re an easy-to-use tap option.</p> <p>Double pillar basin taps are your classic faucet setup. Two taps, usually one for hot water the other for cold and mounted on a two hole basin, they create a classic look that is great for filling up your sink at just the right temperature.</p> <p>Tall mono mixers are ideal for bathrooms equipped with a vessel instead of your standard basin. This tap style is tall enough to easily tower over the vessel and its mixer function means it’s practical whilst also creating a statement.</p> <p>Wall mounted taps are perfect for basins without any pre-drilled tap holes or for vessels. This setup also looks fantastic and definitely adds flair to your bathroom. It’s also really easy to clean both your basin and the tap as nothing gets in the way. This option is currently the peak of modern bathroom design.</p> <h3>Tap Finishes</h3> <p>All of our taps are available in a sleek chrome finish, a versatile and timeless colour option. We also offer a beautiful matt black and a crisp brushed brass finish on some of our brassware collections.</p> <p>Our matt black finish, which looks SO GOOD by the way, is a contemporary design option that is making waves in the world of bathroom styling. Include a tap in this colour when creating a monochrome bathroom to tie the room together and finish this elegant design. It’s also a versatile option and works just as well in a modern bathroom with pops of colour so don’t pass up this tap if you’re working with a wider colour spectrum.</p> <p>Brushed brass taps are becoming more and more popular and it isn’t hard to see why. This finish is bold, it makes a statement and it adds luxury to any bathroom. All of our brushed brass taps are manufactured using a PVD coating to ensure a high resistance to wear and tear, preventing the finish from deteriorating.</p> <p>We offer a huge range of unique taps in all shapes, styles and sizes. If you want to find the perfect tap for you click here, we’re sure you’ll find what you’re looking for.</p> The Right Tap For You the-right-tap-for-you 27
29 2 27 27/29 A B 0 1657148400 0 0 N 0 0 activity en Squeeze More Storage out of Your Bathroom <p><img src="https://nuie.co.uk/images/blog/min003-vault-grey-avola-downsized.jpeg?1659704511398" alt="min003-vault-grey-avola-downsized.jpeg?1659704511398" /></p> <h3>Have you ever thought ‘my bathroom is just too small’? Does the stress of finding enough space for all your bathroom needs keep you up at night? Does your bathroom just feel too cramped, like you have to squeeze everything in with no room to swing the smallest cat?</h3> <p>Well, we have the blog for you! Find out how to maximise the storage space for the smallest bathroom with our range of compact furniture.</p> <p><!--CUT--></p> <h3>Too Narrow</h3> <p>Small bathrooms come in many shapes and sizes, with the space available being different for everyone. A common challenge when trying to furnish a small bathroom is that the room is just too narrow for standard furniture. The units can be too deep to comfortably open the doors and the sink feels like it’s pressed against you. Of course, the need for storage remains even with limited space, so finding solutions can be tricky.</p> <p>One of the best ways to solve your space and storage problems is to fit slimline vanity units. These options give you the most storage for the space available and even with a slimline basin there is enough bowl space to wash your hands and brush your teeth comfortably. Don’t compromise style for practicality, our Vault range of compact furniture is available in a variety of different styles and colourways, we also have a range of mini basin taps so they don’t look overkill on small units, check out our Sanford Mini Basin Mixer for a tap with a sleek contemporary design in a small package.</p> <h3>Just Not Big Enough</h3> <p>Some bathrooms just feel too small in general, there’s no specific width or length issue, it’s just too small for comfort. Slimline furniture can help you out here as well, but if you can afford to use a little extra space for storage why not go for a regular vanity with a smaller width? This option gives you the same depth as other vanities, but it’s narrower which is really helpful for a small bathroom, obviously.</p> <p>If you check out our Cloakroom packs you’ll find a ton of options for different options to fit your space. Our Cloakroom packs are available in a variety of different basin and tap options as well, so you can be sure to find the right pack for you.</p> <p><img src="https://nuie.co.uk/images/blog/mer022-merit-aurora-teal.jpeg?1659704708495" alt="mer022-merit-aurora-teal.jpeg?1659704708495" /></p> <h3>Limited Floor Space</h3> <p>Limited floor space comes with a lot of different headaches. The room might feel too cluttered, bringing the room’s vibe down. It might make the room feel claustrophobic, meaning you’re unable to destress when taking some well-deserved ‘me time’. Thankfully there are a few solutions, the most effective of which is to use compact wall hung furniture. This design lets you reclaim some floor space, allowing light to reach underneath the vanity and give the illusion of a bigger room, magnify this this effect with an LED mirror for even more light. Plus, wall hung vanities look like they’re floating which, let’s be honest, looks unreal.</p> <h3>Other Storage Solutions and Tips</h3> <p>If fitting new furniture isn’t your vibe there are other routes you can take to squeeze more storage space out of your bathroom.</p> <p>The cheapest and quickest way to gain some space is to throw away all of your unused toiletries! Come on, you know you have some, we all do. That bottle of Baylis and Harding hand cream you used once, get it gone. Your old toothbrush with bristle so bent you might as well use your finger, chuck it in the bin. That Lynx Africa set your Nan got you 3 Christmases ago, if you haven’t used it yet you never will. Alternatively, if you feel this is too wasteful you could always regift or donate! This is a good step towards only purchasing, and ultimately storing, things you actually want and need. </p> <p>Our personal favourite storage solution is to use a towel radiator. This toasty solution provides you with all the benefits of a normal radiator whilst saving space where your towels would otherwise be stored AND it means stepping out of the shower on a cold morning isn’t as daunting knowing you have a cozy warm towel waiting for you. Or if you want a quicker and less expensive ways to save space with your towels, fit one of our towel hooks so it’s always in reach and out of the way.</p> Squeeze More Storage Out of Your Bathroom squeeze-more-storage-out-of-your-bathroom 27