SELECT SQL_NO_CACHE DISTINCT jos_pets.* , jos_region.name, jos_breedimages.images FROM `jos_pets` LEFT JOIN jos_breedimages ON jos_breedimages.pet_id= jos_pets.id , `jos_region`,jos_plan,jos_users WHERE jos_users.plan_id =jos_plan.id AND jos_pets.sold_mark = '0' AND jos_pets.status!='adopt' AND jos_pets.region_id=jos_region.id AND (jos_pets.petcat_id=15 OR jos_pets.petcat_id=36) AND jos_pets.breed_id = 100 AND jos_pets.city = 'Bloemfontein' AND jos_pets.status!='adopt' AND jos_pets.published = 1 GROUP BY jos_pets.id ORDER BY jos_pets.created desc float(0.00097417831420898)



No match found...

Featured Articles
Dog Names - Dog Name Dire......

Are you looking to get an adorable puppy? Use our new Dog Names directory. We have launched a new Dog Name Section with ......

Profile Information

Application afterLoad: 0.000 seconds, 0.94 MB
Application afterInitialise: 0.043 seconds, 5.42 MB
Application afterRoute: 0.086 seconds, 11.30 MB
Application afterDispatch: 0.099 seconds, 12.05 MB
Application afterRender: 0.210 seconds, 14.70 MB

Memory Usage

15461576

26 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'mhnh61bulk2he108064j1j6vr1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1397718560' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'mhnh61bulk2he108064j1j6vr1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'mhnh61bulk2he108064j1j6vr1','1397720360','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'puppies-for-sale/whippet/Bloemfontein/15/'
      ORDER BY rank ASC
      LIMIT 1
  8. UPDATE jos_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = ''
      AND `oldurl` = 'puppies-for-sale/whippet/Bloemfontein/15/'
  9. SELECT oldurl, newurl
      FROM jos_redirection
      WHERE oldurl = 'puppies-for-sale/whippet/Bloemfontein/15'
      ORDER BY rank ASC
      LIMIT 1
  10. SELECT newurl
      FROM jos_sh404sef_aliases
      WHERE alias = 'puppies-for-sale/whippet/Bloemfontein/15/'
  11. SELECT newurl
      FROM jos_sh404sef_pageids
      WHERE pageid = 'puppies-for-sale/whippet/Bloemfontein/15/'
  12. SELECT *
      FROM jos_redirection
      WHERE oldurl = 'puppies-for-sale/whippet/Bloemfontein/15/'
  13. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  14. SELECT id  
      FROM jos_content
      WHERE `title`="__404__"
  15. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  17. SELECT id  
      FROM jos_breed
      WHERE name='whippet'
      AND cat_id=15
  18. SELECT name
      FROM jos_breed
      WHERE id=100
  19. SELECT SQL_NO_CACHE DISTINCT jos_pets.* , jos_region.name, jos_breedimages.images
      FROM `jos_pets`
      LEFT JOIN jos_breedimages
      ON jos_breedimages.pet_id= jos_pets.id , `jos_region`,jos_plan,jos_users
                     
      WHERE jos_users.plan_id =jos_plan.id
      AND jos_pets.sold_mark = '0'
      AND jos_pets.STATUS!='adopt'
      AND jos_pets.region_id=jos_region.id  
      AND (jos_pets.petcat_id=15 OR jos_pets.petcat_id=36)
      AND jos_pets.breed_id = 100
      AND jos_pets.city = 'Bloemfontein'
      AND jos_pets.STATUS!='adopt'
      AND jos_pets.published = 1
      GROUP BY jos_pets.id
      ORDER BY jos_pets.created DESC
  20. SELECT id AS VALUE , title AS text  
      FROM jos_categories
      WHERE parent_id='0'
      AND SECTION='petsection'
      ORDER BY id DESC
  21. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 21 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  22. SELECT *
      FROM jos_acymailing_config
  23. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'
      ORDER BY ordering ASC
  24. SELECT jb.name, jc.id, jc.`title`, jc.catid
      FROM jos_breed AS jb
      LEFT JOIN jos_content AS jc
      ON jb.name=jc.title
      AND (jc.catid=12 OR jc.catid = 27)
      AND (jc.sectionid=5 OR jc.sectionid = 1)
      WHERE jb.id IS NOT NULL
      ORDER BY jb.name
  25. SELECT jc.*
      FROM jos_content AS jc
      LEFT JOIN jos_categories js
      ON jc.catid = js.id  
      WHERE jc.publish_up > jc.publish_down
      AND js.alias ='featured-article'  
      LIMIT 1
  26. SELECT `value`
      FROM `jos_admintools_storage`
      WHERE `key` = 'cparams'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None