Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.66 ms
(85.03%)
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
  346141
  382404
  401799
  410690
  419200
  421052
  435005
  446032
  450579
  451752
  454009
  462377
  464188
  464445
  464844
  467867
  467886
  467945
  469755
  478055
  486768
  496339
  509019
  510905
  511379
  516510
  516652
  521831
  526189
  526544
  530428
  531181
  532732
  535279
  537894
  538963
  539875
  540509
  541501
  547543
  552898
  552912
  554818
  555288
  555297
  557873
  558725
  566320
  581609
  582005
  584267
  586557
  586662
  592696
  593974
  594293
  600200
  604891
  606346
  606831
  627225
  636487
  636666
  639108
  639823
  647905
  648241
  648744
  671560
  680475
  696584
  699325
  708518
  713163
  713176
  713185
  722029
  725747
  728540
  731204
  744021
  746087
  748614
  749106
  750285
  751410
  752759
  756708
  758780
  767286
  773252
  776086
  780653
  782547
  785589
  786876
  786879
  787438
  788344
  790804
  791093
  792412
  795404
  796681
  797088
  797139
  797771
  798775
  799636
  802315
  803019
  808842
  810382
  811119
  811709
  815396
  815778
  821195
  825864
]
19.80 ms
(9.53%)
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
  796681
  382404
  786876
  496339
  454009
  464188
  521831
  639823
  516652
  478055
  647905
  538963
  713176
  648241
  555288
  584267
  648744
  558725
  593974
  748614
  756708
  746087
  725747
  797088
  511379
  516510
  435005
  531181
  526544
  639108
  594293
  467867
  464445
  811119
  791093
  555297
  557873
  671560
  636666
  792412
  535279
  566320
  600200
  586662
  401799
  450579
  532732
  540509
  486768
  547543
  699325
  606346
  780653
  786879
  795404
  810382
  797139
  728540
  749106
  752759
  751410
  825864
  469755
  419200
  462377
  526189
  530428
  552912
  713163
  696584
  586557
  636487
  782547
  803019
  776086
  799636
  802315
  744021
  627225
  537894
  821195
  815778
  815396
  464844
  446032
  539875
  510905
  467945
  541501
  554818
  582005
  713185
  680475
  708518
  722029
  581609
  592696
  604891
  606831
  785589
  787438
  731204
  758780
  790804
  797771
  808842
  811709
  773252
  750285
  767286
  798775
  451752
  509019
  410690
  421052
  467886
  552898
  788344
  787989
  346141
]
3.74 ms
(1.80%)
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
  346141
  382404
  401799
  410690
  419200
  421052
  435005
  446032
  450579
  451752
  454009
  462377
  464188
  464445
  464844
  467867
  467886
  467945
  469755
  478055
  486768
  496339
  509019
  510905
  511379
  516510
  516652
  521831
  526189
  526544
  530428
  531181
  532732
  535279
  537894
  538963
  539875
  540509
  541501
  547543
  552898
  552912
  554818
  555288
  555297
  557873
  558725
  566320
  581609
  582005
  584267
  586557
  586662
  592696
  593974
  594293
  600200
  604891
  606346
  606831
  627225
  636487
  636666
  639108
  639823
  647905
  648241
  648744
  671560
  680475
  696584
  699325
  708518
  713163
  713176
  713185
  722029
  725747
  728540
  731204
  744021
  746087
  748614
  749106
  750285
  751410
  752759
  756708
  758780
  767286
  773252
  776086
  780653
  782547
  785589
  786876
  786879
  787438
  788344
  790804
  791093
  792412
  795404
  796681
  797088
  797139
  797771
  798775
  799636
  802315
  803019
  808842
  810382
  811119
  811709
  815396
  815778
  821195
  825864
]
2.11 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сквирт большая игрушк…"
]
1.92 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм большая большие игрушк"
]
1.86 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.