Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
244.75 ms
(90.26%)
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
  193666
  314128
  384413
  385309
  388160
  388266
  389264
  390040
  390813
  391037
  395564
  395596
  395970
  397863
  397881
  400181
  400191
  400254
  400865
  401203
  401235
  401640
  402131
  402262
  404720
  404904
  405525
  405535
  405537
  405977
  406232
  407154
  407662
  411321
  413185
  415893
  419517
  419539
  420438
  424457
  424470
  426412
  427199
  431133
  443147
  443407
  443839
  443953
  446024
  447132
  448644
  449883
  451520
  452132
  453253
  454558
  457000
  460751
  461805
  462477
  463842
  464334
  464649
  465352
  465457
  465840
  466011
  466198
  466930
  467402
  469321
  469377
  470416
  471895
  474025
  474076
  474495
  474975
  476271
  477867
  481332
  483103
  484379
  484392
  484409
  484596
  484659
  484768
  485098
  488373
  490915
  490935
  491411
  491989
  495396
  496028
  503557
  506050
  507681
  508669
  508746
  510750
  525459
  525997
  526270
  527015
  528401
  529801
  535010
  535369
  550219
  566606
  573729
  595769
  596054
  607293
  607618
  646033
  790799
  814921
]
16.99 ms
(6.27%)
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
  484768
  491989
  484379
  485098
  488373
  535369
  607293
  462477
  466011
  465840
  528401
  193666
  395564
  314128
  390040
  391037
  388160
  397863
  397881
  401203
  402262
  406232
  405525
  405977
  404904
  404720
  427199
  443147
  415893
  420438
  814921
  466930
  469321
  474025
  483103
  446024
  449883
  452132
  464334
  469377
  474975
  464649
  471895
  481332
  503557
  495396
  527015
  529801
  491411
  566606
  550219
  573729
  646033
  595769
  790799
  607618
  400191
  400865
  402131
  407662
  413185
  419539
  443953
  453253
  457000
  384413
  385309
  388266
  395596
  401235
  411321
  424457
  443839
  460751
  467402
  476271
  400181
  401640
  424470
  474076
  474495
  389264
  419517
  426412
  431133
  443407
  451520
  454558
  461805
  465352
  465457
  470416
  405535
  405537
  407154
  466198
  510750
  484409
  490915
  496028
  506050
  508746
  525997
  484596
  490935
  525459
  526270
  535010
  484392
  484659
  508669
  463842
  596054
  477867
  507681
  447132
  448644
  395970
  390813
  400254
]
2.60 ms
(0.96%)
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
  193666
  314128
  384413
  385309
  388160
  388266
  389264
  390040
  390813
  391037
  395564
  395596
  395970
  397863
  397881
  400181
  400191
  400254
  400865
  401203
  401235
  401640
  402131
  402262
  404720
  404904
  405525
  405535
  405537
  405977
  406232
  407154
  407662
  411321
  413185
  415893
  419517
  419539
  420438
  424457
  424470
  426412
  427199
  431133
  443147
  443407
  443839
  443953
  446024
  447132
  448644
  449883
  451520
  452132
  453253
  454558
  457000
  460751
  461805
  462477
  463842
  464334
  464649
  465352
  465457
  465840
  466011
  466198
  466930
  467402
  469321
  469377
  470416
  471895
  474025
  474076
  474495
  474975
  476271
  477867
  481332
  483103
  484379
  484392
  484409
  484596
  484659
  484768
  485098
  488373
  490915
  490935
  491411
  491989
  495396
  496028
  503557
  506050
  507681
  508669
  508746
  510750
  525459
  525997
  526270
  527015
  528401
  529801
  535010
  535369
  550219
  566606
  573729
  595769
  596054
  607293
  607618
  646033
  790799
  814921
]
1.82 ms
(0.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old беловолосая milf"
]
1.76 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old blonde milf"
]
1.41 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old беловолосая milf"
]

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.