Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.52 ms
(83.12%)
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
  382928
  385202
  388653
  411477
  417050
  417929
  423981
  425694
  428009
  429523
  438638
  441209
  441237
  442979
  443510
  445050
  446698
  449592
  451316
  451875
  454844
  456109
  457294
  458916
  459085
  460561
  463716
  464194
  466635
  467568
  468213
  471425
  471780
  478488
  478931
  481673
  481806
  482610
  482773
  492126
  495418
  496527
  496708
  498830
  499174
  499177
  499336
  503241
  504876
  505090
  505172
  505667
  505797
  507946
  508427
  509543
  511291
  516655
  516666
  518405
  519392
  520213
  521550
  521788
  524440
  524859
  524866
  526073
  528035
  528815
  529403
  531907
  534825
  544640
  554445
  556330
  556699
  558581
  560314
  579171
  580472
  580941
  582393
  583593
  584212
  588249
  592259
  594868
  597947
  601035
  601981
  603684
  603977
  604505
  605224
  614715
  617214
  621689
  622264
  626082
  626737
  630915
  633515
  633972
  635490
  644917
  653956
  667826
  675107
  675144
  675429
  675431
  675660
  675675
  675723
  675725
  712775
  727744
  733573
  792817
]
18.39 ms
(10.51%)
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
  428009
  441209
  464194
  460561
  505172
  499177
  505090
  667826
  417929
  604505
  601981
  478488
  466635
  456109
  504876
  503241
  385202
  388653
  481806
  792817
  454844
  505667
  521550
  675107
  675675
  675660
  675144
  675723
  560314
  622264
  459085
  529403
  521788
  592259
  458916
  468213
  603977
  633515
  528035
  417050
  531907
  626737
  467568
  534825
  528815
  496708
  516666
  582393
  653956
  579171
  583593
  597947
  633972
  526073
  492126
  443510
  482610
  495418
  588249
  508427
  441237
  411477
  644917
  482773
  451875
  451316
  449592
  520213
  518405
  511291
  584212
  605224
  614715
  733573
  626082
  423981
  438638
  499174
  509543
  516655
  445050
  499336
  507946
  580941
  675429
  675431
  675725
  712775
  603684
  635490
  498830
  580472
  554445
  617214
  463716
  524859
  558581
  630915
  471780
  621689
  727744
  446698
  478931
  481673
  471425
  382928
  425694
  519392
  505797
  594868
  442979
  524866
  601035
  429523
  457294
  524440
  496527
  556330
  544640
  556699
]
3.84 ms
(2.19%)
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
  382928
  385202
  388653
  411477
  417050
  417929
  423981
  425694
  428009
  429523
  438638
  441209
  441237
  442979
  443510
  445050
  446698
  449592
  451316
  451875
  454844
  456109
  457294
  458916
  459085
  460561
  463716
  464194
  466635
  467568
  468213
  471425
  471780
  478488
  478931
  481673
  481806
  482610
  482773
  492126
  495418
  496527
  496708
  498830
  499174
  499177
  499336
  503241
  504876
  505090
  505172
  505667
  505797
  507946
  508427
  509543
  511291
  516655
  516666
  518405
  519392
  520213
  521550
  521788
  524440
  524859
  524866
  526073
  528035
  528815
  529403
  531907
  534825
  544640
  554445
  556330
  556699
  558581
  560314
  579171
  580472
  580941
  582393
  583593
  584212
  588249
  592259
  594868
  597947
  601035
  601981
  603684
  603977
  604505
  605224
  614715
  617214
  621689
  622264
  626082
  626737
  630915
  633515
  633972
  635490
  644917
  653956
  667826
  675107
  675144
  675429
  675431
  675660
  675675
  675723
  675725
  712775
  727744
  733573
  792817
]
1.97 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black cock amateur"
]
1.80 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black cock любительск"
]
1.74 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black cock любительск"
]

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.