1. 0.00858s - Function query: select * from oc_posts where idPost=28137 and isConfirmed=1 Limit 1
  2. 0.00911s - End function query
  3. 0.0135s - Function query: SELECT idLocation,name,(select name from oc_locations where idLocation=C.idLocationParent) FROM oc_locations C order by idLocation, idLocationParent
  4. 0.01459s - End function query
  5. 0.01549s - Function query: SELECT friendlyName,name,(select name from oc_categories where idCategory=C.idCategoryParent) FROM oc_categories C order by idCategoryParent
  6. 0.0164s - End function query
  7. 0.01804s - Function getRows assoc
  8. 0.01815s - Function getRows from cache query: select idLocation, name, friendlyName from oc_locations where idLocationParent=0 order by name
  9. 0.01824s - Function getRows assoc
  10. 0.01834s - Function getRows from cache query: select P.*,C.friendlyName,(select friendlyName from oc_categories where idCAtegory=C.idCategoryParent Limit 1) parent from oc_categories C inner join (SELECT count(P.idPost) cont,P.idPost,P.title,P.type,P.idCategory FROM oc_posts P inner join oc_postshits H on P.idPost=H.idPost where P.isConfirmed=1 and P.isAvailable=1 and TIMESTAMPDIFF(DAY,H.hitTime,now())<=4 group by P.idPost,P.title,P.idCategory,P.type) P on P.idCategory=C.idCategory order by 1 desc Limit 10
  11. 0.02158s - Function closeDB: 4 queries generated in 0.02157s and 2 queries cached