Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.75 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.42 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy milf cock"
]
3 19.76 ms
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
  826172
  814117
  815692
  817344
  482564
  458832
  483592
  583454
  552582
  563790
  681059
  690092
  718806
  589031
  595619
  631692
  620496
  618129
  801375
  803677
  740347
  756499
  770633
  812862
  732406
  734397
  728908
  428844
  418161
  526717
  469484
  540512
  628622
  732169
  826114
  822385
  815933
  818464
  822575
  674116
  641322
  793410
  795059
  800144
  753338
  811045
  756513
  733374
  738571
  762194
  816929
  816741
  824125
  828089
  828333
  536200
  533335
  699316
  719748
  653883
  665258
  702620
  628295
  630314
  795894
  724008
  725209
  725656
  733086
  744830
  758499
  718659
  803323
  408410
  817837
  817217
  818423
  517181
  530445
  538162
  519711
  563015
  651314
  676389
  676549
  687555
  710575
  678977
  720318
  555559
  557101
  604822
  606671
  616505
  639061
  604913
  793616
  810420
  793670
  805735
  807389
  725301
  727007
  727571
  733120
  733155
  740024
  749658
  767928
  733565
  755991
  762192
  765895
  744331
  753729
  740875
  758765
  759982
  719176
  448671
]
4 2.50 ms
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
  408410
  418161
  428844
  448671
  458832
  469484
  482564
  483592
  517181
  519711
  526717
  530445
  533335
  536200
  538162
  540512
  552582
  555559
  557101
  563015
  563790
  583454
  589031
  595619
  604822
  604913
  606671
  616505
  618129
  620496
  628295
  628622
  630314
  631692
  639061
  641322
  651314
  653883
  665258
  674116
  676389
  676549
  678977
  681059
  687555
  690092
  699316
  702620
  710575
  718659
  718806
  719176
  719748
  720318
  724008
  725209
  725301
  725656
  727007
  727571
  728908
  732169
  732406
  733086
  733120
  733155
  733374
  733565
  734397
  738571
  740024
  740347
  740875
  744331
  744830
  749658
  753338
  753729
  755991
  756499
  756513
  758499
  758765
  759982
  762192
  762194
  765895
  767928
  770633
  793410
  793616
  793670
  795059
  795894
  800144
  801375
  803323
  803677
  805735
  807389
  810420
  811045
  812862
  814117
  815692
  815933
  816741
  816929
  817217
  817344
  817837
  818423
  818464
  822385
  822575
  824125
  826114
  826172
  828089
  828333
]
5 158.37 ms
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
  408410
  418161
  428844
  448671
  458832
  469484
  482564
  483592
  517181
  519711
  526717
  530445
  533335
  536200
  538162
  540512
  552582
  555559
  557101
  563015
  563790
  583454
  589031
  595619
  604822
  604913
  606671
  616505
  618129
  620496
  628295
  628622
  630314
  631692
  639061
  641322
  651314
  653883
  665258
  674116
  676389
  676549
  678977
  681059
  687555
  690092
  699316
  702620
  710575
  718659
  718806
  719176
  719748
  720318
  724008
  725209
  725301
  725656
  727007
  727571
  728908
  732169
  732406
  733086
  733120
  733155
  733374
  733565
  734397
  738571
  740024
  740347
  740875
  744331
  744830
  749658
  753338
  753729
  755991
  756499
  756513
  758499
  758765
  759982
  762192
  762194
  765895
  767928
  770633
  793410
  793616
  793670
  795059
  795894
  800144
  801375
  803323
  803677
  805735
  807389
  810420
  811045
  812862
  814117
  815692
  815933
  816741
  816929
  817217
  817344
  817837
  818423
  818464
  822385
  822575
  824125
  826114
  826172
  828089
  828333
]
6 1.77 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy milf cock"
]
7 1.62 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy milf 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.