Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.99 ms
(86.45%)
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
  176394
  187443
  389019
  389883
  401427
  416988
  420674
  444432
  444516
  445007
  445010
  448596
  454570
  455420
  464967
  472606
  495553
  495556
  509516
  510828
  512056
  520524
  524644
  525424
  529978
  533533
  538603
  539309
  541460
  541669
  543640
  544002
  545327
  545506
  547111
  553413
  554158
  559156
  560353
  567603
  568471
  576613
  579545
  579595
  585258
  586404
  588232
  588973
  589235
  589545
  589654
  591708
  592723
  592740
  593380
  596860
  598926
  603275
  603282
  605073
  610199
  630567
  631685
  639635
  645423
  660623
  664227
  671558
  672843
  676769
  681674
  701223
  702335
  706720
  710807
  738101
  740375
  743236
  744187
  744933
  748702
  755495
  758290
  758561
  760358
  768480
  768791
  769382
  770234
  771082
  773496
  780961
  781417
  781946
  783291
  785263
  785492
  785752
  785762
  787525
  796045
  797046
  797050
  797182
  798481
  799633
  799641
  799646
  802273
  804617
  804649
  805355
  806470
  806854
  806980
  808165
  810458
  816831
  823887
  826715
]
14.14 ms
(7.59%)
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
  176394
  816831
  529978
  533533
  544002
  559156
  579545
  547111
  579595
  560353
  660623
  645423
  681674
  702335
  591708
  589545
  592740
  631685
  589235
  593380
  639635
  780961
  785762
  805355
  760358
  768480
  748702
  755495
  768791
  770234
  806470
  806980
  187443
  389019
  823887
  539309
  664227
  672843
  676769
  586404
  592723
  598926
  603275
  585258
  797182
  804649
  781946
  738101
  758561
  758290
  701223
  445007
  568471
  455420
  771082
  783291
  464967
  538603
  554158
  603282
  610199
  589654
  769382
  448596
  472606
  520524
  525424
  541669
  567603
  576613
  545506
  553413
  706720
  671558
  596860
  799633
  799646
  787525
  802273
  810458
  740375
  743236
  785263
  744933
  605073
  710807
  785492
  797050
  806854
  401427
  454570
  444516
  495553
  495556
  389883
  541460
  543640
  588973
  588232
  630567
  785752
  798481
  808165
  744187
  773496
  797046
  416988
  524644
  509516
  512056
  545327
  796045
  804617
  799641
  445010
  510828
  420674
  444432
  826715
  781417
]
3.71 ms
(1.99%)
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
  176394
  187443
  389019
  389883
  401427
  416988
  420674
  444432
  444516
  445007
  445010
  448596
  454570
  455420
  464967
  472606
  495553
  495556
  509516
  510828
  512056
  520524
  524644
  525424
  529978
  533533
  538603
  539309
  541460
  541669
  543640
  544002
  545327
  545506
  547111
  553413
  554158
  559156
  560353
  567603
  568471
  576613
  579545
  579595
  585258
  586404
  588232
  588973
  589235
  589545
  589654
  591708
  592723
  592740
  593380
  596860
  598926
  603275
  603282
  605073
  610199
  630567
  631685
  639635
  645423
  660623
  664227
  671558
  672843
  676769
  681674
  701223
  702335
  706720
  710807
  738101
  740375
  743236
  744187
  744933
  748702
  755495
  758290
  758561
  760358
  768480
  768791
  769382
  770234
  771082
  773496
  780961
  781417
  781946
  783291
  785263
  785492
  785752
  785762
  787525
  796045
  797046
  797050
  797182
  798481
  799633
  799641
  799646
  802273
  804617
  804649
  805355
  806470
  806854
  806980
  808165
  810458
  816831
  823887
  826715
]
2.00 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy solo tits"
]
1.93 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy соло сиськ"
]
1.81 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy соло сиськ"
]
1.63 ms
(0.87%)
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.