Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.67 ms
(86.34%)
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
  9974
  187349
  188453
  188669
  346150
  370715
  382284
  383722
  385408
  388792
  390165
  391917
  397305
  397853
  397923
  420505
  430602
  433434
  439530
  444145
  451121
  463852
  465708
  466954
  469483
  469556
  471764
  472365
  474855
  485267
  496935
  501529
  506334
  509808
  510413
  513846
  516474
  518839
  519088
  520943
  523023
  523196
  524114
  526733
  528157
  529250
  532817
  536212
  541230
  542202
  542787
  544468
  547936
  549650
  550354
  558287
  559142
  559216
  559346
  563198
  563414
  569398
  571028
  573763
  576669
  578300
  580608
  581013
  581231
  583496
  583732
  587266
  589681
  590288
  590370
  592489
  596891
  598113
  604403
  604456
  604923
  607630
  620150
  624803
  663281
  664841
  667314
  668639
  670274
  670676
  673124
  681857
  689715
  690783
  720925
  721712
  727996
  729091
  737404
  737561
  744277
  744369
  748529
  749255
  757276
  757445
  765657
  767247
  774881
  776404
  796644
  803543
  803775
  804146
  805808
  806391
  812981
  815104
  816785
  827269
]
13.69 ms
(7.59%)
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
  757276
  803543
  744277
  765657
  542787
  466954
  607630
  472365
  385408
  397853
  528157
  474855
  558287
  549650
  496935
  510413
  390165
  581013
  188453
  420505
  578300
  370715
  592489
  604923
  524114
  523023
  526733
  516474
  559216
  596891
  624803
  720925
  620150
  529250
  563414
  433434
  583496
  804146
  776404
  729091
  744369
  583732
  664841
  544468
  573763
  187349
  383722
  430602
  589681
  346150
  668639
  542202
  451121
  471764
  547936
  388792
  550354
  812981
  188669
  563198
  532817
  519088
  581231
  571028
  559142
  518839
  9974
  587266
  774881
  523196
  469556
  559346
  670274
  598113
  520943
  509808
  439530
  485267
  501529
  681857
  590288
  397923
  727996
  816785
  469483
  541230
  690783
  569398
  444145
  391917
  382284
  397305
  506334
  513846
  827269
  673124
  689715
  721712
  667314
  580608
  803775
  737404
  805808
  806391
  576669
  670676
  465708
  604456
  663281
  815104
  463852
  536212
  590370
  604403
  737561
  796644
  767247
  748529
  757445
  749255
]
3.34 ms
(1.85%)
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
  9974
  187349
  188453
  188669
  346150
  370715
  382284
  383722
  385408
  388792
  390165
  391917
  397305
  397853
  397923
  420505
  430602
  433434
  439530
  444145
  451121
  463852
  465708
  466954
  469483
  469556
  471764
  472365
  474855
  485267
  496935
  501529
  506334
  509808
  510413
  513846
  516474
  518839
  519088
  520943
  523023
  523196
  524114
  526733
  528157
  529250
  532817
  536212
  541230
  542202
  542787
  544468
  547936
  549650
  550354
  558287
  559142
  559216
  559346
  563198
  563414
  569398
  571028
  573763
  576669
  578300
  580608
  581013
  581231
  583496
  583732
  587266
  589681
  590288
  590370
  592489
  596891
  598113
  604403
  604456
  604923
  607630
  620150
  624803
  663281
  664841
  667314
  668639
  670274
  670676
  673124
  681857
  689715
  690783
  720925
  721712
  727996
  729091
  737404
  737561
  744277
  744369
  748529
  749255
  757276
  757445
  765657
  767247
  774881
  776404
  796644
  803543
  803775
  804146
  805808
  806391
  812981
  815104
  816785
  827269
]
2.32 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелая чулки наездниц…"
]
1.88 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин чулк нижн бел наездниц поз"
]
1.55 ms
(0.86%)
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.