Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.98 ms
(52.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин orgasm"
]
163.30 ms
(41.13%)
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
  424379
  427135
  427148
  427245
  427714
  427716
  429020
  429406
  429861
  429867
  429916
  433418
  434368
  440706
  444913
  445745
  449105
  452205
  455015
  455428
  455589
  460535
  464800
  467889
  469826
  477732
  478508
  478986
  478992
  480718
  485057
  486371
  488238
  488897
  489324
  494540
  495491
  495617
  498196
  499872
  502877
  503738
  505538
  509108
  514568
  517493
  518883
  522249
  524075
  525139
  531184
  533218
  541325
  547751
  547779
  548153
  549573
  549662
  553957
  555091
  570994
  575948
  581995
  583739
  592573
  594491
  598213
  604782
  608670
  618196
  630448
  706006
  714188
  718017
  725240
  726057
  729038
  729262
  730099
  730504
  733415
  733433
  734439
  738503
  738519
  739161
  741853
  742133
  744391
  746170
  752570
  752580
  752767
  756746
  756880
  756884
  757315
  759948
  760171
  760172
  764096
  766335
  767303
  767519
  776824
  781756
  786699
  787726
  791406
  794756
  794899
  795027
  795070
  795370
  795950
  796398
  796589
  801842
  827653
]
18.10 ms
(4.56%)
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
  756884
  760171
  764096
  767303
  781756
  786699
  795027
  795950
  796398
  725240
  729038
  752570
  757315
  760172
  729262
  733433
  739161
  746170
  752580
  730099
  734439
  741853
  756746
  767519
  726057
  742133
  618196
  718017
  794756
  795070
  795370
  796589
  801842
  517493
  429020
  433418
  427714
  429406
  452205
  469826
  489324
  488238
  494540
  503738
  549662
  549573
  706006
  714188
  630448
  756880
  733415
  608670
  427135
  440706
  477732
  434368
  449105
  478986
  455589
  478992
  518883
  525139
  499872
  505538
  495491
  522249
  488897
  445745
  424379
  480718
  509108
  533218
  514568
  464800
  547751
  547779
  553957
  581995
  583739
  541325
  548153
  555091
  570994
  604782
  598213
  759948
  791406
  738519
  752767
  427716
  467889
  455015
  455428
  478508
  495617
  498196
  427148
  827653
  575948
  604910
  776824
  744391
  794899
  730504
  787726
  486371
  427245
  485057
  592573
  460535
  429861
  429867
  524075
  502877
  531184
  594491
  738503
  766335
  444913
  429916
]
2.30 ms
(0.58%)
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
  424379
  427135
  427148
  427245
  427714
  427716
  429020
  429406
  429861
  429867
  429916
  433418
  434368
  440706
  444913
  445745
  449105
  452205
  455015
  455428
  455589
  460535
  464800
  467889
  469826
  477732
  478508
  478986
  478992
  480718
  485057
  486371
  488238
  488897
  489324
  494540
  495491
  495617
  498196
  499872
  502877
  503738
  505538
  509108
  514568
  517493
  518883
  522249
  524075
  525139
  531184
  533218
  541325
  547751
  547779
  548153
  549573
  549662
  553957
  555091
  570994
  575948
  581995
  583739
  592573
  594491
  598213
  604782
  608670
  618196
  630448
  706006
  714188
  718017
  725240
  726057
  729038
  729262
  730099
  730504
  733415
  733433
  734439
  738503
  738519
  739161
  741853
  742133
  744391
  746170
  752570
  752580
  752767
  756746
  756880
  756884
  757315
  759948
  760171
  760172
  764096
  766335
  767303
  767519
  776824
  781756
  786699
  787726
  791406
  794756
  794899
  795027
  795070
  795370
  795950
  796398
  796589
  801842
  827653
]
2.06 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother orgasm"
]
1.84 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.