Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

79.95 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	36.37 ms	SELECT * FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M"] View formatted query View runnable query Explain query SELECT * FROM customer_device WHERE :token LIKE CONCAT(token, '%') AND `status` = 0 SELECT * FROM customer_device WHERE 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M' LIKE CONCAT(token,'%') AND `status` = 0 ;
2	43.58 ms	DELETE FROM customer_device WHERE :token LIKE CONCAT(token,'%') AND `status` = 0 ; Parameters: ["token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M"] View formatted query View runnable query Explain query DELETE FROM customer_device WHERE :token LIKE CONCAT(token, '%') AND `status` = 0; DELETE FROM customer_device WHERE 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M' LIKE CONCAT(token,'%') AND `status` = 0 ;;

#▲

Time

Info

36.37 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M"
]

View formatted query View runnable query Explain query

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

SELECT
        *
        FROM
        customer_device
        WHERE
            'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M' LIKE CONCAT(token,'%') AND
            `status` = 0
        ;

43.58 ms

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

Parameters:

[
  "token" => "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M"
]

View formatted query View runnable query Explain query

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

DELETE FROM customer_device WHERE 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3Mzg3NTkxNDgsImV4cCI6MTczODc2Mjc0OCwicm9sZXMiOlsiUk9MRV9DVVNUT01FUiJdLCJ1c2VybmFtZSI6Imt5Y3NlcmlncmFmaWFAZ21haWwuY29tIn0.grTjt22Trbkg1Rlga0k_gphO15bJSWtXSJrWH7l7lXjO_MkoK39mBN_56nWJCXWIuY8bYdci0xGcz-Wp8pyY4W5Y5JHM_nb3wIbU8Ngx6fT0Z12lEu78Bd1D6F2hZdhXYdezG5fU6HVb9V_5T0giYQjrgjVqPxJWEcGoISpjz-sPsoj7MJ6VegQ2FMGfoQh-vlt2oJyd8JBY3gWxSJ_KG-JJQmmc5aUHRSlx22XVtCDBE3gX8g4TZMEf6ndDTXHB4kta3hESnwEiynutAQcu53ZB__KPAQ-wr23KjuZi1-iivUC4OWR4cwv1qrfDD-D6rR2PPbQ1id1O_iBKeWfv0scABTb-Meje9jwb_rvDj70mfu-hjclUec9IWg9SYXKP_RHYtXecvaqq7AXdjV41_NLlDk1DaN5-QpB9ZudcrIrdRsftwEh-y1cP0ilf33As5DLRTd1zIANzwCiFgzxo1UdC_O3wnB0QJfKtEC4a5eRFos6hT-vS8JVaN0wME2H2XK_kG-MwcznFy2Qw9boZfNj_iUvxdKTO6dJq2EFgAi7lHuhEY3SQtq1RGw9oRqjCNPY_lYm4FmJzcQA-WlxPsUhAja8GfYl_weU2cYROyiI-EuwpDb0BR80bWRWuQ33nwURSJtcl-7mByPckZMf643_FZZ21gnn99T6q3kJSV8M' LIKE CONCAT(token,'%') AND `status` = 0 ;;

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.

Entities Mapping

No loaded entities.

Symfony Profiler

https://prod.golmanagerpanel.com/api/es/customer/device/list?isIos=false&p=api%2Fes%2Fcustomer%2Fdevice%2Flist&version_app=5.0.2

Configuration Settings

Theme