Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.55 ms
(84.77%)
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
  58701
  72822
  79355
  96665
  96946
  97763
  109313
  130045
  130089
  181397
  188337
  188621
  193342
  320078
  383000
  383501
  405074
  408613
  410272
  422672
  430526
  437470
  452263
  452813
  455886
  460171
  462751
  468340
  470493
  479071
  479074
  493088
  501377
  505625
  507284
  511254
  512509
  512561
  516375
  517847
  522157
  523868
  530372
  530373
  531259
  531824
  531836
  532839
  532966
  533064
  533773
  536305
  536359
  536538
  541849
  548454
  556029
  566503
  571213
  577435
  580107
  583460
  583500
  591174
  595761
  599847
  599861
  599964
  600249
  600289
  601584
  605337
  615915
  619407
  631162
  631902
  632184
  632641
  636308
  639759
  645236
  646849
  676088
  678053
  681661
  692806
  699757
  703533
  706232
  712891
  714122
  720795
  734469
  739606
  745326
  752611
  761530
  770840
  770909
  772796
  775024
  775054
  779560
  788169
  789961
  792184
  796285
  801536
  802488
  805598
  809471
  815955
  817059
  817113
  817176
  817334
  817377
  820171
  828872
]
14.12 ms
(9.03%)
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
  817377
  605337
  452263
  631902
  536305
  410272
  96665
  739606
  548454
  507284
  779560
  523868
  802488
  599964
  820171
  817113
  817176
  531824
  706232
  796285
  734469
  752611
  828872
  516375
  556029
  541849
  531294
  801536
  761530
  512509
  517847
  566503
  599861
  601584
  512561
  522157
  639759
  712891
  583500
  599847
  678053
  580107
  631162
  437470
  452813
  532839
  533773
  646849
  676088
  600249
  600289
  532966
  591174
  181397
  188337
  815955
  632641
  770840
  789961
  501377
  536538
  772796
  720795
  615915
  703533
  632184
  775024
  805598
  792184
  188621
  422672
  430526
  530372
  817059
  320078
  788169
  72822
  681661
  809471
  455886
  79355
  619407
  470493
  479074
  468340
  531836
  583460
  479071
  130045
  817334
  745326
  505625
  383000
  462751
  408613
  58701
  511254
  531259
  460171
  405074
  533064
  577435
  636308
  383501
  536359
  530373
  645236
  571213
  714122
  595761
  193342
  96946
  699757
  770909
  97763
  692806
  109313
  130089
  493088
  775054
]
2.81 ms
(1.80%)
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
  58701
  72822
  79355
  96665
  96946
  97763
  109313
  130045
  130089
  181397
  188337
  188621
  193342
  320078
  383000
  383501
  405074
  408613
  410272
  422672
  430526
  437470
  452263
  452813
  455886
  460171
  462751
  468340
  470493
  479071
  479074
  493088
  501377
  505625
  507284
  511254
  512509
  512561
  516375
  517847
  522157
  523868
  530372
  530373
  531259
  531824
  531836
  532839
  532966
  533064
  533773
  536305
  536359
  536538
  541849
  548454
  556029
  566503
  571213
  577435
  580107
  583460
  583500
  591174
  595761
  599847
  599861
  599964
  600249
  600289
  601584
  605337
  615915
  619407
  631162
  631902
  632184
  632641
  636308
  639759
  645236
  646849
  676088
  678053
  681661
  692806
  699757
  703533
  706232
  712891
  714122
  720795
  734469
  739606
  745326
  752611
  761530
  770840
  770909
  772796
  775024
  775054
  779560
  788169
  789961
  792184
  796285
  801536
  802488
  805598
  809471
  815955
  817059
  817113
  817176
  817334
  817377
  820171
  828872
]
1.90 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин double секс"
]
1.80 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин double секс"
]
1.65 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother double fuck"
]

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.