Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.99 ms
(85.36%)
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
  399152
  399598
  417173
  417403
  417560
  417638
  424129
  424213
  427115
  429872
  435355
  437260
  437657
  437970
  438446
  445752
  447281
  449317
  452498
  455015
  455428
  456062
  456388
  459500
  460314
  460986
  464895
  467889
  468601
  471958
  475014
  475622
  476475
  479949
  479965
  480932
  482041
  483667
  487329
  489230
  492355
  493453
  494894
  500308
  502447
  504118
  505196
  505317
  513579
  519237
  521697
  523717
  525807
  527820
  536072
  545334
  548664
  552370
  552624
  552811
  556900
  558143
  558592
  560793
  561909
  563251
  566356
  567217
  571341
  582380
  586699
  589153
  590479
  599528
  602711
  602961
  617604
  619230
  621394
  636471
  646748
  648570
  674475
  678696
  688914
  693374
  696455
  696911
  707867
  709510
  712271
  713583
  718060
  721332
  721875
  733910
  736896
  753895
  761688
  764153
  766342
  766716
  769839
  772579
  777677
  777742
  777968
  779239
  780676
  784110
  784596
  787528
  787532
  795612
  803827
  807009
  809982
  810440
  816703
]
16.61 ms
(8.98%)
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
  527820
  489230
  504118
  505196
  513579
  521697
  424213
  816703
  536072
  566356
  567217
  571341
  545334
  558143
  646748
  674475
  696455
  707867
  709510
  721332
  648570
  678696
  688914
  693374
  713583
  718060
  548664
  552370
  589153
  602961
  621394
  617604
  636471
  586699
  599528
  619115
  619230
  777742
  777968
  784596
  795612
  807009
  779239
  780676
  787528
  787532
  809982
  810440
  761688
  766716
  772579
  784110
  803827
  736896
  764153
  769839
  753895
  733910
  766342
  696911
  712271
  721875
  777677
  417560
  475014
  399152
  399598
  437657
  437970
  447281
  456388
  476475
  479949
  417173
  445752
  437260
  456062
  523717
  500308
  502447
  483667
  487329
  492355
  494894
  552624
  556900
  558592
  582380
  552811
  560793
  561909
  563251
  590479
  602711
  424129
  427115
  438446
  452498
  464895
  480932
  435355
  459500
  467889
  468601
  482041
  417638
  429872
  455015
  460986
  417403
  455428
  471958
  479965
  449317
  460314
  475622
  525807
  493453
  505317
  519237
]
2.63 ms
(1.42%)
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
  399152
  399598
  417173
  417403
  417560
  417638
  424129
  424213
  427115
  429872
  435355
  437260
  437657
  437970
  438446
  445752
  447281
  449317
  452498
  455015
  455428
  456062
  456388
  459500
  460314
  460986
  464895
  467889
  468601
  471958
  475014
  475622
  476475
  479949
  479965
  480932
  482041
  483667
  487329
  489230
  492355
  493453
  494894
  500308
  502447
  504118
  505196
  505317
  513579
  519237
  521697
  523717
  525807
  527820
  536072
  545334
  548664
  552370
  552624
  552811
  556900
  558143
  558592
  560793
  561909
  563251
  566356
  567217
  571341
  582380
  586699
  589153
  590479
  599528
  602711
  602961
  617604
  619230
  621394
  636471
  646748
  648570
  674475
  678696
  688914
  693374
  696455
  696911
  707867
  709510
  712271
  713583
  718060
  721332
  721875
  733910
  736896
  753895
  761688
  764153
  766342
  766716
  769839
  772579
  777677
  777742
  777968
  779239
  780676
  784110
  784596
  787528
  787532
  795612
  803827
  807009
  809982
  810440
  816703
]
2.36 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "orgasm russian"
]
1.98 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "orgasm русск"
]
1.77 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "orgasm русск"
]
1.76 ms
(0.95%)
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.