Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.00 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
  383597
  386719
  390908
  394240
  404053
  407552
  418922
  421360
  422252
  424697
  427378
  433748
  437727
  438533
  447357
  453513
  466540
  471347
  487514
  491215
  496559
  498867
  499476
  501732
  501784
  504681
  507171
  509675
  515879
  518091
  521888
  527793
  538359
  540213
  548720
  551283
  551335
  551359
  552463
  557509
  568129
  570459
  571293
  572014
  573776
  576014
  576285
  578843
  588268
  590813
  596618
  601630
  610183
  615004
  619913
  622329
  624734
  628677
  629017
  636270
  636520
  636794
  640055
  643411
  646246
  651885
  651924
  653238
  653260
  654315
  655418
  661759
  663014
  672534
  673093
  676518
  676927
  677029
  679706
  691458
  695051
  699505
  701873
  706668
  720985
  721408
  721447
  722799
  722875
  722901
  723013
  725375
  727728
  728171
  729134
  730686
  735410
  741083
  753216
  756227
  758033
  759782
  760361
  760919
  765261
  770438
  773188
  778135
  789169
  789753
  789916
  798197
  802512
  802825
  809802
  812078
  815622
  816492
  818151
  823530
]
17.79 ms
(9.73%)
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
  471347
  501732
  815622
  551359
  773188
  789916
  568129
  548720
  590813
  487514
  601630
  447357
  491215
  538359
  499476
  557509
  651885
  651924
  677029
  720985
  673093
  676927
  721408
  721447
  576014
  727728
  427378
  422252
  504681
  741083
  654315
  418922
  722875
  759782
  515879
  437727
  573776
  578843
  661759
  655418
  663014
  676518
  636520
  798197
  789169
  753216
  760361
  778135
  636270
  496559
  615004
  729134
  653238
  572014
  570459
  622329
  507171
  390908
  629017
  551283
  588268
  596618
  421360
  438533
  610183
  756227
  453513
  433748
  394240
  501784
  509675
  521888
  816492
  818151
  823530
  498867
  653260
  679706
  699505
  706668
  802825
  725375
  812078
  730686
  770438
  701873
  723013
  802512
  809802
  466540
  551335
  646246
  576285
  383597
  424697
  640055
  552463
  407552
  527793
  619913
  624734
  404053
  540213
  691458
  695051
  722901
  672534
  571293
  628677
  636794
  789753
  735410
  728171
  758033
  760919
  765261
  722799
  386719
  643411
  518091
]
2.82 ms
(1.54%)
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
  383597
  386719
  390908
  394240
  404053
  407552
  418922
  421360
  422252
  424697
  427378
  433748
  437727
  438533
  447357
  453513
  466540
  471347
  487514
  491215
  496559
  498867
  499476
  501732
  501784
  504681
  507171
  509675
  515879
  518091
  521888
  527793
  538359
  540213
  548720
  551283
  551335
  551359
  552463
  557509
  568129
  570459
  571293
  572014
  573776
  576014
  576285
  578843
  588268
  590813
  596618
  601630
  610183
  615004
  619913
  622329
  624734
  628677
  629017
  636270
  636520
  636794
  640055
  643411
  646246
  651885
  651924
  653238
  653260
  654315
  655418
  661759
  663014
  672534
  673093
  676518
  676927
  677029
  679706
  691458
  695051
  699505
  701873
  706668
  720985
  721408
  721447
  722799
  722875
  722901
  723013
  725375
  727728
  728171
  729134
  730686
  735410
  741083
  753216
  756227
  758033
  759782
  760361
  760919
  765261
  770438
  773188
  778135
  789169
  789753
  789916
  798197
  802512
  802825
  809802
  812078
  815622
  816492
  818151
  823530
]
2.15 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small tits massage"
]
1.66 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ массаж"
]
1.48 ms
(0.81%)
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.