Sandbox

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 (36) 
  AND cscart_pages.status IN ('A') 
  AND cscart_pages.company_id IN (0, 2, 64, 92, 103, 104, 121, 127) 
  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 <= 1786413432 
      AND (
        cscart_pages.avail_till_timestamp >= 1786413432 
        OR cscart_pages.avail_till_timestamp = 0
      )
    )
  ) 
ORDER BY 
  cscart_pages.timestamp desc 
LIMIT 
  0, 10

Query time 0.01792

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "read_sorted_file": {
          "filesort": {
            "sort_key": "cscart_pages.`timestamp` desc",
            "table": {
              "table_name": "cscart_pages",
              "access_type": "range",
              "possible_keys": ["parent_id"],
              "key": "parent_id",
              "key_length": "3",
              "used_key_parts": ["parent_id"],
              "rows": 35,
              "filtered": 100,
              "index_condition": "cscart_pages.parent_id = 36",
              "attached_condition": "cscart_pages.`status` = 'A' and cscart_pages.company_id in (0,2,64,92,103,104,121,127) and cscart_pages.page_type = '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 <= 1786413432 and (cscart_pages.avail_till_timestamp >= 1786413432 or cscart_pages.avail_till_timestamp = 0))"
            }
          }
        }
      },
      {
        "table": {
          "table_name": "cscart_page_descriptions",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["page_id", "lang_code"],
          "ref": ["ebonza_cscart_test.cscart_pages.page_id", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_page_descriptions.lang_code = 'en')"
        }
      },
      {
        "table": {
          "table_name": "cscart_seo_names",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "dispatch"],
          "key": "PRIMARY",
          "key_length": "206",
          "used_key_parts": ["object_id", "type", "dispatch", "lang_code"],
          "ref": [
            "ebonza_cscart_test.cscart_pages.page_id",
            "const",
            "const",
            "const"
          ],
          "rows": 16,
          "filtered": 100,
          "attached_condition": "trigcond(cscart_seo_names.`type` = 'a' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
        }
      }
    ]
  }
}

Result

page_id	parent_id	id_path	status	page_type	position	timestamp	use_avail_period	facebook_obj_type	lang_code	page	description	meta_keywords	meta_description	page_title	seo_name	seo_path
71	36	36/71	A	B	100	1763564673	N	activity	en	For those who love sound quality we have awesome Pioneer speakers! (Demo)	<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>	eBonza s.r.o., For those who love sound quality we have awesome Pioneer speakers! (Demo)	eBonza s.r.o. For those who love sound quality we have awesome Pioneer speakers! (Demo)	For those who love sound quality we have awesome Pioneer speakers! (Demo)	for-those-who-love-sound-quality-we-have-awesome-pioneer-speakers-demo-en-5	36
72	36	36/72	A	B	200	1763564673	N	activity	en	New arrivals of Nintendo Wii games! (Demo)	<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>	eBonza s.r.o., New arrivals of Nintendo Wii games! (Demo)	eBonza s.r.o. New arrivals of Nintendo Wii games! (Demo)	New arrivals of Nintendo Wii games! (Demo)	new-arrivals-of-nintendo-wii-games-demo-en-5	36
73	36	36/73	A	B	300	1763564673	N	activity	en	Only in our store! Famous American WeatherMaster tents! (Demo)	<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>	eBonza s.r.o., Only in our store! Famous American WeatherMaster tents! (Demo)	eBonza s.r.o. Only in our store! Famous American WeatherMaster tents! (Demo)	Only in our store! Famous American WeatherMaster tents! (Demo)	only-in-our-store-famous-american-weathermaster-tents-demo-en-5	36
74	36	36/74	A	B	400	1763564673	N	activity	en	We got the best tracks of legendary B.B.King (Demo)	<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>	eBonza s.r.o., We got the best tracks of legendary B.B.King (Demo)	eBonza s.r.o. We got the best tracks of legendary B.B.King (Demo)	We got the best tracks of legendary B.B.King (Demo)	we-got-the-best-tracks-of-legendary-b-b-king-demo-en-5	36
75	36	36/75	A	B	500	1763564673	N	activity	en	Looking for a keypad Nokia phone and can't find one? We still have them! (Demo)	<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>	eBonza s.r.o., Looking for a keypad Nokia phone and can't find one? We still have them! (Demo)	eBonza s.r.o. Looking for a keypad Nokia phone and can't find one? We still have them! (Demo)	Looking for a keypad Nokia phone and can't find one? We still have them! (Demo)	looking-for-a-keypad-nokia-phone-and-cant-find-one-we-still-have-them-demo-en-5	36
76	36	36/76	A	B	600	1763564673	N	activity	en	Afraid of zombies? Preparing for apocalypse? (Demo)	<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>	eBonza s.r.o., Afraid of zombies? Preparing for apocalypse? (Demo)	eBonza s.r.o. Afraid of zombies? Preparing for apocalypse? (Demo)	Afraid of zombies? Preparing for apocalypse? (Demo)	afraid-of-zombies-preparing-for-apocalypse-demo-en-5	36
77	36	36/77	A	B	700	1763564673	N	activity	en	True American classic! Drifter cruisers (Demo)	<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>	eBonza s.r.o., True American classic! Drifter cruisers (Demo)	eBonza s.r.o. True American classic! Drifter cruisers (Demo)	True American classic! Drifter cruisers (Demo)	true-american-classic-drifter-cruisers-demo-en-5	36
64	36	36/64	A	B	100	1763564239	N	activity	en	For those who love sound quality we have awesome Pioneer speakers! (Demo)	<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>	eBonza s.r.o., For those who love sound quality we have awesome Pioneer speakers! (Demo)	eBonza s.r.o. For those who love sound quality we have awesome Pioneer speakers! (Demo)	For those who love sound quality we have awesome Pioneer speakers! (Demo)	for-those-who-love-sound-quality-we-have-awesome-pioneer-speakers-demo-en-4	36
65	36	36/65	A	B	200	1763564239	N	activity	en	New arrivals of Nintendo Wii games! (Demo)	<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>	eBonza s.r.o., New arrivals of Nintendo Wii games! (Demo)	eBonza s.r.o. New arrivals of Nintendo Wii games! (Demo)	New arrivals of Nintendo Wii games! (Demo)	new-arrivals-of-nintendo-wii-games-demo-en-4	36
66	36	36/66	A	B	300	1763564239	N	activity	en	Only in our store! Famous American WeatherMaster tents! (Demo)	<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>	eBonza s.r.o., Only in our store! Famous American WeatherMaster tents! (Demo)	eBonza s.r.o. Only in our store! Famous American WeatherMaster tents! (Demo)	Only in our store! Famous American WeatherMaster tents! (Demo)	only-in-our-store-famous-american-weathermaster-tents-demo-en-4	36