Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
250.94 ms
(91.39%)
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
  329912
  362615
  397973
  401517
  401809
  415048
  419998
  421435
  427759
  429221
  432418
  432461
  433418
  437733
  450065
  451161
  456405
  457295
  459032
  461830
  465700
  466460
  472622
  488797
  489347
  492816
  493763
  496456
  497683
  497687
  498993
  503816
  508282
  508802
  509149
  517299
  518794
  519712
  519862
  521109
  532814
  534559
  535427
  538725
  540021
  540985
  540987
  545108
  545855
  547074
  547082
  554797
  555602
  562736
  571975
  572901
  574391
  577312
  584425
  584504
  584905
  585365
  587214
  587959
  588791
  590165
  591041
  591162
  593120
  595129
  595582
  595706
  601101
  604466
  605196
  608516
  610101
  613932
  634711
  643827
  657865
  659354
  663749
  666024
  669062
  675638
  680242
  686917
  690884
  713727
  714484
  732745
  732767
  735678
  737673
  739089
  739961
  751822
  757232
  757974
  762899
  766656
  769476
  770281
  776035
  784959
  786412
  787722
  789790
  793151
  796629
  796650
  796696
  797051
  799949
  803374
  808580
  812738
  812743
  821848
]
15.08 ms
(5.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
  492816
  489347
  591162
  789790
  796629
  803374
  797051
  812738
  419998
  465700
  509149
  519862
  538725
  554797
  608516
  532814
  595129
  643827
  508802
  585365
  732767
  362615
  675638
  577312
  587959
  401517
  401809
  540021
  690884
  584504
  429221
  713727
  796696
  808580
  786412
  769476
  737673
  757232
  601101
  415048
  496456
  535427
  547074
  584425
  547082
  574391
  610101
  587214
  739961
  751822
  776035
  437733
  517299
  432461
  457295
  534559
  799949
  787722
  732745
  735678
  488797
  590165
  666024
  450065
  657865
  571975
  329912
  397973
  451161
  518794
  669062
  634711
  796650
  784959
  793151
  757974
  766656
  739089
  432418
  461830
  456405
  508282
  497687
  659354
  686917
  714484
  595706
  604466
  588791
  663749
  427759
  545855
  562736
  812743
  762899
  821848
  472622
  613932
  503816
  572901
  605196
  593120
  521109
  498993
  540985
  584905
  680242
  519712
  497683
  540987
  459032
  433418
  493763
  555602
  545108
  591041
  770281
  421435
  466460
  595582
]
2.61 ms
(0.95%)
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
  329912
  362615
  397973
  401517
  401809
  415048
  419998
  421435
  427759
  429221
  432418
  432461
  433418
  437733
  450065
  451161
  456405
  457295
  459032
  461830
  465700
  466460
  472622
  488797
  489347
  492816
  493763
  496456
  497683
  497687
  498993
  503816
  508282
  508802
  509149
  517299
  518794
  519712
  519862
  521109
  532814
  534559
  535427
  538725
  540021
  540985
  540987
  545108
  545855
  547074
  547082
  554797
  555602
  562736
  571975
  572901
  574391
  577312
  584425
  584504
  584905
  585365
  587214
  587959
  588791
  590165
  591041
  591162
  593120
  595129
  595582
  595706
  601101
  604466
  605196
  608516
  610101
  613932
  634711
  643827
  657865
  659354
  663749
  666024
  669062
  675638
  680242
  686917
  690884
  713727
  714484
  732745
  732767
  735678
  737673
  739089
  739961
  751822
  757232
  757974
  762899
  766656
  769476
  770281
  776035
  784959
  786412
  787722
  789790
  793151
  796629
  796650
  796696
  797051
  799949
  803374
  808580
  812738
  812743
  821848
]
1.67 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black girl homemade"
]
1.65 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black девушк домашн любительск"
]
1.39 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black девушк домашн любительск"
]

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.