[ DB ] CONNECT:[ UseTime:0.028461s ] mysql:dbname=kfw_test;host=rm-8vbr0043pyk836f88ho.mysql.zhangbei.rds.aliyuncs.com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `product_sales_attr` [ RunTime:0.017973s ]
[ SQL ] SELECT * FROM `product_sales_attr` WHERE `id` = 791 [ RunTime:0.016473s ]
[ SQL ] SHOW COLUMNS FROM `product_virtual_category_attr` [ RunTime:0.016752s ]
[ SQL ] SELECT `c`.`id`,`productid`,title virtualtitle,`productsalesattrid` FROM `product_virtual_category_attr` `a` INNER JOIN `product_virtual_category` `c` ON `a`.`productvirtualcategoryid`=`c`.`id` WHERE `productsalesattrid` IN (791) AND `deleted` = 1 [ RunTime:0.025279s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.020767s ]
[ SQL ] SELECT `id`,`title` FROM `product` WHERE `id` IN (61) [ RunTime:0.016286s ]
[ SQL ] SHOW COLUMNS FROM `product_sales_attr_desc` [ RunTime:0.016615s ]
[ SQL ] SELECT * FROM `product_sales_attr_desc` WHERE `productsalesattrid` = 791 [ RunTime:0.016283s ]
[ SQL ] SELECT `c`.`id`,`productid`,title virtualtitle,`productsalesattrid` FROM `product_virtual_category_attr` `a` INNER JOIN `product_virtual_category` `c` ON `a`.`productvirtualcategoryid`=`c`.`id` WHERE `productsalesattrid` IN (791) AND `deleted` = 1 [ RunTime:0.016302s ]
[ SQL ] SELECT * FROM `product_sales_attr` WHERE `productid` = 61 ORDER BY sort asc [ RunTime:0.025440s ]
[ SQL ] SELECT * FROM `product_sales_attr_desc` WHERE `productsalesattrid` IN (258,2310,2311,1037,1038,1039,2579,1558,2582,791,2071,1561,2585,2587,2588,285,2589,798,2590,2591,2592,801,2593,802,2594,2595,2596,2597,2598,295,2599,2600,2601,298,2090,2602,299,2603,812,2604,2605,2606,2607,2608,2611,2360,2361,2364,2368,1096,1097,1098,1099,1100,1868,846,1102,337,856,1883,2661,2151,1899,1900,1389,1394,2418,1651,1910,1911,2425,891,381,1405,384,2178,2179,2183,1161,1417,1162,1163,1164,1165,1943,409,1178,1179,1180,925,931,1187,1191,1197,1970,1213,703,705,706,1995,2507,2508,2001,722,724,1492,1754,989,736,1506,2530,2532,2533,1510,2534,1511,2535,2536,2291,2548,1015,2552,1017,2554,2555) [ RunTime:0.016639s ]
[ SQL ] SELECT `c`.`id`,`productid`,title virtualtitle,`productsalesattrid` FROM `product_virtual_category_attr` `a` INNER JOIN `product_virtual_category` `c` ON `a`.`productvirtualcategoryid`=`c`.`id` WHERE `productsalesattrid` IN (2579,791,2585,2587,285,2589,2590,2591,2592,2593,2594,2595,2596,2598,2599,2601,2602,2603,2604,2605,2606,2607,2608,2611,856,1900,1389,1911,384,1162,1164,1995,2001,724,2533,1510,2534,2535,2548,2554,2555) AND `deleted` = 1 [ RunTime:0.016570s ]
[ SQL ] SHOW COLUMNS FROM `area` [ RunTime:0.016597s ]
[ SQL ] SELECT * FROM `area` WHERE `deleted` = 1 ORDER BY sort ASC [ RunTime:0.038046s ]
[ SQL ] SHOW COLUMNS FROM `product_sku` [ RunTime:0.016787s ]
[ SQL ] SELECT * FROM `product_sku` WHERE `productsalesattrid` = 791 AND `state` = 2 [ RunTime:0.016364s ]
[ SQL ] SELECT * FROM `area` WHERE `deleted` = 1 ORDER BY sort ASC [ RunTime:0.029331s ]
[ SQL ] SHOW COLUMNS FROM `provider_sku` [ RunTime:0.016747s ]
[ SQL ] SELECT DISTINCT `p`.`city` FROM `provider_sku` `ps` INNER JOIN `provider` `p` ON `p`.`id`=`ps`.`providerid` WHERE `p`.`authentication` = 4 AND `p`.`canreceiveorders` = 2 AND `ps`.`productsalesattrid` = 791 AND `ps`.`state` = 2 AND `ps`.`kfwstate` = 2 AND `ps`.`skustate` = 2 AND `p`.`city` IN (3302,3303,3304,3305,71,82,93,105,119,128,160,173,184,201,210,221,238,255,269,283,304,318,361,382,391,407,414,424,438,446,451,72,83,94,106,120,129,161,174,185,202,211,222,239,256,270,284,305,319,362,383,392,408,415,425,439,447,452,73,84,95,107,121,130,162,175,186,203,212,223,240,257,271,285,306,320,363,384,393,409,416,426,440,448,453,74,85,96,108,122,131,163,176,187,204,213,224,241,258,272,286,307,364,385,394,410,417,427,441,449,454,75,86,97,109,123,132,164,177,188,205,214,225,242,259,273,287,308,365,386,395,411,418,428,442,450,455,76,87,98,110,124,133,165,178,189,206,215,226,243,260,274,288,309,366,387,396,412,419,429,443,456,77,88,99,111,125,134,166,179,190,207,216,227,244,261,275,289,310,367,388,397,413,420,430,444,457,78,89,100,112,126,135,167,180,191,208,217,228,245,262,276,290,311,368,389,398,421,431,445,458,79,90,101,113,127,136,168,181,192,209,218,229,246,263,277,291,312,369,390,399,422,432,459,80,91,102,114,137,169,182,193,219,230,247,264,278,292,313,370,400,423,433,460,81,92,103,115,138,170,183,194,220,231,248,265,279,293,314,371,401,434,461,104,116,139,171,195,232,249,266,280,294,315,372,402,435,462,117,140,172,196,233,250,267,281,295,316,373,403,436,463,118,197,234,251,268,282,296,317,374,404,437,464,198,235,252,297,375,405,465,199,236,253,298,376,406,200,237,254,299,377,300,378,301,379,302,380,303,381,3306,3307,3308,3327,3328,3329,3338,3339,3340,3341,3342,3343,3344,3345) AND ( ( `p`.`type` = 5 AND `p`.`kfwzxstate` = 2 AND `p`.`zxstate` = 2 AND `ps`.`isopenzx` = 2 ) OR `p`.`type` <> 5 ) [ RunTime:0.017903s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `provider_sku` `ps` INNER JOIN `provider` `p` ON `p`.`id`=`ps`.`providerid` LEFT JOIN `khcs_customer` `khcus` ON `p`.`id`=`khcus`.`providerid` WHERE `p`.`authentication` = 4 AND `p`.`canreceiveorders` = 2 AND `ps`.`productsalesattrid` = 791 AND `ps`.`state` = 2 AND `ps`.`kfwstate` = 2 AND `ps`.`skustate` = 2 AND `ps`.`province` = 999999 AND `p`.`city` = '3302' AND ( ( `p`.`type` = 5 AND `p`.`kfwzxstate` = 2 AND `p`.`zxstate` = 2 AND `ps`.`isopenzx` = 2 ) OR `p`.`type` <> 5 ) LIMIT 1 [ RunTime:0.017317s ]
[ SQL ] SELECT `p`.`id`,`p`.`realname`,`p`.`areatitle`,`p`.`company`,`p`.`avatar`,`p`.`workstarttime`,`p`.`goodrate`,`p`.`recentordersnum`,`p`.`zxstate`,`p`.`kfwzxstate`,`p`.`type`,`p`.`provideridentityids`,`p`.`businesslineid`,`ps`.`productskuid`,`p`.`canordersstate`,`p`.`kfwcanordersstate`,`ps`.`isopenclue`,`ps`.`isopenzx`,`khcus`.`customernum` FROM `provider_sku` `ps` INNER JOIN `provider` `p` ON `p`.`id`=`ps`.`providerid` LEFT JOIN `khcs_customer` `khcus` ON `p`.`id`=`khcus`.`providerid` WHERE `p`.`authentication` = 4 AND `p`.`canreceiveorders` = 2 AND `ps`.`productsalesattrid` = 791 AND `ps`.`state` = 2 AND `ps`.`kfwstate` = 2 AND `ps`.`skustate` = 2 AND `ps`.`province` = 999999 AND `p`.`city` = '3302' AND ( ( `p`.`type` = 5 AND `p`.`kfwzxstate` = 2 AND `p`.`zxstate` = 2 AND `ps`.`isopenzx` = 2 ) OR `p`.`type` <> 5 ) ORDER BY isopenzx + p.kfwzxstate + p.zxstate desc,ps.effectscore + p.clueconversionscore desc, p.recentordersnum desc,p.id desc LIMIT 0,20 [ RunTime:0.017477s ]
[ SQL ] SHOW COLUMNS FROM `provider_extra` [ RunTime:0.016582s ]
[ SQL ] SELECT `providerid`,`declaration`,`servicetitlejson` FROM `provider_extra` WHERE `providerid` IN (6479) [ RunTime:0.016234s ]
[ SQL ] SHOW COLUMNS FROM `sso_account` [ RunTime:0.016637s ]
[ SQL ] SELECT `p`.`id`,`acc`.`qywxuserid`,`acc`.`qywxqrcode`,`acc`.`liveqrcode` FROM `sso_account` `acc` INNER JOIN `provider` `p` ON `p`.`accountid`=`acc`.`id` WHERE `p`.`id` IN (6479) [ RunTime:0.017080s ]
[ SQL ] SHOW COLUMNS FROM `zx_clue` [ RunTime:0.016671s ]
[ SQL ] SELECT `assigneeid`,COUNT(*) AS count FROM `zx_clue` WHERE `createtime` >= 1737734400 AND `assigneeid` IN (6479) GROUP BY assigneeid [ RunTime:0.068876s ]
