Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.88 ms
(87.06%)
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
  399908
  420303
  435625
  438641
  449111
  454086
  458277
  468252
  470075
  488908
  489131
  505601
  508899
  515443
  517493
  540590
  541043
  541149
  542101
  550968
  552713
  554693
  555403
  555451
  556023
  577034
  583727
  586891
  595625
  647111
  655452
  663195
  665076
  668651
  669858
  671558
  671559
  680597
  688829
  689849
  689871
  689902
  693695
  695552
  698156
  699304
  702639
  703011
  705769
  706057
  707867
  708748
  709983
  713153
  716081
  718036
  720648
  725428
  726057
  728536
  730526
  740636
  741200
  741503
  745715
  746199
  747427
  747433
  748262
  750626
  750641
  750662
  750764
  751281
  751310
  752849
  754986
  756538
  766317
  768229
  773183
  775646
  777715
  777869
  777876
  782855
  783363
  784001
  784048
  784647
  785250
  785505
  786366
  788659
  791024
  791450
  795027
  795362
  796388
  797918
  798769
  799854
  800116
  801780
  801999
  803396
  809150
  810082
  810180
  810917
  814202
  818690
  818722
  820011
  824554
  825991
  826832
  827394
  827439
]
14.57 ms
(8.09%)
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
  783363
  797918
  799854
  810917
  748262
  750641
  740636
  750764
  741200
  751281
  756538
  768229
  773183
  747427
  766317
  703011
  720648
  777876
  784647
  785505
  791024
  795362
  796388
  801780
  814202
  505601
  508899
  706057
  688829
  791450
  785250
  745715
  438641
  489131
  517493
  435625
  663195
  708748
  595625
  782855
  750662
  752849
  709983
  707867
  449111
  454086
  470075
  698156
  671558
  689849
  716081
  809150
  810180
  750626
  784048
  747433
  754986
  784001
  468252
  399908
  515443
  420303
  825991
  824734
  555403
  555451
  542101
  699304
  705769
  668651
  788659
  801999
  810082
  777869
  741503
  746199
  795027
  725428
  730526
  726057
  728536
  713153
  798769
  695552
  751310
  541149
  818722
  820011
  824554
  826832
  827439
  827394
  818690
  458277
  488908
  540590
  556023
  541043
  550968
  552713
  554693
  655452
  665076
  671559
  680597
  702639
  647111
  669858
  693695
  718036
  689871
  689902
  577034
  583727
  586891
  777715
  786366
  775646
  800116
  803396
]
2.10 ms
(1.17%)
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
  399908
  420303
  435625
  438641
  449111
  454086
  458277
  468252
  470075
  488908
  489131
  505601
  508899
  515443
  517493
  540590
  541043
  541149
  542101
  550968
  552713
  554693
  555403
  555451
  556023
  577034
  583727
  586891
  595625
  647111
  655452
  663195
  665076
  668651
  669858
  671558
  671559
  680597
  688829
  689849
  689871
  689902
  693695
  695552
  698156
  699304
  702639
  703011
  705769
  706057
  707867
  708748
  709983
  713153
  716081
  718036
  720648
  725428
  726057
  728536
  730526
  740636
  741200
  741503
  745715
  746199
  747427
  747433
  748262
  750626
  750641
  750662
  750764
  751281
  751310
  752849
  754986
  756538
  766317
  768229
  773183
  775646
  777715
  777869
  777876
  782855
  783363
  784001
  784048
  784647
  785250
  785505
  786366
  788659
  791024
  791450
  795027
  795362
  796388
  797918
  798769
  799854
  800116
  801780
  801999
  803396
  809150
  810082
  810180
  810917
  814202
  818690
  818722
  820011
  824554
  825991
  826832
  827394
  827439
]
1.88 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк мастурбац orgasm"
]
1.75 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl masturbation orgasm"
]
1.46 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк мастурбац orgasm"
]

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.