Advertisement
Guest User

Untitled

a guest
Apr 2nd, 2019
30
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.59 KB | None | 0 0
  1. 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
  2. FROM lw2null_icl_string_pages sp
  3. INNER JOIN lw2null_icl_string_urls su
  4. ON su.id = sp.url_id
  5. INNER JOIN lw2null_icl_strings s
  6. ON s.id = sp.string_id
  7. LEFT JOIN lw2null_icl_string_translations st
  8. ON s.id=st.string_id
  9. AND st.language=su.language
  10. AND s.language!=su.language
  11. WHERE (su.language='fr' and su.url='/fr/') or (su.language='fr' and su.url IS NULL)
  12. +
  13. WPML_ST_Page_Translations_Persist->get_translations_for_page
  14. 0,0904
  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
  16. FROM lw2null_icl_strings s
  17. LEFT JOIN lw2null_icl_string_translations st
  18. ON s.id=st.string_id
  19. AND st.language='fr'
  20. AND s.language!='fr'
  21. WHERE s.context = 'wpml-translation-management'
  22. LIMIT 1000 OFFSET 0
  23. +
  24. WPML_DB_Chunk->retrieve
  25. 0,0623
  26. 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
  27. FROM lw2null_icl_strings s
  28. LEFT JOIN lw2null_icl_string_translations st
  29. ON s.id=st.string_id
  30. AND st.language='fr'
  31. AND s.language!='fr'
  32. WHERE s.context = 'storefront-child-theme-master'
  33. LIMIT 1000 OFFSET 0
  34. +
  35. WPML_DB_Chunk->retrieve
  36. 0,0519
  37. 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
  38. FROM lw2null_icl_strings s
  39. LEFT JOIN lw2null_icl_string_translations st
  40. ON s.id=st.string_id
  41. AND st.language='fr'
  42. AND s.language!='fr'
  43. WHERE s.context = 'default'
  44. LIMIT 1000 OFFSET 1000
  45. +
  46. WPML_DB_Chunk->retrieve
  47. 0,0932
  48. 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
  49. FROM lw2null_icl_strings s
  50. LEFT JOIN lw2null_icl_string_translations st
  51. ON s.id=st.string_id
  52. AND st.language='fr'
  53. AND s.language!='fr'
  54. WHERE s.context = 'default'
  55. LIMIT 1000 OFFSET 2000
  56. +
  57. WPML_DB_Chunk->retrieve
  58. 0,1301
  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
  60. FROM lw2null_icl_strings s
  61. LEFT JOIN lw2null_icl_string_translations st
  62. ON s.id=st.string_id
  63. AND st.language='fr'
  64. AND s.language!='fr'
  65. WHERE s.context = 'default'
  66. LIMIT 1000 OFFSET 3000
  67. +
  68. WPML_DB_Chunk->retrieve
  69. 0,1968
  70. 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
  71. FROM lw2null_icl_strings s
  72. LEFT JOIN lw2null_icl_string_translations st
  73. ON s.id=st.string_id
  74. AND st.language='fr'
  75. AND s.language!='fr'
  76. WHERE s.context = 'default'
  77. LIMIT 1000 OFFSET 4000
  78. +
  79. WPML_DB_Chunk->retrieve
  80. 0,1678
  81. 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
  82. FROM lw2null_icl_strings s
  83. LEFT JOIN lw2null_icl_string_translations st
  84. ON s.id=st.string_id
  85. AND st.language='fr'
  86. AND s.language!='fr'
  87. WHERE s.context = 'default'
  88. LIMIT 1000 OFFSET 5000
  89. +
  90. WPML_DB_Chunk->retrieve
  91. 0,1847
  92. 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
  93. FROM lw2null_icl_strings s
  94. LEFT JOIN lw2null_icl_string_translations st
  95. ON s.id=st.string_id
  96. AND st.language='fr'
  97. AND s.language!='fr'
  98. WHERE s.context = 'default'
  99. LIMIT 1000 OFFSET 6000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement