Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.35 ms
(84.98%)
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
  10065
  14392
  33686
  95873
  96205
  96665
  151564
  154374
  161528
  187223
  187851
  192888
  193662
  205715
  341546
  381924
  382437
  383202
  383237
  383751
  384142
  386658
  386913
  388712
  388912
  393004
  395733
  397303
  398552
  399162
  399688
  400150
  400169
  401673
  403312
  408437
  408767
  409364
  409367
  411726
  420227
  427202
  444106
  448703
  454228
  487513
  489443
  500795
  509228
  531070
  533345
  536305
  549307
  563540
  566558
  568192
  577112
  590904
  599993
  606496
  610007
  623912
  628347
  638565
  641303
  644301
  644306
  649199
  649902
  650643
  653584
  666796
  670487
  671734
  671759
  675208
  676427
  681682
  683228
  686615
  693990
  714864
  714883
  717034
  717607
  720003
  721187
  721716
  731851
  732377
  738619
  747145
  752596
  770129
  770196
  770819
  770840
  784850
  788783
  789647
  789961
  791571
  794557
  794826
  798797
  800947
  801944
  802115
  802128
  803273
  805565
  805690
  805819
  809421
  815124
  816755
  817171
  817341
  818309
  823720
]
14.15 ms
(9.01%)
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
  383237
  817341
  770840
  789961
  398552
  670487
  653584
  794826
  489443
  427202
  671759
  801944
  487513
  732377
  784850
  381924
  681682
  205715
  500795
  721187
  809421
  644306
  789647
  383751
  393004
  341546
  193662
  675208
  161528
  536305
  533345
  577112
  397303
  714864
  720003
  644301
  770196
  717034
  408437
  399688
  386658
  384142
  566558
  401673
  448703
  187851
  747145
  409367
  818309
  671734
  628347
  800947
  408767
  411726
  399162
  610007
  563540
  187223
  714883
  693990
  770129
  192888
  382437
  403312
  395733
  420227
  454228
  549307
  650643
  676427
  599993
  794557
  683228
  721716
  33686
  400169
  531070
  798797
  151564
  509228
  803273
  10065
  14392
  816755
  444106
  638565
  805565
  96205
  400150
  666796
  606496
  590904
  802115
  752596
  96665
  95873
  154374
  388912
  386913
  823720
  649199
  805690
  731851
  791571
  815124
  649902
  568192
  738619
  802128
  817171
  686615
  717607
  641303
  788783
  383202
  409364
  770819
  805819
  388712
  623912
]
2.70 ms
(1.72%)
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
  10065
  14392
  33686
  95873
  96205
  96665
  151564
  154374
  161528
  187223
  187851
  192888
  193662
  205715
  341546
  381924
  382437
  383202
  383237
  383751
  384142
  386658
  386913
  388712
  388912
  393004
  395733
  397303
  398552
  399162
  399688
  400150
  400169
  401673
  403312
  408437
  408767
  409364
  409367
  411726
  420227
  427202
  444106
  448703
  454228
  487513
  489443
  500795
  509228
  531070
  533345
  536305
  549307
  563540
  566558
  568192
  577112
  590904
  599993
  606496
  610007
  623912
  628347
  638565
  641303
  644301
  644306
  649199
  649902
  650643
  653584
  666796
  670487
  671734
  671759
  675208
  676427
  681682
  683228
  686615
  693990
  714864
  714883
  717034
  717607
  720003
  721187
  721716
  731851
  732377
  738619
  747145
  752596
  770129
  770196
  770819
  770840
  784850
  788783
  789647
  789961
  791571
  794557
  794826
  798797
  800947
  801944
  802115
  802128
  803273
  805565
  805690
  805819
  809421
  815124
  816755
  817171
  817341
  818309
  823720
]
2.00 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщины втроем"
]
1.79 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин секс втро"
]
1.49 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женщин секс втро"
]
1.45 ms
(0.93%)
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.