Sandbox

SELECT 
  vi_pages.*, 
  vi_page_descriptions.*, 
  vi_seo_names.name as seo_name, 
  vi_seo_names.path as seo_path 
FROM 
  vi_pages 
  LEFT JOIN vi_page_descriptions ON vi_pages.page_id = vi_page_descriptions.page_id 
  AND vi_page_descriptions.lang_code = 'en' 
  LEFT JOIN vi_seo_names ON vi_seo_names.object_id = vi_pages.page_id 
  AND vi_seo_names.type = 'a' 
  AND vi_seo_names.dispatch = '' 
  AND vi_seo_names.lang_code = 'en' 
  INNER JOIN vi_ult_objects_sharing ON (
    vi_ult_objects_sharing.share_object_id = vi_pages.page_id 
    AND vi_ult_objects_sharing.share_company_id = 1 
    AND vi_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  1 
  AND vi_pages.parent_id IN (7) 
  AND vi_pages.status IN ('A') 
  AND vi_pages.page_type IN ('B') 
  AND (
    vi_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, vi_pages.usergroup_ids) 
    OR FIND_IN_SET(1, vi_pages.usergroup_ids)
  ) 
  AND (
    vi_pages.use_avail_period = 'N' 
    OR (
      vi_pages.use_avail_period = 'Y' 
      AND vi_pages.avail_from_timestamp <= 1776414423 
      AND (
        vi_pages.avail_till_timestamp >= 1776414423 
        OR vi_pages.avail_till_timestamp = 0
      )
    )
  ) 
ORDER BY 
  vi_pages.timestamp desc 
LIMIT 
  0, 20

Query time 0.00128

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "vi_pages.`timestamp` desc",
            "table": {
              "table_name": "vi_pages",
              "access_type": "ref",
              "possible_keys": ["PRIMARY", "parent_id"],
              "key": "parent_id",
              "key_length": "3",
              "used_key_parts": ["parent_id"],
              "ref": ["const"],
              "rows": 8,
              "filtered": 100,
              "attached_condition": "vi_pages.parent_id <=> 7 and vi_pages.`status` = 'A' and vi_pages.page_type = 'B' and (vi_pages.usergroup_ids = '' or find_in_set(0,vi_pages.usergroup_ids) or find_in_set(1,vi_pages.usergroup_ids)) and (vi_pages.use_avail_period = 'N' or vi_pages.use_avail_period = 'Y' and vi_pages.avail_from_timestamp <= 1776414423 and (vi_pages.avail_till_timestamp >= 1776414423 or vi_pages.avail_till_timestamp = 0))"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "vi_page_descriptions",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["page_id", "lang_code"],
          "ref": ["devvipiriscom.vi_pages.page_id", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(vi_page_descriptions.lang_code = 'en')"
        }
      },
      {
        "table": {
          "table_name": "vi_ult_objects_sharing",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "159",
          "used_key_parts": [
            "share_object_id",
            "share_company_id",
            "share_object_type"
          ],
          "ref": ["devvipiriscom.vi_pages.page_id", "const", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "vi_ult_objects_sharing.share_object_id = vi_pages.page_id and vi_ult_objects_sharing.share_object_type = 'pages'",
          "using_index": true
        }
      },
      {
        "table": {
          "table_name": "vi_seo_names",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "dispatch"],
          "key": "PRIMARY",
          "key_length": "206",
          "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
          "ref": ["devvipiriscom.vi_pages.page_id", "const", "const", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(vi_seo_names.`type` = 'a' and vi_seo_names.dispatch = '' and vi_seo_names.lang_code = 'en')"
        }
      }
    ]
  }
}

Result

page_id	company_id	parent_id	id_path	status	page_type	position	timestamp	use_avail_period	facebook_obj_type	lang_code	page	description	seo_name	seo_path
41	1	7	7/41	A	B	100	1773421943	N	activity	en	For those who love sound quality we have awesome Pioneer speakers! (Демо)	<h2>Demo article title h2</h2><p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p><h3>Demo article title h3</h3><p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p><p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	for-those-who-love-sound-quality-we-have-awesome-pioneer-speakers-demo	7
42	1	7	7/42	A	B	200	1773421943	N	activity	en	New arrivals of Nintendo Wii games! (Демо)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	new-arrivals-of-nintendo-wii-games-demo	7
43	1	7	7/43	A	B	300	1773421943	N	activity	en	Only in our store! Famous American WeatherMaster tents! (Демо)	<h2>Demo article title h2</h2><p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p><h3>Demo article title h3</h3><p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p><p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	only-in-our-store-famous-american-weathermaster-tents-demo	7
44	1	7	7/44	A	B	400	1773421943	N	activity	en	We got the best tracks of legendary B.B.King (Демо)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	we-got-the-best-tracks-of-legendary-b-b-king-demo	7
45	1	7	7/45	A	B	500	1773421943	N	activity	en	Looking for a keypad Nokia phone and can't find one? We still have them! (Демо)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	looking-for-a-keypad-nokia-phone-and-cant-find-one-we-still-have-them-demo	7
46	1	7	7/46	A	B	600	1773421943	N	activity	en	Afraid of zombies? Preparing for apocalypse? (Демо)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	afraid-of-zombies-preparing-for-apocalypse-demo	7
47	1	7	7/47	A	B	700	1773421943	N	activity	en	True American classic! Drifter cruisers (Демо)	<h2>Demo article title h2</h2> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue <strong>pleasure rationally encounter</strong> consequences that are extremely painful. </p> <h3>Demo article title h3</h3> <p>Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever <a href="/">undertakes laborious</a> physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure? </p> <p>"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?" </p>	true-american-classic-drifter-cruisers-demo	7
8	1	7	7/8	A	B	0	1415316000	N		en	Check out CS-Cart Marketplace	<p>CS-Cart is feature-packed out of the box. But if you’re looking for something more for your project, we have CS-Cart Marketplace — the official store with add-ons and themes for CS-Cart.</p><div style="text-align: center; margin: 15px auto;"><a class="button ty-btn ty-btn__primary" href="https://marketplace.cs-cart.com/" title="GO TO MARKETPLACE" target="_blank">GO TO MARKETPLACE</a></div><p>Make your CS-Cart store more powerful, beautiful, functional, and user-friendly.</p><!--CUT--><p>CS-Cart Marketplace can help you:<ul><li>extend the functionality of your site;</li><li>create a unique look and feel for it;</li><li>get extra tools for promoting the site, and more;</li><li>save your time for what’s really important.</li></ul></p><p>Filter add-ons by their developer and field of use; choose them by rating, reviews, and compatibility with your CS-Cart version. If you have questions on some add-on or theme, contact its developer right from the product page.</p>	check-out-cs-cart-marketplace	7