Symfony Profiler

SELECT
  *
FROM
  customer_device
WHERE
  :token LIKE CONCAT(token, '%')
  AND `status` = 0

SELECT
        *
        FROM
        customer_device
        WHERE
            'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3MzgzNTYzNTksImV4cCI6MTczODM1OTk1OSwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6InNlcmdpbzE0MDcyMEBpY2xvdWQuY29tIn0.Xxt_ACy4Th5fiBpZ48N57WX0acQNojBrdxcpCxgg1N_7EDzMUW_aIQ-OU484dGTBwYLGCEKltGQNtdly_Mqz137hsmrKFPYDBMW-oXRKYtJnaKr09PVRa4eCf76eGVL6pDE-3OL3xdnmGV94CmxKK8ZHMCCSILEXmFANdSeK-xVVuh32yBZieQKE5lUeeDG7bU-lavEZ7akUhbyBOc44RBmQDaK0daJU3cPnSJP7JV77LNyQfTgtpjo6w0L82mfbKYVpyoxaNJXuDIIH10_4J6I-h0l_Biiu3rUuaFsEle6bCtfp5gH7JwyWGTTTOdRs-hbr625bOjxIXQCOxTbzR3QCjqAuetscymWQOaw5SKR2UL2QnJrx3fA7JeRDy3soHJkF6VJ9OpHCLXFQGFNd6wO0xQX0KRNjkc4T00RLGPGo4BQPBpMLMBjPDLBJ7BF1XPpZje-CkV9pHUT83D8JYofMIgGe6mcnvAMVi_E1v3WO1l9mbCxdl07VuWLOeu6aYsMV8MV4-_BEriZezdJzjQDRdmn_Fu-mEFewttCuKHh69IVmOu0DsjULQXNZlG2OyJABwPlZ-UvMijxIDmnozQv92dq2T1TV6Jbbx7sTOcjAdc1zzd4NhTbhS5VrvZVwuStspgAMB2Ug9GSWizZgfkROqH7gqz8-8QRl5r5muFo' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

UPDATE
  customer
SET
  purchase = ?
WHERE
  id = ?

