Symfony Profiler

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

Query Metrics

insert into trackbrowsing (sessionid, pathname, url, getparameters, userid, browsetime) values 
            (:sessionid, :pathname, :url, :getparameters, :userid, :browsetime)

[
  "sessionid" => "f80c7720cec6fdf8f66ced11347a2159"
  "pathname" => "app_shop_product_details"
  "url" => "/shop/productdetails/5998269/installHook.js.map"
  "getparameters" => "{"shopid":"5998269","productid":"installHook.js.map"}"
  "userid" => "22270733"
  "browsetime" => 1786529456
]

insert into trackbrowsing (
  sessionid, pathname, url, getparameters,
  userid, browsetime
)
values
  (
    :sessionid, :pathname, :url, :getparameters,
    :userid, :browsetime
  )

insert into trackbrowsing (sessionid, pathname, url, getparameters, userid, browsetime) values 
            ('f80c7720cec6fdf8f66ced11347a2159', 'app_shop_product_details', '/shop/productdetails/5998269/installHook.js.map', '{\"shopid\":\"5998269\",\"productid\":\"installHook.js.map\"}', '22270733', 1786529456);

select * from shop where shopid = '5998269'

[]

select
  *
from
  shop
where
  shopid = '5998269'

select * from shop where shopid = '5998269';

select * from shopproducts where shopid = '5998269' and shopproductid = 'installHook.js.map'

[]

select
  *
from
  shopproducts
where
  shopid = '5998269'
  and shopproductid = 'installHook.js.map'

select * from shopproducts where shopid = '5998269' and shopproductid = 'installHook.js.map';