GET https://search.jues.net/search/embeds/6?q=anal%20white

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.38 ms
(87.62%)
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
  17250
  81214
  93524
  100642
  282099
  321806
  338225
  381984
  384317
  385228
  386701
  387852
  388780
  388912
  389239
  389979
  390042
  392632
  393080
  393108
  393151
  393881
  394154
  395710
  396110
  396201
  399632
  400679
  401109
  401303
  402226
  402255
  403904
  404343
  404690
  406361
  408009
  408489
  409805
  410374
  410663
  411451
  412015
  415191
  416258
  417389
  418685
  429353
  432679
  440817
  441072
  441958
  478357
  478895
  490964
  492122
  515506
  522949
  523893
  525078
  527189
  530465
  531277
  531667
  533303
  537229
  538536
  538582
  538810
  539361
  540276
  542881
  547862
  601221
  602109
  630711
  688108
  700760
  705640
  710250
  723159
  724052
  727780
  730038
  731084
  735688
  737516
  737553
  738124
  738816
  741067
  743085
  744662
  745959
  747384
  747407
  748524
  749867
  750228
  752708
  752731
  755188
  755427
  756002
  756081
  756095
  756118
  756462
  760915
  761758
  762199
  762909
  763425
  763939
  766844
  766862
  791729
  791858
  820901
  828873
]
14.31 ms
(7.58%)
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
  710250
  723159
  737553
  741067
  745959
  752708
  756002
  756095
  756462
  761758
  737516
  755427
  756118
  760915
  724052
  727780
  755188
  762199
  730038
  731084
  766844
  738816
  747384
  747407
  756081
  602109
  700760
  705640
  791858
  415191
  387852
  389979
  390042
  396201
  402226
  429353
  282099
  401303
  402255
  93524
  410663
  478895
  408489
  515506
  523893
  492122
  527189
  688108
  522949
  393151
  393881
  338225
  381984
  820901
  828873
  478357
  533303
  538810
  531277
  537229
  525078
  539361
  540276
  530465
  531667
  538536
  542881
  547862
  601221
  630711
  791729
  743085
  748524
  749867
  735688
  750228
  763425
  763939
  752731
  762909
  766862
  738124
  744662
  384317
  395710
  538582
  490964
  386701
  385228
  100642
  394154
  393080
  393108
  392632
  321806
  17250
  81214
  388912
  389239
  388780
  396110
  400679
  399632
  401109
  404690
  406361
  403904
  404343
  418685
  441072
  409805
  410374
  417389
  432679
  408009
  412015
  416258
  411451
  440817
  441958
]
3.38 ms
(1.79%)
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
  17250
  81214
  93524
  100642
  282099
  321806
  338225
  381984
  384317
  385228
  386701
  387852
  388780
  388912
  389239
  389979
  390042
  392632
  393080
  393108
  393151
  393881
  394154
  395710
  396110
  396201
  399632
  400679
  401109
  401303
  402226
  402255
  403904
  404343
  404690
  406361
  408009
  408489
  409805
  410374
  410663
  411451
  412015
  415191
  416258
  417389
  418685
  429353
  432679
  440817
  441072
  441958
  478357
  478895
  490964
  492122
  515506
  522949
  523893
  525078
  527189
  530465
  531277
  531667
  533303
  537229
  538536
  538582
  538810
  539361
  540276
  542881
  547862
  601221
  602109
  630711
  688108
  700760
  705640
  710250
  723159
  724052
  727780
  730038
  731084
  735688
  737516
  737553
  738124
  738816
  741067
  743085
  744662
  745959
  747384
  747407
  748524
  749867
  750228
  752708
  752731
  755188
  755427
  756002
  756081
  756095
  756118
  756462
  760915
  761758
  762199
  762909
  763425
  763939
  766844
  766862
  791729
  791858
  820901
  828873
]
1.55 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal white"
]
1.41 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал white"
]
1.18 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал white"
]

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.