Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.36 ms
(85.47%)
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
  28568
  187542
  282542
  325867
  382579
  392971
  393350
  393550
  414720
  427543
  441424
  463868
  506257
  518366
  531175
  541359
  552748
  564301
  601102
  604186
  604303
  607261
  624209
  629174
  634138
  635339
  646211
  652927
  656085
  656615
  657230
  660714
  661411
  668091
  671594
  672629
  678813
  680284
  698124
  710909
  715124
  715396
  715657
  719524
  720682
  720768
  720811
  723934
  726176
  726217
  728735
  728762
  729835
  731280
  734990
  736336
  737643
  738021
  748434
  752148
  752545
  752717
  754584
  759796
  760481
  762228
  766776
  766785
  766800
  769749
  769754
  769822
  770306
  771352
  773268
  773421
  773751
  777132
  778850
  779681
  779730
  780849
  781341
  781368
  782544
  782573
  783345
  783618
  786199
  788661
  788912
  790531
  790548
  791216
  791506
  791849
  793138
  793449
  794859
  794877
  794908
  796920
  800903
  801297
  802152
  804550
  810323
  811148
  811655
  812049
  812094
  814502
  816679
  816985
  817215
  819719
  821136
  823611
  827685
  827966
]
13.41 ms
(8.53%)
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
  564301
  778850
  414720
  531175
  814502
  791216
  782573
  187542
  392971
  783618
  821136
  601102
  541359
  766785
  810323
  715657
  816679
  646211
  720811
  759796
  734990
  760481
  827966
  710909
  790548
  769822
  819719
  652927
  788912
  794859
  552748
  779730
  726217
  773421
  794908
  427543
  325867
  656615
  698124
  661411
  729835
  518366
  800903
  719524
  780849
  794877
  769754
  604303
  770306
  766776
  802152
  28568
  393550
  393350
  816985
  823611
  827685
  817215
  790531
  726176
  728762
  773268
  754584
  656085
  660714
  678813
  812094
  752545
  811655
  801297
  791506
  748434
  779681
  796920
  680284
  728735
  441424
  786199
  781341
  657230
  624209
  737643
  782544
  736336
  738021
  635339
  791849
  793138
  629174
  762228
  723934
  672629
  771352
  773751
  720682
  811148
  752717
  668091
  766800
  804550
  781368
  788661
  793449
  731280
  715396
  720768
  783345
  752148
  604186
  715124
  634138
  607261
  671594
  777132
  282542
  769749
  463868
  506257
  382579
  812049
]
2.90 ms
(1.85%)
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
  28568
  187542
  282542
  325867
  382579
  392971
  393350
  393550
  414720
  427543
  441424
  463868
  506257
  518366
  531175
  541359
  552748
  564301
  601102
  604186
  604303
  607261
  624209
  629174
  634138
  635339
  646211
  652927
  656085
  656615
  657230
  660714
  661411
  668091
  671594
  672629
  678813
  680284
  698124
  710909
  715124
  715396
  715657
  719524
  720682
  720768
  720811
  723934
  726176
  726217
  728735
  728762
  729835
  731280
  734990
  736336
  737643
  738021
  748434
  752148
  752545
  752717
  754584
  759796
  760481
  762228
  766776
  766785
  766800
  769749
  769754
  769822
  770306
  771352
  773268
  773421
  773751
  777132
  778850
  779681
  779730
  780849
  781341
  781368
  782544
  782573
  783345
  783618
  786199
  788661
  788912
  790531
  790548
  791216
  791506
  791849
  793138
  793449
  794859
  794877
  794908
  796920
  800903
  801297
  802152
  804550
  810323
  811148
  811655
  812049
  812094
  814502
  816679
  816985
  817215
  819719
  821136
  823611
  827685
  827966
]
1.77 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard anal sex"
]
1.73 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard анал секс"
]
1.54 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard анал секс"
]

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.