API tools faq
paste
Advertisement
Guest User

WPML slowing down

a guest
Feb 20th, 2019
20
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.56 KB | None | 0 0
raw download clone embed print report
  1. Time: 29.6ms (0.029634952545166s)
  2. Query:
  3. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'et_builder' LIMIT 1000 OFFSET 1000
  4. Function: WPML_DB_Chunk->retrieve()
  5. Time: 17.6ms (0.017645120620728s)
  6. Query:
  7. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'et_builder' LIMIT 1000 OFFSET 0
  8. Function: WPML_DB_Chunk->retrieve()
  9. Time: 22.4ms (0.022382974624634s)
  10. Query:
  11. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'duplicate-page' LIMIT 1000 OFFSET 0
  12. Function: WPML_DB_Chunk->retrieve()
  13. Time: 39.3ms (0.039297819137573s)
  14. Query:
  15. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'divi' LIMIT 1000 OFFSET 0
  16. Function: WPML_DB_Chunk->retrieve()
  17. Time: 25.4ms (0.025434970855713s)
  18. Query:
  19. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'default' LIMIT 1000 OFFSET 6000
  20. Function: WPML_DB_Chunk->retrieve()
  21. Time: 22.1ms (0.022052764892578s)
  22. Query:
  23. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'default' LIMIT 1000 OFFSET 5000
  24. Function: WPML_DB_Chunk->retrieve()
  25. Time: 15.7ms (0.015704870223999s)
  26. Query:
  27. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'default' LIMIT 1000 OFFSET 4000
  28. Function: WPML_DB_Chunk->retrieve()
  29. Time: 14.3ms (0.014283180236816s)
  30. Query:
  31. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'default' LIMIT 1000 OFFSET 3000
  32. Function: WPML_DB_Chunk->retrieve()
  33. Time: 12.8ms (0.012809038162231s)
  34. Query:
  35. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'default' LIMIT 1000 OFFSET 2000
  36. Function: WPML_DB_Chunk->retrieve()
  37. Time: 8.1ms (0.0080618858337402s)
  38. Query:
  39. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'default' LIMIT 1000 OFFSET 1000
  40. Function: WPML_DB_Chunk->retrieve()
  41. Time: 6.6ms (0.0065901279449463s)
  42. Query:
  43. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'default' LIMIT 1000 OFFSET 0
  44. Function: WPML_DB_Chunk->retrieve()
  45. Time: 23.2ms (0.023181200027466s)
  46. Query:
  47. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'debug_objects' LIMIT 1000 OFFSET 0
  48. Function: WPML_DB_Chunk->retrieve()
  49. Time: 35.0ms (0.034967184066772s)
  50. Query:
  51. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'custom_module' LIMIT 1000 OFFSET 0
  52. Function: WPML_DB_Chunk->retrieve()
  53. Time: 22.2ms (0.022166967391968s)
  54. Query:
  55. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'avocado' LIMIT 1000 OFFSET 0
  56. Function: WPML_DB_Chunk->retrieve()
  57. Time: 38.5ms (0.038539171218872s)
  58. Query:
  59. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'admin_texts_sb_instagram_settings' LIMIT 1000 OFFSET 0
  60. Function: WPML_DB_Chunk->retrieve()
  61. Time: 38.9ms (0.038911104202271s)
  62. Query:
  63. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'WPML' LIMIT 1000 OFFSET 0
  64. Function: WPML_DB_Chunk->retrieve()
  65. Time: 39.5ms (0.039515018463135s)
  66. Query:
  67. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'Divi' LIMIT 1000 OFFSET 0
  68. Function: WPML_DB_Chunk->retrieve()
  69. Time: 0.5ms (0.00049996376037598s)
  70. Query:
  71. SELECT wpml_translations.translation_id, wpml_translations.language_code, wpml_translations.element_id, wpml_translations.source_language_code, wpml_translations.element_type, NULLIF(wpml_translations.source_language_code, '') IS NULL AS original , tm.name, tm.term_id, COUNT(tr.object_id) AS instances FROM wp_icl_translations wpml_translations LEFT JOIN wp_term_taxonomy tt ON wpml_translations.element_id=tt.term_taxonomy_id LEFT JOIN wp_terms tm ON tt.term_id = tm.term_id LEFT JOIN wp_term_relationships tr ON tr.term_taxonomy_id=tt.term_taxonomy_id WHERE 1 AND wpml_translations.trid=3110 GROUP BY tm.term_id
  72. Function: WPML_Translations->get_translations()
  73. Time: 0.5ms (0.00050497055053711s)
  74. Query:
  75. SELECT wpml_translations.translation_id, wpml_translations.language_code, wpml_translations.element_id, wpml_translations.source_language_code, wpml_translations.element_type, NULLIF(wpml_translations.source_language_code, '') IS NULL AS original , p.post_title, p.post_status FROM wp_icl_translations wpml_translations LEFT JOIN wp_posts p ON wpml_translations.element_id=p.ID WHERE 1 AND (p.post_status IN ('publish', 'draft', 'private', 'pending' )) AND wpml_translations.trid=201
  76. Function: WPML_Translations->get_translations()
  77. Time: 0.7ms (0.00066709518432617s)
  78. Query:
  79. SELECT ID FROM wp_posts p JOIN wp_icl_translations wpml_translations ON p.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', p.post_type ) WHERE p.post_type = 'page' AND p.post_name = 'about-us' ORDER BY p.post_parent = 0 DESC
  80. Function: WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB()
  81. Time: 99.6ms (0.099621057510376s)
  82. Query:
  83. SELECT DISTINCT s.id, s.name, s.context, st.status, s.gettext_context, st.value AS tra, st.mo_string AS mo_string, s.value AS orig FROM wp_icl_string_pages sp INNER JOIN wp_icl_string_urls su ON su.id = sp.url_id INNER JOIN wp_icl_strings s ON s.id = sp.string_id LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language=su.language AND s.language!=su.language WHERE (su.language='en' and su.url='(.?.+?)(?:/([0-9]+))?/?$') or (su.language='en' and su.url IS NULL)
  84. Function: WPML_ST_Page_Translations_Persist->get_translations_for_page()
  85. Time: 9.3ms (0.0093421936035156s)
  86. Query:
  87. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'wpml-translation-management'
  88. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  89. Time: 8.7ms (0.0087430477142334s)
  90. Query:
  91. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'wp-super-cache'
  92. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  93. Time: 9.3ms (0.0092999935150146s)
  94. Query:
  95. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'wordpress-seo'
  96. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  97. Time: 13.9ms (0.013863086700439s)
  98. Query:
  99. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'mapplic'
  100. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  101. Time: 8.7ms (0.0087080001831055s)
  102. Query:
  103. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'et_core'
  104. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  105. Time: 14.8ms (0.014755964279175s)
  106. Query:
  107. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'et_builder'
  108. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  109. Time: 8.8ms (0.008814811706543s)
  110. Query:
  111. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'duplicate-page'
  112. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  113. Time: 14.2ms (0.014249801635742s)
  114. Query:
  115. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'divi'
  116. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  117. Time: 15.0ms (0.015044927597046s)
  118. Query:
  119. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'default'
  120. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  121. Time: 9.0ms (0.0089700222015381s)
  122. Query:
  123. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'debug_objects'
  124. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  125. Time: 13.4ms (0.013365983963013s)
  126. Query:
  127. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'custom_module'
  128. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  129. Time: 8.4ms (0.0083928108215332s)
  130. Query:
  131. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'avocado'
  132. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  133. Time: 13.9ms (0.013880014419556s)
  134. Query:
  135. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'admin_texts_sb_instagram_settings'
  136. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  137. Time: 14.2ms (0.014206886291504s)
  138. Query:
  139. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'WPML'
  140. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  141. Time: 14.3ms (0.014265060424805s)
  142. Query:
  143. SELECT COUNT(id) FROM wp_icl_strings WHERE context = 'Divi'
  144. Function: WPML_ST_DB_Translation_Retrieve->get_number_of_strings_in_context()
  145. Time: 23.0ms (0.022962093353271s)
  146. Query:
  147. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'wp-super-cache' LIMIT 1000 OFFSET 0
  148. Function: WPML_DB_Chunk->retrieve()
  149. Time: 22.5ms (0.022526979446411s)
  150. Query:
  151. SELECT s.id, st.status, s.domain_name_context_md5 AS ctx , st.value AS translated, st.mo_string AS mo_string, s.value AS original, s.gettext_context FROM wp_icl_strings s LEFT JOIN wp_icl_string_translations st ON s.id=st.string_id AND st.language='en' AND s.language!='en' WHERE s.context = 'et_core' LIMIT 1000 OFFSET 0
  152. Function: WPML_DB_Chunk->retrieve()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!