Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.61 ms
(85.82%)
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
  92019
  191069
  385125
  387627
  393429
  393779
  394187
  396013
  396176
  399351
  400430
  400454
  400989
  404359
  411937
  416303
  418495
  418740
  422610
  424569
  429342
  430135
  430650
  437804
  443362
  443729
  445345
  445363
  446485
  458039
  462523
  463166
  463168
  463169
  464506
  464940
  466154
  468617
  468756
  470802
  470840
  481320
  482793
  482828
  482966
  488600
  492610
  497515
  499506
  503955
  506499
  511725
  515194
  519986
  520627
  521715
  521872
  522321
  522779
  523262
  524627
  525653
  526949
  531502
  538203
  541332
  550441
  554428
  563871
  564417
  566986
  569665
  569666
  569683
  569690
  569866
  570048
  570060
  570065
  570071
  570075
  570077
  571210
  571958
  572166
  576021
  576082
  576352
  578446
  578468
  578474
  581666
  587297
  600455
  659775
  665381
  685004
  689272
  693078
  714428
  718971
  719244
  734840
  744329
  747558
  759576
  759609
  779300
  789321
  813717
  813914
  814073
  819043
  821443
  821719
  821866
  823000
  823359
  823493
  827942
]
19.88 ms
(9.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
  747558
  759576
  759609
  719244
  789321
  92019
  393429
  411937
  515194
  600455
  779300
  718971
  385125
  191069
  396013
  399351
  443729
  482793
  446485
  470802
  563871
  569866
  570048
  570065
  576021
  581666
  572166
  578446
  578468
  566986
  659775
  693078
  550441
  564417
  570060
  576352
  578474
  587297
  734840
  400989
  464506
  458039
  462523
  463166
  463169
  468617
  418495
  430650
  445363
  468756
  481320
  418740
  422610
  437804
  466154
  522779
  525653
  482828
  482966
  519986
  522321
  523262
  524627
  492610
  497515
  503955
  506499
  511725
  541332
  488600
  499506
  538203
  521872
  526949
  404359
  570077
  416303
  394187
  393779
  443362
  464940
  554428
  570071
  569666
  569690
  569683
  571210
  714428
  689272
  665381
  685004
  569665
  570075
  744329
  400454
  429342
  463168
  470840
  576082
  571958
  430135
  445345
  424569
  521715
  520627
  387627
  396176
  400430
  813914
  814073
  821866
  813717
  819043
  821719
  823000
  821443
  823359
  823493
  827942
  531502
]
2.97 ms
(1.38%)
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
  92019
  191069
  385125
  387627
  393429
  393779
  394187
  396013
  396176
  399351
  400430
  400454
  400989
  404359
  411937
  416303
  418495
  418740
  422610
  424569
  429342
  430135
  430650
  437804
  443362
  443729
  445345
  445363
  446485
  458039
  462523
  463166
  463168
  463169
  464506
  464940
  466154
  468617
  468756
  470802
  470840
  481320
  482793
  482828
  482966
  488600
  492610
  497515
  499506
  503955
  506499
  511725
  515194
  519986
  520627
  521715
  521872
  522321
  522779
  523262
  524627
  525653
  526949
  531502
  538203
  541332
  550441
  554428
  563871
  564417
  566986
  569665
  569666
  569683
  569690
  569866
  570048
  570060
  570065
  570071
  570075
  570077
  571210
  571958
  572166
  576021
  576082
  576352
  578446
  578468
  578474
  581666
  587297
  600455
  659775
  665381
  685004
  689272
  693078
  714428
  718971
  719244
  734840
  744329
  747558
  759576
  759609
  779300
  789321
  813717
  813914
  814073
  819043
  821443
  821719
  821866
  823000
  823359
  823493
  827942
]
1.94 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая young pussy"
]
1.92 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful young pussy"
]
1.90 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая young pussy"
]

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.