Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.26 ms
(83.90%)
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
  385318
  390447
  395904
  400435
  402876
  406022
  411319
  411750
  413946
  414298
  418066
  418774
  419147
  421027
  421658
  422282
  422498
  423732
  423743
  425570
  425684
  425881
  432228
  433592
  434655
  434889
  435437
  436049
  436423
  437610
  437880
  438288
  438334
  444356
  444895
  446418
  448095
  449088
  450145
  450405
  450573
  450643
  450754
  452825
  453129
  453296
  453889
  454374
  456664
  457014
  457204
  457651
  457780
  458475
  458788
  458794
  460380
  462214
  464631
  465243
  466027
  466373
  466640
  473789
  473893
  476974
  478125
  478131
  481747
  482618
  483527
  483627
  486334
  488616
  489293
  491518
  492930
  497934
  499530
  499533
  499977
  502764
  505304
  512359
  512590
  512752
  516778
  519678
  520830
  523788
  524205
  524413
  528544
  529156
  556553
  556554
  556817
  558615
  559293
  565086
  567733
  568630
  588730
  592778
  594638
  596763
  602181
  605865
  609827
  620216
  620250
  625649
  632978
  635834
  673424
  677172
  723287
  730722
  791704
  802691
]
18.89 ms
(10.01%)
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
  632978
  395904
  400435
  411750
  436423
  422282
  432228
  434889
  411319
  425881
  413946
  414298
  422498
  453296
  457780
  456664
  457014
  458794
  460380
  462214
  486334
  449088
  464631
  466027
  492930
  524413
  512590
  499533
  505304
  520830
  523788
  482618
  488616
  556817
  556553
  556554
  559293
  565086
  568630
  677172
  673424
  723287
  558615
  567733
  592778
  602181
  596763
  609827
  594638
  625649
  791704
  802691
  730722
  635834
  421658
  425684
  436049
  448095
  458788
  465243
  466373
  473789
  406022
  425570
  434655
  435437
  438334
  450643
  418066
  418774
  423743
  444895
  446418
  466640
  473893
  437880
  438288
  450405
  452825
  454374
  476974
  421027
  450754
  457204
  458475
  478125
  478131
  481747
  499977
  512752
  516778
  529156
  491518
  499530
  502764
  519678
  483527
  489293
  497934
  512359
  524205
  528544
  483627
  588730
  605865
  620216
  620250
  444356
  385318
  390447
  402876
  419147
  437610
  423732
  433592
  453129
  453889
  457651
  450145
  450573
]
3.45 ms
(1.83%)
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
  385318
  390447
  395904
  400435
  402876
  406022
  411319
  411750
  413946
  414298
  418066
  418774
  419147
  421027
  421658
  422282
  422498
  423732
  423743
  425570
  425684
  425881
  432228
  433592
  434655
  434889
  435437
  436049
  436423
  437610
  437880
  438288
  438334
  444356
  444895
  446418
  448095
  449088
  450145
  450405
  450573
  450643
  450754
  452825
  453129
  453296
  453889
  454374
  456664
  457014
  457204
  457651
  457780
  458475
  458788
  458794
  460380
  462214
  464631
  465243
  466027
  466373
  466640
  473789
  473893
  476974
  478125
  478131
  481747
  482618
  483527
  483627
  486334
  488616
  489293
  491518
  492930
  497934
  499530
  499533
  499977
  502764
  505304
  512359
  512590
  512752
  516778
  519678
  520830
  523788
  524205
  524413
  528544
  529156
  556553
  556554
  556817
  558615
  559293
  565086
  567733
  568630
  588730
  592778
  594638
  596763
  602181
  605865
  609827
  620216
  620250
  625649
  632978
  635834
  673424
  677172
  723287
  730722
  791704
  802691
]
2.54 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde cum"
]
1.98 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая cum"
]
1.78 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая cum"
]
1.73 ms
(0.92%)
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.