Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.80 ms
(87.40%)
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
  67006
  233346
  384779
  391966
  391982
  392032
  393862
  398676
  398678
  398794
  398984
  400719
  401952
  411339
  413473
  421831
  422146
  425692
  426810
  426814
  426908
  426919
  427064
  427083
  435537
  435922
  438858
  443817
  443986
  446813
  448376
  458059
  460554
  460907
  461541
  462277
  464673
  465033
  467350
  470151
  473580
  475182
  476365
  480004
  480430
  480886
  481244
  482832
  483971
  485377
  487470
  490328
  491889
  493089
  495483
  496236
  500402
  501652
  501797
  502907
  504161
  506741
  510098
  510383
  511518
  511750
  512293
  512702
  513441
  513685
  521012
  522817
  524044
  524439
  524690
  524708
  524775
  525438
  534147
  538414
  540245
  543685
  543823
  547052
  548686
  552324
  552415
  552463
  552977
  560558
  564217
  568954
  570321
  571565
  571854
  572168
  573001
  575212
  576095
  576348
  586379
  588822
  590591
  595480
  596411
  596618
  597503
  597811
  623402
  659423
  659621
  673908
  675355
  676537
  720652
  736120
  743170
  754104
  755634
  802080
]
16.09 ms
(7.91%)
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
  736120
  460554
  511518
  401952
  570321
  564217
  623402
  427064
  464673
  398678
  510383
  524044
  506741
  588822
  427083
  513685
  501652
  524439
  543685
  597811
  568954
  552977
  480886
  480430
  534147
  438858
  501797
  465033
  500402
  426810
  524775
  548686
  596618
  461541
  525438
  411339
  398794
  590591
  475182
  512293
  538414
  502907
  676537
  426919
  435922
  483971
  540245
  413473
  510098
  495483
  512702
  513441
  521012
  482832
  675355
  392032
  597503
  422146
  421831
  524690
  576095
  552415
  586379
  426908
  573001
  575212
  426814
  448376
  487470
  571854
  743170
  755634
  233346
  560558
  571565
  572168
  493089
  552324
  596411
  443817
  659423
  595480
  67006
  659621
  802080
  443986
  384779
  398676
  490328
  393862
  473580
  543823
  754104
  460907
  480004
  458059
  511750
  470151
  425692
  446813
  476365
  485377
  576348
  391982
  462277
  467350
  481244
  522817
  496236
  491889
  524708
  400719
  673908
  391966
  504161
  398984
  435537
  552463
  547052
  720652
]
2.55 ms
(1.25%)
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
  67006
  233346
  384779
  391966
  391982
  392032
  393862
  398676
  398678
  398794
  398984
  400719
  401952
  411339
  413473
  421831
  422146
  425692
  426810
  426814
  426908
  426919
  427064
  427083
  435537
  435922
  438858
  443817
  443986
  446813
  448376
  458059
  460554
  460907
  461541
  462277
  464673
  465033
  467350
  470151
  473580
  475182
  476365
  480004
  480430
  480886
  481244
  482832
  483971
  485377
  487470
  490328
  491889
  493089
  495483
  496236
  500402
  501652
  501797
  502907
  504161
  506741
  510098
  510383
  511518
  511750
  512293
  512702
  513441
  513685
  521012
  522817
  524044
  524439
  524690
  524708
  524775
  525438
  534147
  538414
  540245
  543685
  543823
  547052
  548686
  552324
  552415
  552463
  552977
  560558
  564217
  568954
  570321
  571565
  571854
  572168
  573001
  575212
  576095
  576348
  586379
  588822
  590591
  595480
  596411
  596618
  597503
  597811
  623402
  659423
  659621
  673908
  675355
  676537
  720652
  736120
  743170
  754104
  755634
  802080
]
2.07 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian brunette минет"
]
1.76 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск черноволосая минет оральн секс"
]
1.71 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.72%)
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.