Advertisement
jcisio

Untitled

Oct 26th, 2011
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.75 KB | None | 0 0
  1. Executed 894 queries in 23489.18 milliseconds. Queries taking longer than 20 ms and queries executed more than once, are highlighted.
  2. ms#where
  3. query
  4. 1687.291cache_get
  5. SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:admin_menu:tree-data:2cf3a8c6baea4d721d7e6bab8a2ba139'
  6. 645.041_taxonomy_menu_term_count
  7. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 148114)
  8. 644.431locale
  9. SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'fr' WHERE s.source = 'Longitude (If there are multiple locations per node, N is the iteration, starting with 0)' AND s.textgroup = 'default'
  10. 638.211_drupal_lookup_path_direct
  11. SELECT dst FROM url_alias WHERE src = 'taxonomy/term/148111' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  12. 6341cache_get
  13. SELECT data, created, headers, expire, serialized FROM cache_content WHERE cid = 'content_type_info:fr'
  14. 479.11cache_get
  15. SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:tree-data:251ea8a9151345cd06f8be1fad79b923'
  16. 451.721_taxonomy_menu_term_count
  17. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 148528)
  18. 382.941cache_get
  19. SELECT data, created, headers, expire, serialized FROM cache_content WHERE cid = 'fieldgroup_data:fr'
  20. 362.71cache_get
  21. SELECT data, created, headers, expire, serialized FROM cache_views WHERE cid = 'views_data:fr'
  22. 346.061cache_get
  23. SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:campusfrance'
  24. 333.461cache_get
  25. SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'locale:fr'
  26. 226.061flag_get_counts
  27. SELECT f.name, fc.count FROM flags f LEFT JOIN flag_counts fc ON f.fid = fc.fid WHERE fc.content_type = 'node' AND fc.content_id = 908
  28. 224.591_drupal_lookup_path_direct
  29. SELECT dst FROM url_alias WHERE src = 'admin/build/views/edit/fo_liste_noderef_lien_interne' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  30. 222.961cache_get
  31. SELECT data, created, headers, expire, serialized FROM cache_shorten WHERE cid = 'http://www.campusfrance.org/fr/node/908'
  32. 222.785_relatedcontent_localtask_load
  33. SELECT type FROM node WHERE nid = 908
  34. 221.791cache_get
  35. SELECT data, created, headers, expire, serialized FROM cache_views_data WHERE cid = 'fo_liste_noderef_dossier:block_1:output:c6eacecadae370ca34fc39c5e16767c9'
  36. 221.561_drupal_lookup_path_direct
  37. SELECT dst FROM url_alias WHERE src = 'node/1263' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  38. 221.331taxonomy_get_term
  39. SELECT * FROM term_data WHERE tid = 148088
  40. 220.681locale
  41. SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'fr' WHERE s.source = 'Used for advanced javascript work, this will enable the <em>mouseovermarker</em>, <em>mouseoutmarker</em>, and <em>dblclickmarker</em> events.' AND s.textgroup = 'default'
  42. 220.261_nodewords_get_tags_data_query
  43. SELECT * FROM nodewords WHERE type = 5 AND id = 1338
  44. 219.181_node_revision_access
  45. SELECT COUNT(vid) FROM node_revisions WHERE nid = 908
  46. 218.571locale
  47. SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'fr' WHERE s.source = 'Configure what block content appears in your site\'s sidebars and other regions.' AND s.textgroup = 'default'
  48. 218.451locale
  49. SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'fr' WHERE s.source = 'There are currently no style types available to add. You should enable a module that utilizes them, such as Panels.' AND s.textgroup = 'default'
  50. 217.791_drupal_lookup_path_direct
  51. SELECT dst FROM url_alias WHERE src = 'dossiers/all' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  52. 217.61_print_set_node_fields
  53. SELECT link, comments, url_list FROM print_node_conf WHERE nid = 1338
  54. 217.531_drupal_lookup_path_direct
  55. SELECT dst FROM url_alias WHERE src = 'admin/reports/dblog' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  56. 217.281taxonomy_get_term
  57. SELECT * FROM term_data WHERE tid = 148634
  58. 217.251_drupal_lookup_path_direct
  59. SELECT dst FROM url_alias WHERE src = 'rubrique/etudier-en-france' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  60. 217.251ctools_export_load_object
  61. SELECT * FROM page_manager_pages t__0 WHERE name IN ('espace_documentaire')
  62. 216.631_taxonomy_menu_term_count
  63. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 89)
  64. 216.491taxonomy_get_term
  65. SELECT * FROM term_data WHERE tid = 148012
  66. 216.361taxonomy_get_term
  67. SELECT * FROM term_data WHERE tid = 148521
  68. 215.871taxonomy_get_term
  69. SELECT * FROM term_data WHERE tid = 148460
  70. 215.861_taxonomy_menu_get_item
  71. SELECT tid, vid FROM taxonomy_menu WHERE mlid = 18904
  72. 215.71taxonomy_get_term
  73. SELECT * FROM term_data WHERE tid = 57
  74. 215.691privacy_nodeapi
  75. SELECT field_name FROM privacy WHERE nid = 1338
  76. 215.025_relatedcontent_localtask_load
  77. SELECT type FROM node WHERE nid = 908
  78. 214.671_drupal_lookup_path_direct
  79. SELECT dst FROM url_alias WHERE src = 'taxonomy/term/148374' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  80. 214.461_taxonomy_menu_term_count
  81. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 148539)
  82. 214.146_print_set_node_fields
  83. SELECT link, comments, url_list FROM print_node_conf WHERE nid = 908
  84. 213.311taxonomy_get_term
  85. SELECT * FROM term_data WHERE tid = 148563
  86. 212.621_drupal_lookup_path_direct
  87. SELECT dst FROM url_alias WHERE src = 'node/add/ca-catalogue' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  88. 212.111_drupal_lookup_path_direct
  89. SELECT dst FROM url_alias WHERE src = 'node/add/simplenews' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  90. 211.881_taxonomy_menu_get_item
  91. SELECT tid, vid FROM taxonomy_menu WHERE mlid = 26008
  92. 211.881_drupal_lookup_path_direct
  93. SELECT dst FROM url_alias WHERE src = 'node/1265' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  94. 211.751_taxonomy_menu_get_item
  95. SELECT tid, vid FROM taxonomy_menu WHERE mlid = 18434
  96. 210.971_taxonomy_menu_term_count
  97. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 148520)
  98. 2101_drupal_lookup_path_direct
  99. SELECT dst FROM url_alias LIMIT 0, 1
  100. 209.271cache_get
  101. SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'schema'
  102. 124.831_taxonomy_menu_term_count
  103. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 148531)
  104. 111.911_taxonomy_menu_term_count
  105. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 148634)
  106. 110.371_taxonomy_menu_get_item
  107. SELECT tid, vid FROM taxonomy_menu WHERE mlid = 28939
  108. 108.261taxonomy_get_term
  109. SELECT * FROM term_data WHERE tid = 148636
  110. 105.951_taxonomy_menu_term_count
  111. SELECT COUNT(n.nid) AS c FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND t.tid = 148636)
  112. 87.831cache_get
  113. SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:tree-data:0f0ca2ae5a51c5276a22bc50e0a3202c'
  114. 86.631node_load
  115. SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 1338
  116. 62.091taxonomy_node_get_terms
  117. SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 1338 ORDER BY v.weight, t.weight, t.name
  118. 60.071cache_get
  119. SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:tree-data:4e42ccec7c88307d418c7194fa8a023c'
  120. 54.821_taxonomy_menu_get_item
  121. SELECT tid, vid FROM taxonomy_menu WHERE mlid = 18955
  122. 50.461cache_get
  123. SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'context'
  124. 46.811_drupal_lookup_path_direct
  125. SELECT dst FROM url_alias WHERE src = 'node/1266' AND language IN('fr', '') ORDER BY language DESC, pid DESC
  126. 30.21ctools_menu_local_tasks
  127. SELECT * FROM menu_router WHERE tab_root = 'node/%' ORDER BY weight, title
  128. 23.351menu_get_item
  129. SELECT * FROM menu_router WHERE path IN ('node/add/webform','node/add/%','node/%/webform','node/%/%','node/add','node/%','node') ORDER BY fit DESC LIMIT 0, 1
  130. 23.221taxonomy_get_term
  131. SELECT * FROM term_data WHERE tid = 148532
  132. 22.711cache_get
  133. SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:menu-bo-redacteur:tree-data:f575fea494a37e77b8e8a8537384b9d7'
  134. 22.651cache_get
  135. SELECT data, created, headers, expire, serialized FROM cache_views_data WHERE cid = 'fo_liste_noderef_lien_interne:block_1:output:c6eacecadae370ca34fc39c5e16767c9'
  136. 21.421_taxonomy_menu_get_item
  137. SELECT tid, vid FROM taxonomy_menu WHERE mlid = 18954
  138. 20.333cache_get
  139. SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:ab71fa5e18600e1ffd376b83b7492f32'
  140.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement