GET https://search.jues.net/search/embeds/6?q=close%20up%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.43 ms
(86.91%)
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
  398233
  401611
  486144
  486146
  494972
  507271
  513570
  540924
  546836
  560003
  577000
  586432
  588915
  607976
  613943
  615191
  617259
  625935
  628921
  629639
  630419
  636893
  638480
  641522
  644205
  698910
  702910
  706763
  711416
  714400
  715571
  716952
  716991
  719083
  719152
  720581
  721652
  722125
  724923
  725020
  726313
  727500
  734448
  734759
  737891
  740892
  741673
  742914
  743989
  745205
  746433
  748485
  758769
  760266
  760888
  764609
  765405
  767867
  768622
  768635
  768693
  769089
  770340
  771941
  772354
  772361
  774654
  775168
  776067
  776079
  778475
  778641
  780229
  780257
  781142
  781537
  782098
  782525
  782656
  784625
  785672
  785796
  786008
  786855
  787229
  789547
  790577
  790732
  791888
  791890
  792249
  792348
  796034
  796370
  796386
  796393
  796411
  798331
  798503
  799758
  800165
  802285
  803310
  803423
  803432
  803439
  803782
  804035
  804711
  805561
  808199
  812032
  813611
  814658
  824329
  824799
  824842
  825030
  825305
  826844
]
13.07 ms
(7.22%)
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
  625935
  628921
  638480
  588915
  613943
  629639
  636893
  641522
  644205
  803782
  746433
  727500
  760266
  726313
  741673
  767867
  745205
  615191
  617259
  702910
  711416
  715571
  721652
  722125
  780257
  776079
  814658
  813611
  826844
  824842
  486146
  507271
  513570
  486144
  577000
  540924
  719152
  706763
  781142
  785796
  790577
  791890
  796411
  780229
  782656
  786008
  790732
  791888
  796034
  796386
  798331
  800165
  802285
  803432
  803439
  740892
  758769
  796370
  803310
  803423
  804711
  808199
  748485
  768693
  764609
  743989
  768622
  770340
  772361
  765405
  716991
  778641
  782098
  782525
  784625
  789547
  805561
  812032
  398233
  401611
  586432
  630419
  742914
  607976
  768635
  698910
  825305
  824329
  824799
  825030
  494972
  546836
  560003
  716952
  720581
  714400
  719083
  775168
  776067
  778475
  781537
  786855
  787229
  792249
  792348
  798503
  799758
  774654
  785672
  796393
  804035
  734448
  734759
  737891
  760888
  769089
  771941
  772354
  724923
  725020
]
3.24 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
  398233
  401611
  486144
  486146
  494972
  507271
  513570
  540924
  546836
  560003
  577000
  586432
  588915
  607976
  613943
  615191
  617259
  625935
  628921
  629639
  630419
  636893
  638480
  641522
  644205
  698910
  702910
  706763
  711416
  714400
  715571
  716952
  716991
  719083
  719152
  720581
  721652
  722125
  724923
  725020
  726313
  727500
  734448
  734759
  737891
  740892
  741673
  742914
  743989
  745205
  746433
  748485
  758769
  760266
  760888
  764609
  765405
  767867
  768622
  768635
  768693
  769089
  770340
  771941
  772354
  772361
  774654
  775168
  776067
  776079
  778475
  778641
  780229
  780257
  781142
  781537
  782098
  782525
  782656
  784625
  785672
  785796
  786008
  786855
  787229
  789547
  790577
  790732
  791888
  791890
  792249
  792348
  796034
  796370
  796386
  796393
  796411
  798331
  798503
  799758
  800165
  802285
  803310
  803423
  803432
  803439
  803782
  804035
  804711
  805561
  808199
  812032
  813611
  814658
  824329
  824799
  824842
  825030
  825305
  826844
]
1.95 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "close up домашн любительск"
]
1.87 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "close up домашн любительск"
]
1.71 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "close up homemade"
]

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.