Advertisement
JKNN

with all

May 24th, 2019
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.18 KB | None | 0 0
  1. WITH ALL: 15,40S 147.716kB 6,0967S 961Q
  2.  
  3. SLOW QUERIES:
  4. Query Caller Time
  5. SELECT option_value
  6. FROM wp_options
  7. WHERE option_name = '_transient_timeout_wpml_st_upgrade_in_progress'
  8. LIMIT 1
  9. +
  10. get_option
  11. 0,1323
  12. 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
  13. FROM wp_icl_string_pages sp
  14. INNER JOIN wp_icl_string_urls su
  15. ON su.id = sp.url_id
  16. INNER JOIN wp_icl_strings s
  17. ON s.id = sp.string_id
  18. LEFT JOIN wp_icl_string_translations st
  19. ON s.id=st.string_id
  20. AND st.language=su.language
  21. AND s.language!=su.language
  22. WHERE (su.language='da' and su.url='/') or (su.language='da' and su.url IS NULL)
  23. +
  24. WPML_ST_Page_Translations_Persist->get_translations_for_page
  25. 0,0628
  26. SELECT t.*, tt.*
  27. FROM wp_terms AS t
  28. INNER JOIN wp_term_taxonomy AS tt
  29. ON t.term_id = tt.term_id
  30. LEFT JOIN wp_icl_translations icl_t
  31. ON icl_t.element_id = tt.term_taxonomy_id
  32. AND icl_t.element_type IN ('tax_product_shipping_class')
  33. WHERE tt.taxonomy IN ('product_shipping_class')
  34. AND ( ( icl_t.element_type IN ('tax_product_shipping_class')
  35. AND ( icl_t.language_code = 'da'
  36. OR 0 ) )
  37. OR icl_t.element_type NOT IN ('tax_product_shipping_class')
  38. OR icl_t.element_type IS NULL )
  39. ORDER BY t.name ASC
  40. +
  41. WP_Term_Query->get_terms
  42. 0,0943
  43. SELECT option_value
  44. FROM wp_options
  45. WHERE option_name = 'woocommerce_pakkelabels_shipping_gls_business_settings'
  46. LIMIT 1
  47. +
  48. get_option
  49. 0,1894
  50. SELECT post_id, meta_key, meta_value
  51. FROM wp_postmeta
  52. WHERE post_id IN (55744)
  53. ORDER BY meta_id ASC
  54. +
  55. update_meta_cache
  56. 0,0794
  57. SELECT t.term_id, tt.parent, tt.count, t.name, tt.taxonomy
  58. FROM wp_terms AS t
  59. INNER JOIN wp_term_taxonomy AS tt
  60. ON t.term_id = tt.term_id
  61. INNER JOIN wp_term_relationships AS tr
  62. ON tr.term_taxonomy_id = tt.term_taxonomy_id
  63. WHERE tt.taxonomy IN ('action-group')
  64. AND tr.object_id IN (55744)
  65. ORDER BY t.name ASC
  66. +
  67. WP_Term_Query->get_terms
  68. 0,0521
  69. SELECT location_code, location_type
  70. FROM wp_woocommerce_shipping_zone_locations
  71. WHERE zone_id = 11
  72. +
  73. WC_Shipping_Zone_Data_Store->read_zone_locations
  74. 0,1916
  75. SELECT location_code, location_type
  76. FROM wp_woocommerce_shipping_zone_locations
  77. WHERE zone_id = 12
  78. +
  79. WC_Shipping_Zone_Data_Store->read_zone_locations
  80. 0,1463
  81. SELECT zone_name, zone_order
  82. FROM wp_woocommerce_shipping_zones
  83. WHERE zone_id = 13
  84. LIMIT 1
  85. +
  86. WC_Shipping_Zone_Data_Store->read
  87. 0,1918
  88. SELECT method_id, method_order, instance_id, is_enabled
  89. FROM wp_woocommerce_shipping_zone_methods
  90. WHERE zone_id = 6
  91. +
  92. WC_Shipping_Zone_Data_Store->get_methods
  93. 0,1118
  94. SELECT method_id, method_order, instance_id, is_enabled
  95. FROM wp_woocommerce_shipping_zone_methods
  96. WHERE zone_id = 14
  97. +
  98. WC_Shipping_Zone_Data_Store->get_methods
  99. 0,1867
  100. SELECT method_id, method_order, instance_id, is_enabled
  101. FROM wp_woocommerce_shipping_zone_methods
  102. WHERE zone_id = 11
  103. +
  104. WC_Shipping_Zone_Data_Store->get_methods
  105. 0,0653
  106. SELECT method_id, method_order, instance_id, is_enabled
  107. FROM wp_woocommerce_shipping_zone_methods
  108. WHERE zone_id = 14
  109. +
  110. WC_Shipping_Zone_Data_Store->get_methods
  111. 0,2151
  112. SELECT method_id, method_order, instance_id, is_enabled
  113. FROM wp_woocommerce_shipping_zone_methods
  114. WHERE zone_id = 8
  115. +
  116. WC_Shipping_Zone_Data_Store->get_methods
  117. 0,2688
  118. SELECT method_id, method_order, instance_id, is_enabled
  119. FROM wp_woocommerce_shipping_zone_methods
  120. WHERE zone_id = 16
  121. +
  122. WC_Shipping_Zone_Data_Store->get_methods
  123. 0,2128
  124. SELECT method_id, method_order, instance_id, is_enabled
  125. FROM wp_woocommerce_shipping_zone_methods
  126. WHERE zone_id = 17
  127. +
  128. WC_Shipping_Zone_Data_Store->get_methods
  129. 0,2731
  130. SELECT method_id, method_order, instance_id, is_enabled
  131. FROM wp_woocommerce_shipping_zone_methods
  132. WHERE zone_id = 0
  133. +
  134. WC_Shipping_Zone_Data_Store->get_methods
  135. 0,0747
  136. SELECT method_id, method_order, instance_id, is_enabled
  137. FROM wp_woocommerce_shipping_zone_methods
  138. WHERE zone_id = 8
  139. +
  140. WC_Shipping_Zone_Data_Store->get_methods
  141. 0,3761
  142. SELECT method_id, method_order, instance_id, is_enabled
  143. FROM wp_woocommerce_shipping_zone_methods
  144. WHERE zone_id = 12
  145. +
  146. WC_Shipping_Zone_Data_Store->get_methods
  147. 0,0619
  148. SELECT *
  149. FROM wp_posts
  150. WHERE ID = 3662
  151. LIMIT 1
  152. +
  153. WP_Post::get_instance
  154. 0,1362
  155. SELECT t.*, tt.*
  156. FROM wp_terms AS t
  157. INNER JOIN wp_term_taxonomy AS tt
  158. ON t.term_id = tt.term_id
  159. INNER JOIN wp_term_relationships AS tr
  160. ON tr.term_taxonomy_id = tt.term_taxonomy_id
  161. WHERE tt.taxonomy IN ('product_visibility')
  162. AND tr.object_id IN (55481)
  163. ORDER BY t.name ASC
  164. +
  165. WP_Term_Query->get_terms
  166. 0,0603
  167. SELECT id
  168. FROM wp_icl_strings
  169. WHERE BINARY value='wc-api'
  170. AND context='WP Endpoints'
  171. AND name = 'wc-api'
  172. LIMIT 1
  173. +
  174. WPML_ST_String_Factory->get_string_id
  175. 0,0647
  176. SELECT wpml_translations.translation_id, wpml_translations.element_id, wpml_translations.language_code, wpml_translations.source_language_code, wpml_translations.trid, wpml_translations.element_type
  177. FROM wp_icl_translations wpml_translations JOIN wp_term_taxonomy tax
  178. ON wpml_translations.element_id = tax.term_taxonomy_id
  179. AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN wp_icl_translations tridt
  180. ON tridt.element_type = wpml_translations.element_type
  181. AND tridt.trid = wpml_translations.trid
  182. WHERE tridt.trid = (SELECT trid
  183. FROM wp_icl_translations wpml_translations JOIN wp_term_taxonomy tax
  184. ON wpml_translations.element_id = tax.term_taxonomy_id
  185. AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy)
  186. WHERE element_id = 489
  187. LIMIT 1)
  188. +
  189. WPML_Element_Translation->maybe_populate_cache
  190. 0,0808
  191. SELECT *
  192. FROM wp_posts
  193. WHERE ID = 34856
  194. LIMIT 1
  195. +
  196. WP_Post::get_instance
  197. 0,0772
  198. SELECT wp_posts.ID
  199. FROM wp_posts JOIN wp_icl_translations wpml_translations
  200. ON wp_posts.ID = wpml_translations.element_id
  201. AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
  202. WHERE 1=1
  203. AND wp_posts.post_type = 'post'
  204. AND ((wp_posts.post_status = 'publish'))
  205. AND ( ( ( wpml_translations.language_code = 'da'
  206. OR 0 )
  207. AND wp_posts.post_type IN ('post','page','attachment','product','product_variation','mc4wp-form' ) )
  208. OR wp_posts.post_type NOT IN ('post','page','attachment','product','product_variation','mc4wp-form' ) )
  209. ORDER BY wp_posts.post_date DESC
  210. LIMIT 0, 5
  211. +
  212. WP_Query->get_posts
  213. 0,1326
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement