Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.30 ms
(83.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
  383775
  390592
  409921
  417454
  419677
  421206
  428681
  430392
  433998
  436440
  442658
  447447
  454529
  457979
  458125
  469575
  474078
  474379
  475911
  477254
  482081
  483952
  487189
  487724
  497964
  513779
  540183
  541919
  542144
  544471
  547814
  547823
  548660
  548694
  549292
  552650
  553563
  553722
  554540
  555788
  556324
  557742
  558024
  558421
  558573
  558619
  558839
  559501
  560209
  561825
  562291
  563801
  564597
  565481
  569850
  569878
  570418
  570643
  572107
  572134
  572436
  572519
  573379
  573558
  573685
  573698
  573874
  574843
  575112
  575132
  575816
  576025
  576041
  576098
  576732
  577365
  578420
  578472
  581301
  584540
  584974
  585133
  585249
  588204
  592844
  595441
  598621
  598680
  598812
  603103
  605683
  607289
  613155
  622188
  627804
  653287
  655348
  659116
  672744
  675790
  679037
  679702
  718581
  719146
  721310
  721381
  722542
  728902
  735995
  743116
  745075
  750560
  759548
  770489
  777079
  780673
  811184
  817662
  821631
  827974
]
15.04 ms
(9.79%)
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
  562291
  588204
  750560
  770489
  421206
  409921
  513779
  622188
  442658
  475911
  433998
  487189
  569850
  570643
  743116
  745075
  817662
  675790
  547823
  383775
  564597
  575112
  576025
  576041
  578472
  430392
  548660
  563801
  575816
  572107
  573698
  558573
  653287
  655348
  553563
  573874
  574843
  576732
  584974
  598621
  558421
  558619
  569878
  542144
  553722
  722542
  554540
  572436
  573685
  598812
  613155
  390592
  577365
  547814
  584540
  541919
  560209
  565481
  598680
  627804
  555788
  457979
  419677
  428681
  469575
  595441
  482081
  483952
  474078
  447447
  417454
  672744
  573379
  585249
  605683
  436440
  477254
  458125
  497964
  548694
  474379
  487724
  679037
  721310
  607289
  777079
  728902
  759548
  718581
  721381
  454529
  581301
  603103
  544471
  821631
  827974
  540183
  659116
  719146
  549292
  780673
  735995
  811184
  585133
  558024
  559501
  575132
  576098
  572134
  578420
  558839
  570418
  572519
  573558
  679702
  552650
  556324
  557742
  561825
  592844
]
2.94 ms
(1.92%)
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
  383775
  390592
  409921
  417454
  419677
  421206
  428681
  430392
  433998
  436440
  442658
  447447
  454529
  457979
  458125
  469575
  474078
  474379
  475911
  477254
  482081
  483952
  487189
  487724
  497964
  513779
  540183
  541919
  542144
  544471
  547814
  547823
  548660
  548694
  549292
  552650
  553563
  553722
  554540
  555788
  556324
  557742
  558024
  558421
  558573
  558619
  558839
  559501
  560209
  561825
  562291
  563801
  564597
  565481
  569850
  569878
  570418
  570643
  572107
  572134
  572436
  572519
  573379
  573558
  573685
  573698
  573874
  574843
  575112
  575132
  575816
  576025
  576041
  576098
  576732
  577365
  578420
  578472
  581301
  584540
  584974
  585133
  585249
  588204
  592844
  595441
  598621
  598680
  598812
  603103
  605683
  607289
  613155
  622188
  627804
  653287
  655348
  659116
  672744
  675790
  679037
  679702
  718581
  719146
  721310
  721381
  722542
  728902
  735995
  743116
  745075
  750560
  759548
  770489
  777079
  780673
  811184
  817662
  821631
  827974
]
2.05 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лижет маленькую киску…"
]
1.88 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза маленькая вагин"
]
1.76 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза маленькая вагин"
]
1.66 ms
(1.08%)
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.