Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.39 ms
(85.92%)
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
  79570
  392066
  394031
  394258
  394366
  395780
  415815
  423058
  423148
  424247
  424520
  426011
  426484
  427081
  432887
  434470
  434531
  435414
  436938
  437948
  437986
  438005
  438023
  438028
  438044
  438056
  438109
  443459
  443958
  450149
  452872
  455626
  456832
  460288
  461180
  461233
  461969
  463807
  469333
  469361
  469710
  475213
  496472
  496586
  498670
  500994
  507083
  509250
  514066
  521355
  526881
  527845
  528814
  530194
  536989
  538062
  539375
  544423
  549490
  551645
  555088
  555110
  557922
  561809
  573277
  574096
  577243
  577632
  585569
  590917
  592963
  593754
  594167
  596520
  600235
  615963
  621099
  624600
  628589
  638000
  645976
  653330
  714198
  714755
  716546
  717914
  718864
  725425
  725451
  728619
  731317
  732589
  741760
  742987
  747044
  752505
  753726
  761639
  763378
  764319
  766628
  767769
  777482
  777526
  777814
  779722
  779801
  780676
  780936
  784667
  787754
  789768
  791250
  798631
  805292
  809329
  809702
  810531
  813621
  813625
]
11.17 ms
(7.25%)
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
  469361
  763378
  426484
  437986
  791250
  434531
  527845
  539375
  787754
  507083
  549490
  777482
  424247
  813625
  496586
  574096
  561809
  592963
  777526
  779801
  780676
  752505
  764319
  747044
  777814
  394366
  438023
  766628
  79570
  423058
  573277
  645976
  789768
  742987
  761639
  438028
  438109
  436938
  530194
  653330
  551645
  596520
  805292
  438044
  717914
  714198
  600235
  753726
  394031
  577243
  526881
  536989
  555088
  555110
  813621
  500994
  544423
  557922
  718864
  593754
  624600
  594167
  809702
  810531
  725425
  767769
  424520
  426011
  438056
  432887
  496472
  521355
  463807
  714755
  716546
  784667
  732589
  392066
  435414
  461180
  475213
  423148
  461233
  460288
  514066
  438005
  779722
  809329
  728619
  455626
  538062
  585569
  731317
  528814
  443459
  456832
  577632
  590917
  725451
  395780
  437948
  469333
  469710
  461969
  450149
  452872
  628589
  621099
  615963
  741760
  798631
  638000
  780936
  394258
  434470
  415815
  427081
  443958
  509250
  498670
]
2.98 ms
(1.93%)
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
  79570
  392066
  394031
  394258
  394366
  395780
  415815
  423058
  423148
  424247
  424520
  426011
  426484
  427081
  432887
  434470
  434531
  435414
  436938
  437948
  437986
  438005
  438023
  438028
  438044
  438056
  438109
  443459
  443958
  450149
  452872
  455626
  456832
  460288
  461180
  461233
  461969
  463807
  469333
  469361
  469710
  475213
  496472
  496586
  498670
  500994
  507083
  509250
  514066
  521355
  526881
  527845
  528814
  530194
  536989
  538062
  539375
  544423
  549490
  551645
  555088
  555110
  557922
  561809
  573277
  574096
  577243
  577632
  585569
  590917
  592963
  593754
  594167
  596520
  600235
  615963
  621099
  624600
  628589
  638000
  645976
  653330
  714198
  714755
  716546
  717914
  718864
  725425
  725451
  728619
  731317
  732589
  741760
  742987
  747044
  752505
  753726
  761639
  763378
  764319
  766628
  767769
  777482
  777526
  777814
  779722
  779801
  780676
  780936
  784667
  787754
  789768
  791250
  798631
  805292
  809329
  809702
  810531
  813621
  813625
]
1.99 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "глота жен сперм"
]
1.99 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глота жен сперм"
]
1.84 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.