Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.25 ms
(87.27%)
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
  389994
  390139
  391597
  391977
  392005
  392013
  401374
  411402
  421828
  422201
  423867
  423942
  423988
  426767
  426821
  427001
  427077
  432545
  433363
  434242
  437369
  442057
  448918
  454018
  455202
  459659
  460408
  462522
  462580
  464539
  464547
  466337
  466343
  470503
  470679
  474181
  475097
  476675
  477929
  477933
  479604
  485947
  485978
  489225
  489770
  490499
  491124
  492967
  493426
  494594
  494796
  494798
  495137
  495157
  495520
  496019
  498158
  503501
  509264
  513067
  520701
  526494
  545971
  548010
  549732
  566364
  569993
  591913
  597094
  601555
  655515
  692288
  700121
  725224
  725243
  726970
  733232
  735974
  741339
  741714
  741738
  741766
  742056
  742368
  742375
  742828
  743542
  752131
  752732
  752832
  759382
  760452
  766304
  766341
  766516
  778492
  780776
  791099
  794173
  795937
  796563
  796811
  805342
  809800
  824292
  824531
  824533
  824633
  824732
  824733
  824967
  825359
  825428
  825429
  826378
  826483
  826486
  826682
  826686
  826689
]
12.63 ms
(7.29%)
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
  805342
  809800
  392005
  391977
  495137
  824533
  824633
  824733
  796811
  741738
  743542
  752832
  778492
  423988
  433363
  509264
  700121
  566364
  780776
  725224
  725243
  752732
  766516
  726970
  741766
  735974
  791099
  423867
  549732
  477929
  466337
  437369
  489225
  475097
  496019
  495520
  548010
  391597
  432545
  479604
  421828
  427001
  460408
  401374
  411402
  422201
  462522
  477933
  389994
  426821
  434242
  455202
  491124
  492967
  494594
  498158
  493426
  520701
  526494
  485947
  513067
  495157
  569993
  545971
  692288
  655515
  597094
  601555
  742368
  742375
  741714
  454018
  464539
  464547
  427077
  448918
  474181
  476675
  459659
  470503
  466343
  470679
  485978
  503501
  494798
  490499
  494796
  390139
  462580
  796563
  733232
  742056
  489770
  824292
  824531
  591913
  795937
  766341
  741339
  742828
  759382
  752131
  760452
  766304
  794173
  442057
  392013
  426767
  423942
  824732
  824967
  825359
  825428
  825429
  826682
  826486
  826483
  826378
  826686
  826689
]
2.96 ms
(1.71%)
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
  389994
  390139
  391597
  391977
  392005
  392013
  401374
  411402
  421828
  422201
  423867
  423942
  423988
  426767
  426821
  427001
  427077
  432545
  433363
  434242
  437369
  442057
  448918
  454018
  455202
  459659
  460408
  462522
  462580
  464539
  464547
  466337
  466343
  470503
  470679
  474181
  475097
  476675
  477929
  477933
  479604
  485947
  485978
  489225
  489770
  490499
  491124
  492967
  493426
  494594
  494796
  494798
  495137
  495157
  495520
  496019
  498158
  503501
  509264
  513067
  520701
  526494
  545971
  548010
  549732
  566364
  569993
  591913
  597094
  601555
  655515
  692288
  700121
  725224
  725243
  726970
  733232
  735974
  741339
  741714
  741738
  741766
  742056
  742368
  742375
  742828
  743542
  752131
  752732
  752832
  759382
  760452
  766304
  766341
  766516
  778492
  780776
  791099
  794173
  795937
  796563
  796811
  805342
  809800
  824292
  824531
  824533
  824633
  824732
  824733
  824967
  825359
  825428
  825429
  826378
  826483
  826486
  826682
  826686
  826689
]
1.77 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby wife russian"
]
1.67 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby жен русск"
]
1.53 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby жен русск"
]
1.49 ms
(0.86%)
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.