当前ID:82226028037094952
数据库原有链接:NULL
库无链接,开始调用API
API返回原始数据:
Array
(
    [data] => Array
        (
            [event_url_list] => Array
                (
                )

            [item_url_list] => Array
                (
                )

            [material_url_list] => Array
                (
                )

            [shop_url_list] => Array
                (
                    [shop_url_list] => Array
                        (
                            [0] => Array
                                (
                                    [input_shop_id] => 82226028037094952
                                    [link_info_dto] => Array
                                        (
                                            [cps_full_tpwd] => 19¥ CZ028 dDpggeElZna¥ https://m.tb.cn/h.Rluvt8r  SHANSHAN男装服饰店
                                            [cps_long_url] => https://s.click.taobao.com/t?e=m%3D2%26s%3DEkSlUH7N%2FrFw4vFB6t2Z2jAVflQIoZepXoO8tOebS%2BdRAdhuF14FMU1X4hyyY4%2FP5x%2BIUlGKNpVxFreNx8igYobr6St67QTInM%2FydqQ06jzViIvO8m%2BDeTiRUN2xVR4GSFd%2BDE6n8PQ4iPH8M0O3u9%2BRLcmCzt92omfkDJRs%2BhU%3D&union_lens=lensId:TAPI@1781349255@21508b39_0e9e_19ec0b08a03_6cd3@01
                                            [cps_short_tpwd] => ¥dDpggeElZna¥
                                            [cps_short_url] => https://s.click.taobao.com/khZKb0l
                                            [material_type] => 2
                                            [seller_id] => 82226028037094952
                                        )

                                )

                        )

                )

        )

    [request_id] => 16kljh2v6hyq1
)
解析出链接:https://s.click.taobao.com/t?e=m%3D2%26s%3DEkSlUH7N%2FrFw4vFB6t2Z2jAVflQIoZepXoO8tOebS%2BdRAdhuF14FMU1X4hyyY4%2FP5x%2BIUlGKNpVxFreNx8igYobr6St67QTInM%2FydqQ06jzViIvO8m%2BDeTiRUN2xVR4GSFd%2BDE6n8PQ4iPH8M0O3u9%2BRLcmCzt92omfkDJRs%2BhU%3D&union_lens=lensId:TAPI@1781349255@21508b39_0e9e_19ec0b08a03_6cd3@01
记录不存在,执行ADD新增
新增结果:false
最后SQL:INSERT INTO `ytt_dianpu` (`tbk_link`,`id`) VALUES ('https://s.click.taobao.com/t?e=m%3D2%26s%3DEkSlUH7N%2FrFw4vFB6t2Z2jAVflQIoZepXoO8tOebS%2BdRAdhuF14FMU1X4hyyY4%2FP5x%2BIUlGKNpVxFreNx8igYobr6St67QTInM%2FydqQ06jzViIvO8m%2BDeTiRUN2xVR4GSFd%2BDE6n8PQ4iPH8M0O3u9%2BRLcmCzt92omfkDJRs%2BhU%3D&union_lens=lensId:TAPI@1781349255@21508b39_0e9e_19ec0b08a03_6cd3@01',82226028037094952)