Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.96 ms
(83.38%)
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
  4463
  31329
  205794
  388318
  389612
  391565
  397898
  397911
  398531
  409346
  411322
  411757
  411945
  424421
  432596
  432803
  433380
  439643
  443378
  446634
  454274
  454565
  455343
  455475
  457459
  462156
  466199
  466238
  466310
  466868
  469101
  470307
  470537
  470612
  473333
  473342
  476023
  476338
  477963
  479085
  479112
  480647
  481257
  481926
  482443
  483333
  483654
  484447
  490404
  490892
  491329
  502730
  502929
  509427
  518901
  535446
  542950
  543535
  546941
  547605
  547810
  547934
  555041
  555108
  555116
  555119
  555138
  558009
  558700
  560390
  561337
  563078
  563080
  563200
  563217
  563222
  564920
  571103
  573728
  589608
  590503
  590613
  600083
  601930
  614881
  618757
  620223
  695103
  705458
  705471
  712580
  714470
  714496
  718746
  722240
  733319
  733338
  739927
  741723
  741744
  741764
  741789
  742585
  744386
  745462
  765227
  778774
  781648
  781652
  781686
  781692
  781702
  781745
  782210
  786527
  794657
  801450
  802195
  803862
  817886
]
15.63 ms
(9.88%)
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
  781702
  741789
  803862
  739927
  742585
  722240
  781652
  781686
  781692
  781745
  802195
  388318
  547605
  466238
  620223
  817886
  542950
  695103
  714496
  718746
  705471
  600083
  614881
  601930
  786527
  794657
  744386
  745462
  765227
  705458
  778774
  782210
  801450
  397898
  446634
  31329
  466199
  454274
  424421
  457459
  535446
  502730
  490404
  466310
  484447
  462156
  714470
  477963
  479085
  490892
  411322
  470307
  4463
  712580
  733338
  781648
  439643
  411945
  482443
  466868
  473333
  473342
  560390
  563200
  543535
  546941
  547810
  555041
  563222
  564920
  589608
  397911
  432803
  454565
  455475
  469101
  476338
  480647
  389612
  409346
  411757
  470612
  476023
  481257
  391565
  398531
  205794
  432596
  443378
  470537
  481926
  483654
  509427
  479112
  741744
  741723
  558700
  555116
  555119
  561337
  590613
  733319
  741764
  455343
  483333
  491329
  502929
  518901
  618757
  547934
  563078
  563217
  571103
  573728
  555108
  555138
  558009
  563080
  590503
  433380
]
3.04 ms
(1.92%)
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
  4463
  31329
  205794
  388318
  389612
  391565
  397898
  397911
  398531
  409346
  411322
  411757
  411945
  424421
  432596
  432803
  433380
  439643
  443378
  446634
  454274
  454565
  455343
  455475
  457459
  462156
  466199
  466238
  466310
  466868
  469101
  470307
  470537
  470612
  473333
  473342
  476023
  476338
  477963
  479085
  479112
  480647
  481257
  481926
  482443
  483333
  483654
  484447
  490404
  490892
  491329
  502730
  502929
  509427
  518901
  535446
  542950
  543535
  546941
  547605
  547810
  547934
  555041
  555108
  555116
  555119
  555138
  558009
  558700
  560390
  561337
  563078
  563080
  563200
  563217
  563222
  564920
  571103
  573728
  589608
  590503
  590613
  600083
  601930
  614881
  618757
  620223
  695103
  705458
  705471
  712580
  714470
  714496
  718746
  722240
  733319
  733338
  739927
  741723
  741744
  741764
  741789
  742585
  744386
  745462
  765227
  778774
  781648
  781652
  781686
  781692
  781702
  781745
  782210
  786527
  794657
  801450
  802195
  803862
  817886
]
2.05 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐÇÐâÐüÐüð║ð©ðÁ ðÀÐÇðÁð╗ÐïðÁ ð╝ð░ÐéÐÄÐÇÐ%ÔǪ"
]
1.86 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск зрелая женщин зрелая женщин"
]
1.75 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.