Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- BE.ID IBLOCK_ELEMENT_ID
- ,BEP.IBLOCK_PROPERTY_ID
- ,BEP.VALUE
- ,BEP.VALUE_NUM
- ,BEP.ID PROPERTY_VALUE_ID
- ,BEP.DESCRIPTION
- FROM
- b_iblock B
- INNER JOIN b_lang L ON B.LID=L.LID
- INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
- LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID AND BEP.IBLOCK_PROPERTY_ID IN (1081, 1082, 1083, 1084, 1085, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1180, 1181, 1182, 1183, 1188, 1190, 1194, 1195, 1206, 1207, 1208, 1209, 1210, 1211, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1418, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1621, 1622, 1623, 1624, 1625, 1626, 1635, 1649, 1650, 1661, 1662, 1663, 1664, 1665, 1666, 1669, 1673, 1674, 1675, 1721, 1981, 2003, 2009, 2022, 2154, 2157, 2159, 2160, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2264, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2281, 2282, 2283, 2284, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2292, 2293, 2294, 2295, 2296, 2297, 2298, 2299, 2300, 2301, 2302, 2303, 2304, 2305, 2306, 2307, 2308, 2309, 2310, 2311, 2312, 2313, 2314, 2315, 2316, 2317, 2318, 2319, 2320, 2321, 2327, 2328, 2329, 2330, 2333, 2334, 2337, 2338, 2339, 2340, 2382, 2397, 2399, 2400)WHERE 1=1
- AND (
- ((((BE.IBLOCK_ID = '25'))))
- )
- AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
- ORDER BY
- BEP.IBLOCK_ELEMENT_ID, BEP.IBLOCK_PROPERTY_ID, BEP.ID
- mysql> explain SELECT
- -> BE.ID IBLOCK_ELEMENT_ID
- -> ,BEP.IBLOCK_PROPERTY_ID
- -> ,BEP.VALUE
- -> ,BEP.VALUE_NUM
- -> ,BEP.ID PROPERTY_VALUE_ID
- -> ,BEP.DESCRIPTION
- ->
- -> FROM
- ->
- -> b_iblock B
- -> INNER JOIN b_lang L ON B.LID=L.LID
- -> INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
- ->
- ->
- -> LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID AND BEP.IBLOCK_PROPERTY_ID IN (1081, 1082, 1083, 1084, 1085, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1180, 1181, 1182, 1183, 1188, 1190, 1194, 1195, 1206, 1207, 1208, 1209, 1210, 1211, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1418, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1621, 1622, 1623, 1624, 1625, 1626, 1635, 1649, 1650, 1661, 1662, 1663, 1664, 1665, 1666, 1669, 1673, 1674, 1675, 1721, 1981, 2003, 2009, 2022, 2154, 2157, 2159, 2160, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2264, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2281, 2282, 2283, 2284, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2292, 2293, 2294, 2295, 2296, 2297, 2298, 2299, 2300, 2301, 2302, 2303, 2304, 2305, 2306, 2307, 2308, 2309, 2310, 2311, 2312, 2313, 2314, 2315, 2316, 2317, 2318, 2319, 2320, 2321, 2327, 2328, 2329, 2330, 2333, 2334, 2337, 2338, 2339, 2340, 2382, 2397, 2399, 2400)WHERE 1=1
- -> AND (
- ->
- -> ((((BE.IBLOCK_ID = '25'))))
- -> )
- -> AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
- -> ORDER BY
- -> BEP.IBLOCK_ELEMENT_ID, BEP.IBLOCK_PROPERTY_ID, BEP.ID;
- +----+-------------+-------+------------+-------+------------------------------------------------------------------------------------+------------------------------+---------+------------------+-------+----------+------------------------------------+
- | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
- +----+-------------+-------+------------+-------+------------------------------------------------------------------------------------+------------------------------+---------+------------------+-------+----------+------------------------------------+
- | 1 | SIMPLE | B | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
- | 1 | SIMPLE | L | NULL | const | PRIMARY | PRIMARY | 6 | const | 1 | 100.00 | Using index |
- | 1 | SIMPLE | BE | NULL | ref | ix_iblock_element_1,ix_iblock_element_4,ix_iblock_element_3,ix_iblock_element_code | ix_iblock_element_1 | 4 | const | 70594 | 5.00 | Using index condition; Using where |
- | 1 | SIMPLE | BEP | NULL | ref | ix_iblock_element_property_1,ix_iblock_element_property_2 | ix_iblock_element_property_1 | 4 | avilon_app.BE.ID | 19 | 100.00 | Using where |
- +----+-------------+-------+------------+-------+------------------------------------------------------------------------------------+------------------------------+---------+------------------+-------+----------+------------------------------------+
- 4 rows in set, 1 warning (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement