Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.61 ms
(79.74%)
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
  6997
  382242
  382254
  382959
  383205
  416931
  424679
  441110
  441838
  454113
  456333
  456818
  460209
  462381
  463757
  468827
  474413
  478151
  479082
  481920
  490267
  491463
  495067
  498730
  499359
  500375
  505748
  505888
  507793
  510172
  511554
  511916
  512867
  513265
  514088
  515391
  521222
  522343
  523183
  523189
  530570
  531114
  531533
  531884
  532632
  533183
  533584
  534221
  536684
  541206
  543855
  545480
  554859
  559569
  563473
  566777
  568525
  568561
  579547
  579614
  585322
  585476
  593003
  598859
  599814
  603269
  621337
  635050
  640531
  667772
  714228
  716736
  720286
  721454
  729907
  729917
  731776
  731802
  735028
  744904
  745007
  754462
  755076
  765376
  765752
  772694
  773391
  773877
  781646
  781663
  781714
  781731
  781741
  782148
  782230
  782252
  785932
  789407
  790903
  792584
  799160
  801214
  804237
  810045
  815031
  816371
  817113
  817284
  817721
  818812
  819720
  820229
  820284
  822045
  824457
  825015
  825110
  825762
  826973
  827327
]
24.64 ms
(14.28%)
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
  790903
  729907
  755076
  754462
  773877
  799160
  801214
  521222
  441838
  817284
  815031
  495067
  510172
  579547
  481920
  515391
  536684
  523189
  531114
  543855
  640531
  818812
  820229
  534221
  721454
  731776
  782148
  499359
  781731
  598859
  579614
  603269
  505888
  511554
  512867
  491463
  6997
  825015
  532632
  716736
  720286
  714228
  804237
  782230
  810045
  792584
  463757
  523183
  462381
  479082
  498730
  522343
  454113
  568525
  635050
  505748
  513265
  514088
  541206
  785932
  824457
  820284
  817721
  531884
  554859
  566777
  667772
  781714
  789407
  735028
  819720
  825110
  826973
  827327
  817113
  822045
  474413
  507793
  533183
  530570
  585322
  599814
  729917
  772694
  731802
  765376
  773391
  382254
  563473
  559569
  511916
  500375
  533584
  382959
  621337
  781741
  383205
  416931
  490267
  531533
  781663
  744904
  745007
  781646
  782252
  545480
  441110
  424679
  816371
  825762
  456818
  460209
  478151
  568561
  593003
  585476
  765752
  468827
  456333
  382242
]
2.60 ms
(1.51%)
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
  6997
  382242
  382254
  382959
  383205
  416931
  424679
  441110
  441838
  454113
  456333
  456818
  460209
  462381
  463757
  468827
  474413
  478151
  479082
  481920
  490267
  491463
  495067
  498730
  499359
  500375
  505748
  505888
  507793
  510172
  511554
  511916
  512867
  513265
  514088
  515391
  521222
  522343
  523183
  523189
  530570
  531114
  531533
  531884
  532632
  533183
  533584
  534221
  536684
  541206
  543855
  545480
  554859
  559569
  563473
  566777
  568525
  568561
  579547
  579614
  585322
  585476
  593003
  598859
  599814
  603269
  621337
  635050
  640531
  667772
  714228
  716736
  720286
  721454
  729907
  729917
  731776
  731802
  735028
  744904
  745007
  754462
  755076
  765376
  765752
  772694
  773391
  773877
  781646
  781663
  781714
  781731
  781741
  782148
  782230
  782252
  785932
  789407
  790903
  792584
  799160
  801214
  804237
  810045
  815031
  816371
  817113
  817284
  817721
  818812
  819720
  820229
  820284
  822045
  824457
  825015
  825110
  825762
  826973
  827327
]
2.24 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bdsm bondage mature"
]
2.02 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм бдсм mature"
]
1.82 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм бдсм mature"
]

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.