Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.88 ms
(53.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother orgasm"
]
159.32 ms
(40.44%)
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
  383484
  418879
  425592
  428685
  429900
  438655
  453702
  459634
  467893
  473369
  473535
  486775
  492016
  494068
  501322
  503999
  504339
  505061
  506350
  506584
  506914
  513450
  516039
  518014
  521798
  521799
  525310
  528541
  534828
  534925
  535847
  539078
  542181
  548085
  550576
  550859
  551525
  554930
  555390
  555560
  564889
  566788
  571726
  579218
  579319
  580355
  584118
  594989
  597660
  603897
  605742
  606197
  606601
  607288
  608215
  609057
  609083
  609696
  613109
  616072
  616397
  618589
  622527
  627414
  629629
  636477
  636493
  637186
  642022
  643380
  646084
  648918
  657781
  678834
  689897
  692733
  698156
  709524
  710161
  710849
  713031
  713749
  728187
  732771
  733155
  738247
  744952
  746748
  748620
  748626
  750603
  751329
  756273
  756658
  761218
  768517
  771213
  785148
  788655
  789023
  789848
  791921
  792996
  793218
  794212
  794416
  794437
  794453
  795825
  796384
  801841
  802267
  808573
  810070
  811816
  813206
  813720
  816691
  824473
  826601
]
15.49 ms
(3.93%)
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
  642022
  605742
  467893
  506350
  516039
  521798
  551525
  418879
  453702
  826601
  813720
  459634
  492016
  501322
  534828
  534925
  506584
  521799
  528541
  535847
  513450
  525310
  539078
  579319
  550576
  550859
  555560
  542181
  564889
  692733
  710849
  698156
  646084
  657781
  678834
  713031
  713749
  597660
  616397
  627414
  637186
  606601
  609696
  636477
  636493
  613109
  622527
  629629
  788655
  789023
  794453
  801841
  802267
  795825
  733155
  744952
  789848
  796384
  810070
  813206
  732771
  748620
  761218
  748626
  768517
  728187
  738247
  746748
  751329
  616072
  793218
  794212
  794437
  811816
  425592
  383484
  503999
  429900
  438655
  824473
  816691
  473369
  473535
  494068
  504339
  505061
  506914
  518014
  584118
  580355
  555390
  648918
  689897
  548085
  579218
  607288
  594989
  643380
  606197
  608215
  785148
  794416
  792996
  808573
  771213
  756273
  756658
  750603
  603897
  618589
  791921
  428685
  486775
  571726
  554930
  566788
  709524
  710161
  609057
  609083
]
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
  383484
  418879
  425592
  428685
  429900
  438655
  453702
  459634
  467893
  473369
  473535
  486775
  492016
  494068
  501322
  503999
  504339
  505061
  506350
  506584
  506914
  513450
  516039
  518014
  521798
  521799
  525310
  528541
  534828
  534925
  535847
  539078
  542181
  548085
  550576
  550859
  551525
  554930
  555390
  555560
  564889
  566788
  571726
  579218
  579319
  580355
  584118
  594989
  597660
  603897
  605742
  606197
  606601
  607288
  608215
  609057
  609083
  609696
  613109
  616072
  616397
  618589
  622527
  627414
  629629
  636477
  636493
  637186
  642022
  643380
  646084
  648918
  657781
  678834
  689897
  692733
  698156
  709524
  710161
  710849
  713031
  713749
  728187
  732771
  733155
  738247
  744952
  746748
  748620
  748626
  750603
  751329
  756273
  756658
  761218
  768517
  771213
  785148
  788655
  789023
  789848
  791921
  792996
  793218
  794212
  794416
  794437
  794453
  795825
  796384
  801841
  802267
  808573
  810070
  811816
  813206
  813720
  816691
  824473
  826601
]
1.81 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин orgasm"
]
1.46 ms
(0.37%)
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.