Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.63 ms
(84.69%)
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
  282558
  384963
  419522
  419529
  422729
  426711
  428415
  429810
  443130
  443407
  443591
  443799
  443926
  447105
  447750
  457789
  466075
  466223
  469920
  473788
  474635
  475017
  475428
  476248
  476921
  478781
  479149
  481289
  484568
  485940
  501198
  505446
  506216
  510420
  510427
  510641
  515858
  516683
  518059
  521907
  521939
  522568
  526735
  533548
  540270
  541110
  548754
  551175
  552216
  555688
  557942
  557945
  567075
  570627
  574235
  575176
  576056
  576404
  598176
  598557
  598783
  603536
  604142
  611723
  616716
  620563
  622349
  628181
  640939
  651934
  651944
  652617
  653209
  654594
  654824
  654846
  659539
  661262
  676444
  676973
  678568
  678579
  678954
  679058
  679090
  696748
  712441
  717310
  720799
  720835
  721202
  721367
  722827
  722871
  723510
  726892
  730210
  740161
  741958
  742046
  744328
  745723
  747008
  751646
  759548
  785337
  785963
  790397
  792491
  800316
  807462
  809651
  812364
  814330
  818582
  821837
  821839
  821846
  821856
  825299
]
13.06 ms
(8.40%)
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
  792491
  552216
  814330
  723510
  818582
  551175
  659539
  676444
  679090
  678568
  721202
  611723
  730210
  742046
  721367
  384963
  640939
  722871
  522568
  443407
  678579
  679058
  654824
  720799
  720835
  598783
  622349
  628181
  598557
  785963
  741958
  751646
  759548
  696748
  557945
  510427
  555688
  604142
  469920
  474635
  481289
  821837
  506216
  652617
  654594
  651934
  717310
  651944
  653209
  570627
  620563
  807462
  809651
  740161
  745723
  521939
  510641
  676973
  515858
  521907
  501198
  541110
  447750
  476248
  282558
  443926
  825299
  576056
  484568
  557942
  479149
  485940
  598176
  821839
  678954
  744328
  747008
  800316
  443130
  447105
  540270
  790397
  428415
  429810
  478781
  510420
  518059
  526735
  575176
  576404
  548754
  567075
  476921
  574235
  603536
  812364
  785337
  722827
  475017
  426711
  516683
  419529
  466075
  443591
  419522
  443799
  466223
  475428
  505446
  661262
  616716
  457789
  821856
  821846
  533548
  654846
  712441
  726892
  422729
  473788
]
3.09 ms
(1.99%)
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
  282558
  384963
  419522
  419529
  422729
  426711
  428415
  429810
  443130
  443407
  443591
  443799
  443926
  447105
  447750
  457789
  466075
  466223
  469920
  473788
  474635
  475017
  475428
  476248
  476921
  478781
  479149
  481289
  484568
  485940
  501198
  505446
  506216
  510420
  510427
  510641
  515858
  516683
  518059
  521907
  521939
  522568
  526735
  533548
  540270
  541110
  548754
  551175
  552216
  555688
  557942
  557945
  567075
  570627
  574235
  575176
  576056
  576404
  598176
  598557
  598783
  603536
  604142
  611723
  616716
  620563
  622349
  628181
  640939
  651934
  651944
  652617
  653209
  654594
  654824
  654846
  659539
  661262
  676444
  676973
  678568
  678579
  678954
  679058
  679090
  696748
  712441
  717310
  720799
  720835
  721202
  721367
  722827
  722871
  723510
  726892
  730210
  740161
  741958
  742046
  744328
  745723
  747008
  751646
  759548
  785337
  785963
  790397
  792491
  800316
  807462
  809651
  812364
  814330
  818582
  821837
  821839
  821846
  821856
  825299
]
2.25 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русские молодые втрое…"
]
2.17 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск молодые секс втро"
]
1.64 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск молодые секс втро"
]
1.57 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.