Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.84 ms
(82.52%)
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
  73571
  388560
  389132
  400697
  411386
  420468
  423947
  424467
  427487
  436440
  439578
  439737
  443045
  444121
  444132
  444142
  444244
  453623
  454147
  454336
  454790
  455844
  457506
  457617
  460898
  461971
  462250
  462538
  464781
  465162
  465345
  465412
  465904
  465933
  466187
  469757
  470597
  470636
  470666
  470765
  471997
  472298
  474098
  474168
  474982
  475843
  477739
  479916
  481303
  482120
  483607
  485955
  486015
  488528
  489635
  490936
  491643
  492645
  496884
  498248
  501426
  505068
  506039
  506486
  506982
  507487
  507749
  512086
  513333
  515824
  521408
  522244
  522363
  523644
  525439
  527270
  527424
  527594
  528607
  543750
  545685
  547764
  550239
  553621
  559736
  560974
  563072
  567677
  570994
  571724
  572321
  574588
  599504
  611422
  623710
  666465
  667162
  682954
  687411
  689161
  698491
  700513
  701914
  718625
  721374
  724586
  741951
  758066
  761796
  761899
  766071
  776577
  781347
  782361
  795621
  796620
  805788
  810326
  819911
  825128
]
15.01 ms
(9.85%)
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
  462538
  570994
  436440
  522244
  73571
  721374
  571724
  547764
  474098
  521408
  486015
  512086
  523644
  461971
  444244
  761899
  465933
  466187
  444142
  560974
  474168
  465412
  462250
  479916
  506486
  505068
  611422
  465904
  482120
  758066
  477739
  490936
  475843
  457506
  506039
  454336
  439737
  525439
  423947
  501426
  469757
  488528
  689161
  470597
  465345
  550239
  761796
  701914
  420468
  527594
  470666
  515824
  795621
  572321
  400697
  805788
  724586
  741951
  513333
  574588
  453623
  718625
  781347
  454790
  567677
  470765
  424467
  489635
  527270
  766071
  825128
  485955
  700513
  776577
  782361
  471997
  389132
  506982
  507487
  559736
  496884
  698491
  411386
  444121
  819911
  491643
  388560
  457617
  527424
  498248
  483607
  599504
  563072
  810326
  507749
  443045
  666465
  623710
  545685
  455844
  465162
  528607
  682954
  687411
  796620
  464781
  454147
  667162
  427487
  553621
  439578
  522363
  470636
  472298
  460898
  492645
  474982
  444132
  481303
  543750
]
4.37 ms
(2.86%)
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
  73571
  388560
  389132
  400697
  411386
  420468
  423947
  424467
  427487
  436440
  439578
  439737
  443045
  444121
  444132
  444142
  444244
  453623
  454147
  454336
  454790
  455844
  457506
  457617
  460898
  461971
  462250
  462538
  464781
  465162
  465345
  465412
  465904
  465933
  466187
  469757
  470597
  470636
  470666
  470765
  471997
  472298
  474098
  474168
  474982
  475843
  477739
  479916
  481303
  482120
  483607
  485955
  486015
  488528
  489635
  490936
  491643
  492645
  496884
  498248
  501426
  505068
  506039
  506486
  506982
  507487
  507749
  512086
  513333
  515824
  521408
  522244
  522363
  523644
  525439
  527270
  527424
  527594
  528607
  543750
  545685
  547764
  550239
  553621
  559736
  560974
  563072
  567677
  570994
  571724
  572321
  574588
  599504
  611422
  623710
  666465
  667162
  682954
  687411
  689161
  698491
  700513
  701914
  718625
  721374
  724586
  741951
  758066
  761796
  761899
  766071
  776577
  781347
  782361
  795621
  796620
  805788
  810326
  819911
  825128
]
2.20 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни реальное русское"
]
1.95 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс любительск русск"
]
1.72 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс любительск русск"
]
1.42 ms
(0.93%)
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.