GET https://search.jues.net/search/embeds/4?q=amateur%20husband

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.46 ms
(85.63%)
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
  393980
  478283
  479224
  497410
  525602
  534104
  543359
  544131
  545218
  566463
  571110
  595306
  601849
  606667
  606853
  607035
  609566
  610862
  612888
  613678
  613953
  620486
  621730
  621786
  623993
  632500
  635822
  635850
  637299
  640231
  647421
  650967
  653368
  653388
  654006
  654875
  656813
  657247
  669983
  675885
  681509
  686450
  689889
  689930
  695358
  695839
  697581
  697933
  702863
  703282
  704169
  704622
  705727
  705784
  707938
  708742
  710328
  713413
  716962
  717578
  720019
  720027
  724159
  725614
  728379
  731333
  733278
  733491
  745506
  750158
  751967
  761407
  765041
  766395
  768096
  768608
  771806
  780058
  782310
  784628
  786272
  787213
  788378
  789792
  792673
  793157
  793234
  793302
  794452
  794516
  795805
  795955
  796586
  797123
  799829
  800182
  800892
  802934
  809968
  816095
  817487
  817737
  819166
  819277
  819358
  819712
  819747
  820114
  820156
  823353
  823645
  824235
  824489
  824803
  824849
  825809
  825947
  826618
  827258
  827372
]
13.36 ms
(7.76%)
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
  610862
  751967
  612888
  393980
  819747
  816095
  820114
  823645
  819712
  823353
  824235
  824849
  817487
  819358
  825947
  478283
  720019
  780058
  786272
  788378
  794516
  795955
  800892
  789792
  793157
  793234
  794452
  795805
  800182
  724159
  731333
  784628
  787213
  792673
  793302
  796586
  802934
  765041
  766395
  733491
  771806
  761407
  720027
  782310
  534104
  544131
  543359
  545218
  650967
  653368
  653388
  657247
  675885
  695358
  695839
  705784
  708742
  689930
  704169
  647421
  654006
  654875
  669983
  681509
  686450
  689889
  704622
  707938
  710328
  716962
  571110
  606667
  607035
  613678
  613953
  637299
  595306
  606853
  621730
  621786
  635822
  640231
  609566
  623993
  799829
  809968
  745506
  725614
  728379
  768608
  733278
  750158
  620486
  632500
  635850
  697581
  697933
  702863
  703282
  713413
  566463
  601849
  768096
  717578
  797123
  819277
  824803
  826618
  825809
  827258
  827372
  817737
  819166
  824489
  820156
  479224
  497410
  525602
  656813
  705727
]
3.84 ms
(2.23%)
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
  393980
  478283
  479224
  497410
  525602
  534104
  543359
  544131
  545218
  566463
  571110
  595306
  601849
  606667
  606853
  607035
  609566
  610862
  612888
  613678
  613953
  620486
  621730
  621786
  623993
  632500
  635822
  635850
  637299
  640231
  647421
  650967
  653368
  653388
  654006
  654875
  656813
  657247
  669983
  675885
  681509
  686450
  689889
  689930
  695358
  695839
  697581
  697933
  702863
  703282
  704169
  704622
  705727
  705784
  707938
  708742
  710328
  713413
  716962
  717578
  720019
  720027
  724159
  725614
  728379
  731333
  733278
  733491
  745506
  750158
  751967
  761407
  765041
  766395
  768096
  768608
  771806
  780058
  782310
  784628
  786272
  787213
  788378
  789792
  792673
  793157
  793234
  793302
  794452
  794516
  795805
  795955
  796586
  797123
  799829
  800182
  800892
  802934
  809968
  816095
  817487
  817737
  819166
  819277
  819358
  819712
  819747
  820114
  820156
  823353
  823645
  824235
  824489
  824803
  824849
  825809
  825947
  826618
  827258
  827372
]
2.13 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск husband"
]
1.82 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск husband"
]
1.74 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur husband"
]

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.