http://crm.zvigerauto.empat.cloud/api_plugin/user_auth

Query Metrics

11 Database Queries
9 Different statements
18.08 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.68 ms
(75.68%)
2
"COMMIT"
Parameters:
[]
0.69 ms
(3.81%)
1
SELECT t0.id AS id_1, t0.login AS login_2, t0.password AS password_3, t0.changed_date AS changed_date_4, t0.auction_name AS auction_name_5, t0.autocorrect AS autocorrect_6, t0.collect_payment_due AS collect_payment_due_7, t0.country AS country_8, t0.common_name AS common_name_9, t0.changed_by_id AS changed_by_id_10, t0.proxy_account_id AS proxy_account_id_11 FROM auction_account t0 INNER JOIN plugin_user_auction_account ON t0.id = plugin_user_auction_account.auction_account_id WHERE plugin_user_auction_account.plugin_user_id = ?
Parameters:
[
  23
]
0.64 ms
(3.53%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0._1c_guid AS _1c_guid_5, t0._1c_name AS _1c_name_6, t0._1c_code AS _1c_code_7, t0.username AS username_8, t0.telegram_enable AS telegram_enable_9, t0.telegram_pincode AS telegram_pincode_10, t0.telegram_chat_id AS telegram_chat_id_11, t0.telegram_attach_media AS telegram_attach_media_12, t0.email_enable AS email_enable_13, t0.email_attach_media AS email_attach_media_14, t0.enable_plugin AS enable_plugin_15, t0.webhook_url AS webhook_url_16, t0.default_country AS default_country_17, t0.locale AS locale_18, t0.last_for_sale_viewed_date AS last_for_sale_viewed_date_19, t0.sns AS sns_20, t0.carfax_reports_available AS carfax_reports_available_21, t0.invoice_template AS invoice_template_22, t0.show_carfax AS show_carfax_23, t0.limit_carfax_in_day AS limit_carfax_in_day_24, t0.window_sticker_reports_available AS window_sticker_reports_available_25, t26.id AS id_27, t26.logo AS logo_28, t26.title AS title_29, t26.user_id AS user_id_30, t0.parent_id AS parent_id_31, t32.id AS id_33, t32.items AS items_34, t32.relevance AS relevance_35, t32.user_id AS user_id_36 FROM user t0 LEFT JOIN custom_design t26 ON t26.user_id = t0.id LEFT JOIN clarifications_price t32 ON t32.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
0.64 ms
(3.52%)
1
SELECT p0_.id AS id_0, p0_.proxy_host AS proxy_host_1, p0_.proxy_port AS proxy_port_2, p0_.proxy_username AS proxy_username_3, p0_.proxy_password AS proxy_password_4, p0_.proxy_type AS proxy_type_5, p0_.last_used_at AS last_used_at_6, p0_.is_active AS is_active_7, p0_.last_checked_at AS last_checked_at_8 FROM proxy_account p0_ LEFT JOIN auction_account a1_ ON p0_.id = a1_.proxy_account_id WHERE a1_.auction_name = ? AND p0_.is_active = 1 ORDER BY p0_.last_used_at ASC LIMIT 1
Parameters:
[
  "manheim"
]
0.62 ms
(3.42%)
1
SELECT t0.id AS id_1, t0.login AS login_2, t0.password AS password_3, t0.type AS type_4, t0.deleted AS deleted_5, t0.created_at AS created_at_6, t0.owner_id AS owner_id_7, t0.customer_id AS customer_id_8, t0.custom_price_scheme_id AS custom_price_scheme_id_9 FROM plugin_user t0 WHERE t0.login = ? AND t0.deleted = ? LIMIT 1
Parameters:
[
  "empat_test"
  0
]
0.56 ms
(3.10%)
1
SELECT t0.id AS id_1, t0.token AS token_2, t0.disabled_at AS disabled_at_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.plugin_user_id AS plugin_user_id_6 FROM plugin_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "9ae8da71686db1cd1f5bffafdbf8806c209c504f"
]
0.44 ms
(2.42%)
1
UPDATE proxy_account SET last_used_at = ? WHERE id = ?
Parameters:
[
  "2026-01-17 13:22:28"
  5
]
0.42 ms
(2.30%)
2
"START TRANSACTION"
Parameters:
[]
0.40 ms
(2.23%)
1
INSERT INTO plugin_token (token, disabled_at, STATUS, created_at, plugin_user_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  1 => "9ae8da71686db1cd1f5bffafdbf8806c209c504f"
  2 => null
  3 => "on"
  4 => "2026-01-17 13:22:28"
  5 => 23
]

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

Class Mapping errors
App\Entity\PluginToken No errors.
App\Entity\PluginUser No errors.
App\Entity\User No errors.
App\Entity\Customer No errors.
App\Entity\CustomPriceScheme No errors.
App\Entity\AuctionAccount No errors.
App\Entity\PluginUserAuctionAccount No errors.
App\Entity\PluginUserAuctionAccountAssigment No errors.
App\Entity\VehicleAuctionWinner No errors.
App\Entity\CustomDesign No errors.
App\Entity\ClarificationsPrice No errors.
App\Entity\Ticket No errors.
App\Entity\FinanceIncome No errors.
App\Entity\Vehicle No errors.
App\Entity\UserAnnouncement No errors.
App\Entity\ApiUserToken No errors.
App\Entity\LandPrice No errors.
App\Entity\SeaPrice No errors.
App\Entity\DealerPrice No errors.
App\Entity\AdditionalServicePrice No errors.
App\Entity\Carfax No errors.
App\Entity\CommonAdditionalServiceUserPrice No errors.
App\Entity\AccruedAdditionalService No errors.
App\Entity\FinanceIncomeUa No errors.
App\Entity\UserWindowSticker No errors.
App\Entity\BodyTypesLandPriceChange No errors.
App\Entity\BodyTypesSeaPriceChange No errors.
App\Entity\ServicePrice No errors.
App\Entity\ServicesInFinalDestinationPrice No errors.
App\Entity\FinalLandDeliveryPrice No errors.
App\Entity\ProxyAccount No errors.
App\Entity\AuctionPasswordsList No errors.
App\Entity\Warehouse No errors.
App\Entity\ForSale No errors.