Query Metrics
9
Database Queries
9
Different statements
18.75 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.12 ms (37.94%) |
1 |
INSERT INTO campaign_log (created_at, updated_at, attribute, is_processed, cookie_id, is_unique, language, device_os, device_platform, country, city, region, zip, country_code, source_media, channel, is_bot, campaign_id, organization_id, affiliate_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2025-03-15 05:46:07" "2025-03-15 05:46:07" "{"geoip":{"status":"success","country":"Russia","countryCode":"RU","region":"MOW","regionName":"Moscow","city":"Moscow","zip":"127282","lat":55.7487,"lon":37.6187,"timezone":"Europe\/Moscow","isp":"JSC Selectel","org":"Planeta LLC","as":"AS49505 JSC Selectel","query":"185.147.125.23"},"attr":{"uuid":"17PBOV","affiliate":null,"ip":"185.147.125.23","user_agent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/129.0.0.0 Safari\/537.36","http_referrer":"https:\/\/ha-haustechnik.ch\/c?u=17PBOV","accept_language":null},"device":{"client":{"type":"browser","name":"Chrome","short_name":"CH","version":"129.0","engine":"Blink","engine_version":"129.0.0.0","family":"Chrome"},"os":{"name":"Windows","short_name":"WIN","version":"10","platform":"x64","family":"Windows"},"device":"desktop","brand":"","model":"","bot":null}}" 0 "2bf40303-ddcb-4aff-af77-ad0ba19c0944" 1 null "Windows" "desktop" "Russia" "Moscow" "Moscow" "127282" "RU" "qr" null 0 966 273 null ] |
4.64 ms (24.76%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0, c0_.device_os AS device_os_1 FROM campaign_log c0_ WHERE c0_.campaign_id = ? AND c0_.device_os IS NOT NULL GROUP BY c0_.device_os ORDER BY sclr_0 DESC LIMIT 1
Parameters:
[
966
]
|
2.40 ms (12.78%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.priority AS priority_7, t0.clicks AS clicks_8, t0.icon AS icon_9, t0.icon_color AS icon_color_10, t0.format AS format_11, t0.campaign_id AS campaign_id_12, t0.user_id AS user_id_13 FROM campaign_element t0 WHERE t0.campaign_id = ? ORDER BY t0.priority DESC
Parameters:
[
966
]
|
1.31 ms (7.01%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0, c0_.region AS region_1 FROM campaign_log c0_ WHERE c0_.campaign_id = ? AND c0_.region IS NOT NULL GROUP BY c0_.region ORDER BY sclr_0 DESC LIMIT 1
Parameters:
[
966
]
|
0.88 ms (4.68%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.affiliate_bonus AS affiliate_bonus_5, t0.bonus_type AS bonus_type_6, t0.discount AS discount_7, t0.discount_type AS discount_type_8, t0.content AS content_9, t0.redirect_url AS redirect_url_10, t0.uuid AS uuid_11, t0.top_region AS top_region_12, t0.top_device AS top_device_13, t0.scans AS scans_14, t0.type AS type_15, t0.cookie_lifetime AS cookie_lifetime_16, t0.unique_scans AS unique_scans_17, t0.qrcode_attribute AS qrcode_attribute_18, t0.locale AS locale_19, t0.deleted_at AS deleted_at_20, t0.last_scan_at AS last_scan_at_21, t0.alias AS alias_22, t0.enable_tracking AS enable_tracking_23, t0.is_default AS is_default_24, t0.user_id AS user_id_25, t0.organization_id AS organization_id_26 FROM campaign t0 WHERE t0.uuid = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
"17PBOV"
]
|
0.82 ms (4.39%) |
1 |
"COMMIT"
Parameters:
[] |
0.63 ms (3.39%) |
1 |
UPDATE campaign SET scans = ?, unique_scans = ?, last_scan_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ 286 273 "2025-03-15 05:46:06" "2025-03-15 05:46:07" 966 ] |
0.57 ms (3.05%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.company AS company_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.affiliate_code AS affiliate_code_9, t0.signup_code AS signup_code_10, t0.type AS type_11, t0.stripe_session AS stripe_session_12, t0.stripe_customer AS stripe_customer_13, t0.stripe_subscription AS stripe_subscription_14, t0.is_paying AS is_paying_15, t0.request_cancelled AS request_cancelled_16, t0.cancelled_at AS cancelled_at_17, t0.next_payment_at AS next_payment_at_18, t0.is_verified_at AS is_verified_at_19, t0.locale AS locale_20, t0.is_super_admin AS is_super_admin_21, t0.deleted_at AS deleted_at_22, t0.activated_at AS activated_at_23, t0.is_first_visit AS is_first_visit_24, t0.organization_id AS organization_id_25, t0.referee_id AS referee_id_26 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
272
]
|
0.38 ms (2.02%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\Campaign |
|
App\Entity\User | No errors. |
App\Entity\Organization | No errors. |
App\Entity\Affiliate |
|
App\Entity\Conversion | No errors. |
App\Entity\Ledger | No errors. |
App\Entity\CampaignLog | No errors. |
App\Entity\Media | No errors. |
App\Entity\Feedback | No errors. |
App\Entity\Tag | No errors. |
App\Entity\CampaignElement | No errors. |
App\Entity\Device | No errors. |
App\Entity\DomainRecord | No errors. |
App\Entity\CampaignChangeLog | No errors. |
App\Entity\CampaignLead | No errors. |
App\Entity\CampaignPayment | No errors. |
App\Entity\TrackingSession | No errors. |
App\Entity\Referral | No errors. |
App\Entity\PartnerOffer | No errors. |
App\Entity\PartnerOfferRedeem | No errors. |
App\Entity\Webpush | No errors. |