Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.83 ms
(85.87%)
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
  384883
  398019
  416407
  418195
  429504
  433234
  443969
  450847
  460974
  469997
  477067
  477493
  512895
  525168
  529305
  529663
  531072
  535653
  535790
  535806
  539715
  543773
  561559
  570854
  578657
  586038
  588341
  591258
  592843
  596234
  604493
  604593
  606109
  607650
  616049
  630494
  638569
  641381
  648901
  674670
  680049
  687584
  695759
  702050
  703977
  704872
  705553
  709396
  717943
  718592
  718779
  724282
  727520
  728089
  730504
  730700
  730977
  733973
  737089
  737582
  739762
  744693
  747078
  755145
  755359
  758110
  759074
  760648
  767556
  767694
  768396
  769257
  770007
  771394
  774384
  775569
  775583
  776775
  780008
  784850
  784861
  784894
  784946
  786226
  786562
  787571
  789505
  791637
  792287
  792918
  795559
  797469
  797876
  800107
  802075
  802095
  802981
  804302
  806207
  807019
  807037
  807612
  809208
  809791
  810506
  811314
  812975
  815420
  816677
  817018
  818113
  819472
  819589
  822308
  823017
  823763
  825274
  826860
  826907
]
10.28 ms
(6.96%)
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
  525168
  535806
  535653
  604593
  469997
  570854
  592843
  826860
  769257
  398019
  604493
  596234
  429504
  784946
  792287
  787571
  811314
  758110
  774384
  709396
  809791
  460974
  450847
  531072
  416407
  512895
  529305
  786226
  784894
  797469
  767694
  730700
  792918
  477493
  823763
  818113
  817018
  816677
  819589
  535790
  561559
  776775
  784850
  802095
  775569
  789505
  795559
  804302
  802981
  810506
  728089
  733973
  737089
  771394
  702050
  705553
  384883
  586038
  591258
  759074
  433234
  812975
  767556
  797876
  807037
  730504
  807612
  823017
  826907
  822308
  819472
  825274
  529663
  680049
  704872
  674670
  687584
  588341
  638569
  641381
  775583
  784861
  780008
  806207
  727520
  747078
  755145
  724282
  755359
  760648
  768396
  771220
  730977
  718779
  418195
  703977
  539715
  717943
  543773
  616049
  695759
  802075
  739762
  815420
  718592
  807019
  809208
  737582
  744693
  648901
  630494
  791637
  800107
  770007
  607650
  786562
  477067
  578657
  443969
  606109
]
3.24 ms
(2.19%)
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
  384883
  398019
  416407
  418195
  429504
  433234
  443969
  450847
  460974
  469997
  477067
  477493
  512895
  525168
  529305
  529663
  531072
  535653
  535790
  535806
  539715
  543773
  561559
  570854
  578657
  586038
  588341
  591258
  592843
  596234
  604493
  604593
  606109
  607650
  616049
  630494
  638569
  641381
  648901
  674670
  680049
  687584
  695759
  702050
  703977
  704872
  705553
  709396
  717943
  718592
  718779
  724282
  727520
  728089
  730504
  730700
  730977
  733973
  737089
  737582
  739762
  744693
  747078
  755145
  755359
  758110
  759074
  760648
  767556
  767694
  768396
  769257
  770007
  771394
  774384
  775569
  775583
  776775
  780008
  784850
  784861
  784894
  784946
  786226
  786562
  787571
  789505
  791637
  792287
  792918
  795559
  797469
  797876
  800107
  802075
  802095
  802981
  804302
  806207
  807019
  807037
  807612
  809208
  809791
  810506
  811314
  812975
  815420
  816677
  817018
  818113
  819472
  819589
  822308
  823017
  823763
  825274
  826860
  826907
]
1.90 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom дрочк член"
]
1.88 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom hand job"
]
1.79 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom дрочк член"
]
1.77 ms
(1.20%)
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.