API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 21st, 2013
68
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 110.71 KB | None | 0 0
raw download clone embed print report
  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.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!