Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.70 KB | None | 0 0
  1. | 2249979 | ssd | localhost | ssd2 | Query | 0 | preparing | SELECT DISTINCT
  2. BS.*,
  3. B.LIST_PAGE_URL,
  4. B.SECTION_PAGE_URL,
  5. B.IBLOCK_TYPE_ID,
  6. B.CODE as IBLOCK_CODE,
  7. B.XML_ID as IBLOCK_EXTERNAL_ID,
  8. BS.XML_ID as EXTERNAL_ID,
  9. DATE_FORMAT(BS.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,
  10. DATE_FORMAT(BS.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE
  11. ,COUNT(DISTINCT BE.ID) as ELEMENT_CNT
  12. FROM b_iblock_section BS
  13. INNER JOIN b_iblock B ON BS.IBLOCK_ID = B.ID
  14.  
  15. INNER JOIN b_iblock_section BSTEMP ON BSTEMP.IBLOCK_ID = BS.IBLOCK_ID
  16. LEFT JOIN b_iblock_section_element BSE ON BSE.IBLOCK_SECTION_ID=BSTEMP.ID
  17. LEFT JOIN b_iblock_element BE ON (BSE.IBLOCK_ELEMENT_ID=BE.ID
  18. AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL )
  19. AND BE.IBLOCK_ID = BS.IBLOCK_ID
  20. )
  21. )
  22.  
  23. WHERE 1=1
  24. AND BSTEMP.IBLOCK_ID = BS.IBLOCK_ID
  25. AND BSTEMP.LEFT_MARGIN >= BS.LEFT_MARGIN
  26. AND BSTEMP.RIGHT_MARGIN <= BS.RIGHT_MARGIN
  27.  
  28. AND ((((BS.ACTIVE='Y'))))
  29. AND ((((BS.CODE LIKE 'izdeliya-dlya-oboznacheniya-kabelnykh-trass'))))
  30. AND ((
  31. B.ID IN (
  32. SELECT IBLOCK_ID
  33. FROM b_iblock_group IBG
  34. WHERE IBG.GROUP_ID IN (2)
  35. AND IBG.PERMISSION >= 'R'
  36.  
  37. AND (IBG.PERMISSION='X' OR B.ACTIVE='Y')
  38. )
  39. OR (B.RIGHTS_MODE = 'E' AND EXISTS (
  40. SELECT SR.SECTION_ID
  41. FROM b_iblock_section_right SR
  42. INNER JOIN b_iblock_right IBR ON IBR.ID = SR.RIGHT_ID
  43. INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0
  44. WHERE SR.SECTION_ID = BS.ID
  45. AND IBR.OP_SREAD = 'Y'
  46.  
  47. ))
  48. ))
  49. GROUP BY BS.ID, B.ID | 0 | 0 |
  50. | 2249980 | ssd | localhost | ssd2 | Sleep | 1 | | NULL | 0 | 0 |
  51. | 2249981 | ssd | localhost | ssd2 | Query | 0 | preparing | SELECT DISTINCT
  52. BS.*,
  53. B.LIST_PAGE_URL,
  54. B.SECTION_PAGE_URL,
  55. B.IBLOCK_TYPE_ID,
  56. B.CODE as IBLOCK_CODE,
  57. B.XML_ID as IBLOCK_EXTERNAL_ID,
  58. BS.XML_ID as EXTERNAL_ID,
  59. DATE_FORMAT(BS.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,
  60. DATE_FORMAT(BS.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE
  61. ,COUNT(DISTINCT BE.ID) as ELEMENT_CNT
  62. FROM b_iblock_section BS
  63. INNER JOIN b_iblock B ON BS.IBLOCK_ID = B.ID
  64.  
  65. INNER JOIN b_iblock_section BSTEMP ON BSTEMP.IBLOCK_ID = BS.IBLOCK_ID
  66. LEFT JOIN b_iblock_section_element BSE ON BSE.IBLOCK_SECTION_ID=BSTEMP.ID
  67. LEFT JOIN b_iblock_element BE ON (BSE.IBLOCK_ELEMENT_ID=BE.ID
  68. AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL )
  69. AND BE.IBLOCK_ID = BS.IBLOCK_ID
  70. )
  71. )
  72.  
  73. WHERE 1=1
  74. AND BSTEMP.IBLOCK_ID = BS.IBLOCK_ID
  75. AND BSTEMP.LEFT_MARGIN >= BS.LEFT_MARGIN
  76. AND BSTEMP.RIGHT_MARGIN <= BS.RIGHT_MARGIN
  77.  
  78. AND ((((BS.ACTIVE='Y'))))
  79. AND ((((BS.CODE LIKE 'mini-uzk'))))
  80. AND ((
  81. B.ID IN (
  82. SELECT IBLOCK_ID
  83. FROM b_iblock_group IBG
  84. WHERE IBG.GROUP_ID IN (2)
  85. AND IBG.PERMISSION >= 'R'
  86.  
  87. AND (IBG.PERMISSION='X' OR B.ACTIVE='Y')
  88. )
  89. OR (B.RIGHTS_MODE = 'E' AND EXISTS (
  90. SELECT SR.SECTION_ID
  91. FROM b_iblock_section_right SR
  92. INNER JOIN b_iblock_right IBR ON IBR.ID = SR.RIGHT_ID
  93. INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0
  94. WHERE SR.SECTION_ID = BS.ID
  95. AND IBR.OP_SREAD = 'Y'
  96.  
  97. ))
  98. ))
  99. GROUP BY BS.ID, B.ID | 0 | 0 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement