ok 1 - Original query executed without error ok 2 - New query executed without error ok 3 - Resulting rows are the same not ok 4 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000259' # > # '0' ok 5 - Original query executed without error ok 6 - New query executed without error ok 7 - Resulting rows are the same not ok 8 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-4.00000000000004e-06' # > # '0' ok 9 - Original query executed without error ok 10 - New query executed without error ok 11 - Resulting rows are the same not ok 12 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000231' # > # '0' ok 13 - Original query executed without error ok 14 - New query executed without error ok 15 - Resulting rows are the same not ok 16 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-4.1e-05' # > # '0' ok 17 - Original query executed without error ok 18 - New query executed without error ok 19 - Resulting rows are the same not ok 20 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000145' # > # '0' ok 21 - Original query executed without error ok 22 - New query executed without error ok 23 - Resulting rows are the same ok 24 - New query is quicker ok 25 - Original query executed without error ok 26 - New query executed without error ok 27 - Resulting rows are the same ok 28 - New query is quicker ok 29 - Original query executed without error ok 30 - New query executed without error ok 31 - Resulting rows are the same not ok 32 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000139' # > # '0' ok 33 - Original query executed without error ok 34 - New query executed without error ok 35 - Resulting rows are the same not ok 36 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000251' # > # '0' ok 37 - Original query executed without error ok 38 - New query executed without error ok 39 - Resulting rows are the same not ok 40 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-9.2e-05' # > # '0' ok 41 - Original query executed without error ok 42 - New query executed without error ok 43 - Resulting rows are the same not ok 44 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000126' # > # '0' ok 45 - Original query executed without error ok 46 - New query executed without error ok 47 - Resulting rows are the same not ok 48 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000324' # > # '0' ok 49 - Original query executed without error ok 50 - New query executed without error ok 51 - Resulting rows are the same not ok 52 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000141' # > # '0' ok 53 - Original query executed without error ok 54 - New query executed without error ok 55 - Resulting rows are the same not ok 56 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000128' # > # '0' ok 57 - Original query executed without error ok 58 - New query executed without error ok 59 - Resulting rows are the same ok 60 - New query is quicker ok 61 - Original query executed without error ok 62 - New query executed without error ok 63 - Resulting rows are the same not ok 64 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000171' # > # '0' ok 65 - Original query executed without error ok 66 - New query executed without error ok 67 - Resulting rows are the same not ok 68 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000417' # > # '0' ok 69 - Original query executed without error ok 70 - New query executed without error ok 71 - Resulting rows are the same ok 72 - New query is quicker ok 73 - Original query executed without error ok 74 - New query executed without error ok 75 - Resulting rows are the same not ok 76 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.0319479999999999' # > # '0' ok 77 - Original query executed without error ok 78 - New query executed without error ok 79 - Resulting rows are the same not ok 80 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-1.2e-05' # > # '0' ok 81 - Original query executed without error ok 82 - New query executed without error ok 83 - Resulting rows are the same ok 84 - New query is quicker ok 85 - Original query executed without error ok 86 - New query executed without error ok 87 - Resulting rows are the same ok 88 - New query is quicker ok 89 - Original query executed without error ok 90 - New query executed without error ok 91 - Resulting rows are the same ok 92 - New query is quicker ok 93 - Original query executed without error ok 94 - New query executed without error ok 95 - Resulting rows are the same ok 96 - New query is quicker ok 97 - Original query executed without error ok 98 - New query executed without error ok 99 - Resulting rows are the same ok 100 - New query is quicker ok 101 - Original query executed without error ok 102 - New query executed without error ok 103 - Resulting rows are the same ok 104 - New query is quicker ok 105 - Original query executed without error ok 106 - New query executed without error ok 107 - Resulting rows are the same not ok 108 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-6.1e-05' # > # '0' ok 109 - Original query executed without error ok 110 - New query executed without error ok 111 - Resulting rows are the same ok 112 - New query is quicker ok 113 - Original query executed without error ok 114 - New query executed without error ok 115 - Resulting rows are the same not ok 116 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-1.6e-05' # > # '0' ok 117 - Original query executed without error ok 118 - New query executed without error ok 119 - Resulting rows are the same ok 120 - New query is quicker ok 121 - Original query executed without error ok 122 - New query executed without error ok 123 - Resulting rows are the same not ok 124 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00014' # > # '0' ok 125 - Original query executed without error ok 126 - New query executed without error ok 127 - Resulting rows are the same ok 128 - New query is quicker ok 129 - Original query executed without error ok 130 - New query executed without error ok 131 - Resulting rows are the same not ok 132 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000159' # > # '0' ok 133 - Original query executed without error ok 134 - New query executed without error not ok 135 - Resulting rows are the same # Failed test 'Resulting rows are the same' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 83. # Structures begin differing at: # $got->[21][0] = '82' # $expected->[21][0] = '106' [ERROR] 2013/05/21 10:27:33 [Line: 205] HAS DIFFERING RESULTS [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 [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 ok 136 - New query is quicker ok 137 - Original query executed without error ok 138 - New query executed without error ok 139 - Resulting rows are the same ok 140 - New query is quicker ok 141 - Original query executed without error ok 142 - New query executed without error ok 143 - Resulting rows are the same ok 144 - New query is quicker ok 145 - Original query executed without error ok 146 - New query executed without error ok 147 - Resulting rows are the same not ok 148 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.004759' # > # '0' ok 149 - Original query executed without error ok 150 - New query executed without error ok 151 - Resulting rows are the same ok 152 - New query is quicker ok 153 - Original query executed without error ok 154 - New query executed without error ok 155 - Resulting rows are the same ok 156 - New query is quicker ok 157 - Original query executed without error ok 158 - New query executed without error ok 159 - Resulting rows are the same not ok 160 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000324' # > # '0' ok 161 - Original query executed without error ok 162 - New query executed without error ok 163 - Resulting rows are the same ok 164 - New query is quicker ok 165 - Original query executed without error ok 166 - New query executed without error ok 167 - Resulting rows are the same not ok 168 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.004198' # > # '0' ok 169 - Original query executed without error ok 170 - New query executed without error ok 171 - Resulting rows are the same not ok 172 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001969' # > # '0' ok 173 - Original query executed without error ok 174 - New query executed without error ok 175 - Resulting rows are the same not ok 176 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001552' # > # '0' ok 177 - Original query executed without error ok 178 - New query executed without error ok 179 - Resulting rows are the same not ok 180 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.004176' # > # '0' ok 181 - Original query executed without error ok 182 - New query executed without error ok 183 - Resulting rows are the same not ok 184 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000287' # > # '0' ok 185 - Original query executed without error ok 186 - New query executed without error ok 187 - Resulting rows are the same not ok 188 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000446' # > # '0' ok 189 - Original query executed without error ok 190 - New query executed without error ok 191 - Resulting rows are the same not ok 192 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003149' # > # '0' ok 193 - Original query executed without error ok 194 - New query executed without error ok 195 - Resulting rows are the same not ok 196 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003033' # > # '0' ok 197 - Original query executed without error ok 198 - New query executed without error ok 199 - Resulting rows are the same not ok 200 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.0032' # > # '0' ok 201 - Original query executed without error ok 202 - New query executed without error ok 203 - Resulting rows are the same not ok 204 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003202' # > # '0' ok 205 - Original query executed without error ok 206 - New query executed without error ok 207 - Resulting rows are the same not ok 208 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003079' # > # '0' ok 209 - Original query executed without error ok 210 - New query executed without error ok 211 - Resulting rows are the same not ok 212 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003152' # > # '0' ok 213 - Original query executed without error ok 214 - New query executed without error ok 215 - Resulting rows are the same not ok 216 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003249' # > # '0' ok 217 - Original query executed without error ok 218 - New query executed without error ok 219 - Resulting rows are the same not ok 220 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003007' # > # '0' ok 221 - Original query executed without error ok 222 - New query executed without error ok 223 - Resulting rows are the same not ok 224 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00318899999999998' # > # '0' ok 225 - Original query executed without error ok 226 - New query executed without error ok 227 - Resulting rows are the same not ok 228 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003179' # > # '0' ok 229 - Original query executed without error ok 230 - New query executed without error ok 231 - Resulting rows are the same not ok 232 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.002291' # > # '0' ok 233 - Original query executed without error ok 234 - New query executed without error ok 235 - Resulting rows are the same not ok 236 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.004371' # > # '0' ok 237 - Original query executed without error ok 238 - New query executed without error ok 239 - Resulting rows are the same not ok 240 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.012928' # > # '0' ok 241 - Original query executed without error ok 242 - New query executed without error ok 243 - Resulting rows are the same not ok 244 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.009323' # > # '0' ok 245 - Original query executed without error ok 246 - New query executed without error ok 247 - Resulting rows are the same ok 248 - New query is quicker ok 249 - Original query executed without error ok 250 - New query executed without error ok 251 - Resulting rows are the same not ok 252 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-5.7e-05' # > # '0' ok 253 - Original query executed without error ok 254 - New query executed without error ok 255 - Resulting rows are the same not ok 256 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.005197' # > # '0' ok 257 - Original query executed without error ok 258 - New query executed without error ok 259 - Resulting rows are the same not ok 260 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000389' # > # '0' ok 261 - Original query executed without error ok 262 - New query executed without error ok 263 - Resulting rows are the same ok 264 - New query is quicker ok 265 - Original query executed without error ok 266 - New query executed without error ok 267 - Resulting rows are the same ok 268 - New query is quicker ok 269 - Original query executed without error ok 270 - New query executed without error ok 271 - Resulting rows are the same not ok 272 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.005605' # > # '0' ok 273 - Original query executed without error ok 274 - New query executed without error ok 275 - Resulting rows are the same not ok 276 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000311' # > # '0' ok 277 - Original query executed without error ok 278 - New query executed without error ok 279 - Resulting rows are the same not ok 280 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000268' # > # '0' ok 281 - Original query executed without error ok 282 - New query executed without error ok 283 - Resulting rows are the same ok 284 - New query is quicker ok 285 - Original query executed without error ok 286 - New query executed without error ok 287 - Resulting rows are the same not ok 288 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000155' # > # '0' ok 289 - Original query executed without error ok 290 - New query executed without error ok 291 - Resulting rows are the same ok 292 - New query is quicker ok 293 - Original query executed without error ok 294 - New query executed without error ok 295 - Resulting rows are the same not ok 296 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001852' # > # '0' ok 297 - Original query executed without error ok 298 - New query executed without error ok 299 - Resulting rows are the same ok 300 - New query is quicker ok 301 - Original query executed without error ok 302 - New query executed without error ok 303 - Resulting rows are the same not ok 304 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000114' # > # '0' ok 305 - Original query executed without error ok 306 - New query executed without error ok 307 - Resulting rows are the same not ok 308 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-6.1e-05' # > # '0' ok 309 - Original query executed without error ok 310 - New query executed without error ok 311 - Resulting rows are the same not ok 312 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00029' # > # '0' ok 313 - Original query executed without error ok 314 - New query executed without error ok 315 - Resulting rows are the same ok 316 - New query is quicker ok 317 - Original query executed without error ok 318 - New query executed without error ok 319 - Resulting rows are the same not ok 320 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000169' # > # '0' ok 321 - Original query executed without error ok 322 - New query executed without error ok 323 - Resulting rows are the same not ok 324 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00014' # > # '0' ok 325 - Original query executed without error ok 326 - New query executed without error ok 327 - Resulting rows are the same not ok 328 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-4.5e-05' # > # '0' ok 329 - Original query executed without error ok 330 - New query executed without error ok 331 - Resulting rows are the same ok 332 - New query is quicker ok 333 - Original query executed without error ok 334 - New query executed without error ok 335 - Resulting rows are the same not ok 336 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000651' # > # '0' ok 337 - Original query executed without error ok 338 - New query executed without error ok 339 - Resulting rows are the same not ok 340 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00149' # > # '0' ok 341 - Original query executed without error ok 342 - New query executed without error ok 343 - Resulting rows are the same not ok 344 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-5.1e-05' # > # '0' ok 345 - Original query executed without error ok 346 - New query executed without error ok 347 - Resulting rows are the same not ok 348 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001536' # > # '0' ok 349 - Original query executed without error ok 350 - New query executed without error ok 351 - Resulting rows are the same not ok 352 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001582' # > # '0' ok 353 - Original query executed without error ok 354 - New query executed without error ok 355 - Resulting rows are the same not ok 356 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001509' # > # '0' ok 357 - Original query executed without error ok 358 - New query executed without error ok 359 - Resulting rows are the same not ok 360 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001771' # > # '0' ok 361 - Original query executed without error ok 362 - New query executed without error ok 363 - Resulting rows are the same not ok 364 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001466' # > # '0' ok 365 - Original query executed without error ok 366 - New query executed without error ok 367 - Resulting rows are the same not ok 368 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001425' # > # '0' ok 369 - Original query executed without error ok 370 - New query executed without error ok 371 - Resulting rows are the same not ok 372 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001562' # > # '0' ok 373 - Original query executed without error ok 374 - New query executed without error ok 375 - Resulting rows are the same not ok 376 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001654' # > # '0' ok 377 - Original query executed without error ok 378 - New query executed without error ok 379 - Resulting rows are the same not ok 380 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001485' # > # '0' ok 381 - Original query executed without error ok 382 - New query executed without error ok 383 - Resulting rows are the same not ok 384 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001634' # > # '0' ok 385 - Original query executed without error ok 386 - New query executed without error ok 387 - Resulting rows are the same ok 388 - New query is quicker ok 389 - Original query executed without error ok 390 - New query executed without error ok 391 - Resulting rows are the same not ok 392 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.012206' # > # '0' ok 393 - Original query executed without error ok 394 - New query executed without error ok 395 - Resulting rows are the same not ok 396 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.002003' # > # '0' ok 397 - Original query executed without error ok 398 - New query executed without error ok 399 - Resulting rows are the same not ok 400 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.002105' # > # '0' ok 401 - Original query executed without error ok 402 - New query executed without error ok 403 - Resulting rows are the same not ok 404 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00432' # > # '0' ok 405 - Original query executed without error ok 406 - New query executed without error ok 407 - Resulting rows are the same not ok 408 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.005829' # > # '0' ok 409 - Original query executed without error ok 410 - New query executed without error ok 411 - Resulting rows are the same ok 412 - New query is quicker ok 413 - Original query executed without error ok 414 - New query executed without error ok 415 - Resulting rows are the same ok 416 - New query is quicker ok 417 - Original query executed without error ok 418 - New query executed without error ok 419 - Resulting rows are the same not ok 420 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.010249' # > # '0' ok 421 - Original query executed without error ok 422 - New query executed without error ok 423 - Resulting rows are the same not ok 424 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.011411' # > # '0' ok 425 - Original query executed without error ok 426 - New query executed without error ok 427 - Resulting rows are the same not ok 428 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000425' # > # '0' ok 429 - Original query executed without error ok 430 - New query executed without error ok 431 - Resulting rows are the same not ok 432 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00025' # > # '0' ok 433 - Original query executed without error ok 434 - New query executed without error ok 435 - Resulting rows are the same not ok 436 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000229' # > # '0' ok 437 - Original query executed without error ok 438 - New query executed without error ok 439 - Resulting rows are the same not ok 440 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000207' # > # '0' ok 441 - Original query executed without error ok 442 - New query executed without error ok 443 - Resulting rows are the same not ok 444 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000234' # > # '0' ok 445 - Original query executed without error ok 446 - New query executed without error ok 447 - Resulting rows are the same not ok 448 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003139' # > # '0' ok 449 - Original query executed without error ok 450 - New query executed without error ok 451 - Resulting rows are the same ok 452 - New query is quicker ok 453 - Original query executed without error ok 454 - New query executed without error ok 455 - Resulting rows are the same not ok 456 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-6.00000000000001e-06' # > # '0' ok 457 - Original query executed without error ok 458 - New query executed without error ok 459 - Resulting rows are the same not ok 460 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000278' # > # '0' ok 461 - Original query executed without error ok 462 - New query executed without error ok 463 - Resulting rows are the same not ok 464 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000259' # > # '0' ok 465 - Original query executed without error ok 466 - New query executed without error ok 467 - Resulting rows are the same ok 468 - New query is quicker ok 469 - Original query executed without error ok 470 - New query executed without error ok 471 - Resulting rows are the same ok 472 - New query is quicker ok 473 - Original query executed without error ok 474 - New query executed without error ok 475 - Resulting rows are the same not ok 476 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000131' # > # '0' ok 477 - Original query executed without error ok 478 - New query executed without error ok 479 - Resulting rows are the same not ok 480 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000205' # > # '0' ok 481 - Original query executed without error ok 482 - New query executed without error ok 483 - Resulting rows are the same not ok 484 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000248' # > # '0' ok 485 - Original query executed without error ok 486 - New query executed without error ok 487 - Resulting rows are the same not ok 488 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.001385' # > # '0' ok 489 - Original query executed without error ok 490 - New query executed without error ok 491 - Resulting rows are the same not ok 492 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003' # > # '0' ok 493 - Original query executed without error ok 494 - New query executed without error ok 495 - Resulting rows are the same not ok 496 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003134' # > # '0' ok 497 - Original query executed without error ok 498 - New query executed without error ok 499 - Resulting rows are the same not ok 500 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003154' # > # '0' ok 501 - Original query executed without error ok 502 - New query executed without error ok 503 - Resulting rows are the same not ok 504 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003039' # > # '0' ok 505 - Original query executed without error ok 506 - New query executed without error ok 507 - Resulting rows are the same not ok 508 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00315' # > # '0' ok 509 - Original query executed without error ok 510 - New query executed without error ok 511 - Resulting rows are the same not ok 512 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.002969' # > # '0' ok 513 - Original query executed without error ok 514 - New query executed without error ok 515 - Resulting rows are the same not ok 516 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00322' # > # '0' ok 517 - Original query executed without error ok 518 - New query executed without error ok 519 - Resulting rows are the same not ok 520 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003106' # > # '0' ok 521 - Original query executed without error ok 522 - New query executed without error ok 523 - Resulting rows are the same not ok 524 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00319' # > # '0' ok 525 - Original query executed without error ok 526 - New query executed without error ok 527 - Resulting rows are the same not ok 528 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003142' # > # '0' ok 529 - Original query executed without error ok 530 - New query executed without error ok 531 - Resulting rows are the same not ok 532 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000203' # > # '0' ok 533 - Original query executed without error ok 534 - New query executed without error ok 535 - Resulting rows are the same not ok 536 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.013875' # > # '0' ok 537 - Original query executed without error ok 538 - New query executed without error ok 539 - Resulting rows are the same not ok 540 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.000912' # > # '0' ok 541 - Original query executed without error ok 542 - New query executed without error ok 543 - Resulting rows are the same not ok 544 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003608' # > # '0' ok 545 - Original query executed without error ok 546 - New query executed without error ok 547 - Resulting rows are the same not ok 548 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.003903' # > # '0' ok 549 - Original query executed without error ok 550 - New query executed without error ok 551 - Resulting rows are the same not ok 552 - New query is quicker # Failed test 'New query is quicker' # at /home/dolphin/GIT/AXO071/master/Tools/../Perl/OpenAsset/Tool/QueryLogMetrics.pm line 108. # '-0.00425' # > # '0' ok 553 - Original query executed without error ok 554 - New query executed without error ok 555 - Resulting rows are the same ok 556 - New query is quicker 1..556 [INFO] 2013/05/21 10:27:40 Query count: 139 [INFO] 2013/05/21 10:27:40 Failures - Before: 0 [INFO] 2013/05/21 10:27:40 Failures - After: 0 [INFO] 2013/05/21 10:27:40 Has differing results: 1 [INFO] 2013/05/21 10:27:40 Best time difference (seconds): 1.937168 [INFO] 2013/05/21 10:27:40 Worst time difference (seconds): -0.0319479999999999 [INFO] 2013/05/21 10:27:40 Best time difference %: 24.9974972469717 [INFO] 2013/05/21 10:27:40 Worst time difference %: 328.319623971798 [INFO] 2013/05/21 10:27:40 New query is slower: 105 [INFO] 2013/05/21 10:27:40 <<<<<<<<<<<<<<<<<<<<< SLOWER QUERIES >>>>>>>>>>>>>>>>>>>>>> [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 [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 [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 [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 [INFO] 2013/05/21 10:27:40 [Line: 644 -0.01141100s 328.1744%] SELECT album.* FROM album LEFT JOIN carousel ON album.id = carousel.default_album_id LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id 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 )) AND carousel.id IS NULL AND album.name RLIKE '[[:<:]]156' ORDER BY name LIMIT 15 OFFSET 0 [INFO] 2013/05/21 10:27:40 [Line: 643 -0.01024900s 286.3116%] SELECT album.* FROM album LEFT JOIN carousel ON album.id = carousel.default_album_id LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id 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 )) AND carousel.id IS NULL AND album.name LIKE '156%' ORDER BY name LIMIT 15 OFFSET 0 [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 [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 [INFO] 2013/05/21 10:27:40 [Line: 575 -0.00560500s 185.9531%] SELECT album.* FROM album LEFT JOIN carousel ON album.id = carousel.default_album_id LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id 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 )) AND carousel.id IS NULL AND album.name RLIKE '[[:<:]]abc' ORDER BY name LIMIT 15 OFFSET 0 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [INFO] 2013/05/21 10:27:40 [Line: 189 -0.00014000s 133.6538%] SELECT field.id AS id, field.code AS code, field.name AS name, field_type.code AS typeCode, field_display_type.code AS displayTypeCode, is_lookup AS isLookup FROM field JOIN field_display_type ON field_display_type_id = field_display_type.id JOIN field_data_type ON field_data_type_id = field_data_type.id JOIN field_type ON field_type_id = field_type.id WHERE is_lookup = 0 AND alive = 1 AND field_data_type.code = 'string' ORDER BY field.display_order [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [INFO] 2013/05/21 10:27:40 <<<<<<<<<<<<<<<<<<<<< QUICKER QUERIES >>>>>>>>>>>>>>>>>>>>> [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 [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 [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 [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 [INFO] 2013/05/21 10:27:40 [Line: 574 0.00347000s 69.4462%] SELECT album.* FROM album LEFT JOIN carousel ON album.id = carousel.default_album_id LEFT JOIN group2album ON album.id = group2album.album_id LEFT JOIN user2album ON album.id = user2album.album_id 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 )) AND carousel.id IS NULL AND album.name LIKE 'abc%' ORDER BY name LIMIT 15 OFFSET 0 [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 [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 [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 [INFO] 2013/05/21 10:27:40 [Line: 161 0.00050400s 45.5724%] SELECT field.id AS id, field.code AS code, field.name AS name, field_type.code AS typeCode, field_display_type.code AS displayTypeCode, is_lookup AS isLookup FROM field JOIN field_display_type ON field_display_type_id = field_display_type.id JOIN field_data_type ON field_data_type_id = field_data_type.id JOIN field_type ON field_type_id = field_type.id WHERE is_lookup = 1 AND alive = 1 ORDER BY field.display_order [INFO] 2013/05/21 10:27:40 [Line: 183 0.00049500s 53.4774%] SELECT field.id AS id, field.code AS code, field.name AS name, field_type.code AS typeCode, field_display_type.code AS displayTypeCode, is_lookup AS isLookup FROM field JOIN field_display_type ON field_display_type_id = field_display_type.id JOIN field_data_type ON field_data_type_id = field_data_type.id JOIN field_type ON field_type_id = field_type.id WHERE is_lookup = 1 AND alive = 1 AND field_data_type.code = 'string' AND field_display_type.code = 'option' ORDER BY field.display_order [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 [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 [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 [INFO] 2013/05/21 10:27:40 [Line: 610 0.00037200s 61.8070%] SELECT field.id AS id, field.code AS code, field.name AS name, field_type.code AS typeCode, field_display_type.code AS displayTypeCode, is_lookup AS isLookup FROM field JOIN field_display_type ON field_display_type_id = field_display_type.id JOIN field_data_type ON field_data_type_id = field_data_type.id JOIN field_type ON field_type_id = field_type.id WHERE is_lookup = 0 AND alive = 1 AND include_on_search = 1 AND field_data_type.code = 'string' ORDER BY field.display_order [INFO] 2013/05/21 10:27:40 [Line: 188 0.00023000s 63.7795%] SELECT field.id AS id, field.code AS code, field.name AS name, field_type.code AS typeCode, field_display_type.code AS displayTypeCode, is_lookup AS isLookup FROM field JOIN field_display_type ON field_display_type_id = field_display_type.id JOIN field_data_type ON field_data_type_id = field_data_type.id JOIN field_type ON field_type_id = field_type.id WHERE is_lookup = 0 AND alive = 1 AND field_data_type.code = 'date' ORDER BY field.display_order [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [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 [INFO] 2013/05/21 10:27:40 [Line: 190 0.00000700s 98.3908%] SELECT field.id AS id, field.code AS code, field.name AS name, field_type.code AS typeCode, field_display_type.code AS displayTypeCode, is_lookup AS isLookup FROM field JOIN field_display_type ON field_display_type_id = field_display_type.id JOIN field_data_type ON field_data_type_id = field_data_type.id JOIN field_type ON field_type_id = field_type.id WHERE is_lookup = 1 AND alive = 1 AND field_data_type.code = 'string' ORDER BY field.display_order [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 # Looks like you failed 106 tests of 556.