Query Metrics

7 Database Queries
7 Different statements
211.85 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
178.08 ms
(84.06%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  12887
  386709
  390082
  390231
  390571
  390610
  395405
  398955
  407538
  415594
  416928
  418743
  419860
  420351
  421613
  424478
  425996
  426429
  430728
  431687
  432318
  433883
  434838
  437686
  438979
  439626
  440581
  442143
  443312
  444676
  446614
  447995
  448034
  448064
  448069
  448798
  448987
  449260
  449302
  455045
  456367
  456407
  457797
  458119
  461893
  462359
  462360
  462362
  462363
  462364
  465930
  466322
  466721
  467617
  470513
  471934
  473255
  475586
  475590
  476780
  477376
  477568
  479280
  479826
  484016
  485051
  486695
  487005
  487068
  487077
  487086
  489712
  490428
  490903
  491286
  491439
  491671
  491946
  491983
  496086
  496603
  498925
  499182
  499474
  500375
  500530
  502523
  506448
  508881
  510115
  511155
  512073
  512640
  512749
  516022
  516776
  517854
  518382
  519549
  519762
  519769
  521203
  521254
  524155
  524207
  524390
  524694
  526627
  527576
  559140
  560201
  560209
  561114
  579391
  607374
  613319
  637413
  638991
  817115
  819565
]
23.65 ms
(11.16%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  407538
  431687
  432318
  449260
  455045
  473255
  475586
  398955
  421613
  442143
  470513
  475590
  477376
  479280
  395405
  418743
  426429
  438979
  462364
  466322
  390231
  415594
  434838
  449302
  424478
  457797
  465930
  467617
  510115
  511155
  517854
  487086
  490903
  491946
  498925
  502523
  512640
  521254
  524207
  524390
  487005
  487068
  491983
  508881
  524155
  524694
  526627
  487077
  491439
  491671
  519762
  437686
  448987
  489712
  496603
  499182
  512749
  527576
  496086
  516776
  559140
  579391
  560201
  560209
  561114
  638991
  613319
  390571
  439626
  448798
  448034
  479826
  419860
  440581
  420351
  490428
  512073
  519549
  519769
  491286
  500375
  518382
  607374
  637413
  386709
  12887
  390082
  390610
  430728
  433883
  416928
  425996
  443312
  444676
  817115
  819565
  447995
  456367
  456407
  462362
  466721
  471934
  486695
  448069
  462363
  446614
  448064
  458119
  461893
  462359
  462360
  476780
  477568
  484016
  485051
  499474
  500530
  506448
  516022
  521203
]
3.53 ms
(1.67%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  12887
  386709
  390082
  390231
  390571
  390610
  395405
  398955
  407538
  415594
  416928
  418743
  419860
  420351
  421613
  424478
  425996
  426429
  430728
  431687
  432318
  433883
  434838
  437686
  438979
  439626
  440581
  442143
  443312
  444676
  446614
  447995
  448034
  448064
  448069
  448798
  448987
  449260
  449302
  455045
  456367
  456407
  457797
  458119
  461893
  462359
  462360
  462362
  462363
  462364
  465930
  466322
  466721
  467617
  470513
  471934
  473255
  475586
  475590
  476780
  477376
  477568
  479280
  479826
  484016
  485051
  486695
  487005
  487068
  487077
  487086
  489712
  490428
  490903
  491286
  491439
  491671
  491946
  491983
  496086
  496603
  498925
  499182
  499474
  500375
  500530
  502523
  506448
  508881
  510115
  511155
  512073
  512640
  512749
  516022
  516776
  517854
  518382
  519549
  519762
  519769
  521203
  521254
  524155
  524207
  524390
  524694
  526627
  527576
  559140
  560201
  560209
  561114
  579391
  607374
  613319
  637413
  638991
  817115
  819565
]
2.07 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking slave"
]
1.75 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза доминирован"
]
1.35 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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

No loaded entities.