Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.08 ms
(88.08%)
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
  422350
  426707
  428777
  430299
  467998
  474904
  477641
  509522
  516260
  539270
  540581
  541280
  546518
  548017
  548819
  553125
  558484
  559319
  559337
  561370
  563964
  578345
  585524
  592059
  595730
  598210
  598231
  608630
  615156
  621865
  622840
  628195
  630364
  630507
  645204
  655538
  658863
  663312
  676695
  677156
  679273
  686854
  702266
  717782
  726075
  733918
  744761
  752442
  754939
  763100
  763188
  763508
  764318
  764515
  764556
  764622
  764636
  764934
  767624
  768583
  771801
  772551
  772822
  776372
  777699
  777980
  778051
  778093
  779094
  779572
  779828
  780238
  781088
  781405
  781556
  782897
  783060
  787429
  787765
  788042
  788838
  789039
  790077
  790609
  790778
  791009
  791016
  791174
  791673
  792500
  793714
  795641
  797208
  797211
  798626
  800425
  801699
  801707
  802863
  804916
  805009
  805209
  808193
  808695
  811241
  811589
  814281
  814329
  816156
  817661
  818016
  818021
  818736
  818951
  819782
  819797
  825730
  827488
]
12.11 ms
(6.24%)
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
  628195
  509522
  621865
  592059
  768583
  804916
  814329
  814281
  474904
  781088
  790778
  793714
  791009
  791016
  791673
  795641
  801699
  801707
  802863
  763188
  764556
  767624
  790609
  797211
  764934
  771801
  772822
  733918
  763063
  763508
  726075
  764515
  779828
  791174
  811589
  792500
  754939
  772551
  811241
  781405
  788838
  578345
  548819
  808193
  430299
  787429
  467998
  477641
  622840
  679273
  516260
  630507
  763100
  598231
  817661
  777699
  779094
  808695
  645204
  546518
  686854
  655538
  752442
  585524
  558484
  805209
  797208
  553125
  789039
  778093
  595730
  787765
  428777
  818016
  825730
  615156
  702266
  717782
  800425
  541280
  559319
  559337
  658863
  677156
  676695
  598210
  539270
  608630
  630364
  426707
  819782
  818951
  819797
  816156
  818736
  782897
  788042
  778051
  798626
  744761
  764636
  764622
  422350
  548017
  764318
  540581
  818021
  827488
  561370
  563964
  663312
  776372
  777980
  780457
  783060
  779572
  780238
  781556
  790077
  805009
]
3.09 ms
(1.59%)
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
  422350
  426707
  428777
  430299
  467998
  474904
  477641
  509522
  516260
  539270
  540581
  541280
  546518
  548017
  548819
  553125
  558484
  559319
  559337
  561370
  563964
  578345
  585524
  592059
  595730
  598210
  598231
  608630
  615156
  621865
  622840
  628195
  630364
  630507
  645204
  655538
  658863
  663312
  676695
  677156
  679273
  686854
  702266
  717782
  726075
  733918
  744761
  752442
  754939
  763100
  763188
  763508
  764318
  764515
  764556
  764622
  764636
  764934
  767624
  768583
  771801
  772551
  772822
  776372
  777699
  777980
  778051
  778093
  779094
  779572
  779828
  780238
  781088
  781405
  781556
  782897
  783060
  787429
  787765
  788042
  788838
  789039
  790077
  790609
  790778
  791009
  791016
  791174
  791673
  792500
  793714
  795641
  797208
  797211
  798626
  800425
  801699
  801707
  802863
  804916
  805009
  805209
  808193
  808695
  811241
  811589
  814281
  814329
  816156
  817661
  818016
  818021
  818736
  818951
  819782
  819797
  825730
  827488
]
2.14 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов минет оральн секс домашн любительск"
]
2.13 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов минет оральн секс домашн любительск"
]
1.92 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov blowjob homemade"
]
1.76 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.