Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.24 ms
(87.40%)
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
  402772
  417821
  418512
  419173
  429129
  437638
  445567
  456234
  463281
  470750
  473803
  474764
  477949
  483051
  483312
  496576
  497317
  504461
  508828
  509493
  516993
  516994
  520463
  521900
  524525
  527315
  529048
  530245
  531910
  536779
  545520
  547911
  548690
  549048
  549079
  551455
  552921
  554001
  557432
  560178
  560973
  561001
  562120
  562190
  562284
  565559
  565819
  566059
  567096
  567297
  567379
  568404
  568701
  569466
  570721
  572954
  574494
  574680
  578834
  578972
  581532
  587791
  588726
  590423
  591309
  594981
  599261
  600510
  601313
  602486
  604329
  606633
  609240
  610121
  612055
  619120
  620115
  621895
  662502
  664630
  697639
  699104
  724896
  735254
  738268
  755233
  756488
  758892
  764050
  764511
  764570
  768228
  777980
  782568
  782695
  782983
  783259
  784230
  789582
  789912
  795491
  807661
  814641
  815068
  815089
  817331
  818101
  819208
  819272
  820444
  820565
  821537
  821609
  821991
  822303
  822701
  823494
  823528
  825462
  825714
]
15.02 ms
(7.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
  531910
  508828
  504461
  560178
  562190
  567379
  557432
  570721
  574494
  581532
  545520
  566059
  567096
  578834
  587791
  590423
  600510
  565559
  554001
  497317
  516993
  536779
  429129
  819272
  529048
  548690
  549048
  562120
  568701
  547911
  549079
  561001
  569466
  578972
  664630
  562284
  610121
  601313
  604329
  606633
  612055
  588726
  591309
  594981
  599261
  602486
  620115
  724896
  699104
  565819
  818101
  820444
  822701
  825462
  782983
  795491
  789582
  789912
  764050
  758892
  764570
  784230
  483312
  477949
  437638
  509493
  483051
  820565
  821991
  822303
  821537
  823494
  814641
  815068
  821609
  823528
  825714
  530245
  496576
  521900
  551455
  662502
  609240
  777980
  783259
  807661
  768228
  735254
  738268
  755233
  756488
  621895
  697639
  782568
  782695
  764511
  456234
  470750
  474764
  560973
  619120
  445567
  473803
  815089
  418512
  574680
  524525
  527315
  520463
  568404
  572954
  552921
  516994
  419173
  463281
  417821
  567297
  402772
  817331
  819208
]
2.32 ms
(1.21%)
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
  402772
  417821
  418512
  419173
  429129
  437638
  445567
  456234
  463281
  470750
  473803
  474764
  477949
  483051
  483312
  496576
  497317
  504461
  508828
  509493
  516993
  516994
  520463
  521900
  524525
  527315
  529048
  530245
  531910
  536779
  545520
  547911
  548690
  549048
  549079
  551455
  552921
  554001
  557432
  560178
  560973
  561001
  562120
  562190
  562284
  565559
  565819
  566059
  567096
  567297
  567379
  568404
  568701
  569466
  570721
  572954
  574494
  574680
  578834
  578972
  581532
  587791
  588726
  590423
  591309
  594981
  599261
  600510
  601313
  602486
  604329
  606633
  609240
  610121
  612055
  619120
  620115
  621895
  662502
  664630
  697639
  699104
  724896
  735254
  738268
  755233
  756488
  758892
  764050
  764511
  764570
  768228
  777980
  782568
  782695
  782983
  783259
  784230
  789582
  789912
  795491
  807661
  814641
  815068
  815089
  817331
  818101
  819208
  819272
  820444
  820565
  821537
  821609
  821991
  822303
  822701
  823494
  823528
  825462
  825714
]
2.06 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small dick pov"
]
1.66 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая член пов"
]
1.59 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.76%)
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.