B
B
BonBon Slick2017-04-16 17:50:36
MySQL
BonBon Slick, 2017-04-16 17:50:36

Laravel Query log displays queries incorrectly?

Here is the Laravel qveri log^

Будет сохранена

array (size=11)
  0 => 
    array (size=3)
      'query' => string 'select * from `slc_users` where `slc_users`.`id` = ? limit 1' (length=60)
      'bindings' => 
        array (size=1)
          0 => string '1' (length=1)
      'time' => float 1.5
  1 => 
    array (size=3)
      'query' => string 'select * from `slc_roles` where `slc_roles`.`id` = ? limit 1' (length=60)
      'bindings' => 
        array (size=1)
          0 => string '1' (length=1)
      'time' => float 1.29
  2 => 
    array (size=3)
      'query' => string 'select * from `slc_parser2` order by `id` asc' (length=45)
      'bindings' => 
        array (size=0)
          empty
      'time' => float 5.9
  3 => 
    array (size=3)
      'query' => string 'select * from `slc_settings` where `slc_settings`.`id` = ? limit 1' (length=66)
      'bindings' => 
        array (size=1)
          0 => int 1
      'time' => float 1.43
....
  10 => 
    array (size=3)
      'query' => string 'select * from `slc_aliases` where `alias` = ? limit 1' (length=53)
      'bindings' => 
        array (size=1)
          0 => string 'kuda_propali_sigarety_v_roznichnyh_setyah_problemy_s_postavkami_tabaka' (length=70)
      'time' => float 212.57

According to the idea and logic, all requests more than time => 1 should be in the Mysql.log file, where I catch requests, but, here is a completely different picture, requests that are not in the Laravel Query log in the muscle logs:
ceb3ef640ced4f96815242ff2a9b9e1a.png
So how can I catch those requests which really exist? And why are there no queries in mysql .log where time > 1?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Mokhirjon Naimov, 2017-05-01
@BonBonSlick

Not sure, but maybe Laravel Query log shows the time in milliseconds?!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question