Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.06 ms
(56.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"зрелые жены влагалищÐ…"
]
136.47 ms
(36.41%)
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
  70852
  78307
  81022
  111260
  157194
  382810
  384457
  389842
  398527
  409934
  410683
  411738
  415287
  418054
  440399
  442775
  444073
  446386
  452659
  457912
  457993
  457998
  466883
  468497
  470639
  470722
  470768
  471696
  472675
  474784
  475769
  476164
  477881
  478215
  481259
  484681
  485418
  486214
  490598
  492333
  493486
  493587
  493740
  501258
  503836
  504025
  509192
  513480
  513624
  513632
  517272
  517816
  518762
  518949
  519361
  526887
  531546
  534683
  535454
  536170
  544120
  549033
  549243
  549568
  550575
  554235
  554997
  555017
  555028
  555042
  555063
  555119
  557577
  561097
  561526
  563246
  563939
  566777
  571399
  571843
  573742
  585296
  588155
  593605
  606185
  615516
  662087
  680312
  692701
  714613
  714620
  718524
  724252
  726003
  727789
  727857
  730347
  733085
  733265
  737015
  738359
  748812
  756551
  756666
  758355
  761018
  761323
  761696
  762301
  767203
  775202
  780659
  785876
  788856
  797206
  797392
  815835
  817733
  824035
  824364
]
18.47 ms
(4.93%)
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
  485418
  492333
  554997
  472675
  475769
  517272
  756666
  470722
  503836
  509192
  452659
  493587
  554235
  571843
  549568
  157194
  457998
  444073
  478215
  535454
  486214
  518949
  534683
  517816
  457993
  555028
  714613
  733265
  718524
  484681
  549243
  824035
  824364
  457912
  526887
  566777
  550575
  481259
  513632
  70852
  384457
  446386
  561526
  501258
  398527
  470639
  797206
  442775
  733085
  573742
  470768
  724252
  513480
  111260
  440399
  466883
  714620
  785876
  761323
  727789
  410683
  468497
  389842
  78307
  555063
  561097
  81022
  536170
  531546
  692701
  738359
  588155
  680312
  767203
  762301
  571399
  415287
  815835
  817733
  471696
  493740
  518762
  504025
  493486
  555042
  662087
  549033
  606185
  585296
  593605
  775202
  727857
  761696
  788856
  761018
  748812
  756551
  758355
  726003
  730347
  737015
  615516
  780659
  797392
  513624
  519361
  474784
  411738
  409934
  418054
  476164
  563939
  555119
  477881
  382810
  563246
  544120
  490598
  555017
  557577
]
4.28 ms
(1.14%)
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
  70852
  78307
  81022
  111260
  157194
  382810
  384457
  389842
  398527
  409934
  410683
  411738
  415287
  418054
  440399
  442775
  444073
  446386
  452659
  457912
  457993
  457998
  466883
  468497
  470639
  470722
  470768
  471696
  472675
  474784
  475769
  476164
  477881
  478215
  481259
  484681
  485418
  486214
  490598
  492333
  493486
  493587
  493740
  501258
  503836
  504025
  509192
  513480
  513624
  513632
  517272
  517816
  518762
  518949
  519361
  526887
  531546
  534683
  535454
  536170
  544120
  549033
  549243
  549568
  550575
  554235
  554997
  555017
  555028
  555042
  555063
  555119
  557577
  561097
  561526
  563246
  563939
  566777
  571399
  571843
  573742
  585296
  588155
  593605
  606185
  615516
  662087
  680312
  692701
  714613
  714620
  718524
  724252
  726003
  727789
  727857
  730347
  733085
  733265
  737015
  738359
  748812
  756551
  756666
  758355
  761018
  761323
  761696
  762301
  767203
  775202
  780659
  785876
  788856
  797206
  797392
  815835
  817733
  824035
  824364
]
1.60 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин жен вагин"
]
1.51 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.38%)
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.