Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.69 ms
(84.67%)
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
  386273
  391982
  396331
  402217
  412535
  416470
  422099
  425168
  425775
  428711
  428758
  429888
  430548
  431597
  436074
  438067
  440625
  445221
  445396
  446298
  447446
  453809
  454210
  454754
  458488
  460758
  461215
  465970
  466908
  468592
  469899
  470816
  471443
  472316
  472916
  473507
  475414
  476082
  476649
  477100
  478295
  482799
  483275
  486432
  487431
  490050
  493031
  494492
  495140
  495163
  497837
  500238
  503673
  505614
  510586
  510797
  511064
  511238
  511370
  511576
  514327
  514375
  515310
  515620
  515684
  515747
  517088
  518511
  519194
  519321
  519542
  519563
  520154
  522037
  524323
  524535
  524542
  524545
  526267
  532251
  534296
  538972
  543061
  544455
  547242
  548056
  552354
  555717
  556426
  560660
  567220
  567798
  568732
  569030
  572813
  577822
  585079
  589509
  590599
  593125
  593361
  595847
  597193
  600913
  601754
  604342
  605662
  605988
  607537
  619703
  621523
  623646
  624127
  653302
  660306
  663212
  667750
  668688
  682337
  683083
]
16.81 ms
(9.77%)
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
  497837
  396331
  477100
  460758
  600913
  436074
  663212
  447446
  517088
  514375
  590599
  605662
  445221
  538972
  515684
  470816
  422099
  593361
  430548
  471443
  472316
  510797
  526267
  495140
  476082
  567798
  569030
  556426
  560660
  667750
  668688
  624127
  438067
  429888
  476649
  495163
  503673
  505614
  543061
  567220
  604342
  589509
  465970
  428711
  605988
  532251
  391982
  431597
  461215
  682337
  412535
  386273
  482799
  466908
  585079
  475414
  468592
  473507
  547242
  595847
  619703
  428758
  445396
  519542
  440625
  660306
  524323
  519563
  514327
  524542
  577822
  469899
  519321
  515310
  493031
  555717
  402217
  511064
  487431
  593125
  524545
  552354
  568732
  623646
  621523
  500238
  511576
  483275
  515747
  518511
  454210
  490050
  511370
  524535
  544455
  683083
  534296
  548056
  601754
  522037
  520154
  597193
  607537
  425775
  494492
  416470
  478295
  446298
  510586
  511238
  572813
  458488
  454754
  515620
  453809
  653302
  519194
  425168
  486432
  472916
]
2.39 ms
(1.39%)
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
  386273
  391982
  396331
  402217
  412535
  416470
  422099
  425168
  425775
  428711
  428758
  429888
  430548
  431597
  436074
  438067
  440625
  445221
  445396
  446298
  447446
  453809
  454210
  454754
  458488
  460758
  461215
  465970
  466908
  468592
  469899
  470816
  471443
  472316
  472916
  473507
  475414
  476082
  476649
  477100
  478295
  482799
  483275
  486432
  487431
  490050
  493031
  494492
  495140
  495163
  497837
  500238
  503673
  505614
  510586
  510797
  511064
  511238
  511370
  511576
  514327
  514375
  515310
  515620
  515684
  515747
  517088
  518511
  519194
  519321
  519542
  519563
  520154
  522037
  524323
  524535
  524542
  524545
  526267
  532251
  534296
  538972
  543061
  544455
  547242
  548056
  552354
  555717
  556426
  560660
  567220
  567798
  568732
  569030
  572813
  577822
  585079
  589509
  590599
  593125
  593361
  595847
  597193
  600913
  601754
  604342
  605662
  605988
  607537
  619703
  621523
  623646
  624127
  653302
  660306
  663212
  667750
  668688
  682337
  683083
]
2.13 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мастурбирует в кроват…"
]
1.85 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац в кроват"
]
1.46 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац в кроват"
]

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.