[INFO] 2013/05/21 10:12:18 [Line: 369 -0.06606200s 101.4079%] 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:12:18 [Line: 476 -0.06172600s 102.0664%] SELECT DISTINCT(image.id) FROM image LEFT JOIN image_size ON image_size.image_id = image.id AND image_size.default_image_size_id IN (7,6) 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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:12:18 [Line: 148 6.43412700s 27.5357%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) 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:12:18 [Line: 364 0.52828700s 88.0329%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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:12:18 [Line: 405 0.40287400s 90.1183%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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:12:18 [Line: 489 0.00300500s 41.3544%] 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.created,original_recreate,original_width,original_height,original_filesize,original_file_format_id,original_colourspace_id,thumbnail_created,thumbnail_recreate,thumbnail_width,thumbnail_height,thumbnail_filesize,thumbnail_file_format_id,thumbnail_colourspace_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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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) AND image.id IN (268213,268197,268194,268191,268180,268169,268158,268156,199330,326477,268212,268200,268199,268198,268196,268195,268193,268192,268190,268189,268188,268187,268182,268181,268168,268167,268166,268164,268163,268162,268161,268160,268159,268157,268131,268129,226258,226257,226256,212196,203679,203677,199331,142729) ORDER BY image.access_level,image.uploaded DESC,image.id

[INFO] 2013/05/21 10:12:18 [Line: 152 0.00298200s 56.1922%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) 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 (268169,268156,268180,268158,268191,268197,268194,268213,199330,142729,268160,199331,203679,212196,268168,268181,268131,213341,268129,268164,268190,268162,268167,268187,268188,268196,268198,268199,268200,146356,146357,146358,203677,208603,226256,226257,226258,268157,268159,268161,268163,268166,268182,268189,268192,268193,268195,268212,312475,321655,323297,326477) ORDER BY image.access_level,image.click_count DESC,image.id

[INFO] 2013/05/21 10:12:18 [Line: 367 0.00225400s 55.2866%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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 (268169,268156,268180,268158,268191,268197,268194,268213,199330,142729,268160,199331,203679,212196,268168,268181,268131,268129,268164,268190,268162,268167,268187,268188,268196,268198,268199,268200,203677,226256,226257,226258,268157,268159,268161,268163,268166,268182,268189,268192,268193,268195,268212,326477) ORDER BY image.access_level,image.click_count DESC,image.id

[INFO] 2013/05/21 14:40:26 [Line: 364 -1.13802200s 135.5178%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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 14:40:26 [Line: 405 -0.04392200s 101.4847%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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 14:40:26 [Line: 148 4.46936400s 29.2794%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) 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 14:40:26 [Line: 369 0.74864900s 84.7353%] 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 14:40:26 [Line: 51 0.13111400s 90.4233%] SELECT image.id FROM image LEFT JOIN project ON image.project_id = project.id WHERE image.category_id IN (1) AND image.access_level IN (1,2) AND (image.rank >= '1' AND image.rank <= '10') AND (image.uploaded >= '20130421000000' AND image.uploaded <= '20130521000000') AND image.alive = 1 AND (image.category_id=1 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.uploaded DESC,image.id

[INFO] 2013/05/21 14:40:26 [Line: 476 0.04493900s 98.5125%] SELECT DISTINCT(image.id) FROM image LEFT JOIN image_size ON image_size.image_id = image.id AND image_size.default_image_size_id IN (7,6) 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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 14:40:26 [Line: 367 0.00386300s 47.0169%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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 (268169,268156,268180,268158,268191,268197,268194,268213,199330,142729,268160,199331,203679,212196,268168,268181,268131,268129,268164,268190,268162,268167,268187,268188,268196,268198,268199,268200,203677,226256,226257,226258,268157,268159,268161,268163,268166,268182,268189,268192,268193,268195,268212,326477) ORDER BY image.access_level,image.click_count DESC,image.id

[INFO] 2013/05/21 14:40:26 [Line: 152 0.00332200s 43.0775%] 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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) 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 (268169,268156,268180,268158,268191,268197,268194,268213,199330,142729,268160,199331,203679,212196,268168,268181,268131,213341,268129,268164,268190,268162,268167,268187,268188,268196,268198,268199,268200,146356,146357,146358,203677,208603,226256,226257,226258,268157,268159,268161,268163,268166,268182,268189,268192,268193,268195,268212,312475,321655,323297,326477) ORDER BY image.access_level,image.click_count DESC,image.id

[INFO] 2013/05/21 14:40:26 [Line: 489 0.00312800s 40.7127%] 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.created,original_recreate,original_width,original_height,original_filesize,original_file_format_id,original_colourspace_id,thumbnail_created,thumbnail_recreate,thumbnail_width,thumbnail_height,thumbnail_filesize,thumbnail_file_format_id,thumbnail_colourspace_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.filename LIKE '%by%' OR image.original_filename LIKE '%by%' OR image.caption LIKE '%by%' OR image.description LIKE '%by%' OR project.code LIKE '%by%' OR project.code_alias_1 LIKE '%by%' OR project.code_alias_2 LIKE '%by%' OR project.name LIKE '%by%' OR project.name_alias_1 LIKE '%by%' OR project.name_alias_2 LIKE '%by%' OR image.project_id IN (727,750,774,780,781,782,1680) OR image.id IN (9097,9215,10589,10851,10892,10969,10980,16593,18461,20715,22620,27741,29422,33951,37043,37048,37052,37074,37075,43007,43008,43242,43343,48301,48302,48303,48305,57211,63397,63423,63619,82172,153198,153257,98811,110155,118042,143590,143594,143595,115493,116478,116479,116480,116481,116485,116486,116487,116488,116489,116490,122537,113131,113045,113129,113130,113150,116477,116482,116491,116492,117885,117884,117886,118040,118041,119514,122518,122519,122521,122522,122523,122524,122525,122526,122527,122528,122529,122530,122531,122532,122533,122534,122535,122536,122538,122539,122540,122541,122542,131901,131902,131915,157268,157269,157270,157271,157272,157273,157274,157275,157276,157277,157278,157279,157320,157501,54593,92461,92464,92465,92467,92468,92469,92472,92473,92476,92478,92480,92481,92486,92494,92495,92513,92514,92535,92536,92538,92539,92540,92545,92556,92557,92562,92749,92750,92753,92756,92757,92759,92775,92758,92772,92773,92774,92776,92826,92827,92828,92829,92830,97316,92834,147959,147964,147966,147967,147968,147975,147977,147990,147991,147992,147993,147994,147997,147998,147999,147996,148000,148002,148008,148009,148010,148011,148024,148027,148032,148001,148003,148019,148031,148036,148021,148026,148028,148029,148030,148035,148038,148042,148056,148057,148044,148045,148049,156861,27323,56120,56121,56134,59575,59566,59565,59564,59589,59605,59606,59607,59608,47603,47604,47661,47663,47667,47668,47690,47743,107796,116727,82170,82171,107795,116742,116743,116744,17291,156842,47994,122934,122935,122936,122937,122938,122939,140258,140261,140262,140312,82636,115297,115298,115299,115300,115301,140254,140274,140301,140302,140303,140304,140306,140307,140309,140310,140311,140313,140322,140323,140286,140287,156848,26129,26361,97344,156576,156570,8419,8418,8417,8400,8398,43109,43134,97352,153399,153400,153401,9070,9073,9074,9076,9077,9078,9079,9099,9100,9101,9110,9214,14325,14451,14346,14349,14351,14353,14355,80868,80892,82792,94768,94774,94784,72088,72104,72105,72107,72108,72109,72113,72137,156812,156813,66164,72146,72147,72915,72916,72917,72918,72919,72920,72923,72925,75325,75326,75394,75395,72149,72151,147016,139295,139296,139298,163945,163947,163951,163952,163963,51228,148146,168808,168828,168830,168832,168837,168855,168857,168876,176771,176772,176784,176789,176790,176796,177719,16588,8147,8390,9002,9012,9109,9223,9272,9928,9939,10592,10788,10804,10873,10874,10966,11118,11152,11530,11534,11935,11936,12528,13259,13713,13802,14246,14268,18028,18464,22144,22146,22149,24766,24771,24772,43006,43199,43241,43464,43722,44774,47995,48067,50707,56135,70683,71085,71087,71088,71113,71536,72965,76883,77032,80072,81314,81315,81316,92710,95940,95958,107793,111148,117893,122520,138161,140260,140265,140270,143461,143464,144155,144157,144159,147958,147995,153250,153607,153615,153677,153680,156644,156654,156765,158036,163950,50130,50131,50138,50153,8389,8403,9003,9224,9685,12483,18030,18278,27233,47571,50157,63302,70682,71084,95811,95943,95959,131914,140263,140300,143473,144158,153682,157448,158021,158272,202592,202593,202597,153194,153196,153202,153215,132618,132621,132624,132653,132664,141576,141580,141581,141582,141583,141584,141585,24633,24687,24721,24722,24723,24744,24745,24765,24770,24809,24834,24835,204772,204773,204774,204775,204776,204777,204778,204779,204780,204781,204782,204783,204812,204813,204814,204826,63438,206455,206484,206509,206510,206530,206545,206547,206596,206597,206599,206600,210556,210560,210562,210571,210573,210574,210576,210578,210579,210580,211318,211500,211501,211505,211506,211515,211517,211527,211541,211557,211565,211566,211559,211560,206221,206222,206234,206631,207139,8404,8422,10591,133869,153678,184121,184123,184127,16585,16586,16962,108572,110156,111147,140256,140259,153612,158072,216922,7709,158097,48902,140269,143621,114084,140305,144160,153605,206481,72098,224101,224129,224262,224286,224314,224328,224330,224333,224334,224335,224341,224359,224360,224331,224332,225468,225474,225475,225482,224821,206258,224033,224054,226414,228047,228048,226268,228120,228125,226458,226312,226100,226424,229223,229225,229266,229267,229268,229274,126369,126370,126371,126389,126390,231034,126392,126393,126394,126395,126450,231229,231244,231256,131684,131682,131676,131677,131678,131679,131680,131681,131827,131826,131865,126391,131992,131971,131994,232395,232397,232398,232399,232400,232401,232402,232403,232404,232405,232406,232408,232409,232410,232411,232412,232441,232446,232439,232516,235217,235218,235224,235327,235231,235233,235234,235236,235252,235256,235282,235284,235285,235286,235320,235326,235328,235329,235330,235331,235332,234458,234487,234925,234548,234549,234552,234553,234556,234560,234561,234969,234975,234979,234981,234990,238831,238832,238848,238851,238861,238862,238864,238879,240130,240139,242000,243128,132020,132104,132105,132106,132107,132108,132109,132110,129480,129481,129484,129488,129492,132066,132067,132069,132090,132117,132146,129471,129475,129483,67230,67225,67243,67244,259995,259994,259946,259972,259971,261277,262928,262927,240148,240145,240140,240137,240136,268546,276116,276118,276120,275327,275409,275416,275418,275420,275439,275461,278789,278784,278783,280037,280038,280042,280043,280044,280049,280064,279183,279185,279206,279212,281398,281413,281421,281423,281430,281472,281473,281401,281369,279579,280959,280960,280961,280962,280963,280979,280980,280990,280991,280992,281107,280970,280971,280972,279580,280936,280955,280983,282117,282118,282119,282120,282121,282122,282123,282124,282125,282126,282127,282128,282129,282130,282131,282135,282099,285745,285738,285791,285667,285697,287858,287864,288558,288671,288712,291873,296209,296214,296216,296217,141443,141447,141449,298679,300986,301585,301591,301592,301593,301596,301604,301623,301586,301587,301589,301590,301605,301613,301614,301616,301618,301303,301317,301323,301333,301344,301347,301363,303838,303828,307505,307512,307530,307500,307546,308415,312624,312678,312663,312640,312650,312660,312655,312517,312526,312511,312490,313384,317049,317036,317025,317051,318169,318170,318173,318347,313378,313360,317811,317812,317814,317847,317849,317854,317855,317860,317862,317867,317873,317886,317894,317897,317898,317899,317900,317845,317840,317817,317689,317695,317702,317707,317712,317713,317733,317758,317761,317762,317768,317775,317694,317696,317703,317769,317794,317718,322131,322132,322151,322156,322158,322170,322171,322138,322174,322135,321313,321314,321381,321382,321392,321393,321395,321396,321397,321385,321386,321332,321333,321343,321354,321355,321356,321384,321334,321340,321341,321342,321349,321350,321352,321353,321380,323009,323010,323011,323012,323013,323014,323015,323016,323017,323018,323019,323020,323021,322832,326156,326157,326158,326159,326160,326161,326162,326164,326166,326167,326169,326171,326173,326175,326176,326179,326180,326097,326098,326099,326100,326101,326102,326103,326105,326106,326107,326108,326109,326110,326111,326142,326143,326144,326145,326215,326216,326217,326218,326219,326220,326221,326222,326223,326224,326225,326226,326233,326274,326285,333417,333443,333460,333466,333468,333470,333377,334418,334424,334426,334429,334431,334437,334439,334442,334445,334454,333360,333427,333492,333500,333502,333514,333515,334243,334265,334270,333527,333529,333531,333535,333375,333491,331266,331286,331287,331288,331289,331291,331292,331293,331295,331296,331299,331341,331344,331345,331363,331364,331365,331366,331367,331368,331471,331472,331510,331522,331552,331553,331198,331207,331210,331211,331212,331213,331284,331285,331339,331340,331342,331346,331360,331361,331362,331373,331506,331509,331517,331521,331523,333154,331524,331554,331555,331556,333131,333132,333150,331445,331446,331447,331448,331463,331464,331465,331466,331467,331468,331469,331470,331476,331477,331478,331481,331483,331484,331485,333143,333147,331343,331371,331372,331441,331442,331443,331377,331387,331376,331502,331374,331375,331557,331369,331370,335417,335405,335469,336113,338819,338835,338949,338950,339243,339359,339362,339363,339367,339368,339369,340190,340191,340192,340193,340194,340195,340200,340202,340232,340242,340243,340244,340230,340779,340801,340732,340807,340815,340734,340835,340836,340845,340857,340872,340892,340893,340825,340838,341029,329273,329272,329279,329274,329270,343320,343305,343321,343306,343307,343309,343310,343544,343547,343571,343572,343573,343570,324143,324163,324167,345154,345158,345165,345168,345172,345173,345174,345164,325828,326003,326029,347082,347090,347076,349289,349310,349319,349024,349215,326560,246977,247001,203214,351970,351971,351972,352012,355196,356413,356414,356415,356416,356456,356457,356460,359185,359188,359189,359190,359191,359192,359193,359197,359198,359199,359200,359264,359265,359184,359186,359196,359243,359247,359249,359250,359266,358511,358520,358523,358525,358526,364357,364358,364359,361214,361215,361216,361217,361218,361383,361384,361385,361386,361390,361394,361396,361397,370452,370453,370458,370461,370624,370625,370626,370662,370663,403109,403110,403112,403132,403133,403134,403135,403136,403137,403138,403139,403141,403142,403144,403150,403151,403152,403153,403154,403155,403158,403159,409474,409475,409476,411970,411971,411973,411977,411978,411979,411980,411982,411985,411986,411987,411992,411995,412940,412950,413374,414270,414663,421140,422177,422178,422179,422180,422181,422182,422183,422199,422200,148570,148571,148572,148573,151832,39070,152938,152939,152940,152941,152942,152943,152944,152945,152946,152947,152948,152949,152950,152951,152952,152953,152954,152955,152956,152957,152958,152959,152960,152961,152962,152963,152964,152965,152966,152967,152968,152969,152970,152971,152972,152973))) AND NOT ((image.filename LIKE '%order by%' OR image.original_filename LIKE '%order by%' OR image.caption LIKE '%order by%' OR image.description LIKE '%order by%' OR project.code LIKE '%order by%' OR project.code_alias_1 LIKE '%order by%' OR project.code_alias_2 LIKE '%order by%' OR project.name LIKE '%order by%' OR project.name_alias_1 LIKE '%order by%' OR project.name_alias_2 LIKE '%order by%')) 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) AND image.id IN (268213,268197,268194,268191,268180,268169,268158,268156,199330,326477,268212,268200,268199,268198,268196,268195,268193,268192,268190,268189,268188,268187,268182,268181,268168,268167,268166,268164,268163,268162,268161,268160,268159,268157,268131,268129,226258,226257,226256,212196,203679,203677,199331,142729) ORDER BY image.access_level,image.uploaded DESC,image.id