1. 0.00421s - Function getRows value
  2. 0.00427s - Function getRows from cache query:SELECT count(p.idPost) total FROM oc_posts p inner join oc_categories c on c.idCategory=p.idCategory where p.isAvailable=1 and p.isConfirmed=1
  3. 0.0043s - Function getRows assoc
  4. 0.00448s - Function getRows from cache query:SELECT p.idPost,p.title,p.description,p.insertDate, c.Name category,c.friendlyName fcategory,c.idCategoryParent,p.type,p.price,p.password,p.hasImages, (select friendlyName from oc_categories where idCategory=c.idCategoryParent limit 1) parent FROM oc_posts p inner join oc_categories c on c.idCategory=p.idCategory where p.isAvailable=1 and p.isConfirmed=1 order by p.insertDate Desc LIMIT 0, 10
  5. 0.0089s - Function getRows assoc
  6. 0.00899s - Function getRows from cache query:SELECT name,friendlyName,idCategory from oc_categories where idCategoryParent=0 order by `order`
  7. 0.00902s - Function getRows assoc
  8. 0.00908s - Function getRows from cache query:select c.idCategory,c.friendlyName,c.name,count(c.idCategory) cont , (select friendlyName from oc_categories where idCategory=c.idCategoryParent limit 1) parent from oc_categories c inner join oc_posts p on p.idCategory=c.idCategory group by c.idCategory,c.friendlyName,c.name order by cont desc,c.name Limit 7
  9. 0.0091s - Function getRows assoc
  10. 0.00923s - Function getRows from cache query:SELECT idCategory,name,friendlyName, (select name from oc_categories where idCategory=C.idCategoryParent limit 1) parent, idCategoryParent FROM oc_categories C where idCategoryParent!=0 order by idCategoryParent,`order`
  11. 0.01396s - Function getRows assoc
  12. 0.01405s - Function getRows from cache query:SELECT name,friendlyName,idCategory from oc_categories where idCategoryParent=0 order by `order`
  13. 0.01407s - Function getRows assoc
  14. 0.01414s - Function getRows from cache query:SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=1 order by idCategoryParent, `order`
  15. 0.01418s - Function getRows assoc
  16. 0.01424s - Function getRows from cache query:SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=2 order by idCategoryParent, `order`
  17. 0.01428s - Function getRows assoc
  18. 0.0143s - Function query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=3 order by idCategoryParent, `order`
  19. 0.01509s - End function query
  20. 0.01512s - Function getRows assoc
  21. 0.01514s - Function query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=48 order by idCategoryParent, `order`
  22. 0.01551s - End function query
  23. 0.01815s - Function closeDB: 3 queries generated in 0.01813s and 8 queries cached