Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.33 ms
(53.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam anal gape"
]
159.02 ms
(40.61%)
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
  365056
  397478
  403896
  413398
  414099
  415977
  416652
  416677
  416692
  416737
  419819
  423663
  424581
  425431
  426259
  428178
  428255
  431381
  436132
  440414
  441093
  443086
  445103
  445401
  446797
  449406
  451221
  452889
  453213
  456219
  457380
  459306
  459375
  461870
  464228
  465320
  468338
  468949
  469759
  473368
  477418
  477537
  479542
  481861
  482293
  483735
  486775
  487416
  487425
  493254
  493840
  494495
  500789
  509824
  513992
  517509
  519699
  520419
  520790
  530402
  531862
  531877
  532634
  532778
  534535
  534551
  534566
  537138
  541274
  542142
  542306
  542701
  545434
  546129
  548854
  550899
  554083
  558912
  564518
  568770
  570972
  576548
  579582
  585296
  591805
  592576
  598272
  612060
  614967
  619996
  634114
  637203
  656186
  656935
  686119
  695387
  695912
  702402
  713386
  720216
  726986
  735026
  742338
  765266
  766835
  769890
  775228
  777533
  778731
  786048
  787504
  787510
  793749
  794866
  796164
  800502
  804319
  805227
  816094
]
13.87 ms
(3.54%)
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
  765266
  468338
  416677
  558912
  576548
  481861
  542701
  778731
  483735
  416652
  695912
  686119
  794866
  735026
  720216
  426259
  446797
  509824
  436132
  579582
  726986
  445103
  403896
  416692
  816094
  464228
  456219
  500789
  534566
  473368
  541274
  656935
  459375
  445401
  419819
  486775
  520419
  532778
  443086
  425431
  365056
  469759
  519699
  431381
  534535
  570972
  656186
  713386
  546129
  637203
  585296
  592576
  612060
  796164
  742338
  777533
  397478
  487416
  416737
  441093
  428255
  477418
  465320
  477537
  424581
  423663
  459306
  461870
  449406
  493840
  468949
  513992
  413398
  482293
  428178
  451221
  452889
  453213
  479542
  493254
  440414
  414099
  415977
  457380
  520790
  494495
  517509
  531877
  532634
  534551
  531862
  530402
  537138
  487425
  548854
  564518
  542142
  542306
  550899
  554083
  568770
  695387
  702402
  545434
  619996
  634114
  591805
  614967
  598272
  775228
  793749
  804319
  782849
  786048
  787510
  800502
  787504
  805227
  766835
  769890
]
2.42 ms
(0.62%)
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
  365056
  397478
  403896
  413398
  414099
  415977
  416652
  416677
  416692
  416737
  419819
  423663
  424581
  425431
  426259
  428178
  428255
  431381
  436132
  440414
  441093
  443086
  445103
  445401
  446797
  449406
  451221
  452889
  453213
  456219
  457380
  459306
  459375
  461870
  464228
  465320
  468338
  468949
  469759
  473368
  477418
  477537
  479542
  481861
  482293
  483735
  486775
  487416
  487425
  493254
  493840
  494495
  500789
  509824
  513992
  517509
  519699
  520419
  520790
  530402
  531862
  531877
  532634
  532778
  534535
  534551
  534566
  537138
  541274
  542142
  542306
  542701
  545434
  546129
  548854
  550899
  554083
  558912
  564518
  568770
  570972
  576548
  579582
  585296
  591805
  592576
  598272
  612060
  614967
  619996
  634114
  637203
  656186
  656935
  686119
  695387
  695912
  702402
  713386
  720216
  726986
  735026
  742338
  765266
  766835
  769890
  775228
  777533
  778731
  786048
  787504
  787510
  793749
  794866
  796164
  800502
  804319
  805227
  816094
]
1.88 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер анал большая большие дырк"
]
1.37 ms
(0.35%)
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.