Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.56 ms
(81.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
  97045
  161823
  373884
  382825
  386684
  394542
  395597
  398230
  399094
  399604
  401971
  404765
  408974
  411353
  415299
  417441
  417926
  418943
  419765
  420441
  422491
  423670
  428892
  430484
  436481
  437789
  437961
  439194
  443203
  446041
  447533
  449592
  450803
  451232
  452135
  453903
  454599
  457688
  458179
  458348
  459097
  460225
  460424
  460680
  464165
  464610
  465185
  465838
  468022
  470067
  471517
  471592
  472309
  472626
  474178
  474369
  478319
  480954
  481727
  482812
  483014
  485105
  486955
  489634
  490284
  493349
  493460
  493898
  494365
  494670
  496013
  497250
  498924
  499149
  499324
  500888
  501649
  502566
  502896
  505378
  506090
  507199
  509630
  510121
  511913
  519115
  520599
  522083
  523689
  524845
  525833
  525872
  527324
  543833
  548908
  558606
  558770
  560179
  565722
  571500
  573470
  576062
  578123
  578343
  582051
  582521
  592342
  597583
  602009
  602848
  603166
  603253
  605455
  624886
  631466
  679244
  719806
  731884
  791933
]
17.46 ms
(11.49%)
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
  719806
  560179
  453903
  511913
  574070
  497250
  506090
  382825
  373884
  395597
  398230
  399604
  418943
  417441
  499324
  460680
  631466
  386684
  436481
  451232
  458179
  470067
  471517
  417926
  430484
  478319
  510121
  501649
  573470
  605455
  791933
  731884
  401971
  525833
  411353
  437961
  486955
  449592
  498924
  494365
  494670
  558606
  582521
  571500
  548908
  565722
  582051
  679244
  602009
  624886
  602848
  443203
  457688
  480954
  423670
  459097
  437789
  464610
  474178
  481727
  420441
  493349
  499149
  500888
  502896
  505378
  525872
  489634
  490284
  496013
  507199
  509630
  519115
  483014
  493460
  522083
  465838
  460424
  603166
  603253
  408974
  471592
  527324
  502566
  404765
  454599
  474369
  558770
  576062
  592342
  465185
  428892
  520599
  161823
  394542
  415299
  419765
  482812
  452135
  460225
  543833
  578123
  597583
  450803
  485105
  524845
  464165
  472626
  468022
  493898
  439194
  422491
  472309
  399094
  523689
  97045
  458348
  578343
  447533
  446041
]
2.59 ms
(1.70%)
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
  97045
  161823
  373884
  382825
  386684
  394542
  395597
  398230
  399094
  399604
  401971
  404765
  408974
  411353
  415299
  417441
  417926
  418943
  419765
  420441
  422491
  423670
  428892
  430484
  436481
  437789
  437961
  439194
  443203
  446041
  447533
  449592
  450803
  451232
  452135
  453903
  454599
  457688
  458179
  458348
  459097
  460225
  460424
  460680
  464165
  464610
  465185
  465838
  468022
  470067
  471517
  471592
  472309
  472626
  474178
  474369
  478319
  480954
  481727
  482812
  483014
  485105
  486955
  489634
  490284
  493349
  493460
  493898
  494365
  494670
  496013
  497250
  498924
  499149
  499324
  500888
  501649
  502566
  502896
  505378
  506090
  507199
  509630
  510121
  511913
  519115
  520599
  522083
  523689
  524845
  525833
  525872
  527324
  543833
  548908
  558606
  558770
  560179
  565722
  571500
  573470
  576062
  578123
  578343
  582051
  582521
  592342
  597583
  602009
  602848
  603166
  603253
  605455
  624886
  631466
  679244
  719806
  731884
  791933
]
1.98 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сделай глубокий минет…"
]
1.76 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сдела глубокийминет минет оральн секс"
]
1.74 ms
(1.15%)
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.