Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.65 ms
(84.33%)
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
  13011
  79388
  161358
  233298
  396570
  396594
  397988
  399089
  416044
  417081
  418897
  427033
  427759
  429823
  449573
  453194
  457295
  460194
  467049
  468476
  483497
  483587
  484054
  486736
  495321
  495412
  499556
  499717
  506304
  509149
  515777
  516746
  519766
  529318
  530317
  535395
  540021
  545713
  554834
  557430
  558440
  560304
  561237
  562736
  563279
  566242
  583313
  584504
  589238
  595129
  597111
  604464
  604466
  606240
  606725
  606901
  608083
  611547
  620487
  626357
  628332
  629267
  630712
  636574
  641359
  641806
  643827
  644575
  644798
  645618
  648925
  650506
  651251
  654600
  678439
  687192
  691724
  696237
  703982
  704184
  711375
  714663
  715089
  715523
  715553
  717461
  717651
  719832
  719896
  720176
  720806
  729181
  731481
  732745
  733271
  733307
  733566
  735678
  737720
  746846
  747879
  757480
  762899
  765846
  768692
  775202
  799949
  801082
  802432
  803449
  804647
  805112
  807142
  807660
  807725
  812372
  813206
  813459
  817074
  826232
]
21.42 ms
(10.65%)
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
  557430
  560304
  696237
  703982
  714663
  563279
  629267
  630712
  606240
  813206
  747879
  757480
  711375
  233298
  641359
  719896
  417081
  453194
  457295
  483587
  519766
  704184
  562736
  595129
  589238
  799949
  804647
  732745
  620487
  495321
  483497
  717461
  604464
  427033
  13011
  737720
  418897
  499556
  644575
  803449
  397988
  687192
  717651
  733566
  654600
  416044
  651251
  807725
  161358
  817074
  826232
  484054
  449573
  486736
  530317
  535395
  554834
  561237
  720806
  626357
  801082
  807660
  746846
  608083
  429823
  467049
  495412
  529318
  516746
  545713
  645618
  678439
  715089
  715523
  648925
  650506
  719832
  583313
  604466
  636574
  644798
  812372
  729181
  733307
  731481
  515777
  506304
  499717
  606901
  509149
  396594
  79388
  733271
  802432
  606725
  641806
  720176
  460194
  805112
  715553
  396570
  558440
  628332
  468476
  691724
  399089
  611547
  427759
  540021
  566242
  584504
  643827
  597111
  775202
  807142
  762899
  813459
  735678
  765846
  768692
]
2.91 ms
(1.45%)
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
  13011
  79388
  161358
  233298
  396570
  396594
  397988
  399089
  416044
  417081
  418897
  427033
  427759
  429823
  449573
  453194
  457295
  460194
  467049
  468476
  483497
  483587
  484054
  486736
  495321
  495412
  499556
  499717
  506304
  509149
  515777
  516746
  519766
  529318
  530317
  535395
  540021
  545713
  554834
  557430
  558440
  560304
  561237
  562736
  563279
  566242
  583313
  584504
  589238
  595129
  597111
  604464
  604466
  606240
  606725
  606901
  608083
  611547
  620487
  626357
  628332
  629267
  630712
  636574
  641359
  641806
  643827
  644575
  644798
  645618
  648925
  650506
  651251
  654600
  678439
  687192
  691724
  696237
  703982
  704184
  711375
  714663
  715089
  715523
  715553
  717461
  717651
  719832
  719896
  720176
  720806
  729181
  731481
  732745
  733271
  733307
  733566
  735678
  737720
  746846
  747879
  757480
  762899
  765846
  768692
  775202
  799949
  801082
  802432
  803449
  804647
  805112
  807142
  807660
  807725
  812372
  813206
  813459
  817074
  826232
]
2.11 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife black cock"
]
2.06 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен black cock"
]
1.54 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен black cock"
]

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.