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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.22 ms
(84.47%)
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
  3599
  394427
  471887
  482947
  495054
  521712
  529809
  530569
  530570
  531986
  532058
  532112
  532134
  533491
  534134
  537169
  537499
  537858
  537972
  538177
  538826
  544158
  545911
  546466
  548016
  553481
  554543
  555193
  555249
  555332
  555751
  562548
  565648
  567995
  570938
  571132
  577185
  577276
  584227
  584620
  589199
  589644
  592924
  593006
  593065
  595116
  595395
  600813
  603377
  605029
  605514
  606051
  606853
  607703
  610018
  610141
  613145
  615950
  617978
  621376
  628658
  628672
  629739
  636594
  639647
  641397
  642281
  644622
  645052
  651230
  658431
  658481
  659938
  664610
  666201
  668823
  681227
  692460
  693087
  697224
  698249
  698252
  698253
  698256
  700900
  701226
  701235
  707443
  708530
  710380
  710437
  710577
  710732
  714164
  714189
  714223
  715111
  730714
  732855
  733097
  733278
  733458
  742716
  742771
  742842
  746168
  751247
  759929
  765644
  790781
  794816
  796483
  796610
  797254
  799968
  802195
  812541
  823778
  824168
  824263
]
14.01 ms
(9.30%)
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
  765644
  742716
  797254
  799968
  802195
  589644
  641397
  824168
  824263
  790781
  759929
  746168
  592924
  823778
  567995
  794816
  796483
  812541
  751247
  732855
  537972
  471887
  570938
  733458
  742771
  714164
  796610
  521712
  530570
  544158
  529809
  537499
  495054
  532134
  534134
  538177
  530569
  532112
  533491
  537169
  537858
  538826
  531986
  532058
  554543
  577185
  555249
  555332
  555751
  565648
  571132
  584620
  545911
  553481
  584227
  664610
  668823
  692460
  697224
  698253
  708530
  710732
  714189
  658431
  658481
  666201
  681227
  693087
  710577
  714223
  645052
  651230
  659938
  698249
  698252
  698256
  700900
  710380
  715111
  546466
  548016
  555193
  562548
  577276
  589199
  593006
  603377
  615950
  617978
  595395
  606051
  606853
  610018
  636594
  642281
  644622
  595116
  605514
  610141
  621376
  628658
  628672
  593065
  600813
  605029
  607703
  629739
  639647
  730714
  742842
  733278
  613145
  701226
  701235
  707443
  710437
  482947
  394427
  733097
  3599
]
2.60 ms
(1.72%)
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
  3599
  394427
  471887
  482947
  495054
  521712
  529809
  530569
  530570
  531986
  532058
  532112
  532134
  533491
  534134
  537169
  537499
  537858
  537972
  538177
  538826
  544158
  545911
  546466
  548016
  553481
  554543
  555193
  555249
  555332
  555751
  562548
  565648
  567995
  570938
  571132
  577185
  577276
  584227
  584620
  589199
  589644
  592924
  593006
  593065
  595116
  595395
  600813
  603377
  605029
  605514
  606051
  606853
  607703
  610018
  610141
  613145
  615950
  617978
  621376
  628658
  628672
  629739
  636594
  639647
  641397
  642281
  644622
  645052
  651230
  658431
  658481
  659938
  664610
  666201
  668823
  681227
  692460
  693087
  697224
  698249
  698252
  698253
  698256
  700900
  701226
  701235
  707443
  708530
  710380
  710437
  710577
  710732
  714164
  714189
  714223
  715111
  730714
  732855
  733097
  733278
  733458
  742716
  742771
  742842
  746168
  751247
  759929
  765644
  790781
  794816
  796483
  796610
  797254
  799968
  802195
  812541
  823778
  824168
  824263
]
2.01 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature homemade"
]
1.83 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature домашн любительск"
]
1.39 ms
(0.92%)
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.