Salut
Je me pose une question à propos de xoopstube, la plupart des pages du module requière une 50 ene de requêtes et par contre la page index du module en demande plus de 500, les requêtes sont toutes séparé les unes des autres, je me demande si y'a pas un problème.(c'est vraiment trop lourds)
Juste pour afficher les catégories principale et les 50 dernières vidéos,520 requêtes c'est étrange.
Les requêtes se répète encore et encore pour chaque id, je ne sais pas si c'est normal?
Voyez ce que ça donne(extrait):
0.004098 - SELECT a.lid, a.cid, a.published FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid=a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=5 OR b.cid=5)) GROUP BY a.lid, a.cid, a.published
0.000727 - SELECT cid FROM xoopstube_cat WHERE pid=5
0.000537 - SELECT cid FROM xoopstube_cat WHERE pid=26
0.000443 - SELECT cid FROM xoopstube_cat WHERE pid=27
0.000327 - SELECT cid FROM xoopstube_cat WHERE pid=28
0.000375 - SELECT cid FROM xoopstube_cat WHERE pid=29
0.000496 - SELECT cid FROM xoopstube_cat WHERE pid=30
0.000441 - SELECT cid FROM xoopstube_cat WHERE pid=31
0.000393 - SELECT cid FROM xoopstube_cat WHERE pid=87
0.000348 - SELECT cid FROM xoopstube_cat WHERE pid=109
0.000371 - SELECT cid FROM xoopstube_cat WHERE pid=125
0.000353 - SELECT cid FROM xoopstube_cat WHERE pid=189
0.000352 - SELECT cid FROM xoopstube_cat WHERE pid=188
0.000403 - SELECT cid FROM xoopstube_cat WHERE pid=187
0.000628 - SELECT cid FROM xoopstube_cat WHERE pid=186
0.000417 - SELECT cid FROM xoopstube_cat WHERE pid=185
0.000330 - SELECT cid FROM xoopstube_cat WHERE pid=177
0.000323 - SELECT cid FROM xoopstube_cat WHERE pid=180
0.000357 - SELECT cid FROM xoopstube_cat WHERE pid=181
0.000336 - SELECT cid FROM xoopstube_cat WHERE pid=182
0.000309 - SELECT cid FROM xoopstube_cat WHERE pid=183
0.000300 - SELECT cid FROM xoopstube_cat WHERE pid=179
0.000388 - SELECT cid FROM xoopstube_cat WHERE pid=184
0.000315 - SELECT cid FROM xoopstube_cat WHERE pid=190
0.000608 - SELECT cid FROM xoopstube_cat WHERE pid=191
0.000340 - SELECT cid FROM xoopstube_cat WHERE pid=192
0.000346 - SELECT cid FROM xoopstube_cat WHERE pid=193
0.000321 - SELECT cid FROM xoopstube_cat WHERE pid=194
0.000301 - SELECT cid FROM xoopstube_cat WHERE pid=195
0.000278 - SELECT cid FROM xoopstube_cat WHERE pid=196
0.000284 - SELECT cid FROM xoopstube_cat WHERE pid=197
0.000312 - SELECT cid FROM xoopstube_cat WHERE pid=198
0.000330 - SELECT cid FROM xoopstube_cat WHERE pid=199
0.000314 - SELECT cid FROM xoopstube_cat WHERE pid=200
0.000385 - SELECT cid FROM xoopstube_cat WHERE pid=201
0.000351 - SELECT cid FROM xoopstube_cat WHERE pid=202
0.000467 - SELECT cid FROM xoopstube_cat WHERE pid=203
0.000268 - SELECT cid FROM xoopstube_cat WHERE pid=204
0.000284 - SELECT cid FROM xoopstube_cat WHERE pid=205
0.000293 - SELECT cid FROM xoopstube_cat WHERE pid=206
0.013929 - SELECT cid FROM xoopstube_cat WHERE pid=207
0.000369 - SELECT cid FROM xoopstube_cat WHERE pid=208
0.000324 - SELECT cid FROM xoopstube_cat WHERE pid=209
0.000461 - SELECT cid FROM xoopstube_cat WHERE pid=210
0.000324 - SELECT cid FROM xoopstube_cat WHERE pid=211
0.000335 - SELECT cid FROM xoopstube_cat WHERE pid=212
0.000366 - SELECT cid FROM xoopstube_cat WHERE pid=213
0.000332 - SELECT cid FROM xoopstube_cat WHERE pid=214
0.000312 - SELECT cid FROM xoopstube_cat WHERE pid=215
0.000632 - SELECT cid FROM xoopstube_cat WHERE pid=216
0.000744 - SELECT cid FROM xoopstube_cat WHERE pid=217
0.000496 - SELECT cid FROM xoopstube_cat WHERE pid=218
0.000445 - SELECT cid FROM xoopstube_cat WHERE pid=219
0.000326 - SELECT cid FROM xoopstube_cat WHERE pid=220
0.000349 - SELECT cid FROM xoopstube_cat WHERE pid=221
0.000593 - SELECT cid FROM xoopstube_cat WHERE pid=222
0.000358 - SELECT cid FROM xoopstube_cat WHERE pid=223
0.000340 - SELECT cid FROM xoopstube_cat WHERE pid=224
0.000391 - SELECT cid FROM xoopstube_cat WHERE pid=225
0.000347 - SELECT cid FROM xoopstube_cat WHERE pid=226
0.000341 - SELECT cid FROM xoopstube_cat WHERE pid=227
0.000332 - SELECT cid FROM xoopstube_cat WHERE pid=228
0.000329 - SELECT cid FROM xoopstube_cat WHERE pid=229
0.000335 - SELECT cid FROM xoopstube_cat WHERE pid=230
0.000645 - SELECT cid FROM xoopstube_cat WHERE pid=231
0.000360 - SELECT cid FROM xoopstube_cat WHERE pid=232
0.000689 - SELECT cid FROM xoopstube_cat WHERE pid=233
0.000475 - SELECT cid FROM xoopstube_cat WHERE pid=234
0.000349 - SELECT cid FROM xoopstube_cat WHERE pid=235
0.000446 - SELECT cid FROM xoopstube_cat WHERE pid=236
0.000530 - SELECT cid FROM xoopstube_cat WHERE pid=237
0.000509 - SELECT cid FROM xoopstube_cat WHERE pid=238
0.000337 - SELECT cid FROM xoopstube_cat WHERE pid=239
0.000392 - SELECT cid FROM xoopstube_cat WHERE pid=240
0.000692 - SELECT cid FROM xoopstube_cat WHERE pid=241
0.000558 - SELECT cid FROM xoopstube_cat WHERE pid=242
0.000352 - SELECT cid FROM xoopstube_cat WHERE pid=243
0.000433 - SELECT cid FROM xoopstube_cat WHERE pid=244
0.000355 - SELECT cid FROM xoopstube_cat WHERE pid=245
0.000303 - SELECT cid FROM xoopstube_cat WHERE pid=246
0.000325 - SELECT cid FROM xoopstube_cat WHERE pid=247
0.000626 - SELECT cid FROM xoopstube_cat WHERE pid=248
0.000529 - SELECT cid FROM xoopstube_cat WHERE pid=249
0.000343 - SELECT cid FROM xoopstube_cat WHERE pid=250
0.000376 - SELECT cid FROM xoopstube_cat WHERE pid=251
0.000336 - SELECT cid FROM xoopstube_cat WHERE pid=252
0.000337 - SELECT cid FROM xoopstube_cat WHERE pid=253
0.000321 - SELECT cid FROM xoopstube_cat WHERE pid=254
0.000447 - SELECT cid FROM xoopstube_cat WHERE pid=255
0.000596 - SELECT cid FROM xoopstube_cat WHERE pid=256
0.000429 - SELECT cid FROM xoopstube_cat WHERE pid=257
0.000368 - SELECT cid FROM xoopstube_cat WHERE pid=258
0.000344 - SELECT cid FROM xoopstube_cat WHERE pid=259
0.000678 - SELECT cid FROM xoopstube_cat WHERE pid=260
0.000412 - SELECT cid FROM xoopstube_cat WHERE pid=261
0.004051 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=26 OR b.cid=26)) GROUP BY a.lid, a.published, a.cid
0.003928 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=27 OR b.cid=27)) GROUP BY a.lid, a.published, a.cid
0.003666 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=28 OR b.cid=28)) GROUP BY a.lid, a.published, a.cid
0.003697 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=29 OR b.cid=29)) GROUP BY a.lid, a.published, a.cid
0.004503 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=30 OR b.cid=30)) GROUP BY a.lid, a.published, a.cid
0.003769 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=31 OR b.cid=31)) GROUP BY a.lid, a.published, a.cid
0.003676 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=87 OR b.cid=87)) GROUP BY a.lid, a.published, a.cid
0.004454 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=109 OR b.cid=109)) GROUP BY a.lid, a.published, a.cid
0.003729 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=125 OR b.cid=125)) GROUP BY a.lid, a.published, a.cid
0.004702 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=189 OR b.cid=189)) GROUP BY a.lid, a.published, a.cid
0.003713 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=188 OR b.cid=188)) GROUP BY a.lid, a.published, a.cid
0.003919 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=187 OR b.cid=187)) GROUP BY a.lid, a.published, a.cid
0.004475 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=186 OR b.cid=186)) GROUP BY a.lid, a.published, a.cid
0.003775 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=185 OR b.cid=185)) GROUP BY a.lid, a.published, a.cid
0.006050 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=177 OR b.cid=177)) GROUP BY a.lid, a.published, a.cid
0.006242 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=180 OR b.cid=180)) GROUP BY a.lid, a.published, a.cid
0.006058 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=181 OR b.cid=181)) GROUP BY a.lid, a.published, a.cid
0.003817 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=182 OR b.cid=182)) GROUP BY a.lid, a.published, a.cid
0.003657 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=183 OR b.cid=183)) GROUP BY a.lid, a.published, a.cid
0.003663 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=179 OR b.cid=179)) GROUP BY a.lid, a.published, a.cid
0.009385 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=184 OR b.cid=184)) GROUP BY a.lid, a.published, a.cid
0.006124 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=190 OR b.cid=190)) GROUP BY a.lid, a.published, a.cid
0.003699 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=191 OR b.cid=191)) GROUP BY a.lid, a.published, a.cid
0.003821 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=192 OR b.cid=192)) GROUP BY a.lid, a.published, a.cid
0.003777 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=193 OR b.cid=193)) GROUP BY a.lid, a.published, a.cid
0.003893 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=194 OR b.cid=194)) GROUP BY a.lid, a.published, a.cid
0.003861 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=195 OR b.cid=195)) GROUP BY a.lid, a.published, a.cid
0.003718 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=196 OR b.cid=196)) GROUP BY a.lid, a.published, a.cid
0.003725 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=197 OR b.cid=197)) GROUP BY a.lid, a.published, a.cid
0.003859 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=198 OR b.cid=198)) GROUP BY a.lid, a.published, a.cid
0.003770 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=199 OR b.cid=199)) GROUP BY a.lid, a.published, a.cid
0.003943 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=200 OR b.cid=200)) GROUP BY a.lid, a.published, a.cid
0.004584 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=201 OR b.cid=201)) GROUP BY a.lid, a.published, a.cid
0.005318 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=202 OR b.cid=202)) GROUP BY a.lid, a.published, a.cid
0.003920 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=203 OR b.cid=203)) GROUP BY a.lid, a.published, a.cid
0.003825 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=204 OR b.cid=204)) GROUP BY a.lid, a.published, a.cid
0.003715 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=205 OR b.cid=205)) GROUP BY a.lid, a.published, a.cid
0.097354 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=206 OR b.cid=206)) GROUP BY a.lid, a.published, a.cid
0.007605 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=207 OR b.cid=207)) GROUP BY a.lid, a.published, a.cid
0.004145 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=208 OR b.cid=208)) GROUP BY a.lid, a.published, a.cid
0.003864 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=209 OR b.cid=209)) GROUP BY a.lid, a.published, a.cid
0.003926 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=210 OR b.cid=210)) GROUP BY a.lid, a.published, a.cid
0.006237 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=211 OR b.cid=211)) GROUP BY a.lid, a.published, a.cid
0.006055 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=212 OR b.cid=212)) GROUP BY a.lid, a.published, a.cid
0.005693 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=213 OR b.cid=213)) GROUP BY a.lid, a.published, a.cid
0.016749 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=214 OR b.cid=214)) GROUP BY a.lid, a.published, a.cid
0.005094 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=215 OR b.cid=215)) GROUP BY a.lid, a.published, a.cid
0.003921 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=216 OR b.cid=216)) GROUP BY a.lid, a.published, a.cid
0.004089 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=217 OR b.cid=217)) GROUP BY a.lid, a.published, a.cid
0.004927 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=218 OR b.cid=218)) GROUP BY a.lid, a.published, a.cid
0.004106 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=219 OR b.cid=219)) GROUP BY a.lid, a.published, a.cid
0.003822 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=220 OR b.cid=220)) GROUP BY a.lid, a.published, a.cid
0.009914 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=221 OR b.cid=221)) GROUP BY a.lid, a.published, a.cid
0.003784 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=222 OR b.cid=222)) GROUP BY a.lid, a.published, a.cid
0.003748 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=223 OR b.cid=223)) GROUP BY a.lid, a.published, a.cid
0.003699 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=224 OR b.cid=224)) GROUP BY a.lid, a.published, a.cid
0.003769 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=225 OR b.cid=225)) GROUP BY a.lid, a.published, a.cid
0.003744 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=226 OR b.cid=226)) GROUP BY a.lid, a.published, a.cid
0.012157 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=227 OR b.cid=227)) GROUP BY a.lid, a.published, a.cid
0.003982 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=228 OR b.cid=228)) GROUP BY a.lid, a.published, a.cid
0.014815 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=229 OR b.cid=229)) GROUP BY a.lid, a.published, a.cid
0.009514 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=230 OR b.cid=230)) GROUP BY a.lid, a.published, a.cid
0.003783 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=231 OR b.cid=231)) GROUP BY a.lid, a.published, a.cid
0.003860 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=232 OR b.cid=232)) GROUP BY a.lid, a.published, a.cid
0.003895 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=233 OR b.cid=233)) GROUP BY a.lid, a.published, a.cid
0.003703 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=234 OR b.cid=234)) GROUP BY a.lid, a.published, a.cid
0.003691 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=235 OR b.cid=235)) GROUP BY a.lid, a.published, a.cid
0.006801 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=236 OR b.cid=236)) GROUP BY a.lid, a.published, a.cid
0.004105 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=237 OR b.cid=237)) GROUP BY a.lid, a.published, a.cid
0.004079 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=238 OR b.cid=238)) GROUP BY a.lid, a.published, a.cid
0.003955 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=239 OR b.cid=239)) GROUP BY a.lid, a.published, a.cid
0.003801 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=240 OR b.cid=240)) GROUP BY a.lid, a.published, a.cid
0.003734 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=241 OR b.cid=241)) GROUP BY a.lid, a.published, a.cid
0.003726 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=242 OR b.cid=242)) GROUP BY a.lid, a.published, a.cid
0.003775 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=243 OR b.cid=243)) GROUP BY a.lid, a.published, a.cid
0.004148 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=244 OR b.cid=244)) GROUP BY a.lid, a.published, a.cid
0.004383 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=245 OR b.cid=245)) GROUP BY a.lid, a.published, a.cid
0.003937 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=246 OR b.cid=246)) GROUP BY a.lid, a.published, a.cid
0.003807 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=247 OR b.cid=247)) GROUP BY a.lid, a.published, a.cid
0.008035 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=248 OR b.cid=248)) GROUP BY a.lid, a.published, a.cid
0.005657 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=249 OR b.cid=249)) GROUP BY a.lid, a.published, a.cid
0.005637 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=250 OR b.cid=250)) GROUP BY a.lid, a.published, a.cid
0.009553 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=251 OR b.cid=251)) GROUP BY a.lid, a.published, a.cid
0.003868 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=252 OR b.cid=252)) GROUP BY a.lid, a.published, a.cid
0.003796 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=253 OR b.cid=253)) GROUP BY a.lid, a.published, a.cid
0.006124 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=254 OR b.cid=254)) GROUP BY a.lid, a.published, a.cid
0.004464 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=255 OR b.cid=255)) GROUP BY a.lid, a.published, a.cid
0.003786 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=256 OR b.cid=256)) GROUP BY a.lid, a.published, a.cid
0.003667 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=257 OR b.cid=257)) GROUP BY a.lid, a.published, a.cid
0.004623 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=258 OR b.cid=258)) GROUP BY a.lid, a.published, a.cid
0.004377 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=259 OR b.cid=259)) GROUP BY a.lid, a.published, a.cid
0.004471 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=260 OR b.cid=260)) GROUP BY a.lid, a.published, a.cid
0.004349 - SELECT a.lid, a.published, a.cid FROM xoopstube_videos a LEFT JOIN xoopstube_altcat b ON b.lid = a.lid WHERE a.published > 0 AND a.published <= 1418728128 AND (a.expired = 0 OR a.expired > 1418728128) AND offline = 0 AND (b.cid=a.cid OR (a.cid=261 OR b.cid=261)) GROUP BY a.lid, a.published, a.cid