Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.85 ms
(85.78%)
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
  20617
  312919
  343227
  382022
  386335
  386698
  388570
  413612
  419777
  430455
  430574
  433594
  434209
  441965
  447132
  450639
  455227
  460974
  467934
  474953
  476052
  477043
  479162
  483189
  485348
  485886
  491290
  491463
  495063
  496999
  499359
  505891
  508522
  512867
  514149
  521223
  521231
  522177
  524712
  529548
  531574
  532536
  532693
  533977
  534221
  535076
  537118
  538891
  538940
  540274
  541597
  542343
  543441
  543849
  545649
  546177
  546784
  546807
  546825
  547848
  551055
  557198
  568478
  569701
  569736
  569778
  593463
  600824
  600964
  603707
  605512
  605583
  624195
  626533
  628600
  655840
  660608
  676157
  680611
  685979
  687989
  688666
  696097
  697465
  710316
  711269
  713126
  720705
  722481
  722510
  722523
  722544
  733230
  760696
  760793
  770228
  772077
  784713
  785944
  794907
  795354
  796199
  800329
  800759
  801286
  803836
  806121
  808774
  809846
  810675
  813784
  815023
  817048
  817063
  817169
  817887
  818371
  819708
  823330
  827079
]
14.33 ms
(8.43%)
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
  533977
  538891
  540274
  521223
  521231
  522177
  531574
  532536
  537118
  532693
  534221
  538940
  543441
  546177
  546784
  546807
  546825
  568478
  541597
  551055
  542343
  547848
  557198
  569736
  655840
  680611
  685979
  710316
  713126
  697465
  711269
  660608
  676157
  687989
  696097
  722510
  722523
  722544
  569701
  605512
  628600
  600964
  603707
  605583
  593463
  600824
  626533
  809846
  784713
  796199
  801286
  808774
  733230
  760696
  772077
  785944
  794907
  803836
  806121
  760793
  770228
  720705
  722481
  795354
  800329
  800759
  810675
  433594
  20617
  343227
  386335
  430574
  388570
  460974
  479162
  450639
  476052
  499359
  485348
  485886
  447132
  543849
  624195
  505891
  491290
  495063
  535076
  496999
  529548
  545649
  569778
  688666
  455227
  467934
  477043
  419777
  474953
  483189
  508522
  512867
  514149
  491463
  524712
  386698
  312919
  382022
  430455
  441965
  434209
  413612
  817169
  817887
  819708
  823330
  813784
  815023
  817048
  817063
  818371
  827079
]
3.04 ms
(1.79%)
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
  20617
  312919
  343227
  382022
  386335
  386698
  388570
  413612
  419777
  430455
  430574
  433594
  434209
  441965
  447132
  450639
  455227
  460974
  467934
  474953
  476052
  477043
  479162
  483189
  485348
  485886
  491290
  491463
  495063
  496999
  499359
  505891
  508522
  512867
  514149
  521223
  521231
  522177
  524712
  529548
  531574
  532536
  532693
  533977
  534221
  535076
  537118
  538891
  538940
  540274
  541597
  542343
  543441
  543849
  545649
  546177
  546784
  546807
  546825
  547848
  551055
  557198
  568478
  569701
  569736
  569778
  593463
  600824
  600964
  603707
  605512
  605583
  624195
  626533
  628600
  655840
  660608
  676157
  680611
  685979
  687989
  688666
  696097
  697465
  710316
  711269
  713126
  720705
  722481
  722510
  722523
  722544
  733230
  760696
  760793
  770228
  772077
  784713
  785944
  794907
  795354
  796199
  800329
  800759
  801286
  803836
  806121
  808774
  809846
  810675
  813784
  815023
  817048
  817063
  817169
  817887
  818371
  819708
  823330
  827079
]
2.13 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bondage milf"
]
1.71 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм milf"
]
1.34 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм milf"
]

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.