Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.25 ms
(87.96%)
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
  381875
  417495
  420473
  426604
  429823
  432505
  450111
  459085
  463373
  469593
  472295
  505172
  509149
  518975
  521046
  521109
  526658
  528875
  530159
  530564
  535427
  540435
  544690
  547650
  548588
  555602
  560304
  560314
  560799
  588791
  598020
  599781
  602061
  603417
  604464
  604498
  605174
  607478
  608683
  615846
  619391
  624329
  629412
  630160
  635050
  637133
  643018
  648394
  649560
  651601
  653956
  664368
  669192
  669224
  682922
  691724
  692495
  693617
  697130
  703982
  728738
  732745
  756092
  765092
  765959
  766656
  767984
  769700
  770281
  770644
  770945
  771366
  774058
  774285
  776164
  777011
  779774
  780599
  784740
  784814
  784959
  784976
  787678
  787722
  787738
  787885
  788835
  789153
  789645
  789790
  790347
  791752
  791758
  792172
  792813
  795168
  796598
  797029
  797105
  802875
  804647
  808293
  812470
  812743
  812793
  813459
  813584
  817761
  817965
  818587
  818768
  819800
  820990
  821204
  821695
  822961
  823332
  823560
  825965
]
12.80 ms
(7.02%)
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
  795168
  802875
  756092
  780599
  608683
  790347
  787678
  649560
  682922
  603417
  776164
  822993
  825965
  426604
  526658
  637133
  463373
  518975
  818587
  821695
  823560
  635050
  796598
  819800
  648394
  789645
  530564
  544690
  619391
  703982
  789153
  817761
  820990
  817965
  821204
  528875
  692495
  630160
  812470
  530159
  693617
  669224
  624329
  791752
  797105
  774058
  787885
  432505
  823332
  818768
  779774
  791758
  792172
  812793
  770945
  767984
  774285
  797029
  615846
  381875
  540435
  697130
  604464
  605174
  777011
  765092
  728738
  769700
  784740
  469593
  521109
  598020
  813584
  547650
  599781
  607478
  604498
  629412
  812743
  789790
  804647
  787722
  788835
  813459
  732745
  417495
  509149
  651601
  560304
  429823
  822961
  450111
  521046
  535427
  555602
  560799
  548588
  669192
  664368
  588791
  602061
  643018
  784976
  784959
  792813
  770644
  787738
  808293
  765959
  766656
  770281
  771366
  784814
  420473
  472295
  691724
  505172
  653956
  560314
  459085
]
2.84 ms
(1.56%)
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
  381875
  417495
  420473
  426604
  429823
  432505
  450111
  459085
  463373
  469593
  472295
  505172
  509149
  518975
  521046
  521109
  526658
  528875
  530159
  530564
  535427
  540435
  544690
  547650
  548588
  555602
  560304
  560314
  560799
  588791
  598020
  599781
  602061
  603417
  604464
  604498
  605174
  607478
  608683
  615846
  619391
  624329
  629412
  630160
  635050
  637133
  643018
  648394
  649560
  651601
  653956
  664368
  669192
  669224
  682922
  691724
  692495
  693617
  697130
  703982
  728738
  732745
  756092
  765092
  765959
  766656
  767984
  769700
  770281
  770644
  770945
  771366
  774058
  774285
  776164
  777011
  779774
  780599
  784740
  784814
  784959
  784976
  787678
  787722
  787738
  787885
  788835
  789153
  789645
  789790
  790347
  791752
  791758
  792172
  792813
  795168
  796598
  797029
  797105
  802875
  804647
  808293
  812470
  812743
  812793
  813459
  813584
  817761
  817965
  818587
  818768
  819800
  820990
  821204
  821695
  822961
  823332
  823560
  825965
]
1.79 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black hair pov"
]
1.66 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black hair пов"
]
1.49 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black hair пов"
]
1.36 ms
(0.75%)
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.