Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.73 ms
(89.34%)
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
  16971
  404629
  410051
  410254
  411201
  415109
  417801
  419132
  426551
  427447
  428276
  428372
  433074
  433297
  433486
  435443
  436178
  444795
  445416
  445471
  447191
  447785
  448031
  448840
  453032
  453149
  453650
  454210
  454221
  471165
  475304
  478966
  479191
  480752
  480757
  481295
  484692
  489432
  491200
  492097
  492098
  497356
  502043
  508528
  514772
  515142
  516625
  516765
  516769
  517784
  523549
  524792
  525287
  532849
  537773
  538542
  540294
  543772
  545501
  551736
  556045
  559453
  560203
  562282
  564205
  569533
  577371
  587254
  590900
  590908
  592758
  593992
  596431
  598606
  599966
  600076
  604172
  605306
  615756
  623521
  630542
  639712
  639760
  642069
  644250
  646884
  647895
  647905
  650783
  652284
  653870
  653900
  665920
  666528
  674077
  677974
  682839
  684949
  693075
  695175
  697333
  699334
  699621
  713262
  721445
  723480
  724217
  729618
  745550
  756430
  759574
  766843
  773562
  778614
  802123
  809644
  809935
  814736
  818462
  823303
]
14.09 ms
(5.98%)
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
  538542
  818462
  695175
  697333
  745550
  759574
  684949
  590900
  699334
  447191
  448031
  559453
  411201
  454221
  517784
  516765
  478966
  16971
  516625
  497356
  492098
  562282
  646884
  644250
  523549
  647895
  605306
  577371
  650783
  524792
  587254
  592758
  515142
  623521
  809644
  823303
  693075
  814736
  484692
  502043
  417801
  410254
  652284
  516769
  598606
  766843
  433074
  427447
  508528
  556045
  404629
  802123
  809935
  590908
  480757
  677974
  665920
  773562
  615756
  445471
  532849
  647905
  639712
  721445
  778614
  724217
  415109
  428276
  537773
  545501
  666528
  410051
  445416
  454210
  492097
  453032
  569533
  514772
  564205
  642069
  593992
  471165
  435443
  600076
  479191
  489432
  674077
  428372
  540294
  444795
  560203
  653870
  599966
  419132
  604172
  699621
  448840
  551736
  639760
  723480
  630542
  447785
  729618
  453149
  491200
  653900
  682839
  756430
  713262
  433486
  433297
  596431
  453650
  543772
  475304
  481295
  525287
  480752
  436178
  426551
]
4.38 ms
(1.86%)
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
  16971
  404629
  410051
  410254
  411201
  415109
  417801
  419132
  426551
  427447
  428276
  428372
  433074
  433297
  433486
  435443
  436178
  444795
  445416
  445471
  447191
  447785
  448031
  448840
  453032
  453149
  453650
  454210
  454221
  471165
  475304
  478966
  479191
  480752
  480757
  481295
  484692
  489432
  491200
  492097
  492098
  497356
  502043
  508528
  514772
  515142
  516625
  516765
  516769
  517784
  523549
  524792
  525287
  532849
  537773
  538542
  540294
  543772
  545501
  551736
  556045
  559453
  560203
  562282
  564205
  569533
  577371
  587254
  590900
  590908
  592758
  593992
  596431
  598606
  599966
  600076
  604172
  605306
  615756
  623521
  630542
  639712
  639760
  642069
  644250
  646884
  647895
  647905
  650783
  652284
  653870
  653900
  665920
  666528
  674077
  677974
  682839
  684949
  693075
  695175
  697333
  699334
  699621
  713262
  721445
  723480
  724217
  729618
  745550
  756430
  759574
  766843
  773562
  778614
  802123
  809644
  809935
  814736
  818462
  823303
]
1.90 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ffm threesome hardcore"
]
1.78 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жмж секс втро секс втро хардкор"
]
1.31 ms
(0.56%)
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.