Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on May 21st, 2013  |  syntax: None  |  size: 110.71 KB  |  views: 28  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. ok 1 - Original query executed without error
  2. ok 2 - New query executed without error
  3. ok 3 - Resulting rows are the same
  4. not ok 4 - New query is quicker
  5. #   Failed test 'New query is quicker'
  6. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  7. #     '-0.000259'
  8. #         >
  9. #     '0'
  10. ok 5 - Original query executed without error
  11. ok 6 - New query executed without error
  12. ok 7 - Resulting rows are the same
  13. not ok 8 - New query is quicker
  14. #   Failed test 'New query is quicker'
  15. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  16. #     '-4.00000000000004e-06'
  17. #         >
  18. #     '0'
  19. ok 9 - Original query executed without error
  20. ok 10 - New query executed without error
  21. ok 11 - Resulting rows are the same
  22. not ok 12 - New query is quicker
  23. #   Failed test 'New query is quicker'
  24. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  25. #     '-0.000231'
  26. #         >
  27. #     '0'
  28. ok 13 - Original query executed without error
  29. ok 14 - New query executed without error
  30. ok 15 - Resulting rows are the same
  31. not ok 16 - New query is quicker
  32. #   Failed test 'New query is quicker'
  33. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  34. #     '-4.1e-05'
  35. #         >
  36. #     '0'
  37. ok 17 - Original query executed without error
  38. ok 18 - New query executed without error
  39. ok 19 - Resulting rows are the same
  40. not ok 20 - New query is quicker
  41. #   Failed test 'New query is quicker'
  42. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  43. #     '-0.000145'
  44. #         >
  45. #     '0'
  46. ok 21 - Original query executed without error
  47. ok 22 - New query executed without error
  48. ok 23 - Resulting rows are the same
  49. ok 24 - New query is quicker
  50. ok 25 - Original query executed without error
  51. ok 26 - New query executed without error
  52. ok 27 - Resulting rows are the same
  53. ok 28 - New query is quicker
  54. ok 29 - Original query executed without error
  55. ok 30 - New query executed without error
  56. ok 31 - Resulting rows are the same
  57. not ok 32 - New query is quicker
  58. #   Failed test 'New query is quicker'
  59. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  60. #     '-0.000139'
  61. #         >
  62. #     '0'
  63. ok 33 - Original query executed without error
  64. ok 34 - New query executed without error
  65. ok 35 - Resulting rows are the same
  66. not ok 36 - New query is quicker
  67. #   Failed test 'New query is quicker'
  68. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  69. #     '-0.000251'
  70. #         >
  71. #     '0'
  72. ok 37 - Original query executed without error
  73. ok 38 - New query executed without error
  74. ok 39 - Resulting rows are the same
  75. not ok 40 - New query is quicker
  76. #   Failed test 'New query is quicker'
  77. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  78. #     '-9.2e-05'
  79. #         >
  80. #     '0'
  81. ok 41 - Original query executed without error
  82. ok 42 - New query executed without error
  83. ok 43 - Resulting rows are the same
  84. not ok 44 - New query is quicker
  85. #   Failed test 'New query is quicker'
  86. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  87. #     '-0.000126'
  88. #         >
  89. #     '0'
  90. ok 45 - Original query executed without error
  91. ok 46 - New query executed without error
  92. ok 47 - Resulting rows are the same
  93. not ok 48 - New query is quicker
  94. #   Failed test 'New query is quicker'
  95. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  96. #     '-0.000324'
  97. #         >
  98. #     '0'
  99. ok 49 - Original query executed without error
  100. ok 50 - New query executed without error
  101. ok 51 - Resulting rows are the same
  102. not ok 52 - New query is quicker
  103. #   Failed test 'New query is quicker'
  104. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  105. #     '-0.000141'
  106. #         >
  107. #     '0'
  108. ok 53 - Original query executed without error
  109. ok 54 - New query executed without error
  110. ok 55 - Resulting rows are the same
  111. not ok 56 - New query is quicker
  112. #   Failed test 'New query is quicker'
  113. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  114. #     '-0.000128'
  115. #         >
  116. #     '0'
  117. ok 57 - Original query executed without error
  118. ok 58 - New query executed without error
  119. ok 59 - Resulting rows are the same
  120. ok 60 - New query is quicker
  121. ok 61 - Original query executed without error
  122. ok 62 - New query executed without error
  123. ok 63 - Resulting rows are the same
  124. not ok 64 - New query is quicker
  125. #   Failed test 'New query is quicker'
  126. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  127. #     '-0.000171'
  128. #         >
  129. #     '0'
  130. ok 65 - Original query executed without error
  131. ok 66 - New query executed without error
  132. ok 67 - Resulting rows are the same
  133. not ok 68 - New query is quicker
  134. #   Failed test 'New query is quicker'
  135. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  136. #     '-0.000417'
  137. #         >
  138. #     '0'
  139. ok 69 - Original query executed without error
  140. ok 70 - New query executed without error
  141. ok 71 - Resulting rows are the same
  142. ok 72 - New query is quicker
  143. ok 73 - Original query executed without error
  144. ok 74 - New query executed without error
  145. ok 75 - Resulting rows are the same
  146. not ok 76 - New query is quicker
  147. #   Failed test 'New query is quicker'
  148. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  149. #     '-0.0319479999999999'
  150. #         >
  151. #     '0'
  152. ok 77 - Original query executed without error
  153. ok 78 - New query executed without error
  154. ok 79 - Resulting rows are the same
  155. not ok 80 - New query is quicker
  156. #   Failed test 'New query is quicker'
  157. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  158. #     '-1.2e-05'
  159. #         >
  160. #     '0'
  161. ok 81 - Original query executed without error
  162. ok 82 - New query executed without error
  163. ok 83 - Resulting rows are the same
  164. ok 84 - New query is quicker
  165. ok 85 - Original query executed without error
  166. ok 86 - New query executed without error
  167. ok 87 - Resulting rows are the same
  168. ok 88 - New query is quicker
  169. ok 89 - Original query executed without error
  170. ok 90 - New query executed without error
  171. ok 91 - Resulting rows are the same
  172. ok 92 - New query is quicker
  173. ok 93 - Original query executed without error
  174. ok 94 - New query executed without error
  175. ok 95 - Resulting rows are the same
  176. ok 96 - New query is quicker
  177. ok 97 - Original query executed without error
  178. ok 98 - New query executed without error
  179. ok 99 - Resulting rows are the same
  180. ok 100 - New query is quicker
  181. ok 101 - Original query executed without error
  182. ok 102 - New query executed without error
  183. ok 103 - Resulting rows are the same
  184. ok 104 - New query is quicker
  185. ok 105 - Original query executed without error
  186. ok 106 - New query executed without error
  187. ok 107 - Resulting rows are the same
  188. not ok 108 - New query is quicker
  189. #   Failed test 'New query is quicker'
  190. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  191. #     '-6.1e-05'
  192. #         >
  193. #     '0'
  194. ok 109 - Original query executed without error
  195. ok 110 - New query executed without error
  196. ok 111 - Resulting rows are the same
  197. ok 112 - New query is quicker
  198. ok 113 - Original query executed without error
  199. ok 114 - New query executed without error
  200. ok 115 - Resulting rows are the same
  201. not ok 116 - New query is quicker
  202. #   Failed test 'New query is quicker'
  203. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  204. #     '-1.6e-05'
  205. #         >
  206. #     '0'
  207. ok 117 - Original query executed without error
  208. ok 118 - New query executed without error
  209. ok 119 - Resulting rows are the same
  210. ok 120 - New query is quicker
  211. ok 121 - Original query executed without error
  212. ok 122 - New query executed without error
  213. ok 123 - Resulting rows are the same
  214. not ok 124 - New query is quicker
  215. #   Failed test 'New query is quicker'
  216. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  217. #     '-0.00014'
  218. #         >
  219. #     '0'
  220. ok 125 - Original query executed without error
  221. ok 126 - New query executed without error
  222. ok 127 - Resulting rows are the same
  223. ok 128 - New query is quicker
  224. ok 129 - Original query executed without error
  225. ok 130 - New query executed without error
  226. ok 131 - Resulting rows are the same
  227. not ok 132 - New query is quicker
  228. #   Failed test 'New query is quicker'
  229. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  230. #     '-0.000159'
  231. #         >
  232. #     '0'
  233. ok 133 - Original query executed without error
  234. ok 134 - New query executed without error
  235. not ok 135 - Resulting rows are the same
  236. #   Failed test 'Resulting rows are the same'
  237. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 83.
  238. #     Structures begin differing at:
  239. #          $got->[21][0] = '82'
  240. #     $expected->[21][0] = '106'
  241. [ERROR] 2013/05/21 10:27:33 [Line: 205] HAS DIFFERING RESULTS
  242. [ERROR] 2013/05/21 10:27:33 SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM (SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword ) AS dummy ORDER BY name
  243. [ERROR] 2013/05/21 10:27:33 SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword ORDER BY name
  244. ok 136 - New query is quicker
  245. ok 137 - Original query executed without error
  246. ok 138 - New query executed without error
  247. ok 139 - Resulting rows are the same
  248. ok 140 - New query is quicker
  249. ok 141 - Original query executed without error
  250. ok 142 - New query executed without error
  251. ok 143 - Resulting rows are the same
  252. ok 144 - New query is quicker
  253. ok 145 - Original query executed without error
  254. ok 146 - New query executed without error
  255. ok 147 - Resulting rows are the same
  256. not ok 148 - New query is quicker
  257. #   Failed test 'New query is quicker'
  258. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  259. #     '-0.004759'
  260. #         >
  261. #     '0'
  262. ok 149 - Original query executed without error
  263. ok 150 - New query executed without error
  264. ok 151 - Resulting rows are the same
  265. ok 152 - New query is quicker
  266. ok 153 - Original query executed without error
  267. ok 154 - New query executed without error
  268. ok 155 - Resulting rows are the same
  269. ok 156 - New query is quicker
  270. ok 157 - Original query executed without error
  271. ok 158 - New query executed without error
  272. ok 159 - Resulting rows are the same
  273. not ok 160 - New query is quicker
  274. #   Failed test 'New query is quicker'
  275. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  276. #     '-0.000324'
  277. #         >
  278. #     '0'
  279. ok 161 - Original query executed without error
  280. ok 162 - New query executed without error
  281. ok 163 - Resulting rows are the same
  282. ok 164 - New query is quicker
  283. ok 165 - Original query executed without error
  284. ok 166 - New query executed without error
  285. ok 167 - Resulting rows are the same
  286. not ok 168 - New query is quicker
  287. #   Failed test 'New query is quicker'
  288. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  289. #     '-0.004198'
  290. #         >
  291. #     '0'
  292. ok 169 - Original query executed without error
  293. ok 170 - New query executed without error
  294. ok 171 - Resulting rows are the same
  295. not ok 172 - New query is quicker
  296. #   Failed test 'New query is quicker'
  297. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  298. #     '-0.001969'
  299. #         >
  300. #     '0'
  301. ok 173 - Original query executed without error
  302. ok 174 - New query executed without error
  303. ok 175 - Resulting rows are the same
  304. not ok 176 - New query is quicker
  305. #   Failed test 'New query is quicker'
  306. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  307. #     '-0.001552'
  308. #         >
  309. #     '0'
  310. ok 177 - Original query executed without error
  311. ok 178 - New query executed without error
  312. ok 179 - Resulting rows are the same
  313. not ok 180 - New query is quicker
  314. #   Failed test 'New query is quicker'
  315. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  316. #     '-0.004176'
  317. #         >
  318. #     '0'
  319. ok 181 - Original query executed without error
  320. ok 182 - New query executed without error
  321. ok 183 - Resulting rows are the same
  322. not ok 184 - New query is quicker
  323. #   Failed test 'New query is quicker'
  324. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  325. #     '-0.000287'
  326. #         >
  327. #     '0'
  328. ok 185 - Original query executed without error
  329. ok 186 - New query executed without error
  330. ok 187 - Resulting rows are the same
  331. not ok 188 - New query is quicker
  332. #   Failed test 'New query is quicker'
  333. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  334. #     '-0.000446'
  335. #         >
  336. #     '0'
  337. ok 189 - Original query executed without error
  338. ok 190 - New query executed without error
  339. ok 191 - Resulting rows are the same
  340. not ok 192 - New query is quicker
  341. #   Failed test 'New query is quicker'
  342. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  343. #     '-0.003149'
  344. #         >
  345. #     '0'
  346. ok 193 - Original query executed without error
  347. ok 194 - New query executed without error
  348. ok 195 - Resulting rows are the same
  349. not ok 196 - New query is quicker
  350. #   Failed test 'New query is quicker'
  351. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  352. #     '-0.003033'
  353. #         >
  354. #     '0'
  355. ok 197 - Original query executed without error
  356. ok 198 - New query executed without error
  357. ok 199 - Resulting rows are the same
  358. not ok 200 - New query is quicker
  359. #   Failed test 'New query is quicker'
  360. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  361. #     '-0.0032'
  362. #         >
  363. #     '0'
  364. ok 201 - Original query executed without error
  365. ok 202 - New query executed without error
  366. ok 203 - Resulting rows are the same
  367. not ok 204 - New query is quicker
  368. #   Failed test 'New query is quicker'
  369. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  370. #     '-0.003202'
  371. #         >
  372. #     '0'
  373. ok 205 - Original query executed without error
  374. ok 206 - New query executed without error
  375. ok 207 - Resulting rows are the same
  376. not ok 208 - New query is quicker
  377. #   Failed test 'New query is quicker'
  378. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  379. #     '-0.003079'
  380. #         >
  381. #     '0'
  382. ok 209 - Original query executed without error
  383. ok 210 - New query executed without error
  384. ok 211 - Resulting rows are the same
  385. not ok 212 - New query is quicker
  386. #   Failed test 'New query is quicker'
  387. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  388. #     '-0.003152'
  389. #         >
  390. #     '0'
  391. ok 213 - Original query executed without error
  392. ok 214 - New query executed without error
  393. ok 215 - Resulting rows are the same
  394. not ok 216 - New query is quicker
  395. #   Failed test 'New query is quicker'
  396. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  397. #     '-0.003249'
  398. #         >
  399. #     '0'
  400. ok 217 - Original query executed without error
  401. ok 218 - New query executed without error
  402. ok 219 - Resulting rows are the same
  403. not ok 220 - New query is quicker
  404. #   Failed test 'New query is quicker'
  405. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  406. #     '-0.003007'
  407. #         >
  408. #     '0'
  409. ok 221 - Original query executed without error
  410. ok 222 - New query executed without error
  411. ok 223 - Resulting rows are the same
  412. not ok 224 - New query is quicker
  413. #   Failed test 'New query is quicker'
  414. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  415. #     '-0.00318899999999998'
  416. #         >
  417. #     '0'
  418. ok 225 - Original query executed without error
  419. ok 226 - New query executed without error
  420. ok 227 - Resulting rows are the same
  421. not ok 228 - New query is quicker
  422. #   Failed test 'New query is quicker'
  423. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  424. #     '-0.003179'
  425. #         >
  426. #     '0'
  427. ok 229 - Original query executed without error
  428. ok 230 - New query executed without error
  429. ok 231 - Resulting rows are the same
  430. not ok 232 - New query is quicker
  431. #   Failed test 'New query is quicker'
  432. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  433. #     '-0.002291'
  434. #         >
  435. #     '0'
  436. ok 233 - Original query executed without error
  437. ok 234 - New query executed without error
  438. ok 235 - Resulting rows are the same
  439. not ok 236 - New query is quicker
  440. #   Failed test 'New query is quicker'
  441. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  442. #     '-0.004371'
  443. #         >
  444. #     '0'
  445. ok 237 - Original query executed without error
  446. ok 238 - New query executed without error
  447. ok 239 - Resulting rows are the same
  448. not ok 240 - New query is quicker
  449. #   Failed test 'New query is quicker'
  450. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  451. #     '-0.012928'
  452. #         >
  453. #     '0'
  454. ok 241 - Original query executed without error
  455. ok 242 - New query executed without error
  456. ok 243 - Resulting rows are the same
  457. not ok 244 - New query is quicker
  458. #   Failed test 'New query is quicker'
  459. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  460. #     '-0.009323'
  461. #         >
  462. #     '0'
  463. ok 245 - Original query executed without error
  464. ok 246 - New query executed without error
  465. ok 247 - Resulting rows are the same
  466. ok 248 - New query is quicker
  467. ok 249 - Original query executed without error
  468. ok 250 - New query executed without error
  469. ok 251 - Resulting rows are the same
  470. not ok 252 - New query is quicker
  471. #   Failed test 'New query is quicker'
  472. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  473. #     '-5.7e-05'
  474. #         >
  475. #     '0'
  476. ok 253 - Original query executed without error
  477. ok 254 - New query executed without error
  478. ok 255 - Resulting rows are the same
  479. not ok 256 - New query is quicker
  480. #   Failed test 'New query is quicker'
  481. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  482. #     '-0.005197'
  483. #         >
  484. #     '0'
  485. ok 257 - Original query executed without error
  486. ok 258 - New query executed without error
  487. ok 259 - Resulting rows are the same
  488. not ok 260 - New query is quicker
  489. #   Failed test 'New query is quicker'
  490. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  491. #     '-0.000389'
  492. #         >
  493. #     '0'
  494. ok 261 - Original query executed without error
  495. ok 262 - New query executed without error
  496. ok 263 - Resulting rows are the same
  497. ok 264 - New query is quicker
  498. ok 265 - Original query executed without error
  499. ok 266 - New query executed without error
  500. ok 267 - Resulting rows are the same
  501. ok 268 - New query is quicker
  502. ok 269 - Original query executed without error
  503. ok 270 - New query executed without error
  504. ok 271 - Resulting rows are the same
  505. not ok 272 - New query is quicker
  506. #   Failed test 'New query is quicker'
  507. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  508. #     '-0.005605'
  509. #         >
  510. #     '0'
  511. ok 273 - Original query executed without error
  512. ok 274 - New query executed without error
  513. ok 275 - Resulting rows are the same
  514. not ok 276 - New query is quicker
  515. #   Failed test 'New query is quicker'
  516. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  517. #     '-0.000311'
  518. #         >
  519. #     '0'
  520. ok 277 - Original query executed without error
  521. ok 278 - New query executed without error
  522. ok 279 - Resulting rows are the same
  523. not ok 280 - New query is quicker
  524. #   Failed test 'New query is quicker'
  525. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  526. #     '-0.000268'
  527. #         >
  528. #     '0'
  529. ok 281 - Original query executed without error
  530. ok 282 - New query executed without error
  531. ok 283 - Resulting rows are the same
  532. ok 284 - New query is quicker
  533. ok 285 - Original query executed without error
  534. ok 286 - New query executed without error
  535. ok 287 - Resulting rows are the same
  536. not ok 288 - New query is quicker
  537. #   Failed test 'New query is quicker'
  538. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  539. #     '-0.000155'
  540. #         >
  541. #     '0'
  542. ok 289 - Original query executed without error
  543. ok 290 - New query executed without error
  544. ok 291 - Resulting rows are the same
  545. ok 292 - New query is quicker
  546. ok 293 - Original query executed without error
  547. ok 294 - New query executed without error
  548. ok 295 - Resulting rows are the same
  549. not ok 296 - New query is quicker
  550. #   Failed test 'New query is quicker'
  551. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  552. #     '-0.001852'
  553. #         >
  554. #     '0'
  555. ok 297 - Original query executed without error
  556. ok 298 - New query executed without error
  557. ok 299 - Resulting rows are the same
  558. ok 300 - New query is quicker
  559. ok 301 - Original query executed without error
  560. ok 302 - New query executed without error
  561. ok 303 - Resulting rows are the same
  562. not ok 304 - New query is quicker
  563. #   Failed test 'New query is quicker'
  564. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  565. #     '-0.000114'
  566. #         >
  567. #     '0'
  568. ok 305 - Original query executed without error
  569. ok 306 - New query executed without error
  570. ok 307 - Resulting rows are the same
  571. not ok 308 - New query is quicker
  572. #   Failed test 'New query is quicker'
  573. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  574. #     '-6.1e-05'
  575. #         >
  576. #     '0'
  577. ok 309 - Original query executed without error
  578. ok 310 - New query executed without error
  579. ok 311 - Resulting rows are the same
  580. not ok 312 - New query is quicker
  581. #   Failed test 'New query is quicker'
  582. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  583. #     '-0.00029'
  584. #         >
  585. #     '0'
  586. ok 313 - Original query executed without error
  587. ok 314 - New query executed without error
  588. ok 315 - Resulting rows are the same
  589. ok 316 - New query is quicker
  590. ok 317 - Original query executed without error
  591. ok 318 - New query executed without error
  592. ok 319 - Resulting rows are the same
  593. not ok 320 - New query is quicker
  594. #   Failed test 'New query is quicker'
  595. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  596. #     '-0.000169'
  597. #         >
  598. #     '0'
  599. ok 321 - Original query executed without error
  600. ok 322 - New query executed without error
  601. ok 323 - Resulting rows are the same
  602. not ok 324 - New query is quicker
  603. #   Failed test 'New query is quicker'
  604. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  605. #     '-0.00014'
  606. #         >
  607. #     '0'
  608. ok 325 - Original query executed without error
  609. ok 326 - New query executed without error
  610. ok 327 - Resulting rows are the same
  611. not ok 328 - New query is quicker
  612. #   Failed test 'New query is quicker'
  613. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  614. #     '-4.5e-05'
  615. #         >
  616. #     '0'
  617. ok 329 - Original query executed without error
  618. ok 330 - New query executed without error
  619. ok 331 - Resulting rows are the same
  620. ok 332 - New query is quicker
  621. ok 333 - Original query executed without error
  622. ok 334 - New query executed without error
  623. ok 335 - Resulting rows are the same
  624. not ok 336 - New query is quicker
  625. #   Failed test 'New query is quicker'
  626. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  627. #     '-0.000651'
  628. #         >
  629. #     '0'
  630. ok 337 - Original query executed without error
  631. ok 338 - New query executed without error
  632. ok 339 - Resulting rows are the same
  633. not ok 340 - New query is quicker
  634. #   Failed test 'New query is quicker'
  635. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  636. #     '-0.00149'
  637. #         >
  638. #     '0'
  639. ok 341 - Original query executed without error
  640. ok 342 - New query executed without error
  641. ok 343 - Resulting rows are the same
  642. not ok 344 - New query is quicker
  643. #   Failed test 'New query is quicker'
  644. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  645. #     '-5.1e-05'
  646. #         >
  647. #     '0'
  648. ok 345 - Original query executed without error
  649. ok 346 - New query executed without error
  650. ok 347 - Resulting rows are the same
  651. not ok 348 - New query is quicker
  652. #   Failed test 'New query is quicker'
  653. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  654. #     '-0.001536'
  655. #         >
  656. #     '0'
  657. ok 349 - Original query executed without error
  658. ok 350 - New query executed without error
  659. ok 351 - Resulting rows are the same
  660. not ok 352 - New query is quicker
  661. #   Failed test 'New query is quicker'
  662. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  663. #     '-0.001582'
  664. #         >
  665. #     '0'
  666. ok 353 - Original query executed without error
  667. ok 354 - New query executed without error
  668. ok 355 - Resulting rows are the same
  669. not ok 356 - New query is quicker
  670. #   Failed test 'New query is quicker'
  671. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  672. #     '-0.001509'
  673. #         >
  674. #     '0'
  675. ok 357 - Original query executed without error
  676. ok 358 - New query executed without error
  677. ok 359 - Resulting rows are the same
  678. not ok 360 - New query is quicker
  679. #   Failed test 'New query is quicker'
  680. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  681. #     '-0.001771'
  682. #         >
  683. #     '0'
  684. ok 361 - Original query executed without error
  685. ok 362 - New query executed without error
  686. ok 363 - Resulting rows are the same
  687. not ok 364 - New query is quicker
  688. #   Failed test 'New query is quicker'
  689. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  690. #     '-0.001466'
  691. #         >
  692. #     '0'
  693. ok 365 - Original query executed without error
  694. ok 366 - New query executed without error
  695. ok 367 - Resulting rows are the same
  696. not ok 368 - New query is quicker
  697. #   Failed test 'New query is quicker'
  698. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  699. #     '-0.001425'
  700. #         >
  701. #     '0'
  702. ok 369 - Original query executed without error
  703. ok 370 - New query executed without error
  704. ok 371 - Resulting rows are the same
  705. not ok 372 - New query is quicker
  706. #   Failed test 'New query is quicker'
  707. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  708. #     '-0.001562'
  709. #         >
  710. #     '0'
  711. ok 373 - Original query executed without error
  712. ok 374 - New query executed without error
  713. ok 375 - Resulting rows are the same
  714. not ok 376 - New query is quicker
  715. #   Failed test 'New query is quicker'
  716. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  717. #     '-0.001654'
  718. #         >
  719. #     '0'
  720. ok 377 - Original query executed without error
  721. ok 378 - New query executed without error
  722. ok 379 - Resulting rows are the same
  723. not ok 380 - New query is quicker
  724. #   Failed test 'New query is quicker'
  725. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  726. #     '-0.001485'
  727. #         >
  728. #     '0'
  729. ok 381 - Original query executed without error
  730. ok 382 - New query executed without error
  731. ok 383 - Resulting rows are the same
  732. not ok 384 - New query is quicker
  733. #   Failed test 'New query is quicker'
  734. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  735. #     '-0.001634'
  736. #         >
  737. #     '0'
  738. ok 385 - Original query executed without error
  739. ok 386 - New query executed without error
  740. ok 387 - Resulting rows are the same
  741. ok 388 - New query is quicker
  742. ok 389 - Original query executed without error
  743. ok 390 - New query executed without error
  744. ok 391 - Resulting rows are the same
  745. not ok 392 - New query is quicker
  746. #   Failed test 'New query is quicker'
  747. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  748. #     '-0.012206'
  749. #         >
  750. #     '0'
  751. ok 393 - Original query executed without error
  752. ok 394 - New query executed without error
  753. ok 395 - Resulting rows are the same
  754. not ok 396 - New query is quicker
  755. #   Failed test 'New query is quicker'
  756. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  757. #     '-0.002003'
  758. #         >
  759. #     '0'
  760. ok 397 - Original query executed without error
  761. ok 398 - New query executed without error
  762. ok 399 - Resulting rows are the same
  763. not ok 400 - New query is quicker
  764. #   Failed test 'New query is quicker'
  765. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  766. #     '-0.002105'
  767. #         >
  768. #     '0'
  769. ok 401 - Original query executed without error
  770. ok 402 - New query executed without error
  771. ok 403 - Resulting rows are the same
  772. not ok 404 - New query is quicker
  773. #   Failed test 'New query is quicker'
  774. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  775. #     '-0.00432'
  776. #         >
  777. #     '0'
  778. ok 405 - Original query executed without error
  779. ok 406 - New query executed without error
  780. ok 407 - Resulting rows are the same
  781. not ok 408 - New query is quicker
  782. #   Failed test 'New query is quicker'
  783. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  784. #     '-0.005829'
  785. #         >
  786. #     '0'
  787. ok 409 - Original query executed without error
  788. ok 410 - New query executed without error
  789. ok 411 - Resulting rows are the same
  790. ok 412 - New query is quicker
  791. ok 413 - Original query executed without error
  792. ok 414 - New query executed without error
  793. ok 415 - Resulting rows are the same
  794. ok 416 - New query is quicker
  795. ok 417 - Original query executed without error
  796. ok 418 - New query executed without error
  797. ok 419 - Resulting rows are the same
  798. not ok 420 - New query is quicker
  799. #   Failed test 'New query is quicker'
  800. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  801. #     '-0.010249'
  802. #         >
  803. #     '0'
  804. ok 421 - Original query executed without error
  805. ok 422 - New query executed without error
  806. ok 423 - Resulting rows are the same
  807. not ok 424 - New query is quicker
  808. #   Failed test 'New query is quicker'
  809. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  810. #     '-0.011411'
  811. #         >
  812. #     '0'
  813. ok 425 - Original query executed without error
  814. ok 426 - New query executed without error
  815. ok 427 - Resulting rows are the same
  816. not ok 428 - New query is quicker
  817. #   Failed test 'New query is quicker'
  818. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  819. #     '-0.000425'
  820. #         >
  821. #     '0'
  822. ok 429 - Original query executed without error
  823. ok 430 - New query executed without error
  824. ok 431 - Resulting rows are the same
  825. not ok 432 - New query is quicker
  826. #   Failed test 'New query is quicker'
  827. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  828. #     '-0.00025'
  829. #         >
  830. #     '0'
  831. ok 433 - Original query executed without error
  832. ok 434 - New query executed without error
  833. ok 435 - Resulting rows are the same
  834. not ok 436 - New query is quicker
  835. #   Failed test 'New query is quicker'
  836. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  837. #     '-0.000229'
  838. #         >
  839. #     '0'
  840. ok 437 - Original query executed without error
  841. ok 438 - New query executed without error
  842. ok 439 - Resulting rows are the same
  843. not ok 440 - New query is quicker
  844. #   Failed test 'New query is quicker'
  845. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  846. #     '-0.000207'
  847. #         >
  848. #     '0'
  849. ok 441 - Original query executed without error
  850. ok 442 - New query executed without error
  851. ok 443 - Resulting rows are the same
  852. not ok 444 - New query is quicker
  853. #   Failed test 'New query is quicker'
  854. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  855. #     '-0.000234'
  856. #         >
  857. #     '0'
  858. ok 445 - Original query executed without error
  859. ok 446 - New query executed without error
  860. ok 447 - Resulting rows are the same
  861. not ok 448 - New query is quicker
  862. #   Failed test 'New query is quicker'
  863. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  864. #     '-0.003139'
  865. #         >
  866. #     '0'
  867. ok 449 - Original query executed without error
  868. ok 450 - New query executed without error
  869. ok 451 - Resulting rows are the same
  870. ok 452 - New query is quicker
  871. ok 453 - Original query executed without error
  872. ok 454 - New query executed without error
  873. ok 455 - Resulting rows are the same
  874. not ok 456 - New query is quicker
  875. #   Failed test 'New query is quicker'
  876. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  877. #     '-6.00000000000001e-06'
  878. #         >
  879. #     '0'
  880. ok 457 - Original query executed without error
  881. ok 458 - New query executed without error
  882. ok 459 - Resulting rows are the same
  883. not ok 460 - New query is quicker
  884. #   Failed test 'New query is quicker'
  885. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  886. #     '-0.000278'
  887. #         >
  888. #     '0'
  889. ok 461 - Original query executed without error
  890. ok 462 - New query executed without error
  891. ok 463 - Resulting rows are the same
  892. not ok 464 - New query is quicker
  893. #   Failed test 'New query is quicker'
  894. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  895. #     '-0.000259'
  896. #         >
  897. #     '0'
  898. ok 465 - Original query executed without error
  899. ok 466 - New query executed without error
  900. ok 467 - Resulting rows are the same
  901. ok 468 - New query is quicker
  902. ok 469 - Original query executed without error
  903. ok 470 - New query executed without error
  904. ok 471 - Resulting rows are the same
  905. ok 472 - New query is quicker
  906. ok 473 - Original query executed without error
  907. ok 474 - New query executed without error
  908. ok 475 - Resulting rows are the same
  909. not ok 476 - New query is quicker
  910. #   Failed test 'New query is quicker'
  911. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  912. #     '-0.000131'
  913. #         >
  914. #     '0'
  915. ok 477 - Original query executed without error
  916. ok 478 - New query executed without error
  917. ok 479 - Resulting rows are the same
  918. not ok 480 - New query is quicker
  919. #   Failed test 'New query is quicker'
  920. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  921. #     '-0.000205'
  922. #         >
  923. #     '0'
  924. ok 481 - Original query executed without error
  925. ok 482 - New query executed without error
  926. ok 483 - Resulting rows are the same
  927. not ok 484 - New query is quicker
  928. #   Failed test 'New query is quicker'
  929. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  930. #     '-0.000248'
  931. #         >
  932. #     '0'
  933. ok 485 - Original query executed without error
  934. ok 486 - New query executed without error
  935. ok 487 - Resulting rows are the same
  936. not ok 488 - New query is quicker
  937. #   Failed test 'New query is quicker'
  938. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  939. #     '-0.001385'
  940. #         >
  941. #     '0'
  942. ok 489 - Original query executed without error
  943. ok 490 - New query executed without error
  944. ok 491 - Resulting rows are the same
  945. not ok 492 - New query is quicker
  946. #   Failed test 'New query is quicker'
  947. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  948. #     '-0.003'
  949. #         >
  950. #     '0'
  951. ok 493 - Original query executed without error
  952. ok 494 - New query executed without error
  953. ok 495 - Resulting rows are the same
  954. not ok 496 - New query is quicker
  955. #   Failed test 'New query is quicker'
  956. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  957. #     '-0.003134'
  958. #         >
  959. #     '0'
  960. ok 497 - Original query executed without error
  961. ok 498 - New query executed without error
  962. ok 499 - Resulting rows are the same
  963. not ok 500 - New query is quicker
  964. #   Failed test 'New query is quicker'
  965. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  966. #     '-0.003154'
  967. #         >
  968. #     '0'
  969. ok 501 - Original query executed without error
  970. ok 502 - New query executed without error
  971. ok 503 - Resulting rows are the same
  972. not ok 504 - New query is quicker
  973. #   Failed test 'New query is quicker'
  974. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  975. #     '-0.003039'
  976. #         >
  977. #     '0'
  978. ok 505 - Original query executed without error
  979. ok 506 - New query executed without error
  980. ok 507 - Resulting rows are the same
  981. not ok 508 - New query is quicker
  982. #   Failed test 'New query is quicker'
  983. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  984. #     '-0.00315'
  985. #         >
  986. #     '0'
  987. ok 509 - Original query executed without error
  988. ok 510 - New query executed without error
  989. ok 511 - Resulting rows are the same
  990. not ok 512 - New query is quicker
  991. #   Failed test 'New query is quicker'
  992. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  993. #     '-0.002969'
  994. #         >
  995. #     '0'
  996. ok 513 - Original query executed without error
  997. ok 514 - New query executed without error
  998. ok 515 - Resulting rows are the same
  999. not ok 516 - New query is quicker
  1000. #   Failed test 'New query is quicker'
  1001. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1002. #     '-0.00322'
  1003. #         >
  1004. #     '0'
  1005. ok 517 - Original query executed without error
  1006. ok 518 - New query executed without error
  1007. ok 519 - Resulting rows are the same
  1008. not ok 520 - New query is quicker
  1009. #   Failed test 'New query is quicker'
  1010. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1011. #     '-0.003106'
  1012. #         >
  1013. #     '0'
  1014. ok 521 - Original query executed without error
  1015. ok 522 - New query executed without error
  1016. ok 523 - Resulting rows are the same
  1017. not ok 524 - New query is quicker
  1018. #   Failed test 'New query is quicker'
  1019. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1020. #     '-0.00319'
  1021. #         >
  1022. #     '0'
  1023. ok 525 - Original query executed without error
  1024. ok 526 - New query executed without error
  1025. ok 527 - Resulting rows are the same
  1026. not ok 528 - New query is quicker
  1027. #   Failed test 'New query is quicker'
  1028. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1029. #     '-0.003142'
  1030. #         >
  1031. #     '0'
  1032. ok 529 - Original query executed without error
  1033. ok 530 - New query executed without error
  1034. ok 531 - Resulting rows are the same
  1035. not ok 532 - New query is quicker
  1036. #   Failed test 'New query is quicker'
  1037. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1038. #     '-0.000203'
  1039. #         >
  1040. #     '0'
  1041. ok 533 - Original query executed without error
  1042. ok 534 - New query executed without error
  1043. ok 535 - Resulting rows are the same
  1044. not ok 536 - New query is quicker
  1045. #   Failed test 'New query is quicker'
  1046. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1047. #     '-0.013875'
  1048. #         >
  1049. #     '0'
  1050. ok 537 - Original query executed without error
  1051. ok 538 - New query executed without error
  1052. ok 539 - Resulting rows are the same
  1053. not ok 540 - New query is quicker
  1054. #   Failed test 'New query is quicker'
  1055. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1056. #     '-0.000912'
  1057. #         >
  1058. #     '0'
  1059. ok 541 - Original query executed without error
  1060. ok 542 - New query executed without error
  1061. ok 543 - Resulting rows are the same
  1062. not ok 544 - New query is quicker
  1063. #   Failed test 'New query is quicker'
  1064. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1065. #     '-0.003608'
  1066. #         >
  1067. #     '0'
  1068. ok 545 - Original query executed without error
  1069. ok 546 - New query executed without error
  1070. ok 547 - Resulting rows are the same
  1071. not ok 548 - New query is quicker
  1072. #   Failed test 'New query is quicker'
  1073. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1074. #     '-0.003903'
  1075. #         >
  1076. #     '0'
  1077. ok 549 - Original query executed without error
  1078. ok 550 - New query executed without error
  1079. ok 551 - Resulting rows are the same
  1080. not ok 552 - New query is quicker
  1081. #   Failed test 'New query is quicker'
  1082. #   at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108.
  1083. #     '-0.00425'
  1084. #         >
  1085. #     '0'
  1086. ok 553 - Original query executed without error
  1087. ok 554 - New query executed without error
  1088. ok 555 - Resulting rows are the same
  1089. ok 556 - New query is quicker
  1090. 1..556
  1091. [INFO] 2013/05/21 10:27:40                              Query count: 139
  1092. [INFO] 2013/05/21 10:27:40                        Failures - Before: 0
  1093. [INFO] 2013/05/21 10:27:40                         Failures - After: 0
  1094. [INFO] 2013/05/21 10:27:40                    Has differing results: 1
  1095. [INFO] 2013/05/21 10:27:40           Best time difference (seconds): 1.937168
  1096. [INFO] 2013/05/21 10:27:40          Worst time difference (seconds): -0.0319479999999999
  1097. [INFO] 2013/05/21 10:27:40                   Best time difference %: 24.9974972469717
  1098. [INFO] 2013/05/21 10:27:40                  Worst time difference %: 328.319623971798
  1099. [INFO] 2013/05/21 10:27:40                      New query is slower: 105
  1100. [INFO] 2013/05/21 10:27:40 <<<<<<<<<<<<<<<<<<<<< SLOWER QUERIES >>>>>>>>>>>>>>>>>>>>>>
  1101. [INFO] 2013/05/21 10:27:40 [Line: 102 -0.03194800s 101.3774%]    SELECT image.id,image.filename,image.rotate,image.processing_priority,image.uploaded FROM image LEFT JOIN image_size ON image_size.image_id=image.id WHERE image.alive=1 AND image.processing_failures<5 AND (image.contains_video=0 OR (image.contains_video=1 AND image.video_still_created=1)) AND (image.original_details_verified=0 OR image.recheck=1 OR image.rotate=1 OR image.square_created=0 OR image.square_recreate=1 OR image.thumbnail_created=0 OR image.thumbnail_recreate=1 OR image.small_created=0 OR image.small_recreate=1 OR image.webview_created=0 OR image.webview_recreate=1 OR image_size.created=0 OR image_size.recreate=1) GROUP BY image.id,image.filename,image.rotate,image.processing_priority,image.uploaded ORDER BY image.processing_priority DESC,image.uploaded
  1102. [INFO] 2013/05/21 10:27:40 [Line: 674 -0.01387500s 140.6462%]    SELECT id, keywords_match, corrected, first_seen_time, last_seen_time, word_count, search_count, users_count, results_count, score, parent_search_term_id, alive, protected, deleted, data_json FROM search_term WHERE ( ( id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND keywords_match RLIKE ? AND users_count >= ? ) ) ORDER BY search_count DESC, keywords_match
  1103. [INFO] 2013/05/21 10:27:40 [Line: 492 -0.01292800s 177.4921%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( project.deleted = ? ) ORDER BY code
  1104. [INFO] 2013/05/21 10:27:40 [Line: 605 -0.01220600s 122.8363%]    SELECT id, keywords_match, corrected, first_seen_time, last_seen_time, word_count, search_count, users_count, results_count, score, parent_search_term_id, alive, protected, deleted, data_json FROM search_term WHERE ( ( keywords_match RLIKE ? AND users_count >= ? ) ) ORDER BY search_count DESC, keywords_match
  1105. [INFO] 2013/05/21 10:27:40 [Line: 644 -0.01141100s 328.1744%]    SELECT album.*
  1106. FROM album
  1107.     LEFT JOIN carousel ON album.id = carousel.default_album_id
  1108.      LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id
  1109. WHERE (album.oa_user_id = 3 OR (group2album.oa_group_id IN ('3') ) OR (user2album.oa_user_id = 3 ) OR ( album.share_with_all_users = 1 ))
  1110.     AND carousel.id IS NULL
  1111.     AND album.name RLIKE '[[:<:]]156'
  1112.  ORDER BY name LIMIT 15 OFFSET 0
  1113. [INFO] 2013/05/21 10:27:40 [Line: 643 -0.01024900s 286.3116%]    SELECT album.*
  1114. FROM album
  1115.     LEFT JOIN carousel ON album.id = carousel.default_album_id
  1116.      LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id
  1117. WHERE (album.oa_user_id = 3 OR (group2album.oa_group_id IN ('3') ) OR (user2album.oa_user_id = 3 ) OR ( album.share_with_all_users = 1 ))
  1118.     AND carousel.id IS NULL
  1119.     AND album.name LIKE '156%'
  1120.  ORDER BY name LIMIT 15 OFFSET 0
  1121. [INFO] 2013/05/21 10:27:40 [Line: 523 -0.00932300s 158.2797%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( project.alive = ? ) ORDER BY code
  1122. [INFO] 2013/05/21 10:27:40 [Line: 609 -0.00582900s 328.3196%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND hidden = ? AND username RLIKE ? AND valid = ? ) ) ORDER BY username
  1123. [INFO] 2013/05/21 10:27:40 [Line: 575 -0.00560500s 185.9531%]    SELECT album.*
  1124. FROM album
  1125.     LEFT JOIN carousel ON album.id = carousel.default_album_id
  1126.      LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id
  1127. WHERE (album.oa_user_id = 3 OR (group2album.oa_group_id IN ('3') ) OR (user2album.oa_user_id = 3 ) OR ( album.share_with_all_users = 1 ))
  1128.     AND carousel.id IS NULL
  1129.     AND album.name RLIKE '[[:<:]]abc'
  1130.  ORDER BY name LIMIT 15 OFFSET 0
  1131. [INFO] 2013/05/21 10:27:40 [Line: 533 -0.00519700s 131.8210%]    SELECT project.* FROM project JOIN project_keyword2project ON project.id = project_keyword2project.project_id JOIN project_keyword ON project_keyword.id = project_keyword2project.project_keyword_id WHERE ( ( project.alive = ? AND project_keyword.name LIKE ? ) ) GROUP BY project.id ORDER BY code
  1132. [INFO] 2013/05/21 10:27:40 [Line: 382 -0.00475900s 137.0408%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( project.alive = ? AND project.deleted = ? ) ) ORDER BY code
  1133. [INFO] 2013/05/21 10:27:40 [Line: 478 -0.00437100s 122.4326%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( project.deleted = ? ) ORDER BY name, code
  1134. [INFO] 2013/05/21 10:27:40 [Line: 608 -0.00432000s 242.0585%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND full_name RLIKE ? AND hidden = ? AND valid = ? ) ) ORDER BY full_name
  1135. [INFO] 2013/05/21 10:27:40 [Line: 678 -0.00425000s 239.3900%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND hidden = ? AND username RLIKE ? AND valid = ? ) ) ORDER BY username
  1136. [INFO] 2013/05/21 10:27:40 [Line: 431 -0.00419800s 122.0136%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( project.alive = ? AND project.deleted = ? ) ) ORDER BY name, code
  1137. [INFO] 2013/05/21 10:27:40 [Line: 440 -0.00417600s 214.5679%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code
  1138. [INFO] 2013/05/21 10:27:40 [Line: 677 -0.00390300s 233.9396%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND full_name RLIKE ? AND hidden = ? AND valid = ? ) ) ORDER BY full_name
  1139. [INFO] 2013/05/21 10:27:40 [Line: 676 -0.00360800s 234.2761%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND hidden = ? AND username LIKE ? AND valid = ? ) ) ORDER BY username
  1140. [INFO] 2013/05/21 10:27:40 [Line: 450 -0.00324900s 237.7279%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_1 LIKE ? ) ) ORDER BY name_alias_1
  1141. [INFO] 2013/05/21 10:27:40 [Line: 669 -0.00322000s 240.4274%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_1 LIKE ? ) ) ORDER BY name_alias_1
  1142. [INFO] 2013/05/21 10:27:40 [Line: 447 -0.00320200s 262.2087%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_1 LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_1
  1143. [INFO] 2013/05/21 10:27:40 [Line: 446 -0.00320000s 257.4803%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_1 LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_1
  1144. [INFO] 2013/05/21 10:27:40 [Line: 671 -0.00319000s 237.9161%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_2 LIKE ? ) ) ORDER BY name_alias_2
  1145. [INFO] 2013/05/21 10:27:40 [Line: 452 -0.00318900s 235.8177%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_2 LIKE ? ) ) ORDER BY name_alias_2
  1146. [INFO] 2013/05/21 10:27:40 [Line: 453 -0.00317900s 231.7993%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_2 LIKE ? ) ) ORDER BY name_alias_2
  1147. [INFO] 2013/05/21 10:27:40 [Line: 665 -0.00315400s 253.7037%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_1 LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_1
  1148. [INFO] 2013/05/21 10:27:40 [Line: 449 -0.00315200s 254.0567%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_2 LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_2
  1149. [INFO] 2013/05/21 10:27:40 [Line: 667 -0.00315000s 259.8985%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_2 LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_2
  1150. [INFO] 2013/05/21 10:27:40 [Line: 444 -0.00314900s 240.5176%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code
  1151. [INFO] 2013/05/21 10:27:40 [Line: 672 -0.00314200s 222.3997%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_2 RLIKE ? ) ) ORDER BY name_alias_2
  1152. [INFO] 2013/05/21 10:27:40 [Line: 650 -0.00313900s 206.2267%]    SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, copyright_policy_id, data_json FROM copyright_holder WHERE ( name RLIKE ? ) ORDER BY name
  1153. [INFO] 2013/05/21 10:27:40 [Line: 664 -0.00313400s 208.0690%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name RLIKE ? ) ) ORDER BY name
  1154. [INFO] 2013/05/21 10:27:40 [Line: 670 -0.00310600s 219.5535%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_1 RLIKE ? ) ) ORDER BY name_alias_1
  1155. [INFO] 2013/05/21 10:27:40 [Line: 448 -0.00307900s 257.8974%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_2 LIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_2
  1156. [INFO] 2013/05/21 10:27:40 [Line: 666 -0.00303900s 235.0067%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_1 RLIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_1
  1157. [INFO] 2013/05/21 10:27:40 [Line: 445 -0.00303300s 212.7929%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name LIKE ? ) ) ORDER BY name
  1158. [INFO] 2013/05/21 10:27:40 [Line: 451 -0.00300700s 216.1004%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name_alias_1 LIKE ? ) ) ORDER BY name_alias_1
  1159. [INFO] 2013/05/21 10:27:40 [Line: 663 -0.00300000s 222.5991%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code RLIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code
  1160. [INFO] 2013/05/21 10:27:40 [Line: 668 -0.00296900s 229.7640%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_2 RLIKE ? AND deleted = ? AND id NOT IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) ) ORDER BY code_alias_2
  1161. [INFO] 2013/05/21 10:27:40 [Line: 457 -0.00229100s 165.3079%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( ( project.code LIKE ? OR project.code_alias_1 LIKE ? OR project.code_alias_2 LIKE ? OR project.name LIKE ? OR project.name_alias_1 LIKE ? OR project.name_alias_2 LIKE ? ) AND project.alive = ? AND project.deleted = ? ) ) ORDER BY name, code
  1162. [INFO] 2013/05/21 10:27:40 [Line: 607 -0.00210500s 235.9819%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND hidden = ? AND username LIKE ? AND valid = ? ) ) ORDER BY username
  1163. [INFO] 2013/05/21 10:27:40 [Line: 606 -0.00200300s 239.0007%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND full_name LIKE ? AND hidden = ? AND valid = ? ) ) ORDER BY full_name
  1164. [INFO] 2013/05/21 10:27:40 [Line: 438 -0.00196900s 191.0310%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name LIKE ? ) ) ORDER BY name
  1165. [INFO] 2013/05/21 10:27:40 [Line: 581 -0.00185200s 119.3178%]    SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, copyright_policy_id, data_json FROM copyright_holder WHERE ( name RLIKE ? ) ORDER BY name
  1166. [INFO] 2013/05/21 10:27:40 [Line: 597 -0.00177100s 252.0172%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_1 RLIKE ? AND deleted = ? ) ) ORDER BY code_alias_1
  1167. [INFO] 2013/05/21 10:27:40 [Line: 601 -0.00165400s 216.3969%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name_alias_1 RLIKE ? ) ) ORDER BY name_alias_1
  1168. [INFO] 2013/05/21 10:27:40 [Line: 603 -0.00163400s 227.9561%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name_alias_2 RLIKE ? ) ) ORDER BY name_alias_2
  1169. [INFO] 2013/05/21 10:27:40 [Line: 595 -0.00158200s 158.0125%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name RLIKE ? ) ) ORDER BY name
  1170. [INFO] 2013/05/21 10:27:40 [Line: 600 -0.00156200s 248.0569%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name_alias_1 LIKE ? ) ) ORDER BY name_alias_1
  1171. [INFO] 2013/05/21 10:27:40 [Line: 439 -0.00155200s 233.1046%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code LIKE ? AND deleted = ? ) ) ORDER BY code
  1172. [INFO] 2013/05/21 10:27:40 [Line: 594 -0.00153600s 194.1754%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code RLIKE ? AND deleted = ? ) ) ORDER BY code
  1173. [INFO] 2013/05/21 10:27:40 [Line: 596 -0.00150900s 258.3421%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_1 LIKE ? AND deleted = ? ) ) ORDER BY code_alias_1
  1174. [INFO] 2013/05/21 10:27:40 [Line: 592 -0.00149000s 231.2775%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name LIKE ? ) ) ORDER BY name
  1175. [INFO] 2013/05/21 10:27:40 [Line: 602 -0.00148500s 241.6985%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name_alias_2 LIKE ? ) ) ORDER BY name_alias_2
  1176. [INFO] 2013/05/21 10:27:40 [Line: 598 -0.00146600s 256.4568%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_2 LIKE ? AND deleted = ? ) ) ORDER BY code_alias_2
  1177. [INFO] 2013/05/21 10:27:40 [Line: 599 -0.00142500s 217.1875%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code_alias_2 RLIKE ? AND deleted = ? ) ) ORDER BY code_alias_2
  1178. [INFO] 2013/05/21 10:27:40 [Line: 660 -0.00138500s 195.8478%]    SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM photographer WHERE ( name RLIKE ? ) ORDER BY name
  1179. [INFO] 2013/05/21 10:27:40 [Line: 675 -0.00091200s 137.4384%]    SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( alive = ? AND full_name LIKE ? AND hidden = ? AND valid = ? ) ) ORDER BY full_name
  1180. [INFO] 2013/05/21 10:27:40 [Line: 591 -0.00065100s 127.1816%]    SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM photographer WHERE ( name RLIKE ? ) ORDER BY name
  1181. [INFO] 2013/05/21 10:27:40 [Line: 443 -0.00044600s 236.8098%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code LIKE ? AND deleted = ? ) ) ORDER BY code
  1182. [INFO] 2013/05/21 10:27:40 [Line: 645 -0.00042500s 269.3227%]    SELECT id, code, storage_name, name, description, filename_rule, alive, projects_category, public_image_count, private_image_count, unapproved_image_count, dead_image_count, display_order, default_rank, default_access_level, filename_regex, filename_regex_text, photographer_regex, photographer_regex_text, copyright_holder_regex, copyright_holder_regex_text, caption_regex, caption_regex_text, description_regex, description_regex_text, public_filesize_count, private_filesize_count, unapproved_filesize_count, dead_filesize_count, data_json FROM category WHERE ( ( alive = ? AND name LIKE ? ) ) ORDER BY name
  1183. [INFO] 2013/05/21 10:27:40 [Line: 100 -0.00041700s 205.3030%]    SELECT id, code, storage_name, name, description, filename_rule, alive, projects_category, public_image_count, private_image_count, unapproved_image_count, dead_image_count, display_order, default_rank, default_access_level, filename_regex, filename_regex_text, photographer_regex, photographer_regex_text, copyright_holder_regex, copyright_holder_regex_text, caption_regex, caption_regex_text, description_regex, description_regex_text, public_filesize_count, private_filesize_count, unapproved_filesize_count, dead_filesize_count, data_json FROM category ORDER BY display_order
  1184. [INFO] 2013/05/21 10:27:40 [Line: 547 -0.00038900s 163.8752%]    SELECT project.* FROM project JOIN project_keyword2project ON project.id = project_keyword2project.project_id JOIN project_keyword ON project_keyword.id = project_keyword2project.project_keyword_id WHERE ( ( project.alive = ? AND project_keyword.name LIKE ? ) ) GROUP BY project.id ORDER BY code
  1185. [INFO] 2013/05/21 10:27:40 [Line: 403 -0.00032400s 196.4286%]    SELECT id, alive, locked, hidden, debug, code, name, description, notes, data_options_json, user_options_json, content, display_order, script_type_id, script_language_id, script_module_id, data_json FROM script WHERE ( alive = ? ) ORDER BY display_order
  1186. [INFO] 2013/05/21 10:27:40 [Line: 13 -0.00032400s 244.6429%]     SELECT id, alive, locked, hidden, debug, code, name, description, notes, data_options_json, user_options_json, content, display_order, script_type_id, script_language_id, script_module_id, data_json FROM script ORDER BY display_order
  1187. [INFO] 2013/05/21 10:27:40 [Line: 576 -0.00031100s 186.8715%]    SELECT id, code, storage_name, name, description, filename_rule, alive, projects_category, public_image_count, private_image_count, unapproved_image_count, dead_image_count, display_order, default_rank, default_access_level, filename_regex, filename_regex_text, photographer_regex, photographer_regex_text, copyright_holder_regex, copyright_holder_regex_text, caption_regex, caption_regex_text, description_regex, description_regex_text, public_filesize_count, private_filesize_count, unapproved_filesize_count, dead_filesize_count, data_json FROM category WHERE ( ( alive = ? AND name LIKE ? ) ) ORDER BY name
  1188. [INFO] 2013/05/21 10:27:40 [Line: 585 -0.00029000s 216.9355%]    SELECT id, suffix, description, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, supported, uploadable, convertible, can_contain_audio, can_contain_video, data_json FROM file_format WHERE ( suffix RLIKE ? ) ORDER BY suffix
  1189. [INFO] 2013/05/21 10:27:40 [Line: 442 -0.00028700s 113.1290%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND deleted = ? AND name LIKE ? ) ) ORDER BY name
  1190. [INFO] 2013/05/21 10:27:40 [Line: 653 -0.00027800s 214.8760%]    SELECT id, suffix, description, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, supported, uploadable, convertible, can_contain_audio, can_contain_video, data_json FROM file_format WHERE ( suffix LIKE ? ) ORDER BY suffix
  1191. [INFO] 2013/05/21 10:27:40 [Line: 577 -0.00026800s 165.0485%]    SELECT id, code, storage_name, name, description, filename_rule, alive, projects_category, public_image_count, private_image_count, unapproved_image_count, dead_image_count, display_order, default_rank, default_access_level, filename_regex, filename_regex_text, photographer_regex, photographer_regex_text, copyright_holder_regex, copyright_holder_regex_text, caption_regex, caption_regex_text, description_regex, description_regex_text, public_filesize_count, private_filesize_count, unapproved_filesize_count, dead_filesize_count, data_json FROM category WHERE ( ( alive = ? AND name RLIKE ? ) ) ORDER BY name
  1192. [INFO] 2013/05/21 10:27:40 [Line: 654 -0.00025900s 195.2206%]    SELECT id, suffix, description, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, supported, uploadable, convertible, can_contain_audio, can_contain_video, data_json FROM file_format WHERE ( suffix RLIKE ? ) ORDER BY suffix
  1193. [INFO] 2013/05/21 10:27:40 [Line: 1 -0.00025900s 129.0359%]      SELECT id, code, setting_type, is_scalar, value_json FROM global_setting ORDER BY code
  1194. [INFO] 2013/05/21 10:27:40 [Line: 10 -0.00025100s 223.6453%]     SELECT id, code, name, description, display_order, data_json FROM field_type ORDER BY display_order
  1195. [INFO] 2013/05/21 10:27:40 [Line: 646 -0.00025000s 174.8503%]    SELECT id, code, storage_name, name, description, filename_rule, alive, projects_category, public_image_count, private_image_count, unapproved_image_count, dead_image_count, display_order, default_rank, default_access_level, filename_regex, filename_regex_text, photographer_regex, photographer_regex_text, copyright_holder_regex, copyright_holder_regex_text, caption_regex, caption_regex_text, description_regex, description_regex_text, public_filesize_count, private_filesize_count, unapproved_filesize_count, dead_filesize_count, data_json FROM category WHERE ( ( alive = ? AND name RLIKE ? ) ) ORDER BY name
  1196. [INFO] 2013/05/21 10:27:40 [Line: 659 -0.00024800s 211.7117%]    SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM photographer WHERE ( name LIKE ? ) ORDER BY name
  1197. [INFO] 2013/05/21 10:27:40 [Line: 649 -0.00023400s 191.0506%]    SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, copyright_policy_id, data_json FROM copyright_holder WHERE ( name LIKE ? ) ORDER BY name
  1198. [INFO] 2013/05/21 10:27:40 [Line: 4 -0.00023100s 165.6250%]      SELECT id, address_1, address_2, port_1, port_2, domain_path, user_path, password, username_field, full_name_field, email_field, user_code_field, alive, display_order, use_ssl, data_json FROM ldap_domain ORDER BY display_order, domain_path
  1199. [INFO] 2013/05/21 10:27:40 [Line: 647 -0.00022900s 208.5308%]    SELECT id, code, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM colourspace WHERE ( code LIKE ? ) ORDER BY code
  1200. [INFO] 2013/05/21 10:27:40 [Line: 648 -0.00020700s 189.6104%]    SELECT id, code, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM colourspace WHERE ( code RLIKE ? ) ORDER BY code
  1201. [INFO] 2013/05/21 10:27:40 [Line: 658 -0.00020500s 152.6992%]    SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword WHERE ( name RLIKE ? ) ORDER BY name
  1202. [INFO] 2013/05/21 10:27:40 [Line: 673 -0.00020300s 130.0296%]    SELECT id, keywords_match, corrected, first_seen_time, last_seen_time, word_count, search_count, users_count, results_count, score, parent_search_term_id, alive, protected, deleted, data_json FROM search_term WHERE ( ( keywords_match LIKE ? AND users_count >= ? ) ) ORDER BY search_count DESC, keywords_match
  1203. [INFO] 2013/05/21 10:27:40 [Line: 26 -0.00017100s 153.1056%]     SELECT id, maximum_run_count, current_run_count, first_run, latest_run, final_run, alive, code, name, description, display_order, data_json FROM upgrade_task ORDER BY display_order
  1204. [INFO] 2013/05/21 10:27:40 [Line: 587 -0.00016900s 104.9199%]    SELECT id, keyword_category_id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM keyword WHERE ( ( keyword_category_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name RLIKE ? ) ) ORDER BY name
  1205. [INFO] 2013/05/21 10:27:40 [Line: 204 -0.00015900s 139.3564%]    SELECT id, name, display_order, hide_on_advanced_search, code, protected, locked, data_json FROM project_keyword_category ORDER BY display_order
  1206. [INFO] 2013/05/21 10:27:40 [Line: 579 -0.00015500s 186.5922%]    SELECT id, code, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM colourspace WHERE ( code RLIKE ? ) ORDER BY code
  1207. [INFO] 2013/05/21 10:27:40 [Line: 6 -0.00014500s 141.9075%]      SELECT id, name, local_path, remote_path, username, password, use_authentication, primary_store, instant_replication, replication_day, replication_time, data_json, alive, display_order FROM image_store ORDER BY primary_store DESC, display_order, name
  1208. [INFO] 2013/05/21 10:27:40 [Line: 14 -0.00014100s 144.6203%]     SELECT id, code, name, description, display_order, data_json FROM topic_type ORDER BY display_order
  1209. [INFO] 2013/05/21 10:27:40 [Line: 189 -0.00014000s 133.6538%]            SELECT field.id                 AS id,
  1210.                field.code               AS code,
  1211.                field.name               AS name,
  1212.                field_type.code          AS typeCode,
  1213.                field_display_type.code  AS displayTypeCode,
  1214.                is_lookup                AS isLookup
  1215.         FROM field
  1216.             JOIN field_display_type
  1217.                 ON field_display_type_id = field_display_type.id
  1218.             JOIN field_data_type
  1219.                 ON field_data_type_id = field_data_type.id
  1220.             JOIN field_type ON field_type_id = field_type.id
  1221.         WHERE is_lookup = 0
  1222.             AND alive = 1
  1223.            
  1224.             AND field_data_type.code = 'string'
  1225.            
  1226.            
  1227.         ORDER BY field.display_order
  1228. [INFO] 2013/05/21 10:27:40 [Line: 588 -0.00014000s 134.7395%]    SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword WHERE ( name LIKE ? ) ORDER BY name
  1229. [INFO] 2013/05/21 10:27:40 [Line: 9 -0.00013900s 135.6410%]      SELECT id, code, name, description, display_order, alive, protected, data_json FROM image_size_access_type ORDER BY display_order
  1230. [INFO] 2013/05/21 10:27:40 [Line: 657 -0.00013100s 134.2037%]    SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword WHERE ( name LIKE ? ) ORDER BY name
  1231. [INFO] 2013/05/21 10:27:40 [Line: 15 -0.00012800s 140.0000%]     SELECT id, code, name, description, display_order, alive, protected, data_json FROM note_type ORDER BY display_order
  1232. [INFO] 2013/05/21 10:27:40 [Line: 12 -0.00012600s 133.1579%]     SELECT id, field_data_type_id, is_lookup, fixed_options, code, name, description, display_order, data_json FROM field_display_type ORDER BY display_order
  1233. [INFO] 2013/05/21 10:27:40 [Line: 583 -0.00011400s 176.0000%]    SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( ( field_id = ? AND string_value RLIKE ? ) ) ORDER BY string_value
  1234. [INFO] 2013/05/21 10:27:40 [Line: 11 -0.00009200s 125.2055%]     SELECT id, code, name, description, display_order, data_json FROM field_data_type ORDER BY display_order
  1235. [INFO] 2013/05/21 10:27:40 [Line: 185 -0.00006100s 126.4069%]    SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( field_id = ? ) ORDER BY string_value
  1236. [INFO] 2013/05/21 10:27:40 [Line: 584 -0.00006100s 114.2523%]    SELECT id, suffix, description, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, supported, uploadable, convertible, can_contain_audio, can_contain_video, data_json FROM file_format WHERE ( suffix LIKE ? ) ORDER BY suffix
  1237. [INFO] 2013/05/21 10:27:40 [Line: 529 -0.00005700s 123.9496%]    SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword WHERE ( ( id NOT IN ( ? ) AND name LIKE ? ) ) ORDER BY name
  1238. [INFO] 2013/05/21 10:27:40 [Line: 593 -0.00005100s 117.2881%]    SELECT id, storage_name, code, code_alias_1, code_alias_2, name, name_alias_1, name_alias_2, alive, public_image_count, private_image_count, unapproved_image_count, dead_image_count, approved, started, is_current, completed, archived, deleted, latest_upload, data_json FROM project WHERE ( ( alive = ? AND code LIKE ? AND deleted = ? ) ) ORDER BY code
  1239. [INFO] 2013/05/21 10:27:40 [Line: 589 -0.00004500s 112.2951%]    SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword WHERE ( name RLIKE ? ) ORDER BY name
  1240. [INFO] 2013/05/21 10:27:40 [Line: 5 -0.00004100s 107.7358%]      SELECT id, ldap_domain_id, container_path, container_filter, sub_containers, use_ntlm, alive, display_order, data_json FROM ldap_container WHERE ( ldap_domain_id = ? ) ORDER BY display_order, container_path
  1241. [INFO] 2013/05/21 10:27:40 [Line: 187 -0.00001600s 107.4074%]    SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( field_id = ? ) ORDER BY string_value
  1242. [INFO] 2013/05/21 10:27:40 [Line: 160 -0.00001200s 103.7618%]    SELECT id, code, display_order, thumbnail_info, document_info, search_reorder, album_reorder FROM display_field WHERE ( ( album_reorder = ? OR search_reorder = ? ) ) ORDER BY display_order
  1243. [INFO] 2013/05/21 10:27:40 [Line: 652 -0.00000600s 102.4793%]    SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( ( field_id = ? AND string_value RLIKE ? ) ) ORDER BY string_value
  1244. [INFO] 2013/05/21 10:27:40 [Line: 3 -0.00000400s 101.3333%]      SELECT id, name, description, css_filename, font, font_size, logo_filename, logo_width, logo_height, use_logo, logo_offset_top, logo_offset_left, control_panel_offset_top FROM theme ORDER BY name
  1245. [INFO] 2013/05/21 10:27:40 <<<<<<<<<<<<<<<<<<<<< QUICKER QUERIES >>>>>>>>>>>>>>>>>>>>>
  1246. [INFO] 2013/05/21 10:27:40 [Line: 232 1.93716800s 32.5383%]      SELECT image.id FROM image LEFT JOIN project ON image.project_id = project.id WHERE ((image.filename LIKE '%Bridge%' OR image.original_filename LIKE '%Bridge%' OR image.caption LIKE '%Bridge%' OR image.description LIKE '%Bridge%' OR project.code LIKE '%Bridge%' OR project.code_alias_1 LIKE '%Bridge%' OR project.code_alias_2 LIKE '%Bridge%' OR project.name LIKE '%Bridge%' OR project.name_alias_1 LIKE '%Bridge%' OR project.name_alias_2 LIKE '%Bridge%' OR image.project_id IN (1734,800,1736,1255,359,536,665,666,1413,1766,1767,531,143,69,882,166,363,1640,328,1892) OR image.id IN (148501,148502,148503,148504,149004,149011,149012,149013,149014,149015,149016,149017,149039,149468,150743,150969,151542,151543,5813,152155,40592,40793,40794,40795,40796,40797,40798,40799,40800,40801,95656,96831,120815,120816,120817,120818,120819,120820,120821,148955,148956,148957,150411,7703,7728,7730,7845,8560,8563,9003,9022,9331,9332,9333,9335,9393,9394,9396,9401,9407,9408,9411,9418,9494,9495,9497,9501,9502,10790,10794,10836,10930,12018,12019,12020,12021,12078,13129,13902,13905,13909,13974,13976,13992,13993,14013,17006,18840,18841,18846,18849,18850,18851,18853,18855,21160,21162,31725,43890,44406,50120,50122,50132,50158,50159,54711,62694,80137,80138,80139,80140,80144,80145,80149,80150,80151,80157,81192,81193,81194,81197,81201,82483,82484,82485,93739,93741,119112,119121,125265,125272,125274,125281,125283,125284,125287,134111,137360,137362,139145,139154,140257,153193,153197,153215,153248,153250,153607,153619,156554,156765,163945,163952,163968,163987,8392,10963,29308,56849,64025,65531,65536,80463,92545,92546,140272,156914,153220,132652,132656,141579,141584,206222,206223,206238,206286,206287,206288,206619,206621,206622,206626,203323,8231,8252,10970,12255,13932,14087,50487,128917,22152,22154,47738,224163,224164,206607,214192,224815,224816,228040,230904,126392,231236,231239,231243,231250,232516,232517,235252,235256,235320,235329,203076,240137,241982,241983,241984,242000,8158,114093,177756,177733,177796,258857,258855,258847,265502,280024,280025,280026,280027,280036,280041,280042,280049,280063,282105,288558,14028,14029,19887,42509,90742,206617,278058,287864,303123,303139,303141,304348,304456,304457,304458,304459,304460,304462,304485,304513,304514,307617,307643,308564,308605,308624,308639,308650,308555,310685,310686,310687,310689,310690,310691,310702,310703,310704,310705,310706,310707,310708,310709,310710,310732,310735,310736,310655,312620,312521,312566,312575,317025,317051,318216,114052,114055,114060,114061,114183,114254,114260,277895,318862,318863,318864,318865,318866,318867,318868,318869,318870,318871,318872,318873,318878,318879,318880,318881,318882,318883,318884,318885,313378,319648,319652,319656,319666,319669,319672,224396,322982,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,328602,328652,328629,328639,328721,343320,343305,343321,343307,345000,345157,345004,345058,345063,344986,344994,325777,325786,347077,347087,347096,347186,347187,347149,347153,349472,349471,349435,350005,350049,203571,203235,356987,6523,6524,11468,14085,19319,29200,43274,47808,88520,91725,134095,134139,134148,134170,139014,142723,143468,143526,143771,153621,156171,156314,156697,156901,156903,168680,206272,206290,207056,207107,221756,221780,221781,230927,230979,241971,258800,258805,258807,297911,297917,318159,318160,318217,43266,49909,49912,134176,139193,301569,301576,56132,278064,298034,91733,91734,221782,297863,107973,131305,131314,285906,319159,344205,7334,11360,13092,19816,20241,82618,82619,82623,91705,91715,91720,91722,97724,107894,129732,156303,156779,156781,156784,156785,156931,156932,156933,158573,204325,204648,214800,229133,257917,278082,278687,285965,285968,319158,321892,329188,329193,329203,329204,339947,339949,339950,340462,340463,340467,366395))) AND image.alive = 1 AND ((image.category_id=1 AND image.access_level IN (1,2)) OR (image.category_id=2 AND image.access_level IN (1,2))) AND (project.alive IS NULL OR project.deleted = 0) AND (project.alive IS NULL OR project.alive = 1) ORDER BY image.access_level,image.click_count DESC,image.id
  1247. [INFO] 2013/05/21 10:27:40 [Line: 173 1.92361500s 31.3976%]      SELECT image.id FROM image LEFT JOIN project ON image.project_id = project.id WHERE ((image.filename LIKE '%order%' OR image.original_filename LIKE '%order%' OR image.caption LIKE '%order%' OR image.description LIKE '%order%' OR project.code LIKE '%order%' OR project.code_alias_1 LIKE '%order%' OR project.code_alias_2 LIKE '%order%' OR project.name LIKE '%order%' OR project.name_alias_1 LIKE '%order%' OR project.name_alias_2 LIKE '%order%')) AND image.alive = 1 AND ((image.category_id=1 AND image.access_level IN (1,2)) OR (image.category_id=2 AND image.access_level IN (1,2))) AND (project.alive IS NULL OR project.deleted = 0) AND (project.alive IS NULL OR project.alive = 1) ORDER BY image.access_level,image.click_count DESC,image.id
  1248. [INFO] 2013/05/21 10:27:40 [Line: 233 0.01422500s 33.0683%]      SELECT image.id,image.filename,image.category_id,image.project_id,image.album_count,image.access_level,image.md5_at_upload,image.md5_now,image.rotation_since_upload,image.rotate_degrees,image.contains_audio,image.contains_video,image.access_level AS displayField_accessLevel,image.original_filesize AS displayField_fileSize,image.filename AS displayField_filename,photographer.name AS displayField_photographer,square_created,square_recreate,square_width,square_height,square_filesize,square_file_format_id,square_colourspace_id,thumbnail_created,thumbnail_recreate,thumbnail_width,thumbnail_height,thumbnail_filesize,thumbnail_file_format_id,thumbnail_colourspace_id,small_created,small_recreate,small_width,small_height,small_filesize,small_file_format_id,small_colourspace_id,webview_created,webview_recreate,webview_width,webview_height,webview_filesize,webview_file_format_id,webview_colourspace_id,image.created,original_recreate,original_width,original_height,original_filesize,original_file_format_id,original_colourspace_id FROM image LEFT JOIN project ON image.project_id = project.id LEFT JOIN photographer ON image.photographer_id = photographer.id WHERE ((image.filename LIKE '%Bridge%' OR image.original_filename LIKE '%Bridge%' OR image.caption LIKE '%Bridge%' OR image.description LIKE '%Bridge%' OR project.code LIKE '%Bridge%' OR project.code_alias_1 LIKE '%Bridge%' OR project.code_alias_2 LIKE '%Bridge%' OR project.name LIKE '%Bridge%' OR project.name_alias_1 LIKE '%Bridge%' OR project.name_alias_2 LIKE '%Bridge%' OR image.project_id IN (1734,800,1736,1255,359,536,665,666,1413,1766,1767,531,143,69,882,166,363,1640,328,1892) OR image.id IN (148501,148502,148503,148504,149004,149011,149012,149013,149014,149015,149016,149017,149039,149468,150743,150969,151542,151543,5813,152155,40592,40793,40794,40795,40796,40797,40798,40799,40800,40801,95656,96831,120815,120816,120817,120818,120819,120820,120821,148955,148956,148957,150411,7703,7728,7730,7845,8560,8563,9003,9022,9331,9332,9333,9335,9393,9394,9396,9401,9407,9408,9411,9418,9494,9495,9497,9501,9502,10790,10794,10836,10930,12018,12019,12020,12021,12078,13129,13902,13905,13909,13974,13976,13992,13993,14013,17006,18840,18841,18846,18849,18850,18851,18853,18855,21160,21162,31725,43890,44406,50120,50122,50132,50158,50159,54711,62694,80137,80138,80139,80140,80144,80145,80149,80150,80151,80157,81192,81193,81194,81197,81201,82483,82484,82485,93739,93741,119112,119121,125265,125272,125274,125281,125283,125284,125287,134111,137360,137362,139145,139154,140257,153193,153197,153215,153248,153250,153607,153619,156554,156765,163945,163952,163968,163987,8392,10963,29308,56849,64025,65531,65536,80463,92545,92546,140272,156914,153220,132652,132656,141579,141584,206222,206223,206238,206286,206287,206288,206619,206621,206622,206626,203323,8231,8252,10970,12255,13932,14087,50487,128917,22152,22154,47738,224163,224164,206607,214192,224815,224816,228040,230904,126392,231236,231239,231243,231250,232516,232517,235252,235256,235320,235329,203076,240137,241982,241983,241984,242000,8158,114093,177756,177733,177796,258857,258855,258847,265502,280024,280025,280026,280027,280036,280041,280042,280049,280063,282105,288558,14028,14029,19887,42509,90742,206617,278058,287864,303123,303139,303141,304348,304456,304457,304458,304459,304460,304462,304485,304513,304514,307617,307643,308564,308605,308624,308639,308650,308555,310685,310686,310687,310689,310690,310691,310702,310703,310704,310705,310706,310707,310708,310709,310710,310732,310735,310736,310655,312620,312521,312566,312575,317025,317051,318216,114052,114055,114060,114061,114183,114254,114260,277895,318862,318863,318864,318865,318866,318867,318868,318869,318870,318871,318872,318873,318878,318879,318880,318881,318882,318883,318884,318885,313378,319648,319652,319656,319666,319669,319672,224396,322982,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,328602,328652,328629,328639,328721,343320,343305,343321,343307,345000,345157,345004,345058,345063,344986,344994,325777,325786,347077,347087,347096,347186,347187,347149,347153,349472,349471,349435,350005,350049,203571,203235,356987,6523,6524,11468,14085,19319,29200,43274,47808,88520,91725,134095,134139,134148,134170,139014,142723,143468,143526,143771,153621,156171,156314,156697,156901,156903,168680,206272,206290,207056,207107,221756,221780,221781,230927,230979,241971,258800,258805,258807,297911,297917,318159,318160,318217,43266,49909,49912,134176,139193,301569,301576,56132,278064,298034,91733,91734,221782,297863,107973,131305,131314,285906,319159,344205,7334,11360,13092,19816,20241,82618,82619,82623,91705,91715,91720,91722,97724,107894,129732,156303,156779,156781,156784,156785,156931,156932,156933,158573,204325,204648,214800,229133,257917,278082,278687,285965,285968,319158,321892,329188,329193,329203,329204,339947,339949,339950,340462,340463,340467,366395))) AND image.alive = 1 AND ((image.category_id=1 AND image.access_level IN (1,2)) OR (image.category_id=2 AND image.access_level IN (1,2))) AND (project.alive IS NULL OR project.deleted = 0) AND (project.alive IS NULL OR project.alive = 1) AND image.id IN (377290,345712,318217,158573,48400,345153,156779,156934,107796,48875,379125,377249,49903,147010,156903,128917,156935,72082,156554,60777,80280,140269,156741,287864,137362,318216,49912,62058,137360,48404,156781,156798,48402,48403,156590,349436,11079,49897,309708,9494,81895,345157,349499,156845,278082,6648,384576,43274,139154,156595,203798,80251,156697,156782,168812,414026,8158,48389,107800,339272,50702,80256,349467,358558,80295,141579,156785,140270,156786,349505,8231,15347,20240,49914,20241,49909,82619,119410,347203,350049,22146,22149,70845,80301,136159,156314,163952,220158,304460,8573,49899,82618,141584,168872,261289,156783,206222,49874,285952,319536,8646,82637,107798,156931,347186,11360,25929,119437,129078,277945,9022,19988,27224,156932,277941,18853,49916,156784,156901,49894,49902,156591,226794,12024,21162,22151,22154,80246,80300,119435,140268,143771,156806,229225,304458,349443,7730,8650,22147,50544,82623,136155,156592,224396,242000,417112,7848,20233,20236,49901,81410,82638,89854,99373,136156,153180,206238,280621,7849,27231,79284,82633,140273,156303,177756,217039,8651,8653,9497,46851,49913,82624,88566,156297,285965,349435,7847,27232,81896,136158,163945,387838,417111,6524,6647,8662,8663,22144,46852,50608,156588,156594,8644,18852,20235,43245,136157,140278,156301,168669,177796,285968,8652,20234,22152,82621,128399,139145,156299,163968,253813,339305,355021,17006,20247,72087,7851,70080,72104,80138,168814,168815,285955,285956,7841,13092,21159,79286,82616,82620,226280,285959,304372,310909,6523,27223,49873,50636,80149,82622,200220,261291,289536,303824,304485,50637,57198,156914,200221,288907) ORDER BY image.access_level,image.click_count DESC,image.id
  1249. [INFO] 2013/05/21 10:27:40 [Line: 174 0.00749200s 24.9975%]      SELECT image.id,image.filename,image.category_id,image.project_id,image.album_count,image.access_level,image.md5_at_upload,image.md5_now,image.rotation_since_upload,image.rotate_degrees,image.contains_audio,image.contains_video,image.access_level AS displayField_accessLevel,image.original_filesize AS displayField_fileSize,image.filename AS displayField_filename,photographer.name AS displayField_photographer,square_created,square_recreate,square_width,square_height,square_filesize,square_file_format_id,square_colourspace_id,thumbnail_created,thumbnail_recreate,thumbnail_width,thumbnail_height,thumbnail_filesize,thumbnail_file_format_id,thumbnail_colourspace_id,small_created,small_recreate,small_width,small_height,small_filesize,small_file_format_id,small_colourspace_id,webview_created,webview_recreate,webview_width,webview_height,webview_filesize,webview_file_format_id,webview_colourspace_id,image.created,original_recreate,original_width,original_height,original_filesize,original_file_format_id,original_colourspace_id FROM image LEFT JOIN project ON image.project_id = project.id LEFT JOIN photographer ON image.photographer_id = photographer.id WHERE ((image.filename LIKE '%order%' OR image.original_filename LIKE '%order%' OR image.caption LIKE '%order%' OR image.description LIKE '%order%' OR project.code LIKE '%order%' OR project.code_alias_1 LIKE '%order%' OR project.code_alias_2 LIKE '%order%' OR project.name LIKE '%order%' OR project.name_alias_1 LIKE '%order%' OR project.name_alias_2 LIKE '%order%')) AND image.alive = 1 AND ((image.category_id=1 AND image.access_level IN (1,2)) OR (image.category_id=2 AND image.access_level IN (1,2))) AND (project.alive IS NULL OR project.deleted = 0) AND (project.alive IS NULL OR project.alive = 1) AND image.id IN (377290,268169,119554,268156,268180,268158,268191,268197,268194,268213,199330,290921,309882,289188,289453,289889,290922,290972,291186,291554,293615,293959,309681,309682,309731,309736,309742,309810,309885,309901,320050,93551,399908,12751,399905,6781,97779,142729,225935,268160,399906,399907,92453,199331,203679,212196,254201,268168,268181,322327,268131,324220,138535,203084,213341,226487,268129,268164,268190,323635,134057,211913,216890,230904,268162,268167,268187,268188,268196,268198,268199,268200,277902,320004,322034,328722,1094,1466,3780,29187,29188,29198,29199,29582,29736,88507,101914,121876,137260,138532,146356,146357,146358,151112,151113,151114,166792,203196,203677,208603,213138,213347,215730,216372,216424,226256,226257,226258,240893,243630,255188,255723,268157,268159,268161,268163,268166,268182,268189,268192,268193,268195,268212,299929,312242,312297,312317,312475,320689,320690,320691,320692,320693,320694,320695,320696,320697,320698,320699,320700,320701,321655,322737,323066,323293,323297,323499,323519,323565,326477) ORDER BY image.access_level,image.click_count DESC,image.id
  1250. [INFO] 2013/05/21 10:27:40 [Line: 574 0.00347000s 69.4462%]      SELECT album.*
  1251. FROM album
  1252.     LEFT JOIN carousel ON album.id = carousel.default_album_id
  1253.      LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id
  1254. WHERE (album.oa_user_id = 3 OR (group2album.oa_group_id IN ('3') ) OR (user2album.oa_user_id = 3 ) OR ( album.share_with_all_users = 1 ))
  1255.     AND carousel.id IS NULL
  1256.     AND album.name LIKE 'abc%'
  1257.  ORDER BY name LIMIT 15 OFFSET 0
  1258. [INFO] 2013/05/21 10:27:40 [Line: 586 0.00121000s 60.9425%]      SELECT id, keyword_category_id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM keyword WHERE ( ( keyword_category_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name LIKE ? ) ) ORDER BY name
  1259. [INFO] 2013/05/21 10:27:40 [Line: 629 0.00107100s 31.3021%]      SELECT image.id FROM image LEFT JOIN project ON image.project_id = project.id WHERE image.copyright_holder_id IN (2445) AND image.alive = 1 AND ((image.category_id=6) OR (image.category_id=4) OR (image.category_id=1) OR (image.category_id=3) OR (image.category_id=7) OR (image.category_id=2) OR (image.category_id=5)) AND (project.alive IS NULL OR project.deleted = 0) AND (project.alive IS NULL OR project.alive = 1) ORDER BY image.access_level,image.uploaded DESC,image.id
  1260. [INFO] 2013/05/21 10:27:40 [Line: 420 0.00057900s 30.9893%]      SELECT id, album_id, image_id, display_order FROM image2album WHERE ( album_id = ? ) ORDER BY display_order
  1261. [INFO] 2013/05/21 10:27:40 [Line: 161 0.00050400s 45.5724%]              SELECT field.id                 AS id,
  1262.                field.code               AS code,
  1263.                field.name               AS name,
  1264.                field_type.code          AS typeCode,
  1265.                field_display_type.code  AS displayTypeCode,
  1266.                is_lookup                AS isLookup
  1267.         FROM field
  1268.             JOIN field_display_type
  1269.                 ON field_display_type_id = field_display_type.id
  1270.             JOIN field_data_type
  1271.                 ON field_data_type_id = field_data_type.id
  1272.             JOIN field_type ON field_type_id = field_type.id
  1273.         WHERE is_lookup = 1
  1274.             AND alive = 1
  1275.            
  1276.            
  1277.            
  1278.            
  1279.         ORDER BY field.display_order
  1280. [INFO] 2013/05/21 10:27:40 [Line: 183 0.00049500s 53.4774%]              SELECT field.id                 AS id,
  1281.                field.code               AS code,
  1282.                field.name               AS name,
  1283.                field_type.code          AS typeCode,
  1284.                field_display_type.code  AS displayTypeCode,
  1285.                is_lookup                AS isLookup
  1286.         FROM field
  1287.             JOIN field_display_type
  1288.                 ON field_display_type_id = field_display_type.id
  1289.             JOIN field_data_type
  1290.                 ON field_data_type_id = field_data_type.id
  1291.             JOIN field_type ON field_type_id = field_type.id
  1292.         WHERE is_lookup = 1
  1293.             AND alive = 1
  1294.            
  1295.             AND field_data_type.code = 'string'
  1296.            
  1297.             AND field_display_type.code = 'option'
  1298.         ORDER BY field.display_order
  1299. [INFO] 2013/05/21 10:27:40 [Line: 171 0.00046700s 34.6853%]      SELECT id, album_id, image_id, display_order FROM image2album WHERE ( album_id = ? ) ORDER BY display_order
  1300. [INFO] 2013/05/21 10:27:40 [Line: 684 0.00038400s 51.0204%]      SELECT image.id FROM image LEFT JOIN project ON image.project_id = project.id WHERE image.project_id IN (1824) AND image.alive = 1 AND ((image.category_id=6) OR (image.category_id=4) OR (image.category_id=1) OR (image.category_id=3) OR (image.category_id=7) OR (image.category_id=2) OR (image.category_id=5)) AND (project.alive IS NULL OR project.deleted = 0) AND (project.alive IS NULL OR project.alive = 1) ORDER BY image.access_level,image.uploaded DESC,image.id
  1301. [INFO] 2013/05/21 10:27:40 [Line: 205 0.00037500s 77.4232%]      SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword ORDER BY name
  1302. [INFO] 2013/05/21 10:27:40 [Line: 610 0.00037200s 61.8070%]              SELECT field.id                 AS id,
  1303.                field.code               AS code,
  1304.                field.name               AS name,
  1305.                field_type.code          AS typeCode,
  1306.                field_display_type.code  AS displayTypeCode,
  1307.                is_lookup                AS isLookup
  1308.         FROM field
  1309.             JOIN field_display_type
  1310.                 ON field_display_type_id = field_display_type.id
  1311.             JOIN field_data_type
  1312.                 ON field_data_type_id = field_data_type.id
  1313.             JOIN field_type ON field_type_id = field_type.id
  1314.         WHERE is_lookup = 0
  1315.             AND alive = 1
  1316.              AND include_on_search = 1
  1317.             AND field_data_type.code = 'string'
  1318.            
  1319.            
  1320.         ORDER BY field.display_order
  1321. [INFO] 2013/05/21 10:27:40 [Line: 188 0.00023000s 63.7795%]              SELECT field.id                 AS id,
  1322.                field.code               AS code,
  1323.                field.name               AS name,
  1324.                field_type.code          AS typeCode,
  1325.                field_display_type.code  AS displayTypeCode,
  1326.                is_lookup                AS isLookup
  1327.         FROM field
  1328.             JOIN field_display_type
  1329.                 ON field_display_type_id = field_display_type.id
  1330.             JOIN field_data_type
  1331.                 ON field_data_type_id = field_data_type.id
  1332.             JOIN field_type ON field_type_id = field_type.id
  1333.         WHERE is_lookup = 0
  1334.             AND alive = 1
  1335.            
  1336.             AND field_data_type.code = 'date'
  1337.            
  1338.            
  1339.         ORDER BY field.display_order
  1340. [INFO] 2013/05/21 10:27:40 [Line: 401 0.00022400s 44.2786%]      SELECT distinct(general_permission_type.code) FROM general_permission LEFT JOIN general_permission_type ON general_permission_type.id=general_permission.general_permission_type_id WHERE general_permission.oa_group_id IN (3) ORDER BY general_permission_type.code
  1341. [INFO] 2013/05/21 10:27:40 [Line: 582 0.00015500s 62.1951%]      SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( ( field_id = ? AND string_value LIKE ? ) ) ORDER BY string_value
  1342. [INFO] 2013/05/21 10:27:40 [Line: 604 0.00014000s 69.1630%]      SELECT id, keywords_match, corrected, first_seen_time, last_seen_time, word_count, search_count, users_count, results_count, score, parent_search_term_id, alive, protected, deleted, data_json FROM search_term WHERE ( ( keywords_match LIKE ? AND users_count >= ? ) ) ORDER BY search_count DESC, keywords_match
  1343. [INFO] 2013/05/21 10:27:40 [Line: 580 0.00013400s 65.2850%]      SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, copyright_policy_id, data_json FROM copyright_holder WHERE ( name LIKE ? ) ORDER BY name
  1344. [INFO] 2013/05/21 10:27:40 [Line: 656 0.00012500s 94.4837%]      SELECT id, keyword_category_id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM keyword WHERE ( ( keyword_category_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name RLIKE ? ) ) ORDER BY name
  1345. [INFO] 2013/05/21 10:27:40 [Line: 557 0.00011500s 68.2320%]      SELECT id, rank_value, name, maximum_images FROM project_rank_option WHERE ( rank_value <= ? ) ORDER BY rank_value
  1346. [INFO] 2013/05/21 10:27:40 [Line: 402 0.00010400s 99.5173%]      SELECT id, username, password, full_name, email, code, expires, expiry_date, alive, protected, anonymous, super_user, hidden, valid, theme_id, locale_id, home_page_columns, images_per_page, images_per_row, larger_thumbnails, larger_thumbnails_is_set, order_by_field_1_id, order_by_field_2_id, order_by_field_3_id, display_field_1_id, display_field_2_id, display_field_3_id, display_field_4_id, data_json, use_ldap, use_ntlm, ldap_domain_id, ldap_dn, current_album_id, sticky_data_json FROM oa_user WHERE ( ( hidden = ? AND valid = ? ) ) ORDER BY protected DESC, username
  1347. [INFO] 2013/05/21 10:27:40 [Line: 528 0.00010200s 79.5591%]      SELECT id, project_keyword_category_id, name, project_count, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM project_keyword WHERE ( name LIKE ? ) ORDER BY name
  1348. [INFO] 2013/05/21 10:27:40 [Line: 25 0.00008100s 77.5000%]       SELECT id, text_match, text_replace, case_sensitive, preserve_first_letter_case, locale_id, display_order, alive FROM text_rewrite ORDER BY display_order
  1349. [INFO] 2013/05/21 10:27:40 [Line: 655 0.00005600s 97.1385%]      SELECT id, keyword_category_id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count FROM keyword WHERE ( ( keyword_category_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND name LIKE ? ) ) ORDER BY name
  1350. [INFO] 2013/05/21 10:27:40 [Line: 8 0.00005100s 88.8889%]        SELECT id, rank_value, name, maximum_images FROM project_rank_option ORDER BY rank_value
  1351. [INFO] 2013/05/21 10:27:40 [Line: 590 0.00004100s 88.4831%]      SELECT id, name, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM photographer WHERE ( name LIKE ? ) ORDER BY name
  1352. [INFO] 2013/05/21 10:27:40 [Line: 651 0.00003500s 88.1757%]      SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( ( field_id = ? AND string_value LIKE ? ) ) ORDER BY string_value
  1353. [INFO] 2013/05/21 10:27:40 [Line: 7 0.00002100s 94.9519%]        SELECT id, rank_value, name, maximum_images FROM rank_option ORDER BY rank_value
  1354. [INFO] 2013/05/21 10:27:40 [Line: 184 0.00001900s 92.1811%]      SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( field_id = ? ) ORDER BY string_value
  1355. [INFO] 2013/05/21 10:27:40 [Line: 578 0.00001200s 96.6102%]      SELECT id, code, writable, public_image_count, private_image_count, unapproved_image_count, dead_image_count, data_json FROM colourspace WHERE ( code LIKE ? ) ORDER BY code
  1356. [INFO] 2013/05/21 10:27:40 [Line: 101 0.00001000s 97.9757%]      SELECT distinct(general_permission_type.code) FROM general_permission LEFT JOIN general_permission_type ON general_permission_type.id=general_permission.general_permission_type_id WHERE general_permission.oa_group_id IN (2) ORDER BY general_permission_type.code
  1357. [INFO] 2013/05/21 10:27:40 [Line: 190 0.00000700s 98.3908%]              SELECT field.id                 AS id,
  1358.                field.code               AS code,
  1359.                field.name               AS name,
  1360.                field_type.code          AS typeCode,
  1361.                field_display_type.code  AS displayTypeCode,
  1362.                is_lookup                AS isLookup
  1363.         FROM field
  1364.             JOIN field_display_type
  1365.                 ON field_display_type_id = field_display_type.id
  1366.             JOIN field_data_type
  1367.                 ON field_data_type_id = field_data_type.id
  1368.             JOIN field_type ON field_type_id = field_type.id
  1369.         WHERE is_lookup = 1
  1370.             AND alive = 1
  1371.            
  1372.             AND field_data_type.code = 'string'
  1373.            
  1374.            
  1375.         ORDER BY field.display_order
  1376. [INFO] 2013/05/21 10:27:40 [Line: 186 0.00000300s 98.7500%]      SELECT id, string_value, field_id, display_order FROM field_lookup_string WHERE ( field_id = ? ) ORDER BY string_value
  1377. # Looks like you failed 106 tests of 556.
clone this paste RAW Paste Data