[ DB ] CONNECT:[ UseTime:0.022773s ] mysql:dbname=kfw_test;host=rm-8vbr0043pyk836f88ho.mysql.zhangbei.rds.aliyuncs.com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `area` [ RunTime:0.015362s ]
[ SQL ] SELECT * FROM `area` WHERE `title` LIKE '哥伦布%' AND `parentid` > 0 AND `deleted` = 1 LIMIT 1 [ RunTime:0.018620s ]
[ SQL ] SHOW COLUMNS FROM `product_sales_attr` [ RunTime:0.015168s ]
[ SQL ] SELECT * FROM `product_sales_attr` WHERE `id` = 300 [ RunTime:0.014898s ]
[ SQL ] SHOW COLUMNS FROM `product_virtual_category_attr` [ RunTime:0.014989s ]
[ 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 (300) AND `deleted` = 1 [ RunTime:0.014769s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.015056s ]
[ SQL ] SELECT `id`,`title` FROM `product` WHERE `id` IN (88) [ RunTime:0.014704s ]
[ SQL ] SHOW COLUMNS FROM `product_sales_attr_desc` [ RunTime:0.015010s ]
[ SQL ] SELECT * FROM `product_sales_attr_desc` WHERE `productsalesattrid` = 300 [ RunTime:0.017951s ]
[ 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 (300) AND `deleted` = 1 [ RunTime:0.014752s ]
[ SQL ] SELECT * FROM `product_sales_attr` WHERE `productid` = 88 ORDER BY sort asc [ RunTime:0.015950s ]
[ SQL ] SELECT * FROM `product_sales_attr_desc` WHERE `productsalesattrid` IN (300) [ RunTime:0.014841s ]
[ 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 (300) AND `deleted` = 1 [ RunTime:0.015913s ]
[ SQL ] SELECT * FROM `area` WHERE `deleted` = 1 ORDER BY sort ASC [ RunTime:0.038803s ]
[ SQL ] SHOW COLUMNS FROM `product_sku` [ RunTime:0.022241s ]
[ SQL ] SELECT * FROM `product_sku` WHERE `productsalesattrid` = 300 AND `state` = 2 [ RunTime:0.014889s ]
[ SQL ] SELECT * FROM `area` WHERE `deleted` = 1 ORDER BY sort ASC [ RunTime:0.024009s ]
[ SQL ] SHOW COLUMNS FROM `provider_sku` [ RunTime:0.015269s ]
[ 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` = 300 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.016593s ]
[ 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` = 300 AND `ps`.`state` = 2 AND `ps`.`kfwstate` = 2 AND `ps`.`skustate` = 2 AND `ps`.`province` = 999999 AND ( ( `p`.`type` = 5 AND `p`.`kfwzxstate` = 2 AND `p`.`zxstate` = 2 AND `ps`.`isopenzx` = 2 ) OR `p`.`type` <> 5 ) LIMIT 1 [ RunTime:0.016091s ]
[ 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` = 300 AND `ps`.`state` = 2 AND `ps`.`kfwstate` = 2 AND `ps`.`skustate` = 2 AND `ps`.`province` = 999999 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.016187s ]
[ SQL ] SHOW COLUMNS FROM `provider_extra` [ RunTime:0.015107s ]
[ SQL ] SELECT `providerid`,`declaration`,`servicetitlejson` FROM `provider_extra` WHERE `providerid` IN (6,6245,351) [ RunTime:0.014755s ]
[ SQL ] SHOW COLUMNS FROM `sso_account` [ RunTime:0.015111s ]
[ 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 (6,6245,351) [ RunTime:0.014791s ]
[ SQL ] SHOW COLUMNS FROM `zx_clue` [ RunTime:0.015165s ]
[ SQL ] SELECT `assigneeid`,COUNT(*) AS count FROM `zx_clue` WHERE `createtime` >= 1737734400 AND `assigneeid` IN (6,6245,351) GROUP BY assigneeid [ RunTime:0.062197s ]
