Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.80 ms
(85.28%)
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
  45985
  246506
  386880
  387460
  422953
  423171
  426477
  438614
  442705
  447092
  447641
  447778
  449541
  454734
  456319
  459461
  459894
  461201
  466469
  466470
  466568
  468302
  468857
  473613
  473763
  476475
  486640
  486738
  487849
  488235
  489034
  492223
  494302
  495335
  501746
  507315
  510995
  512920
  516197
  516378
  516401
  517780
  517793
  519079
  519646
  520568
  526555
  528103
  530860
  540021
  540033
  545327
  547768
  550042
  551980
  565757
  566055
  575666
  580341
  580567
  581878
  585075
  589987
  594236
  599488
  599500
  599548
  600980
  601265
  613309
  617855
  625866
  626435
  627710
  628525
  629034
  634956
  637388
  640830
  644223
  651544
  659945
  661339
  661702
  666688
  674081
  676976
  677028
  681371
  696250
  698853
  701199
  707592
  708667
  709006
  709083
  713589
  714348
  720732
  738511
  755001
  755838
  758123
  779490
  781752
  789636
  791033
  801406
  808102
  810042
  810256
  814046
  814198
  815386
  815466
  816691
  816703
  816969
  824769
  824870
]
15.76 ms
(9.03%)
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
  426477
  488235
  495335
  580567
  551980
  438614
  585075
  816703
  824769
  814198
  815386
  486640
  487849
  492223
  466568
  447092
  466470
  512920
  540021
  510995
  507315
  528103
  530860
  540033
  468302
  545327
  580341
  565757
  566055
  575666
  581878
  651544
  659945
  661702
  681371
  696250
  698853
  701199
  709006
  713589
  666688
  676976
  714348
  661339
  677028
  708667
  709083
  547768
  550042
  629034
  594236
  601265
  644223
  589987
  599488
  599500
  599548
  613309
  627710
  600980
  617855
  628525
  637388
  640830
  781752
  789636
  779490
  808102
  810042
  755001
  755838
  738511
  758123
  625866
  626435
  634956
  707592
  720732
  791033
  801406
  810256
  45985
  386880
  447778
  473613
  476475
  246506
  449541
  456319
  459461
  516378
  494302
  520568
  526555
  516401
  517780
  519646
  501746
  516197
  517793
  519079
  674081
  387460
  423171
  422953
  442705
  824870
  815466
  816691
  816969
  814046
  459894
  468857
  447641
  473763
  486738
  489034
  454734
  461201
  466469
]
2.93 ms
(1.68%)
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
  45985
  246506
  386880
  387460
  422953
  423171
  426477
  438614
  442705
  447092
  447641
  447778
  449541
  454734
  456319
  459461
  459894
  461201
  466469
  466470
  466568
  468302
  468857
  473613
  473763
  476475
  486640
  486738
  487849
  488235
  489034
  492223
  494302
  495335
  501746
  507315
  510995
  512920
  516197
  516378
  516401
  517780
  517793
  519079
  519646
  520568
  526555
  528103
  530860
  540021
  540033
  545327
  547768
  550042
  551980
  565757
  566055
  575666
  580341
  580567
  581878
  585075
  589987
  594236
  599488
  599500
  599548
  600980
  601265
  613309
  617855
  625866
  626435
  627710
  628525
  629034
  634956
  637388
  640830
  644223
  651544
  659945
  661339
  661702
  666688
  674081
  676976
  677028
  681371
  696250
  698853
  701199
  707592
  708667
  709006
  709083
  713589
  714348
  720732
  738511
  755001
  755838
  758123
  779490
  781752
  789636
  791033
  801406
  808102
  810042
  810256
  814046
  814198
  815386
  815466
  816691
  816703
  816969
  824769
  824870
]
2.02 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body hair"
]
1.70 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body hair"
]
1.62 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body with hair"
]

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.