Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.44 ms
(86.55%)
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
  119987
  225519
  383880
  384289
  385066
  386893
  392623
  395278
  397536
  398195
  400382
  401269
  401336
  401764
  402242
  403166
  414194
  415254
  417952
  418871
  421544
  427252
  428655
  429385
  432514
  434549
  441430
  441613
  444338
  447912
  452922
  454278
  456469
  457030
  465986
  477082
  482526
  483611
  489888
  490076
  496087
  499134
  503448
  534331
  536271
  559212
  568531
  574924
  575095
  575475
  575665
  593560
  595435
  595478
  595515
  596350
  596594
  597057
  597567
  597968
  598443
  598493
  598674
  598712
  601519
  602014
  603464
  604259
  604347
  609645
  611047
  615315
  628310
  628968
  633870
  634159
  637690
  639601
  640466
  644246
  644698
  652882
  653229
  659324
  659329
  659423
  662086
  662181
  663181
  666562
  674110
  682924
  684887
  687205
  696227
  717834
  718690
  718719
  720749
  721302
  722594
  722890
  725149
  727807
  729937
  731984
  735951
  740651
  747437
  751692
  753031
  760931
  777084
  786522
  791975
  805961
  806334
  814228
  817660
  824352
]
15.43 ms
(7.88%)
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
  659324
  598712
  392623
  386893
  398195
  534331
  628968
  639601
  611047
  760931
  735951
  747437
  718719
  400382
  401336
  395278
  814228
  482526
  559212
  659329
  597968
  640466
  595478
  633870
  805961
  729937
  721302
  806334
  385066
  824352
  817660
  652882
  644246
  753031
  575665
  575095
  427252
  447912
  674110
  666562
  615315
  604347
  777084
  725149
  402242
  414194
  434549
  454278
  432514
  456469
  457030
  465986
  489888
  490076
  483611
  601519
  574924
  568531
  634159
  444338
  496087
  503448
  662181
  598493
  441430
  383880
  401764
  403166
  441613
  421544
  696227
  595435
  593560
  418871
  401269
  428655
  417952
  477082
  575475
  662086
  687205
  663181
  596350
  597057
  598443
  598674
  628310
  644698
  791975
  727807
  751692
  717834
  452922
  384289
  653229
  596594
  602014
  595515
  604259
  740651
  731984
  609645
  786522
  119987
  415254
  225519
  397536
  429385
  499134
  536271
  682924
  722594
  722890
  659423
  720749
  684887
  718690
  597567
  603464
  637690
]
3.71 ms
(1.90%)
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
  119987
  225519
  383880
  384289
  385066
  386893
  392623
  395278
  397536
  398195
  400382
  401269
  401336
  401764
  402242
  403166
  414194
  415254
  417952
  418871
  421544
  427252
  428655
  429385
  432514
  434549
  441430
  441613
  444338
  447912
  452922
  454278
  456469
  457030
  465986
  477082
  482526
  483611
  489888
  490076
  496087
  499134
  503448
  534331
  536271
  559212
  568531
  574924
  575095
  575475
  575665
  593560
  595435
  595478
  595515
  596350
  596594
  597057
  597567
  597968
  598443
  598493
  598674
  598712
  601519
  602014
  603464
  604259
  604347
  609645
  611047
  615315
  628310
  628968
  633870
  634159
  637690
  639601
  640466
  644246
  644698
  652882
  653229
  659324
  659329
  659423
  662086
  662181
  663181
  666562
  674110
  682924
  684887
  687205
  696227
  717834
  718690
  718719
  720749
  721302
  722594
  722890
  725149
  727807
  729937
  731984
  735951
  740651
  747437
  751692
  753031
  760931
  777084
  786522
  791975
  805961
  806334
  814228
  817660
  824352
]
2.33 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen anal girls"
]
1.70 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen анал девушк"
]
1.69 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.76%)
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.