GET https://search.jues.net/search/embeds/8?q=hot%20solo%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.86 ms
(84.33%)
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
  411255
  414042
  414119
  414138
  418594
  418720
  418817
  419452
  420515
  420816
  426399
  429608
  429905
  430267
  437867
  438052
  439249
  441049
  444921
  447315
  450287
  452885
  453213
  455608
  457622
  458007
  469223
  469327
  469737
  471148
  472266
  476321
  477506
  478991
  479936
  480119
  485472
  487008
  493258
  495507
  495566
  498114
  499365
  505891
  506228
  507766
  508891
  514621
  516601
  519354
  525729
  526531
  526536
  527180
  527442
  528407
  529154
  531594
  532531
  534169
  536393
  541418
  541839
  553208
  553726
  554235
  554526
  555657
  556202
  558132
  558160
  561919
  563108
  564643
  567071
  567780
  567798
  568264
  570393
  577888
  578718
  579519
  580223
  581873
  583134
  585338
  589685
  590102
  591394
  593292
  594262
  595016
  596857
  597645
  597750
  601806
  604153
  604865
  605266
  605742
  615428
  615918
  621759
  624834
  626066
  628617
  632169
  637245
  643542
  644276
  684666
  684681
  704218
  741764
  770397
  770405
  773257
  792088
  804104
  814434
]
15.50 ms
(10.06%)
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
  563108
  578718
  704218
  684666
  568264
  597645
  621759
  637245
  605266
  438052
  453213
  472266
  493258
  479936
  597750
  447315
  441049
  553208
  558132
  596857
  499365
  814434
  450287
  457622
  469737
  476321
  478991
  528407
  534169
  485472
  487008
  558160
  589685
  615428
  626066
  628617
  770405
  773257
  741764
  429905
  418720
  519354
  507766
  498114
  471148
  444921
  429608
  525729
  508891
  601806
  458007
  414119
  480119
  553726
  570393
  556202
  567071
  583134
  643542
  585338
  792088
  418817
  439249
  452885
  495507
  506228
  514621
  564643
  580223
  644276
  632169
  541839
  420816
  418594
  455608
  469327
  590102
  594262
  605742
  804104
  469223
  516601
  527180
  529154
  577888
  526536
  419452
  430267
  437867
  531594
  579519
  595016
  770397
  414138
  414042
  532531
  604153
  536393
  567798
  541418
  604865
  420515
  527442
  495566
  581873
  411255
  477506
  554235
  561919
  555657
  684681
  593292
  567780
  624834
  615918
  426399
  505891
  591394
  526531
  554526
]
2.43 ms
(1.58%)
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
  411255
  414042
  414119
  414138
  418594
  418720
  418817
  419452
  420515
  420816
  426399
  429608
  429905
  430267
  437867
  438052
  439249
  441049
  444921
  447315
  450287
  452885
  453213
  455608
  457622
  458007
  469223
  469327
  469737
  471148
  472266
  476321
  477506
  478991
  479936
  480119
  485472
  487008
  493258
  495507
  495566
  498114
  499365
  505891
  506228
  507766
  508891
  514621
  516601
  519354
  525729
  526531
  526536
  527180
  527442
  528407
  529154
  531594
  532531
  534169
  536393
  541418
  541839
  553208
  553726
  554235
  554526
  555657
  556202
  558132
  558160
  561919
  563108
  564643
  567071
  567780
  567798
  568264
  570393
  577888
  578718
  579519
  580223
  581873
  583134
  585338
  589685
  590102
  591394
  593292
  594262
  595016
  596857
  597645
  597750
  601806
  604153
  604865
  605266
  605742
  615428
  615918
  621759
  624834
  626066
  628617
  632169
  637245
  643542
  644276
  684666
  684681
  704218
  741764
  770397
  770405
  773257
  792088
  804104
  814434
]
1.65 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot соло жоп"
]
1.62 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot solo ass"
]
1.56 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot соло жоп"
]

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.