GET https://search.jues.net/search/embeds/5?q=homemade%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.72 ms
(84.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
  184359
  205794
  381757
  383171
  384878
  385603
  391592
  397883
  439746
  440868
  441000
  448996
  456194
  459638
  460759
  465376
  466102
  466114
  466136
  466147
  466907
  471390
  472652
  479031
  479084
  479134
  484392
  484417
  484560
  484725
  485766
  485971
  487607
  493172
  513194
  518763
  520899
  521401
  523842
  523852
  526516
  527973
  530688
  536444
  543680
  544447
  544971
  554497
  555077
  555287
  561536
  563064
  563094
  587805
  589610
  590941
  605136
  605157
  610094
  614789
  619531
  619656
  630580
  644529
  686383
  696237
  705458
  707431
  707530
  710379
  715373
  715572
  720008
  725227
  726817
  726838
  727735
  731137
  734333
  734390
  734705
  742385
  742585
  742716
  742812
  742889
  744339
  746658
  746682
  747181
  757258
  759009
  759931
  759939
  765644
  781753
  784282
  795213
  795954
  796036
  796119
  796157
  796252
  797254
  799968
  800796
  802132
  802157
  802195
  807335
  817796
  819011
  824145
  824167
  824268
  824456
  824483
  826827
  827178
  827936
]
12.22 ms
(8.52%)
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
  441000
  439746
  484392
  472652
  385603
  466907
  536444
  590941
  520899
  485971
  802132
  715373
  827936
  555077
  554497
  696237
  707431
  707530
  561536
  619656
  605157
  644529
  614789
  630580
  726817
  757258
  734390
  746658
  705458
  710379
  521401
  391592
  824456
  471390
  479084
  563094
  589610
  807335
  802157
  726838
  742385
  619531
  397883
  460759
  466114
  466102
  479134
  448996
  440868
  465376
  466136
  466147
  479031
  513194
  484417
  484560
  526516
  484725
  485766
  493172
  523842
  523852
  527973
  518763
  487607
  544971
  824145
  824483
  824167
  459638
  563064
  605136
  587805
  795954
  796036
  796252
  800796
  731137
  796157
  742585
  747181
  742812
  746682
  765644
  742716
  797254
  799968
  802195
  384878
  205794
  383171
  184359
  381757
  819011
  826827
  827178
  824268
  817796
  456194
  530688
  544447
  555287
  543680
  715572
  686383
  720008
  610094
  781753
  795213
  725227
  727735
  734333
  734705
  742889
  744339
  759009
  759931
  759939
  784282
  796119
]
2.40 ms
(1.67%)
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
  184359
  205794
  381757
  383171
  384878
  385603
  391592
  397883
  439746
  440868
  441000
  448996
  456194
  459638
  460759
  465376
  466102
  466114
  466136
  466147
  466907
  471390
  472652
  479031
  479084
  479134
  484392
  484417
  484560
  484725
  485766
  485971
  487607
  493172
  513194
  518763
  520899
  521401
  523842
  523852
  526516
  527973
  530688
  536444
  543680
  544447
  544971
  554497
  555077
  555287
  561536
  563064
  563094
  587805
  589610
  590941
  605136
  605157
  610094
  614789
  619531
  619656
  630580
  644529
  686383
  696237
  705458
  707431
  707530
  710379
  715373
  715572
  720008
  725227
  726817
  726838
  727735
  731137
  734333
  734390
  734705
  742385
  742585
  742716
  742812
  742889
  744339
  746658
  746682
  747181
  757258
  759009
  759931
  759939
  765644
  781753
  784282
  795213
  795954
  796036
  796119
  796157
  796252
  797254
  799968
  800796
  802132
  802157
  802195
  807335
  817796
  819011
  824145
  824167
  824268
  824456
  824483
  826827
  827178
  827936
]
2.19 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade mature"
]
1.77 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск mature"
]
1.66 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск mature"
]

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.