1. 0.00555s - Function getRows value
  2. 0.0056s - Function getRows from APP 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.00563s - Function getRows assoc
  4. 0.00579s - 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.0102s - Function query: SELECT idLocation,name,(select name from oc_locations where idLocation=C.idLocationParent) FROM oc_locations C order by idLocation, idLocationParent
  6. 0.01158s - End function query
  7. 0.01248s - Function query: SELECT friendlyName,name,(select name from oc_categories where idCategory=C.idCategoryParent) FROM oc_categories C order by idCategoryParent
  8. 0.01336s - End function query
  9. 0.01649s - Function getRows assoc
  10. 0.01657s - Function getRows from cache query: SELECT name,friendlyName,idCategory from oc_categories where idCategoryParent=0 order by `order`
  11. 0.0166s - Function getRows value
  12. 0.01664s - Function getRows from cache query: select count(p.idcategory) from oc_posts p left join oc_categories c on p.idcategory=c.idcategory where c.idcategoryparent=51 and p.isAvailable=1 and p.isConfirmed=1
  13. 0.01665s - Function getRows assoc
  14. 0.01672s - Function getRows from cache query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=51 order by idCategoryParent, `order`
  15. 0.01673s - Function getRows value
  16. 0.01677s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=132 and isAvailable=1 and isConfirmed=1
  17. 0.01679s - Function getRows value
  18. 0.01683s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=75 and isAvailable=1 and isConfirmed=1
  19. 0.01684s - Function getRows value
  20. 0.01689s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=129 and isAvailable=1 and isConfirmed=1
  21. 0.0169s - Function getRows value
  22. 0.01694s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=130 and isAvailable=1 and isConfirmed=1
  23. 0.01695s - Function getRows value
  24. 0.01703s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=85 and isAvailable=1 and isConfirmed=1
  25. 0.01704s - Function getRows value
  26. 0.01708s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=76 and isAvailable=1 and isConfirmed=1
  27. 0.01709s - Function getRows value
  28. 0.01713s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=74 and isAvailable=1 and isConfirmed=1
  29. 0.01715s - Function getRows value
  30. 0.01719s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=117 and isAvailable=1 and isConfirmed=1
  31. 0.0172s - Function getRows value
  32. 0.01724s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=78 and isAvailable=1 and isConfirmed=1
  33. 0.01725s - Function getRows value
  34. 0.01731s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=56 and isAvailable=1 and isConfirmed=1
  35. 0.01732s - Function getRows value
  36. 0.01736s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=83 and isAvailable=1 and isConfirmed=1
  37. 0.01737s - Function getRows value
  38. 0.01741s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=59 and isAvailable=1 and isConfirmed=1
  39. 0.01742s - Function getRows value
  40. 0.01746s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=131 and isAvailable=1 and isConfirmed=1
  41. 0.01748s - Function getRows value
  42. 0.01751s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=79 and isAvailable=1 and isConfirmed=1
  43. 0.01753s - Function getRows value
  44. 0.01757s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=54 and isAvailable=1 and isConfirmed=1
  45. 0.01758s - Function getRows value
  46. 0.01762s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=77 and isAvailable=1 and isConfirmed=1
  47. 0.01764s - Function getRows value
  48. 0.01768s - Function getRows from cache query: select count(p.idcategory) from oc_posts p left join oc_categories c on p.idcategory=c.idcategory where c.idcategoryparent=39 and p.isAvailable=1 and p.isConfirmed=1
  49. 0.01769s - Function getRows assoc
  50. 0.01774s - Function getRows from cache query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=39 order by idCategoryParent, `order`
  51. 0.01775s - Function getRows value
  52. 0.01779s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=41 and isAvailable=1 and isConfirmed=1
  53. 0.01781s - Function getRows value
  54. 0.01785s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=96 and isAvailable=1 and isConfirmed=1
  55. 0.01787s - Function getRows value
  56. 0.0179s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=46 and isAvailable=1 and isConfirmed=1
  57. 0.01792s - Function getRows value
  58. 0.01796s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=126 and isAvailable=1 and isConfirmed=1
  59. 0.01797s - Function getRows value
  60. 0.01803s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=128 and isAvailable=1 and isConfirmed=1
  61. 0.01804s - Function getRows value
  62. 0.01808s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=86 and isAvailable=1 and isConfirmed=1
  63. 0.01809s - Function getRows value
  64. 0.01813s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=43 and isAvailable=1 and isConfirmed=1
  65. 0.01814s - Function getRows value
  66. 0.01819s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=87 and isAvailable=1 and isConfirmed=1
  67. 0.01821s - Function getRows value
  68. 0.01824s - Function getRows from cache query: select count(p.idcategory) from oc_posts p left join oc_categories c on p.idcategory=c.idcategory where c.idcategoryparent=10 and p.isAvailable=1 and p.isConfirmed=1
  69. 0.01828s - Function getRows assoc
  70. 0.01833s - Function getRows from cache query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=10 order by idCategoryParent, `order`
  71. 0.01835s - Function getRows value
  72. 0.01839s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=88 and isAvailable=1 and isConfirmed=1
  73. 0.0184s - Function getRows value
  74. 0.01844s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=90 and isAvailable=1 and isConfirmed=1
  75. 0.01845s - Function getRows value
  76. 0.01849s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=91 and isAvailable=1 and isConfirmed=1
  77. 0.01851s - Function getRows value
  78. 0.01854s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=92 and isAvailable=1 and isConfirmed=1
  79. 0.01856s - Function getRows value
  80. 0.01859s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=93 and isAvailable=1 and isConfirmed=1
  81. 0.01861s - Function getRows value
  82. 0.01865s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=94 and isAvailable=1 and isConfirmed=1
  83. 0.01866s - Function getRows value
  84. 0.0187s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=118 and isAvailable=1 and isConfirmed=1
  85. 0.01871s - Function getRows value
  86. 0.01875s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=97 and isAvailable=1 and isConfirmed=1
  87. 0.01876s - Function getRows value
  88. 0.0188s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=95 and isAvailable=1 and isConfirmed=1
  89. 0.01881s - Function getRows value
  90. 0.01885s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=11 and isAvailable=1 and isConfirmed=1
  91. 0.01886s - Function getRows value
  92. 0.0189s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=12 and isAvailable=1 and isConfirmed=1
  93. 0.01892s - Function getRows value
  94. 0.01895s - Function getRows from cache query: select count(p.idcategory) from oc_posts p left join oc_categories c on p.idcategory=c.idcategory where c.idcategoryparent=98 and p.isAvailable=1 and p.isConfirmed=1
  95. 0.01897s - Function getRows assoc
  96. 0.01904s - Function getRows from cache query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=98 order by idCategoryParent, `order`
  97. 0.01905s - Function getRows value
  98. 0.01909s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=106 and isAvailable=1 and isConfirmed=1
  99. 0.0191s - Function getRows value
  100. 0.01914s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=89 and isAvailable=1 and isConfirmed=1
  101. 0.01916s - Function getRows value
  102. 0.0192s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=100 and isAvailable=1 and isConfirmed=1
  103. 0.01921s - Function getRows value
  104. 0.01925s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=122 and isAvailable=1 and isConfirmed=1
  105. 0.01926s - Function getRows value
  106. 0.01932s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=102 and isAvailable=1 and isConfirmed=1
  107. 0.01933s - Function getRows value
  108. 0.01937s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=99 and isAvailable=1 and isConfirmed=1
  109. 0.01938s - Function getRows value
  110. 0.01942s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=107 and isAvailable=1 and isConfirmed=1
  111. 0.01943s - Function getRows value
  112. 0.01947s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=103 and isAvailable=1 and isConfirmed=1
  113. 0.01948s - Function getRows value
  114. 0.01952s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=104 and isAvailable=1 and isConfirmed=1
  115. 0.01954s - Function getRows value
  116. 0.01958s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=105 and isAvailable=1 and isConfirmed=1
  117. 0.01959s - Function getRows value
  118. 0.01963s - Function getRows from cache query: select count(p.idcategory) from oc_posts p left join oc_categories c on p.idcategory=c.idcategory where c.idcategoryparent=108 and p.isAvailable=1 and p.isConfirmed=1
  119. 0.01964s - Function getRows assoc
  120. 0.0197s - Function getRows from cache query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=108 order by idCategoryParent, `order`
  121. 0.01971s - Function getRows value
  122. 0.01975s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=121 and isAvailable=1 and isConfirmed=1
  123. 0.01976s - Function getRows value
  124. 0.0198s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=109 and isAvailable=1 and isConfirmed=1
  125. 0.01981s - Function getRows value
  126. 0.01985s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=125 and isAvailable=1 and isConfirmed=1
  127. 0.01986s - Function getRows value
  128. 0.0199s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=110 and isAvailable=1 and isConfirmed=1
  129. 0.01991s - Function getRows value
  130. 0.01995s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=112 and isAvailable=1 and isConfirmed=1
  131. 0.01997s - Function getRows value
  132. 0.02003s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=111 and isAvailable=1 and isConfirmed=1
  133. 0.02004s - Function getRows value
  134. 0.02008s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=113 and isAvailable=1 and isConfirmed=1
  135. 0.02009s - Function getRows value
  136. 0.02013s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=123 and isAvailable=1 and isConfirmed=1
  137. 0.02014s - Function getRows value
  138. 0.02018s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=124 and isAvailable=1 and isConfirmed=1
  139. 0.0202s - Function getRows value
  140. 0.02024s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=114 and isAvailable=1 and isConfirmed=1
  141. 0.02025s - Function getRows value
  142. 0.0203s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=115 and isAvailable=1 and isConfirmed=1
  143. 0.02032s - Function getRows value
  144. 0.02038s - Function getRows from cache query: select count(p.idcategory) from oc_posts p left join oc_categories c on p.idcategory=c.idcategory where c.idcategoryparent=36 and p.isAvailable=1 and p.isConfirmed=1
  145. 0.02039s - Function getRows assoc
  146. 0.02044s - Function getRows from cache query: SELECT idCategory,name,friendlyName FROM oc_categories C where idCategoryParent!=0 and idCategoryParent=36 order by idCategoryParent, `order`
  147. 0.02045s - Function getRows value
  148. 0.02049s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=120 and isAvailable=1 and isConfirmed=1
  149. 0.0205s - Function getRows value
  150. 0.02054s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=49 and isAvailable=1 and isConfirmed=1
  151. 0.02055s - Function getRows value
  152. 0.02059s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=70 and isAvailable=1 and isConfirmed=1
  153. 0.0206s - Function getRows value
  154. 0.02064s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=127 and isAvailable=1 and isConfirmed=1
  155. 0.02065s - Function getRows value
  156. 0.02069s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=116 and isAvailable=1 and isConfirmed=1
  157. 0.0207s - Function getRows value
  158. 0.02074s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=119 and isAvailable=1 and isConfirmed=1
  159. 0.02075s - Function getRows value
  160. 0.02079s - Function getRows from cache query: SELECT count(*) FROM oc_posts where idCategory=82 and isAvailable=1 and isConfirmed=1
  161. 0.02116s - Function getRows assoc
  162. 0.02122s - Function getRows from cache query: select idLocation, name, friendlyName from oc_locations where idLocationParent=0 order by name
  163. 0.02131s - Function getRows assoc
  164. 0.02138s - 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
  165. 0.02438s - Function closeDB: 3 queries generated in 0.02437s and 80 queries cached