Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.26 ms
(87.33%)
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
  407401
  428067
  436155
  487570
  536934
  543135
  544935
  554257
  562997
  586613
  587310
  612955
  618315
  618755
  623391
  642292
  675359
  683037
  686620
  689079
  709237
  711650
  712690
  713457
  714551
  714888
  716267
  716508
  717150
  721693
  723565
  723778
  724015
  725183
  727009
  727152
  731259
  732837
  735903
  735925
  739164
  742719
  742723
  742745
  744377
  744770
  746865
  746871
  747827
  748068
  749554
  752104
  753500
  758121
  759732
  759947
  761084
  761579
  763219
  765562
  769481
  769539
  779908
  780469
  782522
  789489
  792961
  793626
  795001
  795299
  795631
  795661
  796119
  796252
  797020
  797238
  800582
  800899
  801044
  801269
  801656
  802144
  802500
  803364
  803563
  805246
  805280
  805706
  807446
  809755
  811562
  817256
  817604
  818053
  818454
  818473
  818771
  818959
  819332
  819348
  819634
  819823
  819893
  819918
  819935
  820057
  820077
  820730
  823974
  824077
  824350
  824451
  824483
  824844
  825985
  826052
  826166
  826651
  826757
  827038
]
14.17 ms
(7.14%)
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
  802500
  739164
  826166
  717150
  800899
  801656
  795631
  735925
  761579
  809755
  759732
  742723
  753500
  612955
  793626
  819823
  721693
  587310
  795299
  765562
  752104
  789489
  407401
  817604
  818454
  819348
  819893
  819918
  826052
  723565
  826651
  817256
  818771
  819634
  820730
  826757
  818053
  818959
  819935
  820077
  819332
  820057
  823974
  824350
  824844
  487570
  544935
  543135
  562997
  686620
  689079
  714888
  675359
  711650
  712690
  713457
  554257
  618315
  623391
  618755
  642292
  779908
  782522
  801044
  805246
  811562
  801269
  803364
  807446
  735903
  744770
  763219
  795001
  805280
  805706
  746871
  724015
  742745
  744377
  749554
  747827
  758121
  727009
  727152
  769481
  769539
  709237
  714551
  716267
  436155
  536934
  683037
  795661
  796252
  803563
  725183
  797238
  761084
  723778
  742719
  746865
  759947
  792961
  797020
  428067
  825985
  780469
  748068
  800582
  802144
  796119
  818473
  824077
  824483
  827038
  824451
  716508
  586613
  731259
  732837
]
3.11 ms
(1.57%)
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
  407401
  428067
  436155
  487570
  536934
  543135
  544935
  554257
  562997
  586613
  587310
  612955
  618315
  618755
  623391
  642292
  675359
  683037
  686620
  689079
  709237
  711650
  712690
  713457
  714551
  714888
  716267
  716508
  717150
  721693
  723565
  723778
  724015
  725183
  727009
  727152
  731259
  732837
  735903
  735925
  739164
  742719
  742723
  742745
  744377
  744770
  746865
  746871
  747827
  748068
  749554
  752104
  753500
  758121
  759732
  759947
  761084
  761579
  763219
  765562
  769481
  769539
  779908
  780469
  782522
  789489
  792961
  793626
  795001
  795299
  795631
  795661
  796119
  796252
  797020
  797238
  800582
  800899
  801044
  801269
  801656
  802144
  802500
  803364
  803563
  805246
  805280
  805706
  807446
  809755
  811562
  817256
  817604
  818053
  818454
  818473
  818771
  818959
  819332
  819348
  819634
  819823
  819893
  819918
  819935
  820057
  820077
  820730
  823974
  824077
  824350
  824451
  824483
  824844
  825985
  826052
  826166
  826651
  826757
  827038
]
2.21 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass stepmom"
]
1.94 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп stepmom"
]
1.87 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп stepmom"
]

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.