Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.53 ms
(85.38%)
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
  17190
  212024
  387376
  388290
  390593
  395563
  397288
  399088
  399853
  400982
  401793
  401858
  412180
  413296
  416847
  417366
  417491
  417744
  419383
  421977
  423580
  428241
  430103
  430809
  433164
  437635
  441389
  443729
  447499
  447514
  451254
  451755
  456156
  461155
  461743
  463884
  463965
  464593
  475451
  478644
  482538
  485306
  485336
  487189
  489522
  491667
  491718
  494526
  497439
  497976
  501723
  507651
  512257
  512306
  518905
  522288
  527531
  527927
  530476
  530632
  530697
  533266
  533696
  537910
  537929
  541073
  543720
  552637
  557086
  561361
  561685
  561824
  561880
  565158
  565959
  566516
  574473
  574553
  574804
  574813
  574882
  575165
  575464
  575505
  576047
  576104
  576291
  576324
  578392
  594171
  595515
  596582
  597801
  598489
  598712
  603285
  629243
  642687
  644923
  663231
  665714
  666865
  667760
  680151
  680198
  686088
  692051
  697291
  720388
  729940
  735085
  737298
  740373
  747402
  753302
  765278
  780533
  786522
  799531
  817195
]
16.75 ms
(9.38%)
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
  433164
  437635
  447514
  463965
  417491
  447499
  512257
  491667
  522288
  487189
  491718
  489522
  212024
  17190
  390593
  417366
  456156
  518905
  464593
  574473
  665714
  663231
  720388
  574813
  597801
  598489
  595515
  598712
  740373
  753302
  735085
  737298
  765278
  747402
  629243
  786522
  388290
  401858
  397288
  533266
  594171
  441389
  461155
  603285
  537929
  530476
  537910
  697291
  729940
  387376
  817195
  780533
  686088
  692051
  799531
  507651
  596582
  666865
  642687
  395563
  399088
  399853
  400982
  401793
  421977
  430809
  412180
  443729
  413296
  416847
  423580
  430103
  417744
  419383
  428241
  644923
  451755
  475451
  451254
  482538
  461743
  485306
  485336
  497976
  501723
  530697
  497439
  512306
  530632
  527531
  533696
  494526
  527927
  463884
  478644
  561824
  565158
  566516
  574553
  574882
  575464
  575505
  576104
  576291
  552637
  557086
  561880
  565959
  575165
  576324
  578392
  541073
  543720
  561361
  561685
  574804
  576047
  667760
  680151
  680198
]
2.89 ms
(1.62%)
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
  17190
  212024
  387376
  388290
  390593
  395563
  397288
  399088
  399853
  400982
  401793
  401858
  412180
  413296
  416847
  417366
  417491
  417744
  419383
  421977
  423580
  428241
  430103
  430809
  433164
  437635
  441389
  443729
  447499
  447514
  451254
  451755
  456156
  461155
  461743
  463884
  463965
  464593
  475451
  478644
  482538
  485306
  485336
  487189
  489522
  491667
  491718
  494526
  497439
  497976
  501723
  507651
  512257
  512306
  518905
  522288
  527531
  527927
  530476
  530632
  530697
  533266
  533696
  537910
  537929
  541073
  543720
  552637
  557086
  561361
  561685
  561824
  561880
  565158
  565959
  566516
  574473
  574553
  574804
  574813
  574882
  575165
  575464
  575505
  576047
  576104
  576291
  576324
  578392
  594171
  595515
  596582
  597801
  598489
  598712
  603285
  629243
  642687
  644923
  663231
  665714
  666865
  667760
  680151
  680198
  686088
  692051
  697291
  720388
  729940
  735085
  737298
  740373
  747402
  753302
  765278
  780533
  786522
  799531
  817195
]
1.84 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits teen"
]
1.72 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ teen"
]
1.49 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сиськ teen"
]

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.