Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.19 ms
(84.37%)
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
  389474
  390518
  397766
  399568
  401674
  442171
  444127
  447478
  453625
  460684
  469890
  470322
  473981
  474007
  474955
  475143
  477398
  482085
  482840
  484667
  484731
  492609
  495706
  495741
  497568
  501382
  501756
  521925
  544064
  548727
  548796
  549778
  559644
  559716
  560319
  566780
  570505
  570627
  574878
  575086
  576165
  596604
  598176
  598538
  598557
  598783
  600073
  602859
  620563
  621394
  622349
  627118
  651934
  651944
  652245
  652617
  652853
  652877
  652895
  657023
  661262
  677003
  677407
  678557
  678561
  678579
  678588
  679050
  679058
  692584
  694639
  696748
  701051
  701495
  703505
  708134
  709295
  716406
  718655
  720774
  720778
  720799
  721203
  721569
  721796
  721837
  721843
  723481
  723603
  723609
  729328
  730210
  736151
  740594
  741125
  741127
  741476
  742046
  742158
  744246
  751618
  751646
  757544
  758404
  759548
  768571
  776280
  776316
  776396
  784142
  787716
  788443
  792515
  807439
  807462
  809620
  809651
  814320
  814488
  821837
]
17.53 ms
(9.91%)
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
  730210
  742046
  492609
  495741
  678579
  679058
  720799
  598783
  621394
  622349
  598557
  751646
  759548
  696748
  821837
  652617
  651934
  651944
  570627
  620563
  807462
  809651
  598176
  776396
  560319
  576165
  661262
  600073
  399568
  495706
  447478
  460684
  473981
  544064
  474955
  548796
  575086
  484731
  574878
  482840
  501382
  482085
  484667
  549778
  397766
  521925
  677407
  792515
  807439
  559716
  444127
  475143
  721203
  758404
  814320
  652853
  720774
  652877
  776280
  751618
  627118
  701051
  721569
  716406
  701495
  708134
  453625
  497568
  596604
  474007
  470322
  477398
  721796
  723481
  720778
  652245
  657023
  718655
  602859
  787716
  788443
  741125
  742158
  721837
  401674
  390518
  442171
  723609
  559644
  678588
  548727
  570505
  709295
  389474
  469890
  501756
  814488
  723603
  566780
  678557
  677003
  679050
  652895
  678561
  692584
  694639
  598538
  776316
  741127
  768571
  784142
  809620
  741476
  757544
  729328
  744246
  736151
  740594
  703505
  721843
]
3.19 ms
(1.81%)
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
  389474
  390518
  397766
  399568
  401674
  442171
  444127
  447478
  453625
  460684
  469890
  470322
  473981
  474007
  474955
  475143
  477398
  482085
  482840
  484667
  484731
  492609
  495706
  495741
  497568
  501382
  501756
  521925
  544064
  548727
  548796
  549778
  559644
  559716
  560319
  566780
  570505
  570627
  574878
  575086
  576165
  596604
  598176
  598538
  598557
  598783
  600073
  602859
  620563
  621394
  622349
  627118
  651934
  651944
  652245
  652617
  652853
  652877
  652895
  657023
  661262
  677003
  677407
  678557
  678561
  678579
  678588
  679050
  679058
  692584
  694639
  696748
  701051
  701495
  703505
  708134
  709295
  716406
  718655
  720774
  720778
  720799
  721203
  721569
  721796
  721837
  721843
  723481
  723603
  723609
  729328
  730210
  736151
  740594
  741125
  741127
  741476
  742046
  742158
  744246
  751618
  751646
  757544
  758404
  759548
  768571
  776280
  776316
  776396
  784142
  787716
  788443
  792515
  807439
  807462
  809620
  809651
  814320
  814488
  821837
]
1.96 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "руское мжж"
]
1.80 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жмж секс втро"
]
1.61 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.