Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.00 ms
(84.31%)
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
  6640
  38135
  82143
  198616
  383659
  425459
  426467
  444349
  460475
  471066
  485021
  495308
  499911
  505935
  507488
  525367
  529729
  535701
  546907
  554960
  556160
  569971
  578740
  583633
  586542
  588221
  591005
  598929
  605828
  616007
  621464
  627491
  632296
  661378
  672833
  679361
  680650
  681075
  699277
  700652
  708594
  714254
  714564
  716915
  718729
  719563
  721903
  729031
  729132
  729683
  734414
  736379
  740070
  741075
  742698
  742824
  743329
  743350
  746594
  750729
  751767
  753043
  753646
  753849
  756342
  758269
  758624
  759160
  767991
  768200
  768969
  770367
  770981
  773114
  773444
  774828
  778602
  779341
  782052
  782766
  783841
  784347
  784446
  785873
  786260
  788302
  788956
  789278
  795678
  796027
  798763
  800107
  800129
  800654
  801517
  804030
  804098
  804300
  804413
  805544
  807003
  807593
  807740
  810037
  811785
  812053
  812447
  813261
  813745
  814378
  815540
  815692
  817887
  820577
  820664
  821554
  824634
  825340
  825488
  826560
]
13.86 ms
(9.35%)
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
  425459
  38135
  495308
  505935
  708594
  718729
  680650
  588221
  804300
  773444
  815692
  810037
  740070
  750729
  6640
  817887
  826560
  821554
  824634
  820664
  825340
  825488
  471066
  525367
  507488
  460475
  583633
  554960
  556160
  699277
  714564
  661378
  716915
  700652
  714254
  719563
  578740
  598929
  605828
  632296
  774828
  783841
  785873
  786260
  784446
  788956
  796027
  798763
  801517
  807740
  812447
  734414
  743350
  758624
  768200
  805544
  807593
  811785
  742698
  758269
  729683
  736379
  759160
  768969
  729031
  756342
  767991
  770367
  773114
  782052
  800654
  813261
  198616
  444349
  820577
  672833
  591005
  746594
  743329
  426467
  813745
  815540
  485021
  499911
  535701
  529729
  546907
  679361
  721903
  681075
  569971
  586542
  616007
  627491
  804030
  807003
  789278
  795678
  729132
  782766
  788302
  800107
  800129
  753646
  753849
  741075
  742824
  751767
  753043
  770981
  778602
  779341
  784347
  804098
  804413
  812053
  82143
  383659
  621464
  814378
]
2.42 ms
(1.63%)
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
  6640
  38135
  82143
  198616
  383659
  425459
  426467
  444349
  460475
  471066
  485021
  495308
  499911
  505935
  507488
  525367
  529729
  535701
  546907
  554960
  556160
  569971
  578740
  583633
  586542
  588221
  591005
  598929
  605828
  616007
  621464
  627491
  632296
  661378
  672833
  679361
  680650
  681075
  699277
  700652
  708594
  714254
  714564
  716915
  718729
  719563
  721903
  729031
  729132
  729683
  734414
  736379
  740070
  741075
  742698
  742824
  743329
  743350
  746594
  750729
  751767
  753043
  753646
  753849
  756342
  758269
  758624
  759160
  767991
  768200
  768969
  770367
  770981
  773114
  773444
  774828
  778602
  779341
  782052
  782766
  783841
  784347
  784446
  785873
  786260
  788302
  788956
  789278
  795678
  796027
  798763
  800107
  800129
  800654
  801517
  804030
  804098
  804300
  804413
  805544
  807003
  807593
  807740
  810037
  811785
  812053
  812447
  813261
  813745
  814378
  815540
  815692
  817887
  820577
  820664
  821554
  824634
  825340
  825488
  826560
]
2.15 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "her pussy"
]
1.68 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "her pussy"
]
1.52 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "her 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.