Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.63 ms
(86.43%)
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
  391009
  394059
  398567
  402628
  411116
  411690
  411727
  419956
  421696
  422426
  423495
  425570
  432611
  435318
  442100
  446551
  446792
  448332
  453170
  453224
  456022
  458047
  462021
  462104
  464053
  465393
  471020
  477548
  482303
  485432
  490599
  490638
  493744
  515203
  517834
  527503
  533299
  536103
  538080
  547422
  550921
  574398
  577281
  578780
  581291
  584027
  584191
  591549
  593807
  598341
  600987
  605230
  606071
  606254
  606345
  607765
  609071
  614759
  615283
  617880
  625874
  626027
  626889
  628531
  628744
  629539
  636052
  638769
  638905
  640147
  644141
  646088
  653078
  656137
  661472
  663212
  664169
  680542
  697222
  703705
  703771
  703773
  703942
  714934
  717535
  720442
  722115
  722134
  725216
  725443
  726736
  728047
  730316
  731316
  732177
  732178
  733223
  734179
  735445
  735473
  745746
  745987
  751255
  752584
  753242
  761523
  761525
  764212
  788841
  790236
  793195
  795310
  798708
  802336
  803738
  818540
  823600
  824125
  826620
  827634
]
14.02 ms
(7.50%)
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
  722134
  605230
  606071
  790236
  725216
  734179
  761523
  725443
  730316
  732177
  733223
  745746
  726736
  732178
  735445
  761525
  731316
  745987
  764212
  722115
  803738
  411116
  421696
  411690
  458047
  435318
  464053
  793195
  398567
  823600
  824125
  827634
  714934
  802336
  547422
  490638
  606254
  581291
  591549
  795310
  465393
  515203
  419956
  638769
  577281
  533299
  536103
  538080
  584027
  550921
  703705
  653078
  661472
  646088
  656137
  664169
  697222
  584191
  615283
  628744
  626027
  644141
  607765
  617880
  636052
  593807
  625874
  638905
  640147
  735473
  751255
  629539
  703771
  703773
  703942
  574398
  663212
  482303
  717535
  609071
  453224
  425570
  462021
  423495
  391009
  402628
  446792
  453170
  493744
  490599
  477548
  826620
  517834
  720442
  752584
  728047
  753242
  788841
  818540
  626889
  527503
  600987
  606345
  394059
  432611
  411727
  456022
  471020
  448332
  798708
  680542
  628531
  614759
  442100
  422426
  446551
  485432
  462104
  578780
  598341
]
3.06 ms
(1.64%)
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
  391009
  394059
  398567
  402628
  411116
  411690
  411727
  419956
  421696
  422426
  423495
  425570
  432611
  435318
  442100
  446551
  446792
  448332
  453170
  453224
  456022
  458047
  462021
  462104
  464053
  465393
  471020
  477548
  482303
  485432
  490599
  490638
  493744
  515203
  517834
  527503
  533299
  536103
  538080
  547422
  550921
  574398
  577281
  578780
  581291
  584027
  584191
  591549
  593807
  598341
  600987
  605230
  606071
  606254
  606345
  607765
  609071
  614759
  615283
  617880
  625874
  626027
  626889
  628531
  628744
  629539
  636052
  638769
  638905
  640147
  644141
  646088
  653078
  656137
  661472
  663212
  664169
  680542
  697222
  703705
  703771
  703773
  703942
  714934
  717535
  720442
  722115
  722134
  725216
  725443
  726736
  728047
  730316
  731316
  732177
  732178
  733223
  734179
  735445
  735473
  745746
  745987
  751255
  752584
  753242
  761523
  761525
  764212
  788841
  790236
  793195
  795310
  798708
  802336
  803738
  818540
  823600
  824125
  826620
  827634
]
2.34 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur hairy ass"
]
2.09 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск волосатая жоп"
]
2.03 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск волосатая жоп"
]
1.83 ms
(0.98%)
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.