GET https://babl.apto.gr/admin/remarketing

Response
200 OK
Referer
Browse referrer URL
IP
84.254.4.129
Profiled on
Token
0f6c4e

Query Metrics

11 Database Queries
9 Different statements
9.48 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
2.22 ms
(23.46%) 		1 
SELECT COALESCE(s0_.cycle_key, s0_.cycle_reference) AS sclr_0 FROM sms_recipient s0_ WHERE s0_.cycle_key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR (s0_.cycle_reference IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s0_.submitted_at >= ?)
Parameters: 
[
  "1ad7ee402982cc23cd35754a93fa59e4d39cab6b683eac32414aef367ce62743"
  "c1a02445448c060b271d9197048350b6fb8ceaa8433de8627b05b99fb9de5019"
  "6242063df4b0c77c9b275ebc7a7901b0b203ea986fbd067d670b0d6cba884b7b"
  "1f443207d07f10365d606f0e76c09fc56f4f9ca8072b14046b81d83e73ba3662"
  "27b4d7ac6b0b8ae1cb78c4e627593aa5e6227a99e1f277dd73810d495549827c"
  "b8f80a035266d8bc83ff09008df354f910ef7185e8a386fc3ecc448e1166b93c"
  "ee44dc9176973ea62dbe9187e00d243c86dfd068ac67cb62f07d9b7f5a9b6ac4"
  "efafe4ed104c74f58b748128735656bc834f53624f5aa38779c243d9a87e1017"
  "651b428a82a664280743a44a7c6fff643934431b36cab8d49515b84a1fcd8e56"
  "d4f7cd5f2ea64577f0e3ab96bb6ec316fd1628abe528ce7fc3bf16253bd9810e"
  "5c5b40ac92e2e435422f91fb0aa2cd50d51055af5ffeb0c063a0ab41f5a326d5"
  "8793a483c9941bae412d26f87edeb1d54b6465e115d4b30206780406911d0fbc"
  "abf0d4f1e9bcb6efb149a7c7a991dd145729a2a23982fc15e26c9063957db65f"
  "0b83f2a1fa241a30f7a703755fabb02bea39a62e2ba7679fc67f65f2eaaec34f"
  "3ea888af99727e3b9708fddc49befcd1c343d75e7b494e9ad5231007bc783e0c"
  "e7f2ceed4c7c47991170edd00157996676350d042f3bd73f257f95fb0db10155"
  "1342b741c97602ef81f41d75655df3fa05c17f4451e638212d47827e4409c4e6"
  "f8835c938b1bf07a7e52158cd1dfdb706fc9e5be622fb4d35104a4c9ed6d38c7"
  "ae264fb6d03a6e3fd13956ec447c1831b9de2573077a0b8899eb3e643129c658"
  "82aec0b6a2f985ca773614371a609612f5b419158634d56124077813ae1421c0"
  "61a7f9dd16d30111dc83fce7d1cedd64a18ea0343e7e50a96666b9703600ce38"
  "f15fe88c09124db719cf2bd128607f6d9e58e578e893bb224324ec36ff09dd6f"
  "02a11089b53e0779d01f720867f6546163f074834ae6cde61581922c70cc4a9c"
  "405a50f318cfb2775983bd1ba7a4355740c68eb9a66a38437ef207f35d3eb44a"
  "dde08e2a373fb86537644eb690a429a03bae615c686169e6a70ecdb5ee8a0bb7"
  "b5903436995d31a46302e85fc280afc90682d07b3a6d21656cc23b6535e38d89"
  "4f9573a58fc5bd71b9acad1eab29014ca6010dc9d6693d78676b5589325b20e2"
  "0f26571886def5424bb6154a207fb458d0df53979d54efe47aa846cc20006a94"
  "02d291ef822ef4bca73e52d6b9b5d3d0e89c1fe20adefdf982f14ad37519ab08"
  "422fb40f6b0cc1afbd6fe1d8d8d28fa2bd16c9154a0c0c6f33fe03fd823f421a"
  "e60e2a5ba140b17076b4a4072675f7ed4e3d3debba41db10b2b323ae5a638f54"
  "b7bbca4512477455deb693bd7f5f4e4275b4c012513a30ef838ebf88ebf06968"
  "13a34e96b5e9c9b6340aeb26529a1b8dd1afbfa2c75660b6cb98582af2da1d7a"
  "ce4fbb2ab4fe082f4538c5db9fea05a1838a48e8cf979f96e671fbce56125bb3"
  "f4a64690f6f5f0e1ed31515dbba5c47548505171bfda862463dc7fd36b5fc890"
  "c978f5c48661b892200629a789ab558b0ea08bc33af6dc67205cc17c4b1e9756"
  "447be874f2e8ae60db5a6f10e81029ac2129bdda339b357cf03ad838aec3f331"
  "781c627d1a3b7d46e8248bc4c1fa89a8584556e142e6cd81b5980f74279ff61c"
  "ee15cf45f2620219b445ff30a2531762bd6798da2ff15ede3b2f51b78d448e6e"
  "5432b0830157f0a241f18ecc5a9d86842e0f907b1c59144eaf0680725ce6ed30"
  "baa8735ca22c81010e4a081b988b62f01420b8096b6c5e924ea3e2cfe51dffdd"
  "6087180d1553eae80e20f71639f678c701a8ab00b802432f943effb16010910e"
  "5de9745f0edcc3520e2753c37f4f50f6e1abb74d97c139849f1fa7c13173c8eb"
  "04968a00f882ff7a271a225406de3cce1bda34f2270fdc643a9899cafae7d1d1"
  "09427a830443c72323d3d2240acd9b7bb26abb34a8d64c9541174b8b6b353eda"
  "5634d950291bbfb56898e504c17b7f492896df22ce10936014c1e2e283a74779"
  "5fa660328eb0e343913eb32a099ef2deced17f6fae681f58f8dcdf8787d63c5c"
  "5d06a80b27c7ba80592bb5dc361663af92357a4ae03d2650344d159ece5f5384"
  "b7343cd224ef646507d5c51565433a00fb0b9fd535d92643ddad0ed9952971fc"
  "dbc734e85555f291404a5e141cf0c14409c72392ca8b8892b91107d85c193014"
  "40182ded31e39cafa1004ca6812800b40adb0efa6b25af4455418c7013286def"
  "eadb1665e8af3ac18c315fbcbd23139c0075c76d522cbb8fd50f30fd00dcd0dd"
  "c719d7e84ab274028edd902c7e0ef791b691aca39d7ca1464b49be594371b0da"
  "ccbdace9ef8cb15a7502a01cd69fd37fb2ed1118f20ff31009c4639989ac2cf8"
  "e059418f2e580747b852928316e57ec7965b1f9e64ecbaca9616832707c5980e"
  "fab590e3c23c816b9bc5e215aca28a9e2d54ec4a2f08acd6c42eb02c53e022fb"
  "4b5e9924a443f8a89cf4cbdc1f29fc207c8dca95c3bed51e5a7202d5215de158"
  "e698acf52554338877684bcb67bfff85365d2e670262852102159c8f7a16fdb8"
  "7afb25ff3d7dc0b2e220d6d37f7c8471cbb3bfa47c99a40362979c6ff4f326b7"
  "86dd199d5d2214cd2a374552f087ad37ae093974d7615bb02af78ede37c43271"
  "8da7e636b12fd06d075972f00e7d92f523a364f5116deb4d2e01e2a55c66936b"
  "1457b857ad6a36fb328c7d87fe47de76f53e23427e6c53e044a89f4c6f9f4824"
  "299318c42f4a0357cd3214c436f59ded350b2b7f8d317ca674bf1eafe256c05a"
  "d8fd5138dbf53e6bd021aef19232a16854554b6ec98146878cc15cedd84556d7"
  "3e394511f8c824b27e590d360428c169bea8300d2f3211212b9c88c511fe0e87"
  "a4be23447fabae4989f6f0de24045bdf4f60b2971ce1165fc8fb4092ea30ed88"
  "ffbb96905329d3814746fa5dbb719ab54df3f5b82723c30b768760c30ee8a01a"
  "68baf8079919a599778c46185733ac44a516fdf80068930d1c09cd714f6c56ea"
  "fef08c2708e086e0565bf9bec53db3e3aeaba6cd8315973acb698060d1c3b22d"
  "ea5048f34f150e4e51bd2ae690bbd23ff3d17ee4b1dc9cf20d2e938d143a0105"
  "ce7ea4389d5e02a280bc1bb684c6c3497dc7ef7650667426604f0776990e940c"
  "65b27a884fa6071d2f52403ac202e99c061bcb446f801e28bda3a843a66d1f40"
  "ec309f8d550bb24a0b1be96bd881d00de4720c3381b62b47310617310c1886e2"
  "1a8fa4ccee5165a7a1014eab64def7e4189407217cef7886301680e95ee6683d"
  "1d118a659203d653e03e437d2353eab23c975c3f9a4d1e3d64eba037427e617a"
  "275218914cafd3e0e6124bb60fab0bd13a160f849e437cc233f8e8a043ccab5b"
  "a46ce8c99cc02b5858128837b1f9a486ce7894556ae7edae2eb0e1f81bcf8013"
  "8bbecfabc35587d00c02cc6a683b9c347ebe3e5ee0832cc37703956214e58ad2"
  "1fc9b255241ca7ca1dc912e3ab6c6d8c53684a51104d2e114b69cef9b5d0a467"
  "c34876eb51814ef367f724154e4db627dd7e3a76cc3c8c245bed826ff799f533"
  "c4c50f6fbc4e68a66029b87188bd02c4176359233cbd12bb20e10fd4ed73ddfe"
  "a79df69c61cd7a4ce6dae22b85bf91f73170eaf0f62cd92a52e17e26c7d64c6c"
  "45c78626566e6078bf6c7daf910ad1970e413ec23f9b1e1f312a523f8a7ad14b"
  "d51e3c5661edba314add96627650a6a010fc32f3d4368d8b895989d94b613309"
  "6dd6515cdfc891462f4a039339479026c4622518d210c4f9549c70923391d6e3"
  "43e24a6db769a6d0afd85702c9671605a77d3f65092ae8a3edff8e1eea439ea4"
  "361fb74141980b059bedc534d5e06bb7782c32840af5830c3e059cc525344588"
  "defdd29581f146f0a20a4ab2c13432596b93b41ea4e6921058408fc148c3f1c9"
  "3b2fecf9fb569cbcca9bb1d31ea7b1001d88abf59bccfe8634edf86fed92b932"
  "8588069981f41c08a7ab1dc2efd5b358f36a025681ca77d11c33d5d53004f63f"
  "f4b333765cd163db4324b545ae9f037a8bfe3ac2ba903bf405cd94e3722e25d6"
  "82e86a482e2b2cdbc22d3402700fbdcbd5b761ea0706f7bc9a9f9651bf3a6b6a"
  "442676b75e3f5b3fb2f282d09ac1eb922735ecabb42a13fa248b6817ee96e687"
  "61e8d69422e6fc658a209adf482afeccd68033ccbec727588bed7416b466b6f5"
  "3a09f0b56c6594c6473dbfd81225110a96f6f5f3c284b47bda32ac2c9f1923f5"
  "3fa3027361bb659f863f9b60e6e577349a45b6284daccd4ab95af753ff1d4f17"
  "342563726127ad3ebd66c9f701602b590acff4102702dbcb033a8683cdf39480"
  "20fd7b09559588d836d47166116253bac4720cab9f0ff524561acc36e25cdcda"
  "9924bea4c8ce9621ff8dd1c359c1fdf00bb3ec0f6f14d556690e61a20a87e873"
  "ef8ad63253096a035026cfebcf747d34a2c6705d910698a68ca7a4e366b95919"
  "00d70d2ff0027fa1db5366d1a43f07ddd38d6607667dc38cc26362a2e207e0f3"
  "0c5f0dfe610d668d8d766767010369c6ee5b9f75e1f48930a5bffb7db8d8d530"
  "e783ae4316fcde3ab3ca51adce544a419c21be3ed1c137e40210b8f19eb3790f"
  "bf2f2d1a388b91e8bb91039c5557a415b997500faff8c660b1dfab4a15854bba"
  "fdfe0de94d867befe72a08c20ad906779363ad04517430cb8cbf957a062b6223"
  "36eba759c3a69b50cb823fc1d70a8908d42844f1d9278b2237634b681ecce4be"
  "8886cce3b9374bf8f0257c47e8c93272c0d3f48dc2debe40ca1c2e0a25296171"
  "873519cce211cf3ec215d535285e0cd693c281ce88f04206667249049df09ab4"
  "9d3632b7e1a4e1078a5c352b5d16061a6ab0d6a60972c53e3e9fd39af7a38135"
  "f14b1c993cdcf3e6d2bad3e125fde80106c626d27ea5aa6c552ceeeb67468800"
  "a812eb0eaa93694fca064ac5e98c83bacd66d209f1445de910522907f36df26c"
  "35f9af2e9881605921ffab31a1225262eb3c26efac7fe418179436d7d4e9cf99"
  "c0281428b1ed5a7188f604b58698452048b0d3b2383aea8f938e65381f6b66f6"
  "a9bc012e8ac7ca046c4045faa9ef9fdbecf792f611192b3bd15e52257f80fe1e"
  "0eb10e360761009c17c6e19ce5a87b91da4fb5b0a3bfb85d129f7f661ab89a8a"
  "49f8876cf3219d021e7ffb6636028916be7ee1f603952ab0f216d3e355da2e65"
  "5a379ecc46e8e0c9b7ed96079bd2ac32c7e561294dd49c7c12793bd7f1a200f0"
  "c23c999dd37898a014ed9084a30cb64b4a9a321d217f12c267740414499104a4"
  "f1eb95fecf20f1791e32293bc59aca7febd016df55daab681422bef4d6ee0d3b"
  "986df9f92f77c78bcf8e5efb1de961eb8d2f33f0d9f2ae2be22b83923db60f82"
  "c885406dcb8681c898df92513f270b382cb036a369178c4347243684e6e0d8d6"
  "63dabd1bade02280c818ba67124bb6f0f3b22b54a4c71d4f1d67948005141cb0"
  "073d7f45fc53d5012445a7186f38f429317971add503cac3ad1c7653fd617ad5"
  "efc3fd1041058d95dd3efc986aacad7e82cf12ffb2faeb6b9870a0450ae3ae02"
  "24f6e23100e550fb6516335fc095df4489c839205d7a30c09bb7e01d05a92466"
  "ca1d3aca6845517527b1912f96e7508a67929a6beb029313fbec6dfe1470c7b4"
  "2e578d11d7c84714a31fc70d93a4c1296fd1cd5ac718b869e74853bdf3538ae4"
  "7c7a90d3cdef66e1830e25c66e526a69d7532c99b9bc6507ad177446e5226a46"
  "9d0c3e4d7480efced21eff17d76ddb8bd24faeaf6ca80957a314193d726653d8"
  "a624861418723e86571f3841f5bf1d9434111d676427cda345930aeef49776e2"
  "4da8d3d4226b2afe18581813182dce175946f0091882bb71a2eeede721a47f58"
  "10de33398f66b91c6161fb335ce4be6d6f4ea307b035cd72f11b4da5f3833659"
  "430a43d793fb44dab9161d68f2884bf3c3d19058eca7809c7872d1e961ba61c3"
  "888fdd16465259eae598490213220102df261189ca69dce307d82dad796d5c48"
  "db049b00c5b076beda8e709d201654fc0108b9f69cfa7f2f1f540bda83f7f957"
  "122586f31e588ee8541843bcb98d6b55210aa98a08bd5b37ec722883c7f5f039"
  "189dc7bfb995ed5684890f4cda542c3da326691b97fc50ea5f8336f8ca8bc7de"
  "eb84bbfa6847f1ea625ba96504bc68b2cb628232549a157b1c2362ac1fa991d8"
  "bd5bbc7258ad6f2ac1a81e443979806bd107ed71cd6ebb9e621f93447220d9bc"
  "171fca23b244f07e49a85c5553ba2f899fb66b7238f6bee58b3898fb8294576b"
  "4dcf5f4cc77385525fc8d8bebe6df50ad431062218ccabb81f8e37d6ddc475db"
  "fd71011bf475aea1073866275b89b5c31bb97f0210c7550bd229af726fa2b598"
  "24164367f2fb2e0aa202b74bb346c1fb6a86d38c957cd75f9c132d539a6affe9"
  "6c8fb555c1073ce8d38b0b7acbf4ffa3ce50d088336f7feea537002a5714ee58"
  "b378d93c1b31cae3e13a78b6859e8d97b5f138499ca32d1ae6bbd3ada412a27d"
  "6f3a6211fde3b49a654e1b89ab43ca237c6359a1f18e54422a2f3a59d35182e5"
  "5854a2f667d019b9a2a3990c48c3a190eb476213a0ffa3aafe15faa20b9a7f83"
  "87dda85c68ce578fc37fc6e814927dd76ad52d0ba43a56698b9093851c94f89f"
  "845b7def672c27dfd39a550ea8212a60c0189290d8d29b106770390820b90eda"
  "0f5d6fe0276ef63cb4c094c007847ffb18b3c94ce3748a037e1c895bbd56816f"
  "cbcd3579faaf670c678d1a094a4708565b118df45ea98a5a63696b47b70a7891"
  "756ee90a1b8292a3694cb7a7d98d3a115068421dca3c3d47d5839b5fd7f69620"
  "e65a4c3203f9332d467d68e33f597ff9af197bdc6291ea2b4476574e1068fcbd"
  "66c8be51e84f917a386e5b05bf2f29153844577df844f57091e89208907da431"
  "264236ae1674dbc82d35935f3416c24bfd9cfe8c115118fd4177b58a6410ba1e"
  "f2548d04ec211bf29f30e9026ce405fe9a9a4af7ee033eba3edfd8f8b76983dc"
  "493ee48aff5850e41072e41b0d475b035fb0f7a00bf0097e330391371ad8c10a"
  "ba5c2d1544c40a5dd688f1289b627f0c1b729bc4af59368cc335b9914121bc6c"
  "d771d74de48d3d8ed553abf9ce6a3102e01b8f066ce4df3a001bbd8c9ef5701f"
  "d3b419ec3566722d93b567ade5e5ad4b0e89b8dfcf11af9c33c58d6e0ad5aadd"
  "4201f8443325bbe797daf0fe3b0f0637c0fe84cfeaff85e083248ab444736426"
  "04f8b05475cd0f42606e02e748baf2992b5e205141f74c9cd555fadb458d8b02"
  "ac8f7ee5140a44a3f6e66fde15bc79d574a4860688d429075c9e46e335e56384"
  "fb233d2269eca1261162ec7e16491b5b601544c98c31ae9f0e76d53b5c796241"
  "bf1ee145d1bdde0b27b7a80388dc3d2f15ed7b4c888e03ba024ed9eb57c95207"
  "723a12756e0c4778395c35b68942e7be89825cf422a4a29fd891650a16580d7a"
  "bf311aed566dd7866edfbac327282a902a7fe4b250ec03d2fa1d9acf44838496"
  "c02e2bf9339cca8742ca88b130e24bc950b2d82dc2d069a049e1bdc8c8846503"
  "087a77431d88f52b17f07ffde11ce41b2a42f76d86f4d8d9630a5b02e904b73f"
  "15ba1cb4b6dcc97b3284a5efe49f9c293191404c8e7b8721fc77dfb9546e3060"
  "d36209d4614df5d5531f1c532f5354b217a2cfb3c045630a32ada517b60c9064"
  "26853c084c1ada632f9c72cd0bb5fb18868ce8cbf4d14b773d4cd7cc6f1108f1"
  "93fc725360b0ee2d2e4c1bc38616a8cc50d2b4d04f866762e1afca4a8a5fbd2a"
  "80ab80d0505990d1a278276c014ea06c2f7d81e091d00c12c188917c7c2de6df"
  "50e7289473970f5f2c44b9612b8219813d6e0193a47ac3bf4d2195743f0cda7e"
  "593260e4a167e81956e16b244b6f00c99560fc59a0ce6e87eed6fee5ab2c048c"
  "753ca416720a670dd0ad0a001e16883ab6f2013c31b72077664dfcf750c17779"
  "85ac70edcd62ca5ad22f73be5ef03d431fde3650f9df6e09cfdb0d03e9ff5ad0"
  "f65c70161f1aab8c8641e532097fa5c14542cae6fcc80b17a5991a9ff8d56354"
  "328b13118b24f700c0c232af275bf13316d26f8f942d24a497d3af6b79f83d27"
  "5a66b445b507c997c9ed4e03a24bbcadb4a9efe10980f6d7ad89604e3ec4b68d"
  "22b89e99bc17c966b861156ba07d1c226170af23ff17da1fa83a6a656f212c28"
  "49f75163f1229d0a56d206a62745f7687935c0a3f4f7f7494d6291670873aff8"
  "3b971c7ed1d74e6b04f4df38965b855ce6755b365bbbb7174beb8c110e8de0b3"
  "d26ec760d6d3160232fe7224f01da684aef328da0ebccc1654a4a7026bdcf0dc"
  "c75ab94d611ee05d199f587eb0e5e80c599cba49f62c08b33f0b2dff7d63b047"
  "ecdef2d55ea0c6d03a72d2bcf04cc8aacd798fa5240ef3a8968856df79d8879a"
  "ae66889a6c4c11b8a97c82de40a2a5343be65d4522f4a8d6da79c3c13f97a67d"
  "6c1097001ff3d76dd744dbf5ce9b0bb1736de22b1ac25c97bf5a0cebdc033d06"
  "5aea6828dda0ca171aa63d2a0699a7b2bbf70fbdc19b97aaac41f18ea0e0b8a5"
  "5ca0433c59c27542b7af9ca950ae9d833d22d3813cc9a6050721669e05395175"
  "b462a4c1ae14b215a58727523ce71a6105f1afc11b6e047ba15956d2e2ab0a60"
  "96724affff4832a1c2e742889f88c85d647db0044a6aef3d04cdf6d6d1a19f20"
  "b69d3760a765b0bfeb2c024962c982d6b2e6a815e9bc410af164b4db31265f1d"
  "741964c1f4437d6d67ebd65cf75dd5710c31eae7770cd1c119bc9c2e30d4e04f"
  "6d3b2e2693e6680bb64eb6489cf6fe1c5b9a48e07cac71726d5217155c6d546b"
  "b6d4f1445d6e3d51c2d3183924014b19c5446c86e008bf6b7b3382777f11ceda"
  "d6020a65df6c235801f4891fdcc404ba36135782989adf5e72e14492e78390b6"
  "ffa733b1aa6afa801fc8421e7845e17101a1c96c5ba745ef784afc8ac93f70b6"
  "f36f9eb4804efd68ebb6753bd4671c86f3791f74b0da9d59e7c3729cda4e440f"
  "a9648e53252182a27548aca84adb5ec09e3a803ac758de55c43e87d0103770fe"
  "f607e0972c9fccb0b367424e908c2a4d9f87aa6bfcd71f6668be492dc00f52f2"
  "dfc48681e4c47af531000ed1963804187abc4d766153781e89587416e9b39197"
  "963758c3c6251a75934e6bbd71c3e1af1c81dc53e52d3ea74ffefaf9fa3084de"
  "def116c90df09aa772f4dffd3941f51ad6f394ba5631d8810f78c808c9fc1abb"
  "1ad7ee402982cc23cd35754a93fa59e4d39cab6b683eac32414aef367ce62743"
  "c1a02445448c060b271d9197048350b6fb8ceaa8433de8627b05b99fb9de5019"
  "6242063df4b0c77c9b275ebc7a7901b0b203ea986fbd067d670b0d6cba884b7b"
  "1f443207d07f10365d606f0e76c09fc56f4f9ca8072b14046b81d83e73ba3662"
  "27b4d7ac6b0b8ae1cb78c4e627593aa5e6227a99e1f277dd73810d495549827c"
  "b8f80a035266d8bc83ff09008df354f910ef7185e8a386fc3ecc448e1166b93c"
  "ee44dc9176973ea62dbe9187e00d243c86dfd068ac67cb62f07d9b7f5a9b6ac4"
  "efafe4ed104c74f58b748128735656bc834f53624f5aa38779c243d9a87e1017"
  "651b428a82a664280743a44a7c6fff643934431b36cab8d49515b84a1fcd8e56"
  "d4f7cd5f2ea64577f0e3ab96bb6ec316fd1628abe528ce7fc3bf16253bd9810e"
  "5c5b40ac92e2e435422f91fb0aa2cd50d51055af5ffeb0c063a0ab41f5a326d5"
  "8793a483c9941bae412d26f87edeb1d54b6465e115d4b30206780406911d0fbc"
  "abf0d4f1e9bcb6efb149a7c7a991dd145729a2a23982fc15e26c9063957db65f"
  "0b83f2a1fa241a30f7a703755fabb02bea39a62e2ba7679fc67f65f2eaaec34f"
  "3ea888af99727e3b9708fddc49befcd1c343d75e7b494e9ad5231007bc783e0c"
  "e7f2ceed4c7c47991170edd00157996676350d042f3bd73f257f95fb0db10155"
  "1342b741c97602ef81f41d75655df3fa05c17f4451e638212d47827e4409c4e6"
  "f8835c938b1bf07a7e52158cd1dfdb706fc9e5be622fb4d35104a4c9ed6d38c7"
  "ae264fb6d03a6e3fd13956ec447c1831b9de2573077a0b8899eb3e643129c658"
  "82aec0b6a2f985ca773614371a609612f5b419158634d56124077813ae1421c0"
  "61a7f9dd16d30111dc83fce7d1cedd64a18ea0343e7e50a96666b9703600ce38"
  "f15fe88c09124db719cf2bd128607f6d9e58e578e893bb224324ec36ff09dd6f"
  "02a11089b53e0779d01f720867f6546163f074834ae6cde61581922c70cc4a9c"
  "405a50f318cfb2775983bd1ba7a4355740c68eb9a66a38437ef207f35d3eb44a"
  "dde08e2a373fb86537644eb690a429a03bae615c686169e6a70ecdb5ee8a0bb7"
  "b5903436995d31a46302e85fc280afc90682d07b3a6d21656cc23b6535e38d89"
  "4f9573a58fc5bd71b9acad1eab29014ca6010dc9d6693d78676b5589325b20e2"
  "0f26571886def5424bb6154a207fb458d0df53979d54efe47aa846cc20006a94"
  "02d291ef822ef4bca73e52d6b9b5d3d0e89c1fe20adefdf982f14ad37519ab08"
  "422fb40f6b0cc1afbd6fe1d8d8d28fa2bd16c9154a0c0c6f33fe03fd823f421a"
  "e60e2a5ba140b17076b4a4072675f7ed4e3d3debba41db10b2b323ae5a638f54"
  "b7bbca4512477455deb693bd7f5f4e4275b4c012513a30ef838ebf88ebf06968"
  "13a34e96b5e9c9b6340aeb26529a1b8dd1afbfa2c75660b6cb98582af2da1d7a"
  "ce4fbb2ab4fe082f4538c5db9fea05a1838a48e8cf979f96e671fbce56125bb3"
  "f4a64690f6f5f0e1ed31515dbba5c47548505171bfda862463dc7fd36b5fc890"
  "c978f5c48661b892200629a789ab558b0ea08bc33af6dc67205cc17c4b1e9756"
  "447be874f2e8ae60db5a6f10e81029ac2129bdda339b357cf03ad838aec3f331"
  "781c627d1a3b7d46e8248bc4c1fa89a8584556e142e6cd81b5980f74279ff61c"
  "ee15cf45f2620219b445ff30a2531762bd6798da2ff15ede3b2f51b78d448e6e"
  "5432b0830157f0a241f18ecc5a9d86842e0f907b1c59144eaf0680725ce6ed30"
  "baa8735ca22c81010e4a081b988b62f01420b8096b6c5e924ea3e2cfe51dffdd"
  "6087180d1553eae80e20f71639f678c701a8ab00b802432f943effb16010910e"
  "5de9745f0edcc3520e2753c37f4f50f6e1abb74d97c139849f1fa7c13173c8eb"
  "04968a00f882ff7a271a225406de3cce1bda34f2270fdc643a9899cafae7d1d1"
  "09427a830443c72323d3d2240acd9b7bb26abb34a8d64c9541174b8b6b353eda"
  "5634d950291bbfb56898e504c17b7f492896df22ce10936014c1e2e283a74779"
  "5fa660328eb0e343913eb32a099ef2deced17f6fae681f58f8dcdf8787d63c5c"
  "5d06a80b27c7ba80592bb5dc361663af92357a4ae03d2650344d159ece5f5384"
  "b7343cd224ef646507d5c51565433a00fb0b9fd535d92643ddad0ed9952971fc"
  "dbc734e85555f291404a5e141cf0c14409c72392ca8b8892b91107d85c193014"
  "40182ded31e39cafa1004ca6812800b40adb0efa6b25af4455418c7013286def"
  "eadb1665e8af3ac18c315fbcbd23139c0075c76d522cbb8fd50f30fd00dcd0dd"
  "c719d7e84ab274028edd902c7e0ef791b691aca39d7ca1464b49be594371b0da"
  "ccbdace9ef8cb15a7502a01cd69fd37fb2ed1118f20ff31009c4639989ac2cf8"
  "e059418f2e580747b852928316e57ec7965b1f9e64ecbaca9616832707c5980e"
  "fab590e3c23c816b9bc5e215aca28a9e2d54ec4a2f08acd6c42eb02c53e022fb"
  "4b5e9924a443f8a89cf4cbdc1f29fc207c8dca95c3bed51e5a7202d5215de158"
  "e698acf52554338877684bcb67bfff85365d2e670262852102159c8f7a16fdb8"
  "7afb25ff3d7dc0b2e220d6d37f7c8471cbb3bfa47c99a40362979c6ff4f326b7"
  "86dd199d5d2214cd2a374552f087ad37ae093974d7615bb02af78ede37c43271"
  "8da7e636b12fd06d075972f00e7d92f523a364f5116deb4d2e01e2a55c66936b"
  "1457b857ad6a36fb328c7d87fe47de76f53e23427e6c53e044a89f4c6f9f4824"
  "299318c42f4a0357cd3214c436f59ded350b2b7f8d317ca674bf1eafe256c05a"
  "d8fd5138dbf53e6bd021aef19232a16854554b6ec98146878cc15cedd84556d7"
  "3e394511f8c824b27e590d360428c169bea8300d2f3211212b9c88c511fe0e87"
  "a4be23447fabae4989f6f0de24045bdf4f60b2971ce1165fc8fb4092ea30ed88"
  "ffbb96905329d3814746fa5dbb719ab54df3f5b82723c30b768760c30ee8a01a"
  "68baf8079919a599778c46185733ac44a516fdf80068930d1c09cd714f6c56ea"
  "fef08c2708e086e0565bf9bec53db3e3aeaba6cd8315973acb698060d1c3b22d"
  "ea5048f34f150e4e51bd2ae690bbd23ff3d17ee4b1dc9cf20d2e938d143a0105"
  "ce7ea4389d5e02a280bc1bb684c6c3497dc7ef7650667426604f0776990e940c"
  "65b27a884fa6071d2f52403ac202e99c061bcb446f801e28bda3a843a66d1f40"
  "ec309f8d550bb24a0b1be96bd881d00de4720c3381b62b47310617310c1886e2"
  "1a8fa4ccee5165a7a1014eab64def7e4189407217cef7886301680e95ee6683d"
  "1d118a659203d653e03e437d2353eab23c975c3f9a4d1e3d64eba037427e617a"
  "275218914cafd3e0e6124bb60fab0bd13a160f849e437cc233f8e8a043ccab5b"
  "a46ce8c99cc02b5858128837b1f9a486ce7894556ae7edae2eb0e1f81bcf8013"
  "8bbecfabc35587d00c02cc6a683b9c347ebe3e5ee0832cc37703956214e58ad2"
  "1fc9b255241ca7ca1dc912e3ab6c6d8c53684a51104d2e114b69cef9b5d0a467"
  "c34876eb51814ef367f724154e4db627dd7e3a76cc3c8c245bed826ff799f533"
  "c4c50f6fbc4e68a66029b87188bd02c4176359233cbd12bb20e10fd4ed73ddfe"
  "a79df69c61cd7a4ce6dae22b85bf91f73170eaf0f62cd92a52e17e26c7d64c6c"
  "45c78626566e6078bf6c7daf910ad1970e413ec23f9b1e1f312a523f8a7ad14b"
  "d51e3c5661edba314add96627650a6a010fc32f3d4368d8b895989d94b613309"
  "6dd6515cdfc891462f4a039339479026c4622518d210c4f9549c70923391d6e3"
  "43e24a6db769a6d0afd85702c9671605a77d3f65092ae8a3edff8e1eea439ea4"
  "361fb74141980b059bedc534d5e06bb7782c32840af5830c3e059cc525344588"
  "defdd29581f146f0a20a4ab2c13432596b93b41ea4e6921058408fc148c3f1c9"
  "3b2fecf9fb569cbcca9bb1d31ea7b1001d88abf59bccfe8634edf86fed92b932"
  "8588069981f41c08a7ab1dc2efd5b358f36a025681ca77d11c33d5d53004f63f"
  "f4b333765cd163db4324b545ae9f037a8bfe3ac2ba903bf405cd94e3722e25d6"
  "82e86a482e2b2cdbc22d3402700fbdcbd5b761ea0706f7bc9a9f9651bf3a6b6a"
  "442676b75e3f5b3fb2f282d09ac1eb922735ecabb42a13fa248b6817ee96e687"
  "61e8d69422e6fc658a209adf482afeccd68033ccbec727588bed7416b466b6f5"
  "3a09f0b56c6594c6473dbfd81225110a96f6f5f3c284b47bda32ac2c9f1923f5"
  "3fa3027361bb659f863f9b60e6e577349a45b6284daccd4ab95af753ff1d4f17"
  "342563726127ad3ebd66c9f701602b590acff4102702dbcb033a8683cdf39480"
  "20fd7b09559588d836d47166116253bac4720cab9f0ff524561acc36e25cdcda"
  "9924bea4c8ce9621ff8dd1c359c1fdf00bb3ec0f6f14d556690e61a20a87e873"
  "ef8ad63253096a035026cfebcf747d34a2c6705d910698a68ca7a4e366b95919"
  "00d70d2ff0027fa1db5366d1a43f07ddd38d6607667dc38cc26362a2e207e0f3"
  "0c5f0dfe610d668d8d766767010369c6ee5b9f75e1f48930a5bffb7db8d8d530"
  "e783ae4316fcde3ab3ca51adce544a419c21be3ed1c137e40210b8f19eb3790f"
  "bf2f2d1a388b91e8bb91039c5557a415b997500faff8c660b1dfab4a15854bba"
  "fdfe0de94d867befe72a08c20ad906779363ad04517430cb8cbf957a062b6223"
  "36eba759c3a69b50cb823fc1d70a8908d42844f1d9278b2237634b681ecce4be"
  "8886cce3b9374bf8f0257c47e8c93272c0d3f48dc2debe40ca1c2e0a25296171"
  "873519cce211cf3ec215d535285e0cd693c281ce88f04206667249049df09ab4"
  "9d3632b7e1a4e1078a5c352b5d16061a6ab0d6a60972c53e3e9fd39af7a38135"
  "f14b1c993cdcf3e6d2bad3e125fde80106c626d27ea5aa6c552ceeeb67468800"
  "a812eb0eaa93694fca064ac5e98c83bacd66d209f1445de910522907f36df26c"
  "35f9af2e9881605921ffab31a1225262eb3c26efac7fe418179436d7d4e9cf99"
  "c0281428b1ed5a7188f604b58698452048b0d3b2383aea8f938e65381f6b66f6"
  "a9bc012e8ac7ca046c4045faa9ef9fdbecf792f611192b3bd15e52257f80fe1e"
  "0eb10e360761009c17c6e19ce5a87b91da4fb5b0a3bfb85d129f7f661ab89a8a"
  "49f8876cf3219d021e7ffb6636028916be7ee1f603952ab0f216d3e355da2e65"
  "5a379ecc46e8e0c9b7ed96079bd2ac32c7e561294dd49c7c12793bd7f1a200f0"
  "c23c999dd37898a014ed9084a30cb64b4a9a321d217f12c267740414499104a4"
  "f1eb95fecf20f1791e32293bc59aca7febd016df55daab681422bef4d6ee0d3b"
  "986df9f92f77c78bcf8e5efb1de961eb8d2f33f0d9f2ae2be22b83923db60f82"
  "c885406dcb8681c898df92513f270b382cb036a369178c4347243684e6e0d8d6"
  "63dabd1bade02280c818ba67124bb6f0f3b22b54a4c71d4f1d67948005141cb0"
  "073d7f45fc53d5012445a7186f38f429317971add503cac3ad1c7653fd617ad5"
  "efc3fd1041058d95dd3efc986aacad7e82cf12ffb2faeb6b9870a0450ae3ae02"
  "24f6e23100e550fb6516335fc095df4489c839205d7a30c09bb7e01d05a92466"
  "ca1d3aca6845517527b1912f96e7508a67929a6beb029313fbec6dfe1470c7b4"
  "2e578d11d7c84714a31fc70d93a4c1296fd1cd5ac718b869e74853bdf3538ae4"
  "7c7a90d3cdef66e1830e25c66e526a69d7532c99b9bc6507ad177446e5226a46"
  "9d0c3e4d7480efced21eff17d76ddb8bd24faeaf6ca80957a314193d726653d8"
  "a624861418723e86571f3841f5bf1d9434111d676427cda345930aeef49776e2"
  "4da8d3d4226b2afe18581813182dce175946f0091882bb71a2eeede721a47f58"
  "10de33398f66b91c6161fb335ce4be6d6f4ea307b035cd72f11b4da5f3833659"
  "430a43d793fb44dab9161d68f2884bf3c3d19058eca7809c7872d1e961ba61c3"
  "888fdd16465259eae598490213220102df261189ca69dce307d82dad796d5c48"
  "db049b00c5b076beda8e709d201654fc0108b9f69cfa7f2f1f540bda83f7f957"
  "122586f31e588ee8541843bcb98d6b55210aa98a08bd5b37ec722883c7f5f039"
  "189dc7bfb995ed5684890f4cda542c3da326691b97fc50ea5f8336f8ca8bc7de"
  "eb84bbfa6847f1ea625ba96504bc68b2cb628232549a157b1c2362ac1fa991d8"
  "bd5bbc7258ad6f2ac1a81e443979806bd107ed71cd6ebb9e621f93447220d9bc"
  "171fca23b244f07e49a85c5553ba2f899fb66b7238f6bee58b3898fb8294576b"
  "4dcf5f4cc77385525fc8d8bebe6df50ad431062218ccabb81f8e37d6ddc475db"
  "fd71011bf475aea1073866275b89b5c31bb97f0210c7550bd229af726fa2b598"
  "24164367f2fb2e0aa202b74bb346c1fb6a86d38c957cd75f9c132d539a6affe9"
  "6c8fb555c1073ce8d38b0b7acbf4ffa3ce50d088336f7feea537002a5714ee58"
  "b378d93c1b31cae3e13a78b6859e8d97b5f138499ca32d1ae6bbd3ada412a27d"
  "6f3a6211fde3b49a654e1b89ab43ca237c6359a1f18e54422a2f3a59d35182e5"
  "5854a2f667d019b9a2a3990c48c3a190eb476213a0ffa3aafe15faa20b9a7f83"
  "87dda85c68ce578fc37fc6e814927dd76ad52d0ba43a56698b9093851c94f89f"
  "845b7def672c27dfd39a550ea8212a60c0189290d8d29b106770390820b90eda"
  "0f5d6fe0276ef63cb4c094c007847ffb18b3c94ce3748a037e1c895bbd56816f"
  "cbcd3579faaf670c678d1a094a4708565b118df45ea98a5a63696b47b70a7891"
  "756ee90a1b8292a3694cb7a7d98d3a115068421dca3c3d47d5839b5fd7f69620"
  "e65a4c3203f9332d467d68e33f597ff9af197bdc6291ea2b4476574e1068fcbd"
  "66c8be51e84f917a386e5b05bf2f29153844577df844f57091e89208907da431"
  "264236ae1674dbc82d35935f3416c24bfd9cfe8c115118fd4177b58a6410ba1e"
  "f2548d04ec211bf29f30e9026ce405fe9a9a4af7ee033eba3edfd8f8b76983dc"
  "493ee48aff5850e41072e41b0d475b035fb0f7a00bf0097e330391371ad8c10a"
  "ba5c2d1544c40a5dd688f1289b627f0c1b729bc4af59368cc335b9914121bc6c"
  "d771d74de48d3d8ed553abf9ce6a3102e01b8f066ce4df3a001bbd8c9ef5701f"
  "d3b419ec3566722d93b567ade5e5ad4b0e89b8dfcf11af9c33c58d6e0ad5aadd"
  "4201f8443325bbe797daf0fe3b0f0637c0fe84cfeaff85e083248ab444736426"
  "04f8b05475cd0f42606e02e748baf2992b5e205141f74c9cd555fadb458d8b02"
  "ac8f7ee5140a44a3f6e66fde15bc79d574a4860688d429075c9e46e335e56384"
  "fb233d2269eca1261162ec7e16491b5b601544c98c31ae9f0e76d53b5c796241"
  "bf1ee145d1bdde0b27b7a80388dc3d2f15ed7b4c888e03ba024ed9eb57c95207"
  "723a12756e0c4778395c35b68942e7be89825cf422a4a29fd891650a16580d7a"
  "bf311aed566dd7866edfbac327282a902a7fe4b250ec03d2fa1d9acf44838496"
  "c02e2bf9339cca8742ca88b130e24bc950b2d82dc2d069a049e1bdc8c8846503"
  "087a77431d88f52b17f07ffde11ce41b2a42f76d86f4d8d9630a5b02e904b73f"
  "15ba1cb4b6dcc97b3284a5efe49f9c293191404c8e7b8721fc77dfb9546e3060"
  "d36209d4614df5d5531f1c532f5354b217a2cfb3c045630a32ada517b60c9064"
  "26853c084c1ada632f9c72cd0bb5fb18868ce8cbf4d14b773d4cd7cc6f1108f1"
  "93fc725360b0ee2d2e4c1bc38616a8cc50d2b4d04f866762e1afca4a8a5fbd2a"
  "80ab80d0505990d1a278276c014ea06c2f7d81e091d00c12c188917c7c2de6df"
  "50e7289473970f5f2c44b9612b8219813d6e0193a47ac3bf4d2195743f0cda7e"
  "593260e4a167e81956e16b244b6f00c99560fc59a0ce6e87eed6fee5ab2c048c"
  "753ca416720a670dd0ad0a001e16883ab6f2013c31b72077664dfcf750c17779"
  "85ac70edcd62ca5ad22f73be5ef03d431fde3650f9df6e09cfdb0d03e9ff5ad0"
  "f65c70161f1aab8c8641e532097fa5c14542cae6fcc80b17a5991a9ff8d56354"
  "328b13118b24f700c0c232af275bf13316d26f8f942d24a497d3af6b79f83d27"
  "5a66b445b507c997c9ed4e03a24bbcadb4a9efe10980f6d7ad89604e3ec4b68d"
  "22b89e99bc17c966b861156ba07d1c226170af23ff17da1fa83a6a656f212c28"
  "49f75163f1229d0a56d206a62745f7687935c0a3f4f7f7494d6291670873aff8"
  "3b971c7ed1d74e6b04f4df38965b855ce6755b365bbbb7174beb8c110e8de0b3"
  "d26ec760d6d3160232fe7224f01da684aef328da0ebccc1654a4a7026bdcf0dc"
  "c75ab94d611ee05d199f587eb0e5e80c599cba49f62c08b33f0b2dff7d63b047"
  "ecdef2d55ea0c6d03a72d2bcf04cc8aacd798fa5240ef3a8968856df79d8879a"
  "ae66889a6c4c11b8a97c82de40a2a5343be65d4522f4a8d6da79c3c13f97a67d"
  "6c1097001ff3d76dd744dbf5ce9b0bb1736de22b1ac25c97bf5a0cebdc033d06"
  "5aea6828dda0ca171aa63d2a0699a7b2bbf70fbdc19b97aaac41f18ea0e0b8a5"
  "5ca0433c59c27542b7af9ca950ae9d833d22d3813cc9a6050721669e05395175"
  "b462a4c1ae14b215a58727523ce71a6105f1afc11b6e047ba15956d2e2ab0a60"
  "96724affff4832a1c2e742889f88c85d647db0044a6aef3d04cdf6d6d1a19f20"
  "b69d3760a765b0bfeb2c024962c982d6b2e6a815e9bc410af164b4db31265f1d"
  "741964c1f4437d6d67ebd65cf75dd5710c31eae7770cd1c119bc9c2e30d4e04f"
  "6d3b2e2693e6680bb64eb6489cf6fe1c5b9a48e07cac71726d5217155c6d546b"
  "b6d4f1445d6e3d51c2d3183924014b19c5446c86e008bf6b7b3382777f11ceda"
  "d6020a65df6c235801f4891fdcc404ba36135782989adf5e72e14492e78390b6"
  "ffa733b1aa6afa801fc8421e7845e17101a1c96c5ba745ef784afc8ac93f70b6"
  "f36f9eb4804efd68ebb6753bd4671c86f3791f74b0da9d59e7c3729cda4e440f"
  "a9648e53252182a27548aca84adb5ec09e3a803ac758de55c43e87d0103770fe"
  "f607e0972c9fccb0b367424e908c2a4d9f87aa6bfcd71f6668be492dc00f52f2"
  "dfc48681e4c47af531000ed1963804187abc4d766153781e89587416e9b39197"
  "963758c3c6251a75934e6bbd71c3e1af1c81dc53e52d3ea74ffefaf9fa3084de"
  "def116c90df09aa772f4dffd3941f51ad6f394ba5631d8810f78c808c9fc1abb"
  "2026-10-25 22:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.96 ms
(20.68%) 		1 
SELECT c.id, c.name, c.softone_code, c.mobile, c.phone, c.sms_marketing_consent,
            p.purchase_count, p.last_purchase,
            (SELECT MAX(latest.id) FROM sale latest WHERE latest.customer_id = c.id AND latest.date = p.last_purchase AND latest.cancelled = 0 AND latest.gross_amount > 0) AS last_purchase_id
            FROM customer c JOIN (
                SELECT customer_id, COUNT(*) AS purchase_count, MAX(date) AS last_purchase FROM sale
                WHERE cancelled = 0 AND gross_amount > 0 AND date <= ? GROUP BY customer_id
            ) p ON p.customer_id = c.id
            WHERE c.active = 1 AND p.last_purchase <= ?
            ORDER BY p.last_purchase ASC, c.name ASC, c.id ASC
Parameters: 
[
  "2026-10-26"
  "2026-09-26"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.56 ms
(16.48%) 		1 
SELECT c.id, c.name, c.softone_code, c.mobile, c.phone,
            c.active, c.sms_marketing_consent, COALESCE(p.purchase_count, 0) AS purchase_count, p.last_purchase
            FROM customer c LEFT JOIN (
                SELECT customer_id, COUNT(*) AS purchase_count, MAX(date) AS last_purchase FROM sale
                WHERE cancelled = 0 AND gross_amount > 0 AND date <= ? GROUP BY customer_id
            ) p ON p.customer_id = c.id
            ORDER BY c.name ASC, c.id ASC
Parameters: 
[
  "2026-10-26"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.20 ms
(12.71%) 		3 
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.default_days AS default_days_3, t0.enabled AS enabled_4, t0.first_order_message AS first_order_message_5, t0.second_order_message AS second_order_message_6, t0.restock_message AS restock_message_7 FROM remarketing_settings t0 WHERE t0.settings_key = ? LIMIT 1
Parameters: 
[
  "remarketing"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(9.42%) 		1 
SELECT s0_.customer_id AS sclr_0, MAX(COALESCE(s0_.accepted_at, s0_.submitted_at)) AS sclr_1 FROM sms_recipient s0_ WHERE s0_.status IN (?, ?, ?) AND s0_.customer_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.customer_id
Parameters: 
[
  "accepted"
  "unknown"
  "sending"
  7
  6
  4
  8
  17
  12
  15
  14
  23
  22
  18
  19
  40
  38
  28
  27
  26
  34
  31
  33
  25
  36
  39
  41
  43
  44
  42
  47
  48
  46
  45
  50
  49
  56
  58
  60
  66
  63
  59
  65
  62
  61
  68
  75
  69
  76
  73
  78
  74
  79
  71
  80
  29
  84
  83
  81
  82
  87
  88
  86
  90
  94
  92
  91
  96
  95
  97
  98
  99
  100
  102
  104
  67
  85
  112
  118
  115
  105
  114
  111
  110
  106
  107
  109
  116
  119
  133
  132
  126
  122
  129
  127
  130
  124
  131
  121
  125
  134
  120
  123
  128
  138
  145
  141
  139
  144
  140
  142
  143
  137
  146
  150
  147
  148
  149
  152
  32
  154
  155
  159
  158
  57
  51
  161
  165
  160
  164
  163
  162
  35
  169
  168
  170
  172
  167
  166
  173
  171
  177
  175
  174
  180
  178
  181
  176
  187
  183
  185
  184
  188
  189
  186
  196
  198
  191
  192
  195
  199
  194
  193
  197
  190
  202
  201
  52
  206
  207
  156
  204
  203
  205
  208
  213
  216
  217
  212
  30
  211
  209
  210
  214
  215
  218
  226
  219
  224
  220
  221
  223
  222
  225
  9
  228
  227
  231
  234
  230
  72
  233
  101
  232
  229
  235
  53
  70
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(4.93%) 		1 
SELECT s0_.phone AS phone_0, MAX(COALESCE(s0_.accepted_at, s0_.submitted_at)) AS sclr_1 FROM sms_recipient s0_ WHERE s0_.status IN (?, ?, ?) AND s0_.phone IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.phone
Parameters: 
[
  "accepted"
  "unknown"
  "sending"
  "306980379808"
  "306943828440"
  "306951379516"
  "306938428827"
  "306972284862"
  "306988612794"
  "306986624335"
  "306943403503"
  "306976222570"
  "306972408582"
  "306977898835"
  "306974815096"
  "306982886490"
  "306956333444"
  "306972103382"
  "306951776510"
  "306931807733"
  "306959672741"
  "306948345621"
  "306955649717"
  "306942213830"
  "306942514406"
  "306987722189"
  "306978902511"
  "306974248106"
  "306945086119"
  "306942774321"
  "306936187265"
  "306949606483"
  "306942039110"
  "306945374133"
  "306970468715"
  "306974192083"
  "306974634865"
  "306971903034"
  "306937377392"
  "306944595118"
  "306971583730"
  "306987962237"
  "306986591495"
  "306978940859"
  "306945568705"
  "306943195517"
  "306945415395"
  "306976191361"
  "306940586875"
  "306987209456"
  "306948143950"
  "306939199197"
  "306982583511"
  "306944745434"
  "306959754245"
  "306955394390"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(4.78%) 		1 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(3.80%) 		1 
SELECT s0_.phone AS phone_0 FROM sms_opt_out s0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(3.75%) 		1 
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.encrypted_client_id AS encrypted_client_id_3, t0.encrypted_api_key AS encrypted_api_key_4, t0.sender_name AS sender_name_5, t0.oauth_scope AS oauth_scope_6, t0.public_base_url AS public_base_url_7, t0.enabled AS enabled_8, t0.updated_at AS updated_at_9 FROM apifon_settings t0 WHERE t0.settings_key = ? LIMIT 1
Parameters: 
[
  "apifon"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\RemarketingSettings 1
App\Entity\ApifonSettings 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\RemarketingSettings No errors.
App\Entity\SmsOptOut No errors.
App\Entity\SmsRecipient No errors.
App\Entity\Customer No errors.
App\Entity\ApifonSettings No errors.