Запросы, тормозящие систему.

Demias

Захожу иногда
244
2 / 0

Запросы, тормозящие систему.

« : 03.10.2012, 16:53:16 »

Посмотрел в логах MySql, данные запросы по 2 часа висят в процессах. Один запрос такой жрет 26 минут... Может кто подскажет решение проблемы?

Код

SELECT DISTINCT relation.itemid, relation.catid, title, owner, image, background, icon FROM `jos_sobi2_cat_items_relations` AS relation LEFT JOIN `jos_sobi2_item` AS items ON relation.itemid = items.itemid WHERE ((`catid` = 265 OR `catid` = 265 OR `catid` = 266 OR `catid` = 267 OR `catid` = 268 OR `catid` = 269 OR `catid` = 270 OR `catid` = 271 OR `catid` = 272 OR `catid` = 273 OR `catid` = 274 OR `catid` = 275 OR `catid` = 276 OR `catid` = 277 OR `catid` = 278 OR `catid` = 279 OR `catid` = 280 OR `catid` = 281 OR `catid` = 282 OR `catid` = 283 OR `catid` = 284 OR `catid` = 285 OR `catid` = 286 OR `catid` = 287 OR `catid` = 288 OR `catid` = 289 OR `catid` = 290 OR `catid` = 291 OR `catid` = 292 OR `catid` = 294 OR `catid` = 295 OR `catid` = 296 OR `catid` = 297 OR `catid` = 298 OR `catid` = 299 OR `catid` = 300 OR `catid` = 301 OR `catid` = 302 OR `catid` = 303 OR `catid` = 304 OR `catid` = 305 OR `catid` = 306 OR `catid` = 307 OR `catid` = 308 OR `catid` = 309 OR `catid` = 310 OR `catid` = 311 OR `catid` = 312 OR `catid` = 313 OR `catid` = 314 OR `catid` = 315 OR `catid` = 316 OR `catid` = 317 ) AND `published` = '1' AND (`publish_down` > '2012-10-03 15:20:08' OR `publish_down` = '0000-00-00 00:00:00' ) AND items.itemid IN(SELECT DISTINCT relation.itemid FROM `jos_sobi2_cat_items_relations` AS relation LEFT JOIN `jos_sobi2_item` AS items ON relation.itemid = items.itemid WHERE ((`catid` = 265 OR `catid` = 265 OR `catid` = 266 OR `catid` = 267 OR `catid` = 268 OR `catid` = 269 OR `catid` = 270 OR `catid` = 271 OR `catid` = 272 OR `catid` = 273 OR `catid` = 274 OR `catid` = 275 OR `catid` = 276 OR `catid` = 277 OR `catid` = 278 OR `catid` = 279 OR `catid` = 280 OR `catid` = 281 OR `catid` = 282 OR `catid` = 283 OR `catid` = 284 OR `catid` = 285 OR `catid` = 286 OR `catid` = 287 OR `catid` = 288 OR `catid` = 289 OR `catid` = 290 OR `catid` = 291 OR `catid` = 292 OR `catid` = 294 OR `catid` = 295 OR `catid` = 296 OR `catid` = 297 OR `catid` = 298 OR `catid` = 299 OR `catid` = 300 OR `catid` = 301 OR `catid` = 302 OR `catid` = 303 OR `catid` = 304 OR `catid` = 305 OR `catid` = 306 OR `catid` = 307 OR `catid` = 308 OR `catid` = 309 OR `catid` = 310 OR `catid` = 311 OR `catid` = 312 OR `catid` = 313 OR `catid` = 314 OR `catid` = 315 OR `catid` = 316 OR `catid` = 317 ) AND `published` = 1 AND (`publish_down` > '2012-10-03 15:20:08' OR `publish_down` = '0000-00-00 00:00:00' ) )) ) GROUP BY items.itemid ORDER BY items.title ASC  LIMIT 132, 12

Заранее благодарен!

Записан