Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.76 ms
(85.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
  6669
  31758
  91344
  150488
  159392
  172340
  315815
  338113
  380962
  385290
  389266
  390467
  392386
  394309
  395526
  395983
  396432
  397613
  398914
  400588
  400598
  402450
  403986
  407438
  407910
  408620
  409804
  410796
  411533
  417266
  419842
  422718
  423959
  431594
  440721
  446484
  452312
  454014
  454614
  454655
  460131
  461314
  465536
  465612
  466387
  467901
  473816
  475728
  476066
  479123
  479362
  479708
  480518
  487623
  493021
  497125
  498436
  499172
  501000
  511408
  512795
  514196
  515443
  515793
  522518
  523126
  532407
  534011
  534469
  539463
  541737
  545495
  546516
  550257
  554064
  556172
  556763
  571312
  577137
  577652
  589428
  589485
  589712
  593241
  593975
  602109
  602663
  603369
  605505
  610884
  616265
  620813
  627135
  632718
  641313
  643451
  667377
  696763
  706421
  706422
  713841
  722369
  728932
  729382
  732646
  734416
  735734
  742833
  745457
  749606
  755553
  760521
  762227
  763410
  776542
  778610
  781941
  792458
  811961
  813240
]
13.63 ms
(8.53%)
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
  755553
  732646
  760521
  762227
  763410
  749606
  395526
  466387
  398914
  31758
  419842
  422718
  792458
  408620
  541737
  395983
  380962
  410796
  460131
  454014
  454655
  497125
  556172
  706422
  556763
  589712
  616265
  742833
  409804
  479362
  396432
  431594
  511408
  493021
  515443
  523126
  593975
  475728
  501000
  722369
  605505
  729382
  602109
  811961
  394309
  480518
  487623
  539463
  315815
  6669
  159392
  407910
  423959
  512795
  465612
  577652
  577137
  696763
  589428
  603369
  643451
  620813
  627135
  610884
  641313
  776542
  813240
  728932
  734416
  632718
  706421
  713841
  778610
  781941
  397613
  411533
  440721
  390467
  465536
  473816
  338113
  385290
  403986
  452312
  515793
  532407
  546516
  172340
  667377
  593241
  602663
  735734
  389266
  514196
  534011
  522518
  554064
  589485
  150488
  392386
  91344
  400588
  400598
  402450
  407438
  454614
  467901
  498436
  499172
  534469
  461314
  550257
  571312
  545495
  745457
  417266
  476066
  479708
  446484
  479123
]
3.20 ms
(2.00%)
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
  6669
  31758
  91344
  150488
  159392
  172340
  315815
  338113
  380962
  385290
  389266
  390467
  392386
  394309
  395526
  395983
  396432
  397613
  398914
  400588
  400598
  402450
  403986
  407438
  407910
  408620
  409804
  410796
  411533
  417266
  419842
  422718
  423959
  431594
  440721
  446484
  452312
  454014
  454614
  454655
  460131
  461314
  465536
  465612
  466387
  467901
  473816
  475728
  476066
  479123
  479362
  479708
  480518
  487623
  493021
  497125
  498436
  499172
  501000
  511408
  512795
  514196
  515443
  515793
  522518
  523126
  532407
  534011
  534469
  539463
  541737
  545495
  546516
  550257
  554064
  556172
  556763
  571312
  577137
  577652
  589428
  589485
  589712
  593241
  593975
  602109
  602663
  603369
  605505
  610884
  616265
  620813
  627135
  632718
  641313
  643451
  667377
  696763
  706421
  706422
  713841
  722369
  728932
  729382
  732646
  734416
  735734
  742833
  745457
  749606
  755553
  760521
  762227
  763410
  776542
  778610
  781941
  792458
  811961
  813240
]
1.74 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "розовая попка"
]
1.69 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "розов жоп"
]
1.45 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.18 ms
(0.74%)
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.