Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.14 ms
(85.51%)
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
  150461
  392508
  397977
  422350
  479446
  487528
  496247
  536972
  544713
  552993
  553244
  555010
  561487
  572464
  588481
  588885
  593193
  595107
  596394
  601855
  606539
  616438
  616475
  619602
  619689
  627567
  633748
  643569
  644757
  650728
  664671
  669315
  684865
  689807
  690633
  698918
  706784
  709707
  710210
  710244
  710416
  714392
  717089
  719065
  721755
  721831
  723454
  724662
  725025
  725646
  726097
  726308
  728412
  730078
  731027
  731646
  738517
  740666
  746320
  746680
  754654
  755765
  756396
  757083
  757602
  757686
  758128
  758310
  758604
  758988
  759506
  760092
  760677
  764678
  765027
  765823
  766934
  767899
  768721
  768930
  770098
  770722
  770729
  771785
  773809
  777572
  778572
  779035
  779729
  779790
  780954
  781348
  782067
  783178
  785617
  787161
  791491
  791684
  793213
  793347
  795599
  795821
  796490
  796580
  796714
  796752
  797357
  797601
  797713
  798019
  800041
  801309
  801692
  803161
  803194
  803464
  808448
  809716
  810544
  811968
]
12.96 ms
(7.97%)
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
  758128
  765027
  765823
  767899
  726308
  731027
  731646
  738517
  754654
  757686
  758604
  771785
  759506
  760092
  760677
  766934
  768721
  768930
  770098
  740666
  756396
  758988
  770729
  773809
  644757
  710416
  714392
  779035
  782067
  783178
  787161
  797357
  797601
  803161
  422350
  397977
  593193
  633748
  553244
  698918
  650728
  595107
  616475
  730078
  746320
  791491
  795599
  150461
  392508
  479446
  487528
  536972
  496247
  544713
  552993
  572464
  561487
  706784
  717089
  689807
  690633
  709707
  710210
  721755
  664671
  669315
  684865
  710244
  719065
  721831
  723454
  555010
  588481
  601855
  588885
  619689
  596394
  606539
  616438
  619602
  627567
  643569
  778572
  780954
  795821
  796580
  796714
  797713
  803194
  810544
  777572
  779729
  779790
  781348
  796752
  798019
  800041
  801309
  803464
  811968
  725646
  755765
  757083
  758310
  764678
  770722
  785617
  791684
  793213
  793347
  796490
  801692
  808448
  809716
  724662
  725025
  726097
  728412
  746680
  757602
]
2.47 ms
(1.52%)
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
  150461
  392508
  397977
  422350
  479446
  487528
  496247
  536972
  544713
  552993
  553244
  555010
  561487
  572464
  588481
  588885
  593193
  595107
  596394
  601855
  606539
  616438
  616475
  619602
  619689
  627567
  633748
  643569
  644757
  650728
  664671
  669315
  684865
  689807
  690633
  698918
  706784
  709707
  710210
  710244
  710416
  714392
  717089
  719065
  721755
  721831
  723454
  724662
  725025
  725646
  726097
  726308
  728412
  730078
  731027
  731646
  738517
  740666
  746320
  746680
  754654
  755765
  756396
  757083
  757602
  757686
  758128
  758310
  758604
  758988
  759506
  760092
  760677
  764678
  765027
  765823
  766934
  767899
  768721
  768930
  770098
  770722
  770729
  771785
  773809
  777572
  778572
  779035
  779729
  779790
  780954
  781348
  782067
  783178
  785617
  787161
  791491
  791684
  793213
  793347
  795599
  795821
  796490
  796580
  796714
  796752
  797357
  797601
  797713
  798019
  800041
  801309
  801692
  803161
  803194
  803464
  808448
  809716
  810544
  811968
]
2.33 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot sperm"
]
2.15 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot сперм"
]
1.84 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot сперм"
]
1.83 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.