Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.40 ms
(58.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончил в рот красотка"
]
121.55 ms
(34.55%)
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
  80801
  101894
  392066
  402963
  408425
  413165
  414692
  417513
  422961
  423322
  424385
  424815
  426551
  428772
  430407
  434655
  439838
  447526
  447913
  448250
  451707
  451712
  452424
  458386
  458788
  459685
  461537
  461808
  462943
  468274
  470524
  471593
  471768
  474713
  480861
  484431
  488867
  491588
  491672
  492339
  493141
  493409
  494199
  494367
  494837
  495212
  497211
  497251
  498909
  499750
  502645
  503072
  504905
  506100
  506299
  507004
  508076
  509614
  511898
  512242
  512427
  513361
  518421
  521334
  521942
  522615
  523532
  526632
  529802
  529842
  542072
  543824
  543829
  545409
  546383
  546439
  550449
  551669
  553359
  554125
  558839
  561684
  563759
  566760
  567910
  568329
  570060
  570089
  571374
  571381
  575979
  576348
  577356
  579320
  581922
  610708
  624081
  636186
  637306
  659698
  671685
  673244
  677848
  686586
  695123
  703589
  704341
  761680
  765130
  766139
  766143
  772813
  777902
  783003
  786635
  789798
  792415
  799045
  807314
]
15.21 ms
(4.32%)
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
  80801
  459685
  414692
  522615
  497251
  494837
  686586
  761680
  417513
  567910
  470524
  494367
  512427
  488867
  551669
  480861
  101894
  428772
  413165
  451707
  491588
  493141
  543829
  581922
  543824
  546383
  579320
  554125
  576348
  561684
  571381
  408425
  439838
  461537
  422961
  471768
  424815
  461808
  509614
  513361
  521942
  526806
  491672
  499750
  504905
  492339
  545409
  426551
  518421
  671685
  434655
  507004
  521334
  577356
  529802
  529842
  659698
  677848
  703589
  636186
  610708
  624081
  777902
  783003
  789798
  792415
  807314
  765130
  766139
  772813
  799045
  402963
  423322
  452424
  474713
  546439
  570089
  571374
  786635
  766143
  704341
  392066
  451712
  458386
  503072
  512242
  494199
  637306
  575979
  484431
  448250
  506100
  424385
  566760
  568329
  558839
  673244
  458788
  462943
  468274
  502645
  695123
  447913
  553359
  563759
  550449
  570060
  471593
  430407
  447526
  508076
  495212
  526632
  498909
  493409
  497211
  506299
  511898
  523532
  542072
]
2.49 ms
(0.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
  80801
  101894
  392066
  402963
  408425
  413165
  414692
  417513
  422961
  423322
  424385
  424815
  426551
  428772
  430407
  434655
  439838
  447526
  447913
  448250
  451707
  451712
  452424
  458386
  458788
  459685
  461537
  461808
  462943
  468274
  470524
  471593
  471768
  474713
  480861
  484431
  488867
  491588
  491672
  492339
  493141
  493409
  494199
  494367
  494837
  495212
  497211
  497251
  498909
  499750
  502645
  503072
  504905
  506100
  506299
  507004
  508076
  509614
  511898
  512242
  512427
  513361
  518421
  521334
  521942
  522615
  523532
  526632
  529802
  529842
  542072
  543824
  543829
  545409
  546383
  546439
  550449
  551669
  553359
  554125
  558839
  561684
  563759
  566760
  567910
  568329
  570060
  570089
  571374
  571381
  575979
  576348
  577356
  579320
  581922
  610708
  624081
  636186
  637306
  659698
  671685
  673244
  677848
  686586
  695123
  703589
  704341
  761680
  765130
  766139
  766143
  772813
  777902
  783003
  786635
  789798
  792415
  799045
  807314
]
1.88 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в рот красивая"
]
1.65 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.