Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.46 ms
(80.92%)
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
  191048
  400491
  404629
  423486
  424232
  429953
  434376
  447721
  452263
  452299
  452813
  455207
  455816
  456455
  457003
  458793
  462606
  463084
  469736
  476674
  476986
  477094
  477114
  478035
  485147
  492136
  495400
  502762
  503086
  503658
  506407
  508451
  519642
  520319
  520753
  520759
  522618
  523924
  529801
  530011
  530275
  532241
  533534
  537970
  541889
  545763
  552348
  552623
  562894
  564203
  564891
  567591
  570165
  577435
  580219
  580561
  580631
  583384
  591259
  592324
  593764
  597216
  600011
  603589
  611301
  615382
  617212
  618381
  619527
  619536
  619556
  621683
  622241
  623261
  626944
  639258
  641127
  642006
  642016
  642037
  645870
  647837
  673314
  675008
  675022
  705099
  715089
  717898
  734578
  735778
  738236
  742817
  742865
  750699
  751575
  767377
  771251
  775889
  796180
  797351
  803620
  805005
  810336
  814901
  824920
  825812
  826019
]
18.07 ms
(11.57%)
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
  577435
  552623
  580631
  805005
  814901
  508451
  191048
  469736
  545763
  455207
  591259
  603589
  520753
  826019
  532241
  452813
  456455
  541889
  796180
  476986
  452263
  530275
  404629
  530011
  580219
  623261
  641127
  478035
  429953
  715089
  735778
  824920
  717898
  533534
  423486
  580561
  810336
  734578
  803620
  503658
  675022
  622241
  647837
  452299
  611301
  522618
  562894
  462606
  775889
  797351
  564203
  477094
  619556
  742865
  593764
  751575
  750699
  738236
  463084
  503086
  492136
  675008
  597216
  639258
  642006
  642037
  642016
  455816
  825812
  506407
  567591
  742817
  502762
  523924
  767377
  457003
  645870
  619536
  424232
  458793
  705099
  529801
  618381
  771251
  583384
  477114
  400491
  520319
  619527
  626944
  552348
  592324
  537970
  495400
  673314
  485147
  621683
  447721
  476674
  519642
  570165
  564891
  600011
  615382
  434376
  617212
  520759
]
3.54 ms
(2.27%)
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
  191048
  400491
  404629
  423486
  424232
  429953
  434376
  447721
  452263
  452299
  452813
  455207
  455816
  456455
  457003
  458793
  462606
  463084
  469736
  476674
  476986
  477094
  477114
  478035
  485147
  492136
  495400
  502762
  503086
  503658
  506407
  508451
  519642
  520319
  520753
  520759
  522618
  523924
  529801
  530011
  530275
  532241
  533534
  537970
  541889
  545763
  552348
  552623
  562894
  564203
  564891
  567591
  570165
  577435
  580219
  580561
  580631
  583384
  591259
  592324
  593764
  597216
  600011
  603589
  611301
  615382
  617212
  618381
  619527
  619536
  619556
  621683
  622241
  623261
  626944
  639258
  641127
  642006
  642016
  642037
  645870
  647837
  673314
  675008
  675022
  705099
  715089
  717898
  734578
  735778
  738236
  742817
  742865
  750699
  751575
  767377
  771251
  775889
  796180
  797351
  803620
  805005
  810336
  814901
  824920
  825812
  826019
]
2.37 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard mother anal"
]
2.11 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard мам женщин анал"
]
1.96 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard мам женщин анал"
]

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.