Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Configuration

Query Metrics

insert into everflow_vkwip_stats 
      (source_id, offer_id, affiliate_id, date, searches, clicks, revenue, pub_impression, source_impression)
      
select source_id, offer_id, affiliate_id, date, sum(searches), sum(clicks), sum(revenue), pub_impressions, source_impressions
from everflow_vkwip_report where date = "2026-06-25" 
  GROUP BY source_id, offer_id, affiliate_id, date;

[]

insert into everflow_vkwip_stats (
  source_id, offer_id, affiliate_id,
  date, searches, clicks, revenue, pub_impression,
  source_impression
)
select
  source_id,
  offer_id,
  affiliate_id,
  date,
  sum(searches),
  sum(clicks),
  sum(revenue),
  pub_impressions,
  source_impressions
from
  everflow_vkwip_report
where
  date = "2026-06-25"
GROUP BY
  source_id,
  offer_id,
  affiliate_id,
  date;

insert into everflow_vkwip_stats 
      (source_id, offer_id, affiliate_id, date, searches, clicks, revenue, pub_impression, source_impression)
      
select source_id, offer_id, affiliate_id, date, sum(searches), sum(clicks), sum(revenue), pub_impressions, source_impressions
from everflow_vkwip_report where date = "2026-06-25" 
  GROUP BY source_id, offer_id, affiliate_id, date;;

insert into everflow_vkwip_stats_vendor 
      (source_id, offer_id, affiliate_id, date, searches, clicks, revenue, pub_impression, source_impression, vendor)
      
select source_id, offer_id, affiliate_id, date, sum(searches), sum(clicks), sum(revenue), pub_impressions, source_impressions, vendor
from everflow_vkwip_report_source where date = "2026-06-25" 
  GROUP BY vendor, source_id, offer_id, affiliate_id, date;

[]

insert into everflow_vkwip_stats_vendor (
  source_id, offer_id, affiliate_id,
  date, searches, clicks, revenue, pub_impression,
  source_impression, vendor
)
select
  source_id,
  offer_id,
  affiliate_id,
  date,
  sum(searches),
  sum(clicks),
  sum(revenue),
  pub_impressions,
  source_impressions,
  vendor
from
  everflow_vkwip_report_source
where
  date = "2026-06-25"
GROUP BY
  vendor,
  source_id,
  offer_id,
  affiliate_id,
  date;

insert into everflow_vkwip_stats_vendor 
      (source_id, offer_id, affiliate_id, date, searches, clicks, revenue, pub_impression, source_impression, vendor)
      
select source_id, offer_id, affiliate_id, date, sum(searches), sum(clicks), sum(revenue), pub_impressions, source_impressions, vendor
from everflow_vkwip_report_source where date = "2026-06-25" 
  GROUP BY vendor, source_id, offer_id, affiliate_id, date;;

insert into everflow_vkwip_stats_vendor_subsource 
      (source_id, offer_id, affiliate_id, date, searches, clicks, revenue, source_impression, vendor, sbs_id, sbs_type, sbs_slot)
      
select source_id, offer_id, affiliate_id, date, sum(searches), sum(clicks), sum(revenue), source_impressions, vendor, sbs_id, sbs_type, sbs_slot
from everflow_vkwip_report_subsource where date = "2026-06-25" 
  GROUP BY vendor, source_id, sbs_id, sbs_type, sbs_slot, offer_id, affiliate_id, date;

[]

insert into everflow_vkwip_stats_vendor_subsource (
  source_id, offer_id, affiliate_id,
  date, searches, clicks, revenue, source_impression,
  vendor, sbs_id, sbs_type, sbs_slot
)
select
  source_id,
  offer_id,
  affiliate_id,
  date,
  sum(searches),
  sum(clicks),
  sum(revenue),
  source_impressions,
  vendor,
  sbs_id,
  sbs_type,
  sbs_slot
from
  everflow_vkwip_report_subsource
where
  date = "2026-06-25"
GROUP BY
  vendor,
  source_id,
  sbs_id,
  sbs_type,
  sbs_slot,
  offer_id,
  affiliate_id,
  date;

insert into everflow_vkwip_stats_vendor_subsource 
      (source_id, offer_id, affiliate_id, date, searches, clicks, revenue, source_impression, vendor, sbs_id, sbs_type, sbs_slot)
      
select source_id, offer_id, affiliate_id, date, sum(searches), sum(clicks), sum(revenue), source_impressions, vendor, sbs_id, sbs_type, sbs_slot
from everflow_vkwip_report_subsource where date = "2026-06-25" 
  GROUP BY vendor, source_id, sbs_id, sbs_type, sbs_slot, offer_id, affiliate_id, date;;

INSERT INTO everflow_pub_offer_summary (date, pub, offer, total_click, unique_click, gross_click, payout, revenue) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

[
  "2026-06-25"
  302725
  30556
  9
  9
  13
  "0"
  "0"
]

INSERT INTO everflow_pub_offer_summary (
  date, pub, offer, total_click, unique_click,
  gross_click, payout, revenue
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO everflow_pub_offer_summary (date, pub, offer, total_click, unique_click, gross_click, payout, revenue) VALUES ('2026-06-25', 302725, 30556, 9, 9, 13, '0', '0');

delete from everflow_vkwip_stats_vendor_subsource where date = "2026-06-25";

[]

delete from
  everflow_vkwip_stats_vendor_subsource
where
  date = "2026-06-25";

delete from everflow_vkwip_stats_vendor_subsource where date = "2026-06-25";;

delete from everflow_vkwip_stats where date = "2026-06-25";

[]

delete from
  everflow_vkwip_stats
where
  date = "2026-06-25";

delete from everflow_vkwip_stats where date = "2026-06-25";;

delete from everflow_pub_offer_summary where date = "2026-06-25";

[]

delete from
  everflow_pub_offer_summary
where
  date = "2026-06-25";

delete from everflow_pub_offer_summary where date = "2026-06-25";;

delete from everflow_vkwip_stats_vendor where date = "2026-06-25";

[]

delete from
  everflow_vkwip_stats_vendor
where
  date = "2026-06-25";

delete from everflow_vkwip_stats_vendor where date = "2026-06-25";;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";