Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.12 ms
(56.41%)
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
  317866
  325706
  383274
  386264
  388805
  390827
  392817
  394152
  397997
  410331
  448678
  451687
  451694
  453312
  463896
  476297
  491788
  492840
  494758
  505722
  505899
  506924
  507138
  507532
  509310
  509596
  511061
  511309
  519754
  522448
  526535
  529422
  530130
  535898
  539800
  544503
  547035
  548590
  555502
  565126
  565627
  567116
  567628
  568202
  575997
  578704
  580033
  580886
  582153
  582792
  584430
  584434
  586552
  590734
  595434
  595590
  596251
  596778
  599472
  600614
  602328
  602343
  602704
  603396
  604634
  604808
  604854
  604863
  606082
  620401
  620403
  628589
  638181
  638742
  661031
  661410
  666808
  667199
  667649
  667672
  671328
  676208
  680538
  680570
  687144
  695867
  699267
  700855
  703949
  705677
  707483
  707529
  709790
  709960
  710001
  710228
  712081
  712177
  712283
  714203
  715732
  743858
  749578
  750395
  756914
  772547
  776421
  790323
  793917
  796272
  798829
  804649
  810384
  810996
  814498
  814988
  815941
  822646
  824735
  825190
]
137.56 ms
(36.41%)
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
  317866
  325706
  383274
  386264
  388805
  390827
  392817
  394152
  397997
  410331
  448678
  451687
  451694
  453312
  463896
  476297
  491788
  492840
  494758
  505722
  505899
  506924
  507138
  507532
  509310
  509596
  511061
  511309
  519754
  522448
  526535
  529422
  530130
  535898
  539800
  544503
  547035
  548590
  555502
  565126
  565627
  567116
  567628
  568202
  575997
  578704
  580033
  580886
  582153
  582792
  584430
  584434
  586552
  590734
  595434
  595590
  596251
  596778
  599472
  600614
  602328
  602343
  602704
  603396
  604634
  604808
  604854
  604863
  606082
  620401
  620403
  628589
  638181
  638742
  661031
  661410
  666808
  667199
  667649
  667672
  671328
  676208
  680538
  680570
  687144
  695867
  699267
  700855
  703949
  705677
  707483
  707529
  709790
  709960
  710001
  710228
  712081
  712177
  712283
  714203
  715732
  743858
  749578
  750395
  756914
  772547
  776421
  790323
  793917
  796272
  798829
  804649
  810384
  810996
  814498
  814988
  815941
  822646
  824735
  825190
]
20.31 ms
(5.38%)
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
  386264
  383274
  317866
  390827
  815941
  680538
  699267
  709960
  712283
  600614
  590734
  604808
  595590
  606082
  790323
  793917
  810384
  756914
  749578
  712081
  715732
  392817
  388805
  397997
  822646
  824735
  453312
  582153
  667672
  603396
  804649
  772547
  750395
  743858
  798829
  810996
  325706
  529422
  825190
  491788
  505899
  509310
  511309
  526535
  539800
  519754
  511061
  530130
  565126
  555502
  582792
  584434
  712177
  580033
  602328
  604634
  602343
  602704
  796272
  394152
  522448
  410331
  814498
  814988
  451694
  448678
  451687
  476297
  492840
  507138
  507532
  509596
  535898
  505722
  494758
  506924
  463896
  548590
  565627
  578704
  544503
  547035
  575997
  580886
  584430
  567628
  661410
  666808
  671328
  703949
  705677
  707483
  707529
  709790
  661031
  667199
  676208
  695867
  710001
  667649
  680570
  687144
  700855
  710228
  714203
  567116
  568202
  596251
  604863
  628589
  638181
  586552
  595434
  596778
  620401
  620403
  599472
  604854
  638742
  776421
]
2.17 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boobs tits"
]
1.63 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boobs сиськ"
]
1.39 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boobs сиськ"
]

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.