Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.45 ms
(86.94%)
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
  487788
  530168
  530241
  531371
  532859
  536798
  537087
  537179
  539605
  539773
  540777
  541061
  542558
  543170
  546052
  546079
  553879
  554487
  554672
  559410
  561501
  561794
  561796
  562544
  562753
  577278
  583875
  584040
  584050
  585622
  587552
  588727
  591719
  591743
  591853
  593052
  598307
  605080
  615297
  624794
  628514
  634975
  641503
  642160
  649241
  650323
  651130
  665626
  666087
  666360
  668739
  677891
  680308
  680583
  680609
  687118
  692116
  693722
  697679
  698768
  699499
  701186
  702371
  710879
  714385
  714597
  714820
  715161
  715638
  718606
  719746
  720345
  725617
  728111
  728513
  729053
  730181
  730215
  731134
  732176
  738019
  739190
  740200
  740659
  741865
  742284
  748082
  748867
  761101
  761307
  764273
  768058
  771409
  773469
  780167
  786485
  791348
  791734
  792818
  792898
  793007
  794292
  794484
  794755
  794965
  795273
  795282
  795341
  795609
  795814
  801532
  802039
  803438
  804274
  810594
  811174
  811781
  812110
  812379
  827085
]
12.76 ms
(7.09%)
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
  559410
  714820
  780167
  791348
  793007
  795282
  795609
  802039
  803438
  811174
  812110
  792818
  794755
  795273
  795341
  804274
  810594
  791734
  794484
  801532
  811781
  729053
  742284
  773469
  771409
  739190
  761101
  761307
  768058
  786485
  792898
  794292
  540777
  487788
  530168
  536798
  532859
  537087
  539773
  530241
  539605
  531371
  537179
  541061
  542558
  543170
  553879
  561501
  561796
  562753
  584040
  546079
  554487
  561794
  577278
  584050
  650323
  680308
  687118
  699499
  702371
  714385
  715638
  649241
  665626
  666360
  668739
  693722
  651130
  666087
  680583
  680609
  692116
  710879
  714597
  715161
  718606
  554672
  583875
  605080
  615297
  624794
  628514
  585622
  587552
  588727
  591719
  634975
  591743
  593052
  598307
  642160
  641503
  794965
  725617
  731134
  732176
  730181
  740200
  748082
  764273
  741865
  740659
  698768
  728513
  738019
  719746
  701186
  677891
  591853
  730215
  728111
  827085
  720345
  795814
  546052
  562544
  748867
  812379
  697679
]
2.59 ms
(1.44%)
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
  487788
  530168
  530241
  531371
  532859
  536798
  537087
  537179
  539605
  539773
  540777
  541061
  542558
  543170
  546052
  546079
  553879
  554487
  554672
  559410
  561501
  561794
  561796
  562544
  562753
  577278
  583875
  584040
  584050
  585622
  587552
  588727
  591719
  591743
  591853
  593052
  598307
  605080
  615297
  624794
  628514
  634975
  641503
  642160
  649241
  650323
  651130
  665626
  666087
  666360
  668739
  677891
  680308
  680583
  680609
  687118
  692116
  693722
  697679
  698768
  699499
  701186
  702371
  710879
  714385
  714597
  714820
  715161
  715638
  718606
  719746
  720345
  725617
  728111
  728513
  729053
  730181
  730215
  731134
  732176
  738019
  739190
  740200
  740659
  741865
  742284
  748082
  748867
  761101
  761307
  764273
  768058
  771409
  773469
  780167
  786485
  791348
  791734
  792818
  792898
  793007
  794292
  794484
  794755
  794965
  795273
  795282
  795341
  795609
  795814
  801532
  802039
  803438
  804274
  810594
  811174
  811781
  812110
  812379
  827085
]
2.13 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск жен"
]
2.04 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateurs wife"
]
1.91 ms
(1.06%)
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.