Query Metrics
7
Database Queries
7
Different statements
11.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.82 ms (65.32%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.08 ms (9.06%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.69 ms (5.80%) |
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.66 ms (5.48%) |
1 |
INSERT INTO plugin_ping (logged_copart, logged_plugin, date, assigment_id, token_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 => 0 2 => 0 3 => "2026-01-17 11:55:54" 4 => "1000" 5 => "23030" ] |
|
0.63 ms (5.29%) |
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 = ? AND t0.status = ? LIMIT 1
Parameters:
[ "a25cdd7a9a31c5b44c30035c5a6f1d113ac2a48d" "on" ] |
|
0.56 ms (4.67%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.plugin_version AS plugin_version_3, t0.ip AS ip_4, t0.plugin_user_id AS plugin_user_id_5, t0.auction_account_id AS auction_account_id_6 FROM plugin_user_auction_account_assigment t0 WHERE t0.id = ?
Parameters:
[
1000
]
|
|
0.52 ms (4.37%) |
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.id = ?
Parameters:
[
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\AuctionBid | No errors. |
| App\Entity\PluginPing | No errors. |
| App\Entity\Warehouse | No errors. |
| App\Entity\ForSale | No errors. |