Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.50 ms
(88.21%)
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
  148814
  383238
  401628
  411183
  412779
  414067
  415965
  415981
  415992
  416037
  416501
  416515
  416525
  416600
  416621
  416666
  416715
  419633
  419816
  421759
  421971
  422101
  428305
  428742
  430261
  430347
  432246
  432274
  437859
  439117
  439150
  439218
  439240
  439320
  439359
  439960
  441032
  441095
  446641
  447160
  448108
  448551
  448588
  448642
  448773
  449008
  452375
  452567
  454641
  460378
  460384
  466745
  466842
  467110
  469615
  475405
  477245
  480203
  482731
  483691
  486829
  493687
  496725
  502767
  505327
  510573
  512363
  523393
  540032
  540990
  545369
  545376
  545426
  552401
  558519
  564237
  576139
  582579
  583377
  584351
  594113
  595249
  595517
  603362
  614966
  614975
  618514
  623333
  629287
  639481
  661424
  666355
  675858
  688980
  692743
  700257
  701291
  709128
  713858
  737052
  750637
  751424
  755079
  768244
  775709
  776059
  782872
  785558
  785577
  785591
  785614
  787075
  787508
  792089
  799937
  803557
  804195
  806580
  810962
  814443
]
14.33 ms
(7.33%)
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
  768244
  639481
  701291
  713858
  775709
  782872
  785577
  792089
  804195
  148814
  383238
  421759
  428742
  430347
  439240
  688980
  466842
  505327
  460378
  466745
  576139
  582579
  558519
  595517
  750637
  787508
  448588
  452375
  460384
  421971
  422101
  480203
  448642
  411183
  512363
  523393
  496725
  432246
  419633
  448551
  454641
  467110
  482731
  700257
  401628
  412779
  477245
  428305
  416037
  441095
  416666
  432274
  415992
  416515
  416621
  416715
  439150
  416525
  441032
  415965
  814443
  475405
  447160
  540032
  510573
  540990
  564237
  545369
  584351
  583377
  692743
  661424
  666355
  545426
  603362
  614966
  629287
  594113
  595249
  623333
  776059
  785614
  799937
  803557
  810962
  737052
  755079
  787075
  751424
  709128
  785558
  437859
  439117
  416501
  416600
  430261
  439320
  415981
  439359
  448108
  469615
  483691
  493687
  502767
  552401
  449008
  439960
  448773
  545376
  614975
  806580
  486829
  414067
  675858
  618514
  785591
  446641
  452567
  419816
  439218
]
2.34 ms
(1.20%)
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
  148814
  383238
  401628
  411183
  412779
  414067
  415965
  415981
  415992
  416037
  416501
  416515
  416525
  416600
  416621
  416666
  416715
  419633
  419816
  421759
  421971
  422101
  428305
  428742
  430261
  430347
  432246
  432274
  437859
  439117
  439150
  439218
  439240
  439320
  439359
  439960
  441032
  441095
  446641
  447160
  448108
  448551
  448588
  448642
  448773
  449008
  452375
  452567
  454641
  460378
  460384
  466745
  466842
  467110
  469615
  475405
  477245
  480203
  482731
  483691
  486829
  493687
  496725
  502767
  505327
  510573
  512363
  523393
  540032
  540990
  545369
  545376
  545426
  552401
  558519
  564237
  576139
  582579
  583377
  584351
  594113
  595249
  595517
  603362
  614966
  614975
  618514
  623333
  629287
  639481
  661424
  666355
  675858
  688980
  692743
  700257
  701291
  709128
  713858
  737052
  750637
  751424
  755079
  768244
  775709
  776059
  782872
  785558
  785577
  785591
  785614
  787075
  787508
  792089
  799937
  803557
  804195
  806580
  810962
  814443
]
2.08 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen webcam dildo"
]
1.59 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen вебкамер дилд"
]
1.52 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.21 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen вебкамер дилд"
]

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.