GET https://search.jues.net/search/embeds/10?q=touch%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.98 ms
(80.98%)
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
  148582
  185249
  213662
  327523
  387097
  390445
  397490
  398542
  398911
  399078
  401379
  403308
  413785
  414762
  424017
  432536
  434087
  441405
  441576
  453315
  458704
  460707
  467701
  467967
  470288
  472623
  473490
  485925
  490291
  490580
  504866
  506302
  507816
  510571
  511781
  512490
  516861
  517811
  521403
  525167
  526699
  527245
  528442
  529804
  530329
  533152
  535613
  536599
  537273
  538146
  538480
  540469
  541737
  541888
  554142
  559895
  563922
  564264
  567053
  573321
  577548
  578466
  579341
  584003
  584985
  590067
  590864
  592923
  594832
  597283
  597533
  601854
  604422
  611033
  615048
  615603
  618266
  618700
  622702
  623876
  625117
  630656
  632063
  635212
  636446
  650146
  651163
  652952
  661680
  662723
  663038
  663695
  665253
  666763
  670850
  671189
  672741
  674369
  675801
  709405
  738985
  745469
  751036
  751791
  752452
  752460
  756914
  757678
  772564
  789780
  802037
  803774
  804268
  804737
  813589
  815546
  815931
  819661
  823938
  824407
]
22.99 ms
(13.40%)
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
  398542
  398911
  813589
  823938
  819661
  824407
  536599
  540469
  529804
  573321
  567053
  516861
  663695
  527245
  413785
  535613
  525167
  651163
  636446
  590067
  618266
  399078
  512490
  590864
  403308
  490291
  526699
  597283
  815546
  530329
  521403
  577548
  672741
  632063
  804268
  752460
  803774
  751036
  757678
  630656
  802037
  387097
  148582
  538480
  541737
  592923
  441405
  424017
  663038
  584985
  414762
  441576
  815931
  665253
  453315
  460707
  507816
  538146
  485925
  559895
  554142
  670850
  662723
  594832
  604422
  601854
  611033
  615603
  615048
  185249
  504866
  541888
  579341
  623876
  327523
  397490
  458704
  473490
  537273
  506302
  666763
  675801
  745469
  432536
  401379
  528442
  510571
  470288
  597533
  467967
  390445
  434087
  467701
  490580
  511781
  517811
  533152
  563922
  564264
  578466
  671189
  709405
  650146
  652952
  661680
  674369
  584003
  625117
  635212
  618700
  804737
  738985
  752452
  756914
  772564
  751791
  622702
  789780
  472623
  213662
]
2.29 ms
(1.34%)
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
  148582
  185249
  213662
  327523
  387097
  390445
  397490
  398542
  398911
  399078
  401379
  403308
  413785
  414762
  424017
  432536
  434087
  441405
  441576
  453315
  458704
  460707
  467701
  467967
  470288
  472623
  473490
  485925
  490291
  490580
  504866
  506302
  507816
  510571
  511781
  512490
  516861
  517811
  521403
  525167
  526699
  527245
  528442
  529804
  530329
  533152
  535613
  536599
  537273
  538146
  538480
  540469
  541737
  541888
  554142
  559895
  563922
  564264
  567053
  573321
  577548
  578466
  579341
  584003
  584985
  590067
  590864
  592923
  594832
  597283
  597533
  601854
  604422
  611033
  615048
  615603
  618266
  618700
  622702
  623876
  625117
  630656
  632063
  635212
  636446
  650146
  651163
  652952
  661680
  662723
  663038
  663695
  665253
  666763
  670850
  671189
  672741
  674369
  675801
  709405
  738985
  745469
  751036
  751791
  752452
  752460
  756914
  757678
  772564
  789780
  802037
  803774
  804268
  804737
  813589
  815546
  815931
  819661
  823938
  824407
]
2.15 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "touch ass"
]
1.75 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трога жоп"
]
1.48 ms
(0.86%)
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.