Projets : Différence entre versions

De fablabo
Aller à : navigation, rechercher
Ligne 1 : Ligne 1 :
ici les Projets développés dans et autour du thème du fablab
 
 
 
 
 
 
 
{{#ask:[[Category:Projets]]
 
{{#ask:[[Category:Projets]]
  | limit=30
+
  | limit=100
 
  | sort=Date de modification
 
  | sort=Date de modification
 
  | order=descending
 
  | order=descending
Ligne 12 : Ligne 6 :
 
  | ?Description
 
  | ?Description
 
  | ?Image
 
  | ?Image
  |format=debug |template=ListeProjets |headers=hide |link=all |offset= }}
+
  |format=debug  }}

Version du 24 octobre 2014 à 15:49

Debug Output by SQLStore

Ask query

[[Catégorie:Projets]]

SQL Query

SELECT DISTINCT
  t2.smw_id AS id,t2.smw_title AS t,t2.smw_namespace AS ns,t2.smw_iw AS iw,t2.smw_subobject AS so,t2.smw_sortkey AS sortkey , t4.o_sortkey
FROM
  `mw_smw_object_ids` AS t2
INNER JOIN
  `mw_smw_fpt_inst` AS t0 ON t2.smw_id=t0.s_id
INNER JOIN
  `mw_t1` AS t1 ON t0.o_id=t1.id
INNER JOIN
  `mw_smw_fpt_mdat` AS t4 ON t2.smw_id=t4.s_id
WHERE
  t2.smw_iw!=':smw' AND t2.smw_iw!=':smw-delete' AND t2.smw_iw!=':smw-redi'
ORDER BY
  t4.o_sortkey DESC
LIMIT
  105
OFFSET
  0

SQL Explain

IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt1ALLPRIMARY2Using temporary; Using filesort
1SIMPLEt0refs_id,o_ido_id5fablabo.t1.id9
1SIMPLEt4refs_ids_id4fablabo.t0.s_id1
1SIMPLEt2eq_refPRIMARY,smw_id,smw_iwPRIMARY4fablabo.t0.s_id1Using where

Auxilliary Tables Used

  • Temporary table t1
      Recursively computed hierarchy for element(s) ('137').

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None