Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.46 ms
(86.42%)
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
  28386
  365348
  384945
  387441
  400469
  401589
  402928
  412518
  412537
  412866
  413254
  413289
  414220
  418493
  421138
  426177
  429161
  432327
  434838
  443197
  444098
  445764
  446656
  447390
  447496
  447609
  448077
  449291
  457653
  460853
  467324
  468209
  470784
  470839
  473019
  475509
  479281
  485017
  486889
  488060
  491581
  494645
  494815
  494822
  498875
  499177
  500943
  501567
  501784
  503293
  512297
  512647
  515556
  518152
  521869
  528018
  528182
  550716
  560630
  562236
  564461
  571585
  576039
  576102
  576276
  576290
  586928
  593237
  595419
  604064
  617096
  620775
  628055
  631299
  648754
  652262
  668397
  674240
  679347
  679355
  679385
  685676
  696465
  709306
  710246
  712882
  717887
  722854
  726449
  736056
  737386
  742456
  744540
  747257
  747487
  754529
  756047
  767560
  773349
  774299
  775995
  779124
  779360
  779532
  780369
  780445
  784069
  786859
  790240
  791789
  800976
  801901
  803079
  803677
  820150
  825803
  825942
  826103
  827960
]
14.61 ms
(8.39%)
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
  426177
  562236
  800976
  803677
  413254
  449291
  470784
  468209
  825942
  744540
  28386
  825803
  503293
  652262
  668397
  747487
  726449
  402928
  518152
  576290
  564461
  571585
  576276
  710246
  679385
  560630
  586928
  595419
  421138
  447609
  434838
  445764
  457653
  475509
  443197
  479281
  512647
  501567
  512297
  498875
  500943
  696465
  780445
  412866
  401589
  413289
  447390
  470839
  827960
  742456
  773349
  737386
  767560
  780369
  791789
  779360
  648754
  628055
  784069
  786859
  754529
  679347
  384945
  604064
  779124
  790240
  774299
  617096
  709306
  779532
  387441
  593237
  801901
  736056
  775995
  494815
  712882
  827931
  826103
  722854
  685676
  747257
  756047
  803079
  631299
  365348
  460853
  446656
  550716
  576039
  674240
  679355
  717887
  576102
  620775
  447496
  429161
  467324
  412518
  432327
  400469
  414220
  418493
  444098
  448077
  473019
  528182
  486889
  494645
  501784
  491581
  515556
  485017
  488060
  494822
  499177
  521869
  528018
  412537
  820150
]
2.33 ms
(1.34%)
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
  28386
  365348
  384945
  387441
  400469
  401589
  402928
  412518
  412537
  412866
  413254
  413289
  414220
  418493
  421138
  426177
  429161
  432327
  434838
  443197
  444098
  445764
  446656
  447390
  447496
  447609
  448077
  449291
  457653
  460853
  467324
  468209
  470784
  470839
  473019
  475509
  479281
  485017
  486889
  488060
  491581
  494645
  494815
  494822
  498875
  499177
  500943
  501567
  501784
  503293
  512297
  512647
  515556
  518152
  521869
  528018
  528182
  550716
  560630
  562236
  564461
  571585
  576039
  576102
  576276
  576290
  586928
  593237
  595419
  604064
  617096
  620775
  628055
  631299
  648754
  652262
  668397
  674240
  679347
  679355
  679385
  685676
  696465
  709306
  710246
  712882
  717887
  722854
  726449
  736056
  737386
  742456
  744540
  747257
  747487
  754529
  756047
  767560
  773349
  774299
  775995
  779124
  779360
  779532
  780369
  780445
  784069
  786859
  790240
  791789
  800976
  801901
  803079
  803677
  820150
  825803
  825942
  826103
  827960
]
2.04 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful pussy"
]
1.75 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая pussy"
]
1.35 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая pussy"
]

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.