Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.10 ms
(86.02%)
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
  28568
  40051
  56464
  327170
  393865
  394120
  395731
  400166
  400857
  403279
  403340
  407550
  413889
  416408
  430833
  430839
  430979
  446706
  461841
  465649
  477335
  478835
  482248
  486252
  490801
  492331
  496118
  510466
  510934
  513113
  514589
  519929
  530325
  532770
  533411
  536279
  537727
  540549
  544255
  549342
  549911
  556659
  558272
  559129
  563100
  579910
  580300
  596576
  606884
  611345
  615990
  617190
  629479
  644253
  644254
  668438
  677590
  680878
  683530
  687471
  687571
  695186
  699536
  704987
  710568
  711671
  714457
  714475
  721060
  721155
  721674
  721822
  724706
  725362
  726887
  726891
  730955
  734528
  745036
  751491
  751655
  757107
  758564
  764919
  765045
  770749
  771000
  771320
  776820
  776970
  777220
  777270
  781171
  781326
  786462
  787342
  787636
  793121
  793410
  796451
  797867
  799259
  799604
  801192
  802384
  805548
  807369
  813118
  814382
  815288
  815684
  816772
  818865
  819474
  821238
  822094
  822278
  822585
  822775
  827074
]
13.24 ms
(8.36%)
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
  393865
  478835
  519929
  486252
  668438
  818865
  814382
  819474
  821238
  533411
  510934
  490801
  549911
  683530
  677590
  596576
  793410
  734528
  796451
  771320
  403279
  695186
  781326
  563100
  606884
  777220
  777270
  813118
  726887
  765045
  764919
  629479
  787342
  540549
  400857
  413889
  465649
  514589
  751655
  400166
  492331
  430833
  786462
  787636
  724706
  725362
  758564
  710568
  56464
  403340
  815288
  815684
  822278
  822585
  816772
  822094
  827074
  822775
  530325
  721155
  721674
  680878
  687471
  644253
  799604
  776820
  781171
  751491
  797867
  801192
  771000
  776970
  799259
  802384
  40051
  395731
  28568
  558272
  416408
  482248
  477335
  714475
  580300
  617190
  699536
  714457
  430979
  430839
  394120
  513113
  745036
  510466
  611345
  327170
  446706
  496118
  644254
  407550
  461841
  532770
  537727
  549342
  559129
  687571
  615990
  805548
  757107
  704987
  721822
  556659
  730955
  793121
  726891
  711671
  721060
  579910
  536279
  544255
  770749
  807369
]
2.38 ms
(1.50%)
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
  28568
  40051
  56464
  327170
  393865
  394120
  395731
  400166
  400857
  403279
  403340
  407550
  413889
  416408
  430833
  430839
  430979
  446706
  461841
  465649
  477335
  478835
  482248
  486252
  490801
  492331
  496118
  510466
  510934
  513113
  514589
  519929
  530325
  532770
  533411
  536279
  537727
  540549
  544255
  549342
  549911
  556659
  558272
  559129
  563100
  579910
  580300
  596576
  606884
  611345
  615990
  617190
  629479
  644253
  644254
  668438
  677590
  680878
  683530
  687471
  687571
  695186
  699536
  704987
  710568
  711671
  714457
  714475
  721060
  721155
  721674
  721822
  724706
  725362
  726887
  726891
  730955
  734528
  745036
  751491
  751655
  757107
  758564
  764919
  765045
  770749
  771000
  771320
  776820
  776970
  777220
  777270
  781171
  781326
  786462
  787342
  787636
  793121
  793410
  796451
  797867
  799259
  799604
  801192
  802384
  805548
  807369
  813118
  814382
  815288
  815684
  816772
  818865
  819474
  821238
  822094
  822278
  822585
  822775
  827074
]
1.86 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс mom beauty"
]
1.77 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex mom beauty"
]
1.44 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс mom beauty"
]
1.43 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.