Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.52 ms
(49.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг жен"
]
195.69 ms
(46.04%)
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
  117596
  117806
  389775
  396119
  410239
  415029
  415988
  419557
  422324
  429961
  434527
  440739
  441057
  441073
  441101
  441107
  441834
  441925
  443152
  444079
  448791
  459201
  460070
  471671
  474891
  481169
  481903
  481905
  487429
  493744
  501098
  502457
  506516
  506839
  508909
  512065
  512078
  514234
  514261
  515965
  517724
  518561
  519312
  519697
  519698
  524804
  529897
  530310
  531869
  534552
  534578
  536375
  536463
  547465
  547484
  547501
  559298
  559368
  559787
  568257
  568268
  573193
  575369
  576438
  576916
  577005
  580207
  580786
  581781
  586844
  590289
  592926
  595483
  602283
  604080
  619108
  619996
  628485
  639381
  643187
  644018
  648224
  651963
  656886
  656895
  661036
  666988
  668677
  669012
  669062
  670360
  671002
  672942
  672952
  684706
  685061
  689074
  705466
  709559
  713185
  729800
  735124
  742304
  750300
  752598
  757400
  757883
  788181
  788580
  790136
  791501
  792736
  796837
  800930
  801625
  801628
  805227
  805642
  817671
]
12.60 ms
(2.97%)
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
  481903
  524804
  515965
  481905
  575369
  666988
  671002
  651963
  656895
  668677
  705466
  602283
  729800
  790136
  792736
  800930
  801628
  757400
  801625
  805642
  440739
  481169
  518561
  512078
  519312
  530310
  396119
  441107
  441834
  422324
  434527
  441073
  419557
  429961
  441057
  443152
  559368
  487429
  460070
  471671
  459201
  493744
  514261
  536375
  536463
  529897
  534552
  534578
  514234
  531869
  547465
  547484
  547501
  568257
  577005
  580786
  568268
  573193
  576438
  580207
  648224
  656886
  669062
  684706
  685061
  713185
  670360
  672952
  672942
  559298
  586844
  619996
  644018
  628485
  592926
  619108
  782849
  788580
  791501
  750300
  805227
  757883
  742304
  752598
  415029
  474891
  441101
  441925
  415988
  444079
  512065
  788181
  117596
  389775
  817671
  661036
  709559
  639381
  643187
  796837
  735124
  117806
  502457
  506516
  501098
  506839
  508909
  517724
  519697
  519698
  581781
  669012
  559787
  576916
  590289
  604080
  595483
  410239
  448791
  689074
]
2.70 ms
(0.64%)
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
  117596
  117806
  389775
  396119
  410239
  415029
  415988
  419557
  422324
  429961
  434527
  440739
  441057
  441073
  441101
  441107
  441834
  441925
  443152
  444079
  448791
  459201
  460070
  471671
  474891
  481169
  481903
  481905
  487429
  493744
  501098
  502457
  506516
  506839
  508909
  512065
  512078
  514234
  514261
  515965
  517724
  518561
  519312
  519697
  519698
  524804
  529897
  530310
  531869
  534552
  534578
  536375
  536463
  547465
  547484
  547501
  559298
  559368
  559787
  568257
  568268
  573193
  575369
  576438
  576916
  577005
  580207
  580786
  581781
  586844
  590289
  592926
  595483
  602283
  604080
  619108
  619996
  628485
  639381
  643187
  644018
  648224
  651963
  656886
  656895
  661036
  666988
  668677
  669012
  669062
  670360
  671002
  672942
  672952
  684706
  685061
  689074
  705466
  709559
  713185
  729800
  735124
  742304
  750300
  752598
  757400
  757883
  788181
  788580
  790136
  791501
  792736
  796837
  800930
  801625
  801628
  805227
  805642
  817671
]
1.77 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фистинг жен"
]
1.38 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting wife"
]
1.35 ms
(0.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.