Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.77 ms
(87.30%)
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
  7665
  12731
  28591
  28717
  91891
  188621
  263788
  307339
  318343
  382058
  396866
  397382
  398614
  410855
  431537
  431744
  450652
  451798
  470194
  477360
  489616
  491367
  494261
  504042
  504170
  506548
  512535
  536979
  540957
  545585
  552928
  555688
  559029
  559644
  559711
  564157
  590631
  590867
  593759
  603549
  603627
  607620
  608038
  622005
  622154
  622155
  622613
  624225
  624510
  632028
  644303
  647980
  649146
  650842
  651003
  651888
  651889
  653165
  653619
  664855
  665876
  667656
  669408
  671004
  677957
  680657
  681271
  682423
  694143
  702058
  705663
  709295
  720834
  721072
  721568
  723582
  724111
  724440
  726252
  726799
  732784
  734422
  735078
  746082
  770799
  770874
  770885
  770891
  771282
  775931
  778061
  781414
  783412
  790971
  791571
  797936
  798083
  800259
  801944
  806038
  806300
  807191
  807512
  810668
  811236
  811931
  817445
  817658
  817692
  817912
  817914
  820523
  823873
  824804
  825122
  826865
  827370
  827516
  828257
  828647
]
13.27 ms
(7.30%)
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
  817658
  817914
  820523
  817692
  649146
  694143
  720834
  622154
  811236
  770891
  771282
  790971
  806300
  770799
  798083
  7665
  28591
  451798
  817445
  477360
  470194
  669408
  677957
  681271
  647980
  632028
  608038
  801944
  644303
  810668
  431744
  504170
  491367
  410855
  494261
  91891
  28717
  559029
  512535
  564157
  555688
  603627
  778061
  382058
  824804
  827516
  817912
  552928
  650842
  671004
  797936
  770874
  770885
  398614
  450652
  431537
  590867
  318343
  827370
  536979
  506548
  540957
  651888
  665876
  667656
  651889
  653619
  664855
  622005
  622155
  781414
  735078
  746082
  723582
  825122
  545585
  559644
  680657
  702058
  651003
  806038
  807512
  726799
  724111
  705663
  709295
  811931
  489616
  807191
  775931
  593759
  603549
  734422
  823873
  826865
  828257
  828647
  721568
  783412
  800259
  732784
  622613
  263788
  791571
  590631
  307339
  397382
  682423
  188621
  396866
  653165
  726252
  624225
  721072
  12731
  724440
  504042
  559711
  607620
  624510
]
2.83 ms
(1.55%)
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
  7665
  12731
  28591
  28717
  91891
  188621
  263788
  307339
  318343
  382058
  396866
  397382
  398614
  410855
  431537
  431744
  450652
  451798
  470194
  477360
  489616
  491367
  494261
  504042
  504170
  506548
  512535
  536979
  540957
  545585
  552928
  555688
  559029
  559644
  559711
  564157
  590631
  590867
  593759
  603549
  603627
  607620
  608038
  622005
  622154
  622155
  622613
  624225
  624510
  632028
  644303
  647980
  649146
  650842
  651003
  651888
  651889
  653165
  653619
  664855
  665876
  667656
  669408
  671004
  677957
  680657
  681271
  682423
  694143
  702058
  705663
  709295
  720834
  721072
  721568
  723582
  724111
  724440
  726252
  726799
  732784
  734422
  735078
  746082
  770799
  770874
  770885
  770891
  771282
  775931
  778061
  781414
  783412
  790971
  791571
  797936
  798083
  800259
  801944
  806038
  806300
  807191
  807512
  810668
  811236
  811931
  817445
  817658
  817692
  817912
  817914
  820523
  823873
  824804
  825122
  826865
  827370
  827516
  828257
  828647
]
2.08 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome blowjob"
]
2.05 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро минет оральн секс"
]
1.28 ms
(0.71%)
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.