Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
228.06 ms
(60.67%)
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
  607050
  729881
  822530
  826147
  818934
  825475
  828277
  537786
  649965
  642789
  813353
  560837
  382182
  561359
  553315
  402267
  546767
  387082
  480680
  499684
  519628
  561652
  602778
  525558
  554428
  568081
  560050
  565178
  567820
  573960
  576658
  579888
  550702
  561302
  564585
  573127
  574578
  659300
  663854
  551612
  569827
  589972
  599292
  622302
  597469
  598083
  395423
  243071
  542983
  554320
  654490
  657649
  563336
  607053
  641774
  744544
  731950
  732024
  735843
  547554
  542385
  404351
  548271
  552189
  595872
  448998
  88115
  510660
  745886
  552401
  740233
  766205
  749041
  750402
  761847
  462226
  516845
  588489
  429855
  593242
  824058
  826540
  818682
  819167
  822802
  824907
  827989
  828293
  828358
  828365
  828726
  535930
  658619
  754405
  789333
  773753
  767476
  768940
  573602
  573716
  732033
  528898
  571363
  418469
  813095
  424970
  422710
  828654
  818428
  827644
  522571
  529057
  716000
  604144
  788737
  746634
  742427
  760995
  800759
  450025
]
137.78 ms
(36.65%)
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
  88115
  243071
  382182
  387082
  395423
  402267
  404351
  418469
  422710
  424970
  429855
  448998
  450025
  462226
  480680
  499684
  510660
  516845
  519628
  522571
  525558
  528898
  529057
  535930
  537786
  542385
  542983
  546767
  547554
  548271
  550702
  551612
  552189
  552401
  553315
  554320
  554428
  560050
  560837
  561302
  561359
  561652
  563336
  564585
  565178
  567820
  568081
  569827
  571363
  573127
  573602
  573716
  573960
  574578
  576658
  579888
  588489
  589972
  593242
  595872
  597469
  598083
  599292
  602778
  604144
  607050
  607053
  622302
  641774
  642789
  649965
  654490
  657649
  658619
  659300
  663854
  716000
  729881
  731950
  732024
  732033
  735843
  740233
  742427
  744544
  745886
  746634
  749041
  750402
  754405
  760995
  761847
  766205
  767476
  768940
  773753
  788737
  789333
  800759
  813095
  813353
  818428
  818682
  818934
  819167
  822802
  824058
  824907
  825475
  826147
  826540
  827644
  827989
  828277
  828358
  828365
  828654
  828726
]
2.58 ms
(0.69%)
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
  88115
  243071
  382182
  387082
  395423
  402267
  404351
  418469
  422710
  424970
  429855
  448998
  450025
  462226
  480680
  499684
  510660
  516845
  519628
  522571
  525558
  528898
  529057
  535930
  537786
  542385
  542983
  546767
  547554
  548271
  550702
  551612
  552189
  552401
  553315
  554320
  554428
  560050
  560837
  561302
  561359
  561652
  563336
  564585
  565178
  567820
  568081
  569827
  571363
  573127
  573602
  573716
  573960
  574578
  576658
  579888
  588489
  589972
  593242
  595872
  597469
  598083
  599292
  602778
  604144
  607050
  607053
  622302
  641774
  642789
  649965
  654490
  657649
  658619
  659300
  663854
  716000
  729881
  731950
  732024
  732033
  735843
  740233
  742427
  744544
  745886
  746634
  749041
  750402
  754405
  760995
  761847
  766205
  767476
  768940
  773753
  788737
  789333
  800759
  813095
  813353
  818428
  818682
  818934
  819167
  822802
  824058
  824907
  825475
  826147
  826540
  827644
  827989
  828277
  828358
  828365
  828654
  828726
]
2.15 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small panties"
]
1.97 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая трусик нижн бел"
]
1.52 ms
(0.40%)
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.