Performance Profiling

Total processing time: 140 ms; Peak memory: 5.846 MB. Show Profiling Timeline

总计13条数据

Time	Duration	Category	Info

11:57:19.354	15.1 ms	yii\db\Command::query	SELECT "rvr"."user_id" AS "id", "rvr"."user_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_approve_verify_rels" "rvr" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON rvr.user_id = u.id WHERE "approve_id" IN (2104, 2105, 2103, 2106, 2107, 2108, 1424, 1491, 1526, 1751, 1855, 1055, 1969, 2001, 1327, 2036, 130, 499, 498, 2076, 88, 983, 1612, 496, 536, 1731, 1219, 1390, 1648, 1173, 2063, 1677, 314, 735, 843, 879, 1029, 1240, 931, 1020, 113, 1639, 1729, 1076, 1997, 1582, 1563, 1578, 1658, 93, 685, 259, 435, 500, 549, 1175, 1207, 1346, 16, 1580, 1643, 362, 390, 614, 701, 1249, 1687, 948, 330, 239, 1660, 28, 81, 1365, 1373, 1372, 1366, 1370, 1369, 1371, 1375, 1379, 1378, 1380, 1454, 2045, 1440, 1415, 2042, 2044, 2046, 2054, 1395, 2050, 2053, 2047, 2043, 1387, 1389, 555, 1393, 1419, 1388, 1394, 1399, 80, 1397, 1402, 1401, 1400, 1403, 1467, 1416, 1422, 1408, 1414, 1413, 1466, 1412, 1417, 1428, 1421, 1418, 1426, 1425, 1427, 1432, 1433, 2060, 2066, 2061, 2065, 573, 2072, 2064, 2071, 2070, 2069, 2068, 2067, 2079, 2077, 1438, 1455, 1443, 1436, 1437, 1447, 1445, 1449, 752, 1450, 1446, 1451, 143, 1464, 1459, 1453, 1456, 1516, 1457, 1458, 1465, 1470, 1468, 1471, 1469, 159, 2082, 778, 1481, 1478, 1479, 1502, 1561, 1562, 1482, 1477, 1476, 1487, 1488, 1486, 1490, 1493, 1489, 1494, 1492, 216, 209, 1496, 1497, 1498, 1499, 1517, 2085, 2083, 1500, 1501, 1508, 1509, 1513, 1503, 1504, 1515, 1523, 1512, 1506, 1507, 1514, 1505, 241, 238, 240, 1519, 1521, 2084, 1557, 255, 1527, 1528, 1524, 1552, 1178, 1537, 1536, 1533, 1534, 1539, 1540, 2091, 268, 2092, 1538, 2089, 1548, 1576, 1554, 1547, 1546, 1549, 1556, 1565, 1555, 1551, 1560, 1559, 1564, 2095, 2102, 1577, 2096, 324, 1573, 1570, 1571, 1566, 1567, 1574, 1572, 1575, 998, 1568, 1581, 1586, 1587, 366, 1594, 1590, 1591, 493, 1593, 1602, 1595, 1600, 1598, 1601, 1609, 1610, 394, 1606, 1611, 404, 407, 277, 1624, 1614, 1622, 1623, 1002, 1620, 1621, 1617, 1627, 1625, 1629, 1626, 1630, 1631, 439, 1663, 1628, 451, 1636, 1637, 1640, 1654, 1638, 1642, 1632, 476, 468, 466, 1653, 485, 1652, 1657, 1665, 1656, 1664, 1655, 514, 1666, 527, 523, 1667, 793, 1678, 1675, 1674, 1673, 1672, 1679, 1676, 1680, 1684, 1682, 1681, 1683, 1688, 568, 565, 1693, 1690, 1697, 1849, 1692, 1698, 1695, 1691, 1700, 1696, 1701, 1703, 1705, 624, 596, 1706, 1718, 1713, 1715, 1720, 1716, 1719, 1717, 1850, 1723, 1721, 1722, 1725, 1726, 1832, 1727, 1728, 645, 640, 1737, 1732, 1742, 1733, 1827, 1745, 1743, 1744, 1750, 1747, 1746, 1749, 1730, 675, 692, 1757, 1758, 817, 1759, 1765, 1763, 1760, 1756, 1771, 1839, 554, 1770, 1761, 1766, 1762, 1768, 1774, 1773, 1775, 1776, 708, 1785, 1784, 1783, 1782, 1789, 1792, 1781, 1790, 1786, 1794, 1793, 880, 1795, 755, 1801, 1802, 1799, 1803, 1806, 1808, 1810, 1812, 1811, 1805, 1809, 1807, 1813, 1859, 802, 805, 800, 1816, 1867, 1862, 1815, 1822, 1821, 1817, 1826, 1824, 1823, 982, 1828, 1825, 1833, 1831, 1830, 1835, 1836, 856, 1837, 1844, 1838, 1854, 1843, 1841, 1842, 1851, 1852, 1857, 1858, 1872, 1865, 1861, 1868, 1863, 1866, 1864, 1876, 1875, 1874, 1877, 1878, 1880, 941, 1889, 1885, 1881, 1882, 1883, 1890, 1887, 1888, 1895, 1893, 1896, 1919, 1897, 1899, 1894, 1900, 1901, 1902, 969, 1910, 1074, 1075, 1904, 1905, 1903, 1906, 1338, 1908, 1914, 1911, 2038, 1909, 1913, 1912, 1915, 1920, 1921, 1011, 1923, 1081, 1930, 1924, 1337, 1932, 1931, 1936, 2012, 1940, 1941, 1945, 1947, 1946, 1948, 1944, 1951, 1949, 1955, 1977, 1958, 1966, 1963, 1962, 1964, 1967, 1968, 1970, 1163, 1155, 1161, 1989, 1067, 1194, 1974, 1980, 1270, 2039, 1217, 1235, 1992, 1988, 1995, 1990, 1986, 1999, 1994, 2024, 1998, 2000, 1993, 715, 2003, 2004, 137, 2005, 1295, 641, 660, 2006, 2020, 2010, 2019, 2013, 2014, 2018, 2025, 1360, 1362, 2030, 9, 17, 23, 15, 14, 12, 2033, 2037, 2040, 21, 13, 18, 7, 8, 20, 22, 27, 26, 25, 76, 34, 30, 33, 31, 43, 849, 32, 39, 40, 41, 35, 45, 44, 77, 131, 620, 102, 49, 46, 127, 65, 48, 68, 47, 59, 78, 75, 83, 125, 79, 153, 796, 84, 90, 50, 61, 58, 141, 53, 52, 54, 62, 128, 67, 66, 70, 82, 86, 85, 129, 106, 138, 148, 151, 202, 201, 193, 204, 428, 282, 751, 87, 89, 96, 95, 169, 100, 94, 97, 104, 98, 103, 99, 101, 105, 320, 108, 107, 413, 109, 161, 111, 115, 117, 187, 120, 116, 122, 118, 121, 114, 123, 124, 140, 421, 132, 133, 135, 134, 146, 144, 142, 147, 149, 150, 152, 154, 145, 199, 156, 212, 447, 158, 244, 160, 166, 163, 162, 168, 196, 192, 200, 1260, 205, 194, 170, 183, 171, 208, 178, 172, 184, 181, 275, 177, 185, 189, 186, 188, 203, 206, 211, 207, 214, 218, 210, 274, 215, 217, 790, 220, 219, 221, 251, 287, 223, 225, 266, 587, 224, 232, 226, 229, 228, 231, 230, 280, 233, 334, 234, 337, 602, 235, 236, 448, 237, 424, 246, 245, 247, 250, 249, 254, 431, 253, 260, 618, 252, 261, 256, 258, 257, 263, 338, 361, 264, 273, 270, 271, 276, 278, 279, 283, 370, 340, 291, 285, 294, 286, 416, 289, 288, 335, 290, 295, 323, 296, 344, 368, 310, 297, 303, 298, 304, 300, 375, 318, 312, 301, 299, 307, 327, 313, 305, 308, 311, 309, 336, 341, 403, 475, 315, 319, 321, 316, 317, 325, 322, 326, 328, 329, 331, 333, 339, 385, 346, 348, 347, 349, 358, 353, 355, 354, 359, 381, 382, 352, 357, 356, 360, 363, 427, 365, 377, 371, 372, 376, 574, 379, 380, 383, 397, 384, 398, 395, 387, 391, 389, 412, 396, 388, 399, 393, 400, 402, 409, 445, 459, 405, 437, 408, 406, 411, 410, 415, 414, 420, 422, 423, 425, 436, 469, 429, 433, 430, 440, 432, 443, 438, 441, 442, 558, 446, 449, 477, 450, 456, 452, 454, 595, 458, 463, 464, 560, 577, 465, 473, 486, 470, 471, 483, 478, 479, 481, 480, 482, 484, 489, 491, 488, 578, 492, 487, 490, 501, 502, 503, 505, 517, 575, 506, 508, 580, 556, 510, 512, 509, 513, 520, 515, 519, 518, 535, 525, 807, 521, 524, 522, 526, 545, 542, 532, 531, 530, 529, 528, 534, 537, 600, 551, 550, 668, 543, 538, 544, 552, 553, 557, 559, 748, 563, 570, 564, 569, 566, 1050, 604, 811, 571, 576, 572, 579, 584, 581, 582, 585, 586, 597, 610, 589, 605, 694, 613, 590, 611, 808, 588, 616, 615, 622, 722, 798, 630, 593, 1077, 609, 686, 690, 599, 601, 598, 607, 603, 750, 608, 612, 619, 623, 626, 669, 625, 627, 628, 716, 635, 689, 691, 693, 633, 629, 632, 631, 638, 636, 723, 664, 639, 642, 665, 651, 658, 650, 643, 646, 644, 647, 652, 648, 654, 655, 649, 656, 657, 794, 672, 670, 666, 662, 707, 667, 663, 674, 673, 676, 677, 678, 682, 727, 733, 680, 679, 687, 683, 714, 695, 684, 809, 696, 697, 700, 764, 699, 706, 705, 740, 709, 712, 710, 713, 711, 719, 720, 721, 724, 730, 725, 726, 732, 731, 736, 741, 739, 734, 737, 738, 743, 744, 745, 749, 754, 775, 806, 768, 756, 766, 947, 759, 767, 765, 770, 771, 772, 773, 774, 803, 777, 875, 783, 776, 779, 789, 782, 785, 786, 787, 791, 792, 795, 799, 812, 801, 810, 804, 815, 1154, 819, 846, 816, 822, 820, 828, 823, 821, 824, 826, 825, 827, 830, 832, 829, 831, 833, 990, 1045, 1359, 866, 1149, 857, 841, 882, 835, 840, 842, 848, 836, 847, 844, 845, 850, 851, 992, 1046, 853, 924, 863, 858, 870, 869, 864, 860, 867, 861, 935, 868, 872, 873, 859, 889, 877, 885, 886, 914, 884, 881, 890, 887, 883, 892, 891, 888, 913, 898, 894, 893, 895, 897, 900, 905, 901, 915, 902, 909, 903, 904, 908, 910, 918, 911, 916, 917, 912, 997, 921, 928, 926, 922, 970, 929, 927, 930, 934, 923, 932, 925, 936, 984, 942, 937, 951, 938, 939, 954, 946, 956, 950, 949, 952, 957, 953, 955, 980, 999, 959, 1086, 1105, 958, 981, 1073, 1049, 989, 993, 986, 1150, 988, 985, 967, 971, 994, 991, 995, 1000, 1084, 1043, 1113, 1100, 1122, 960, 962, 968, 963, 964, 1115, 961, 965, 966, 1013, 1017, 975, 973, 974, 976, 977, 978, 979, 996, 1009, 1083, 1023, 1031, 1026, 1005, 1010, 1006, 1018, 1007, 1008, 1016, 1012, 1014, 1021, 1022, 1019, 1044, 1133, 1134, 1024, 1034, 1035, 1030, 1032, 1027, 1033, 1028, 1094, 1039, 1066, 1038, 1037, 1040, 1041, 1042, 1058, 1051, 1056, 1057, 1062, 1054, 1059, 1153, 1065, 1064, 1068, 1070, 1071, 1089, 1072, 1080, 1091, 1079, 1085, 1088, 1082, 1087, 1092, 1095, 1099, 1096, 1097, 1107, 1106, 1103, 1132, 1102, 1142, 1143, 1104, 1101, 1112, 1111, 1114, 1116, 1119, 1120, 1108, 1239, 1123, 1128, 1126, 1141, 1130, 1127, 1131, 1129, 1145, 1146, 1144, 1147, 1151, 1152, 1177, 1187, 1166, 1157, 1164, 1156, 1159, 1169, 1160, 1165, 1176, 1167, 1168, 1170, 1171, 1174, 1180, 1181, 1186, 1211, 1183, 1184, 1237, 1185, 1203, 1188, 1192, 1189, 1190, 1196, 1200, 1193, 1195, 1197, 1202, 1199, 1198, 1201, 1206, 1209, 1212, 1210, 1215, 1213, 1218, 1214, 1221, 1223, 1222, 1220, 1226, 1224, 1227, 1228, 1230, 1234, 1231, 1232, 1236, 1233, 1247, 1242, 1246, 1243, 1241, 1244, 1253, 1251, 1248, 1252, 1250, 1254, 1257, 1261, 1259, 1357, 1279, 1275, 1271, 1281, 1274, 1278, 1285, 1283, 1282, 1284, 1290, 1294, 1291, 1299, 1301, 1302, 1300, 1308, 1310, 1311, 1318, 1313, 1356, 1325, 1323, 1321, 1328, 1319, 1339, 1331, 1332, 1333, 1335, 1344, 1349, 1345, 1347, 1353, 1354, 1355, 1886, 1898, 1926, 1927, 419, 1704, 1856, 1374, 1439, 1869, 1870, 1452, 284, 1460, 1871, 1461, 1462, 1463, 494, 1873, 281, 1472, 1473, 1474, 1475, 495, 418, 1480, 292, 293, 467, 1484, 1485, 1495, 1483, 497, 306, 1879, 426, 1884, 1510, 1511, 539, 540, 541, 1891, 1892, 1518, 1520, 504, 507, 1907, 1853, 1522, 1525, 1529, 1530, 1531, 1532, 434, 546, 548, 332, 1916, 1917, 1918, 444, 1535, 1541, 1542, 1543, 1544, 1545, 342, 343, 345, 350, 1922, 1925, 351, 1550, 1553, 1928, 1933, 1934, 547, 1558, 1935, 1569, 364, 367, 1937, 1938, 474, 1939, 369, 1942, 373, 378, 1943, 453, 11, 455, 457, 19, 374, 24, 36, 37, 38, 42, 51, 56, 63, 69, 472, 386, 392, 1579, 1583, 1584, 1588, 1589, 460, 461, 91, 92, 110, 1592, 1596, 1585, 1599, 112, 462, 511, 1950, 119, 1597, 987, 126, 136, 1603, 1604, 1608, 1613, 1615, 1616, 1618, 1619, 1607, 1952, 155, 157, 164, 165, 1633, 1634, 167, 567, 1954, 1953, 1929, 1956, 1635, 179, 180, 516, 182, 190, 191, 195, 197, 198, 1957, 1960, 1961, 1965, 1959, 1814, 213, 222, 227, 242, 243, 562, 248, 262, 265, 267, 269, 272, 1641, 1645, 1646, 1647, 583, 591, 592, 594, 1644, 606, 617, 621, 634, 637, 1649, 1605, 1650, 1651, 1659, 1661, 1662, 1670, 1671, 1668, 1669, 1685, 1686, 1689, 1694, 659, 661, 671, 681, 1702, 1707, 1708, 1709, 1710, 1711, 1712, 1714, 688, 698, 702, 703, 704, 717, 718, 1724, 1734, 1735, 1738, 1739, 1740, 1741, 1736, 1748, 1752, 1754, 728, 729, 742, 746, 747, 753, 1755, 1753, 1764, 757, 758, 760, 761, 763, 769, 1971, 1972, 1973, 1975, 1976, 1769, 1772, 1767, 1777, 1778, 1779, 1780, 1787, 1788, 1796, 780, 781, 784, 788, 1797, 797, 1791, 1798, 1978, 1979, 1981, 1985, 1984, 834, 837, 838, 839, 1983, 852, 855, 854, 1991, 1996, 862, 865, 871, 972, 874, 876, 2002, 899, 2007, 2008, 2009, 2011, 2016, 2017, 2021, 2022, 2023, 906, 907, 919, 920, 933, 1800, 940, 943, 944, 1804, 1001, 1003, 1004, 1015, 1025, 1036, 1819, 1820, 1047, 1048, 1829, 1052, 1053, 1060, 1061, 1063, 1069, 1840, 1845, 1090, 1109, 1110, 1117, 1118, 1846, 1847, 1848, 1121, 1135, 1136, 1137, 1138, 1139, 1140, 1148, 1162, 1179, 1860, 1191, 1204, 1205, 1208, 1216, 1225, 57, 561, 1229, 1238, 1245, 1258, 1262, 1263, 1264, 1265, 1267, 1268, 1266, 1269, 1272, 1273, 1277, 1276, 1280, 1286, 1287, 1288, 1289, 1292, 1293, 1296, 1297, 1298, 1304, 1305, 1306, 1307, 1309, 1312, 1317, 1316, 1320, 1322, 1324, 1326, 1329, 1330, 1334, 1336, 1340, 1342, 1343, 1348, 1350, 1351, 1352, 1358, 1363, 1364, 1367, 1368, 1376, 1377, 1381, 1382, 1383, 1384, 1385, 1386, 1391, 1392, 1396, 1398, 1404, 1407, 1409, 1410, 1411, 1423, 1420, 1429, 1430, 1431, 1434, 1435, 1441, 1442, 1444, 1448, 2028, 2029, 2031, 2032, 2034, 2027, 2026, 2041, 2048, 2051, 2052, 2055, 2056, 2057, 2058, 2059, 2062, 2049, 2073, 2074, 2075, 2080, 2086, 2087, 2088, 2090, 2093, 2094, 2098, 2099, 2100, 2101, 2097) GROUP BY "user_id", "u"."name", "pinyin1", "pinyin2", "pinyin3", "pinyin4", "namecut1", "namecut2", "namecut3", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
11:57:19.341	9.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approves"
11:57:19.322	3.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5250
11:57:19.320	2.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:57:19.327	2.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
11:57:19.370	1.5 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/approve/get-filter-of-project', '{"id":"4073","web_access_token":"whZjM8ZfyqxulYW-_i5kn1yK2K5nH7iz"}', '{"code":2000,"result":[{"key":"ApproveSearch[form_department]","name":"\u90e8\u95e8\/\u7533\u8bf7\u4eba","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","department_id":1},{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de","department_id":1}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","child":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","department_id":2},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2},{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","department_id":2},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","child":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3}]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","child":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","child":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","department_id":6}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","child":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","child":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10}]}],"default":"","itemKey":"ApproveSearch[created_by]"},{"key":"ApproveSearch[form_type]","name":"\u7533\u8bf7\u7c7b\u578b","value":[{"id":2100000000,"key":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},{"id":316,"key":316,"name":"\u63d0\u6b3e\u7533\u8bf7"},{"id":319,"key":319,"name":"\u6b63\u5e38\u5f00\u7968"},{"id":320,"key":320,"name":"\u6b63\u5e38\u5907\u8d27"},{"id":313,"key":313,"name":"\u63d0\u524d\u5907\u8d27\u7533\u8bf7"},{"id":315,"key":315,"name":"\u63d0\u524d\u5f00\u53d1\u7968\u7533\u8bf7"},{"id":2100000001,"key":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7"},{"id":321,"key":321,"name":"\u6d4b\u8bd5\u8bbe\u5907\u7533\u8bf7"},{"id":322,"key":322,"name":"0\u51fa\u5e93\u7533\u8bf7"},{"id":312,"key":312,"name":"\u51fa\u5dee\u7533\u8bf7"},{"id":317,"key":317,"name":"\u5176\u4ed6"}],"default":""},{"key":"ApproveSearch[form_approveVerifyRels]","name":"\u5ba1\u6279\u4eba","value":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"},{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11"},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"id":1015,"key":1015,"name":"\u5434\u660a"},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e"},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e"},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"},{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896"}],"default":""},{"key":"ApproveSearch[status]","name":"\u5ba1\u6279\u72b6\u6001","value":[{"key":1,"name":"\u5ba1\u6279\u4e2d"},{"key":2,"name":"\u5df2\u901a\u8fc7"},{"key":4,"name":"\u5df2\u62d2\u7edd"}],"default":""},{"custom":"1","key":"ApproveSearch[created_at_period]","name":"\u63d0\u4ea4\u65e5\u671f","value":[{"key":"thismonth","name":"\u672c\u6708"},{"key":"lastmonth","name":"\u4e0a\u6708"},{"key":"custom","name":"\u81ea\u5b9a\u4e49"}],"default":""},{"custom":"1","key":"ApproveSearch[verify_at_period]","name":"\u5ba1\u6279\u65e5\u671f","value":[{"key":"thismonth","name":"\u672c\u6708"},{"key":"lastmonth","name":"\u4e0a\u6708"},{"key":"custom","name":"\u81ea\u5b9a\u4e49"}],"default":""}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-04 11:57:19') RETURNING "id"
11:57:19.336	0.9 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
11:57:19.338	0.9 ms	yii\db\Command::query	SELECT "d"."id" FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON u.department_id = d.id WHERE ("user_status"='1') AND ("u"."id" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) GROUP BY "u"."id", "d"."id", "d"."order" ORDER BY "d"."order"
11:57:19.340	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "department_id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) AND ("department_id" IN (4, 1, 2, 3, 8, 6, 7, 10)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
11:57:19.341	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
11:57:19.339	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 3, 3, 8, 6, 6, 7, 10, 10, 10, 10) ORDER BY "order"
11:57:19.337	0.3 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
11:57:19.339	0.2 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"