Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.26 ms
(82.22%)
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
  397766
  414135
  417192
  421695
  424560
  426962
  427543
  433066
  437999
  446212
  447848
  449412
  452654
  453024
  453992
  455031
  462352
  462686
  462899
  464022
  465550
  468889
  469597
  473784
  474913
  474969
  475196
  475996
  476893
  479426
  479965
  480564
  490149
  492233
  493610
  498288
  498768
  500115
  500118
  506342
  508206
  508970
  523820
  524102
  527194
  532487
  543970
  548414
  553332
  555103
  555109
  556100
  560304
  561281
  563743
  565012
  566405
  567594
  574068
  574153
  574418
  577562
  577995
  578285
  579215
  580292
  580533
  587885
  591206
  592644
  593393
  593967
  594451
  599000
  601678
  602073
  610322
  618031
  618384
  624196
  625435
  628903
  628956
  634229
  641407
  660109
  672240
  673416
  684695
  693629
  717851
  722984
  725720
  732211
  741185
  741855
  752197
  756626
  756639
  757446
  761495
  762337
  763442
  764666
  764698
  772763
  776773
  783162
  784042
  784552
  785443
  787802
  795213
  795812
  798966
  803394
  808228
  814272
  816679
]
17.37 ms
(10.96%)
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
  574418
  555103
  772763
  618031
  465550
  498768
  795213
  752197
  732211
  628903
  756639
  757446
  473784
  433066
  469597
  479426
  579215
  397766
  455031
  462686
  479965
  424560
  508970
  553332
  672240
  427543
  417192
  814272
  452654
  453024
  462899
  474913
  480564
  464022
  500118
  500115
  506342
  508206
  527194
  532487
  476893
  574068
  577995
  543970
  563743
  577562
  548414
  556100
  561281
  565012
  566405
  578285
  580292
  717851
  673416
  684695
  693629
  555109
  580533
  587885
  591206
  624196
  593393
  594451
  599000
  610322
  618384
  625435
  634229
  641407
  592644
  784552
  808228
  776773
  779185
  783162
  803394
  725720
  741185
  761495
  762337
  741855
  756626
  764698
  601678
  602073
  784042
  787802
  795812
  798966
  475196
  421695
  446212
  447848
  468889
  475996
  437999
  474969
  498288
  524102
  492233
  490149
  493610
  660109
  462352
  426962
  523820
  763442
  560304
  567594
  722984
  593967
  785443
  764666
  414135
  628956
  816679
  453992
  449412
  574153
]
2.87 ms
(1.81%)
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
  397766
  414135
  417192
  421695
  424560
  426962
  427543
  433066
  437999
  446212
  447848
  449412
  452654
  453024
  453992
  455031
  462352
  462686
  462899
  464022
  465550
  468889
  469597
  473784
  474913
  474969
  475196
  475996
  476893
  479426
  479965
  480564
  490149
  492233
  493610
  498288
  498768
  500115
  500118
  506342
  508206
  508970
  523820
  524102
  527194
  532487
  543970
  548414
  553332
  555103
  555109
  556100
  560304
  561281
  563743
  565012
  566405
  567594
  574068
  574153
  574418
  577562
  577995
  578285
  579215
  580292
  580533
  587885
  591206
  592644
  593393
  593967
  594451
  599000
  601678
  602073
  610322
  618031
  618384
  624196
  625435
  628903
  628956
  634229
  641407
  660109
  672240
  673416
  684695
  693629
  717851
  722984
  725720
  732211
  741185
  741855
  752197
  756626
  756639
  757446
  761495
  762337
  763442
  764666
  764698
  772763
  776773
  783162
  784042
  784552
  785443
  787802
  795213
  795812
  798966
  803394
  808228
  814272
  816679
]
2.30 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife hard pov"
]
1.99 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен hard пов"
]
1.74 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен hard пов"
]

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.