Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.46 ms
(87.64%)
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
  205910
  382803
  386276
  390736
  393727
  393759
  398390
  400718
  400864
  402160
  403678
  418286
  419559
  421762
  423322
  425061
  425656
  433635
  434488
  439006
  439396
  444366
  445099
  451705
  453790
  454863
  463232
  467321
  467673
  477322
  478879
  481773
  483725
  483918
  484216
  486632
  486846
  486933
  504727
  509329
  510530
  510586
  519967
  523061
  524273
  542133
  548982
  556144
  560498
  579528
  580155
  580402
  585596
  587967
  592114
  592946
  593634
  594108
  595231
  599729
  600933
  607073
  607631
  612509
  614094
  618670
  622521
  626461
  638033
  660462
  661593
  677524
  679858
  682328
  683089
  684012
  684335
  702521
  713872
  722731
  736738
  739792
  741035
  746084
  746618
  749582
  756088
  759567
  759578
  763062
  763327
  767957
  767964
  768687
  772684
  775538
  777007
  779973
  780925
  782646
  783617
  784716
  784806
  784969
  785195
  785462
  787619
  789863
  789888
  792056
  799722
  805044
  806866
  807591
  811146
  814122
  817200
  818067
  820106
  827776
]
14.22 ms
(7.40%)
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
  579528
  779973
  741035
  433635
  775538
  763327
  423322
  444366
  600933
  784969
  789863
  805044
  746084
  785462
  421762
  661593
  592114
  787619
  817200
  523061
  595231
  736738
  626461
  400718
  483918
  580402
  702521
  783617
  739792
  614094
  486933
  478879
  402160
  439006
  607073
  679858
  713872
  585596
  418286
  684335
  792056
  807591
  612509
  811146
  542133
  445099
  481773
  780925
  818067
  782646
  398390
  820106
  806866
  827776
  504727
  785195
  746618
  382803
  486632
  684012
  400864
  386276
  393759
  756088
  439396
  677524
  682328
  205910
  767957
  548982
  722731
  789888
  767964
  814122
  580155
  618670
  599729
  784716
  784806
  509329
  638033
  403678
  483725
  434488
  560498
  660462
  593634
  594108
  592946
  454863
  510530
  390736
  477322
  607631
  777007
  799722
  768687
  463232
  393727
  484216
  425061
  759567
  759578
  749582
  486846
  519967
  772684
  510586
  467321
  587967
  622521
  524273
  556144
  683089
  763062
  467673
  419559
  425656
  451705
  453790
]
2.86 ms
(1.49%)
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
  205910
  382803
  386276
  390736
  393727
  393759
  398390
  400718
  400864
  402160
  403678
  418286
  419559
  421762
  423322
  425061
  425656
  433635
  434488
  439006
  439396
  444366
  445099
  451705
  453790
  454863
  463232
  467321
  467673
  477322
  478879
  481773
  483725
  483918
  484216
  486632
  486846
  486933
  504727
  509329
  510530
  510586
  519967
  523061
  524273
  542133
  548982
  556144
  560498
  579528
  580155
  580402
  585596
  587967
  592114
  592946
  593634
  594108
  595231
  599729
  600933
  607073
  607631
  612509
  614094
  618670
  622521
  626461
  638033
  660462
  661593
  677524
  679858
  682328
  683089
  684012
  684335
  702521
  713872
  722731
  736738
  739792
  741035
  746084
  746618
  749582
  756088
  759567
  759578
  763062
  763327
  767957
  767964
  768687
  772684
  775538
  777007
  779973
  780925
  782646
  783617
  784716
  784806
  784969
  785195
  785462
  787619
  789863
  789888
  792056
  799722
  805044
  806866
  807591
  811146
  814122
  817200
  818067
  820106
  827776
]
1.73 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "daddy секс девушк"
]
1.72 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "daddy sex girls"
]
1.59 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "daddy секс девушк"
]

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.