Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.04 ms
(85.76%)
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
  362588
  382141
  403618
  405831
  411488
  414077
  415874
  415877
  415961
  416508
  416600
  416648
  416681
  416696
  416703
  419832
  420630
  424107
  426301
  427027
  428375
  428753
  430262
  430350
  430366
  431960
  432681
  443340
  444180
  444531
  445077
  446986
  447352
  449985
  452574
  454745
  455980
  458115
  467568
  471987
  475189
  475419
  476699
  476784
  477246
  479544
  481231
  481952
  482280
  482283
  483705
  493825
  493849
  497609
  498200
  498483
  498915
  500525
  502559
  505630
  506092
  508891
  512550
  513015
  515330
  516035
  517304
  520907
  521831
  525399
  525738
  526163
  529069
  536236
  543856
  545677
  548873
  552699
  552706
  559191
  561977
  565298
  566545
  569594
  569603
  569613
  570911
  571222
  572774
  576128
  598406
  598971
  601696
  618931
  623268
  623281
  623870
  645889
  668297
  700259
  718678
  722405
  750565
  751509
  766174
  767255
  782054
  783044
  790461
  793146
  803615
  805120
  806636
  808468
  810962
  817185
  820787
  821554
  822571
  824929
]
15.68 ms
(8.96%)
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
  552699
  424107
  476699
  449985
  545677
  570911
  623870
  428375
  481231
  432681
  454745
  506092
  497609
  498200
  502559
  751509
  445077
  521831
  598406
  415874
  427027
  362588
  500525
  515330
  476784
  561977
  565298
  569594
  571222
  598971
  475419
  405831
  455980
  411488
  419832
  428753
  444180
  446986
  493849
  513015
  525738
  403618
  821554
  505630
  543856
  566545
  420630
  430262
  416681
  508891
  576128
  718678
  569613
  482283
  414077
  430366
  477246
  806636
  793146
  766174
  767255
  572774
  512550
  808468
  618931
  430350
  416703
  416648
  444531
  415877
  416696
  467568
  482280
  483705
  458115
  493825
  517304
  529069
  479544
  559191
  548873
  552706
  601696
  805120
  382141
  416508
  443340
  475189
  426301
  415961
  447352
  498483
  498915
  569603
  810962
  416600
  452574
  431960
  481952
  520907
  525399
  516035
  471987
  722405
  700259
  783044
  782054
  803615
  750565
  790461
  824929
  820787
  822571
  817185
  536236
  526163
  668297
  645889
  623268
  623281
]
2.63 ms
(1.50%)
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
  362588
  382141
  403618
  405831
  411488
  414077
  415874
  415877
  415961
  416508
  416600
  416648
  416681
  416696
  416703
  419832
  420630
  424107
  426301
  427027
  428375
  428753
  430262
  430350
  430366
  431960
  432681
  443340
  444180
  444531
  445077
  446986
  447352
  449985
  452574
  454745
  455980
  458115
  467568
  471987
  475189
  475419
  476699
  476784
  477246
  479544
  481231
  481952
  482280
  482283
  483705
  493825
  493849
  497609
  498200
  498483
  498915
  500525
  502559
  505630
  506092
  508891
  512550
  513015
  515330
  516035
  517304
  520907
  521831
  525399
  525738
  526163
  529069
  536236
  543856
  545677
  548873
  552699
  552706
  559191
  561977
  565298
  566545
  569594
  569603
  569613
  570911
  571222
  572774
  576128
  598406
  598971
  601696
  618931
  623268
  623281
  623870
  645889
  668297
  700259
  718678
  722405
  750565
  751509
  766174
  767255
  782054
  783044
  790461
  793146
  803615
  805120
  806636
  808468
  810962
  817185
  820787
  821554
  822571
  824929
]
2.18 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful masturbation dildo"
]
1.68 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая мастурбац дилд"
]
1.49 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.71%)
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.