0.00374s - 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
0.00379s - Function getRows assoc
0.0436s - 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
0.05054s - Function getRows assoc
0.05067s - Function getRows from cache query:SELECT name,friendlyName from oc_categories where idCategoryParent=0 order by `order`
0.05076s - Function getRows assoc
0.05555s - 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
0.07849s - Function getRows value
0.07854s - Function getRows from cache query:SELECT count(idPost) from oc_posts P where P.isConfirmed=1
0.0786s - Function getRows value
0.07865s - Function getRows from cache query:SELECT count(P.idPost) FROM oc_posts P
inner join oc_postshits H
on P.idPost=H.idPost where P.isConfirmed=1
0.07874s - Function getRows assoc
0.07915s - 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())<=7
group by P.idPost,P.title,P.idCategory,P.type) P
on P.idCategory=C.idCategory
order by 1 desc Limit 5
0.08315s - Function closeDB: 1 queries generated in 0.08314s and 7 queries cached
