API tools faq
paste
Advertisement
itachi_jeni

db

itachi_jeni
Sep 27th, 2012
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.94 KB | None | 0 0
raw download clone embed print report
  1. by UGBrazil
  2. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_113` AS t113_1 ON (e.id = t113_1.entry_id) WHERE 1 AND `e`.`section_id` = '13' AND ( t113_1.value REGEXP '' OR t113_1.handle REGEXP '' ) ORDER BY ( SELECT `ed`.value FROM sym_entries_data_36 AS `ed` WHERE entry_id = e.id ) LIMIT 0, 10
  3.  
  4. Backtrace:
  5.  
  6. [/var/www/html/symphony/lib/toolkit/class.mysql.php:463] MySQL->__error();
  7. [/var/www/html/symphony/lib/toolkit/class.mysql.php:609] MySQL->query();
  8. [/var/www/html/symphony/lib/toolkit/class.entrymanager.php:416] MySQL->fetch();
  9. [/var/www/html/symphony/lib/toolkit/class.entrymanager.php:667] EntryManager->fetch();
  10. [/var/www/html/extensions/symql/lib/class.symql.php:277] EntryManager->fetchByPage();
  11. [/var/www/html/workspace/data-sources/data.noticia_especifica_relacionadas.php:68] SymQL::run();
  12. [/var/www/html/symphony/lib/toolkit/class.frontendpage.php:828] datasourcenoticia_especifica_relacionadas->grab();
  13. [/var/www/html/symphony/lib/toolkit/class.frontendpage.php:413] FrontendPage->processDatasources();
  14. [/var/www/html/symphony/lib/toolkit/class.frontendpage.php:202] FrontendPage->__buildPage();
  15. [/var/www/html/symphony/lib/core/class.frontend.php:111] FrontendPage->generate();
  16. [/var/www/html/index.php:25] Frontend->display();
  17.  
  18. Database Query Log:
  19.  
  20. SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'; [0.0002]
  21. SET CHARACTER SET 'utf8'; [0.0001]
  22. SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = 'c488n6bo1cp4najkbo61mmk763' LIMIT 1; [0.0002]
  23. SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled'; [0.0009]
  24. SELECT SQL_CACHE t1.name, t2.page, t2.delegate, t2.callback FROM `sym_extensions` as t1 INNER JOIN `sym_extensions_delegates` as t2 ON t1.id = t2.extension_id WHERE t1.status = 'enabled'; [0.0008]
  25. SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` = 'noticia' AND `handle` = 'sus-e-juventude-serie-de-reportagens-sus-e-juventude' LIMIT 1; [0.0005]
  26. SELECT SQL_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'noticia' LIMIT 1; [0.0006]
  27. SELECT SQL_CACHE `type` FROM `sym_pages_types` WHERE `page_id` = '84'; [0.0003]
  28. SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '13'; [0.0003]
  29. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '36' LIMIT 1; [0.0003]
  30. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '36' LIMIT 1; [0.0003]
  31. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '168' LIMIT 1; [0.0003]
  32. SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` = '168' LIMIT 1; [0.0004]
  33. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_36` AS t36_1 ON (e.id = t36_1.entry_id) LEFT JOIN `sym_entries_data_168` AS t168_1 ON (e.id = t168_1.entry_id) WHERE 1 AND `e`.`section_id` = '13' AND ( t36_1.value IN ('sus-e-juventude-serie-de-reportagens-sus-e-juventude') OR t36_1.handle IN ('sus-e-juventude-serie-de-reportagens-sus-e-juventude') ) AND ( t168_1.value IN ('Publicado') OR t168_1.handle IN ('Publicado') ) ORDER BY `e`.`id`DESC LIMIT 0, 1; [0.0014]
  34. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '39' LIMIT 1; [0.0003]
  35. SELECT SQL_CACHE * FROM `sym_fields_datetime` WHERE `field_id` = '39' LIMIT 1; [0.0003]
  36. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `element_name` = 'views' AND `parent_section` = 13 LIMIT 1; [0.0003]
  37. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '109' LIMIT 1; [0.0003]
  38. SELECT SQL_CACHE * FROM `sym_fields_incrementnumber` WHERE `field_id` = '109' LIMIT 1; [0.0003]
  39. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_168` AS t168_1 ON (e.id = t168_1.entry_id) LEFT JOIN `sym_entries_data_39` AS `t39` ON `e`.`id` = `t39`.entry_id LEFT OUTER JOIN `sym_entries_data_109` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '13' AND ( t168_1.value IN ('Publicado') OR t168_1.handle IN ('Publicado') ) AND (((`t39`.start BETWEEN '1970-01-01 00:00:00' AND '2012-09-27 23:06:00') OR (`t39`.end BETWEEN '1970-01-01 00:00:00' AND '2012-09-27 23:06:00') OR (`t39`.start < '1970-01-01 00:00:00' AND `t39`.end > '2012-09-27 23:06:00'))) ORDER BY `ed`.`value` DESC LIMIT 0, 5; [0.0077]
  40. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 13 AND `element_name` IN ('titulo'); [0.0004]
  41. SELECT SQL_CACHE * FROM `sym_entries_data_36` WHERE `entry_id` IN (2575,324,6083,545,418) ORDER BY `id` ASC; [0.0004]
  42. SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '24'; [0.0003]
  43. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '170' LIMIT 1; [0.0003]
  44. SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '170' LIMIT 1; [0.0003]
  45. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_170` AS t170_1 ON (e.id = t170_1.entry_id) WHERE 1 AND `e`.`section_id` = '24' AND ( t170_1.value IN ('no') OR t170_1.value IS NULL ) ORDER BY RAND() LIMIT 0, 1; [0.0006]
  46. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 24 AND `element_name` IN ('titulo', 'link', 'imagem'); [0.0003]
  47. SELECT SQL_CACHE * FROM `sym_entries_data_82` WHERE `entry_id` IN (8557) ORDER BY `id` ASC; [0.0003]
  48. SELECT SQL_CACHE * FROM `sym_entries_data_83` WHERE `entry_id` IN (8557) ORDER BY `id` ASC; [0.0003]
  49. SELECT SQL_CACHE * FROM `sym_entries_data_84` WHERE `entry_id` IN (8557) ORDER BY `id` ASC; [0.0002]
  50. SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_170` AS t170_1 ON (e.id = t170_1.entry_id) WHERE `e`.`section_id` = '24' AND ( t170_1.value IN ('no') OR t170_1.value IS NULL ); [0.0001]
  51. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '82' LIMIT 1; [0.0002]
  52. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '82' LIMIT 1; [0.0001]
  53. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '84' LIMIT 1; [0.0002]
  54. SELECT SQL_CACHE * FROM `sym_fields_uniqueupload` WHERE `field_id` = '84' LIMIT 1; [0.0002]
  55. SELECT SQL_CACHE DISTINCT p.* FROM `sym_pages` AS p LEFT JOIN `sym_pages_types` AS pt ON (p.id = pt.page_id) WHERE 1 = 1 AND p.parent IS NULL ORDER BY p.`sortorder` ASC; [0.0007]
  56. SELECT SQL_CACHE `page_id`,`type` FROM `sym_pages_types`; [0.0002]
  57. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '64' ORDER BY `sortorder` ASC; [0.0001]
  58. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '77' ORDER BY `sortorder` ASC; [0.0002]
  59. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '78' ORDER BY `sortorder` ASC; [0.0001]
  60. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '125' ORDER BY `sortorder` ASC; [0.0001]
  61. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '79' ORDER BY `sortorder` ASC; [0.0002]
  62. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '80' ORDER BY `sortorder` ASC; [0.0001]
  63. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '81' ORDER BY `sortorder` ASC; [0.0002]
  64. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '82' ORDER BY `sortorder` ASC; [0.0002]
  65. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '75' ORDER BY `sortorder` ASC; [0.0002]
  66. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '76' ORDER BY `sortorder` ASC; [0.0001]
  67. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '83' ORDER BY `sortorder` ASC; [0.0002]
  68. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '112' ORDER BY `sortorder` ASC; [0.0002]
  69. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '126' ORDER BY `sortorder` ASC; [0.0001]
  70. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '110' ORDER BY `sortorder` ASC; [0.0001]
  71. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '84' ORDER BY `sortorder` ASC; [0.0001]
  72. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '85' ORDER BY `sortorder` ASC; [0.0002]
  73. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '115' ORDER BY `sortorder` ASC; [0.0001]
  74. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '86' ORDER BY `sortorder` ASC; [0.0002]
  75. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '87' ORDER BY `sortorder` ASC; [0.0002]
  76. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '88' ORDER BY `sortorder` ASC; [0.0002]
  77. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '89' ORDER BY `sortorder` ASC; [0.0002]
  78. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '90' ORDER BY `sortorder` ASC; [0.0001]
  79. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '91' ORDER BY `sortorder` ASC; [0.0001]
  80. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '92' ORDER BY `sortorder` ASC; [0.0001]
  81. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '93' ORDER BY `sortorder` ASC; [0.0001]
  82. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '94' ORDER BY `sortorder` ASC; [0.0002]
  83. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '95' ORDER BY `sortorder` ASC; [0.0001]
  84. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '96' ORDER BY `sortorder` ASC; [0.0001]
  85. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '98' ORDER BY `sortorder` ASC; [0.0002]
  86. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '99' ORDER BY `sortorder` ASC; [0.0002]
  87. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '100' ORDER BY `sortorder` ASC; [0.0002]
  88. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '97' ORDER BY `sortorder` ASC; [0.0002]
  89. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '101' ORDER BY `sortorder` ASC; [0.0002]
  90. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '102' ORDER BY `sortorder` ASC; [0.0001]
  91. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '103' ORDER BY `sortorder` ASC; [0.0002]
  92. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '104' ORDER BY `sortorder` ASC; [0.0001]
  93. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '105' ORDER BY `sortorder` ASC; [0.0001]
  94. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '107' ORDER BY `sortorder` ASC; [0.0001]
  95. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '108' ORDER BY `sortorder` ASC; [0.0001]
  96. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '109' ORDER BY `sortorder` ASC; [0.0001]
  97. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '123' ORDER BY `sortorder` ASC; [0.0001]
  98. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '106' ORDER BY `sortorder` ASC; [0.0002]
  99. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '117' ORDER BY `sortorder` ASC; [0.0002]
  100. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '120' ORDER BY `sortorder` ASC; [0.0002]
  101. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '116' ORDER BY `sortorder` ASC; [0.0002]
  102. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '118' ORDER BY `sortorder` ASC; [0.0002]
  103. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '119' ORDER BY `sortorder` ASC; [0.0002]
  104. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '121' ORDER BY `sortorder` ASC; [0.0002]
  105. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '122' ORDER BY `sortorder` ASC; [0.0002]
  106. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '124' ORDER BY `sortorder` ASC; [0.0002]
  107. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '127' ORDER BY `sortorder` ASC; [0.0002]
  108. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '128' ORDER BY `sortorder` ASC; [0.0002]
  109. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '129' ORDER BY `sortorder` ASC; [0.0002]
  110. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '130' ORDER BY `sortorder` ASC; [0.0001]
  111. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '131' ORDER BY `sortorder` ASC; [0.0002]
  112. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '132' ORDER BY `sortorder` ASC; [0.0001]
  113. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '133' ORDER BY `sortorder` ASC; [0.0001]
  114. SELECT SQL_CACHE * FROM `sym_pages` WHERE `parent` = '134' ORDER BY `sortorder` ASC; [0.0002]
  115. SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '8'; [0.0002]
  116. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `element_name` = 'ordem' AND `parent_section` = 8 LIMIT 1; [0.0001]
  117. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '166' LIMIT 1; [0.0002]
  118. SELECT SQL_CACHE * FROM `sym_fields_order_entries` WHERE `field_id` = '166' LIMIT 1; [0.0002]
  119. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT OUTER JOIN `sym_entries_data_166` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '8' ORDER BY `ed`.`value` ASC; [0.0002]
  120. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 8 AND `element_name` IN ('titulo'); [0.0002]
  121. SELECT SQL_CACHE * FROM `sym_entries_data_25` WHERE `entry_id` IN (8,7) ORDER BY `id` ASC; [0.0002]
  122. SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` WHERE `e`.`section_id` = '8'; [0.0002]
  123. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '25' LIMIT 1; [0.0002]
  124. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '25' LIMIT 1; [0.0002]
  125. SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '14'; [0.0002]
  126. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `element_name` = 'ordem' AND `parent_section` = 14 LIMIT 1; [0.0002]
  127. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '165' LIMIT 1; [0.0002]
  128. SELECT SQL_CACHE * FROM `sym_fields_order_entries` WHERE `field_id` = '165' LIMIT 1; [0.0002]
  129. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT OUTER JOIN `sym_entries_data_165` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '14' ORDER BY `ed`.`value` ASC; [0.0002]
  130. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 14 AND `element_name` IN ('titulo'); [0.0001]
  131. SELECT SQL_CACHE * FROM `sym_entries_data_48` WHERE `entry_id` IN (24,23,25,26,27,28) ORDER BY `id` ASC; [0.0002]
  132. SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` WHERE `e`.`section_id` = '14'; [0.0001]
  133. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '48' LIMIT 1; [0.0002]
  134. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '48' LIMIT 1; [0.0001]
  135. SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '19'; [0.0002]
  136. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `element_name` = 'ordem' AND `parent_section` = 19 LIMIT 1; [0.0002]
  137. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '164' LIMIT 1; [0.0002]
  138. SELECT SQL_CACHE * FROM `sym_fields_order_entries` WHERE `field_id` = '164' LIMIT 1; [0.0002]
  139. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT OUTER JOIN `sym_entries_data_164` AS `ed` ON (`e`.`id` = `ed`.`entry_id`) WHERE 1 AND `e`.`section_id` = '19' ORDER BY `ed`.`value` ASC; [0.0002]
  140. SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 19 AND `element_name` IN ('link', 'titulo'); [0.0001]
  141. SELECT SQL_CACHE * FROM `sym_entries_data_71` WHERE `entry_id` IN (40,41,42,43,44,45,46,39,47,48,49,50,51,52,3155) ORDER BY `id` ASC; [0.0002]
  142. SELECT SQL_CACHE * FROM `sym_entries_data_72` WHERE `entry_id` IN (40,41,42,43,44,45,46,39,47,48,49,50,51,52,3155) ORDER BY `id` ASC; [0.0002]
  143. SELECT SQL_CACHE count(`e`.id) as `count` FROM `sym_entries` AS `e` WHERE `e`.`section_id` = '19'; [0.0001]
  144. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '71' LIMIT 1; [0.0002]
  145. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '71' LIMIT 1; [0.0002]
  146. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '72' LIMIT 1; [0.0002]
  147. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '72' LIMIT 1; [0.0002]
  148. SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'noticias' LIMIT 1; [0.0002]
  149. SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '13' ORDER BY t1.`sortorder` ASC; [0.0004]
  150. SELECT SQL_CACHE * FROM `sym_fields_publish_tabs` WHERE `field_id` = '34' LIMIT 1; [0.0002]
  151. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '37' LIMIT 1; [0.0001]
  152. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '40' LIMIT 1; [0.0001]
  153. SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '41' LIMIT 1; [0.0002]
  154. SELECT SQL_CACHE * FROM `sym_fields_uniquecheckbox` WHERE `field_id` = '151' LIMIT 1; [0.0002]
  155. SELECT SQL_CACHE * FROM `sym_fields_uniquecheckbox` WHERE `field_id` = '44' LIMIT 1; [0.0002]
  156. SELECT SQL_CACHE * FROM `sym_fields_uniquecheckbox` WHERE `field_id` = '172' LIMIT 1; [0.0002]
  157. SELECT SQL_CACHE * FROM `sym_fields_uniquecheckbox` WHERE `field_id` = '173' LIMIT 1; [0.0002]
  158. SELECT SQL_CACHE * FROM `sym_fields_uniquecheckbox` WHERE `field_id` = '174' LIMIT 1; [0.0002]
  159. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '46' LIMIT 1; [0.0002]
  160. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '47' LIMIT 1; [0.0002]
  161. SELECT SQL_CACHE * FROM `sym_fields_preview` WHERE `field_id` = '175' LIMIT 1; [0.0002]
  162. SELECT SQL_CACHE * FROM `sym_fields_enhancedtaglist` WHERE `field_id` = '113' LIMIT 1; [0.0003]
  163. SELECT SQL_CACHE * FROM `sym_fields_publish_tabs` WHERE `field_id` = '35' LIMIT 1; [0.0002]
  164. SELECT SQL_CACHE * FROM `sym_fields_uniqueupload` WHERE `field_id` = '42' LIMIT 1; [0.0002]
  165. SELECT SQL_CACHE * FROM `sym_fields_imagecropper` WHERE `field_id` = '43' LIMIT 1; [0.0002]
  166. SELECT SQL_CACHE * FROM `sym_fields_publish_tabs` WHERE `field_id` = '114' LIMIT 1; [0.0001]
  167. SELECT SQL_CACHE * FROM `sym_fields_uniqueupload` WHERE `field_id` = '115' LIMIT 1; [0.0002]
  168. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '116' LIMIT 1; [0.0001]
  169. SELECT SQL_CACHE * FROM `sym_fields_uniqueupload` WHERE `field_id` = '117' LIMIT 1; [0.0001]
  170. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '118' LIMIT 1; [0.0001]
  171. SELECT SQL_CACHE * FROM `sym_fields_uniqueupload` WHERE `field_id` = '119' LIMIT 1; [0.0002]
  172. SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '120' LIMIT 1; [0.0002]
  173. SELECT SQL_CACHE `e`.id, `e`.section_id, e.`author_id`, UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date` FROM `sym_entries` AS `e` LEFT JOIN `sym_entries_data_113` AS t113_1 ON (e.id = t113_1.entry_id) WHERE 1 AND `e`.`section_id` = '13' AND ( t113_1.value REGEXP '' OR t113_1.handle REGEXP '' ) ORDER BY ( SELECT `ed`.value FROM sym_entries_data_36 AS `ed` WHERE entry_id = e.id ) LIMIT 0, 10; [0.0000]
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!