[ DB ] CONNECT:[ UseTime:0.026395s ] mysql:dbname=kfw_test;host=rm-8vbr0043pyk836f88ho.mysql.zhangbei.rds.aliyuncs.com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `product_sales_attr` [ RunTime:0.017746s ]
[ SQL ] SELECT * FROM `product_sales_attr` WHERE `id` = 1458 [ RunTime:0.017292s ]
[ SQL ] SHOW COLUMNS FROM `product_virtual_category_attr` [ RunTime:0.017436s ]
[ 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 (1458) AND `deleted` = 1 [ RunTime:0.017185s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.017512s ]
[ SQL ] SELECT `id`,`title` FROM `product` WHERE `id` IN (121) [ RunTime:0.017192s ]
[ SQL ] SHOW COLUMNS FROM `product_sales_attr_desc` [ RunTime:0.017667s ]
[ SQL ] SELECT * FROM `product_sales_attr_desc` WHERE `productsalesattrid` = 1458 [ RunTime:0.017283s ]
[ 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 (1458) AND `deleted` = 1 [ RunTime:0.017226s ]
[ SQL ] SELECT * FROM `product_sales_attr` WHERE `productid` = 121 ORDER BY sort asc [ RunTime:0.018300s ]
[ SQL ] SELECT * FROM `product_sales_attr_desc` WHERE `productsalesattrid` IN (2314,2315,2328,2329,2365,2366,2367,1123,1124,1125,1126,1127,1128,1937,1458,2232,2233,2768,2271,2287,1454,1456,1455,1457,1453) [ RunTime:0.017416s ]
[ 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 (2367,1458,2271,1456,1455,1453) AND `deleted` = 1 [ RunTime:0.022624s ]
[ SQL ] SHOW COLUMNS FROM `area` [ RunTime:0.017552s ]
[ SQL ] SELECT * FROM `area` WHERE `deleted` = 1 ORDER BY sort ASC [ RunTime:0.036687s ]
[ SQL ] SHOW COLUMNS FROM `product_sku` [ RunTime:0.017676s ]
[ SQL ] SELECT * FROM `product_sku` WHERE `productsalesattrid` = 1458 AND `state` = 2 [ RunTime:0.020216s ]
[ SQL ] SELECT * FROM `area` WHERE `deleted` = 1 ORDER BY sort ASC [ RunTime:0.033391s ]
[ SQL ] SHOW COLUMNS FROM `provider_sku` [ RunTime:0.017730s ]
[ 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` = 1458 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.018068s ]
[ 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` = 1458 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.019727s ]