UPDATE customer SET purchase = 'MIIZBAYJKoZIhvcNAQcCoIIY9TCCGPECAQExDzANBglghkgBZQMEAgEFADCCCDoGCSqGSIb3DQEHAaCCCCsEgggnMYIIIzAKAgEUAgEBBAIMADALAgEDAgEBBAMMATEwCwIBEwIBAQQDDAEyMAsCARkCAQEEAwIBAzAMAgEKAgEBBAQWAjQrMAwCAQ4CAQEEBAICARcwDQIBDQIBAQQFAgMCv4UwDgIBAQIBAQQGAgRbVMTzMA4CAQkCAQEEBgIEUDMwNTAOAgELAgEBBAYCBAdHL54wDgIBEAIBAQQGAgQz+i+0MBICAQ8CAQEECgIIBv3h1huXB0gwFAIBAAIBAQQMDApQcm9kdWN0aW9uMBgCAQQCAQIEEH/HzaaDalFjvhveSBqZf4IwHAIBAgIBAQQUDBJjb20uZ29sbWFuYWdlci5pb3MwHAIBBQIBAQQUkvzm5sX91Spul3CAk7miwB7tvHYwHgIBCAIBAQQWFhQyMDI1LTAxLTMxVDIwOjM0OjU3WjAeAgEMAgEBBBYWFDIwMjUtMDEtMzFUMjA6MzQ6NTdaMB4CARICAQEEFhYUMjAyNC0wOS0xMFQyMTo0Mjo1M1owQQIBBwIBAQQ5N4kJo6jLFIzmfSlcqqKJYUgx3W+nzja8zFTy141vTkLP6hoXwBmVU8b+UON6mOt3mk0/m57/s3C6MEQCAQYCAQEEPDFvBA8ya0wpwy7c1E3lJuUT9pKRGN51JZqhjLM9pABMAZuayAUkWTiMLkPscqoB2gtDsS0HrDsUa7/LczCCAYMCARECAQEEggF5MYIBdTALAgIGrQIBAQQCDAAwCwICBrACAQEEAhYAMAsCAgayAgEBBAIMADALAgIGswIBAQQCDAAwCwICBrQCAQEEAgwAMAsCAga1AgEBBAIMADALAgIGtgIBAQQCDAAwDAICBqUCAQEEAwIBATAMAgIGqwIBAQQDAgEDMAwCAgaxAgEBBAMCAQAwDAICBrcCAQEEAwIBADAMAgIGugIBAQQDAgEAMA8CAgauAgEBBAYCBFuK1i0wEQICBq8CAQEECAIGP6pkbDQgMBUCAgamAgEBBAwMCmdtLm1vbnRobHkwGQICBqcCAQEEEAwONzAwMDIyOTIwNjE5NzcwGQICBqkCAQEEEAwONzAwMDIyOTIwNjE5NzcwHwICBqgCAQEEFhYUMjAyNC0wOS0xMVQxMjoyNjozN1owHwICBqoCAQEEFhYUMjAyNC0wOS0xMVQxMjoyNjozOVowHwICBqwCAQEEFhYUMjAyNC0xMC0xMVQxMjoyNjozN1owggGDAgERAgEBBIIBeTGCAXUwCwICBq0CAQEEAgwAMAsCAgawAgEBBAIWADALAgIGsgIBAQQCDAAwCwICBrMCAQEEAgwAMAsCAga0AgEBBAIMADALAgIGtQIBAQQCDAAwCwICBrYCAQEEAgwAMAwCAgalAgEBBAMCAQEwDAICBqsCAQEEAwIBAzAMAgIGsQIBAQQDAgEAMAwCAga3AgEBBAMCAQAwDAICBroCAQEEAwIBADAPAgIGrgIBAQQGAgRbitYtMBECAgavAgEBBAgCBj+qZGw0ITAVAgIGpgIBAQQMDApnbS5tb250aGx5MBkCAganAgEBBBAMDjcwMDAyMzQwMTY5Mjg3MBkCAgapAgEBBBAMDjcwMDAyMjkyMDYxOTc3MB8CAgaoAgEBBBYWFDIwMjQtMTAtMTFUMTI6MjY6MzdaMB8CAgaqAgEBBBYWFDIwMjQtMDktMTFUMTI6MjY6MzlaMB8CAgasAgEBBBYWFDIwMjQtMTEtMTFUMTM6MjY6MzdaMIIBgwIBEQIBAQSCAXkxggF1MAsCAgatAgEBBAIMADALAgIGsAIBAQQCFgAwCwICBrICAQEEAgwAMAsCAgazAgEBBAIMADALAgIGtAIBAQQCDAAwCwICBrUCAQEEAgwAMAsCAga2AgEBBAIMADAMAgIGpQIBAQQDAgEBMAwCAgarAgEBBAMCAQMwDAICBrECAQEEAwIBADAMAgIGtwIBAQQDAgEAMAwCAga6AgEBBAMCAQAwDwICBq4CAQEEBgIEW4rWLTARAgIGrwIBAQQIAgY/qmWm9WwwFQICBqYCAQEEDAwKZ20ubW9udGhseTAZAgIGpwIBAQQQDA43MDAwMjM5MDEwNTYwMzAZAgIGqQIBAQQQDA43MDAwMjI5MjA2MTk3NzAfAgIGqAIBAQQWFhQyMDI0LTExLTExVDEzOjI2OjM3WjAfAgIGqgIBAQQWFhQyMDI0LTA5LTExVDEyOjI2OjM5WjAfAgIGrAIBAQQWFhQyMDI0LTEyLTExVDEzOjI2OjM3WjCCAYMCARECAQEEggF5MYIBdTALAgIGrQIBAQQCDAAwCwICBrACAQEEAhYAMAsCAgayAgEBBAIMADALAgIGswIBAQQCDAAwCwICBrQCAQEEAgwAMAsCAga1AgEBBAIMADALAgIGtgIBAQQCDAAwDAICBqUCAQEEAwIBATAMAgIGqwIBAQQDAgEDMAwCAgaxAgEBBAMCAQAwDAICBrcCAQEEAwIBADAMAgIGugIBAQQDAgEAMA8CAgauAgEBBAYCBFuK1i0wEQICBq8CAQEECAIGP6pm7EviMBUCAgamAgEBBAwMCmdtLm1vbnRobHkwGQICBqcCAQEEEAwONzAwMDI0MzkzMjY4MjYwGQICBqkCAQEEEAwONzAwMDIyOTIwNjE5NzcwHwICBqgCAQEEFhYUMjAyNC0xMi0xMVQxNTo1MToxM1owHwICBqoCAQEEFhYUMjAyNC0wOS0xMVQxMjoyNjozOVowHwICBqwCAQEEFhYUMjAyNS0wMS0xMVQxNTo1MToxM1qggg7iMIIFxjCCBK6gAwIBAgIQfTkgCU6+8/jvymwQ6o5DAzANBgkqhkiG9w0BAQsFADB1MUQwQgYDVQQDDDtBcHBsZSBXb3JsZHdpZGUgRGV2ZWxvcGVyIFJlbGF0aW9ucyBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eTELMAkGA1UECwwCRzUxEzARBgNVBAoMCkFwcGxlIEluYy4xCzAJBgNVBAYTAlVTMB4XDTI0MDcyNDE0NTAwM1oXDTI2MDgyMzE0NTAwMlowgYkxNzA1BgNVBAMMLk1hYyBBcHAgU3RvcmUgYW5kIGlUdW5lcyBTdG9yZSBSZWNlaXB0IFNpZ25pbmcxLDAqBgNVBAsMI0FwcGxlIFdvcmxkd2lkZSBEZXZlbG9wZXIgUmVsYXRpb25zMRMwEQYDVQQKDApBcHBsZSBJbmMuMQswCQYDVQQGEwJVUzCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAK0PNpvPN9qBcVvW8RT8GdP11PA3TVxGwpopR1FhvrE/mFnsHBe6r7MJVwVE1xdtXdIwwrszodSJ9HY5VlctNT9NqXiC0Vph1nuwLpVU8Ae/YOQppDM9R692j10Dm5o4CiHM3xSXh9QdYcoqjcQ+Va58nWIAsAoYObjmHY3zpDDxlJNj2xPpPI4p/dWIc7MUmG9zyeIz1Sf2tuN11urOq9/i+Ay+WYrtcHqukgXZTAcg5W1MSHTQPv5gdwF5PhM7f4UAz5V/gl2UIDTrknW1BkH7n5mXJLrvutiZSvR3LnnYON6j2C9FUETkMyKZ1fflnIT5xgQRy+BV4TTLFbIjFaUCAwEAAaOCAjswggI3MAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUGYuXjUpbYXhX9KVcNRKKOQjjsHUwcAYIKwYBBQUHAQEEZDBiMC0GCCsGAQUFBzAChiFodHRwOi8vY2VydHMuYXBwbGUuY29tL3d3ZHJnNS5kZXIwMQYIKwYBBQUHMAGGJWh0dHA6Ly9vY3NwLmFwcGxlLmNvbS9vY3NwMDMtd3dkcmc1MDUwggEfBgNVHSAEggEWMIIBEjCCAQ4GCiqGSIb3Y2QFBgEwgf8wNwYIKwYBBQUHAgEWK2h0dHBzOi8vd3d3LmFwcGxlLmNvbS9jZXJ0aWZpY2F0ZWF1dGhvcml0eS8wgcMGCCsGAQUFBwICMIG2DIGzUmVsaWFuY2Ugb24gdGhpcyBjZXJ0aWZpY2F0ZSBieSBhbnkgcGFydHkgYXNzdW1lcyBhY2NlcHRhbmNlIG9mIHRoZSB0aGVuIGFwcGxpY2FibGUgc3RhbmRhcmQgdGVybXMgYW5kIGNvbmRpdGlvbnMgb2YgdXNlLCBjZXJ0aWZpY2F0ZSBwb2xpY3kgYW5kIGNlcnRpZmljYXRpb24gcHJhY3RpY2Ugc3RhdGVtZW50cy4wMAYDVR0fBCkwJzAloCOgIYYfaHR0cDovL2NybC5hcHBsZS5jb20vd3dkcmc1LmNybDAdBgNVHQ4EFgQU7yhXtGCISVUx8P1YDvH9GpPEJPwwDgYDVR0PAQH/BAQDAgeAMBAGCiqGSIb3Y2QGCwEEAgUAMA0GCSqGSIb3DQEBCwUAA4IBAQA1I9K7UL82Z8wANUR8ipOnxF6fuUTqckfPEIa6HO0KdR5ZMHWFyiJ1iUIL4Zxw5T6lPHqQ+D8SrHNMJFiZLt+B8Q8lpg6lME6l5rDNU3tFS7DmWzow1rT0K1KiD0/WEyOCM+YthZFQfDHUSHGU+giV7p0AZhq55okMjrGJfRZKsIgVHRQphxQdMfquagDyPZFjW4CCSB4+StMC3YZdzXLiNzyoCyW7Y9qrPzFlqCcb8DtTRR0SfkYfxawfyHOcmPg0sGB97vMRDFaWPgkE5+3kHkdZsPCDNy77HMcTo2ly672YJpCEj25N/Ggp+01uGO3craq5xGmYFAj9+Uv7bP6ZMIIEVTCCAz2gAwIBAgIUO36ACu7TAqHm7NuX2cqsKJzxaZQwDQYJKoZIhvcNAQELBQAwYjELMAkGA1UEBhMCVVMxEzARBgNVBAoTCkFwcGxlIEluYy4xJjAkBgNVBAsTHUFwcGxlIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MRYwFAYDVQQDEw1BcHBsZSBSb290IENBMB4XDTIwMTIxNjE5Mzg1NloXDTMwMTIxMDAwMDAwMFowdTFEMEIGA1UEAww7QXBwbGUgV29ybGR3aWRlIERldmVsb3BlciBSZWxhdGlvbnMgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxCzAJBgNVBAsMAkc1MRMwEQYDVQQKDApBcHBsZSBJbmMuMQswCQYDVQQGEwJVUzCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAJ9d2h/7+rzQSyI8x9Ym+hf39J8ePmQRZprvXr6rNL2qLCFu1h6UIYUsdMEOEGGqPGNKfkrjyHXWz8KcCEh7arkpsclm/ciKFtGyBDyCuoBs4v8Kcuus/jtvSL6eixFNlX2ye5AvAhxO/Em+12+1T754xtress3J2WYRO1rpCUVziVDUTuJoBX7adZxLAa7a489tdE3eU9DVGjiCOtCd410pe7GB6iknC/tgfIYS+/BiTwbnTNEf2W2e7XPaeCENnXDZRleQX2eEwXN3CqhiYraucIa7dSOJrXn25qTU/YMmMgo7JJJbIKGc0S+AGJvdPAvntf3sgFcPF54/K4cnu/cCAwEAAaOB7zCB7DASBgNVHRMBAf8ECDAGAQH/AgEAMB8GA1UdIwQYMBaAFCvQaUeUdgn+9GuNLkCm90dNfwheMEQGCCsGAQUFBwEBBDgwNjA0BggrBgEFBQcwAYYoaHR0cDovL29jc3AuYXBwbGUuY29tL29jc3AwMy1hcHBsZXJvb3RjYTAuBgNVHR8EJzAlMCOgIaAfhh1odHRwOi8vY3JsLmFwcGxlLmNvbS9yb290LmNybDAdBgNVHQ4EFgQUGYuXjUpbYXhX9KVcNRKKOQjjsHUwDgYDVR0PAQH/BAQDAgEGMBAGCiqGSIb3Y2QGAgEEAgUAMA0GCSqGSIb3DQEBCwUAA4IBAQBaxDWi2eYKnlKiAIIid81yL5D5Iq8UJcyqCkJgksK9dR3rTMoV5X5rQBBe+1tFdA3wen2Ikc7eY4tCidIY30GzWJ4GCIdI3UCvI9Xt6yxg5eukfxzpnIPWlF9MYjmKTq4TjX1DuNxerL4YQPLmDyxdE5Pxe2WowmhI3v+0lpsM+zI2np4NlV84CouW0hJst4sLjtc+7G8Bqs5NRWDbhHFmYuUZZTDNiv9FU/tu+4h3Q8NIY/n3UbNyXnniVs+8u4S5OFp4rhFIUrsNNYuU3sx0mmj1SWCUrPKosxWGkNDMMEOG0+VwAlG0gcCol9Tq6rCMCUDvOJOyzSID62dDZchFMIIEuzCCA6OgAwIBAgIBAjANBgkqhkiG9w0BAQUFADBiMQswCQYDVQQGEwJVUzETMBEGA1UEChMKQXBwbGUgSW5jLjEmMCQGA1UECxMdQXBwbGUgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxFjAUBgNVBAMTDUFwcGxlIFJvb3QgQ0EwHhcNMDYwNDI1MjE0MDM2WhcNMzUwMjA5MjE0MDM2WjBiMQswCQYDVQQGEwJVUzETMBEGA1UEChMKQXBwbGUgSW5jLjEmMCQGA1UECxMdQXBwbGUgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxFjAUBgNVBAMTDUFwcGxlIFJvb3QgQ0EwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDkkakJH5HbHkdQ6wXtXnmELes2oldMVeyLGYne+Uts9QerIjAC6Bg++FAJ039BqJj50cpmnCRrEdCju+QbKsMflZ56DKRHi1vUFjczy8QPTc4UadHJGXL1XQ7Vf1+b8iUDulWPTV0N8WQ1IxVLFVkds5T39pyez1C6wVhQZ48ItCD3y6wsIG9wtj8BMIy3Q88PnT3zK0koGsj+zrW5DtleHNbLPbU6rfQPDgCSC7EhFi501TwN22IWq6NxkkdTVcGvL0Gz+PvjcM3mo0xFfh9Ma1CWQYnEdGILEINBhzOKgbEwWOxaBDKMaLOPHd5lc/9nXmW8Sdh2nzMUZaF3lMktAgMBAAGjggF6MIIBdjAOBgNVHQ8BAf8EBAMCAQYwDwYDVR0TAQH/BAUwAwEB/zAdBgNVHQ4EFgQUK9BpR5R2Cf70a40uQKb3R01/CF4wHwYDVR0jBBgwFoAUK9BpR5R2Cf70a40uQKb3R01/CF4wggERBgNVHSAEggEIMIIBBDCCAQAGCSqGSIb3Y2QFATCB8jAqBggrBgEFBQcCARYeaHR0cHM6Ly93d3cuYXBwbGUuY29tL2FwcGxlY2EvMIHDBggrBgEFBQcCAjCBthqBs1JlbGlhbmNlIG9uIHRoaXMgY2VydGlmaWNhdGUgYnkgYW55IHBhcnR5IGFzc3VtZXMgYWNjZXB0YW5jZSBvZiB0aGUgdGhlbiBhcHBsaWNhYmxlIHN0YW5kYXJkIHRlcm1zIGFuZCBjb25kaXRpb25zIG9mIHVzZSwgY2VydGlmaWNhdGUgcG9saWN5IGFuZCBjZXJ0aWZpY2F0aW9uIHByYWN0aWNlIHN0YXRlbWVudHMuMA0GCSqGSIb3DQEBBQUAA4IBAQBcNplMLXi37Yyb3PN3m/J20ncwT8EfhYOFG5k9RzfyqZtAjizUsZAS2L70c5vu0mQPy3lPNNiiPvl4/2vIB+x9OYOLUyDTOMSxv5pPCmv/K/xZpwUJfBdAVhEedNO3iyM7R6PVbyTi69G3cN8PReEnyvFteO3ntRcXqNx+IjXKJdXZD9Zr1KIkIxH3oayPc4FgxhtbCS+SsvhESPBgOJ4V9T0mZyCKM2r3DYLP3uujL/lTaltkwGMzd/c6ByxW69oPIQ7aunMZT7XZNn/Bh1XZp5m5MkL72NVxnn6hUrcbvZNCJBIqxw8dtk2cXmPIS4AXUKqK1drk/NAJBzewdXUhMYIBtTCCAbECAQEwgYkwdTFEMEIGA1UEAww7QXBwbGUgV29ybGR3aWRlIERldmVsb3BlciBSZWxhdGlvbnMgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxCzAJBgNVBAsMAkc1MRMwEQYDVQQKDApBcHBsZSBJbmMuMQswCQYDVQQGEwJVUwIQfTkgCU6+8/jvymwQ6o5DAzANBglghkgBZQMEAgEFADANBgkqhkiG9w0BAQEFAASCAQBuh4wr5uvadnhxjnjFXz74oJ54RkTQz16u050+7+y7QKmNS2u1XvVtnavv09shxeoholGeeJC5HSrKzW0qyD0S4mPme1RIGvdMhuoWBdAnX5MyrZqV1l6uTNCmisMcd2/RTeg12tANc/82ZUHirLSKsdKPpWYZVOC8kSwtH1rkWgyEWIycf+AVmUHQHmoGozXNNUtKdJMN4Stv0C/DulMerZ+DIo+WZtc6kvvpvKrEABtiBPosufjvcaCBdR1ByGp32Aqh/SOfkP2IE75PWy/9UOewqtOh7NGECp2ORYUNpclFbPVdxLubiSvnDgZ6z0wMIaFfwPKZZHUvf/+PLO0F' WHERE id = 26331;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.plain_password AS plain_password_6,
  t0.enabled AS enabled_7,
  t0.name AS name_8,
  t0.surname AS surname_9,
  t0.address AS address_10,
  t0.celular AS celular_11,
  t0.image AS image_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.country_id AS country_id_15,
  t0.season_active AS season_active_16,
  t0.type_account AS type_account_17,
  t0.is_pro AS is_pro_18,
  t0.purchase AS purchase_19,
  t0.purchase_platform AS purchase_platform_20,
  t0.membership_id AS membership_id_21,
  t0.coupon_status AS coupon_status_22,
  t0.phone AS phone_23,
  t0.google_auth_code AS google_auth_code_24,
  t0.google_auth_code_verified AS google_auth_code_verified_25,
  t0.date_of_birth AS date_of_birth_26,
  t0.deleted_at AS deleted_at_27,
  t0.is_deleted AS is_deleted_28,
  t0.country_id AS country_id_29
FROM
  customer t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.plain_password AS plain_password_6, t0.enabled AS enabled_7, t0.name AS name_8, t0.surname AS surname_9, t0.address AS address_10, t0.celular AS celular_11, t0.image AS image_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.country_id AS country_id_15, t0.season_active AS season_active_16, t0.type_account AS type_account_17, t0.is_pro AS is_pro_18, t0.purchase AS purchase_19, t0.purchase_platform AS purchase_platform_20, t0.membership_id AS membership_id_21, t0.coupon_status AS coupon_status_22, t0.phone AS phone_23, t0.google_auth_code AS google_auth_code_24, t0.google_auth_code_verified AS google_auth_code_verified_25, t0.date_of_birth AS date_of_birth_26, t0.deleted_at AS deleted_at_27, t0.is_deleted AS is_deleted_28, t0.country_id AS country_id_29 FROM customer t0 WHERE t0.email = 'sergio140720@icloud.com' LIMIT 1;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";